Hi There,
I'm Deepak Vemula

Experienced

Resume

About Me

I'm Deepak Kumar Vemula

Data Analyst | PL-300 Microsoft Certified: Power BI Data Analyst Associate

With over 4 years of expertise in Power BI, Tableau, and advanced Excel, I excel at creating and delivering dynamic dashboards that empower data-driven decision-making.


Proficient in Python, SQL, DAX, and SAP IBP, with extensive experience in automating workflows and developing predictive models for demand planning and forecasting.

Strong foundation in data modeling, ETL processes, and data warehouse design, with a keen ability to evaluate data sources for optimal data management and analysis.

Demonstrated success in collaborating with cross-functional teams to deliver tailored reporting solutions and actionable insights that address diverse business needs.

University (Graduated) : Saint Louis University ( SLU )

email : vemuladeepak1999@gmail.com

place : St. Louis, USA

Resume

My Education

SLU College Image

Master's in Computer Science

Saint Louis University (SLU)

2022-2024 | Graduated

Additional Education Image

Projects Made

Marketing and Sales Analytics for Caleres

Designed Power BI dashboards to monitor customer segmentation, sales performance, and marketing campaign effectiveness across Caleres-owned brands, including Famous Footwear, Naturalizer, Sam Edelman, Blowfish, Vionic, LifeStride, Dr. Scholl's, and Ryka

View Code

Navigating New York City’s Airbnb Landscape

Performed in-depth exploratory data analysis on a large Airbnb dataset to extract key insights on pricing trends, occupancy rates, and neighborhood popularity, helping optimize resource allocation.

View Code

A Comprehensive Analysis of U.S. Air Quality

Analyzed U.S. air pollution data from multiple sources, identifying regional pollutant trends over time, and correlating these with population density and industrial activity.

View Code
View All

Experience

Caleres Logo

Caleres

Data Analyst                                                      Sep 2024 - Present

- Worked in Data Analysis and Planning
- Designed and implemented interactive PowerBI dashboards to track sales, inventory, and operational KPIs, enhancing real-time decision-making and reducing stockouts by 15%.
- Utilized SAP IBP and Excel for predictive modeling, optimizing inventory levels and reducing holding costs by 18%, while increasing forecast accuracy for demand planning.

Sodexo Logo

Sodexo (Saint Louis University)

Inventory Management Analyst               Dec 2022 - May 2024

- Led cross-functional team efforts to implement an automated inventory management system, reducing stockouts and overstock situations by 20% through streamlined order forecasting and reordering protocols.
- Executed weekly inventory audits and reconciliations, using discrepancy trend analysis to reduce shrinkage by 10% through targeted corrective measures and employee training.

Capgemini Logo

Capgemini (Morgan Stanley Client)

Data Analyst                                                     March 2021 - Aug 2022

- Visualized healthcare and insurance data trends using Tableau, optimizing benefit packages based on claim frequency analysis, resulting in a 12% increase in client satisfaction.
- Conducted pattern recognition on healthcare and insurance datasets, using outlier detection and data cleansing techniques to improve data accuracy by 25%.

Deepak's Portfolio

Thank you for exploring my portfolio! Feel free to connect with me via email.

quick links

home about education Projects experience

contact info

vemuladeepak1999@gmail.com

St. Louis, USA

Designed with by Deepak Kumar Vemula Portfolio Image