PROFESSIONAL SUMMARY:

• I have over 7+ 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, testing and Implementation of ETL & Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP.
• Involved in complete software development life cycle (SDLC) of the projects and have experience in various domains like HealthCare, Insurance, Banking and Sales.
• Directly work with EPIC system and EPIC date. The main source date from EPIC.
• Validate the data from Clarity’s source to Netezza through Data Validation Option (DVO).
• Extensively used SYSTEM QA methodology for testing data extraction, transformations and loading process, in a corporate-wide-SYSTEM QA Solution using Informatica, and other SYSTEM QA tools.
• ETL testing in Data warehouse implementations ETL methodology using Informatica Power Center 9.6.1/9.1.0/8.6/8.1/7.1 , Oracle 10g/9i/8i and MS SQL SERVER 2005/2000.
• Expertise in Testing complex Business rules by creating mapping and various transformations.
• Experienced with creating Unit Test Cases for mapping and code reviews.
• 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 and Flat Files.
• Expert in writing SQL for validating complex business rules based on ETL mapping document.
• Experience in testing XML files, flat files, others and validating the data loaded to staging tables.
• Extensively used Service Now, Rational Clear Quest, Quality Center for Test Case and defect tracking management.
• Strong Knowledge of Data Warehouse Architecture and Designing Star Schema, Snow flake Schema, FACT and Dimensional Tables, Physical and Logical Data Modeling using Erwin.
• Extensive Experience in writing SQL queries for records & tables.
• 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.
• 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).
• ETL testing on Resourceful, creative problem-solver with proven aptitude to analyze and translate complex customer requirements.
• Experience in various Industry Sectors Such as Banking, Health Care, Finance, Sales.
• 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 9.x/8.x/7.x, Power Exchange, Informatica Data Quality, Repository Server Administrator

Databases: Oracle 11g/10g/9i/8i, DB2, Netezza, Microsoft SQL Server 2000/

Reporting Tools: QlikView 11, Tableau,

Operating System: Windows XP/NT/2000/Linux

Testing Tools: Service Now , Rational Clear Quest, HP Quality Center 10.0, Test Director

Modeling Tools: Erwin Studio

Database utility tool: SQL Developer, Aginity, Toad, SQL server management studio

Automation Tool: Data Validation Option (DVO), Selenium

Programming Language: Core java

Automation Tools: Selenium (Eclipse)

EXPERIENCE SUMMARY:

Confidential, Detroit, Michigan

Data Warehouse Engineer/QA Analyst

Responsibilities:

• Developing test strategy, test cases and test scripts based on design document, requirements, specifications and other documented sources. Ensuring that all requirements, both functional and non-functional, are met.
• Preparation of the various technical and functional documents consisting of High Level and Detailed Design Documentations.
• Create and maintain a robust data warehouse and define, document, and implement quality assurance processes.
• Retrieve, combine, clean, and manage data from multiple sources systems by using Business Intelligent tools and loading data into oracle data warehouse.
• Implementing Validation and Verification of data in Major DB Oracle, using complex SQL queries.
• Performed GAP analysis between Technical STM and Business STM and report and discrepancy.
• Extensively working on both data migration and data transformation testing (Smart To Salesforce).
• Worked with other IT and technology teams including developers and DA to refine technical specifications for test analysis and quality assurance.
• Developed SQL queries using querying tools and SQL and relational database manipulation.
• Extensively used SQL Override function in Source Qualifier Transformation to implement complex business logics at the database level.
• Extensively used Normal Join, Full Outer Join,in the Joiner Transformation for joining relational sources and XML processing.
• Handled Daily and weekly load through Incremental Loading strategy in Informatica.
• Executed ICS jobs which loads data from EDW to Salesforce and set the parameter dates to run a Partition.
• Involved in performing code migrations as part of weekly/Monthly Change request releases.
• Created temp tables in EDW and loaded Salesforce data using Salesforce Dataloader.
• Verified data model using Describe Salesforce tool.
• Understanding of aggregation, capacity planning, data standardization, slowly changing dimensions and data security
• Performed data cleansing, data validation, and mapping as described in the business requirements.
• Performed Integration, Regression, End-to-End, system testing
• Developed PL/SQL Procedures and Functions according to the business requirements for loading data into database tables.
• Preparing documentation for some of the recurring defects and resolutions and business comments for those defects.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping.
• Generated csv file from SQL server tables and copied to local machine using oracle.
• Used Sharepoint extensively for documentation retrieval and uploads.
• Performed User Acceptance Testing (UAT).
• Used Clear Quest for Bug reporting, tracking.
• Conducted various management activities by analyzing and verifying test results, providing status reports.
• Prepared specifications, Unit Test plans, and test cases for the Data warehouse related jobs.
• Created test data for creating delta for testing TYPE 2 and negative scenarios.
• Involved in developing Test Plans, Developed Test Cases, Test Scripts and Prepared Test Data for Extract transform and Load through ETL.
• Tested ETL process (Data Loading, Extraction and transformations) using Informatica.
• Developed Complex SQL queries to query the database and involved in SQL optimization of the queries.
• Created database objects tables, views, materialized views depends on Project requirement
• Prepared SQL Scripts to validate the data in both source and target databases.
• Closely worked with the reporting team to ensure that correct data is presented in the reports.

Environment: ETL (Informatica 10.2.0), Oracle 11g, TOAD 12.10.0.30 , Rational Clear Quest 8.0.1.14, SQL Server 2014, SQL Server Management Studio, Data Loader for Salesforce, Tivoli, Putty

Confidential, Madison, WI

Quality Assurance Analyst/Senior ETL tester

Responsibilities:

• Designed & created Test Cases based on the business requirements and make complete Test Plan.
• Worked with Business Analyst to gather business requirements and Involved in daily/weekly team meetings.
• Communicated and documented test results and defect resolutions during all phases of testing.
• Testing Experienced with creating Netezza External Tables and Views.
• Testing Experienced in writing the Queries with Netezza SQL and Oracle SQL.
• Validate the data from Clarity’s source to Netezza through Data Validation Option (DVO).
• Involved in ETL process testing using Informatica ETL tool(DVO).
• Directly work with EPIC system and EPIC date. The main source date from EPIC.
• 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, BA and Developer teams in improving the processes, methods, effectiveness and efficiency.
• Involved in various project testing in both Agile and Waterfall methodologies.
• Data Quality Analysis to determine cleansing requirements.
• Monitoring CA work Load Automation for object load.
• Used Netezza tools for Querying Database.
• Dealt with slowly changing Dimensions (SCD).
• Participated in walkthrough and defect report meetings periodically.
• Every week status meeting for going on project discussion with QA team, Manager.
• Created ETL test cases for all ETL mapping rules to test the functionality of the Informatica mappings and other ETL Processes (Data Warehouse Testing).
• Documented and reported various bugs during Manual Testing.
• 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 and
• Updated the status of the testing to the QA team, and accomplished tasked for the assigned work to the Project Management team regularly.
• Involved in Unit Testing, System Testing, Integration Testing and User Acceptance Testing of various task.

Environment: ETL (Informatica 9.1.0), Oracle 11g, Data Validation Option for to connect two database(DVO), Aginity for Netezza, Microsoft SQL Server 2008, SQLTools 1.6, Call Logging, ServiceNow, Windows XP Professional, MS Visio.

Confidential, St. Louis, MO

QA Data Analyst

Responsibilities:

• 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.
• Designed & created Test Cases based on the business requirements.
• 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 Rational Clear Quest for open defect and also link defects with requirements.
• Performed all aspects of verification and validation.
• Defined Test Scenarios for the validation SQL and performed manual testing in Quality Center.
• 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 TOAD tools for Querying Database.
• Experienced in Bug Tracking systems and processes using Quality Center.
• Every week status meeting for going on project discussion with Test Lead, Manager, other test team and offshore team.
• Participated in standing meeting every Friday.
• Documented and reported various bugs during Manual Testing.
• 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 fixes the defects and Participated defect report meetings.
• 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 8.6.1), Oracle, DB2, TOAD for Oracle 9.7.2, Toad for DB2 4.5, Defect Tracking Tools (DTS, IBM Rational Clear Quest), HP Quality Center 10.0, Windows XP Professional, Lotus Notes 8.5.3

Confidential

QA/ETL Analyst

Responsibilities:

• 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.
• Designed & created Test Cases based on the business requirements.
• DATA validation using SQL queries and back-end testing
• Responsible for testing all new and existing ETL data warehouse components.
• Experienced at testing ETL's and flat file data transfers.
• Used HP Quality Center to state requirements, business components, test cases, and test runs for every iterations, defects. Also link defects with requirements.
• Performed all aspects of verification and validation
• Worked with other members of the QA and Development teams in improving the processes, methods, effectiveness and efficiency
• Documented and reported various bugs during Manual Testing.
• Worked with SQL queries to validate the data in database (SQL Server, Oracle )
• Updated the status of the testing and defect tracking to the QA team, and accomplished tasked for the assigned work to the Project Management team regularly.

Environment: SQL, Toad, Informatica Power Center 7.1.2, MS SQL server, Oracle 9i, 8i, Windows 2007, Quality Center 9.0