SUMMARY

• Having 7 years of industry experience specializing in Quality Assurance (QA) which includes experience in all phases of SDLC including Analysis, Design, Development and Testing. Experience also includes testing various web - based, object-oriented, wireless, client-server and multi-tier applications. Experience in Insurance, Financial, Healthcare, Retirement and Automated Child Welfare system applications.
• Extensive experience in Black Box and White Box testing.
• Specialized in testing Java, .NET and Oracle, Excel, Access, Data warehousing applications using both Automation and manual testing for various business applications.
• Experience with QA Methodology and QA Validations to ensure the Quality Assurance Control.
• Experience in Back-end testing using SQL and PL/SQL and testing database applications of RDBMS in MS SQL Server 2008/2005/2000 , DB2, and Access, ORACLE 10g /9i /8i.
• Expert in GUI, Unit, Functional, System, Integration, Regression, UAT, Stress, Load, Back end and Performance Testing.
• Experience in mentoring testers and end users, assisted end users in User Acceptance testing, Validation Testing and Verification Testing.
• Devised, implemented Software Testing Methodologies/Strategies in both Client/Server and Web based applications to ensure Quality Assurance Control.
• Excellent skills in overall Defect Management/Problem Solving including tracking bugs, reporting using Test director, Quality Center.
• Involved in writing the Test Scripts by using QTP, WinRunner and LoadRunner.
• Experience on Excel and Access in processing the files.
• Good understanding of CTI (Computerized data interchange) and EDI (Electronic data interchange).
• Strong in analyzing Business requirements and design specifications and developing/maintaining the Test Plans, Test Scripts, Test Cases and executing them.
• Ability to interact with developers and product analysts regarding application analysis.
• Excellent interpersonal skills and communication skills, proven team player with an analytical bent to problem solving and delivering under high stress environment with resource constraints.

TECHNICAL SKILLS

Languages: C, C#, C++, JAVA, .NET, SQL, PL/SQL, VBA

Web Technologies: HTML, DHTML, CSS, XML, XSL, XSLT and SOA

GUI: D2K, Forms 6i, Reports 6i, .Net, Visual Basic 6.0, VB.NET, ASP.NET, VC++, Oracle 11i Applications, Toad, PLSQL Developer

Scripting: Java Script, XML,VB Script, PERL, UNIX, Shell scripting

RDBMS: Oracle 9i/10g, SQL Server 2005/2008, DB2 and MS Access.

Testing Tools: Quick Test Professional 9.0/9.2/9.5/10 , WinRunner 7.6, LoadRunner 7.2, Compuware QARun, Selenium, Quality Center, Test Director, TestComplete, Silk, SQA Robot, Rational tool suite.

Reporting Tools: Brio, Business Objects, Crystal Reports, Developer 2000, Excel

Source Control Tools: Rational ClearCase, CVS, PVCS, VSS

DW Tools: Informatica Power Center 8.x/7.x, COGNOS, Ab Initio, Micro Strategy, Crystal Reports

Test Script Languages: TSL, VBScript, SQA Basic

Operating Systems: Windows 7/XP/2000/NT, DOS, MAC, UNIX (SOLARIS), Linux

Network Protocols: TCP/IP Protocol Suit, Basic concepts of SAN/NAS.

Bug Tracking Tools: Bugzilla, Test Director, Quality center, Team Foundation Server (TFS), JIRA, ClearQuest

Modeling: Rational Rose (UML), Relational Model, E-R Model, MS Visio, UML (Unified Modeling Language), VISIO, Rational Unified Process (RUP)

Servers: Apache, Tomcat, JBOSS, Web Logic 8.1, WebSphere 6.1, IIS, LDAP, Team Foundation Server

PROFESSIONAL EXPERIENCE

Confidential, Lansing, MI

QA/QC Analyst

Responsibilities:

• The SACWIS web based project life cycle model is being adapted within the use of SEM (Systems Engineering Methodology) Phases. Project is a combination of an application transfer, iterative development (Agile), and waterfall test life cycle model. As a QA\Quality Control team member, involved in various phases of project life cycle that mainly includes Requirements Gathering, Development and Testing & Implementation.
• As a part of Quality Control/QA team, participated in Joint Application Design (JAD) sessions to ensure that the QC/QA testing technicians understand requirements, which serve as the foundation for subsequent testing activities and develop Test scenario\cases for use in but not limited to System /UAT testing.
• Analyzed requirements and module-specific functionalities to identify test requirements and to prepare test cases.
• Developed Test Scenario’sand Test Scripts from Use Cases.
• Used Rational Quality manager to write test cases, analyzed the results and generated the report.
• Implemented defect tracking using Rational Clear Quest.
• Documented all errors/defects identified and implemented their resolutions as defined by management.
• Participated in walk through meetings and created meeting minutes.
• Participated in Conceptual Design Sessions that mainly includes initial Use case Reviews, User\worker approvals for Intake, Payments and Accounting tracks and also provided Test Metrics report to Test Manager as necessary.
• Involved in Detailed Design Session that includes Use case detailed Reviews and approvals, Screen Specifications review, approvals and signoff
• Validated Artifacts for Use Cases, Screen specifications, UCR (Technical DesignDocument) in Clear Case for each Increment and provided Reports to the Testing Manager as needed. Used Rational Clear Case as a repository for uploading all the Use Case, Screen Specifications, Use Case Realization Documents and using those documents as reference to develop the application and also for writing Test Cases and Test Scripts
• Worked with the Test Manager to set the expectations and direction from a strategically and planning perspective. Used Rational Quality Manager for Creating Test Strategy and Test Plan and for developing Test Cases and Test Scripts and conducting the required reviews
• Maintained Traceability Matrix in all phases to ensure proper test coverage.
• Participated in user acceptance testing with the users and reported defects to the development team and retested the fixed issues.
• Participated in round table conference meetings with the users, developers, system analysts, subject matter experts, business analysts and discussed the issues and areas to be covered through the next iterations of the project.
• Prioritized and planned effectively so all the deadlines of the work needs to be done through the iterations are met.
• Participated in reviewing the technical specification documents for each use case along with the systems analyst and the Business Analyst.
• Maintained all meeting minutes and detailed information specific to the iterations and reported to the Management on time.

Environment: MS Visio, Rational Requisite Pro, Rational Test Manager, RationalClear Quest, Java (JDK 5), JSP, Servlets (JSDK 3.0), Web Sphere Application Server 7.x, JDBC, Oracle11G, TOAD for SQL Query, Windows XP, Firefox, I.E.8.0, Crystal Reports.

Confidential, Phoenix, AZ

QA Analyst / ETL

Responsibilities:

• Analyzed the business requirements and configuration documents.
• Tested the application by implementing and following Agile methodology.
• Involved in writing test plans, test cases and test scripts according to the business requirements documents.
• Developed test plans and test cases in Quality center.
• Created test plans to accomplish required testing.
• Involved in testing of the User interface of an application.
• Tested various flat files for the required content within.
• Performed manual testing for each and every test case.
• Executed all test cases successfully.
• Used Quality Center for requirements tracking, test case design, management reporting and defect tracking.
• Entered the tracked defects into the defect module of Quality Center.
• Performed automated testing using QTP.
• Executed all the test cases successfully.
• Used Tem Foundation server for requirements management, defect management and version control.
• Successfully performed different kinds of testing’s such as Integration, Regression, System testing.
• Tested ETL process for proper loading of data from oracle database, flat files, DB2, to the oracle DW.
• Successfully tested the SAP customizations and applications which are integrated with SAP.
• Successfully tested the ETL transformations.
• Tested the ETL data through different environments like development to test and test to production.
• Involved in execution of unit test plans and preparing the reports along with ETL developer.
• Involved in FRD documents review meetings.
• Provided support to the UAT team.
• Participated and reported status in all test related project team meetings.

Environment: Java, J2EE, Java scripts, HP Quality center 10.0, QTP 10.0, Winrunner, HP Load runner, Tibco, Team Foundation Server (TFS), SAP ERP, SAP ECC, MS-Word, MS-Excel, MS-Project, Informatica powercenter 8.6, Unix, Unix shell scripting, Windows XP.

Confidential, Phoenix, AZ

QA Analyst

Responsibilities:

• Actively involved in 5 stages of planning process such as defining testing goals, test subjects, designing tests, test steps and automating tests.
• Involved in interacting with the business team and Requirement gathering, preparing the test cases, application testing & Lead a team with Agile/Scrum Methodology.
• Involved in requirements review meetings and design review meetings. Have constant communication with Business Analyst, Developers, Project Manager and Users throughout the life cycle of the project.
• Analyzed various requirement documents to prepare the detailed Test Cases.
• Execution of test cases, verification of actual results against the expected and documentation of the test plan. Developed a suite of generic functions using QTP for use of regression testing.
• Involved in interacting with the business team and Requirement gathering, preparing the test cases, application testing & Lead a team.
• Developed Test cases based on Use cases & Business Requirements.
• Performed Risk Analysis to determine the focus of the testing; identified critical business processes.
• Involved in writing System test plan, test cases and test procedures and test scenarios.
• Involved in the testing on the existing UNISYS system for migrating to PERIS.
• Tested the EMR (electronic medical record) application used to retrieve the data of some of the members who are deceased.
• Tested Imaging Content Store, Data Capture, FileNet BPM Queues, workflow Navigation and SOA.
• Involved in Production Support in solving the production support critical issues.
• Tracked and reported bugs using JIRA for managing bug features, tasks or improvements or any issues. Created and updated the defects through JIRA.
• Added various conditional statements to enhance the Test Scripts in for the functional and regression testing.
• Involved in writing complex SQL queries to find the data for all the scenarios from the database and involved in performing the back end testing before sending the extract files for auditing to Actuary & Mellon Bank by writing SQL and PL/SQL scripts and comparing/validating the data with Excel files.
• Extensively involved in Excel and Access files testing using macros for Payments and Pension/Newret payrolls processing reconciliation file, process Mellon transfer file, Mellon transfer Trankey record, Mellon daily adjustment file, Rollover address change, Re-issue checks overnight, Mellon issue file, Re-issue check as ACH
• Involved in the batch processing testing for the projects Contribution Posting in the phases Trial, Rollback and Final and Pension those were developed by Web Services.
• Involved in testing the web application used by the members to access their accounts and information.
• Developed and automated the database scripts by writing PL/SQL functions and procedures in Oracle and developed the shell scripts in UNIX for reconciling the data in the existing application in UNISYS.
• Developed test scripts for Functional, performance and data driven tests for the AUT.
• Attended review meetings and walkthroughs to discuss the status of the project.
• Actively involved in adhoc meetings to improve the performance of testing process.

Environment: Java, Java Script, J2EE, XML, JBoss, SOA, Web Services, ASP.Net, C#, IIS, File Net BPM, Oracle 10g/9i/8i, SQL, PL/SQL, PVCS, JIRA, QTP, Quality Center, VB Script, Hibernates, Spring, JSF, JSP, Excel, Access, VBA, UNIX, Unisys, windows XP D2K, Oracle Forms 6i, Reports 6i, PL/SQL Developer, QARun and QA Track Record.

Confidential

Oracle Developer

Responsibilities:

• Understanding the customer’s requirements, analysis, design, development and implementation of system; gather and define business requirements, improve business processes.
• Designed and developed PL/SQL functions, stored procedures, cursors, triggers and packages.
• Involved in designing the E-R (EER) diagrams to create a normalized database
• Created tables, views, Stored Procedures
• Developed front-end screens using HTML and JavaScript to provide user-friendly interface
• Developed client side validation programs using Java Script to check the input
• Extensive programming in PL/SQL, created stored procedure and functions
• Developed triggers to enforce Integrity constraints and to carry out updates of new fields, and exceptions for run-time error handling
• Involved unit testing for all the modules and Provided end-user support, maintenance, and training
• Provided End User Training and Support

Environment: Oracle 8i, PL/SQL, SQL*Plus, Oracle Forms 6i and Reports 6i, HTML, XML, JavaScript, Windows 2000