Summary: 7 years of IT industry experience in testing Data Warehousing and ETL BI applications Experienced in the complete life cycle of project development: System Analysis, Design, Development, Testing, Deployment and End User Training. Good experience in analyzing Business Requirements, Test Planning, Developing QA project plans, test plans, test scripts and testing procedures for business intelligence applications. Extensively used ETL methodology for testing and supporting data extraction, transformations and loading process, in a corporate-wide-ETL Solution using Informatica, Ab Initio, DataStage and SSIS Proficient experience in different Databases like Oracle, SQL Server, DB2, Sybase and Teradata. Strong experience in System Testing, Regression Testing, Functionality Testing and Performance Testing of Web based Client/Server and Data Warehousing applications in Windows Environments. Proficient in Backend Testing and Data Integrity Testing using SQL and PL/SQL. Extensively used Test Director/Quality Center for requirements tracking, defect tracking, results and status reporting. Well versed with the data modeling to understand the logical and physical relation between facts and dimension. Experienced in providing the knowledge transfer to the fellow team member based on lesson learnt after completion of each project. Good analytical communication skills and ability to work independently with minimal supervision and also perform as part of a team. Skills Matrix: Testing Tools Quality Center 10, IBM Rational Clear Quest/Clear Case Soap UI QTP 9.2 Programming Languages XML, VB, PL/SQL, SQL, Shell Scripting, PERL RDBMS/Database Oracle 11g/10g/9i Teradata V2R6, 12.0 DB2 9.0 SQL Server 2008 Sybase 12.5 ETL/DW Tools Informatica 9.0, IBM DataStage, Ab Initio 2.15 Business Objects XIR4, Microstrategy 8.0 TOAD, SQL Developer, WinSQL Data Modeling Erwin 7.0, ER Studio Methodologies SDLC, Method 1, SOX Server Ftp, IBM AIX, SUN SOLARIS, HP UNIX, REDHAT LINUX Project Management MPP, MS office, Visio

Professional Experience: Confidential Sr. ETL QA Analyst EDI Transactions- HIPPA Standards 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. Reported defects and status of the defects in HP QC. Validated the data transformations developed by DB2 stored procedures and Informatica. Developed complex SQL queries to verify the data loaded into the target tables. Validate the test data using MS access, TOAD, UNIX MS Excel 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. Communicate QA progress, of test cases executed per day to the supervising authority Conduct walk through meetings with various teams in understanding the QA processes, bug life cycles, QA documentation Performed database integrity check using SQL and Unix Shell Scripts Performed Functional, Regression, Data Integrity, System, Compatibility, and User Acceptance Testing including GUI testing Experience in data analysis and data testing. And verified fields present in the reports are as agreed in the ETL specifications Involved in backend testing with SQL, check the data integrity and referential integrity. Gather feedback from the manager to incorporate changes as required for the QA process documentation Written several complex SQL queries to validate the Business Objects XIR3 reports. Worked with multiple outsourcing companies and efficiently worked as a liaison b/n the client and multiple outsourcing companies. 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 Perform automated QA reports using Quality Center and Start Team dashboards Conduct pre release meetings and documentation approvals Train users and help in conducting UAT Environment: Oracle 11g, SQL, PL/SQL, Informatica-8.5, XML Spy 2011, UNIX, TOAD, XML Files, VSAM Files, XSD,DTD, HP Quality Center 10, Shell Scripting, Business Objects XIR3 Confidential Sr. ETL/SQL Test Analyst Responsibilities: Actively involved in Agile testing process for Web-Methods System. Analyze the Business requirements and ensured the testability of the same. Responsible for preparing Resource Sizing and estimation for the testing efforts. Responsible for preparing Testing timelines and resource utilization for various QA components. Coordinating off-shore and On-shore Test resources. Written complex SQL queries for data completeness, data quality data transformation. Managed multiple data feeds coming from different source systems. Developed Test Plan and review the test cases and test scripts prepared by the team for the QA Phase of the Global Data Warehouse. Co-ordinate the Unit, Integration, Regression, Load and UAT Test phases Testing the POS systems on a daily basis for any possible menu changes. Report defects and status of the defects in Mercury Quality center. Analyze the ETL mappings and generate test scenarios. Involved as part of the team to developed and review the complex SQL queries for all the ETL test components involved. Validate the PL/SQL Procedures and ensure the data quality. Developed XML test data for web services testing and mimicked the same using XML spy. Tracking the entire testing process via Quality Center and reporting the progress on a daily, weekly and monthly basis to the project manager. Trained developers and testing team members on Quality Center. Conducted defect analysis, Testing progress and Risk mitigation meetings as required with the Business sponsors, Business Analyst, Project Manager. Analyze and present the Load test results to Technical Lead and Project Manager. Involved in the development of a standardized ETL testing framework for the Burger King Corporation Data Warehousing QA practices. Environment: SQL, PL/SQL, Oracle 10g, Web Methods 7.1, Informatica 8.1, BO XI, Oracle SQL Developer, SOAP UI, Teradata V2R6, Teradata SQL Assistant 6.0 Confidential ETL/BI Test Analyst- Claims DataMart Enterprise Datawarehouse Responsibilities: Review the functional requirements and ensure the testability 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 Wrote SQL and PL/SQL scripts to perform database testing and to verify data integrity. Validate the data being transformed via ETL Informatica 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, Informatica 7.1, Microstrategy, UNIX, TOAD, Quality Center 9.0, WinSQL Confidential QA Analyst SQL Test Analyst- Claims Data Processing Datawarehouse Responsibilities: Worked with the Subject Matter Experts to ensure that requirements were correct and complete. Responsible for identifying business scenarios / test cases to be used during the end to end test phase. Performed Unit, Integration, End-to-End, Regression and UAT tests phases. Executed integration/End to end testing for the entire process. Verification and validation of the data and mappings during various stages. Performed testing to check the performance of the server, network, and graphs and documented the key performance issues to be resolved. Written complex SQL queries to validate the data conditions based on ETL data mapping document. Conducted JAD sessions and developed a standard Data warehouse testing procedure for Accenture and American Express BI/DW Department Developed reports on test progress, of test cases execution/day/week/month, defect reports/ day/week/month both manually Excel and using test tracking tools Star Team, Quality Center 9.0 Performed cost and budget analysis of QA resources using Microsoft Excel and MPP Coordinating off-shore and On-shore Test resources on a 24/7 work model and assisted clients in the resource hiring process for QA as required Develop and present power point presentations in walking the tech, business and sponsors to understand the QA test plans, progress reports, risks, build release requirements, test prioritization, resource allocation, team training needs and defect life cycles. Conduct walk through meetings with various teams in understanding the QA processes, bug life cycles, QA documentation Gather feedback from the manager to incorporate changes as required for the QA process documentation Worked with multiple outsourcing companies and efficiently worked as a liaison b/n the client and multiple outsourcing companies. 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 Perform automated QA reports using Quality Center and Start Team dashboards Train users and help in conducting UAT Environment: Oracle 8i 9i, Informatica 6.2, UNIX, TOAD, Quality Center 8.0, XSD, XML, Shell Scripting