Open to opportunities

Vanshika Gupta

@vanshikagupta5

Business analytics professional turning CRM data into KPI dashboards, revenue insights, and measurable process improvements.

India

Message

What I'm looking for

I’m looking for a business analytics role where I can turn CRM and KPI data into Power BI dashboards and MIS reporting, support UAT/validation, and collaborate with stakeholders to drive process improvements and revenue growth.

I’m an MBA (Business Analytics) candidate with experience in business requirement gathering, KPI reporting, dashboard development, CRM analytics, market research, and process improvement across IT, aviation, consulting, and marketing domains. In CRM analytics work, I analyze conversion rates and revenue KPIs and build weekly and monthly MIS dashboards for pipeline forecasting.

I’ve improved reporting efficiency by 15% and helped identify revenue opportunities worth 20+ lakh, while increasing lead conversion metrics by up to 12%. I document client requirements and coordinate with technical and marketing teams to keep CRM data accurate and reporting standards consistent.

I also bring a strong analytical and strategic mindset from competitor benchmarking and structured business reporting (including SWOT and revenue projections), plus Power BI dashboarding and UAT support. I enjoy turning messy data into clear stakeholder reporting that drives better decisions.

Experience

Work history, roles, and key accomplishments

Business Executive – CRM Analytics

JSR NetSol Pvt. Ltd.

Oct 2025 - Apr 2026 (6 months)

Analyzed 500+ monthly CRM records to track conversion and revenue KPIs and built weekly/monthly MIS dashboards for pipeline forecasting. Improved reporting accuracy and monitored B2B email metrics (open and conversion rates) while maintaining CRM data standards.

CRM Analytics KPI Tracking Power BI Advanced Excel Data Quality Management Revenue Metrics

Management Trainee – Business Strategy

MachanX

May 2025 - Jun 2025 (1 month)

Conducted competitor benchmarking across 15+ industry players and identified a revenue expansion opportunity worth 20+ lakh through gap analysis. Produced structured business reports (SWOT and revenue projections) and recommended operational improvements based on process evaluation.

Competitive Benchmarking Gap Analysis SWOT Revenue Projection Market Research Business Reporting Business Process Improvement Data Analysis

Business Analytics Intern

GMR Airport Limited

May 2024 - Oct 2024 (5 months)

Cleaned and validated 10,000+ operational records to improve reporting accuracy and built 5+ Power BI dashboards for passenger flow and revenue KPIs. Reduced reporting turnaround time by 15% and supported UAT testing and cross-department data validation.

Data Cleaning Power BI Dashboard Development KPI Tracking Data Validation UAT Support Passenger Analytics Revenue Analytics

Marketing Intern

Padamshree Infotech

Aug 2022 - Sep 2022 (1 month)

Analyzed campaign performance data and customer segments to improve lead generation outcomes. Increased lead generation efficiency by 12% through data-driven marketing optimization.

Marketing Analytics Customer Segmentation Data Analysis

HR & General Management Intern

Infovirtech Pvt. Ltd.

Jun 2022 - Aug 2022 (2 months)

Prepared HR performance reports and maintained workforce tracking sheets to support internal reporting needs. Supported documentation and reporting processes to improve data organization and access.

HR Reporting Spreadsheet Management Documentation

Sales & Market Research Intern

Homeflic Wegrow

Sep 2021 - Dec 2021 (3 months)

Performed customer data analysis to identify untapped market segments and inform outreach strategy. Improved outreach conversion rate by 10% by targeting priority segments more effectively.

Data Analysis Market Segmentation Strategic Outreach Lead Qualification Market Research