SUMMARY:

. *+ years of experience in IT Quality Assurance, Application Testing

and Production Support.

. Strong domain proficiency in Retail (Retek- RMS, RPM, ReSA and RIB),

Insurance and Investment.

. 2+ Years of work experience in Production Support (L2) for managing

IMs, PMs, building resource capability and support activity.

. Around 7 Years of Extensive Testing experience in RMS, RPM, RIB, ReSA

and All the Down Stream Systems involved in Oracle Retail Suite.

. Working Experience on SQL in various projects and use different SQL

queries including joins. Experience in writing and executing SQL

queries to perform Data Validation and Back end testing of databases

to check the integrity of data.

. Excellent knowledge of SDLC (Software Development Life Cycle) right

from Requirements gathering, Analysis, Design, Development, System

Testing, Acceptance Testing, Deploy and Support phases

. Extensive experience in Preparing Test plan, Test summary report,

Daily status report, reviewing Test Scenarios and publishing defect

metrics and SLA Adherence reports.

. Expertise in Black Box testing techniques on Client/Server and Web

based Applications.

. Good at bug-reporting and bug-tracking using the test management tools

Quality Center, Clear Quest.

. Experienced in Agile, scrum and Waterfall Methodologies.

. Good understanding of development environment using AGILE

methodologies with SCRUM process. Participated in Daily Scrums, Sprint

Planning, Sprint Retrospective meetings.

. Well versed with most of the testing phases starting from Peer

Testing, Sanity Testing, Link testing to Functional Testing,

Regression Testing, Integration Testing, End To End Testing,

Production testing and User Acceptance Testing.

. Experience in Batch testing using CSV & XML files.

. Good Functional Knowledge in RMS (Oracle Retail Merchandising system),

RPM (Oracle Retail Price Management) and RIB (Oracle Retail

Integration Bus).

. Expert in Analyzing the Business Requirements and Reviewing the Design

to meet the Business Requirements.

. Experience in Automation testing using different tools.

. Extensive Knowledge in internal and external Audits.

. Experience in leading a team and delivering the quality products as

per schedule and People Management.

. Extensive experience in Onshore/Offshore Development model.

. Leading & coordinating the offshore team through very complex

applications.

. Expertise in testing of application developed using JAVA, J2EE, .NET

architectures

. Played major role in identifying and implementing process improvement

initiatives in the area of Quality Assurance and Software Testing.

. An effective communicator with strong analytical, problem solving &

organizational abilities.

. Proven ability to work independently or with a team. Dynamic

performer, excellent team player, goal-oriented employee.

. Capable of prioritizing task, also work with minimal supervision with

excellent written and oral communication skills.

. Experienced in Providing RTM (Requirement Traceability Matrix), Test

Summary Report, Defect Reports using Quality Centre.

Technical Skills:

Testing Tools: QTP, Test Director, ePMO, Clear Case, Clear Quest,

and Quality Center.

Operating Systems: Windows98/XP/2000. Linux, UNIX, Android and IOS.

RDBMS: Oracle, SQL DB, PL Sql, Toad.

Configuration Tools: VSS VSS, Clear Case, CGI, PERL

Educational qualifications:

. Master of Business Administration (M.B.A) with Marketing and Finance as

specializations from S.V.University, Tirupati, 2003.

. Bachelors in Computers received from SV University, Tirupati, 1999.

PROFESSIONAL EXPERIENCE:

Client: TESCO (Fresh &Easy) (Bangalore & Nevada, AZ)

DEC 11- July 2014

Project: Commercial Support (Retek)

Title: Principle Software Engineer/RMS Lead

Description:

Tesco is world's third biggest retailers with stores in 14 countries

divided as Asia, Central Europe, USA (Fresh & Easy) and UK/ROI with

millions of customers and suppliers. The retail information flows Between

Oracle Retail Merchandising System (ORMS V12), Oracle Retail Pricing

Management (ORPM) and other retail systems via Oracle Retail Integration

Bus (ORIB). All the countries are using different Versions of RMS (RMS V10,

RMS V12 and RAMS) According to the requirements and all the 4 Regions

require Support for the Daily Business to run smoothly and to prevent the

potential loss to the business.

Responsibilities:

As a lead for Production Support I was responsible for all the below

. Monitoring the Nightly batches for all the Asian Countries (China,

Thailand, Malaysia, Japan, and Korea) and USA.

. Fixing batches based on the Errors by changing the data or executing

required scripts.

. Assigning the IM's to the team and self and makes sure all the IM's are

resolved within SLA and make sure business is not impacted.

. Support Business Users in case of any issues Related to RMS, RPM, RIB and

ReSA.

. Guiding the Business users with the alternate ways to come over the

Issues and fixing the issues from backend.

. Maintaining the Load Balance in DB and taking the necessary actions like

killing sessions and making sure performance is not down for the business

users.

. Discuss with the Business Team on Daily basis and provide the status of

the support.

. Providing the Dash Board results on Monthly basis.

. Providing the Status of the SLA and SLA Adherence on Daily basis.

. Identifying the repetitive issues and reporting to L3 team With Possible

root cause details.

. Used SQL statements extensively to resolve the production issues

reported.

Environment:

Java, Oracle Forms, SQL, Windows XP.

Client: TESCO (Bangalore, IND)

Apr 07 - Nov 11

Project: NBS - Oracle Retail Mods (Retek)

Title: Senior Software Engineer

Description:

NBS is being developed for the UK and ROI buyers to carry out their

business smoothly and NBS is an internal Tesco project that aims to

decouple few mainframe systems and instead have all the legacy system

business related data in base RETEK applications like ORMS and ORPM. The

project involves developing a lot of new functionality on top of the

base(Vanilla) ORMS,ORPM,ORIB packages to enable the client to set up Tesco

specific item structures, supply chain attributes, Deals, Price Changes,

Promotion and clearances, synchronize the UK and ROI business into one

instance of ORMS. The same is achieved through interface designs that pull

in data to the RETEK applications from ODS which had data synchronized with

mainframe systems. We also aim to test all the functional aspects of ORMS

and ORPM that included product life cycle, promotions, deals and supplier

information amongst other business areas. This is an end to end integration

testing effort to prove the business runs as per requirements and we have a

sync of data with the legacy systems as well. Applications like BizTalk

server and Abinitio along with RIB, See beyond help us achieve the

integration of data.

Responsibilities:

. Reviewing the Design documents.

. Participate in the Design reviews and identify the Design gaps from a

Testing Prospective.

. Preparing the Test cases and Reviewing/executing the Test Cases/Scenarios

Planned for the release.

. Guiding the Team in the Execution phase.

. Coordinating with the dependent team for the Integration testing.

. Peer Reviews and Peer Testing of the Defect Fixes.

. Analyzing the data collected on the number of review comments received

while test case definition stage and help team to continuously improve

test case identifying capability.

. Analyzing the data collected on the defects and suggest for the

improvements in quality process across teams.

. Review of Team Deliverables to ensure that they are of good quality, are

technically correct & adhere to any standards relating to documentation /

format etc.

. Providing feedback to the team and ensuring that any processes &

templates are utilized correctly

. Coordinating Peer Review & Global review activity to ensure sign off of

deliverables.

. Phase specific ABCD (weekly)

. Ensuring that Clear quest is set up & configured correctly for the

testing period

. Ensuring that defects are logged with the appropriate level of detail to

enable the fix team to progress with root cause analysis & problem

resolution

. Involvement in defect triage sessions to ensure all defects are resolved

in a timely manner

. Ensuring that all team members are clear about the role which they play

in the team, the activities which they are expected to undertake and

timescales for delivery.

. Responsible to get the Verification done across the Legacy systems such

as BD, BM, LM, CR, MM, CRST, QL, SRS for the data which has been sent

from the NBS applications RMS & RPM.

. Responsible for E2E which covers the Validations from RMS to Till systems

in stores.

. Managed all Stake holders involved in the delivery.

. Effectively communicated and reported all the issues at the program level

as and when required.

. Environment definition & provisioning activity.

. Assisting team for Business queries on Retail domain.

. Responsible for the new environment build and Sanity checks for all the

phases and deliveries.

. Complete ownership on the applications like ORMS, ORPM and ORIB.

. Responsible for Functional KT Sessions for all the new joiners into the

team in Development or in Testing.

Environment: Java, Oracle Forms, SQL, Windows XP.

Client: MASTEK Ltd (Mumbai, IND)

Nov 05 - Mar 07

Role: Software Engineer

Project: Keebo (Pacific Select Distributors)

Pacific Select Distributors, Inc. has an extensive Broker dealer network

and for that we are building an integrated back office solution for its

broker dealer operations. The overall mission is to build a highly

configurable solution, which can be customized to suit the operations of

its various Broker-Dealer organizations and implement across all these

organization. This project mainly works on different workflows. This

project is having different modules like KIBO, VO, AFO, EAI, BIZTALK, and

PORTAL. In KIBO there are different types of accounts like Direct Business,

Mesirow, and Pershing. Key features of the system will be Multi-company,

Configurable, Built on contemporary technology, Meets requirements of ASC,

UP, WFG and MSC, Ability to add future BDs, Rapid deployment of updates by

BD or by all.

Responsibilities:

. Writing and executing test cases for manual testing.

. Developing and executing Automation test Scripts.

. Defect tracking and reporting defects through ePMO.

. Participated in CAM (Causal analysis Management).

. Responsible for conducting Delivery Audits, internal and External Audits.

. Documentation of Manual/QTP Test Plan and Testing Requirements.

. Define project scope, goals and deliverables that support business goals

in collaboration with senior management and stakeholders.

. Effectively communicate project expectations to team members and

stakeholders in a timely and clear fashion.

. Liaise with project stakeholders on an ongoing basis.

. Determine the frequency and content of status reports from the offshore

project team, analyze results, and troubleshoot problem areas.

. Performed Data base testing and Back end testing using SQL queries

. Report the Management with the Test Case Matrix, Weekly and Daily Status

Report.

. Conduct the Weekly status meetings with the Client.

. Analyzed and developed hybrid automation framework for PSD application.

. Worked extensively in test scripts to Parameterize values for performing

Data-Driven testing

. Created Reusable Actions for user-defined functions to enhance code

efficiency

. Enhanced scripts by putting Check Points like standard checkpoints, Text

Checkpoint, output values by putting Text Area output value Check point,

passing values between actions if the scripts needs.

. Created Per Action/Shared Object Repository so that they can be used for

different modules in the test plan.

Environment: SQL-Server 2000, .Net, Windows 2000 professional.

Contact this candidate