Rajasekhar Gogula

732-***-****

SUMMARY:

Over Twelve years of professional experience in Information Technology with extensive experience in performing Manual and Automated Testing.

Experience in testing Web-based / E-commerce / Data warehouse / ERP / Mainframes and Client-Server applications on different environments.

Strong knowledge of Software Development Life Cycle (SDLC), QA Methodologies like Agile, CMM, RUP and SCRUM.

Strong experience in developing Test Plans and Test cases using requirements and design documents while specifying Testing Overview, Approach, Strategy, Scope, Roles and Responsibilities.

Ability to write test plans, test cases, test procedures & test scripts from requirements

and Use Cases.

Experienced in software analysis, Requirements Management, Quality Assurance, Modeling, Configuration Management and Change Management.

Experience in Manufacturing Execution Systems, Finance, MRP and CRM Applications.

Experience in automated Test tools Mercury Tools (QC, Load Runner and QTP) and Rational Suite (Requisite Pro, Robot, Functional Test Manager, Clear Quest and ClearCase).

Experience in working with Rational Team Concert and Rational Quality Management

Experience in Web Services testing with SOAP UI, Groovy Scripts.

Experience in working with Open Source Tools Selenium (Selenium IDE, Selenium RC, Selenium Web Driver), Junit, Eclipse and preparation of Automation Framework.

Expertise in performing different types of Testing: White box, Black box, Module, Integration, Stress, Volume, System, Performance, Regression.

Extensive Experience in using XML, Flat-files.

Trained in Worksoft Automation Tool for Validation and Testing the End to End Business Solutions

Experience in developing and running User Acceptance Test Scripts.

Experience with MS Test Manager Automation Tool.

Good understanding of Relational Database Management Systems.

Extensive working knowledge in UNIX and Windows platforms.

Strong experience in UNIX, MSSQLServer, ORACLE environments and ability to write Shell and SQL scripting.

Proficient in SQL and PL/SQL Programming for testing database integrity

Expertise in Data warehouse Testing with strong T-SQL and relational modeling.

Experience in Cross Browser Testing IE, Firefox, Chrome and Safari.

Working knowledge of Siebel CRM,SalesForce, ETL tools like Informatica, Data Stage.

Involved in testing of Oracle, Java, VB, ERP and Mainframes applications.

Industry experience includes Telecommunications, Insurance, Financial and Pharmaceuticals.

Excellent interpersonal and customer relational Skills. Proven communication, presentation Skills and Leadership Qualities

TECHNICAL SKILLS:

Operating Systems: MS-DOS, UNIX, Windows 9x/NT/2000/XP

Languages: C, C++, COBOL, PERL, JAVA, SQL, PL/SQL, UNIX Shell

Scripting, TSL, UML, CICS, TSO, VSAM

RDBMS: Oracle9.x/ 10.x/11.x, MS SQL Server, Sybase, DB2

Web Technologies: HTML, ASP.Net, J2EE, XML, Java Script,JSP, Web logic,

Websphere,MQ Series and IIS

Packages: Visual Studio.Net,MS-Office, Siebel CRM, SAP R/3, SalesForce

GUI Tools: Oracle Developer 2000 and Visual Basic 4/5/6/.net

Testing Tools: WinRunner, Test Director, Load Runner,QTP.QC

Test Strategies: Integration, System, Regression, User-Acceptance, White Box,

Black Box, Performance, Load, Stress Testing.

Datawarehouse: Informatica, Data stage, SSIS

OLAP: Cognos, BusinessObjects

EDUCATION: Bachelors in Engineering.

CERTIFICATION: Microsoft Certified Solution Developer

PROFESSIONAL EXPERIENCE:

Glemser Technologies PA

Sr QA/Validation Analyst

xmLabeling/GLS(ABBVIE) May 14 to Till Date

XmLabeling is a Product based global content Management system that addresses all FDA US Submissions, QRD EMEA Submissions and Clinical Labeling of World Wide Pharma Clients

.

Worked under Agile Methodology and attend the User and Team Meetings

Reviewed and developed SOPs for xmlabeling System and worked with Perforce Version Control System.

Maintained Audit Trials that keep a complete time and date record.

Developed CSV Assessment and 21 CFR Assessments to xmlabeling Application.

Validation of US Label Documents, EU Label Documents and PPLS Doc Types

Involved in WebService Callback and Abbvie Global Label Systems

Involved in Validation of Source Document and Target Country Labels Change Notices and Responses

Used SOAPUI and REST for Functionality and Regression Testing of xmlabeling.

Developed Requirements Traceability Matrix (RTM) to track requirements against Installation Qualification (IQ), Operation Qualification (OQ) and Performance Qualification (PQ).

Developed the Test Plan for xmlabeling System.

Recorded and Play Back Test with Firefox using selenium IDE

Used Firebug Tool to identify the object ID, Name, Xpath, Link in the Application

Exported Test Case Scripts (Java Selenium RC) in Eclipse IDE modified the selenium scripts executed, prepared Automation Framework.

Used JIRA for managing the Test Process for xmlabeling Applications.

Wrote Test Scripts for IQ, OQ and PQ for xmlabeling.

Used MS Visio 2000 for creating Work Flow Diagrams and Business Processes.

Involved in developing the test cases for User acceptance Test Scripts.

Validated the Change Management System of Change Request Forms.

Run DQL Queries to test the database for xmlabeling System.

Communicated with Test Status Reports with Business Stake Holders and Project Management Team

Validated the xmlabeling Reports for all EU Label Doc Types and US Label Doc Types

Environment: Documentum 6.7, DCM 6.7, Oracle 11, J2EE, Oracle 11,Web Services, SOAPUI, REST,XML, JIRA, SalesForce, TrackWise, Selenium .

Financial Information Services Agency, City of New York Apr08 – Apr14

Sr QA Analyst

Involved in Working with Client Financial Information Services Agency, City of New York, NY

The City of New York will replace its current Financial Management System (FMS/2) with an application based on the AMS Advantage 3 (ADV3) Financial Management product. It is a significant upgrade that will focus on using baseline Adv3 software along with system modifications to meet the NY City’s business needs. The modified ADV3 application will be known as “FMS/3”. The FMS/3 implementation will consist of functionality that will be used by the all agencies in the NewYork City for PS (Personal Services) processing and OTPS (Other than Personal Services) expenditure chain functionally consistent with Citywide rules and processing. FAMIS,VENDEX, IFA, DMS, NYCAPS and other Agency Applications are integrating with City Wide FMS Application.

Responsibilities:

Involved the Review of Design Documents, code Review with FISA Architects as per the Business needs of city Agency Users

Involved in Vendor Management, Contract Management, all Expenditure Chain and Revenue Management of FMS System.

Involved in the Testing Co-ordination meetings with City Agencies.

Developed the Test Case Scenarios as per the Detail Design Requirements.

Involved in Integration, System and Regression Testing of Citywide Application.

Running backend database queries for dataset up and verified in DB2 on Mainframe for FMS/2(Legacy Application) and Oracle database on the Web Side of FMS/3 (NY City new Financial Management System).

Verified the System Assurance and Functional Reports Sync and Out of Sync Conditions of FMS/2,FMS/3 and Other NY City Agency Systems

Involved in data setup for System Assurance Reports like Vendor Interface, Master Agreement Contracts and Expense Accounting

Validated XML information received from NY City Agencies Systems against FMS/3 Screens

Developed and Validated the inbound Interface XML Files for Encumbrances, Payments

Develop the SQL Queries for Backend Testing for all FMS Modules

Validated the Unix Shell Scripts for Nightly Cycle Batch Jobs, inbound and Outbound Interface Jobs

Validated the FMS System Out Bound Extract Data to the NY City Agencies

Validated the ANSI X12 EDI Data for NY City Bank and Vendor Bank through Inbound and Outbound Interfaces

Developed and executed the Test cases for whole Expenditure Chain documents such as Requisitions, Purchase Orders, Payments, Disbursements with EFT’s and Checks

Involved in the Validation of GIS Process with FMS System and NY City Agency Authorized Bank Systems

Involved in developing Procedures, Functions and Triggers as per business rules using PL/SQL

Used the Rational Clear Quest System to log the issues and assign the issues to the development Team

Assist the FISA Test Team and Users in the Testing of System Assurance Processes and Reports

Involved in developing the Project Status document updates and review Meetings

Involved in FMS System Verification and Validation Batch Processes

Effectively Communicated with both Technical and Non-Technical users of the FMS System

Involved with Production and Technical Support for FMS System Application

Guided the Team Members in working with FMS Version Release Testing Management.

Involved in developing the Test Strategies and Test Scenarios for Vendor Punchout Module in FMS Application

Develop the SQL Queries with MS SQL Server and validate the backend for DMS Application

Involved in configuration and Manage the Rational Functional Tester with FMS Automation Scripts.

Environment: Mainframe OS/390, DB2, CICS, JCL/TSO, UNIX, Shell Script, XML, J2EE,Java Script, Oracle EBS 12,QC11,QTP11, VB Script, Rational Clear Quest, Rational Clear Case, Selenium, SAP BOXI,IBM Websphere7.0, MQ Server 7.0, PeopleSoft 9.0,.NET, MS SQL Server 2008, Informatica 8

Ernst & Young, NJ Feb 06 – Apr 08

Sr QA Analyst.

Global Acceptance and Continuance System/Global Billing Application

The Project GAC is a Quality and Risk Management application. Mainly the GAC application is a Workflow Tool Provides Consistent implementation of the Universal and global service line Policies, Questions and Processes, enable member firms to comply with local legal and regulatory requirements and also provides a central Repository for documentation of Acceptance and Continuance decisions. GAC is dependent on QMS, GHRDB, GIS and GFIS Applications. Global Billing Application supports all EY Global Billing Purposes.

Responsibilities:

Involved in Development and execution GAC System Test plan and Test cases.

Managed requirements, Test Plans and Defect Tracking using Quality Center Application.

Documented Test cases corresponding to business, functional requirements and Use cases.

Tested the backend database using SQL queries.

Involved in Developing the Automated Test Scripts.

Used QTP for functional testing for GAC and gBiller Applications.

Documented User Requirements and functional Specifications.

Performed End-to-End testing of all GAC Application process.

Lead and guide the Testers while production Implementation of GAC Application

Involved in Functionality Testing of created documents, Properties in the Questionnaire Management System.

Responsible for GUI Testing, System Testing and Regression Testing of QMS and Whole GAC Application.

Responsible in providing regular test reports to the management.

Involved in Migrating the Production data with Siebel Application Server.

Validated the Siebel CRM data of existing Customers from some of the locations.

Involved in Testing the Production Issues of GAC Current release Environment.

Tested the Batch Process Files with mandatory Data Elements and Additional Validation Process.

Involved in development of Test Plans and Test Cases with gBiller System.

Involved in Backend Testing for gBiller System.

Reported the bugs, Email notifications to the developers using the Team Track Application.

Investigate software defects and interact with developers to resolve technical issues.

Involved in Testing the Reports in GAC Application with Hyperion Performance suite.

Environment: J2EE, Oracle 8.1.7.4, QC 8.0,QTP 8.0,XML,Peoplesoft 8.0.Siebel 7.0.4,Hyperion Suite 9.0

W R Grace, MD Dec 04- Feb 06

Sr QA Analyst.

Quality Document Management System/Finance Credit Management System

The Project QDMS is a documentum based application. Mainly the QDMS application stores Business Documents, Production Documents, Legacy Change Orders (ECOs) and all Supporting Documents. The FCM is acting as the repository for the claims, invoices and other legacy data. The QDMS customizations were done with J2EE Environment.

Responsibilities:

Involved in Development and execution QDMS System Test plan and Test cases.

Managed requirements, Test Plans and Defect Tracking using Qualitycenter.

Documented Test cases corresponding to business rules and other operating conditions in Qualitycenter.

Tested the backend database using SQL queries.

Involved in Developing the Automated Test Scripts.

Used QTP for functional and Regression testing.

Documented User Requirements and functional Specifications.

Involved in performing Data Driven tests using QTP.

Performed End-to-End testing of all procurement process.

Regression Testing of Invoices, Pricing procedures and Purchase Orders.

Responsible for GUI Testing, System Testing and Regression Testing using QTP.

Responsible in providing regular test reports to the management.

Developed Automated Test scripts using QTP.

Wrote SQL Queries to retrieve the data from SQL Server for FCM application.

Used Loadrunner for conducting System Performance Testing.

Reported the bugs, Email notifications to the developers using the Qualitycenter.

Monitored Quality Center to close the bugs/cases as and when developers fix the bugs.

Investigate software defects and interact with developers to resolve technical issues.

Environment: J2EE, Documentum 5.2.5, SQL Server 2000, Qualitycenter 8.0,QTP 8.0,Loadrunner 7.0, WebLogic Application Server, SAP R/3 4.6C.

United Bank, GA Aug 03- Nov 04

QA analyst

This project is basically a up-gradation to the existing web based automated banking system which updates the existing automated functionalities like Savings account, Checking account, Term Deposits, Transactions (Cash and Transfers), GL Maintenance and Accounting, Cash Management, Clearings, Installement Loans & Small Business Loans,Advances, Remittances & Bills, Safe Deposit lockers and Bank Guarantees, MIS reports and queries.

Responsibilities:

Prepared Test plans. Developed Project Plans for manual/ automated testing process.

Unit tested PL/SQL stored procedures, functions, triggers to meet new features to be incorporated in the system to implement business rules.

Tested complex screens for transactions with required validations and writing procedures for common functionality using Forms.

Tested the database by SQL queries from various table and views.

Involved in performing White Box testing with extensive use of SQL Queries and UNIX commands.

Involved in Data Migration with Sybase of data and Backup servers.

Involved in Blackbox, System Integration and Performance Testing.

Automated all the functionalities of the modules using Winrunner.

Used Test Director for developing the Test plan and Test Strategy for the Application.

Used Test Director for defect tracking and Bug Reporting.

Environment: Oracle 9i, .Net FrameWork,PL/SQL, Winrunner7.0,Test Director 7.0, MS Office,Unix and Windows2000,Sybase Server.

Qiagen Sciences, MD Oct 02 – Jul 03

QA Tester

LIMS

Qiagen Sciences is in the discovery, development and commercialization of innovative Biotech products. Involved in implementation of LIMS Global Application.

Responsibilities:

Writing and executing software System test plans and Test cases. These Scripts were developed after reviewing the business requirements document, and technical specifications document

Managed requirements using TestDirector.

Documented Test cases corresponding to business rules and other operating condition in TestDirector.

Tested the backend database using SQL queries.

Worked with Unix and Shell Scripts.

Validated the Data marts.

Worked with SQL and PL/SQL to test database functionality.

Extensively used UNIX shell scripts.

Responsible for GUI Testing, System Testing, Regression Testing and Acceptance Testing using WinRunner.

Responsible in providing regular test reports to the management.

Developed Test scripts in Test Script Language and enhanced scripts using WinRunner.

Reported the bugs, Email notifications to the developers using the TestDirector.

Monitored TestDirector to close the bugs/cases as and when developers fix the bugs.

Analyzed all the bugs in the TestDirector reported by the users during the UAT.

Investigate software defects and interact with developers to resolve technical issues.

Tested the online programs and batch programs.

Tested the CICS Screens

Responsible in providing regular test reports to the management.

Environment: Mainframes, IBM S390, COBOL, CICS, JCL, MVS, XML, DB2, Abinitio, Java, Java script, HTML, SAP R/3,Web Sphere, Web Logic, MQ Series, MS SQL Server 2000,Oracle 8.1.x, Windows NT, WinRunner, TestDirector, Unix, Business Objects

MetLife, New York Apr 01 – Sep 02

QA Tester

MetLife is one of the leading Financial and Insurance Company. Worked as a Senior QA tester in their implementation of newly developed websites, MetLife Financial eSERVICE and MetLife Auto & Home eSERVICE. Using MetLife Financial eSERVICE customers can manage their individual variable life insurance policies and annuity contracts. Using MetLife Auto & Home eSERVICE. Customers manage their policy, billing and claim information. Most of the testing was done manually.

Responsibilities:

Reviewed Business Requirement Documents and the Technical Specification.

Managed requirements using Test Director.

Documented Test cases corresponding to business rules and other operating

Condition in Test Director.

Involved in testing MetLife’s eSERVICE web sites manually.

Tested the backend database using SQL queries.

Involved in Developing Test Plans, Test Cases & Test Scripts.

Involved in the functional testing of web pages using Win Runner.

Generated GUI maps using Win Runner and involved in performing Data driven

tests using Win Runner.

Conducted Performance test for eSERVICE web applications using Load Runner.

Performed End-to-End testing manually.

Extensively used UNIX shell scripts.

Responsible for GUI Testing, System Testing, Regression Testing and Acceptance

Testing using Win Runner.

Prepared status summary reports with details of executed, passed and failed test cases.

Developed QA metrics to keep track of department’s achievements.

Reported the bugs, Email notifications to the developers using the Test Director.

Environment: Java, J2EE, Servlets, SQL Server, SQL, Mercury Tools (Test Director 6.0, Win Runner 6.0, Load Runner 6.0) UNIX.

Contact this candidate