SUMMARY:

• Oracle Apps Finance Techno Functional Consultant adept at application development with over 10 years of experience on Oracle E - Business Suite Release R12 and 11i.
• Full lifecycle implementation for 5 Oracle R12 implementation projects for global clients in healthcare and industrial sectors. Part of Design, Development, SIT, UAT, PROD cutover and post production support.
• Involved in high level designing of solutions which would require minimal end user training and low impact on current production system.
• Lead teams to develop and document solutions custom solutions after breaking them down to quantifiable tasks.
• Diverse project experiences - Implementation, Re-implementation, Upgrade, Support and Archive.
• Proficient in SQL, PL/SQL, RDF,RTF BI and XML Reports, Forms and RICEW objects like Interfaces (Inbound and Outbound), Conversions, Extensions, Workflows and Web ADI development, including coordinating ground-up planning, technical design, coding and implementation.
• Proficient in writing stored procedures, Functions, Packages and Triggers using SQL, PL/SQL programming languages.
• Designed and developed solutions for various EBS modules like Accounts Payables (AP), Account Receivables (AR), Fixed Assets (FA), General Ledger (GL), Subledger Accounting (SLA), Purchasing (PO), Procurement, Project Accounting (PA), Inventory (INV), Cost Accounting/ Cost Management, Advanced Collections (IEX), iExpense, Order Management (OM), Field Service, Human Resource Services Management (HRMS) and Oracle Incentive Compensation (OIC) modules.
• Extensive functional business process knowledge across the Oracle E-Business Suite Cycles like Procure to Pay (P2P), Order to Cash (O2C), Record to Report (R2R).
• Experience in Trading Community Architecture (TCA) and Multi-Org Access Control (MOAC) in Oracle E-Business Suite.
• Followed both traditional waterfall methodology and Agile (SCRUM) methodology.

TECHNICAL SKILLS:

Oracle EBS Modules:  Accounts Payables, Receivables, Fixed Assets, Inventory, Purchasing, Order Management, General Ledger, Subledger Accounting, Field Service, Project Accounting, Human Resource Services Management, iExpense, Oracle Incentive Compensation and AOL.

Programming Languages:  SQL, PL/SQL

Oracle Databases:  Oracle 11g/10g

GUI:  Oracle Forms 11g/10g/6i

Database Tools:  SQL Developer, PL/SQL Developer, SQL*Plus, TOAD and SQL*Loader

Migration Tools:  Kintana, Serena PVCS, HPQC, Tortoise SVN, Win-SCP, SSH and Putty

Operating Systems:  Windows and Unix

PROFESSIONAL EXPERIENCE:

Confidential

Senior Oracle Techno Functional Developer

San Jose, CA

Environment: Oracle R12 - AR, AP, GL, SCM, INV, MFG

 Responsibilities:

• Retrofit of objects from 11i to R12 in AR, AP, GL and SCM modules.
• Design and development of utilities for R12 for frequently used functionalities.
• Development of scripts to ensure Online Patching compliance of the system including working on standard and custom violation compliance checker.
• Designed and developed automated scripts to rectify codes that were in violation.
• Planning and working with individual teams to ensure codes are R12 ready.
• Work with Oracle support for any standard issues arising during the upgrade.
• Worked on cutover activities for go-live.

Confidential

Senior Oracle Finance Techno Functional Developer

Los Angeles, CA

Environment: Oracle R12 - AR, GL, OM, Advanced Pricing, INV, BOM, TCA

Responsibilities:

• Interact with business users to understand requirements and transform them to a working solution for project to automate the AR invoicing process for OceanX.
• Developed a UI in Apex for Invoice Setup entry and Invoice Approval hierarchy.
• Design and development of AR interface for fixed charges for OceanX.
• Design and development of AR invoice interface for spreadsheet upload of invoices with approval hierarchy.
• Design and development of Sales Order Interface to create Sales Order and invoice based on item prices from price list module and B2B items and shipments.
• Breakdown of items into its BOM components and fetching price of every item along with its markups.
• Design and development of AR interface to create invoices and credits based on GL Accruals and Actuals.

Confidential

Senior Oracle Finance Techno Functional Developer

Troy, MI

Environment: Oracle R12 - FA, AR, GL, AP

Responsibilities:

• Worked on data conversions from legacy systems and worked with MDM teams for data file cleanup.
• Work on tickets and bugs to deliver fixes with quick turnaround times in AP, FA, GL modules.
• Worked on credit card payments report.
• Worked on OAF page personalization’s to add attachments and delete fields.
• Interact with business users to understand requirements and transform them to a working solution.
• Customized the GL Journal Approval workflow.
• Worked on Latin American localizations for AP Payment Process Register.
• Performance tuning of long running programs in AR.
• Created a new customer statement report in AR.
• Worked on enhancement of existing custom XML publisher report.

Confidential

Senior Oracle Finance Techno Functional Developer

Environment: Oracle R12 - AR, AP, OIC, OM, GL, iExpense, EBTax

 Responsibilities:

• Worked on BOM conversion from legacy systems. Coordinated with MDM teams including mapping support to ensure smooth conversion of data in Oracle system.
• Worked with Master Data Management on getting and loading the data files from legacy to Oracle system for various data conversions.
• Designed a solution for porting existing reports to Seaspine and customizing the reports with added flexibility to use this solution for all future rollouts. This solution was used for over 12 reports and was used during 5 new Operating Units creation.
• Performed requirement analysis, fit-gap analysis, POC and solution design and prepared functional specification and technical design.
• Prepared Technical design MD70 for custom RDF, BI/XML Publisher reports, conversions and Web ADI components to be developed in AR, OM, OIC, AP modules.
• Designed and developed solution for delivery of report outputs using the XML bursting functionality.
• Worked on modifications to expense pay workflow.
• Customized various custom reports such as Commission Statement in OIC, AR Customer Invoice for SeaSpine, Cyrano and 4 new Operating Units spin off. Added detailed tax information for Belgium.
• Developed a new commission statement report in Oracle Incentive Compensation (OIC) module for Bonus Statements. The report had to be developed for displaying the bonus for salesrep and had 2 sections - Summary and Detail. The summary section displayed the bonus grouped by salesrep and plan element while the detail section displayed the transactional data.
• Modified the existing Commission Statement report of OIC for Spine and Recon dealers. Added additional functionality to programmatically email the statements to the salesrep and their managers. Other modifications included displaying the beginning balance, manual payments and manual notes.
• Worked extensively on output delivery functionality for programs using XML bursting.
• Worked on error monitoring and error notifications of interface programs using shell scripts.

Confidential

Senior Oracle Finance Techno Functional Developer

Environment: Oracle R12 - GL, FA, AGIS, AR, PO, SLA

Responsibilities:

• Designed, developed, tested and delivered PO conversion for converting PO’s in R12 as per client requirements.
• Worked with team to deliver Supplier Conversion to create suppliers and supplier sites.
• Worked on R12 GL code combinations mapping for PO and suppliers.
• Prepared Technical design MD70 for custom RICE components - RDF reports, BI publisher reports, interfaces and conversions to be developed.
• Worked with clients face to face to get sign off for the technical designs prepared.
• Responsible for running conversions in PROD for go-live.
• Worked with junior developers to develop objects based on the technical design.
• Designed and developed GL reconciliation report to reconcile GL data between primary and secondary ledger in R2R flow.
• Designed and developed a report for bank reconciliation.
• Worked on report to generate asset category listing for FA module.
• Worked on program to Create Mass Additions in FA from AP.
• Worked on Siterra AP inbound interface.
• Designed and developed inbound interface for AGIS intercompany transactions.
• Involved in SIT, UAT and production runs of conversions.
• Resolved defects found in SIT, UAT.
• Coordinated SRs/TARs with Oracle for technical issues.

Confidential

Senior Oracle Techno Functional Developer

Environment:Oracle R12 - AR, QP, OM, TCA

 Responsibilities:

• Designed and developed on Price List Qualifier and Price List Modifier Web ADI.
• Worked on XML reports with preprinted stationery such as Check Printing program.
• Worked on enhancements of existing customer facing AR Reports such as Customer Statement, Customer Invoice.
• Worked on enhancements of existing OM reports such as Sales Order Acknowledgement, Preliminary Invoice, Sales Order Confirmation Report.
• Worked on performance tuning of long running programs.
• Worked with junior developers to code and test objects based on technical design.
• Coordinated SRs/TARs with Oracle for technical issues.

Confidential

Senior Oracle Techno Functional Developer

Environment: Oracle R12 - HRMS, INV, AR, QP, CM

Responsibilities:

• Prepared Technical design for custom objects to be developed.
• Designed and developed the employee conversion program in HRMS to create employees and assign the newly created employees. Worked with MDM to understand the employee setup in legacy system.
• Designed and developed a Web ADI component to apply cash receipts to AR invoices. Designed and developed item conversion to migrate items from third party legacy system to Oracle INV. Worked with Master Data Management on getting and loading the data files from legacy to Oracle system.
• Worked with offshore functional team to understand the client system in order to deliver optimum designs.

Confidential 

Senior Oracle Techno Functional Developer

Environment: Oracle R12 - HRMS, INV, AR, QP, CM, Install Base CSI

 Responsibilities:

• Prepared Technical design for custom objects to be developed.
• Designed and developed the Zero Cost Item Report for INV module.
• Designed and developed the Expiring Warranty Report for CRM team to use for sales calls.
• Designed and developed the Pricing Expiration Report in QP.
• Designed and developed the Employee Census Report in HRMS.
• Worked with offshore functional team to understand the client system in order to deliver optimum designs.

Confidential

Senior Oracle Finance Techno Functional Developer

Environment: Oracle R12 - AR, AP, CM

Responsibilities:

• Analyzed Functional Design Document (MD050 documents) and understand the business requirements for RICE objects.
• Customized the AR lockbox process as per business requirements for application of receipts to invoices.
• Customized the positive pay file process for payment of AP suppliers.
• Work with clients/other teams to get the required information, background and business process.
• Raise the issues which need to be resolved before the technical phase initiation.
• Develop Technical Design Documents (MD070) and code the object.
• Preparing UTP Documents (TE020) for testing.
• Create code pack and ensure code pack adhere to check list review followed by code pack delivery.
• Coordinated SRs with Oracle for technical issues.

Confidential

Senior Oracle Finance Techno Functional Developer

Environment: Oracle R12 - GL, FA, AR, INV, Cost Management, Field Service, Advanced Collections IEX, BOM

 Responsibilities:

• Analyzed Functional Design Document (MD050 documents) and understand the business requirements.
• Designed and developed technical solutions based on functional requirements to address gaps in standard system and customize vanilla functionality as per business needs.
• Designed and developed a custom UI for processing credit card sale and refund transactions using PayPal in Advanced Collections IEX module.
• Designed, developed, tested and delivered an extension to split item costs from INV into material cost and overhead cost and create separate parent and child assets in FA. The costing was derived from the Cost Management module that was setup.
• Worked on BOM and costing part to break item cost into the frozen item cost, split the overheads into markups and create assets based on the cost.
• Worked on interfacing vacation Benefit Accruals from Workday to Oracle.
• Designed and developed interface to transfer transactions from Treasura to Oracle GL.
• Customized the Oracle CRM Service Requests Form to add functionality of automatic gapless Proof of Delivery (POD) numbering.
• Develop Technical Design Documents (MD070) and send it for approvals.
• Preparing UTP Documents (TE020) for testing.
• Create code pack ensure code pack adhere to check list review followed by code pack delivery
• Peer review code packs for the team and assist in design and code pack of team members.
• Coordinated SRs with Oracle for technical issues.
• Part of POC Production Support Team.

Confidential

Senior Oracle HRMS Technical Developer

Environment: Oracle 11i - HRMS

Responsibilities:

• Designed and developed RDF, XML and Discoverer reports as per client requirements.
• Worked on enhancement of existing custom packages.
• Worked on creating an extract of employee data for BCBS interface for HRMS.

Confidential

Senior Oracle Finance Technical Developer

Environment: Oracle 11i - AR, AP, CM

Responsibilities:

• Worked directly with the clients in preparation of Archive plan, deployment of Archive of AR data in UAT/Production environment.
• Worked on Oracle data volume analysis as starting point for estimating impact, downtime and ease of archived data accessibility.
• Worked on performance tuning of long running programs in AR.
• Responsible for validation of AR data in the application after Archive.
• Worked on resolution of Post Production issues.
• Worked with the clients in understanding and implementing their requirements.

Confidential

Oracle Finance Techno Functional Developer

Environment: Oracle 11i - 11.5.8 to 11.5.10 - AR, AP, CM, GL

Responsibilities:

• Worked on customization and retrofit of existing customizations of AR Lockbox program as per business requirements.
• Worked on retrofit of Zegris to AP invoice interface to suit the new instance.
• Worked on retrofit of various reports in AR, AP and GL modules including the AP trial Balance and GL Trial Balance Report.