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

Jul 2017 – current place MEXICO/US public http://www.tesys21.com cancel
  • BMC Control-M migration to Automic UC4 for 7-Eleven.
  • BPM process definition for Grupo Rivero.
  • Informatica BI Operations with Tecnologico de Monterrey (most prestigious university in Latin America).
  • Stores performance reports with Oracle Publisher for 7-Eleven.
  • Informatica Developer for Discount Tire (Nearshore).
  • Responsible for internal Nearshore operations.
 

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 (more than 80 hours) 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: 2019-11-06
Made with ♥ by Juan Rios / All rights reserved 2019 ®