Jyoti Gupta Phone-214-***-****, acb0zf@r.postjobfree.com

PROFESSIONAL EXPERIENCE SUMMARY

• Over 14 years of diverse experience in Information Technology providing extensive support in Business

Analysis, Design, Quality Assurance, Software Testing, and support activities

• Have extensive experience in Healthcare, Finance and Telecommunication.

• Analytical, methodical, and resourceful approach to problem-solving, identifying root causes and corrective actions

to meet short and long-term business and system requirements.

• Proven ability to assist the business with creating application road maps, gathering business requirements, and

performing effective communications and expectation setting including understanding of business functional

requirements matching to technical systems setups and configuration.

• Excellent analytical skills in understanding the business process (AS-IS and TO-BE), understanding the functional

requirements and translating them to system requirement specifications.

• Experience in software configuration management activities to adhere to CMM level 5 standards, six sigma

processes, TQM, continuous process improvement.

• Gained experience in Test Development and Test Execution of various web applications and client server

applications

• Testing procedures like black box, white box, regression testing, data driven testing, user interface testing

• Excellent team player with problem solving and troubleshooting capabilities

• Solid skills in LoadRunner, QuickTest Pro, Rational Suite, ALM (QualityCenter) and PVCS.

• Experience in writing Test plans, Test Cases and Test Scripts.

• Good knowledge of Object- Oriented Analysis and design.

• Experience in Manual and Automated Testing.

• Self-motivated and have strong work ethics.

• Involved in writing programming scripts in TSL.

• Strong skills in performing System, Acceptance, Regression, Stress, Performance, Load, Functionality, Front

End and Back End Testing.

• Skilled at assessing client needs, working in a group, suggesting ideas that enhance efficiency and maximize

performance, implementing cutting-edge technology solutions, and training/supporting end users.

• Extensive experience, primarily, in the areas of Maintenance, Development and testing of various software

systems.

• Experience in conducting GAP analysis, facilitating JAD Process improvement, User Acceptance Testing (UAT),

SWOT analysis, Cost benefit analysis and ROI analysis.

• Experience developing project management documents such as Schedule document, Lessons Learnt, Gantt

Chart, Stakeholder Register, Team Status reports, Project Performance Report.

WORK STATUS – US Citizen (I have worked with Federal Govt - CMS and US Treasury)

TECHNICAL SKILLS

Testing and Reporting Tools Rational ClearQuest, Rational ClearCase, Rational Test Manager, Clear

quest, QuickTestPro, Rational Test Suite, LoadRunner, ALM, Sharepoint,

PVCS Tracker

Methodology Waterfall, RUP, Scrum, Agile, Six Sigma, CMM

MS Office MS Project, MS Word, MS Excel, MS PowerPoint, MS Access, MS Visio

Internet Technologies JDK, JDBC, Servlets, RMI and EJB, ASP, FrontPage, Macromedia DreamWeaver,

Macromedia Flash/Fireworks.

Languages Java, VB, SQL, PL/SQL, HTML, JavaScript, VBScript, C/C++, JSP, VB.NET

GUI/Tools Visual Basic, Visual SourceSafe

Page 1 of 7

Jyoti Gupta Phone-214-***-****, acb0zf@r.postjobfree.com

RDBMS Oracle, MS-Access, MS SQL Server

Web Server Netscape Web server, Apache, IIS

Operating System Win NT/95/98/2000/XP, Unix and Linux.

EDUCATION & CERTIFICATION

Masters in Computer Application

Masters in Business Administration (MBA)

Cisco Certified Network Associates (CCNA)

Microsoft Certified Professional (MCP)

Oracle Certified Professional (OCP)

WORK EXPERIENCE

AT&T, Fairfax, VA April 2011 – Present

Test Manager/Sr. Business Analyst

Environment: MS Excel, MS Word, MS Project, MS Power Point, MS Visio, ALM(QualityCenter), Share Point,

Java, TOAD, Oracle

Currently working as a Test Manager was responsible for the coordination, planning, and execution for AT&T services

numerous project of ORT/PDU testing (BVoIP, AVPN, EVPN, WCS OE and/or MIS). Also responsible for developing test

scenarios/cases, monitoring test status, facilitating training, raising/working issues through to resolution with

Labs/IBM/WCS testers

Responsibilities:

• Responsible for executing test management activities for UAT, UCT and ORT.

• Develop comprehensive test plans (scenarios & scripting) and obtain approval from all stakeholders (Work

Centers, IT and Product). Applies to UAT, UCT, and ORT.

• Responsible for confirming resources required and establishing test team, training plan/courses,

communications plan, testing bridge and confirm operating rules for the duration of the testing project.

• Also lead & guided other testers and coordinated testing activities & hourly progress for the project. Ensure

issues are raised & notify immediately on critical issues (for example testing blockers to IT and the Work

Center management team as appropriate).

• Monitored & enforce UAT/ORT entry and exit criteria utilizing UAT/ORT project plan to establish timelines,

owners, and tracking % actual to targets.

• Compile and deliver daily status progress reports in standard formats.

• Executed testing hands-on where applicable and feasible. Define extent during test planning activities as part

of resource planning.

• Participated and provided input to Service Realization Test Methodology approved improvement activities.

• Conducted JAD sessions involving SME’s, business users, data administrators, system architects, managers

and development team in order to create a good business process model.

• Identified the project scope, business objective, feasibilities and risks based on Scope/Vision documents.

• Reviewed test plans and test scripts developed by development team and QA team to make sure all

requirements have been covered in scripts and tested properly.

PNC Bank, Riverdale, MD June 2010 – April 2011

Sr. Consultant

Environment: Java, Weblogic, Tomcat, UNIX, Rational ClearQuest, Rational ClearCase, PCC(Process

Command Center), Oracle 11g, PL/SQL, Toad, XMLspy, SecureFx, SecureCRT

PNC Bank is a highly diversified and growing financial services organization spanning the retail, business

and corporate markets. PNC offers a wide range of services from individuals and small businesses,

to corporations and government entities.

Page 2 of 7

Jyoti Gupta Phone-214-***-****, acb0zf@r.postjobfree.com

Responsibilities:

• Responsible for the development of detailed quality assurance test plans, test case scenarios and test cases.

• Develop requirements and specification documentation associated with Treasury Management projects.

• Perform functional, regression and system testing for the PNC Bank application (Large transaction broker that

collects information from a variety of trading partners) for old features, functionality, and enhancements to existing

products.

• Frequently utilize Oracle 11g Database for query creation and execution with relation to the developing and

executing test cases.

• Log defects using IBM Clear Quest defect tracking systems and discuss defects with developers to clarify findings

when needed; retest defects to validate fixes and update defect statues accordingly.

• Executes back-end file processing using UNIX Command Line Interface.

• Validate web based systems function correctly to display incoming transactions and reporting statistics.

• Provided testing support for release implementation/deployment to production.

• Provide operational, analytical and research support to Treasury Management operations, technical and business

units.

• Attend requirements, high level, detailed design, and code reviews to gain knowledge and provide input from a

testing perspective.

IBM, Linthicum, MD Oct 2004 – May 2010

Sr. QA Analyst/Business Specialist

Environment: Oracle Financials (AR, AP, GL,FV) ERP 11.5.10, TOAD, Java, Websphere, Unix, Rational

ClearQuest, Rational ClearCase, Rational Test Manager, ManageNow –IBMBug tracking system, QuicktestPro,

LoadRunner, and Windows 2000 Client, Oracle Loans, HIGLAS Transaction Base HTB, Oracle 8i, PL/SQL,

Autosys.

Centers for Medicaid and Medicare Services (CMS) is an operating agency of the Department of Health and Human

Services (DHHS), administers the Medicare and Medicaid programs. CMS uses automated systems to support both the

benefits accounting process and the administrative accounting functions. The system that has been supporting

Medicare Claims is separate from the system that supports CMS’s administrative accounting functions. CMS is

replacing these existing systems with one integrated accounting system known as HIGLAS (Healthcare Integrated

General Ledger Accounting System). CMS has selected Oracle Federal Financials as the Commercial Off The

Shelf (COTS) application to improve the system’s ability to manage the benefits and administrative accounting

functions. HIGLAS has been recognized as world’s largest implementation in Oracle Financials.

The current approach to implementing HIGLAS involves the piloting solution (i.e. Oracle Accounts Receivables

(AR), Accounts Payable (AP), General Ledger (GL), Cash Management (CM), Letter generation modules, and

associated processes and reports for two Medicare contractors in the first phase.A number of RICEL components

such as AR/AP Netting,1099 Extension, Stale Dated Extension, Voids extension and Interface were developed to

integrate, automate and simplify the claims processing and Accounting procedure. Complex interfaces are being used

for Supplier creation, Invoice Creation and Payment Processing for 274, 271, 824, 837,835 and 811.

Responsibilities:

• Managed and responsible for projects, tasks and phases of the projects through ManageNow, Rational

ClearCase, ClearQuest, and eRoom for program documentation of Quarterly Release BETA /PMR (Problem

Management Record ) testing activities.

• Assisted the Maintenance Team Program Manager with the day to day management of the Integration and

Data Conversion testing in the Quarterly Releases. Working knowledge of Federal Accounting and Budget

processes within the Oracle modules.

• Liaison between the client and CMS contractors. Served as liaison with other systems, which interfaced with

the accounting system to ensure that all requirements were identified and addressed.

• Managed and executed BETA/PMR testing which provided more comprehensive testing to ensure that the new

and/or modified code function development improvements worked, not only within the specific component, but

Page 3 of 7

Jyoti Gupta Phone-214-***-****, acb0zf@r.postjobfree.com

across the entire solution and in coordination with the third party system. Supported the development of

policies and procedures for business requirements.

• Managed and established comprehensive BETA/PMR test plans that identified the nature and extent of

BETA/PMR testing deemed necessary to achieve testing objectives for each of the Quarterly Releases.

• Managed and coordinated an orderly schedule of events which described test methodologies and strategies to

be used and identified the entry and exit requirements, as well as, items to be delivered.

• Provided Management Reporting for progress and status for all Business related Work Products/Deliverables.

• Performed requirement gathering, design and development of test plans, test scenarios, test scripts, and test

SQL queries.

• Executed and assisted with the functional testing and documentation of BETA/PMR test results. Supported

testing of customizations, extensions, configuration of the application for multiple functional modules.

Identified problems and subsequent resolutions that will be documented through the project defect reporting

procedures. Recommended process improvements to management.

• Analyzed the Financial Reconciliation and Treasury Report of Receivables and Debt collection Activities for

each Beta Quarterly Release testing to identify and document any variances within the budget and determined

the correct accounting treatment. Extensive knowledge of analytical techniques, practices, research ability,

interpreted and compared data to identify problems, report findings, arrived at conclusions, and recommended

actions to management.

• Participated in Test Planning Meetings, Status Calls, Peer Reviews, and Knowledge Transfer Training.

• Involved in performing negative testing against HIGLAS system

• Manually testing various Oracle applications core financial modules like AP, AR and GL

• Ensuring that the application functionality was according to the business rules and regulations.

• Creating a Master test plan for Systems Integrations Testing and also creating unit test cases for testing

various modules to ensure the environment is ready for an integration testing process

• Maintaining a log of the issues faced during the Data Conversion and Systems Integration testing cycle

• Designing testing strategies with team members to accomplish the system and integration testing goals within

the allotted testing time frame

• Validate that data is transmitted across defined interfaces.

• Management of test data within the Oracle system to preserve the relationships between ‘existing’ and

inbound data

• Validating behavior of Websphere components when handling interface data

• Ensuring proper handling of file level errors by Websphere

• Ensuring the proper handling of data errors introduced to verify specific business rules

• Ensuring the proper receipt and processing of data by the Oracle 11i application layer for inbound interfaces

• Ensuring the proper preparation of data for the shared systems for outbound interfaces

• Validating the behavior of Websphere components when handling conversion data

Honeywell –POMS,Herndon,MD Jul 2004 – Oct 2004

Sr. Consultant

Environment: Rational Test Suite (Rational ClearQuest, Rational Test Manager, Rational Robot, Rational RequisitePro),

PVCS Version Manager, ASP DotNet, VB DotNet, Oracle 9i, TOAD

POMS is a Manufacturing Execution System that increases responsiveness of manufacturing by ensuring products are

manufactured and packaged the right way, at the right time, every time, at lowest possible cost. POMS MES enables

control and tracking of all aspects of production on the plant floor, ensuring predictive quality and enforcing cGMP, Best

Practice Manufacturing, and HACCP compliance while providing a complete history for compliance demonstration and

performance improvements.

Responsibilities:

• Involved in gathering business requirement, studying the application and collecting the information from

developers.

• Participated in requirement analysis and prepared systems test documents.

• Participated in the test environment setup and in ensuring that the facilities, test tools and scripts are in place

to successful perform the required testing effort

Page 4 of 7

Jyoti Gupta Phone-214-***-****, acb0zf@r.postjobfree.com

• Involved in project planning, coordination and implemented QA methodology.

• Involved in client interaction to take note of the changing requirements and analysis

• Conducted Functionality, Regression Testing, for entire application for various builds in a team

environment

• Developed test cases and test scripts using Rational Test Manager for Functionality, Security and

Regression Testing.

• Was responsible for weekly status updates showing the progress of the automation testing effort and open

issues to be resolved.

• Actively participated in enhancement meetings focused on making the application more robust and user

friendly.

• Used Rational Robot to perform Functionality and GUI testing.

• Used Rational Clear Quest for bug tracking and reporting.

• Maintained Test Matrix and Traceability Matrix.

Computer World Sept 2002 – June 2004

QA Analyst /Business Systems Analyst

Environment: Oracle 11i (Financial, HR, Installed Base, Service Agreements), Oracle Forms/Reports 6i, Java,

HTML, JSP, Progress, Oracle 8i, PVCS, TOAD, PVCS Version Manager, WinRunner, LoadRunner, TestDirector

Worked on the CIBER (Contracts, Install Base and Entitlements Repository) application integrating different

projects such as Oracle 11i Financial (AP, AR, GL), SA Service Agreements, BI Business Intelligence, IQT Interim

Quoting Tool, SCC Service Contracts Center, CARE Customer Advocacy Response Environment, and RMA Return

Materials Authorization. The application is developed in different environment and is integrated with each other. The

Mercury tools are used for the testing purposes.

Responsibilities:

• Worked as QA Analyst responsible for analyzing the application, performing Black Box testing.

• Developed a functional test matrix considering all aspects of the application.

• Involved in making the detailed QA test plan regarding the scope and focus of the testing.

• Developed strategy to configure TestDirector as the defect tracking and reporting tool.

• Worked closely with the development team to develop and implement Testing Plans.

• Involved in doing the lab set-up with different configuration and operating systems.

• Have written complex SQL queries to test the different scenarios in the application.

• Involved in the preparation of knowledge base for the application by reviewing different applications and

documents.

• Developed test cases for Functionality, Validation and Regression Testing.

• Developed test automation scripts using WinRunner for regression testing of the various releases of the

application. Writing functions in C/C++ and TSL to get the desired results.

• Developed templates for test script, test cases and test matrix.

• Created the test plan for the web testing.

• Used PVCS version manager for the version control and was involved in doing the Check-in and Checkout of the

modules from it.

• Did performance testing of the web site and the entire application and analyzing the test results with the business

team.

CHSM Jan 2002 – Sept 2002

Managing Consultant

Environment: WinRunner, LoadRunner, Rational Test Manager, Rational ClearQuest, VBScript, HTML, ASP, SQL

Server 2000, PVCS

Worked on the Visa View Online web application and Visa View Online Client-Server application which is used to solve

the disputes made by the customers. The application was based on various business rules to solve the issued between

the acquirer and issuer.

Page 5 of 7

Jyoti Gupta Phone-214-***-****, acb0zf@r.postjobfree.com

Responsibilities:

• Worked as QA Engineer responsible for analyzing and testing the Application, coordinating end-user requirements,

providing QA status reports to management, and coordinating testing efforts with other business clusters.

• Worked closely with the development team to develop and implement Testing Plans.

• Investigated and recommended automation tools to improve testing productivity. Used WinRunner to do the data

driven testing and also the functionality testing.

• Also involved in the manual testing and white box testing and tested procedures and packages in SQL Server

2000.

• Wrote complex SQL queries to test the different scenarios in the application.

• Developed test cases for Functionality, Validation and Regression Testing.

• Developed test automation scripts using WinRunner for regression testing of the various releases of the

application.

• Involved in attending the JAD (Joint Application Development) meeting and used to compile the meeting minutes in

the weekly status report.

• Developed templates for test script, test cases and test matrix.

• Conducted performance testing (both IE & NN), with load Runner for the specific transactions where Concurrent

actions will take place.

• Created the test plan for the web testing.

• Did performance and load testing of the web site using LoadRunner.

• Tested flow of data among different modules and database using SQL queries.

• Used PVCS for the version control and was involved in doing the Check-in and Check-out of the modules from it.

CHSM Jan 2000 – Dec 2001

QA Analyst / Production Support Analyst

Environment: WinRunner, LoadRunner, SQL Server 2000, VISUAL BASIC, Visual Source Safe, Java, DHTML

Worked on the Valve monitoring System application which is a migration from MS Access to Visual Basic. The

application was to develop the forms and reports in VB and crystal reports for the Valve, Turbine and Pump

Calculations.

Responsibilities:

• Involved in analysis, design, development and testing of the Database Application for Valve Calculation with

VISUAL BASIC as front end and SQL SERVER 2000 as back end.

• Performed database designing, developed packages, stored procedures, functions and database triggers using

SQL Server 2000. Designed relational data models based on application system data requirements. Validated

models with the application team.

• Contributed significantly towards designing Application’s architecture (3-tier), integrating third party software, writing

test plans, executing test cases and summarizing test results.

• Reviewed, developed and executed automatic test scripts using WinRunner to perform regression testing.

• Investigated bugs using Test Director and interacted with developers to resolve technical issues.

• Was responsible for weekly status meetings showing the progress and the future testing efforts.

• Made the test plan for doing the web testing.

• Was involved in writing the manual test cases.

CHSM May 1999 - Jan 2000

Visual e-MART

QA Analyst / Software Developer

Environment: C/C++, ASP 2.0, VBScript, JavaScript, VB 6.0, XML, HTML/DHTML, IIS 4.0, SQL Server 7.0,

Windows NT.

Page 6 of 7

Jyoti Gupta Phone-214-***-****, acb0zf@r.postjobfree.com

Visual e-MART is an E-commerce solution designed to leverage business online and to become an e-commerce

business in just five minutes without the hassle of product fulfillment, payment processing, inventory, etc. Site owners

would be able to add a store to their site for free and choose an unlimited number of products from a master product

catalog. It consists of 3 modules: Store Creation, Store Administration and Site Administration.

Responsibilities:

• Involved in Designing, Development, Deployment and testing of this project.

• Participated in designing database and development of the user interfaces using HTML, CSS, DHTML, Java

Script, VB Script and ASP. Prepared ActiveX Components using VB 6.0

• Involved in maintenance of Databases processes like Trouble shooting in stored procedures, Triggers etc.

Prepared detailed documentation and participated in user end testing.

• Involved in preparing the knowledge base for the application.

• Did manual testing of the application.

• Involved in making the Test Plan and Test cases to test different functionality of the application.

ACHIEVEMENTS AND AWARDS:

• Received Scholarships and Cash prizes for academic excellence.

• Received Value Awards for Job performance.

• Ability to master new technologies quickly.

• An active member of National Service scheme (NSS).

Page 7 of 7

Contact this candidate