SUMMARY:

• Over 8+ years of IT testing experience with emphasis on Software Testing/Quality Assurance.
• Strong knowledge on all phases of Software Development Life Cycle (SDLC), Software Test Life Cycle (STLC).
• Extensive experience working with ETL tools like Datastage, Informatica, Abinitio, SSIS and Autosys tools.
• Experience working in an Agile/Scrum development process
• Solid knowledge on SQL and Scripting
• Experienced in designing test plans and test cases, verifying and validating web - based applications and Data warehousing and Reporting applications based on standards
• Expertise in Manual/Functional Testing and good idea on using Automation Testing.
• Good idea of data and testing with working knowledge of Retail, finance and healthcare domains.
• Proficient at all stages of Test Life Cycle from test planning to defect tracking and managing defect life cycle and gathering quality related Matrix.
• Excellent experience in SQL and UNIX VI editor commands for data validation and testing the ETL.
• Working experience in testing XML, SOAP and Web Services environment.
• Extensive experience in coordinating testing effort, responsible for test deliverables, status reporting to management, issue escalations.
• Experienced in creating Requirements Traceability Matrix to ensure comprehensive test coverage of the requirements Experience in using Oracle Databases, DB2 UDB, Sybase, SQL Server, Redbrick, Netezza, and Teradata.
• Good experience in preparation of test bed, installation smoke testing, replication of problems and generation of bug report.
• Verifying the error logs created by outputs of ETL processes.
• Strong communication skills, both verbal and written, with particular emphasis on the production of clear and detailed written Test Plans, Business Requirements and Functional Specifications

TECHNICAL SKILLS:

Operating Systems: Windows, UNIX and Mac OS

Languages: VI Editor Command, XML and SQL

Databases: Oracle 11g / 10g, MS SQL 2008, Teradata 13, MS Access, Netezza NPS 8050

Tools: & Utilities: MS Visual Source Safe, Edit Plus, MS Office, TOAD, CA-Harvest, Erwin. SharePoint, HP ALM/QC and Jira

Data warehousing tools: DataStage 9.1/11.5 Informatica 9.6, Cognos, Oracle Warehouse Builder, SSIS, Crystal Reports, Business Objects XI

Domain Knowledge: Data warehousing, Retail, Finance and healthcare domains

PROFESSIONAL EXPERIENCE:

Confidential, Denver, CO

Quality Assurance Analyst

Responsibilities:

• Analyzed the Business Requirement Documents in order to understand the project and the overall goal of the project in agile environment.
• Create detailed, comprehensive and well structured test plans and test cases
• Attended meetings and walkthroughs with Business Analyst, Development Lead and QA Team
• Worked with HP ALM to develop Test Plans and Test cases to cover all the positive and negative scenarios for the given user story to validate the acceptability of the user story in either scenario
• Estimate, prioritize, plan and coordinate testing activities
• Verified the workflow with different scenarios and created Test Data sets for simulating scenarios
• Perform thorough regression testing when bugs are found and resolved
• Developed and executed SQL scripts to validate the data completeness and correctness after either the Job run or after DML execution
• Responsible for writing major SQL commands to validate the data between multiple tables including joins, sub queries, CTE and various SQL functions
• Manually performed back-end testing by writing SQL queries.
• Compared actual and expected test results, discussed the defects in defect meeting with development team.
• Responsible for updating and maintaining the test results in Quality Center (HP /ALM) for all the defects found during functional and Regression testing and follow up of the bug life cycle
• Created test data to cover all positive and negative scenarios.
• Participated as a team member in the agile development process, working closely with the other team members to complete the set sprint assignments and meet production goals
• Conducting knowledge transfer session for testing team.
• Extensively worked with QC to develop full lifecycle Test Plans including business rules and business models for functional, end to end and User Acceptance testing.
• Responsible for running Jobs in Datastage Director to populate the data from a designated source table to the target table and validate the job status including WARNINGS/ERRORS(if any)
• Responsible for running and monitoring the SEQUENCE JOBS to validate all the parallel jobs incorporated under the sequence job are being called properly and validating the job STATS for all the sequence and parallel jobs.
• Responsible for staging records in Trilogie and run the simulated PROD environment type BUILD in the test environment to validate the parallel job works effectively when incorporated in the sequence that is scheduled to run automatically.
• Responsible for validating the Cognos reports by writing complex queries on the backend like Dashboard, Summary Reports and Drill Down. Reports

Environment: Netezza, Cognos, HP ALM, Datastage, SQL.

Confidential,Livingston,NJ

ETL QA Test Analyst.

Responsibilities:

• 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, and Report testing.
• Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down.
• Monitored the data move process through Data Extract to Flat file through Informatica
• Execution flows and Loading data to Netezza Data mart through NZLOAD utility.
• Testing the ETL data movement from Oracle Data mart to Netezza Data mart on an Incremental and full load basis.
• Written Test Cases for ETL to compare Source and Target database systems.
• Identified requirement and Code gaps to reduce business risk ahead and created Test design estimations timeline based on reviewed scope.
• Create Master test plan and review testing approach with Project management, Development, Business Analyst to identify dependencies and make changes where it is necessary.
• Create Test cases in HP Quality Center to write test cases (TPS), analyzed the results, track defects in QC.
• Performed UI/Reports and Data centric tests for to satisfy business in test SQL server environments
• Validate data lodes in Pre-prod/UAT environment before deployment to Users
• Co-ordinate with the team to ensure and track total quality deliverables to satisfy business need.
• Prepared documents on every errors/defects and deployed solutions for those.
• Validated Cognos reports using complex SQL queries.
• Wrote and executed complex SQL queries to conducted Backend Testing for data validation and verification on database. Responsible for the design and development of Datastage Parallel Jobs.
• Designed ETL jobs incorporating complex transform methodologies using DataStage tool resulting in development of efficient interfaces between source and target systems.
• Created Traceability Matrix for Requirements vs. Test Case Matrix
• Tested front end web applications and defect verification with SQL for data retrieval from database.

Environment: ETL DataStage8.1/8.5, SQL Server 2008, Netezza, SQL, Windows XP, MS Office Suite, HP Quality Center, Cognos 10, SQL Server reporting Services (SSRS), Citrix, SQL Server Management Studio.

Confidential,Brooklyn, NY

QA PL/SQL Tester

Responsibilities:

• Test plan preparation, Test Strategy preparation, Test cases review, test cases execution, designing, executing, verifying and analyzing test programs.
• Created test scripts to validate the data between various LOBs as source and EDW as target system
• Uploaded all test cases to Quality Center
• Mapped test cases with the requirement and created RTM.
• Logged all the defects in the Quality Center
• Performed smoke and sanity testing
• Review of test cases, test plan with business and edited Entry & Exit criteria
• Unit tested BO reports before moving to the staging area.
• Executed the Oracle SQL Test Scripts in TOAD and documented the results in RTM.
• Analyzed SQL code to ensure Business Objects queries the correct data from the database
• Run the jobs through CA Autosys scheduler.
• Did DB/Backend Testing to ensure The field size validation, Check constraints, Indexes are done or not (for performance related issues), Stored procedures, The field size defined in the application is matching with that in the db Customized the DataStage jobs par with current business enhancements.
• Followed up deployment process of DataStage code migration on different environments (development, test and production) with admin team.
• Developed Teradata SQL test scripts from test procedures and executed them with Queryman or BTEQ query utilities
• Tested and modified the Business Objects WEBi Reports for various financial groups using the Universe as a main data provider
• Tested reports using Business Objects functionality like Queries, Slice and Dice, Drill down, @Functions, Formulae etc
• Business components preparation and storing in Quality center
• Performed sanity testing
• Analyzed the existing business scenario and understood the business rules.

Environment: DataStage 7.5, Business Objects XIR3, Auto Sys, Oracle 10g, Teradata 12.0, Teradata SQL Assistant 12.0, SQL, PL/SQL, TOAD, Quality Center 10.0, Agile Methodology

Confidential,Seattle,WA

QA ETL Tester

Responsibilities:

• 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 Data Validation, Cube Testing and Report testing.
• Tested to verify that all data were synchronized after the data is troubleshoot and also used SQL to verify/validate my test cases.
• Written Complex SQL queries to validate the data against Oracle and SQL Server.
• Reviewed data load into the data warehouse for accuracy
• Experienced in Data Scrubbing and cleansing for Inconsistent / duplicate / erroneous data.
• Maintained and enhanced data acquisition process to improve accuracy of data warehouse data
• Experienced in the area of data integration and data exchange
• Data conversion from Leap and other outside business vendors to DW staging and production tables
• Data flow accuracy and reliability from leap to DW
• Wrote intermediate to complex Queries, Sub queries, Joins, group by, etc. using standard query language
• Designed, developed, tested and documented of reporting services using crystal reports
• Facilitated Error detection and correction through the standard procedure defined by the organization knowledge and experience in analyzing data in the database
• Used automated testing tools to create test cases in test lab and test plan module of Mercury Quality Center.

Environment: DB2 UDB, Mainframe, SQL, Quality Center 8.0, Oracle 8i, SQL Server, XML Files

Confidential,Houston, TX

ETL/BI Tester

Responsibilities:

• Managed individual test cycles, reported bugs and worked with analysts and developers to resolve problems and Involved in writing and executing test cases based on the requirements.
• Performed End-to-End testing of full functionality
• Experienced in using Mercury Quality Center as a defect tracking tool.
• Involved in Component Testing, Functional Testing, Integration Testing and Regression Testing.
• Involved in performing Regression testing manually for every new Releases.
• Worked on Waterfall and Agile both methodology
• Involved with the Solutions Architect and the Business Team for validation and verification of the ETL data loading.
• Used SQL tools like TOAD to run SQL queries and validate the data in warehouse.
• Tested various mappings like Update Strategy, Look up, Sequence Generator, expression, Aggregator, XML, Stored Procedure and tested the mappings for data verification in Designer
• Tested workflows and tasks in Workflow Manager and linked the database through server setup and various other connections.
• Did various data load simulations to stress test the mappings
• Involved in monitoring Informatica jobs/processes using Workflow Monitor
• Tested the shell scripts to backup the log files and job scheduling in SIT, QA, UAT and Production.
• Tested mapplets in place of mappings which were repeatedly used like formatting date or data type conversion.
• Co-ordinate with the off-shore teams and mentored junior QA’s.
• Tested the reports using Business Objects functionality's like Queries, Slice and Dice, Drill Down, @Functions, Cross Tab, Master Detail and Formulae's etc.
• Involved in trouble shooting of various reporting errors for testing needs.
• Tested Business Objects reports, Queries with constant interaction with the end users. Trained end users in understanding the reports.

Environment: Informatica Power Center 8.1.2, Oracle 10g, Erwin 4.0, pmcmd scripting, Shell Scripting, TOAD, PL/SQL, UNIX, PERL, HP Quality Center 9.2, Business Objects XIR2, VSAM Files, COBOL Copy Books, XML Files, Flat Files, Web Services.