Summary
Overview
Work History
Education
Skills
Rewards And Recognition
Timeline
Generic

Ankit Thakur

Hyderabad

Summary

Results-driven Senior Data Consultant at Fractal Analytics with expertise in Google SQL and stakeholder engagement. Successfully analyzed GPay's financial transactions, enhancing merchant retention strategies. Proven ability to convert complex data into actionable insights, significantly impacting marketing and finance decisions. Adept at mentoring teams to elevate performance and quality of output.

Overview

14
14
years of professional experience

Work History

Senior Data Consultant

Fractal Analytics
Hyderabad
01.2022 - Current
  • Analyzing GPay's financial transactions across India to answer critical business questions (Merchant Operations Analytics, Merchant Churn Analysis, Monthly Business Report on movement of critical KPI's)
  • Mentoring incoming juniors by providing them regular KT sessions for improving their quality of output
  • Converting deep dive projects into impactful case studies for showcasing to prospective clients
  • Preparation of Monthly Business Decks: Analyzing affect of Business campaigns, Offers, External/Internal factors in KPI's movement and forecasting our KPI's for next month based on current performance.
  • Merchant churn Analysis: Identifying various Internal & External factors which causes merchants to leave Google pay Merchant app and attributing the importance of each factor
  • Geo Analysis (Cluster based targeting): Identified districts to target for inducting of new merchants, resurrecting old merchants based on LTV framework which looked at health of merchants in each district, cost benefit analysis on the retention of merchants VS the amount spent on onboarding new merchants etc.
  • Impact: Report is consumed by Marketing, Finance & Strategy team which helps them in assessing short term & long term impact of their strategy and do necessary course corrections for better results
  • Impact: With merchants churning one of the biggest cause of concern for Gpay, High risk factors were identified and appropriate course corrective steps were taken to improve retention
  • Impact: The final output is being used by the onboarding team while preparing onboarding strategy for the CY 2024 with separate approaches used for separate clusters identified across India

Consultant

Optum Global Solutions
01.2017 - 01.2022
  • Company Overview: United Health Group
  • Spearheaded UHG's Medical Claims dashboard reducing overall Claims monitoring time by 25%
  • Owned Project Management Application for the 90 member audit team built on VBA + MS SQL + Power BI improving overall employee utilization of the audit team by 10% in 2020
  • Participated in multiple Internal Audits (Pharma Audit for price regulation, Medical Claims Audit, HR Audit)
  • Part of Net Promoter System team responsible for Survey Creation, Distribution, Analysis & Presentation
  • United Health Group

Systems Engineer

Tata Consultancy Services
01.2012 - 01.2015
  • Coordinated responsibilities of Reviewing software requirements, Execution of test cases and Reporting defects of a major B2C website of a Multinational Bank

Education

M.B.A - Finance

Xavier Institute of Management (XIMB)
Bhuvaneshwar
01.2017

B.Tech - Computer Science & Engineering

Institute of Technical Education & Research
Bhuvaneshwar
01.2012

Skills

  • Google SQL
  • SQL proficiency
  • Visual analytics
  • Stakeholder engagement
  • Data analysis
  • MS SQL
  • Teradata
  • Python
  • R
  • MS Excel
  • Tableau
  • Google Data Studio
  • Analyzing complex datasets

Rewards And Recognition

  • Received NPS scores of promoter for 4 consecutive quarters with following testimonials from Client: 'Merchant WBR: Built from scratch with cross collab across Fractal analyst that drives the merchant strategy and business cadence Merchant Value. For the first time we assigned a value to the consumer merchant flywheel. Breakthrough study Organic resurrection: V powerful insights.'
  • 'Amazing attitude to learn and deliver. Owned critical pipelines such as FOS Revisits, WBR and Feature table. These are very complex workflows with high impact on Merchant business.'
  • Participated in Fractal Roadshow competition showcasing Geo Clustering analysis bagging first prize.

Timeline

Senior Data Consultant

Fractal Analytics
01.2022 - Current

Consultant

Optum Global Solutions
01.2017 - 01.2022

Systems Engineer

Tata Consultancy Services
01.2012 - 01.2015

M.B.A - Finance

Xavier Institute of Management (XIMB)

B.Tech - Computer Science & Engineering

Institute of Technical Education & Research

Similar Profiles

CREATE PROFILE
Ankit Thakur