Prashant Patwa

Business Development Executive

Gurgaon, Haryana, India7 yrs 9 mos experience

Most Likely To SwitchAI Enabled

Key Highlights

Drove $2.5M in revenue growth through data analytics.
Enhanced operational efficiency by 13% across multiple domains.
Proven ability to transform complex data into actionable insights.

Stackforce AI infers this person is a Data Analytics expert in Fintech and MarTech, specializing in data-driven strategies.

Contact

Skills

Core Skills

Data AnalysisBusiness Intelligence ToolsMarketing AnalyticsDigital Strategy

Other Skills

SQLTableauData QualityData ValidationEmail CampaignsPredictive AnalyticsStrategyRisk ManagementRisk AnalyticsCredit Risk ManagementBusiness AnalysisBusiness InsightsBig Data AnalyticsPythonPower BI

About

Data Analytics Professional with over 6.5+ years of experience leveraging SQL, Python, Power BI/Tableau, and advanced analytics tools to drive $2.5M in revenue growth and enhance operational efficiency by 13% across the BFSI, Marketing, and IT domains. Expertise in digital product management, fraud analytics, data analysis, and marketing analytics with a proven ability to transform complex, large-scale data sets into actionable insights. Proficient in working within big data environments, employing advanced analytical techniques to solve business challenges, and delivering data-driven strategies that optimize performance and mitigate risks.

Experience

7 yrs 9 mos

Total Experience

2 yrs 7 mos

Average Tenure

4 yrs 4 mos

Current Experience

American express

Senior Data Analyst

Jan 2022 – Present · 4 yrs 4 mos · Gurugram, Haryana, India · Hybrid

Spearheaded data sync projects starting from issue identification in Amex’s demographic data to implementing corrective measures to rectify and uplift user experience for 1.2 million customers.
Optimized Amex's customer demographics data and conducted data quality comparative analysis on multiple SORs (system of records) like Customer 360 and other legacy SORs.
Spearheaded rigorous data validation and cleansing procedures using SQL queries, resulting in a 2% reduction in data errors and inconsistencies across multiple databases.
Conducted comprehensive root cause analysis using advanced SQL techniques to identify and rectify data anomalies, such as duplicates and outliers decreasing operational risk events by 75%.
Leveraged Tableau to provide leadership real-time insights on data quality, and product efficiency, and drove 25% growth in product adoption through informed decision-making.
Led and managed a team of 3 analysts across multiple projects, providing mentorship, guidance, and regular performance evaluations to ensure alignment with project and personal goals.

SQLTableauData QualityData ValidationData AnalysisBusiness Intelligence Tools

Wunderman thompson

Senior Data Analyst

Jan 2020 – Jan 2022 · 2 yrs · Gurgaon, Haryana, India

Orchestrated the activation of email campaigns for Microsoft by extracting, manipulating, and analysing email address datasets to extend awareness of Microsoft’s products.
Implemented a marketing mix model (Random Forest) to optimise budget allocation for digital marketing for different channels, leading to a 10% reduction in wasted ad spend for Allianz and Microsoft.
Enhanced the email deliverability rate from an average of 93% to 97% (an increase of 4%) by manipulating and cleaning the distribution lists before deploying the campaigns.
Increased the email open rate from an average of 10.3% to 17.8% (an increase of 7.5%) using multivariate test (A/B testing) strategies by analyzing test results using SQL to determine statistically significant differences for Allianz.
Executed in-depth data analysis of email campaign performance using SQL to evaluate key metrics such as open rates, click-through rates, and conversion rates to enhance the campaign’s effectiveness.

Digital StrategySQLEmail CampaignsMarketing Analytics

Tata consultancy services

Data Analyst

Jul 2018 – Dec 2019 · 1 yr 5 mos · Pune Area, India

Collaborated with a 7-member cross-functional team (Analytics, marketing, and IT) to integrate data-driven insights and recommendations in Aviva’s (TCS’ client) marketing initiatives.
Leveraged predictive analytics to segment the audience accurately, resulting in an increase in clickthrough rate from 1.87% to 2.25% for one of the Facebook campaigns.
Forecasted customer churn and implemented targeted retention strategies, reducing churn rate by 5% and increasing customer lifetime value by 11%.

Predictive AnalyticsData AnalysisStrategyBusiness Intelligence Tools

Uttar pradesh power corporation limited

Intern

Jun 2015 – Jul 2015 · 1 mo · Greater Noida

I was responsible for the operational management of 220KV/33KV Substation. This internship helped me in the following ways-
1. Broadened the understanding with respect to the working of a substation which involved SCADA in its working
2. In gaining valuable insights regarding the practical application of Transformers, Lightning arresters, CTs, PTs, Switchgears etc.