Shubham Upadhyay

Shubham Upadhyay

Data Analyst
India

About Me

Accomplished data analyst with expertise in extracting actionable insights from complex datasets. Proficient in statistical analysis, data visualization, and database management. Proven track record of driving informed d…

Experience

Data Analyst

ImpactGuru
Dec 2022 - Present · 3 years 6 months

As a Data Analyst, I will play a crucial role in improving various aspects of our business by analyzing data from 2 million active users. My insights will guide decisions in critical modules such as Payments, CRM, Insurance, User acquisition, and Sales growth, ultimately driving an increase in Gross Merchandise Value (GMV). Additionally, I will excel in fitting machine learning models using Python, contributing to the enhancement of our analytical capabilities.

Key Responsibilities:

Enhance business scalability in key areas including Payments, CRM, Insurance, User acquisition, and Sales growth through data analysis.
Overhaul the Donor Conversion Funnel and Campaigner Funnel using tools like Tableau and MySQL to increase lead-to-campaign conversion rates by 30%.
Conduct complex data queries using SQL to extract, analyze, and present key business insights, reducing data processing time by 25%.
Develop and optimize SQL queries, utilizing advanced functions such as JOINs and subqueries for comprehensive data analysis.
Create customized Tableau and Power BI dashboards to identify changes in donation processes, resulting in a revenue increase of 20%-25%.
Support Product and Marketing teams in customer segmentation, retention, and growth metric initiatives.
Achieve a 3.5x ROI on social media advertising campaigns through advanced audience targeting and bid optimization strategies.
Analyze data from web traffic, mobile app usage, and marketing campaigns to provide insights into business performance and customer behavior.
Execute A/B Test Analysis, leading to a 15% surge in donor conversion rates and a 2X growth in organizational revenue.
Apply machine learning techniques and Python programming skills to fit models, further enhancing our analytical capabilities and driving actionable insights.
Qualifications:

Bachelor's degree in a relevant field such as Statistics, Mathematics, Computer Science, or a related discipline.
Proficiency in SQL and experience with databases like MySQL.
Strong analytical skills and attention to detail.
Experience with data visualization tools such as Tableau and Power BI.
Proficiency in Python programming for machine learning model fitting.
Ability to work collaboratively with cross-functional teams.
Excellent communication skills to convey complex data insights effectively.

Data Analyst (Product & Technology)

Impact Guru Technology Ventures Pvt. Ltd
Present

Visualization & Analytics: Tableau, Power BI, MS Excel, PowerPoint, Google Analytics, DAX, ETL
Database: MS SQL Server, MySQL Workbench
Project & Task Management Tools: Atlassian Jira, Google Sheets
Enhanced business scalability in critical modules such as Payments, CRM, Insurance, User acquisition, and Sales growth.
Delivered strategic insights by analyzing data from 2 million active users, guiding customer service, and shaping Product and Marketing strategies to boost GMV.
Overhauled the Donor Conversion Funnel and Campaigner Funnel using Tableau and MySQL.
Conducted A/B Test Analysis, resulting in a significant 30% increase in lead-to-campaign conversion rates.
Provided valuable data insights and suggestions, contributing to a notable 2X growth in organizational revenue.
Conducted complex data queries using SQL to extract, analyze, and present key business insights.
Developed and optimized SQL queries, resulting in a 25% reduction in data processing time.
Utilized advanced SQL functions, including JOINs and subqueries, to perform comprehensive data analysis.
Recommended system modifications and developed policies for data governance.
Created customized Tableau and Power BI dashboards, resulting in a 20%-25% revenue increase by identifying changes in donation processes.
Participated in customer segmentation, retention, and growth metric initiatives to support Product and Marketing teams.
Achieved 3.5x ROI on social media advertising campaigns by implementing advanced audience targeting (Retention Marketing) and bid optimization strategies.
Analyzed data from web traffic, mobile app usage, and marketing campaigns, unveiling crucial insights into business performance and customer behavior.
Revamped and fine-tuned the Donor Conversion Funnel and Campaigner Funnel.
Executed A/B Test Analysis, leading to a remarkable 15% surge in donor conversion rates and a noteworthy 2X growth in organizational revenue.

Skills

Analytics Data Analysis Professional Information Systems Management Data Mining Microsoft Access Python Structured Query Language (SQL) Data Representation Data Analysis Skills Power BI Tableau Data Analysis Data Visualization Techniques Business Intelligence Exploratory Data Analysis Decision-Making Data Storytelling ML Engineering Analytics Consulting Business Growth Product Service Data Modeling Stake holder management Requirements Gathering Process Improvement Project Management Teamwork Agile Methodology Documentation Linear Regression Logistic Regression Amazon AWS MS Excel Google Analytics ETL MS SQL Server MySQL Workbench Atlassian Jira Google Sheets PowerPoint DAX Pandas Plotly Decision Tree Naive Bayes
Report this Profile?