-Designed and Implemented Analytics solutions to move and transform data in AWS and Azure ecosystems to improve availability in near-real time, monitoring through dashboards and recoverability through self recoverable pipelines using Python, Data Factory, Snowflake and PowerShell.-Modeled and developed Analytic solutions to monitor business processes, visualize KPIs, and track data quality metrics to grow revenue by up to 10% with PowerBI, Tableau, Snowflake, Redshift, Synapse and Teradata.-Definef and implemented Data Governance strategies by implementing Data Quality and Master Data Management frameworks and tools, and align business process to improve data consistency in 20% across multiple orgs and reduce data silos in 30%.

Leading the Business Intelligence department to offer the business analytical tools to get insights of their data.• Designed and owned Data Governance process to address Data Quality issues.• Led automation of manually produced reports to save 200 hrs. per year.• Designed a scalable a reusable back end to reduce coding in 15%.• Led automation of data transfers to third parties to reduce $1M per year in fees.

Cloud Solutions• Developed dynamic cloud solution using PowerBI and AzureSQL in SCRUM methodology.• Automated data analysis and reporting.• Designed a process to virtualize and upgrade SQL Server Databases to a Software Defined Data Center.• Wrote PowerShell scripts to analyze on-premises SQL Server databases and migrate them to AWS.• Identified concerns Application Owners need to address pre and post virtualizations and upgrades.Data Governance• Utilized Microsoft Master Data Services to ensure Data Governance controls.• Installed and configured Microsoft Master Data Services (MDS).• Trained Data Stewart to follow Data Governance processes and manage Sales Hierarchy using MDS and PowerPivot.Data Visualization• Analyzed existing reporting approaches.• Gathered requirements from Product Owners.• Developed global dashboards using PowerBI, PowerPivot and Tableau in SCRUM methodology.• Analyzed Teradata scripts to identify hardcoded business rules and country information.• Translated business rules and KPIs into DAX and Teradata scripts to query and analyze data.Data Warehousing• Designed and developed Clinical Quality Data Mart design using Kimball modeling techniques.• Analyzed Patient Readmission Performance metrics.• Designed HIPAA Compliance Reporting.• Designed ETL processes to query and analyze data using SSIS.• Documented end-to-end Data Warehouse Technical Architecture.IT Service Management • Analyzed SLA gaps throughout Supply Chain• Identified areas of opportunity to align data availability to the expectations from the business.• Collected recurring issues from different teams across the globe and analyze their root cause.• Defined a strategy plan to deliver reliable reporting to the business.

Reporting Data Quality, Test Lead– Cable Company, Monterrey, Mex (2013)Lead a nearshore team to guarantee the data Quality of a Reporting solution.

Data Governance• Implemented and maintained a tool to guarantee Sales Hierarchies and Accounts Portfolios data integrity.• Maintained a process to manage Account Planning using SSIS, SSAS, SQL Server and SharePoint.• Maintained an Expense Allocation Engine to predict expenses of sales transactions based on business rules.• Managed a unified control to align exchange rates and units of measure to the needs of the business.• Maintained Global Product Mapping tool to guarantee local sales could roll up to global products catalog for unified reporting.Data Warehousing• Lead the development of Data Warehouse built on DB2 to support a Configuration Management System.• Maintained an Enterprise Data Warehouse to consolidate Sales performance metrics from 30 countries.• Adapted a global reporting solution built with Microsoft BI stack to the business needs of each region such as expense allocation rules to determine sales costs and revenue.• Customized SSIS packages (ETLs) to the needs of each country and scheduled data loads for each region to guarantee higher availability.• Gathered requirements from different countries and integrated related requirements into standardized reports to reduce complexity.IT Service Management • Implemented Change and Risk Management processes following ITIL to manage and document changes to the reporting solution. • Implemented a Configuration Management System (CMS) according to ITIL.• Coordinated and represented Changes on the Change Advisory Board.Contributions• Reduction of $1M USD in IT overhead expenses by consolidating requirements and proposing cost-effective enhancements. • Increased profit in Middle-East by $0.5M by increasing data refreshing feeds so that they could make faster decisions in their rapidly changing market.