Summary of Experience

• 4.5 Rich Business / Testing and Test Analyst in Manual, Automation and Functional testing which believe will add value to your operations. Exposure in QA methodologies and expertise in all types of SDLC testing process - Manual Testing (Black box Testing), Unit testing, Integration testing, System testing, Regression Testing.
• This experience encompasses a wide range of Databases, web based technologies, Mainframe techniques and TBA tools mainly for U.S Defined Benefits domain. Worked on Database testing, GUI and Web testing.
• Experienced in leading the team for Analyzing the requirement,Testing Strategy design, Test Plan Preparation and Test execution and tracking of defects to closure.
• Experienced in Analyzing Client Requirements, design/configuring client's databases using DB2, Web Pages, Estimating QA Metrics.
• Proficient in the data manipulation using SQL for the retrieval of data from the relational database.
• Involved in User Acceptance Test planning and designing UAT test cases.
• Experienced in Configuration and testing of Client/Server, GUI and Web-based Applications.
• Interaction with the Onsite team and QA Manager regarding release status updates and defects.
• Construct and organize requirements, configuring provisions, create and execute test sets, monitor defects, and use graphs, reports and metrics to track the success of a project using the Benefits Administration Tool TBA
• Well versed in Defect Tracking & Bug Reporting and Analyzing the production defects, provide the high level analysis and Reporting using Quality center.
• Has good domain knowledge of U.S Defined Benefits
• Worked in Agile Software development methodology.
• Proficient in MS word and MS Excel.

Work Experience:

Company : Confidential
Designation : Functional System Analyst.
Duration : Oct 2006 to May 2011

Educational Qualifications

Bachelor of Engineering. in Electronics and Communication Engineering

TECHNICAL EXPERTISE

Operating Systems

Windows '95, Windows NT, Windows 2000

Tools

HRO Workbench, Total Benefits Administration(TBA), CONTROL-D, YBR, CM Synergy, SQL,AQUA generator, Quality Center.

Exposure:

Technology
Platforms used

Business Platforms

Domain

Job Functions

SDLC,SQL, GUI, YBR (Web), Middle Office, DB2 SPUFI - ADB2,CICS,

Lotus Notes, HRO Maestro

U.S Defined benefit

Requirement Analysis, Coding, Testing, Production Support, On-site Coordination, and Client Communication

Trainings Participated

• Participated in training on Quality Standards conducted by company.
• Participated in a training on "Personal and Interpersonal Effectiveness" conducted by company.

Credentials

• 2 - On the spot Awards for Performance Excellence.
• Achieved Extra miler Award for Performance Excellence.
• Client Appreciations for Customer Support

Company profile
Confidential, is the largest Financial Service firm in the world. Hewitt delivers a complete range of Automated Finance solutions, including Banking and Insurance , Market Investments ,HR Outsourcing, to the employees of more than 300 Companies of Fortune Five Hundred Companies.

Domain Description

Worked on Aon Hewitt's ERP package - T.B.A (Total Benefit Administration) with DB2 as back end on Mainframe platform.

• Configuration of the TBA system based on client specifications, which includes - Analysis, Customization, Test Planning, Testing, Debugging and supporting the production environment to develop a fully functioning system.

T.B.A -Tool which uses the existing COBOL code for creating functional logic as per the benefit requirements provided by the employer to their employees.

• Allows the employer to calculate benefits of the employee based on the portfolio of investment selected by the employee.
• Calculates, maintains and manages the total funds under an employee portfolio and calculates benefits as per the US Government rules accordingly.
• Enable the employee to simplify the benefits process by allowing the services to manage and maintain records of accounts and funds.

Hewitt's Clients have their own unique web Portal 'Your Benefit Resources' for their employees to access, create and manage the benefit estimates. Hewitt provides services that enable Active, Retiree and Term Employees to enroll in their benefits and Spending A/c, Change their Plans, Enrollment of dependent and beneficiaries and make Payments for their benefits through a web portal and IVR.

MAJOR PROJECTS ACCOMPLISHED:

Project: USERRA and Service Calc testing
Client: Confidential,

Description:
USERRA and pre 88 service project consisted of complex calculation provisions and working on this task required in depth knowledge of provisions. I went through the requirement documents, understood the big picture, made transition of knowledge from my onshore team. Later I mentored the complex provisions to additional resources, made them to perform spreadsheets, clarified their questions, in addition to working on my part. I did the challenging role of mentoring, managing, clarifying and self working for the two projects simultaneously and single handily.

In this project I have also involved in GUI testing to detect if application is functionally correct. GUI Testing includes how the application handles keyboard and mouse events, how different GUI components like menu bars, toolbar, dialogs, buttons, edit fields, list controls, images,Panels etc. reacts to user input and whether or not it performs in the desired manner.

Achievements:

Promoted as Functional System Analyst.
Got Impromptu and Extra miler Award for successfully completing this project.

Project: YBR 5.9 Implementation
Client: Confidential,

Description:
This Project Involves in implementing and upgrade of YBR. Analyzing the system and creating the configuration guidelines, designing the test plan containing the appropriate test cases which will test the system configured and finally reviewing the testing done. All these are web based testing which have a high visibility to the client as well as the end users and hence requires vast domain knowledge and high potential debugging skills.

Achievements:
Got appreciation for completing the project with high quality and on time.
Project: FAP Calculation testing
Client: Confidential,

Description:
Final Average Pay (FAP) remains the most common type of defined benefit plan offered in the United States. In FAP plans, the average salary over the final years of an employee\'s career determines the benefit amount. This project is to test the FAP value that returns in both GUI and YBR (Web-portal) testing. I went through the provision documents, took part in a training, understood the FAP calculation formula and performed the spreadsheet calculations.

Achievements:
Achieved Spot award for identifying and fixing various defects.
Promoted as Senior Setup Configuration Analyst

Project: YBR Testing Project (Web application)
Client: Confidential

Description:
YBR is the web based tool by which the participants can estimate the retirement income, Retire, Enroll
in various Health benefits and invest in different plan which their employer offers. This project is to test the various fields of YBR after the enhancement is done. Testing various fields of YBR for all kinds of event flows and making sure that the new version of YBR is compatible with the older version and providing enhanced features that can be easily accessed by the US Employees.
In this project I have involved in functional testing, Database testing, Usability & Interface testing, Performance and Security testing.
Achievements:
Got appreciation for completing the project with high quality and on time.

Domain Knowledge:
I have also Worked in projects related with 401(k) plans, Beneficiaries, Roth IRA, Employments status, Notices, QDRO, Eligibility dates. GUI, YBR, PCS and Manual calc testing. Worked in Retirement, Death and Termination flows.

Professional Experience

Project Type

Reviewing Requirements, Coaching, Project tracking and Reporting, Deployment

Role

Functional System Analyst

Client

Confidential

Duration

January 2011 - May 2011

Responsibilities:

• Understanding Client Requirements and creating Analysis Change document containing the new Client requirements. Reviewing client requirements and perform gap and/or impact analysis.
• Establish plans, processes, standards, and procedures to ensure that they fit the project's needs. perform Impact analysis.
• Design test plans (unit, Integration, regression, acceptance) and incorporate recommended updates into test plans.
• Reviewing analysis and test plan documentation and evaluate the results of test execution.
• Coordinating the work of aligned setup analysts, monitor task completion, and communicating with the team
• Involved in system configuration and Integration testing.
• Involved in UAT planning and designing UAT test cases.
• Quality checking the PCS forms.
• Involved in Deployment Process - Involved in Planning, Executing, Communicating, Verifying, and Signing of.
• Supporting the production environment (defects and trends) and defect management.
• Involved in Coaching the team members technically about the system and existing work flow and processes to quickly bring them up to speed.
• Supporting the team in project planning activities, in evaluating risks, and shuffle priorities based on unresolved issues.
• Communicate status of various projects to on-site team and to the reporting head.
• Performed Database testing and Interface testing to check the data integrity while maintaining and updating the web application and GUI.
• Ensure that all the test cases are updated in the Quality Center along with Master test plan.

Project Type

Analysis , Test planning & Issue Resolution

Role

Senior Setup Configuration Analyst

Client

Confidential

Duration

January 2008 - December 2010

Responsibilities:

• Reviews client requirements document and identifies needed configuration to meet the client requirements
• Studying and applying the SDLC model to gather requirements and configuring client side systems according to client requirements and specifications.
• Tailoring the TBA as per the Analysis Doc.
• Used tool named Middle Office by Sefas to generate Personalized Communication Statement (PCS) for the employee of the US based client.
• Customizing Client website (YBR) by using tool eTBA
• Running and debugging of JCL Jobs used to implement the Defined Benefits practice for the client.
• Report Generation and checking the PCS output online using Control-D.
• Creating Test File Extracts (TFE) in a database and inserting that generation group data in other database.
• Error Resolution by analyzing the error logs in CICS region.
• Developing test plans as per the client requirement for both manual and automated testing by reviewing the client requirements and preliminary test plans.
• Preparation of Unit and Integration test plan based on the requirement.
• Participate in defect prevention and process improvement activities.
• Also, involved in a peer review process which includes both testing and technology.
• Documentation, tracking of unresolved issues, ensuring SDLC adherence across the tasks done by the team.

Project Type

Configuration & Testing Projects

Role

Setup Configuration Analyst

Client

Confidential

Duration

October 2006 - December 2008

Responsibilities:

• Setup and Configuring table's parameters in TBA system as defined by analysis using proprietary systems and tools.
• Execution of the test plans both by manually and automated tool (ECHO-Hewitt Specific) in both GUI and WEB.
• Worked on both Integration and Regression testing.
• Testing their benefit amount using hand calcs and raising defect for CE team(Calc Engine - A system used to calculate their payments)
• Identifies/Creates test participants, Executes test plan and documents results, Creates issues as needed when the actual results are not as expected.
• Perform the first level of analysis on the defect encountered.
• Documentation and Reporting the defect to the Support Team.
• Analyzing and Debugging the issue.

Declaration:
I hereby declare that all the information supplied above is true to the best of my knowledge.