INFORMATICA SPECIALIST / CLOUD AND
ON-PREMISE ADMINISTRATOR & DEVELOPER
CONSULTANT // MEXICAN // 36 YEARS

OBJECTIVE:

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.

 

timeline TIMELINE

 

work WORK EXPERIENCE

May 2016 – Jul 2018 place MEXICO/US/IRELAND/INDIA cancel
  • 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.
 

school EDUCATION AND SPECIALIZED COURSES

  • Bachelor degree for Information Technologies AdministrationInstituto Tecnológico de Sonora link
    Dec 2005
  • Project management methods – RSM Mexico
    Feb 2006
  • Informatica platform admin – UDEMY
    May 2016
  • Internal knowledge transfer – Qualcomm
    Jun 2016
  • Splunk power user and admin certified – Splunk Inc
    Dec 2016
  • "Be the new" program – Accenture
    Feb 2018
 

assignment_ind COMPETENCES

public INTERNATIONAL EXPERIENCE

 

list_alt APTITUDES

pool INTEREST

 

assignment PROFESSIONAL PROFILE

Data integration and BI tools

  • 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.
access_time Last update: 2018-10-21
Made with ♥ by Juan Rios / All rights reserved 2018 ®