Senior Business analyst

Ankit Gupta

Hartford, CT 480-***-**** *****.*********@*****.***

A motivated, dynamic and solution focused business analyst with rich 10+ years of IT experience in entire SDLC.

Extensive Business Systems Analyst experience includes working in Agile, non-Agile models with strong SQL skillset in Life Insurance and Healthcare domains.

Work Experience

Senior Business Systems Analyst - Hartford, CT

Computer Sciences Corporation (CSC) – Oct’2014 - Present

Client(s): Global Atlantic Financial Group (GAFG)

•Identified complex data and prepared mapping documents from the source system to the target system and guided other System Analysts to do the same.

•Prepared Functional Requirements/BR documents, led the change request management and prioritized features.

•Provided project objectives and scope definition, use cases, workflow diagrams and screen mockups.

•Co-ordination with different internal & external teams i.e. Business Analysts, Development, testing and other vendor teams.

•Led rollout of complex projects by cross-functional team collaboration, data analysis and driving issue resolution.

•Analyzed the ‘As is’ and recommended the ‘To be’ scenario for Policy admin system.

•Develop and document data definitions, use cases, quality standards and business rules.

•Prioritized and assigned the service requests coming from client and helping the technical team in delivering the right solution in order of changing client priorities.

•Collaborated project planning: goal setting, scoping, managing stakeholders and vendors, resourcing and setting timelines.

•Led the product backlog grooming and change request management in an agile environment.

•Developed use cases/user stories using Rally and coordinated their implementation and delivery in a two-week sprint model.

•Review of the estimations based on the signed-off requirements and if any deviation getting the approval from the business and review of the project plan or time lines.

•Guiding the technical design discussions between technical architecture and Scrum team to guide the team to achieve requirements.

•Status Reporting (Daily/Weekly status report) with internal and external stake holders.

Conducting Sprint demo to Visa IT and business stake holders.

Tools/Domain Products Used: - JIRA, wmA (Wealth Management Accelerator), Vantage, Product Wizard, Performance Plus, MS-office, Output manager/ACORD mapper.

Technical Environments: IBM DB2, SQLs

Business System Analyst - Hartford, CT

Computer Sciences Corporation (CSC) - Sep' 2010 to Sep'2014

Client(s): Presidential Life Insurance co., Phoenix Life Insurance co., Lincoln Financial Group, Pacific Life

wmA customization: Latest version of wmA v10.01 was customized per the client’s requirements and delivered at client’s location.

Stored Valuation: This project was part of the first outsourced project of VANTAGE-ONE for PacLife. Work required optimizing the existing production system running for closed block policies, for the client by calculating the valuation of all policies at a certain point in time. Research into the client’s system for best solution, proof of concept, finalizing the solution and developing it were the major tasks.

Terminated Master File (TMF): Implemented the enhancement (retrofitted enhancement from base system). This project required archiving old policies from the client’s database, so that the production cycle time is saved from processing old policies daily.

Roles’ Processing: Designed the solution in Life insurance Agent commission system Performance Plus (Pplus), to distribute commissions to agents having multiple roles in different hierarchies.

Develop and document data definitions, use cases, quality standards and business rules.

Created mapping documents for interfacing systems.

Prepared Life cycle models for the existing and new To-be system.

Designed and tested the complex modification supporting Premium Bonus recapture.

Developed Requirement specifications with continuous discussions with client.

System Analysis of the changes across wmA, online screens, and the interface Service Manager, and database changes.

Testing: Unit, Impact, System, UAT support, full iterative system Testing.

Delivery and post-delivery support.

Correspondence enhancement: Design the system to enable correspondence to client’s customers.

Created mapping document and maps in XML Gateway designer per ACORD standards.

Carried out Proof of Concept.

Tools/Domain Products Used: JIRA, wmA (Wealth Management Accelerator), Vantage, Product Wizard, Performance Plus (Pplus), Universal Life, Traditional & Annuities products, XML Designer, ACORD mapping.

Technical Environments: IBM DB2, SQL, QMF

Application Dev/System analyst

Computer Sciences Corporation (CSC) - 2008 to Sep'2010

Client(s): Phoenix Life Insurance co., Sammons Financial Group

Goal was to develop a new system in Mainframe replacing existing system.

Project required both business knowledge and technical knowledge of Performance Plus. Analysis of old system, in business terms, laying down business scenarios and modifying them to include current and new business requirements of the client. Creating mapping documents.

The work included enhancements, database conversion, new transactions setup thru JAVA online interface and sent to Mainframe for processing, and then return the control to JAVA. Development and testing done on Mainframe Express (MFE) and installation done on Mainframe z/OS.

Creating Tech designs, Coding, code reviews, Testing: unit, production parallel, system, UAT, Delivery.

Requirement gathering for conversion by directly talking to client Business Analysts and Managers.

Analysis and Design of system.

Creating test plan and test data.

Handled entire Conversion of the database: Requirement analysis, design, coding, testing and delivery.

Testing: unit, production parallel, guiding client how to carry out UAT.

Delivery and installation.

Post implementation production support.

Part of the team standardizing the installation and setup of NEX environment on client’s server.

Successfully integrating the subsystem to the existing production cycle.

Knowledge transfer to the client for understanding the new system.

Environment/Tools:- Mainframe, MFE (Mainframe Express), Service layer, Intertest, File manager, Endevor, $AVRS, QMF, CICS, VSAM, DB2, z/OS

Domain Products Used: - wmA (Wealth Management Accelerator), Vantage, Product Wizard, Performance Plus

Asst Systems Engineer (Programmer Analyst)

TATA Consultancy Services (TCS) – India 2006-2008

Client(s): Phoenix Life Insurance co.

CERTIFICATION Scrum Master

LOMA FLMI-1 (U.S. Insurance domain certification)

EDUCATION Bachelor of Engineering (2005), Rajiv Gandhi Technical University, India.

ADDITIONAL INFO

Core competencies

Scrum, Agile, Co-ordination offshore/onshore.

Business Requirement gathering/Analysis, Test plans, Testing, UAT, System Analyst, Life Insurance products, Team co-ordination/facilitation.

Life Insurance domain products: Vantage, wmA (Wealth Management Accelerator), ACORD (XML Gateway), Pplus (Performance Plus)

Software development-Tech design, coding, testing, implementation, defect resolution, maintenance, production support, interfacing systems.

Technical

Languages: COBOL, JCL, SQL, DOS Scripting, CICS

Tools: JIRA, Intertest, File manager, Endevor, $AVRS, QMF, SPUFI, Changeman, Xpediter.

Platform: Mainframe Z/OS, Net Express, Mainframe Express

Database: IBM DB2, VSAM

Contact this candidate