SUMMARY

• An accomplished professional with more than 7(Seven) years of hands - on experience in implementation, upgrade and support of Oracle 11i/R12 applications, business process analysis, evaluation, validation and integration of internal systems and training the users.
• Experience in implementing, testing, training, live production supporting on various Oracle ERP modules like Inventory(INV), Purchasing(PO), Order Management(OM), Bills of Materials(BoM), Work in Process(WIP), Warehouse Management(WMS), General Ledger(GL), Accounts Payable(AP), Fixed Assets (FA), Accounts Receivables(AR), Cash Management(CM), Oracle Trading Community Architecture (TCA), E-Business Tax, Service Contracts, Sub Ledger Accounting(SLA), iStore, iSupplier, iProcurement, iExpenses, Y.O.D.A etc.,
• Several successful implementations so far including upgrades for several large clients.
• Worked on various phases of Software Development Life Cycle (SDLC), such as Project Requirement study, Project Planning, High-level design, Low-level design, Coding, Implementation, Testing and Quality Assurance documentation.
• Good technical knowledge on Supply Chain Analysis(SCA), Global Supply Chain Management(G-SCM), Inventory planning,
• Strong technical and functional knowledge in business processes like Order-to-Cash (O2C), Procure-to-Pay (P2P), Business to Business (B2B), Pick to Order (PTO), Assembled to Order (ATO), Third Party Logistics (3PL).
• Extensive experience in back end database development using tools such as, SQL*PLUS, iSQL PLUS, TOAD, SQL Navigator.
• Experience in Data Migration from the Legacy System to Oracle Application and Oracle Installed Base.
• Well experienced in integrating and uploading data from the desktop excel spreadsheets using Web ADI.
• Involved in performing Unit Testing, System Testing and Integration Testing using tools in HPQC.
• Experienced in Requirement gathering, Gap analysis, As-Is Process Mapping, Re-Engineering, To-Be Process mapping, Solution design and Application Setup/Configuration.
• Worked extensively on designing functional documents for various customizations, Data Conversions, Interfaces to third party systems, Reports, Workflows etc.
• Strong knowledge of financial accounting including Key Commercial and Federal Financial statements.
• Knowledge on Sub ledger Accounting (SLA) for managing accounting across Sub ledger transactions to generate accounting entries.
• Extensive knowledge in using Oracle AIM of project implementation methodologies.
• Self-motivated, ability to learn and apply new technologies, well committed to responsibilities, ability to work independently as well as in teams for longer hours.
• Good Decision Making ability with Mathematical Decision Modeling and Analysis to make key decisions in the project, both individual and group decision making.
• Certified Lean Six Sigma Green Belt consultant, helps in better understanding of lean production and distribution concepts and its challenges.
• Several years of experience in project planning using PERT, CPM methods and MS Project tool.
• Strong educational background in Mechanical engineering with production and distribution as majors gives me good leverage over advanced concepts in the field.
• Excellent communication, problem-solving and Client Management skills.
• Oracle Apps skills with special emphasis on Distribution Modules

TECHNICAL SKILLS

Oracle Apps Versions: R12.1, R12.0.6, R12.0.4, 11.5.10.2 and 11.5.7.

Modules: Inventory(INV), Purchasing(PO), Order Management(OM), Bills of Materials(BoM), Work in Process(WIP), Warehouse Management(WMS), Advanced Supply Chain Planning(ASCP), General Ledger(GL), Purchasing(PO), Accounts Payables(AP), Accounts Receivables(AR), Fixed Assets(FA), Inventory(INV), Cash Management(CM), Order Management(OM), E-Business Tax, Sub Ledger Accounting(SLA), Internet Modules(iStore, iSupplier, iProcurement, iReceivables, iPayments) and System Administration, Y.O.D.A, etc.

Processes: Distribution

AIM: BR100,TE020,TE040,MD050,CV040

Databases: MS Access 2000, Oracle 9i, 10g, 11g.

Operating Systems: Windows 8/7/Vista/XP/NT/2000/Linux, UNIX, Sun Solaris.

Office Software: MS Word, MS Excel, MS PowerPoint, MS Project, MS Access

Programming Languages: C,C++,SQL,PL/SQL,HTML,XML,JAVA,PERL,PYTHON.

Tools: Data Loader, ADI, Web ADI, SQL Loader, Win SCP, Toad, Web Architectures.

PROFESSIONAL EXPERIENCE

Confidential, San Carlos, CA

Oracle Financials Techno-Functional Consultant

Environment: EBS R12, GL, AP, AR, CM, PO, INV, BOM, OBIEE, Informatica

Responsibilities:

• Gather business requirements from end users and executives, analyse, suggest and design a suitable functional design meeting the specifications.
• Make a FIT-GAP Analysis, make suggestions and provide solutions using Oracle’s best practices
• Setting up a new P2P and O2C cycles with newly acquired business units.
• Oversee the security hierarchy, decisions on user accessibility to data in various dimensions.
• Worked on creating new master items, serial controls, location controls, sub inventories etc.
• Defined Pick to Order, shipping, picking rules etc. for new acquisitions.
• Guide the team on OBIEE implementation, provide table mappings, metrics and facts, formulae from EBS, provide suggestions, validate the reports etc.
• Testing the reports and data for bugs and redundancies, file and format errors and suggest necessary changes to achieve desired data output.
• Providing information on EBS configuration and coordinate with OBIEE Team for report customizations,
• Defining the new bills of materials for several products, phantom assemblies, locator controls etc.
• Oracle WMS was introduced for task assignments and shipment tracking, performing cycle count etc

Confidential, Atlanta, GA

Oracle Functional Consultant

Environment: Oracle 11.5.10, R12

Responsibilities:

• Analyzed business requirements & performed Gap Analysis to map user requirements to oracle apps functionality & performed prototyping of “To Be” business process flows
• Setting up of complete Order to Cash (O2C) cycle setups from order entry to ship confirm, and Procure to Pay (P2P) Cycle as well. Performed Quote to Order (QTC).
• Studied, understood the Supply operations and solution in Supply chain, a unique design model that is very different from standard flow.
• Performed inter-org transfers, re-order point planning, defined the items and location controls, lot control, created templates and calendars etc. using Oracle Inventory.
• Defined inventories, sub inventories, shipping and approval methods.
• Performed PTO setups to enable custom selection of shipping material at different levels of the business process.
• Used Warehouse Management (WMS) for setting up BOMs, warehouse organizations, task-type assignment rules, defining and assigning LPNs and performing cycle count using WMS.
• Describing picking process and container management. Processing various receipts, accounting classes, schedule groups, transactions and material control etc. was done using Oracle WIP.
• Phantom assemblies, locator replenishment, ATPs’ and resource factors for Lead-time etc. were identified, calculated and implemented.
• Generating time zones for locations and phone numbers along with real-time address validations was setup using Oracle Trading Community Architecture. Managing employee and group resources such as defining skill ratings, hierarchies etc. was also successfully implemented.
• Defining FCL, AR and AP setups to allow and monitor international transactions
• Defining transportation calendar, pick release, container tracking ISO Cycle, shipment methods, price lists etc. and generating reports in Order Management.
• Integration of Oracle Order Management with iPayments, Oracle Project Costing etc.
• Defining foreign calendars, multi-currency and summary accounts.
• Supplier-Buyer details entry, configuration and product setup of iSupplier, user registrations, Purchase order and shipping entries, Splittings and change requests, invoicing, shipment notices etc. were carried out on Oracle iSupplier portal.
• Acted as a contact manager for various clients across the globe and managed profiles on iSupplier.
• Used Oracle Service Contracts to define billing stream, billing schedule to billing profile, tax emptions etc. Contract terms and renewal terms and subscriptions and subscription shipping and renewal along with price adjustments were also set up.
• Documented the new business processes, also provided with training materials, Test Scripts to the business users.
• Conducting testing events like CRP1, CRP2 and UAT.
• Experience with Y.O.D.A 2.0 to manage and export tables, reports etc. for easier access and better analysis. Also the interface was translated to different languages on Y.O.D.A.
• Played key role of functional owner for documentation for the entire Reimplementation.
• Prepare and review test scripts based on the business requirements
• Planned, Executed and Monitored the CRP phases in Development instances
• Imparting functional training to users and super users
• Involved in change management to follow up the necessary changes which have been made as per the business flow in day to day activities.

Confidential, Houston, TX

Oracle Techno Functional Consultant

Environment: Oracle 11.5.10.2

Responsibilities:

• Worked with the technical team in providing the functional documents for technical support and enhancements.
• Created inventories and sub-inventories for their service depots, defined item classification and shipping methods.
• Rule based transfer of journal entries to GL, user approvals for purchases etc.
• Created and maintained mass update batches, setting up and managing counters etc. was done using Oracle Installed Base.
• Cash Management module to streamline and monitor cash flows to various departments and projects
• Setting up AP, AR accounts payment and receiving methods, credit cards setup etc.
• Defined new Order to Cash (O2C) and Procure to Pay (P2C) cycles.
• Defined RMA Cycle, customers, pricing agreement, validation templates, drop shipments, pick releases etc. along with iPayments integration on Oracle Order Management
• Used Oracle Warehouse Management System (WMS) for defining storage & facility management and used WMS rules for directed picking and putaway and task dispatching.
• Derived several inventory reports, and performed mini-max planning, created items, assigned them and made templates for simpler processing. Handled miscellaneous receipts and other issues on Oracle Inventory.
• Created BOMs, location and sub-inventory parameters.
• Performed bulk imports and customer interfaces along with generating time zones for locations on Oracle TCA. Also defined Skill ratings, Group Memberships and hierarchies etc.
• Extensive work on Oracle Service Contracts for creating contracts items in Inventory, modifying contract lines, line omissions, Pricing basis change, subscriptions, pricing adjustments, extension, renewal and termination of contracts etc.
• Defined procurement authorizations and employee hierarchies on HRMS module as well.
• Worked on setting up order verification holds and new customer credit check holds in OM.
• Responsible for assigning the tickets to team members based upon skill set Performed Item Mapping
• Was responsible for taking requirements from clients on Enhancements, Delivering in Timelines.
• Was also responsible for closing the issues after interacting with the respective users.
• Experience with Web Architecture to design a simple, intuitive and reliable web application.
• Involved in the deployment cycle for Item Mapping, Production Cutover activities, helping the Pilot divisions to Go-Live, & user support in live phase.
• Documented new procedures and was involved in training the business users on the new processes and also assisted them during their on-job training exercise.
• Participated and executed all phases of UAT: The test plan, developing test cases, documenting the test logs, and user sign-off.
• Worked on Y.O.D.A web platform to create drop-down lists, procedures, DB links etc.,

Confidential, Kansas City, MO

Oracle Supply Chain Techno Functional Consultant

Environment: Oracle Apps R12 AP, AR, GL, OM, PO, OM Reports Builder 10.1.X, Workflow Builder 2.6.X, Forms Builder 10x, PL/SQL, SQL*Loader, UNIX and System Administration.

Responsibilities:

• Actively participated in implementation team for analyzing the key business process requirements.
• Processed Order API and Order Import interface used for order conversion processed the orders using standard actions - Book Order, Apply Holds.
• Defining the inventories, sub-inventories and imposing location controls etc. Performed Mini-max planning, cycle counting, inter-org tractions etc. using Oracle Inventory Module.
• Did Customer conversions by Trading Community Architecture (TCA) APIs, Customer Open Interface.
• Wrote custom scripts for Journal Entries Import Interface for GL entries migration.
• Worked on Payables Open Interface (AP Invoice Import) for invoice data conversions.
• Used Receivables Import Interface, and Auto-Invoice Master Program ensuring seamless integration of OM and Receivables.
• Customized standard workflows using Workflow Builder 2.6.x (e.g. OEOL-OM Order line), managed the versions, and connected to the customized transaction types.
• Customized the standard Workflow Items and process such as Order Headers and Order Line.
• Customized OM Order Line workflow (by adding Apply Holds API) and tested it from the front end.
• Developed scripts for entering transactions like Regular orders, Inter Company Invoicing, Regular Invoicing, Invoicing Rules and different methods of Receipt Processing and application in OM and AR (Order Management and Accounts Receivable).
• Shop floor control was implemented at all locations using Oracle’s WIP module to enable inter/intra operation moves, move status monitoring, pick releases, ATP and Backflush transactions etc.
• Did enhancement and development of new custom reports: 'Order-Lines Detailed Status Report’.
• Customized new forms meeting business needs (e.g. Quick Feasibility Study Form).
• Customized Flex fields to capture sales order specific field, restricted usage to specific operating units.
• Worked on mass data loading using SQL*Loader utility, used .dat and csv files, SQL scripts.
• Took up administrative position for various jobs like creating user logins, altering tables, fields and monitoring data export using Y.O.D.A.
• Attended regular status meetings with project team members to manage deliverables and time scopes

Confidential, Petaluma, CA

Oracle Techno Functional Consultant

Environment: 11.5.10.2

Responsibilities:

• To Support Modules of order to delivery track.
• Defined complete O2C cycle for their products with different categories and various routing methods
• Responsible for assigning the tickets to team members based upon skill set.
• Setting up payment methods and cash management to and from various inter-orgs.
• Defining and setting up FCA, FCL for project monitoring.
• Defining GL setups and running consolidation, translation and revaluations.
• Putting cross-validation rules, summary accounts and security rules etc. in GL
• Defined inventories, BOM, PO planning and performed ABC Analysis.
• Defined set Confidential for mini-max planning based on the data provided and performed physical and cycle counts.
• Performed inter-org transfers, item definitions, attributes and templates, serial number control, replenishment planning and issued miscellaneous receipts and move order transactions etc. using Oracle Inventory Module.
• Several controls, including location and user approvals were defined.
• Assigning LPN and directed Pickup and Putaway using WMS.
• Designed item templates and UOM classes and imposed serial control in Inventory.
• Performed midpoint rescheduling, inter/intra operation moves, completion and return transactions etc. on WIP. Also, Process costing and scheduling along with several reports were defined and carried out using Oracle WIP.
• Coordinated with users to fix the issues.
• Responsible for resolving the issues in given SLA’s and PO as well.
• Worked in nexus with off-shore support teams to resolve other technical issues.
• Was responsible for following up the tickets logged, resolving the issues and documenting the resolutions.
• I also took up the task of training the users and resolving the issues based on their feedback.

Confidential, Richmond, VA

Oracle Techno Functional Consultant

Environment: Oracle 11.5.10.2

Responsibilities:

• Role to Reimplementation, Support, Enhancement of order to Cash track.
• Understanding the Business process of the organization.
• Configuration of OM module and Coordinating between off- shore and on site.
• Involved in setups for OM as per company’s specific requirement.
• Used Oracle WIP to derive various reports, scheduling and costing the processes, Resource charging, lead-time calculation etc. was performed.
• Worked on breakdown, deciding on Timelines, Estimations and Tracking.
• Was part in Unit testing, functional and integration testing, UAT.
• Given functional support to the Technical Consultants to develop the customized reports.
• Involved in the preparation of user guidance manuals, training manuals.

Confidential

Oracle Technical Development Consultant

Environment: Oracle 9.2, Developer Suite, PL/SQL and SQL, Business Analysis.

Responsibilities:

• Conducted Business Analysis.
• Met with the customer teams, account executives and end users to develop functional requirements.
• Documented the Requirement gathering to configure Applications.
• Developed Screens using Developer Suite Forms.
• Designed various reports based on requirements gathering and analysis.
• Wrote Server side PL/SQL for business functions.
• Created Year End Reports using Oracle Reports.
• Trained the client core team members & end users in the configured solution.
• Prepared well documented user procedure manuals.