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.
• Worked with IT Operations to ensure test environment readiness.
• 5+ years of experience in Data Warehouse applications testing using Informatica, SSIS, 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
• 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
• Experience in testing the Universe (business view of the database), and updating the existing Universes, developing canned/ad-hoc reports, scheduling the processes using Broadcast Agent and administering the BO activities.
• Expertise in working with SQL queries and PL/SQL (Stored Procedures, Triggers, Packages/Functions).
• Excellent knowledge of the design and implementation of the Data Warehouse life cycle.
• Familiarity with entity-relationship/multidimensional modeling (star schema, snowflake schema).
• Knowledge of Data Warehouse/Data Mart design concepts.
• Experience with business requirements gathering, business analysis and documentation.
• Proficient experience in different Databases like Oracle, SQL Server, DB2 and Teradata.
• 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.1/8.1/7.1/6.1 , SSIS, Data Stage 8.x, SSIS

Reporting Tools: Business Objects XIR4, Cognos 8 Suite, OBIEE, Hyperion, Crystal Reports

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

Testing Tools: Test Director, HP Quality Center, Rational Clear Quest, Rational Clear Case

RDBMS: Oracle 11i/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, Boston, MA

DWH Tester 

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
• Extensively used the Report Inspector tool to change, multiple reports database schemas, scheduling multiple reports, deploying and publishing.
• Testing the reports and maintenance of daily, monthly and yearly.
• Involved in Writing Detailed Level Test Documentation for reports and Universe testing.
• Coordinated 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 FIT, 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
• Created lookup files where necessary for validation of critical enterprise codes, lender identifiers and service numbers.

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

Confidential, Irvine, California

Data Warehousing Tester

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.
• Written complex SQL queries for validating the data against different kinds of reports generated by Business Objects XIR2
• Tested many different reports developed in Business Objects including Dashboards, Summarized Reports, Master-Detailed, Cascades, Grouped List, KPI's etc.
• Involved in data warehouse testing by checking ETL procedures/mappings.
• Tested various graphs for both negative and positive scenarios.
• Involved in creating source target mappings based on the Technical Design requirements.
• Used different sources for Input.
• 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, Omaha, Nebraska

Informatica/SQL 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.
• 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.
• Written test cases and completed unit test documentation.
• Involved in pager rotation program to support 24 x 7 production support.

Environment: Informatica 6.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, Seattle, WA

Backend & Front-End Tester

Responsibilities:

• Understand and review the requirements.
• Participated in Functional Walk-troughs to validate the application design against the Test Cases.
• Performed GUI testing and Navigational Testing.
• Authored Test Cases in Test Director after the analysis of Requirements/Use cases.
• Extensively performed Functional and Regression Testing.
• Performed Regression Testing after each build.
• Tested frontend java based applications
• Performed Backend testing to validate the data using Toad, added SQL queries to the required Test cases.
• Extensively used Oracle and SQL to perform backend database testing for data integrity.
• Recorded defects in the defect-tracking tool "Test Director".
• Assigned Priority and Severity based on the defect found.
• Work closely with technical support, developers, database team´s management etc to quickly validate defects, assess severity and find temporary workarounds and permanent resolutions.
• Provide weekly status report to the Project Manager and discuss issues related to quality and deadlines.
• Perform final release testing and Release sign-off.
• Performed backend testing on UNIX and Windows environment.
• Responsible for creating test cases to make sure the data originating from source is making into target properly in the right format.

Environment: TestDirector8.0, Windows 2003/XP, Java, J2EE, JSP, Servlets, Oracle9i, TOAD, SQL/PL-SQL, Sun Solaris 9 (SunOS 5.9)