Summary
Overview
Work History
Education
Skills
Affiliations
Skillset wise Top Achievements
Timeline
Generic
Satyajit Choudhury

Satyajit Choudhury

Bangalore

Summary

Well versed in creating quick and sustainable solutions for Reporting, Analysis, and BI needs across all level of stakeholders in Sales and Customer Success Ops. Optimization of process steps, translating operational needs into technical solutions. Functional knowledge in Software Sales, Planning operation and Customer Success Operation along with technical knowledge in automation software and tools like Python, Power BI, Alteryx, VBA helps solving variety of operational needs. Looking out for additional opportunities to explore my knowledge in data science

Overview

12
12
years of professional experience

Work History

Lead Business Analyst

VMware India Pvt. Ltd
Bangalore
02.2014 - Current
  • Business Intelligence in Customer Success Operation
  • Data modelling and creation of Power BI dashboards
  • SQL to extract data from Presto DB using DBeaver
  • Python for data modelling in Power BI m query and Alteryx workflow
  • Process automation in Sales Operation (Bookings, Sales Opportunity, Sales Comission)
  • Reports and process automations using VBA and Advanced Excel
  • Front end report creation in SAP BOBJ
  • Sales Commission planning and credits
  • Customer cohort trial using data science methods

Senior Reporting Analyst

Oracle India Pvt. Ltd
Bangalore
12.2011 - 02.2014
  • Reports and Data Analysis for education sales
  • Oracle SQL to extract data and analyze using MS Excel
  • Automation of analysis using VBA
  • Front end report creation in Oracle OBIEE

Education

Post Graduate Program in Data Science And Business Analytics - Data Science

The University of Texas At Austin
Online
09-2021

Master of Computer Applications - Computer And Information Sciences

Sikkim Manipal University
Online
04-2011

Bachelor of Science - Mathematics

Assam University
Silchar, India

Skills

  • SQL, Python, Power BI, VBA, Advanced Excel, SAP BOBJ, Alteryx
  • Data Analysis
  • Requirements Gathering
  • Data Mining
  • Workflow Analysis
  • Operational Reporting
  • Operations Analysis
  • BI Tools Expertise
  • Github exposure

Affiliations

  • Gardening, Morning Walk, Badminton, Cooking

Skillset wise Top Achievements

  • Python
  • automated sales quote creation in PDF which involves information lookup from multiple tables including SFDC, data mining and complex process steps
  • automated a series of data downloading from Presto using SQL stored in text files
  • extracted data through API call and parsed the data.
  • Power BI
  • Created KPI dashboards for Senior management periodic reviews. Each visualization having underlying dataset for deeper analysis into any identified risks
  • Used m queries for data modelling including python. Used DAX for report measures
  • Published the report in server enabling dynamic RLS for 1000+ users
  • SQL
  • Built complex SQL queries to extract data joining multiple tables, removing duplicates etc
  • Alteryx
  • Joining data from multiple sources to transform into required format using Select, Filter, Formula, Data Cleansing, Sort, Join, Union etc
  • Leveraged Python coding within Alteryx workflow to overcome certain limitations of Alteryx
  • Have created 10+ workflows in Alteryx
  • VBA
  • Built a data reconciliation macro to evaluate the quality of Sales Opportunities closed by agents by comparing them with bookings data having many to many relationship. The automated has reduced manpower requirement by 9 headcount.
  • Functional Knowledge
  • Knowledge of Sales Ops domains like Sales Opportunity creation to bookings closure, bookings adjustment in terms of products and territory. Sales territory planning, compensation planning and compensation credit to Sales tree
  • Knowledge of Customer Success operations keys metrics like Risk Perspective, Consumption metrics, Time to Value, Churn, Renewal Rates etc. Have experience in accessing reports from Gainsight tool capturing details of customer journey.

Timeline

Lead Business Analyst

VMware India Pvt. Ltd
02.2014 - Current

Senior Reporting Analyst

Oracle India Pvt. Ltd
12.2011 - 02.2014

Post Graduate Program in Data Science And Business Analytics - Data Science

The University of Texas At Austin

Master of Computer Applications - Computer And Information Sciences

Sikkim Manipal University

Bachelor of Science - Mathematics

Assam University
Satyajit Choudhury