Sumit Pandey

Experience

• 

  Sitel India pvt ltd

  May 2013 - Nov 2013

  Health claim department

  -Coordination with other department and process initial approval of claim for customer in terms of cashless process when customer is visiting to network hospital-Handling customer query related to claim settlement process in terms of reimbursement process and cashless process-To create daily MIS report for all the claim settlement in terms of cashless claim and reimbursement claim.-Handled the customer query related to insurance claim and create a new opportunity in terms of sales by giving information of new product related to insurance. Show less

• 

  Citibank India

  Jan 2014 - Jul 2014

  Subject Matter Expert

  -Handled the customer complaints related to credit card,personel loan, home loan and banking complaints in terms of saving account and current account.-Interaction with customer related to their complaints and provide resolution within the turn around time.-Coordination with other department to the for customer in terms of personal loan and home loan-To create daily MIS report for all the complaints and loan related query and send all the report to business team.

• 

  Isobar india

  Jan 2015 - Jun 2015

  Quality Analyst

  Contract Job - Testing of website

• 

  IndusInd Bank

  Oct 2015 - Mar 2018

  Business Analyst

  -Responsible for making new dashboard and template in Advance excel as per business requirement- • Coordinate with various department and gather the information regarding the process requirement in term of functional and technical. • To create Business requirement document(BRD) or Functional Requirement document (FRD) based on business requirements. • Conduct JAD session, business and system review to understand the requirement and system design. • Coordinate with IT and development team to implement the requirements into the system. • Conduct various level of testing include functional testing, User acceptance testing(UAT), System integrations testing(SIT)and performance to verify business need are met. • Writing SQL queries and reporting the result to business team. • To write test cases by creating requirement traceablity matrix so that business requirement and functional requirement are mapped. • Liaise between business and technical department to ensure a mutual understanding of requirement for the process and application. • Well versed in making macro and template in excel for all type of excel data. • Fluent in technology of business process tools such as advance excel, MS visio, Microsoft office. Show less

• 

  Harjai Computers

  Jan 2019 - May 2019

  Business Analyst

  • Have work on enhancement project of ebranch which is related to life insurance • Gather the business requirement and create Business Requirement Document. • Create the process flow diagram and wireframe to make developer understand exact business requirement. • To write test cases by creating requirement traceability matrix so that business requirement and functional requirement are mapped. • Coordinate with testing team to perform the UAT testing before implementation of the product. • Hands on experience on tools like team foundation server(TFS) for bug tracking purpose Show less

• 

  Unistanz Software Private Limited

  May 2019 - May 2023

  Senior Business Analyst

  • Have worked on multiple project like new product, enhancement of existing product, revamping of existing product, minor modification and other application related changes • Coordination with business stakeholder to understand the business requirement and create the Business Requirement specification • Create wireframe as per the business need • Coordination with developer team to finalise the timeline of the project. • Performed UAT testing before implementation of product • Hands on experience on tools like Redmine for bug tracking purpose Show less

• 

  IndiaFirst Life

  Mar 2022 - now

  Senior Project Manager