Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Generic

PRAGATHI PATHI

Chicago,IL

Summary

  • Leveraged data analytics, business intelligence, and project management to drive operational excellence, achieving a 15% improvement in reporting accuracy and a 10% reduction in operational costs.
  • Proficient in Salesforce, SQL, Tableau, Python, and Microsoft Excel for data analysis and visualization, resulting in a 20% increase in process efficiency.
  • Facilitated communication between cross-functional teams, ensuring alignment and successful project delivery, contributing to a 25% increase in project approval rates.
  • Developed and maintained interactive dashboards and reports, reducing report generation time by 30% and enhancing decision-making capabilities.
  • Utilized lean models and Six Sigma methodologies for inventory management, leading to improved efficiency and cost savings.
  • Implemented ERP solutions and integrated third-party APIs, enhancing supply chain efficiency and system interoperability by 25%.
  • Participated in agile project management approaches, increasing project delivery speed and efficiency by 40%.
  • Conducted impact studies and risk assessments for proposed IT solutions, mitigating potential risks and enhancing project success rates by 20%.

Overview

4
4
years of professional experience

Work History

Business Analyst

USAA
Texas City, TX
01.2024 - 06.2024

Utilized SQL and Salesforce to analyze sales data and customer trends, providing insights for strategic decision-making and operational efficiency improvements
Utilized lean model and Sig sigma for Inventory Management
Developed ERP solutions, including integration of third-party APIs for mobile ordering and payment systems, enhancing supply chain efficiency
- Conducted detailed analysis of business processes and performance metrics, identifying trends and patterns that led to a 20% increase in operational efficiency.
Developed and maintained comprehensive reports and dashboards using Excel, Power BI, and Tableau, resulting in a 15% improvement in reporting accuracy.
Standardized data collection methods that improved data consistency by 25%, enabling more reliable decision-making.
Implemented process enhancements that reduced operational costs by 10% within the first 3 months.
Successfully led a project that increased process efficiency by 20%, utilizing advanced data analysis and visualization techniques.
Collaborated with IT, Marketing, and Operations teams to gather requirements and translate them into actionable project plans, contributing to a 25% increase in project approval rates.
Facilitated workshops and meetings to align project objectives, ensuring all stakeholders were informed and engaged, which improved stakeholder satisfaction by 30%.
Monitored project progress using project management tools, ensuring milestones were met and risks were mitigated effectively, achieving a 95% project success rate.
Created and presented detailed business cases, reports, and presentations to senior management, which resulted in a 20% increase in the adoption of recommended solutions.
Conducted training sessions for team members on data analysis and reporting tools, enhancing their skills and productivity by 15%.

Business Analyst

ITC Private Ltd
Hyderabad, Telangana
11.2020 - 12.2022

Utilized SQL queries in collaboration with stakeholders to analyze business requirements, resulting in a 20% improvement in data accuracy and efficiency
Performed data analysis and modification using SQL and Salesforce, Python, leading to a 15% reduction in data processing time
Developed and maintained 10+ interactive Tableau dashboards and reports for data visualization, enhancing decision-making capabilities and reducing report generation time by 30%
Translated 50+ user stories and technical specifications from business requirements, ensuring clear communication and alignment with development teams
Facilitated integration of 5+ third-party services and APIs into existing systems, improving system interoperability and functionality by 25%
Participated in agile project management approaches, contributing to a 40% increase in project delivery speed and efficiency
Conducted impact studies and risk assessments for proposed IT solutions, mitigating potential risks and enhancing project success rates by 20%
Actively participated in continuous improvement programs and post-implementation reviews, leading to a 10% increase in overall process efficiency
Oversaw adherence to internal quality standards at every stage of the software development lifecycle, achieving a 98% compliance rate with company policies and procedures.

Tech Associate

Publicis Sapient
Bangalore, Karnataka
09.2019 - 10.2020

Collaborated with cross-functional teams, including supply chain subject matter experts and business analysts, to convert challenging requirements into effective technological solutions
Performed data analysis and visualization using Power BI and Tableau, providing stakeholders with actionable supply chain insights
Extracted, transformed, and loaded supply chain data using SQL and data warehousing techniques, facilitating effective data processing and analysis
Developed scalable solutions for supply chain incentive calculation processes, significantly reducing turnaround time
Extracted, transformed, and loaded data from several sources using SQL and data warehousing techniques, facilitating effective data processing and analysis
Created dynamic reports and dashboards that let stakeholders track important performance metrics and make informed decisions
Using Salesforce, C# and SQL, a modular, scalable, and effective solution for incentive calculation processes was developed, leading to a 60% turnaround time reduction
Developed a strong, error-proof algorithmic solution in .NET to fix $2MM in fees billed wrongly, impacting 10,000 clients
The solution integrated with current systems and ensured smooth stakeholder management
Redesigned the reward provisioning process using ASP.NET and Web APIs, preventing a 92% decline in reward reserve following a crucial migration
Made use of GitHub and Git for version control and team communication during development, guaranteeing code maintainability, quality, and effectiveness.

Education

Master of Science - Business Analytics

Lewis University
Romeoville, IL
05.2024

Bachelor of Technology - Electrical, Electronics & Communications Eng

Gitam University
Hyderabad
05.2020

Skills

  • Tableau & Power Bi
  • Data visualization & Machine Learning tools
  • SQL & Python
  • Visio & Lucid Charts
  • Requirements Gathering
  • Microsoft Office Suite
  • User Acceptance Testing
  • Salesforce
  • Supply chain Management
  • Agile Methodologies
  • Six Sigma & Lean Models
  • Web APIs
  • HTML
  • CSS

Accomplishments

Capstone Project: Comprehensive Investment Analysis on Shark Tank Dataset

  • Technologies: Tableau, Python, Data Visualization, SQL, Excel, Lucid chart- Performed in-depth quantitative analysis on a dataset of 1,345 investment deals from 15 seasons of the reality show Shark Tank using advanced data analytics techniques
  • Leveraged data visualization tools like Tableau to create insightful charts and graphs exploring investment trends over time, industry distributions, and equity-investment correlations
  • Employed statistical modeling using regression analysis in Python to determine key predictor variables like initial ask amount and pre-money valuation for secured investment amounts
  • Implemented machine learning techniques like K-means clustering and decision tree algorithms (J48) to uncover underlying patterns in investor behaviors across diverse industries
  • Designed an optimized entity-relationship database model in SQL and developed complex queries to analyze investment allocations by top Sharks, industry preferences, and most successful startups
  • Conducted exploratory data analysis calculating statistical measures like mean, median, quartiles, skewness, kurtosis, and outlier bounds to evaluate variability and shape of deal amount distributions
  • Presented comprehensive findings through visualizations and a formal report detailing data-driven insights, strategic recommendations, and limitations using quantitative methods

CERTIFICATIONS

  • Completed Data Analytics Certification in Microsoft
  • Completed Web APIs Certification in LinkedIn
  • Completed C# Certification in LinkedIn

POSITIONS OF RESPONSIBILITY

VP of Core Executive Committee, organized college fest, alumni sessions, and career fairs

Conducted health campaigns

Timeline

Business Analyst

USAA
01.2024 - 06.2024

Business Analyst

ITC Private Ltd
11.2020 - 12.2022

Tech Associate

Publicis Sapient
09.2019 - 10.2020

Master of Science - Business Analytics

Lewis University

Bachelor of Technology - Electrical, Electronics & Communications Eng

Gitam University
PRAGATHI PATHI