About

Manoj Pandey is a Senior Software Engineer/Lead DE at Microsoft with over 15 years of experience in Data Engineering using Microsoft Data Platform. He is an expert in building modern BI data solutions on Microsoft Azure cloud by using Azure Data Lake, Azure Synapse, Azure Databricks, Azure SQL DB, Azure Data Factory, AAS Cube, Power BI, and on-premise solutions. Currently, he is working on a complete BigData LakeHouse & Reporting solution using Databricks/Synapse (Spark, Scala), ADF pipelines, AAS Tabular Cube, and Power BI dashboards. Manoj is experienced in implementing end-to-end DW/BI solutions by deriving Data Warehouse/LakeHouse, Data Marts from existing OLTP, Relational, noSQL, and heterogeneous source systems. He has strong skills in Microsoft SQL Server, SQL, writing complex SQL scripts, Stored Procedures, Query tuning & optimization, and Administration. He also has hands-on experience with Data & Dimensional Modelling, Database Design/Development. Manoj has performed several Upgrades and Migrations of VLDBs with TBs of data with complex/custom business logic/code. He is a Microsoft Certified Professional (MCP), 70-461 - Querying Microsoft SQL Server 2012/2014. He is an evangelist of “SQL and Data Analytics” through his personal blog SQLwithManoj.com. Manoj is currently working with Microsoft India as Senior Data Engineer (Dev Lead) for 10+ years. He has previously worked with NIIT and RMS India as a Senior Software Engineer. He holds a Master's degree in Computer Science & IT from Apeejay College and a Bachelor's degree in Computer Science & IT from Amrapali Institute. He completed his 10+2 from Beersheba Sr. Sec. School, Haldwani, Nainital, UA. Manoj's technical skills include SQL, Azure, Software Engineer, Databricks, Data Engineering, Spark, Data Warehouse, Scala, and NoSQL. He has 16.87 years of relevant experience in the field.