SUMMARY:

• 9 - years of IT experience in the Analysis and Testing of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications, Web-based applications, and Financial applications.
• QA experience in all phases of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of QA methodologies, disciplines, tasks, resources and documenting.
• Excellent experience on Capital Market, Securities, Liquidity Charge, Credit Risk, CRM and IRB,
• Exceptional ability to maintain and build client relationships, interact one on one with clients, business stakeholders and converse with all Facets in the clients organization.
• Experience in Integration, Functional, System, Regression, SIT, Black Box, White Box and User Acceptance Testing (UAT).
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification.
• Experience on working with HPQC (Quality Center), Rational Tools - Rational Clear Quest, Rational Clear Case, Rational Requisite Pro and DOORS.
• Extensive experience in developing Test Plans, Test Scenarios, Test Strategies, Test Cases, Test Reports.
• Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
• Solid Back End Testing experience by writing and executing SQL Queries.
• Have solid experience on database query tools such as TOAD, SQL Navigator, Teradata SQL Assistant, Rapid SQL, and SQL Plus.
• Experience is testing the Reports for data validation and cosmetic content.
• Good Experience in testing Initial (Reconcile) and Daily (Delta) ETL loads.
• Experience working in UNIX environment and good at file management using VI editor.
• Experience in maintaining the test environments; involved in requesting the deployments, requesting data loads, data base backups, restarting the servers, troubleshooting issues.
• Extensively worked with batch scheduling tools Autosys, Control M to run and monitor the ETL and batch jobs.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL

RDBMS: Oracle 11g/10g, DB2, Teradata, SQL Server 2005/2008

Operating Systems: Microsoft Windows 98/XP, Linux, UNIX

RDMS Query Tools: TOAD, SQL Assistant, SQL Navigator, SQL Server

Test Management Tools: HP Quality Center, ALM

Defect Tracking Tools: JIRA Rational Clear Quest, HP Quality Center

Incident Mgmt. Tools: BMC Remedy

Scheduling Tools: Autosys, Control-M

Reporting Tools: Crystal Reports, Cognos, BOXI, SSRS, Micro Strategy

Test Documentation: Test Plan, Test Summary Reports, Bug Reports

PROFESSIONAL EXPERIENCE:

Confidential, Herndon, VA

ETL Tester/ QA Analyst

Responsibilities:

• Responsible for creating Test Plan, development of test scripts (Gherkin format), execution and validate test results and document test evidence, creating production shutout document.
• Executed test cases, and test scenarios for User Acceptance (UAT), Functional and Regression test cases.
• Reviewed unit test cases and test results and certified the code for integration testing
• Created user acceptance testing documents and reviewed them with the customer.
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
• Mapped test cases to requirements using quality center
• Involved in entering and tracking defects using JIRA.
• Creating Agile testing document, RTM (Risk traceability matrix)
• Involved in testing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL.
• Conducted reviews of test plans, test cases, and prepared test results.
• Effectively communicate testing activities and findings in oral and written formats.
• Validated business objects reports for data and lay out.
• Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.
• Created Test input requirements and prepared the test data for back end testing.
• Provided status reports on test execution, and defects identified during testing.
• Written complex SQL queries for data validation for verifying the ETL Mapping Rules.
• Involved in maintaining the test environments; with activities like requesting data loads, data base backups, restarting the servers, requesting the deployments, troubleshooting issues.
• Used Toad to run SQL queries and validate the data loaded in to the target tables.
• Involved in Functional Testing, Regression Testing, Sanity Testing, Ad-hoc Testing and User Acceptance Testing.
• Created and executed Test cases in Soap UI to validate web services.
• Tested Ab Initio graphs with both positive and negative scenarios.
• Responsible for testing Initial and daily loads of ETL workflows.
• Exclusively involved in execution of Autosys jobs, PL/SQL batch programs and responsible for reporting the defects to development team.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Written several complex SQL queries for validating Business Objects Reports.
• Created Test input requirements and prepared the test data for Data Driven testing.
• Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.

Environment: Oracle 12c, Toad, DB2, SQL, PL/SQL, Rally, JIRA, ALM, MS Visio, JMS Channel, Soap UI Windows, TIBCO BE, TIBCO BW, UNIX.

Confidential, Philadelphia, PA

DWH ETL UAT QA Tester

Responsibilities:

• Developed complex SQL queries to test ETL jobs from source to target Data Warehouse (DWH)
• Involved in defining Test Scenarios for the applications and performed manual testing in HP Quality Center.
• Created and executed different types of test cases for the Change Request and existing functionality of the application.
• Responsible for checking data in database by writing and executing SQL statements.
• Involved in meetings with Automation team for Development of Automation Scripts for Change requests to run along with regression tests suites of business priorities.
• Written Test scenario, Test result, Reported bugs and tracked defects using ALM and JIRA
• Performed all aspects of verification, validation including functional, regression, and system testing.
• Expertise in testing SSRS reports.
• Used Teradata SQL Assistant and SQL server to run SQL queries and validate the data loaded into the target tables.
• Involved in Functional Testing, Regression Testing, and Smoke testing.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Involved in integration testing to validate the interface commitment data Underlying loans.
• Involved UAT/GUI testing and validated in Acquisition inbound and outbound related to the loans.
• Actively involved in design and development of test plans based on high-level documents (BRD & FRS).
• Work on prioritizing the requirements as per the Business.
• Execute the MS Access GUI - Job on Demand and lender listing.
• Good experience in writing and implementing the Test plan, Test cases, Test Procedures, Test sets using Use cases and requirement specifications.
• Analyzed customer and business needs to determine business and functional requirements.
• Participated in functional requirement reviews and code reviews.
• Extensively worked with data mapping document to understand the transformation rules.
• Worked with Business Analyst and Developer to resolve the defects.
• Analyzed and optimized the use cases and created the Test cases based on them for Change Requests.
• Executed all Test cases in different phases of testing like Smoke, Regression and System testing of the application.
• Validated the Informatica workflows according to business requirement documents.
• Used Informatica workflow monitor to run the workflow and verify their status and logs.
• Validated the Data Warehouse (DWH) Table structure as a part of ETL testing
• Executed batch processing and verify the ETL jobs status and data in database tables
• Involved in backend testing using UNIX commands.
• Also involved in testing various kinds of reports and also validate the data in the reports with the data in the database.
• Work with XMLs, WSDLs, Web Services and Client/Server messaging as required and also tested the request and response using the SOAP UI tool.
• Validated the web services using Soap UI.
• Extensively involved in testing the application developed in Agile Methodology and detailed designs.

Environment: SQL Server, Teradata, HP Quality Center, ALM, JIRA, Facets, HIPAA, SQL, SQL Server, .Net,Batch Jobs, Shell Scripting, Autosys, Rational Requisite Pro, OBIEE, Netezza, Web Services, Soap UI, UNIX, Web Logic, WINSQL, Remedy, Putty

Confidential, Boston, MA

DWH | ETL | BI QA Analyst

Responsibilities:

• Participated in various meeting like project kick-off, project planning, weekly & monthly client status meetings,
• Extensively involved in writing and reviewing the test scripts.
• Experienced in gathering Functional Requirements, Business Requirements and Design Documents.
• Developed detailed Test Cases based on the Functional Requirements and Design Documents.
• Identified the test data to execute the test cases.
• Wrote complex SQL Queries in Teradata using mapping documents and PDM (Physical Data Model)
• Reported bugs and tracked defects using Quality Center.
• Developed the Test Scripts and Test Cases in Quality Center.
• Error handling and performance tuning in Teradata queries and utilities.
• Data reconciliation in various source systems and in Teradata.
• Performed Functionality, Negative, Security, GUI, Integration, System and Database testing.
• Involved in testing the Data stage jobs, by validating whether the mapping adhere to the development standards and naming conventions; whether the mapping do what the technical design says it should do; whether the mapping work correctly in relation to other processes in your data logistical flow.
• Focused more on automating the test cases and reduce manual effort. Hands on expertise in Test Planning, Design, Execution, Scheduling and Reporting for Web and Mainframe applications. Very good at onsite- offshore coordination skills.
• Experience on Capital Market, Investment Management domain
• Validated OBIEE Reports in the Dashboards for the Oracle Financial Analytics modules like GL, AP, AR and created the Ad-hoc report according to the client needs.
• Tested Cascading Prompts and Multi-Level Prompts on Dashboards.
• Identified issues, performance bottlenecks, and optimized the Business Intelligence Dashboards and Reports.
• Validated different kinds of reports (pivots, charts, tabular) using global and local Filters.
• Extensively worked on RPD and Dashboards.
• Validated Query Prompts as, Cascading Prompts, Calculations, Conditions & Filters
• Experienced using database query and integration tools such as TOAD, SQL plus etc.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Extensively used SQL to verify and validate the data loaded into Target
• Submitted weekly bug or issue report updates to the Project Manager in the form of the QA Error Log.
• Preparing test data and supporting the QA test environments

Environment: Data Stage, Oracle, Quality Center, C#, SQL Server 2008, SQL Developer, Teradata, OBIEE, XML, PL/SQL, SQL, WinSCP, Putty, TFS, UNIX, Toad, SharePoint, OBIEE, SSRS.

Confidential, Phoenix, AZ

DWH | ETL | BI QA Analyst

Responsibilities:

• Created new projects in Soap UI to validate the web services.
• Worked with regulatory compliance data and did testing for web interface modules for exchanging the data feeds between the systems.
• Performed Negative testing using Ab-Initio GDE to find how the functions and variables perform when it encounters invalid and unexpected values.
• Used Rational Clear Quest for the bug tracking and Rational Quality Manager for Test Case Management.
• Used Rational Requisite Pro for requirement management.
• 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
• Responsible for Data mapping testing by writing complex SQL Queries using WINSQL
• Validating the data passed to downstream systems.
• Involved in testing data mapping and conversion in a server based data warehouse.
• Involved in validating inbound and outbound batch processes.
• Validated OBIEE Reports in the Dashboards for the Oracle Financial Analytics modules like GL, AP, AR and created the Ad-hoc report according to the client needs.
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Assist in the maintenance of technical and non-technical SDLC documentation.
• Creation of SDLC documentation, including User Requirements, Technical Specifications, and Test Cases.
• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.
• Involved in understanding Logical and Physical Data model using Erwin Tool.
• Worked on Autosys for Batch Processing ETL, PL/SQL subprograms and performed backend testing.
• 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.
• Involved in extensive testing of batch processing for positive and negative scenarios.
• Involved in testing the UI screens, reports which was used by the internal business team.
• Extensively tested the Cognos reports for data accuracy and static errors
• Tested Ab Initio graphs with both positive and negative scenarios.
• Responsible to test the functionality of Ab Initio graphs.
• Responsible for testing Initial and daily loads of ETL jobs.
• Written Shell scripts to run the Ab Initio developed jobs (.ksh) and Automated the ETL process through scheduling and exception routines.
• Participated in developing the file management and ftp process for transmitting the files, also scheduled the daily batch process.

Environment: Ab Initio 2.13, Facets, HIPAA, SQL, SQL Server 2008/2005, .Net, SSIS, Rational Clear Quest, Cognos 8, Autosys, Rational Requisite Pro, OBIEE, XML, XSLT, IBM AIX 5.3, Netezza, Web Services, Soap UI, UNIX.

Confidential, Bloomington, IL

DW/ ETL UAT BI Tester/Data Analyst

Responsibilities:

• Coordinated with the release manager/DBAs for deploying right application build into the Testing as well as Development environment.
• Prepared test data for positive and negative test scenarios for Functional Testing as documented in the test plan.
• Prepared Test Cases and Test Plans for the mappings developed through the ETL tool from the requirements.
• End to end testing of Guidewire Insurance Suite 7.0 (Policy, Billing & Claims), P&C, and Supporting DWH and Business Intelligence Solutions.
• Integration testing between the systems (Policy, Billing & Claims) to create test data/scenarios for ETL, BI and UAT Testing manually as well as by employing UFT.
• Extensively used Informatica Workflow Manager to run the workflows/mappings and monitored the session logs in Informatica Workflow Monitor.
• Verified session logs to identify the errors occurred during the ETL execution.
• Created Test Cases, traceability matrix based on mapping document and requirements.
• Performed complex data validation using SQL queries.
• Verified the logs to identify the errors occurred during the ETL execution.
• Involved in testing SSIS Packages, and in Data Migration.
• Worked in agile to create, maintain and execute test cases while participating in the validation of functional and non-functional requirements in an agile development environment.
• Actively provided inputs for agile retrospective to improve the process.
• Worked in agile methodology to perform manual exploratory and acceptance testing of new features being iteratively developed
• Written several complex SQL queries for data verification and data quality checks.
• Reviewed the test cases written based on the Change Request document and Testing has been done based on Change Requests and Defect Requests.
• Tested the Informatica mappings and other ETL Processes (DW Testing).
• Used Team Foundation Server as a test management tool for preparing test cases and executing them.
• Prepared Mock data based for covering all the scenarios on the different test cases.
• Analyzed the Requirements from the client and developed Test cases based on functional requirements, general requirements and system specifications.
• Experienced business analyst specializing in requirements analysis and SDLC documentation in Waterfall, Agile and Scrum methodologies.
• Have tested reconcile and incremental ETL loads for the project.
• Scheduled shell script jobs, creating instances of jobs, verifying logs according to client requirement using Autosys server.
• Written Shell scripts to run Informatica mapping jobs.
• Written Shell scripts to handle data before executing Informatica Maps and to meet pre-requirements to run the Maps.
• Tested data migration to ensure that integrity of data was not compromised.
• Wrote complex SQL queries for extracting data from multiple tables and multiple databases.
• Used Rational Clear Quest as defect tracking tool.
• Validated various SSIS and SSRS packages according to the functional requirements.
• Worked on application integration testing in SOA Architecture and validated the SOAP based web services.
• Validated OBIEE Reports in the Dashboards for the Oracle Financial Analytics modules like GL, AP, AR and created the Ad-hoc report according to the client needs.
• Tested Cascading Prompts and Multi Level Prompts on Dashboards.
• Identified issues, performance bottlenecks, and optimized the Business Intelligence Dashboards and Reports.
• Passed the various requests for web services in Soap UI and validated the responses.
• Validated different kinds of reports (pivots, charts, tabular) using global and local Filters.
• Developed UNIX Shell Scripts for scheduling various data cleansing scripts and loading process.

Environment: Informatica Power Center, Informatica Data Validation Option (DVO), OBIEE, SQL, PL/SQL, UNIX, TFS, WinSCP, Oracle 10g, MS Visual Studio, HP Quality Center, Autosys, SQL Server 2008, and TOAD

Confidential, Winston-Salem, NC

QA Web based Tester

Responsibilities:

• Responsible for daily generation and analysis and reporting of Asset & Liability report (ALCO), working closely with Market Risk, Credit Risk and Treasury to provide liquidity reports, Stress Testing analysis, Value at Risk and sensitivity analysis.
• Supported Risk and Treasury on working capital management, and market risk analysis.
• Written Test Plans, Test Strategy, Test Script, Test Cases, Reported bugs and tracked defects using Quality Center
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing.
• Analyzed the business requirements, system requirements, and data mapping requirement specifications, interacting with client, developers and QA team.
• Written complex SQL queries for data validation for verifying the ETL Mapping Rules.
• Tested Metadata of tables including the data types, constraints and default values on the columns.
• Involved in maintaining the test environments; with activities like requesting data loads, data base backups, restarting the servers, requesting the deployments, troubleshooting issues.
• Used Toad to run SQL queries and validate the data loaded in to the target tables.
• Involved in user training sessions and assisting in UAT (User Acceptance Testing).
• Involved in Functional Testing, Regression Testing, Sanity Testing, Ad-hoc Testing and User Acceptance Testing.
• Created and executed Test cases in Soap UI to validate web services.
• Tested Ab Initio graphs with both positive and negative scenarios.
• Responsible to test the functionality of Informatica workflows.
• Responsible for testing Initial and daily loads of ETL workflows.
• Exclusively involved in execution of Autosys jobs, PL/SQL batch programs and responsible for reporting the defects to development team.
• Scheduling shell script jobs, creating instances of jobs, verifying logs according to client requirement using Autosys server
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Written several complex SQL queries for validating Business Objects Reports.
• Created Test input requirements and prepared the test data for Data Driven testing.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Tested whether the reports developed in Micro Strategy are as per company standards.

Environment: Informatica 8.1, Oracle 9i, SQL Server, HP Quality Center, SQL, TOAD, PL/SQL, DB2, Business Objects XI, Micro Strategy, Autosys, Web Services, Soap UI, Shell Scripting, Windows XP, TIBCO, Putty, UNIX