EXL service
Total years of experience :10 years, 1 Months
Redesigning fulfillment process by leveraging Hive & Tableau for data understanding & visualization. Using SAS & R
statistical tools for solving customer challenges having exposure to Multivariate Analysis Techniques (Linear & Logistic
Regression, Factor Analysis, Cluster Analysis and Decision Tree Modelling) for data management exploratory analysis and
data visualization.
Roles and responsibility:
* Identify client’s strengths and weaknesses and suggesting areas where they can improve. Furthermore, after
suggesting a solution (or solutions) that will assist them, review and edit specific requirements, specifications,
business processes and recommendations to ensure the suggestion will be a successful as possible.
* Also develop functional specifications and system design details for a particular client. SAS, Hive & Tableau are
the most common tools used for the same.
* Synthesize and analyze information from various sources to identify trends, opportunities, and dangers.
Key Projects:
* Tableau Automation - Automating the already created dashboards to have minimal manual intervention for data
presentation in order to minimize the chances of error. The Tableau dashboards were created for the audience all
over the world interested in the anomalies in the payment ecosystem.
* Risk Analytics & Merchant Analytics - Developed dashboards which display comprehensive fraud statistics for
various Acquirer & Issuer Banks. Developed Dashboards which display transactional & geographical sales statistics
for merchants & benchmarked the merchants against their peers. Then identified prospective audiences or
customers for merchants based on these statistics.
* Segmentation Analytics‐ Using k‐Means cluster analysis developed a customer segmentation to define marketing
strategy by understanding its customer behavior so to have an enriched customer profile by having intelligent
KPI’s to gain insight on customer profiles
Proven analytical, problem solving, organizational and interpersonal skills with ability to engage and operate effectively
at all levels in the organization - from board level executives to internal and cross organization teams. Working with team
members & supporting them in preparing various data analysis & representation templates.
Roles & Responsibilities:
* Preparing variance analysis reports using R ‐ Profit Variances and Budget to Forecast Analysis.
* Compilation of data with Dashboard, with multiple graphs including customized filters & Charting events, using
Tableau for variance analysis & presenting the same to help analyze monthly results & budget.
* Providing reduced dataset reports using SAS which was used further for model building & validation tasks.
* Cut short the dataset & provide the important & relevant factors of the project along with the detail analysis of
the end result & predictions.
* Created summary reports of database tables using R for descriptive statistics.
Key Projects:
* Process Optimization - Using basic R codes, formatted and combined data in proper order. The idea was to
shorten the duration of completing a project by optimizing the process and automating admin tasks that can be
done with minimum supervision.
* Churn Management Analysis - Using Logistic regression technique, done a proactive churn management for a
telecom industry client to retain its existing customers. The idea was to use insights from the model to develop
an incentive plan for enticing would be churners to remain with the Company.
* Product Strategy and Pricing Policy ‐ Developed product strategy and pricing policy using linear regression for a
London based laptop retail chain. Recognizing the key drivers that affects the sales of the laptops.
Part of Anti‐Money Laundering division requires in‐depth analysis using advance excel extracting client information
associated for Transaction Filtering & query system to verify with Global Client Screening Database & performing Due
diligence.
Roles & Responsibilities:
* Skills include the interrogation of data using tools such as Excel & basic SQL queries in order to generate insight
to answer key business questions.
* Extraction of client’s payments information from pile of data using advanced excel skills & analyzing the same for
discrepancies with possible highest accuracy coupled with Backend tools such as world check, transaction system,
to bring out the results in different formats depending on the related parties (Internal as well as external parties).
Key Projects:
* AML - Transaction Filtering:
o Analyzing the routing of payment and Identifying Banks,
–
–