Parth Batra

Background

About Parth Batra

Data Analyst | Business Intelligence | Data Enrichment | SQL | Python | Power BIResults-driven Data Analyst with 3+ years of experience, specializing in data transformation, data enrichment, and business intelligence. Proven ability to analyze large-scale datasets, optimize SQL queries, and deliver actionable insights that drive decision-making. Current Role at TCS – Envestnet | Yodlee Data Enrichment Project:Working on a leading financial data aggregation platform that enhances merchant identification and transaction analytics for BFSI clients.Extracting, cleansing, and transforming millions of financial transactions using SQL, Python (Pandas, NumPy, Regex), and AWS to improve data accuracy and reporting efficiency.Designing and implementing regex-based transaction patterns, enabling machine learning models to predict merchant names accurately from transaction descriptions.Conducting Root Cause Analysis on YoY and MoM transaction trends, identifying key drivers for transaction dips, new pattern shifts, and merchant activity changes.Optimizing AWS Redshift-based data pipelines, ensuring faster data processing and real-time financial insights for stakeholders.Developing KPI-driven Power BI dashboards, automating reports, and providing actionable business insights to drive better financial decision-making.Managing and resolving JIRA tasks, ensuring structured project tracking, issue resolution, and process improvements. Previous Project – PayCor Implementation (Payroll Management System):Processed and standardized payroll data by cleaning and formatting large volumes of paycheck records using Excel (VLOOKUP, Pivot Tables, Data Validation) and SQL.Loaded structured payroll data into databases, ensuring seamless integration with payroll management systems.Collaborated with cross-functional teams to improve payroll data workflows, reducing manual effort and increasing reporting accuracy. Achievements & Recognitions: Twice received the On The Spot Award for client appreciation. Service and Commitment Award for completing 3 years at TCS. Appreciation Certificate from HR and Unit HR for compliance with RTO and dedication to work. Key Skills: SQL | Python (Pandas, NumPy, Regex)| Power BI | AWS (Redshift, S3)| Data Wrangling | KPI Analysis | Root Cause Analysis | Stakeholder Communication | JIRA Passionate about data-driven decision-making, trend analysis, and optimizing business intelligence processes. Open to Data Analyst & Business Analyst roles in product-based, fintech, or e-commerce companies.