Professional Summary:

• I have over 8 years of Professional Experience in Software Quality Assurance and Testing in different environments and platforms including Data Warehousing, Client-Server and Legacy Mainframe applications. Additional skills include:
• Experience in the Analysis, design, development, testing and Implementation of ETL Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.
• Expertise in Testing complex Business rules by creating mapping and various transformations.
• Good Experience in QA Methodology and Validations to ensure industry standards.
• Excellent troubleshooting and debugging skills.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, MS Access and Flat Files.
• Expert in writing SQL for validating complex business rules based on ETL mapping document.
• Strong Knowledge of Data Warehouse Architecture and Designing Star Schema, Snow flake Schema, FACT and Dimensional Tables, Physical and Logical Data Modeling using Erwin.
• Solid experience in Black box testing techniques, which includes, Unit, Integration, Functional, System, Regression Testing.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica.
• Good experience in Client/ Server applications and Good knowledge of Database testing.
• 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 .
• Experience in various Industry Sectors Such as Banking, Health Care, Finance, Insurance, Pharmaceutical.
• Strong interpersonal skills, ability to interact with individuals at all levels, excellent communication and presentation skills.

Technical Skills Summary:

• Data warehousing Tools: Informatica Power Center 8.x/7.x/6.x, Power Exchange, Data Profiler, Informatica Data Quality, Repository Server Administrator Console, IBM Data Stage 7x, SSIS, Ab Initio
• Databases: SQL Server 2008, Oracle 10g/9i/8i, DB2, Netezza
• Languages: SQL, C, TOAD 8.0/7.1, SQL Plus
• Reporting Tools: Business Objects 6.5, XIR3
• Operating System: UNIX Sun Solaris 8.0, AIX5.1 and Windows NT/2000.
• Other Tools: Erwin Data Modeler
• Testing Tools: HP Quality Center 10.0, Rational Clear Quest, Test Director
• Modeling Tools: Star Schema Snowflake-FACT and Dimension Tables, ER Studio
• Scheduler Tools: AutoSys, Control-M

Experience Summary:

Confidential

Quality Assurance Analyst

Responsibilities:

• Designed created Test Cases based on the business requirements and make complete Test Plan.
• Communicated and documented test results and defect resolutions during all phases of testing.
• Validate the data from Clarity's source to Netezza through Data Validation Option DVO .
• Involved in complete project Software Development Life Cycle SDLC and Software Testing Life Cycle STLC .
• Conducted source-system data analysis to understand current state, quality and availability of existing data.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Involved with Design and Development team to implement the requirements.
• Developed and Performed execution of Test Scripts manually to verify the expected results.
• Validated that design meets requirements and function according to technical and functional specifications.
• Extensive experience in manual testing the ETL and Business Intelligence Applications.
• Responsible for testing all new and existing ETL data warehouse components.
• Used defects tracking tools for open defect and also link defects with requirements.
• Performed all aspects of verification and validation.
• Worked with other members of the QA and Developer teams in improving the processes, methods, effectiveness and efficiency.
• Data Quality Analysis to determine cleansing requirements.
• Used Netezza tools for Querying Database.
• Participated in walkthrough and defect report meetings periodically.
• Every week status meeting for going on project discussion with QA team, Manager, other test team.
• Participated in standing meeting every day HIMC 38 .
• Documented and reported various bugs during Manual Testing.
• Involved in running the ETL loads in development server.
• Written SQL Queries to define, Identify and validate the code written for the data movement into the database tables.
• Retesting the resolved defects/issues after the developers fix the defects.
• Updated the status of the testing to the QA team, and accomplished tasked for the assigned work to the Project Management team regularly.

Environment: ETL Informatica 9.1.0 , Oracle, Data Validation Option for to connect two database, Aginity for Netezza, Microsoft SQL Server 2008, SQLTools 1.6, Call Logging, ServiceNow, Windows XP Professional, , MS Excel, MS Word, MS PowerPoint, MS Outlook, MS Visio.

Confidential

Responsibilities:

• Involved in the design, development and testing phases of the project.
• Identified the key facts and dimensions necessary to support the business requirements.
• Worked on Informatica Power Center Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformations Developer and Workflow Manager.
• Designed the ETL processes using Informatica to load data from ODS to the staging area, applied the appropriate business logic to load data from staging database to Data Warehouse.
• Designed, developed and tested ETL scripts to extract, transform, and move the data from ODS through the staging area to the Data Warehouse.
• Created mappings to load Slowly Changing Dimension tables based on the amount of historical dimension data to be stored in data ware house.
• Created the mappings using transformations such as the Source qualifier, Aggregator, Expression, Lookup, Router, Filter, Sequence generator and Update Strategy.
• Tested and tuned mappings for better performance.
• Developed re-usable transformations, mappings and mapplets conforming to the business rules.
• Identified bottlenecks for ETL runtime on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Debugged and resolved load failures by verifying the log files.
• Generated Reports on a daily basis using Hyperion Analyser.
• Supported QA Team in fixing the bugs.

Environment: Informatica 8.1, Oracle 10g, SQL, PL/SQL, Windows, TOAD

Confidential

Responsibilities:

• Involved in system analysis and data modeling, development, deploying and testing.
• Extensively worked on Informatica Power Center Designer, Workflow Manager and Workflow Monitor.
• Extensively used ETL processes to load data from various source systems such as Oracle and Flat Files into target systems by applying business logic on transformation mapping for inserting and updating records when loaded.
• Used the Workflow Manager for creating, validating and running the workflows, sessions and scheduling them to run at specified times.
• Developed various Mappings and Transformations using Informatica Designer.
• Extensively used Expression, Filter, Joiner, Lookup, Router, Aggregator and Update Strategy transformations.
• Used debugger to test the mapping and fixed the bugs.
• Created reusable Worklets involving many tasks.
• Applied Performance Tuning logic at mapping and session level.
• Used Type2 mapping to update a slowly changing dimension table to keep full history.
• Wrote SQL queries for data and report validation.
• Interacted and coordinated with technical and non-technical clients while providing 24/7 production support.

Environment: Informatica 7.1.3, Oracle 9i, SQL, PL/SQL, Windows, UNIX, TOAD, MS Excel

Confidential

Responsibilities:

• Involved in design of database using Entity Relationship Diagrams.
• fWorked with Power Center -Designer tool to develop mappings to extract and load the data from flat files, Oracle.
• Created various transformations like Source Qualifier, Joiner, Update Strategy, Rank, Expressions, Aggregator and Sequence Generator to load data into targets.
• Created reusable transformations and mapplets to use in multiple mappings.
• Created and ran debug sessions in the Debugger to monitor and test the sessions prior to their normal run in the Workflow Manager.
• Tuned Mappings for optimum performance. Applied Performance Tuning logic at mapping and session level
• Extracted, Transformed and Loaded OLTP data into the Staging area and Data Warehouse using Informatica mappings and complex transformations Aggregator, Joiner, Lookup Connected Unconnected , Source Qualifier, Filter, Update Strategy, Router, and Expression .
• Wrote SQL queries for data and report validation in TOAD.
• Generated reports using Hyperion Analyzer.

Environment: Informatica 7.1.1, Oracle 9i, SQL, PL/SQL, TOAD, UNIX.

Confidential

Responsibilities:

• Involved in design, development and maintenance of database for Data warehouse project.
• Designed the ETL processes using Informatica tool to load data from SQL Server, Oracle 9i, Oracle database.
• Imported various Sources, created Targets and Transformations using Informatica Power Center Designer Source analyser, Warehouse developer, Transformation developer, Mapplet designer, and Mapping designer .
• Used transformations like Joiner, Connected, Unconnected lookups, Filter, Aggregator, Rank, Update Strategy, Router, Normalizer, etc.,
• Applied dynamic lookup techniques.
• Extracted data from sources like Oracle 10g and Flat files transformed the data according the business requirement.

Environment: Informatica Power Center 8.1/7.1 Oracle 10g, Repository Manager, Designer, Workflow Monitor,, Business Objects XI, Workflow Manager, Windows XP

Environment: Informatica Power Center 8.1, 7.1.1, Oracle 9i, 10g, SQL, PL/SQL, TOAD, UNIX.