Kalpraj Anand

Data Analyst (Consultant)

Grant Thornton Bharat LLP•  September 2024 - Present•  Gurgaon

Developed and optimized ETL workflows using PostgreSQL, ensuring efficient data extraction, transformation, and loading for real-time insights. Automated repetitive processes, reducing manual intervention by 30% and enhancing data accuracy. Designed interactive Tableau dashboards and Power BI reports for stakeholders, enabling actionable insights into operational performance. Created dashboards for financial performance tracking, reducing reporting time. Seamlessly synchronized Tableau with SQL databases, enabling real-time dashboard updates and ensuring data accuracy. Integrated data quality checks into pipelines to ensure regulatory and organizational compliance. Collaborated with teams to define KPI metrics and align data processes with business objectives. Optimize the data source connections (Direct connection, Indirect connection, Direct Query and import mode).

Data Analyst

JLL•  January 2023 - August 2024•  Gurugram, India

Created data models and optimized workflows in Power BI for efficient data exploration, linking multiple data sources. Delivered insights by developing interactive Tableau dashboards and presenting findings to senior management. Conducted financial analysis on operational activities, identifying cost-saving opportunities. Developed structured ETL processes in Azure for integrating diverse datasets and maintaining data integrity. Provided actionable insights for strategic planning, market analysis, and competitive benchmarking.

Business Analyst

Ewebguru Solution Pvt Ltd•  December 2021 - January 2023•  Noida, India

Designed and deployed Power BI dashboards, transforming raw data into visually appealing, actionable reports for clients. Actively involved in BI pre-sales activities, gathering requirements and presenting customized solutions to stakeholders. Conducted user training sessions to improve client understanding of BI dashboards. Transitioned existing Excel-based MIS reports into Tableau and Power BI, improving efficiency and interactivity.

Business Analyst

Xaivelence Infotech Pvt Ltd•  September 2017 - March 2020•  Patna, India

Developed KPI-driven dashboards in Power BI for clients, showcasing business performance metrics. Integrated Excel with Power BI for seamless data updates and real-time analysis. Utilized SQL for data modeling, joins, and aggregations to support custom reporting requirements. Provided real-time reporting solutions by integrating SQL databases with Power BI for seamless analysis. Built an Excel-based financial model for monthly expense tracking, improving budget accuracy. Actively being a part of BI pre-sales activities for understanding Business problems and providing solution accordingly.

IIT JODHPUR

Data Science, PGD(DE)•  January 2023 - January 2024•  Percentage: 72

Executive program for Data Science

mechanical Eng, B.Tech•  January 2009 - January 2013•  Percentage: 83

Mechanical Engineering