We provide IT Staff Augmentation Services!

Etl Testing And Manual Resume

SUMMARY:

  • 8+ years of experience in IT working with Automation Testing, ETL Testing and Manual Testing projects and currently working at KPMG, Roseland.
  • Leading and coordinating Automation and Manual Testing project activities.
  • Experience working with Risk management (Basel II), Compliance (Actimize) and Volker Rule projects.
  • Extensively worked in automating Data Warehouse project, Actimize Web Application.
  • Proficient in Test Automation using QTP and Selenium Tools.
  • Worked with different software development models such as Agile and Waterfall methodologies.
  • Experience working with ETL testing consisting of Data transformation, sourcing, mapping.
  • Experience working Selenium WebDriver, Junit and TestNG.
  • Automated Qlikview BI reports using Selenium cucumber framework.

TECHNICAL SKILLS:

Automation Tools: QTP 11.53, Excel Macro VB Script, PhpUnit2 Framework

Database: Oracle, Toad for Oracle 10i/9i, SQL Server 2000

Testing Tool: HP ALM 11, Quality Center 11, Oracle Revelus Tool, Business Object, JIRA, Selenium

Documentation Tools: MS - Office, Power point

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

  • Coordinating onsite-offshore testing activities for IEP application.
  • Automating IEP application using Selenium Cucumber framework.
  • Reviewing and developing test cases for IEP application.
  • Performing functional testing, Regression Testing.
  • Logging and tracking bugs using TFS.
  • Writing scripts using element locator, web driver methods, Java programming features and TestNG annotations.
  • Established database connection and using Json files for storing database results.
  • HTML reports are generated for each script.
  • Environment setup using Eclipse, Java, Maven and Selenium web drivers.

Environment: Mobile and IPad, Qlikview, TFS, Selenium, Cucumber Framework, SQL Server 2008

Confidential

Responsibilities:

  • Lead and Develop QTP scripts using Descriptive programming for Fin crime IRIS web application.
  • Leading and coordinating onsite-offshore testing activities for Compliance (Actimize) web-application.
  • Ensure Defects and Test cases are reviewed and executed as per project schedule.
  • Manage releases and ensure overall success of testing process.
  • Participate in project meetings and send Daily status report to clients.
  • Create data driven test with test data set and verified functionality.
  • Maintain and create new shared object repository for automation scripts.
  • Create functional library and reused functions across all scripts.
  • Execute QTP Script from QC.
  • Coordinate Performance testing, Automation Testing activities with team.
  • Develop excel macro for Entitlement and Data masking.
  • Writing and executing SQL queries for different ETL database layers.
  • Business Object Report validation.
  • Perform Data migration testing and writing different SQL.
  • UAT support

Environment: QTP 11.5, QC11, Excel Macro, Toad for Oracle 11, SQL Server 2000, Windows XP

Confidential

Responsibilities:

  • Analyze and understand business requirements.
  • Preparation and execution of test scenario and test cases.
  • Writing and executing test cases in ALM11.
  • Verification of Volker rule reports using Business objects.
  • Adding and tracking defects using JIRA.
  • Participating in daily status call with Client for understanding business requirements.
  • Conducting different types of testing such as System Testing, Regression Testing and Sanity Testing.
  • Peer Review for automation scenarios prepared for different modules.
  • Executing QTP scripts from ALM11.
  • UAT Support

Responsibilities:

  • Analyse and understand business requirements.
  • Preparation and execution of test scenario and test cases.
  • Developed automation tool for validating different source feed with target table.
  • Writing and executing SQL queries using SQL server for different modules at datamart.
  • Adding and tracking defects by using JIRA.
  • Participating in daily status call with Client.
  • Validating source files for different feeds.
  • Validating target tables for different feeds.
  • Comparing different models result based on query with XML generated as well comparing XML generated with XML.
  • Conducting different types of testing such as System Testing, Regression Testing, Database Testing, Sanity Testing.

Environment: QC11, Excel Macro, SQL Server 2000, JIRA, Windows XP

Confidential

Responsibilities:

  • Prepared the Automation Test Plan for Pillar III Report and different modules developed.
  • Leading automation activities and mentoring team members.
  • Leading and coordinating Onsite activities for Pillar III report
  • Automated Pillar III Reports using QTP tool and VB script.
  • Developing and working on huge Automation Framework.
  • Thoroughly analyze each and every test case to be automated.
  • Designed, developed and automated Pillar III Reports using User defined functions, Generic functions with well-versed VB scripting, Descriptive programming in scripting dynamic objects for Interact UI in Quick Test Professional 11.0
  • Creating Functions and Library Files using VB Script to maximize the reusability of scripts.
  • Customized and enhanced the test scripts defining various checkpoints, Synchronization point and reusable functions.
  • Created data driven test with test data set and verified functionality.
  • Maintain and create new shared object repository for automation scripts.
  • Executed the QTP Script from QC and updating the final status in Test lab with attachments.
  • Developing Automation tool for different modules such as Data Load, SCD Process and Data Quality using VB script.
  • Demo and presentation to Client and Onsite Co-coordinator for automation tool developed using VB script and Excel Macro.
  • Preparing and maintaining Input sheets for running different Test cases by automation tool.
  • Used Error handling methods (On Error Resume Next) to handle expected/predicted errors.
  • Writing and executing SQL queries using toad for different modules like Data Load, SCD Process, Data Quality, Asset Categorization and RWA Calculators for different assets for different releases.
  • Running and monitoring different batches from Oracle Revelus Tool.
  • Verification of Pillar III BI Publisher and Drill down reports by comparing data with SQL Queries.
  • Used Descriptive programming to access child objects.
  • Analyzing the failed tests and defects; Comparing DQ failed test cases with DQ Reports generated from OBI Reports.
  • Logging and tracking defects by using ALM 11.
  • Writing SQL queries for generating different report after running RWA Calculator batch and comparing the result with Reports generated from OBI Reports.
  • Conducting and participating in daily status call with Client and Onsite co-coordinator.
  • Preparing Weekly status activity report for the project.

Environment: QC11, Excel Macro, Toad for Oracle 11, Windows XP

Confidential

Responsibilities:

  • Creating and executing test cases manually or by running test cases using automation tool for various mappings assigned for different releases on different databases.
  • Updating various sheets like Estimation base sheet, Data profiling, Regression sheet, E2E balance sheet etc.
  • Input sheet creation for running Test cases by automation tool.
  • Developed automation tool to verify SQL at different database layers using VB script and Excel Macro.
  • Generating Automation test scripts using VB script and performing unit testing on those test scripts.
  • Worked at SIF Layer with different mappings and of different types of products like traded and non-traded assets.
  • Peer Review of Test cases and Test execution.
  • Logging and Tracking defects by using Mercury Quality Centre 9.0 Tool.
  • Used Toad for writing SQL queries of different transformation.
  • Created Excel report using ALM for monthly release report using VB script and Macro.

Environment: QC11, Excel Macro, Toad for Oracle 10

Confidential

Responsibilities:

  • Creating Issue report for various clients.
  • Verifying websites on different versions of software.
  • Verifying, Reporting and Creating Trouble Requests on various modules and builds.
  • Identifying Test Scenarios and Creating Test Plans and Test Scripts.
  • Working on different cases/Hotfixes for various accounts.
  • Conducting GAP analysis by comparing website with live site and creating reports.
  • Testing Templates as per the design checklist.
  • Verifying functionalities using Voyager software for Residential site (Online leasing/ Property Sites/Resident Portal) Commercial and Condo accounts on different builds and releases.
  • Verification of various themes on different test environment.
  • Creation of Checklist document for developer, designer and QA.
  • Involved in Build Verification Testing.
  • Assignment given to QA for various account testing.

Environment: ASP.Net, C#, Fiddler Tool, Windows XP, Excel, MS SQL Server 2005

Confidential

Responsibilities:

  • Corporate Site: It includes features such as Property search, advanced search for property, Fusion map, Floor plans and Unit availability.
  • Property Site: It includes features such as Property Tours and Photo Galleries, Real-time Unit Availability, Floor Plans with Space Planning, HTML/Flash eBrochure, Local maps, Appointment Scheduling, Rental Applications with Credit check.
  • Residential Site: It includes features such as Online Rent payments (Credit cards /ACH), Lease renewals, Work Order tracking, Community Bullein board and Yard sale, Revenue Management, Reservation, Survey and CTM ETL.

Accounts Tested: Greystar, Korman, Nevins, HNN, Alliance, Transglobe, Trinity Residential, StarPoint, BRE and Harward.

Confidential

Responsibilities:

  • To manage whole Test life cycle using Test Director.
  • Functional Testing, Regression Testing, Compatibility Testing, Usability Testing, Module Testing, Integration Testing, Performance Testing
  • Analytics (Report) Testing: Testing of Real-time generated reports by creating various Test Scenarios and verification of various reports created using different calculation.
  • To Coordinate with Business Developer for understanding functional requirements for creating Test Plans and Test Scenarios.
  • Mentoring Junior Test Engineers by giving them Product demo and assigning various assignments.
  • Preparing and Executing Test Cases using various methods of Black Box Testing as per Functional requirement document.
  • Creating Daily Functionality Status report (Enhancement/Customization).
  • Bug reporting and tracking by Mentis Tool.
  • Automating the functionality using QTP and creating Data driven Test Script and various checkpoints using QTP.
  • Involved in shortlisting resumes.

Environment: Mentis, QTP, Test Director, Asp.net

Confidential

Environment: PhpUnit2 Framework, CVS, PhpMyAdmin, Functionality Testing, Usability Testing, Compatibility Testing, MySql

Responsibilities:

  • To initiate Unit Testing by using PhpUnit2 Framework (Automation Tool) and verifying functions of the classes.
  • To Identify Test Scenarios and prepare Test Cases.
  • White Box Testing (Unit Testing) using Phpunit2 Framework.
  • Functionality Testing, Usability Testing and Compatibility Testing.
  • To create Unit Test Reports, User/Usability Reports and User Guide.
  • To coordinate with Project Manager and Test Leads.

Hire Now