Oracle HCM Consultant

Database Administration Raleigh, North Carolina, United States

Profile
Contacts

Summary

Having 8 years of experience in Oracle E-Business Applications various levels software development process like analysis, development, testing and deployment process.
Deep technical knowledge including development, implementation and Customizing Oracle E-Business suite 11i, implementation Oracle E-Business suite R12 for various Modules.
Excellent Technical experience in Core HR, Payroll, Oracle Time and Labor (OTL), General Ledger (GL), Account Receivables (AR) and System Administrator.
Involved in developing user interface using oracle forms for migration of all data from
Source to target system.
Very Strong Knowledge in SQL& PL/SQL, D2K Reports, XML Reports, SQL Loader, Alerts.
Effectively used SQL/PLSQL features like creating Tables, Indexes, Triggers, sequences cursors and Ref cursor for performance and validation process.
Created materialized views for performance tuning.
Extensively Worked on Conversions, Inbound and Outbound Interfaces.
Having good exposure in creating control files, UTL file and LDT (FNDLOAD) files.
Have been part in preparing the turn scripts for production support.
Worked extensively on all AOL features like concurrent programs, request sets, value sets and profiles
Designing of the objects MD70, MD120 based on MD 50 as per AIM Method.
Having knowledge on Workday Reporting and Integration.
Enhancements on Oaf Pages.
Employee data migration from oracle 11i to Oracle R12.
Write, debug, database packages, procedures/ Function / Triggers in RDBMS using Oracle Technologies i.e. (SQL, PL/SQL) as per business requirement.
Carry out user screens / reports Enhancement and personalization based on business requirements.
Interact with business user to clarify requirements and propose/review design requirement.
Develop detailed functional and technical specification for system configuration, enhancement and to develop reports to meet the user requirements.
Work with other team to ensure technical and functional deliverables meet user requirements and co-ordinate on-time to complete dependent tasks.

Expectations

In my new job, I'd anticipate fulfilling various roles such as providing insightful responses, assisting with tasks efficiently, and adapting to different contexts to offer the best support possible. I'd strive to be dependable, resourceful, and continually improving to meet the evolving needs of the team and those I interact with. Additionally, fostering positive interactions and contributing to a collaborative work environment would be priorities.