KIRTIKA MEHTA
Senior Analytic Consultant
Banglore
Summary
Dynamic and results-driven Data Analyst with over 8 years of experience in data analytics and reporting, seeking a challenging role within a reputable organization to leverage expertise for mutual growth and success. Proven ability to maintain high-quality standards in fast-paced environments, complemented by strong leadership, problem-solving, and project management skills. Exceptional communicator adept at building relationships across all levels of business, thriving in dynamic settings while remaining focused and pragmatic. Proficient in SAS, including Base SAS, PROC SQL, and SAS Macros, alongside a solid understanding of Tableau for effective data visualization.
Overview
9
9
years of professional experience
4
4
Certifications
Work History
Senior Analytic Consultant
Wells Fargo
03.2022 - Current
- Domain: Auto, Home lending,Cards
- Customer accounts mature during the 10-day period the payoff quote provided may contain an inaccurate amount of interest owed, this could result in a paying amount larger than what is owed on their post maturity. Portfolio Analysis Understanding the Credit Business, Market scenario and behaviour of customers in segments to identify and create the target population for the credit card campaigns and performing Ad-hoc analysis. Creating Ad-hoc reports for Complete Transaction Analysis. Understanding the Credit Business, market scenario, and behaviour of customers in segments to identify and create the target population for the credit card campaigns a performing ad hoc analysis. Creating ad-hoc reports for complete transaction analysis, card holder analytics. Need to resolve bugs by using jira tool and need to confirm finding or observation review and mark as complete every subtask followed by business procedure. Developed and automated statistical models for predicting customer payment behavior post maturity in auto lending and home lending domains.
- Responsible for Working in the Following Modules: -
- Customer Remediation Reporting for home lending on Monthly & Quarterly.
- Roles and Responsibilities:
- Importing all the required data sources from Excel, CSV, Teradata into Isasgrid based on the requirement documents.
- Involve into the exploratory analysis to identified additional data sources required to process the business requirement.
- Analysis the data that are coming from data sources by using Data validation, Data cleaning and Data manipulation as per requirements.
- Calculate the loan foreclosure status based on the customer payments.
- Calculate the monthly report for the remediated customers including over remediations.
- Generate reports either in HTML, EXCEL, PDF or RTF formats according to requirements.
- Extensive use of SAS Procedures like PROC SQL, PROC SORT, PROC FREQ, PROC MEANS, PROC CONTENT, PROC SUMMARY, PROC RANK, PROC APPEND, PROC COPY to perform analysis of the datasets using queries, joining and altering.
- Professional Experience
CAPGEMINI
08.2020 - 02.2022
- Credit Banking Management
- Project Description: Improving operational performance by analyzing client’s information technology controls on finance and risk management.
- Extract raw data and create SAS data sets that are required for project analysis.
- Cleaning and sanity of data using data step and SAS base procedures, validating sorting, and merging techniques include Macros and SQL.
- Churn Analysis of the data and generate the reports in the form of Pie Chart, Bar Graph.
- Generate HTML, Listings and Excel reports for presenting the findings of various analysis by using Proc Print along with SAS ODS.
- Automating various regular reports using Macros.
- Analyzing the data coming from multiple data sources and performing data validation, Data cleaning & Data manipulation by SQL, SAS function and Excel.
- Writing efficient codes from scratch on Ad-hoc requests using PROC FREQ and using various Charts of TABLEAU for various Reports.
- Project Description
Global logic technology
11.2016 - 08.2020
- Creating Dashboards & Reports with decent graphics and publishing using Tableau Desktop, Tableau Server.
- Excel Skills using Functions/Formulas, Pivot Tables, H Look-up & V Look-up etc.
- Pre-processing of data, data extraction, validation & manipulation, removing duplicates.
- Need to apply various sanity checks for improving the efficiency of data.
- Project Description
Education
B. Tech - Computer science
Uttarakhand technical University Dehradun
01.2016
High School Diploma -
UBTER Roorkee
01.2013
Skills
Sas ,Macros
Certification
Certificate in SAS from Coursera.
Disclaimer
I am confident of my ability to work as an individual and as a team. I hereby declare that all the above mentioned facts and information are true to the best of my knowledge and belief.
Timeline
Senior Analytic Consultant
Wells Fargo
03.2022 - Current
CAPGEMINI
08.2020 - 02.2022
Global logic technology
11.2016 - 08.2020
B. Tech - Computer science
Uttarakhand technical University Dehradun
High School Diploma -
UBTER Roorkee