We provide IT Staff Augmentation Services!

Sr. Qa Test Analyst / Sr. Test Lead / Offshore Coordinator Resume

Downtown -, NyC

Professional Summary:

Over ten years of hands on experience to streamline, implement the best practices of the Software Quality Assurance with a professional approach to align the project to the organization goals. A hands-on manager who owns, practice System, Functional, Regression, application controls testing, usability testing and Performance testing methodologies. Works closely together with business to identify problems, analyze the root cause analysis and suggest appropriate mitigation based on the critical nature of the problem. Specialized in testing techniques of Data warehouse applications involving ETL, ODS, EDW, EDM using star schema, dimensions involving cross-platform Client/Server, Java J2EE (GUI) and Web based applications.

Highlights:

  • Extensive experience in reviewing and understanding of Business & Testing requirements and writing detailed Test Plans, Test Cases, Test Scripts.
  • Executed full test lifecycle projects on Banking (Retail/Commercial), Finance, Insurance(Whole / Term products), Card products, Healthcare claims management projects for end to end testing of the complex business processes and system integration..
  • Excellent exposure to various software Development Life Cycle (SDLC), documented the test requirements, tracked the requirements throughout the phases of test lifecycle such as Requirements, Analysis/Design, Development and Testing and part of implementing RUP, CMM, TQM, ISO 9001 best practices in full test lifecycle projects.
  • Experience in developing Test Cases using the Business, user and technical requirements and handled large projects with more than 100,000 test objectives.
  • Strong technical knowledge of QA process including system, functional, performance, regression and integration testing.
  • Hands on experience in Black Box Testing and creating generic, reusable, efficient and effective automated Test Functions and Scripts in QTP.
  • Performance testing expertise in developing Performance Test plans, Test Strategy, Load Modeling, Performance Metrics and Performance Analysis.
  • Worked extensively on File-Aid for mainframe DB2, VSAM and flat files and have used SPUFI for extracting and validating the data against the Verisk to meet the IVV project requirements using Hummingbird as 3270 emulator.
  • Hands on programming skills in legacy applications, VB.NET, C, C++ and Java and have excellent understanding of J2EE Architecture documentation.
  • Experienced in scripting for RDBMS like Oracle/SQL, Server 2000/ MS Access, mainframe database testing using SQL Scripting and employed tools such as SQLPLUS, DBVisualizer for test automation for claims management related to dental, revenue and member testing.
  • Experience in GUI, Functional, Regression, Performance, Load and automation testing of the application using QTP.
  • Worked on performance testing of the web applications using IIS 5.0 & IIS 6.0 with LoadRunner and analyzed in-depth report and graphs mainly (VUser Graphs, Transaction Graphs, Web Resource Graph, and Network Monitor Graph).
  • Extensively used of Microsoft team foundation, Quality Center / Test Director and Clear Quest for Defect Tracking and have integrated Clear Quest with MSProject to manage the day-to-day project management tasks.
  • Excellent Documentation Management and Presentation skills for the complete QA Project Team including Test Plan, Test Case Specs, Test Requirement, Test Case Matrix and Defect Reports.
  • Worked with fellow QA managers to carry out the best practices and lessons learnt and provided them to Quality management group and drive process improvements across the organization during mergers/acquisitions, new product development and migration/conversions.
  • Worked as a trainer for PMP aspirants and have mentored associates on projects resulting in excellent performance of the associates.
  • Participated in the vendor evaluations for tools selection and have managed test vendors in a distributed and matrix environment.
TECHNICAL SKILLS:

Software development methodologies: Waterfall, Agile/Scrum software development methodology

Requirements Management Tools: IBM Rational tool RequisitePro UML and Use Case Modeling, Homegrown RTM-IS tool Quality Center / Test Director

TeleLogic Doors: Version / Document /Change management Mainframe source control using Change Man, Endeavor

Visual Source: Safe, Atlassian Confluence, Share Point for document management Managed Remedy Tickets for production support change requests

Eclipse IDE and integrated: Maven for software deploymentsCVS – Open Source version control tool:

  • Mainframe technologies: CICS,COBOL, DB2,TSO,SPUFI,JCL,EasyTrieve, CA-IDEAL
  • Windows Application Languages: Java J2EE, .Net 1.1 framework, ANT scripts integrated with Maven
  • Presentation skills: Microsoft Office products
  • Data Warehousing and ETL tools: ETL, OLAP, OLTP, COGNOS (reporting framework),

VERISK reporting for Data Cubes, Business Objects:

  • Web Technologies and Data Sharing tools: HTML, IIS 5.0,IIS 6.0, DHTML, XML, CSS, WSDL, JSP
  • Testing Tools: QTP, LoadRunner, JMeter (open source tool) Quality Center / Test Director, RTM-IS tool, DBVisualizer, Atlassian JIRA SQLDeveloper, Micro Strategy V8, SQLPlus
  • Application Deployments Eclipse IDE: Maven, ANT scripts for major deployment projects
  • Business Process Management tools: Scorecards, Homegrown tools for Project Dashboard development.
PROFESSIONAL EXPERIENCE:

Confidential, Downtown - NYC

Sr. QA Test Analyst / Sr. Test Lead / Offshore Coordinator

Responsibilities:
  • Responsible to test the GUI and backend testing of Kaplan marketed products for K12 Learning Services
  • Owned the test artifacts such as Test requirements (Business, Technical and User) for GUI using Selenium and owned the database testing for the K12 data warehouse initiatives.
  • Have used Mercury Quality Center / Test Director for capturing the Test requirements, test plan, create test instances and monitor the Run statuses for test iterations.
  • Provided the test reports and prepared an intuitive Program level dashboard to extract information from Quality Center / Test Director for management reporting.
  • Involved in the entire testing efforts and coordinated the testing efforts among the Business Analysts, Solution Consultants and ETL Team, Data Architects and end users to track the requirements across the board for test coverage, requirements completeness and create, modify, or update the existing test scripts for data warehouse OLAP cubes.
  • Owned the Test bed creation for QA Testing, applied TDM principles and participated in the functional, regression, end-to-end, system, and user acceptance testing to ensure that requirements are met and partnered with external vendors and internal project groups to define the test objectives for entry, exit criteria for various testing efforts (functional, regression, Usability, performance, UAT).
  • Worked on MySQL, QTP for testing the data warehouse, conduct ETL testing of the OLAP cubes for data marts initiated by K12 Learning services.
  • Responsible to work closely with the data architects, enterprise architects, data modelers, Program and project managers to work on the gap analysis and handled the scope / change management for the incremental releases of the Data warehouse projects.
  • Responsible to review the business artifacts from the testing perspective and identify the problems during the early stages of the project.
  • Owns the Defects triage meetings and facilitated the defects documented by testing team using the Quality Center / Test Director and coordinate with the development team for reproducing the defects in the development region and responsible to retest them in the QA region for closure during the redelivery of the code.
  • Responsible to provide the test reports and weekly status reports on the defect aging, accumulated defect status and day-to-day defect progression statistics to the senior management and help them in mitigating the issues, risks from the testing perspective.
  • Defined the test cycles within the defined project timeline and provide test summary at the end of each test cycle enabling the senior management to eye the testing critically and help the testing team to progress in the pace required for implementation.
  • Developed entire defect management for Microsoft team foundation server, change management and release management processes and coordinated efforts leading to senior management buy-in in the processes and helped organization to implement the standards and processes.
  • Critically looked at the gaps within the testing team and mentored the peers and team members to equip them in the required skills to perform the testing and create a result oriented team.
  • Responsible to manage the large offshore testing team for overseeing the entire testing efforts and prepare causal analysis reports for the failed test cases and report the overall progress of the testing for each test cycle.

Environment: Kaplan K12 Products, MySQL, PHP, Dot Net 2.0 framework

Confidential, Owings Mills – Maryland

Sr. QA Manager

Responsibilities:
  • Owned complete testing artifacts for testing the claims and members business processing and delivered test artifacts such as Test Strategy, Test plan, developed test scenarios and test cases for data warehouse backend testing in CMMI Quality framework.
  • Owned the Test requirements (Business, Technical and User) for entire database testing and Verisk data cubes testing using Star Schema at the relational database level for data warehouse applications and involved in preparing/reviewing the training materials for end users for production and post implementation.
  • Have used Mercury Quality Center / Test Director for capturing the Test requirements, test plan, create test instances and monitor the Run statuses for test iterations.
  • Provided the test reports and prepared an intuitive Program level dashboard to extract information from Quality Center / Test Director for management reporting.
  • Involved in the white box testing and coordinated the testing efforts involving Teradata (OLAP Cubes)among the team of ETL developers, Business Owners and solution consultants to track the requirements across the board for test coverage, requirements completeness and accuracy to create, modify, or update the existing test scripts
  • Owned the Test bed creation for QA Testing, applied TDM principles and participated in the functional, regression, end-to-end, system, and user acceptance testing to ensure that requirements are met and partnered with external vendors and internal project groups to define the test objectives for entry, exit criteria for various testing efforts (functional, regression, Usability, performance, UAT).
  • Owned entire testing of the business processes involved in integrating Lotus Notes Claims (Dental, Medical, NASCO, Revenue, Product and providers and the feeds provided to Verisk HealthCare Platform (Data Cubes and Data Marts - DM) and responsible to reconcile the claims processing codes (835, 834 & 837) for mismatch on the target databases.
  • Worked on SQL, DBVisualizer, SQLPlus,SQLServer, SPUFI, DB2 tables, QTP for testing the medical claims, ODS,EDM,EDW,FACMOD,Facets 4.5, Dental, pharmacy claims on mainframe environment using Hummingbird as 3270 emulator..
  • Owned the Defects triage meetings and facilitated the defects documented by testing team using the Quality Center / Test Director and coordinate with the development team for reproducing the defects in the development region and responsible to retest them in the QA region for closure during the redelivery of the code.
  • Responsible to provide the test reports and weekly status reports on the defect aging, accumulated defect status and day-to-day defect progression statistics to the senior management and help them in mitigating the issues, risks from the testing perspective.
  • Defined the test cycles within the defined project timeline and provide test summary at the end of each test cycle enabling the senior management to eye the testing critically and help the testing team to progress in the pace required for implementation.
  • Developed entire defect management for Microsoft team foundation server, change management and release management processes and coordinated efforts leading to senior management buy-in in the processes and helped organization to implement the standards and processes.
  • Critically looked at the gaps within the testing team and mentored the peers and team members to equip them in the required skills to perform the testing and create a result oriented team.
  • Partner with client groups to ensure that the testing strategy is understood, in use, that system test prerequisites are completed, and that system test outputs are analyzed.

Environment: IBM MAINFRAME, Oracle, SQL Server 2000, .NET, Share point, QT Pro, Quality Center / Test Director, VERISK, Business Objects 6.1b, Micro strategy 8.0,DbVisualizer, PL/SQL.

Confidential, Enfield – CT

IT Test Manager

Responsibilities:
  • Analyzed the business and functional requirements (Pre and final RTMs) of the application and also helped in developing detailed test plan and test cases
  • Defined the SIT, UAT test criteria, and project schedules and worked to baseline the test requirements and prepare test plan and walkthroughs in a Agile/Scrum iterative project releases and used Maestro Scheduler (Control-M) for testing with Offshore-Onsite model with 30 offshore and 20 Onsite testers.
  • Used QTP scripts for automated test scripts based on application for each nightly builds released into QA region.
  • Written Quick Test Pro VB scripts to automate most of the test cases to test the functional, security, GUI and regression testing of the New Business Implementation with eDocs applications and Lotus Notes integration for Term and whole life products and the related web services
  • Owned the QA and UAT Test data, used the TDM principles and participated in the functional, regression, end-to-end, system, and user acceptance testing to ensure that requirements are met and partnered with external vendors and internal project groups involving data ware house, data marts, File net for document imaging requirements and Planet soft development team (TPP – The Policy Processor).
  • Initiated risk management and mitigation meetings and prepared the documents related to the business continuity planning and disaster recovery planning activities.
  • Written test scenarios for White Box testing efforts leading to 90% coverage of the code during execution and reviewed the programs to meet the SLA for code coverage and to baseline the code for technical requirements traceability.
  • Owned and facilitated defect review meetings and customized the defects using Atlassian JIRA for managing entire defect management lifecycle, defect triage meetings and retested the defects in testing for closure of defects using Microsoft team foundation server.
  • Automated the IT testing efforts using the Quick test Pro, completed the ETL backend testing of the DB with Teradata by writing SQL queries using Star Schema to test the integrity of the application and Oracle databases for TPP (The Policy Processor) and wrote test scripts for the test cases and SQL/Automation scripts for backend validations of the OLAP cubes.
  • Owned entire testing efforts of the data warehouse / data mart projects involving ETL developers and testers and worked closely with Business team, Solution Consultants, Data Architects and end users to track the requirements across the board for test coverage, requirements completeness and create, modify, or update the existing test scripts
  • Worked extensively on File-Aid for mainframe DB2, VSAM and SQL developer for ORACLE, Unix Sybase tables with teradata and have used SPUFI and DBVisualizer for extracting and validating the data against the IVV project requirements.
  • Involved in functional and regression testing of the web-application (IIS 5.0, IIS 6.0) and tested the software using different browsers to study the browser compatibility and usability testing.

Environment: IBM MAINFRAME, Oracle, SQL Server 2000, .NET, Visual Source Safe, Unix, XML, QT Pro, Win Runner, LoadRunner, Performance Center, WebMethods, Citrix, IBM,SOPA, LDAP, WSDL, Clear Quest, Rational Rose, Quality Center / Test Director 9.2, SOAP, RMI, Java.

Confidential, Bridgeport - CT

Sr. QA Manager

Responsibilities:
  • Coordinate with the technical leads, enterprise architects, application development team, Business Analyst to coordinate bug scrub meetings and baseline the workflow architecture, test requirements and identified critical business scenarios for end-to-end functionality and regression testing using Agile/Scrum iterative project framework with Offshore-Onsite model with 35 offshore and 10 Onsite testers..
  • Created and implemented a viable testing routine with the Test Plans created in Test Director and then associated them with specific requirements utilizing the Tests Coverage feature of Quality Center / Test Director to write test scripts for the test cases and SQL/Automation scripts for backend validation using Star Schema and wrote test scripts for the test cases and SQL/Automation scripts for backend validations.
  • Worked closely with the project stakeholders and owned the QA and UAT Test data, used the TDM principles to ensure that requirements are met and partnered with external vendors and internal project groups.
  • Worked closely with the infrastructure team to finalize the hardware requirements including setting up the test environment for E-Rate and federal funding for People United Bank, defining detailed test requirements, write test plans/cases and developing test matrices and have used Perl Scripting for testing few key Online Channels.
  • Worked for the testing initiatives on mergers/acquisition of Chittenden bank with People’s Bank and aligned the testing of applications on the new testing environment of Chittenden bank as part of merger tasks and conducted SIT, UAT and post UAT testing efforts and review the training materials for user during the production and post implementation of the project.
  • Owned and facilitated defect review meetings and categorized, prioritized and facilitated entire process of defect triage and retested the defects in testing for closure of defects using Microsoft team foundation server.
  • Reviewed the business use cases and UML diagrams for Business process diagrams, activity diagrams, state diagrams, and/or sequence diagrams developed by other business analysts and business community during the SDLC and provided comments for incorporating changes to the business process flows and exception processing and participated in the java programs for code coverage;
  • Worked extensively on File-Aid for mainframes, validate UNIX Sybase, Oracle, MS-Access, DB2 VSAM and flat files using SPUFI, SQL developer, DBVisualizer for extracting and validating the data against the QA testing requirements using Hummingbird as 3270 terminal emulator.
  • Worked extensively on ETL testing efforts for Data marts (DM), Data warehouse, Maestro (Control-M) scheduler, use several feeds resulting loading the ODS for data warehouse and OLAP cubes..
  • Worked extensively on COGNOS, Business Objects, Micro Strategy, QTP for Data warehouse reporting and written queries on COGNOS, Business Objects to customize management reports from ODS and worked with business owners/team, ETL developers, senior management and solution delivery managers to track the ETL and OLAP cube requirements across the board for test coverage, requirements completeness and create, modify, or update, report the testing progress from time to time.
  • Participated in finalizing the forms requirements of Lotus Notes forms associated with Online channels and API’s interfacing the core banking product and coordinated the eDocs, and Lotus Notes test efforts across People’s United Bank and Chittenden bank and involved in preparing the Wiki pages for test management using Atlassian Confluence web-based corporate Wiki.
  • Designed load tests (Stability, Stress and isolation tests) in different ways to measure the application performance.
  • Worked with the infrastructure team using ITIL – Infrastructure library standards to re-engineer the process to develop and implement appropriate environment Release control process involving multiple vendors for online channels and interfaces.

Environment: Oracle Apps, Oracle Forms/Reports 6i, Java, HTML, JSP, Unix, Oracle 9i, PL/SQL, MS Project, Microsoft Share point Portal, Visual Intercept, SQL Navigator, QTPro, Win Runner, Load Runner, Microsoft team foundation Db2, ERWIN, JCL, VSAM, GDG, Maestro scheduler, CICS, COBOL, VB Scripts, Microsoft Office products, MSProject, VISIO

Confidential, New Jersey

Sr. Business Analyst / Business Tester

Responsibilities:
  • Worked on Doors to deliver the Test requirements and manage the Pre-Test RTMs for large project implemented on a global scale.
  • Delivered major Business Requirement deliverables and UML diagrams for market data products such as Quotes, charts;
  • Authored several Business process diagrams, activity/sequence diagrams, state diagrams, and/or sequence diagrams for major software initiatives leading to process improvements in a Agile/Scrum iterative project environment.
  • Worked on various subject areas to deliver the business requirements document for the data warehouse / data mart project implementation for Global Subscription Processing project. Delivered the ETL requirements for data mart using Star Schema, OLAP cubes and responsible to transition from Business analyst to Business tester role during the project implementation.
  • Discuss the proposed process map changes and validate the gap analysis with Business and Technology teams during the SDLC with Onsite/Offshore model implementation.
  • Partnered with developers and used Maven/Ant for testing the incremental releases / nightly builds delivered to the QA phase of the project.
  • Identified the functional and non-functional requirements for QA and UAT phase of the project;

Environment: RUP, JAVA.Net Framework, Oracle 10i RAC, Db2, ERWIN, ASP, JCL, VSAM, GDG, Maestro schedulers, CICS, COBOL, VB Scripts, Microsoft Office products, MSProject, Junit, Design Patterns, Portlets, VISIO, SQL Scripting, QC, QTP, LoadRunner.

Confidential

Sr. QA Manager / Delivery Manager

Responsibilities:
  • Responsible to manage the entire Test lifecycle of the core banking product comprising of back office application testing and integrate the document imaging API’s during the QA and UAT stages of the project with Offshore-Onsite model with 60 offshore and 30 Onsite testers.
  • Worked with Glaxo, India for implementing the Pharmacy claims processing for reconciliation and balancing processes to reconcile the claims processing codes (835, 834 & 837) for mismatches reported on the target databases during the SIT, UAT processes and managed the entire Post Implementation efforts, release management and defect management process.
  • Written and organized the Test cases, Test Procedure, Expected results according to the feature categories specified in the requirements document using Agile/Scrum iterative project framework. Test Cases involved both the positive and negative test cases for each feature and delivered the training and user manuals for end users during production and post implementation of the project.
  • Owned the defect management and customized the defects categorization, prioritization and resolution using Atlassian JIRA and responsible to authored the automation framework for electronic payments and Claims processing and reconciliation.
  • Created Wiki pages for test management using Atlassian Confluence web-based corporate Wiki.
  • Was part of the testing team for Infrastructure Disaster recovery planning and testing efforts and coordinated the Disaster recovery testing activities for a major financial institution in India.
  • Worked with Bugzilla for managing the project defects for a major implementation of card products St.George Bank, Australia.
  • Worked closed with the Onsite team, business users, Solution Consultants and ETL Team, Data Architects to deliver the project testing requirements and analyze the gap documents produced by the ETL developers and written new test cases for the new functionalities and responsible to prepare an elaborate traceability matrix for OLAP cubes testing involved in the data warehouse project testing and delivery.
  • Worked on GUI functional testing using Perl Scripting and Database backend testing using Oracle, DB2, SQL and MS-Access tables for IVV testing efforts and have used Business Objects, COGNOS for writing queries to customize the reports required by the testing group on day-to-day basis using Hummingbird as 3270 terminal emulator.
  • Worked in the testing the settlement applications for EBT applications using Omni 3740 for Point of Sales applications.
  • Participated in vendor evaluation and complete procuring of the LoadRunner licenses for the project.
  • Performed the RBAC based Site Minder (Single Sign On) for Web-based Java J2EE applications (IIS 5.0, IIS 6.0) developed for major financial and credit card applications.

Environment: RUP, JAVA.Net Framework, Oracle 10i RAC, Db2, ERWIN, ASP, JCL, VSAM, GDG, Maestro schedulers, Portlets, CICS, COBOL, VB Scripts, Microsoft Office products, MSProject, File net P8, XML, CSS, HTML, VISIO, QTP, Endeavor, LoadRunner, Win Runner, Jmeter, Junit, Microsoft team foundation server (for defect management), Quality Center / Test Director, SQL Scripting

Confidential

QA Manager

Responsibilities:
  • Co-ordinate and Control testing quality cycle from test planning through execution to defect management for SIT, UAT, Production support testing efforts for major customers such as Kroger, Citibank, Putnam Investments, ACNeilson.
  • Responsible for initiating the pre-project activities for Putnam investments for major offshore testing efforts using CMM quality framework.

Environment: IBM OS 390,PL/I, IMS DB and DL/I, IBM OS390 / Cool-Gen, Oracle 9i RAC, Db2, ERWIN, ASP, JCL, VSAM, GDG, Maestro schedulers, CICS, COBOL, VB Scripts, Microsoft Office products, MSProject, SQL, QC, QTP, LoadRunner

Confidential

Team Lead / Business Test Lead

Responsibilities:
  • Responsible to setup the unit test environment, defining detailed test requirements, Installation and test the upstream and downstream applications interfacing the core banking product.
  • Involving in the execution of the manual test cases, analysis of the test results and maintenance of Test metrics.
  • Compared and analyzed actual to expected results using text, GUI and database checkpoints and reported all deviations for resolution for testing the Point of sales applications using Omni 3740.
  • Participated in User Evaluation and User Acceptance Testing of implementing major migration projects and Payroll applications.

Environment: CA-IDEAL, COBOLII, DB2, MVS, FARABI (Multilingual GUI) and BARR/BETA92 for scheduler management, Microsoft Office Products.

Hire Now