OBJECTIVE

• To make a contribution and add value in a fast - paced team environment by utilizing my proven software testing skills and abilities, and my diversified experience in software quality assurance, to ensure the company’s sustained growth and continued success.

SUMMARY

• Over 7 Years of IT Experienced in Prepared documentation such as business requirements and functional specifications based on business needs and used the information to develop detailed comprehensive test strategies to verify system changes to meet the needs of the client.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile
• Good testing experience in Insurance domains.
• Experienced in developing Test Plans and Test Cases for different types of software testing.
• Proficient in both Manual and Automated Testing Tools such as QTP, Win Runner, Load Runner.
• Extensive knowledge of SDLC (Software Development Life Cycle) methodologies.
• Experienced in various types of testing including Sanity Testing, Smoke Testing, Functionality Testing, Performance Testing, Volume Testing, Unit Testing, Integrated Testing, System Testing, Positive and Negative Testing, Security Testing and Regression Testing of, Web Based and Client-Server applications
• Involved in maintaining Test Matrix and Traceability Matrix and performed Gap Analysis
• Good understanding of Data warehousing, ETL in SSIS to perform Source to Target testing.
• Performed User Acceptance Testing (UAT) manually.
• Participated in design walkthroughs and verified QC Test Scripts and results.
• Tracked and reported on test execution.
• Good Documentation and Process Management skills with an ability to effectively understand the business requirements to develop a quality product.
• Performed portfolios of clients and assignments and key client relationship, develop and deliver services and value charters.
• Effective Time Management Skills and consistent ability to meet client deadline.

TECHNICAL SKILLS

TESTING TOOLS: Win Runner, Load Runner, QTP, SOAPUI, ETL, DATA WAREHOUSE

BUG REPORTING: Test Director, Mercury ALM / Quality Center, CQTM

REQUIREMENT MGMT TOOLS: CaliberRM, Rational Requisite Pro

PROGRAMMING LANGUAGES: SQL, TSL (Test Script Language), VB Script

RDBMS: Oracle, MS Access, SQL Server, DB2

OFFICE SOFTWARE: MS Office (Word, Excel, PowerPoint)

OPERATING SYSTEM: Windows 95/98/XP/2000/VISTA/, UNIX/LINUX

WEB TECHNOLOGIES: J2EE, JAVA, HTML, XML,.NET, ASP.NET, HTML, BEA WEBLOGIC, BEA WEBLOGIC PORTAL FRAMEWORK

PROFESSIONAL EXPERIENCE

Confidential, Harrisburg, PA

QA Analyst

Responsibilities:

• Responsible for testing the Navigation Flow, Functionality Testing, System Testing and User Acceptance Testing.
• Interacted with business analysts to gather the requirements for business and performance testing.
• Have good exposure to modern Agile methodologies such as SCRUM and TDD.
• Prepared Test Data and executed Test Cases from ALM / Quality Center.
• Prepared test data and helped load test data into the test database environment.
• Created and tested different reports like Cross Tab, Parameterized Reports, Tabular, Freeform Reports and Ad-Hoc Reports using Business Objects Reporting tool for Claims, Members, and Providers and Billing modules
• Principles in an Agile or test driven methodology environment.
• Created and maintained SQL Scripts to perform back-end testing on the oracle database.
• Reviewed extensive SQL Queries with complex multi-table joins and nested queries.
• Responsible for gathering requirements, design and develop data warehousing ETL solutions and delivery reports
• Tested the ETL Informatica mappings and other ETL Processes (Data warehouse Testing)
• Perform static, functional, technical integration, end-to-end and User Acceptance Testing
• Involved in reviewing complex SQL queries, views, functions and stored procedures and spotting issues before/during code migration.
• Created several Test Cases and Test Conditions for testing various Claims, Membership, Billing and Provider reports
• Tested various versions of handheld devices to perform cross platform and browser compatibility testing.
• Performed backend testing for data validation using SQL Queries.
• Performed rigorous manual testing such Functional Testing, Smoke testing, Integration testing, UAT Testing, Backend Testing, Regression Testing, End to End Testing and System Testing
• Analyze and make specific recommendations on improvements that can be integrated into business processes
• Participate in reviews throughout the development life cycle
• Created and maintained SQL Scripts to perform back-end testing on the oracle database.
• Performed Database testing using SQL queries
• Facilitate User Acceptance Testing by providing the necessary support to the business users
• Extensively performed manual testing and defect reporting using ALM / Quality Center.
• Worked on parameterizations, calling/copying, Check points heavily.
• Assisted in developing test plans for testing the functionality, GUI, and security.
• Performedmanual testing,considering the base line of developed test plan and test cases considering both positive and negative scenarios
• Conducted and participated in walkthroughs to generate consensus, maintaining quality and resolve issues among different stakeholders in the SDLC.
• Test scenario identification and alignment to service oriented architecture implemented within organization
• Created different pricing rules and verified whether the adjudication system is using the rules while adjudicating the Claims

Environment: s: Java, J2EE, HTML, Oracle, MS SQL Server, Informatica, ETL, HTML, XML, DB2, MS, QTP, ALM / Quality Center

Confidential, Berkley Heights, NJ

Sr. QA Analyst

Responsibilities:

• Worked with clients to better understand their needs and present solutions using structured SDLC approach.
• Managed various testing activities throughout the Software Testing Lifecycle (STLC) for multiple projects.
• Responsible fortestingall new and existingETLData warehousecomponents.
• Attended Change Request Meetings to ensure products and changes are fully documented for further Test changes.
• Extensively worked intestingreporting tool,Cognosby writing test cases and executing them in full software development life cycle
• Developed mappings in Informatica to load the data from various sources into the Data warehouse
• Performed various types of testing such as Functional, Regression, SIT, UAT, Backend etc..
• Created Test Plans and Scenario which describes the features and functions to be tested.
• Worked with ETL group for understating mappings for dimensions and facts
• Tested for data in the database by writing SQL queries for SQL Server before testing the module
• Prepared Test Cases based on Business Requirements and required documents.
• Actively participated in the weekly Project Status Meetings.
• Involved in writing Test scenarios, Generic tests cases, detail Positive and negative test cases for ETL also Preparing ETL and SQL routines/code for performing ETL testing (system and integration testing) and Documenting the test results
• Assigned test cases to responsible testers through by creating various Test Sets in Test Lab module.
• Produced various test reports such as Test Execution Status, Test Execution Summary/Progress, Defect Status, Defect Summary, Defect Inject Rate on daily and weekly basis and submitted
• Performed Grey Box, Black box testing and User Acceptance Testing.
• Performed Data Validation of the data flow from the front-end to the back-end by executing SQL scripts.
• Performed Data Profiling of current state of data in the Data warehouseby doing Data Analysis using advanced SQL Queries and Microsoft Excel, finding Gaps in Data and formulating solutions for the same
• Used SQL queries to validate the data between the backend and the front end
• Arranged meetings with the Project Teams to discuss the test approach used for the Data Conversion andETLmodules
• Worked with the components of Data Warehousing like components model,ETLtools.
• Gathered business requirements from users and created designs for enhancements and to remedy defects.
• Createdtest plans,conditions, scripts, and test data; performed product testing, user acceptance, remote user testing, usability standards validation, and performance testing; and resolved system defects.
• Conducted the defect report in Quality Center.
• Interacted with the developers to report and using Mercury Quality Center.
• Developed the reports using Quality Center.
• Maintained and modified the QTP scripts with user defined functions as a part of functional and regression test.

Environment: Java, Cognos,Oracle, ETL, Informatica, Data warehousing, SQL Server, PL/SQL, XML, Quality Center, QTP, Etc.

Confidential, Erie, PA

Quality Analyst

Responsibilities:

• Analyzed the objectives and scope of each stage of testing process from the Test plan.
• Interacted with business analysts to gather the requirements for business and performance testing.
• Participated in the Manual Vs Automated testing decision-making process.
• Responsible for testing the Navigation Flow, Functionality Testing, System Testing and User Acceptance Testing.
• Interacted with users and vendors for full life cycle of project.
• Written Medicare COB functional Requirements, Test steps and Test cases in Quality Center
• Prepared test data and helped load test data into the test database environment.
• Analyzed all types of the workers compensation, Disability insurance and provider Claims.
• Prepared Test Data and executed Test Cases from Quality Center.
• Stimulate financial calculations for a given formula for a given period.
• Life cycle test for various products contracts.
• Responsible for Performing Integration Testing, UAT testing. Conducted Back-End Testing Using SQL Commands
• Extensively used SQL statements to query the Oracle and DB2 Database for Data Validation and Data Integrity.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• ConductedFunctionality testingduring various phases of the application.
• Prepared automated scripts for Maintenance and Regression testing.
• Automated test scenarios for GUI, Functionality and performed data driven testing on the application inserting different data in excel sheet
• Worked on parameterizations, calling/copying, Check points heavily.
• Performed extensive manual testing.
• Extensively performed manual testing using Quality Center.
• Defect reporting and bug tracking using Quality Center.
• Created test cases and automated them for the purpose of regression testing and functional testing with check points usingQuick Test Professional.
• Analyzed the functional requirement documents, system requirement documents and business requirement documents.
• Assisted in developing test plans for testing the functionality, GUI, and security.
• Performedmanual testing,considering the base line of developed test plan and test cases considering both positive and negative scenarios.
• PerformedIntegration, Functional, GUIandUAT testing
• Interacted with developers to resolve defects.
• Developed automated scripts usingQTPto perform functional and regression testing
• I was responsible to create test data for functional testing and UAT.
• Performed functional testingfor new release enhancements.
• Participated actively in the team meetings with the developers for bug reviews.

Environment: Quality Center, Html, XML, Web Sphere, Oracle,SQL, UNIX, Windows XP

Confidential, Blue Bell, PA

QA Analyst

Responsibilities:

• Analyzed business requirements and module-specific functionalities to identify test requirement.
• Developed Requirements Traceability Matrix to track requirements.
• Conducted Manual Testing for checking the flow of the application functionality.
• Manually tested each module of the application and verify against expected results.
• Analyzed user requirements and prepared test approach document.
• Prepared test requirements, test cases manually.
• Checked the data flow through the front-end to back-end and used SQL queries to extract the data from the database.
• Defects were tracked, reviewed, analyzed and compared using Quality Center
• Worked in Agile Scrum methodology for both manual and automation testing.
• Use Jira application for Defect entry and maintain test cases for Agile process.
• Conducted Back-End Testing for Oracle databases using complex SQL queries.
• \Performed comparison of actual report with the expected values by querying the database.
• Performed extensive manual testing on critical functionalities of the application.
• Created and tested scenarios using positive and negative test data.
• Wrote simple to complex SQL queries to verify the database tables for the data inserted from the GUI.
• Modified and maintained test cases with changes in application interface and navigation flow.
• Used Quality Center for bug tracking and reporting, also followed up with development team to verify bug fixes, and update bug status.
• Prioritized and reported defects, presented documents and reports in weekly team meetings.
• Simulate business use with multiple users with typical business scenarios.
• Interacted with developers and team members for verification and validation aspects.

Environment: Oracle, Windows, Quality Center, SQL, MS Office, Etc.