Yogi Patel

Yogi Patel Philadelphia, PA

Yogi Patel, portrait

Data Analyst & Visualizer.

Graphic Designer & Video Animator/Editor

Based in the suburbs of Philadelphia. Experienced in data analysis, visualization, reporting, graphic design, and video animation.

Hire me Download Resume

Experience with

  • Dollar General
  • UnitedHealth Group
  • PwC
  • Philadelphia Gas Works
  • Pfizer
  • 10 Consulting & Volunteer Projects Complete
  • 50,000 Consulting Hours
  • 7 Years experienced

01 / About

About

Name
Yogi Patel
Location
Philadelphia, PA, USA
Zip code
19020
Email
yogi.patel224@gmail.com
Education
Bachelor of Business Administration, Double Major in Management Information Systems and Supply Chain Management
Temple University, Fox School of Business and Management · August 2015 – May 2019
Tableau Public (opens in new tab) Resume (PDF)

02 / Experience

Experience

  1. –

    Senior Licensing Data Analyst

    Dollar General Corporation

    • Achieved cost savings of $1.5 million by developing and deploying a Python and Alteryx-based automation tool to autofill license renewal forms, eliminating the need for temporary staffing and enhancing operational efficiency.
    • Led reporting initiatives for 10 Licensing teams, utilizing SQL, Alteryx, Excel, Access, and PowerBI to streamline KPI data workflows and enhance decision-making.
    • Reduced over 40 hours of weekly labor by automating manual reporting processes for Licensing Specialists using Alteryx and Microsoft Excel, improving operational efficiency and accuracy.
    • Created 10 PowerBI dashboards to deliver insights, supporting business intelligence and forecasting.

  2. –

    Senior Business Risk Management Analyst

    OptumRx at UnitedHealth Group

    • Managed SQL database for client reporting
    • Developed client reporting and provided business and technical support to operational performance guarantee stakeholders for accurate report delivery.
    • Improved Performance Guarantee process by automating data entry processes leveraging Excel, SQL scripts, and Alteryx workflows.
    • Collaborated with legal department to ensure the timely receipt of executed agreements.

  3. –

    Experienced Associate, Advisory

    PricewaterhouseCoopers LLP

    • Executed Fraud Analytics for client by performing data analytics using Alteryx and presented insights by creating Tableau dashboards.
    • Analyzed, optimized, and tested 12 Data Validation procedures using SQL programming language and developed use cases for user testing.
    • Led a team of 10 colleagues for a code review project reviewing SQL queries for 5 separate clients; worked with leadership to present work and implement feedback, provided insights to team members and guided team members to resolve SQL inquiries.
    • Performed data completeness exercise leveraging fuzzy match tool on Alteryx.
    Show 5 more Show less
    • Automated financial reports for film distribution organization using Alteryx by normalizing financial data and implementing into annual reports.
    • Assisted in managing data team from across the USA as well as India that abstracted contractual data from pdf files using PwC’s DataSieve system to create and develop client database.
    • Performed and delivered Data Governance assessment while adapting to client’s working environment delivering work via AuditBoard.
    • Developed and implemented process flow for Common Data Model using Microsoft Visio.
    • Co-led creation of Google website for a national internal firm volunteering initiative.

  4. –

    Supply Chain Intern

    Philadelphia Gas Works

    • Automated and optimized reporting process by recreating Buyer, Purchase Order, and Account reports and creating Excel Macros for automation of repetitive reporting tasks.
    • Extracted data from Oracle databases and created Excel purchase order and inventory reports.
    • Delivered 6 daily reports, and ad hoc reports, to Buyers and Managers utilizing Excel tools such as pivot tables, slicers, macros, and other functions.
    • Performed material planning, inventory management, and data analytics to oversee minimum stock requirements on thousands of stock and non-stock items to minimize shortages.

  5. –

    SAP Business Analyst Intern

    Pfizer Inc.

    • Created and delivered Tableau dashboards to leadership teams across the globe to enable strategic business and financial planning.
    • Participated in an innovation event to develop a marketing solution for Meningitis B vaccination using emerging technologies such as holograms and virtual reality.
    • Created master documentation file consisting of navigational paths to 2,040 SAP transactions.
    • Collaborated with senior leadership in strategic planning meeting to determine budget flexibility for the 2019 fiscal calendar.

03 / Skills

Skills

  • Data Analytics & Visualization

    • Alteryx
    • Microsoft PowerBI
    • JustInMind
    • Tableau
    • Tableau Server

  • Database Management

    • MySQL
    • MySQL Server
    • Oracle
    • Salesforce nCino

  • Design & Animation

    • After Effects
    • AutoCAD
    • Blackmagic DaVinci Resolve
    • Illustrator
    • InDesign
    • Photoshop
    • Premiere Pro

  • Microsoft Office 365

    • Excel
    • PowerPoint
    • Word
    • Visual Studio

  • Programming & Virtualization

    • Bootstrap
    • CSS
    • HTML
    • Java
    • JavaScript
    • Microsoft Azure
    • NetBeans
    • PHP

  • Enterprise Resource Planning

    • SAP

04 / Selected work

Selected work

Video & Animation

Visual Tableau Analysis

Graphic Design

05 / Volunteering

Making a difference

Volunteering, building a better future.

BAPS Swaminarayan Akshardham at sunset, seen across the reflecting pool, Robbinsville, NJ
BAPS Swaminarayan Akshardham, Robbinsville, NJ

One of 450 full-time volunteers who helped construct the Akshardham, a Hindu house of worship. Most of the volunteers quit their jobs, paused their careers, moved their families, and took semesters off or gap years, to serve. The volunteers’ ages ranged from 19 to 70.

  1. May 2021 – February 2023 · Site Safety

    From May 2021-February 2023, administered the Site Safety team to ensure OSHA compliance throughout construction site. Trained a team of 6 volunteers and organized OSHA certification courses and testing for all team members. Organized weekly OSHA trainings for all volunteers to ensure compliance. Coordinated with external OSHA consultant to ensure construction site is compliant with all OSHA safety standards.

  2. February 2023 – June 2023 · Scaffolding

    From February 2023-June 2023, led a team of 20 volunteers erecting and dismantling iron coupler scaffolding throughout construction site. Coordinated with all team leads to gather scaffolding requirements and schedule erection or deconstruction. Erected the site's tallest and widest structure for 92-foot Mahashikhar (spire).

  3. June 2023 – October 2023 · Stone work

    From June 2023-October 2023, led a team of 15 volunteers to place and fit stone on the parikrama (exterior colonnade). Measured and marked decorative stones for fitting by referencing AutoCAD designs. Cut stones using construction power tools such as 16” gas powered saw, stone cutting grinder, jackhammer, etc. Clamped stones using long L and C-shaped stainless-steel rods. Marked up and cut structural holes for stainless steel and PVC conduit pipes for electrical wiring and water drainage.

06 / Contact

Have a Project or Job Opportunity?

Enter your information below with brief details and I will be in touch!

Address

Philadelphia, PA