SUMMARY:

• 7+ years of experience as a QA Test Engineer using Manual & Automation Testing. Worked in multiple domains like Health Care, Finance and Telecom Domains
• Extensive experience working with SQL for validating the ETL feeds and transformations.
• Extensive experience working with SQL for validating the BI reports and business specifications.
• Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
• Experienced in testing all kinds of reports generated using Cognos and Business Objects reports.
• Managing test cases, executing test cases and also tracking defects using Quality Center
• Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within time frame
• Extensively strong on databases including Oracle 11i/10g/9i/8i, MS SQL Server 2005/2008/2012 and Teradata, Sybase.
• Good experience in Data Modeling concepts: Star Schema and Snow Flake Schema.
• Extensive knowledge in regression testing and design documentation.
• Extensive experience in writing SQL and PL/SQL scripts to validate the database systems and for backend database testing.
• Extensive working experience with UNIX and PERL script.
• Expertise in Functional testing, Integration/System testing, Regression testing and User Acceptance testing.
• Ability to perform end to end testing by understanding the entire system functionality.
• Good experience in data sources, data profiling, data validation, developing low level design patterns based on the business and functional requirements.
• Good understanding of Software development and technical Networking systems.
• Excellent communication, analytical and interpersonal skills
• Ability to work in fast pace environments.
• In - depth knowledge of Whitebox Testing

TECHNICAL SKILLS:

Languages: Java, Java Script, CSS, HTML, Shell Script

Technologies: J2EE, JSP, JDBC, HTML, Java Script, SOAP, XML, Peoplesoft.

QA Tools: SELENIUM IDE/RC/ Web Driver/ GRID, QTP, JUNIT 3/4, TEST NG, Firebug, FirePath, xpath, Maven, JSON, Jenkin, SVN, JXL

Bug Tracking Tools: Quality Center, BugZilla, JIRA

Web Services: SOAP, RESTFUL, WSDL, SOAP UIReporting Tools Cognos 8.0 Suite, Business Object XI 3.1, Crystal Reports, OBIEE, SSRS.

Operating system: Windows, MAC, DOS, Linux/ Unix

Database: Oracle, SQL Server, MS Access, MySQL ETL Tools Infrmatica, Datastage, Ab Initio, SSIS

Web Servers: Tomcat, Web Sphere, Web Logic, IIS

Browsers: Internet Explorer, Firebox, Chrome, Safar

PROFESSIONAL EXPERIENCE:

Confidential, Cleveland OH

ETL Tester

Responsibilities:

• Analyze the Business Requirements and closely work with the Business Team to get the clarifications addressed
• Run Defect Triaging and Review the Test Scenarios/ Test Cases with Business Review Business requirement for different Specialty center modules and provide Test estimation to project management
• Analysis of Business requirements & Design Specification Document to determine the functionality of the ETL Processes.
• Tested reports developed by Business Objects Universes for both Adhoc & Canned Reporting users of Business Objects XI R3
• Planning for Test Execution activities to accomplish tasks on daily/weekly basis
• Actively participate in review meeting including Functional Spec, Test Plan and Test Case
• Involved in the error checking and testing of the ETL procedures and programs Informatica session log.
• Used Control M and Tivoli to run the schedules
• Performed browser compatibility testing Performed front end web application testing and verified and validated defects using SQL to retrieve data from database.
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes.
• Working experience on daily status reporting & managed end to end testing
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes. People soft involved in testing accounts table

Environment: IBM Data Stage 8.0, Control M, Tivoli, Peoplesoft ERP, Business Objects XI R3, Oracle, SQL, PL/SQL, MS Office Suite, Quality Center, Clear Quest, Unix, Windows.

Confidential, Arlington VA

ETL Tester

Responsibilities:

• Worked with all kinds of components with Ab Initio including Dedup, Denormalize, Normalize, Rollup, Scan, Reformat, Redifine, Sort, Joiner, XML Read, XML Write, FBE, Partition Components.
• Run Defect Triaging and Review the Test Scenarios/ Test Cases with Business Review Business requirement for different Specialty center modules and provide Test estimation to project management
• Analysis of Business requirements & Design Specification Document to determine the functionality of the ETL Processes.
• Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing, front end user interface testing.
• Worked with all kinds of components with Ab Initio including Dedup, Denormalize, Normalize, Rollup, Scan, Reformat, Redifine, Sort, Joiner, XML Read, XML Write, FBE, Partition Components.
• Executed parallel browser testing on various machines using Selenium Grid and performed cross browser testing.
• Tested Ab Initio graphs and used Ab Initio as an ETL tool to load the final loads.
• Actively participate in review meeting including Functional Spec, Test Plan and Test Case.
• Worked with end users to generate UAT scripts and to successful completion of UAT testing
• Performed browser compatibility testing Performed front end web application testing and verified and validated defects using SQL to retrieve data from database.
• Report testing Extensive experience with Reporting Tools like OBIEE
• Working experience on daily status reporting & managed end to end testing

  Environment: Ab Initio CO>OP 2.15, Oracle, SQL, OBIEE, PL/SQL, MS Office Suite, Quality Center, Unix, Windows.

Confidential, Tampa FL

ETL Tester

Responsibilities:

• Interacted with Business Analysts, Developers and support team to define the testing requirement documents along with the QA Manager and mentored the QA Team accordingly.
• Extensively used Data Stage for extraction, transformation and loading process.
• Implemented whole life cycle of QA Methodologies starting from Planning, Capturing, Creating, Executing, Reporting, and Tracking the requirements, defects and changes to Project Plan using IBM Rational Clear Quest, MS Excel, MS Word and MS Visio.
• Inserted various types of check points including text checkpoints, text area checkpoints and Image checkpoints.
• Strong in writing UNIX shells scripting. Automated and scheduled the Data stage jobs using UNIX Shell Scripting.
• Used Unix Commands to access and trouble shoot Errors by accessing the Error Log files.
• Participated in Design Phase, together with members of the Product team, developers, and DBAs.
• Performed Smoke, System testing, system Integration Testing, User acceptance, Database & Regression testing.
• Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards
• Expert with Test documentation, such as Test Cases, Bug Reports, Use Cases etc.
• Designed various test Cases with different test conditions.
• Extensively used Data Stage for extraction, transformation and loading process.
• Worked with ETL group for understating Data Stage.
• Performed Regression testing by executing the scripts developed with QTP.
• Conducted User Acceptance Test (UAT) with users and customers and wrote issues log based on outcome of UAT.
• Adopted Data Driven Methodology to the test application with different sets of data.
• Develop test cases on various types of credit card applications.
• Developed test plan to test the ETL system thoroughly.
• Extensively interacted with developers to analyze & resolve issues that were encountered while testing application.

  Environment: Oracle, SQL, IBM Data Stage 8.0, PL/SQL, Stored Procedures, DB2, Quality Manager 8.0, Points Portal, MS Office Suite, Cognos 7 Series, IBM Mainframe, TOAD, Requisite Pro, Rational Clear Quest, Test Manager, Automation through Infogix/Manual Testing

Confidential - Charlotte, NC

ETL Tester

Responsibilities:

• Actively participated in multiple review meetings including Stakeholders Scope, Functional Spec, Test Plan and Test Case.
• Create Test strategy and review testing approach with Project management, Development, Business Analyst and Business Users to identify dependencies and make changes where it is necessary.
• Used Rational Quality manager to write test cases, analyzed the results, tracked the defects and generated the reports.
• Metadata graphs from legacy source system to target database fields and involved in creating Ab Initio DMLs.
• Prepared test scenario and review with Business Users according to Business requirement and use cases to cover business scenarios.
• Created Test Cases and Test scripts for Scenarios document by understanding the requirements and functional spec.
• Involved in developing Unix Korn Shell wrappers to run various Ab Initio Scripts
• Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic
• Reported the bugs through email notifications to developers using Quality Manager
• High Level Test Plans were written by incorporating User Profiles, Configurations, Environments, Risks, Test Scenarios, Schedules and Analysis and Presentation of Results
• Involved in validating both functional and automated business processes using Quality Manager.
• Tested Ab Initio graphs and used Ab Initio as an ETL tool to load the final loads.
• Performed front end web application testing and verified and validated defects using SQL to retrieve data from database.
• Documented all errors/defects identified and implemented their resolutions as defined by management.
• Involved in Manual and Automated testing using RQM and Robot
• Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards
• Developed strategies and plans for test automation, and implemented automated test scripts.
• Worked with software testing methodologies with all phases and stages of testing desired (Functional, System, Integration, Regression, Data Validation, User Acceptance, Performance, Stress and Load)
• Inserted verification checkpoint for the validation of the functionality under stress conditions.
• Engaged in daily triage meetings and reporting.
• Written several complex SQL queries for validating Cognos Reports.
• Facilitated formal review meetings with users and developers to report, demonstrate, prioritize and suggest resolution to issues discovered during testing cycles
• Tested ETL Mappings and worked with Staging area to validate the data with SQL queries. Worked with Legacy and current data sources and ETL Transformations (Data cleansing validations and Matching processes)

Environment: UNIX, Oracle 9i, SQL Server2005, Autosys, Ab Initio, VB script, Rational Quality Manager 10.0, SQL, Cognos 7 Series, PL/SQL, PERL, Shell Scripting, Windows XP, MS Office Suite.