SUMMARY:

• Over 7+ 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).
• 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
• Good experience in preparation of test bed, installation smoke testing, replication of problems and generation of bug report.
• Excellent knowledge of DW concepts including database design star and snow flake schema and testing of slowly changing dimension.
• 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 2012, Teradata 13, MS Access

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

Data warehousing tools: Cognos, Informatica 9.x, Oracle Warehouse Builder, SSIS, Crystal Reports, Business Objects XIDomain Knowledge: Data warehousing, Retail, Finance and healthcare domains

PROFESSIONAL EXPERIENCE:

Confidential, PA

ETL 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.
• 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.
• Created Traceability Matrix for Requirements vs. Test Case Matrix
• Tested front end web applications and defect verification with SQL for data retrieval from database.
• Tested Informatica ETL mappings that transfer data from Oracle source systems to the Data Mart
• Review Test scripts and Test close summary with Business and development.
• Perform Testing regression for integration SSRS reports, Specialty center changes.

Confidential, New York City, NY

ETL 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
• Involved in developing the UNIX scripts for Informatica Workflows using parameter files and monitoring the workflows on testing environment.
• Did testing on multiple Informatica mapping for data validation and data conditioning.
• 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
• 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
• Review project / test performance metrics
• Coordination with tech support team.
• Requirements review, Design review, test plan review, test cases review meetings coordination.
• Weekly reports, interim test reports, build status reports.
• Preparation and presentation to management.
• Analyzed the existing business scenario and understood the business rules.

Confidential, NJ

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.

Confidential, Beltsville, MD

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.