Data Analytics Engineer

• Designed and developed ETL/ELT processes to integrate diverse data sources (APIs, JSON, CSV, Excel, SQL) into Seismic Cloud CMS using SSIS.
• Optimized .NET C# applications and refactored legacy processes, improving pipeline performance and reducing execution time by 30%.
• Automated data validation workflows with Python (Pandas, NumPy), cutting manual QA efforts by 50%.
• Implemented Azure DevOps CI/CD pipelines and migrated PowerShell scripts to YAML, reducing manual intervention by 80%.
• Supported SQL Server upgrades by modernizing existing data processes, improving system reliability and maintainability.

• Developed end-to-end data and ERP solutions for small and medium-sized enterprises (SMEs), integrating sales, invoicing, and inventory systems.
• Designed POS and ERP systems using ASP.NET, WinForms, and SQL Server, enhancing transaction processing and reporting efficiency.
• Built dashboards and KPIs in Power BI and SSRS, enabling data-driven decision-making across departments.
• Improved data pipelines by 40% through the use of SSIS, and implemented offline and online database synchronization with Microsoft Sync Framework.
• Automated reconciliation processes, reducing cash discrepancies by 20% and saving management teams 50% of reconciliation time.
• Provided technical leadership in full-stack development, collaborating with stakeholders to translate business requirements into scalable, high-performance solutions.

• Designed and implemented an enterprise Financial Data Warehouse (DWH) that supported Tesla’s global operations.
• Developed over 100 SSRS reports and 5 SSAS cubes, including a General Ledger cube, to provide drill-through analytics for the Finance, Accounting, and Tax teams.
• Reduced month-end, quarter-end, and year-end financial close cycles by 50% through process automation and optimized ETL workflows.
• Consolidated multiple data sources—Dynamics AX, Oracle, SQL Server, ERPs, and APIs—into a star-schema DWH containing over 100 tables and billions of rows.
• Improved query performance by 40% through enhanced indexing and partitioning of high-volume financial data.
• Delivered KPI-driven reports that ensured SOX compliance and supported global regulatory audits.
• Collaborated with cross-functional teams to replace costly third-party BI software, achieving 60% savings in licensing costs.
• Served as a technical lead, mentoring engineers and ensuring the scalability and maintainability of BI solutions.

• Designed and implemented Line-of-Business (LOB) applications for web and desktop using C#, .NET, and SQL Server.
• Developed ETL jobs in SSIS to process thousands of daily transactions, providing real-time data visibility.
• Implemented database synchronization for offline and online environments, ensuring uninterrupted business operations.
• Delivered operational and financial reports through SSRS, reducing reporting costs by 25% and increasing sales efficiency by 20%.
• Collaborated directly with business stakeholders to identify reporting gaps and translate requirements into actionable BI dashboards.

Clarient Inc., later acquired by DTCC, was a leading provider of financial market infrastructure solutions.

• Developed BI solutions for risk, compliance, and financial reporting.

• Built SSRS dashboards and SSAS cubes to consolidate global regulatory data.

• Implemented ETL pipelines with SSIS, ensuring high data quality and regulatory compliance.

3M is a multinational conglomerate serving industries such as health, manufacturing, and consumer products.

• Developed a Financial Data Warehouse (DWH) for accounting and planning departments.

• Designed dashboards and KPIs in SSRS to improve financial visibility.

• Automated ETL processes with SSIS to optimize data ingestion and transformation.

Universidad Autónoma de San Luis Potosí is one of Mexico’s oldest public universities, with a strong focus on engineering and research.

• Developed web and desktop applications for academic and administrative systems.

• Designed data models and integrated SQL Server databases with C# .NET applications.

• Automated manual reporting processes, which boosted staff efficiency.