Gourav Halder
Kolkata
Summary
More than 7 years of experienced professional in Reporting, data analysis, data visualization, report automation. Seeking a position that allows me to apply my strong analytical and problem-solving skills, along with my passion for continuous learning, to make a positive impact and contribute to the overall goals of the organization.
Overview
8
8
years of professional experience
1
1
Certification
Work History
Team Lead (Business Intelligence and Automation)
Tata Consultancy Services
Kolkata
02.2024 - Current
- Prepared Automated solution for using Power BI and VBA to automate daily SLA, Non SLA and Working Day pipeline volume report for operation which has reduced 95% of the previous time.
- Developed multiple Desktop Application using VBA and Access Database - SLA Miss, Quality, Resource Database, Time Tracking, survey Application.
- Prepared Automated Daily Utilization Report, Capacity Planning, Volume Forecasting Report for around 600 FTEs.
- Combining all the automated solutions have reduced the daily manual reporting timing and effort to 90% of their previous timing.
Software Engineer
Capgemini
02.2023 - 02.2024
- Developed complete end to end Supply Chain Dashboard for a unit in Power BI and published.
- Developed improvement of Headcount and MT (missing time) dashboard in Power BI.
- Implementing proper scheduling for data refresh and row-level security in Power BI workspaces depending on the type of access required.
- Developing analysis reports and visualization using DAX functions like Calculate, Filter, All, AllSelected, AllExcept, RemoveFilter, Aggregation, Logical, Text, Date-time, and Iteration functions.
- Writing SQL scripts, queries and stored procedures to extract data.
- Performing data analysis for generating reports using Excel and SQL.
Reporting Analyst
02.2022 - 02.2023
- Prepared Global HR Reports & Dashboard for different business units as per the requirement of different stake holders.
- Developing interactive analysis reports and dashboards in Power BI and Excel.
- Prepared Headcount, Attrition and ARC analysis reports and dashboards.
- Design and development of reporting data model for HR data analytics.
- Performing data analysis for generating reports using Excel and SQL.
- Writing SQL queries to extract data from databases for reporting purposes.
- Automating existing Scheduled reports using VBA, Power Query, Power Pivot and Power BI.
Senior Data Process Executive
Cognizant
02.2018 - 01.2022
- Preparing Daily, Weekly & Monthly MIS Reports.
- Preparing presentations, Graphs and analytical reports.
- Development and improvement of different reporting system for customer management and internal communication.
- Developing Power BI reports and dashboards from multiple data sources and publish them on Power BI Service.
- Creating Measures and Calculated columns using DAX.
Education
B.Sc. - Physics
University of Calcutta
01.2016
Skills
- Power BI
- SQL
- Microsoft Fabric
- Azure Data Factory
- SSIS,SSRS
- Data Modeling
- MS Access
- DAX
- Data Visualization
- Microsoft Power Query
- VBA
Certification
- Microsoft Power BI Desktop for Business Intelligence
- MySQL for Data Analysis
- Excel VBA - The complete Excel VBA Course for beginner.
- Alteryx Masterclass for Data Analytics, ETL and Reporting
Projects
1. Quality Dashboard :
Skills: Data Modeling · DAX · Microsoft Excel · Data Visualization ·
Microsoft Power BI · Dashboard · Data Analysis
Link: https://mavenanalytics.io/project/7610
2.Superstore Sales Analysis Dashboard :
Skills: Microsoft Excel · Microsoft Power BI · Microsoft Power
Query · Dashboard
Link: https://mavenanalytics.io/project/7582
Timeline
Team Lead (Business Intelligence and Automation)
Tata Consultancy Services
02.2024 - Current
Software Engineer
Capgemini
02.2023 - 02.2024
Reporting Analyst
02.2022 - 02.2023
Senior Data Process Executive
Cognizant
02.2018 - 01.2022
B.Sc. - Physics
University of Calcutta
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
Ratnadeep RoyRatnadeep Roy
Freelancer at Self-employed ServicesFreelancer at Self-employed Services