PROFESSIONAL SUMMARY:

• Around 7+ years of experience in software Analysis, Design and Software Quality Assurance Testing in client server, ERP, Web based E - Commerce, Data warehousing Ab Initio, Informatica, SSIS, Data Stage and enterprise applications on UNIX and Windows environments
• Experience in Ab Initio, Informatica based ETL testing for data warehouse and business intelligence solutions.
• Strong experience in writing Test Plans, Test Conditions, Defining Test Cases, Developing and maintaining Test Scripts, analyzing the results of scripts, interaction with team members in fixing the errors
• Strong working knowledge of complete Software development life cycle with timely delivery against aggressive deadlines
• Strong working experience with Mercury testing Product Quality Center and Test Director
• Good understanding of quality assurance testing methodology relative to the Software Development Lifecycle SDLC
• Extensive working experience on Integration Testing, Functional Testing, GUI Testing, Regression Testing, System Testing, Database Testing.
• Involved in stages of Test Analysis and User Acceptance Testing.
• Provided Efforts, Estimate and coordinated the test schedule using Agile testing methodology in UAT phase
• Experienced in Database Testing using SQL queries on RDBMS databases like SQL Server and Oracle.
• Strong experience in using Quality Center and Test Director for Requirement Management, Test Planning, Test Case development, Test Case execution and Defect Tracking
• Experience in identifying and documenting in detail discrepancies between actual and expected results
• Ability to handle multiple tasks and work independently and in a team environment
• Ability to communicate with both Business and Technical Project Team members
• Strong interpersonal, communication and writing skills

TECHNICAL SKILLS:

ETL Tools:  Informatica 8.6.1/8.6/8.5/8.1/8.0 Informatica Power Exchange (Designer, Workflow Manager & Monitor, Server Manager, Power Connect), SSIS, Ab Initio (GDE 1.15, CO>Op 2.15), Data Stage 7.x

Data Modeling:  Star Schema Modelling, Snow Flake Modelling, Erwin 4.0

Databases:  Oracle 10g/9i/8i, Teradata V2R5 and V2R6/V12 (Manager, SQL Assistant, PMON),MS SQL Server 2008/2005/2000 , DB2 8.0, Sybase 12.5

OLAP Tools:  Business Objects XIR2/XI/6.5, Cognos 8.0 Series, Crystal Reports

Languages:  SQL, PL/SQL, Unix Shell Script, Perl Script, XML, HTML, Visual Basic

Tools:  Microsoft Office - Word, Excel, Access, Visio, PowerPoint, Toad, SQL* Loader, PVCS, Autosys

Operating Systems:  Windows 2003/2000/NT, IBM AIX, Sun Solaris, Linux, HP Unix

PROFESSIONAL EXPERIENCE:

Confidential, Rochester, MN

ETL/SQL Testing

Responsibilities:

• Written SQL Queries to define, Identify and validate the code written for the data movement into the database tables.
• Participated in meetings with Business Analyst and Design Review meetings with the Developers for better understanding of the modules
• Prepared test plan, strategies and estimations
• Written various UNIX SHELL SCRIPTS for file manipulation, data parsing, text processing, job scheduling and cleanup needs.
• Source to target requirements, etl map specifications and business requirements were referred to write precise test cases
• Conducted walkthroughs with business and development team to get the approval of the test cases.
• Performed smoke test to make sure all the test environment is set and executed the test cases in QC
• Used Quality Center to log the defect and follow the complete defect cycle
• Conducted status meetings with Development Team and QA Team to discuss and resolve the issues reported in QC
• Used Control-M to test the batch interface jobs and their dependencies.
• Involved in developing, debugging and executing Unix Shell scripts.
• Performed regression testing of the application once the defect is fixed.
• Performed negative testing on the different modules of the application
• Wrote and executed test scripts and test cases for different source to staging, staging to accredited and accredited to data warehouse data flows.
• Participated in Functional and Design Review meetings of conversion components
• Participated in meetings on peer review of test cases on conversion components mentioned above and secured sign off on them before conversion test execution.
• Tested the above components by running the Ab Initio ETL jobs in UNIX box, verified and validated the requirements as per Functional and Design specs.
• Logged defects into Mercury Quality Center and participated in Defect Resolution daily meetings
• Writing Queries, Various DML statements, applying join conditions, functions to analyze the data in the database using SQL Server Manager.
• Writing Sub Queries, Correlated Sub queries to retrieve data from multiple tables.
• Interacting with BA s, Team leads for any clarifications or in getting data that should be provided/ dependent on different conditions.
• Interacted with BA s, Developers, Team leads to resolve the issues.
• Regressed fixed defects to closure
• Peer - reviewed test cases written by peers at onsite and offshore
• Mentored new test analysts at Wipro Offshore, India
• Submitted a weekly report on test case development and execution
• After successful completion of SIT, was involved in UAT support activities.

Environment: Unix IBM - AIX, Ab Initio (GDE 1.15, Co>Op 2.15), Oracle 10i, Mercury Quality Center, Toad, Toad for DB2, SQL, PL/SQL, XML Files, XSD, XSLT, XML Spy 2010, VSAM Files, MVS, JCL, Shell Scripting, PERL, Control-M

Confidential, Wilmington, DE

ETL/SQL Testing

• Conducted source-system data analysis to understand current state, quality and availability of existing data.
• Involved in supporting UAT testing execution in Hotfix environment.
• Given technical support to the UAT team in terms of writing the SQL code.
• Designed & Created Test Cases based on the Business requirements.
• Responsible for testing transformation/default value population logic according to mapping documents while testing batch/DW jobs.
• Developed and executed Complex SQL queries for verifying Transformation rules against ORACLE, SQL-Server 2005, Teradata and DB2
• Validated Source to target documents that are used in building interfaces are according to system requirement documents.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the database in UNIX environment for testing the business rules imposed on data movement.
• Involved with Design and Development team to implement the requirements.
• Developed and Performed execution of Test Scripts manually to verify the expected results.
• Validated that design meets requirements and function according to technical and functional specifications.
• Used HP Quality Center 9.2 to state requirements, business components, test cases, and test runs for every iterations, defects. Also link defects with requirements.
• Worked with other members of the QA and Development teams and offshore team in improving the processes, methods, effectiveness and efficiency
• Designed Source to Targets mapping.
• Performed front-end testing on OBIEE Executive Dashboard portal
• Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
• Generate data requirements and system specifications in an organized fashion for business solutions and for the developers to follow on.
• Used TOAD & SQL Navigator GUI tools for Querying Database.
• Documented and reported various bugs during Manual Testing.
• Involved in running the ETL loads in development server
• Written SQL Queries to define, Identify and validate the code written for the data movement into the database tables.
• Retesting the resolved defects/issues after the developers fix the defects
• Involved in preparing test data for UAT and participated in UAT signoff
• Created Logical Data Model as a blended configuration of Conceptual Model elements along with material deemed essential and/or useful from the source-system analysis.
• Developed the strategies for analyzing the data for ETL Team
• Updated the status of the testing to the QA team, and accomplished tasked for the assigned work to the Project Management team regularly.

Environment: MVS, ISPF, OS/390, JCL, COBOL II, VSAM, Erwin, Test Cases, Test Scripts, Test Plan, Copy Books,, Informatica 8.1/ 7.1.4, Oracle 8i/9i/10G, Teradata V2R5/V2R6 Teradata SQL Assistant, SQL Server 2000,OBIEE, Flat files, PL/SQL, SAS/ETL, SAS/ODS, SAS/MACROS, SAS/STAT, TOAD 8.0, SQL, UNIX, Maestro 8.0 (Tivoli Work Scheduler), Charm, Remedy, Test Director

Confidential, Durham, NC

Data/SQL Tester

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Involved in complete project software development life cycle (SDLC) and Quality Assurance Life Cycle (QALC)
• Responsible for Data quality checks in OLAP data.
• Worked closely with the User Acceptance Test Coordinator, Project Manager and Business system analysts to understand business processes and develop concrete User Acceptance Test cases.
• Review and rework of the deliverables from team members.
• Developed test scenarios for testing Enterprise Data warehouse and Credit Data Mart data in DB2 environment.
• Developed SQL scripts to validate the data loaded into warehouse and Data Mart tables using Informatica.
• Developed Reports and Graphs to present the results to the management.
• Developed several Unix Shell scripts for running the jobs.
• .Performed Data Driven Testing of the Application for different users/data sets
• Preparation of test data for various levels of testing
• Performed segmentation to extract data and create lists to support direct marketing mailings and marketing mailing campaigns.
• Load new or modified data into back-end Oracle database.
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Worked on issues with migration from development to testing.
• 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

Environment: SQL, PL/SQL, T-SQL, SAS/BASE 8.1, SAS/Access, SAS/Connect, Informatica Power Center 7.1 (Power Center Designer, workflow manager, workflow monitor), Test Director, DB2, SQL *Loader, Cognos 7.0,Oracle8i, SQL Server 2000, Erwin 3.5, Windows 2000, TOAD 7, XML Files, VSAM Files, Dat Files

Confidential, Reston VA

ETL Tester

Responsibilities:

• Designed Sources to Targets mapping from primarily Flat files to Oracle using Informatica PowerCenter.
• Coordinated with source system owners, day-to-day ETL progress monitoring, Data warehouse target
• schema design (Star Schema) and maintenance.
• Worked on Informatica PowerCenter 6.1 tool - Source Analyzer, Data warehousing designer, Mapping Designer, Mapplet & Transformations.
• Designed and developed UNIX scripts for creating, dropping tables which are used for scheduling the jobs.
• Wrote pre-session shell scripts to check session mode (enable/disable) before running/ schedule batches.
• Various kinds of the transformations were used to implement simple and complex business logic. Transformations used were: Remote Procedure, connected & unconnected lookups, Expressions, source qualifier, aggregators, filters, sequence generator etc.
• Main contact for vendor regarding technical and user issues for the design, development and maintenance of the new Oracle based client-server software system.
• Designed a new system for the Fire Prevention Department using Tidemark’s Advantage, Utilities, Designer and Import/Export modules.
• Created links between Fire Prevention Department case types never done before in Tidemark Advantage.
• Supported the Tidemark Permit Plan / Advantage client-server software and AIRS (Automated Inspection Request System) for the Department of Planning and Development and Fire Prevention Department for over six years.
• Main technical advisor for the customer departments.
• Coordinated efforts with several departments for data transfers and data standardization across micro and mainframe platforms.
• Created links between Tidemark Permit Plan / Advantage and other batch and real-time, third-party software systems.
• Worked closely with third-party software vendors.
• Prepared program specifications for PL/SQL Procedures and Functions to do the data migration and conversion.
• Analyzed and prepared Statement of Work and Requirement Definition Document.
• Creating the Oracle schema i.e. table spaces, tables, indexes, constraints, triggers, synonyms, Database links, roles etc. Implementing basic replication using snapshots.
• Developed Test Plans and tested the application to ensure proper functionality, data accuracy and that modifications have no adverse Impact on integrated system environment.

Environment: Oracle 8i (SQL, PLSQL), Forms 4.5i, Reports 2.5i, TOAD, PERL, Shell Scripting, XML