Hairav Kumar

Business Analyst

Noida, Uttar Pradesh, India2 yrs 10 mos experience

Key Highlights

Expert in transforming raw data into actionable insights.
Proficient in SQL, Power BI, and Advanced Excel.
Automated reporting processes, reducing time by 20%.

Stackforce AI infers this person is a Data Analyst with expertise in Fintech and data-driven decision-making.

Contact

hairavkumar34@gmail.com LinkedIn

Skills

Core Skills

Data AnalysisSqlData Visualization

Other Skills

Microsoft Power BIPython (Programming Language)Data ValidationPythonPower BIAdvanced ExcelOracle SQL DeveloperSales AnalysisPower queryPowerPivotDashboardsPandasNumPyMatplotlibSeaborn

About

Data Analyst with hands-on experience in transforming raw data into powerful insights using Advanced Excel, SQL, Power BI, and Python. I specialize in data cleaning, modeling, visualization, and have a strong command over ETL processes, Power Query, and DAX to deliver optimized, performance-driven solutions. With a focus on data accuracy and integrity, I enjoy turning complex datasets into actionable dashboards and reports that drive business growth. Whether it’s analyzing trends, identifying opportunities, or solving analytical challenges — I thrive on using data to tell stories and support smarter decisions. Keep learning — because in the world of data, curiosity is the most powerful tool. Let’s connect and talk data!

Experience

Shivalik small finance bank

Data Analyst

May 2025 – Present · 10 mos · Noida, Uttar Pradesh, India · On-site

Led end-to-end financial and operational data analysis using advanced SQL on Oracle databases to support MIS, regulatory, and management reporting.
Designed and optimized complex SQL queries and data validation frameworks to ensure accuracy, consistency, and compliance with banking standards.
Analyzed financial and operational datasets as per RBI regulatory guidelines and prepared compliance-ready reports for submission to regulatory and internal management teams.
Automated recurring reports using Python and performed data cleaning and transformation, resulting in a 20% reduction in manual reporting time.
Built and maintained interactive Power BI dashboards for real-time KPI tracking, improving data visibility and decision-making speed by 25%.
Collaborated with IT, Risk, BI, and Operations teams to deliver data-driven insights and resolved production data issues through root-cause analysis, reducing data discrepancies by 15%.

Microsoft Power BIPython (Programming Language)SQLData Analysis

Mentortca technology pvt ltd

Data Analyst

Jul 2024 – Jan 2025 · 6 mos · Noida, Uttar Pradesh, India · On-site

Utilized Advanced Excel (VLOOKUP, INDEX-MATCH, Pivot Tables, Conditional Formatting) for data cleaning, organization, and trend analysis to support decision-making.
Built interactive Power BI dashboards to visualize KPIs, sales trends, and customer segmentation, improving data accessibility and reporting efficiency by 20%.
Developed complex SQL queries with joins, aggregations, and window functions to analyze large datasets, improving query performance and reducing data retrieval time by 20%.

Microsoft Power BISQLAdvanced ExcelData AnalysisData Visualization

Intellectt inc

Associate

Jun 2022 – Jun 2024 · 2 yrs · Noida, Uttar Pradesh, India

Analyze recruitment trends, including hiring sources, applicant conversion rates, and rejection reasons.
Maintain and update candidate information in Excel sheets and recruitment systems.
Use Excel tools (pivot tables, VLOOKUP, filters) to manage and analyze large datasets of candidates.
Analyze and report on offer declines to improve strategies.
Report findings using Excel charts, graphs, and summary insights.
Created and sustained regular reports, dynamic dashboards, and key performance indicators (KPIs) to monitor and drive business performance.