SUMMARY:

• Oracle HCM Cloud, Fusion ERP Cloud techno - functional consultant with extensive integration experience
• Expert in building analytical reports through Oracle Transactional Business Intelligence (OTBI) within Oracle Fusion Cloud Financials, Oracle Fusion Cloud Human Capital Management (HCM) and Oracle Fusion Cloud Project Portfolio Management (PPM).
• Experienced in Oracle cloud ERP, Fusion Financials, and Fusion HCM implementation
• Experienced in Oracle Fusion Finance Cloud and Fusion Procurement Cloud production on-call support
• Experience in full cycle implementation on Oracle Cloud PPM integrating Oracle Cloud Financials
• Experience in Oracle Enterprise Manager Fusion Middleware Control 12c; WebLogic Server Administration Console
• Experience in Oracle Transactional Business Intelligence (OTBI), Oracle Business Intelligence Applications (OBIA) and Oracle BI Publisher, File Base Data Integrator (FBDI) and ADF di. Oracle Enterprise Performance Management (EPM).
• Expertise in the AIM Methodology, Documentation, Configuration of Applications, Testing, End-User and Supporting for Oracle Fusion Financials Cloud, Oracle Lease and Finance Management (OLFM), Oracle Fusion Financials Cloud, Oracle Financials R12/11i GL, AP, AR, CM, and FA modules.
• Experience in Oracle Financial Reporting Studio (FRS) fusion edition
• Experience in full cycle implementation of Order Management, Inventory, and Cost
• Experience in creating financial Ad Hoc Reports and Analyzed Ledger data in Smart View connecting Oracle Enterprise Performance Management (EPM)
• Participated in multiple Oracle apps 11i/R12 implementations in multi org/multi-currency scenarios, Order management and worked as areas involving Pricing, Purchasing, and Inventory.
• Experience in Data mapping the external source files with oracle columns in Oracle Accounts Receivables, Accounts Payables, General Ledger, Fixed Assets, Oracle Project Accounting, Inventory and Purchasing modules.
• Prepared Technical design documents for customizations/conversions using Oracle Application Implementation Methodology (AIM).
• Expert in building CEMLI (Configuration, Extension, Modification, Localization, and Integration)
• Experience in design, development, testing and deployment of WRICE (Workflow, Reports, Interface, Conversion, Extension) objects
• Expert in preparing RD020, BP040, BP080, BR100 MD30, MD50, MD70, MD120 and TE040 documents.
• Experience in all phases of the system development/implementation life cycle.
• Expertise in the design/development RICE-W objects using Oracle Forms, Oracle Reports, PL/SQL, SQL, Workflow Builder, XML/BI Publisher, JDeveloper (Java) and Oracle Application Framework (OAF) using O/S level Windows, UNIX and Linux.
• Self-motivated team player with ability to multitask with minimal supervision and high reliability
• Excellent team player with immense ability to grasp new concepts and apply them as per business requirements. Well organized with interpersonal and developmental skills, strong work ethics and willingness to work hard to achieve employer goals and targets.
• Excellent Mentor and Peer Reviewer for other ERP Application Analyst/Developers
• Experience in different development methodologies including Agile, SCRUM, Waterfall
• Experience managing ERP/MIS enterprise architecture support team

TECHNICAL SKILLS:

Key skills: Infrastructure as Service (IaasS), Software as Service (SaaS), Platform as Service (PaaS), Oracle Fusion ERP Cloud. Oracle Database 18c/12c/11g/10g/9i/8i/7.3/6.0, PL/SQL 11.2/9/8/2.x/1.x, SQL*Loader, Oracle Developer Suite 10g/9i/6i/2000, Oracle Forms 10g/9i/6i/4.5/3.0/2.3, Oracle Reports 10g/9i/6i/2.5/2.0, Oracle Report Writer 1.0/1.5, RPT, Oracle Discoverer, Pro*C, UNIX/Linux Korn/Bourne Shell Scripts, Workflow Builder 2.6.3. Activity Management Gateway (AMG). Approval Management (AME). Oracle Applications Framework (OAF) Personalization and Extension. Oracle XML/BI Publisher. Java Programming. XML/EDI Gateway. TOAD, Oracle SQL Developer and SQL Navigator. Oracle Fusion Middleware.

Oracle Applications Modules: Oracle Cloud ERP R13, Oracle eBusiness Suite R12.2.2, Oracle Applications R11i, Oracle Human Resources (HRMS), Oracle Time and Labor (OTL), Oracle Contracts (OKC), Oracle Purchasing (PO), iProcurement (Self Service Web Applications/ICX), iSupplier Portal(POS), Oracle Receivables (AR),eBusiness Tax(eBTax / ZX), Internet Expenses (OIE),Order Management (OM), Order Entry (OE), Payables (AP), Fixed Assets (FA), Oracle Lease and Finance Management (OLFM), Oracle Subledger Accounting (SLA), General Ledger (GL), Subledger Accounting (XLA),Oracle Human Resources (HRMS), Oracle Advanced Benefits (OAB), Oracle Payroll Process(OPP), Oracle e-Business Human Capital Management (HCM, Oracle Cloud HCM), Project Accounting (PA), Oracle iPayments (IBY), FastFormula (FF), Application Object Library (AOL), Inventory (INV), Oracle Workflow Web Applications, Oracle Framework Manager (OFM), Oracle Approval Management (AME). Oracle Trade Managements (OZF). Procure to Pay (P2P), Order to Cash (OTC), Supply Chain Management (SCM),Oracle Service Procurement (OSP),Advanced Supply Chain Planning (ASCP),Global Order Promising (GOP), Production Scheduling (PS), Oracle Lease and Financial Management (OLFM),Oracle Credit to Cash, (OTC), Oracle Assets and Real Estates, Oracle Alerts, Value Chain Planning (VCP), Value Chain Execution (VCE), Oracle Process Confidential (Subject Matter Experts (OPM SME).Activity Management Gateway (AMG), Web ADI, XML/EDI Gateway. Oracle Business Intelligence Enterprise Edition (OBIEE), Demantra.

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles

Oracle ERP/HCM Cloud Lead

Responsibilities:

• Gathering business requirements, design, Develop Oracle Transactional Business Intelligence (OTBI)/Business Intelligence (BI) reports for Core HR and Benefits in Human Capital Management (HCM)
• Plan and configure application user data security rules for various roles across multiple business units (BU)
• Create and maintain employee data using HCM Data Loader (HDL) and support application user login issues
• Presented user guide for User Acceptance Test (UAT) session related Core HCM and Benefits Module
• Responsible for Oracle Cloud user security and roles maintenance (HCM/ERP Security Console)
• Working with business on resolving the integration exceptions using ADF di (Transaction Console)
• Work with business on creating custom HCM/EPR user roles and assigning to end user across all BU.
• Responsible for deploying and monitoring Oracle Financials Cloud inbound and outbound integration in post implementation support environment
• Construct and maintain outbound employee records and benefits info for external health care organization
• Responsible for Ceridian and Unity payroll integration in post implementation support environment.
• Gather business requirements, defined and deployed benefits Fast Formulas for plan discounts
• Responsible for employee data conversion using HCM Data Loader (HDL)
• Coordinate with subsystem team leads on overall operation of the cloud production environment
• Maintained and Monitor Payroll extract outbound to Ceridian System.
• Responsible for loading and supporting external payroll data through Oracle Integral Cloud (OIC) integration
• Working with Oracle Support on various HCM configuration issues and coordination of new release

Confidential, Charlotte, NC

Oracle ERP/PPM Cloud Lead

Responsibilities:

• Prepared functional documents to convert Customers and Contract from EBS to Oracle Cloud environment.
• Prepared Customer, Supplier, Employees data conversion from EBS Environment to Oracle Cloud using File Based Data Integrator (FBDI) Templates.
• Prepared Mappings for AP Invoice AR Invoice, FA Invoice and PPM Invoice Integrations through FBDI and Imported through Enterprise System Scheduler (ESS)
• Design and Developed AR,AP,GL and FA Integration to subsystems using Oracle Transactional Business Intelligence (OTBI) extract and bursting for transmission.
• Prepared Project upload functional document to upload project using FBDI
• Prepared contract conversion functional document to service contract using FBDI
• Used SmartView and Reporting Studio in General Ledger Trial Balance analysis.
• Prepared functional document for converting EBS R12 on-premise HR Employees, Assignments and Profiles data.
• Prepared functional document for Oracle EBS R12 Supplier data conversion to Cloud using FBDI Mapping and Cloud ESS Jobs.
• Worked on offshore-onsite model coordinating the integration testing and deliverables.
• Worked on System Integration Test scripts and User Guide Documentations for ERP Integrations
• Worked on unit testing and functional testing documents for Project Billings.

Confidential, Pittsburgh, PA

PPM Cloud Lead

Responsibilities:

• Post go-live Fusion ERP/PPM Cloud Support, working with business users on post go-live issues and providing solutions.
• Prepared user guide and user documentation for PPM Cloud local implementation
• Worked with Oracle Support on major issues like time transfer from HCM to PPM.
• Fixed issue related to Manage Person, Manage Timecard in HCM Cloud
• Configured and Managed Projects, Project Costs, Billing for Service Contracts, Configured and Amend Service Contracts in Cloud PPM
• Managed Contract Bill Rate Schedule and Bill Cycles in Cloud PPM
• Resolved issues related to Create Accounting and Project Month End Period Close process.
• Developed OTBI PPM, ERP Cloud reports using Project, Finance subject areas for AP,AR and GL modules.
• Developed Cloud PPM BI Reports for users and business for Project to GL reconciliation and Project Billing Revenue Recognition.
• Developed BI Report for ePay approved expense invoices scheduled to be executed.
• Resolved issues related Service Contract Billing Invoice for Employees and Contractors.
• Managed and Supported Time Management and Person management configuration in HCM Cloud.
• Prepared user procedure for Project Accounting Monthly Period Close process in PPM Cloud.
• Developed accounting rules in Financial Accounting Hub (FAH) to consolidate parent accounting setup.

Confidential, Sterling, VA

ERP Cloud Managing Consultant

Responsibilities:

• Full cycle implementation of Oracle Cloud PPM integrating Oracle Cloud Financials
• Built solution for Oracle on-premise Enterprise Business Lease and Finance Management (OLFM) integration with Oracle Financials Cloud and Oracle Fixed Assets Cloud
• Built, scheduled and monitored jobs through Oracle Integration Cloud Service (ICS) platform between on-premise EBS and Cloud ERP Applications in order to retail key
• Responsible for AR receipts, adjustment, customer and invoice integrations in Oracle Fusion Cloud ERP
• Built Asset Retirement, Asset Reinstatement, Asset Depreciation, Asset Cost Adjustment and Asset Transfer extract program from Oracle Fusion Cloud Fixed Asset to Oracle on-premise EBS application using Oracle ICS platform, IBM Sterling Platform and Oracle Service-Oriented Architecture (SOA) Suite.
• Designed, developed, tested and deployed Oracle Fusion Cloud Financials/Fixed Assets, Oracle Fusion Cloud Project Portfolio Oracle Transactional Business Intelligence (OTBI) and Business Intelligence (BI) Reports
• Involved in HCM integration and HDL data extract and Cloud HCM BI/OTBI Reporting
• Helped Cloud Fixed Asset data conversion, Cloud AR customer data conversion and Cloud Payroll configuration.
• Worked Oracle Fusion Cloud Cash Management (OTC) configuration and integration to General Ledger (GL) Reconciliation.
• Designed and Developed Project to GL Activity Detail Report and GL Project to GL Reconciliation Report using OTBI subject area in Oracle ERP Cloud Project Portfolio Management (PPM)
• Worked on File Based Data Integrator (FBDI) for Oracle Cloud FA service contract data
• Worked on cloud AR Customer data load using ADF di (ADF Desktop Integration)
• Through knowledge of OTBI subject area for PPM, HCM, FIN and FA module and cross functional architecture
• Worked on Project to GL Activity dashboard reports, Created GL Reports in Financial Reporting Studio (FRS)
• Used Financial Reporting Center (FRC) architecture for BI,OTBI, FRS and Smart View Reports
• Interacted with offshore development team for Cloud OTBI and BI development and testing of fusion cloud HCM, PPM and FA modules

Confidential, Topeka, KS

Senior ERP Technical Analyst

Responsibilities:

• Supported and maintained Service Enterprise Application Management (SEAM) system-based Oracle business Suite 12.2.5 on Oracle 12c.
• Architect SEAM application integrates Oracle Enterprise Asset Management (EAM) and enterprise systems
• Worked on Oracle Business Intelligence Publisher (BIP) Template Builder for designing reports used across Cloud Financials products including AP,AR and GL.
• Designed and Developed BI Publisher for Payables electronic payment advice, GL trial balance by contract report, AR reconciliation report, GL journal entries report to match original transactions Oracle Lease and Finance Management (OLFM) audit reports for postal SEAM application.
• Developed and deployed custom screen using Oracle Forms 11g for postal service representative
• Designed, Developed and Deployed BI Publisher Financial Reports, XML busting for email distributions
• Coordinating deployment of Report, Integration, Conversion, Extension and Workflow objects on Development, Test, User Acceptance and Production environments
• Worked on Oracle eBusiness Suite Mobile Maintenance application implementation of Asset and Oracle Leasing and Financial Management (OLFM) for SEAM applications on mobile platform to support Material Distributions and Inventory Management Systems (MDIMS).
• Followed scrum methodology in VersionOne and ticketing system ServiceNow, participated in gap analysis, gathering user requirement, recommending solutions
• Supported business users by presenting SQL ad-hoc queries through Oracle Business Intelligence OBIEE Oracle data warehouse

Confidential, Wichita, KS

Senior ERP Technical Lead

Responsibilities:

• Oracle ERP Tech Lead for Finance Module
• Performed production support and worked on system enhancements on Payables, Receivables and General Ledger Modules.
• Preparing road map for R12 upgrade, implementation subject to management budget approval.
• Participated in EBS system production operations on-call support.
• Responsible for interface from mobile and internet third party applications.
• Work with business users to support on ad-hoc financials reports.
• Manage and coordinate with offshore QA team
• Work with business to design and develop HR Interface from Dayforce HCM to Oracle HRMS
• Design and develop payroll fast formula for Oracle Payroll integration with Oracle HRMS
• Worked on Oracle Forms 11g and Oracle Reports 11g and BI/XML Publisher products
• Followed scrum methodology using Version One and used ServiceNow ticking system.

Confidential, Olathe, KS

EBS Technical Lead

Responsibilities:

• Oracle ERP Tech Lead for Project Portfolio Manager (PPM)
• Performed Full Life Cycle Implementation of Order Management within Oracle e-Business Suite R12
• Designed and Developed report for Item, BOM and Routings Consolidation for Advanced Supply Chain Planning (ASCP)
• Worked on Item, BOM and Routing data conversion from external system into Oracle EBS on acquisition.
• Personalized Oracle Sales Order Forms, Oracle Receipts forms heavily to accommodate our business requirements.
• Developed oracle workflow solution for Garmin custom Purchase Order approval process.
• Designed, configure GL Rxi Report for presenting management with monthly financial reports.
• Worked and e-Business Tax to Oracle Order management and Oracle Receivables Extensions.
• Integrated Order Management with service consumers using Oracle SOA suite and Oracle BPEL Process Manager through Integrated SOA Gateway (ISG)
• Worked on Oracle Receivables Intercompany Accounting and COGS Workflow Customizations
• Worked on automation of Web Order Import into Oracle Order Management (OM).
• Extended Oracle APIs in R12 for eBTax integration with OM and Advanced Pricing (QP Price Lists) for complex tax rules across the stated in the US and several other countries localization on global implementation.
• Prepared road map for 11i to R12.2.2 upgrade for Oracle Financials Modules in Oracle Database 12c.
• Worked on Oracle EFT Payment extension, positive pay and electronic payment remittance in EBS 12.2.2.
• Collaborated effectively with approved suppliers and contract manufacturers
• Used Oracle Trading Community Architecture (TCA) to define customer, supplier, buyer and bank relationship and setting up EDI Trading partners.
• Worked on Financial and Cloud HCM integration with on-premise ERP for global business.
• Worked Oracle Cloud Payables to capture all the real-time invoice documents from various suppliers
• Worked on changing purchasing approval hierarchy from roll base to rule base using AME (Oracle Approvals Management)
• Setup User Interface (UI) attributes on object layer for schema objects to be processed by AME Engine using AME APIs in Oracle Workflow
• Worked closely with technical team on Order Header and Order Lines Workflow customizations
• Personalized iSupplier, iProcurement self-service portal to accommodate business needs
• Created mass change requests for Bill To or Ship To addresses and party or account contacts within Oracle Service Contracts
• Worked with development team on providing solution for WRICE (Workflow, Reports, Interface, Conversion, Extension) objects
• Worked with offshore team on flexible hours to coordinate the development efforts.
• Worked with offshore team during R12 upgrade proving consensus
• Got strong experience in business process analysis and redesign, including business analysis skills, process mapping and business process redesign and implementation.
• Personalized Receivables Forms and Order Entry Forms to extend customer needs.
• Used Application Object Library (AOL) APIs to create oracle user, roles and responsibility.
• Involved in Development of Oracle Fusion application for global HCM integrating external Human Resource application (ADP).
• Worked on requirement gathering, design, development, testing of “ADP to Oracle HRMS Automation” process.
• Wrote several Fast Formula and Functions for Oracle HRMS to calculate worker compensations.
• Extended worker compensation through self-service HRMS workers compensation workbench
• Created ad-hoc reports in Oracle fusion financials within Financial Reporting Studio (FRS) dashboard
• Build multiple financials reports on multiple orgs using BIP on Financials Reporting studio of Fusion edition.
• Worked on Fusion Financial Reporting Center with Balance Inquiry and Financial Reports
• Worked on asset lines creation in Project Accounting (PA) and Interfacing to Oracle Fixed Assets (FA)
• Worked on integration of Oracle Project Accounting with Oracle Time and Labor (OTL) and Oracle Human Resource Management System (HRMS)
• Worked on Inventory Items and Cost Management standard cost association.
• Build multiple financials reports on multiple orgs using BIP on Financials Reporting studio of Fusion edition.
• Worked on Fusion Financial Reporting Center with Balance Inquiry and Financial Reports
• Worked on Credit Card Scrub module as per Payment Card Industry (PCI) regulations.
• Worked on Work in Process Standard Cost Transaction integration with Financial.
• Followed scrum methodology through confluence (Jira) throughout project development life cycle.
• Followed PCI compliances on Payment Processing while credit card fund capturing
• Helped Unit testing, integration testing and User Acceptance Testing (UAT) on Procure to Pay and Credit to Cash
• Supported multiple projects/tasks within assigned area of Oracle ERP portfolio and related business
• Used automated testing tool Application Lifecycle Management (ALM) for testing ERP modules on conference room pilot (CRP) and User Acceptance Testing (UAT).
• Supported and Managed configuration, code migration and validation during CRP, SIT (Test), UAT(QA) phases of project development life cycle
• Production support Lever-3 contact for Oracle EBS Release 12.2.2 (to support Application Production Operations group if they cannot resolve the Production issues)
• Served as a mentor and peer reviewer to other ERP team members
• Worked with peer on software design, development and deployments to comply with industry standard SOX audit.

Confidential, Kansas City, MO

ERP Technical Lead

Responsibilities:

• Designed, Developed, Tested and Deployed PPM Billing Applications through BI Publisher during upgrade to Oracle E-Business Suite R12.1 converted several Forms Scape Reports to BI Publisher for Human Resource (Oracle HRMS).
• Worked on deploying new reports and supporting integrating Oracle HRMS and incentive compensations.
• Worked on Oracle Projects Accounting based User Interface Application using Excel and Visual Basic for project managers to enter project information from project construction remote locations.
• Worked on Project Billing Setup Form using Oracle Forms 11g for Billing Clerk to setup print information, discounts, adjustments and Generate bills for end client.
• Designed and developed invoice printing for end client through BI Publisher. Billing Drafts printed by billing clerks and reviewed by billing supervisor later approved by project managers through Oracle workflow and final bill sent to end client.
• Interfaced Receivable Invoice Receipts and posts to GL Account.
• Customized iExpense pages to process project expenses.
• Used Application Object Library (AOL) APIs to create oracle ad-hoc user, roles and responsibility.
• Created Oracle Alerts to monitor concurrent jobs and send email notification when job fail.
• Extended and personalized Oracle Leasing and Financial Management (OLFM),iExpense, iSupplier and iProcurement self-service portal for BMCD MIS System.
• Created Client Extension for Project Costing on cost analysis and asset capitalizations on Project Portfolio Management PPM.
• Configured asset allocation entry, burdening and allocations for Project Costing on PPM.
• Worked on several Oracles Project accounting extension APIs for project security and assigning data access level based on person’s role on the project.
• Helped Unit testing, integration testing and User Acceptance Testing (UAT) on Projects and HRMS modules

Confidential, Irvine, CA

Technical Lead

Responsibilities:

• Developed Sales Order Upload utility, Item Upload Utility and Item Cost Upload Utility using OA Framework and PL/SQL Packages.
• Worked on Standard Cost Valuation (Cost Management), Bills of Material Conversion, Work in Process interfaces and Inventory Item Conversions.
• Executed Format One Conversion using PL/SQL Package to Extract and Load security card details.
• Developed report for Item, BOM and Routings Consolidation for Advanced Supply Chain Planning (ASCP)
• Worked on COA Conversion using PL/SQL packages. Worked on Vertex to eBTax conversion as part of R12 Upgrade for Localization of tax on Global Implementation.
• Built PL/SQL API for GL Balance Conversion for Activities Balance and Beginning Balance.
• Consolidated GL Balance converted data after Journal Import in R12 System.
• Loaded AR Customer Profile Amount using API to Creation and Update customer credit Limit.
• Constructed OAF Page for Invoice Upload from several supplier invoices and process payment for the same through Payables using SOA suite and Oracle BPEL Manager.
• Developed AP Invoice Upload using OA Framework and PL/SQL packages.
• Coordinated with offshore development team and helped other developers on resolving critical issues.
• Helped Unit testing, integration testing and User Acceptance Testing (UAT) on Financials and Supply Chain modules.

Confidential, New Jersey, NJ

Senior Analyst/Developer

Responsibilities:

• Worked on Trade Management Implementation (O2C), to befit customer on global, scalable, Integrated Trade management tool, POS Data Collection Gateway for Bus Intelligence Reporting and Formal structure to assess effectiveness of Sales Incentive programs.
• Built Trade Management resale Extension to accommodate custom volume discounts and lump-sum discount for end customers.
• Worked on Advanced Pricing on price modifiers and qualifiers formula in QP Price List, Modified list headers and list lines using APIs.
• Using Oracle Workflow builder and PL/SQL to build the extension and integrate with Oracle ERP Applications Release 12.
• Built custom General Procurement Organization Reports, Custom Contract Sales Report, Custom Price List by End Customer and Price List Eligibility by End Customer Reports.
• Using Oracle BI Publisher, XML, SQL and PL/SQL to build all custom Oracle Reports for Oracle Fusion Financials. I built Procure to Pay (P2P) related reports for Oracle Fusion Procurement.
• Coordinated with end user on system testing and on Trade Management Module Integration within Fusion Applications.
• Built Trade Management BIP Reports for Fusion Financial Report Center, Oracle Leasing and Financial Managements (OLFM)
• Built Incoming Rebates to Trade management (EDI867) Interface.
• Built Oracle PL/SQL module to import Invoices into Oracle Receivables and matched Purchase Orders in Oracle Purchasing.
• Worked on Order Management, Inventory and Cost Management integration, and data conversion to fulfill business need.
• Built Interface program to load orders from external systems into Oracle Order Management, also built delivery and shipping confirmations module for outbound.
• Built oracle PL/SQL program module and UNIX Shell scripts to work with Oracle EDI Gateway to transmit Inbound and Outbound Invoices using standard EDI 810 Inbound and Outbound mapping.
• Executed testing scripts for various scenarios in various instances and extended user .
• Worked on oracle AR Lockbox interface for various business partners across different operating units (OU) on multi-org environment.
• Prepared test cases and executed unit testing and coordinated with end-user on EDI applications.

Confidential, Houston, TX

Lead Analyst/ Developer

Responsibilities:

• Lead development of Confidential Interface which major component in SCM.
• Worked closely with functional resources and testing team to make sure requirements are met and solution is working.
• Built Manifest reports using Oracle Reporting tool.
• Built PL/SQL Program Modules on Project data conversions and Inventory Items Data conversion.
• Worked on Oracle Projects to Oracle Fixed Assets (FA) Interfaces using PL/SQL
• Coordinated production go-live preparations and provided OAF Personalization support for iProcurement.
• Designed and Developed Software to comply with SOX audit and followed industry standard set by the corporation.