INFORMATICA SPECIALIST / CLOUD AND
ON-PREMISE ADMINISTRATOR & DEVELOPER
CONSULTANT // MEXICAN // 35 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.
 

label LABELS

 

share SOCIAL NETWORKS

This website was created in three days trying to remember how to code, CSS styles were used from w3 schoolslink, PHP3 and old school JavaScript.

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).

×

TIMELINE
COMPETENCES
INTERNATIONAL EXPERIENCE
APTITUDES
INTEREST
access_time Last update: 2018-08-09
Made with ♥ by Juan Rios / All rights reserved 2018 ®