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 PowerCenter 9.0/8.x/7.x, (Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, DataStage 7.x

BI Tools: Cognos 8.0 Series, Business Objects, 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: Quality Center

PROFESSIONAL EXPERIENCE:

Sr. ETL BI QA Tester

Confidential, Boston, MA

Responsibilities:

• Analyzed the Specifications and involved in identifying the source data needs to be moved to data warehouse.
• Well exposed to SDLC (Software Development Life Cycle) and Test methodologies.
• Tested reports developed by Business Objects Universes for both Adhoc & Canned Reporting users of Business Objects
• Worked closely with (TDM) Test Data Management team for data scrubbing. Used to send work order requests to Test Data Management team when sensitive data exists in source tables.
• Designed, developed stored procedures using PL/SQL and tuned SQL queries for better performance.
• Used debugger to test the data flow between source and target and to fix the invalid mappings.
• Used Informatica Power Center and it’s all features extensively in migrating data from OLTP to Enterprise Data warehouse
• Designed and created the Microsoft Visio diagram which represents the workflow and execution process of all the process in the reinsurance world.
• Archived and retired several applications using Informatica ILM and DVO to archive the data and backload into the data warehouse.
• Extensively used SQL queries to check storage and accuracy of data in database tables.
• Written complex SQL queries for validating the data stored in different database tables.
• Helped the team in analyzing the data to be able to identify the data quality issues
• Involved in Database testing by writing & executing SQL & PLSQL queries using TOAD to validate that data is being populated in an appropriate tables & manually comparing the results with front - end values.
• 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.
• Applied rules and policies using ILM (Information Life Cycle Management) workbench for Data Masking
• Transformation and loading into targets.
• Involved in writing the test cases and Test plans based on Informatica mappings and Data Analyst mappings, BA Visio diagrams.
• Extensively worked on handling the application response for Positive and Negative sets of data using data driven testing.
• Also, manually tested the application for each system build, for both negative and positive testing.
• Communication with the client for weekly status report
• Test execution in accordance with test strategy and test schedule, review; issue identification and data mining exercises in accordance with project plan timelines.
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases.
• Worked with Data replication, Data retention and ILM process and Partition Extender jobs.
• Stimulated several production cycles. Worked with data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
• Utilized Test Director/Quality Center for Tracking and Reporting Defects, which are assigned to developers.
• Designed and developed Test Plans, Test Scripts and Test Cases in HP Quality Center and executed them.
• Participated in Daily and weekly status meeting with team members and coordinated with teams (Development, Business, and QA) for the progress of the work done in application.

Environment: Informatica power center 9.1, SQL, PL/SQL, Business Objects, Unix Shell Scripting, Oracle11g, ILM, TDM, ALM/HP Quality Center 11, Autosys, Microsoft Visio

ETL/ QA BI Tester

Confidential, Wilmington, DE

Responsibilities:

• Involved in development of test plans, analyzed the business requirements and data mapping documents and developed test cases.
• PL/SQL queries were written to perform operations like joins in the source database.
• Vigorously worked on Manual Testing. Written Test plans, Test Cases and Test Scripts.
• Developed Test Cases for testing the mapping designs before going to the production phase.
• Developed test reports, which compare the sources and the desired targets.
• Involved in all testing phases: System Testing, Acceptance Testing, Regression Testing, and Integration Testing.
• Written several complex SQL queries for validating Cognos Reports.
• Provided support to sales team management and sales operations support groups in the receipt, warehousing and reporting account level sales information.
• Extremely involved in using Test Director for identifying the bugs with the help of SQL queries.
• Involved in understanding the Requirements of the end Users/Business Analysts and Developed Strategies for ETL processes.
• Responsible for Mini specifications document that describe the functionality of each subject area.
• Tested new Data migration tool used in the mapping of data to new system.
• Implemented Database Checkpoints for Back-end Testing
• Performed the Back-end Integration Testing to ensure data consistency on front-end by writing and executing SQL statements
• Experienced in writing Teradata SQL Queries, creating Tables and Views by following Teradata Best Practices.
• Experience in ETL Data Warehousing, database testing using Informatica for Workflow process.
• TOAD is used to perform manual test in regular basis. UNIX and Oracle are used in this project to write Shell Scripts and SQL queries
• Worked with business team to test the reports developed in Cognos
• Validated the data of reports by writing SQL queries in PL/SQL Developer against ODS.
• Prepared extensive set of validation test cases to verify the data
• Tested different detail, summary reports and on demand reports.
• 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.
• Creating and executing SQL queries to perform Data Integrity testing on Oracle Database to validate and test data using TOAD.
• Coordinated with different users in UAT process.
• Involved in job scheduling using MS SQL server Agent.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the DB2 database in UNIX environment.
• Scheduled the ETL jobs using Maestro and loaded the data into target tables from staging area using dynamic load process.
• Extracted data from Oracle and upload to Teradata tables using Teradata utilities FASTLOAD
• Extensively worked in the Unix Environment using Shell Scripts.
• Created test plans and performed unit testing for the Informatica mappings.
• Used Confidential -SQL for Querying the SQL Server database for data validation.
• Executed workflows created in Informatica by the developers then compared before and after transformation of data generated to ensure that transformation was successful.
• Performed Data validity testing for reports and feeds based on client's requirement.
• Validated format of the reports and feeds.

Environment: Informatica Power Center 9, Oracle 10g, MS SQL Server 2008, Teradata, IBM DB2, Flat files, PL/SQL, SQL, Toad, Transact-SQL, SQL*Loader, Windows, Unix Shell Scripting, PERL, XML Files, Cognos

ETL/ QA Tester

Confidential, East Providence, RI

Responsibilities:

• Reviewed the Business Requirement Documents and the Functional Specification
• Prepared Test Plan from the Business Requirements and Functional Specification.
• Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet
• Designer and Transformation.
• Tested to verify that all data were synchronized after the data is troubleshoot and also used SQL to verify/validate my test cases.
• Reviewed Informatica mappings and test cases before delivering to Client.
• 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.
• Loaded the data into the Teradata database using Load utilities like (Fast Export, Fastload, Multiload)
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Testing has been done based on Change Requests and Defect Requests.
• Preparation of System Test Results after Test case execution.
• Performed Functional, Regression, Data Integrity, System, Compatibility.
• Extensively executed Confidential -SQL queries in order to view successful transactions of data and for validating data in SQL Server Database.
• Prepared reusable function in QTP to use across the automation scripts
• Experienced in writing Teradata SQL Queries, creating Tables and Views by following Teradata Best Practices.
• Worked along with MicroStrategy Knowledge Base to troubleshoot some Report related issues
• Extensively worked with defect tracking software as Bugzilla, JIRA
• Wrote MACROS in Teradata to generate less channel traffic and easy execution of frequently used SQL operations and improves the performance
• Worked on issues with migration from development to testing for different data loading jobs
• Performed Data centric testing using advanced SQL skills.
• Data Integration testing for products, Reference Data and Customer master data management (MDM)
• TOAD is used to perform manual test in regular basis. UNIX and Oracle are using in this project to write Shell
• Scripts and SQL queries.
• Involved in testing MicroStrategy reports including conditional formatting testing and threshold testing.
• Wrote SQL queries to validate source data versus data in the data warehouse including identification of duplicate records.
• Extensively involved with backend testing by writing complex SQL queries.
• Scripts have been written for both Batch mode which will write results to the individual called test and Interactive (non-batch) mode which will write to the main test.
• Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Mercury Quality Center
• Prepared Test status reports for each stage and logged any unresolved issues into Issues log.
• Used Confidential -SQL for Querying the SQL Server database for data validation.
• Writing the test scripts for manual testing.
• Performed Pre-Migration Assessment, Migration and Post Migration.
• Wrote and ran UNIX Scripts for batch jobs.
• Involved with ETL test data creation for all the ETL mapping rules.
• Tested stored procedures & views in MS SQL
• Communicated discrepancies determined in testing to impacted areas and monitored resolution.

Environment: Informatica Power Center 8.6.1, PL/SQL, SQL, UNIX, Teradata V2R6, MicroStrategy, TOAD 9.2, Oracle 10g, DB2 UDB, MS Access, MS Excel, MS PowerPoint, QTP, Microsoft Share Point, XML, XSD, XQuery, XPath, XSLT, XML Spy 2010, QTP 9.5, HP Quality Centre 10, Windows NT/XP//2003.

ETL BI Tester

Confidential, Alpharetta, GA

Responsibilities:

• Worked on Informatica Power Center tool (Workflow Monitor, Workflow Manger, Mapping & Mapplet Designer and Transformation Developer) to transform data mainly from Oracle and Flat Files and load that data to Staging.
• Prepared PL/SQL queries to perform operations like joins in the source database.
• Involved in Functional, Regression and System testing.
• Designed and created various Test Plans, Test Cases and Test Scripts based on the application requirements.
• Analyzed the business requirements (e.g., business logic, Process specs, process flows)
• Developed test plans and test cases based on the business requirements.
• Used various SQL queries to validate the test case results for back-end test cases. Written SQL Queries to define,
• Identify and validate the code written for the data movement into the database tables.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Reported periodic project status and updates to the QA Lead and QA Manager
• Reported the Defects found during test execution using the Test Director tool and followed up the development personnel for bug resolution.
• Interact with analyst, system staff, business user and developers. Provide input and documentation to System Level Test Plan and facilitated project deliverables
• Development of Unit Test Plans, Integrated and System test plans
• Wrote MACROS in Teradata to generate less channel traffic and easy execution of frequently used SQL operations and improves the performance
• Stored data in the Data Warehouse about Customers, Accounts. The loads were scheduled (Daily and weekly) depending on the frequency of source data.
• Participated in walkthrough and defect report meetings periodically.

Environment: Informatica, Toad, Oracle, MS SQL Server, IBM Mainframes, Teradata, DB2, COBOL, XML, PL/SQL, SQL Plus, SQL*Loader, Business objects XIR2, UNIX, Windows NT.