PREETI GUPTA

Senior QA Analyst

Ph: 832-***-****

Email: acggnl@r.postjobfree.com

PROFESSIONAL SUMMARY

. 10+ years of professional experience in Quality Assurance Testing and

SAP ABAP Development and Testing with strong focus on leadership and

team management oriented roles.

. Expertise in Banking and Financial domain and Insurance with solid

experience in SAP ABAP/4 (3.1I, 4.6C, ECC 6.0) with primary focus on

SD, MM, FI, PP, PLM and CSS modules ABAP/4.

. Worked as a Team Lead mentoring junior team members.

. Developed and manage matrices, providing daily defect status, testing

coverage and delivery schedule to the customer.

. Involved in whole SDLC from requirement gathering phase to end-to-end

implementation of the projects at client site.

. Planned and Executed backend testing using numerous complex SQL Queries

to verify the dataflow from the database.

. Expert in Manual and Automation Testing with Web application, SAP,

Client-Server and .Net applications.

. Manual Testing for Web, SAP R/3 - 4.7, ECC 6.0, SAP CCS, .NET

applications, Quality Center Administration.

. Experience with Mainframe TSYS, AFS, HOGAN, TSO systems.

. Experience in testing ETL processes and was also involved in data

conversion testing where I've written SQL queries, sub queries, joins,

triggers and stored procedures.

. Worked as a team member to provide assistance with ROW Acceptance

Regression Testing including: QC maintenance and reporting, SAP ID

coordination.

. Involved in creation of Test Plan based on software requirements

specifications which detailed testing scope, strategy, hi-level test

requirements, necessary resources and limitations.

. Involved in creation of Quality Centre business scenario maintenance

during Integration and User Readiness Testing (IURT) planning and

execution phases.

. Extensively interacted with client, Onsite - Offshore development teams

and testing team for requirement gathering, verifying new requirements

and testing effort assessment.

. Proficient in utilizing professional communication skills (verbal &

written) to handle key coordination roles.

. Created Excel Reports from Quality Centre such as Defect report,

Overall Testing status report.

. Thorough in Backend testing writing complex SQL queries and sub queries

for database.

. Utilized as multitasking resource, working experience in multiple

projects at the same time.

. Extensive experience in implementing testing methodologies such as

AGILE and Waterfall methodologies, test strategy, creating test plans

and test cases.

. Have Failover/Disaster Recovery testing experience. When one machine

failed, used another machine takes over and resumes service.

. Used emergency data center, in case of disaster, providing service and

protocols.

. Expert in Omniture testing using Charles Proxy.

. Experience in defect life cycle management - logging, replication,

triaging, verification, closing, metrics reporting, etc

. Knowledge of Automation testing tools like QTP.

. Conducted all types of testing including User Acceptance Testing(UAT),

functional, Negative, Regression, Integration, Interface, System and

Data Analysis, Database testing, Backend testing and Mainframe testing.

. Validating data integrity for interface testing, testing stored

procedures, triggers, and batch process.

. Thorough in Credit Card processing, back shop maintenance functions and

audit.

Professional Qualification:

Bachelor of Engineering (Computer Science & Engineering) -- MPCT Gwalior,

INDIA

TECHNICAL SKILLS

QA Testing: User acceptance testing, End to End testing, System testing,

Negative testing, Regression Testing,

functional Testing, Interface testing, Smoke testing, black box Testing,

data migration and conversion test, Backend testing, Integration testing,

Complex SQL Queries, Database Testing, Mainframe Testing(TSYS, AFS, HOGAN).

Tools Known: Mercury Quality Center 9.2, Test Director, QTP 8.2, Expertise

in MS Word, Excel and Power Point.

Languages Known: ABAP/4, C, C++, SQL/PLSQL, Core Java, Visual Basic, XML,

HTML, UML, Shell scripts.

Operating System: UNIX, Windows

SAP Skills: ABAP, BDC, Data Conversions and Dialog Programming, Data

Dictionary,

SAP Script, Smart Forms, User Exit, BAPI, EDI, ALV, IDOC, LSMW

Professional Experience:

The City Of Houston - Houston TX

March 2014- Till Date

Public Works and Engineering/ Utility Customer Services

Title: Project Implementation Manager

Modernization Initiative - The Modernization Initiative is transforming the

UCS business lines (Customer Service, Billing Operations, Field Operations)

through the adoption of a more modern suite of technology solutions aimed

at enabling more effective work processes across all business lines. The

solutions ranges from commercial Billing software package configured for

UCS use, expanding AMI network coverage and integrating the AMI network

into the new systems, building a Meter Data Management system, enabling

mobile application solutions, and integrating Portal technology into back

office.

Responsibilities:

. Support the successful implementation of strategic programs and

projects by evaluating product innovation business cases, conducting

feasibility studies, assessing schedule and scope, performing

requirements engineering and analysis, developing and managing test

cases and conducting risk assessments.

. Responsible for direct management of other more junior Business

Analysts or other staff.

. Participates under the direction of the Project Director to support

the implementation of enterprise level projects from final business

case development through implementation and closure.

. Works as liaison between project business sponsor(s) /stakeholders and

the technology /operations teams and represents the business needs to

the project

. Translates business vision and objectives into such project needs as

technical requirements, scope definition, process maps, gap analyses

and test cases.

. Ensures technical designs meet product objectives through analysis and

implementation of successful test program.

. Provides issue management, risk assessments, risk mitigation plans,

cost analysis, and scope and change management evaluations.

. Identifies needs for technical vendors and supports vendor selection

and management

. Understands both business expectations and technology capabilities

. Ensures compliance with company processes and policies.

. Communicates recommendations, and resolutions to senior management

team and all stakeholders

. Enhances department and organizational reputation by demonstrating

superior leadership skills and behaviors, and accomplishing projects

in a highly successful manner.

Wells Fargo Bank - Houston TX

June 2012 - Dec 2013

Title: UAT Tester/Sr. Quality Analyst

WTS (Wholesale Technology Services) develops and supports the primary

applications used to provide products and services to Wholesale customers.

We also facilitate internal applications used throughout Wholesale in

support of tracking customer information and customer issue identification

and resolution.

C3P (Commercial card core processing)

Commercial Card Core Processing (C3P) is an application that supports

payment and credit limit management for Commercial Card customers. The

application supports customers in US for Payments and Credit Limits,

Revenue Share in US Dollar and European currency denomination.

Responsibilities:

Lead the team for European extension project analyzed the Business

requirement, created test plan, testing strategy and time estimate for

project completion.

. Participated in the business process discussions and Functional

Specifications Reviews.

. Applied in depth knowledge for Credit card payment, Credit limit

processing for GBP and EUR Currency.

. Validated data in GL (General Ledger), Main frame systems and

database.

. Validated the Currency true ups for all EOD processes updated in

backend systems.

. Applied in-depth knowledge of credit card payment processing and

General Ledger concepts to revenue share accruals and payout

processes.

. Defined Revenue Share Agreement set up and validated customer's

accrual reports.

. Executed and improved critical path test cases.

. Used HP ALM for test planning, executing and defect tracking.

. Performed validation of data on HOGAN, TSYS, TS2 and AFS, BACS.

. Used Studio, Team Foundation Server 2010 to log defect for SIT

testing.

. Conducted various tests, such as database, integration, functional,

regression, cross Platform acceptance, usability and compatibility

during all software development stages.

. Responsible for writing test plans, tests procedures, and test cases.

Performed User acceptance Test UAT, functional, GUI, security,

usability, scalability error handling, stress, and regression testing.

. Wrote SQL queries to execute backend validation - audit etc.

. Involved in Production validations for each release.

. Involved in infrastructure upgrade testing and performed end to end

integration testing.

. Testing on Prod Fix Environment whenever needed.

Environment: .NET, HTML, XML, MS - Excel, MS - Word, SQL, HP ALM.

Reliant an NRG Company - Houston, TX

Mar 2011 - Feb 2012

Title: Lead QA Analyst

Reliant provides electricity and energy services to more than 1.5 million

retail customers-including homes, small and large businesses, manufacturing

facilities, government entities and institutions across Texas.

As part of NRG Energy, Reliant is backed by one of the nation's largest

power producers. NRG owns and operates more than 24,000 megawatts of

generation capacity, including more than 11,000 megawatts of capacity in

Texas.

Responsibilities:

. Analyzed the Business requirements and developed time estimates for

project completion.

. Developed detailed Testing Strategy for the entire application and

developed various test plans, test cases, test data for system

integration, regression, compatibility, and performance test phases of

web projects and other online software development efforts.

. Documentation of expected and actual results.

. Created and maintained manual Test cases, Test plans and Test Matrices

using HP Quality Center.

. Took part in contagious test planning in case of failure and disaster.

. Used bug-tracking tool-Clear Quest to record and follow up on all found

problems.

. Track and report status on all defects through to closure. Regularly

report status and raise the issues and risks as appropriate. Suggested

the possible alternative to avoid the risks.

. Planned and Executed backend testing using numerous SQL Queries to verify

the dataflow from the database.

. Involved in creation of test plan based on software requirements

specifications which detailed the testing scope, strategy, hi-level test

requirements, necessary resources and limitations.

. Extensively interacted with Business Analyst, development team and end

user to prepare test plan and test cases.

. Scheduled and performed functional, integration, regression, and release

testing. Analyzed the issues and risks and submitted errors to

development for correction, and retests once errors have been corrected.

. Reported test results and status as appropriate. Track defects and causal

analyses to closure. Acts independently to review and certify test

results of other analysts and testers.

. Created test cases, tracked and reported defects using mercury quality

center. Able to use independent judgment to plan, prioritize and organize

a diversified workload.

. Able to use independent judgment to plan, prioritize and organize a

diversified workload. Able to use independent judgment to plan,

prioritize and organize a diversified workload.

. Able to use independent judgment to plan, prioritize and organize a

diversified workload.

. Verified data consistency across different subsystems.

. Operational and technical experience with Credit Card interchange,

billing and payment processes.

. Enhanced and modified the scripts according to the test case scenarios.

. Effective communication with project team, customers and sponsors.

Develop strong working relationships with individuals at all levels of

company, operations, and IT applications and infrastructure teams.

. Experience in backend testing tested data in Toad and SAP CCS Module.

. Collaborate with team members and operational groups to identify and

prioritize/reprioritize work when necessary.

. Analyzed the defects, reported defect status, reviewed documentation and

verified defect entry.

. Tested the product for Platform Independence and browser Independence.

. Used Quality centre for Report generation and Bug tracking.

. Experience testing on major commercial web browsers including Internet

Explorer, Safari, Chrome and Firefox.

. Work with Deployment team participating in after-hours deployment and

quality assurance effort to test production environment updates before

they are distributed

. Fix delivery coordination with offshore - onshore development and testing

teams.

. Worked in very fast paced AGILE testing environment, attending daily

standup meetings, providing daily testing status and raising any concerns

or doubts.

. Ability to work well under pressure, remaining focused and calm in the

face of distractions, changing priorities in a fast-paced environment

. Performed Functional, Navigation, Regression and Smoke tests on the new

enhancements added to the web application.

. Mentored new testers joining the team, giving them knowledge of the

applications and introducing them to the methods and procedures being

followed in the organization.

Environment: JAVA, Oracle, HTML, XML, MS - Excel, Word, Power point, SQL,

Quality Center 9.2

American Express - Phoenix, AZ

Nov 09 - Dec 10

Title: QA Analyst

MYCA - OFX: Manage Your Card Account-- Open Financial Exchange -American

Express is the major credit card issuer to customers in U.S. and also

across the world. Project was for international website (ranked one among

the top banking websites) of American Express where Card Members use

existing services. The services offered include ability to register for a

secure on-line access to accounts, verify billed and unbilled charges,

perform account maintenance (such as adding a card to account access,

changing a password or an e-mail address), pay credit card bills, verify

Membership Rewards point balance etc.

Responsibilities:

. Analyzed the Business requirements and the site specifications for RUP

methodology process.

. Developed detailed Testing Strategy for the entire application and

developed various test cases.

. Created and maintained manual Test cases, Test plans and Test Matrices

using Mercury Quality Center.

. Operational and technical experience with Credit Card interchange,

billing and payment processes.

. Planned and Executed backend testing using numerous SQL Queries to verify

the dataflow from the database.

. Involved in creation of test plan based on software requirements

specifications which detailed the testing scope, strategy, hi-level test

requirements, necessary resources and limitations.

. Extensively interacted with Business Analyst, development team and end

user to prepare test plan and test cases.

. Created test cases, tracked and reported defects using mercury quality

center.

. Verified data consistency across different subsystems.

. Experience with mainframe CICS, TSO systems.

. Thorough knowledge of credit card processing, back shop maintenance

functions and audit.

. Enhanced and modified the scripts according to the test case scenarios.

. Analyzed the defects, reported defect status, reviewed documentation and

verified defect entry.

. Tested the product for Platform Independence and browser Independence.

. Used Quality centre for Report generation and Bug tracking.

. Used SoapUI for web service interface testing developed using SOAP WSDL.

. Fix delivery coordination with offshore - onshore development and testing

teams.

. Worked in very fast paced agile testing environment, attending daily

standup meetings, providing daily testing status and raising any concerns

or doubts.

. Performed Functional, Navigation, Regression and Smoke tests on the new

enhancements added to the web application.

. Mentored new testers joining the team, giving them knowledge of the

applications and introducing them to the methods and procedures being

followed in the organization.

Environment: HTML, XML, MS - Excel, Word, Power point, SQL, Quality Center

9.2

Progressive Insurance - Mayfield Village, Ohio

Jan 09 - Oct 09

Title: QA Analyst

Project was about developing customized Internet/Intranet web-enabled

solution for a Workflow based System for Auto Insurance Policy. The policy

covers entire customer Insurance details. The System will generate the new

Quote or Retrieve a saved Quote. The Customer can get all his Account

details and can pay online. Project automated and integrated following work

functions to manage the entire cycle of service to their customers- Filing

module, Application module, Payment module, Redemption module, User/System

Integration, Search Facility, Reporting, and Backend Integration.

Responsibilities:

. Involved in creation of test plan based on software requirements

specifications which detailed the testing scope, strategy, hi-level test

requirements, and necessary resources.

. Analysis, Project planning, Status reporting, document review, defect

entry verification.

. Analyzed user requirements attended change request meetings.

. Developed and conducted system and user acceptance test plans on

completion of system testing before installation of the application on

user environment.

. Report generation and Bug tracking using Mercury Quality Centre.

. Actively involved in QA process improvement activities like process flow,

problem resolution, bug tracking etc.

. Worked in Production and testing environment to test after production

defects.

. Responsible for end to end system testing which included online flows,

backend processes and batch jobs.

. Performed Functional, Navigation, Regression and Smoke tests on the new

enhancements added to the web application.

. Captured the SQL statements from the application execution and manually

checked the results.

. Involved in backend testing writing complex SQL queries and sub queries

for database testing.

. Coordinated with the users, Development teams both onsite/offshore teams.

Environment: VB, Quality Centre, MS - Excel, Word, power point, SQL.

Walgreens (Benefits Enrollment)

Title: QA Tester

Deerfield, IL Oct 08 - Dec08

Description: Benefits Enrollment is an Insurance Automation system that

handles Benefits Enrollment and summary Plan Descriptions /Policy Posting

eligibility for Walgreens Employees across US and Puerto Rico. Employees

become eligible to enroll in different benefits or view policies based on

the amount of service with the company and their premium is deducted from

payroll accordingly. The eligibility process will access insurance

eligibility rules and record eligibility for open enrollment, newly

eligible, work status change, Leave Of Absence, COBRA and Retirees.

Personal policies are performed ad hoc by filters that determine which

policies an employee is able to view. An employee can add coverage (within

guidelines) for a dependent/beneficiary at open enrollment, life

event/status changes, new hire, and newly eligible. A beneficiary can be

changed at any given time (within guidelines).

Responsibilities:

. Prepared test plan, test cases and test data for functional,

regression, database, UAE testing.

. Worked with developers to analyze scenarios and results.

. Created test scripts for end to end testing of different scenarios.

. Performed Functional, Navigation, Regression and Smoke tests on the

new enhancements added to the web application.

. Attended daily defect and status meeting.

. Performed smoke testing for further rigorous testing

. Tracked and reported defects using Mercury Quality Center

. Verified data consistency across different subsystems.

Environment: JAVA, Quality Centre, MS - Excel, Word, power point, SQL.

Sulzer Pumps - Brookshire, TX

Feb 06 - Aug 08

Title: ABAP Developer and Tester

Sulzer Pumps develops and supplies centrifugal pumps worldwide. The

division also provides technical services for all types of pumps and other

rotating equipment. It occupies a preeminent position in its markets.

Because of its intensive research and development, the division is also a

leader in high-pressure applications and special materials.

In addition to manufacturing

equipment, Sulzer Pumps runs the most extensive service network in the

world, offering maintenance, repair, spare parts, and upgrading services

for pumps. Upgrading improves working processes, increases the value of

production systems, and prolongs life cycles.

. Responsibilities

. Requirement Analysis for new reports.

. Modified reports to improve the performance of the system.

. ABAP/4 development including Reports, Smart Forms, User exits, BDC.

. Worked as a team member to provide assistance with ROW Acceptance

Regression Testing including: QC maintenance and reporting, SAP ID

coordination.

. Conducted the performance testing on the reports.

. Create Excel reports from QC and Remedy data Coordinate new SAP User

ID requests for IURT role testing.

. Extensively interacted with client, onsite - offshore development

teams and testing team for requirement gathering, verifying new

requirements and testing effort assessment.

. Developed Smart Forms for Sales Order and Purchase Order.

. Developed a report to create the Equipment Bom with Flat structure

from Sales Order Bom with Multilevel Structure.

. Planned and Executed backend testing using numerous SQL Queries to

verify the dataflow from the database using TOAD and SQL-PLUS

. Developed reports for Order Bom explosion, Material Bom Explosion, and

Equipment Bom explosion.

. Worked on Enhancement in DMS to provide the additional functionality in

'Process' button in CV04N.

. Translation of Smart Forms in Spanish Language.

. Test report and defect report generation at the end of the day.

Environment: SAP ECC 6.0, SD, MM, PLM, CSS, Test Director.

Wabash National - Lafayette, IN

Jan 05- Dec 05

Title: ABAP Developer and Tester

Wabash National Corporation is one of the leading manufacturers of semi

trailers in North America. The company specializes in the design and

production of dry freight vans, refrigerated vans, flatbed trailers, zdrop

deck trailers, and intermodal equipment. Wabash National implemented SAP

R/3 solution with the legacy systems and implementation was done by

Accenture in May 2006 and afterwards they moved to off-shore support with

Infosys Technologies, Bangalore. This project also involved the maintenance

and enhancement of the existing interfaces.

Responsibilities

. Requirement Analysis for new reports.

. ABAP/4 development including Report, Smart forms, BAPI, BDC, IDOCs, ALV,

LSMW, User exits.

. Solved R/3 code issues by debugging R/3 code.

. Test report and defect report generation at the end of the day.

. Tracked and reported defects using Mercury Quality Center

. Verified data consistency across different subsystems.

. Coordinating with ABAP and functional team and resolve any issues.

. Developed a BDC Program, which transfers Customer Master Data from legacy

system to SAP System

. Developed some ALV reports and used REUSE_ALV_GRID_DISPLAY function

module to display the ALV grid.

. Designed some custom tables (one header and another line item table) in

SAP to hold the data and created reports to pick the data from custom

table and create sales and purchase contract.

. Modified the reports output to ALV grid.

. Using ALV, generated a report in material master that outputs material

value stock, grouped by material type and plant.

. Modified reports to improve the performance of the system.

. Created some small enhancement like adding a selection field on reports,

adding field on output layout and area menu.

Environment: SAP R/3 4.7, SD, MM, PP, PM., Test Director

Punjab National Bank - Delhi India

Jan 04 - Oct 04

Title: QA Tester

Punjab National bank provides financial services all over the country

having a network of 66 offices/branches in 29 countries spanning all time

zones. Its products and services include banking, brokerage, finance,

general and life insurance, investment banking, mortgage lending, and

mutual fund management. The project was mainly targeted to deal with invest

banking, mortgage, general ledger, financial statements, expense analysis,

tax reporting, payroll and benefits administration.

Responsibilities

. Executed existing automated regression tests scripts using Win runner.

. Defect tracking and reporting, Analyzing and resolving issues with

developers.

. Conducted functional testing of AUT on localized systems

. Created and reviewed Test design from the Business Requirements

. Developed detailed Testing Strategy for the entire application and

developed various test cases.

. Analysis, Project planning, Status reporting, document review, defect

entry verification.

. Maintained Win runner automated test scripts and upgraded them.

. Test report and defect report generation at the end of the day.

. Planned and Executed backend testing using numerous SQL Queries to

verify the dataflow from the database using TOAD and SQL-PLUS

. Prepared test plan, test cases and test data for functional,

regression, database, UAT and E-E testing.

. Tested stored procedures and ETL processes.

. Created test cases, tracked and reported defects using Mercury Test

director.

. Verified data consistency across different subsystems.

.

Environment: Mercury Test director, Win runner 8.2, Toad, UNIX, SQL.

Contact this candidate