SUMMARY:

• Over 7+ years of Professional Experience in Software Quality Assurance and Testing in different environments and platforms including Data Warehousing, Client - Server and Legacy Mainframe applications.
• Worked with IT Operations to ensure test environment readiness.
• 5+ years of experience in Data Warehouse applications testing using Informatica, Shell Scripting, PL/SQL, Data Stage and Ab Initio on multiple platforms.
• Experience using query tools for Oracle, DB2 and MS SQL Server to validate reports and troubleshoot data quality issues.
• 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 bugs
• 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.
• Experience in Financial, Banking, Brokerage, and Securities industries
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
• Experience in testing and writing SQL and PL/SQL statements.
• Experience in testing Business Intelligence reports generated by various BI Tools like Cognos and Business Objects
• Proficient experience in different Databases like Oracle, SQL Server, DB2 and Teradata.
• Expertise in Developing PL/SQL Packages, Stored Procedures/Functions, triggers.
• Solid Back End Testing experience by writing and executing SQL Queries.
• Well versed in analyzing the XML Files.
• Ability to interact with developers and product analysts regarding testing status and to maintain detailed QA documentation.
• Extensive background in QA methodologies.
• Strong Problem Analysis & Resolution skills and ability to work in Multi Platform Environments like Windows and UNIX.
• Experience in Installation and Implementing Mercury Interactive Test suite.
• Has expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Experience in UNIX shell scripting and configuring cron-jobs for Informatica sessions scheduling
• Experience in testing XML files and validating the data loaded to staging tables.
• Good experience in Cognos & Business Objects Reports testing
• Experience in Performance Tuning of SQL and Stored Procedures.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Expert knowledge in UNIX shell scripting (Korn shell/Bourne shell)
• Excellent analytical, programming, written and verbal communication skills.

TECHNICAL SKILLS:

Data Warehousing: Ab Initio CO>Op 2.15, GDE 1.15, Informatica 8.6/8.1/7.1/6.1 , Data Stage 8.x

Reporting Tools: Business Objects6.5, XIR3, Cognos 8 Suite

Testing Tools: Win Runner, Load Runner, Test Director, Mercury Quality Center, Rational Clear Quest

RDBMS: Oracle 10g/9i/8i/7.x, MS SQL Server 2008, UDB DB2 9.x, Sybase 12.5, Teradata V2R6, MS Access 7.0

Programming: UNIX Shell Scripting, Korn Shell, C Shell, Bourne Shell, Bash, SQL, SQL*Plus, PL/SQL, TOAD, C++

Web Technologies: JavaScript, HTML 4.0, and DHTML, Java, J2ee, .Net.

Environment: UNIX, MVS, HP-UX, IBM AIX 4.2/4.3

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Data Warehouse Tester

Roles & Responsibilities:

• Responsible for Business analysis and requirements gathering.
• Responsible for coordinating testing throughout both systems ODS and EDW which were two different teams.
• Performed complex defect reports in various environments like UAT, SIT, and QA etc to ensure the proper delivery of the application into the production environment.
• Developed data quality test plans and manually executed ETL and BI test cases.
• Designed and kept track of Requirement Traceability Matrix
• Quality Center updates and test cases loading and writing Test Plan and executing Test Cases and printing status report for the team meetings.
• Worked with the co-testers closely in determining both medium and high severity defects, that would potentially affect the downstream systems before the release of the project.
• Involved in Integrating and Functional System Testing for the entire Data Warehousing Application.
• Used Quality Center for defect tracking.
• Performed data quality analysis using advanced SQL skills.
• Tested slides for data flow and process flows using PowerPoint and Microsoft Visio
• 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.
• Testing the reports and maintenance of daily, monthly and yearly.
• Coordinate and helped in testing the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
• Written complex SQL queries for validating the data against different kinds of reports generated by Business Objects
• Involved in data warehouse testing by checking ETL procedures/mappings.
• Implemented and maintained tools required to support data warehouse testing.
• Performed the tests in both the QA and contingency/backup environments
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing
• Worked on test data and completed unit testing to check all business rules and requirements are met. Also tested for negative data to check that the job fails on any critical error.
• Tested several data migration application for security, data protection and data corruption during transfer
• Responsible to help testing team on creating test cases to make sure the data originating from source is making into target properly in the right format.
• Analyzed the data and applied relevant transformations and verified that the source data types are correct.
• Applied appropriate validation rules and created graph parameters to check the validations are correct so that the graph should stop.
• Maintained the Traceability Matrix between Requirements, Design Components, Test Cases and Defects.
• Participate in weekly meeting with the management team and walkthroughs
• Developed Test Strategy, Test plan, Test cases, and Test scripts and various other project documentation in HP Quality Center
• Involved in developing UNIX Korn Shell wrappers to run various dependency graphs.
• Created lookup files where necessary for validation of critical enterprise codes, lender identifiers and service numbers.
• Created different user defined functions for applying appropriate business rules

Environment: Informatica 8.6, SQL,PL/SQL, HP Quality Center 10, MS Excel, Business Objects Enterprise XI R3, Teradata 12.0 Korn Shell Scripting, XML, XSLT, XSD, XPath, XML Spy 2010, MVS, COBOL II, JCL, VSAM Files, Copy Books, TSO, Putty

Confidential, Richmond, VA

Data Warehousing Tester

Roles & Responsibilities:

• Responsible for Business analysis and requirements gathering.
• I have imparted and organized training to newcomers in the team regarding different technologies like SQL, PL/SQL and different processes.
• Attending Client calls for Business understanding and Clarifications.
• Designed and developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads.
• Written several shell scripts using UNIX Korn shell for file transfers and clean up process.
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance
• Wrote SQL and PL/SQL scripts to perform database testing and to verify data integrity.
• Extract data from Mainframe data sets to compare against Target Values.
• Reported bugs and tracked defects using Quality Center 8.2 (Test Director)
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Involved in testing of Universes from different data sources like Oracle/SQL Server.
• Used various @Functions like @Prompt (for user defined queries), @Where (For creating conditional filters), and @Select.
• Involved in Writing Detailed Level Test Documentation for reports and Universe testing.
• Tested the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
• Written complex SQL queries for validating the data against different kinds of reports generated by Business Objects XIR2
• Involved in data warehouse testing by checking ETL procedures/mappings.
• Performed the tests in both the SIT, QA and contingency/backup environments
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing
• 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 migration application for security, data protection and data corruption during transfer
• Analyzed the data and applied relevant transformations and verified that the source data types are correct.
• Involved in creating source target mappings based on the Technical Design requirements.
• Used different sources for Input.
• Applied appropriate validation rules and created graph parameters to check the validations are correct so that the graph should stop.
• Involved in developing UNIX Korn Shell wrappers to run various dependency graphs.
• Created lookup files where necessary for validation of critical enterprise codes, lender identifiers and service numbers.
• Created different user defined functions for applying appropriate business rules
• Worked on test data and completed unit testing to check all business rules and requirements are met. Also tested for negative data to check that the job fails on any critical error.

Environment: Quality Center 8.2, SQL, PL/SQL, Business Objects XIR2, Ab Initio CO>OP 2.14, AB INITIO GDE 1.14, EME, MainFrame Flat Files, COBOL II, ITG, Service center, UNIX, Oracle 10G, DB2, TOAD

Confidential, Madison, Wisconsin

Informatica /SQL Tester - HEDIS (ODW)

Roles & Responsibilities:

• Involved in creating source target mappings based on the Technical Design requirements.
• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Develop ETL test plans based on test strategy. Created and executed test cases and test scripts based on test strategy and test plans based on ETL Mapping document.
• Tested design strategy of the Extract, Transform and Load for various ODW tables.
• Tested mappings with the Design Documents and also performed testing for various sample data.
• Tested various mappings transformations like Filter, Joiner, Sequence Generator and Aggregator and perform query overrides in Lookup transformation as and when required to improve the performance of the mappings.
• Co-ordinate with team members for effective management for all project requirements and responsible for deliverables and receivables during all project phases.
• Preparation of technical specifications and Source to Target mappings.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Experienced using query tools for Oracle to validate reports and troubleshoot data quality issues.
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
• Developed scripts, utilities, simulators, data sets and other programmatic test tools as required executing test plans.
• Effectively communicate testing activities and findings in oral and written formats.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Worked with ETL group for understating mappings for dimensions and facts.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Validated cube and query data from the reporting system back to the source system.
• Used different sources for Input.
• Applied appropriate validation rules and created graph parameters to check the validations are correct so that the graph should stop.
• Involved in developing UNIX Korn Shell wrappers to run various dependency graphs.
• Created lookup files where necessary for validation of critical enterprise codes, lender identifiers and service numbers.
• Created different user defined functions for applying appropriate business rules
• Written test cases and completed unit test documentation.
• Used Unix environment variables in various .ksh files which comprises of specified locations to build Ab Initio Graphs
• Involved in pager rotation program to support 24 x 7 production support.

Environment: Informatica 7.1, MVS, UNIX (K-Shell Script), Oracle 10G, SQL Server 2005, DB2, Windows 2000 Pro, XML, XSLT, XSD, Rapid SQL, PL/SQL, TOAD, Dat Files, XML Files, Autosys

Confidential, Cleveland, OH

QA Tester

Responsibilities:

• Analyzed the Business Requirements and Rules and worked with Business Analyst and Business Users.
• Gone through the Functional Specifications and implemented their technical aspect In Functional Testing, System and Integration testing (SIT).
• Worked in AGILE Methodology.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Developed Test Cases for each mapping according to the business requirements.
• Queried data from different database tables as per the requirement by joining queries using TOAD tool.
• Experienced using database query tools for Oracle SQL such as TOAD and SQL Plus.
• Tested and developed the mapping for extracting, cleansing, transforming, integrating, and loading data using Autosys
• Written extensive UNIX Shell scripting for error logging, cleanup, data archiving & job scheduling
• Performed the Query Tuning for complex SQL and PL/SQL.
• Reported bugs and tracked defects using Quality Center.
• Involved in system testing and regression testing.
• Worked with QA team lead to review the test cases and worked with team members to prepare the final RTM with updated test cases and change requests.
• Tested several stored procedures and invoked into ETL Procedures.
• 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 test the reports for data accuracy.
• Experienced in data migration from one data source to another for testing purposes like migrating data from dev. to QA.

Environment: Informatica Power Center 8.6, UNIX, Oracle 11G/10G, DB2 8.0/7.0, XML, SQL, PL/SQL, Quality Center, ASP.net, TOAD, Autosys, UNIX.