Jenish

Data Analyst

2+ yrs exp 86 · Excellent

About

Data Analyst with 3 years at Tata Consultancy Services (TCS) turning large, messy operational datasets into automated reporting and BI solutions. Delivered a Python automation that cut a recurring report cycle from 2–3 days to 5 minutes, and a root-cause analysis that lifted client productivity from 20% to 75% in three months. Strong hands-on background in SQL (joins, CTEs, window functions), Power BI/DAX, and Azure ETL (Data Factory, Synapse), with working exposure to ADLS Gen2, Medallion Architecture, and CI/CD-based deployments.

Skills & Expertise (44)

Power BI Advanced

8.0/10

Years Exp

SQL Advanced

8.0/10

Years Exp

Data Cleaning Advanced

7.4/10

Years Exp

Data Warehousing Intermediate

7.0/10

Years Exp

Stakeholder Management Intermediate

7.0/10

Years Exp

ETL Intermediate

7.0/10

Years Exp

Python Intermediate

7.0/10

Years Exp

Data Modeling Intermediate

7.0/10

Years Exp

MySql Trend Analysis Postgresql SQL Server Excel Pivot Tables XLOOKUP VLOOKUP Advanced Formulas VBA Macros Business Requirements Gathering Power Automate ServiceNow Git GitHub Root Cause Analysis Power Query validation Transformation Data Quality Azure Data Factory Azure Synapse Analytics ELT ADLS Gen2 Medallion Architecture DAX OpenpyXL Power BI Service Deployment Pipelines Dashboard Development KPI Reporting Pandas NumPy Matplotlib Seaborn

Work Experience

Data Analyst

Tata Consultancy Services (TCS)

Apr 2025 - Present

Delivered BI reporting and contributed to data engineering activities for airline booking, cancellation, and regional performance data, supporting commercial and operations stakeholders. Contributed to Azure Data Factory and ADLS Gen2 pipelines for data ingestion, staging, validation, and transformation, with Synapse Analytics for downstream analysis. Worked with data from multiple sources, including CSV, MySQL, SQL Server, Amazon S3, and ServiceNow, integrating and validating datasets for downstream analysis and reporting. Gained working exposure to CI/CD-based deployment of ADF/Synapse changes across Dev, Test, and Production environments. Wrote SQL using joins, CTEs, window functions, and CASE logic to clean, validate, and analyze data, surfacing high-value customer segments, top booking channels, and cancellation drivers. Developed interactive Power BI dashboards tracking booking trends, cancellations, regional performance, and business KPIs for operational stakeholders. Published and managed semantic models across Dev/Test/Prod using Power BI Deployment Pipelines with configured scheduled refreshes. Built Power Automate workflows to send automated success/failure alerts for dataset refreshes, reducing manual monitoring.

Data Analyst

Scottish Power Electricity Network (SPEN)

Oct 2023 - Mar 2025

Processed and validated 40,000+ operational data files per reporting cycle (800,000+ across the program), producing weekly management and client reports against defined performance benchmarks. Owned end-to-end reporting delivery, validated data, built Power BI dashboards, and published final outputs to the client via SharePoint. Diagnosed a 60% productivity drop through file-processing-time analysis, isolating large-asset files (5–6 hrs) vs standard files (10–15 min) as the root cause. Presented root-cause findings to the client and proposed an automated polygon-generation concept, which the client's dev team built into a buffer-polygon feature lifting productivity from 20% to 75% over three months and helping the project finish ahead of schedule.