Shubh Deep Chaudhary

Results-driven Data analyst with three years of experience in designing and optimizing ETL workflows to enhance business decision-making. Expert in data preparation, blending, complemented by strong SQL skills for efficient data extraction, transformation, and querying. Proven ability to automate complex data pipelines and deliver actionable insights through collaboration with cross-functional teams and stakeholders, including industry leaders like NielsenIQ and Walmart. Skilled in requirement analysis, database management, and process optimization, aiming to leverage Alteryx and SQL expertise to drive scalable, data-driven business outcomes

• Uber Drive Dataset, 5 Months, Designed and optimized a full-stack ETL pipeline using Power BI to analyze Uber ride data. Automated data ingestion, cleaning, transformation, and reporting. Developed DAX to streamline data preprocessing and reduce runtime by 40%. Integrated SQL queries to fetch data from relational databases, applying aggregations and filters. Used CASE statements and indexing for performance tuning and categorization. Built modular workflows and batch macros to automate data ingestion, transformation, and report generation
• Sales Performance Dashboard Automation, 6 Months, Created a fully automated ETL process for sales data across regions and integrated it with Power BI for realtime dashboard updates. Developed chained apps and used interface tools for parameterized report generation. Used multi-row formulas, conditional filtering, and join tools to handle complex aggregations. Scheduled workflows in Power BI and implemented email delivery of reports to regional heads. Reduced workflow runtime by 40% by implementing data schema optimization and minimizing tool overhead
• Financial Data Reconciliation, 9 Months, Engineered a scalable reconciliation ETL framework in Power BI to match transaction-level data from two systems. Used error flagging, conditional joins, and multi-layer transformation to reconcile 1M+ records monthly. Implemented logging framework for traceability and auditing. Deployed and scheduled workflows on Power BI Server and published reconciled data for dashboards
• FMCG data analysis, 7 Months, Extracted large-scale POS transactional data using SQL (JOINs, CTEs, and aggregations) from a relational database. Used Power query to automate data cleaning and preprocessing, reducing manual effort. Integrated SQL and Power BI for advanced data transformation and real-time reporting. Optimized Alteryx workflows, reducing ETL processing time by 40% through efficient data blending and transformation

• English
• Hindi