PROFESSIONAL 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.
• 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.
• Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
• Worked on different versions of Cognos for Report testing.
• Experienced in DW projects ETL testing against DW testing with Informatica, Ab Initio and data stage tools.
• Excellent Communication, Analytical and Interpersonal skills.
• Worked with IT Operations to ensure test environment readiness.
• Experienced in working in Agile Scrum, Agile XP, Waterfall, RUP, RAD and SDLC methodology environments
• 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.
• Expertise in Developing PL/SQL Packages, Stored Procedures/Functions, triggers.
• Solid Back End Testing experience by writing and executing SQL Queries.
• Experience with Agile Methodology.
• 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 UNIXshell 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, Informatica8.6/8.1/7.1/6.1, SSIS, Data Stage 8.x

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

Data Modeling: Star-Schema Modeling, Snowflake-Schema Modeling, Fact and dimension tables, Pivot Tables, Erwin

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

Environment: UNIX, MVS, HP-UX, IBM AIX 4.2/4.3, Novell NetWare, Win 3.x/95/98, NT 4.0, Sun-Ultra, Sun-Spark, Sun Classic, and SCO

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

ETL QA/BI Lead 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.
• Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards
• Tested the messages published by data stage and data loaded into various databases
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Experience in Leading the Offsite Project, managing a team of 8 Offshore and 4 Onsite consultants..
• Responsible for leading team and co-coordinating with offshore team.
• Developed data quality test plans and manually executedETL and BI test cases.
• Worked in AGILE Methodology.
• Designed and kept track of Requirement Traceability Matrix
• Quality Center updates and test cases loadingand writing Test Plan and executing Test Cases and printing status report for the team meetings.
• 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.
• Promoted Unix/Data Stage application releases from development to QA and to UAT environments
• 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
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance.
• Worked as Onsite Coordinator for getting the work done from offshore team.
• Testing the reports and maintenance of daily, monthly and yearly.
• Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic
• Involved in Writing Detailed Level Test Documentation for reports and Universe testing.
• 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 FIT, QA and contingency/backup environments
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing
• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression 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.
• Functioned as the Onsite / Offshore coordinator and Team Lead
• Tested Cognos reports and written test cases using HP Quality Center.
• Executed Data stage ETL jobs using UNIX to load the data into target tables
• Wrote SQL and PL/SQL scripts to perform database testing and to verify data integrity.
• Written several complex SQL queries for validating Cognos Reports.
• Created different user defined functions for applying appropriate business rules

Environment: Quality Center 10.0, SQL, PL/SQL, Cognos 8.0 Series, Data stage,, MainFrame Flat Files, Agile, COBOL II, UNIX, Korn Shell Scripting, Oracle 10G, DB2, TOAD9.7

Confidential, Warren, New Jersey

ETL QA 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.
• Involved in testing the Cognos reports by writing complex SQL queries
• Extensively used Data Stage for extraction, transformation and loading process
• 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.
• Worked in an Agile technology with Scrum
• Written several complex SQL queries & PL/SQL stored procedures for validating Cognos Reports
• 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 (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.
• Managed and executed the test process, using Agile Methodology
• Extracted Data from Teradata using Data Stage ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes.
• 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
• Reported bugs and tracked defects using Quality Center
• Worked with business team to test the reports developed in Cognos
• 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.
• Involved in Manual and Automated testing using QTP and Quality Center.
• Tested several Data stage ETL jobs and ran on UNIX for loading purpose and checking the log files
• Created different user defined functions for applying appropriate business rules
• Worked with business team to test the reports developed in Cognos
• 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: SQL,PL/SQL, HP Quality Center 10, Cognos 7 Series, Rational Clear Quest, MS Excel,, Teradata 12.0 Agile, Data Stage, Teradata SQL Assistant, Korn Shell Scripting, XML, XSLT, XSD, XPath, XML Spy 2010, MVS, COBOL II, JCL, VSAM Files, Copy Books, TSO, Putty

Confidential, VA

Data Warehouse Tester

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.
• Quality Center updates and test cases loading and writing Test Plan and executing Test Cases and printing status report for the team meetings
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Followed RUP and AGILE development methodology and adhered to strict quality standards in requirement gathering
• 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.
• Tested analytical reports using Analysis Studio
• 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.
• Used Quality Center for defect tracking
• 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.
• Involved in pager rotation program to support 24 x 7 production support.

Environment: AB INITIO CO>OP 2.13, AB INITIO GDE 1.13, Quality Center, EME, MVS, UNIX (K-Shell Script), Oracle 10G, DB2, Windows 2000 Pro, XML, Agile, XSLT, XSD, Rapid SQL, PL/SQL, TOAD

Confidential, Cincinnati, OH

Responsibilities:

• Participated in business requirement walk through, design walk through and analyzed Business requirements.
• Involved in developing detailed test plan, test cases and test scripts using Test Director for Functional and Regression Testing.
• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Created Test plan, Test Design, Test scripts and responsible for implementation of Test cases as Manual test scripts.
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning
• 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.
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Extraction of test data from tables and loading of data into SQL tables.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Written several complex SQL queries for validating Cognos Reports.
• Tested several stored procedures.
• Written customized SQL queries for business needs.
• Did automation using PERL and UNIX Shell scripting.
• Reviewed system use cases and functional specs with business and System Analysts.
• 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
• Responsible for Data mapping testing by writing complex SQL Queries using WINSQL
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Validating the data passed to downstream systems.
• Worked with Data Extraction, Transformation and Loading (ETL).
• Involved in testing data mapping and conversion in a server based data warehouse.
• Involved in testing the UI applications
• Involved in Security testing for different LDAP roles.
• Worked with business team to test the reports developed in Cognos
• Tested whether the reports developed in Cognos are as per company standards.
• Used Quality Center to track and report system defects
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
• Responsible for creating test cases to make sure the data originating from source is making into target properly in the right format.

Environment:Informix, DB2, Java, Cognos, SQL, Teradata V2R4 (MLOAD, FLOAD, FAST EXPORT, BTEQ), XML, IBM AIX 5.3, UNIX, Shell Scripting, WINSQL, Ultra editor, Oracle 8i/9i, DB2, SQL Server 2000, Mainframe, SunOS 5.8, DTS, ERWIN, Windows XP