Vinay Vuppala
Denton,TX
Summary
Experienced Data Analyst with 5years of expertise in specializing in optimizing data analysis processes. Recognized for designing highly efficient data models, leading to a 50% increase in overall efficiency. Proficient in Python, R, SQL, AWS, Snowflake, GCP, Tableau, and Power BI. Adept at translating complex data into actionable insights and eager to contribute expertise to a dynamic and challenging role.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Data Analyst
Discover Financial Services
Illinois, CH
07.2022 - Current
- Analysed and extracted data from various confidential databases and Data Mart using SQL/Oracle (Toad) queries/codes, achieving an average of 90% successful extractions per month.
- Executed data cleansing and manipulation tasks using Excel VLOOKUPs, pivot tables, and advanced Excel functions, resulting in an 12% improvement in data accuracy.
- Conducted quality assurance on tables in Postgres and Snowflake using Python, achieving a thorough check on 99% of tables and identifying 8 discrepancies, ensuring data integrity during migration.
- Developed the required data warehouse model using Star Schema for the generalized model in Snowflake, consistently meeting project timelines with 95% accuracy in model development.
- Maintained accurate data flow documentation and performed object mapping using Power BI tools and Confluence, ensuring a 100% accuracy in the representation of data flows
- Actively participated in daily Agile and Scrum Master meetings, consistently attending 100% of the meetings and providing valuable feedback and project updates.
- Created process flow charts, presentations, and defect documentation using JIRA and PowerPoint, contributing to 20% documented processes and 10% identified defects.
- Conducted performance optimization on Tableau dashboards, resulting in a 10% reduction in load times.
- Implemented scalability enhancements on GCP infrastructure, achieving a 15% increase in system scalability. Leveraged GCP services like Kubernetes Engine and Autoscaling for efficient workload management, ensuring peak performance.
- Implemented advanced data processing pipelines on Google Cloud Platform (GCP) using services like Cloud Dataflow and BigQuery, enhancing real-time data analytics capabilities and reducing processing time by 20%.
Data Analyst
Optimal Crave International
Hyderabad, IN
03.2019 - 08.2021
- Spearheaded the conceptualization and development of a robust data model for EBMS, revolutionizing event booking processes
- Engineered and seamlessly deployed a lightweight Progressive Web Application using Flask, resulting in a noteworthy 3.5% surge in data availability on AWS ECS
- Providing vital support to the event management section, streamlining booking processes by an impressive increase of 10%
- Orchestrated active team meetings in Agile and Scrum master, leveraging technical expertise to propose innovative solutions and Applied driving continuous improvement initiatives
- Developed and maintained interactive Tableau dashboards, contributing to a 90% increase in data accessibility and analysis efficiency
- Executed comprehensive data modeling activities, improving database efficiency by optimizing query performance and reducing data redundancy by 15%
- Implemented data integration workflows in Informatica, resulting in a 10% reduction in data processing time and increased data accuracy
- Maintained detailed data documentation in Confluence, ensuring a 25% increase in project knowledge accessibility and collaboration efficiency
- Executed comprehensive dimensional modeling, improving database efficiency by optimizing query performance and reducing data redundancy by 20%
- Executed performance tuning on MySQL by developing optimized SQL queries, leading to a 12% improvement in query execution speed
- Employed Python for data manipulation, contributing to a 15% improvement in data accuracy.
Education
Master's in Business Analytics -
University of North Texas
05.2023
Skills
- Python
- R Studio
- SQL, MySQL
- AWS, GCP
- Power BI, Tableau
- HTML, CSS, SAS
- JavaScript, Java
- JIRA, Confluence
Certification
- AWS Cloud Practitioner Certification
- IBM Data Analyst Professional Certificate
- Profit Impact Metrics
- Google Database Foundations
Projects
Project KIVA - May 2022 – July 2022
Employing neural networks and Python, I achieved a remarkable 97.13% accuracy in predicting loan statuses using Kiva.org data. By leveraging Tableau, I identified pivotal factors crucial for loan approval, significantly enhancing Kiva.org's loan approval rates. Proficient in Python and Tableau, I optimized data visualization techniques, contributing to overall project efficiency.
Machine Learning Project - August 2023 – December 2023
Through rigorous data preprocessing in Python, I significantly improved model accuracy, resulting in more reliable predictions. I streamlined model selection processes, reducing time expenditure by 12%. By implementing efficient data preprocessing techniques, I reduced model training time by 20%, enhancing overall project efficiency.
Timeline
Data Analyst
Discover Financial Services
07.2022 - Current
Data Analyst
Optimal Crave International
03.2019 - 08.2021
Master's in Business Analytics -
University of North Texas
Similar Profiles
Latasha PalmerLatasha Palmer
Home Loans Document Specialist at Discover Bank/Discover Financial ServicesHome Loans Document Specialist at Discover Bank/Discover Financial Services
Justin SicienskiJustin Sicienski
Principal Product Manager (Commercial Payments) at Discover Global Network - Discover Financial ServicesPrincipal Product Manager (Commercial Payments) at Discover Global Network - Discover Financial Services
River BonsRiver Bons
Lead Account Specialist at Discover Financial Services, DFSLead Account Specialist at Discover Financial Services, DFS
DAWNE GARRETTDAWNE GARRETT
Senior Customer Service Representative at Discover Financial Services, DFSSenior Customer Service Representative at Discover Financial Services, DFS
Lisa JurgensmeierLisa Jurgensmeier
Laundry Pro at The Mat by Laundry on DemandLaundry Pro at The Mat by Laundry on Demand