Niharika Raghav

Aiming to contribute to an organization's success by developing intuitive, interactive dashboards, performing advanced data analytics, and delivering data-driven strategies that enhance business performance and operational efficiency.

Seasoned Data Engineer

Professional with over 9 years of experience, including 6 years of specialized expertise in Azure DataBricks, Azure Data Factory, PySpark, SQL, MS Fabric. Utilized ADF debug mode, activity run logs, and dependency tracking to identify bottlenecks, troubleshoot failed activities, and implement robust retry and error-handling mechanisms. Incorporated SQL-based validation scripts and custom PySpark checks within Databricks to ensure data accuracy, completeness, and consistency across ingestion and transformation layers.

Specialized in Complex Data Modeling and Predictive Analytics, enhancing forecasting accuracy through robust statistical analysis and machine learning models. Hands-on experience in ETL Operations and Data Integration using tools like Alteryx and Python, integrating data from diverse sources to deliver actionable insights for stakeholders. Adept at Business Intelligence (BI) Solutions with a deep understanding of Data Warehousing Concepts, enabling scalable and efficient reporting structures across organizations.

Recognized for Project Management Expertise, having led end-to-end project deliverables in diverse environments including Deloitte, TCS, and Fractal Analytics, consistently meeting business objectives and deadlines.

Senior Consultant (Azure Power BI Engineer) - Deloitte

(2023-03)

Environment: Azure DataBricks, Azure Data Factory, PySpark, SQL, Power Automate, Power App, Power Bi Service, Python, Ci/CD (Azure DevOps)

• Developed custom ETL scripts in Python for complex data transformations not natively supported in ADF.
• Configured CI/CD pipelines in Azure DevOps for automated deployment of ADF pipelines, Power BI datasets, and Python scripts.
• Implemented version control and branching strategies (Git) to ensure smooth collaboration across teams.
• Automated data quality checks, logging, and error handling to improve reliability of data workflows.
• Designed and implemented scalable ETL pipelines in Azure Data Factory to automate data ingestion from diverse sources (SQL, APIs, flat files).
• Performing in-depth data analysis to identify trends, correlations, and actionable insights, continuously optimizing Power BI models to improve business intelligence frameworks and enhance reporting efficiency across departments.

Business Analyst - TCS

(2021-10 - 2023-02)

Environment: Azure DataBricks, Azure DataFactory, Alteryx, Excel, SQL, Power Bi Service

• Designed and implemented scalable pipelines in Azure Data Factory (ADF) to ingest data from diverse sources including SQL Server, REST APIs, flat files, and cloud storage into Azure Data Lake Storage Gen2 (ADLS Gen2).
• Leveraged Azure Databricks with PySpark to perform complex transformations such as flattening nested JSON, cleansing, and aggregating large datasets for analytical readiness.
• Built optimized SQL scripts and queries for data validation, transformation logic, and integration with downstream systems, ensuring high performance and accuracy.
• Integrating, cleansing, and harmonizing data from diverse databases, cloud platforms, and third-party APIs, ensuring comprehensive data quality and integrity to support robust analytics and performance metrics.

Consultant - Fractal Analytics (Procter & Gamble)

(2020-08 - 2021-10)

Environment: Azure DataBricks Azure DataFactory

• Tuned pipeline performance by leveraging parallelism, partitioning, and staging in ADLS Gen2, reducing overall data ingestion time and improving throughput for large datasets.

Senior Software Engineer - Value Labs Solution (Publics)

(2019-11 - 2020-05)

Publicis is a media-focused project based in the UK. Publicis Worldwide delivers strategic, creative, and digital solutions that empower clients to drive change and thrive in their marketing transformation efforts. Environment: Power BI, Birst, SQL

• Led the design and implementation of complex data models and BQL queries in BIRST, ensuring robust data structures and efficient query performance to support comprehensive business intelligence and analytics.
• Cultivated deep business acumen and established strong relationships with IT and business stakeholders, effectively aligning and integrating data activities to streamline processes and enhance collaborative efforts across organizational functions.

Software Engineer - Mother Son Sumi Infotech Design & Limited

(2017-06 - 2019-11)

This was the Japanese project, "Integrated Global Harness System (IGHS)," designed to automate the handling of parts used in automotive manufacturing. Environment: Power BI, WPF (Windows Presentation Foundation), SSRS, SQL

• Spearheaded the development of sophisticated reports utilizing Windows Presentation Foundation (WPF), enhancing user interface design and interactivity to deliver insightful and visually compelling data presentations.
• Architected and optimized complex stored procedures using SQL Server, and employed SQL Server Reporting Services (SSRS) to generate and print detailed, high-quality reports, ensuring precise and reliable data output for informed decision-making.

B. Tech. - Computer Science (2017)