Kumari Sangita Singh
Business Analyst
Summary
- 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
Ravenshaw University
08.2014 - 07.2017
12th -
Holy Cross School
05.2012 - 05.2014
10th -
Kendriya Vidyalaya
03.2011 - 04.2012