SUMMARY:

• Over 7+ years of diverse experience in the field of Information Systems with emphasis on Business Analysis, System Analysis and Quality Assurance projects focused on diverse domains
• Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.
• Experience writing and maintaining test automation in XML using QTP, XPath, XQuery, XSchema is required
• Have the ability to evaluate an ETL/BI specification, verify it with Systems experts and data architects, and assess if it complete and fully understand EDW and ETL Architecture.
• Having extensive experience in testing and maintaining applications in Data Warehouse using ETL tool Data Stage 8/PX7.5/7.5.2.
• Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL
• Experience in Data Modeling using Erwin in Client/Server and distribute applications development
• Expertise in Defect Tracking, Defect management and Bug Reporting Tools like Mercury’s Quality Center (TestDirector), Project Trak, Rational Clear Quest and version control tools like Rational Clear Case. Participated in and Bug Reporting using Test Director for business software and Web applications.
• Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within time frame
• Extensively strong on databases including Oracle 10g/9i/8i, MS SQL Server 2000/2005/7.0 and DB2
• 7 plus years of experience in SQL, PL/SQL, and Shell scripting. About 6+ years of strong Data Warehouse ETL experience using Ab Initio, OLAP, Teradata, Oracle 9.x/8.x, SQL*Plus, SQL*Loader, and various kinds of UNIX flavors
• Extensive experience in Functional Testing, System Testing, Integration Testing, Regression Testing, User Acceptance Testing, Performance Testing, Stress Testing and White & Black Box testing manually and also using automated tools WinRunner, Load and Stress testing using Load Runner and QTP for testing Client / Server and Web based applications. Experience in Integration of TestDirector with Mercury Interactive tools (WinRunner and LoadRunner) and external tools like Rational Clear Quest and Rational Clear Case. Knowledge of SQA, ANSI, ISO, CMM levels
• Six years of IT experience in Analysis, Design and Development on ETL (Extraction, Transformation and Loading) mechanism using Informatica using DTS, SQL Server 2005 SSIS, SSAS, SSRS in complex, high volume Data Warehousing projects in both Windows and Unix environment
• 6+ yrs of Experience in Data Analysis, Data Validation, Data Profiling, Data Verification,Data Mapping, Data Modeling, Data Loading and 5+ years of Data Warehousing testing experience
• Good experience in Data Modeling using Star Schema and Snow Flake Schema and well versed with UNIX shell wrappers, KSH and Oracle PL/SQL programming and stored procedures
• Experience in testing Data warehousing Applications developed by Informatica, Data Stage, Oracle and DB2/UDB
• Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL Loader
• Strong in developing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL
• Good experience in Data Modeling using Star Schema and Snow Flake Schema and well versed with UNIX shell wrappers, KSH and Oracle PL/SQL programming and stored procedures.
• Excellent programming and problem solving skills having worked on C, C++, VB, SQL, PL/SQL
• Extensive knowledge in regression testing and design documentation.
• Extensive experience in writing SQL and PL/SQL scripts to validate the database systems and for backend database testing.
• Good experience in data sources, data profiling, data validation, developing low level design patterns based on the business and functional requirements.
• Excellent communication, analytical and interpersonal skills.

TECHNICAL SKILLS:

Business Modeling Tools: MS Visio, Power Designer

Change Mgt Tools: Test Director, Quality Center, PVCS

Database: DB2, Oracle, SQL Server, Teradata

Data Warehouse Tool: Informatica Power Center, MS DTS Packages & Fast Load

Functional Test Tools: WinRunner

Languages: PL/SQL, T - SQL, SQL, XML, Visual Basic

Office Tools: MS Office Suite, MS Project

Operating System: IBM AIX, UNIX, Windows

Rational Tools: Requisite Pro, Clear Case, Clear Quest, Manual Tester

Reporting Tool: Cognos 8.0 Suite, Business Objects XIR2, Crystal Reports 7.x

Standards: RUP, CMM, ISO 9001

Tools: XMLSpy 4.3/5.0, TOAD, SQL Enterprise Manager, SQL Query Analyzer, Win SQL, Citrix, Control Center

Web Technologies: XML, XSL, XHTML, HTML, CSS, JavaScript, VBScript

PROFESSIONAL EXPERIENCE:

Confidential, Naperville, IL

Sr. QA Analyst

Responsibilities:

• Responsible for developing system test strategies and plans and translating technical, functional and performance requirements into detailed test plans and test cases.
• Written test plans, which detailed the testing scope, strategy, hi-level test requirements, and necessary resources.
• Documented test cases corresponding to business rules. Analyzed user requirements, attended Change Request meetings to document changes and implemented procedures to test changes.
• Perform additional compliance functions including preparation of process improvement initiatives.
• Create and set up test environments (build, install and maintain the technology used in the testing environment).
• Involved in writing and executing the SQL querys using DDL and DML statements.
• Verified the data in TOAD by writing the complex SQL joins in Fee Schedule system
• Verified the data Confidential the backend for all the claims processed in specified networks
• Developed test plans and test cases based on the business requirements.
• Developed and executed integration, regression, black box, white box and system tests for the web applications. Involved in testing life cycle.
• Involved in the production checkout for dot releases.
• Tested and verified the claims in EDI format.
• Responsible for testing the applications related to Fee Schedule, Rate Sheet, Billing, A/R, Networks, Providers, Customer Support Service and Claims Processing.
• Automated manual test cases into automated scripts using QTP 9.0. Developed several regression test suites. Involved in developing functions which are reusable in other scripts.
• Logged the defects in Rational Clear Quest.
• Execute UAT Scripts internally, prior to delivery of code to customer for User Acceptance Testing.
• Verified the log files in Unix environment and executed the shell scripts.
• Involved in utilizing the WAS MQ Series to route the messages from one system to the other system
• Verified the Queues, Queue Managers and Clusters in MQ Series.
• Tested Cognos Reports according to the business requirements.
• Tested several complex reports generated by Cognos including Dashboards, Summary Reports, Master Detailed, Drill down.
• Verified the data in Data Stage including Manager, Designer and Director.
• Tested the reports in Cognos Business Intelligence.
• Retrieved the data from DB2 and executed the SQL queries.

Environment: Mercury Quality Center9.0, QTP 9.0, Datastage, ETL, Business Intelligence, Cognos 8.0, J2EE, Java, Eclipse, XML, SOAP, Agile Methodology, WAS MQ Series, Web Services, RUP, Rational Clear Case, Rational Clear Quest, C++, .Net, Oracle BPM, SQL, TOAD, PERL, HIPAA, EDI, DB2, UDB, Mainframe, JCL, Tivoli. UNIX, Shell Scripts, PERL, CGI, HTML, Windows NT, MS Office

Confidential, Hoffman Estates, IL

Sr. ETL QA Analyst

Responsibilities:

• Reviewed Business Requirements Documents and the Technical Specification.
• Written test plans, which detailed the testing scope, strategy, hi-level test requirements, and necessary resources.
• Documented test cases corresponding to business rules. Analyzed user requirements, attended Change Request meetings to document changes and implemented procedures to test changes.
• Involved in RUP business requirements, user requests and bug Scrubs meetings
• Wrote test cases and test scripts for the functionality testing.
• Manage test script development, execution and monitoring in Test Director 8.0
• Performed End-to-End testing manually.
• Extensively involved in testing the application in Manual Testing environment.
• Involved in utilizing the TIBCO Rendezvous to route the messages from one system to the other system. Create data to support the User Acceptance Test Cases.
• Involved in writing and executing the SQL querys
• Execute Test phase Test Cases. Documented DCRs found during the execution of Test Cases per Testing Phases. Retest Code modified as a result of DCRs.
• Closely worked with developers and System Engineers to nail down the technical problems
• Developed several regression suites. Wrote functions that are reusable in other scripts.
• Performed Regression testing
• Reported the bugs, Email notifications to the developers using rational Clear Quest.
• Monitored Clear Quest to close the bugs/cases as and when developers fix the bugs

Environment: Test Director 8.0, Rational Clear Quest, Rational Clear Case, Sybase, SQL, TIBCO Rendezvous, C++, Java, J2EE, RUP. Lotus Notes 4.6, Sybase, SQL, DB2, UDB, CICS, Unix (HP-UX 10.2), Mainframe, UNIX, Windows NT, MS Office

Confidential, Madison, WI

Sr. DWH/ Quality Analyst

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 9.0
• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.
• External interactions with NSCC, DTCC, NFS and various fund companies in which MMLISI is associated.
• 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.
• 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.
• 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.
• Tested with Front-end functionality for the entire application
• Tested the data load process using the Informatica Power Center ETL tool.
• Focused on Data Quality issues / problems that include completeness, conformity, consistency, accuracy, duplicates, and integrity.
• Worked as liaison between support team, business and development team for resolving multiple issues during test execution and data loading.
• Worked with Data Conversion projects for testing data quality after migration.
• Experienced using database query tools for Oracle, SQL and UNIX such as TOAD, Teradata SQL Assistant and SQL Plus.
• Experienced in data analysis using SQL, PL/SQL and many other queries based applications.
• Written several UNIX scripts for invoking data reconciliation.
• Worked with safety regulations and enforces section 361 of FDA Rules for validating the data.
• Worked with FDA Compliance Software for validating electronic & audit trial data.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Validated business reporting requirements with internal and external customers.
• Used SQL for Querying the DB2 database in UNIX environment
• Used workflow manager for session management, database connection management and scheduling of jobs.

Environment: Informatica Power Center 8.1/7.1, (Power Center Designer, workflow manager, workflow monitor), FDA, 21 CFR Part 11, Shell Scripting, SAS/ODS, SAS/ETL, SAS/SQL, SAS/Connect, SAS/Access, SQL, PL/SQL, Teradata V2R6, FLOAD, MLOAD, TPUMP, BTEQ, FEXPORT, SQL Assistant 6.2.0, Quality Center 8.2, Oracle 10g, Cognos Series 7.3, Report Net, Impromptu, Report Studio, SQL Server 2005, Erwin 4.0, UNIX, Windows 2000, TOAD

Confidential

ETL QA

Responsibilities:

• Created and documented Test Plan and detailed Test Procedures for the application
• Responsible for testing GUI module which is the heart of Patient-Soft application
• Understanding existing sales system.
• Extracted Data from Oracle and Flat files using Informatica.
• Design of ETL processes using Informatica tool to transform data from source system to target database.
• Designed and developed various Mappings using transformations like aggregator, joiner, Lookup, Filter, Router and Update Strategy.
• Writing Various SQL queries for Testing the Mappings and PL/SQL blocks like Procedure and Functions.
• Used Debugger for debugging Mappings.
• Performed tasks of executing, scheduling and validating the sessions in Informatica workflow manager.
• Executed test cases before and after bug fixes for each build
• Interacted with developers regarding priority of bugs and update the status of bugs once they are fixed

Environment: Informatica 6.1, Oracle 8.x/9i, IBM AIX 5.2, Shell Scripting, SQL, PL/SQL, UNIX