SUMMARY

• 10 + Years of professional experience in ERP implementation and Production Support of Oracle E - Business Suite Supply Chain Modules namely Inventory (INV), Order Management (OM), Purchasing (PO) and me-Procurement
• Extensive hands on experience on Oracle Inventory (INV), Purchasing (PO), me-Procurement and Order Management (OM) modules.
• Strong implementation knowledge of O2C(Order to Cash), P2P(Procure to Pay), Quote to Cash, Back to Back order and Drop Ship end to end Cycles
• Proficient in functional aspects of Oracle General Ledger (GL), Accounts Payables (AP), Accounts Receivables (AR), Advance Pricing.
• Extensive experience in documenting BR100, BR120, MD50 and TE20 documents.
• Good knowledge on the new features of Oracle Release 12 in SCM domain coupled with strong Supply Chain domain knowledge.
• Proactive participation with Business in configuring Oracle Supply Chain modules setups - INV, PO and OM.
• Strong Exposure in preparing Requirement Analysis Documentation, high-level functional design documents for Custom application development, Conversions, Interfaces & Reports.
• Proven expertise in handling post production issues, proposing turn around solutions and permanent fix for repetitive issues and conducting knowledge transfer sessions on business and process flow to fellow colleagues.
• Has thorough knowledge on handling month-end issues.
• Proven expertise in business process mapping, analysis, design and configuration.
• Proven expertise in performing functional and regression testing of various applications.
• Very good understanding of Oracle AOL components - creation of dependent and independent value sets, executables, concurrent programs, responsibilities and KFF.
• Strong on technical basics - writing SQL queries, retrieving data from database and code review.
• Proven expertise in interacting and coordinating with different stakeholders (interfacing systems, business users etc) in case of a production issue.
• Experience in leading a team and working on onsite-offshore model effectively.

TECHNICAL SKILLS

Programming Languages: SQL, PL/SQL, C, C++, Shell script, Java 2.0

Middleware Technology: Oracle SOA Suite 11g, OBIA 11g

Databases: ORACLE 9i/8i/8/7x, MS SQL Server 2000, MYSQL, MS-Access.

ERP: Oracle Financials 11i/R12 Business Suite, Oracle Financials (General Ledger, Account Receivables, Trading Community Architecture (TCA), Account Payables, Oracle Purchasing). Inventory, Order Management, Shipping, Pricing, BOM, Application Object Library (AOL), Oracle Install base, Service Contracts.

Testing Tools: LoadRunner 7.x (Automation Tools), Regression Testing, Unit Testing, Quality Center

Operating Systems: MS-DOS, Windows Vista/XP/ 2000/NT 4.0/98/95, Linux 6.2 / 7.2, UNIX AIX.

Others: Visual SourceSafe, Concurrent Version System (CVS), Project Revision Control System (PRCS) (Version control tools), REMEDY, INOVIS, GENTRAN,XML,XSD,XSLT,WSDL

PROFESSIONAL EXPERIENCE

Confidential

Sr. Oracle ERP Consultant

Responsibilities:

• Involved in the data migration related requirements analysis
• Define use cases, test plans, test cases and execute and validate them. Work with end users and developers to ensure high quality, on time outcomes both simple and complex applications.
• Contributes to the overall strategic vision, and integrates a broad range of ideas regarding implementation and support.
• Undertakes implementation and support projects involving single disciplines,that may impact multiple business units.
• Elicit and define requirements, formulate process flows, configure systems, test, and train users in multiple applications.
• Provide functional expertise and work with developers and users to leverage technology for business operations. Analysis and testing of ERP systems.
• Responsible for requirements gathering, validation, definition and documentation. Configure and integrate between major functional areas.
• Translates customer requirements into a best fit within the application, and develops processes and documentation that support the SDLC.
• Document system processes and requirements traceability.
• File Import in BI: Work done to import Third Party data file in the BI Finance area. The areas covered were new SDE/ SIL mappings for incremental run, new SDE mapping for historical update, new columns added to tables in the RPD, creation of new complex reports to show the file data in terms of the financial impact of expenses
• Work done covers requirement gathering /analysis, development in OBIA requirements with writing of MD50, Unit and System Testing with TE20, TE25 documents covering requirement gathering, following AIM methodology
• Other Tasks: Test case creation for the development and data entry in EBS and or dummy data creation in staging/ temporary tables. Setting up TASK execution priority in ETLs.
• Involved in the OBIEE R12 Upgrade Impact analysis and approach.
• Involved in the Bug fixing/Analysis of the Production issues raised by the Business
• Involved in the Oracle R12 upgrade remediation activities
• Involved in the data migration for Oracle R12 upgrade
• Enhancing the existing Custom OBIA report for the Autosys Upgrade
• Involved in the Implementation of P2P (Procure to Pay) process.

Confidential, Portland, Oregon

Oracle Functional Analyst

Responsibilities:

• Involved in the Implementation of O2C (Order to cash) Cycle.
• Coordinated with the Business and technical consultant teams, for the business process understanding, unit and integration test script documentation, on-time delivery of documents, and identification and documentation of the custom objects
• Wrote SDDs - Solution Design Documents for custom components.
• Wrote various Test scripts (T034 docs) for custom interfaces/conversions.
• Involved in Post implementation Burn-in support.
• Involved in SIT
• Designing and Development of various Inbound and Outbound Interfaces viz., Sales order importing, Notice of Invoices and Notice of Adjustments, etc pertaining to AR, OM modules of oracle applications.
• Reviewing and Testing of offshore deliverables
• Involved in Business meetings for the requirement analysis and gathering.
• Involved in the functionality testing of deliverables.
• Developed Customer Interface to create and maintain customers using TCA APIs.
• Creating process flow diagrams using swim lanes and presenting them to source system analysts & business team members.
• Involved in the Drop ship cycle implementation for the Supplies project.
• Preparing the solution design documents by coordinating with Business analysts.
• Participated in all BRD - Business Requirement Documents (owned by business analyst) review meetings where me worked closely to map business requirements with Oracle Standard processes and some custom processes.
• Owned all the setups related to the drop ship functionality in OM, PO and INV.
• Worked on complex order inbound interface.
• Owned OM setups like defaulting rules, Transaction types, payment terms and processing constraints...etc.
• Addressing of the functional issues related to EIA application.
• Upgrading the customizations from 11.5.10.2 to 12.1.3
• Remediated the 11i customizations based on R12 changes and Upgrade Impact Analysis.
• Testing the customizations and interfaces after the upgrade in GL and FA modules.
• Participating in CRP discussions, doing proof of concepts, setups…etc.

Confidential, Malvern,PA

Oracle Business Analyst

Responsibilities:

• Track lead for 5 associates.
• Responsible for production support and delivery of Oracle, SCM, CRM on behalf of onsite (USA) and offshore (India) delivery team.
• Meeting strict SLA’s of client in terms of delivery and support to the business.
• Resolving of Production related tickets pertaining to EDI, SCM and CRM modules of ERP and timely co-ordination with the team for timely delivery.
• Supporting the month end activities in Oracle for period closure.
• Raise Service requests with Oracle for application bugs and resolution.
• Preparation of defect analysis reports.
• Responsible for 'Tuning of the SQL queries'.
• Responsible for releasing of code to various instances
• Coordinating with onsite (USA) for resolving the Production issues related to SCM, Field IT, Data Load, Batch jobs.
• Preparation of the Ticket Tracker report on daily basis for the Issues resolved.
• Client liaison and Project Management for Oracle Applications
• Responsible for the development of reports in Oracle Discoverer.
• Preparation of Daily, Weekly, Monthly and Quarterly Reports to the client
• Coordinating with onsite (USA) for resolving the Production issues related to SCM, Field IT, Data Load and Batch jobs.
• Understanding the existing Order to Cash flow of e-IKON Business process
• Identifying the beneficial areas of the proposed enhancement project in e-IKON Business
• me am responsible for preparing delivery schedules, metrics preparations and offshore - onsite team co ordination.
• Requirement gathering and evaluating specific requirements.
• me am key participant in major discussions on backbone components of the project created Mapping Documents to map the legacy sales order record fields to Oracle sales order.
• Prepared test case and test data documents, and Implementation Plans.
• Functional testing of the custom interfaces once code is delivered by the developer.
• Executed the BR - 100 set up documents for INV, OM modules.

Confidential, FranklinPark .,IL

Techno Functional Consultant

Responsibilities:

• Involved in importing ITEMS, Suppliers, WIP Orderless, GL Journals and Balances from legacy system to Oracle Applications using the standard programs.
• Involved in setting up the price lists with Functional Lead based on the client’s criteria
• Development of Reports.
• Customized the PO form for populating only the Blanket PO in the PO type
• Developed about 3-4 forms, which effectively gives a look and feel of Oracle Applications whilst keeping the Mainframe functionality in view.
• Has worked on creation of Operating Unit-A new Business that entered India Market
• Owned the set up for an Inventory Organization completely.
• Owned the set up for Sub inventory-Locator definitions.
• Owned the set up for Blanket Purchase Agreements, Blanket Releases, Standard Purchase orders
• Involved in Conversion of Journals and GL Balances from the Excel sheet to the Interfacing table using SQL*Loader. Then submitted Journal Import to port data to base tables
• Calling built-in oracle packages to submit concurrent requests.
• A best approach TEMPhas been derived to populate the required order information
• Automatically starting various Concurrent Processes from PL/SQL procedures
• Testing the transactions in the Multi-Org setup to ensure all the user requirements are being addressed
• Prepared Item Templates to be used for Item Definition
• Requirement gathering and participation in discussions with Management related to incorporating required Business Process implementation.
• Prepare Functional & Technical documents (MD50, MD70) based on AIM methodology.
• Responsible for the registration of the developed reports in Application Object Library (AOL).
• Developed programs to extract vendor related data in Oracle Applications PO module including details like vendor site, contacts, term’s etc. The data was extracted in the form of an Excel spreadsheet.
• Created various data files, which included details such as all Open Purchase Orders, and all PO’s less TEMPthan a particular amount.
• Extensively Involved in the design and development of PL/SQL packages for loading Blanket Purchase Orders having thousands of items using Standard APIs like Purchasing Documents Open Interface, Requisitions Interface.
• Designed and developed complete Invoice Import interfaces for import of Invoice information into the system. Used SQL * Loader for import into interface table and PL/SQL block for complete validation of data and inserting into base tables.
• Created Custom reports and Customization of Standard Reports in OM, which includes extensive PL/SQL code (Procedures and Functions).
• Prepared ER Diagrams, Data flow diagrams based on the requirement.
• Written SQL scripts to create database objects like tables, views and sequences.
• Used SQL*Loader to load bulk data from various flat files.
• Extensively worked on Format Triggers, Formula Columns, Summary Columns, Placeholder Columns and Ref Cursor Query for developing the reports and prepared complex Data Model and Data Layout in Oracle Reports 6i.
• Developed Interface to load Sales Orders from the Legacy System to Oracle. Used Oracle API for loading the Sales Orders and creating RMAs and used EDI interface also.
• Developed database triggers on insert or update on MTL ITEM CATEGORIES table.
• Developed a Custom Package to update and add pricing attributes to Items