SUMMARY

• Great Exposure and Hands on Experience on Oracle Fusion SAAS implementation and supporting Oracle Cloud HCM R13/20A platforms and Implemented Oracle Cloud HCM, SCM and Financial role based security and page personalization.
• Working on Oracle Taleo, Fusion Security, Fusion Core HR, Compensation, Benefits, Goals, performance and Payroll.
• Hands on experience on functional and technical objects such as building and updating Inbound and Outbound interface, working on optimization projects, building and updating custom roles, classical page personalizations, changing classical views to HCM transactional studio responsive page views, BI publisher extracts, HCM Extracts, HDL, PBL, OTBI and functional configurations.
• Prior fusion, working on Oracle ERP Techo Functional Development for 10 plus years, hands on at Oracle Supply Chain Management (SCM), CRM, P2T and Oracle Financials modules. Techical liason for OBIA / OBIEE implementation.
• Experienced in requirement study, analysis, solution, design, Interfaces and conversions development, implementation, testing, customization, maintenance, support, and migration on Oracle Applications 11i and R12.

PROFESSIONAL EXPERIENCE

Confidential, Santa Barbara, CA

Sr Oracle Fusion HCM Techno Functional

Responsibilities:

• Been a part of Oracle fusion HCM implementation.
• Hands on experience on fusion security concepts and customizations for HCM, Financials and SCM.
• Supporting HCM Techno Functional day to day responsibilities on production environment
• Working and monitoring closely on monthly Cloud Patch upgrades
• Testing / Building OTBI, BI publisher reports for Core HR, Compensation, Benefits, Payroll.
• Implementing page personalization / customizations
• Supporting HCM workflows changes / upgrades
• Supporting and Developing Oracle Taleo
• Developing Taleo customer connect tool customizations
• Working on Optimizations projects
• Supporting Outbound and Inbound from Cloud HCM to Taleo, Taleo to HCM
• HCM to kronos Inbound and Outbound day to day and enhancement and development support
• Supporting P2T refresh maintenance support (before and after)
• Building Custom Roles for security
• Testing Oracle cloud monthly / quarterly patching
• Updating workflows, BPM Worklist
• Building outbound interface
• Updating and supporting HCM extracts
• Adding more functionality to Payroll pay stubs, Check Prints
• Updated starting check numbers functionality in payroll
• Building custom roles, abstract roles
• Setting up new DFF fields
• Implemented new W4 functionality at Oracle Taleo Application
• Implemented and supporting on Taleo Outbound interface development and ongoing day to day support.
• Updated Rates for Benefits plans (variable rates for plan profile)
• Updated OTBI Report scripts (updated seeded New hire OTBI report, added action reason, extra column)
• Building updating BI Publisher Reports
• Building OTBI Reports
• Supporting Inbound and Outbound interfaces for HR, Benefits and Payroll, Taleo
• Building and update PBL for payroll details
• Building and updating HDL, converting PBL to HDL for 2020 US Taxation, Federal and state calculation card,
• Working on ADP ACA project, ADP Garnishment projects

Confidential, San Diego

Senior Oracle Applications Developer

Responsibilities:

• Experience on Oracle applications R12, OM, Shipping, Inventory, Quality Module, Service module, Custom Applications, Sales force, SOA and OBIEE 11g
• Responsibilites are closly working with Offshore team, Supporting tasks and Projects
• Supporting on Sales force and SOA projects
• Working on Custom application.
• Building new and updating xml publisher, OBIEE reports
• Supporting new form developement projects with offshore on requirement gathering, teaming up between business and offshore.
• Working on production support issues on Oracle quality, OM, Shipping, PO, AP, AR, Inventory, quality module and TCA etc.
• Builing custom wrappers API’s for bug fix and data updates / uploads
• Supporting on EDI bug fixes, exposing a new field in EDI process for Pickslip
• Worked on enhancement and bug fixes on Oracle ERP and Custom applications
• Invovled in RPC5 test phases

Confidential, Ann Arbor, MI

Oracle Applications Techno Functional Lead

Responsibilities:

• Experience with Oracle ApplicationsR12 AR, HR, Financials, PO
• Involved in Latin American Financials implementation and requirement gathering
• Implemented Latin America Invoice reports (Costa Rica, Mexico, Chile, Ecuador) - AR invoice reports
• Made code and process bug fixing for ADP payroll outbound processes
• Supporting on Employee summary and detail report changes
• Enhanced and build new superviors distrition reports
• Updated HR detail reports for each country (canada and USA)
• Active employee list reports
• AR invoice reports for nonfoodAR invoices
• Existing Invoice report template changes
• US PO Report Changes
• NSF UK PO Report Changes

Oracle Applications Consultant

Responsibilities:

• Experience with Oracle Applications R12 OM, AR, INV and Service Contracts
• Implemented Customer Conversions using Api’s
• Implemented Open AR Conversion Projects
• Understanding and analyzing existing pl/sql scripts / codes, developed new scripts on extracting data from source systems.
• Build Customer Wrapper Apis for Sales Order Authorizations and Book confirm
• Made new processes on existing processes
• Working on Enhancement projects
• Building BI-Publisher reports
• Configuring Table Data feed process for reporting purpose on Oracle commitments, commitment transactions and daily GL rates.
• Added enhancements to RDF - report builder reports
• Updated BI-Publisher reports
• Build multiple data process source objects for data ware housing / Informatica.
• Build Custom Oracle Application Frame(OAF) Pages
• Updated Custom OAF pages
• Involved Requirement gathering and analysis

Confidential, Wixom, MI

Techo functional consultant

Responsibilities:

• Experience with Oracle Applications R12 OM, AR, INV, PO, AP, GL, Oracle Financial Modules
• Created custom wrapper around AR Invoice creations using Interface tables and AR adjustment creation and customer creation using oracle API’s
• Production support issues on OM, TCA, Oracle Rebates, Oracle AR and ..etc..
• Build some custom pl/sql procedure and views for online website usage
• Involved in tuning some Discover report views and BI publisher views
• Build some oracle Alerts using Alert manager modules for users
• Implemented better error logging methods in OM Order creation and AR adjustment creation processes.
• Build custom reports on out of stock inventory modules.

Confidential, El Segundo, CA

Techno functional / Team Lead

Responsibilities:

• Involved in the implementation of Oracle Applications R12 OM, TCA, INV and Pricing.
• Experience with Oracle Applications 11.5.10 OM, AR, INV, Pricing, PO, Order-to-cash
• Developed Customer Interface to create new customers using Custom Interfaces.
• Lead developer on Order and Customer Import processes.
• Production support on Order imports
• Defining new Order sources in OM, Updating existing DFF, LOV as per the requirement.
• Working closely with Thirdparty IT team and managing entire order and customer import process from requirement gather to until Go live.
• Worked as a team lead for OBIA implementation
• Closely working with OBIA Architect for obia implementation and sharing all Oralce ERP source system functionalities and comparing with OBIA plotform.
• Involved in data mapping, gap analysis between obia - oracle ERP and obiee1og
• Hands on experience on OBIA DAC configurations, Informatica mappings, workflows and sessions
• Created custom ETL objects informatica and DAC level
• Worked closely on OBIA out of the box reports - OBIA analytics area.
• Good understanding and thoroughly referred OBIA out of the box configuration documentations, data lineage documents
• Build custom wrapper packages and procedure, functions for OBIEE 10g
• Developer and implemented BI-publisher report
• Designed, developed new Oracle Reports.
• Worked on customizing and creating several reports using reports 6i, Oracle Discoverer.
• Good knowledge in creation, updation and usage of price lists, pricing modifiers / qualifies. Good understanding in functional area.
• Worked on various custom API’s for unit testing and preparation of test cases.
• Involved in club Member Order creation Interface program code changes / updates and full production support on order process
• Support and troubleshoot applications for Business users.
• Worked on forms personalization in R12.
• Worked in custom pll in 11i
• UAT on new campaign test order process
• Involved in FTP and SFTP shell scripts code implementations
• Involved new order import process design with third party vendor team and in- business meeting
• Involvement in assign Oracle users logins and responsibilities in sys admin / Sales reps, alert notifications, AOL objects LOV, DFF
• Actively involved in verifying functional setups like in Item Master attributes, Order transactions forms, Order forms, advanced pricing / qualifiers / modifiers, customer standard forms, more setups.
• Build custom responsibility for particular user group. Copied existing OM menu and functions and restricted other objects from standard features and build a new responsibility for users
• Production support on OM interfaces error, Customer Interface error - daily.
• Implemented custom Data warehouse / Data mart for reporting.
• Developed a program to copy 11i orders and migrate and define orders in R12 - Order import and customer imports. Used OM interface and TCA Apis
• Developed codes on creating pre-scheduled orders in oracle systems
• Developed and implemented Item Swap / Sku swap OM Api for Backend order situations for every 3 months.
• Supporting and Worked aas Business Analyst support more than 3 years
• Build custom views for third party Order systems / SQL Server
• Build table Indexes, tables, views, synonyms, grants, Materialized views, procedures, functions, packages, concurrent programs, alert notifications, explain plans.
• Worked under Multi-org environments
• Worked in Single Org Environments
• Involved in updating Pricing qualifiers / modifiers. UAT.
• Using Core FTP tool, putty, Leach FTP tools for data File migrations.
• Good understanding on Business process on Order creation / customer creation / promotions creations / freight charges flow, tax on freight process, order-to-cash flow process.
• Involved in build Custom Source code / key values - design for order behavior variations.
• Involved in AR process. Fixing Invoice print options. Supported AR interface errors.

Environment: Oracle saas fusion, Oracle Taleo, Kronos, OTBI, BI Publisher, Oracle applications R12, Oracle Apps 11.5.10, OM, TCA, INV, Pricing, AR, GL Oracle 9i, AOL, Reports 6i, Oracle Discoverer, OBIEE, OBIA, Data ware house, Informatica, OBIEE DAC, UNIX, Windows NT, core FTP, PUTTY, Leach FTP, SFTP.