Prasanjeet Singh Digwa
- |-| www.linkedin.com/in/prasanjeet-singh-digwa
SKILLS:
Excel, SQL, Python, Power Bi, Data Analysis, Statistical analysis, Problem Solving, Data Manipulation, Data Visualization, Business Sense, Process improvement,
Cost-benefit analysis.
ACADEMICS:
PGDM in Marketing and Information Technology (Asian Business School, Noida)
2018-20
Bachelors in science (Gurukul Kangri Vishwavidyalaya, Haridwar)
2015-18
PROJECTS:
Freshco Hypermarket Capstone Project
Situation: Project was the part of Skillovilla learning which is evaluated project and to check the learning of fundamentals.
Task: Need to analyze the data using excel advance functions on different level analysis.
Action: Analyzed the data using advance excel function based on customer order data on various levels
Result: Estimated the factors responsible for frequency of orders, delay in delivery of orders and highest order area in city.
-
Capstone Project Airline DB
Situation: Project was the part of Skillovilla learning which is evaluated project and to check the learning of fundamentals.
Task: SQL queries to solve complex database problems
Action: Solve SQL complex queries based on database set given in project and assured 100% accuracy.
Result:
Write the SQL complex queries using given database using aggregation, joins, window functions and scored 100%
-
ShopNest Power BI Capstone Project
Situation: Project was the part of Skillovilla learning which is evaluated project and to check the learning of fundamentals.
Task: Power BI dashboard to visualize the store data sales year wise and ratings of product.
Action: Designed interactive dashboards using various features of Power BI and building relationships between table.
Result: Analyze the data using relationship between tables and visualize the data using power bi dynamic dashboard.
WORK EXPERIENCE:
MetLife Inc. (July 2022 - Present): Program & Project Management Specialist
-
Situation: Served as a Project management & analytics supporting MetLife's digital transformation initiatives and quarterly Oracle system upgrades, focusing on
data analysis and visualization to drive project success.
-
Task:
Excel: Developed comprehensive reporting solutions using advanced Excel functions, PivotTables, and Power Query to track project metrics and analyze
system performance data
SQL: Extracted and transformed complex datasets from Oracle databases to support testing validation and identify process optimization opportunities
Power BI: Created interactive dashboards with DAX functions to visualize release management KPIs and provide actionable insights to stakeholders
-
Action:
Analyzed historical release data to identify bottlenecks and optimization opportunities, leading to a 30% reduction in deployment time
Designed and implemented measurement frameworks to quantify testing efficiency, resulting in data -driven improvements that reduced testing by 35%
Developed automated reporting solutions that tracked release readiness metrics across multiple system components
Performed trend analysis on system performance data to validate the impact of quarterly Oracle updates
-
Result:
Established data visualization tools that improved stakeholder visibility into project status and resource utilization
Created analytical models that increased test coverage by 20% while optimizing testing resources
Transformed raw system data into meaningful insights that guided process standardization efforts
Supported 8 successful Oracle releases with comprehensive data analysis for risk assessment and mitigation
-
Infinizi Consulting Pvt Ltd. (May 2021 – June 2022): Business Operations Associate
Situation: Joined Infinizi during a critical phase when the company was expanding its EdTech client portfolio but experiencing challenges with project completion
tracking and client communication.
Task: Assigned to develop and implement a systematic approach for following up on EdTech project completion, ensuring timely delivery, and maintaining client
satisfaction throughout the project lifecycle.
Action: Created a comprehensive project tracking system specifically for EdTech clients
Established regular check-in protocols with freelancers to monitor progress and identify potential delays
Result: Improved on-time project delivery rate from 65% to 92% for EdTech clients
Reduced client escalations by 40% through proactive communication
Increased client satisfaction scores for project management by 25%
Patanjali Ayurved Limited (May 2020 – April 2021): Executive Assistant
Situation: Joined Patanjali during a period of rapid company growth and expanding product lines, when customer inquiries had increased by 40% while satisfaction
scores were declining.
Task: Assigned to improve customer response times, increase customer satisfaction ratings, and develop a more efficient system for handling customer feedback
Action:
Analyzed existing customer service processes to identify bottlenecks and areas for improvement
Effectively resolve customer grievances regarding product issues, implementing systematic approaches to address complaints pr omptly.
Result: Reduced average customer response time from 48 hours to 12 hours
Improved customer satisfaction ratings by 28% within 6 months
ACHIEVEMENTS:
Process Improvements:
Problem- Manual work allocation was there which has the high chances of error and time consuming.
Action- Implemented cost-saving automation using Power Query for work allocation.
Result- Resulting in annual savings of $190 USD.
-
