SUMMARY:

• Over 8+ years of IT experience in the Analysis, design, development, testing and Implementation of ETL & Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.
• Expert in writing complex SQL queries and Unix to execute the back end jobs.
• Expertise in defining Test Strategies, writing detailed Test Plan and Test Cases, Defect Tracking and Defect Reporting using Mercury Test Director and Quality Center.
• Extensive experience in Database Testing in Oracle, SQL Server and DB2 SQL.
• Expertise in Data Mover scripts for Data Export and Import.
• Experience in Integration and extraction of data from various sources like DB2, SQL Server, Oracle, Sybase, and Teradata, Ms Access, Flat files into a staging area.
• Extensive experience in Data validation and verification in all ETL Stages (Source, Staging and Target environments).
• Created manual Test Cases in HP QC/HP ALM for various User Stories based on Release and Sprint Plan.
• Good knowledge on Automation Tool Selenium and Quick Test Professional.
• Working experience in Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Analysis Services (SSAS) and Integration Services (SSIS).
• Hands on expertise in Data ware housing concepts and tools. Involved in the ETL processes where in the organizations were using Data stage, Informatica, Ab initio and Auto sys tools.
• Analyzed and tested Data Stage jobs with OLTP source data, staging and target data.
• Experience on different types of Testing like Black Box, White Box, Integration, System, Functional and Regression Testing.
• Generated automated Scripts in QTP and designed Automated Test Suites for regression testing in Quick Test Pro.
• Knowledge of and ability to apply a wide range of software test engineering concepts: testing principles (Testing Methodology) and concepts, building a test environment, tracking defects n Quality Center
• Hands on expertise with test automation tools such as HP QTP (Quick Test Pro).
• Experience in assisting the customer in User Acceptance Testing (UAT).
• Experienced in working in Agile Scrum, Agile XP, Waterfall, RUP and SDLC methodology environments.
• Strong knowledge of Business Intelligence, Data Warehousing and Business Architecture
• Excellent skills in TeraData, DB2, SQL Server and Oracle 11g/10g/9i/8i RDBMS and Sybase.

TECHNICAL SKILLS:

Quality Assurance Tool: HP ALM 11/HP Quality Center 10, Test Director 7.5, IBM ClearQuest

Environment: Windows 98/2000/NT/XP, IBM Mainframes, Unix, Linux.

Languages: SQL, PL/SQL,Shell, Perl and bash

RDBMS: Oracle 8i/9i/10g/11g, SQL Server, Teradata, Sybase, DB2

GUI/ RDBMSQuery Tools: SQL* Plus, Oracle SQL Developer, SQL Server Management studio, Teradata SQL Assistant 13.0, TOAD, WinSQL

ETL Tools: Informatica PowerCenter 8.x/9, Ab Initio, SSIS and Datastage

BI Tools: Business Objects XIR2/XIR3, Cognos, Microstrategy, SSRS and Hyperion

PROFESSIONAL EXPERIENCE:

Confidential, Denver, CO

Sr. QA Analyst

Responsibilities:

• Documented the business requirements, developed test plans, test cases created for the database backend testing and to test database functionality.
• Assisted in gathering the business requirements, ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project
• Different Data Stage components especially are used effectively to develop and maintain the database
• Developed ETL test cases for various lines of businesses based on ETL mapping document.
• Backend testing of the DB by writing SQL queries and PL/SQL scripts to test the integrity of the application and SQL Server database.
• Expertise in validating SSIS and SSRS packages according to functional requirements.
• Expertise in writing SQL Statements in database to make sure whether the data is populated in Data Mart/Data warehouse According to Business Rules.
• Closely went through and worked on all the stages of SDLC for this project and designed and executed Functional, Integration, Regression, System (End to End) and Backend (Database).
• Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded.
• Involved in Test plan, Test case preparation and assigning defects through TFS
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing in a corporate - wide-ETL Solution.
• Created ETL test data for all ETL mapping rules to test the functionality of the SSIS packages.
• Used SQL for Querying the SQL Server database in UNIX environment
• Written Complex SQL Queries. To do Manual testing in my feature for every release and check the configurations
• Validated SSRS dashboard reports by writing several complex SQL queries based on reporting logic.
• Created ETL test data for all ETL mapping rules to test the functionality of the SSIS packages.
• Tested several different types of reports including Report Layout, Naming Conventions, Totals, and Sub-Totals, Drilling options, prompts, metric calculations, drill maps and security filters.
• Ran several jobs in data stage from both command line and front-end.
• Wrote SQL and PL/SQL scripts to validate the database systems and for backend database testing.
• Raised defects in HP Quality Center defect tracking system.
• Good experience in writing SQL in order to data validation in migration as part of backend testing Worked with ETL group for understating mappings for dimensions and facts.
• Assisted in promotion of Data stage code and UNIX from UAT to Production.

Environment: SQL,PL/SQL, TOAD, Data warehouse ETL IBM Data Stage 8.1, SQL Server, SSIS, SSRS, SSAS, Quality Center/ALM 11.0, .Net, Visual studio, MS Access,, DB2, SDLC, TSYS, SQL Developer, QTP, UNIX, PERL, DB Visualizer, EMWE WEBSITE, Flat Files, Pivot Tables, Pivot Tables.

Confidential, Lake George, CO

Sr. QA Tester

Responsibilities:

• Running of ETL jobs and test data setup using Autosys, Quality check for test data. -Transformation logic verification, RCA for defect found.
• Used SQL Server to run SQL queries and validate the data loaded into target tables
• Tested several Informatica Mappings to validate the business conditions.
• Testing the source and target backend databases for conformance to specifications
• Writing complex SQL queries for data validation for verifying the SSIS Packages and SSRS for reporting.
• Worked in an intense AGILE environment, where the code is delivered every 3 days .
• Participated in weekly defect review meetings with the dev./business and test team peers
• Extensively involved in Onsite-Offshore model, where need to held meetings on daily basis, as were following AGILE methodology.
• Tracked the defects using QC ALM tool and generated defect summary reports.
• Extensively used grep,AWK,find commands and used Shell Scripting to call back end jobs
• Validated the data movement (XML, Flat Files, VSAM,.dat,.xls) and transformations are done correctly
• Worked with Data Warehousing developers who extensively used Informatica9x, to design
• Mapping to move data from source to target database-using Stages to do the functionality.
• Testing of Data Mapping documents between source and target databases as per transforming logic
• Prepared status summary reports with details of executed, passed and failed test cases
• Backend testing of the DB by writing SQL queries and PL/SQL scripts to test the integrity of the application and SQL Server databases.
• Reviewing Functional Specification Document and preparing traceability matrix for test case mapped.
• Participated to develop automation scripts in QTP to automate smoke and regression testing.
• Reported the bugs through email notifications to developers using TFS
• Used Quality center to execute automation scripts in batch mode or unattended mode.
• Enhanced the scripts in QTP by applying checkpoints, parameterizations, synchronization point, data driven tests and creating modular tests.
• Partner with business and development partners to create detailed test plans and validation strategies. 
• Identify and document defects in a defect tracking system and manage issues/defects through resolution. 
• Identifying duplicate records in the staging area before data gets processed. Provide communication to project stakeholders. 
• Manually execute detailed test procedures designed to validate application functional requirements. 
• Ensure software requirements are verifiable and quantifiable with the ability to build test cases. 
• Contribute to efficient and effective program in solving medium-complex business problems. 

Environment: SQL, Oracle, TOAD, Unix, ETL Informatica, AutoSys, SQL Server, SSIS, SSRS, SSAS, WIN SCP, QTP, .Net, VB descriptive scripting, HP Quality Center .

Confidential, Atlanta, GA

QA Analyst

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Assisted for the business requirements, ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project
• Tested Complex ETL SSIS and SSRS Packages, Sessions based on business user requirements and business rules to load data from different source
• Promoted Unix/Data Stage application releases from development to QA and to UAT environments as required.
• Wrote Complex SQL queries and PL/SQL subprograms to support the test case results, SQL performance tuning.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to test business rules and security.
• Involved in user training sessions and assisting in UAT (User Acceptance Testing).
• Assisted in promotion of SQL Server Integration Services and UNIX Shell scripts from UAT to Production.
• 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.
• Assisted in System Test and UAT testing scenarios as required
• Worked with thin client and thick client (Business Objects )
• 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 Data Stage Mapping
• Extensive experience in writing complex SQL and PL/SQL scripts.
• Written several complex SQL queries for validating Cognos Reports.
• Tested the reports using SSRS reports.
• Created ETL test data for all ETL mapping rules to test the functionality of the SSIS packages.
• 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.
• 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

Environment: SQL, PL/SQL, TOAD, MVS, UNIX, Oracle, DB2, .Net, SQL Server, SSIS, SSRS, SSAS, XML, XSLT, XSD, Rapid Data Files, XML Files, Visual Studio, MS Access, Quality Center, Autosys

Confidential, Alpharetta, GA

Quality Analyst

Responsibilities:

• Worked closely with Business user in Understanding designing and documenting the Functional testing plan and then Writing, executing, documenting the results and Logging defects.
• Involved in development and implementation of test cases test plans test data and test scripts for customers.
• Involved in preparing detailed Business Analysis documents, ETL SSIS design documents, unit test plans for the mappings
• Involved in testing the data warehouse for both the initial load and the incremental loads of the target
• Used Quality Center to develop test cases, and executed them in test lab.
• Involved in various kinds of testing like functional testing, system testing and integration testing.
• Constructed context diagrams and data-flow diagrams based on the description of a business process. Analyzed the data model to code efficiently in SQL.
• Writing complex SQL queries for data validation for verifying the SSIS Packages and SSRS reports and business Rules.
• Worked with UNIX scripts. Worked with releasing scripts live and tested.
• Extensively involved in performance tuning at source, target, mapping, session and system levels.
• Worked on generating reports using SQL Plus and PL/SQL. Worked on tuning SQL statements.
• Worked intensively with indexes to tune the query, exploited the B-tree and Bitmap index functionality of oracle to get the better performance.
• Backend testing of the DB by writing SQL queries and PL/SQL scripts to test the integrity of the application and SQL Server databases.
• Good experience in working with UNIX scripts in executing and validating logs for the issues.
• Involved in complete life cycle activities like pre-testing phase and testing phase.
• Analyzed system requirements specifications, developed executed detailed test plans test cases, security and usability of application information.
• Created Test Procedures and Test Cases to perform the system testing and Regression testing.
• Attended bug review and client meetings.

Environment: ETL, Toad, SQL, PL/SQL, Test Director, Quality Center, .Net, Visual Basic, Oracle, SQL Server, SSIS, SSRS, SSAS, QTP, Windows 2000, UNIX.

Confidential, Atlanta, GA

QA Analyst

Responsibilities:

• Involved in Data Validation using SQL queries.
• Performed negative testing, to make sure validations are done properly.
• Provide update to management on testing status and some other issues.
• Carried out and oversee test execution for Business scenario, User acceptance and Regression testing
• Involved in Data Validation with Business Team.
• Creating and executing SQL queries to perform Data Integrity testing on an Oracle Database to validate and test data using TOAD.
• Was involved in design part for Extracting data from different source systems into the target database using Data stage Server 6.1.
• Extensively involved in Extracting, Transformation and Loading of data to target oracle warehouse database.
• Was responsible for Creating Job, Job Sequencers and Shared Containers.
• Extensively developed and deployed Unix Shell scripts as wrappers that build runtime parameters to DataStage jobs.
• Validated Business Objects dashboard reports by writing several complex SQL queries based on reporting logic.
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Review the test cases written based on the Change Request document.
• Testing has been done based on Change Requests and Defect Requests.
• Used Test Director, to manage the entire process and log in defects
• Effectively coordinated with the development team.
• Created critical scenarios for each change request and defect request.

Environment: Data stage Server 6.x, Oracle 9i, C++, UNIX, IBM AIX 5.0, .Net, Test Director, and Shell Scripting