Suraj Kumar Jha
Noida
Summary
Data Analyst with expertise in Power BI, SQL, and Advanced Excel, with 6+ years of experience in developing dashboards, data modeling, and business performance reporting. Skilled in DAX, Power Query, ETL processes, and SQL optimization to transform raw data into meaningful insights. Experienced in supporting business teams with data-driven strategies and automated reporting solutions.
Overview
1
1
Certification
7
7
years of professional experience
Work History
Sr. Associate Data Analyst
upGrad Education Pvt Ltd
Noida
11.2024 - Current
- Automated daily sales data updates in dashboards using Power Query, ensuring accurate and timely reporting with minimal manual intervention.
- Optimised SQL queries to extract current quarter performance metrics (total call time, sales count, counselling data) at employee level using aggregations and GROUP BY, integrating output with Power BI for real-time performance dashboards.
- Created sales dashboards featuring KPIs, cards, and slicers to monitor calling time, counselling activities, and other performance metrics.
- Built revenue dashboards to analyse last 7-day revenue trends and sales sources for management decision-making.
- Implemented Row-Level Security (RLS) to ensure secure, role-based data access for different stakeholders.
WFM Analyst
Concentrix Daksh Pvt Ltd
Gurugram
06.2022 - 11.2024
- Leveraged advanced SQL to analyse employee production data across multiple datasets, enabling data-driven decision making and improving operational efficiency by 15%.
- Developed data models in Power BI by establishing relationships across multiple data sources, facilitating accurate production performance analysis.
- Streamlined Power BI dashboards for production and attrition analysis, enhancing reporting efficiency and providing actionable insights.
- Collaborated with clients to gather business requirements and address data-related queries, ensuring alignment with operational needs.
Sr. MIS Reporting Analyst
Tech Mahindra
Noida
09.2021 - 06.2022
- Prepared weekly and monthly reports, including scorecards, dashboards, budget allocations, and variance analysis, to support senior management decision-making.
- Maintained and updated daily productivity reports with Advanced Excel and Power BI, providing data visualisation and insights for informed strategic planning.
- Generated client count and daily performance reports while overseeing management of client additions, deletions, and leave records to ensure accurate tracking of client metrics.
Reporting Associate - Operations
One97 Paytm
Noida
04.2019 - 09.2021
- Built and deployed a real-time Power BI dashboard integrated with Hive SQL via Direct Query, providing live onboarding insights to leadership.
- Generated automated reports by extracting merchant onboarding data from Hive Server using SQL, enabling accurate weekly tracking of business performance.
- Prepared flash reports, forecasts, and actual vs budget reports, facilitating monitoring of profitability and revenue performance.
- Optimized Hive SQL queries and implemented role-based filters, enhancing data security and query performance.
Education
Bachelor of Arts - Political Science
IGNOU
Noida, India01-2018
Class XII -
CBSE Board, Delhi
01-2014
Class X -
CBSE Board
Skills
- Power BI
- Data Analysis
- Data Modelling
- Dashboard Creation
- Data visualisation
- KPIs
- Measures
- DAX
- Row-Level Security
- Power Query
- Advanced Excel
- Pivot Tables
- XLOOKUP
- INDEX-MATCH
- SUMIFS
- Reporting Automation
- Interactive Dashboards
- Power BI Service
- Publishing
- Refresh Scheduling
- App Workspaces
- SQL
- Querying Skills
- Joins
- Subqueries
- Window Functions
- CTEs
- Aggregations
- Query Performance Optimization
- Data Cleaning
- ETL Processes
- Data Cleaning
- ETL Processes
Certification
- Management Information Systems (MIS) Certification, MAATI Institute Delhi, 2018
- Power BI Certification, MAATI Institute Delhi, 2020
- SQL Certification, MAATI Institute Delhi, 2018
Accomplishments
- Designed SQL queries to extract and monitor employee production details, improving reporting accuracy by 25%.
- Created sales revenue dashboard in Power BI that gave leadership real-time visibility into KPIs, leading to faster decision-making.
- Recognized multiple times for outstanding performance, quality delivery, and contribution to business growth.
Custom
http://www.linkedin.com/in/suraj-kumar-jha-088b68151
Timeline
Sr. Associate Data Analyst
upGrad Education Pvt Ltd
11.2024 - Current
WFM Analyst
Concentrix Daksh Pvt Ltd
06.2022 - 11.2024
Sr. MIS Reporting Analyst
Tech Mahindra
09.2021 - 06.2022
Reporting Associate - Operations
One97 Paytm
04.2019 - 09.2021
Bachelor of Arts - Political Science
IGNOU
Class XII -
CBSE Board, Delhi
Class X -
CBSE Board