Oracle Specialist, Oracle Analyst, Sr. Oracle Consultant

Bellow roles and responsibilities address my engagement with Petrofac UK and UAE.
* Reports and Analytics
o Developed BI Analysis across the multiple Fusion Application business steams
o Developed following BIP Reports
* Invoice Detail Backup Report
* Account Receivable Aging Report
* Invoice Raw data Export Report
* Project Time Report for Offshore employees
* PPM Budget and Forecast Report
* Leave History report - Daily breakup Report
* Oracle Learning - Training Completion Report
* Oracle Learning - Training Feedback Report
* Advance Shipment Notices - ASN Report
* Oracle Learning - Offering Custom Pricing Report
* PPM - Intercompany Transaction Report
* 3rd Party Payroll Time Report
* PPM - Project Expenditures Report
* Un-invoiced ARL transactions Report
* PPM - Costing Report
* Global Employee Details Report
* Head Count Analysis Report
* Legacy Learning Records Report.
* Oracle Learning - Compliance Defaulters Report
* Oracle Learning - Compliance Learner Defaults Summary Report
* Oracle Learning - eLearning Completion Report

* Integration
Achieved an Outbound Integration with Oracle Primavera Unifier to track and manage budgets, commitments,
spends, forecasts and business processes. Integration was involved following outbound extracts
* Project Center Extraction
* Project Creator Extraction
* Purchase Orders (PPM to PO) Extraction
* Project Portfolio Management CTR Extraction
* PA AR Invoice Extraction
* Project Time Sheets Extraction
* Projects Expenditure Extraction
* Project Bill Rates Extraction

* Alerts Development - Alert Composer
* Designed and developed following "Bell Notification" and "Email Notification" for Oracle Learning
* Employee registers for catalogue courses (E learning and other resources) Notification
* Employee request for catalogue courses (ILT non paid courses)
* Seat Confirmation Notification
* Waiting list entering and exiting Notification
* Seat not available Notification

Roles & Responsibility:
Bellow roles and responsibilities address my engagement with 4 US, 1 Canadian and 1 Brazilian client.

* Design & Build phase responsibilities
o Elicit requirements using interviews, document analysis, requirements workshops, surveys, site visits, business
process descriptions, use cases, scenarios, business analysis, task and workflow analysis
o Conducted analysis by critically evaluating information gathered from multiple sources, reconcile conflicts,
decompose high-level information into details, abstract up from low-level information to a general
understanding, and distinguish user requests from the underlying true needs
o Design and deliver solutions that will meet the business objectives
o Translate the designs into the following artifacts as needed: Functional requirements, Business Requirements
Documents, Use Cases, and Interface designs.
o Work with developers to understand and document program development requirements

* Global Human Resources Implementations (4 Implementations)
o Adopted a swift implementation approach to shift to cloud.
o Gathered client's requirements using customized and pre-build templates for each business process.
o Performed "Fit-Gap" analysis to determines if gaps in functionality exist and provided the best possible fit.
o Recommend roadmap of how to effectively deliver additional value to customers through the use of Oracle Cloud
HCM applications
o Work with business customers to understand their requirements and business processes
o Translate functional requirements into technical designs and configure business applications according to
Customers' need
o Articulate business processes and functionalities of the relevant module(s) to clients and prepared blue-prints.
o Analyze complex business processes and design practical solutions and workarounds
o Modeled the Enterprise Structure to meet legal and management objectives.
o Setup and Configured Geographies and Locations.
o Setup Positions, Jobs, Grades, Organizations (Enterprise, LE, LRU, Worker Unions , BU, Departments, Divisions).
o Configured both 2-Tier and 3 Tier Employment Models.
o Setup assignments with Union, Locals and Bargaining Units.
o Considered tons of scenarios to address employee mobility across the LEs, or due to promotion, global transfer
and secondment .
o Created appropriate Security Profiles and Custom Data Roles.
o Setup Progression Grade Ladder, Grades in Ladder, Step Rates and Values and Progression Rules.
o Conduct all facets of testing from test planning, script development, execution and validation
o Performed defect resolution and updated IBM QC.

* Absence Management Implementations (3 Implementations)
o Conduct Workshops to understand the requirements and scope .
o Setup complex model of Absence Management that included almost 30 different absences types.
o Configured different absence components i.e., Rates, Eligibility, Reason, Types, Plans, Repeating Periods,
Derived Factors and Fast Formulae.
o Performed FLSA Setup for Premium pay.
o Setup Lieu Time Leave using Compensatory Absence Plan Type newly introduced in R13 17D.
o Configured Variable Payment Rates based on accrual balance for Vacation Leaves.
o Setup Qualification , No entitlement and Accrual Plans for the different leaves i.e., Compassionate, Statutory
(ESA), Pregnancy, Parental, Professional Development, Paid, Unpaid, Jury Duty, PTO, Sabbatical, Suspension, Half
Day, Partial Day, Reduced Work, Gradual Return to Work and different other types of Leave.
o Considered the following County and State regulations applicable at Legal Entity level, that contribute different
pay rates as per the waiting period and length of services or Sickness.
* Emergency Management and Civil Protection Act.
* Canadian Armed Forces Act.
* Employment Insurance (EI)


* Registered retirement savings plan (RRSP)
* Additional Voluntary Contributions (AVC) to a pension fund.
* Long Term Sickness - LTD
o Provided a range of different functionality need to be considered with each absence type i.e. Full and Partial
Proration, Plan Terms (Variable in some cases), UOM (Days, Cal. Days, Weeks and even Months), Qualification
Bands, Payment Percentage Override , Final Disbursements, Balance Transfer and Concurrent Plan Entitlement
(when consumed 1 use other).
o Created several reports including Audit Report that looks for WHO columns in absence tables.
o Wrote several fast formula for validation, accrual, conversion, rate, anniversaries and proration.
o Setup "Calculation Factors" of absence elements to reflects the periodicity
o Define custom and meaningful messages with several token values as per the clients requirements.
o Created appropriate elements to attach with each absence plan for payroll/reporting purpose.
o Performed impact analysis of new releases and upgrades.
o Prepared SIT and UAT test scenarios with user.

* Time and Labor Implementations (3 Implementations)
o Time Management happened to be a most challenging module to cater with different work pattern and
organization cultural behavior in terms of shifts and flexi-work requirements.
o Gathered clients requirement from users and defined scope of work.
o Performed a Fit-Gap analysis considering an already existing People soft system to handle time and labor.
o Interfaced OTL with various 3rd party application like KRONOS and CHRIS21.
o Considered all aspects of OTL integration with Absence Management including modification of fast formulas of
"<>_Entitlement_Results" shadow elements and mapped the resulting values in "Status Processing Rules ".
o Setup time elements like Regular Time, Double Time, Overtime and National Holidays.
o Created Open Element Links .
o Created Several Rules to calculate; Premiums, Daily/Weekly/Holiday Overtime, Shift Differentials, Consecutive
Days and Weekends, Meal Breaks, FLSA Re-categorization, Guarantee (Call In), Waive Differentials, Standby Not
Worked Reduction and 144 others rules.
o Helped technical consultant to build a REST (Web-Service ) integration with OTL for OTL data load and bulk
operations.
o Created Time related elements like Regular Hours, Double Time, Overtime, National Holiday and others.
o Defined Repeating Time Periods for different departments based on the integration with Payroll and Projects.
o Setup different Time Entry Layout Component both single, multiple and web-clock timecard fields.
o Setup Time Layout Sets both for payroll and project costing (for hourly and salaried employees).
o Defined Time Categories for Payroll Time Type, Absence Management Type, Project, Task and Expenditures.
o Created different "HCM Groups" based on Payroll and Location Evaluation Criteria.
o Created Fast Formula of type " Time Calculation Rule " that validates if reported time entries are less than a
defined minimum/maximum hours value. The minimum/maximum hours value and time attributes are inputs to
the delivered formula.
o Defined " Time Repository Rule Template" based on business requirements, for submission, validation and
calculation rules.
o Defined " Time Repository Rules/Rule Sets" for Entry, Calculation, Device and Submission.
o Defined " Worker Time Entry/Processing Profiles" to directly link workers and indirectly link managers to time
entry validation and calculation rules.
o Defined "Shifts" of type Duration, Elapsed and Flexible.
o Defined " Work Workday Patterns " to attach with the "Shifts"
o Created " Work Schedules" as per business requirements and attached with " Work Schedule Assignment
Administration"
o Defined " Geographic Hierarchy Tree" to address the location as California based employees were have different
overtime rules and calculation.
o Designed a logic for Working a day before or after a holiday in a fast formula
o Created "Calendar Event" to define Holiday schedule.
o Defined Salaried, Hourly and Absence Liability rates.
o Prepared test scripts for each absence type and conducted UAT successfully.

* Oracle Fusion Global Payroll Implementations (3 Implementations)
o Setup an appropriate Payroll Employment Model to address payroll relationships with the PSUs.



o Review mapping between System Person Type and Payroll Relationship Record
o Set the country extension to Payroll using the Manage Features by Country or Territory
o Appended Eligibility Rules for predefined elements
o Created several monetary and non-monetary Rate Definitions based on calculated payroll balances and other
rate contributors.
o Defined static and dynamic type of Object Groups and Work Relationship Groups to include and exclude certain
work/payroll relationships and assignments
o Used PBL to load the initial payroll setup and worker data.
o Revisit some tasks to address payroll-specific requirements, such as creating tax reporting units .
o Verified Enterprise Structures and updated (where required) LE, LRU, PSU and COA.
o Performed accounting configuration setup for Payroll, and ultimately opened the first period.
o Reviewed the accounting segments for Costing , Suspense and Offset Accounts.
o Setup reconciliation of payments for GL and CM modules
o Defined various lookups, value sets, DFFs, EFFs, profile options, pay frequencies, consolidation groups, payroll
definitions, time definitions, UDTs and others as a part of core Payroll Components.
o Create several Fast Formulae based on specific business requirements and criteria
o Reviewed the predefined balances, dimensions and feeds and create the new ones where required.
o Determined what balances were required to include or exclude from Net-to-Gross process
o Performed setup to create Calculation Cards and its Associations with TRU, Absence, Time, and Benefits.
o Setup Event Groups for Retro and Proration of several Earning and Deductions, based on calendar days and work
schedule
* Goal & Performance Management Implementations (3 Implementations)
o Setup Goal Types and lookup values
o Defined Profile Options and Eligibility Profiles
o Defined Review Periods
o Setup Goals Notifications, Libraries, Plans and Plan Sets.
o Assigned Individual and Organization Goals at worker level to be alligned with company's strategy.
o Tracked Goals to make sure that the progress being made.
o Setup Goal Assignment by HR Specialist, Manager and Employee
o Setup Goals approvers
o Established Development Plan and Worker.
o Managed Worker Development Goals and assigned them to Workers
o Specify Goal Intents
o Achieved Sharing and Approving Developing Goals.
o Setup Questionnaires, Templates and Libraries.
o Created DFF for Performance attributes.
o Setup Performance Profile Options, Roles and Matrixes
o Created Performance Eligibility Profiles.
o Setup Performance Review Periods, Flow Definition, Document Types, Templates & Template Sections
o Defined Rating Model Distribution.
o Setup Performance and Proficiency Chart Labels
o Setup Goal Types and lookup values
o Defined Profile Options and Eligibility Profiles
o Defined Review Periods
o Setup Goals Notifications, Libraries, Plans and Plan Sets.
o Assigned Individual and Organization Goals at worker level to be alligned with company's strategy.
o Tracked Goals to make sure that the progress being made.
o Setup Goal Assignment by HR Specialist, Manager and Employee
o Setup Goals approvers
o Established Development Plan and Worker.
o Managed Worker Development Goals and assigned them to Workers
o Specify Goal Intents
o Achieved Sharing and Approving Developing Goals.
o Setup Notifications, Eligibility Batch Process
o Setup Self and Manager Evaluation
o Conducted SIT and UAT



o Resolve 150+ defects
o Conducted User Training and prepared user guides.
* Benefits Implementations
o Responsible for end-to-end benefits implementation.
o Gathered requirements from legacy system and translated into a "to be" solution (HCM Cloud Ben).
o Setup Eligibility Profiles, Life Events, Year Periods, Plan Types, Options, Plans, Programs, Rates and elements.
o Setup Fast Formula for conditional enrollment and dynamic rates based on Absence Hours.
o Configure and setup new Lookups (Set-Enabled) and Values based on requirements.
o Setup multiple processing, unrestricted and life event processing.
o Create several Derived Factors based on compensation.
o Create several Fast Formula to address logical processing of each benefit object, where required.
o Defined UDTs to hold static or less frequently changing data.
o Develop 400 test scenario and document them.
o Conduct SIT and UAT session and resolve 80 related to technical setup i.e. FF, Derived Factors.
o Developed 12 customized report
* Data Conversion, OTBI and Interfacing (2 Implementation)
o Executed Data Conversion using Templates(UCM) and File Based Loader (FBL).
o Setup and maintain users privileges, roles and responsibilities within Security Console.
o Setup complex Absence Management System and integrated with Time and Labor.
o Setup and accomplished Data Loading/Data Migration activities for HCM and Payroll module.
o Outbound integration with EBS, CHRIS21, ADP and KRONOS .
o Web-Service (REST) development along with SaaS and PaaS integration.
o Extended Oracle Fusion application using Sandbox customization.
o Customized Validation Rules and Triggers In Application Composer.
o Used BPM Composer and Object Workflows for Custom Approvals.
o Developed more than 35 BI Cloud custom reports related to Pension & Welfare funds.
o Developed 15 fixed length and CSV formatted eText reports. User just provided us the COBOL written program to
generated these reports and we went through the program logic to understand the attribute and printing format.
o Tune several poor performance reports and used in-line view model of queries to execute faster.
o Reduced reports execution time from several hours to few minutes (2-5 min.)
o Worked with the User Defined Tables (UTD) to store barely changing constant values and used them in Fast
Formulas.

* Oracle Recruitment Loud
o Implemented an end-to-end ORC project module
o Requirement Gathering from business users and Career development staffs
o Setup career site with splash pages and custom contents
o Managed multiple Google enabled career sites.
o Facilitate Candidate options to verify the identity, Save Job applications, Alerts for new and upcoming jobs
o Created Job application flows with Session and Blocks, Questionnaires, Legislative Diversity Information, CWK and
external candidates.
o Configured Internal Job Application Flow Sections Using HCM Experience Design Studio
o Setup Candidate Selection process with different Phases and States.
o Created Fast Formula for conditional Move of a Candidate.
o Created Flexfied and SIT to be displayed on Candidate Move page (upon rejection with reason)
o Setup Templates for Job Requisitions, Interview schedule to save recruiters and hiring manager's time.
o Setup Candidate Pool, Talent Community and Agency Hiring processes.
o Enabled Third Party Integration with RSC, Linked and Indeed.
o Created hundreds of Test case Scenarios with expected results during SIT and UAT project phases
o Resolved issues and defects during testing phase
o Provide training to end users with "How to Do" helping

Functional Roles & Responsibility:
Client: Mubadala Petroleum, Singapore

* Oracle EBS Leave of Absence - LOA module Implementation
o Requirement Gathering and FIT Gap Analysis
o Prepared Blue Print document explaining the "To-Be" system and business process.
o Defined Scope of implementation across all 5 branches in Abu Dhabi, Singapore, Vietnam, Malaysia and
Indonesia.
o Setup Lookups, Absence Category, Absence Types, Absence Reasons & Accrual Categories.
o Defined Elements for Absence, Balances, Adjustments and Encashment
o Defined Accrual Plans for several absences/leaves.
o Defined Accrual Bands and Net Calculation rules.
o Setup Length of Service Bands and Link accrual plans wit elements.
o Custom page development for PMS module with the following features;
o Partial Page Rendering
o Internal and External LOVs
o Train between multiple pages
o Master Detail relationship
* Workflow Development & Enhancements
o Customized IRC workflow for unapproved vacancies.
o Customized Purchasing workflow to be adept a different approval rout when requisition are made on exempted
from tax items.
* Oracle EBS Leave of Absence - LOA module Implementation
o Requirement Gathering and FIT Gap Analysis


Technical Roles & Responsibility:
* Oracle Forms & Reports
o Developed Form for Post Approval Leave Cancelation.
o Customized Purchase Order form to display additional UOM attribute.
* SOA
o Web Service Development related to OPEC pricing change and invoices.
o Calling Post and Get methods from EBS domains.
* OBIEE:
o Gather reporting and analysis requirements. Document the report specifications; implement the metadata layers
including Physical, Business Model and Mapping, and Presentation layer.
o Technical Design and Specifications
o Report Development using Discoverer, XML Publisher and Oracle Reports Writer.
o UAT and Trainings, Interface & Reports Development