PROFESSIONAL SUMMARY

• 9.5 years of experience in Testing RADIAN Mortgage Applications,Banking Applications, AMEX Credit Card Applications,Tax Financial Applications using Datawarehouse-BI SSIS/SSRS , Mainframes Web.
• Excellent experience in ETL Testing for around 2 years.
• Good experience in Web based Testing.
• Hands on experience in COBOL, JCL , CICS, ISPF/PDF, File-Aid, INSYNC,SQL
• Lots of client interaction exposure.
• CSTE Certified, HP : QC and QTP Certified
• Work effectively independent or as part of team.
• Good experience in Agile Methodology and handling Scrums
• Extensive experience in manual functional testing using BI SSIS/SSRS , Mainframes and also in web technologies.
• Awarded the ARP of the Quarter ARP of the Month multiple times in my tenure at ADP and received many E-Recognitions from client in the following categories Team work, Client Focus, Solutions and Responsiveness.
• Awarded High Flyer of the Month Most Valuable Performer at CTS.
• Awarded Star of the Quarter at Alliance Global Services in the 2nd quarter of joining itself.
• Expertise in Project Reviews Audits, Metrics Management, Estimation, and Change Management, working and communicating with project teams situated in various geographic locations.
• Proactive and analytical problem solver with strong leadership skills.
• Strong knowledge with Testing process and methodology including defect-tracking

Involved in Recruitment as an interviewer.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

ETL QA Test Lead

Radian ERS Enterprise Reporting Services

• Description: Radian helps promote and preserve the tradition of home ownership while protecting lenders from default-related losses on residential first mortgages. It also facilitates the sale of low-down payment mortgages in the secondary market. Their commitment to home ownership is built on a foundation of evaluating credit risk. Radian helps clients and investors expertly and prudently manage risk in any market condition. Radian Group Inc. is traded on the New York Stock Exchange under the symbol RDN.
• Module: Radian ERS Enterprise Reporting Services module is to migrate the data from existing systems consisting of Oracle and SQL databases and generate reports in SSRS

Responsibilities

• Understanding the Mapping Documents for Datawarehouse ETL Projects and Requirements for Reporting
• Developing Test Strategy and Plan including Estimations based on the Scope
• Creating Test Cases to ensure Extract,Transform,Load,Error Handling,Surrogates,Reports, Email distributions
• Creating SQL Queries to validate the mentioned Test Cases
• Involved in Functional,Regression,Negative,Error and End to End testing of the project
• Defect management and Bug Reporting
• Client communication
• Handling Scrums in Agile environment,Task assignments to team and Status updates to the higher management

Environment: SQL, BI SSIS/SSRS , ORACLE, MS Access, SSIS Frame Work, StarTeam, JIRA, QC , INFORMATICA and WEB PAGES.

Confidential

Description: OFAC is the Office of Foreign Assets Control which administers and enforces Economic and Trade Sanctions based on US Foreign policy and National Security Goals against targeted Foreign countries and Regimes. As part of this, OFAC publishes a list of individuals and companies owned or controlled by or acting for on behalf of Targeted countries. As part of Santander Brazil OFAC Projects it is necessary to do an OFAC check on parties involved in any financial transaction. The project is to check if OFAC check is performed on all Parties and all types of Transactions are not on the OFAC List.Data Check and Data Transfer for reporting purpose is handled through BI SSIS/SSRS .

Responsibilities

• Preparation of Test Cases based on the Project Requirement Documents.
• Developing Test Scripts.
• Involved in Functional and Regression testing of the Requirements.
• Involved in Front End Testing of Reports and Web Pages.
• Defect management and Bug Reporting.
• Client communication.
• Status updates to the higher management.

Environment: CICS Panels , SQL,BI SSIS/SSRS ,QC AND WEB PAGES.

Confidential

Test Lead

Description: Global New Accounts is a Part of American Express which deals with the New and existing Account details of members of American Express.GNA deals with the applicant's information and the eligibility of the Applicant for various cards.GNA interacts with multiple systems like Customer Care Applications, Data storage databases and Management groups. This project deals with multiple URLs. Multiple projects had involvement in web page testing also.

Responsibilities

• Preparation of Test Cases based on the Project Requirement Documents.
• Developing Test Scripts.
• Involved in Functional, Regression and Negative testing of the Requirements.
• Involved in Front End Testing of Reports and Web Pages.
• Defect management and Bug Reporting.
• Involved in several meetings to solve the Critical Issues with Developers and Other Application Teams.
• Responsible for Reviews of test cases and test results.
• Helped the team/organization in process improvements.
• Client communication.
• Responsible for all the deliverables made by my project team.
• Status updates to the higher management.
• Auditing the Projects of the Team.

Environment: FILE AID, CONTROL-M, CICS, TSO, QC AND WEB PAGES.

Confidential

Sr. Tester

• Description: Employer Services is the largest division within ADP, and is the leading provider of Tax and Payroll processings. This segment generates highest revenues within ADP. The application is responsible for movement of money from employers to tax-collecting agencies for tax deducted at source. It ensures timeliness, accurate money to be deposited to Federal, State and Local agencies.
• Deposits Application is used to receive Payroll and Tax information using ICS Input Control System from ADP's own regions regions receive payroll information from clients and processes Federal, State and Local taxes based on Deposit Frequency, Payroll Activities, Check-Dates, Cutoff Dates, Due dates and creates tax deposits to be sent to the appropriate agencies jurisdictions .
• When correct business date is reached, checks/efiles are generated to transfer money to the agency, as required either by Check or Electronic.
• Any over-payments are also arranged to be returned back to employer by sending requests to agencies. The late or inaccurate deposits impact as penalty and interest P I due to under depositing, and/or over-deposits resulting in negative ending balances.

Responsibilities:

• Preparation of Test Cases based on SRS/SDS for the SRs.
• Developing Test Scripts in QC.
• Involved in estimating the time taken to test my team SRs.
• Involved in Functional, Regression and Negative testing of the SRs.
• Defect management and Bug Reporting.
• Involved in several meetings to solve the Critical Issues with Developers and Business Team.
• Responsible for Reviews of test cases and test results.
• Helped the team/organization in process improvements.
• Client communication.
• Responsible for all the deliverables made by my team.
• Training on the technology to the other teams.
• Status updates to the higher management.

Environment: CHANGEMAN, CONTROL-M, TSO, CICS, INSYNC, FILE-AID, SUPER-CE, QC

Confidential

Description: FACS is Financial and Compliance Services which includes different applications related to Mainframes and Open Systems. The mainframe Data related to ADP Business is converted into Oracle tables to be available on Web for users to view or update related data. The Service Requests include testing the Web Sites for Links, Authorizations, Navigations, Buttons, Reports, Error Messages, Warnings and other functionalities.

Responsibilities:

• Understanding the requirements.
• Preparation of Test Cases based on SRS/SDS for the SRs.
• Developing Test Scripts.
• Involved in estimating the time taken to test the SRs.
• Involved in Functional, Regression and Negative testing of the SRs.
• Defect management and Bug Reporting.

Environment:QC, HTML, CICS,DB2, TSO, Web Servers.

Confidential

Description: Convert all Datacom tables to DB2. As interim the project will use 3rd party software 2BDB2 Transparency by ISI to minimize recoding of batch and on-line programs to access DB2 tables via native Standard Query Language SQL . The transparency should handle DB2 tables in the same manner as Datacom.

Responsibilities:

• Providing estimations for Project testing.
• Preparation of Test Cases based on SRS/SDS.
• Developing Test Scripts.
• Involved in Functional, Regression and Negative testing.
• Defect management and Bug Reporting.
• Responsible for all the deliverables made.

Environment:CHANGEMAN, CONTROL-M, CICS,DB2, TSO, INSYNC, FILE-AID, SUPER-CE, QC

Confidential

Description: Efiling or Electronic Filing is the paperless exchange of business information using electronic data exchange. It's the electronic filing of Tax information. NewYork SIT is converted to eFiling. The purpose of the NY Daily NYS-1 e-File Project is to validate that ADP can successfully create and Transmit NY Daily NYS-1 E-Files to Agency, receive Positive/Negative Acknowledgements, post Agency Positive acknowledgement to EFI and send E-Mail for Negative Acknowledgements to Users.

Responsibilities:

• Providing estimations for Project testing.
• Preparation of Test Cases based on SRS/SDS.
• Developing Test Scripts.
• Involved in Functional, Regression and Negative testing.
• Defect management and Bug Reporting.
• Responsible for all the deliverables made.

Environment:CHANGEMAN, CONTROL-M,CICS,DB2,TSO, INSYNC,FILE-AID,SUPER-CE,QC.

Confidential

Description: EBTS Proof of Concept is built to validate if EFT Payment file generation No Paper/Form outputs function correctly for new N As of Guam. New Local codes are to be setup in Test Environment to have Branch-companies having a Type of Service of only depositing .And have deposits generated from different files like ICS,PTI Transporter for test verification.

Responsibilities:

• Providing estimations for Project testing.
• Preparation of Test Cases based on SRS/SDS.
• Developing Test Scripts.
• Involved in Functional, Regression and Negative testing.
• Defect management and Bug Reporting.
• Responsible for all the deliverables made.
• Providing suggestions and feedback for issues related to other applications like Banking of EBTS.

Environment:CHANGEMAN, CONTROL-M, CICS,DB2, TSO, INSYNC, FILE-AID, SUPER-CE, QC.

Confidential

Description: The ATS system Amendment Tracking System is for amending any already filed Quarterly and/or Annual returns which needs correction. ATS ensures that all tax liabilities of each employee of each client are taken care accurately. It is multiyear capable and can amend the filings for any quarter in the last seven years.

The system calculates Employee level differences, Summary level differences, Evaluates various Agency requirements, Develops Fees, Produces Impounds, Requests waivers, and creates laser generated client letters and agency output. Provides online visibility for status, work in progress, work completed, jurisdictions with changes, jurisdictions amended, number of employees, special agency requirements, financial transactions, fees generated, etc.

Responsibilities:

• Preparation of Test Cases based on SRS/SDS for the SRs.
• Developing Test Scripts.
• Involved in Functional, Regression and Negative testing of the SRs
• Defect management and Bug Reporting.
• Responsible for all the deliverables made by me.

Environment:CHANGEMAN, CONTROL-M, CICS,DB2, TSO, INSYNC, FILE-AID, SUPER-CE.

Confidential

Description: Electronic Commerce or Electronic Filing is the paperless exchange of business information using electronic data exchange. It's the electronic filing of Tax information. Alabama SIT SUI, Iowa SIT and Georgia SIT tax filings are converted to E-filing. The purpose of Resubmission of eFiling Rejects is to alleviate some of the manual workload which is created as a result of failed eFilings. Employer level data that is rejected by agencies is often potentially correct or near correct data. This project will address the resubmission of files when the rejects are the result of enrollment or ID errors. By correcting these errors and resubmitting the files electronically, the manual effort of filing exceptions will be reduced.

Responsibilities:

• Preparation of Test Cases based on SRS/SDS.
• Developing Test Scripts.
• Involved in Functional, Regression and Negative testing.
• Defect management and Bug Reporting.
• Responsible for all the deliverables made.

Tools Environment:CHANGEMAN, CONTROL-M, DB2 , CICS, TSO, INSYNC, FILE-AID, SUPER-CE.