Summary
Overview
Work History
Education
Skills
Accomplishments
Hobbies
Timeline
BusinessAnalyst
Kumari Sangita Singh

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
Kumari Sangita SinghBusiness Analyst