SUMMARY:

• Over 7+ years of extensive experience in Information Technology with emphasis on Quality Assurance, Data warehousing Testing, Manual testing of Web, and Client/Server based commercial applications.
• Involved in the Analysis, design, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.
• Well versed with Software testing concepts, SDLC, Agile and Waterfall methodologies
• Extensive experience in testing ETL data from multiple sources into Data warehouse using Informatica.
• Experience in Data Analysis, Data Validation, Data Modeling, Data Profiling, Data Verification, Data Mapping, Data Loading, Data Warehousing/ETL testing and BI Reports Testing
• Experienced in DW projects ETL testing against DW testing with Informatica, Ab Initio and Data stage tools.
• Extensive ETL testing experience using Informatica Power Center 9 / 8.1 components (Designer, Workflow Manager, Workflow Monitor and Server Manager)
• Expert in using Test Management Tools - HP Quality center 10
• Worked with different querying tools like SQL Assistant, TOAD, Oracle SQL Developer, iSQL * plus
• Experience in writing complex SQL and PL/SQL statements.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, MS Excel, MS Access and Flat Files.
• Expert in Test plan, Test strategy, Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Implemented various Test cases for the Functional Testing, smoke testing, re-testing, Regression Testing, Configuration Testing, Performance Testing, Back-End and User Acceptance testing (UAT)
• Ability to understand and adapt to new technologies and environments faster, good at analysis and troubleshooting and excellent analytical, programming, written and verbal communication skills.

TECHNICAL SKILLS:

ETL Tools: Informatica 9/8.x, Data Stage, Ab Initio (GDE 1.15, Co>Op 2.14

Bug Reporting: Quality Center 10.0 / 9.0/8.2, ALM, Rational Clear Quest, TFS 2010

Programming/Scripting Languages: SQL, PL/SQL, XSLT, JCL, HTML, XML

Operating Systems: Windows XP/NT/2000, DOS, Mac 10.4, AIX-UNIX, LINUX

Databases: Oracle 11g/ 10g/9i, MS SQL Server 2008 / 2012, Sybase12.0/11.0, MS Access 2005, Teradata 13 / V2R6/V2R5

Reporting Tools: Business Objects, Micro Strategy 9, Cognos 8.0

PROFESSIONAL EXPERIENCE:

Confidential, Washington DC

Sr. ETL Test Engineer

Responsibilities:

• Involved in reviewing/analyzing Business Requirement Documents/Functional specifications/use cases.
• Worked with Business Analysts, developers while reviewing the Business Requirement Documents and when there are enhancements in the applications.
• Experience in ETL Data Warehousing, database testing using Informatica for Workflow process.
• Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases
• Extensively used Informatica for extraction, transformation and loading process
• Peer reviewed test cases developed by QA team members and advice/point/discuss possible complex scenarios and make sure requirements are completely covered.
• Supported and provided test cases for UAT, staging and production Participated in review meetings and attended training sessions to understand various business concepts.
• Prepared Entry and Exit criteria for Testing cycles, review with functional leads and PM.
• Exported Requirements, test plans and test cases to TFS 2010.
• Created Traceability Matrix to ensure that all requirements are covered in test cases.
• Develop Risk-based Test Strategy whenever required, to save time and to determine which test activities to carry out and created complexity matrices.
• Prepared Kickoff meeting PowerPoint and gave presentation on testing activities for each cycle of testing and for different releases.
• Assisted in kicking off ETL jobs using UNIX and analyzed the data in dimension and fact tables
• Conducted Defect meetings on daily bases to track defects status with functional leads and to speed up resolution process at end of each cycle.
• Interacting with developers, business analysts to communicate the defects.
• Bug reporting and Bug tracking using HP Quality Center.
• Involved in UAT process before rolling out to production when required. Participated in debugging prod issues along with support team.
• Worked in Agile methodology during application development and participated in daily scrum meetings.
• Developed user defined functions, created objects where required and used descriptive programming to automate.
• Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.
• Developed and Executed SQL statements in Toad to retrieve data and to validate data.
• Tested data migration to ensure that integrity of data was not compromised.
• Validated the data thru various stages of data movement from staging to Data Mart to Data Warehouse tables.
• Responsible for documentation of test results, test matrix, and participated in daily/weekly QA meetings.
• Used Quality Center for logging the defects.
• Conducted down test and up test for release builds pushed to UAT and to Production.

Environment: Informatica Power Center 9.1/8.5.1, Oracle 11g, TFS 2010, UNIX, Teradata 13, MS SQL Server, HP Quality Center 10.0/ ALM, TOAD, MS Excel, MS Project, Business Objects.

Sr.ETL Tester

Responsibilities:

• Involved in Regression, Functional, Integration, System Testing and User Acceptance Testing.
• Participated in analysis of Business and functional requirements.
• Interacted with Business users to determine User requirements and goals.
• Created reports that included a general overview, open bugs, new bugs and enhancement requests.
• Entered new bugs and maintained the current status of those bugs.
• Responsible for communicating Defect Status Reports to business in project meetings.
• Participated and Organized weekly meetings and walkthroughs to improve the testing efforts.
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.
• Tested several Data stage ETL jobs and ran on UNIX for loading purpose and checking the log files
• Used Data Stage to test mappings, transformations and source and target tables
• Developed Test Strategy, Test plans, and Test scenarios using MS Word and MS Excel.
• Developed Test Cases and Test Scripts for System and UAT Testing.
• Performed Positive and Negative Testing for many scenarios and applications.
• Performed basic testing of security features using manual testing.
• Responsible for creating Test Strategy for the Data Warehouse.
• Conducted regression testing on the application under test and Debugging the SQL-Statements and stored procedures.
• Identifying defects and logged/tracked them using bug tracking tool Rational Clear Quest.
• Tested the Oracle SQL testing programs and tested the Oracle Applications and Portals like Executive Dashboard, Credit Mortgage lookup built on Oracle.
• Used RAPID SQL Software for querying DB2.
• Conducted review sessions on test case and regression test scripts in Quality Center and defect in Clear Quest.
• Used Data Stage director to run the data stage jobs and verify according to data mapping requirements.
• Coordinated in testing Data stage ETL using complex stored procedures.
• Verified and maintained Data Quality, Integrity, data completeness, ETL rules, business logic.
• Tested several UNIX Korn Shell scripts for ETL data loading
• Verified the property and loan order information like data in the pricing models against source and target databases by using SQL Queries.
• Extensively used SQL queries to check storage and accuracy of data in database tables.
• Used SQL for Querying the Oracle database.
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing.
• Tested whether the reports developed in Cognos are as per company standards.
• Tested different detail, summary reports and on demand reports using Report Studio.
• Worked with business team to test the reports developed in Cognos.

Environment: Oracle 11g, Data Stage, SQL Server, Cognos 8.0 Series, XML, Test Cases, Unix, Test Matrix,, TOAD, HP Quality Center 9.2

ETL Data Warehouse Tester

Responsibilities:

• Reviewed the Business Requirement Documents and the Functional Specification.
• Written Test Cases for ETL to compare Source and Target database systems.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet designer and Transformation.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Tested the ETL process for both before data validation and after data validation process.
• Tested to verify that all data were synchronized after the data is troubleshoot and also used SQL to verify/validate my test cases.
• Performed Data Analysis during the requirements gathering phase by reviewing the source data model and running SQL queries
• Testing has been done based on Change Requests and Defect Requests.
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Involved in integration testing of Informatica mappings.
• Performed all aspects of verification, validation including Functional testing, Unit Testing, System testing, Regression testing, structural testing, Performance, load and Back-End testing manually.
• Responsible for different Data mapping activities from Source systems to Teradata.
• Queried Teradata Database and validated the data using SQL Assistant
• Used Quality Center to track and report system defects.
• Performed Data validity testing for reports and feeds based on client's requirement.
• Created reports that included a general overview, open bugs, new bugs and enhancement requests. Entered new bugs and maintained the current status of those bugs.
• Responsible for communicating Defect Status Reports to business in project meetings.
• Participated and Organized weekly meetings and walkthroughs to improve the testing efforts.
• Worked closely with engineering team to discuss the design and testing aspects of the applications to design the test plans and to isolate the root cause of defects.
• Involved in meetings and walkthroughs.
• Responsible for weekly status.

Environment: Informatica Power Center 8 (Power Center Designer, workflow manager, workflow monitor, UNIX, Oracle8, Teradata V2R4, SQL Server 2005, Windows 2000, Cognos8.4.1,Quality center 9.2

QA Analyst

Responsibilities:

• Created Test Plan and Test Scripts and analyzed the user/business requirements. Functional specs, Use Case documents and created the Test Plans, Test cases for System testing.
• Executed of generated Test Cases Manually in Test Director.
• Created the Regression Test cases and automated them for the purpose of regression Testing.
• Developed and maintained automated test scripts to support regression testing and participated actively in system testing and regression testing.
• Developed and maintained the regression test bed.
• Complete responsible for manual testing of the Web Site.
• Attended project meetings, release meetings, and QA status meetings.
• Conducting user interviews at both in-house and client locations, gathering and analyzing requirements using Requisite Pro RUP.
• Perform Gap analysis by identifying existing technologies, documenting the enhancements to meet the end state requirements.
• Conduct workflow, process diagram and gap analyses to derive chuck for existing systems enhancements
• Assist with user testing of systems (UAT), developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.

Environment: Oracle8, DB2, Teradata, MS Excel, MS Word, MS PowerPoint, SQL, MS Project, 7.0, Quality Center, Windows NT, J2EE, Oracle 8i, EJB 2.0.