Hello! This is Yogi

Data Analyst & Visualizer

Graphic Designer & Video Animator/Editor

Hire me Download Resume








0 Consulting & Volunteer Projects Complete
0 Consulting Hours
0 Years experienced
My Intro

About Me

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

  • Name: Yogi Patel
  • Location: Philadelphia, PA, USA
  • Zip code: 19020
  • Email: yogi.patel224@gmail.com
  • Phone: +1 (201) 381-7781
  • Education: Bachelor of Business Administration, Temple University, August 2015 - May 2019
Experience

My Professional Experience

Hover over each tile to learn more about my experiences!

March 2021 - July 2022

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.
Senior Business Risk Management Analyst
OptumRx at UnitedHealth Group

August 2019 - March 2021

  • 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.
  • 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.
Experienced Associate, Advisory
PricewaterhouseCoopers LLP

October 2018 - May 2019

  • 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.
Supply Chain Intern
Philadelphia Gas Works

May 2018 - August 2018

  • 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.
SAP Business Analyst Intern
Pfizer Inc.
Skills

Below are my skills along with softwares and applications that I have experience in.

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

Have a project or job opportunity on your mind.

Contact me

Accomplishments

My Projects

Click on the thumbnails below to view my projects

Making a difference

Volunteering

building a better future

May 2021 - October 2023 = Full-time Volunteer

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.
  • 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.
  • 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).
  • 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.
Contact me

Have a Project or Job Opportunity?

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