SUMMARY:

• 7+ years of experience in the Information Technology industry, involving analysis, ETL and BI testing of DWH applications and reporting applications in the Banking, and Financial Domains and Telecom domains
• Proficient in writing Test Strategies, Test Plans, Test Cases, Test Scripts and Test Scenarios
• Experienced in testing requirements developed and reviewed scripts for positive and negative test scenarios, conducted baseline testing, and generated reports.
• Possess specific experience performing Regression and Functional Testing.
• Proficient in Mercury's Quality Center for Test Designing, Requirement Mapping, Reports and Defect Tracking
• Good skills in SQL and PL SQL and Unit testing.
• Hands on expertise in Data ware housing concepts and tools.
• Involved in the ETL processes using Datastage, Informatica, Abinitio, SSIS, SSRS and Autosys tools.
• Expertise in possess specific testing including Backend, Frontend, Regression, Functional, System, Interface, Usability, Black box, Integration Verification and Validation End - to-end and User Acceptance Testing.
• Extensive Experience in Agile Methodology of SDLC.
• Experience in UNIX shell scripting and configuring cron-jobs for Informatica sessions scheduling
• Good experience in Cognos & Business Objects Reports testing
• Well experienced in writing complex SQL queries for extracting data from multiple tables.
• Experience in Performance Tuning of SQL and Stored Procedures.
• Excellent experience in different Databases like Oracle, SQL Server, DB2 and Teradata.
• Proficient in Rational Clear Quest and Quality Center for Defect Tracking
• Defined and Implemented Processes and Procedures for QA Departments
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
• Expert knowledge in UNIX shell scripting (Korn shell/Bourne shell)
• Ability to work independently or in a team environment or in a rapid pace environment.
• Possess strong interpersonal skills, communication and presentation skills with the ability to interact with people at all levels

TECHNICAL SKILLS:

Web Technologies: XML, HTML, Java 1.4/1.5, J2EE, XSLT, Java Script

App Servers: Java Web Server, Apache Tomcat, Web Logic 8.x, IBM Websphere 7.x

GUI Tools Visual Basic 6.0, Developer 2000

Databases & RDBMS: ORACLE 7.X, 8, 9i, 10g, MY SQL, MS Access 2003, DB2, SQL Server 2005,SQL Server 2008Teradata V2R5/V2R6, IBM DB2 8.x, Sybase 12.3

Operating Systems: MS-DOS 6.22, WINDOWS '95,'98 & NT/2000/XP, Unix

Languages: C, C++, Java, SQL, PL/SQL, VB Scripting

Web Browsers: Internet Explorer 6.0, 5.0, Netscape 7.0, 6.0, Mozilla Firefox 1.5

Defect Management Tool Test Director 8.0, Quality Center.8.2/9.1

Data Warehousing: Tools Informatica Power Center 8x, Data Stage 7.x, Ab Initio Co>Op 2.14/ GDE 1.14)

BI Tools:: Business Objects 6.5.1/6.0/5.1. x/4.0 (Supervisor, Designer, Reporter), Web Intelligence, ZABO, InfoView, 3

Tier Business Objects, BCA, BO XI R2

Main Frame: MVS, JCL, COBOL II, VSAM, OS/2, ES 9000, IMS DB/DC, Copy Books

PROFESSIONAL EXPERIENCE:

Confidential, Miramar, FL

Sr. ETL Data warehouse BI QA Test Analyst

Roles & Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Participated in reporting summary documents reviews.
• Developed Test Cases and Test Scripts for System and UAT Testing
• Worked closely with developers and report planners/analysts to insure that an acceptance criterion is complete and accurate for desired report capability.
• Extraction of test data from tables and loading of data into SQL tables.
• Helped the System test lead in developing the Test Plan and Testing Strategy for ETL/BI
• Managed and executed the test process, using Agile Methodology.
• Worked with Teradata SQL Assistant for data retrieval and data validation.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Written several complex SQL queries for validating Cognos Reports.
• Used Quality Center for bug tracking and reporting, also followed up with development team to verify bug fixes, and update bug status.
• Coordinate very closely with the developers regarding functionalities and defects.
• Conducted manual back-end testing on a reconfigured sales application system.
• Performed extensive Back-End testing by writing and executing SQL queries on the database-using SQL Query Analyzer.
• Contributed to design, analyzed and conducted back-end testing using SQL scripts on a database developed from Data Mining.
• Used T-SQL for Querying the SQL Server database for data validation and data conditioning.
• Raised defects in HP Quality Center defect tracking system.
• Designed Traceability Matrix to match the test scripts with the Functional design document.
• Provided the Test status to the Tech lead, Project lead and the team mates.
• Effectively communicated testing activities and findings in oral and written formats.
• Worked with ETL group for understating mappings for dimensions and facts.
• Tested data from various sources like Oracle, flat files and SQL Server

Environment: Agile methodology, MySQL, Informatica 10.5, IBM DB2, Oracle, XML Files, CSV, VSAM Files, SQL Server 2008, ASP.NET, ADO.Net, C#, XML, COM, JavaScript, Visual Source Safe 6.0, QTP 9.0, Quality Center 10.0, SQL, PL/SQL, PERL, Shell Scripting, SQL, PL/SQL, PERL, Visual Studio, .NET 2008, Teradata V2R6, Cognos 10.0 Series.

Confidential - West Valley City, UT

Sr. ETL QA BI DWH Test Analyst

Roles & Responsibilities:

• Followed Agile software development practice paired programming, Test Driven Development and Scrum status meetings.
• Identifying business rules and processing logic and creating and defining requirements to be used across all inbound interfaces.
• Obtained a detailed knowledge of the business process being followed in the project environment
• Extensively used Informatica power center for extraction, transformation and loading process.
• Involved in Unit testing and integration testing of Informatica mappings.
• Used SQL for Querying the DB2 database in UNIX environment
• Wrote complex SQL scripts in DB2 for testing data quality and validation.
• 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.
• Designed and developed Oracle PL/SQL scripts for test data Import/Export
• Extensively worked with TOAD for querying Oracle Database
• Involved in prioritizing the requirements according to business needs and putting all the requirements in QC.
• Totally involved with data validation and data conditioning process for testing the quality of the data. Performed white box and black box testing.
• Extensively worked with Quality center for Uploading test cases and defect tracking and reporting defects
• Extracted the business requirements from the end users keeping in mind their need for the application, and documented it for the developers
• Prepared several test scenario for the work flow of the entire ETL cycle
• Prepared test conditions and Test Cases for modules assigned
• Conducted Defect tracking according to status and Priority and maintenance of defects
• Involved in Documenting/Executing business test cases
• Performed detailed analysis of data issues encountered during business acceptance testing
• Actively involved in the daily testing status meeting in which the defects identified were discussed
• Worked with Data Extraction, Transformation and Loading (ETL)
• Involved in testing data mapping and conversion in a server based data warehouse
• Developed and executed test cases and verified actual results with expected results
• Worked with developers in understating the ETL code for writing several complex test plans for testing both front-end and backend

Environment: Agile methodology, IBM DB2, Informatica Power Center v7.1.2, UNIX AIX, DB2, Windows XP, XML, XSD, Oracle 10g, Business Analyst XIR3, TOAD, Mercury Quality Center, JavaScript, XML, JSON, Restful web services, MongoDB (NOSQL), HTML, PL/SQL, MySQL, Rally, Facets, Selenium WebDriver, JUNIT, Mockito, TestNG, Jenkins

Confidential - Dallas, TX

Data Warehouse ETL QA Test Analyst

Roles & Responsibilities:

• Analyzed and reviewed project documentation, business requirements to prepare detailed test schedules and plans.
• Performed Integration, System, Regression, Performance and User Acceptance testing of an application.
• Tested various jobs and performed data loads and transformations using different stages of Datastage and pre-built routines, functions and macros.
• Wrote complex SQL queries to validate EDW data versus EDM source data including identification of duplicate records and quality of data based on Mapping/Transformation rules.
• Initiated and developed new techniques to improve the testing process and improve the performance of the test scripts.
• Tested Datastage Hash files for extracting and write data to an intermediate file in a job.
• 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.
• Worked with XML feeds from multiple sources systems and loaded the same into Enterprise data warehouse.
• Verified correctness of data after the transformation rules were applied on source data.
• Coordinated the execution of User Acceptance Testing, regression and integration testing with multiple departments.
• Employed data modeling, table normalization (de-normalization for Adhoc) in establishing data and application integrity.
• Identified appropriate test data in relevant source systems and incorporated this data into test scripts.
• Updated the status of testing to the QA team, and accomplished tasked for the assigned work to the Project Management team regularly.
• Performed Regression testing of the fixed issues in the new build until no new issues are identified.
• Submitted weekly bug or issue report updates to the Project Manager in the form of the QA Error Log.
• Submitted Final Test Report and required documentation for the entire project within the assigned time frame.
• Involved in developing detailed test plan, test cases and test scripts using Test Director for Functional, Security and Regression Testing.
• Validated all kinds of transformations used in every work flow, used to transform data.
• Validating the data flow from source to target.
• Checking the data flow from one end to another by using SQL queries
• Worked with technical staff to create, interpret and implement business requirements into technical specifications.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Developed automated test scripts using QTP to perform Functional and Regression testing.
• Created Test input requirements and prepared the test data for Data Driven testing.
• Used Test Director to track and report system defects and bug fixes. Written modification requests for the bugs in the application and helped developers to track and resolve the problems.
• Involved in other test planning meetings and submitted test metrics daily to the management.

Environment: Data Stage7.x, Java, SQL, PL/SQL, Oracle 11g, 8i+9i, HTML, TOAD, XML, UNIX, Test Director, Quick Test Pro, OBIEE 10.3.4, Quality Center, Shell Scripting, MVS, COBOL II, VSAM, JCL, ISPF, CSV files, Flat Files, Java Script, XML, My SQL, Shell Scripting, Restful Services, Jenkins, JIRA 5.x, Mongo DB.

Confidential - Minnesota, MN

ETL QA Backend Tester

Roles & Responsibilities:

• Involved in Agile - Sprint methodologies to do requirements gathering, analysis and planning. Involved in gathering requirements from existing functionality for the custodians.
• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 9.2
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Performed segmentation to extract data and create lists to support direct marketing mailings and marketing mailing campaigns.
• Expert in writing Complex SQL/PLSQL Scripts in querying SQL Server, Teradata and Oracle.
• Defined data requirements and elements used in XML transactions.
• Tested the database schema with help of data architects using ERWIN.
• Involved in the testing of Data Mart using Power Center.
• Identified and Documented additional data cleansing needs and consistent error patterns that could diverted by modifying ETL code.
• Experience in Leading the Offsite Project, managing a team of 8 Offshore and 4 Onsite consultants.
• Extensively used Informatica Power Center for Extraction, Transformation and Loading process.
• Extensively tested several ETL Mappings developed using Informatica.
• Extensively used Teradata load utilities Fast load, Multiload and FastExport to extract, transform and load the Teradata data warehouse
• Tested reports developed by Business Objects Universes for both Adhoc & Canned Reporting users of Business Objects.
• Testing of Business Objects and Reports which Includes, Database Connectivity, Tested objects in the Universe to ensure the correct mapping of the objects, Tested the Universe s Structure to ensure that tables are properly uploaded., Tested the aggregate Universe to ensure the query is pulling correct level of Aggregation
• Worked in an agile technology with Scrum.
• Ensured data integrity and verified all data modifications and calculations during database migration using ETL tools. Developed test cases to accomplish ETL data migration
• Responsible for different Data mapping activities from Source systems to Teradata.
• Queried Teradata Database and validated the data using SQL Assistant.
• Effectively distributed responsibilities, arranged meetings and communicated with team members in all phases of the project.
• Used import and export facilities of the application to download/upload XMLs of failed test cases so as to re-verify.
• Scheduled the jobs using Auto sys and automated the jobs to be ran at specific time and automated the reports.
• Writing UNIX scripts to perform certain tasks and assisting developers with problems and SQL optimization.
• Involved in preparation of Requirement Traceability Metrics (RTM), Software Metrics, Defect Report, Weekly Status Reports and SQA Report using Quality Center.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Validated the data in the reports by writing simple to complex SQL queries in the transactional system.
• Performed Functional, Regression, Data Integrity, Data Profiling, System, Compatibility.
• Implemented Database Checkpoints for Back-end Testing.
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance.
• Processed a query to update a field in an Oracle database, to ensure that debt payments are allocated.
• Tested and validated the cube data, ensuring that the data is correct by comparing the data results to comparable source system reports or by querying individual transactions and forms.
• Worked in multiple source data extraction and data transition from existing production system to test environment.
• Followed RUP and AGILE development methodology and adhered to strict quality standards in requirement gathering.
• Did Unit testing for all reports and packages.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Used Quality Center for requirement analysis, scheduling and generating test cases

Environment: Informatica 8.6.1/7.1, Flat files, Erwin 4.0, MS SQL Server 2000, Oracle 9i, SQL, PL/SQL, IBM DB2 8.0, AGILE, Teradata V2R6,, Business Objects XIR2, COBOL, Quality Center 9.0 Autosys, UTL FILE, TSO, ISPF, OS/z, JCL, Mainframes, Toad, Unix Shell Scripting, Windows XP/2000