SUMMARY:

• Oracle Certified Associate (OCA) with 11+ years of experience in Oracle Fusion HCM cloud and Oracle EBS applications (11i and R12).
• Exposure to Implementation Projects, Support Projects and R12 Upgrade Projects.
• Good Experience in EBS customizations (Forms, Workflow, Alerts, Custom Library, Procedure, and Packages) and CEMLIs.
• Expertise in using various Oracle reporting tools includes Oracle Reports, XML/BI Publisher, and Discoverer.
• Expertise in Design to the delivery of EBS RICE components (Reports, Interfaces, Conversions and Extensions).
• Good Knowledge of Multi organization Access control (MOAC) architecture and understanding of MOAC Impact on custom programs development like report, forms, and workflow PL/SQL packages.
• Strong implementation knowledge of O2C (Order to Cash), P2P (Procure to Pay) business processes.
• Knowledge and Experience of TCA (Trading Community Architecture).
• Good knowledge of Dell Boomi (iPAAS) integration platform.
• Expertise in Fusion cloud OTBI reports, Analysis, Inbound, Outbound integrations, and extracts.
• Good Experience Sandbox customizations in Fusion cloud to match the client requirements.
• Experienced in the leveraging the use of functional setup manager (FSM) to configure Fusion HCM, Payroll, Compensation, and Benefits.
• Experienced in File Based Loader (FBL)/HDL and Coexistence Functionality of Oracle Fusion Applications.
• Oracle Fusion HCM cloud: Hands - on experience in Oracle Fusion Core HR, Payroll, Benefits, Absences, Compensation, Talent Management, Workforce management and Time and Labor.
• Implemented various customizations by developing custom Oracle Forms and Custom PLL and Forms/OAF Personalization.
• Good knowledge of UNIX Shell Scripting.

TECHNICAL SKILLS:

ERP: Oracle EBS 11.5.8, 11.5.10 and R12, Oracle Fusion HCM Cloud V9,10

RDBMS: Oracle 9i, 10g and 11g.

Reporting Tools & others: OTBI, BI Analysis, HCM Extracts, XML/BI Publisher, Oracle Reports, Oracle Forms, Oracle Discoverer, Alerts, OAF, WebADI, FBL, HDL, DataLoad, Java, JDeveloper, JavaScript, Oracle SQL Developer, TOAD, Dell BOOMI, PPM, HP ALM.

PROFESSIONAL EXPERIENCE:

Confidential, Cupertino, CA

Senior Consultant

Environment: Oracle Applications EBS R12, Account Payables, Account Receivables, Model N Revvy integration, REC

• Developed custom APIs for Inbound and outbound interfaces to integrate EBS with Model N using Dell Boomi integration platform (iPAAS).
• Developed Direct Customer Interface to send Customers and customer updates to Model N.
• Developed Parts Interface to send Seagate Products details to Model N.
• Also developed one time load scripts to send data from EBS to Model N.
• Oracle EBS AR/AP integration with Model N Revvy cloud application which is integrated in SFDC. Creating Oracle AR credit memo and AP invoice for Revvy Payments.
• Tracking of the Design, validating unit testing results, and driving the Payment Integration with Revvy.
• Integration Testing including sending data from SFDC to Oracle EBS and Oracle EBS to Model N through Boomi integration.
• Created Design documents and Test case documents for interfaces developed with Seagate standards.
• Creating and managing the Integration defects, creating and executing the test plans for the defects fixed in HP ALM (Quality Center).
• Worked closely with offshore team, Model N product team and Seagate IT functional leads during the integration testing.
• Daily Monitoring and managing the Dell Boomi processes and report and fix the data inconsistency issues if any.
• Troubleshooting the Dell Boomi processes during the development and integration testing of interfaces.
• Developed adhoc plsql scripts to load and send missing Distributors, Customers and Parts records to Model N.

Confidential, Sunnyvale, CA

Senior Consultant

Environment: Oracle Applications EBS R12, P2P, Vertex, Account Payables, Account Receivables

• Retrofit the custom RICE components to meet the R12 table level changes and Online Patching (OLP) compliant.
• Created the custom scripts and ad-hoc queries to analyze the custom objects and change them as per the R12.2.5 standards and Online Patching (OLP) compliant.
• EBS and Vertex Integration changes as per the new changes in R12 by new tax module EB Tax module.
• Removed Nascent Tax Links (NTL) integration from the design and used custom objects to integrate EBS and Vertex.
• Worked on Employee Expense Report and Use Tax report changes in EBS and Vertex side configuration changes.
• Raising the bugs with Oracle Support and Vertex support for data fixes.
• Worked on Custom AP - PO reports and modified post go live for performance and design changes.
• Created new Business Events for custom concurrent programs to fulfil the business needs.
• Custom APIs performance improved by re design and tuning it after retrofit changes as per R12 standards.
• Worked extensively on PPM optimization activities to improve the migration process using the Parallel mechanism.
• Used Google internal tools - Plx for custom reporting needs and automated the workflow.

Confidential, Daly City, CA

Sr. Fusion HCM Consultant

Environment: Oracle Fusion HCM Cloud (Human Capital Management) - Core HR, Payroll, Absences, Performance, Talent Management, Compensation, OTL, OTBI, Analytics, Fast formulas BI Reports, Taleo.

• Analyzed business requirements and developing effective configuration solutions.
• Worked as Oracle Fusion subject matter expert providing best-practice guidance on HCM business processes.
• Sharing suggestions and thoughts to help optimize implementation methodology.
• Worked with HR, Finance and Recruitment teams to identify the business requirements and understand the Workday customizations.
• Customizations are implemented in Fusion HCM using Page composer Personalization to configure the application to the specific business requirement.
• Integrated Fusion HCM cloud with multiple third party applications including ADP, AD, HRDM, Taleo,CIGNA,GORE, and BOOMI etc.
• Developed multiple custom Dashboards, Analysis to match business users requirements.
• Developed 50+ custom OTBI reports for HR, Finance and Recruitment team’s requirements.
• Worked extensively on HDL for Inbound activities.
• Automated the HCM Inbound integration with other third party tools using HDL web services and UNIX scripting.
• Worked on Outbound integration using BI reports and HCM Extracts by leveraging the features of HCM.
• Created/modified custom OTBI Reports and Analytic using Fusion HCM BI.
• Setup Core HCM configuration as required to support business scenarios.
• Worked on fusion setup manager as well as an implementation consultant. Defined customized role-based access control for multiple responsibilities.
• Setup HCM Cloud security profiles, role mapping and role provisioning.
• Employee related setup/modification in Fusion application.
• Fixes to fast formulas to ensure accurate proration and payroll setup.
• Defined Compensation Plan, configured components, Alerts, and processed compensation.
• Customizations using Fusion Sandbox and Composer.
• Developed OBI Reports/OTBI Analytics for Global HR, OTL and Payroll Interface and Fusion Benefits.

Confidential, Palo Alto, CA

Sr. Consultant

Environment: EBS Oracle Applications O2C, Oracle Finance modules, Accounts Payables, Accounts Receivables, General Ledger

• Responsibilities include process implementation, Object deployment through PPM, version management using PERFORCE (P4V), business and IT approvals before deployments.
• Responsible to handle the defect management for JIRA TOOL.
• Involved in unit and integration testing along with QA's.
• Setup Defaulting Rules for Order Booking.
• Worked through the whole OTC (Order to Cash) cycle and Service Contracts integrations with various IBs.
• Defined Transaction Sources, Transaction types, Transaction flex fields (Line, Reference, Link-To and Invoice) structures for auto invoice in AR.
• Developed new XML Reports and Discoverer reports.
• Set up of Suppliers, Payment terms, Distribution setups, Payable Options and Financial Options in Accounts Payables.
• Entering Suppliers and Customer masters.
• Set up for Invoice, Receipts, Lockbox, and Auto Accounting.
• Involved in Unit Testing, Performance Testing and Testing of various test scenarios.
• Created Customized responsibilities, customized menus, customized request groups
• Involved in Quarter end war room activities.
• Providing extracts on ad hoc basis to business users.
• New notifications developed for Partners like Pivotal and Airwatch.
• Worked extensively on Order Management including customizations in the workflow.
• Involved in building, designing and data modeling custom database called SDP which is used by Java team to show required information in Admin Portal and MyVmware portal that Vmware commonly uses to manage their business.
• Designed custom processes which integrates custom database SDP and EBS (OM, SC, IB, AR) and developed various wrappers and API that involved smooth transition of data in between these two systems. Customized the service contract approval workflow and Service Contract Renewal notification.
• Customized the Service contract QA check process to match user requirements.
• Customized Contract termination process and integration with the portal.
• Detailed the PLSQL Validations for Service Contracts Renewals to be performed and creating EDI Orders in Oracle Order Management and Fulfilling the order so as to create the contract.
• Worked on XML Publisher Templates to send reminder notification to Customers whose contracts are expiring.
• Auto Reminder Process has been developed to send notifications to customers automatically to renew the contracts based on no of days of expiration of contract
• Developed several custom XML Publisher reports and Discoverer Reports for OM, SC, IB modules.
• Worked extensively with QA team to make sure all the functional requirements are properly addressed and tested efficiently.
• Built and ran ad-hoc SQL queries to pull data from the backend tables and analyzed them for cleansing based on the issues respectively.

Confidential

Techno Functional Analyst

Environment: Oracle Applications EBS R12, Account Payables, Account Receivables, Fixed Assets, Cash Management and General Ledger

• Developed Conversions, Interfaces and Custom Extensions.
• Setting up of Banks, Bank Accounts, Receipt Classes and Payment Methods.
• Importing data into FA tables.
• Also Defined Line ordering rules, Payment terms, Receipt classes etc and AutoCash rules determine the sequence of application methods Receivables uses when applying receipts imported using Auto Lockbox to open debit items.
• Defining system parameters for Cash management with the default set of books and other information
• Developed Custom forms and Customizations on standard forms.
• Developed Interface programs for OM, AR and AP modules. Interfaces like RA Payments, ACH Payments, Web sales Orders etc.
• Reviewed the functional design documents with functional team.
• Prepared the Technical design document
• Once the Technical design document is approved build the code in R12 instance.
• Test the object in R12 & capture the results
• Prepare the code pack and upload the code pack in GCDP.

Confidential

Techno Functional Analyst

Environment: EBS SCM, Service Contracts, Install Base, CRM, Oracle 11g, PL/SQL, Vertex

• Working on the Change Requests (CRs) given by business.
• Analyze the FRDs given by BAs and design the TDDs.
• Customized of Service contract approval workflow.
• Developed XML reports and Discoverer Reports as per business requirements.
• Root cause analysis and data/system fix for CR’s.
• Providing resolution for existing issues.
• Design and Development of code as per standards.
• Development and Enhancements to the application as requested by the Business.
• Creation of Technical Documentation and User Test Cases.

Confidential

Developer

Environment: Oracle Applications 11i, SQL, PL/SQL, Oracle Reports, Oracle Discoverer 4i.

• Handling the issues of given by Ferring team.
• Involved in creating /modifying the Discoverer Reports, Oracle Reports/Forms.
• Creation /modification of Forms as the client requested.
• Involved in customizations (forms, Custom PLL, Personalization).
• Responsible for support and maintain the code.
• Preparation of Design Level Documents, Test Plans.
• Involved in Quality Audits.
• Maintaining all the source codes with the modified versions in the VSS.
• Worked in issues involved in topics like Special menus, Attachments, Flex fields, Alerts and Profiles.
• Developed Procedural discoverer reports which also uses global temporary tables.

Confidential

Developer

Environment: Oracle Applications 11i, SQL, PL/SQL, SQL Loader, Oracle Reports, Oracle Discoverer.

• Development of Interfaces.
• Involved in writing Control Files for SQL Loading.
• Develop/Modify Interface programs to upload necessary data as part of OPM and AP modules. Interfaces like Item Master, Lot Master etc.
• Loading data in UAT and PROD instance.
• Development of IQ (Installation Qualification) Document as per Ferring Standards.
• Development of PLSQL packages and procedures/functions.
• Updating the documentation and preparing the test cases
• Designed the Conversion with other systems using PL/SQL stored procedures and packages.