Vrushali Shah
Pune
Summary
9+ years of experience in analytical domain including Statistical Predictive Modeling, Quantitative Analysis, Data Preparation and Data Engineering. Strong exposure to statistical and analytical tools such as Alteryx, SQL and SAS. Excellent communication & presentation skills, seeking a challenging role that leverages my statistical expertise and analytical skills to contribute to innovative projects.
Overview
13
13
years of professional experience
1
1
Certification
Work History
Senior Associate
BNY Mellon
02.2023 - Current
- Automation of daily IOA, NOS and Custody reports via Alteryx
- Manual effort of 2 FTEs for 2 hours daily saved
- Alteryx workflow designed which runs in 2-3 minutes
- Datasets setup in Data Enterprise Platform (EDP) to store these datasets on a regular basis
- Views created in Denodo to pivot these datasets for trending and creating dashboards in ThoughtSpot
- Automation of Governance Reporting saving 80 hours of manual work weekly
- Developed SQL queries to extract items and exception data from Data Enterprise Platform (EDP)
- Designed Alteryx workflow depicting complex logic of governance reporting which takes 2-3 mins to run
- Collaborated with cross-functional teams to define project objectives, requirements, and deliverables.
Senior Consultant
Capgemini
10.2019 - 01.2023
- Tier inconsistency between HUB and NET, within NET at account level and at profile level is checked by designing workflows
- Inconsistencies are reported to local GMs for resolution(if HUB tier is wrong then NET is corrected and vice a versa)
- HUB data is then loaded into client margins by using profile to tier mapping
- Ad hoc requests from local GMs or Client Margins to identify Customer names, account numbers, LOBs, GHO codes for customers is handled in alteryx by making simple workflows
- Preparing migration document to migrate data into Client Margin
- Retail Convergence – testing of UAT and PROD data
- Preparing data for regulatory reporting
- Creating packages to identify delta between monthly data
- Querying data in hive and SQL to identify and report mismatches.
Lead Analyst
BNY Mellon
05.2017 - 01.2019
- Redesigned existing Alteryx workflow models to improve efficiency and realized an 85% time improvement by leveraging SQL coding and more advanced database tools available within Alteryx
- Provide actionable insights through usage of Analytics which includes predictive models using machine learning models, diagnostic analysis, descriptive analysis etc
- Lead a team of Analyst and data engineers, Part of business development discussion with Clients and Stakeholders
- Assistance with database management efforts to load, extract, maintain and transform data from Hadoop and SQL
- Sqoop commands to load data from SQL to Hadoop in an automated fashion.
Consultant
Maxima IT Consulting
12.2014 - 05.2016
- Responsible for handling analytical projects for IT domain like using t test to check performance before and after applying any IT process
- Monitoring IT processes by control charts like Run charts, IMR charts and Gantt charts
- Conducted exploratory data analysis on large datasets, identifying key patterns and trends to guide business strategy.
- Analyzed problematic areas to provide recommendations and solutions.
SAS Analyst
NettPositive Business Analytics Pvt. Ltd.
06.2014 - 11.2014
- Build logistic regression model in SAS with 90% accuracy to predict whether existing saving account customer will buy loan from the bank by study past 18 months data
- Performing statistical analysis and data management on study data by utilizing appropriate statistical methods using SAS procedures like PROC TRANSPOSE, PROC FORMAT, PROC SUMMARY, PROC MEANS, PROC TABULATE, PROC SQL, PROC PRINT and SAS tools
- Presenting statistical reports using the appropriate graphs, charts, tables and written reports for banking/financial domain
- Develop new macros for report generation using SAS/Macros as per the customer's requirements.
Sr. Practitioner - Analytics
IBM Daksh Business Process Services Pvt. Ltd.
04.2013 - 06.2013
- Making production reports in excel by extracting data from MS- Access
- Making claims request reports in SAS/EG.
Associate Biostatistician
GlaxoSmithKline
07.2010 - 07.2012
- Statistical analysis plan and table figures and listings of clinical studies and epidemiological studies
- Statistical analysis and producing brief statistical report for clinical, epidemiological and interim clinical studies
- QC of SAS programs according to Organization Standard of epidemiological studies, time trend analysis and pooled analysis
- Review of clinical study report for epidemiological and clinical studies.
Education
M.Sc. in Statistics -
Pune University
Pune, Maharashtra04.2010
Skills
- Strong Analytical Thinking
- Effective Communication
- Team Collaboration
- Attention to Detail
Additional Information
- Alteryx
- SQL
- SAS
Certification
- IBM Certificate on Data Science
- SAS Programmer by Coursera
- Data Visualization and Communication with Tableau
Timeline
Senior Associate
BNY Mellon
02.2023 - Current
Senior Consultant
Capgemini
10.2019 - 01.2023
Lead Analyst
BNY Mellon
05.2017 - 01.2019
Consultant
Maxima IT Consulting
12.2014 - 05.2016
SAS Analyst
NettPositive Business Analytics Pvt. Ltd.
06.2014 - 11.2014
Sr. Practitioner - Analytics
IBM Daksh Business Process Services Pvt. Ltd.
04.2013 - 06.2013
Associate Biostatistician
GlaxoSmithKline
07.2010 - 07.2012
M.Sc. in Statistics -
Pune University
Similar Profiles
ANKUR WADHEANKUR WADHE
Associate I at Bank of New York Mellon (BNY Mellon)Associate I at Bank of New York Mellon (BNY Mellon)
Vishal TilwaniVishal Tilwani
Associate, AML/Prevention/KYC Representative at BNY Mellon (Bank of New York Mellon)Associate, AML/Prevention/KYC Representative at BNY Mellon (Bank of New York Mellon)
Sonali VetalSonali Vetal
Associate Quality Engineer at BNY Mellon TechnologyAssociate Quality Engineer at BNY Mellon Technology