Oracle EBS/HRMS Techno Functional Consultant
Milaha
مجموع سنوات الخبرة :25 years, 11 أشهر
• Worked on Oracle E-Business Suite R12 implementation Oracle Human Resource Management Modules.
(Core HR, Oracle Payroll, Oracle OTL, Oracle SSHR)
• Responsible for Functional and Technical support of Oracle E-Business Suite Modules.
• Transformed complex business requirement to Self Service Requests (Extra Information Type). Ex: Employee Reimbursements and Deductions, Special Mission Request, Joining Report, etc.
• Resolve issues with fast formulas, elements setup, year-end processing.
• Developed concurrent requests to send out SMS alerts on Employee requests approval (Leave process and other business processes)
• Configure Approval Process using AME for Self Service SIT and EIT functions, Performance Management Approvals, Leave Approvals and Payable Invoice Approvals.
• Developed alerts for Oracle HRMS and Procurement systems.
• Developed interface systems using API and conversion programs.
• Managing integration of Employee Time and attendance data to Oracle Time and Labor.
• Design complex SQL queries to extract data for business and audit requirements.
• Developed custom reports as per business specifications.
• Developed Crew Management System, Invoice Tracking System, Vessel Certification Tracking System, and Workshop Job Desk which are custom made software for specific business requirement and have saved the company from considerable cost. These are stable and very efficient systems, running from more than 10 years which have improved and streamlined company processes.
• Responsible for Functional and Technical support of Oracle E-Business Suite Module.
• Integration of subsystems with Oracle E-Business Suite.
• Trouble shooting Oracle issues with Oracle Support - Monitoring SRs.
• Installation, configuration and maintenance of Oracle (9i, 11g) and SQL Server databases.
• Successfully upgraded Oracle 9i production database to 11g Rel 2.
• Managing daily database backup and Restore procedures.
• Installing and upgrading Oracle Server Patches.
• Designed and maintained user interfaces utilizing Oracle 6i Forms & Reports and Developer Suite 10g.
• Monitoring Forms and Reports Server Oracle Application Server 10g.
• Developed, modified, and optimized complex queries for data retrieval and modification.
• Designing and tuning Oracle reports.
• Developed Crew Management System to manage Crew Sign In/Out operations of Fleet & Technical Department.
• Developed Invoice Tracking system - Track invoice flow from receipt, approval till payment.
• Adding new modules to the present ERP applications in Payroll, Accounts and inventory.
• Train users on the use and functions of forms and reports.
• Lead the upgrade process of Oracle Forms and Reports 6i to 10g including setup of 10g Oracle Development environment.
• Designed oracle reports to generate various daily, weekly and monthly Document expiry alerts
(Passport, visa, certificates) by email.
• Developed and managing intra net web to host company HR forms, uploading circulars and other
company information using ASP .net Web forms.
• Integrated Biostation Card Access data from the Card reader with Oracle Payroll database to generated
Daily Attendance and OT reports.
• Developed Workshop Job Desk and IT Help Desk - intranet web sites using Microsoft Visual Studio.net with SQL Server 2008 Database.
• Maintaining of company web site.
Organizing and conducting effective training programs in the following modules.
• MS-Office
• MS-Project
• C, C++, C#
• Microsoft Visual Studio 6.0 and Microsoft Visual Studio .net
• Oracle Forms and Reports Developer
• Java, Network Programming in Java, Remote Method Invocation, and implementation of SWING
based GUI systems.
• Software Engineering, System Analysis and Design
• Software Project Management and Quality Assurance
Programmer extensively on J2EEE environment.
• Developed and used various Java beans through JSP scriplets.
• Used Java Mail APIs in JSP
• Implemented session tracking mechanisms through JSP
• Developed programs to implement distributed applications using Remote Method Invocation(RMI) technology.
Worked on
• Data modeling using XML
• Transforming XML using XSL and CSS
• Manipulating XML documents using DOM object properties, methods and events.
• Responsible for design, development and implementation of Software for a Maintenance Workshop of
Photocopies to computerize the customer services using 4th Dimension on Macinstosh system.
• Software for a Dental Clinic to computerize Patient Management and Billing system using Foxpro.
• Responsible for design, development and implementation of taxation system imposed on vehicles for a
Regional Transport Office in CLIPPER.
• Training and assisting students for their projects.
Bachelor of Engineering in Computer Science