SUMMARY

• 8 years of experience in Software Quality Assurance (QA) and tested Data Warehouse, Database (ETL & BI), Web, Ecommerce, and Client - Server Systems and Applications for Health, Financial, Telecom and Retail sectors.
• Excellent working experience in testing Data Warehousing jobs (Informatica, SSIS, DataStage) and applications, Business Intelligence reports (OBIEE, SSRS, Micro Strategy, Cognos), Java based applications, Quality Assurance and management.
• Extensively done Data Centric Testing (data testing requiring data to be moved, copied from source to target systems correctly and completely, Checksum comparison, checking quality of data).
• Excellent experience on Ecommerce QA testing in the design and implementation of testing solutions, with a specialty in Point of Sale (POS) and JDL retail systems.
• Sound understanding in Software Development Life Cycle (SDLC), waterfall and Agile models .
• Used Master Data Management (MDM) and TDM technology, tools to create and maintain consistent and accurate lists of Master.
• Expeeience in planning and executing Smoke, Functional, Integration, Regression, User Acceptance Testing, Compatibility Testing for Java and .Net based web application, Data Warehouse Application, UNIX based applications and Client Server applications.
• Experience testing ETL, PL/SQL, UNIX batch jobs using scheduling tools such as Autosys.
• Very good experience working with UNIX commands and UNIX Shell Scripting.
• Experienced in writing detailed Test Plans, Test Strategy, Test Data Management Plan and maintained Test Readiness Reviews (TRR) for large releases, application enhancements, maintenance releases and defect fixes for various applications.
• Knowledge in creating Business Scenarios, Test Scenarios, Test Cases for System, Integration, Regression using HP Quality Center and User Acceptance Testing.
• Experience working with Data Warehousing, Data Validations, Data Scrubbing, Data Cleansing, Data Profiling and Data Frequency Analysis.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica.
• Excellent working experience on Informatica Workflow Manager to run the workflows and monitored the status and logs in Workflow Monitor.
• Validated data consistency, data completeness, de-duping logics in data migration and data conversion projects.
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
• Experience in testing 3NF Data Warehouse, Star Schema Data Marts, Data Stage jobs.
• Automated test scenarios for GUI, Functionality and performed data driven testing on the application inserting different data in excel sheet using QTP/sellinium
• Tested 4010/5010 conversion EDI transactions, 820, 834, 835, 837 etc.
• Review application enhancements with UAT tester and business testers
• Experienced in Informatica Data Validation Option (DVO) suite to automate ETL testing
• Participated in building automation test scripts based on BPT module of Quality center.
• Managed all testing artifacts in HP Quality Center, TFS (Team Foundation Server), utilized the same for test execution and reporting.
• Expert in writing Complex SQL quires for backend testing and created several queries on the fly for user specific requirements for trouble shooting day-to-day production issues to identify root cause.
• Tested migration of applications from Development to Production environments.
• Data Warehouse System Development Life Cycle

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x/8, SSIS, Data Stage, AbInitio

QA Tools: HP - Quality Center, TFS, Quick Test Pro (QTP), Selenium, JIRA

DBMS/Query Tools: TOAD, Rapid SQL, SQL Developer, SQL Navigator

Languages: SQL, PL/SQL/Cucumber/Ruby/Java

Databases: Oracle11g/10g, SQL Server 2008, DB2, Teradata V2R6/V2R5

Version Control Tools: Rational Clear Case, WIN CVS,TFS, Subversion

Requirements Tools: Doors, Rational Requisite Pro

BI / Reporting Tools: IBM Cognos 8.0, Business Objects BOXI, SSRS

Operating Systems: Microsoft Windows 2000, NT 4.0, UNIX - Sun Solaris, HP-UX

Other Tools: TextPad, TDM, MDM, CompareIT, PuTTY, C#, WinScp, SnagIT

Scheduling Tools: Autosys, Control M, Flux

PROFESSIONAL EXPERIENCE

Confidential, Spokane, WA

ETL QA Analyst

Responsibilities:

• Worked with developers togather information for a set of Development Plan templates documenting the service’s requirements, functional, and technical design Included SDLC and Data Warehouse System Development Life Cycle documentation.
• Prepared test data for positive and negative test scenarios for Functional Testing as documented in the test plan.
• Prepared Test Cases and Test Plans for the mappings developed through the ETL tool from the requirements.
• Extensively used Informatica Workflow Manager to run the workflows/mappings and monitored the session logs in Informatica Workflow Monitor.
• Verified session logs to identify the errors occurred during the ETL execution.
• Created Test Cases, traceability matrix based on mapping document and requirements.
• Validated the web services using the Soap UI.
• Worked in Informatica Data Validation Option (DVO) suite to automate ETL testing
• Worked in Agile to create, maintain and execute test cases while participating in the validation of functional and non-functional requirements in an agile development environment.
• Creates table pairs in Informatica data validation option (DVO) and validated the data moving from source to target.
• Written several complex SQL queries for data verification and data quality checks.
• Reviewed the test cases written based on the Change Request document and Testing has been done based on Change Requests and Defect Requests.
• Effectively coordinated with development team for closing a defect using Team Foundation Server.
• Used Team Foundation Server as a test management tool for preparing test cases and executing them.
• Perform defect Tracking and reporting with strong emphasis on root-cause analysis to determine where and why defects are being introduced in the development process.
• Have tested reconcile and incremental ETL loads for the project.
• Scheduling shell script jobs, creating instances of jobs, verifying logs according to client requirement using Autosys server.
• Written Shell scripts to handle data before executing Informatica Maps and to meet pre-requirements.
• Profiled the data using Informatica data quality (IDQ).
• Validated various SSIS packages according to the functional requirements.
• Tested Cascading Prompts and Multi Level Prompts on Dashboards.
• Identified issues, performance bottlenecks, and optimized the Business Intelligence Dashboards and Reports.
• Validated different kinds of OBIEE reports like pivots, charts, tabular and ad hoc reports.
• Involved in testing the Informatica mappings, by validating whether the mapping adhere to the development standards and naming conventions; whether the mapping do what the technical design says it should do.
• Developed UNIX Shell Scripts for scheduling various data cleansing scripts and loading process.
• Communication of the team goals, policies and procedures to the team.

Environment: Informatica Power Center 9.5/ 9.1, Informatica Data Validation Option (DVO), Informatica Data Quality (IDQ), TDM, MDM, Star Schema Data Marts, C#, Clear Case, OBIEE, Clear Quest, SQL, PL/SQL, UNIX, Putty, Shell Scripting, Soap UI, Selenium, Cucumber/Ruby, Web Services, .NET, HTML, ASP .NET, SSIS, Sybase, Oracle 11g, Compare IT, TFS, Autosys, SQL Server 2012, TOAD.

Confidential, Boston, MA

ETL QA Analyst

Responsibilities:

• Involved in design and development of test plans based on high-level documents (BRD & FRD).
• Involved in high and detail level design reviews to ensure requirement traceability and to determine application/component functional readiness requirements.
• Being part of the test team, responsibilities involved writing complex queries using SQL and PL/SQL to generate data based on the complex derivations for each attribute.
• Complex SQL queries were written to compare data generated by the application against the expected results generated based on mapping requirements for each interface.
• Involved in testing of 3NF Data Warehouse, Star Schema Data Mart, Data Stage
• Invloved in testing of various Business objects universes and reports for Lay out and data quality.
• Worked in Informatica Data Validation Option (DVO) suite to automate ETL testing
• Worked as Ecommerce QA testing in the design and implementation of testing solutions, with a specialty in Point of Sale (POS) and JDL retail systems.
• Exclusively involved in execution of Autosys jobs, PL/SQL batch programs and responsible for reporting the defects to development team.
• Defects identified in testing environment where communicated to the developers using defect tracking tool JIRA.
• Tested a number of complex ETL mappings and reusable transformations for daily data loads.
• Creating formal test cases for ETL mappings and design documents for production support.
• Worked with the development team to create a suite of test data (Input files, Expected results), that fully exercises Data Validation (detecting, rejecting bad data) to test ETL functionality (properly processing). testing migration of applications from Development to Production environments
• Worked on Informatica Workflow Manager to run the workflows and monitored the status and logs in Workflow Monitor.
• Validated data consistency, data completeness, de-duping logics in data migration and data conversion projects.
• Evaluated and created different document to support data migration process & troubleshooting during data and application migration process from development to production.
• Coordinated with different level of team members for successful data migration, goal, policies & progress update.
• Tracked and executed the User Acceptance Test Cases (UAT) with respect to the requirements to determine the feature coverage.
• Performed functional, data and cosmetic testing for OBIEE reports.
• Validated procedures, functions, triggers in T-SQL.
• Responsible for testing Initial and daily loads of ETL jobs.
• Involved in testing the batch scheduling programs by using the Autosys tool.
• Involved in creating various data scenarios (Excel Sheets having expected data) and validating them before and after running the respective Autosys batches.

Environment: UNIX, Informatica 9.1, Oracle 11g, SQL, PL/SQL, Autosys, SQL Server 2008, SSIS Toad, Java, Autosys, Business Objects XI, TDM, MDM, Data Stage, Rational Clear Quest, C#, .Net, Selenium, TSQL, SQL Server 2008, OBIEE, Clear Case, UAT, Quality Center, Putty, XML, XSD, XSLT, Ecommerce, Leech FTP, Remedy, Windows XP/NT, JIRA

Confidential

ETL DWH Tester/ Reports Tester

Responsibilities:

• Developed formal test cases based on functional requirements, general requirements and system specifications.
• Prepared test data for positive and negative test scenarios for Functional Testing as documented in the test plan.
• Extensively used Cognos for generating the reports and validating them according to business requirements.
• Responsible for testing of 3NF Data Warehouse, data marts, data stage, data validation, business objects universes, accuracy of calculated fields, accuracy of the data shown, Selection criteria shown, accuracy of subtotals, for the Cognos reports.
• Tested business object universes and reports in Cognos using Analysis studio, Report studio and query studio.
• Tested reports for column headings, field titles, column and field alignment, field spacing and size, fields in correct format (dates, currency etc).
• Written several complex SQL queries for data verification and data quality checks.
• Verified session logs to identify the errors occurred during the ETL execution.
• Created Test Cases, Traceability Matrix based on mapping document and requirements.
• Verified the logs to identify the errors occurred during the ETL execution.
• Reviewed the test cases written based on the Change Request document and Testing has been done based on Change Requests and Defect Requests.
• Validated SSIS and SSRS reports according to requirements.
• Preparation of System Test Results after Test case execution.
• Effectively coordinated with the development team for closing a defect.
• Prepared Test Scenarios by creating Mock data based on the different test cases.
• Perform defect Tracking and reporting with strong emphasis on root-cause analysis to determine where and why defects are being introduced in the development process.
• Run Data Stage jobs by using Data Stage Director and by running UNIX scripts as well.
• Used Rational Clear Quest as defect tracking tool.
• Before the Load is accepted to test, have performed the smoke or shake-out test.
• Extensively used Oracle database to test Data Validity and Integrity for Data Updates, Deletes & Inserts.
• Worked in the role of data analyst in mapping and scrubbing sensitive data within the application.
• Provided the management with weekly QA documents like test metrics, reports, and schedules.
• Experienced with Data Warehouse System Development Life Cycle

Environment: Oracle 11g, Cognos 8.0,SQL, Business Object, Star Schema Data Marts, Data Stage, Teradata V2R6/V2R5, SQL Assistant, Rational Clear Case, Rational Clear Quest, PL/SQL, UNIX, Putty, DB2, HP Quality Center, Autosys, Toad, Data Warehouse System Development Life Cycle.

Confidential, New York, NY

ETL/QA Analyst

Responsibilities:

• Responsible for review of requirements from Business Functional Specifications and conducted code as well as application design walkthroughs with Business, dev. team and test team members respectively to create Application Design Document.
• Performed Gap analysis and assessed risks of the project
• Responsible for creating test beds, assigning test scenarios, writing test scripts and tracking defects to certify that applications meet technical and business requirements
• Followed Agile & Waterfall Methodology to emphasize on real time communication over written documentation.
• Perform static, functional, technical integration, end-to-end, User Acceptance Testing and funcational testing with mortgage background .
• Validated data consistency, data completeness, de-duping logics in data migration and data conversion projects.
• Evaluated and created different document to support data migration process & troubleshooting during data and application migration process from development to production
• Automated test scenarios for GUI, Functionality and performed data driven testing on the application inserting different data in excel sheet using QTP
• Review application enhancements with UAT tester and business testers
• Worked extensively on web-based testing and involved in UAT environment, pre-production environment and production environment
• Participated in building automation test scripts based on BPT module of Quality center.
• Participated in the management of testing project with the help of QTP.
• Performed Manual Testing to check the usability of the application.
• Involved in UAT testing for migrating the data.
• Successfully implemented the End2End testing and UAT (User acceptance testing)
• Worked extensively on web-based testing and involved in UAT environment, pre-production environment and production environment
• Used SQL queries to do backend testing to perform data validation, data migration/data conversion validation.
• Conducted Back-End Testing manually for the purpose of Database Integrity with mortgage background.
• Defect tracking and bug reporting using Quality center.
• Developed test scripts in SQL to check the data integrity from the databases
• Conducted result analysis and interacted with developers to resolve bugs.
• Bug Reporting and Tracking using Quality center
• Generated defect reports using Quality center and presented using MS Office tools
• Performed Usability Testing

Environment: SQL, SQL Navigator, VB Script, DB2, Oracle, IBM Data Studio, MS Visio, XML, MS Outlook, Quality center, QTP, CMSA, Siebel, Claim Processing System Diamond Etc