PROFESSIONAL SUMMARY:

• Over 7+ years of IT experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.
• Experience in Data Analysis, Data Validation, Data Profiling, Data Verification, Data Loading and testing DWH application.
• Experienced in complete Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC) and Bug Life Cycle (BLC)
• Extensive experience in Black Box Testing Functional Testing, Integration Testing, System Testing, Regression Testing, Performance Testing, UAT Testing, Manual Testing etc., on Enterprise Applications.
• Worked on various Domains like Insurance, Health care, Investments and Pharmacy.
• Expertise in OLTP/OLAP System Study, Analysis and E - R modeling, developing Database Schemas like Star flake schema and Snowflake schema used in relational, dimensional and multidimensional modeling
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL)
• Involved in preparation of Test Cases and to ensure detailed test process wrote Test Scripts
• Involved in preparation of test data to test the functionality of Informatica Sources Mappings, Targets
• Worked with both V-Model and Agile Methodology.
• Proficient in warehouse designs based on Ralph Kimball (Bottom-Up) and Bill Inman (Top-Down) methodologies.
• Extensive Backend testing Experience on Database.
• Expertise in Defect management, Bug tracking, Bug Reports and generating the Graphs using Test Management Tools such as Quality Center, Test Director
• Involved in preparation of Weekly and Status reports.
• Worked with wide variety of sources like Relational Databases, Flat Files, TeraData and DB2.
• Worked with Oracle and SQL Server Stored Procedures, Triggers, Index, and experienced in loading data into Data Warehouse/Data Marts.
• Familiar with PL/SQL Coding, Normalized Database creation in relational databases like Oracle 8i/9i, MS-SQL Server 2000 and optimizing the SQL to improve the performance.

TECHNICAL SKILLS:

Testing Tools: Quality Center 9.0, Test Director 8.0, Rational Requisite Pro, Rational Test Manager, Rational Clear Quest

Data Modeling: Dimensional Data Modeling, Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical / Logical Data Modeling, Erwin

Databases: Oracle 9i/8i, SQL Server 2000, DB2, TeraData, MS Access 2000, TOAD, DB2

ETL: Informatica Power Center 8.X/7.x, OLTP, OLAP

Programming: SQL, PL/SQL, UNIX Shell Scripts

Operating Systems: Windows95/98/2000/XP/2003, Unix

PROFESSIONAL EXPERIENCE:

Confidential . - Jersey City, NJ

ETL Tester

Responsibilities:

• Worked with Business analysts to understand Business/System requirements in order to transform business requirements into functional test cases.
• Responsible for reviewing Functional specs, user documentation and use cases and developing manual test cases out of it.
• Responsible for planning and directing Quality Assurance and Software change control policies.
• Study and analysis of the mapping document indicating the source tables, columns, data types, transformations required, business rules to be applied, target tables, columns and data types
• Coordinated in setting up Test Environments and Test Plan needs with team members.
• Developing various Test Scripts, Test Execution using Quality Center based on the Functional Specifications.
• Executed Test Cases using positive and negative data in Quality Center’s Test Lab and reported results and defects using Quality Center’s Defects tool.
• Involved in validating the Data mart tables as per the business logic applied to the staging tables.
• Executed the test scripts against TeraData source and validated the rules according to mapping documentation.
• Testing and validation of the developed Informatica mappings.
• Worked with Testing of Flat File and source data.
• Developed SQL queries for Back-end testing/Database testing and participated in end to end testing.
• Validated the source system data with the staging data using SQL and Pl/SQL scripts.
• Reached Testing Goals by doing Data Completeness, Data transformation, Data Quality, Performance and Scalability
• Expertise with System Testing, Functional Testing, Regression Testing.
• Prepared Traceability Matrix with requirements versus test cases.
• Tested several UNIX shell scripting for File validation and also PL/SQL programming
• Involved in identifying the defects and developed Defect Tracking report using Mercury Quality Centre which involved Bug life cycle.
• Provided daily and weekly status reports.

Environment: Quality Center 9.0, Informatica Power Center 7.1.3/8.1, Erwin, Ms Excel, Oracle 10g/9i, SQL, PL/SQL, Teradata utilities, TOAD 8.0, Autosys Scheduler, UNIX, Windows 2000

Confidential - Dublin, OH

ETL/QA Tester

Responsibilities:

• Analyzed the Business Requirements and Rules and worked with Business Analysts and Business Users in preparing Test Plans.
• Gone thru the Functional Specifications and implemented their technical aspect in System and Integration testing (SIT).
• Developed Test cases, Test scripts from the data mapping documents, functional Specification documents and mapped the test cases with the requirements for generating the Requirement Traceability Matrix (RTM).
• Closely went through and worked on all the stages of SDLC for this project and designed and executed Functional, Integration, Regression, and System (End to End), UI Testing, Browser Compatibility, Backend (Database) Testing.
• Extensively used Informatica Workflow Manager to run the workflows.
• Monitored the session logs/log files in Informatica Workflow Monitor.
• Tested theETLInformatica mappings and otherETLProcesses (DW Testing).
• Analyzed and tested Informatica Mappings with OLTP source data, staging and target data.
• Involved in testing the batch programs by using the Autosys tool.
• Scheduling shell script jobs, creating instances of jobs, verifying logs according to client requirement using Autosys server.
• Involved in maintaining the test environments; with activities like requesting data loads, data base backups, restarting the servers, requesting the deployments, troubleshooting issues.
• Coordinating with source system owners, day-to-dayETLprogress monitoring and maintenance of dailyInformaticabatch schedule run on a nightly basis.
• Exclusively tested the inbound and outbound batch jobs.
• Involved in testing the functionality of ETL workflows.
• Worked with the UNIX shell scripts.
• Used HP Quality Center as test management tool.
• Tested Business Objects Reports according to the business requirements.
• Prioritized the test cases based on the projected metrics and project deadlines.
• Worked with Developers on Defects until the test case is passed.
• Extensively written SQL to confirm the data transfer from source to target.
• Involved in testing informatica workflows, and also involved in Data Migration.
• Tested the PL/SQL procedures, functions, packages according to the requirements.
• Verified test results (querying the database using the SQL) documenting the defects.
• Involved in testing the UI screens, reports which was used by the internal business team.
• Prepared Test Scenarios by creating Mock data based on the different test cases.
• Attended Bi-Weekly Defect Review and Defect Status meetings. Provided updates to Team Lead on testing activities.

Environment: Informatica Power Center 9.1/8.6, HP Quality Center 11, Business Objects BOXI, Rational Clear Case, Clear Quest, TOAD, Oracle 11g, SQL Server 2008, Autosys, DB2, PL/SQL, UNIX, Putty, Flat files, Session Logs, SQL scripts.

Confidential - Milwaukee, WI

ETL Tester

Responsibilities:

• As an ETL Tester I was involved in analyzing the existing system process.
• Designed and created Documentation for the proposed system by creating Technical documentation, mapping documents, Functional Documents.
• Enhanced the Legacy Technical Specifications to meet the Enhanced System specs.
• Designed and maintained logical and physical enterprise data warehouse schemas.
• Worked on Star schema loaded data using Fact Tables (Rebate Utilization, AMP Utilization Table, etc.) to the staging tables (I calculate).
• As testing all data issues I have used SQL scripts to get issues resolved.
• Created naming conventions and system standards for lookup (Connected and unconnected) transformation and target tables.
• Experienced in writing complex SQL queries for testing data in oracle targets.
• Worked on issues with migration from development to testing.
• Prepared test data to validate ETL rules wherever necessary.
• Extensively used ETL and Informatica to load data from flat files (Price Group, Balancing File, etc.) MS Access and MS SQL Server 2005.
• Used Informatica Workflow Monitor to monitor workflows and review session log.
• Designed, developed and deployed new Data Marts along with modifying existing support additional business requirements
• Worked on Source Analyzer, Power Center designer, Workflow manager, Mapping Designer.
• Loaded data from source tables (Contract Pharmacy, Pharmacy Name, Pharmacies (vw), ProviderXRef (vw)) to the target table named Pharmacy Name.
• Performed Regression Testing as and when the Bugs got fixed and check whether the application is free from builds.
• Writing test plans to in corporate the testing needs of the data warehouse using Test Director.
• Writing test cases for the data extracts to make sure the vendors are sending the correct data files.
• Maintained Source definitions, Transformation rules and Target definitions.
• Improved Performance for complex jobs by using Transformations Source Qualifier, Aggregator.
• Involved in developing and maintaining Modeling standards, Operation procedures and new development areas.
• Implemented Scheduled jobs in UNIX Environment and EDW scheduler.
• Worked on testing with Complex Mappings by importing Procedures/functions to build business rules to load data.
• As a testing process created Database scripts, Procedures, Database Constraints.
• Designed developed and tested processes for validating and conditioning data and maintained test documents (UAT), System Testing and integration Testing.
• Tuning was implemented as a part of the ETL testing with use of hints, parallel hints.
• Translated business-reporting (OLTP REPORTS) requirements into Data Warehouse Architectural design.
• Performed Performance tuning and solved data quality issues raised in loading the data form Source to Target.

Environment: Informatica Power center 8.1/8.6.0,Oracle 10g, SQL, PL/SQL, MS SQL Server 2005, MY SQL, MS Access 2003, UNIX, TOAD

Confidential - Long Island, NY

QA Tester

Responsibilities:

• Involved in preparing Test Plan based on User requirement documents.
• Written test cases as per the Functional Specification documents and executed them.
• Performed Interface/flow, Functionality & Data validation for Modules like Tax Calculation, Customer ID, Recipient, Payment and Confirm Validate Orders.
• Performed Integration, Regression, Acceptance, System, Usability, etc. testing during different stages of the application development.
• Requirements changed documented and test cases were modified/incorporated in respective Functional Specifications.
• Responsible for performing various types of process evaluations during each phase of the software development life cycle including, audit, review, walk through and hands on system testing.
• Tested application, logged found bugs into Test Director/Mercury Quality Center, monitored their progress and verified their fix.
• Actively participated in enhancement meetings focused on making the product more effective in real time scenario.
• Created Orders in UOC and Verified Created order in backend system Assist & Validated file transfer of data in XML.
• Data was set up in Universal Administrative System (UAS) and verified in front at UOC.
• Attended Walk through, Meeting with Project manager & QA team.
• Responsible for sending Daily & weekly status report using MS-Office tools.

Environment: Java, J2EE, Oracle 8i, Citrix, XML, AS400, Test Director/Mercury Quality Center, MS-Office.

Confidential

Data Base Developer

Responsibilities:

• Created Database tables, Indexes, Clusters, Triggers, Procedures, Functions and Database links.
• Created Dimension Tables and Fact Tables based on the warehouse design.
• Planned, scheduled and Implementation of backup procedures. Performing recovery of databases.
• Involved in development of Front-end screens for entering information of the problems using Forms 4.5.
• Designed various Reports using Reports 2.5
• Performed Manual Functional Testing, focusing on the end-user point of view, by executing written test scripts and reporting bugs found using the Defect Tracking System (Test Director).

Environment: Oracle 7.x, Forms 4.5, Reports 2.5, Developer 2000, PL/SQL, Test Directory, Windows 2000