SUMMARY

• 7 years of experience as a QA Analyst/Software Tester in Information Technology (IT) industry in Testing, Design, Development and Implementation of Software applications.
• Experienced in the development of test plans, test procedures and executing manual test scripts.
• Used DATASTAGE as an ETL Tool for Developing the Data Warehouse
• Used Informatica as an ETL Tool for Developing the Data Warehouse.
• Identify the source tables from which the Data Warehouse extracts data.
• Worked with the components of Data Warehousing like components model, ETL tools.
• Knowledge on Various ETL, Reporting, and Database development tools like Informatica, Hyperion, Erwin, Visio, SQL Server, and Oracle with strong SQL coding skills
• Served as mentor and reviewer to junior Specialists in all areas of data warehousing and ETL
• Experience in all aspects of Software Development Life Cycle (SDLC) focus on Testing.
• Demonstrated excellence in creating and developing Test Plans, Test cases and Test scripts.
• Proficient in Black Box Testing, Unit Testing, Integration Testing, & Regression Testing
• Proven experience in Manual and Automated Testing using the Tools Quick Test Pro, Quality center and also familiar with Load Runner.
• Ability to interact and work collaboratively with testers, developers and other project team members
• Enhanced Test Scripts using Quick Test Pro features like checkpoints, synchronizationpoints and parameterization (Data Driven Testing). Debug the Test Scripts using Break Points.
• Applications: MS Office, IE7, Mozilla Firefox 2, MS SharePoint, Visio, Adobe Acrobat,
• Extensive experience in writing and executing automated Testing scripts using VB Script.
• Expertise in Problem solving and Bug Reports using Defect Tracking Tools like Test Director/Quality Center.
• Involved in support for the existing EDW (Enterprise Data ware house).
• Monitoring and resolving Data warehouse ETL Production issues
• Adaptable to different client situations and quick in the learning of new skills and methods.
• Excellent Technical, Analytical, Presentation, Communication skills. Strong team player and ability to perform in both team and individual settings.

TECHNICAL SKILLS:

• Testing Tools: Quick Test Pro 7.6/8.0/9.0/9.2, HP Quality Center 10.0/9.2
• Operating Systems: Windows, UNIX, and MS-DOS.
• Database: Oracle, MS Access.
• Servers - Application: WebLogic , Websphere
• Servers - Web: Apache Tomcat 6
• Languages: C, XML, SQL and PL/SQL
• ETL Tools: Informatica Power Center 7.1, 7.1.5, 8.5.1 Sql server analysis services and Reporting services
• Office Applications: MS Office, Adobe PageMaker.

PROFESSIONAL EXPERIENCE:

Confidential, NYC, NY Nov 2011 to Till Date
QA Analyst

The American Arbitration Association (AAA) is nation\'s largest full-service alternative dispute resolution (ADR) provider. AAA offers fast, convenient online claim filing through AAA WebFile service. In addition to filing claims, clients can make payments, perform online case management, access rules and procedures, electronically transfer documents, select Neutrals, use a case-customized message board and check the status of their case.

Responsibilities:

• Involved in preparing High Level Test plans based on user requirement documents.
• Created RTM (Requirements Tractability Matrix) to match requirements.
• Involved in defining Test objectives for the applications and performed Manual Testing.
• Involved in cross browser testing using Netscape Navigator and Internet Explorer.
• Involved in developing Integration Test Plans, System Test Plans and Performance Test Plans for the applications.
• Performed Data Integration testing and front end testing.
• Developed Test Plan, Test Procedures and Process for UAT testing and involved in Installation Testing.
• Involved in functional testing, Integration testing, System testing, performance testing, stress testing and load testing the system.
• Used SQL Queries to verify the data from the Oracle database.
• Developed Test Plans and Test Case design using Quality Center.
• Defect and Change Tracking was done using Quality Center.
• Develop parameter driven ETL process to map source systems to target data warehouse with Informatica complete source system profiling
• Loaded data to different databases using SQL scripts and maintained a repository for data loading scripts
• Used Shell scripts extensively for automation of file manipulation and data loading procedures
• Interacted with the developers for bug fixes and problem resolution
• Involved in the User Acceptance Testing, Participated in various meetings and discussed Enhancement and Modification Request issues.
• Participated in regular project status meetings related to testing

Environment: Manual Testing, HTML, Quality center, Windows, UNIX and Oracle 10g. Informatica

Confidential, is one of the largest healthcare provider in USA provides health care plans to Large group, Small group, SSB, individuals. The WGS 2.0 Claims System is part of the WGS 2.0 family of systems which is loosely coupled to allow for flexibility and growth. WGS Claims system is claims primary adjudication system within Confidential, WGS Overlays NPI (BNPI or RNPI) submitted by the provider. Ultimately NPI is not sent out via the 835 file which now causes us to be NPI non-compliant. In addition, on occasion the NPI is not being passed on host interplan transactions, when present on the incoming claim (electronic or paper) in accordance with BCBSA IPS.

Responsibilities:

• Created test cases as per the requirement documents and stored the same in clear quest.
• Interacted actively with Business Analysts/Users/developers for collecting requirements.
• Involved in development of Test plan and test cases for integration, functional, System and regression testing.
• Working in the agile development environment with frequently changing requirements and features set.
• Conducted functionality testing during various phases of the application.
• Prepared Test data to enable the software to be quality checked.
• Responsible for setting up of Test environment.
• Tested new features and their impact on existing functionality before each release
• Coordinate with offshore team on execution.
• Monitor and report issues through the bug tracking system
• Accurately record and clearly document all actual results and compare them to expected results.
• Regression Testing conducted to make sure bugs fixes are working fine, and to make sure issues fixed doesn’t impact other areas application.
• End-to-end ETL development of the Data Mart.
• Communicate withsupport,business and development teams to resolve issues during test execution.
• Responsible for weekly status, attend the bridge meetings showing progress and future testing efforts.

Environment: Mainframes, J unit, Java, Clear Quest, MS OFFICE 2007, Visio, Windows XP, UNIX.

St Fransishas many modules. The module I worked on is EPIC ADT and AMB. Participated in System and Functional testing. Created defects and entered the defect descriptions in Quality center. Involved in team meetings to resolve the defects and help track the status to the project lead.

Responsibilities:

• Understanding the client requirements by studying functional documents.
• Identification of scenarios for the Requirements.
• Preparation of Test Plan.
• Writing the test cases based on Functional specs and business requirement documents.
• Identified Test requirements and checked if the test cases were complete enough to test the business functionality.
• Worked on Claims (837,835), EDI transactions (270,271) and Statements
• Reviewing the Test cases and suggesting modifications through review report.
• Performed System testing and Regression testing
• Executing the Test cases and reporting the bugs through defect tracking tool.
• Daily updating the Test case execution status.
• Publishing daily status reports during execution.
• Scheduling Defect Status meetings with IT and Business

Environment: Manual Testing, XML, HTML, Windows XP Professional., UNIX and Oracle 9i.

Confidential, is a web based application developed to meet the sales support needs for MCI On-Net order processing. OP uses web technology to provide an automated and efficient solution for the ordering of local, long distance, and data product. OrderPro Facilitates timely accurate, and further processing of customer orders. OP allows observation of the progress, status, and details of an order as it is initially entered by the sales force and completed at Order Entry. OrderPro application provides support to three primary user communities: Sales, Implementation Coordinator, and Order Entry (Hub). It improves intervals, Reduce expenses, Increase order accuracy, and Improve accountability. The Front-end application was built using SQL, PL/SQL (Oracle) and Java.

Responsibilities:

• Analyzing the user/business requirements and functional specs documents.
• Created project requirements, test plans and test cases in Quality Center
• Writing of test cases to test the application manually in Quality Center and automated using Quick Test Pro.
• Tested the application manually using Quality Center.
• Created test scenarios and reusable actions by using Quick Test Pro.
• Used Quick Test Pro methods to create automated scripts.
• Configured Quick Test Pro with Quality center.
• Involved in regression and functional testing using Quick Test Pro.
• Created checkpoints and synchronization points in test scripts using Quick Test Pro.
• Performed backendtesting to ensure the authentic retrieval of data from the database.
• Used Test Director for defect reporting and tracking.
• Worked on resolving any issues entered into Quality Center by the Business Team during Systems/Acceptance, and Pre-production validation testing phases.
• Coordinated with release manager, team lead and developers to carry out functional enhancement requests and addressing issues related to them.

Environment: QTP, Test Director, MS SQL Server, MS office, oracle 10g