Jayant Sharma Email & Phone Number

I am Business Analyst whose is surrounded by Business problems everyday. - Why did the conversion fall yesterday, why is the acquisition cost so high, Which step in the funnel became the bottleneck - How to reactivate the old user, which strategy works the best, which target cohort performs better- What should be the revenue model, when will this campaign break even, how's the ARPUsThese are the tip of the iceberg problems that I deal with and answer using my Data Analysis and Engineering capabilities.In the Current Company, my works involves- Writing complex sql queries/python program to pull the data, analyse it, identify the trend, identify the winners and loosers and share it with business for informed decision making.- Create Interactive Dashboards and reports, monitor KPIs, set alerts, report anomalies/drops/failures to the stakeholders- Extract personalized insights on customer's profile and investment behavior to use it as a tool to re-activate and re-engage the customer- Set up & monitor ETL Data pipelines to automate reporting and dashboardingSome of my key Projects are:- Designed the customer profiling for company’s 10 million+ user base. It serves as a single source of truth for organization wide customer analysis and personalization.- Revamped the Growth, Marketing and Finance reporting from excel sheets to fully automated dashboards, daily mailer reports and alerts.- Led strategic analysis to broaden insurance product targeting. Successfully addressed a 35% funnel drop-off, resulting in a refined strategy that reduced this drop to 15% - Analysed historic influencer marketing campaigns data and selected the most cost-effective influencers for the next quarter. Subsequently, acquired the same quality users at a 30% lower cost- Detected and prevented referral program abuse and proposed a data-driven strategy to revamp the program which was successfully implementedLanguage: MySQL, PostgreSQL, Python, Scala, Pyspark, JavaTools & Tech: Redshift, Spark, Hadoop, HBase, Hive, Sqoop, S3, Airflow, Redash, Metabase, Firebase, Google Analytics, Bigquery, Looker, Quicksight, Tableau, Mixpanel, Docker, Bitbucket, Jira, ETL ,CI/CD

• 

  Computer Science & Engineering Department Dcrust Murthal

  Computer Science