loader
Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Additional Information
Quote
Timeline
Ambarish Dongre

Ambarish Dongre

Manager, Data Science & Analytics
New York
Summary
  • Microsoft Certified Data Engineer with 8+ years experience wrangling big datasets
  • Excellent Client Facing as well as project execution experience
  • Worked for over 8 years in Data Warehousing, Data Analytics,Visualization, Modeling and Optimization
    Achievements include creating risk engine model to detect fraud and achieved 25% more accuracy
  • Eager to build robust databases that lay the groundwork for revealing game-changing insights
  • Expert in SQL Server and have extensive work experience in using products like SSIS, SSAS and Power BI as well as implementing Data pipelines
  • Outstanding experience in building analytics, visualizations and communicating with the stakeholders
Overview
6
6
Certificates
6
6
years of post-secondary education
9
9
years of professional experience
Work History

Manager, Data Science & Analytics

Deloitte Audit & Assurance
2016-07 - Current

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

Senior Consultant Data analytics

Deloitte Advisory
2013-08 - 2016-06
  • 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

Data Engineer

Infocepts LLC
2009-06 - 2011-06
  • 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
Education

Masters Information Management

University Of Maryland
2011-08 - 2013-05

Bachelor of Engineering Electronics

Nagpur University
2005-08 - 2009-06
Skills

SQL Server, MySQL

SAS, R, Python (NumPy, Pandas, Matplotlib)

SSIS, SSAS

Tableau, Power BI

Microsoft Azure

Business Intelligence

Cognos, Microstrategy

PHP, Perl, C#

Certification

Microsoft Azure Data Engineer

2020-06

Microsoft Data Analyst

2020-06

Azure Fundamentals

2020-04

Certified Trifacta Wrangler

2020-08

Certified Tableau Developer

2020-04

Certified Fraud Examiner

2019-05
Accomplishments
  • Received an award for Audit innovation for a project for Microsoft Revenue Audit
  • Created/ Updated risk engine model to detect fraud and achieved
    25% more accuracy
  • Developed a revenue recognition ASC 606 model in SQL Server that was deployed on multiple engagements for 100% testing
Additional Information
  • Runs EventMogambo.com an online platform for hosting local events
  • Teaches SQL to undergrads
Quote
Every problem is a gift—without problems we would not grow.
Tony Robbins
Timeline

Certified Trifacta Wrangler

2020-08

Microsoft Azure Data Engineer

2020-06

Microsoft Data Analyst

2020-06

Azure Fundamentals

2020-04

Certified Tableau Developer

2020-04

Certified Fraud Examiner

2019-05

Manager, Data Science & Analytics

Deloitte Audit & Assurance
2016-07 - Current

Senior Consultant Data analytics

Deloitte Advisory
2013-08 - 2016-06

Masters Information Management

University Of Maryland
2011-08 - 2013-05

Data Engineer

Infocepts LLC
2009-06 - 2011-06

Bachelor of Engineering Electronics

Nagpur University
2005-08 - 2009-06