SUMMARY:

• Over 7+ years of extensive experience as Oracle Applications Techno - Functional Consultant in implementation, upgrade and customization of Oracle e-Business Suite Applications. This includes system study, design, development, roll outs, post implementation maintenance and support of Oracle EBS.
• Oracle EBS Implementation experience includes Banking, Insurance/Mortgage, Manufacturing, Oil & Gas, Retail, travel and tourism, shipping, logistics and Storage and data management Industry.
• As an Oracle EBS(11i/R12) Techno-Functional Consultant, has executed 5 projects that includes end-to-end implementation, support, enhancement and upgrades.
• Expertise in Oracle Finance (GL, AR, AP, EAM), Oracle SCM (OM, SC, INV, BOM), Oracle CRM( Adv. pricing, Quoting, configurator) and P2P (PO, AP, iProc).
• Experience on both Quote to Cash, Procure to Pay cycle and Record to Revenue cycle.
• Expertise in Implementation of Revenue tool like RevPro 2.4/3.0.
• Extensively worked on Oracle SQL, PL/SQL, Report, Forms, Workflow Builder, XML/BI Publisher, UNIX shell script and having knowledge SOA (Oracle SOA11g) and OAF.
• Experienced in detailed analysis, collecting requirements, technical specifications, development and unit testing, integration and production install and support.
• Extensive experience in Design, Development, Customization and Implementation of business applications using Oracle Applications, SQL, PL/SQL, Oracle Workflow, Developer 6i/9i/10g and XML/BI Publisher, Discover Report.
• Extensive experience in Implementation, Migration, Customization, Production and Support of various modules in Oracle Applications with major focus in Order Management (OM), Inventory (INV), General Ledger (GL), Accounts Receivable (AR), Accounts Payables (AP), Purchasing (PO).
• Expertise in Order management, Purchasing, Account Receivable, Account Payable, Inventory, CA and GL.
• Strong conceptual knowledge on business processes in Inbound and Outbound Logistics, Operations and Supply Chain Management.
• Strong programming experience in creating Procedures, APIs, Packages, Functions, Triggers views, collections (nested tables and arrays), records, sequences, Materialized views, Constraints and other database objects using SQL and PL/SQL.
• Highly conversant with various modules of Oracle Financials (GL, AP, AR), Manufacturing/Supply Chain/Distribution (INV, PO, BOM, OM, eAM), MDM (CDH (Customer Data Hub) and SDH (Supplier Data Hub)), System Administration and AOL.
• Exposure with Oracle EDI Gateway and Oracle Release Management, transferring EDI documents from the legacy system to Oracle.
• Worked on RICE components involved in creation of Reports that are not available as standard reports, creation of the Interfaces to external systems, creation of Conversion programs to transfer data from a legacy system to the new system and Extensions to the existing system to add additional functionality to existing system without disturbing the core software functionality of the system.
• Participated in multiple Oracle apps 11i/R12 implementation in multi org/ multi-currency scenarios, order management and worked as areas involving pricing, purchasing, and Inventory.
• Experience registration of concurrent programs, request sets, creation of Users, Responsibilities, Forms, Functions, Values Sets and Flexfields in Oracle Applications
• Developed SQL Program to load data from Excel files, flat files into temporary table using UTL FILE utilities and SQL loader.
• Experience in developing, customizing, modifying forms, reports existing in Oracle Applications according to the business requirements and specifications using Oracle Developer Suite 10g/9i(Forms, Reports) and other front-end tools.
• Experience in creating a new workflow and calling the workflow in the forms as done in the standard Oracle form.
• Extensively involved in SQL tuning, troubleshooting, debugging and fixing the codes/scripts, Month-end activities and production support.

SKILL:

Application Modules: Oracle Process Manufacturing (OPM), General Ledger (GL), Accounts Payables (AP), Accounts Receivables (AR), Oracle Purchasing (PO), iProcurement, Supply Chain Management (SCM), Oracle Fusion HR, OTL, Receivables(AR) Order Management (OM), Inventory (INV), Payroll, Work in Progress (WIP), Project Accounting, Q2C, Oracle Alerts, XML Gateway and e-Commerce Gateway.

Tools: Oracle Forms (6i/10g), Oracle Reports (6i/10g), Oracle Workflow Builder, XML/BI Publisher, JDeveloper, Visio, Putty, SQL, PL/SQL, UNIX.

Oracle EBS Technical Skills: Oracle PLSQL Programming, Oracle APIs to perform standard transactions through programs, Integration Development (SOA Middleware), Unix shell scripts, HTML Report development, ETL (Extract, Transform and Load), ADI Development, SQL Loader, Oracle Form (UI) Personalization BI Publisher Report development XML Reports development RICE Development System Administrator Setups Data Conversion program development Oracle Reports & Forms development

Oracle EBS Functional Skills: Order management Purchasing Inventory Work in Process Bills of Material HRMS General Ledger Account Receivables Account Payables Project Accounting Kronos

EXPERIENCE:

Sr. Oracle EBS Consultant

Confidential, Austin, TX

RESPONSIBILITIES:

• Worked with internal architects and, assisting in the development of current and target state enterprise data architectures and worked with project team representatives to ensure that logical and physical data models were developed in line with corporate standards and guidelines. Worked with internal architects and, assisting in the development of current and target state enterprise data architectures
• Worked with project team representatives to ensure that logical and physical data models were developed in line with corporate standards and guidelines.
• Involved in defining the source to target data mappings, business rules and data definitions.
• Experience with various ETL, data warehousing tools and data conversion methods.
• Documented the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Developed a data acquisition tool to gather the underlying business logic and transformed it to a data mart for future analysis.
• Worked Oracle EBS R12.1/R12.6 GL and AP modules to migrate the AP Invoices, Suppliers, GL Account Balance, GL Journal, GL Accounts, etc. to the financial data mart through a custom based ETL process.
• Worked with AppTalk and Informatica integration teams through requirement analysis, mapping, design and development of ETL for different modules including:
• Oracle EBS, DotCom order processes System (OLS) to add bundled returns functionality to existing DotCom order processes
• Order Invoice Publication Management System (OMS) to add mobile activation keys to existing Order Invoice publication
• Bounty Extract Application for Sales Transaction Revenue (BEAST RA) to add sales transaction line number to bounty extract process
• Mobile promotion gift cards (CAR) to create new extract to identify mobile activation keys for DotCom promotions.
• Transactional: AP Invoices, AR Invoices, AR Receipts, Journals, SO, PO, Item on hand, Sourcing Rules, BPA, Item categories, Item cross references and Item costs
• Worked on setting up the new tax rates including VAT and withholding taxes as localization requirements, I - expense templates (parking, per diem, corporate cell phone and mileage rates), Approval Hierarchies in Purchasing Module, and Fixed Asset Books and Categories, Corp, TAX and State Book.
• Sales Data Repository (ODS) to create new extract of audited sales, fulfilled open orders & unaudited/audit gaps
• Retail Audited Sales (ReSA) to create new extract to identify mapping of sales/orders to GL
• Retail Management System (RMS) to create new extract to identify mapping of unmatched receipts to GL
• Retail Invoice Management (ReIM) to create new extract to identify mapping of (3-way) matched invoices to AP
• Oracle EBS to create new GL extracts (acct balances & journals) and new AP extract
• Promotional Metadata (OMT) to create new extract of promotional metadata
• Requirement Analysis, Design and Development of full ETL cycle from staging to base tables (fact and dimension tables) through PL/SQL procedure in Oracle 12c.
• Design and implementation of Batch Processing on Red Red Hat Enterprise Application Server by using Master Data Maestro Suite on Linux.
• Design and implementation of Data Quality Assurance (DQA) package to support SOX controls on all transactions.
• Conducted a comprehensive research to design an interdisciplinary data model based on the business requirements

Oracle EBS Consultant

Confidential, Providence, RI

RESPONSIBILITIES:

• Performed all the setups for OM, Shipping and Advance Pricing, AR, INV modules.
• Flow Testing for SCM Modules (AR, AP, OM, WSH, QP, BOM, INV, PO) to make sure flow is working without any issues.
• Automation for O2C and integration with third party systems.
• AME integration with iProcurement and iExpense. AME setup for iExpense and iProcurement applications. Approval process setup by defining / modifying Attributes, Conditions, Actions, Approval Groups, and Rules.
• Worked extensively on understanding the proposed 100% customized business logic of the Business in building the customized solutions for Shipping on OA framework Technology based on the legacy of Oracle application E - business suite 11.5.10. All the above bases business logic was captured in OA Framework code.
• Design & customization, RDF and XML Publisher Reports, Oracle Workflows, Form Personalization in OAF.
• Analysed the custom code components in proc to pay process and retrofitted custom PL/SQL Packages, Reports, Forms, and Workflows to make them work in R12. Personalization and Extension of OAF pages in various modules.
• Created multiple Complex OAF Pages for Purchasing, Order Management, and iExpense which included Partial page rendering functionality
• Lead a team of OAF developers and workflow consultants to accomplish the custom module development in time
• Baselined technical design and migration documents for OAF.
• Created a custom application from scratch using oracle OAF (Querybean, Create Page - Tables, Advanced Tables, Shuttles, Invoking DB procedures/API's and workflows etc.)
• Worked on enhancement of seeded iExpense OAF pages like modification of LOVe for fetching the data from third party systems by calling the web services, adding the custom regions and enabling partial page rendering at multiple levels, extending the VO, creation of validation view object, adding Entity expert to the standard EO.
• It is required to gain operational efficiencies by moving the organization on same CRM, ERP and Quality systems. Bright 2.0 program is responsible for process mappings, application integrations, infrastructure setups and implementing quality control procedures as per standards.
• Implemented changes to send pick tickets from the OE/OM module (based on the delivery shipping model; WSH) to a vendor's warehouse management system (WMS). Extensive architectural changes and enhanced error checking. Also, enhanced the custom ship confirmation process which takes ship confirmations from the vendor's WMS, and loads them into the standard Oracle Applications interface tables (Open Shipping Interface) so the data can be populated (via the standard Oracle API) into the OE.
• Understanding complex business requirements and processes and liaising between Business Analyst / External Partners and development team.
• Spearheaded functional training on Order-to-Cash for technical team and technical trainings on OAF and Java for Global IT team.
• Order Management O2C (Order to cash) end-to-end cycle using API as Shipping is being done from legacy systems.
• Order Management and Purchasing enhancement for integrating it with Third Party Logistics information systems.
• The Returns feature in Oracle Receiving does not provide the flexibility to track the returns. The Business process requires Return to Vendor functionality to provide an efficient method of controlling the return and exchange of items bought from suppliers, ensuring visibility and tracking of the item until the transaction is concluded.
• Kit Cross Docking project to automate many parts of the processing of Affiliate packaged Kits containing multiple saleable SKU. A custom OAF page was developed in which unique Kit ID and detailed component data get housed. Users can view Kit ID data and Receive, Put Away, Pick and Ship Kits at a Kit ID Summary Level. By updating the form at the Kit ID level, an automation of all Kit component transactions take place.
• Oracle ERP R12 implementation.
• Order Management, Requisition, Account Generator workflow customizations.
• Liaise between vendors and internal Project teams for business/Technical requirements.
• Leading solution design for Oracle Manufacturing, Purchasing and Supply chain modules.

Oracle EBS Analyst

Confidential, New York City, NY

RESPONSIBILITIES:

• Support to daily tickets for Oracle EBS in modules QA, PO, Bill of Materials (BOM), INV, PER (HRMS), PAY, Construction Module (MC), PA, AP, GL.
• Analysis and design of new developments. Fix bugs of actual developments.
• Work as sysadmin with oracle on demand team.
• Raise and follow up for SR & RFC to oracle support.
• Train key and end users in oracle EBS implementation.
• Interact with end users and suppliers to raise new requirements for oracle developments.
• Gather and develop new RISES (Reports, Interfaces, Setup and Extensions) for EBS 11.5.10.
• Setup new operating units for modules INV, PO, AP, AR.
• Support to daily operation for construction users.
• Help in assessment for implementation of R12 for all EBS modules in company.
• Implementation of PO, AP, INV modules in 2008 to interact with construction module.
• Created functional design documents such as BR100, M050, etc.
• Completed the configuration set ups for the Primary (Corporate) and Secondary ledgers for various country businesses - the international subsidiaries
• Defined the security rules and CVRs for the EGL and uploaded them into Oracle form using a data loader
• Performed all account mappings for the EGL
• Worked on the integration of the EGL with ECAS- the Employee Compensation Allocation System, and the APS- Allocation Processing System.
• Created and successfully tested the functionality of Interface tables integrating EGL to APS and ECAS
• Maintained document and information-sharing web-based SharePoint application for project participants, consumers and principals alike.
• Maintained the Oracle EBS Test environments- UATTEC and UATFIX