Mohit Batra Email and Phone Number
Mohit Batra personal email
- Valid
- Valid
• 18+ years of experience architecting & building BI, big data solutions with key metrics for Finance, Sales, Marketing and Compliance.• Building large scale Data Warehouses with volumes > 5TB, using Modern BI practices. Built critical systems for multi-billion-dollar payouts.• Experience on Cloud services. In-depth experience on Microsoft Azure stack and working knowledge of Amazon Web Services (AWS).• Pluralsight Author for course – Build your first ETL pipeline using Azure Databricks (https://app.pluralsight.com/library/courses/building-etl-pipeline-microsoft-azure-databricks/table-of-contents)• Certifications A. Microsoft Certified Trainer B. Azure Solutions Architect Expert (AZ-300, AZ-301) C. Azure Data Engineer Associate (DP-200, DP-201) D. Azure Developer Associate (AZ-203) E. Azure Administrator Associate (AZ-103) F. Microsoft Azure Certified Professional - 70-776 - Big Data Engineering in the Cloud G. Certified Scrum Master H. Certified SAFe practitioner• Key Technical Skills A. Cloud stack: Microsoft Fabric, Azure Databricks (Spark), SQL Data Warehouse, Data Factory, Data Lake, Data Lake Analytics, SQL Database, Cosmos DB, HDInsight, Virtual Machines, Stream Analytics, App Services, Web Apps, Logic Apps, Functions, API Management, Cognitive Services, Bot framework, Automation, Azure ML, ARM templates, Docker, Container Registry, Event Hubs, Event Grid, Service Bus., Snowflake B. AI Stack: Azure Open AI C. BI Tools: SQL Server 2016, Integration Services (SSIS), Analysis Services (SSAS), Power BI. D. Big Data: Hadoop, Spark E. Dev Tools/Languages: C#, .NET, T-SQL, VSTS.
Crystal Talks
View-
Crystal TalksHyderabad, In
-
FounderCrystal Talks Nov 2019 - PresentExtensive 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.
-
AuthorPluralsight Nov 2019 - PresentDraper, Ut, UsCourses:Building Your First ETL Pipeline Using Azure DatabricksConceptualizing the Processing Model for Azure Databricks Service -
Software Engineer 2Microsoft Jan 2017 - Nov 2019Redmond, Washington, UsProject – 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’. -
Senior ManagerSaxo India Private Limited Oct 2012 - Jan 2017Gurgaon, 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. -
Technical LeadNivio Oct 2011 - Oct 2012Palo Alto, Ca, Us -
FounderIpaathshala Labs Nov 2009 - Oct 2011 -
Senior Software EngineerPersistent Systems Aug 2008 - Nov 2009Pune, Maharashtra, InWorked with Microsoft Research group to implement pluggable security for a semantic store, Zentity. -
Software EngineerR Systems International Ltd Nov 2007 - Aug 2008El Dorado Hills, California, UsWorked 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 -
Software EngineerPersistent Systems Ltd. Jul 2005 - Nov 2007Pune, Maharashtra, InWorked 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.
-
Project TraineeTata Consultancy Services Jul 2004 - Dec 2004Mumbai, Maharashtra, InWorked on a live data warehousing project for Agilent Technologies. Developed ETL system using Informatica.
Mohit Batra Skills
Mohit Batra Education Details
-
Punjab Technical UniversityComputer Science And Engineering -
D.A.V. Public School, RohiniNon-Medical
Frequently Asked Questions about Mohit Batra
What company does Mohit Batra work for?
Mohit Batra works for Crystal Talks
What is Mohit Batra's role at the current company?
Mohit Batra's current role is Microsoft Certified Trainer | Author - Pluralsight / ACloudGuru / O'Reilly | Azure, Big Data, AI | Ex-Microsoft | Speaker.
What is Mohit Batra's email address?
Mohit Batra's email address is ms****@****ail.com
What schools did Mohit Batra attend?
Mohit Batra attended Punjab Technical University, D.a.v. Public School, Rohini.
What are some of Mohit Batra's interests?
Mohit Batra has interest in Listening To Music, Children, Learning New Technology, Education, Playing Lawn Tennis, Health.
What skills is Mohit Batra known for?
Mohit Batra has skills like .net, Software Design, Data Warehousing, Etl, Amazon Web Services, Ssis, T Sql, Visual Studio, Microsoft Azure, Microsoft Sql Server, Load, Azure Data Factory.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial