Chhavi Goel

Experience

• 

  Tata Consultancy Services

  Nov 2015 - May 2019

  Programmer/ Analyst

  Project 2: American Express (Gurgaon, client site) as Digital Analytics Strategy to increase Click through rate and decrease Cost per Approval in PPC and Media Channels.•Created SAS macros on SAS EG which can automate a regular task of creating intermediatery datasets•Worked in team engaged in devising acquisition strategy for search engine marketing channel in US & Int'l markets for credit cards.•Understood customer portfolio and its optimizations /dashboards were made using SAS code, Excel techniques and fetching data from Teradata.•Analyzed data of the various markets for measuring its performance on various parameters using SAS, excel•Marketing Analytics: Campaign tracking and assess against goals (ROI and KPIs)•POC of data handling on multiple google based platforms and internal databases like GoogleAdWords, Adobe Site CatalystProject 1: A.P Moller Maersk as SAS programmer/ Data analystThe environment had various applications to manage security standards of more than 50000 machines.•Transferred data from SQL database, MS Excel into SAS for analysis and used filters based on the analysis.•Cleaned data from missing values, redundant data and outliers and further analyzed for finding out the best suitable antivirus products for the machines and any bugs or vulnerabilities.•Used PROC LOGISTIC and other procedures for data analyses to forecast the possibility of a network record Show less

• 

  EXL

  Jun 2019 - Jan 2022

  Project 2: PNC Bank (Pittsburgh National Corporation, USA) as Portfolio Analyst / Data Analyst Student Loan Lending Portfolio Analytics, Reporting, dashboard Creating, Data crunching and data management.•Data cleaning, data crunching, data management of student loan lending portfolios like Performance and Originations Dashboards and many KPIs.•Pulled data from different sources and using Hive queries.•Used Tableau for dashboard creation and publishing them for the client.•Created reports using SAS codes, Excel and Tableau.•Created various decks for the client and worked on various ad hoc analytics requests.•Worked on Experian servers for bureau data like FICO, origination year, repayment trends, and losses. Show less Project 1: CitiBank (USA) as Credit Risk Analyst Model validation for risk and fraud identification, root cause analysis, mitigation and documenting.•Validated Probability of Default (PD), EAD, LGD models of different domains/areas like underwriting, acquisition, small business, and collections of the credit card segment of the bank.•Created advance SAS codes and macros for setting up models, their data extraction and trend analysis.•Macro-tised SAS codes for automation purpose and for quick and efficient processes.•Created many copyrighted documents of the bank comprising of the model validation results, triggers analysis, trend analysis, root cause analysis, new changes like portfolio/channel expansion, platform/browser changes, usage changes and many more.•Worked on Experian bureau data on their respective server for better insights on customer behavior, fetching bureau variables and proxy variables and also to find performance of declined population for underwriting models.•Recommended risks and shortcomings of many models to the policy makers and client, so that models can be revamped or replaced with a new being more suitable with today’s USA economy and an efficient machine learning technique.•Worked on many metrics like KS, PSI/CSI, MAPE, ROB, PDO results, rates, balances, losses and other regular statistics which are used in finding trend analysis and threshold breaches/triggers.•Presented results/trends/charts/dashboards on Tableau for better visualization. Show less

  • Lead Assistant Manager

    Jul 2021 - Jan 2022

  • Senior Business Analyst

    Jun 2019 - Jul 2021
• 

  NatWest Group

  Jan 2022 - now

  Business Data Analyst

  Data and Remediation Analyst (SAS- Base/Advance, Ms-Excel, Tableau, Hue, SQL, Python, Data Analytics, Research)• Prepared comprehensive and detailed documentation in Confluence of StreamSets pipelines built using Python.• Prepared monthly processes, built in SAS, Python, SQL, HUE/Hive, Teradata and Tableau, JIRA, also used for data quality, data management, KPI handling and customer profiling.• Also did, data loading via Teradata parallel transporter and SAS Data Integration.• Working on building pipelines using Python. As the existing SAS processes will be migrated to new platform, the research and building process is going side by side. Show less