SUMMARY:

• 7 years of Dynamic, Results - oriented professional with IT industry experience in Analysis, Design, Development, Documentation, Testing and Implementation of Business Intelligence solutions For Insurance, Telecom, Pharmaceutical and Financial domains.
• 5 years of Experience in ETL division of Data Warehousing Testing/Analysis in Informatica and Oracle Warehouse Builder.
• 2 years of Experience in ETL division of Data Warehousing using Informatica as developer.
• Extensive experience in Quality Assurance and System Testing of Client/Server and Web based Applications using WinRunner, Quality Center and Rational Suite of products.
• Expertise in Quality Assurance, Manual Testing, Automation Testing, Analysis and Development.
• Experience in writing, maintaining and executing Test Strategies, Test procedures, Test plans, Test Cases, Test Results and generating software defect reports.
• Experience in conducting Smoke, Functional, Regression, Integration, Database, System and User Acceptance Testing.
• Experience in querying databases like Oracle, Teradata, DB2 and MS SQL Server to validate reports and troubleshoot data quality issues.
• Expertise in Analysis of Business Requirements and reviewing Software Requirements Specifications document (SRS), Mapping Specification Document and in writing Test Plan, Test Strategy, Exit/Acceptance Criteria Document, Requirements Traceability Matrix, Test Execution Matrix, Test Cases, Technical Design Document and Mapping Specification Document.
• Expertize in ensuring data integrity during Data Conversion, Data Cleansing and Data Migration from legacy systems using complex SQL queries with analytic functions, collections and PL/SQL.
• Strong in writing SQL Queries and experience in Performance Tuning (Using TKPROF, SQL TRACE, TIMED STATISTICS & Explain Plans, Analyzing Indexes etc.).
• Experience in creating and Testing BI reports using Cognos and Siebel.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Database/ETL/Reports testing -- Validated the data derived in the target table is adhering to the standards and business rules. Played major role in Test Data Creation and Maintenance. Verified if there are any downstream impacts in the warehouse
• Thorough understanding of Datawarehouse Concepts - Star and Snowflake Schemas; Fact and Dimensional tables and extensive experience testing in Data Warehouse Environment.
• Good knowledge of Software Development Life Cycle (SDLC) and the methodologies followed in SDLC.
• Experience in Debugging/Optimizing/Tuning Informatica mappings for better performance and efficiency.
• Assisted in Timely delivery of projects with planning and teamwork.
• Expertise in tasks like Project Tracking, Mentoring, Report Specification, Version Controls, Software Change Request (SCR / SCM) management, Project Deliveries / Quality Control and Migration.
• Excellent Communication and Interpersonal skills, self-starter, Quick learner and excellent Team Player.
• Ability to learn and adapt to new technologies quickly.

TECHNICAL SKILLS:

Testing Tool: Quality Center 9.2/9.0, Rational Clear Case, Test Director 8.0/7.6/7.2, Win Runner 7.6/7.0/6.5, Quick Test Pro 8.0/6.5/6.0, Load Runner 7.6/7.2, Rational Robot

Networking/Language: UNIX Shell Scripting, SQL, PL/SQL, XML, HTML, PHP, Perl, Java Script, VB Script, Transact SQL, Visual Basic 5.0/6.0, UML

Operating System: Windows 7/NT/2000/XP, UNIX, LINUX

Database: Oracle 11g/10g/9i, Teradata V2R6 (BTEQ, Fast Load, Multi Load, Fast Export, T-Pump), SQL Server 2008/2005, IBM DB 2 9.5/8.0/7.0, MS Access

Tools: Informatica Power Center 9.1, 8.6, 8.1, 7.1.3, Informatica Power Exchange, Oracle Warehouse Builder 11g/10g, Quality Center 9.2, WinRunner, LoadRunner, Rational Clear quest/Case/Rose, Test Director 8.0/7.6/7.2, TOAD 9.5/7.1/6.0, TOAD for Db2, TOAD for Data Analysts, SQL Server Management Studio, SQL Loader, SQL Developer, ER Win 4.0/3.5, MS Visio, Siebel, Star Team, VSS, eRoom.

Defect Tracker: Quality center 9.2/9.0, Rational Clear Quest, PVCS Tracker

Scheduling Tools: Tivoli, Cron Jobs, Autosys, Control-M

App/Web Servers: Apache, Tomcat, Web logic, Web sphere

PROFESSIONAL EXPERIENCE:

Confidential, MI

Sr. ETL/QA Analyst

Responsibilities:

• Analysis of Business requirements & Design Specification Document to determine the functionality of the ETL Processes and attending user review meetings and documenting User Acceptance Criteria.
• Used Agile methodology and was involved in the entire software development Life Cycle of the project from Initiation to Implementation.
• Performed Structural and Functional Back-End testing so as to check validity of data on the databases. Setting up the Back-End Testing environment and strategies for the project.
• Planned, designed and executed test cases based on Requirement Specifications Document and developed manual test cases for Positive, Negative, Functional and Performance testing.
• Performed Full Regression testing on all BIC DataMarts when needed.
• Involved in Testing Datamart projects like Datamart Updates, Enterprise Releases, and Database Conversion.
• Wrote SQL Queries, PL/SQL packages and stored procedures to check data integrity and consistency.
• Performed Post-PROD release testing. This is to assure that all changes were correctly applied from UAT to Production.
• Performed Validation of ETL processes from various source systems to Target database.
• Performed mocking of data that will meet the scenarios of the Test Cases that will be executed in the testing. This is done if the data feed does not have enough scenarios applicable for the testing.
• Provided proactive daily status of issues and progress made during test execution and general application testing.
• Wrote Exit Criteria documents that will be submitted to Business Analysts and UAT Team. This document was required to be approved to assure that the testing performed has met the requirements and was able to cover the possible scenarios.
• Tested loading of data into Data Warehouse, which is in Star schema model.
• Extensive coding in SQL for the Data analysis, Data integrity and Data mart validation.
• Performed smoke testing for certain modules.
• Responsible for setting up the User Acceptance Test (UAT) environment and participated in all walkthrough and reviews.
• Created test plan and test cases from the business requirements to match the project’s initiatives in Quality Center.
• Used Quality Center to create defects based on the information obtained from session logs in case of errors, Data Validation issues (on Datawarehouse) and requirements mismatch.
• Interacted with developers & various members of team to discuss and resolve defects and their priorities.
• Worked with Business Users to develop Test cases for user acceptance testing.
• Performed Data Quality integrity testing (completeness, conformity, consistency, accuracy, duplicates).
• Tested SQL queries, PL/SQL scripts to validate the data and performance of the database.
• Involved in understanding business/transformation rules which are involved in developing the source to target mappings, wrote Complex SQL queries to reflect those rules and validated the mappings by running these test scripts and checked if the data in the target table populates correctly by writing complex SQL queries.

Environment: Informatica 8.6 (Power Center, Power Exchange 8.6), Oracle 10g, SQL Server, DB2, Toad for Oracle 10.5, Toad for Data Analysts 2.6, WINSCP 3, Tivoli Scheduler, CA SCM, Quality Center 9.2, Ksh Scripts, UNIX, Windows 7Project 2: Pharmacy Inbound (for EDW) Aug ‘09 - Aug ‘10

Confidential, NJ

Sr. ETL/QA Tester

Responsibilities:

• Analyzed business requirements, data mapping requirement specifications, and responsible for documenting functional and supplementary requirements in Quality Center 9.0
• Involved in writing detailed Test Plan, Test Cases and Test Scripts using Quality Center for Functional and Regression Testing.
• Used Quality Center 9.0/9.2 to perform manual testing to check the basic functionality of the modules.
• Involved in reviewing Data mapping specifications document to create and execute detailed system test plans. The data mapping specifications document specifies what data will be Extracted, Transformed and Loaded into the Data Warehouse.
• Involved in validating data to verify Referential Integrity.
• Tested Complex ETL Mappings and Sessions based on business user requirements to load data from various source systems like flat files, Mainframe DB2 tables and XML files to target tables.
• Involved in setting up the test environment (in QA and UAT regions) by making the required data available for validating the ETL Processes. Data validations are performed for the data that moves from source to staging, staging to IDS (Integrated Data Store) and IDS to Data Warehouse.
• Written UNIX scripts using commands like grep, awk, sed for data validation, which involved Extraction/Loading of data into/from flat files.
• Verified Informatica Workflow Monitor for status of the workflow, session statistics (count of records loaded/rejected into each Target table/file).
• Involved in testing the XML files and checked whether data is parsed and loaded into staging tables.
• Responsible for testing ETL process based on Data Mapping Specification Document by writing complex SQL Queries in SQL Assistant.
• Written SQL queries and performed Explain Plans on the written queries while querying huge volume of data in production environment as part of my analysis.
• Worked on Informatica Workflow Manager and Workflow Monitor for running the workflows and monitoring the session runs.
• Verified Data Integrity and performed Data Validation for the data flow from Source to Staging, Staging to ODS (Operational Data Store) and ODS to DataWarehouse.
• Involved in Regression, Functional, Integration, System Testing and User Acceptance Testing.
• Used Quality Center to track and report system defects.
• Scheduled Review meetings to discuss Test Plans, Test Cases and Test Results.

Environment: Informatica 9.1/8.6.1, DB2, Toad for DB2, Oracle, SQL Server Management Studio, Business Objects, XML, AIX UNIX, Shell Scripting, Quality Center 9.0, Autosys, Windows XP, Microsoft Office(Word, Excel)Project 3: CAE/CIR DW Nov ‘08 - Jul ‘09

Confidential, NY

Data Warehouse/QA Tester

Responsibilities:

• Shared high responsibility in understanding business requirements and assisting in creating comprehensive test plans and test cases for backend and functional testing.
• Reviewed and Analyzed the System Requirement Specs (SRS), high-level scenarios (HLS), use cases, detailed level requirements and design documents.
• Fully involved in backend integration database testing by writing and executing SQL queries to ensure data integrity and data consistency.
• All SQL queries were fine tuned for greatest effectiveness and performance during the User Acceptance Testing (UAT) for Database testing and Gray-Box testing.
• Performed Integration, System, Regression, Performance and User Acceptance testing of an application.
• Written Test Scripts based on the Business requirements and executed Functional testing and data validation, data reconciliation with defect correction and retesting, followed by regression and performance testing.
• Maintained the test logs, test reports, test issues and defect tracking using Quality Center.
• Involved in preparation of Requirement Traceability Metrics (RTM), Software Metrics, Defect Report, Weekly Status Reports and SQA Reports using Quality Center
• Responsible for documenting test plans for both positive and negative testing scenarios.
• Extensive coding in SQL for Data Analysis and Data Integrity.
• Examined Informatica log files for errors during instances where data was not being loaded and documented the same.
• Solid testing experience in working with SQL, Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
• Involved in Regression testing, checked data completeness, data transformation, data quality, performance, scalability, integration, user-acceptance and regression testing.
• Wrote extensively SQL and PL/SQL scripts to test the ETL flow, Data Reconciliation, Initialization, and Change Data Capture, Delta Processing, Incremental process for multiple source feeds and tested Cognos reports.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Written SQL Queries in Teradata SQL Assistant for data retrieval and data validation.
• Executed BTEQ, Fastload, Mload, TPump scripts to load the data into staging, Datawarehouse and reporting layers.
• Validated reports like DrillDown and CrossTab reports generated from Cognos.
• Created various complex reports using interactive reporting studio using querying, Pivots, Charts, Dashboards from various data sources according to end user requirements.
• Compared Reports Generation with Query Outputs using SQL Scripts and Cognos (MSExcel Pivot Tables).
• Involved in testing the UI applications.
• Involved in Security testing for different LDAP roles.
• Involved in creating both positive and negative test data to cover all business scenarios.
• Created Test input requirements and prepared the test data for Data Driven testing.
• Used Clear Quest to track and report system defects and bug fixes. Written MRs (Modification Requests) for the bugs in the application and helped developers to track and resolve the problems.
• Performed quality assurance reviews through out System Development Life Cycle.
• Participated in defect review meetings with the team members.
• Involved in test planning meetings and submitted test metrics daily to the Team Lead.

Environment: Informatica 8.6, Teradata 12 (MLOAD, FLOAD, FAST EXPORT, BTEQ), SQL Assistant, IBM DB 2 9.5/8.0/7.0, TOAD for DB2 5.x, Oracle 10g, SQL Server 2008, XML Files, Flat Files, UNIX, Quality Center 9.0, Control-M, MS Visio, Erwin, Rational Clear

Confidential

ETL/OWB Tester

Responsibilities:

• Involved in Writing Test Cases and executing them.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Prepared extensive set of validation test cases to verify the data and used TOAD to perform manual test while performing data validation on regular basis.
• Analyzed and reviewed project documentation, business requirements to prepare detailed test schedules and plans.
• Tested OWB data loads for data integrity and performed data validation using complex SQL and PL/SQL scripts.
• Validated the data in Siebel reports by writing SQL queries.
• Wrote Shell Scripts for FTP in transferring Source files from different servers into OWB server.
• Replicated high sensitive data into different environment servers (Dev/QA/Production), using peer-to-peer and snapshot transactional replication methods.
• Extensively used PL/SQL programming in the form of functions, procedures, packages to implement business rules, security, and test cases in the process of building the transaction Datamart.
• Designed well described Test scripts for System testing based on the Functional Design Document
• Designed and executed various Test scripts for Regression tests.
• Collected requirements and tested several business ETL processes in Oracle Warehouse Builder.
• Extracted data from ORBIT database to generate various reports using Siebel.
• Created and Executed Korn Shell scripts in UNIX.
• Conducted Regression Test for the fixes and enhancement of the application.
• Investigated issues occurred while System testing and Regression testing using Requirements document.
• Involved in reading the log files to identify issues/errors in scripts
• Involved in verifying the data in case of errors by tracking the root cause for the error.
• Collected evidence for each step of the process to ensure that any errors are captured on time and resolved immediately
• Raised defects in PVCS defect tracking system. Designed Traceability Matrix to match the test scripts with the Functional design document.
• Helped the System test lead in developing the Test Plan. Provided the Test status reports to the Tech lead and Project lead.
• Effectively communicated testing activities and findings in oral and written formats.
• Worked with ETL group for understating mappings built for dimensions and facts. Extracted data from various sources like Oracle, flat files and SQL Server.

Environment: Oracle Warehouse Builder 10g, Oracle 10g, SQL Developer, UNIX, Windows, Crystal Reports, Siebel 7.5, XML, Star Team, Cron Jobs, PVCS

Confidential, NY

Informatica Developer

Responsibilities:

• Involved in designing Informatica mappings by understanding Business Requirements/Technical Requirement Document (TRD) and writing Technical Design Document (TDD).
• Involved in designing of Data Validation for accurate data loads.
• Developed ETL Mappings using various Informatica transformations like Expression, Lookup, Aggregate, Joiners, Router, Filter, Stored Procedure, SQL Transformation, Update Strategy etc.
• Developed Oracle PL/SQL package for refreshing Materialized views.
• Created UNIX scripts to automate loading verification process.
• Used SQL to run ad hoc queries, created reports and wrote shell scripts in UNIX.
• Tasked to review and evaluate proposed system design resolutions (such as table structure, table relationships) and determine feasibility and practicability in real time environment.
• Worked with 4.5 terabytes of data warehousing storage with Audit/Source/Staging/Reporting databases.
• Developed PL/SQL Packages where the transformation requirement was complex and generated SIEBEL Reports.
• Worked extensively on writing complex SQL queries. Fine-tuned existing queries to enhance speed of Informatica load processes.
• Development of customizedOracle PL/SQLprocedures, functions and packages to load data into and extract data from staging tables, cubes and facts.
• Involved in debugging of the mappings using Informatica Debugger by creating breakpoints to gain troubleshooting information about data and error conditions.
• Overriding the default query in the Source Qualifier by incorporating SQL queries and applying the business rules at the source itself to improve efficiency and avoid cumbersome transformations.
• Worked on Push down Optimization, which improves the mapping performance.
• Evaluated Informatica Power exchange for CDC (Change Data Capture).
• Performance tuning the workflows by identifying the bottlenecks in targets, sources, mappings, sessions and workflows and eliminated them.
• Executed BTEQ, Fastload, Mload, TPump scripts to load the data into staging, Datawarehouse and reporting layers.
• Worked with Teradata SQL Assistant for data retrieval and data validation.
• Scheduled different workflows using Informatica scheduler.
• Performed extensive unit and Integration testing.
• Developed Unit Test Cases to ensure successful execution of the data loading processes.
• Was involved in 24/7 Production support as required.
• Used type I and type II dimensions to update and insert the information in the data warehouse.
• Developed scheduling and automation of jobs using Tivoli Scripts.
• Developed FTP/SFTP process to move data in Flat files to receive/send from/to various systems.