Ambarish Dongre

Microsoft Corporation

• Created data pipelines to perform 100% testing for the revenue data with 99.9% accuracy and saved millions in expenses
• Used the project success as a base to create a standard model to perform revenue testing on other large clients

Illumia Tool (A web tool that is used by thousands of Audit professionals to request data analytics services from the Audit Analytics group. It is also used for project management and reporting)

• Led the database management team from requirement gathering to execution and testing of the tool
• Designed data model, Created tables, Indexes, Stored Procedures and ETL SSIS packages for loading daily data to the backend to support reporting activities
• Created and Published Tableau reports for the leadership for different reporting aspects

Audit Analytics

• Led geographically distributed teams and managed several resources to help deploy analytics on audit engagements
• Created data pipelines for data processing large amount of data in Microsoft Azure Cloud to support different audit procedures
• Created standardized R scripts to transform the data to be viewed in a standard Tableau/Power BI report

• Co Engineered the Deloitte Analytics Platform Risk Engine to provide fraud risk scoring to entities based on transactions
• Led data mapping assessment work stream by reviewing ETL processes executed between various data sources and AML monitoring system for a financial institution
• Wrote complex SQL queries to extract data from SWIFT messages to uncover discrepancies
• Wrote complex stored procedures to support the ASP.NET front end tool

• Created and maintained complex SSIS ETL packages
• Created complex queries, data transformations, aggregations, stored procedures and Triggers
• Modified existing data cubes to add new measures and dimensions
• Used Cognos 8.3 extensively with AJAX and Javascript to deliver high quality Business Intelligence reports