Candidates About

 

Nagarjuna Babu Gutti

Oracle EBS Consultant

 

·10 years in IT with expertise in Oracle E-Business implementations as Functional Analyst with strong Technical background involved in analysis, design, requirements gathering, development, testing & implementation of (Supply Chain, Financials, Manufacturing and CRM) modules in versions R12/11i

·         Proficient in all phases of project life cycle analysis, design, requirements gathering, development, implementation, user training, fit gap analysis, well versed with AIM documentation writing BR100’s, Functional (MD50's) and technical design documents (MD70's) in addition to excellent problem solving and project management skills with sound business knowledge.

·         Functional (Business Analyst):  Requirements gathering, functional gap analysis, derive business process flows, application design to fit business requirements, module setup, test script generation, testing, conducting workshops, training guides, training end users, and production support.

·         Technical (Technical lead): interfacing with users, identifying functional and technical gaps, estimating work, architecting system interfaces, designing custom solutions, programming using SQL, PL/SQL, schedule jobs, lead developers, documentation, and production support.

·         Project Management: Managed projects right from design, development, testing, implementation and production support issues involving Functional, Technical and offshore resources.

·Working knowledge (and have been part of teams) of scaled Agile framework.

·Extensive experience customizing and configuring all Supply Chain Management application modules.

·Extensively worked on the business flows Order to Cash (O2C) and Procure to pay (P2P) .

·Expertise in Application Object Library (AOL) and system administration activities such as managing concurrent programs and managers, application user setup, define responsibilities, value sets, key and descriptive flex fields, profile options, lookups, register forms, functions and menus, and provide support to application end users.

·Expertise in Oracle account generator workflows to modify per client requirements to fit their chart of accounts structure.

·Good understanding of Oracle R12 E-Business with MOAC Concepts.

• Experience in Oracle R12 (12.1.3)/11i (11.5.10) Customization Workflow and PROD maintenance of Oracle ERP applications and e-Business Suites, migration of database and data synchronization.
• Excellent interpersonal, communication skills with the ability to adapt to new and challenging environments and be an effective team player and work independently.

 

Education:

 

Bachelor’s Degree in Electronics and Communications Engineering, 2007 from JNTU, INDIA

 

 

Technology:

 

ERP Versions	Oracle Applications 11i (11.5.10.2), R12 (12.1.3)
Cycles/Processes	Order to Cash, Procure to Pay, sales Orders and Shipping execution, Sub-ledger accounting, Inventory Transactions and processes
Functional Modules	Purchasing (PO), General Ledger (GL), Accounts Payables(AP), Inventory (INV), Accounts Receivable (AR), Order Management (OM), Shipping (WSH), TCA, Core HRMS, Payroll, Self Service (HR), Oracle Time and Labor OTL, Costing, Bill of Materials (BOM), Advanced Pricing (QP), Install Base (IB)
Certifications	Oracle PL/SQL Developer Certified Associate, Introduction to Oracle 9i SQL
Tools and Technologies	SQL, PLSQL, AOL, Oracle workflows, Alerts, XML Publisher, TOAD, SQL Developer

 

 

Experience Details:

 

IPC Systems, Inc                                                                                                                                                                      Dec 2015 - Till Date

Jersey City, NJ

Oracle Functional Analyst

                      

·         Lead the project as a Functional Lead by making decisions in project planning, design, development, delivery, testing and support through Implementation.  Coordination with DBA Team for Instance Building, code migrations, patching and cutover planning.

·         Enabled the order management setups and picking / shipping rules for five operating units (Italy, Spain, France, Switzerland, Germany)

·         Played the SME role for order to cash business flow.

·         Team Lead for integrating Oracle supply chain for the newly acquired company as a part of Agile implementation methodology.

·         Work with Offshore Team to give the required business analysis and technical inputs for development.

·         Responsible for Inter-Company, Inter-Organization Setups and Process and design for IR/ISOs

·         Worked on day to day issues for sales orders and invoices to customers.

·         Designed solution to reduce redundant workflow notifications, improving the system performance significantly

·         Responsible for defining Order Management setup for Picking Rules, Inventory Organization shipping parameters, Shipping networks, and inter organization transfers, RMA for credit.

·         Responsible for resolving issues around Internal Sales Orders, Order Entry, shipping, AR invoicing and billing for standard and return orders

·         Support sales order processing for both standard and return orders, order fulfillment, work with users to resolve issues around item availability and ship confirm process

·         Working with Buyers on daily basis to resolve issues with Requisitions, Purchase orders, cancelling PO’s, receipts, and discrepancies between PO and invoices.

·         Resolve pending and stuck inventory transactions for period close

·         Setup and Manage Price lists, Define Attributes, Formulas, Qualifiers, Modifiers

·         Setup the Inventory organizations, sub inventories and stock locators as per the business requirements.

·         Worked closely with business users to resolve day to day issues with requisitions, order entry, shipping and material transactions, and receiving on the procure to pay cycle.

·         Setup the new order types, line flows, document sequences, defaulting rules and processing constraints.

·         Setup the Intercompany Transaction Shipping and Procurement flows between different operating units for internal shipments, intercompany invoicing.

·         Setup intercompany shipping process flow between the France and other operating units.

·         Converted items, assigned them to required inventory organizations, bills of material BOM and its components, standard item costs and item categories

·         Prepared training documents for the application users.

·         Document activities from design to completion to help future analysts understand work solutions.

·         Assist end users with financial month end and year end close.

·         Lead offshore development team on technical skills and provide guidance as needed basis.

·         Responsible for migration, implementation, and overall delivery for inventory and order management for a company we acquired recently.

·         Completely managed the setups and implemented internal requisition – internal sales order mechanism as a part of recent acquisition of one of the firms from Europe.

·         Onsite Lead for deliverables and managing an offshore team of 3 – assisting the team with technical nuances, help them understand the business requirements and convert them into technical specs, build and test. 

·         Supported the physical inventory activities and updating the standard item costs.

·         Involved with resolving help desk tickets and post cloning functional setups.

·         Performed system integrations testing, and support user acceptance testing.

·         Set up multi-currency conversion setups in advanced pricing.

·         Created item templates in Oracle inventory module by modifying control level options.

·         Set up new user responsibilities for different org based on the end user

·         Setup suitable descriptive flex fields for the item based on the Inventory Organization.

·         Setup all organizations, locations, elements, element links, costing, job titles, payrolls, bank details, cost centers, Application Utility Lookups, Security Profiles and reports within the Oracle HRMS module for all applicable localizations, Setup HR related Descriptive Flex Fields, Key Flex fields, Validation Sets, Special Information Types, Security Profile attachments, users, responsibilities, request sets and menus under the System Administrator responsibility

·         Open Oracle SR’s for the Implementation product issues and get the solutions/work arounds from Oracle by working with their support Team.

 

 

 

Tata Consultancy Services                                                                                                                                                     Oct 2013 to Dec 2015

Webster, NY (Xerox Oracle Spares Orders Fulfillment)

Oracle Techno Functional Consultant

                                           

·         Liaison with clients for business requirements gathering and analysis, provide estimates for development and testing effort, design, build, and unit test code in compliance with business.

·         Single point of contact between offshore and onsite business users for SUPPORT, to handle all the critical issues. Responsible for overall delivery, quality, issue/ defect identification and resolution

·         Responsible for the technical solution, design, development and implementation of new requirements, enhancements, issues, bug fixes and to manage a team of developers

·         Responsible for BR100’s and configuration of Inventory, Order Management, Purchasing for new branches (inventory orgs) that are part of go-live, tasks included inventory organization setup, receiving options, purchasing options, Item templates creation for use during item conversion, Item validation after conversion, Purchasing module tasks included setup of Purchasing Approval Hierarchy.

·         Gathered business requirements for Logistics business process and documented it, translated the business requirements to technical requirements, reviewed the code and provided the feedback and helped on critical issues.

·         Support sales order processing for both standard, counter orders and return orders, order fulfillment, work with users to resolve issues around item availability and ship confirm process, setup picking rules, price lists, modifiers, qualifiers and shipping networks for internal order processing.

·         Worked with the Xerox business team to simulate what-if scenarios.

·         Setup the IR/ISO flow to be initiated between different manufacturing warehouses for Xerox.

·         Wrote business requirements documentation for Order processing, consolidated shipping process.

·         Implemented one of the complex interfaces for order sourcing rules for Xerox customer spare parts and orders

·         Setup price lists to support the intercompany process flows at transfer price using pricing formulas and custom pricing attributes.

·         Designed solutions to enhance standard oracle flows for Procure to Pay P2P, TCA and GL Accounting process.

·         Prepared the test scripts to cover all the business scenarios and tested the objects by coordinating with business teams.

·         Performed the setups for Organizations, Inventory Organizations, Item templates, category sets, categories, custom lookups, profiles, UOM’s, Sub Inventories, stock locators, Shipping Networks, Payment Terms.

·         Developed a complex interface using PL/SQL to restrict spare parts orders as per the customer country resulting in significant dollar savings for client.

·         Create internal requisitions, approvals, ship confirm and receipt for Inter-org transfers of inventory.

·         Support the business users and resolved issues pertaining to all the SCM and Distribution modules after go-live

·         Setup the Internal Ordering process between the Distribution center and the various manufacturing sites. Setup shipping networks and internal customers.

·         Configure the modules, designing reports and add-ons and coordinate with the technical team to monitor development and implementation progress.

·         Gap analysis in support of minimizing oracle customizations and encouraging business process changes.

·         Helped in maintaining interfaces from various legacy systems. 

·         Worked closely with business analysts to test all the CEMLI’s and report the issues for rework. If there is requirement change report the change management team.

 

 

 

Tata Consultancy Services                                                                                                                                                     Apr 2012 to Sep 2013

Hyderabad, India (Xerox Developing Markets Organization DMO Applications Upgrade)

Senior Oracle Systems Analyst

                                                            

·         Led the offshore technical team and worked in multiple time zones for implementing the functional and technical solutions

·         Worked as support to the functional analyst on day to day issues across modules and functionalities which includes material transactions, PO’s, Receipts and invoice issues.

·         Modified an interface to restrict sending non-USD POs for analysis for different Operating Units. This is a huge savings in terms of manual efforts for end users and reduced the redundancy of data.

·         Report the status to the client and track the deliverables. Coordinated with Marketing Team for New Product Launch to get the functional and technical inputs.

·         Responsible for upgrade activities for EBS upgrade from version 11.5.10 to R12.1.3 for Xerox business with Brazil and Mexico.

·         Responsible for impact analysis, functional testing of current process flows, custom functionalities and features for R12 upgrade.

·         Responsible for providing functional assistance to developers for CEMLI remediation.

·         Set up the pick release rules, shipping parameters and shipping networks.

·         Worked as the support analyst for the INV, OM and QP modules.

·         Set up new qualifier and pricing contexts as per the design and worked with the development team to define the custom packages required to fetch the price.

·         Plan and schedule concurrent programs Requisition Import, create internal orders and Order Import for internal orders processing and monitor essential concurrent program scheduled for supply chain team

·         Developed a custom form (10g) that will allow the user to have flexibility in reconciling bank statements as per the transaction type.

·         Developed several forms personalization on creating service contracts form.

·         Customized reports for purchase requisitions which included creation of new parameters, fields, columns,

Register the report in Oracle Applications, which included defining executables, report group, value sets, concurrent programs, registering concurrent programs

·         Setup and prepared setup document BR 100 and BR 120 to enable a context sensitive Descriptive Flex Field (DFF) for Xerox Financial modules

·         Analyzed the issues on Production System and resolved them.

·         Worked with accounting setups, Ledger, Ledger sets and Data Access set for General Ledger in R12

·         Functional support for Inventory, Purchasing, Order Management, and Pricing, resolving issues in PROD on day to day basis after go-live

·         Setup Planners, Buyers, Categories, Unit of Measurement.

·         Set up of Purchasing options, Receiving Options, Financial Options, and Ship-to Location.

·         Worked on fixing several Install Base issues which were preventing OM, INV transactions from creating/updating  respective Install Base instances and customers were not able to see the correct Instance/Serial on their reports

·         Setup new Items, added to the price list and setup modifiers for surcharges.

 

 

 

 

Infosys Limited                                                                                                                                                                                   Oct 2009 to Nov 2011

Mangalore, India (Exterran Holdings Inc.,)  

Oracle Technology Lead

 

·         Executed the full project lifecycle: requirements analysis, design, configuration/setup changes, technical specifications, create and execute business test scenarios, documentation, and knowledge sharing and training.

·         Daily tasks included attending meetings with the client project manager and review the project status along with regular design, development and unit test activities.

·         Customized Oracle PO Account Generator workflow to fit in the business requirements for Exterran Chart of

accounts and segment structure.

·         Used SQL Loader to load data from legacy system (CORE) and developed PL/SQL programs to dump the data from the staging tables to the interface tables and concurrent programs to get data into Oracle base Tables.

·         Customized field service forms to make them suitable for technician requirements.

·         Worked extensively on developing oracle reports using oracle 6i reports builder and XML Publisher

·         Developed an oracle alert whenever specific orders are cancelled to send prompt notifications to designated end users.

·         Developed and tested logical apps rules as per business requirements.

·         Prepared the end user training documentation for the OM module.

·         Designed, prepared, and conducted workshops and training sessions for Customer Relationship Module

(CRM) users to provide them with shortcuts and point out lesser-known features so they can improve their day-to-day productivity.

·         Worked on the most complex workflow for the client in automating their sales quotes by developing custom approval processes. This was a savings around $0.5M for the customer.

·         Created and maintained client custom responsibilities for Oracle EBS including concurrent programs, assigning them to specified request groups, creating/customizing menus, and profile values.

·         Registered customized applications, Programs, Executable and created Application Users, Responsibilities, customized menus, attached menus to responsibilities and finally added this to user using AOL.

·         Performed setup of Set of Books (Chart of Accounts, Calendar and Currency).

·         Extensively used Oracle Technical Reference Manuals (TRM) and metalink to debug production issues.

 

 

 

 

Infosys Limited                                                                                                                                                                       Jun 2008 to Sep 2009

Mangalore, India (British Petroleum)  

Oracle Senior Systems Engineer

 

·         Among the youngest leads to handle ERP applications and won accolades for successful delivery and leading a novice team.

·         Manage offshore resources and conduct status meetings.

·         Prepared Project plan and change request process approvals.

·         Weekly Stake holder communication and status reporting

·         Designed and built changes to the existing Oracle Applications (E-Business Suite) on R11i system. Tested (both standard functionality and custom functionality), worked with Oracle on bugs, developed new business processes, and configured the application during go-live.

·         Customized Purchase Order and Purchase Requisition Account Generator workflows to fit in the General Ledger accounting requirements of the client.

·         Developed custom interfaces (outbound and inbound) with required validations on data

·         Modified existing codes and developed oracle Reports, PL/SQL packages to perform certain specialized functions /enhancements on oracle Applications

·         Performed detailed requirements analysis, teamed with client to provide recommendations for process improvements in cash management module that saved $1M.

·         Created Technical and User Documentations and gave support to the users.

·         Performed quality assurance tests (prior to user testing), and produced documentation and training materials.

·         Test the various reports with the help of TE30 (Test Cases)

·         Supported all the production environments and users on a daily basis by responding to emergency requests

·         Carried out User Acceptance Test (UAT), go-live activities and Post implementation support.

·         Was involved with migrating inventory from one organization to another.

 

 

 

 

Infosys Limited                                                                                                                                                           Jun 2007 to May 2008

Mangalore, India (Ameren Corporation)

Oracle Systems Engineer

 

·        Interact with onshore counterparts for understanding & gathering of requirements.

·        Data design and process re-engineering to fit with the Oracle system; Prototype new business processes;

·        Design legacy data conversion; Configure applications; Create test scenarios.

·        Train and guide new team members on various technical and functional aspects.

·        Customized Quick Invoices form in Accounts Payable (AP) R12 using Oracle Form Builder 10g

·        Developed a custom report related to Purchase requisitions using oracle reports 10g and developed the report layout with XML Publisher.

<p class="MsoListParagraph" sty