SUMMARY

• 8+years of experience in Data Warehouse applications, ETL testing using Informatica Power
• Extensive testing ETL experience using) Informatica Power Center 9.0/8.5.x/7.x, (Source Analyzer, Warehouse Designer, Repository Admin console, Mapplet Designer, Mapping Designer, Repository Manager, Workflow Manager, Workflow Monitor and Informatica Server)
• Strong knowledge of Data warehousing methods and Architectures, Star Schema modeling, Fact and Dimension table design, Physical and logical data modeling using Erwin 4.0.
• Proficiency in data warehousing techniques for data cleansing, Slowly Changing Dimension (SCD) phenomenon, Surrogate key assignment.
• Extensive experience in reviewing Business Requirement Documents, Software Requirement Documents and preparing Test Cases, Test scripts and Execution.
• Experience in Black box testing with a complete QA cycle - from testing, defect logging and verification of fixed defects.
• Extensive experience in Functional testing, Integration/System testing, Regression testing and User Acceptance testing.
• Well versed in GUI application testing, Database testing and Front-end testing.
• Ability to interact with developers and business analysts regarding testing status and to maintain detailed QA documentation.
• Highly adaptive to a team environment and proven ability to work in a fast paced teaming environment with excellent communication skills.
• Coordinated meeting between the manual testing teams and automation group in order to facilitate communication and produce more future-proof automated test scripts.
• Responsible for weekly status to show the Progress of the testing efforts.

TECHNICAL SKILLS

Operating Systems: Windows NT/ 2000/2003/2007/ XP/, UNIX

Programming Languages: C, C++SQL, PL/SQL.

Databases: Oracle 10g/9i/8i, Netezza 4.6, SQL Server 2008 R2

Data ware house tools/BI tool: Informatica 9.1and Cognos Report Studio 8.0

Testing Tools: HP ALM,HPQuality Center 10.0/9.0,Rational Clear Quest, QTP,LoadRunner

Data Modeling: Erwin, Microsoft Visio, Rational Rose (UML), ER Studio

PROFESSIONAL EXPERIENCE

Confidential, St Petersburg FL

Sr. ETL/DWH SQL Test Consultant

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Involved in reviewing/analyzing Business Requirement Documents/Functional specifications/use cases.
• Performed Verification, Validation, and Transformations on the Input data (Text files, XML files) before loading into target database.
• Tested Cognos Reportnet reports into Cognos 8BI.
• Used SDK to validate reports for Cognos Reportnet and Cognos8 SDK
• Run batch jobs for loading database tables from flat files using SQL*Loader
• Strong experience in XML, XSLT, XPath and XML Spy.
• Developed test plan and Responsible for creatingTest Strategyfor the Data Warehouse.
• Loading the test data in testing Environment to ensure the tests are done with no data issues.
• Perform Functional, Data Validation, Integration, regression and User Acceptance testing.
• Rigorously performed Regression testing for every modification/enhancement of the project.
• Tested ETL’s to ensure that the source and the target are mapped as per the Requirements/specifications.
• Ensure that data quality validation is done before loading the data into data warehouse.
• Initial loading of records on data ware house and incremental loading of records at a later date to verify newly inserted/updated data.
• Good understanding of agile software development lifecycle (iterative and incremental)
• Performed tests on various features of agile development process
• Prepared scripts, running tests, Analyzing results in LoadRunner for Performance testing.
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning
• Used Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata
• Responsible for different Data mapping activities from Source systems to Teradata
• Tracked and reported the bugs with HP ALM(Quality center).
• Defect Reporting & Defect Tracking using HP ALM(Quality Center).
• Wrote complex SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application.
• Use SQL, PL/SQL to validate the Data going in to the Data Ware House
• Initiated Defects review meetings with Developers and communicated with them for whole defect life cycle until the logged defect is closed and verified.
• Involved in backend testing for different environments like System Integration E2E Testing (SIT-E2E) and User Acceptance Testing (UAT).
• UtilizedCongas Series for building the Reports.
• Involved in testing the Cognos reports by writing complex SQL queries.
• Worked on Rational Clear Quest to log defects and track resolution till the closing of defect after retesting.
• Worked on RTI release management process between the Development, Test and Production environments.
• Developed and ExecutedSQL statementsinToadto retrieve data and to validate data
• Validated the data thru various stages of data movement from staging to Data Mart to Data Warehouse tables.
• Worked with business team to test the reports developed in Cognos
• Responsible for documentation of test results, test matrix,LoadRunner andparticipated in daily/weekly QA meetings.

Environment: Informatica 9.1, Erwin, PL/SQL, SQL Server 2008 R2,Agile,XML, Cognos Cognos 8 BI Cognos Connection, Cognos 8 BI s, Rational CQ, Toad, MS Office Suite, HP ALM (Quality Center) 11.0, QTP, UNIX, Share point

Confidential, Park Ridge, NJ

ETL Tester

Responsibilities:

• Interacted with Business Analysts to identify information needs and business requirements.
• Preparation and Execution of Test Plans, Test Cases for the mappings developed through the ETL Informatica tool in the QA environment
• Created test data for testing specific ETL flow
• Performed all aspects of verification, validation including functional, structural, regression, Performance, load and system testing.
• Performed tests on various features of agile development process
• Strong testing Quality Assurance experience within agile environment
• Creating test scripts using HP ALM (Quality Center) and performing regression testing on new versions of the software.
• Created/Enhanced TeradataStored Procedures to generate automated testing SQLs
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning
• Experienced in working with DB2, Teradata
• Used HP Quality Center for bug reporting
• Execute the session and review session statistics, document all the load timing information.
• Initial loading of records on data ware house and incremental loading of records at a later date to verify newly inserted/updated data.
• Automated detailed test cases by using Quick Test Pro (QTP).
• Worked in keyword view as well as expert view of Quick Test Pro (QTP).
• Testing the rejected records that do not fulfill transformation rules.
• SQL queries used to validate source data versus data in the data warehouse including identification of duplicate records
• Worked with XML feeds from multiple sources systems and loaded the same into Enterprise data warehouse.
• Used XPath to navigate through data elements and attributes in an XML document.
• Personalized Cognos Connection for specified display options for testing regional options and personal information.
• Developed UNIX Shell scripts to automate repetitive database processes
• Day-to-day Cognos administration activities like monitoring Scheduled jobs like Cube refresh, Impromptu scheduled reports, Backup and recovery maintenance
• Performed backend database testing by writing SQL and PL/SQL scripts to verify data integrity
• Back-end testing using SQL queries and Involved in writing PL/SQL quires
• UsedInformaticatoanalyze the mappingsand sometimes even debug them to compare the code with respect to the requirements specification, also usedWorkflow Manager,Workflow MonitorinInformaticato run the ETL and monitor the ETL jobs along with reading the log files to find out the errors
• Exporting the test cases into Quality Center 10.0 and executing those test cases in the ‘Test Lab’
• Tested ETL’s to ensure that the source and the target are mapped as per the Requirements/specifications.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Tested whether the reports developed in Cognos are as per company standards.
• Created Traceability Matrix to ensure that all requirements are covered in test cases.
• Responsible for Documentation of the Test cases, completed modules and the results of acceptance testing.

Environment: Informatica 8.6.1, UNIX, Erwin, QTP, Agile, PL/SQL, WinCvs 8.0,LoadRunner, Oracle 10g and Netezza 4.6, Cognos, ABAC, HPQuality Center10.0.

Confidential, Columbus, OH

ETL/SQL QA Test Engineer

Responsibilities:

• Participated in the requirements, design, and release readiness reviews.
• Assisted in the implementation of QA processes to ensure correctness of data flowing through each stage of the Informatica based ETL process.
• Created and maintained test documentation and test plans. Development and Execution of Test Cases for Informatica ETL components.
• Worked with the development team to create a suite of test data to exercises data validation and actual ETL functionality.
• Used QTP for Checkpoints, Regular Expression and Accessed Data Tables for multiple applications.
• Involved in writing test scripts and functions in Test Script Language using QTP for automated testing.
• Used SDK to validate reports for Cognos Reportnet and Cognos SDK.
• Created Jobs to Schedule multiple reports in Cognos Connection.
• Performed Database Testing by writing SQL queries for generating reports to ensure data integrity and validating business rules
• Extensively executed SQL queries in order to view successful transactions of data and validating data after Backend testing
• Strong testing Quality Assurance experience within agile environment
• Good understanding of agile software development lifecycle (iterative and incremental)
• Based on change requests, performed Impact analysis to determine the regression testing efforts
• Analyzed Test Execution Results and reported the Bugs/defects using Quality Center Performed Defect fix verification after each release
• Performed Verification, Validation, and Transformations on the Input data (flat files) before loading into target database
• Responsible for documentation of test results, test matrix,andparticipated in daily/weekly QA meetings

Environment: Informatica 7.1, UNIX, QTP, Erwin 4.0,TOAD and Quality Center 9.0,Agile.

Confidential, Alpharetta, GA

ETL/DWH SQL QA Test Analyst

Responsibilities:

• Worked on the business requirements specified by the customer.
• Analyze and testingto ensure the efficient functioning of the system.
• Review and analyze data mapping document to determine ETL program design.
• Use Informatica to develop ETL program to extract data from the LaSalle data warehouse (e.g., CDW or FRW). File extract to be created will follow the instructions specified in the data mapping and file layout documentation.
• Worked on Informatica to resolve production issues perform testing and debugging of mappings and reports
• Involved in automation of test cases in functional testing using QTP.
• Extraction of test data from tables and loading of data into SQL tables
• Responsible for Data mapping testing by writing complex SQL Queries using WINSQL
• Experience in testing UNIX scripts for file transfer and file manipulation
• Validating the data passed to downstream systems and worked with data validation, constraints and source to target row counts
• Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards.
• Tested CognosReportnet reports into Cognos.
• Analyzing the AS-IS system which loads the Monthly/Weekly/daily multi source data files for Data mart using PL/SQL procedures and convert them into informatica code.
• Back-end testing using SQL queries and Involved in writing PL/SQL quires
• Used data conversion to protect the data and prevent data loss
• Support user acceptance testing.
• Set up file transfer connectivity to send the extract files to BAC ECRIS system for processing.

Environment: Informatica 6.1, QTP, UNIX AIX 4.2, SQL, and Windows XP, Quality Center 9.0

Confidential, Overland Park, KS

ETL/QA/Manual Tester

Responsibilities:

• Built the Forms for application using various form modules and windows.
• Participated in gathering Business Requirements and designed the project according to the Business requirement specifications.
• Written PERL scripts and UNIX Shell Scripts for various data comparison and data parsing needs.
• Conducted Bug Review meetings for update on defects from development team and retesting of bug fix. Worked with developers to fix faults found in the structure and functionality of the application.
• Prepared daily/weekly bug status reports highlighting bug fix metrics and tracked the progress of test cycles in Quality Center
• Conducted Training & Knowledge Transfer Sessions on new applications to QA Analysts
• Expertise in code reviews. Expertise in security issues of client/server technologies.
• Designed the screens and layout using Visual Basic 5.0.
• Used SQL*Plus for updating the database and for data retrieval.
• Did unit testing, manual testing of the processes to check the integrity.
• Involved in the implementation, testing and maintenance of the system.
• Design and develop a custom database (Tables, Views, Functions, Procedures, Packages)
• Work with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
• Used Clear Quest for defect tracking and reporting, updating the bug status and discussed with developers to resolve the bugs.

Environment: Oracle 7.0/8i, SQL*Plus, SQL, QC, TOAD, Rational Clear Quest, Clear Case, SQL Server 2000, PL/SQL, Visual Basic 6.0, Windows 95, XML, XSLT, Java and UNIX

Confidential

QA/Manual Tester

Responsibilities:

• Involved in the creation of test plan, test cases and test procedures requires for manual testing.
• Developed Test Plans, Test Scenario and Test Cases for the testing procedure.
• Maintained Test cases and QA documentation using SharePoint.
• Performed Smoke Testing and Sanity Testing manually.
• Performed Backend database testing by writing SQL and PL/SQL scripts to verify data integrity
• Developed SQL Stored Procedures and Queries for Backend testing
• Involved in extensive DATA validation using SQL queries and Backend testing
• TOAD is used to perform manual test in regular basis. UNIX and Oracle are using in this project to write Shell Scripts and SQL queries
• Extensively used SQL Queries for Database Testing to make sure that frontend operations are being stored into the right tables at the backend.
• Performed Functional, Positive, Negative, Integration Testing manually.
• Used SQL queries to validate the data between the backend and the frontend.
• Performed manual testing to conduct backend testing using UNIX and SQL Queries.
• Participated in requirement walkthroughs and creation of test plan.
• Used Test Director as the defect-tracking tool to enter defects regarding the issues found during testing.
• Worked closely with QA lead to clarify/understand functionality, resolve issues.
• Attended weekly meeting with team leaders, managers and developers to discuss the issues found during the creation of the test case/scripts.

Environment: Manual Testing, Test Director, SQL, Oracle/Unix, Windows 2000/XP/07