SUMMARY:

• 7+ years of experience in Software Quality Assurance with expertise inData warehousing, database testing and data analysisinFinancial, Healthcare, Retail, Telecom domains.
• Strong understanding of Information Technology, process to develop web based & Client based (Internet & Intranet) applications.
• Expert in using the RUP, Agile/Scrum and Waterfall testing lifecycle Methodologies
• Expertise in both manual and automation testing of Web services/ SOA/Soap UI
• Experienced in developing, Reviewing, and Executing Test Strategy, Test Plans, Test Scenarios, and Test Cases/Script
• Experience in manual testing process and in creating automation environment using Quick Test Pro (QTP), Test Director, and Quality Center/ALM11.0.
• Tested Shell scripts and cron jobs to refresh the load on weekly basis.
• Expertise in test strategy design based on the various types of testing including unit, integration, function, system, usability (UI), End to End, security, load, stress, capacity and performance testing.
• Worked on SCDI,II and III datadimensions
• Experience in testing of Data Warehouse/ETL Applications developed in Informatica, Ab initio using SQL Server, Oracle, Netezza, DB2, and UNIX. Ability to evaluate ETL/BI specifications and processes.
• Excellent in performing with in manual testing with the focus on Black Box testing, White Box testing smoke testing, system integration, regression, Batch Testing, GUI Testing, acceptance and usability testing of web applications.
• Experience in testing HIPAA EDI Transactions
• Experience on 837/997, 835, 270/271, 276/277 EDI Transactions.
• Have tested several complex reports generated by Microstrategy,including dashboards and summary reports
• Experienced with ETL tools like Informatica, Abinitio, and Data stage
• Extensively performed automated testing for SOAP/WSDL/XML web services for the different portfolio event alterations by QTP.
• Adept in Web service testing using SoapUI.
• Extensive experience is using ComplexSQL queriesusing techniques like Sub queries, Correlated Sub queries and Stored Procedures for speedy and effective data analysis.
• Expertise in working with different type of files(eg: Flat files, VSAM,ebcdic, XML, CSV )
• Expertise in creating the test suite to perform regression testing across various releases and builds.
• Maintain the test environments (e.g., data loads, database backups, restarting the servers, requesting deployments, troubleshooting issues).
• Good understanding of Relational Database Design, Data Warehouse/OLAP concepts and methodologies
• Extensively used HP ALM to track defectsand to upload Test Plans and test cases
• Involved in meetings with Customers and educate them about the data, that’s being loaded into the data ware house.
• Interact with clients for Quality discussions and responsible for the QA deliverables.
• Expertise in Microsoft office (Word, Excel, Power Point, Outlook, Project, Project, & Visio)
• Proficient in using SQL Queries using TOAD & SQL Plus to ensure data consistency of front - end and raw feed by developing and executed complex SQL queries for data base.
• Strong experience in testing ETL applications and BI reports.
• Strong testing experience in UNIX platform.
• Expert in reviewing/reporting, tracking, & maintaining Defects with high level of detail, accuracy and informative recreation steps using Quality Center, Clear QUEST, Bugzilla, and Email (outlook)
• Ability to learn and adapt to new tools and technologies very quickly

TECHNICAL SKILLS

Languages: SQL, PL/SQL

RDBMS: Oracle 11g/10g/9i/8i, DB2 (Mainframes),Netezza, Teradata V2R5/V2R6, Sybase, MS SQL Server 2003/2005/2008

Operating Systems: Microsoft Windows 98/XP, Linux, UNIX

RDMS Query Tools: TOAD, SQL Assistant, SQL Navigator, and SQL * Plus, Rapid SQL, SQL Queries

Testing Tools: QTP, Selenium, WinRunner

Test Management Tools: HP Quality Center

Version Control Tools: Rational Clear Case

Defect Tracking Tools: Rational Clear Quest, HP Quality Center

Scheduling Tools: Autosys, Control-M

Reporting Tools: Crystal Reports, Cognos, BO, SSRS, OBIEE, MicroStrategy

ETL Tools: Ab Initio GDE>Co-op 3.x/2.x, Informatica Power Center, Data Stage.

Other Tools: PuTTY, Textpad, Compare It, WinSC

PROFESSIONAL EXPERIENCE:

Confidential,East Providence, RI

Sr. ETL QA Tester

Responsibilities:

• Review the Business requirements and ensure the testability of these requirements.
• Developed QA project plan, Test Plan, Test cases for the QA Phase of the Global Data Warehouse.
• Responsible for coordinating off-shore and On-shore Test resources
• Extensively followed AGILE methodology to achieve the desired results
• Reported defects and status of the defects in HPQuality Center.
• Extensively usedQuality Centerfortest planningandUsed Rational Clear Questfor bug tracking and reporting.
• Involved in Back End Testing using UNIX Utilities and automated Regression Testing using Shell Scripting.
• Customized the QTP Test as per the Test Case by using the VB-Script.
• Perform Data Integration, Data comparison and Data Validation for Back End Testing by using SQL Queries (TOAD).
• Validated the data transformations developed by DB2 stored procedures and Informatica.
• Created reports utilizing vlookup of both internal excel worksheet and external data.
• Developed complex SQL queries to verify the data loaded into the target tables.
• Performed Count Validation, Dimensional Analysis, Statistical Analysis and Data Quality Validation in Data Migration.
• Tested data conversion and data migration scripts for ETL process
• Validate the test data using MS access, TOAD, UNIX & MS Excel.
• Developed SQL queries to test the data after executing transactions like deposit processing and check processing in batches.
• Connect to telnet to the UNIX environment and download, transport test data files
• Coordinated and participated in generating the test data required for various test activities.
• Generate QA progress reports on a daily, weekly and monthly basis.
• Communicated risks and escalated issues to supervising Manager as required.
• Conduct walk through meetings with various teams in understanding the QA processes, bug life cycles, QA documentation
• Manage the testing process, schedule batch tests, log and track defects using Quality Center.
• Performed database integrity check using SQL and Unix Shell Scripts
• Performed Functional, Regression, Data Integrity, System, Compatibility, and User Acceptance Testing including GUI testing.
• Participated inData Validation processin QAT by developing spreadsheets with data from the reports in QA.
• Involved in backend testing with SQL, check the data integrity and referential integrity.
• Gather feedback from the manager to in corporate changes as required for the QA process documentation
• Written several complex SQL queries to validate the Microstrategyreports.
• Worked with multiple outsourcing companies and efficiently worked as a liaison b/n the client and multiple outsourcing companies.
• Tested ESB Web Service using Soap UI. Sent service request and checked for success response.
• Validated Request and Response data using SOAPUI.
• Work with teammates to resolve inter and intra teammate issues without affecting the project timelines
• Escalate database downtimes and any issues that could potential create hindrance to testing progress
• Tested theDashboard reports usingMicrostrategy.
• Extensively tested several MicroStrategy Reports for data quality, fonts, headers, footers, and cosmetics.
• Conduct pre release meetings and documentation approvals

Environment: Oracle 11g, SQL, PL/SQL, Informatica- 9.1, Microstrategy 9.X,XML Spy 2011, UNIX, TOAD, XML Files, XSD,DTD, HP Quality Center 10, Shell Scripting, VB scripts,SOAP UI

Confidential, Madison, WI

ETL QA/ DWH BI Tester

Responsibilities:

• Worked with Business analysts to understand Business/System requirements in order to transform business requirements into functional test cases.
• Responsible for reviewing Functional specs, user documentation and use cases and developing Testplans/ manual test cases out of it.
• Responsible for planning and directing Quality Assurance and Software change control policies.
• Study and analysis of the mapping document indicating the source tables, columns, data types, transformations required, business rules to be applied, target tables, columns and data types
• Coordinated in setting up Test Environments and Test Plan needs with team members.
• Developing various Test Scripts, Test Execution using Quality Center based on the Functional Specifications.
• Developed Ab Initio graphs to manipulate the logs and load the data into the Oracle databases.
• Generated reports using OBIEE.
• Executed Test Cases using positive and negative data in Quality Center’s Test Lab and reported results and defects using Quality Center’s Defects tool.
• Created ETL test data for all ETL mapping rules to test the functionality of the Ab Initio graphs
• Involved in validating the Data mart tables as per the business logic applied to the staging tables.
• Executed the test scripts against Teradata source and validated the rules according to mapping documentation.
• Extensively worked on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes.
• Implemented Scheduled jobs in UNIX Environment and EDW scheduler.
• Used Rational Clear Quest as defect tracking tools.
• Used Quick Test Professional (QTP) for regression testing and running the automation suite.
• Enhanced the scripts in QTP by applying checkpoints, parameterizations, synchronization point, data driven tests and creating modular tests
• Developed SQL queries for Back-end testing/Database testing and participated in end to end testing.
• Validated the source system data with the staging data using SQL and Pl/SQL scripts.
• Tested various Dashboards and Scorecards In Microstrategy
• Tested various Ad-Hoc reports and canned reports for the users using Microstrategy
• Tested several new controls for Dash boards like time series slider, radio buttons, and drop down menus for the flash version of the dashboards in Microstrategy9.0
• Reached Testing Goals by doing Data Completeness, Data transformation, Data Quality, Performance and Scalability
• Involved in Unit Testing the Ab Initio graphs and quality assurance and bug fixing
• Expertise with System Testing, Functional Testing, Regression Testing.
• Prepared Traceability Matrix with requirements versus test cases.
• Tested several UNIX shell scripting for File validation and also PL/SQL programming
• Involved in identifying the defects and developed Defect Tracking report using Mercury Quality Centre, which involved Bug life cycle.
• Provided daily and weekly status reports.

Environment: Quality Center 9.0, OBIEE 10g, Ab Initio GDE>C0-op 2.13, Erwin, Ms Excel, Oracle 10g/9i, SQL, PL/SQL, Teradata utilities, Teradata SQL Assistant, TOAD 8.0, Autosys Scheduler, UNIX, Windows 2000, Microstrategy9x

Confidential, Seattle WA.

Senior ETL DWH/BI tester

Responsibilities:

• Review and understand the ETL processes, functionality & identify test requirements and coverage
• Involved in creating Testplans/test cases based on BRDs and FSDs,we got from Business and Development teams
• Reviewing Test cases and scripts based on client requirements in HP Quality Center
• Reporting and tracking the defects in Quality Center
• Tested various reports developed in Business Objects
• Wrote very complex SQL to validate several BI Reports.
• Involved in testing data migration.
• Responsible for testing packages using Informatica (ETL) to verify data.
• Connected to telnet to the AIX environment and download, transport test Flat files.
• Share the results with Stakeholders and data assessment core team.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Suggestions to fix the anomalies during conversion stage or DB Validation
• Developed Test Plans, Test Cases, and Test Scripts for SIT.
• Did data validations using Autosysby Batch, dependency Testing, Error Handling and Job Restart Testing
• Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
• Created Test Cases and developed Tractability Matrix and Test Coverage reports.
• Extracted Data using SSIS from DB2, XML, Oracle and flat files, Excel perform transformations and populate the data warehouse
• Managed and conducted System testing, Integration testing and Functional testing.
• Written complex SQL queries for data validation for verifying the ETL Mapping Rules.
• Extensively used Teradata and Putty for the entire project.
• Worked on SQL scripts to load data in the tables in Test environment.
• Used the Informatica monitor to schedule the jobs, validating and debugging its components, and monitoring the resulting executable versions.
• Running of ETL jobs in Informatica and test data setup, Quality check for test data.-Transformation logic verification, RCA for defect found.
• Imported existing test cases from Excel sheet to QC (Quality Center)& completed the configuration of QC and QTP in order to execute Functional and regression test cases.
• Written VB scripting for performing Regression using QTP
• Used SQL tools like TOAD to run SQL queries and validate the data loaded into the target tables
• Involved in testing web services, and validated the XML responses using SOAP UI
• Validated requests and responses through java using SOAP UI
• Worked with Data Warehousing developers who extensively used Informatica, 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 the transforming logic
• Prepared status summary reports with details of executed, passed and failed test cases
• Interacted with developers, Business & Management Teams and End Users.
• Reviewing Functional Specification Document and preparing traceability matrix with the test case mapped.
• Sending status report and reviewing the progress with client on a daily basis and involved in preparing Test results as a QA signoff

Environment: Informatica 9.1, HP Quality center10.0/ALM11.0,QTP 9.2, Oracle 9i/10g, SQL/PLSQL,Teradata V2R6,QTP,VB Script, UNIX, Business Objects, Rational Clear Case, DB2 8.x, IBM AIX 5.5, MVS, ISPF, VSAM Files, Flat Files, XML Files, Shell Scripting, PERL, XML, XSD, TOAD, WinSQL, SOAP UI

Confidential, Chicago, IL

DWH Tester

Responsibilities:

• Tested all phases of ETL testing including Extraction, Transformation and Loading.
• Tested various Drill down reports and Alerts. Business Intelligence reports using Web Intelligence module.
• Worked with ETL group for understating mappings for dimensions and facts.
• 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.
• Used and altered UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Scripts have been written for both Batch mode which will write results to the individual called test and Interactive (non-batch) mode which will write to the main test
• Used DataStage stages namely Hash file, Sequential file, Transformer, Aggregate, Sort, Datasets, Join, Lookup, Change Capture, Funnel, Peek, Row Generator stages in accomplishing the testing
• Managed data utilizing Excel, pivot tables, vlookup, conditional formatting and graphs
• Created automated functional regression test scripts using QTP and scheduled, organized and executed the test scripts in QC-QTP integrate environment and documented the test results.
• Tested test scenarios that were used to validate the ETL movement
• Written complex SQL queries for validating the transformation rules for ETL mappings.
• Tested Korn Shell scripts and cron jobs to refresh the load on weekly basis.
• Tested ad hoc and canned reports for Business objects.
• Tested reports for various portfolios using universe as the main data provider.
• Tested reports using Business Objects functionality like Queries, Slice and Dice, Drill down, @Functions, Formulae etc.
• Tested graphical representation of reports such as Bar charts, Pie charts as per End user requirements.
• Tested Desktop Intelligence and Web Intelligence reports.

Environment: Oracle 9i/10g, SQL, PL/SQL, Datastage,Stored Procedures, XML, XSD, Unix Shell Scripting, Teradata V2R5, SQL Assistant 6.0, QTP9.2, Business Objects 6.5.

Confidential, Kansas City, MO

ETL QA Tester

Responsibilities:

• Review the functional requirements and ensure the testability, SOX compliance for the same
• Developed the test strategy for ensuring QA of Pinnacle points advance reporting
• Review the mapping documents and develop test cases and test scripts accordingly
• Ran SQL queries to verify the number of records from Source to Target and validated the referential integrity, Time variance, Missing records, and Nulls/Defaults/Trim spaces rules as per the design specifications.
• Written complex SQL queries for several business scenarios to validate the data across source and target system
• Validate the data being transformed via (ETL) Ab Initio
• Run tests by using Selenium remote control in different browsers.
• Created Automation test framework using Selenium.
• Developed SQL queries to verify the data loaded into the target tables.
• Work as part of the team in execution and defect life cycle process
• Develop QA progress reporst, bug reports, analyze risks on a daily, weekly and monthly basis
• Responsible for coordinating off-shore and On-shore Test resources.
• Performed Unit, Integration, and Regression and UAT Test phases.
• Tracked QA process, reported defects and status of the defects in Mercury Quality center.

Environment: DB2 V8.2, SQL, PL/SQL, XML, XSLT, XML Spy, Ab Initio (Co>Op 2.14, GDE 1.14), Microstrategy, UNIX, TOAD, Quality Center, WinSQL