DEVOPS SYSADMIN – INFORMATICA SPECIALIST // CLOUD AND ON-PREMISE ADMINISTRATOR-DEVELOPER
CONSULTANT // MEXICAN 38 YEARS
CONSULTANT // MEXICAN 38 YEARS
timeline TIMELINE

work WORK EXPERIENCE
Nov 2019 – Present
place US/INDIA
public http://www.qualcomm.com
DevOps Agile PLM IT Engineer, Staff – Since August 2020
DevOps Agile PLM IT Engineer, Staff – Since August 2020
- Juan is able to manage Oracle Agile PLMProduct Lifecycle Management Enterprise and Tomcat custom apps.
- Responsible for all Agile PLM environments with more than 70 services.
- Experience with on call and "follow the sun" team work continuity with high and critic incidents.
- Helps with process and knowledge base documentation using Microsoft Teams and Confluence.
- Juan helps to configure changes, troubleshooting and resolve incidents; working with team members around the world (mainly United States and India).
- Works with several Sitescope monitors and Splunk Dashboards, AppDynamics and Waratek for operations monitoring.
- DevOps; Continious delivery and Integration with GitHub, Ansible and Jenkins.
- Juan still works with DI and Agile teams at the same time.
- Juan is able to administer, support and manage different versions of the Informatica PowerCenter 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 90 services, including production.
- Manage 3 Informatica Cloud organizations with more than 10 agents; including NAS share security, Salesforce, Oracle, Composite datasources among others.
- Migrated Informatica services from v10.1 to v10.4; he also worked with Composite migration from v7 to v8.2.
- Experience with on call and "follow the sun" team work continuity with high and critic incidents.
- Helps with process and knowledge base documentation using Communities and Confluence.
- Juan helps to configure changes, troubleshooting and resolve incidents; working with team members around the world (mainly United States, India and Ireland).
- Works with several Sitescope alerts and Splunk Dashboards for operations monitoring.
- Experience working with monitoring tools such like Splunk, HP SiteScope and ServiceNow.
- Mainteinance of Flask Python (3.8) applications.
school EDUCATION AND SPECIALIZED COURSES
- Bachelor degree for Information Technologies Administration – Instituto 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

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.