SUMMARY:

• Sree has experience in Quality Assurance including ETL, Manual and Automation testing.
• Good Knowledge in Requirement analysis, Business analysis, Use - case analysis, Change management and Configuration management.
• Extensive experience in testing various Domains like Mortgage, Finance and Health Care on Windows and UNIX Environments.
• Experience of full Software Development Life Cycle - SDLC (Agile/Scrum and Waterfall) Methodologies & Validations to ensure the Quality Assurance Control.
• Extensively worked in all phases of testing includes Integration, System, Regression, Load, Stress and User Acceptance Testing (UAT), Mainframe Testing.
• Extensively worked in System, Functional, End-End, Integration, and Data Driven Testing.
• QA Black Box, White Box Testing, Understanding of JAVA test tool, JTEST and test framework JUNIT and JAVA knowledge and concepts, Full System and QA Lifecycle, all phases and deliverables.
• Extensive experience in testing various Domains like Finance and Insurance domains on Windows and UNIX Environments.
• Expertise in Manual and Automation Testing. And also in UNIX commands and Shell Scripting.
• Good Experience in using SQL, PL/SQL, UNIX Shell Scripting, TSL and VB Script.
• Performed Quality Assurance testing on Client/Server and WEB Based applications.
• Good experience with Automation Testing Tools using Quick Test Professional (QTP), Win Runner and Load Runner.
• Created new, and modify existing SQL queries for use in the data integrity testing of the Data Warehouse application's ETL process
• Experience in writing Complex SQL Queries to validate data integrity of backend data.
• Strong skills in Object Oriented programming, Client/Server environment, web technologies and Relational Databases. Deep knowledge in the Analysis of Bug Severity, Bug Tracking system and Bug Reporting using Mercury Test Director
• Extensive knowledge in ETL testing, Manual Testing and Test Automation using Tools like Ab Initio, Informatica, HP UFT, QTP, HP Application Life Cycle (ALM), HP Quality Center.
• Worked as a DATA CENTIRIC TESTER in Financial and Banking Domain.
• Experience in testing Web-based, Client-Server and Data Warehouse applications on different environments.
• Testing of Database applications developed with ORACLE, Microsoft SQL Server, IBM DB2 and Microsoft Access.
• Experience in Data Warehouse applications testing using Informatica, SSIS, SSRS, SSAS, SSMS Shell Scripting, PL/SQL, Informatica, Data Stage and Ab Initio on multiple platforms.
• Develop the frame work for the Data masking using Ab Initio.
• Experience in creating ETL test data for all ETL mapping rules to test the functionality of the Ab Initio and Informatica graphs.
• Strong knowledge of Metadata and Star Schema/Snowflake Schema.
• Tested Informatica ETL Data Validation. Worked on Data Comparison and Data Integration Testing.
• Expertise in querying and testing RDBMS such as Oracle, MS SQL Server using SQL, PL/SQL for data integrity.
• Strong skills in Object Oriented programming, Client/Server environment, web technologies and Relational Databases. Deep knowledge in the Analysis of Bug Severity, Bug Tracking system and Bug Reporting using Mercury Test Director
• Experience in Automation Test Scripts using Keyword Driven Framework in QTP.

TECHNICAL SKILLS:

Testing Tools: Quick Test Pro 11.0, Load Runner, SOAPUI, Quality Center, Test Director, TOAD and SQL Developer, JMeter

ETL Tools: Ab Initio, Informatica Power Center

Operating Systems: Windows 95/98/2000/XP/NT, Unix/Linux

Reporting Tools: Cognos, Crystal Reports and Business Objects.

Virtualization: VMware Server, Oracle Virtual Box

Defect Tracking Tool: HP UFT, HP ALM, HP Quality Center HP Quality Center 9.0/9.2/10.0, ClearQuest 7.1.2, Bugzilla. Rational Clear Quest, JIRA

Languages: C, C++, Java, J2EE, VB.Net, ASP.Net, SQL, PL/SQL, Visual Basic 6.0, ASP

Database Tools: TOAD for Oracle 10.6, TOAD for Data Analyst 2.7 and DB-Visualizer 7.1

RDBMS: Oracle 11g/10g/9i/8i, MS SQL Server, 2003,2005,2008,DB2, MS-Access

Scripting: Java Script, VB Script, Unix Shell Scripting, HTML and XML

Tools: /Packages Visual Source Safe, MS Office

Application Server: Apache Server, Web Sphere V5.0/V6.0.x

Web Technologies: HTML,DHTML and Java Script

Front End Tools: Visual Basic, MS Front Page, Java, J2EE.

PROFESSIONAL EXPERIENCE:

Confidential, Florida

ETL QA Tester

Responsibilities:

• Strong knowledge of Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC) and QA Methodologies like Agile - Scrum, Waterfall.
• Involved in preparing the Test Plans, Test Strategy documents, Test Cases & Test Scripts based on business requirements, rules, data mapping requirements and system specifications.
• Experience on Functional testing, System Testing, Regression Testing, Integration testing, GUI Testing, Security testing, Smoke testing, System Integration Testing (SIT ), Software Validation testing, UAT, Interface testing, and Performance Testing.
• Involved in preparation of Requirement Traceability Matrix (RTM), Defect Report, and Weekly Status Reports, Test Readiness Review Documents, Test Summary Reports.
• Experienced in Data Modeling for Data Warehouse projects and designing business logic. Extensive knowledge of Implementation of full Lifecycle in Data Warehousing Project.
• Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators.
• Good understanding of FACT and Dimension tables. Very strong in SQL and PL/SQL, extensive hands on experience in creation of database tables, triggers, sequences, functions, procedures, packages, and SQL performance-tuning.
• Working Experience in Autopsy's. Strong experience in using Informatica mapping variables/parameters and session variables good in writing DOS commands.
• Have Good understanding of ETL/Informatica standards and best practices, Slowly Changing Dimensions (SCD1, SCD2, and SCD3).
• Experience in testing coordination, writing test cases and executing test scripts and logged defects in Quality Center (QC).
• Build a customer data centric data warehouse to analyze transactions across finance, marketing, risk collections and consumer relations for the credit card division. Clean customer data warehouse successfully implemented on Oracle target, the data warehouse is growing in its analytical richness.
• Tested several data migration application for security, data protection and data corruption during transfer
• Tested various Mappings using Aggregator, Joiners, Lookups, Filters, Router and Update strategy
• Unit testing performed on Mappings.
• Tested the ETL process for both before data validation and after data validation process.
• Tested with Front-end functionality for the entire application
• Involved in validating both functional and automated business processes using HP Quality center.
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance.

Confidential, Buffalo, NY

ETL QA Tester

Responsibilities:

• Data quality checking and interacting with the business analysts.
• Good experience in communicating with offshore team.
• Communication with the client for weekly status report
• Created test data that includes all scenarios and created several scenarios to test the referential integrity between tables.
• Prepared Test Plan and Testing Strategy for the project.
• Wrote SQL and PL/SQL scripts to perform database testing and to verify data integrity.
• Tested different detail, summary reports and on demand reports developed by Report Studio.
• Designed and developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL Test loads.
• Written several shell scripts using UNIX Korn shell for file transfers and cleanup process.
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance.
• Used Apache Axis utility to generate client for Web Services, executed Web Services using Eclipse Java IDE and SOAP UI.
• Executed SQL statements for data validation to check data integrity, error handling, data redundancy, and data consistency.
• Conducted review sessions on test case and regression test scripts in quality center.
• Promoted Unix/Data Stage application releases from development to QA and to UAT environments
• Written complex SQL statements for data reconciliation including comparing record counts between source data, data loaded to the warehouse and rejected records.
• Worked as a consultant in delivering quality data centric solutions for various business domains.
• Involved in SOAP and Restful web services using SOAP UI, axis client.
• Reported bugs and tracked defects using Quality Center
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Supporting presales activity for Data centric warehouse testing projects.
• Involved in Web Services Testing using SOAP UI.
• Involved in data warehouse testing by checking ETL procedures/graphs.
• Performed the tests in both the SIT, QA and contingency/backup environments
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing
• Tested the messages published by data stage and data loaded into various databases
• Strong ability in developing advanced and complex SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted

Environment: Data stage, UNIX, Shell Scripting, T-SQL, SQL, PL/SQL, Quality Center 10.0, Oracle 10g,Java, Report Net, SQL Server 2008, XML Spy 2010, XSD, XML

Confidential, Florida

ETL QA Tester

Responsibilities:

• Involved in Relational modeling and Dimensional Modeling Techniques to design ER data models and Star Schema designs.
• Worked with Data Completeness, Data Transformation, Data Quality, Integration testing, Performance, Scalability and Regression Testing.
• Documented the validation rules, error handling and test strategy of the mapping.
• Tuned the complex SQL queries for better performance by eliminating various performance bottlenecks.
• 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.
• Compared the actual result with the expected results. Validated the data by reverse engineering methodology i.e. backward navigation from target to source.
• Created temporary tables for validations after understanding the transformation logic.
• Tested several UNIX shell scripting for File validation and also PL/SQL programming
• Tested complex mappings using mapplets and reusable transformations.
• Different Ab Initio components especially are used effectively to develop and maintain the database.
• Established and documented ETL QA standards, procedures and QA methodologies.
• Verify development of rule-set test scenarios, test cases, expected results and analysis of XML test scripts
• Extraction, Transaction and Loading was done using different Components and different expressions using Ab Initio to create test data.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Extensively tested several ETL Mappings developed using Informatica.
• Involved in testing data reports. Written several SQL queries for validating the front-end data with backend.
• Tested Ab Initio graphs and used Ab Initio as an ETL tool to load the final loads.
• Conducted back to back meetings with developers and discussed about all open issues.
• Conducted test case reviews to ensure scenarios accurately capture business functionality.
• Worked with ETL Source System and Target System (ETL Mapping Document) for writing test cases and test scripts.
• Written several SQL statements to confirm successful data transfers between source and target.
• Worked with data profiling, data scrubbing and data cleansing.
• Tested Standard Reports, Cross-tab Reports, Charts, Master-Child Drill through Reports and Multilingual Reports.

Environment: Informatica Power Center 6.1,Abintio, Quality Center, Windows NT, Micro Strategy, Oracle 8i, SQL Server, SQL, PL/SQL, SQL*Plus, Toad, VSAM Files, XML, XSD,SSRS,SSAS,VB.NET,ALM.

Confidential

ETL Tester

Responsibilities:

• Reviewed Business Requirements Documents and the Technical Specifications.
• Developed Test Cases, Test Scripts from the data mapping documents, functional specification documents and mapped the test cases with requirements for generating Requirement Traceability Matrix (RTM).
• Performed Functional, Integration, Regression and System (End-End), and Back-End Integration Testing with back end Oracle Database using SQL Queries.
• Modified and created SQL Queries and stored procedures for quality assurance and analysis.
• Analyzed application data using SQL to identify ETL processes.
• Worked with Data Analysts to implement Informatica Mappings and Workflows.
• Worked Extensively with SSIS to import, export and transform the data between Used T-SQL for Querying the SQL Server2000 database for data validation and data conditioning
• Extensively used Informatica Workflow Manager to run workflows.
• Monitored the session logs/log files in Informatica Workflow Monitor.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow variables and Session parameters to extract the additional data added during that period.
• Analyzed and tested ETL Informatica Mappings with source data, staging and target data.
• Automated and scheduled Informatica Jobs using AUTOSYS and UNIX Shell Scripting.
• Worked closely with the Developers and System Engineering Teams in the review and modification of the product and its specifications.
• Involved in generating Test plans and Test specifications.
• Involved in ETL process for a Data Warehouse from their legacy systems using Informatica Power Center.
• Extensively worked on ETL tool Informatica - Mapping Designer, Workflow Manager, and Workflow Monitor.
• Worked on QTP for Regression, Integration, and system Testing.
• Developed, Enhanced, and Maintained automated testing scripts with QTP.
• Used Parameterization for testing with a specific set of data.
• Enhanced scripts by adding checkpoints.
• Reported the Bugs using HP Quality Center and closely worked with developers to nail down the technical problems.

Environment: Quick Test Pro 11.0, HP Quality Center 11.0, Informatica, AUTOSYS, MS SQL Server 2005/2008.SSIS,SSRS,SSAS, ASP.Net, XML, TOAD, Java Script, Windows 7.