PROFESSIONAL SUMMARY:

• Overall 10+ years of extensive experience in all phases of Enterprise Software Application Development encompassing the full project life cycle (SDLC).
• Expertise in Implementation and Support for Oracle - EBS projects in the Functional & Technical areas of Financials (AP, AR, FA, SLA, GL, IBY, CM), I-Procurement and I-Expense & SCM (PO, OM) Manufacturing (INV, WIP, BOM) modules of Oracle Applications
• Strong implementation knowledge in P2P& OTC Cycles. Good understanding of TCA, AME & FSG setups.
• Worked on roles like Team Lead, Module Lead, Functional and Techno-Functional Consultant in Oracle EBS.
• Commendable Experience in performing Pre-Assessment Studies, Gap Analysis, Process Re-Engineering, Post Implementation, System Integrations.
• Have been engaged in an Oracle EBS R12 Implementations, Upgrades and Roll outs.
• Proficient in mapping customer business process/requirements to Oracle Applications flow, analyzing gaps and designing gap fillers.
• Strong Analytical skills in System Configuration, Data Migration, Database Application Design & Development.
• Expertise in Data Modeling, Manipulation Migration and Data Building.
• Expertise in Multi-org concepts, Oracle Apps Architecture, Directory & Schema structure in Oracle Applications.
• Expertise in developing Interfaces & working with API’s & customizing new forms using OAF & Oracle Apex.
• Experienced in Full Life Cycle Implementations using RICE concepts, Workflows Admin and BI/ XML Publisher.
• Expertise in the Oracle Applications Technology layer like: Oracle Applications Object Library (AOL/FND), System Administration.
• Expertise in PL/SQL, Toad, SQL Loader, and UNIX shell Scripting.
• Strong understanding of AIM methodologies and project management and documentation.
• Excellent motivational, interpersonal, written & oral communication skills with the ability to assess complex business problems navigate through challenges & implement Solutions.

TECHNICAL SKILLS:

Languages and Tools: PL/SQL / Unix Scripting / AOL / Workflow / TOAD / SQL Workbench / Reports / OA-Framework / Oracle Apex / jDeveloper / BI/XML Publisher / HTML5 / JavaScript / JQuery / AJAX / Bootstrap / CSS3.

Analysis Methodologies: AIM / Agile / Scrum.

Analytics Tools: Tableau / Incorta / OBIEE.

Source Control: Github / Tortoise SVN / Serena PVCS / CVS.

Defect Tracking Tool: Remedy / JIRA / Service Now.

Database: Oracle / Microsoft Access / MY SQL / SQL Server / Mongo DB

Operating Systems: Windows / SUN Solaris / RHEL.

Oracle Apps: R12 (12.0.3,12.1.3,12.2.5) / 11.5.10.2 / 11.5.9.

Oracle APEX: Apex Version 3, 4, 5

Modules: General Ledger, Accounts Receivables, Accounts Payables, Cash Management, Fixed Assets, Purchasing, Inventory, Order Management, Shipping, Configurator, Bill of Materials, Work in Progress, I-Expense, I-Procurement.

WORK EXPERIENCE:

Confidential, Palo Alto, CA

Sr. Oracle Techno-Functional Consultant

Responsibilities:

• Involved in implementing the Cash Management and Fixed Assets and also in setup of the BAI2 files.
• Setup of Bank Transaction codes for Bank Statement import.
• Worked on Mass Addition Interface to bring legacy assets in to Oracle in FA.
• Handled Unreconciled Bank statement transactions by extending the workflows.
• Setup of creating Misc AR receipts for unreconciled expenses.
• Integrated internal workorders with AP for invoice creations.
• Worked on FICO Implementation for integration of iExpense and REQ, PRS to create VIEWS.
• Automated Wire Payment Process by configuring Payment Profile and designing EDI Template according to Wells Fargo specification.
• Developed Payment programs for electronic payments and In-house Check printing and outsource Check.
• Implemented integration of on demand Supplier Creation within the transaction.
• Worked on integration of PeopleSoft with SIMES DB for tracking of students funding at project level.
• Integration with Oracle and ETL to track payroll distribution charges of federally sponsored projects for Certification based on input provided by Business stakeholders and SMEs.
• Designed & Implemented a new system for University Budget Office for better planning, forecasting & transfers of one-time funding from central to budget units & with in the schools & departments by eliminating the third party system & integrated the journal transfer to GL.
• Implemented GL Multi-Table Import to maximize GL Import Performance.
• Integrated other 3’rd party systems to EBS
• Customized the SLA pages for the CE responsibilities depending on the access levels.
• Extended the View Objects and Application Modules to display additional information in the Cash flow pages in Cash Management.
• Developed several forms in Apex and OAF according to the client requirements.

Environment: Oracle Apps R12(12.1.3,12.2.5) (GL, AR, AP, PO, CE, FA, PA, iProcurement, iExpenses, Inv), TOAD, Oracle 11g, UNIX, Developer 10g, OA Frame Work, Oracle Apex, jDeveloper, Workflow, JavaScript, JQuery, CSS.

Confidential, Las Vegas, NV

Sr. Oracle Techno-Functional Consultant

Responsibilities:

• Developed a project plan for Process Playback, Conference Room Pilot and User Acceptance Testing.
• Lead the team for developing test scripts for Post-Implementation verification.
• Support of R12 Upgrade from 11.5.10
• Involved in change of setups for Trading Partners.
• Utilized XDO loader Utility for Migration of templates.
• Customized the Sub Ledger Accounting Events, Journal Entry Lines and supplier entry Pages.
• Customized and extended several objects in HRMS for the self-service pages.
• Extended the View Objects and Application Modules to display additional information in the Appraisal page in HRMS.
• Extended the controller to handle the Update, Correction logic in the Employee information Pages.
• Extended the Regions to add the Switch Cases for the update options.

Environment: Oracle Apps R 12.0.3-11.5.10 (GL, AP, PO, HRMS), TOAD, Oracle 10g/11g, UNIX, Developer 10g, OA Frame Work, jDeveloper, AIM.

Confidential, Emeryville, CA

Oracle Techno-Functional Consultant

Responsibilities:

• Worked in collecting requirements from users and prepared relevant documents for Logistics forms.
• Worked on Data Validation, Integration Testing and Fit/ Gap Analysis.
• Defined new line types depending upon the items selected.
• Worked with the multi organizations environment for creating PO’s receiving goods into oracle.
• Worked with accounting periods, purchasing periods.
• Performed system administrator tasks like providing access to other users, Creating menus, responsibilities etc.
• Defined new freights and freights costs by integrating with the carriers.
• Developed a conversion program for Archive and purging the history data of the work flow tables.
• Customized the PO Approval Path workflow depending on requirements.
• Developed a new form to maintain unique codes for the vendors, customers and consignees.
• Customized the existing reports and used BI/XML Publisher to enhance the quality of the report.
• Developed several reports like PO Acknowledgement, Online Bookings.
• Designed and developed Booking Pages using OAF where suppliers can enter goods information.
• Developed the Oaf pages with headers and lines level and added complex functionalities such as user restriction functions, uploading Attachments, E-mail notifications etc.
• Developed several line level pages and routed as per the transaction type selected.
• Created different responsibilities and attached the OAF pages and restricted the form access as per the responsibility logon.
• Created several Controllers for Data Validation and Calculation process.

Environment: Oracle Apps 11.5.10.2 (AP, PO, INV, OM and WSH), TOAD, Work Flow, Oracle 9i/10g, UNIX, Developer 6i/9i, OA Frame Work, jDeveloper, Workflow, AIM.

Confidential, Chicago, IL

Oracle Techno-Functional Consultant

Responsibilities:

• Responsible for working with individual Business Units to develop and analyze business issues.
• Imported Items from the legacy system and implemented AP as per the client requirements.
• Worked in full implementation of the Procure to Pay (PTP) cycle.
• Implemented the advanced options like Assemble to Order (ATO) and Configure to Order (CTO) for the client customers by creating various bills and configurations.
• Set-up the procurement hierarchy and defined catalogs for use on requisitions and purchase orders with approval limits.
• Involved in developing interface program for HR Payroll to GL which involves in collecting the business requirements from users, developing the interface program and also documenting the whole process.
• Developed the integration of Order Management with credit card companies for the validation of the cards and payments.
• Developed a conversion program for the import of the history of the sales order for the tracking of the customer’s history by manipulating the data.
• Developed Bills and routing conversions and registered as concurrent programs to make it as interfaces.
• Customized work flows for order imports, approval paths and email notifications in OM & PO.
• Documented the work using AIM methodology and explained the new changes for the daily end to end users.

Environment: Oracle Apps 11.5.10(GL, AP, INV, OM and BOM), TOAD, Work Flow, Oracle 9i/10g, Developer 6i/9i.

Confidential, Troy, MI

Oracle Techno-Functional Consultant

Responsibilities:

• Developed a project plan including test scripts used in Process Playback, Conference Room Pilot and User Acceptance Testing.
• Upgraded various technical components of P2P track to as per major architect changes in PO suite.
• Worked in Setting up AP by defining different setup options as per the FDD.
• Assigned purchasable items to different categories, organizations, buyers in Oracle Purchasing.
• Integrated Advance Pricing with Configurator and Order Management.
• Developed ATO & CTO models for item configuration by Customers.
• Incorporated and setup EDI for Purchasing.
• Created model items and assembly items and assigned alternates to them for the configuration option for the customers.
• Customized the interface program to create bills according to the configuration of the items and a work order is created against the bill.
• Developed Open Item Interface to import the data from legacy system and building data from payables invoice with minimum specifications.
• Standard and Custom sales order line type are imported from the legacy system into oracle order management by developing conversion.
• Developed an interface program for the import of the discrete jobs from the clients existing web based system for the work order creations.
• Developed a conversion program for the import of the intended bills and revised bills.
• Developed interfaces for import of the routings and routing documents into the existing oracle applications.
• Concurrent programs had been developed and attached to appropriate request group and responsibility.
• Customized Cancelled Orders Report and Order Discount Detail Report using Oracle Reports & Discoverer.
• Sales Orders are customized using BI publisher to add company logo and additional data.
• Developed Functional & Technical Design Documents (MD70) using AIM.

Environment: Oracle Apps 11.5.9 - 11.5.10.2 (PO, Inv, Pricing, OM, WSH, BOM and WIP), Work Flow, BI Publisher, Oracle 9i, TOAD, UNIX, Developer 6i/9i, AIM.