SUMMARY:

• More than twenty - five years of experience in IT and the execution of multimillion dollar enterprise level projects.
• A record of consistent success in partnership with project management, development, business users and external customers for applications deployed in varied environments with minimal defects.
• Strong business analysis, systems analysis, project management and coordination skills including resource estimation, mentoring and test strategy preparation.
• Experience in Functional, Regression, Performance, UAT, and External Customer testing to support on time product delivery
• Testing of CDO Payment File Processing, Reports Validation in Crystal Reports and on Web
• Testing applications to support Continuous Integration and Continuous development process
• Web services testing using SoapUI and REST API testing using Postman, Mobile and Cross Browser Testing
• Worked with Business Users, Business Analysts, and Development teams to setup test data for applications with and without GUI front end using Shell Scripts, Python, Excel, and Backend Databases like Oracle, DB2, MS SQL Server 2014
• Manual test scripts in Version One, Quality Center and Confluence; Automation testing using QTP and Selenium WebDriver Automation Framework
• Defect management in Version One, ClearQuest, Quality Center and Jira
• Managed team test efforts, including Test Case execution and status reporting to stakeholders
• Experienced in working in delivering applications developed in Amazon Web Services Platform and Hadoop HQL and Hive
• Executed projects in Waterfall, Iterative, RUP, Agile Scrum, CMMI Level 3 environments

TECHNICAL SKILLS:

Business Software: MS Office, ClearQuest, ClearCase, Jira, SVN, VersionOne, Confluence, Quick Test Professional, Quality Center, Informatica, TSO, CICS, Toad, DOORS, Amazon Web Services (AWS), Crystal Reports, CDOSuite, Postman

Programming Languages/Protocols: Unix Shell and Bash Programming, C, JavaScript, Gherkin, Java SE8, VB6, VBScript, XML, FIXML, HTML

Operating Systems: UNIX, Linux, Windows, Main Frame OS

Databases: Oracle SQL, PL/ SQL, SQL Plus, HQL, Hive, PostgreSQL, DB2, Teradata, MS SQL Server 2014

PROFESSIONAL EXPERIENCE:

Confidential

Senior QA Analyst Consultant

Responsibilities:

• Responsible for testing CDO Payment Web Applications in Agile environment in a two week sprint cycle
• Review and participate in requirement refinement meetings for user stories, confirm Acceptance Criteria, and identify Acceptance Test scenarios with Business Users, BA and Development Teams support
• Develop Manual Test Scripts and associated SQL scripts with test steps and store in VersionOne;
• Test applications, identify and retest defects after delivery of product Continuous Integration and Continuous development process in real time
• Generate complex test data using the GUI Front End in CDOSuite and MS SQL Server 2014 SQL scripts
• Hands on execution of functional and UAT testing and generate defects during test execution in VersionOne and implement customer guidelines for defect management
• Partner with business team, product owner and Development teams to deliver application to production

Confidential

Senior QA Analyst Consultant

Responsibilities:

• Member of QA team responsible for delivering web based application to deliver the prices for Options on Futures Product in Agile environment in a two-week Agile sprint cycle
• Review and participate in review of business requirements, user stories, estimate story points, confirm Acceptance Criteria, and identify UAT test scenarios for delivery of new and Refactored products
• Review functional and development artifacts and identify testable requirements and generate Requirement Traceability Matrix mapping the business requirements to the test cases
• Generate Automation Test Scripts, for top priority business test scenarios, in Gherkin and save in Eclipse to be executed using Cucumber and document manual test cases as needed and save in Confluence
• Generate test data in Oracle using Oracle SQL and Front End GUI application
• Hands on execution of functional testing in both smoke and QA environments, regression testing, pre-production testing in Linux/Web platform including Shell scripts, testing API REST calls, and Oracle SQL queries in backend data validation
• Manual Testing of applications to support Continuous Integration and Continuous development process in real time after build is delivered by Development Team
• Generate defects and blockers during test execution in Jira and follow customer guidelines for defect management
• Partner with business team in setting up UAT test environment and support execution of UAT test scenarios and resolve any defects found using Jira
• Support Production Deployment Activities and document Test Results to follow customer test process in Confluence

Confidential

Senior QA Analyst Consultant

Responsibilities:

• Member of QA team responsible for delivery of Regulatory Surveillance Applications in Amazon Web Services (AWS) environment and Hadoop HQL and Hive
• Responsibilities include:
• Review the functional requirement specification document for identifying testable requirements and the gaps in the requirements
• Generate Test Plan, Requirement Traceability Matrix between test scenarios and functional requirements, Test Execution Results and Test Summary Report and maintain in Subversion
• Implement proprietary Automation Test framework software by developing test data to cover functional requirements, in an end to end test case for each requirement, and export to Amazon Web Services Cloud Platform using Python, XML and Linux scripts
• Download latest software build using Jenkins and verify and validate the functionality to support Continuous Integration and Continuous Delivery process, including REST API calls with Postman
• Execute the Automated functional, end to end, and regression test cases in Linux, AWS, Python, by using Oracle SQL Developer, SQLWorkbench (HQL), Hive and Postgresql
• Document the issues found as bugs and manage the defect triage process in Jira by providing supporting documentation for each bug and provide daily status report to management

Confidential

QA Lead Consultant

Responsibilities:

• Analyst and sourcing of data for Migration Project from Mainframe to Oracle/Informatica for Large Options Positions Reporting (LOPR) for Confidential Compliance management and delivery
• Member of scrum team responsible for quality of the product, in progress, being delivered to clients
• Documented business requirements after discussions with Business SME, data definition dictionaries and mapping documents
• Generate Requirement Traceability Matrix document to provide test coverage and map to both business and functional requirements using ALM Quality Center
• Work with Business SME to identify and setup test data for test execution from front office to back office including backend data validation in BETA Host Mainframe (CICS, DB2), Informatica, and Oracle 11g
• Hands-on verification and validation of ETL process for the project in ODS model on Oracle 11g which include:
• Creation and extraction from BETA Host of initial Option trades and modifications on a as of date, move to Linux systems and maintain the data format compliance between both systems
• Data stored in staging tables and transformed in Informatica to follow data format and business rules
• Data loaded in to Oracle tables after completing transformations is completed
• Validate LOPR reports generated in FIXML format and handled defect management in BMC Remedy
• Responsible for Verification and Validation of distinct types of LOPR messages as mandated in FIXML format for both Individual and In-Concert Accounts

Confidential

QA Lead Consultant

Responsibilities:

• Lead responsible for testing, with onshore and Offshore India teams, implementation of data migration and end to end strategy for the delivery of the new flag ship product in J2EE platform in Agile Scrum environment using Data Driven Test Framework
• Partner with Contract Negotiation team in developing Work Order Job Aid for identifying requirements, governance and scope for Result Based Work Order (RBWO) service providers
• Lead and manage the offshore/onshore team for documentation of detailed use cases, test scripts, and Requirement Traceability Matrix
• Manual testing of web application on Mobiles (iphone, Android, and Ipad) and Cross Brower Testing
• Responsible for supporting production deployment activities onsite, including process development to deploy software updates to meet client expectations
• Hands-on validation of the results, including backend Postgres data, provided by RBWO vendor of test results including web services with SoapUI and manage regression automation using Selenium scripts
• Work with development team to fix Java code to resolve and retest defects after Continuous Integration and Continuous Delivery by development team

Confidential

QA Lead Consultant

Responsibilities:

• Responsible for testing and sign-off of web applications for the Treasury Services Product
• Participate in Refinement meetings, develop requirement traceability matrix, and develop test strategy, test plans and project plans
• Manage offshore test team in India, including verify and validate test execution and results generated
• Analyze and develop test data via XML and hands-on testing of API Web Services with SoapUI
• Develop and test using Linux scripts and Oracle 11g SQL scripts, defect triage and status to management

Confidential

QA Lead Consultant

Responsibilities:

• Consultant for the Dept. of Interior working on project with a Public Trust Clearance in VB.net platform and MS SQL Server 2005.
• Developed system requirement specification and requirement traceability matrix.
• Test Front End GUI and backend SQL scripts in SQL Server 2005 and tracked progress in Numara Track-It

Confidential

Senior QA Analyst Consultant

Responsibilities:

• Responsible for architecting and performance testing of applications for the Mortgage Application and HAMP (Home Affordability Modification Program) using Ab-Initio as ETL tool
• Test schedule, Test Harness setup for Data conversion testing, develop test execution report scripts for pre-production testing using Linux, and Oracle SQL and PL/SQL and Toad for backend data validation
• Executed ETL batch jobs using Ab-Initio and AutoSys scheduler and validate the results using Crystal Reports and defect management in ClearQuest.
• Review and provide feedback for requirement document reviews in DOORS.

Confidential

Senior QA Analyst Consultant

Responsibilities:

• Responsible for Claim Locks project development effort using proprietary SDM process (SEI-CMM based) with responsibility to review refine business requirements, functional requirements, resource planning and estimation activities.
• Review/update system use cases, generate test scripts, lead and hands-on execution in Main frame and DB2 database environment using Rational Manual Tester and Defect Triage using ClearQuest
• Analysis and development and baseline the overall strategy, system/data conversion and parallel plans.

Confidential

Senior QA Analyst

Responsibilities:

• Functional testing of user stories for Web Applications with Postgres SQL scripts in Agile Scrum process.
• Used JIRA for defect management and prioritization.

Confidential

QA Lead Consultant

Responsibilities:

• Testing of Web applications and Anti-Money Laundering application working in an agile scrum process environment using mainframe COBOL/DB2 application and Fortent product.
• Responsible for Baseline and Test schedules for System Test and UAT Test strategy documents development and obtain signoffs from business and development stakeholders
• Lead report generation requirements efforts, Requirement Traceability Matrix in MS Sharepoint
• Developed Performance Test Plan and Managed Performance Test Team using LoadRunner
• Manage change requests for scope changes from business users in consultation with project manager
• Lead training sessions for teams in US and India in script execution, hands-on execution in Mainframe, UNIX, and Oracle database and defect triage with project team
• Develop automation test scripts using VBScript using a data driven automation framework in QTP

Confidential

QA Lead Consultant

Responsibilities:

• Analysis and development of Pepsi Operational Data Store database application in CMMI Level 3 process environment using Teradata database.
• Key QA reviewer in technical design reviews, in StarTeam and Caliber RM application.
• Responsible for generating Software Release documentation for field deployment as part of CMMI level 3 process compliance.
• Performed data validation and data loading using ETL scripts, UNIX Shell, Bteq, and Informatica.
• Validate bug fixes using Teradata Bteq, Unix, and Oracle PL/ SQL scripts using Toad, and SQLPlus.
• Test effort management in Quality Center, and defect status report to senior management team.

Confidential

Senior QA Analyst Consultant

Responsibilities:

• Manually created Credit Default Swap Assets, Credit Default Swap Index & Tranche Assets and Synthetic Collateralized Debt Obligation Tranches
• Test strategy development, writing manual and automation (QTP) test scripts, execution and defect management and report generation to management
• Creation and validation of test data based on traders, portfolios, tickers with Sybase and Oracle SQL queries and PL/SQL scripts Oracle databases
• Partnered with development team in debugging Java code for resolving the defects found during testing

Confidential

QA Manager/Lead

Responsibilities:

• Responsible for requirement generation, resource identification, testing of web and desktop health insurance applications and external customer relationship management with sign-off of Individual Medical Insurance billing application for Web and Desktop configurations
• Resource identification/allocation, interface with development teams using MS Excel and MS Project for tracking purposes.
• Responsible for monitoring and execution of Service Level Agreement (SLA) with external customers.
• Responsible for planning, documenting and manual and/or semi-automatic execution of use case review for development process within the desktop/Citrix and e-Commerce applications.
• Generated test data using Excel VBA scripts for semi-automated functions of application developed in .NET environment.
• Proof of concept delivery of Rational Robot scripts for development of web applications, saving approximately $100K in interval reduction and cost over a period of 6 months for a 3-member team.

Confidential

QA Coordinator

Responsibilities:

• Analysis of the requirements and use cases for delivery of large life insurance product.
• Lab resource management with lab architects, communicating requirements, workflow process improvement, form standardization and software distribution.
• Coordinated and prioritized system test planning, execution and status report to management

Confidential

Member Technical Staff (QA Analyst)

Responsibilities:

• Developed menu-driven application, using Unix Shell Scripts, simulating changing office environment for end-to-end functionality.
• Identified test strategy, write test cases, effort estimates, planning, hands-on and lead test execution efforts, defect management and delivery to external customers
• Experience managing SLA, including interactions with customers to delivering quality product in compliance with SLA resulting in savings of 2 THCM each of efforts for a 6-member team.
• Managed client expectations to generate win-win solutions. Saved 4 weeks of efforts for a team of 5 members (in different organizations) and savings of approximately $200K in fines not paid.
• SME level participation generating software process Improvements, including reusing existing processes
• Responsible for team compliance, including needed artifact generation for ISO 9001 certification