Senior Consultant
ERNST AND YOUNG
Keywords
Python
SQL
SAS
Analysis
Django developer
Ruby On Rails
Vue JS
React React Native TypeScript HTML5 Java Script CS
Magento certified Developer
IoT Cloud
Data Architecture
ReactJS Backbone.js
React / Redux
saas expert
Flask / Django
Flutter App Development Company
Flutter Expert
Android & iOS
Three.js
nextjs
Skills
SAS, Regression, Programming, SAS 9, SAS 8.1/9.1/9/2/9.3/9.4, SAS Guide, R, SQL, PL/SQL, C, Python -3.6, Hypothesis testing, Linear, Logistic/Linear regression, ANOVA, CHAID, decision trees, Univariate, Bivariate analysis, Segmentation, KNN, Forecasting, Database, DB2 IBM Mainframe, MS SQL Server, SAS Enterprise Guide, E4O (Internal Tool), MS Office Suite, analytics, Cluster Analytics, Factor Analytics, Logistic Regression, Multivariate, Machine Learning, algorithm, Markov, Random Forest, space complexity, python, data science, big data, sentiment analyzer, sentiment analyser, markov chain, AMPL, open source, SQL server databases, data warehouse, Data Analysis, data-mining, ETL, DWH, PowerPoint reports, Excel, SAS 9.1 programming language, SQL queries, SDLC, Integration Testing, Enterprise Guide, HTML, Java Script, Sas Eminer, Oracle Suite, Matplotlib, decision tree, machine learning algorithm, PowerPoint, Advance SAS
Project history
10/2016
-
01/2021
Accountabilities:
* Head Implementer of Analytics-CoE for Government of Rajasthan for DOIT, Government of Rajasthan
* Enterprise Intelligence & Analytics (EI&A) Lead for Implementation of Analytics project in
government sector for Excise/CTD/IGRS department.
* To identify the revenue leakages, Compliance and Process Optimization.
* Use of statistical techniques to propose amendment to the existing policy for example
reissuing of licenses based on the performance evolution against forecasted sales.
* Interaction with client on regular basis to map the client requirements in terms of feasible
work which includes identifying KPI, and providing client feedback to the developers to
implement those.
* Analysis various scenarios and realizing opportunities to apply analytical solution in real
world. Presenting the outcome of the analytical methodologies in simple and lucid language
which could be understand and implemented by the client easily.
Achievement:
* Helped the department in analysing present policies and use the model output in devising out the
new policies
* Head Implementer of Analytics-CoE for Government of Rajasthan for DOIT, Government of Rajasthan
* Enterprise Intelligence & Analytics (EI&A) Lead for Implementation of Analytics project in
government sector for Excise/CTD/IGRS department.
* To identify the revenue leakages, Compliance and Process Optimization.
* Use of statistical techniques to propose amendment to the existing policy for example
reissuing of licenses based on the performance evolution against forecasted sales.
* Interaction with client on regular basis to map the client requirements in terms of feasible
work which includes identifying KPI, and providing client feedback to the developers to
implement those.
* Analysis various scenarios and realizing opportunities to apply analytical solution in real
world. Presenting the outcome of the analytical methodologies in simple and lucid language
which could be understand and implemented by the client easily.
Achievement:
* Helped the department in analysing present policies and use the model output in devising out the
new policies
08/2013
-
01/2021
Assistant Manager
LUMATA DIGITAL INDIA (P) LTD.
Accountabilities:
* Part of ENGAGE- a vertical which use data science methodologies to invent client solutions002E
* Accountable to lead a team of 5 resources in a project for enhancement to the campaign model of
O2 by involving Segmentation/Profiling and focusing the approach towards tapping problem of low
customer engagement.
* Managing the transition of process/data from the SQL server databases to the new E4O (internal
system) and developing the SAS data warehouse for accumulation of data on daily basis
* Responsible for eliciting business/system requirements & providing the customers with best
solutions involving evaluation & definition of scope and finalization of project requirement.
* Involved in over sight of large amount of daily telecom transactional data by developing in-house
macro programmes that validated the data different levels while handled pre-planned Analyses, BAU
Reports as well as Ad-hoc Analyses Requests
* Spearheading resource allocations and deployment of the communication channels across the various
horizons of the organization structure.
* Supporting coordination with Onsite Team via teleconferencing for preparing of the monthly deck
and presenting to the client, both presentations & project progress, when needed
* Conducting review meetings to monitor progress of the project as per schedule/budgets, ensuring
timely completion and delivery of project to the client.
* Performing daily team administration routines as well as team development and people management
activities to improve team productivities.
Achievement:
* Interfaced with Products Group & provided extremely useful feedback, resulting in marked
improvement of capabilities
* Part of ENGAGE- a vertical which use data science methodologies to invent client solutions002E
* Accountable to lead a team of 5 resources in a project for enhancement to the campaign model of
O2 by involving Segmentation/Profiling and focusing the approach towards tapping problem of low
customer engagement.
* Managing the transition of process/data from the SQL server databases to the new E4O (internal
system) and developing the SAS data warehouse for accumulation of data on daily basis
* Responsible for eliciting business/system requirements & providing the customers with best
solutions involving evaluation & definition of scope and finalization of project requirement.
* Involved in over sight of large amount of daily telecom transactional data by developing in-house
macro programmes that validated the data different levels while handled pre-planned Analyses, BAU
Reports as well as Ad-hoc Analyses Requests
* Spearheading resource allocations and deployment of the communication channels across the various
horizons of the organization structure.
* Supporting coordination with Onsite Team via teleconferencing for preparing of the monthly deck
and presenting to the client, both presentations & project progress, when needed
* Conducting review meetings to monitor progress of the project as per schedule/budgets, ensuring
timely completion and delivery of project to the client.
* Performing daily team administration routines as well as team development and people management
activities to improve team productivities.
Achievement:
* Interfaced with Products Group & provided extremely useful feedback, resulting in marked
improvement of capabilities
03/2017
-
04/2017
Senior Consultant
Ernst and Young LLP
Project Predictive Analytics using Sas Eminer to Forecast Liquor Sales
Organization Ernst and Young LLP
Duration March'17 - April'17
Team Size 3
Environment Sas Eminer, Oracle Suite
Role Senior Consultant
Responsibilities * Identifying the key important variables which impacts the sale of liquor
*
* Creation of a Time Series model which predicts the expected sales of the customer
* Comparing this with the actual sale of the liquor with the predicted value to filter out
possible levy of excise duty.
Organization Ernst and Young LLP
Duration March'17 - April'17
Team Size 3
Environment Sas Eminer, Oracle Suite
Role Senior Consultant
Responsibilities * Identifying the key important variables which impacts the sale of liquor
*
* Creation of a Time Series model which predicts the expected sales of the customer
* Comparing this with the actual sale of the liquor with the predicted value to filter out
possible levy of excise duty.
02/2017
-
03/2017
Senior Consultant
Ernst and Young LLP
Project Predictive Analytics using Sas Eminer to Formulate policy of price change of liquor brand
Organization Ernst and Young LLP
Duration Feb'17 - March'17
Team Size 4
Environment Sas Eminer,Decision Trees, Random forest ,Matplotlib to see visual effect Techniques in Python
Role Senior Consultant
Responsibilities * Understanding the impact on the sales of a particular brand with respect to the change in the
price of that Brand.
* * Listing all the important variables like no. of time the price have changed in a single
year,price per bottle etc.
* * The formulation of a decision tree for each brand which help in deciding wheter the department
should go ahead with the price change introduction.
Organization Ernst and Young LLP
Duration Feb'17 - March'17
Team Size 4
Environment Sas Eminer,Decision Trees, Random forest ,Matplotlib to see visual effect Techniques in Python
Role Senior Consultant
Responsibilities * Understanding the impact on the sales of a particular brand with respect to the change in the
price of that Brand.
* * Listing all the important variables like no. of time the price have changed in a single
year,price per bottle etc.
* * The formulation of a decision tree for each brand which help in deciding wheter the department
should go ahead with the price change introduction.
01/2016
-
10/2016
Assistant Manager
Lumata Digital Private Limited
Project Churn management of O2 customer at service level as well as physical churn
Organization Lumata Digital Private Limited
Duration Oct'16 - Jan'16
Team Size 3
Environment Advance SAS, SQL Work Bench,E4O(Internal Tool)Excel, & PowerPoint
Role Assistant Manager
Responsibilities * The operator was having a huge churn both at service level as well the complete movement of the
customer to a competitor.
*
* There was a attrition model proposed to arrest the future attrition by predicting the customer's
probability to move out. We prepared a logistic model to ascertain the probability of the
customers and worked on the basis of cut-off level
* * On the basis of prediction by model, customers with high risk were put on specialized churn
prevention campaigns.
Organization Lumata Digital Private Limited
Duration Oct'16 - Jan'16
Team Size 3
Environment Advance SAS, SQL Work Bench,E4O(Internal Tool)Excel, & PowerPoint
Role Assistant Manager
Responsibilities * The operator was having a huge churn both at service level as well the complete movement of the
customer to a competitor.
*
* There was a attrition model proposed to arrest the future attrition by predicting the customer's
probability to move out. We prepared a logistic model to ascertain the probability of the
customers and worked on the basis of cut-off level
* * On the basis of prediction by model, customers with high risk were put on specialized churn
prevention campaigns.
01/2015
-
10/2015
Assistant Manager
Lumata Digital Private Limited
Project Enhancement to the campaign model of O2 by involving Segmentation and Profiling
Organization Lumata Digital Private Limited
Duration Jan'15 - Oct'15
Team Size 5
Environment Advance SAS, SQL Work Bench,E4O(Internal Tool)Excel, & PowerPoint
Role Assistant Manager
Responsibilities
* Led a team to create a focussed approach towards tapping problem of low customer engagement.
Since the contract with O2 is Loyalty management and we are paid based on the number of
redemptions done by the users, a fresh approach which could boost up the redemptions was needed.
* * The redemption was very low at ~ 18% which has resulted in unhappiness with the client. We
created far more Sauvé Segments and targeted those customers with intuitive campaigns.
*
* Besides the segment approach, we also try to cater to the need of the user with special
customized offers like data, Smartphone device customer, people who joined recently(whole
lifetime of customer was monitored with special campaigns at every stage.)
Organization Lumata Digital Private Limited
Duration Jan'15 - Oct'15
Team Size 5
Environment Advance SAS, SQL Work Bench,E4O(Internal Tool)Excel, & PowerPoint
Role Assistant Manager
Responsibilities
* Led a team to create a focussed approach towards tapping problem of low customer engagement.
Since the contract with O2 is Loyalty management and we are paid based on the number of
redemptions done by the users, a fresh approach which could boost up the redemptions was needed.
* * The redemption was very low at ~ 18% which has resulted in unhappiness with the client. We
created far more Sauvé Segments and targeted those customers with intuitive campaigns.
*
* Besides the segment approach, we also try to cater to the need of the user with special
customized offers like data, Smartphone device customer, people who joined recently(whole
lifetime of customer was monitored with special campaigns at every stage.)
07/2012
-
08/2013
Senior Analyst
Fifth Third Bank
Project Marketing Analytics & Consulting, Predictive & Logistic Regression Model
Client Fifth Third Bank, U.S.A.
Duration Jul'12 - Aug'13
Team Size 7
Environment Advance SAS, Excel, & PowerPoint
Role Senior Analyst
Responsibilities * Led a Project Team of analysts engaged in cross-selling & up-selling models and providing
information & analysis to support their business decisions across their product portfolio
* * Conducted Requirement Scoping, Data Analysis, Decision Science Support, Management Reporting &
Strategic Research
* * Set up a Center of Excellence by working closely with US based leading retail bank (WIP)
* * Segmented customers based on their needs for cross-selling & up-selling various products
* * Predicted the attrition of customers and targeted customers with prioritized/relevant offers
Client Fifth Third Bank, U.S.A.
Duration Jul'12 - Aug'13
Team Size 7
Environment Advance SAS, Excel, & PowerPoint
Role Senior Analyst
Responsibilities * Led a Project Team of analysts engaged in cross-selling & up-selling models and providing
information & analysis to support their business decisions across their product portfolio
* * Conducted Requirement Scoping, Data Analysis, Decision Science Support, Management Reporting &
Strategic Research
* * Set up a Center of Excellence by working closely with US based leading retail bank (WIP)
* * Segmented customers based on their needs for cross-selling & up-selling various products
* * Predicted the attrition of customers and targeted customers with prioritized/relevant offers
08/2011
-
08/2013
Senior Programme Analyst
INDUCTIS INDIA (P) LTD.
Accountabilities:
* Led a team of 7 resources n a couple of business analytics solution development projects for
international clients engaged in cross-selling & up-selling models
* Managed to lead the team of analysts to provide information & analysis to support their business
decisions across their product portfolio.
* Responsible to Requirement Scoping, Data Analysis, Decision Science Support, Management Reporting
& Strategic Research while interacted closely with the client to understand the business & data
requirements.
* Involved in import of data to SAS datasets, understanding of the data, application of cleansing
rules & validation rules and performed all data-mining tasks.
* Spearheaded generation of valuable insights from the data by segmenting and profiling the sample
and then providing actionable recommendations having high business impact.
* Supported deployment of a Center of Excellence by working closely with US based leading retail
bank and used Univariate Analysis and Bivariate Analysis to find target segments from the
population
* Conducted pre-planned analyses prepared BAU as well as Ad-hoc Analyses Requests along with
development of a Regression Linear Model to arrest the attrition of customers.
* Performed daily team administration routines as well as team development and people management
activities to improve team productivities.
Achievement:
* Received accolades from on-shore team for successful implementation of Cross sell and Attrition
model for US Bank
* Led a team of 7 resources n a couple of business analytics solution development projects for
international clients engaged in cross-selling & up-selling models
* Managed to lead the team of analysts to provide information & analysis to support their business
decisions across their product portfolio.
* Responsible to Requirement Scoping, Data Analysis, Decision Science Support, Management Reporting
& Strategic Research while interacted closely with the client to understand the business & data
requirements.
* Involved in import of data to SAS datasets, understanding of the data, application of cleansing
rules & validation rules and performed all data-mining tasks.
* Spearheaded generation of valuable insights from the data by segmenting and profiling the sample
and then providing actionable recommendations having high business impact.
* Supported deployment of a Center of Excellence by working closely with US based leading retail
bank and used Univariate Analysis and Bivariate Analysis to find target segments from the
population
* Conducted pre-planned analyses prepared BAU as well as Ad-hoc Analyses Requests along with
development of a Regression Linear Model to arrest the attrition of customers.
* Performed daily team administration routines as well as team development and people management
activities to improve team productivities.
Achievement:
* Received accolades from on-shore team for successful implementation of Cross sell and Attrition
model for US Bank
08/2011
-
04/2012
Senior Analyst
British Gas
Project Statistical & Operational Analytics
Client At British Gas, U.K.
Duration Aug'11 - Apr'12
Team Size 7
Role Senior Analyst
Responsibilities * Interacted closely with the client to understand the business & data requirements and devised
sound approaches to address the underlying business objective
* * Imported data to SAS datasets, understood the data, applied cleansing rules and validation rules
and performed all data-mining tasks
* * Worked on pre-planned Analyses, BAU Reports as well as Ad-hoc Analyses Requests
* * Reported the SAS output and designed & delivered analytical reports
* * Generated valuable insights from the data by segmenting & profiling the sample and providing
actionable recommendations having high business impact
* * Conducted various concurrent tasks while managing prioritization of tasks that came from multiple
business partners
Client At British Gas, U.K.
Duration Aug'11 - Apr'12
Team Size 7
Role Senior Analyst
Responsibilities * Interacted closely with the client to understand the business & data requirements and devised
sound approaches to address the underlying business objective
* * Imported data to SAS datasets, understood the data, applied cleansing rules and validation rules
and performed all data-mining tasks
* * Worked on pre-planned Analyses, BAU Reports as well as Ad-hoc Analyses Requests
* * Reported the SAS output and designed & delivered analytical reports
* * Generated valuable insights from the data by segmenting & profiling the sample and providing
actionable recommendations having high business impact
* * Conducted various concurrent tasks while managing prioritization of tasks that came from multiple
business partners
08/2010
-
07/2011
System Development Specialist
ACS XEROX
Accountabilities:
* Managed ETL operations for DWH/BI solutions & reports, using ETL tools to load and extract the
data based on client requirement & integrated large amount of data from varied sources/platforms
and analyzed the same in SAS to present in PowerPoint reports or Excel dashboards which served as
the final deliverable to the client.
* Managed ETL operations for DWH/BI solutions & reports, using ETL tools to load and extract the
data based on client requirement & integrated large amount of data from varied sources/platforms
and analyzed the same in SAS to present in PowerPoint reports or Excel dashboards which served as
the final deliverable to the client.
05/2007
-
08/2010
Senior Batch Technical Analyst
Hewitt Associates India Pvt. Ltd.
Accountability:
* Managed a team of 4 resources for development & support of SAS Programs in terms of development
of codes to extract, clean & validated (ETL) data from tables.
* Responsible to implement various logics involved behind data loading, client reporting and data
manipulations using SAS 9.1 programming language and SQL queries.
* Involved in analysis of the client requirements, drafting og SDLC approach to resolve issues as
well as supported Production Environment (failures in job streams and defects).
* Spearheaded execution of workflow and Defect Management with Ongoing Delivery Group (ODG).
analysing the cause of the defect, identifying the best solution, implementing it and testing to
confirm results.
* Provided execution of testing of the code, which included Unit & Integration Testing and
Regression Testing.
* Performed daily team administration routines as well as team development and people management
activities to improve team productivities.
Achievement:
* Received Premier Team award for Client DuPont revamp of their HR process in October 2009
* Recipient of Extra Miler award for Client contribution in August 2009
* Awarded Tier 2 in March 2009
PROJECT SUMMARY (SELECT)
Project
Creation of Feedback Mechanism to update the status on the evasion detected
* Managed a team of 4 resources for development & support of SAS Programs in terms of development
of codes to extract, clean & validated (ETL) data from tables.
* Responsible to implement various logics involved behind data loading, client reporting and data
manipulations using SAS 9.1 programming language and SQL queries.
* Involved in analysis of the client requirements, drafting og SDLC approach to resolve issues as
well as supported Production Environment (failures in job streams and defects).
* Spearheaded execution of workflow and Defect Management with Ongoing Delivery Group (ODG).
analysing the cause of the defect, identifying the best solution, implementing it and testing to
confirm results.
* Provided execution of testing of the code, which included Unit & Integration Testing and
Regression Testing.
* Performed daily team administration routines as well as team development and people management
activities to improve team productivities.
Achievement:
* Received Premier Team award for Client DuPont revamp of their HR process in October 2009
* Recipient of Extra Miler award for Client contribution in August 2009
* Awarded Tier 2 in March 2009
PROJECT SUMMARY (SELECT)
Project
Creation of Feedback Mechanism to update the status on the evasion detected
Local Availability
Only available in these countries:
India
