Advanced excel & VBA Micro
Taranjeet Singh
Data Analysist
New Delhi
Summary
Dynamic professional with expertise in data analysis and business reporting, leveraging advanced Excel and SQL skills to drive strategic insights at Shubham Housing Development Finance Company Ltd. Proven track record in stakeholder coordination and process improvement, enhancing sales productivity and achieving targets. Recognized for identifying growth opportunities and mitigating risks through data-driven decision-making.
Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.
Overview
9
9
years of professional experience
Work History
Business Planning & Support
Shubham Housing Development Finance Company Ltd.
02.2025 - Current
- Prepared MIS dashboards, performance reports, projections, and variance analysis for senior leadership and COO decision-making
- Tracked and analyzed branch-wise and region-wise KPIs including logins, sanctions, disbursements, AUM, conversion ratios, productivity, TAT, and quality metrics
- Designed and monitored sales target frameworks for 3,000+ sales team members, aligned with company growth objectives
- Analyzed sales productivity, conversion trends, and performance gaps to enable realistic and achievable target allocation
- Supported annual, quarterly, and monthly business planning through top-down and bottom-up target setting for offline centers
- Monitored performance vs targets, identified gaps, deviations, and risks, and drove timely corrective actions
- Coordinated cross-functionally with Sales, Finance, Operations, HR, and SCM to ensure smooth execution of business plan
- Led stakeholder communication, including performance updates, escalations, milestone tracking
- Identified growth opportunities and risk areas through data-driven insights and trend analysis
Data Analyst
Airtel Payments Bank
12.2018 - 02.2025
- Used statistical methods to analyze data and generate useful business reports.
- Improved decision-making processes with accurate data analysis and visualization techniques.
- Utilized data visualization tools to effectively communicate business insights.
- Developed daily, weekly, and monthly MIS dashboards for senior management.
- Prepared promoter attendance and performance trackers for GTM managers.
- Generated monthly partner commission reports with high accuracy.
- Coordinated with onboarding teams and cross-functional stakeholders.
MIS Coordinator
Creative Hitech Private Limited
02.2017 - 12.2018
- Prepared production, dispatch, and sales performance reports.
- Conducted employee productivity and sales efficiency analysis.
- Analyzed e-commerce vs in-store sales performance.
Education
Bachelor of Commerce (B.Com) - Financial Accounting, Business Laws Among Others.
Indira Gandhi National Open University
New Delhi, India 04.2001 -
Senior Secondary (12th – Commerce) -
National Institute of Open Schooling (NIOS)
New Delhi, India 04.2001 -
Skills
Advanced Excel (Pivot Tables, Power Query, Dashboards VBA and Micros)
SQL (Joins, Queries, Data Extraction )
Data Analysis, Business Reporting & Automation
Sales & Operations Analytics
Process Improvement
Stakeholder Coordination
MS Office Suite
Software
Structured query language (SQL)
Power BI
Timeline
Business Planning & Support
Shubham Housing Development Finance Company Ltd.
02.2025 - Current
Data Analyst
Airtel Payments Bank
12.2018 - 02.2025
MIS Coordinator
Creative Hitech Private Limited
02.2017 - 12.2018
Bachelor of Commerce (B.Com) - Financial Accounting, Business Laws Among Others.
Indira Gandhi National Open University
04.2001 -
Senior Secondary (12th – Commerce) -
National Institute of Open Schooling (NIOS)
04.2001 -