Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Generic

Ayush Sharma

Delhi

Summary

An MBA in business analytics and marketing with 4+ years of experience and a passionate business analyst/data analyst leading data-driven consulting Sales AI projects providing end to end solution for a diverse global hi-tech customer base with focus on sales enablement through diagnostic and predictive analytics.

Overview

10
10
years of professional experience

Work History

LEAD ASSISTANT MANAGER

ANALYTICS EXL SERVICES PVT. LTD
01.2023 - Current
  • Working in fraud front line unit under fraud analytics services umbrella for a major American bank supporting their debit card fraud strategy
  • Created fraud mitigation strategy rules implemented in Defense Edge by analyzing big data in
  • Impala/Hadoop using tools like SAS, SQL, Hive, Tableau and Python
  • Supporting various ongoing analytics projects under banking product Debit card ranging from signature, mobile wallet and debit pin products of the bank
  • Involved in created a bank wide policy rule on incorrect CVV mitigation resulting in gross fraud savings of $255K / month for the bank.

CONSULTANT

EMPLAY INC
05.2020 - 12.2022
  • Experience in managing end to end delivery of Sales AI and fraud analytics projects around enabling the sales function of the organization by providing guided support using predictive analytics and devising fraud mitigation models/strategies for BFSI clients
  • Have delivered Sales AI Strategy and Fraud Analytics projects for hi-tech large enterprises like
  • Google, SAP, ServiceNow, Zendesk and UiPath
  • Worked in customer use-cases around revenue operations, learning organizations and HR organizations
  • Worked on multiple projects like Manager Sales Coaching and Impact Analysis (Before-After analysis), where the business aim was to judge whether a sales representative’s performance has improved after a training program was conducted
  • As a part of DDL, DML for data collection and preparation activity, used Postgres SQL to write complex SQL queries using complex joins to fetch data from multiple data sources like
  • Salesforce CRM, HR, L&D taking good care of consistency property of the ACID to prepare an intermediate database ready for analysis
  • Worked with SQL functions like UNNEST, PIVOT, DATE, CAST and SQL window functions for data manipulation, transformation, and data crunching to create analysis output tables which formed an input to the visualization tools like PowerBI and Google Data Studio.
  • Wrote SQL scripts to calculate 50 + important financial/sales business metrics to judge sales reps’ performance like leading/lagging indicators, e.g., bookings pipe, partner attach rate, opportunities closed, win rate, revenue forecast, net revenue productivity, quota attainment etc
  • Making sure the data is segmented as per the business needs, and the analysis is only limited to the population under examination, utilized proper CASE and WHILE statements wherever required to filter and segment the data to fit business requirements
  • Created automated workflows in SQL scheduled to run at specified times in a particular order, to enable data refresh and be as close as possible to the latest extract of the data in source systems
  • The extracted, cleaned, processed, and analyzed was then fed as an input to data studio visualization tool through Postgres connectors and a visual summary report was generated
  • Generated EDA reports in python for better data/business understanding and to highlight any inconsistencies in the data
  • Good experience with MS Office tools like MS Excel, Word, and PowerPoint as a medium for data analysis and delivering executive presentations.

APPLICATION DEVELOPMENT ANALYST

ACCENTURE
10.2015 - 08.2017
  • Have worked as an SAP ABAP Developer in SAP Implementation and Upgrade projects
  • Roles and responsibilities included getting business requirements from SAP Functional, analyzing and giving suitable man hours needed for development, coding, unit testing and forwarding to the Quality Testing team
  • Worked on - Enhancements, Reports, Function Modules, SAP Scripts, Smart Forms, Customer and User Exits

Education

PGDM - Marketing and Analytics

SVKM'S NARSEE MONJEE INSTITUTE OF MANAGEMENT STUDIES (NMIMS)
2020

BTECH - COMPUTER SCIENCE

MAHARAJA AGRASEN INSTITUTE OF TECHNOLOGY
2015

Skills

  • Management Skills - Agile methodology, Stakeholder management, Client communication, Senior
  • Analytical Skills - Primary and Secondary Research, Data Analysis, Data Visualisation, Descriptive Analytics, Predictive Analytics, Regression Analysis, Sales Forecasting
  • Programming/Querying language – SAS, Python, R, Java, SQL
  • BI Tools - Google Data Studio, Power BI, Tableau, Looker

Accomplishments

  • Certificate in Java Programming Language using Java SE6 – Oracle
  • Certificate Program in Advanced Java Programming for Web Development - Oracle
  • The Complete SQL Bootcamp 2022 – Udemy
  • Innovating with Data and Google Cloud - Coursera
  • Analyzing and Visualizing Data in Looker - Coursera

Timeline

LEAD ASSISTANT MANAGER

ANALYTICS EXL SERVICES PVT. LTD
01.2023 - Current

CONSULTANT

EMPLAY INC
05.2020 - 12.2022

APPLICATION DEVELOPMENT ANALYST

ACCENTURE
10.2015 - 08.2017

PGDM - Marketing and Analytics

SVKM'S NARSEE MONJEE INSTITUTE OF MANAGEMENT STUDIES (NMIMS)

BTECH - COMPUTER SCIENCE

MAHARAJA AGRASEN INSTITUTE OF TECHNOLOGY

Similar Profiles

CREATE PROFILE
Ayush Sharma