anna poorani

Developed various HR letters, including Change Bank Letter, Immigration Letter (in Arabic and English), Embassy Letter, Employment Letter, and To Whom It May Concern letters, ensuring proper formats and compliance with organizational policies. Designed and implemented the Payroll Element Register, ensuring accurate tracking and reporting of payroll components, deductions, and allowances.

Designed and implemented Fast Formulas for payroll calculations, absence management, benefits, and compensation, ensuring smooth integration with other HR processes. Utilized HDL for seamless data migration and loading of employee data, assignment details, payroll records, and other HR-related information into Oracle Fusion HCM.

Implemented Absence Validation Rules using Fast Formula to restrict invalid leave entries and automated Employee and Assignment Data Loading using HCM Data Loader (HDL) for bulk employee creation and updates. Designed Payroll Reconciliation Reports using BI Publisher, extracting payroll results from PAY_RUN_RESULTS and PAY_PAYROLL_REL_ACTIONS, and developed a custom Pension Report using OTBI and B

Worked on Oracle SQL queries to calculate salary and developed complex Oracle SQL queries to fetch detailed employee-related information, including job, grade, probation details, nationality, emails, and personal details while ensuring effective date validations. Built queries to extract grade-related details and retrieved payroll-related data by working with tables such as pay_rel_groups_d, pay_e