Utkarsh
Mumbai
Summary
Insightful professional in the realm of business intelligence, known for unparalleled productivity and efficiency in task completion. Specialize in data warehousing, predictive analytics, and visualization techniques. Excel in critical thinking, problem-solving, and effective communication, ensuring clarity and actionable insights in complex scenarios.
Overview
5
5
years of professional experience
Work History
Assistant Manager - Data Analytics
Adani Realty
Mumbai
05.2024 - Current
- Generated BI reports detailing metrics for Sales, Collections, Construction, Debt, and Interest for CEO.
- Developed predictive model from call center data, achieving 80% accuracy in lead conversion forecasting with Python.
- Designed a channel partner scoring system using RFM modeling to evaluate performance and implement incentives with Python and Excel.
- Established approval system architecture to capture project schedule changes and obtain approvals from business heads using Power Automate.
- Created >10 ad-hoc BI reports for budgeting, estimation, legal, sales, and marketing teams, integrating BI with Salesforce, MSP, and SharePoint.
Data Service Analyst Intern
Philips
Chennai
04.2023 - 08.2023
- Developed end-to-end data engineering pipeline for transferring procurement data from SharePoint to Databricks.
- Analyzed purchase order documents, identifying duplicates valued at 500K euros for payment reversals using Excel.
- created a BI report for German based warehouse for monitoring the SKUs on a daily basis capturing inflow and outflow data.
Firmware Develope
Secure Meters Pvt. Ltd
Udaipur
07.2020 - 06.2022
- Analyzed meteorological data from energy meters at nine sites in Udaipur and Delhi, NCR, to develop logic for effective DG detection.
- Generated interactive Excel summary reports for Team Lead and Product Line Manager to monitor weekly progress of DG detection logic.
Education
MBA - Big Data Analytics
Goa Institute of Management
Goa, India04-2024
B. Tech - Electronics And Communications Engineering
DIT University
Dehradun, India05-2020
HSC - Science
City Montessori School
Lucknow, India05-2016
Skills
- Predictive modeling
- RFM analysis
- Business intelligence
- Data integration
- Data cleaning
- Natural language processing
- MS Excel
- Performance metrics
- Predictive analytics
- Data visualization
- Report generation
- Power BI
Affiliations
- Placement Coordinator, responsible for placing a batch of 116 BDA students for the 22-24 batch
Languages
Hindi
First Language
English
Proficient (C2)
C2
Timeline
Assistant Manager - Data Analytics
Adani Realty
05.2024 - Current
Data Service Analyst Intern
Philips
04.2023 - 08.2023
Firmware Develope
Secure Meters Pvt. Ltd
07.2020 - 06.2022
MBA - Big Data Analytics
Goa Institute of Management
B. Tech - Electronics And Communications Engineering
DIT University
HSC - Science
City Montessori School
Similar Profiles
Satish KumarSatish Kumar
MEP Manager at Adani RealtyMEP Manager at Adani Realty
Nilesh SoniNilesh Soni
Head IR & ER (CoE) at ADANI REALTYHead IR & ER (CoE) at ADANI REALTY
Lamak BohariLamak Bohari
Associate Officer, Accounts at Adani realtyAssociate Officer, Accounts at Adani realty