SUMMARY

• 7+ years of IT experience in Software Quality Assurance & Testing of various business applications in client/server environments, web based applications, Data Warehousing and Business Intelligence solutions on Banking & Telecom domains.
• Experienced in QA on Cognos reports and Informatica ETL mappings.
• Expertise in Manual Testing.
• Expertise in Test Management includes Test Strategy Design, Effort Estimation & Resource Loading, Test Plan Design, Defect Management and Test Reporting.
• Expertise in Data Warehouse / BI Testing includes ETL & Report testing.
• Work experience on the Banking DW model which is a standard DW model proposed by IBM to support BASEL regulatory compliances.
• Strong knowledge on DW architectures includes 3NF / Star / Snowflake Schemas and Entity Relationships, ETL concepts includes history / delta loading and DB SQL Querying.
• Widely used QC / ALM modules like Requirement, Test Plan, Test Lab, Defect and Dashboards for testing activities.
• Good knowledge on UNIX Environment to access and process delimited file data, compare files, file transfer and creating shell scripts.
• Strong knowledge of Software Development Life Cycle (SDLC) as well as Software Testing Life Cycle (STLC) and the Role of QA.
• Extensively experience in analysing business requirements and specifications, development and execution of Test Plans and Test Cases.
• Strong experience in all levels of testing such as System / System Integration / Sanity / Regression / Tech UAT Testing.
• Involved In requirement analysis, and defect reviews with the development team
• Worked with both on - site & offshore Testing team and reported directly to QA Manager.
• Excellent Organization, Analytical and Problem Solving skills and ability to quickly learn new technologies.
• Interacted with developers to assure quality of testing
• Proven success in meeting and exceeding customer needs as an individual contributor and as a team with good Communication, Interpersonal and Team Work Skills.
• Excellent Documentation and Communication skills, willingness to learn the latest cutting edge technologies
• Ability to understand and translate Business Requirements and to operate independently or in a team environment. Well versed in different management scenarios like Change Control, Quality Assurance, Defect Tracking and System Integration.
• Strong Team player and contribute towards the team goals.
• Ability to work productively and effectively in a team as well as individually.

TECHNICAL SKILLS

Operating System: Microsoft Windows XP,LINUX, UNIX

Languages: SQL, PL/SQL, Java Basic, C, C++, HTML

Test Management Tools: HP Quality Center 10.0, ALM 11.0

RDBMS: Oracle10g, Oracle11g, DB2

Application Tools: Informatica 9.x, Informatica 8.x, Cognos 8.3, Putty 0.62, Winscp, DB2, Toad for DB2 4.7.x, Toad for Oracle, Winscp 4.3.x, PL/SQL Developer 7.x, MS Office/MS Word

PROFESSIONAL EXPERIENCE

Confidential, Greensboro, NC

Sr. QA Analyst

Responsibilities:

• Analysing business requirements and Functional Specifications rules and worked with Business Analyst and Business Users in preparing test plans.
• Developed Test Cases, Test Scripts form the data mapping documents, functional specification documents and mapped the test cases with requirements for generating the Requirement Traceability Matrix (RTM).
• Developed and executed manual test cases.
• Involved in testing Mapping Sources and Targets, performed data validation while dealing with missing data and reconciling during extracts and loads.
• Extensively written SQL to confirm the data transfer from source to target and report data
• Involved in identifying the defects and raising them in HP ALM and assigning to the respective team.
• Maintaining defect tracker sheet to track the defect status so management can make decisions on priority defects
• Involved in defect analysing and worked in coordination with various teams and work on resolving the defect and close the defect in the given time.
• Report defect issues into the bug reporting/tracking systems and followed up with the development, Business, environment teams and other related teams respectively until resolved the status of the defect accordingly using ALM.
• Used HP ALM to prepare Test cases, procedures and Requirements Traceability Matrix
• Used HP ALM for test management and defect management activities
• Involved in User Acceptance testing and Post implementation.
• Involved in running and modifying UNIX scripts and other SQL validation scripts, and writing SQLs to validate the outputs
• Performed Functional, Regression, UAT and Integration testing.
• Done research on validating the quality of Data Extracts from the source system before loading it to the database
• Assigning tasks to offshore team and coordinate with them in successful completion of deliverables.

Environment: Oracle 11g, Informatica 9.x, ESP Scheduler, HP ALM 11.0, Toad, Putty / Unix, Winscp, MS Word, MS Excel

Confidential, San Diego, CA

Informatica ETL & BI Tester

Responsibilities:

• Interacted with business users and developers, collected business information and their requirements to test reports.
• Involved in analysing the Business Requirements.
• Understand the ETL mapping design and preparation of test cases.
• Testing the Informatica facts and dimensions in various scenarios so as to identify the defects.
• Testing of Cognos reports including data validation and UI.
• Develop and write a suite of Test Scripts that included Acceptance, Functional and Regression test cases of Cognos reports.
• Testing for the informatica ETL out-of-box mappings by writing SQL’s
• Execution of test cases and capturing the test results and validate the actual results against the expected results.
• Maintaining defect tracker sheet
• Verified that all modules were tested properly based on requirements
• Used Quality Center to prepare Test cases and Requirements Traceability Matrix
• Generated Test Analysis Report using Quality Center
• Participate in requirement review meeting and discuss about required testing strategy
• Coordination with developers for defects closure.
• Summarize the test results and defects
• Involved in System Integration Testing
• Verified the Business Scenarios on new builds to allow extended testing by the QA team.
• Involved in identifying the defects and raising them in HP ALM and assigning to the respective team.
• Involved in defect analyzing and worked in coordination with various teams and work on resolving the defect and close the defect in the given time.
• Involved in regular day to day internal, business and defect triage meetings and implement for any accordingly.
• Interacted with client and updated daily status reports.

Environment: Oracle 11g, Cognos 8.3, Windows XP, PL/SQL Developer 7.0, HP Quality Center 10.0/ALM 11.0, Informatica Power Center, MS Word, MS Excel

Confidential

ETL Quality Analyst

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 9.2
• Prepare Test strategy and Test plan.
• Create, develop and execute test cases based on test strategies and test plans according to ETL Mapping document.
• Validated the source to target transformation mappings (ETL transformations ) which extracts and loads from flat files to database
• Execution of test cases and capturing the test results
• Maintaining defect tracker sheet.
• Coordinated with Dev team about the issues and prioritized
• Coordination with developers for defects closure.
• Summarize the test results and defects
• Used Quality Center to prepare Test cases and Requirements Traceability Matrix
• Involved in User Acceptance testing and Post implementation.
• Involvement in running and modifying UNIX scripts and other SQL validation scripts, and writing SQLs to validate the outputs
• Performed Functional, Regression, UAT and Integration testing
• Prepared documentation for some of the recurring defects and resolutions and business comments for those defects.
• DevelopedTest Matrixto give a better view of testing effort.
• Prepared pivot tables and charts of Test Results using Excel.

Environment: IBM DB2, Toad, Informatica Power Center, HP Quality Center, MS Excel, MS Word, Putty/Unix, Winscp