Oracle Management

Krishna YarraOracle Apps Techno Functional

Phone: 956-***-****

: ************@*****.***

Resumes ID: 49080

Location:, Massachusetts

Posted: 04.30.2012

Resume Details:

Summary

Over 7 years of extensive experience in Oracle Applications implementation, enhancements, customizations, upgrade, migration, interfacing and conversion

Experience in working on all phase of the project life-cycle: (1) gathered all business requirements in the service provider/service logistics area. (2) Designed training materials to bring users up to speed with the standard system functionality. (3) Performed an initial configuration of the system to support training and demonstration activities. (4) Final design incorporated business processes throughout the Support organization. (5) Completed configuration and setup to meet these needs. (6) Three cycles of testing performed: conference room pilots (CRPs) 1 and 2 and user acceptance testing (UAT). (7) Trained super-users. (8) Supported all go-live activities and post-production troubleshooting.

Extensive experience with analysis, design, development, customizations and implementation of Oracle applications e-Business Suite on various products.

Thorough understanding of Order to Cash Business Cycle. Have Experience in requirement gathering (AS-IS), TO-BE process design and GAP Analysis.

Having thorough experience of testing Client Server, Web based, and ERP applications.

Extensively used PL/SQL queries to interact with SQL database.

Experience in Oracle Applications (R12, 11i), Oracle Order Management (OM), Account Receivables (AR), Oracle Inventory (INV), Bill of Material (BOM), Oracle Purchase Orders (PO), IProcumrement, Account Payables (AP), Fixed Assets (FA), Workflow, Oracle General Ledger (GL), Oracle HRMS, Oracle CRM, Service Contracts, Installed Base (IB), Oracle Sales, Quotes and System Administration.

Responsible for analyzing the business requirements defining the scope and planning the deliverables Developed functional design document. Worked on future business process flow. Configured dev and test instance for user testing. Documented test scripts for user testing. Conducted CRP with the key users Worked with the cross functional teams to ensure the end-to-end solution works. Ensured technical stability, timely support and successful integration of enhancements.

Possess extensive technical knowledge in addition to functional expertise in PL/SQL programming and forms.

Well versed with Oracle AIM Methodologies.

Knowledge in Software Development Life Cycle (SDLC).

Actively involve in preparation of Test Plans.

Track test results for management, categorizing issues and creating/distributing defect reports and managing defect databaseusing Quality Center.

Excellent in Documentation and Data validation skills.

Highly motivated team player with strong communication and analytical skills.

Participated in all the bug scrub meetings.

Responsible for monitoring resources technically and training QA Team Members and end users.

Setup the Brainstorm Sessions and had a one to one interaction with the Users. Extensively used MLS (Multi Language Support) for translations and worked in the environment that used 14 different languages for the global implementation.

Quick learner and excellent team player having ability to meet tight dead lines and work under pressure.

A good team player with excellent time management skills having profound insight to determine priorities, schedule work, and meet critical deadlines within budgetary guidelines.

Job Interests

Implementations and Upgrades / Functional Consultant/ /Business Analyst/Functional Analyst/Tester ( Oracle / Oracle Applications: CRM, Order Management, Advanced Pricing, ERP including Oracle R12 / 11i /Implementations, Upgrades, Customizations, Enhancements, Testing).

Education

Bachelor of Engineering in Electronics and Communication engineering

Technical Skills

Programming Languages

C, C++, VB.NET, C #, SQL, PL/SQL, HTML and XML

Database

ORACLE 8i, 9i and 10g

Oracle ERP/CRM

Oracle Apps R12 and 11.5.10 (Supply Chain & CRM Modules)

Order Management

Advanced Pricing

Shipping Execution

Inventory

Purchasing

Trade Management

Service Contract

Install base

Financials

Account Payables

Fixed Assets

General Ledger

Account Receivable

I Procurement

Defect Tracking Tools

Quality Center, Mercury IT Governance and Test Director

Testing Tools

Mercury Interactive Tools

Load Runner,

Mercury IT Governance center

Quick Test Professional.

Operating Systems

Windows95/98/NT/2000/XP and UNIX

Experience

Dec 2011 – Current Vertex Pharmaceuticals, Inc. Cambridge, MA

Oracle Apps Consultant

Description:

Vertex creates new possibilities in medicine. Our team discovers, develops and commercializes innovative therapies so people with serious diseases can lead better lives. Vertex scientists and our collaborators are working on new medicines to advance the treatment of hepatitisC, cystic fibrosis, epilepsy and other life-threatening diseases.

Responsibilities:

Responsible for Account payables, Fixed Assets, General ledger, Account receivables, Purchasing, I-procurement and Cash management modules.

Supporting releases, in terms of change requests, production support issues, Testing and validation.

In process of upgrading / re-implementing to R12. Involving in business meetings.

Solution Environment: Oracle Applications 11.5.10.2

Nov 2008 – November (2011) Amway Global, ADA, MI

Oracle Apps Functional Consultant/ Test Lead (Order Management – Advanced Pricing)

Description:

Amway Global. is a global corporation offering products, business opportunities and manufacturing and logistics services in more than 80 countries and territories worldwide. Alticor is the parent company of Amway Global and Quixtar Inc. Alticor companies focus on nutrition, wellness, beauty and home products and manufacturing and logistics services. Vitamins, food supplements and cosmetics are among the company's leading global brands.

Responsibilities:

An effective team player with good communication, interpersonal skills. Well-organized, inquisitive problem solver who enjoys challenges.

Analyzed the client's pain points, scoped and analyzed business requirements and conducted application workshops as an illustration of the application features.

Architected the Back-to-Back, Drop Ship processes, usage of Regions and Zones, Advanced Pricing features thereby eliminating several customizations.

Responsible for analyzing client’s business requirement in Order management and Pricing sector, Gap and Fit analysis, providing best possible solution with respect to client’s business environment.

Responsible for designing Functional Specifications based on the requirement and Gap analysis. Also designed Test Case documents.

Performed upgrade & implementation of R12.1.2 for Order Management, Advanced Pricing.

Involved in discussions with users to gather business requirements, conducted application workshops, prepared functional specification documents and conducted the Conference Room Pilot Sessions.

Developed functional specifications, coordinated with the offshore technical team and validated the customizations.

Provided analysis & support for issues in the Order To Cash track and Compensation processes, coordinated with Oracle Support, Management, DBAs, Testers & Developers to plan, test, and implement fixes and patches.

Worked on CRM modules likes Service contracts, Install base and Tele services.

Involved in setting up the Inventory, Security, Scheduling concurrent programs, profile options and Price list related to service contracts.

Worked in Install base module to check Item instances, transactions and Transaction errors.

Responsible for all functional review & setups & Testing for all Operating Units till going live.

Reviewed and tracked issues, coordinated with the technical teams and presented to the PMO on a daily basis.

Implemented Oracle Advanced Pricing for calculating the final price of products based on modifiers, qualifiers and pricing formulas, according to the customer’s business rules.

Used Oracle API’s for loading price lists. Also, developed code to extract price lists and update them for a price increase.

Worked on Price Lists/Multi Currency Conversions, Pricing Agreements, Multi-Org Setup, Intercompany Billing with Pricing Contexts, Modifiers.

Involved in developing master QA plan that covers the complete objective, Scope, Approach and focus on the QA effort in all the phases.

Prepared the Validation Scripts for each stage of testing

Involved in developing automated test scripts for Ecom (Web) Applications using QTP.

Responsible for testing Ecom and ERP application integration performance. Done in Test Analysis. Generated different kinds of test reports such as defect detection rate, test cases actual Vs Planned, defect density, defects per feature for application under test.

Performed positive and negative testing of the application for identification of bugs after fixing of errors in each subsequent build during the process of development.

Wrote SQL, PL/SQL queries/procedures to access the data from the database tables and crosscheck the results, also been used for Automation Regression Testing.

Worked closely with the Technical people in the process of Performance tuning.

Update the number of defects that are pending to the Share point site weekly, to track the latest status of the defects.

Executed the test scripts on different releases and validated the actual results against the expected results.

Directly involved with Developers and Business analysts to discuss and resolve severity, issues and to make sure the application is according to specifications.

Reported and tracked defects, also worked closely with the Infrastructure team to ensure high quality and timely release.

Responsible for setting up Pricing and Promotions and debug the issues related to Modifiers and Pricing.

Communicating with Technical Team members on the specific requirements to deliver the custom components within time and perfection

Responsible for Production Support activities including solving problem tickets, giving support to affiliate.

Actively involved in Upgrade related tasks from R 12.0.4 to 12.1.2

Responsible for Business User training on specific areas

Responsible for Production Support activities including solving problem tickets, giving support to affiliate.

Solution Environment: Oracle Applications R12 (12.0.4 and 12.1.2) Order Management, Oracle Applications R12 Advance Pricing, Oracle Applications R12 Install Base, Oracle Applications R12 Service Contract, Oracle Applications R12 Teleservices, Data Loader and Toad

Dec 2007 – Oct 2008 Kronos Incorporated, Chelmsford, MA

Oracle Apps Functional Consultant

Description:

Kronos is the universal expert in helping organizations effectively in managing their Workforce. Kronos is mainly focused on delivering an integrated suite of software and services that enable organizations to reduce costs, increase productivity, Improve employee satisfaction and enhance the level of service they provide. More than 30 million employees using Kronos products daily. Kronos work force central, Iseries central suite, Human resources, Payroll, Time and labor, Time and Attendance and Talent management are some of the Kronos Products.

Responsibilities:

Defined systems strategy, developed system requirements, designed and prototyped, trained, developed support procedures and delivered under deadline.

Responsible for implementation of different CRM and ERP modules.

Gap Analysis between Kronos business process and Oracle applications 11.5.10

To work as a Module Owner for Order Management, Advance Pricing, Inventory, PO and Trade Management

Provided support to users Pre & Post Implementation Support as a part of the team.

Involved in setting up Account Inquiry,Journal Inquiry,Period Open/Close,Account Calenders, Chart of Accounts Intercompany Accounts

Customized various transactions in Accounts Receivables (AR) like Invoices, Receipts, Credit Memos and Debit Memos create Revenue Recognition Schedules for the Invoices.

Customized various transactions in Accounts Receivables (AR) like Invoices, Receipts, Credit Memos and Debit Memos create Revenue Recognition Schedules for the Invoices.

Worked with the team on mapping the service contracts vanilla functionality to the as-is business process and coordinated with functional team in modeling several business flows in Service Contracts

Performed functional set ups including Contract Status & operations, line types, categories, party roles, contact roles, UOM, coverage types, business processes, billing profiles, templates

Addressed the requirements, configured the system as per the requirements, Performed solution design, gap analysis and identified potential gaps for Install Base

Prepared BR100 and MD50 for Install Base

Done in Test Analysis. Generated different kinds of test reports such as defect detection rate, test cases actual Vs Planned, defect density, defects per feature for application under test.

Responsible for Functional, System and Integration testing.

Extensively used the legacy applicationsClarify, Change point and Ontrack (TRR) and performed the integrations using Web methods.

Involved in integration of ERP and ECOM systems using SOA, implemented using Websphere Process Server(WPA),

Responsible for testing different web applications like Order status, Employee lookup, Customer Push and Chart of accounts Was/Is.

Performed positive and negative testing of the application for identification of bugs after fixing of errors in each subsequent build during the process of development.

Wrote SQL, PL/SQL queries/procedures to access the data from the database tables and crosscheck the results, also been used for Automation Regression Testing.

Contact this candidate