Prashant Kumar
Senior Data Analytics
Bangalore
Summary
Data Analytics professional with 9 years of proven experience in transforming data into meaningful business insights. Known for collaborative approach and focus on achieving impactful results. Proficient in Power BI, Power Query, Python, SQL, and Excel, with expertise in building scalable dashboards, ETL pipelines, and ML-based forecasting models. Dependable and adaptable, skilled in data modeling, predictive analytics, and stakeholder communication.
Overview
9
9
years of professional experience
2
2
Certifications
1
1
Language
Work History
Senior, Data Analytics
Jacobs Solutions India Pvt. Ltd.
10.2020 - Current
- Developed and maintained Power BI dashboards for strategic infrastructure portfolios including NEOM OXAGON, Middle East Delivery, and India’s NICDC, enabling real-time tracking of KPIs, cost trends, and financial metrics.
- Leveraged Power Query and Power BI Dataflows to automate data ingestion and transformation.
- Applied Python (Pandas, NumPy, Matplotlib) for advanced analytics and built ML-based forecasting models to enhance cost and schedule predictability.
- Engineered scalable ETL pipelines using SQL and Oracle, improving reporting accuracy and operational efficiency.
- Migrated legacy systems from Prolog to Kahua, streamlining cost workflows and improving data integrity.
- Built EVM analytics solutions to monitor funding, budgets, and expenses across infrastructure projects.
- Automated cost reporting using Excel VBA, reducing turnaround time by 50%.
- Conducted invoice analysis for BART Projects, saving $4M through strategic claims avoidance.
- Domain: Data Analytics
Project Lead
OYO Hotels & Homes Pvt. Ltd.
08.2017 - 09.2020
- Created financial dashboards and reporting systems to monitor budgets, vendor rates, and project schedules.
- Led data-driven vendor negotiations and market rate analysis, reducing operational costs by 15%.
- Utilized analytics to optimize inventory levels and resource utilization.
- Built reporting pipelines for India Projects team, translating raw data into actionable insights.
- Maintained tactical control of project budgets and timelines, achieving schedule targets.
- Domain: Data Analytics
Project Planning Coordinator
Artefact Projects Ltd.
04.2016 - 07.2017
- Analyzed structural and architectural drawings to generate accurate cost estimates and BOQs for highway projects.
- Delivered MIS reports and bid proposals using data-driven insights, securing client approvals and optimizing project planning.
- Led planning and cost estimation for 400+ km of highways worth ₹1800 Cr, applying WBS and Activity-Based Costing (ABC) methods.
- Created activity schedules for DPR, IE, AE, and O&M tenders using MS Projects & Primavera P6, demonstrating strong planning and analytical skills.
- Domain: Data Analytics
Education
PG - Data Science and Business Analytics
01-2023
MBA - Advanced Construction Management
03-2016
GPA: 8.63
B.Tech - Civil Engineering
05-2014
GPA: 8.31
Skills
Data Analytics & Visualization: Power BI, Power BI Dataflow, Tableau, Power Query, DAX, Excel, VBA
Data Integration & ETL: SQL, Oracle, Power Query
Programming & Scripting: Python (Pandas, NumPy, Matplotlib, Scikit-learn)
AI & Machine Learning: Forecasting Models, Predictive Analytics, ML Pipelines, Azure ML Studio
Project Controls & Cost Management: Cost Reporting, Financial Modeling, Budget Forecasting, EVM
Tools & Platforms: Power App, Power Automate, Azure, Kahua, Prolog, SharePoint
Certification
PL-300 Microsoft Power BI Data Analyst Associate – Microsoft, 2025
Timeline
Senior, Data Analytics - Jacobs Solutions India Pvt. Ltd.
10.2020 - Current
Project Lead - OYO Hotels & Homes Pvt. Ltd.
08.2017 - 09.2020
Project Planning Coordinator - Artefact Projects Ltd.
04.2016 - 07.2017
University of Texas – Great Lakes - PG, Data Science and Business Analytics
NICMAR - MBA, Advanced Construction Management
BCET, WBUT - B.Tech, Civil Engineering