Shubham Kumar Mishra

Results-oriented Data Engineer with over 4.5 years of experience in data analytics, ETL pipeline development, and data modeling. Proficient in designing scalable Data Warehouse solutions using Star and Snowflake schemas, and skilled in creating impactful dashboards in Power BI. Successfully migrated on-premises data to Azure, ensuring data integrity, while implementing custom DAX formulas that enhanced data-driven decision-making.

Data Engineer at Global Logic (2023-02 – Present)

• Developed interactive dashboards using Power BI and DAX to drive data-driven decision-making.
• Wrote optimized SQL queries and reports to analyze customer retention and sales performance.
• Improved dashboard performance by 30–40% by optimizing DAX and data models
• Implemented SCD Type 1 & Type 2 using SQL and ETL processes to manage historical data.
• Implemented Row-Level Security (RLS) to ensure secure, role-based data access.
• Developed reusable DAX measures and calculation groups for scalable reporting.
• Integrated Power BI with multiple data sources (SQL Server, Azure, APIs, Excel).
• Designed drill-through, bookmarks, and dynamic dashboards for better user interaction.

Database Developer at People Tech Group (2021-07 – 2023-01)

Led migration of on-premises data to Azure cloud using Azure Data Factory and SSIS, ensuring data integrity and seamless transition.

• Worked with SQL Server, Azure SQL, Azure Data Factory, and Azure Synapse to build and manage cloud-based data solutions.
• Designed and implemented fact and dimension tables using Star Schema for customer and product analytics.
• Collaborated with business analysts to gather requirements and develop scalable data warehouse (DWH) solutions.
• Ensured data security and compliance, including PII masking and governance standards.
• Developed and optimized Power BI dashboards and reports, leveraging SSRS for data sourcing and performance tuning.

Bachelor of Engineering in Computer Science and Engineering – Institute of Technology & Management (2015-07 – 2019-07)