Mohit Batra Email & Phone Number

Hyderabad, In

Extensive experience in online and offline training.Conducted multiple successful batches and trained 1000+ participants on Microsoft Azure, Business Intelligence, Data Warehousing and Big Data. Experience in delivering case study-based training.Experience in handling diverse audience with different personas and experience levels.

Draper, Ut, Us

Courses:Building Your First ETL Pipeline Using Azure DatabricksConceptualizing the Processing Model for Azure Databricks Service

Redmond, Washington, Us

Project – Online Commerce Warehouse:> Built data warehouse for MS Partner Center’s 5TB+ data. Built key metrics on partners’ activities, incl. identifying illegal tenant churn.> Requirement gathering from Product Owner, manage sprint priorities, and warehouse & metric design.> Optimization by implementing delta load, columnstore indexes, table & tabular model partitioning. Improved load performance by 30%.> Stabilized the platform by analyzing & fixing data quality issues in source data, reducing load issues to almost zero.> Later, lead the project migration to PaaS and Azure SQL DW. Redesigned tables, ingestion process and overall orchestration. Reduced infrastructure cost by 58% and improved load performance by 83%.Project – Partner Incentives Framework:> Lead framework design to calculate MS partners’ eligibility & incentives under a program. System handles multi-billion-dollar payouts.> Built on Modern BI Architecture. Ingested data from 20+ disparate data sources.> Helped in quick incentive release and saved nearly 10% of amount by accurate calculations.Project – QuickRe Bot Framework> Ideated & demoed a bot framework to enable instant & on-the-go access to enterprise data. Presented at multiple layers of LT.> Enabled data access via multiple platforms like email, MS Teams and Cortana, and in multiple formats.Accomplishments: > Microsoft Hackathon 2017 – 2nd place in ‘Consumers’ category.> QuickRe bot framework was well appreciated and received funding for building the product in FY19.> Microsoft Excellence Award Q3 2018 – Online Commerce project.> Completed edX certification on – ‘Delivering a Data Warehouse in the Cloud’.

Gurgaon, Haryana, In

• Managing India platform team/activity (that focusses on enhancements to framework, optimizing SQL environment, add new features to DWH, building utilities etc).• Running daily India scrum. Doing design and code reviews.• Involved in design/development of complete lifecycle of Business Intelligence solution• Involved in building logical and physical data models. Managing SCDs (Type 1 and Type 2 changes).• Design complex ETL solutions through SSIS and .NET applications.• Performance tuning and optimization.• Built frameworks like Monitoring Engine (for emails, files etc), File Validation framework (validation against DWH for referential integrity, data type validation etc).• Implementation of advanced features like column store indexes, incremental statistics, partitioning etc.• Building reports and dashboards using SSRS and Power BI.• Building windows services to get data from external sources (which aren’t SQL).• SQL unit testing using Redgate SQL Test.• Mentoring new team members on internal processes and design of warehouse.• Following agile practices and continuous integration methodology.

Palo Alto, Ca, Us

Pune, Maharashtra, In

Worked with Microsoft Research group to implement pluggable security for a semantic store, Zentity.

El Dorado Hills, California, Us

Worked on a live data warehousing project for a big retail company, which is more of an operational Business Intelligence, for their finance and pre-sales activities.Involved mostly on ETL development side using SQL Server Integration Services (SSIS) and also a bit on OLAP development, using SQL Server Analysis Services (SSAS).Conducted 10 days training session on .NET

Pune, Maharashtra, In

Worked with Microsoft group for Microsoft. Was spot-awarded for outstanding contribution to the account.Lead a team of six, initiated four projects (one of which was at Microsoft, Redmond). Worked on tools development. Initiated onsite the project to automate the ETL systems' working and make ETL systems metadata driven.Lead the team on Visual Studio 2008 and Vista Software Development Kit. Part of testing team for Microsoft SQL Server Best Practices Analyzer.Developed connectors for SSIS (most prominent being Oracle bulk load destination connector).Developed Visual Studio extensions.Worked on C#, .NET, SQL Server Integration Services (SSIS), Visual Studio Integration Package (VSIP), SQL Server 2005, Oracle 9i and 10G and XML Web Services.

Mumbai, Maharashtra, In

Worked on a live data warehousing project for Agilent Technologies. Developed ETL system using Informatica.

Engineer'S Degree, Computer Science And Engineering

High School, Non-Medical