Ripulkumar Prajapati

Data Analyst | Project Specialist

Mumbai, India 12+ yrs exp 92 · Outstanding

About

Data Analyst and Project Specialist with 12+ years in telecommunications and technology, delivering data-driven insights and automation for enterprise clients including Cisco Systems, Reliance Jio, Nokia, and Vodafone Idea. Skilled in Power BI, Advanced Excel, SQL, and Python scripting to convert raw operational data into dashboards and workflows that cut manual processing time by up to 20% and improve reporting accuracy. Proven track record in reverse logistics, telecom infrastructure coordination, and financial reconciliation.

Skills & Expertise (12)

Advanced Excel Advanced

8.0/10

Years Exp

Pivot Tables Advanced

8.0/10

Years Exp

Project Coordination Advanced

8.0/10

Years Exp

Power BI Advanced

7.8/10

Years Exp

Dashboard Design Advanced

7.5/10

Years Exp

VLOOKUP Advanced

7.5/10

Years Exp

Power Query Advanced

7.5/10

Years Exp

VBA Advanced

7.5/10

Years Exp

Macros Advanced

7.5/10

Years Exp

XLOOKUP Intermediate

7.0/10

Years Exp

Vendor Management Intermediate

7.0/10

Years Exp

MySql Intermediate

6.5/10

Years Exp

Work Experience

Project Specialist

Aerial Telecom Solutions Pvt. Ltd.

Feb 2023 - Present

Streamlined reverse logistics operations by cleaning and validating multi-regional data streams, cutting reporting anomalies and improving data integrity across teams. Designed interactive Excel dashboards using COUNTIFS, Pivot Tables, and Conditional Formatting to deliver real-time progress metrics to leadership. Built custom Python scripts to automatically extract, merge, and compile data from multiple email-sourced Excel files, reducing weekly processing time by 20%. Developed Excel VBA macros for routine data sanitization, cutting weekly processing time by 15% and eliminating manual data-entry errors.

Project Coordinator

TeamLease Digital Pvt. Ltd.

Oct 2017 - Feb 2023

Managed and distributed daily high-priority progress reports to track critical project-lifecycle milestones. Reconciled end-to-end Purchase Order (PO) allocations against actual work completion, identifying and resolving billing discrepancies. Directed monthly hardware utilization audits and stock reconciliation cycles, maintaining warehouse inventory accuracy. Partnered with Finance and Integration & Commissioning (I&C) teams to verify vendor deliverables prior to releasing partner payments. Consolidated disparate multi-partner datasets into unified analytical frameworks using Power Query.

Project Coordinator

Vedang Cellular Services Pvt. Ltd.

Aug 2015 - Oct 2017

Managed end-to-end site planning, sequencing, and coordination for cellular infrastructure installation and network integration. Partnered with field engineers to troubleshoot and resolve critical on-site technical blockers. Owned project status presentations for Senior Management, proactively flagging milestone variations and mitigation plans. Collaborated with Quality Engineers to enforce site-readiness standards ahead of final integration.

Project Engineer

Vedang Cellular Services Pvt. Ltd.

Mar 2014 - Aug 2015

Executed Ready for Installation (RFI) surveys across GBM, GBT, RTP, and RTD site classifications. Assessed site feasibility and determined optimal equipment installation locations to meet technical requirements. Identified network azimuth blockages and drafted technical escalation briefs for the RF optimization team, accelerating resolution. Supervised and scheduled field survey crews against structured specs and timelines to enforce data-collection standards.