PALLAVI BHAN
Data Analyst/ Business Analyst
Najafgarh
Summary
Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data.
Overview
2
2
years of professional experience
Work History
Business Analyst
Girnarsoft(Car-Dekho)
10.2023 - Current
- Analyzed direct marketing campaigns to uncover substantial insights, focusing on critical KPIs and campaign affecting factors
- Managed NCD(New-Car-Dealer) business, CPS (Cost-per-sale) business by maximizing the revenue target up to 35 lakh using SQL and ETL tools (Matillion) to identify discrepancies and anomalies to ensure accurate billing and around 50% revenue gain
- Collaborated with cross-functional teams: Investigated revenue leakage and implemented corrective actions through ETL processes, resulting in a 15% reduction in revenue losses
- Conducted data analysis with SQL: for New-Auto Dealer health check by API health checks which led to improvements 30% improved lead flow
- Developed interactive dashboards and reports using Power BI: Visualized key metrics and insights for stakeholders, integrating data
- Provided quality assurance of imported data: Worked with quality assurance analysts to ensure data quality improvement up to 50%
- Developed and implemented data-driven approach to marketing strategy, resulting in 20% increase in customer engagement.
Data Analyst Trainee
ETechnology Solutions
08.2022 - 09.2023
- Conducted comprehensive demographic profiling of the bank's clients, analyzing variations across different districts to identify key customer segments hence improved the matrix around 23%
- Evaluated the bank's major expenses, proposing cost-reduction strategies to enhance profitability by about 15%
- Analyzed the usage and profitability of various types of accounts, identifying the most common account types and their financial impact.
Education
Bachelor of Technology [B. tech] [Computer Science Engineering] -
Maharishi Dayanand University
Higher Secondary School - undefined
Rao Man Singh Senior Secondary Public School
Skills
Snowflake
SQL Proficiency
Requirements Gathering
Project Management
Stakeholder Management
Gap analysis
Microsoft Excel Mastery
Internal Auditing
Business process improvement
Power Bi
Python (Pandas, NumPy, Seaborn, Matplotlib)
AWS
Data Visualizations
Exploratory Data Analysis
Good Listener & Communicator
Team Building & Interpersonal Skills
Analytical Problem Solving
Accomplishments
Cleared various government examinations like SBI Clerical, RRB Rural banks at preliminary stages
Knowledgepurview
- Business Intelligence / Data Analysis
- Data Governance/ Modeling
- Stake holder Communication
- Campaign Performance Tracking
- Data Migration
- Data visualization (Power BI)
Toolssoftware
- Power BI
- Git
- Visual Studio
- MySQL Workbench
- Excel
Cloudtechnologies
- Snowflake
- AWS (EC2, S3)
- Matillion
Profiles
Data Analyst/ Business Analyst, Dynamic and results-driven Business Analyst with experience in analyzing business processes, identifying opportunities for improvement, and implementing strategic solutions to drive efficiency and profitability. Proficient in gathering and interpreting complex data sets, conducting comprehensive market research, and collaborating with cross-functional teams to achieve organizational goals. Experience in Dashboarding stories using Power BI.
Timeline
Business Analyst
Girnarsoft(Car-Dekho)
10.2023 - Current
Data Analyst Trainee
ETechnology Solutions
08.2022 - 09.2023
Bachelor of Technology [B. tech] [Computer Science Engineering] -
Maharishi Dayanand University
Higher Secondary School - undefined
Rao Man Singh Senior Secondary Public School