Offering a combined experience of around 2 years in Credit Cards, data analytics, database creation, MIS & reporting, process design and business excellence.
A data enthusiast with analytical and understand real problems and to come up with logical business driven solutions.
Experienced in SAS, SQL, MS EXCEL, Macros and Tableau.
Having Experience in automation to build and find opportunities to reduce human intervention in processes.
Overview
3
3
years of professional experience
9
9
years of post-secondary education
Work History
Business Analyst
EXL Service
Noida
09.2021 - Current
Supporting fortune 500 US bank, credit card portfolio and data management department in insight generation and analysis of the performances, product profit and loss, credit card trend report, delinquencies, charge offs, sourcing and program monitoring using SAS for data extraction
Developing SAS programs to load raw data from different database, applying business logics and storing data sets to be used by business users for reporting, decision making and Adhoc requests
Partnering with client to understand business requirement and providing them solution using advance analytics
Developing code and excel reports for monthly Interchange analysis, using monthly credit card transaction data.
Improved business direction by prioritizing client and implementing changes based on collected feedback.
Reporting Analyst
EXL Service
Noida
10.2020 - 10.2021
Create monthly and weekly Excel Reports for Retail Analytics
Code Automation using SAS
Tableau Refresh and developing dashboards
Developing and changing reports time to time according to client requirement
Digital Automation: Automation of group of codes fully using macros in SAS
Creating Quality check codes, to check if data is above limits or below limits.
Prepared monthly ad hoc reporting in alignment with client needs.
Maintained ongoing schedule and documentation for all reporting procedures.
Intern
EXL Service
Gurugram
01.2020 - 07.2020
Introduction to SAS and training
Collaborated with team to optimize workflow and achieve objectives.
Introduction to banking and credit card process flow.
Identified issues, analyzed information and provided solutions to problems.
Analyzed problems and worked with teams to develop solutions.
Completed research, compiled data and assisted in timely reporting.
Education
10th -
Kendriya Vidyalaya
Bokaro
03.2011 - 04.2012
12th -
Holy Cross School
Bokaro
05.2012 - 05.2014
Bachelor of Science - Information Technology and Management
Ravenshaw University
Cuttack
08.2014 - 07.2017
Masters in Computer Application - Computer Applications
National Institute of Technology
Jamshedpur
08.2017 - 07.2020
Skills
Microsoft Excelundefined
Accomplishments
EXL's Data Analytics Rapid Training Program(Great Learning)
Duration: 08/2020 – 01/2021
Course Description: Introduction to Excel, Data Analytics using SQL, Data Analysis using SAS, Data Analytics using Tableau, Python trainings.
Hobbies
Listening and Collecting songs
Art and Crafting
Travelling
Photography
Timeline
Business Analyst
EXL Service
09.2021 - Current
Reporting Analyst
EXL Service
10.2020 - 10.2021
Intern
EXL Service
01.2020 - 07.2020
Masters in Computer Application - Computer Applications
National Institute of Technology
08.2017 - 07.2020
Bachelor of Science - Information Technology and Management