CAREER OBJECTIVE:

• A tester position where I can leverage my data management, QA testing, and quality analysis experience and skills to help deliver quality products to the business and ultimately to the firm’s clients. As such I possess:
• 7+ years of IT experience in Quality Assurance for ETL, Backend, Web based, Client/Server applications using Manual and Automated testing tools.
• Strong Understanding and experience in Software Testing Life Cycle.
• Expertise in building Test Strategies, Test Plans, Test Cases, Manual and Automated Scripts and creating and maintaining Traceability Matrices.
• Tested the reports like Drilldown, Drill Up and Pivot reports generated from OBIEE
• Extensive testing ETL experience using Informatica 8.1/7.1/6.2/5.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager), AutoSys, Control M and Maestro.
• Experienced working for Data Migration, Data Extraction, Data Cleansing, Data Profiling, Data Consolidation, Data Standardization and Data Quality for various business data feeds.
• Proficient in using testing tools such as Quality Center, Win Runner, Load Runner and Quick Test Professional for web - based and client server applications.
• Strong working experience on DSS (Decision Support Systems) applications, and Extraction, Transformation and Load (ETL) of data from Legacy systems using Ab Initio &Informatica
• Solid Back End Testing experience by writing and executing SQL Queries.
• Solid experience in ETL / Data warehouse testing and BI Report Testing.
• Exposure to multiple ETL tools including Data stage, Informatica, Ab Initio and SSIS.
• Experience in report testing using Cognos and Business Objects.
• Worked in Oracle, Teradata, SQL Server data warehouses and used many other databases as the source.
• Extensive experience in writing complex SQL, PL/SQL queries using joins, aggregation and various other transformations.
• Extensive experience in testing Business Intelligence (BI) reports using various reporting tools like Micro strategy (MSTR), Cognos Report Net and Business Objects
• Exposure to loaders like SQL*Loader, BTeQ, FastLoad and MultiLoad.
• Experience in UNIX and Linux. File parsing, file processing, comparing data sets from source to target environments and executing Shell Scripts.
• Extensive experience in functional validation of Star Schema, Snowflake Schema and 3rd normal form Logical data models.
• Expert hand on knowledge of SAS/BASE, SAS/MACRO, SAS/STAT, SAS/GRAPH, SAS/ACCESS.
• Proficient at performing data analysis and identifying patterns and root causes for data discrepancies
• Good understanding of data management, history maintenance and slowly changing dimensions
• Strong in communicating with Developers and Business Users for gathering and testing business scenarios, translating technical issues into business terms and discussing functional specifications and defects
• Excellent understanding of all phases of SDLC including project planning, scheduling, requirements gathering, risk analysis, development, build, testing and implementation.
• In depth knowledge of Agile and Waterfall development methodologies.
• Involved in Sprint Planning meetings, Requirement Review meetings, weekly Bug tracking meetings, Status meetings

TECHNICAL SKILLS:

OPERATING SYSTEMS: Windows, OS/2, Linux

LANGUAGES KNOWN: C, PL/SQL 8.x/2.x, SQL*Plus, SAS 9.1

REPORTING TOOLS: OBIEE, MicroStrategy, Business Objects 5.1, Cognos 8/7.0

SCRIPTING LANGUAGES: VB Script

DATABASES: IBM DB2, Oracle 11g/10g, Teradata 13, Sybase 12.3, SQL Server 2012, Netezza NPS 8050

WEB SERVERS: Java WebServer2.0, Netscape Enterprise Server, Web Logic

DATAMODELLING TOOLS: Erwin 3.5.1/4.x, Designer 2000

DATAWAREHOUSING: Informatica 9/ 8.6 (Power Center/ Power Mart),ETL, Data Mining, Data Mart, OLAP, OLTP, SQL*Loader, TOAD, Data Flux, Ab Initio, (GDE 1.14, Co>Op 2.14), EME, Data Profiler

PROFESSIONAL EXPERIENCE:

Confidential, Providence RI

SQL/QA Tester

Responsibilities:

• Analyzed the Requirements from the client and developed Test cases based on functional requirements, general requirements and system specifications.
• Prepared test data for positive and negative test scenarios for Functional Testing as documented in the test plan.
• Extensively tested several OBIEE reports for data quality
• Prepared Test Cases and Test Plans for the mappings developed through the ETL tool from the requirements.
• Experienced in working in Agile Scrum, Agile XP, Waterfall, RUP, RAD and SDLC methodology environments
• Developed Test Strategy, Test plan, Test cases, and Test scripts and various other project documentation in HP Quality Center
• Worked on executed SAS programs in UNIX.
• Tested the reports generated by OBIEE and verified and validated the reports using SQL.
• Execution flows and Loading data to Netezza Data mart through NZLOAD utility.
• Testing the ETL data movement from Oracle Data mart to Netezza Data mart on an Incremental and full load basis.
• Verified session logs to identify the errors occurred during the ETL execution.
• Created Test Cases, traceability matrix based on mapping document and requirements.
• Analyzed the requirements for the project from DOORS requirements/version control tool.
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices
• Verified the logs to identify the errors occurred during the ETL execution.
• Written several complex SQL queries for data verification and data quality checks.
• Reviewed the test cases written based on the Change Request document and Testing has been done based on Change Requests and Defect Requests.
• Tested the ETL Informatica mappings and other ETL Processes (DW Testing). 
• Effectively coordinated with the development team for closing a defect.
• Prepared Test Scenarios by creating Mock data based on the different test cases.
• Perform defect Tracking and reporting with strong emphasis on root-cause analysis to determine where and why defects are being introduced in the development process.
• Debugging and Scheduling ETL Jobs/Mappings and monitoring error logs.
• Have tested reconcile and incremental ETL loads for the project.
• Exclusively involved in execution of Autosys jobs, PL/SQL batch programs and responsible for reporting the defects to development team.
• Exclusively used test plan module to write and test lab module to execute the test cases in HP Quality Center/ALM.
• Exclusively used requirement module for requirement and defect module for entering the defects in HP Quality Center/ALM.
• Involved in testing the batch programs by using the Autosys tool.
• Compared SAS datasets using SAS PROC Compare
• Involved in backend testing for the front end of the application using SQL Queries in Teradata data base.
• Tested data migration to ensure that integrity of data was not compromised.
• Involved in validating SSIS and SSRS packages according to data mapping specifications.
• Wrote complex SQL queries for extracting data from multiple tables and multiple databases.
• Before the Load is accepted to test, have performed the smoke or shake-out test.
• Extensively used Oracle database to test the Data Validity and Integrity for Data Updates, Deletes & Inserts.
• Used rational Clear case and sharepoint as version control tools.
• Validated various transformations of SSIS data flow and control flow.
• Report testing: Extensive experience with Reporting Tools like OBIEE
• Involved in testing the Informatica mappings, by validating whether the mapping adhere to the development standards and naming conventions; whether the mapping do what the technical design says it should do.
• Developed UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. 
• Provided the management with weekly QA documents like test metrics, reports, and schedules. 

Environment: Oracle 11g, Informatica Power Center 9.1, SSIS,Agile, Clear Case, OBIEE, Clear Quest, SQL, PL/SQL, TOAD, UNIX, TFS, Putty, SharePoint, Flat files, Netezza, SAS/Stat, SAS/Graph, SAS/ODS, SAS/SQL, SAS/Connect, SAS/Access, SAS/ETL, XML files, DB2, HP Quality Center/ALM, Autosys, SQL Server 2008.

Confidential, Mount Laurel NJ

SQL/QA Tester

Responsibilities:

• Designed and Created test plan, test scenarios and test cases for Data warehouse and ETL testing.
• Responsible to translate business requirements into quality assurance test cases. 
• Review of test scenarios, test cases and Data warehouse Test Results. 
• Developed test scripts using SQL queries to validate data.
• Worked in Agile technology with Scrum and waterfall models
• Prepared Regression Test Plans, Requirements Traceability Metrics (RTM), positive and negative test scenarios, detailed oriented Test Scripts, Test Kickoff documents, Test Scorecard for test progress status, Test Results, Release Check list, Lessons Learned documents and Regression Test Suite for future use.
• Involved in the error checking and testing of the ETL procedures and programs Informatica session log.
• Responsible in testing Initial and daily loads of ETL jobs.
• Tested and Automated SAS jobs running on a daily, weekly and monthly basis using Unix Shell Scripting
• Performed front-end testing on OBIEE Executive Dashboard portal
• Tested Netezza database for data validation using NZ SQL.
• Interacted with design team to decide on the various dimensions and facts to test the application. 
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes.
• Involved in preparation of Requirement Traceability Metrics (RTM), Software Metrics, Defect Report, Weekly Status Reports and SQA Report. 
• Manually tested the applications and handled Test Cases through Test Management tool Quality Center/ALM.
• Analyzed Test Results and generated Defect Reporting and tracking via Quality Center/ALM 11. Consolidated and presented regular updates to project team management.
• Generated Test Execution and Defect Summary reports from Quality Center to the management and Product owners
• Interacted with Users to understand the bugs in Business Reports generated from OBIEE
• Planned ahead of time to test the mapping parameters and variables by discussing with BA’s. 
• Extensively used Rational ClearQuest to track defects and managed themExtensively involved in testing the ETL process of data sources, SAP, PeopleSoft, Teradata, SQL Server, Oracle, flat files into the target Teradata, Oracle database as per the data models.
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes.
• Tested all OBIEE Dashboards according to the requirement
• Executed automated test scripts using QTP for Regression testing.
• Created test cases and Scripts to test the Performance of the application using Load Runner.
• Reviewing the test activities through daily Agile Software development stand-up meetings.

Environment: HP Quality Center/ALM, Informatica 8.6.1/8.1, SSIS, OBIEE, Rational Clear Case, Rational Clear Quest, Teradata SQL Assistant, Teradata V2R6, Rational RequisitePro, SharePoint, Autosys, Rally, TOAD, QTP, Perl, Putty, Web logic, Oracle 11g/10g, QL Server 2005, Agile, SAS/Stat, SAS/Graph, SAS/ODS, SAS/SQL, SAS/Connect, SAS/Access, Netezza, XML,TIBCO, PL/SQL, Linux, Win XP 

Confidential, Nashville, TN

SQL/QA Tester

Responsibilities

• Involved in creating source target mappings based on the Technical Design requirements.
• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Assisted the users during UAT. Took part in Triage Meetings with the required parties after defect analysis to prioritize defect resolution
• Tested the reports like Drilldown, Drill Up and Pivot reports generated from OBIEE
• Tracked defects through Quality Center and Clear Quest.
• Develop ETL test plans based on test strategy. Created and executed test cases and test scripts based on test strategy and test plans based on ETL Mapping document.
• Tested design strategy of the Extract, Transform and Load for various ODW tables.
• Tested mappings with the Design Documents and also performed testing for various sample data.
• Created test suites for functional and regression testing.
• Worked with all Teradata load utilities.
• Defined data requirements and elements used in XML transactions
• Use Quality Center for all test phases as a repository , test management, test execution, and test reporting activities
• Was involved in user acceptance testing (UAT) cycle.
• Preparation of technical specifications and Source to Target mappings.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Experienced using query tools for Oracle to validate reports and troubleshoot data quality issues.
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
• Developed scripts, utilities, simulators, data sets and other programmatic test tools as required executing test plans.
• Responsible for testing packages using SSIS (ETL) to verify data completeness, data transformation, data quality, integration testing, UAT & regression testing
• Effectively communicate testing activities and findings in oral and written formats.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Worked with ETL group for understating mappings for dimensions and facts.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Tested all OBIEE Dashboards according to the requirement
• Authored and executed Test cases for Claims and Customer Service Workflow by manually
• Validated cube and query data from the reporting system back to the source system.
• Responsible for coordinating testing status and defects between Cost of Care Data Mart and EDW which were two different teams.
• Written several complex SQL queries for validating OBIEE Reports.
• Represented the Cost of Care Data Mart testing team in Agile Sprint meetings and shared the current status and issues.

Environment: Informatica, Teradata, OBIEE, Microsoft Visio, Microsoft Word, XML/XSL, QTP, Red Hat Enterprise Linux 5/4/3 , HP Quality Center 10, SSIS ,DB2, J2EE, Sql Server ,Agile, XML, HTML, XSD, Java Script, VBA, Toad 7, Windows XP.

Confidential, Plymouth Meeting PA

Database Tester

Responsibilities

• Participated in requirement gathering and Business analysis meetings.
• Worked in testing strategy preparation for the risk data mart enhancement project.
• Develop ETL test plans based on test strategy. Created and executed test cases and test scripts based on test strategy and test plans based on ETL Mapping document
• Involved in working on Test Plans, Test Schedules and RTM based on the Requirement documents.
• Actively participated in Test data analysis, identification and masking for SIT and UAT
• Involved in writing the Test cases and Test scripts based on Source to Target Mapping documents and Data Model diagrams.
• Written XSLT scripts for various XML needs and used XPath, XQuery for data retrieval from XML documents.
• Wrote SQL queries for each Test case and automated standard reusable test cases like audit control and balancing
• Tested Business Objects reports and Web Intelligence reports
• Strong usage of HP Quality center for centralized control over entire project.
• Executed Test Scripts in Teradata and Oracle SQL Plus to validate the data between Enterprise Data Warehouse (source for our data mart) and the Data Mart Staging Tables.
• Worked with ETL group for understating mappings for dimensions and facts
• Resolved data related issues during initial loads from different sources.
• Performed Smoke Test, SIT and Regression Testing for every enhancement.
• Developed Excel templates to verify results and performed extensive data analysis and reconciliation.
• Coordinated with the Developers regarding the Defects raised and Retested them.
• Supported UAT by providing users with SQL queries for business scenarios. Retested UAT defects in the SIT environment before handover to the users.
• Generated defect reports by various environments like UAT, SIT, and QA and shared with the stakeholders on a daily basis
• Responsible for coordinating testing status and defects between Risk Data Mart and EDW which were two different teams.
• Represented the Risk Data Mart testing team in Agile Sprint meetings and shared the current status and issues.

Environment: Informatica 8.6.1, Oracle 10g, MS SQL Server 2005, Windows, Mainframe, HP Quality Center 10.0, Rational Clear Quest, XML Files, XSD, XML Spy 2011, Agile, Business Objects XIR3