SUMMARY

• Over 7 years’ experience as Software QA engineer in Manual & Automated Testing, Client/Server, ERP, .Net applications and Web - based environments in a rapid development environment utilizing best QA practices.
• Well versed with Software Development Life Cycle (SDLC), Agile / SCRUM Development, Software Testing Life Cycle (STLC) in all the phases with major responsibilities.
• Worked closely with other members of the Development Team to review the designs of the system, implement test plans, and effectively managed Off-Shore testing teams.
• Participated in System Requirement Analysis, GUI Testing, Functionality testing, Integration Testing, Stress/Load testing, Regression Testing, Performance and User Acceptance Testing, Integration Testing, Smoke Testing and System Testing.
• Exposure in both Manual and Automated Testing using products like UFT (Unified Functional Testing), QTP, Quality Center.
• Ability to read/understand API development and scripting languages such as Java, CSS, HTML,VB and Java Script
• Strong SQL skills and worked on Oracle and MS SQL Server, with ability to perform basic to complex select statements, database joins perform update/insert test data to databases.
• Participated in Requirements review and supported User Acceptance and Production Verification Testing and on creating Traceability Matrix between Requirements and Test Cases using HP Quality Center (QC).
• Worked across multiple cross-functional teams to execute full system, interface, and end-to-end testing.
• Excellent Organizational, Analytical and Problem solving skills and ability to quickly learn new technologies.
• Good communication, interpersonal, Teamwork skills and leadership Qualities.
• Ability to work under pressure and meet SLA’s and deadlines
• Domain experience in Banking, Financial, Energy and Health Care clients with good Business and Functional knowledge.
• Experience in drafting Business Requirement Documents (BRD), Functional Specifications Document (FSD) and developing test plans.
• Actively worked with Design, development and other teams to translate technical, functional and non-functional requirements into use cases and testing scenarios
• Experience and expertise in taking ownership and responsibility for developing and enhancing of various QA and testing related best practices
• Experience in ensuring the software applications / Products confirm to the Quality standards and meets all the requirement specifications
• Knowledge of applications, skills, tools, and techniques to the definition, planning and tracking of project activities to meet or exceed customer and stakeholder needs and expectations.
• Experience and expertise in QA and testing in various phases of project like Design, development, testing, UAT and production support of applications.
• Proactive, quick learner and ability to Understand and work on various applications in a distributed environment
• Responsible for creating test cases based on business, functional and technical requirements documents
• Lead testing efforts successfully for the projects involving multiple technical and distributed environments.
• Involved in End - to - End web testing of applications supporting various platforms.
• Familiar with project management methodologies including Agile, scrum and Waterfall.

TECHNICAL SKILLS

Databases: Teradata T 12, Oracle, DB2, SQL Server, MS Access.

Operating systems: Windows 9x/NT/XP/Vista, UNIX, LINUX.

Database Tools: TOAD, SQL Developer.

Languages/Scripting: Java, Visual Basic, SQL, VB Script, Perl, Shell, Groovy, PHP, Python and Ruby.

Data Warehousing: Informatica 9.x/8.x, Ab Initio

Reporting: Business Objects, Cognos

Testing/Requirements: HP Quality Center 9, 11

Web Browsers: Internet Explorer, Mozilla Fire fox, Netscape Navigator.

File Compare Tools: Text Pad, Excel, Notepad.

PROFESSIONAL EXPERIENCE

Confidential, HI

Sr. ETL QA Tester

Responsibilities:

• Extensively involved in Developing Test Plans, Test Scenarios, Test Strategies and Test Cases with inputs from the assigned Business Analysts.
• Developed test scripts based upon business requirements and processes, in line with defined workflows and use cases.
• Processed transactions from system entry to exit. Tested functionality across applications and workflows.
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance.
• Ensuring smooth onsite to offshore transition of requirements and conducting knowledge transition sessions.
• Good experience in web related technologies including HTML, XML, SOAP, JavaScript, ASP, VB, VB.NET,ASP.NET
• Experienced in creating the SSIS packages, DTS
• Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards
• Metadata graphs from legacy source system to target database fields and involved in creating Ab Initio DMLs.
• Good experience in writing SQL in order to data validation in migration as part of backend testing
• Communicate directly with different business owners in the company to understand product and system requirements
• Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic
• Generated reports using SOAPUI.
• Hands on experience in Automation testing using QTP.
• Attend Daily Scrum meetings / Defect review meetings
• Involved in developing Unix Korn Shell wrappers to run various Ab Initio Scripts
• Performed System Testing, Regression Testing, Performance Testing, end-end testing and Production Smoke Test.
• Involved in testing designing and development of Data warehouse environment.
• Implemented SDLC, QA methodologies and concepts in the Project.
• Coordinated component, system testing with the appropriate technical groups and Release Management and documented test procedures and findings.
• Written several complex SQL queries for validating Cognos Reports.
• Wrote SQL and PL/SQL scripts to perform database testing and to verify data integrity
• Reconciled test results from different tests and different groups. Assessed readiness and deviation of product/project performance based upon test results and product specifications.

Environment: Ab Initio CO>OP 2.15, GDE 1.15, PL/SQL, Cognos 8.0 Series, Oracle, SOAPUI, SSIS, AGILE, HP Quality Center 11, SQL Server 2012, TFS 2010, QTP, Control-M, Teradata 13, UNIX, Autosys.

Confidential, MA

ETL QA Analyst

Responsibilities:

• Worked with Business analysts to understand Business/System requirements in order to transform business requirements into functional test cases.
• Responsible for reviewing Functional specs, user documentation and use cases and developing manual test cases out of it.
• Tested reports developed by Business Objects Universes for both Adhoc & Canned Reporting users of Business Objects XI R3
• Responsible for planning and directing Quality Assurance and Software change control policies.
• Study and analysis of the mapping document indicating the source tables, columns, data types, transformations required, business rules to be applied, target tables, columns and data types
• Coordinated in setting up Test Environments and Test Plan needs with team members.
• Developing various Test Scripts, Test Execution using Quality Center based on the Functional Specifications.
• Executed Test Cases using positive and negative data in Quality Center’s Test Lab and reported results and defects using Quality Center’s Defects tool.
• Involved in validating the Data mart tables as per the business logic applied to the staging tables.
• Executed the test scripts against Teradata source and validated the rules according to mapping documentation.
• Tested ad hoc and canned reports for Business objects.
• Testing and validation of the developed Informatica mappings.
• Worked with Testing of Flat File and XML data.
• Developed SQL queries for Back-end testing/Database testing and participated in end to end testing.
• Validated the source system data with the staging data using SQL and Pl/SQL scripts.
• Reached Testing Goals by doing Data Completeness, Data transformation, Data Quality, Performance and Scalability
• Performed System Testing, Functional Testing, Regression Testing.
• Prepared Traceability Matrix with requirements versus test cases.
• Tested several UNIX shell scripting for File validation and also PL/SQL programming
• Involved in identifying the defects and developed Defect Tracking report using HP Quality Centre which involved Bug life cycle.
• Provided daily and weekly status reports.

Environment: Quality Center, ALM, Business Objects XIR3, Informatica Power Center 9.1/8.6, Erwin, Ms Excel, Oracle 10g, SQL,, TOAD, XML

Confidential, N.C

ETL QA Analyst

Responsibilities:

• Performed Database validation, Testing and conformance in a Data warehousing environment on EHR health records.
• Working on file systems in the Unix environment
• Involved in end-to-end web testing of applications supporting various platforms
• Used UNIX for working for file permission and controls.
• Written SQL Queries to define, Identify and validate the code written for the data movement into the database tables.
• Retested the resolved defects/issues after the developers fixed the defects.
• Involved in testing Java based web-based applications on Electronic health records incentive programs supported by government.
• Involved in preparing Test Summary Document.
• Involved in testing cross browser and Platform testing web applications
• Involved in preparing test data for UAT and participated in UAT signoff.
• Interacted with developers regarding priority of bugs and update the status of bugs once they are fixed.
• Involved in Data Validation using SQL queries.
• Prepared test data for positive and negative test scenarios as per application specifications. Involved in both Manual and Automated test plans and test cases.
• Queried the Teradata Database for Data verification and validation.
• Involved in Business objects front end validation of data
• Checked for Data Profiling and Date format issues in Teradata.
• Checked for Data quality issues in Teradata database.
• Prepared test data for positive and negative test scenarios as per application specifications.

Environment: Teradata, SQL Assistant 6.0, Oracle 9i/10g, XML, Flat Files, Business Objects, MS Excel, 9.x, SQL, Windows, Quality Center.

Confidential

ETL QA Analyst

Responsibilities:

• Involved in DATA validation using SQL queries and back-end testing.
• Used SQL for Querying the database.
• Developed separate test cases for ETL process (Inbound & Outbound).
• Involved with Design and Development team to implement the requirements.
• Developed and Performed execution of Test Scripts manually to verify the expected results.
• Validated that design meets requirements and function according to technical and functional specifications.
• Used HP Quality Center 9.2 to state requirements, business components, test cases, and test runs for every iterations, defects. Also link defects with requirements.
• Created Requirement Traceability Matrix for various projects.
• Performed all aspects of verification and validation.
• Worked with other members of the QA and Development teams and offshore team in improving the processes, methods, effectiveness and efficiency.
• Used TOAD & SQL Navigator tools for Querying Database.
• Documented and reported various bugs during Manual Testing.
• Written SQL Queries to define, Identify and validate the code written for the data movement into the database tables.
• Reviewed the Business Requirement Documents and the Functional Specification.
• Prepared Test Plan from the Business Requirements and Functional Specification.
• Developed Test Cases for Deployment Verification, ETL (Informatica) Data Validation, Cube Testing and Report testing.
• Performed Functional, Regression, Data Integrity, System, Compatibility.
• Involved with ETL test data creation for all the ETL mapping rules.
• Preparing and supporting the QA and UAT test environments.
• Was involved in analyzing scope of testing the application. Test Strategy was created to test the all modules of the Data Warehouse.
• Created the test data for interpreting positive/negative results during functional testing.
• Involved in the whole testing life cycle covering the entire project from initiation to completion.
• Clearly communicated and documented test results and defect resolution during all phases of testing.
• Tested different detail, summary reports and on demand reports.
• Worked closely with the Business Analysts, Systems Analysts, Developers, and DBAs to solve the issues identified during the testing process in a timely manner.

Environment: Oracle 9i/10g, SQL,Informatica, Oracle, Quick Test Pro 8.0, Quality Center 8.0,, MS Office Suite, Cognos 7.3 / 8 Series, TOAD, AB - initio, Windows, SQL, MS OFFICE, HTML, VB Script.

Confidential

ETL QA Analyst

Responsibilities:

• Responsible for Business analysis and requirements gathering.
• Organized training to newcomers in the team regarding different technologies like SQL, PL/SQL and different processes.
• Attending Client calls for Business understanding and Clarifications.
• Designed and developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads.
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance
• Wrote SQL and PL/SQL scripts to perform database testing and to verify data integrity.
• Extract data from Mainframe data sets to compare against Target Values.
• Reported bugs and tracked defects using Quality Center 8.2 (Test Director)
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Involved in testing of Universes from different data sources like Oracle/SQL Server.
• Used various @Functions like @Prompt (for user defined queries), @Where (For creating conditional filters), and @Select.
• Defined data requirements and elements used in XML transactions
• Involved in Writing Detailed Level Test Documentation for reports and Universe testing.
• Written complex SQL queries for validating the data against different kinds of reports generated by Business Objects XIR2
• Tested many different reports developed in Business Objects including Dashboards, Summarized Reports, Master-Detailed, Cascades, Grouped List, KPI's etc.
• Involved in data warehouse testing by checking ETL procedures/mappings.
• Tested various graphs for both negative and positive scenarios.
• Involved in creating source target mappings based on the Technical Design requirements.

Environment: Quality Center 8.2, SQL, PL/SQL, Business Objects XIR2, Ab Initio CO>OP 2.14, AB INITIO GDE 1.14, EME, MainFrame Flat Files, COBOL II, XML, ITG, Service center, UNIX, Oracle 10G, DB2, TOAD