PROFESSIONAL SUMMARY:

• Total 8 years of IT experience in Oracle Applications as Oracle Apps Technical Consultant.
• Diversified technical expertise in Oracle Applications 11i /R12 with extensive exposure in development of Interfaces, Conversions, APIs, dealing with System Admin and Application Object Library (AOL).
• Worked extensively on R12 Implementations, R12 Upgrades and support projects.
• Received KUDOS Award in recognition of outstanding contribution for 2013 Q1.
• Specialized in Implementation, Support of Oracle applications specifically in Account Receivables (AR), Order Management (OM), Inventory (INV), Purchasing (PO), Account Payables (AP) and General Ledger (GL), Cash Management (CM), Fixed Assets (FA), Core HRMS, Payrolls, Oracle Advanced Benefits.
• Expertise experience in business analysis, system integration, design, development, customizations implementation, System/functional and integration testing of ERP applications.
• Expertise experience in Procure to Pay (P2P) and Order to cash (O2C) cycles.
• Strong experience in Developing and Customization Reports, interfaces and Conversions.
• Having good experience on Shell scripts.
• Extensively worked on XML/BI Publisher Reports.
• Capable of Performance Tuning, Optimizing SQL and PL/SQL scripts.
• Extensively worked on Cursors, Functions, Procedure and Packages as business requirements using PL/SQL.
• Involved in developing Interface Objects for Inbound and Outbound Interface process.
• Involved in functional design solutions for bug fixes and business enhancements.
• Experience in writing Test Cases, Prepared Master Test Plans, did unit and integration testing for different PL/SQL packages.
• Experience in SQL Loader, UTL File.
• Had organizational in house training in OBIEE and ADF technologies.
• Experience in AIM, OUM and Agile Scrum Methodologies.

TECHNICAL SKILLS:

ERP: Oracle Applications 11i, R12 E - Business Suits.

Modules: AR, GL, AP, OM, PO, CM, FA, Core HRMS, Payroll, Advanced Benefits

AOL: System Administrator, AOL, Alert Manager

Oracle Tools: SQL*PLUS, SQL *Loader, Sql-Developer, Toad

Developer Tools: Oracle Reports6i/10g, XML Publisher Reports.

Databases/RDBMS: Oracle 9i/10g.

Languages: SQL, PL/SQL.

Operating Systems: Windows7/8 and UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

Technical Consultant

Responsibilities:

• Working on implementation of Lease Accelerator to Oracle Integration. (Primary function of Lease Accelerator is to operationalize lease accounting activities, generate sub ledger accounting entries and provide disclosure reporting as per the new ASC 842 standards)
• Worked on implementation of virtual payment process for Automating payments of Meeting and Events (M&E) business process. (Leveraging AMEX’s virtual card functionality for paying suppliers). This involves File based, Point to point integration approach development using sftp and file encryption.
• Utilized best programing practices, standards and aim methodology templates.
• Worked on reports development in India GST implementation to support new taxation law.
• Worked on implementation of Scalable AR Auto Receipts Reconciliation with bank statements.
• Re-designed and migrated reports from one technology to other.
• Worked on Michigan State Taxes Refund Automation program. (This component received GBO award for dealing with 10Million dollar revenue and delivered without single bug). Automation includes
• Un-apply ALL MI State Receipts.
• Invoice has open balance.
• Issue BCM (Bound to the Invoice tax line total only).
• Receipt Application.
• Automate Credit Card refund i.e. Create debit memo and apply to the unapplied receipt having the refund amount.
• Worked on Cash Management missing bank statements compliance control program. Utilized XML Bursting features.
• Involved in development of multiple reports for Revenue Management System (RMS) that supports revenue standards ASC 606. This includes XML Publisher, PLSQL reports.
• Implemented complex solution design in Sabrix Tax Engine integration (In user hooks) for AR missing Tax lines. (Salesforce uses Sabrix to generate Tax lines for AR Transactions)
• Worked on implementation of Travel & Expense Payment Solution (T&E).
• To move away from Western Union as the current payment provider for T&E payments made to Employees, Sub-Contractors and AMEX.
• The new payment solution will enable T&E to leverage User banking information entered in Workday and have complete control and visibility to User and AMEX payments.
• Workday - Oracle integration for employee bank details. (This involves File based, Point to point integration approach development using sftp and file encryption.)
• Program for creating employees as suppliers.
• Worked on multiple SR’s and interacted with oracle support team.
• Worked on multiple small to medium enhancements and production fixes.
• Developed technical design documents by reviewing functional requirement documents.

Confidential, Sunnyvale, CA

Technical Consultant

Responsibilities:

• Giving Support for prod issues based on the priority.
• Worked on API’s used to create auto deliveries and ship confirm the booked sale orders.
• Worked on ACH extract payment method.

Confidential, San Francisco, CA

Oracle Consultant

Responsibilities:

• Worked on implementation of Pre Bills (Revenue Recognition) Automation package to schedule Earned ad Unearned Revenues.
• Worked on enhancements of Mobix Summary and Detail reports.
• Worked on development of Revenue Recognition Reports (RRR) Summary report by BU and account
• Worked on customization of Account Analysis Report.
• Worked on customization of Po report by project number.
• Worked on multiple small to medium production bugs.

Confidential

Technical Consultant

Responsibilities:

• First point of contact on the development front.
• Assist program manager in estimations for development.
• Involved in Development Resource planning.
• Involved in design and development of multiple Payroll interfaces.
• Developed multiple xml reports
• Pay Group Pay report that can only run after the Payroll Process has passed the Pre-Payment Stage.
• Funding report that will contains the sum of the elements with specific Element Classification information.
• Pay Results by Department report. The Intent of this report is to provide employee gross to net information.
• Pay Input by Period report. Report will pull non-recurring elements on the pay period as well as any open-ended recurring elements at the time (all active elements on the selected pay period).
• Vacation Liability report. The intent of this report is to provide employee vacation liability as of a certain date.
• Filed Active Employees report. The intent of this report is to provide employee headcount to the security group.
• Payroll Reimbursement report. The intent of this report is to retrieve payment details.

Confidential

Technical Consultant

Responsibilities:

• This is an R12.1.3 Upgrade Project for the client Scholastic. This project consists of close to 1000 CEMLIs for R12 Upgrade and it involves various modules like Financials, Supply Chain, Projects and General Ledger.
• Analyze all the custom CEMLI objects for remediation that are in scope of this project, identify the high level changes that need to be done.
• Conducted multiple Upgrade iterations and Load tests.
• Responsible for Migrations of the technical objects from Development instance to other testing by preparing code patches.
• Ensured technical stability, timely support and successful integration of enhancements.
• Organizes and document process changes and RICE object changes.
• Prepared Technical design documents for CEML’s assigned.

Confidential

Technical Consultant

Responsibilities:

• This is an R12.1.3 Upgrade Project for the client SBEC. This project consists of close to 700 CEMLIs for R12 Upgrade and it involves various models like Financials, Supply Chain, Projects and General Ledger.
• Analyze all the custom CEMLI objects for remediation that are in scope of this project, identify the high level changes that need to be done.
• Conducted multiple Upgrade iterations and Load tests.
• Responsible for Migrations of the technical objects from Development instance to other testing by preparing code patches.
• Ensured technical stability, timely support and successful integration of enhancements.
• Organizes and document process changes and RICE object changes.
• Prepared Technical design documents for CEML’s assigned.

Confidential

Technical Consultant

Responsibilities:

• Single point of contact for all Payroll related jobs for the project from initialization to closure phase.
• Facilitate communication and weekly status meetings.
• Designed and developed 9 Asian Payrolls (Malaysia, Singapore, Indonesia, Korea, Hong Kong, China, Philippines, Taiwan and Thailand) Outbound interfaces.
• Designed and developed 5 US ADP Payrolls (US Payroll Personal Changes, US Payroll Tax Data, US Payroll 50K. Insurance, US Payroll Email Address and US General Deductions) Outbound Interfaces.
• Developed Delta Dental Benefits Outbound Interface.
• Developed US Medical Benefits HCM to Blue Cross Blue Shield Outbound Interface.
• Developed Vision Service Plan Benefits Outbound Interface.
• Developed Bluefin Benefits Outbound Interface.
• Developed 401K Indicative from HCM to Fidelity Outbound Interface.
• Developed PayFlex Cobra Benefits Outbound Interface.
• Developed Employee Conversion.
• Developed phone and email conversion.
• Worked with Onsite Technical team to fix any issue during support.
• Maintaining patches history and issues list to keep environment stable by optimizing the patches during respective iterations.

Confidential

Technical Consultant

Responsibilities:

• Was part of team in enhancements on Oracle Core HRMS, Payrolls, Order Management, Inventory, Purchasing, AR, AP.
• Responsible for creating Test Cases, Unit Testing, Integration Testing of customizations and validate the functionality by Conducting UAT with the key users, SME’s and responsible to get signoff and release to Production.
• Automation of Employee Training Records in Oracle HRMS using API.
• Worked on development of multiple core HRMS reports.
• Worked on Enterprise Asset Management system.
• Worked on Oracle Process Manufacturing.
• Extensively worked on O2C and P2P cycles.
• Extensively worked on XML Reports and Developed Custom Scripts for HRMS, OPM and Order Management Modules.
• Responsible for user Training and documentation.

Confidential

Associate Consultant

Responsibilities:

• Worked on Item, Item Categories and Item On Hand Conversions.
• Developed the EDI 940 Outbound Interface which is used to pick confirm the Sales order using API.
• Developed Purchased Order Conversion Program for standard purchase order import.
• Developed Sales order acknowledgment XML report for sales order acknowledgment details.
• Developed Concurrent Programs and value sets as per the business requirement.
• Prepared CV40 Technical documents for conversions as per OUM Methodology.
• Involved in the migration of the objects from CRP1 to CRP2, UAT and then Production Instance.