SUMMARY

• Over 10 years of excellent IT experience in requirement gathering, data analysis, design, development, Testing and Implementation of Data Warehouses using ETL & Business Intelligence solutions, UNIX, OLAP for multiple domain.
• AWS Cloud Practioner Certified.
• Expertise in understanding Business/Functional/technical requirements and compliance rules.
• Experienced in writing test plans, test cases and test scenarios.
• Complete exposure to all stages of SDLC process with strong skills in writing various test plans, developing, maintaining test cases and test scenarios.
• Excellent Understanding in relational Data modelling, Dimensional data modelling, logical/Physical Design, ER Diagrams, analyzing data sources.
• Experience in testing complex reports generated by Cognos, Business Objects including dashboards, summary reports, master detailed, drill down and score cards.
• Expertise in Data Analysis, Understanding inDimensional Data Modelling, Data Extraction, Transformation& Loading (ETL), Cubes and End User Reports.
• Good Understanding on Star Schema Modelling, Snow - Flake Modelling, FACT and Dimension Tables, Physical and Logical Data Modelling.
• Extensive experience in using SQL, PL/SQL Procedures/Functions, Triggers and Packages for testing purposes.
• Developed Ab Initio test environment for UAT testing and used all Ab Initio components while testing the graphs and ran the jobs on back ground.
• Created ETL test data for all ETL mapping rules to test the functionality of the Ab Initio graphs
• Tested the ETL Ab Initio graphs and other ETL Processes (Data Warehouse Testing)
• Experienced infunctional, integration, regression, compatibility, security, back end, acceptance testing (UAT), and GUI Testing.
• Advanced user in using Test management tools like HP Quality Center/Test Director,JIRA.
• Worked on Oracle 11g/10g/9i/8/7.3, MS SQL Server 2008/2005/2000/7.0/6.5 , IBM DB2 7.1/8.2/v9, Teradata V2R6/R5 databases.
• Prepared and loaded test data in different environments for different testing needs.
• Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within time frame.
• A good team player with excellent written and verbal communication skills.
• Excellent problem solving skills with a strong technical background and good interpersonal skills.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center9,8.5.1(Designer, Workflow Manager, Workflow Monitor,)AbinitioGDE, Data Stage, Control-M.

OLAP Tools: IBM Cognos v9, SAP Business Objects 2010/2008/XIR2, Microstrategy 8.0

Data Modelling: Erwin, Microsoft Visio, Rational Rose (UML), ER Studio

Operating Systems: Windows NT/2000/2003/XP, UNIX, Solaris and MSDOS

Databases: Oracle 11g/10g/9i/8i, SQL Server2008/2005,DB2, MS Access, Teradata V2R5, TOAD DB2, MongoDB

Testing Tools: Rational ClearQuest, Test Director, JIRA, HP ALM & Quality Center 9.0/9.2/10.0 , Doors, QTP Automation. SOAP Web services.

Languages: XML, SQL, PL/SQL, C,C++, VB, Java Script

PROFESSIONAL EXPERIENCE

Confidential

ETL Quality Assurance Analyst

Responsibilities:

• Involved in Regression, Functional, Integration, System Testing and User Acceptance Testing.
• Data Modeling, Data Analysis for OLTP and OLAP systems.
• Participated in analysis of Business and functional requirements.
• Interacted with Business users to determine User requirements and goals.
• Tested of complex mappings using slowly change dimension (SCD) Type I, Type II and Type III involving transformations such as expression, joiner, aggregator, lookup, update strategy, and filter.
• Entered new bugs and maintained the current status of those bugs.
• Responsible for communicating Defect Status Reports to business in project meetings.
• Participated and Organized weekly meetings and walkthroughs to improve the testing efforts.
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.
• Metadata graphs from legacy source system to target database fields and involved in creating Ab Initio DMLs.
• Involved in developing Unix Korn Shell wrappers to run various Ab Initio Scripts
• Responsible for creating the Requirements Traceability Matrix.
• Developed Test Strategy, Test plans and Test scenarios using MS Word and MS Excel.
• Developed Test Cases and Test Scripts for System and UAT Testing.
• Performed Positive and Negative Testing for many scenarios and applications.
• Testing the source and target databases for conformance to specifications.
• Conditional testing of constraints based on the business rules.
• Conducted regression testing on the application under test and Debugging the SQL-Statements and stored procedures.
• Tested the Oracle SQL testing programs and tested the Oracle Applications and Portals like Executive Dashboard, lookup built on Oracle.
• Conducted review sessions on test case and regression test scripts in Quality Center.
• Used Inner and Outer Joins in order to retrieve and validate the Various Transaction Details from multiple tables.
• Verified and maintained Data Quality, Integrity, data completeness, ETL rules, business logic.
• Tested several UNIX Korn Shell scripts for ETL data loading
• Extensively used SQL queries to check storage and accuracy of data in database tables.
• Used SQL for Querying the Oracle database.
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing.
• Tested whether the reports developed in Cognos are as per company standards.
• Tested different detail, summary reports and on demand reports using Report Studio.
• Reported bugs and tracked defects using Quality Center 10.
• Worked with business team to test the reports developed in Cognos.
• Personalized Cognos Connection for specified display options for testing regional options and personal
• Information; Also written several complex SQL queries for validating Cognos Reports.

Environment: Ab Initio CO>OP GDE 3.0.4, Oracle 11g&10g, TOAD DB2,Data Stage, Informatica, UNIX, MDH, Cognos 8.0 Series, XML, Test Matrix, Control-M, HP ALM, IBM Clear Quest.

Confidential

Sr.QA /ETL Analyst

Responsibilities:

• Involved in reviewing/analyzing Business Requirement Documents/Functional specifications/use cases.
• Worked with Business Analysts, developers while reviewing the Business Requirement Documents and when there are enhancements in the applications.
• Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.
• 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
• Peer reviewed test cases developed by QA team members and advice/point/discuss possible complex scenarios and make sure requirements are completely covered.
• Supported and provided test cases for UAT, staging and production Participated in review meetings and attended training sessions to understand various business concepts.
• Exported Requirements, test plans and test cases to QC 9.2.
• Created Traceability Matrix to ensure that all requirements are covered in test cases.
• Develop Risk-based Test Strategy whenever required, to save time and to determine which test activities to carry out and created complexity matrices.
• Involved in UAT process before rolling out to production when required. Participated in debugging prod issues along with support team.
• Worked in Agile methodology during application development and participated in daily scrum meetings.
• Developed user defined functions, created objects where required and used descriptive programing to automate.
• Tested Ab Initio graphs and used Ab Initio as an ETL tool to load the final loads.
• Tested several data validation graphs developed in Ab Initio environment.
• Tested graphs for extracting, cleansing, transforming, integrating, and loading data using Ab Initio ETL Tool.
• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting Test cases, Test Scripts in Quality Center 9.2
• Created defects, manage defect reports and defect status in Clear Quest tool
• Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.
• Developed and ExecutedSQL statementsinToadto retrieve data and to validate data.
• Tested data migration to ensure that integrity of data was not compromised.
• Validated the data thru various stages of data movement from staging to Data Mart to Data Warehouse tables.
• Responsible for documentation of test results, test matrix,andparticipated in daily/weekly QA meetings.
• Conducted down test and up test for release builds pushed to UAT and to Production.

Environment: Informatica PowerCenter,Oracle 10g,MS SQL,HP Quality Center 9.2,TOAD, Business Objects, MS Excel, MS Project, Control-M, Cognos and IBM Clear Quest.

Confidential

Sr. QA Analyst/ETL Test Analyst

Responsibilities:

• Analyzed the Business requirements and developed Test cases based on functional requirements, general requirements and system specifications.
• Prepared test data for positive and negative test scenarios for Functional Testing as documented in the test plan.
• Exclusively involved in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Quality Center.
• 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.
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Tested to verify that all data were synchronized after the data is troubleshoot and also used SQL to verify/validate my test cases.
• Testing the ETL data movement from Oracle Data mart to Teradata Data mart on an Incremental and full load basis.
• Wrote SQL queries to validate source data versus data in the data warehouse including identification of duplicate records.
• Tested whether the reports developed in Business Objects and Crystal Report is as per company standards.
• Tested Ad-hoc reports, drill down and drill through reports using Business Objects.
• Tested different detail, summary reports and on demand reports.
• Involved in pre and post session migration planning for optimizing data load performance.
• Interfaced with the Portfolio Management and Global Asset Management Groups to define reporting requirements and project plan for intranet applications for Fixed Income and Equities.

Environment: Informatica PowerCenter8.6, MS SQL 2000, Oracle 9i, SQL, PL/SQL, Windows XP and 2000,Business Objects, Crystal Reports, Quality Center.

Confidential

Data warehousing Tester

Responsibilities:

• Analyzed business rules to generate consolidated (fact/summary) data identified by dimensions using Informatica ETL (Power Center) tool.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository manager.
• Scheduled sessions and Batch process based on demand, run on time, run only once using Informatica server manager.
• Written Test Cases to cover overall quality assurance testing.
• Performed manual testing on different modules of the application.
• Performed data integrity testing by executing SQL statements and manually verifying the contents.
• Used SQL to perform Backend Testing on databases.
• Involvedin supporting the deployment of data marts and reports.
• Performed manual testing prior to automate testing on the application.
• Scheduled and monitored transformation processes using Informatica Server Manager.
• Prepared Test status reports for each stage and logged any unresolved issues into Issues log.
• Prepared Test Plan from the Business Requirements, detected defects, tracked and reported bugs using Test Director.
• Involved in writing testing methodology by following standards for test documentation, test requirements and test procedures.

Environment: Informatica Power Center, Oracle 9i, PL/SQL, SQL*Loader, XML, XSLT, XSD, MVS, SQL, PL/SQL, HTML, Windows NT/2000