INFORMATICA SPECIALIST / CLOUD AND ON-PREMISE ADMINISTRATOR & DEVELOPER CONSULTANT // MEXICAN // 36 YEARS
Juan is focused to the analysis, development and implantation of IT Information Technology solutions; using Data Analytics, Informatica ETL Tool for Extract, Transform and Load data, Data Virtualization and Cloud services.
May 2016 – Jul 2018place MEXICO/US/IRELAND/INDIAcancel
Juan was able to administer, support and manage different versions of the Informatica platform (on premise ETL, MM, Analyst tool), including Informatica Cloud and Composite/TDVAlso known as Cisco Data Server and Tibco Data Virtualization.
Responsible for all ETL Informatica environments with more than 200 services, including production.
Managed 3 Informatica Cloud organizations with more than 10 agents; including NAS share security, Salesforce, Oracle, Composite datasources among others.
Juan biggest achievement was he was able to migrate more than 90% of Informatica services from v9.1 to v10.1; he also worked with Composite migration from v6 to v7.
Informatica migrations included to fix Salesforce sessions and certificates to Improve security and operations failures.
Highly Experienced with on call and "follow the sun" team work continuity with high and critic incidents.
Helped with process and knowledge base documentation using Communities and Confluence.
Juan helped to configure changes, troubleshooting and resolve incidents; working with team members around the world (mainly United States, India and Ireland).
Created several Sitescope alerts and Splunk Dashboards for operations monitoring.
Experience working with monitoring tools such like Splunk, HP SiteScope and ServiceNow.
Data integration and Informatica PowerCenter administrator.
Created new projects and deployments for all the environments; including recovery plan and backup strategies.
Tech and team lead for POCs and integration processes with Informatica ETL.
Created several Data Integration and interfaces for invoicing, external payments and payroll ATM.
Juan biggest achievement was to create a payment interface model that Integrated more than 20 external payment types (including recurrent/direct debit and credit payments with banks) using flat files, databases and web services. The platform processed millions of records (and money) without issues and interruptions. The whole interface Included trace of every transaction and files with several OBIEE (BI Platform) reports for operations and audit.
Configured and development for execution of remote apps via bash scripts, Java and SSH.
Prospect and sales: Provide support and feedback about ACL solutions for RFI/RFP.
Project management: Consulting services with ACL for Data extraction and analytics projects. Including IT controls reviewing and systems automated tests (CCM) from the beginning to next steps (phases and continuity).
ACL Training and Technical Support, trained more than 300 people about ACL Solutions in several sectors/companies.
Certified by ACL to be Instructor and provide ACL Technical Support (more than 8 months process with Canada ACL representatives).
Integrated Informatica PowerCenter and ACL Products; full cycle projects; from requirements to proposals thru deliveries and customer feedback.
Trained new joiners about IT and Quality methodologies.
Participation and leadership in several projects:
Evaluation and review of IT controls based on 3140 IMCP bulletin, COBIT from ISACA and ITIL from OGC.
Data Analytics with IDEA Caseware (for data mining and external audit support); IDEA it’s a CAATS tool like ACL.
Coordination, documentation and development of requirements for information systems (request for proposal) and advisory for enterprise software (ERP) and technology support selection/bidding; including the implementation management.
Diagnostics and process re-engineering, implementation/documentation and diffusion of QMS based at the norm ISO 9001:2000/NMX-CC-9001-IMNC-2000.
Informatica PowerCenter (ETL), Tibco Data Virtualization (TDV, formerly Composite/Cisco Information Server), Informatica Cloud, Toad DBA for Oracle, Microsoft SQL Studio, Several Text and SSH/SFTP tools. Experience in systems integration, data warehouse/data marts and BI.
Experience with a lot of source data/files; like databases (ODBC/JDBC), files (XML, flat files, CSV, etc.) and several web-services like (SOAP/WSDL and Rest).
Basic reporting with Tableau and OBIEE (Front-end) – Oracle Business Intelligence Enterprise Edition.
OS and Database Systems (DBMS)
Advanced knowledge of Windows, Solaris and Linux (Domain of batch, bash and korn scripts).
Proven experience with several database management systems such like Oracle DB (PL/SQL), SQL Server, MySQL, Teradata, DB2, PostgreSQL, Progress and Microsoft Access. Every database through ODBC and JDBC drivers.
Experience improving and detecting process/queries bottlenecks, RCA and troubleshooting.
Use of tools for data modeling and BI like: DB visualizer, Toad Oracle Data Modeler, Sybase Power Designer and Microsoft Visio.
Several methodologies and tools
Quality management systems implementation (QMS) based at ISO 9001:2000/NMX-CC-9001-IMNC-2000. Process definition, delivery and implementation.
Experience in audits for IT internal controls based on 3140 IMCP bulletin, COBIT 4 from ISACA and ITIL from OGC.
Intermediate knowledge for BI design and Data Modeling (DM/DWH) based on Inmon and Kimball.
Software Development Life Cycle (SDLC); Including DevOps and continues delivery methods.
Juan used a web editor, Linux and a public domain with a lot of ideas from old CVs/resume and material designlink. It's supposed to support all the web-browsers, uses dynamic/responsive containers and looks good (at least for Juan).
access_time Last update:
Made with ♥ by Juan Rios / All rights reserved 2018 ®