SUMMARY:

• 8 years of Information Technology experience in Software Quality Assurance as a Test Lead, Test Analyst and Test Engineer implementing large and small projects/ programs which involve Mainframe, Unix, Informatica, Business Object reporting, Siebel UI, Java based UI, IBM Content Manager, IBM process server user interface, client/ server, web applications and services, Microsoft Office 365 Pro Plus upgrade, Visual Studio (SSIS and SSRS), Infrastructure upgrades - Active Directory and Exchange2010, Data Movement (Stage-Warehouse-Mart using Rapid SQL, SQL Server Management Studio), Reporting and wireless internet access testing on Mobile devices with iOS, Android and Blackberry OS 7 wireless access.
• In depth experience in both front-end and back-end testing.
• Detailed understanding of mainframe testing (JCL, COBOL, DB2 queries, SAS programs).
• Very good understanding and hands on experience in STLC which involves Unix, Informatica, Business Objects reporting, testing e-forms that involved IBM content manager, IBM process server, web services, query operation in Oracle, Sybase, SQL servers and testing experience with Microsoft Office 2007 and Office 365 (2013) version installation and integration with business applications.
• Experience on various testing levels like System functional, Integration (includes production parallel testing) and User Acceptance Testing. Good knowledge on Test Planning activities like estimation for small and large projects, creation and review of Test Plan, Test Strategy, Test Scenarios, Test Cases, Requirement Traceability Matrix, Test Environment set up and review, Risk Reporting, Review and Analysis, Test Result Reporting and Review, Defect Management, Communication and Coordination, Test Data Protection Plan and Post Test Analysis Report documents.
• Conversant with Waterfall, Iterative and Agile lifecycle models.
• Experienced with both White box and Black box testing methodology.
• Followed the testing types like Installation, Compatibility, Smoke and Sanity Testing, Integration, Regression, Acceptance, Functional vs. Non-Functional and Usability testing.
• Used service virtualization concept - design review, process flow, data set up and test execution review and reporting.
• Conversant with tools like QTP, Test Management tool like HP Quality Center/ ALM 11.0, Beyond Compare
• Adept in reviewing and analyzing the Business Processes and Business Process Flows. (Includes review of HLD, DLD, process flow diagrams on MS Visio, Data Definition documents for Stage, Warehouse, Mart)
• Managed and lead multiple projects independently with minimal supervision, and is able to mentor team members in business and technical analysis techniques, process, and procedures and proactively identify improvement opportunities for processes, systems, and interfaces.
• Trained in Rapid Improvement Event programs applicable for project management.
• In depth knowledge in Life Insurance domain.
• LOMA280 and LOMA290 certified.
• Ability to adapt and work in a fast paced, dynamic team environment, strong verbal and written communication skills
• Possesses strong skills in organizing and prioritizing tasks to ensure accurate completion of work within scheduled timeline, meeting deadlines and adjusting pace according to the changing volume of work or schedule.

TECHNICAL SKILLS SUMMARY:

RDBMS Servers: DB2, Sybase, UDB, MS SQL Server 2008/2005/2000 , Oracle 9i, 10g

Operating Systems: Windows 7, Windows 8, Windows XP, Z-OS, Mac OS X

Programming: Cobol, JCL, CICS, SQL, PL/SQL, Informatica: version 8 and 9, Unix, Visual Basic

Office Applications: MS Office Suite and Outlook 2007, MS Office 365 ProPlus, MS Visio, MS Project Planner, MS Live Meeting

Others: Rapid SQL, Business Object Reports, Siebel UI and DB, IBM Content Manager, Visual Studio 2010, VMware, QTP, HP Quality Center (Application Lifecycle Management 11.5), Beyond Compare tool, Sharepoint 2010

PROFESSIONAL EXPERIENCE SUMMARY:

Confidential

Test Lead / Migration Database Support Lead

Environment: Windows7 32bit, MS Office2007, MS Office 365 Pro Plus, QC-ALM for defect management, SQL server, MSBI suite

Responsibilities:

• Managed the SQL Database - Scheduling(Adding), Tracking(through query and reporting) and Updating of all AD, Exchange and Office migrations being planned and taken to completion for all Home Office and Field Respresentatives of the Organization.
• Used SSIS packages to handle complex operations and also used SQL (Rapid SQL) to update the database and manage the org-wide migrations that were planned for both Home Office and Field members.
• Identify all business applications during the business case phase of the project (both in Home Office and Field) that integrate with MS Office and are impacted by the upgrade. Engage respective teams for testing the application with the new version.
• Reporting on progress/ issues to senior management.
• Gathered the functionalities of the new version from the Microsoft technical repository. This activity was done during the business case phase of the project when Microsoft released the preview version of Office 365.
• Defect Management using Quality Center - ALM11.5
• Create and Review Estimates, Plan Strategy document.
• Apply Risk Based Testing approach methodology to select the applications (Top Tier, BCP critical, HO and Field image) for testing.
• Part of the project Governance team to help take decision and ensure remediation of applications that have incompatibility issues during testing or post migration.
• Part of Risk review team - To log, assess, provide inputs to help allocate the necessary budget and provide other probable suggestions to mitigate the risks.
• Worked in Rapid Improvement Process Events (RIE), that was planned as part of the Microsoft Collaboration Platform program.
• Coordinate the application testing, help set up test environment, track and report the testing Progress.
• Participate in pilot and final roll out deployment activities.
• Monitor and schedule Database updates for Migration of AD, Exchange and Office and generate daily reports. Coordinate with Offshore team to ensure proper communication and oversee daily (planned, adhoc and urgent) migration activities run smoothly.
• Status Reporting.

Confidential

Test Lead

Environment: Windows7 32bit, JRE v1.7

Responsibilities:

• Identify Java based business applications impacted by the upgrade and engage the application teams for testing the application with the new version.
• Documented functional requirements using interviews, document analysis, storyboards, business process descriptions, use cases, scenarios, gap analysis, task and workflow analysis, and/or viewpoints.
• Track, Monitor and Report project issues.
• Status report creation, review and publish.
• Created Estimate, Plan and Strategy document.
• Applied Risk Based Testing approach methodology to select the applications for testing.
• Co-ordinate and Monitor the application testing, review test results, defect management and ensure test result sign-off.
• Primarily responsible for ensuring service delivery while coordinating with Business Users, Technical and Quality teams.
• Coordinated with the infrastructure team in providing resolutions to issues, fixing bugs and daily updates on execution.
• Co-ordinate with technical team on various tickets, project based development request and defect resolution.
• Create Post Test Analysis Report.

Confidential

Test Lead

Environment: MS SQL server, Sybase, Data Warehouse, IBM content manager, IBM process server, web services (inquiry and update), Java based web UI, Informatica, Unix.

Responsibilities:

• Involved in testing the CLR UI designed for contracting financial representatives.
• Participate in meetings with third party vendors like BIG and FINRA to provide inputs towards an optimal solution for the process and design.
• Utilized technical knowledge like reviewing configuration changes and code changes to evaluate and propose different technical solutions.
• Worked on implementing the new tool for managing all the analysis related elements like requirements, use cases, traceability and test cases.
• Worked on multiple reporting projects as system analyst to define data mapping and report formats
• Perform service virtualization data set up and testing.
• Create Test Strategy.
• Review Test Scenarios and Test Cases.
• Coordination with Offshore team involved. Review the artifacts delivered by Offshore team.
• Create Test Execution Flow Diagram and give a walkthrough of the different tracks (Contracting, Licensing, Underwriting, Registration, Decision and Reporting) and integration points between the same.
• Test Data set up and review.
• User acceptance testing coordination.

Confidential

Technical Test Lead

Environment: IBM Compatible PC, iPAD, iPhone, Android Tablets and Android Mobile phones, Dell Laptop, Microsoft 2007, Windows7 32 bit, Mac OS

Responsibilities:

• Create Test Estimates, Test Plan and Strategy.
• Review Test Scenarios and Test Cases.
• Worked with developers to make sure that they understand the Use Cases and worked with quality control teams to develop Test Plans and Test Cases.
• Partnered with the technical areas in the research and resolution of system and User Acceptance Testing (UAT), Test Plans and documentation of test reports
• Lead with the quality assurance team so as to test different releases and to develop Test Plans and Test Cases
• Coordinated with the offshore team in providing resolutions to issues, fixing bugs and daily updates on changing design along with development
• Co-ordinate with technical team on various tickets based and project based development request and defect resolution
• Create Post Test Analysis Report.

Confidential

Test Lead

Environment: Windows 7 32 bit, Beyond Compare Tool

Responsibilities:

• Create Test Estimates, Test Strategy and Test Plan.
• Gather requirements from SME’s (Subject Matter Experts) on the different policy types and transaction types that need to be validated thoroughly.
• Co-ordinate with Offshore team for Test planning and Test execution activities.
• Review Test Scenarios, Test Cases and Test Data set up.
• Test Result Review and Delivery.
• Defect Management.
• Gather sign-off on all testing artifacts.
• Create Test Data Protection Plan.
• Create Post Test Analysis Report.

Confidential

Test Lead

Environment: IBM Compatible PC, VMware, Mainframe - DB2 and COBOL, Unix, Informatica - Version8 and Version9, Sybase, UDB, Siebel, Microsoft 2007

Responsibilities:

• Involved in analyzing the business requirements and creating system specifications based on requirements
• Developed test cases and scripts based on the Business Requirement documents and specifications.
• Actively involved and lead review meetings and client interaction.
• Reviewing Test Data, Actual results and reports.
• Coordinating the testing effort with offshore team.
• Issue resolution and tracking.
• Actively Involved in end user .

Confidential

Test Lead

Environment: IBM Compatible PC, VMware, Unix, Informatica - Version8 and Version9, Sybase, Microsoft 2007

Responsibilities:

• Test Strategy and Test Plan creation, Identify and document Test Scenarios and Test Cases.
• Reviewing Test Cases, Coordinating with Offshore team member for various testing/ verification activities.
• Worked closely with Production Managers, Technical Managers and Business Managers in planning, scheduling, developing, and executing the project
• Maintained requirements and created Traceability between Requirements, functional specifications, design documents and Test Cases
• Assigning data privilege to the users as per the position in the organization hierarchy.
• Review the Test artifacts, report and track defects till closure, Post-Test Analysis document creation.

Confidential

Test Lead

Environment: IBM Compatible PC, VMware, Microsoft 2007, Mainframe

Responsibilities:

• Test Strategy and Test Plan creation, Identify and document Test Scenarios and Test Cases.
• Reviewing Test Cases, Coordinating with different stakeholders (the different teams involved) for various testing/ verification activities in Mainframe (JCL and DB2)
• Responsible for developing Test Plans, Test Scripts and Test Cases using Test Director.
• Identified the Test Cases to be automated and lead the effort for automating the product using Quick Test Professional.
• Executed System, Integration, Functional, Data Validation and Regression testing of new and revised applications using Quick Test Professional.
• Responsible for creating and enhancing Test scripts by Creating Checkpoints, Synchronization points and Output values using WinRunner
• Responsible for carrying out Regression Testing to ensure that the new code has less or no adverse effect upon the current system, particularly in the area of corrupting data used by different applications or system performance

Confidential

Test Lead

Environment: IBM Compatible PC, VMware, Mainframe - DB2 and COBOL, Microsoft 2007

Responsibilities:

• Effectively communicated with Business Users for Data Requirement and Data Analysis Documents
• Test Strategy and Test Plan creation, Identify and Create test timelines, Reviewing Test Cases, Coordinating with different stakeholders (the different teams involved) for various testing/ verification activities - Coordinate the test execution and timeline with different teams impacted by this project.

Confidential

Test Lead

Environment: IBM Compatible PC, VMware, Mainframe, Unix Servers, Mainframe - DB2 and COBOL, Unix, Informatica, Sybase, csv files.

Responsibilities:

• Interacting with clients and gathering business requirements from business users.
• Involved in developing Test Cases for the User Acceptance Testing and documentation of the developed application
• Test data identification, Interacting with the Offshore functional team and reporting defects
• Reviewing Test Cases, Expected and Actual Results, Troubleshooting execution issues/ data set-up, offshore team coordination
• Test result reporting and review and defect management.
• Responsible for the testing of all customers issues and patch releases.
• Created custom checkpoints and test reports using the programming logic and QTP object model

Confidential

Test Analyst

Environment: SQL Server 2005, Oracle 10g, Access, .CSV Files, Windows 2003 Server, Unix, Informatica, Mainframe.

Responsibilities:

• Test Planning, Test data identification, Interacting with the functional team and reporting defects, Executing Test Cases, Updating Test Plans and Test Strategy, Test result reporting and Defect Management.
• Reviewing deliverables that include - Test Cases, Test Results and Reports.

Confidential

Test Analyst

Environment: SQL Server 2005, Oracle 10g, Access, .CSV Files, Windows 2003 Server, Unix, Informatica, Mainframe

Responsibilities:

• Conduct Test Requirement Analysis
• Responsible for developing Test Plans, Test Scripts and Test Cases using Test Director.
• Identified the Test Cases to be automated and lead the effort for automating the product using Quick Test Professional.
• Creation and review of Test Scenarios and Test Cases
• Requirement Traceability Matrix creation
• Test Data identification and test data set up
• Testing in mainframe, unix and informatica
• Execution of mainframe jobs (JCL’s), test scripts and ETLs

Confidential

Test Analyst

Environment: SQL Server 2005, Oracle 10g, Access, .CSV Files, Windows 2003 Server.

Responsibilities:

• Test Requirement Analysis
• Creation and review of Test Scenarios and Test Cases
• Test Data identification and set up
• Requirement Traceability Matrix
• Accessing Sybase tables for data set up and test result verification.
• Testing in Unix and Informatica
• Execution of test scripts and ETL’s
• Test result reporting and review
• Defect Management

Confidential

Test Analyst

Environment: SQL Server 2005, Oracle 10g, Access, .CSV Files, Windows 2003 Server.

Responsibilities:

• Involved in Regression and Functional Requirement Analysis
• Developed Test Strategy Preparation, Test Scenario and Test Case preparation
• Meet with customers and knowledge base coordinators to gather project requirements
• Requirement Traceability Matrix creation
• Test data identification and set up for testing in mainframe environment
• Preparing and submitting Mainframe Jobs (JCL’s)
• Accessing DB2 - Tables for retrieving data required for execution of the Test cases
• Test result reporting and defect management

Confidential

Test Analyst

Environment: SQL Server 2005, Oracle 10g, Access, .CSV Files, Windows 2003 Server.

Responsibilities:

• Involved in analyzing the business requirements and creating system specifications based on requirements.
• Developed test cases and scripts based on the Business Requirement documents and specifications
• Reviewed Test plans, Patch request documents
• Created custom checkpoints and test reports using the programming logic
• Strong debugging and development skill on PL/SQL
• Testing in mainframe environment
• Preparing and submitting Mainframe Jobs (JCL’s)
• Accessing DB2 - Tables for retrieving data required for execution of the Test cases

Confidential

Test Engineer

Environment: SQL Server 2005, Oracle 10g, Access, .CSV Files, Windows 2003 Server.

Responsibilities:

• Responsible for gathering requirements for different solicitations and business processes Test Strategy Preparation
• Test Scenario and Test Case preparation
• Maintained requirements and created Traceability between Requirements and all other project artifacts
• Coordinating work with other technology groups to ensure end-to-end functional integrity.
• Provide daily operational support to ensure systems are functioning properly and take corrective measures if necessary
• Testing in mainframe environment
• Preparing and submitting Mainframe Jobs (JCL’s)
• Accessing DB2 - Tables for retrieving data required for execution of the Test cases

Confidential

Test Engineer

Environment: SQL Server 2005, Oracle 10g, Access, .CSV Files, Windows 2003 Server.

Responsibilities:

• Responsible for developing Test Plans, Test Scripts and Test Cases.
• Identified the Test Cases to be automated and lead the effort for automating the product using Quick Test Professional.
• Executed Functional and Regression testing of revised application.
• Responsible for creating and enhancing Test scripts by Creating Checkpoints, Synchronization points and Output values using Win Runner.
• Regression Testing to ensure no adverse effect upon the current system.
• Test data identification and set up.
• Testing in mainframe environment for reports.
• Preparing and submitting Mainframe Jobs (JCL’s).
• Accessing DB2 - Tables for retrieving data required for execution of the Test cases.