SUMMARY

• Around 7+ years of total IT experience and very good knowledge QA of Software Applications and Testing. Extensive experience in testing of data warehouse / data marts for business applications with Banking, Financial, Brokerage, Insurance, Pharmaceuticals, Manufacturing.
• Experience in Data Warehousing technology in building and managing various data warehouse / data marts using Informatica products such as Informatica Power Center/Power Mart, Power Connect, Power Analyzer and Power Exchange Tools.
• Expert in writing T - SQL, working on DTS, SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration.
• Experienced testing Web Services using SOA, SOAP UI, and REST & Custom Based Approach.
• Experience in using SOAP Sonar for providing simple, intuitive and comprehensive testing for SOAP-, XML- and REST-based services
• Coded Business logic in C#, VB.NET.
• Used HP Quality Center (QC)/ALM as test management tool and logged the test plan and test cases in QC.
• As a part of this project I had to perform data profiling using the Abintio Data profiler
• Performance Tuning, Optimization using TKPROF, STATS PACK, ADDM and Cost Based Optimizer
• Experience on black box, white box, and gray box testing.
• Strong experience in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export through the use of multiple ETL tools such as Ab Initio and Informatica Power Center.
• Abilities to perform VB .NET programming
• Reported and tracked bugs using ALM and involved in defect management systems.
• PL, SQL, SQL Development and Tuning Skills, Process Automation using Shell Scripting
• Experience working in using Databases like Oracle, Teradata, SQL Server, DB2, MS Access and DB2. Expertise in Database Programming (Stored Procedures, Triggers, Packages, PL/SQL) using Oracle.
• Experience in Pharmaceutical, Financial, Banking, Manufacturing, and Securities industries.
• Extensive testing ETL experience using) Informatica Power Center 9.0/8.x/7.x, (Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer.
• Performed Black Box testing such as Smoke, Functional, Regression, Integration and End-to-End testing.
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica.
• Designing and Coding the Abintio Graphs
• Updated the Test cases and executed test cases maintain the automation test scripts and maintain the Defects in HP Quality Center.
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
• Extensive experience in Business Intelligence reporting tools using Cognos Series, Power Play, Transformer, Impromptu Web Reports (IWR).
• Converted all Oracle ETL Packages to Informatica Mappings and created workflows/Sessions.
• Extensively used SQL, PLSQL to create complex queries, SQL Override, Stored Procedures, and Triggers.
• Experienced in Data Modeling, Erwin, Star/Snow Flake Schema Designs, Logical Data Modeling, Normalization, Physical Design, Data Analysis, Data Modeling, Reports and Report Design.
• Expertise in writing Unix Shell Scripts.
• Expert in using Test Management Tools - HP, ALM,Quality center 11
• Helped create a question bank on Abintio which could be used for internal certification
• Creating Oracle objects like tables, types, packages, procedures and functions.
• Execution of test cases for Functional testing, System Testing and Regression testing
• Involved in functional, integration, End-to-End, interface, system, black box testing.
• Excellent Analytical and Logical Programming skills with a good understanding at the Conceptual Level and possess excellent Presentation, Interpersonal skills with a strong desire to achieve specified goals. Excellent written and verbal communication skills including experience in proposal and presentation creation.

TECHNICAL SKILLS

OS: Sun Solaris 2.7/2.6, HP-UX, IBM AIX 4.3/4.2, MS DOS 6.22, Win NT/2000/98/95.

ETL Tools: Informatica Power Center 9.0/8.x/7.x, (Source Analyzer, Warehouse Designer, Data stage 7.x, Transformation Developer, Mapplet Designer, Mapping Designer, Ab Initio GDE 1.15/1.14 / 1.13 / 1.12

BI Tools: Cognos 8.0 Series, Business Objects, SSRS, SSAS, Crystal Reports and Siebel Analytics

Languages: SQL, PL/SQL, VB, C, C++, COBOL.

Databases: Oracle 10g/9i/8i, MS Access, SQL Server 2008, DB2 9.x, Teradata V2R6

Other Tools: Erwin 4.5/4.0/3.5.5/3.5.2

Testing Tools: Win Runner 8.2, Load Runner 7.8, QTP 8.2, Quality Center 10, ALM, and Test Director

PROFESSIONAL EXPERIENCE

Confidential, Florida

Sr. ETL QA Test Engineer

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.
• Lead team of 6 people in Quality Assurance Team.
• 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, Warren, NJ

ETL Tester

Responsibilities:

• Prepared Test Plan, Estimation and Overall project tracking for every release.
• Experience in creating UNIX scripts for file transfer and file manipulation
• Extensively used T-SQL to verify and validate the data loaded to the SQL Server
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing Involved in extensive DATA validation using SQL queries and back-end testing
• Wrote complex SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application
• Written several UNIX scripts for running test loads for regression testing purpose
• Used Informatica Power Center 8.6.1forextraction, loading and transformation (ETL) of data in the data warehouse.
• Involved in developing Unix Korn Shell wrappers to run various Ab Initio Script
• Involved in Implementation of the QA process and documentation of ETL Test Plans, ETL Test Cases, Test Procedures and Test Scripts for manual and automated testing scope in the QA life cycle.
• Worked on a Business Intelligence reporting system that was primarily functioning on Oracle Applications OLTP environment with Business Objects for Business Intelligence reporting
• Responsible for the management, design, and continuous development of the Data Migration Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Responsible for testing Business Reports developed by Business Objects XIR2.
• Performed GUI Tests, Regression tests, Functionality testing,Integration Testing and Adhoc Testing.
• The reports that were created in Business Objects were testing by running the SQL statements
• Exported the results through SQL and documented the test results for test cases, suites executed.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation.
• Analyzed and verified the flat, Mainframe IMS and xml data using Ab Initio Data Profiler
• Validated the server logs for Exstream server errors which are running on UNIX boxes by using Putty
• 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 successfuly implemented on Oracle target, the data warehouse is growing in its analytical richness.
• Adhered to all established processes and procedures for UAT
• Proficient in writing SQL, PL/SQL stored procedures, packages and triggers.
• Worked with T-SQL for validating the SQL Server2008
• Prepared UAT test cases and testing estimates
• Promoted Unix/Informatica application releases from development to QA and to UAT environments as required.
• Creating test scripts using Quality Center and performing regression testing on new versions of the software.
• Involved in automation of test cases using QTP.

Environment: Informatica 9.1,8.6, Abintio,Oracle 11g, OBIEE, Windows 2000, UNIX, Perl, Python, Quality Center 10.0, QTP 10.0,Business Objects Enterprise XI R2/ R3, Teradata V2R6, MS SQL, ALM,Server,.SSIS,SSRS,SSAS,SQL,PL/SQL,T-SQL,ASP.NET, SharePoint, java Script, HTML, VB.NET.

Confidential, Bloomfield, CT

ETL/SQL QA Tester

Responsibilities:

• Designed and developed Test Plans, Test Scripts and Test Cases in HP Quality Center and executed them.
• Involved in writing the Test Plans based on Business Requirement and Functional Requirement documents.
• Involved in implementation of the Test plans, Test cases and Test Scripts.
• Created Test sets in Test Lab to move all the test cases from Test plan to execute the test cases.
• Tested the data and data integrity among various sources and targets.
• Developed and involved in both Manual Testing and Automation Test Scripts based on Use cases developed.
• Tested to verify that all data were synchronized after the data is troubleshoot, and also used SQL to verify/validate my test cases.
• Tested Business Objects reports and Web Intelligence reports.
• Managed user accounts and security using Business Objects Supervisor.
• Tested the universes and reports in Business Objects XRI3.
• Extensively used Informatica power center for ETL process.
• Preparation of ETL mapping specifications.
• Worked with QTP for Regression Testing.
• Configured Quick Test Professional with Quality center.
• Executed of QTP Script for automation testing, analyzing the automation result
• Reviewed Informatica mappings and test cases before delivering to Client.
• Used all Teradata utilities including Fast Load, Multi Load, Fast Export, SQL Assistant, BTEQ & TPUMP
• Trained and coordinated with the offshore team members in understanding the requirements and test cases for UAT.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
• Involved in ETL Mapping Design and Performance tuning to Load mapping process.
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Reviewed the test cases written based on the Change Request document.
• Testing has been done based on Change Requests and Defect Requests.
• Involved in preparation of System Test Results after Test case execution.
• Experienced in writing UNIX script.
• Effectively coordinated with the development team.
• Created critical scenarios for each change request and defect request.
• Worked on HP Quality Center and updated defects status with appropriate information. Test cases and Test plans are managed and controlled using HP Test Director. And also used HP Test Director to manage and track defects.
• Involved in various testing phases like Unit Testing, System Integration Testing, Validation Testing, User Acceptance Testing, Parallel Testing, Performance Testing and Regression Testing.
• Used various SQL queries to validate the test case results for back-end test cases.
• Well exposed to Software Development Life Cycle and Test methodologies.
• Hands on experience with working on Autosys jobs and MQ’s. MQ’s are used for intermediate storage where the messages are stored for temporary purpose.
• Hands on experience working with SQL Server DTS Packages.

Environment: Informatica Power Center 8.1,Abintio, Business Objects XRI3, SQL, PL/SQL, SQL Server 2000/2005, Unix Shell Scripting, XML, XML Spy 2008, XSLT, TOAD 9.2,Oracle 9.2, SOA, SOAP UI, REST Teradata, HP Quality Center 9.2, QTP 9.2, Rational Suite, DB Artisan 8.5.2, Autosys, MQ’s,SSRS.

Confidential, Pleasanton, CA

ETL Quality Engineer

Responsibilities:

• Projects were in different methodologies like Waterfall and AGILE, well versed with both Methodologies of SDLC.
• Identified the requirements and arranged peer reviews, walkthroughs and sign off meetings.
• Involved in Gathering and Analyzing Business Requirements, High Level Designing and Detail Technical Design of ETL application.
• Involved in unit testing and integration testing of the developed work Analyzed production support Issues.
• Designed detailed test plans, test case and executed test scripts and diagnose problems in Informatica mappings based on Business Requirements.
• Gathered UI specifications and analyzed business process and established test strategies.
• Tested the values for test, Component parameters in Quality Center.
• Performed Backend Testing, Database validations, patient claims validations by writing complex SQL minus queries
• Installing, Configuring and maintaining of Load runner and QTP Tools.
• Wrote scripts to perform basic Sanity Testing and uploaded Test Scripts in Test Director.
• Responsible for developing PL/SQL Stored Procedures, Functions, Packages, triggers and other Database objects.
• Assigned users in TD administration, Created Test folders in Test Directors users in Project Customization.
• Logged issues in Test Director and tracked them to see whether the bug is fixed in the next Version.
• Communicated with Developers regarding technical issues.
• Used Remedy in trouble ticketing and moving projects from testing to pre-production Environments. VSS to upload track and manage scripts and documents.

Environment: Test Director 8.0, SQL server 2005( SSIS, SSRS ), SSAS, Informatica 8.x, SQLServer, DTS Packages, Remedy, Windows NT, UNIX, MS Excel, VSS(Visual SourceSafe), Load Runner, Quality Center 8.2, QTP 8.2, Ab Initio GDE1.12,TFS,Load Runner.