SUMMARY

• Over 7+ 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.
• Extensively Used Quality Center, PVCS Tracker, Rational Clear Quest for Test Case and defect tracking management.
• 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

Defect Tracking Tools: HP ALM 11/ HP Quality Center 10/9.0/9.2, IBM Clear Quest 9.0,QTP, Bugzilla and Jira

ETL Tools: Informatica 9.0,Data Stage, Ab Initio 1.15, SSIS

BI/Reporting Tools: Business Objects XIR4, Crystal Reports XIR4, Cognos 8.4

Operating System: Windows 98/XP/2000,UNIX, Linux

Methodologies: Waterfall, Iterative, Agile/Scrum, SDLC, STLC

Programming Languages: SQL, PL/SQL, XML, java, C, Perl scripting, VB

RDBMS/ Database: SQL Server, Oracle, IBM DB2, Teradata 12.0GUI Tools: TOAD, Oracle SQL Developer, SQL* Plus, SQL server

PROFESSIONAL EXPERIENCE

Confidential, Overland Park, KS

Sr. QA Test 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 Oracle databases.
• Expertise in writing SQL Statements in database to make sure whether the data is populated in Data Mart/Data warehouse According to Business Rules.
• Hands on experience in testing soap UI and xml web service interfaces and running basic UNIX.
• 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.
• Developed and Executed Test Plan & Test Script in Quality Center
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing in a corporate - wide-ETL Solution.
• Execute batch jobs using Control-M enterprise manager and check SYSOUT, ERROR LOG details.
• Used SQL for Querying the Oracle database in UNIX environment
• Written Complex SQL Queries. To do Manual testing in my feature for every release and check the configurations
• Involved in testing Web services and XML using SOAP UI. Verified the response received by updating the request XML.
• Tested several ETL job activity for data stage using Data stage designer
• 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.
• Designed Traceability Matrix to match the test scripts with the Functional design document.
• 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: DWH ETL Informatica 9, Business Objects XIR4, Oracle 11g/10g, SQL Server, DB2, Teradata, SOAP UI, XML, Webservices, HP Quality Center, C#, .Net, Java, ALM, Sql server 2008,UAT, TOAD, SQL, SQL*Plus, UNIX, Flat files, XML,, XML Spy 2010, Windows

Confidential, Madison, WI

Sr.QA Tester

Responsibilities:

• Used SQL tools like TOAD for Oracle 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
• Participated in daily meetings with Business/DEV teammates to enhance the productivity.
• 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.
• 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 Oracle databases.
• Reviewing Functional Specification Document and preparing traceability matrix for test case mapped. Responsible for WQA representation in the full end-to-end testing processes.
• Design and write formal test plans and test specifications to address system, integration, and data conversion testing.
• Participated to develop automation scripts in QTP to automate smoke and regression testing.
• Tested several BO Reports for several business needs including Dashboards, Drill-Down, Master-Detailed, Aggregated, KPI s, Grouped List, Cascade and Web Reports
• 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: ETL Informatica 8.6, SQL Server, Cognos, SQL, TOAD, Quality Center 11,SOAP UI, XML, WEB Services, PL/SQL, MS Office 2007, Oracle 10g, Windows XP/2003, UAT, QTP, Ration Tools, Clear Quest, VB Script, Excel.

Confidential, Baltimore, MD

QA Analyst

Responsibilities:

• Involved in analyzing system design specifications and developed Test Plans, Test Scenarios and Test Cases to cover overall quality assurance testing.
• Tested all the ETL process that were developed to fetch the data from various feeds into the data warehouse.
• Written SQL scripts for validating the data loaded by the ETL processes.
• Tested the reports developed using Business Objects.
• Perform manual testing and created various test results to track the testing results.
• Export requirement, test cases into the Quality Center, run manual and automation test cases from test lab and log defects from defects module.
• Followed up with standard software testing life cycle (STLC) to perform different types of testing for the projects.
• Participated in peer review meeting for created Test plan, test cases and analyzing various testing documents and process of testing life cycle.
• Create standard testing life cycle flow diagram for projects and presented to test team to follow testing process.
• Participated to create Test Analysis reports (TAR) and stored them into the Quality Center.
• Updated RTM in daily, send status report and daily tracking report to test manager.
• Performed UAT testing in the UAT environment prior to notify to the customer to start performing UAT testing.
• Developed SQL Queries to retrieve or create test data from different Oracle Test databases.
• Writing complex SQL queries for data validation for verifying the SSIS Packages and business Rules.
• Tested reports in report studio and query studio by using SQL.
• Met with client to present future functionality of the application, gather information from them to know about their need and send this information to test manager.
• Automated and scheduled the Data stage jobs using UNIX Shell Scripting.
• Worked closely with the application development and design and testing team to resolve technical issues and interacted with them to ensure overall quality of the software.

Environment: Data Stage, Business Objects, SQL Server Quality Center 9.2, Web Services/Web methods, XML, HTML Oracle, SQL,ALM, TOAD, Windows 2003/2007, UNIX.

Confidential, Boston, MA

Quality Analyst/ Software Tester

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 testing the data warehouse for both the initial load and the incremental loads of the target
• 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.
• Worked on generating reports using SQL and PL/SQL. Worked on tuning SQL statements.
• Involved in preparing detailed Business Analysis documents, ETL design documents, unit test plans for the mappings
• Involved in debugging of the scripts according to the modifications made to the build using QTP
• Defined and executed test cases across a number of internally developed Front and Middle office applications through Clear Quest.
• 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: Informatica power mart 5.1, Toad, Test Director, Visual Basic 6.0, Rational Functional Tester, Rational Clear Quest, Rational RequisitePro Oracle 8i, QTP, Windows 2000, UNIX.