Pranav Gupta Email & Phone Number

New York, New York, United States

New York, United States

1. Created Customer Retention Model leveraging Python to segment the customer base, enabling targeted marketing initiatives and personalized offers resulting in 6% more Customer Retention.2. Developed and implemented advanced analytical models using R to forecast ticket sales demand, resulting in an 8% increase in ticket sales, the highest in the company’s history.3. End-to-end automation of the ticket sales reporting system on Tableau leveraging highly complex and custom SQL queries, which resulted in real time ticket sales reporting.4. Building multiple end to end automated data pipelines for third-party vendors like Eventellect, Logitix and BASIS leveraging AWS micro-services like EC2, S3, IAM and Python.5. Created the Data Lake from 2 leading Ticketing platforms in Seatgeek and Ticketmaster.

Mumbai

1) Integral part of a team tasked with delivering ML Models for the Google Partner Program. The aim was to identify lesions in the brain and I constructed an end-to-end pipeline on GCP [using CodeBuild] enabling the development, evaluation, and deployment of ML models on the Kubernetes Clusters deployed. 2) Consulted Fortune 100 US client for development of SaaS Product in the healthcare and insurance domain. Expertly working with extensive AWS Services to migrate an American Insurance Company’s data from multiple on-premises SQL Servers to DynamoDB in AWS Cloud environment: a) Successfully modeled platform infrastructure using CloudFormation. Resources created were - DynamoDB Tables, Dax Cluster, EC2 Instances, S3 Buckets, Glue Jobs, Glue Crawlers, Glue Databases, Step Functions, Lambdas, Cloudwatch Rules, KMS Keys, SNS Topics and Subscriptions, deployed to 3 environments - qa, intg and production. YAML was used for the CloudFormation templates.b) Successfully automated the entire project by developing and deploying the StepFunction definition.c) Successfully handled daily ingestion of big data from Infoworks to the AWS Environment.d) Developed numerous customized scripts to automate jobs, massively improve performances, save resources and overcome limitations of the AWS Services. Certain use-cases are as follows:- Developed Lambda to act as an Instance Scheduler i.e Stops the running instances automatically in order to optimize costs.- Developed a script to Truncate the DynamoDB Tables. AWS doesn’t offer functionality to truncate the DynamoDB Table.- Implemented Automation Framework for GlueJobs i.e automated the testing of updated Glue Jobs when Glue Jobs with modifications are committed to the AWS CICD pipeline.3) Coached newly-hired team members on advanced technical procedures.4) Planned deliverables for multiple cross-functional teams as story-points in sprints using VersionOneSoftware, adopting agile processes through scrum framework.

Mumbai, Maharashtra, India

1) Performed quantitative and qualitative business analysis of six competitors, generating insight to shape strategies for premium services at 25% lower price.2) Researched market to benchmark options, framing the unique scope of services for future development.3) Grew student mentor base to include 100+ universities spanning across four continents.4) Partnered with top foreign education consultancies to successfully build a customer base to achieve double the revenue targets.

1) Launched personalized consulting business model in Mumbai and nearby regions for Civil Services and MBA entrance examinations, guiding 1K+ people to prepare for and apply to degree programs and positions.2) Researched, analyzed, and projected data for potential markets leveraging Customer Analytics3) Grew team from four to 12, mentoring new employees as Team Lead, delivering $50k+ revenue monthly.4) Planned marketing initiatives and leveraged referral networks to promote business development.Commemorated for generating the highest weekly revenue PAN India in the company's history for Civil Services’ department.5) Analyzed the Customer Market and panned out strategies for increasing the customer base.

Education record

Activities and Societies: Fuqua Private Equity Club | Ping Pong Club | Tennis Club

Bachelor Of Engineering - Be, Information Technology

Activities and Societies: Captain of the College Table Tennis Team, having participated in various Mumbai University and Inter-College.