Héctor Hernández Ortega Email & Phone Number

Monterrey, Nuevo León, Mexico

• Senior Data Analyst for a Payroll Reconciliation 2023 – 2024 in Xcel Energy | Designed a canonical model for payroll and timesheet data analysis. Goal: Identify payroll inconsistencies across different pay groups.• Site Lead for an S/4HANA Implementation in ConAgra Foods | Successfully led an SAP end-to-end implementation. Managed supply chain functional groups through integration, training, user acceptance testing, Go-Live, and Hypercare phases.• Business Value Architect for a Snowflake Cloud Implementation in Pacific Gas & Electric | Orchestrated Snowflake Cloud Platform implementation and Enterprise Adoption Program. Led cross-functional program team using Scaled Agile Framework. Conducted thorough analysis, risk management, and comprehensive documentation.

Monterrey, Nuevo León, Mexico

• As Delivery Manager for Innova Solutions | Managed $1.5M+ in revenue. Coordinated a team of 30 engineers, creating career plans and providing coaching. Led recruiting activities for various engagements. • Architect Lead for Data & Analytics Center of Excellence | Executed CoE strategy and roadmap across the organization. Demonstrated CoE capabilities to stakeholders. Delivered multi-annual projects integrating analytics capabilities. • Program Manager for a Power BI Implementation Program in Beauty Health Co. | Defined migration roadmap for different regions. Enabled technical team members and created a Knowledge Repository. Architected data model for Power BI reports. • Project Manager for an ERP Data Migration in Beauty Health Co | Led ERP platform migration in the NAM region. Implemented communication plan, change management strategy, and risk management. Developed reconciliation data strategy for migration quality assurance. • Senior Data Analyst for a Reporting Rationalization Project in Beauty Health Co | Orchestrated rationalization strategy for 600+ Tableau Desktop reports. Provided team oversight and acted as Tableau SME. • Data Scientist for an Accounts Reconciliation Program | Architected automated accounts reconciliation pipeline for legacy to target Telecom Expense Management (TEM) Platform.

Monterrey Area, Mexico

• Data Scientist for an Asset Reconciliation Project with Qualcomm | Architected a solution to identify the IT Infrastructure assets deprecated to be removed from the company’s general ledger reducing company’s taxes liability. Performed requirements elicitation with client to determine needs. Stakeholders management to determine data sources for the engagement. Coordinated workshops with stakeholders to identify business rules. • ServiceNow Administrator & Developer with Qualcomm | The Information Technologies Operations Management (ITOM) team required the customization of ServiceNow (Kingston & London) ITOM module in order to incorporate data from multiple sources to generate company’s CMDB. Performed ServiceNow administration activities to support integration with endpoints building code to ingest data from the ServiceNow Table API. Implemented ServiceNow Discovery module to generate company´s CMDB. • Data Virtualization Architect for a Data Virtualization Project in Qualcomm | Provisioned virtualized tables from internal systems for reporting purposes and other systems consumption using Cisco Information Server / TIBCO Data Virtualization. Created data models for endpoints data ingestion aligned to data vault models. Worked on query optimization for virtualized tables to reduce response times. Developed dashboards using QlikView and Splunk to support operations monitoring.

Monterrey, Mexico

• Business Analytics Lead for the Operational Reporting Platform in Deutsche Bank | Led a team of 6 for Business Intelligence and Software Development. Migrated reports from Microstrategy to TIBCO JasperReports. Customized trading pre-confirmation application using Java, Spring 2, Ant, and Maven.• Data Virtualization Architect for the SingleSource Program in BP Alaska | Created a single source of data services using Composite/TIBCO Data Virtualization and Netezza Appliance. Coordinated multicultural on-site and offshore teams. Delivered 10+ data virtualization projects.• Project Manager for BP Alaska | Managed diverse engagements, including application migrations, hardware end-of-life, and business intelligence. Coordinated multicultural teams and ensured delivery assurance. Responsible for a $1M+ projects portfolio.

Aguascalientes Area, Mexico

Business Intelligence Lead for the Data Warehousing Program in Sonoco Products Co. | Technical lead for the support of the legacy data warehouse and the development of the new solution. Coordinated a team of 10 engineers split in the following areas: ETL support and development, Business Intelligence reports support and development, and design, development, and execution of quality assurance activities.