Nov 2019 – Present place US/INDIA public http://www.qualcomm.com cancel

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.

Data Integration Administrator IT Engineer, Sr (Consultant)

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

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.

Aug 2018 – Oct 2018 place MEXICO/US/INDIA public http://www.chubb.com http://www.accenture.com cancel

• Juan was responsible to manage Informatica Cloud and Azure SQL Server instances.
• Responsible for all Informatica environments and Azure DBA; configuration manager (CM), tuning and deployments.
• Experience working with collaborative tools, such like GitHub and Jira.
• Team lead for analytics operation team.

May 2016 – Jul 2018 place MEXICO/US/IRELAND/INDIA public http://www.qualcomm.com http://www.accenture.com cancel

• Juan was 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 80 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.
• 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.

Jul 2012 – May 2016 place MEXICO public http://www.cablevision.com.mx http://www.izzi.mx http://www.telum.mx cancel

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

Jan 2009 – Jun 2012 place MEXICO/CANADA public http://www.kernel.com.mx cancel

• 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.
• Projects with more than 15 companies.

Jun 2008 – Jan 2009 place MEXICO/US public http://www.ey.com cancel

• Data integration, data analytics fraud checkup and forensic computer projects (for support to investigations and dispute services).
• Trained at Dallas and Chicago for forensic techniques and tools.
• Worked on several referral projects from US companies.

May 2005 – May 2008 place MEXICO public https://www.rsm.global/mexico/en cancel

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

Jun 2003 – May 2005 place MEXICO public https://www.juanrios.com cancel

• Developed more than 20 web pages.
• Created 4 web applications using ASP/SQL Server or PHP/MySQL.
• Created interactive and dynamic sites using ASP, PHP, Flash and JavaScript.