We provide IT Staff Augmentation Services!

Sr.database Testing Consultant Resume

Hockessin, DE

SUMMARY:

  • Over 12 years of IT experience in various phases of IT projects such as Development, Testing, deployment and application support. Hands on experience with all phases of Software Testing Life Cycle (STLC)
  • Have the ability to elicit, understand and articulate business requirements and perform detailed analysis to map them to functional QA requirements.
  • Experience in testing Data Marts, Data Warehouse/ETL Applications developed in Informatica, Ab Initio and Data stage using Oracle, DB2, Teradata and UNIX.
  • Strong experience in testing Data Warehouse (ETL) and Business Intelligence (BI) applications.
  • Expertise in creating Test plan documents and Test strategy documents. Expertise in designing the test scenarios and scripting the test cases in order to test the application. Good exposure with databases like Oracle 11g, DB2, SQL Server 2008
  • Performed System Testing, Regression Testing, Performance Testing, end - end testing and Production Smoke Test. Implemented XSLT style sheet language for XML
  • Strong experience with ETL systems, and having expertise with tools Informatica and Data stage.
  • Strong experience in testing Data Warehouse (ETL) and Business Intelligence (BI) applications.
  • Strong experience in Data Analysis, Data Validation, Data Profiling, Data Verification, Data Loading.
  • Experience in Dimensional Data Modeling using Star and Snow Flake Schema
  • Strong working experience in the Data Analysis and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL). Strong experience in script developing for QTP using VB script.
  • Experience in maintaining Full and Incremental loads through ETL tools on different environments..
  • Experienced in Defect Management using Mercury Test Director, HP Quality Center
  • Good experience in writing SQL in order to data validation in migration as part of backend testing
  • Worked with different data sources ranging from VSAM files, flat files, DB2, oracle and SQL Server databases.
  • Experience in debugging the issues by analyzing the SQL queries.
  • Good experience in working with UNIX scripts in executing and validating logs for the issues.
  • Experience with testing reporting tools (Cognos/Business Objects).
  • Good knowledge in Healthcare modules like Member Enrollment, Eligibility Check, Claims, Billing and Policy Issuance. Created defect reports in Excel file by exporting the data from Quality Center.
  • Hands on experience in writing SQL queries, Joins, Functions, Procedures, Packages, DBMS, RDBMS, and Triggers in Oracle and SQL Server databases. Good expertise in using TOAD, SQL*Plus and Query Analyzer.
  • Strong experience in UNIX shell scripting, writing UNIX wrapper scripts and monitoring the UNIX logs to check for any errors.
  • Write, execute and troubleshoot test scripts in QTP.
  • Created the test instances for the project in the Test Lab and Test Plan module of Quality Center.
  • Have tested several complex reports generated by Business Intelligence tools Cognos, Business Objects BOXI, Micro Strategy including dashboards, summary reports, master detailed, drill down and score cards.
  • Excellent understanding of Relational Database Management System (RDBMS)
  • Used XSLT for document is transformed into another XML document that uses the formatting vocabulary
  • Designed the Data Driven tests in Quick Test Professional (QTP) script to validate with different sets of test data.
  • Hand on experience in testing the ETL process using ODI (Oracle Data Integrator), Informatica and reporting and analysis tools such Business object, Oracle OBIEE, Hyperion.

WORK EXPERIENCE:

Sr.Database Testing Consultant

Confidential, Hockessin, DE

Responsibilities:

  • Focal point for requirements analysis and system testing of the module price engine.
  • Responsible for development of the test plan and test report documentation as per the requirements of various pricing models.
  • Involved in the design sessions with the architects and senior developers to understand the complex data models.
  • Execute the ETL jobs in QA environment to load data from files to the database tables and validate the data load as per requirements.
  • Supported demonstrations/walkthroughs of the application to the offshore team to make them understand the requirements and complete the work on time.
  • Worked closely with the development team to resolve the defects.
  • Provided software requirements and testing technical experience in the form of writing requirement specifications, test plans and procedures, test execution and defect tracking for multiple projects.
  • Experienced in writing complex SQL queries, PL SQL Anonymous blocks, Stored Procedures and triggers.
  • Performed regression testing after the bug fixes.

Sr. Database Testing Consultant

Confidential, Fort Lauderdale, FL

Responsibilities:

  • Analyzed the Functional/Technical specifications provided by the system analysts and converted them into test cases/test plans.
  • Involved in the design meetings with architects/developers to understand the functionality of the payment portal application.
  • Coordinated with the development team and system analysis team throughout various testing phases like system testing, Integration testing, Volume testing etc.
  • Involved in GUI, Functional testing of the Web application that is built in ASP.Net and Oracle database.
  • Created and debugged complex ETL processes using T-SQL queries, functions, stored procedures.
  • Extensive experience in understanding the existing SQL modules and modify them according to the requirements.
  • Experienced in writing Anonymous blocks, Stored Procedures, triggers.
  • Experience in writing Views with complex joins with multiple tables and use them for reading the data to perform various test cases.
  • Experienced in performance tuning of complex SQL queries.
  • Involved in testing the ETL processes (written in PL/SQL) that brings the source data from Siebel CRM system to Payment portal database.
  • Developed complex SQL queries to validate the data that is written into the database after performing various test scenarios as per the functional requirements.
  • Assist in designing physical data structures to support application's requirements
  • Developed Oracle PL/SQL anonymous blocks to test the stored procedures.
  • Developed the test scripts, test cases for both backend and front end test scenarios.
  • Coordinated with the sales and finance teams to understand the functionality of the payment portal.
  • Created database Views joining multiple tables and used these views in the regression testing to verify the data.
  • Reported the issues found during the testing to the system analysts.
  • Performed regression testing after the bug fixes.

Environment: s: Oracle SQL Developer, Toad for Oracle, SQL Server 2000, SSMS, SQL, PL SQL, Siebel CRM, Lawson.

QA Analyst/ ETL Tester

Confidential, Fort Lauderdale, FL

Responsibilities:

  • Reviewing Business Requirement Documents and the Technical Specification.
  • Documented test cases corresponding to business rules and other operating conditions.
  • Written tractability matrices based on use cases and business requirements documents (BRDs) using HP Quality Center/ALM as QA Status Report, QA Summary Reports, QA Test Logs.
  • Set up a QA process and ensured it was effective project wide.
  • Documented test cases corresponding to business rules and other operating conditions.
  • Created Test Input Data Requirements and prepared the test data for data driven testing.
  • Created complex SQL, triggers, PL SQL stored procedures, T-SQL queries and UNIX scripts to perform data validation testing; also utilized ETL, EDI, OLAP, and flat files for data profiling and data validation testing.
  • Extensively used UNIX VI editor to create/modify/view the files on the server.
  • Verify that data is transformed correctly according to various business requirements and rules.
  • Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping
  • Performed negative testing by entering improper data to make sure appropriate error messages are displayed.
  • Validated the Report GUI for Report testing and Functional testing of the reports by looking against the data displayed in data mart and reports.
  • Involved in detail testing of Fact Tables, Dim Tables and validated the load Data in the Tables and XML messages.
  • Addressing customer queries and solving the issues in the automation process.
  • Created and executed Test scripts to verify complex system requirements.
  • Reported the failed test cases, tracked the defects and verified the fixes in multiple environments.
  • Work with development, users and support groups to understand the application architecture, use and current production issues to simulate the best possible real time scenarios for load and stress testing.
  • Defining the test scenarios and making sure that scripts are working according to planned scenario.
  • Used Quality center to log defects and generate defect reports and graphs.
  • Attending meetings with other groups and explain performance objective, strategy and progress.

Environment: s: Windows, UNIX, Oracle SQL Developer, Toad for Oracle, SQL Server 2000/2005, SSMS, Oracle Forms/Reports, ASP.Net, Oracle Financials 11i.

Testing Consultant

Confidential

Responsibilities:

  • Analyzed the functional requirements and created test cases in QC in Web applications testing.
  • Experience in functional requirements and application development and test cases on that Creating automation script using Automation scripting in QTP 10 with database.
  • Experience in working with to that extent, we have the technology to provide check imaging, and create web based portal of the UI by-phone services in ETL tool.
  • Expert in working with creating prototypes with iPad, iPhone, iTouch application in agile methodology.
  • Experience in Mobile Life store UI the customer can select the accessory items from web site and pay by, debit cards an extensive different way of transaction.
  • Assist Business Analysts in requirement review meeting and giving feedback JAD session and assisted in Design test case, test data and test automation in ETL tools.
  • Conducted Regression testing, Integration testing, and User Acceptance testing for various combinations using Manual and automated scripts.
  • Conducted load and stress testing on Load Runner in efficient/semi-automated database testing.
  • Wrote SQL queries on OBIEE to perform Back End Testing and using Putty for UNIX scripting.
  • Enhanced Test cases in QTP as per the new functional requirements for ALM.
  • Performed Load, Performance and Stress testing in Load Runner on Consumer electronics test.
  • Developed, enhanced, and maintained automated testing scripts with Quick Test Pro using Automation Framework.
  • Developed test cases based on business and functional requirement in Framework and device testing.
  • Applied check points in the Plsql skills in writing complex query with developer on Consumer electronics test.
  • Performed Parameterization using Data Driver in VB Script for Quick test Pro.
  • Performed Descriptive Programming to build keyword driven framework tracked and managed on Jira.
  • Performed Multiple Actions depending on the requirements in LOAD UI on database.
  • Maintaining status reports and communicating with the Management on progress of work.
  • All the issues that came up during this process were logged in Defect Tracker as Defects.

Testing Consultant

Confidential, Indianapolis, IN

Responsibilities:

  • Analyzed the objectives and scope of each stage of testing process from the test plan on web based application.
  • Involved in analyzing the applications and development of test cases.
  • Serve as Property & Casualty Insurance SME, reporting to the President, addressing various Insurance industry issues as they arise and the point person for the development and adoption of the ACORD xml standards.
  • Used test director for running automated and manual tests and for defect reporting automation scripting.
  • Involved in generating Test cases for property and casualty Insurances for Different Levels of Business
  • Analysis of business requirements and system requirements of the client and also for Property and casualty modules on guide wire.
  • Writing user stories for Business Process Flow, System Integration Testing based on the Configuration requirements of Guidewire Policy Center for Personal Auto LOB.
  • Analyzed test cases for automation and used UFT 11.5(Unified Functional Testing), Quick Test Professional (QTP) to automate manual test scripts for Regression and Functional testing.
  • Worked on Property and Auto products using Guidewire Application.
  • Developed and maintained Service Oriented Architecture (SOA) governance process costing models and metrics ensuring architecture compliance in function of code.
  • Test plan and developed test cases based on technical specifications and business requirements.
  • Extensive knowledge of object oriented analysis using UML and MS-Visio.
  • Expert in test plan, Test cases, and executing test cases manually and recording results in logs.
  • Involved in preparing test cases from functionality requirement docs, involved in client and developer meetings to hammer out the functionality and requirements on data integrity standards.
  • Used check points, outputs vales, recover scenarios, object repository administration extensively in QTP
  • Used VBScript heavily for writing the automation test scripts and solved in High severity defect.
  • Used database checkpoints in QTP for database testing
  • Used reporter object in QTP for reporting test results in function of code.
  • Creation of automated test scripts in QTP for the regression and smoke test efforts in agile methodology.
  • Enhancements and debugging the automated test VB scripts in QTP in efficient/semi-automated testing.
  • Analyzed reviewed business requirements and functional specifications of the application.
  • Involved in the design, development of various modules and generation of reports.
  • Acting as key team player and leading seven people in offshore and onsite on Jira.

Environment: s: Windows, UNIX, Oracle SQL Developer, QTP, UFT 11.5, Jira

Hire Now