SUMMARY

• Over 10+ years of experience in ERP Implementation, up gradation, Customization, Analyzing, Developing and Support of Oracle EBS and in EDI wif various tools.
• Worked wif 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 wif Discoverer reports.
• Worked as Production Support analyst and helped in Resolving Open Issues relating to oracle applications.
• Worked wif Oracle Support and go through teh Service Request Process, and solve Implementation/Support Issues.
• Experience in Data Conversion from Legacy Systems to Oracle Applications.
• Worked wif System administrator and AOL modules for Creating User, Assigning teh Responsibilities, Creating Concurrent Executable, Concurrent Programs and setting profile options as per teh 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 wif SAP R/3, SAP IDOCs, XML and Internet based EDI.
• Strong interpersonal skills, ability to interact wif 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, ATL, GA

Oracle Apps Functional/Prod Support Consultant

Responsibilities:

• 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 wif 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 teh BA team to roll over multiple subsidiary companies into parent company COA structure so they can be maintained under teh same LE, OU as per teh 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

Responsibilities:

• 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 teh Min-Max quantity update process to update teh 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 teh user requirements for teh 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 teh technical specification documents for importing Open PO’s also involved in importing vendors into PO VENDORS and PO VENDOR SITES.
• Involved in teh reconciliation of AP wif 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

Responsibilities:

• Responsible for Analysis, design and development for customization, new developments and data migration.
• Worked wif 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 wif 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 teh respective Oracle Database tables using SQL* Loader scripts.
• Provided teh 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

Responsibilities:

• 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 wif 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 teh 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, Stamford, CT

EDI Consultant

Responsibilities:

• 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

Responsibilities:

• Developing GIS maps Using Paper Maps.
• Reviewing teh 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 teh Business process and automated teh 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 teh mapping specks to interact wif teh Trading partners.
• Developed maps to translate customer EDI to SAP IDOC and other custom flat file formats.
• Developed maps to translate teh XML to SAP IDOC structure for internal needs.
• Sending test data to teh partner & checking teh acknowledgements.
• Involved in Unit testing of teh maps.
• Involved in preparing teh documentation of developed maps.
• Involved in Unit, Functional & Integration testing.
• Configured teh FTP, AS2 and VAN’s to integrate wif teh business partners to transfer teh files.
• Raising help tickets to create teh mailboxes and adding trading partners in teh VAN.

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