Summary
Overview
Work History
Education
Skills
Certification
Work Availability
Quote
Timeline
BusinessAnalyst
Dhiraj Kumar

Dhiraj Kumar

Delhi

Summary

A seasoned banking professional with 10+ years of experience, I excel in leading diverse projects and teams, showcasing expertise in data analysis, dashboard development, and ETL processes. Holding a Data Science diploma, proficiency spans Excel, SQL, SSIS, Power BI, Tableau, Python (including pandas and numpy), as well as ML and DL techniques. Passionate about leveraging data for valuable business insights, I consistently excel in analyzing complex datasets, creating user-friendly dashboards, and applying advanced methodologies. Committed to continuous learning, I stay updated with industry trends and emerging technologies. With a focus on achieving exceptional outcomes, I leverage skills to drive impactful results for organizations.

Overview

10
10
years of professional experience
1
1
Certification

Work History

Lead Engineer

ThoughtFocus
11.2022 - Current
  • Developed a new dashboard utilizing Power BI, effectively visualizing data and providing valuable insights.
  • Constructed a comprehensive set of measures to calculate and validate numerical values at the model level, ensuring accurate and reliable data analysis.
  • Collaborated with the team to identify key performance indicators (KPIs) and integrated them into the dashboard, enabling stakeholders to monitor important metrics effortlessly.
  • Implemented data cleansing and transformation techniques to enhance the quality of data used in the dashboard, resulting in improved accuracy and usability.
  • Conducted thorough testing and validation to ensure the dashboard's functionality, responsiveness, and compatibility across different devices and screen sizes.
  • Worked closely with stakeholders to understand their requirements, translating them into actionable items and delivering solutions that met or exceeded expectations.
  • Documented the entire development process, including data sources, transformations applied, and calculations performed, facilitating easy maintenance and future enhancements.

Sr Consultant

Deloitte
11.2020 - 11.2022
  • Led Power BI projects, taking charge of end-to-end project management and ensuring successful delivery within specified timelines.
  • Engaged directly with clients, understanding their business requirements and translating them into effective Power BI solutions.
  • Developed complex DAX (Data Analysis Expressions) formulas to extract valuable insights from the data, enabling advanced calculations and measures.
  • Designed visually appealing and user-friendly templates for Power BI reports and dashboards, enhancing the overall user experience.
  • Created new dashboards from scratch, incorporating relevant data sources, visualizations, and interactive features to provide actionable insights to stakeholders.
  • Took responsibility for meeting project deadlines, and coordinating tasks and resources efficiently to ensure timely completion.
  • Collaborated closely with cross-functional teams, including data analysts, developers, and business stakeholders, fostering effective communication and collaboration throughout the project lifecycle.

MIS Executive

Fullerton India
07.2018 - 10.2020
  • Designed and developed performance tracking dashboards for field and in-house collection teams.
  • Built data models from scratch, leveraging Python and Power Query for ETL processes on unstructured data.
  • Wrote complex DAX queries to develop interactive dashboards and track key performance indicators (KPIs) for various loan types and revenue streams.
  • Published reports on the Power BI service for easy access and sharing.
  • Took ownership of handling ad hoc requests and efficiently updated live systems.
  • Planned and led administration of management information system for achieving threshold-level performance

Data Specialist

Navatar Group
01.2018 - 07.2018
  • Project assignment and monitoring to ensure timely delivery.
  • Extracting strategic insights from diverse data sources (unstructured/structured/live).
  • Designing reports and templates for M&A/Private Equity stakeholders.
  • Preparing performance and escalation reports.
  • Resolving process-related queries for team members.
  • Data manipulation, cleansing, and processing using Excel and Power BI.

Acquisition Manager

Indusindbank
06.2016 - 01.2018
  • Gathered and analyzed business requirements, estimating feasibility, time, and efforts.
  • Analyzed business requirements and functional specifications.
  • Developed DAX queries for dashboard creation.
  • Designed interactive dashboards using Power BI and Tableau.
  • Proficient in ETL tools such as Excel, Power Query, and Python for data wrangling.
  • Managed multiple requirements, reports, and dashboards concurrently with Power BI and Tableau.
  • Took complete ownership of handling ad hoc requests and ensuring timely updates.
  • Monitored and ensured timely publication of reports, automating manual processes where possible.
  • Conducted analysis on historical credit card and personal loan data, providing valuable insights.

MIS Executive

Omni Solution
08.2013 - 05.2016
  • Analyzed historical sales and recovery data, extracting actionable insights and identifying opportunities.
  • Created a sales tracker to monitor and compare targets and achievements.
  • Designed dashboards using Excel tools, generating monthly review reports.
  • Developed logic for monthly incentive calculations.
  • Conducted data wrangling using Excel, Power Query, and SSIS.
  • Automated data quality checks across multiple systems using VBA Macros and Excel.
  • Examined ISO Certification Reports in collaboration with clients and salespersons.

Education

PGDS - IT

IIIT
Bangalore
2021

MBA - Finance

Mahatma Gandhi University
Meghalaya
2016

Skills

  • Power BI Microsoft Certified PL300, Tableau, Excel
  • Matplotlib, Seaborn, Plotly Express
  • SQL Server, Python, Pandas, NumPy
  • Machine Learning, Deep learning
  • AWS Certified Cloud Practitioner

Certification

  • Microsoft Certified PL 300
  • AWS Certified Cloud Practitioner
  • Microsoft Certified Excel 2016

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Quote

Do not go where the path may lead, go where there is no path and leave a trail.
Ralph Waldo Emerson

Timeline

Lead Engineer

ThoughtFocus
11.2022 - Current

Sr Consultant

Deloitte
11.2020 - 11.2022

MIS Executive

Fullerton India
07.2018 - 10.2020

Data Specialist

Navatar Group
01.2018 - 07.2018

Acquisition Manager

Indusindbank
06.2016 - 01.2018

MIS Executive

Omni Solution
08.2013 - 05.2016

PGDS - IT

IIIT

MBA - Finance

Mahatma Gandhi University

Similar Profiles

CREATE PROFILE
Dhiraj Kumar