Name: Megha Prasad

Experience: 6 Years 3 Months

Address: Pune, India

Skills

SQL 65%
POWER BI 85%
TABLEAU 70%
EXCEL 70%
Power Point 80%

About

About Me

Highly motivated and experienced Coordinator and former Financial Analyst with 6 years of dedicated service at UPS Logistics. Proficient in data analysis, reporting, customer behaviour analysis, & data cleaning. Demonstrated success in creating impactful project reports. Proven track record in analytical problem-solving and enhancing team accountability.

  • Profile: Business Analyst & Power BI Developer
  • Domain: Retail, Ecommerce, Logistics & Human Resource
  • Education: MBA & BCA
  • Language: English, Hindi
  • BI Tools: Microsoft Power BI & Tableau
  • Other Skills: SQL, Excel, Power Point & Git
  • Interest: Canva

0 +   Projects completed

LinkedIn

Resume

Resume

Highly motivated and experienced Coordinator and former Financial Analyst with 6 years of dedicated service at UPS Logistics. Demonstrated expertise in data analysis, data models, and handling large data sets. Proficient in SQL and expertise in utilizing data visualization tools such as MS Excel, Power BI, PowerPoint, and Tableau to create comprehensive reports and visualizations. Recognized for facilitating seamless collaboration among departments and external clients, leading discrepancy resolution, and driving process improvements.

Experience


2018-2023

Coordinator

UPS (United Parcel Services) Logistics, Pune

Grade 8

  • Proficient in report creation, reporting, and task allocation.
  • Maintained end-to-end communication with the client, involved in reporting within TAT (Turnaround Time).
  • Gathered data using the company's QWS application and performed transformation and loading using Excel and Power BI.
  • Created clear and compelling data visualizations to communicate insights effectively using DAX.

2017-2018

Financial Senior Admin Assistant

UPS (United Parcel Services) Logistics, Pune

Grade 7

  • Performed Audits.
  • Strong process knowledge and support to Project transition.
  • Conducted training and presentations.
  • Interpreting and analyzing financial information available in Revenue Data.



Education


2013-2015

Masters of Business Administration

DAIMSR College (RTMNU), Nagpur (Maharashtra)

Grade: First class distinction.

2010-2013

Bachelor of Computer Applications

St Aloysius College (RDVV), Jabalpur (M.P.)

Grade: First class distinction.

Projects

Projects

Below are the sample Data Analytics projects on SQL & Power BI

Dynamic Budget Dashboard

Budget Analysis dashboard displaying key metrics such as Budget, Revenue, Transactions, and Qty Sold, enhanced by dynamic tooltips for detailed insights.

Last Mile Dashboard Using Power BI

Last Mile Dashboard in Power BI is designed to provide real-time insights and performance metrics on the last-mile delivery phase within logistics and supply chain operations..

Music Data Analysis Using SQL

Analyzed music store data using advanced SQL queires to identify gaps and increase the business growth.

Technical Support Dashboard Using Power BI

Analyzing technical support involves evaluating service delivery, ticketing systems, staff skills, customer satisfaction, escalation procedures, proactive maintenance, and cost-effectiveness to enhance operational efficiency.

Churn Analysis Using Power BI

Dashboard for the retention manager reflecting the KPIs.

Logistics Dashboard Using Power BI

Dashboard to monitor shipments across two different cut-off periods, while also tracking any pending backdated shipments.

Employee-Onboarding-Dashboard Using Excel.

An Employee Onboarding Dashboard providing a visual overview of key metrics and processes related to new hires, tracking their progress through orientation, training, and integration into the company.

Covid-19 Analysis Using Power BI

COVID-19 Daily Cases dashboard providing information on the daily reported COVID-19 cases, including confirmed cases, deaths, recoveries, and testing data.

Learn Joins in SQL

Create two tables and apply joins using SQL.

Last Mile Dashboard

A Last Mile Dashboard in Power BI is designed to provide real-time insights and performance metrics on the last-mile delivery phase within logistics and supply chain operations. This dashboard focuses on the final leg of the delivery process, which directly affects customer satisfaction and efficiency.

Latest Project

Watch My Latest Project

AWARDS

AWARDS

Below are the recognitions I received from my last organization, UPS Logistics:

Imminent Creators Award

Received on UPS Founders' Day for sharing insights on team performance improvements.

Appreciation For Accountability

For always being willing to go beyond the shift hours.

Appreciation For Planning And Organizing

Received appreciation for exceptional planning and organizing as a multitask performer.


Appreciation For Team Work

Received appreciation for effectively supporting other sub-processes with the knowledge gained.

Horizon Awards and Spark Of Brilliance Awards

Awarded multiple times for achieving the team's goals.

0 Achievements
0 Projects
0 Internships
0 Cups of Tea per day

More projects on Github

I love to solve business problems & uncover hidden data stories


GitHub

Contact

Contact Me

Below are the details to reach out to me!

Address

Pune, India

Contact Number

+91 9665014002

Email Address

meghapd007@gmail.com

Resume

resumelink



Have a Question? Click Here



Copyright © All rights reserved | This template is made with by Colorlib