Sudhakar Rajput

Business Analyst

Gurgaon, Haryana, India8 yrs 9 mos experience

Key Highlights

Over 8 years of data analytics experience.
Expert in Power BI and SQL for reporting.
Strong background in financial reporting and KPI tracking.

Stackforce AI infers this person is a Data Analytics professional with expertise in Fintech and Consulting.

Contact

Skills

Core Skills

Data AnalysisReporting And AnalyticsFinancial ReportingFinancial Analysis

Other Skills

Advance ExcelAnalyticsCapital & Expense Budget ManagementCapital Expenditure PlanningClient SupportDAXData AutomationData CleaningData ConsolidationData ManagementData ModelingDocumentationKPI MonitoringKPI TrackingMIS Reporting

About

Data Analytics professional with over 8 years of experience in transforming complex data into actionable insights for strategic business decisions. Specialized in developing interactive dashboards and reports using Power BI, SQL, and DAX, with a strong background in financial reporting, KPI tracking, and data automation using Power Automate. Proven expertise across sectors including banking (IndusInd Bank), consulting (EY India), and hospitality (ITC Hotels). Adept at stakeholder management, RLS implementation, and creating MIS reports for executive leadership. Passionate about turning raw data into meaningful stories that drive results 🚀Key Expertise: 1- Rich experience in Microsoft Excel 2- Proficient in Power BI, Power Query, Data cleaning and Data Modeling techniques 3- Good Hands-on SQL 4- Having sound knowledge of Python and Azure Databricks. #Business Analysis #Data Analysis #Reporting and Analytics

Experience

8 yrs 9 mos

Total Experience

1 yr 9 mos

Average Tenure

1 yr 9 mos

Current Experience

Indusind bank limited

Data Analyst

Aug 2024 – Present · 1 yr 9 mos · Gurugram, Haryana, India · Hybrid

Develop new Power BI reports and Maintain/Modify existing power BI reports using various data sources.
Implementation of RLS to distribute data/reports in a secure way.
Write new queries/optimize existing SQL queries to fetch data from database as per stakeholder’s requirement.
Automation through Power BI: - Automated daily, weekly, and monthly reporting for key business metrics.
Created dashboards to track financial movements, product performance, and portfolio metrics to reduce manual efforts and improve productivity.
Tracking business Metrics / Management Reporting- Publishing regular reports on financial movements, FTE
And other performance metrics.to Monitor the business growth.
Prepare ad-hoc reports/dashboards to address queries and distribute to stakeholders as per requirement.
Variance analysis to track business -Plan Vs Actual/ YoY/MoM Metrics.
Data and Portfolio Management: - Working with large datasets and data warehouses, using optimized SQL queries for data extraction reduced query running time. Ensuring minimal unmapped portfolio by collaborating across PAN bank teams to maintain report accuracy.
Financial Analysis and Business Growth metrics- Conducting financial analysis, managing portfolios, and identifying growth customer trends to support business development results in growth in new business clients

Power BISQLDAXData AutomationFinancial ReportingKPI Tracking+2

Ey

Power BI Developer

May 2022 – Aug 2024 · 2 yrs 3 mos · Gurugram, Haryana, India · Hybrid

Key responsibility of handling & distributing Daily/Weekly and Monthly Power BI reports for PAN India Reporting practice.
Develop new PBI reports & modify existing reports as per management’s ask.
Manage Roles of stakeholders and Row Level Security.
Developed interactive dashboards in Power BI to monitor KPIs and provide real-time insights to the management.
Utilized SQL to query and extract data from databases and performed data cleaning and processing.
Participating in Trend Analysis through comparison from historical data and analyzing the reasons for variance
Developing and presenting MIS on budgets, actuals and variance analysis to management
Preparing Plan/Forecast Excel Models for different business partners/service lines & market segments controllers for getting their input and then compiling the data
Develop & review organization YTD monthly performance decks to and providing the same to CFO & India Managing Partners
Providing strong reporting and many other analytical information supports Exec. Management & leadership
Assisted CFO/Directors and senior leadership in effective decision making by KPI reporting
Coordinated with the IT team to automate the process of report sharing to align with business lingo of global
Work with business partners & cross functional teams to understand business objectives and develop value-added reporting and provide ad-hoc data extracts and analysis

Power BISQLData CleaningKPI MonitoringMIS ReportingData Analysis+1

Itc hotels

Finance Associate

Sep 2019 – May 2022 · 2 yrs 8 mos

Responsible for creating monthly financial reports and ad hoc reports for a high-volume Hospitality business. Identified opportunities for 15% more revenue.
Assisting in Planning of Monthly, Quarterly and Yearly Capital Expenditure, Revenue and Profit.
Monthly MIS of Actuals with Plan, Capital Expenditure utilization.
Quarterly analysis of Quarterly, Half Yearly financial results with Industry competitors.
Assisting In monthly and quarterly planning of revenue and cost.
Preparation of key indices for measuring performance of units.
Analyzing and assisting in approvals of capital expenditure.
Prepare fixed and Variable cost analysis report and compare with plan.
Analyzing R&M and HLP cost of units.
Prepare foreign travel report quarterly.
Prepare consolidated Statutory Compliance report and check compliances of each unit.
Track record of vehicle insurance of company vehicle of the division.

Financial ReportingCapital Expenditure PlanningRevenue AnalysisFinancial AnalysisReporting and Analytics

Efleet systems pvt. ltd.

System Analyst

Jul 2018 – Sep 2019 · 1 yr 2 mos · Gurugram, Haryana, India · On-site

Performed analysis and design including investigations, documentation, recommendation, and problem-solving in firm
Wrote user requirements into technical specifications.
Trained executives in secure use of proprietary bank software.
Prepare process document/ prototype on MS Word/ Excel (New Development)
Software testing (New Development),
Client query/support (Software),
Logistic / Transport related system support to clients,
Reconciliation of Sales/Purchase reports,
Maintaining data on Google Sheets

DocumentationSoftware TestingClient Support