Shrey Gupta

Junior Analyst

Kanpur Nagar, India 1+ yrs exp 84 · Excellent

About

Junior Data Analyst with 2 years of hands-on experience in Data Reporting, delivering timely MIS reports and executive dashboards to enhance operational visibility. Demonstrates strong analytical thinking and attention to detail in driving data quality and resolving discrepancies across large datasets, utilizing Excel, SQL, Power BI, and Google Sheets to expose trends and anomalies. Seeks to further impact analytics through automation, collaboration, and enabling leadership insights.

Skills & Expertise (71)

Excel Advanced

8.2/10

Years Exp

Power BI Intermediate

7.5/10

Years Exp

SQL Intermediate

7.5/10

Years Exp

Data Cleaning Intermediate

7.0/10

Years Exp

Python Intermediate

7.0/10

Years Exp

Data Visualization Intermediate

7.0/10

Years Exp

Generative AI Tools Beginner

6.5/10

Years Exp

Looker Studio Intermediate

6.5/10

Years Exp

DAX Intermediate

6.5/10

Years Exp

Data Governance Beginner

5.5/10

Years Exp

Cloud Computing Beginner

5.0/10

Years Exp

Networking Root Cause Analysis ETL Processes Business Intelligence Data Architecture Ownership Data Integration Data Transformation Creative Thinking Communication Conflict Resolution Strategic Planning collaboration Negotiation Skills Mentorship Attention to Detail Analytical Thinking Statistical Analysis Dashboarding Data Reporting Google Sheets Machine Learning Data Warehousing Predictive Modeling Critical thinking Adaptability Problem Solving Team Collaboration Time management Joins Pivot Tables Pivot Charts XLOOKUP VLOOKUP Index Match Power Query Conditional Formatting Data Validation Dashboards Select WHERE GROUP BY ORDER BY HAVING Case Data Mining Window Functions Views Data Modeling KPI Dashboards Pandas NumPy Matplotlib Anomaly Detection Report Automation KPI Reporting Trend Analysis Data Quality MIS Reporting OpenAI

Work Experience

Analyst – Data Analytics, MIS Reporting & Business Operations

HCLTech

Nov 2024 - Present

Prepared and delivered daily, weekly, and monthly MIS reports to client leadership with 100% on-time, accurate delivery – built reports using Advanced Excel (Pivot Tables, XLOOKUP, Conditional Formatting, Data Validation) and Google Sheets to track operational KPIs and SLA metrics, ensuring data reporting accuracy and attention to detail. Built KPI dashboards in Looker Studio and Power BI, combining SQL aggregations (SELECT, GROUP BY, HAVING, Window Functions including ROW_NUMBER and RANK) with DAX measures and Power Query transformations to deliver executive-level performance visibility and support dashboarding initiatives. Performed data quality validation and discrepancy resolution across 500+ operational records in ServiceNow and SharePoint – applied SQL JOINs, CTEs, and CASE statements to cross-check datasets, identify root causes of data issues, and correct classification and timestamp errors with full audit trails, demonstrating strong problem solving and analytical thinking. Conducted trend analysis and root cause analysis on recurring operational issues – used Python (Pandas, NumPy) for anomaly detection on server metrics, flagging irregularities and providing data-backed findings to engineering and operations teams. Automated repetitive reporting workflows using Python (openpyxl) – built scripts to refresh pivot summaries and generate formatted Excel MIS reports, significantly cutting manual processing time and improving reporting consistency, highlighting adaptability and ownership. Created Pivot Charts, INDEX MATCH lookups, and dynamic dashboards in Excel to visualize SLA breach patterns, incident trends, and utilization benchmarks – enabling leadership to make data-driven decisions on operational performance and fostering communication and collaboration. Modeled data using Power Query and SQL Views to consolidate multi-source operational data into clean, analysis-ready datasets for downstream reporting and business operations analysis. Generated weekly SLA exception reports from SQL views and Excel, reducing leadership query turnaround time. Validated incoming ServiceNow incident feeds using SQL JOINs and scripts, correcting timestamp and status mismatches. Designed automated Excel templates with XLOOKUP and conditional formatting to standardize monthly MIS packages. Built Power BI dataset with DAX measures and Power Query transforms to consolidate multi-source operational metrics. Performed anomaly detection on server logs using Python (Pandas) to surface recurring outages for engineering review. Led handoff documentation and SOPs for report owners, improving report reproducibility across operations teams and supporting collaboration. Created ad-hoc SQL queries and pivot-ready extracts for business stakeholders to speed decision cycles. Compiled daily MIS extracts from ServiceNow and SharePoint using SQL queries, delivering reconciled datasets to stakeholders. Validated timestamps and status fields across 500+ records with JOINs and CASE logic to correct classification errors with attention to detail. Developed Power Query transformations to consolidate multi-source feeds into a single analysis-ready view for reporting. Automated Excel report generation with openpyxl scripts to refresh pivot summaries and apply consistent formatting. Wrote DAX measures and Power BI visuals to track SLA breaches and present weekly exception lists to operations leadership. Performed anomaly detection on server metrics using Pandas and NumPy, flagging irregularities for engineering review. Built Looker Studio dashboards combining SQL aggregations and visual filters to support client performance discussions and demonstrate data reporting expertise.