SUMMARY

• 8+ years of experience in Manual Testing and Automated Testing for web based, ecommerce client/server applications and Web service applications on several platforms, using SOAPUI and automation tools (Quick Test Professional, Loadrunner and Quality Center) on applications developed in Java, VB, C++ and Oracle.
• Solid experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
• Experience using query tools for Oracle, MS SQL, DB2 and Teradata server to validate reports and troubleshoot data quality issues..
• Experience in Telecom, Pharmaceutical, Financial Banking and Brokerage.
• Extensive testing ETL experience using Informatica 9, 8.6, 8.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager), DataStage, SSIS.
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing, in a corporate - wide-ETL Solution using Informatica
• Extensive experience in testing and implementing Extraction, Transformation and Loading of data from heterogenoues sources into Data warehouse using ETL Tools.
• Proficient in different Databases like Oracle, SQL Server, DB2 and Teradata.
• Experience in testing and writing SQL and PL/SQL statements.
• Expertise in utilizing Oracle utility tool like SQL*Loader and Toad for developing Oracle applications.
• Extensively involved in Data-centric testing to test the data completeness, data integrity, data validation, data quality of the data as it is extracted from source and loaded into target.
• Involved in application upgradation testing during which, data validation was performed to test if the data from the older application was same as the data loaded into DB through new application.
• Experienced in Source to Target Testing to validate the data before and after it passes through the transformation/mappings are exactly same and to test if the values before transformation and after are corosponding to the expected values.
• Production Validation Testingwas performed before the deployement of the developed application to the production systems to ensure that the data is being processsed efficently and to test the correctness of the data.
• Expertise on the usage of reporting tools such as IBM Cognos8, Business Objects.
• Experience in using Defect Management tools like Quality Center and HP ALM.
• Involved in application upgradation testing during which, data validation was performed to test if the data from the older application was same as the data loaded into DB through new application.
• Involved and implemented various phases of testings such as integration testing, system testing, regression testing, performance testing, operational testing of the mappings, jobs and sessions atat are involved in extraction, transformation, and loading of data from source to DWH.
• Extensively worked on Dimensional modeling, Data cleansing and Data Staging, Data integration of operational sources using ETL processes.
• Extensive Working experience in applying Relational Database concepts, Entity Relation diagrams and Normalization concepts.
• Experience in all phases of Software Development life cycle.
• Excellent communication skills, Good organizational and interpersonal skills, outgoing personality, Self-motivated, hardworking, ability to work independently or cooperatively in a team, eager to learn, ability to adapt based on the demands of work.

TECHNICAL SKILLS

ETL Tools: Informatica 9.0/8.6/8.1/7.1 (Power Mart/Power Center) (Designer, Workflow Manager, Workflow Monitor, Server Manager, Power Connect), SSIS, DataStage 8.X

Data Modeling: Erwin 4.0/3.5, MS Visio

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005/2000 , DB2 9.0/8.0, Teradata

OLAP Tools: Microstratergies

Reporting Tools: IBM Cognos 8.1, Business Objects XI R2/R3/4.0/4.1

Languages: SQL, PL/SQL,, Visual Basic,Java, c#.

Tools: Toad, SQL* Loader, WinSQL, Teradata SQL Assistant 6.0

Operating Systems: Windows 2003/2000/NT, UNIX, AIX, Linux

Testing Tools: QTP, Quality Center 10, ALM 11, Test Director, WinRunner, LoadRunner

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr DWH/ETL/BI Tester

Responsibilities:

• Tested the ETL process to automate the testing process and also load the test data into the testing tables.
• 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.
• Reported debuging using informatica 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.
• 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
• Write ATDD tests using Gherkin as template and C# as the code behind the test cases in Visual Studio.
• Experience in working with business analysts to understand the business complexity and analyzing the impact & risks.
• 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
• Managed multiple projects for EDWH Group for all testing activities related to both ETL and BI
• Involved in rebuild testing of the BI Reports from Cognos to Crystal Reports and written extensive SQL for comparing the records against source data.
• Was responsible for maintaining all the test cases and defects in HP ALM 11.0 for all the team members to review.
• Testing every attribute at each level and used to update the testing results in HP Quality center ALM for tracking.
• Used ALM to plan tests, manage test assets, and create and run manual and external scripts to check GUI and functional features.
• Tested several data migration application for security, data protection and data corruption during transfer
• Preparation of Metrics on a monthly basis in order to check the accuracy of the data which is residing in the Risk Data Warehouse
• Tested the data load process using the Informatica ETL tool for various data loading scenarios including Batch Load, Sequential Loads, Incremental Loads & Direct Dumps
• Focused on Data Quality issues / problems that include completeness, conformity, consistency, accuracy, duplicates, and integrity.
• Worked with Data Conversion projects for testing data quality after migration.
• Experienced using database query tools for Oracle, SQL and UNIX such as TOAD, Teradata SQL Assistant, WinSQL and SQL Plus.
• Used SQL Loader for data retrieval and querying.
• Experienced in data analysis using SQL, PL/SQL and many other queries based applications.
• Production reconciliation was performed before the deployement of the developed application to the production systems to ensure that the data is being processsed efficently and to test the correctness of the data.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Validated business reporting requirements with internal and external customers.
• Used SQL server and Oracle database as source and destination data warehouse.
• Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.
• Validated the reports to make sure all the data is populated as per requirements.

Environment: Informatica 9.0/8.6, SSIS, SQL Server 2008, HP ALM 11/Quality Center 10, Oracle 10g, Erwin 4.0, UNIX, Windows 2000, C#, TOAD.

Confidential, Tampa, FL

Sr ETL/DWH Tester

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Used Quality Centre for tracking the defects.
• Tested all data reports published to Web including dashboards, summarized, master-detailed and KPI’s.
• Tested mapping for extracting, cleansing, transforming, integrating, and loading data using Informatica ETL Tool.
• Worked as ETL Tester responsible for the requirements gathering / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Involved in Implementing Agile (Scrum) methodologies for the complex project modules.
• Tested and worked on creating open document reports for business.
• Preparation of technical specifications and Source to Target mappings.
• Performed Risk Analysis based on Defect Severity and Priority.
• Involved in entire QA Life Cycle, which includes Designing, Developing and Execution of the entire QA process and documentation of Test Plans, Test Cases, Test Procedures, Reporting and Tracking the defects.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Running QTP scripts from Quality Center for Regression testing and reporting results to Manager.
• Develop Functional/Regression automated testing solutions using QTP, traditional QTP framework, and/or Data Driven techniques.
• Written SQL scripts to test the mappings and extensively used Cognos for report generation.
• Responsible for verifying the log files using UNIX and database for the submitted application.
• Coordinated and Interacted with Development team and actively participated in status meetings during the defect life cycle, reported the bugs and maintained their status.
• Validated format of the reports and feeds.
• Effectively communicate testing activities and findings in oral and written formats.
• Worked with ETL group for understanding dimensions and facts.
• Extracted data from various sources like Oracle, flat files and DB2.
• Designing and creation of complex mappings using SCD type II involving transformations such as expression, joiner, aggregator, lookup, update strategy, and filter.
• 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.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Validated cube and query data from the reporting system back to the source system.
• Tested analytical reports using Analysis Studio

Environment: Informatica, data stage, Quality Center, SQL *Loader, cognos, PL/SQL, SQL, Stored Procedures, Test Cases, Test Scripts, Test Plans, Oracle8i/9i, DB2, Erwin 3.5/4.1, Windows 2000 and TOAD.

Confidential, Charlotte, NC

Sr ETL/DWH Tester

Responsibilities:

• Involved in Relational modeling and Dimensional Modeling Techniques to design ER data models and Star Schema designs
• 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.
• Performed automation testing for the Back Office using Quick Test Pro and coordinate with the dev team for immediate hot fixes.
• Executed SQL queries to perform backend database testing and verify/modify user data.
• Enhancing the QuickTest Pro Scripts with GUI checkpoints, Database Checkpoints, Parameterization, User Defined Functions (adding functional features) and Synchronizations.
• Performed Manual Functional Testing and Automated Testing using QTP, of the application against new builds.
• 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.
• 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
• 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.
• 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, QTP, SOAP, Windows NT, Test Cases, Test Scripts, Test Plans. Oracle 8i, SQL Server, SQL, PL/SQL, SQL*Plus, TOAD and Shell Scripting.

Confidential, Bellevue, WA

QA ANALYST

Responsibilities:

• Tested/Found the defects in Mappings and Work flows. Used Mercury Quality Centre for tracking the defects.
• Tested all data reports published to Web including dashboards, summarized, master-detailed and KPI’s.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• A test reporting environment was established to combine Distribution Work Management and PeopleSoft information into a consolidated place to allow combined reports to be generated.
• 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.
• 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.
• Validated format of the reports and feeds.
• Effectively communicate testing activities and findings in oral and written formats.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Designing and creation of complex mappings using SCD type II involving transformations such as expression, joiner, aggregator, lookup, update strategy, and filter.
• 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.
• Validated cube and query data from the reporting system back to the source system.

Environment: Informatica 8.1, SQL *Loader, QTP, PL/SQL, SQL, Stored Procedures, Test Cases, Test Scripts, Test Plan, Oracle8i/9i, SQL Server 2000/2005, Erwin 3.5/4.1, Windows 2000, TOAD