Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic
Praveen Patel

Praveen Patel

Dallas,TX

Summary

Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data.

Overview

4
4
years of professional experience
1
1
Certification

Work History

Founder

Data Hands
04.2023 - Current
  • Developing online platform to teach practical data processing and insights generation skills for students and professionals across various sectors, including finance, marketing, and supply chain management
  • Analyzed industry trends and tracked competitor activities to inform decision-making.
  • Crafting project-based tutorials utilizing SQL, Python, R Programming, Excel, Power BI, and Tableau to provide immersive learning experiences, focusing on data manipulation, interpretation, and visualization techniques
  • Collaborated with industry professionals and subject matter experts to review and maintain compliance with regulations.

Data Analyst Intern

Mindshare
07.2022 - 01.2023
  • Collaborated with clients' Subject Matter Experts (SMEs) to understand quarterly sales goals, and reallocated media funds using Jira for project management, resulting in a 14% increase in sales
  • Streamlined 700K+ rows of historical sales data using ETL methods and AWS cloud, eliminating duplicate data for market research, and analyzed Unilever product trends with Excel, SQL, and Python to make profitable decisions
  • Generated standard and custom reports to provide insights into business performance.
  • Created Power BI dashboards to visualize complex sales data, enhanced decision-making, and increased revenue while delivering exceptional customer service through teamwork and valuable insights for clients
  • Developed a Churn prediction model for PayPal using Logistic Regression, evaluating its performance with accuracy, precision, recall, and F1 score metrics, and employed Scrum methodology to ensure timely delivery
  • Boosted sales by $210K+ for Ford Pro using marketing analytics, evaluating channels with regression and time series analysis, and effectively communicating recommendations in an Agile environment
  • Developed a Business Intelligence Model for Ford to study trends, using Regression and Time Series Analysis to analyze the impact of various factors on sales and provided recommendations to maximize ROI.
  • Performed routine tasks under direct supervision and within established procedures and guidelines

Data Analyst

Alliant Infotech
06.2019 - 07.2021
  • Led and managed team of 3 people to design a unified Power BI Sales Monitoring dashboard using Oracle SQL and Excel tools to find relevant KPIs like profit margins/revenue enhancing Sales by ~12% for Retail clients
  • Boosted Web traffic by performing A/B testing and building Adobe analytics reports deploying various acquisition, retention and customer metrics resulting in 11% increase in client-base, 8% increment in conversion rate
  • Developed a recommendation system for an E-commerce company using collaborative filtering and matrix factorization techniques
  • Generated ad-hoc reports to evaluate specific business requirements.

Education

Master of Science - Data Science

The University of Texas
Dallas, TX
05.2023

BBA - Finance

Devi Ahilya University
India
05.2019

Skills

  • TECHNICAL SKILLS
  • Analysis Tools: Google Analytics, Adobe Analytics, Advanced MS Excel (Macros, Solver), Jira, Scrum, AWS Cloud
  • Methodologies: Regression, Hypothesis Testing, A/B Testing, Predictive Analysis, Data Processing, Statistics
  • Programming Languages: Python, SAS, R Programming,
  • Databases & Visualization tools: SQL Server, MySQL, Oracle, Mongo DB, Tableau, Power BI

Certification

Google Analytics Individual Qualification and Alteryx Designer Core

Timeline

Founder

Data Hands
04.2023 - Current

Data Analyst Intern

Mindshare
07.2022 - 01.2023

Data Analyst

Alliant Infotech
06.2019 - 07.2021

Master of Science - Data Science

The University of Texas

BBA - Finance

Devi Ahilya University

Similar Profiles

CREATE PROFILE
Praveen Patel