Professional Summary

• Information technology professional with 7 years experience in Requirement's Gathering, Analysis, Documentation, Testing, Implementation and Maintenance. Specialized in Quality Assurance and testing, worked as ETL Tester, SQL Tester, BI Tester, Data Tester and QA Analyst.
• Experience with Software Development Life Cycle SDLC with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.
• Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
• Experience in Data Migration, Database Transferring and related objects in SQL Server from one server into other Remote servers.
• Tested applications in Waterfall and Agile development processes.
• Experienced in DW projects ETL testing against DW testing with Informatica, Ab Initio and data stage tools.
• Experience in Integration and extraction of data from various sources like DB2, SQL Server, Oracle and Teradata, Ms Access, Flat files into a staging area.
• Expertise in Developing PL/SQL Packages, Stored Procedures/Functions, triggers.
• Expertise in utilizing Oracle utility tool SQL Loader and expertise in Toad for developing Oracle applications.
• Experience in Mercury Quality Center - Design Test Steps, Requirement Mapping to Tests, Executing Tests Manually, Defect Logging, Defect Reporting
• Proficient experience with SQL Server and MSBI tools like SSIS
• Strong skills in database programming using SQL, PL/SQL, T-SQL, Stored Procedures
• Extensive Working experience in applying Relational Database concepts, Entity Relation diagrams and Normalization concepts.
• Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within time frame
• Experienced in DW projects ETL testing against DW testing with Informatica, Ab Initio and data stage tools.
• 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.
• Extensive experience in writing SQL and PL/SQL scripts to validate the database systems and for backend database testing.
• Excellent communication, analytical and interpersonal skills
• Good analytical skills, presentation skills with strong communication skills

Technical Expertise

• Testing Tools
• HP Quality Center10/9.2/Test Director, Clear Quest, QTP 8.0
• Utility Tools
• TOAD v.10.5, SQL Server Management Studio, SQL Plus, SQL Loader, SQL Developer, SQL Assistant
• Databases RDBMS
• Oracle 10g/9i/8i, DB2 8.0/7.0/6.0, SQL Server 2000/2005/2008, MS Access, Teradata V2R4
• Operating Systems
• Windows 98/2000/XP/7, Linux and UNIX
• Languages
• SQL, PL/SQL, T-SQL, C, C , Dot Net
• Networking
• TCP/IP, FTP, UDP, ATM, Ethernet, LAN WAN
• Data Warehousing Tools
• Informatica 8.6.1/8.1.1, Data Stage 7.5
• BI Tools
• Business Objects XIR3, Cognos 8, SSRS

Work Experience

Confidential

ETL QA Tester

Responsibilities:

• Interact with Business Analysts to clarify the User Design and functionality of the application. Writing Test Cases corresponding to business rules and requirements..
• Prepared Test Scenarios of testing and maintaining testing standards.
• Tested the IKA GUI application for all the Medicare and Medicare advantage plans.
• Mocked data as per CMS Rules and tested the Membership Enrollment Application
• Tested the subscriber and Member enrollment in association with class, plan and product.
• Developed Ab Initio test environment for UAT testing and used all Ab Initio components while testing the graphs and ran the jobs on back ground.
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Created ETL test data for all ETL mapping rules to test the functionality of the Ab Initio graphs
• Tested the ETL Ab Initio graphs and other ETL Processes Data Warehouse Testing
• Validate the Files from IKA that are processed in NMS Horizon New Membership Enrollment System .
• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.
• Responsible for testing Business Reports developed by Business Objects XIR2.
• The reports that were created in Business Objects were testing by running the SQL statements
• As a Lead, was involved in weekly status, following up the development as well as the business /Testing teams, re-scoping project planning.
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices.
• Validated the data in NMS which is IBM Mainframe System.
• Validated the Enrollment data that fed into the UCSW Universal Customer Service Workstation Inquiry/ Service Request Application
• Perform Functional, Regression, UAT testing. Validate provider access Portal with the Legacy if there are any difference just logs the defects, Its Web base application for the Provider.
• Involved in Production Checkout and validated everyday enrollment data in IKA, Validating the Error reports and validating the NMS.
• Followed RUP and AGILE development methodology and adhered to strict quality standards in requirement gathering.
• Involved in Data Extraction from Teradata and Flat Files using sql assistant.
• Involved in Manual and Automated testing using QTP and Quality Center.
• Metadata graphs from legacy source system to target database fields and involved in creating Ab Initio DMLs.
• Used Rational Clear quest for logging the Defects.
• Involved in Daily Defect Meetings with Business and Development Teams.

Environment: IBM Mainframe Systems NMS , Mercury Quality Center 10,MS Access 2010, Rational Clear Quest 7.1.1, Ab Initio CO>OP 2.15, GDE 1.15, Teradata SQL Assistant, Teradata V2R6, AGILE ,Business Objects XIR2/6.5.1/6.0/5.1.x/4.0 ,IKA GUI-Web Application

Confidential

ETL QA Tester

Responsibilities:

• Analyzing the requirements and understand project functionality.
• Estimating the testing scope of the project based on the requirements.
• Preparing test plan, test strategy, and risk management plan for the project.
• Experience in loading from various data sources like Teradata, Oracle,Fixed Width and Delimited Flat Files.
• Preparing the test case indexes and test cases using business requirements and technical requirement documents.
• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 9
• Tested several data validation graphs developed in Ab Initio environment.
• Worked with all kinds of components with Ab Initio including Dedup, Denormalize, Normalize, Rollup, Scan, Reformat, Redifine, Sort, Joiner, XML Read, XML Write, FBE, Partition Components
• Created and tested business processes UAT and Integration testing and supported end users in execution of test scripts.
• Involved in backend testing for the front end of the application using SQL Queries in Teradata data base
• An active participant in system Regression, Integration, UAT and Implementation Testing Supported the Stabilization of the new Lines of Business after Go-Live
• Wrote Complex Sql queries in Toad which are used in test cases for test execution.
• Tested Complex web service applications based on business requirements
• Worked in an Agile technology
• Used HP Quality Center for Test case execution and Log the defects.
• Attend Daily Defect triage calls and interacting with developers and Business analysts about the issues logged.
• Responsible for testing Business Reports developed by Business Objects XIR2.
• The reports that were created in Business Objects were testing by running the SQL statements
• Provide technical and procedural support for User Acceptance Testing UAT
• Preparing the Test Traceability matrix for mapping the requirements against Test Case Index and Test cases.
• Run the control m jobs in UNIX server.
• Used complex SQL Queries for Data mock up.
• Tested ETL data movement from source to target.
• Tested graphs for extracting, cleansing, transforming, integrating, and loading data using Ab Initio ETL Tool.
• Performed Functional, GUI, Regression, System Integration testing.
• Tested complex market transaction applications and applications with external vendors.
• Review of the test cases written for unit and integration level.
• Writing test cases for unit level testing and functional testing based on the threads.

Environment: Ab Initio CO>OP 2.15,Oracle 10g, Business Objects XIR2/6.5.1/6.0/5.1 HP Quality Center, Teradata SQL Assistant, Teradata V2R6,UNIX, VBScript, QTP, AGILE, SQL, PL/SQL, UNIX, Excel

Confidential

ETL QA Tester

Responsibilities:

• Functional and Technical understanding of domain with reference to BRD, SRS and design documentation
• Develop and execute functional/system test cases to ensure ETL data movement meets functional and design specifications.
• Created Test cases for Data Acquisition and Data Delivery and tested the data accuracy for all the transformations.
• 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
• Developed test scenarios for testing Enterprise Data warehouse and Credit Risk DataMart data in DB2 environment.
• Managed and executed the test process, using Agile Methodology
• Clearly communicated and documented test results and defect resolutions during all phases of testing.
• Stimulated several production cycles. Worked with data validations, constraints, record counts, and source to target, row counts, random sampling and error processing.
• Involved in testing of Universes from different data sources like Oracle/SQL Server.
• Performed Black-box testing, White-box testing, System Testing, Data Integrity Testing and end to end testing
• 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.
• Prepared Test Cases for the mappings developed through the ETL Informatica tool
• Executed backend data-driven test efforts with a focus on data transformations between various systems and a data warehouse.
• Executed Informatica Workflows from UNIX using the shell scripts.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Used TOAD SQL Navigator GUI tools for Querying Database.
• Performed functional test and load test on SQL queries, store procedures and forms.
• Performed smoke, functional, integration, system, regression, retesting, performance and User Acceptance Testing.
• Involved in Unit testing and integration testing of Informatica mappings
• Analyze data using SQL, Excel, UNIX data testing tools. Review SQL code.
• Written SQL Queries to define, Identify and validate the code written for the data movement into the database tables.
• Testing of Business Objects and Reports which Includes, Database Connectivity, Tested objects in the Universe to ensure the correct mapping of the objects, tested the Universe s Structure to ensure that tables are properly uploaded, tested the aggregate Universe to ensure the query is pulling correct level of Aggregation.
• Test Business Objects reports for data validations and compare results with TOAD.
• Ran various Batch jobs using telnet service Unix
• Used Quality Center for Bug Reports and Defect Tracking.
• Report product bugs, bug isolation, verify fixed bugs and issue resolution.
• Tested ad hoc and canned reports for Business objects.
• Tested reports using Business Objects functionality like Queries, Slice and Dice, Drill down, Functions, Formulae etc
• worked closely with the Project Manager, Technical Lead and a range of client interfaces on-site on a daily basis
• Worked closely with offshore team and allocated and jobs for completion
• Managed Test cycle reporting status meetings / coordination.
• Developed user documentation for all the application modules.

Environment: Mercury Quality Center 8.0, Informatica PowerCenter 7.1, ERWin 4, Business Objects XIR2, DB2, TOAD, Unix, Windows 2003 Server, SQL Server, Autosys Scheduling Tool, MS Visio 2003, XSLT, XML Spy 2008, SQL, PL/SQL, WinSQL, PERL, Agile ,Shell Scripting

Confidential

ETL QA Tester

Responsibilities:

• Designed Created Test Cases based on the Business Requirements, Source to Target mapping Transformation rules document.
• Implemented SDLC, QA methodologies and concepts in the Project
• Involved in Developing Test Plans and Developed Test Cases/Test Strategy with input from the assigned Business Analysts
• Developed separate test cases for ETL process Inbound Outbound and reporting
• Developed Test Plan and Test Cases for the entire module of Data mart.
• Developed and Performed execution of Test Scripts manually to verify the expected results
• Extensively tested ETL processes using Data Stage ETL tool.
• Conducted Black Box Functional, Regression and Data Driven and Integration Testing.
• Defects tracking, review, analyze and compare results using Quality Center.
• Identify and assess potential risks associated to testing scope, quality of the product and schedule
• Created and executed test cases for Data Stage jobs to upload master data to repository.
• Conducted test case review and revision of surrogate key generation in Data Stage to uniquely identify master data elements for newly inserted data.
• Tested the ETL process for both before data validations and after data validations process.
• Tested the messages published by ETL tool and data loaded into various databases
• Involved in developing UNIX Shell wrappers to run various SQL Scripts.
• Used TOAD Software for Querying ORACLE and Used WinSQL for Querying DB2.
• Reconciled test results from different tests and different groups. Assessed readiness and deviation of product/project performance based upon test results and product specifications.
• Written several Korn Shell Scripts for performing various tasks like error loggin, archiving, cleanup move and add new data.
• Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.
• Tested summary reports, ad-hoc reports and on demand reports using Cognos Report Studio.
• Extensively tested several Cognos reports for data quality, fonts, headers and cosmetic
• Tested the list, cross tab, repeater and Drill-through reports in different formats like PDF, XML and HTML.

Environment: Windows XP, Data Stage 7.5, DB2, QTP 9.2, SQL Server 2000, Quality Center 9.0, Oracle 9i, TOAD, SQL, PL/SQL, Java, Unix AIX 5.2,VB Script, Cognos 8, XML, XSLT, XSD, UNIX, Shell Scripting