Premkumar Venkataratnam

Dedicated Technical Consultant adept at cultivating long-term partnerships with lucrative clients. Knowledgeable in Oracle HCM , Finance and SCM . Successful career history comprising more than 9 years.

• Fusion Implementation project for HCM cloud

· Migration of bulk HCM data using HCM Data loader (HDL)

· Extracted HCM data from fusion using HCM Extract Definitions.

· New report development using BIP and OTBI.

· Approval workflow for Employee self service (ESS), Manger self service (MSS), HR Admin activities.

· Developed employee custom form (custom object) using

application composer and controlled data flow between HCM and custom object using REST web services.

• Developed New PL/SQL , XML and RDF HRMS Reports in R12
• Designed New workflows and customized oracle standard Workflows Ex: Cash Clearing Notification , Service PO workflow
• Developed new Fast formulas and Formula Functions
• Created new User Hooks and AME
• Developed new Oracle Alerts for HCM
• Migration of all HRMS and Payroll objects
• Migration of all Open AP, AR Modules Data (AP and AR Invoice, Payments , Receipts, Customer and Supplier Master Data) .
• Automation of B2B Integration between Bank Server and Oracle Cash Management using MT940 Bank Statement format for AR Receipts.
• Developed Integrations: Property Location integration between oracle and Maximo, AR Customer creation and Property Lease creation Integration between Microsoft CRM and Oracle AR , Property Manager.