Pranjul Tripathi

Data Analyst

Madhya Pradesh 3+ yrs exp 87 · Excellent

About

SQL-focused Data Analyst with 3+ years of experience working with large-scale datasets, ETL workflows, and enterprise reporting systems across consulting and technology environments. Strong expertise in advanced SQL, data validation, reconciliation, and performance optimization within Data Warehouse environments. Experienced in end-to-end analytics workflows including data extraction, transformation, profiling, and insights generation. Hands-on exposure to fact-dimension modelling, query tuning, and production data pipelines using SQL, Python, and Power BI.

Skills & Expertise (45)

SQL Advanced

8.5/10

Years Exp

Advanced SQL Advanced

8.0/10

Years Exp

Pandas Intermediate

7.5/10

Years Exp

Data Analysis Intermediate

7.5/10

Years Exp

Python Intermediate

7.5/10

Years Exp

Problem Solving Intermediate

7.0/10

Years Exp

Stakeholder Collaboration Intermediate

7.0/10

Years Exp

Power BI Intermediate

7.0/10

Years Exp

Data Transformation Intermediate

7.0/10

Years Exp

ETL workflows Intermediate

7.0/10

Years Exp

Data Cleaning Intermediate

7.0/10

Years Exp

Databricks SAP Microsoft Copilot Generative AI NumPy Complex Joins CTEs Window Functions Stored Procedures Query Optimization Aggregations Data Validation Performance Tuning SQL Server MySql Star Schema SharePoint Excel Power Query Data Reconciliation Fact & Dimension tables Data Warehousing Reporting DAX Power Query Dashboard Development Excel Automation VBA KPI Analysis Requirement gathering Large Dataset Handling Analytical Thinking Production support Data Pipelines Root Cause Analysis

Work Experience

Data Analyst

Deloitte USI

Feb 2025 - Present

Worked extensively on SQL-based data extraction, transformation, and validation processes for enterprise reporting workflows. Processed and analysed 1M+ records from enterprise SQL databases ensuring 99%+ data accuracy and consistency across reporting systems. Optimised complex SQL queries and reporting workflows, improving data refresh efficiency by 25%. Performed data profiling, reconciliation, and root cause analysis to identify reporting inconsistencies and improve data quality. Collaborated with cross-functional stakeholders to gather reporting requirements and deliver analytical solutions aligned with business needs. Built automated ETL-style workflows using SQL, Power Automate, VBA, and Databricks reducing manual effort by 8–10 hours weekly. Developed semantic data models and implemented incremental refresh strategies to improve reporting performance and scalability. Leveraged Microsoft Copilot and Generative AI tools to streamline SQL development and analytical workflows.

Data Analyst

Fauxiq Technology Pvt Ltd

Nov 2022 - Feb 2025

Performed SQL-driven analysis on large customer and billing datasets to support operational and financial reporting. Developed and maintained data transformation pipelines using Python (Pandas) and SQL for data cleansing and validation. Identified and resolved billing discrepancies through reconciliation and root cause analysis, preventing annual revenue leakage exceeding INR 10 Lakhs. Worked with structured datasets across multiple sources ensuring consistency, accuracy, and reporting reliability. Automated recurring reporting processes using SQL and Excel-based automation improving reporting accuracy by 25%. Supported end-to-end analytics workflows including data sourcing, transformation, validation, and reporting.