Duncan Hernandez

About Duncan Hernandez

With over a decade of experience in the data analytics field, my core competencies lie in leading data projects, architecting data pipelines, and delivering actionable business intelligence. At Energy Recovery, Inc, my mission is to enhance decision-making and operational efficiency through advanced data solutions. My role aligns with the organization\'s pursuit of innovation, where I bring a diverse perspective and a strategic leadership approach to the team.Recently, I\'ve spearheaded the integration of SharePoint, API, CRM, and Dynamics 365 data into an Azure data warehouse, developing Power BI dashboards that have significantly enhanced insights for the company. My oversight of ETL processes in Azure SQL has been instrumental in ensuring data integrity and availability. These efforts, coupled with my expertise in Azure Analysis Services and SQL data modeling, have been pivotal in transforming our business intelligence landscape.

Experience

1. Manager of Business Intelligence

   Energy Recovery, Inc

   Mar 2023 — Present

   Created manufacturing forecast for supply and demand based on sales opportunities. Led to production orders being opened if demand was higher than anticipated on-hand inventory.• Created gross margin reports to tie data between sales, inventory, ledger journal, and finance.• Developed views for purchase price variance to help company spend across items according • Tied Build of Material (BOM) historical costs by material, labor, overhead to financial reports, saving approximately 50 hours of manual work per month-end.• Analyze opportunity CRM data looking at the sales stage funnel process to identify potential bottlenecks. Improved CRM data quality for faster opportunity closes by 20%• Designed data structure and integrated with Sharepoint for manufacturing to easily create item labels and show realized and error quantity and costs.• Drive user adoption of Power BI and increased users from 5 to 40.• Architect and deploy new data pipelines integrating IoT, API, CRM, MES, and Dynamics 365 data into the Azure data warehouse.• Transform D365 data entities for business-critical reporting and external vendor applications, enhancing insights and decision-making.• Develop Power BI dashboards connected to Azure Analysis Services semantic models and leverage Azure SQL for robust data modeling.• Oversee ETL processes and data flow pipelines (fact and dimension tables) in Azure SQL (JET/TimeXtender), ensuring data integrity and availability.• Liaison between stakeholders and technical data situations to ensure clear communication.

Education

• UCLA

  BS, Mathematics/Economics

  2007 — 2011

• Quantic School of Business and Technology

  Master's of Business Administration

  2018 — 2018

Skills

• Sql
• Powerpoint
• Microsoft Excel
• Financial Modeling
• Economics
• Sas Programming
• Data Analysis
• Analysis
• Bloomberg Terminal
• Analytics
• Data Analytics
• Litigation Consulting
• Finance
• Mathematics
• Statistics
• Research
• Strategy
• Management
• Microsoft Sql Server
• Econometrics
• Problem Solving
• Microsoft Access
• Access
• Python
• Stata
• Mysql
• R
• Data Mining
• Tableau
• Statistical Modeling
• Adobe Analytics
• Leadership
• Healthcare Analytics
• Sas