Data Analyst Power Bi

RAHUL PAWAR

SUMMARY

A data-driven professional with 2.6 Year of experience in data management, ETL

development, big data processing, and analytics. Currently working as a Data Analyst at Bajaj Finserv, driving business insights and strategy using Azure, Databricks, ADF, SQL, Power BI, and Python. Skilled in building scalable pipelines, automating reporting systems, and optimizing performance. Microsoft-certified Azure Data Engineer with strong statistical and analytical foundations.

WORK EXPERIENCE

Designed and optimized ETL pipelines using Azure Data Factory, Databricks, and PySpark. Automated data processing with custom SQL and Python scripts, enhancing efficiency by 40%.

Analyzed B2B and B2C market data from urban and rural regions to support strategic decision-making.

Built and monitored Power BI dashboards to ensure accurate rate of interest calculations. Handled error logging, SQL query tuning, and workflow scheduling in Databricks. Collaborated in Agile sprints; tracked progress in Jira and worked closely with cross- functional teams.

Data Analyst

Innovsource Services Pvt Ltd (Deputed at Bajaj Finserv) Jan 2024 – Present Data Support Analyst

Teamlease Services Pvt Ltd (Deputed at Bajaj Finserv) Mar 2023 – Dec 2023 Extracted and processed large datasets using Databricks SQL, Python, and Excel. Debugged and maintained SQL queries in production pipelines. Developed FOS Productivity MIS reports and managed performance metrics. Created insurance quotes (TAGIC, AIG, ICICI Lombard) based on customer requests. Improved Spark job performance by tuning clusters and monitoring resources. Conducted data validation and shared actionable insights with stakeholders. SKILLS

Languages: SQL, Python, PySpark

Tools & Technologies: Azure Data Factory, Azure Databricks, Power BI, MS SQL Server, Advanced Excel, VBA

Libraries: Pandas, NumPy, Scikit-learn, Statsmodels Cloud Platforms: Microsoft Azure, Salesforce

OS: Windows, Linux

Methodologies: Agile, Scrum, Jira

Interests: Data Engineering, Cloud Computing, Financial Analytics

Pune, MH ************@*****.*** +91-965******* LinkedIn:https://www.linkedin.com/in/rahul-pawar-b10530201

️ Date of Birth: 03/07/1998

CERTIFICATIONS

DP-203: Azure Data Engineer – Microsoft

SQL Certification – Quickes Infotech Pvt Ltd

Python Certification – Udemy

Microsoft Power BI Certification – Udemy

EDUCATION

Bachelor of Science in Statistics

North Maharashtra University

Specialization: Statistics

SSC & HSC in Science

Nashik Board

SSC (2014): 69.80%

HSC (2016): 73.08%

CORE COMPETENCIES

Solved complex statistical problems and provided step-by-step solutions. Helped students understand key concepts in data analytics and statistical modeling. Applied real-world knowledge in probability, regression, and hypothesis testing. Subject Matter Expert (Freelancer)

Chegg India Oct 2021 - Jun 2023

PROJECT

Market share and Financial Modelling

Developed a data pipeline using Spark and SQL to integrate internal sales data with third-party web traffic and market data APIs.

Build predictive models using libraries like pandas, numpy, scikit-learn, and statsmodels. Develop and run large-scale data processing tasks to handle large datasets, perform feature engineering, and model training.

Schedule and orchestrate data pipelines to automate the process of data extraction, model training, and model validation.

Designed and built scalable ETL pipelines using SQL and Python to automate daily and monthly financial data aggregation from internal databases, and Excel sources. Integrated multiple data sources (loans, insurance, investments) into a centralized reporting layer, ensuring data consistency and reducing reconciliation time by 60%. Implemented data validation and exception handling logic to ensure data accuracy before report generation, reducing manual errors by 90%.

Automated Financial Reporting Pipeline

Financial Data Analysis & MIS Reporting

Big Data Processing & ETL Automation

SQL Optimization & Data Validation

Dashboard Design with Power BI

Agile Methodology & Cross-functional Collaboration Statistical Analysis & Data Modeling

Contact this candidate