SUMMARY:

• Over 10+ years of experience in ERP Implementation, up gradation, Customization, Analyzing, Developing and Support of Oracle EBS and in EDI with various tools.
• Worked with multiple clients related to Telecom, Banking, Point of Sale, Retail, Manufacturing and Service Oriented.
• Functional and Technical expertise in R12, 11i oracle application modules such as General Ledger, Accounts Payables, Accounts Receivables, Fixed Assets, Inventory, Cash Management, Purchasing and Order Management (GL,AP,AR,FA,INV,CM,PO,OM).
• Experienced in configurations, conducting CRP sessions, preparing Test Plans, Test Cases and performing User Acceptance Testing.
• Expertise in Procure to Pay Cycle and Order to Cash Cycle.
• Expertise in designing and developing Reports using Oracle Financial Statement Generator (FSG).
• Expertise in Trading Community Architecture (TCA) and with Discoverer reports.
• Worked as Production Support analyst and helped in Resolving Open Issues relating to oracle applications.
• Worked with Oracle Support and go through the Service Request Process, and solve Implementation/Support Issues.
• Experience in Data Conversion from Legacy Systems to Oracle Applications.
• Worked with System administrator and AOL modules for Creating User, Assigning the Responsibilities, Creating Concurrent Executable, Concurrent Programs and setting profile options as per the requirements.
• Expertise in preparation of BR Docs, Process Flows, Gap Analysis Report and Set Up Documentations as per AIM Methodology.
• Expertise in writing and following AIM (Application Implementation Methodology), BR010, BR030, BR100, CV040, MD050, MD070, RD020, RD050, TE020 and TE040, etc.
• Expertise in mapping customer business process/requirements to Oracle Applications flow, analyzing gaps and designing gap fillers.
• Developed maps in EDI formats ANSI X12, EDIFACT, VICS, HIPAA and TRADACOMS.
• Expertise in B2B standards, implementation of Integrated EDI applications and Enterprise Application Integration (EAI) for business processes across applications.
• Experience with SAP R/3, SAP IDOCs, XML and Internet based EDI.
• Strong interpersonal skills, ability to interact with people at all levels, good communication and presentation skills.
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment.

TECHNICAL SKILLS:

ERP: Oracle Application R12, 11i (GL, AP, AR,FA, CM), iProcurement, iExpense, Order Management, Inventory, Purchasing.

EDI: Sterling Integrator, GIS 4.3, Sterling Map Editor, ANSI X12, SAP IDOCs.

Databases: Oracle 12c/11g/10g/9i/8i.

Tools: SQL*Loader, Data Loader, TOAD.

GUI: Forms 10g/6i, Reports 10g/6i, Discoverer 4i/9i/10g.

Languages: SQL, PL/SQLx

Operating Systems: Windows XP/2000/98/95, UNIX,Windows NT.

Third Party Tools: Excel, Microsoft Projects, Adobe, Visio and Power Point.

PROFESSIONAL EXPERIENCE:

Confidential, GA

Oracle Apps Functional/Prod Support Consultant

• Carried out requirement gathering, requirement analysis, gap analysis, setups, functional modifications, unit testing, and UAT sessions.
• Responsible for detail documentation of as - is-analysis, to-be-process analysis, GAP analysis process documents.
• Worked on AIM Documentation for BR100, CV040, RD020, MD050, MD070, and Period Close Process.
• Designed custom interfaces for GL, AP and AR to integrate third party source systems with Oracle Apps to import point of sale GL accruals, AP Invoices and AR Transactions for day to day business activities.
• Designed multiple conversion programs for AP, AR, INV, and PO to convert data from legacy system to Oracle.
• Worked as part of the BA team to roll over multiple subsidiary companies into parent company COA structure so they can be maintained under the same LE, OU as per the respective ledgers.
• Carried out several steps for Global implementation of R12 for different legal entities and multiple operating units.
• Performed some administrative work such as, creating users, menus, adding forms and functions to menus, assigning responsibilities etc.
• Prepared end user documents for Accounts Payables, Accounts Receivables and general Ledger Modules.
• Prepared TE040 test scripts and user manuals to deliver smooth functioning of CRP, SIT and UAT sessions.

Environment: Oracle Applications R12.1.3, R11i (GL, AR, AP, INV, PUR, OM, CM),Workflow Builder, Discoverer, SQL, PL/SQL, SQL*Loader, Oracle 11g/12c, Windows XP.

Confidential

Oracle Apps Functional/Prod Support Consultant.

• End-to-end up gradation of R12 from R11.5.10.2 for GL, AP, AR, PUR, INV, OM, CM and iProcurement.
• Designed a single import program to import all AP invoices/Credit memos from multiple source systems.
• Defined and maintained receiving options, control options, Payment terms, Distribution sets, buyers, approval groups, approval assignment and lookup codes.
• Defined banks,lockbox, payment methods, approval limits, Purchase Order-Invoice matching tolerances, holds and approvals.
• Carried out setups for Receipt Routings, Invoice Match Options, and Match Approval Levels and also developed an Auto Match form which is a 3-Way match (Invoice-Receipt-PO).
• Created the Min-Max quantity update process to update the minimum and maximum quantities of items at different sub-inventories.
• Implemented order processing cycles: Standard, Planned, Blanket & Contract Purchase Orders, Scheduled and Blanket releases.
• Customized iProcurement module according to the user requirements for the client.
• Data loaded into temporary table from a flat file and then into AP INVOICES INTERFACE and AP INVOICE LINES INTERFACE tables.
• Designed and maintained Item Import, Requisition Import and Purchase Order Import Interface.
• Prepared the technical specification documents for importing Open PO’s also involved in importing vendors into PO VENDORS and PO VENDOR SITES.
• Involved in the reconciliation of AP with respect to GL accounting and Provided Support during Go Live and post implementation process.

Environment: Oracle Applications R12.1.3, 11i ( INV, AP, AR, CM, OM, GL), iProcurement, Workflow Builder 2.6, Oracle Forms 10g, Oracle Reports 10g, SQL, PL/SQL, SQL*Loader, Oracle 10g, Windows XP.

Confidential

Oracle Apps Functional/Prod Support Consultant.

• Responsible for Analysis, design and development for customization, new developments and data migration.
• Worked with Implementation team in configuring setups forOM, INV, AR, CM for Order to Cash cycle.
• Defined customer profiles, customers, payment terms, payment methods and tax structures,including tax exemptions in Accounts Receivables.
• Defined AR transaction types, Document sequences, Defaulting Rules, Dunning letters and Statement Cycles.
• Created Distribution Sets, Receipt Sources, Receipt Classes, Payment Terms, Application Rule Sets, Auto Accounting Rules & Auto cash Rule Sets.
• Designed a single program to import invoices into AUTO INVOICE INTERFACE tables from different sources.
• Designed conversion programs to import legacy system transactions like Regular Orders, Inter Company Invoicing, Regular invoicing, and Invoicing with Rules in OM.
• Designed many reports like Pick Slip, packing Slip, Mailing Label for shipping and Credit Order Detail, Orders by Item, Order Detail & Summary Reports for Order Management
• Implemented Automatic upload & Bank Reconciliation functionality in CM and Auto Lock box Functionality in AR.
• Involved in data migration from Flat files into the respective Oracle Database tables using SQL* Loader scripts.
• Provided the post Implementation production support and resolved issues related to day to day activities.

Environment: Oracle Applications R12, 11i (AP, AR, CM, GL, INV, PO), Workflow, Oracle Forms 6i, Oracle Reports 6i, SQL, PL/SQL, SQL*Loader, Oracle 10g, Windows XP.

Confidential

Oracle Apps Functional/Prod Support Consultant.

• Responsible for pre-implementation, implementation and post-implementation support of Oracle Application Financials AP, AR and GL modules.
• Created Set up of Set of Book (SOB), Calendars, and Currency. Set up of Key Accounting Flex fields with 7 Segments.
• Created set of books, defined responsibilities, value sets, flexfield structure, segment values, calendar, currencies, chart of accounts etc.
• Created parent-child relationships for segment values and defined Rollup Groups and Summary Accounts.
• Defined Budgets, Budget Organizations, and Budget Formulas, Budgetary control options, Mass Budgets and created Master/Detail budgets.
• Defined formulas for Mass Allocation, Recurring Journals and Statistical Journals.
• Defined flex fields, creating value sets, registering concurrent programs, adding users, setting up responsibilities.
• Defined Validation rules, Short hand aliases and Security rules.
• Designing and generated reports for management information needs and third part reporting using the Financial Statement Generator (FSG).
• Imported journals, from different modules, reconciled and posted in GL, for closure of GL accounting periods.
• Designed custom Interface for importing journals into GL INTERFACE table and imported data via Journal Import into GL JE HEADERS, GL JE LINES, and GL JE BATCHES.
• Developing functional test cases, Unit test cases and Integration test cases for carrying out pre development testing under Test Instance/environment

Environment: Oracle APPS 11i (AP, AR, and GL), Windows NT, Oracle 8i, Reports 6i, Forms 6i, Discoverer 4i, TOAD, SQL*Loader, PL/SQL, SQL* Plus.

Confidential

EDI Consultant

• Primarily focused on production map fixes.
• Analysis on data failures in Production.
• Build Routing Rules, Doc extraction, map creation and Envelope creation.
• Developed Business Processes for FTP and SFTP communications.
• Configures AS2 profiles for sending files and receiving files using AS2 protocol in SI.
• GAP Analysis and created Mapping Specs.
• Enhancements and new map developments.
• Worked on Step-up and Step-down conversions from 4010 to 5010 and vice-versa.
• Worked on various file types like XML, Flat Files, SAP IDOCs and EDI Standards
• Worked on implementing various types of outbound processes (XML to X12, IDOC to X12, and .CSV to X12) and inbound processes (X12 to XML, X12 to X12, X12 to .CSV).
• Created inbound and outbound Maps for transactions 837, 835, 834, 270,271,276,277 transactions.
• Deployed maps into SI.
• Created an automated process for loading envelopes into SI using a specific type of load sheets and envelope maps.
• Created routing rules for transferring files from one mailbox to other and their processing.
• Created Document extraction maps.
• Created test cases for integration testing

Environment: Sterling Integrator 5.0, ANSI X12, UNIX Shell Scripting, SAP IDOCs.

Confidential

EDI Consultant

• Developing GIS maps Using Paper Maps.
• Reviewing the Paper maps.
• Involved in mapping ANSI X12 810, 850, 856, 860, 940, 945, 944, 214, 846, 867, 855, 816 Transactions for various trading partners.
• Used EDIFACT Messages ORDERS, DESADV, INVOIC, CONTROL, TAXCON, INVRPT Messages.
• Created the Business process and automated the whole Inbound and outbound.
• Created Envelopes for Inbound & Outbound and Code list for different trading partners in GIS.
• Having Good experience in developing business process using business process integrator 4.1 and 4.3.
• Monitor inbound and outbound EDI transactions and associated error notification and logs, troubleshoot issues, and resolve them in a timely basis.
• Going through implementation guide and creating the mapping specks to interact with the Trading partners.
• Developed maps to translate customer EDI to SAP IDOC and other custom flat file formats.
• Developed maps to translate the XML to SAP IDOC structure for internal needs.
• Sending test data to the partner & checking the acknowledgements.
• Involved in Unit testing of the maps.
• Involved in preparing the documentation of developed maps.
• Involved in Unit, Functional & Integration testing.
• Configured the FTP, AS2 and VAN’s to integrate with the business partners to transfer the files.
• Raising help tickets to create the mailboxes and adding trading partners in the VAN.

Environment: GIS 4.3, Sterling Map Editor, ANSI X12, Windows, SAP IDOC, XML.