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.