Clare Detko

Experience

• 

  Reader's Digest Association

  Aug 2005 - May 2009

  Technical Lead

  Developer of HR and Benefits interfaces and reporting for Oracle HR system Technologies used: ORACLE HR 11.5.9, ORACLE PL/SQL 9.2, SQR, ORACLE Forms/Reports 6.0, Data Loader, UNIXDeveloped, designed and maintained all interfaces related to financial benefits such as 401(k), financial accrual of benefits, deferred bonus interest calculations and employee listings to finance project managers. Designed annual compensation award calculations, which includes the calculation of employee bonuses and the calculation of eligibility for pay increases and bonuses.Responsible for the annual benefits enrollment. This includes changing system settings in the Oracle Advanced Benefits module to adjust for changes to employee benefits for the next calendar year and includes importing employee benefits elections. Developed benefits enrollment reports and audit modules.Key contact to Benefits Administrator, Payroll, HR, Compensation and Finance departments to assist in use of Oracle HR and Benefits to report on data and expedite changes to employee HR, Compensation, Payroll, Benefits, or Finance data, or to assist them in reporting on this data. Show less

• 

  Cantor Fitzgerald

  Jun 2009 - now

  Senior Analyst/Developer

  Over 10 years of technical and functional experience with Oracle Fusion HCM and Oracle EBS R12, for HR and BenefitsTechnologies: Oracle Fusion 20A, ORACLE EBS 12.1 for HR and Benefits, ORACLE PL/SQL 11.2, Fast Formulas, Custom ADI, Form Customizations, XML Publisher, ORACLE Forms/Reports Builder 6.0, SQL Developer, Data Loader, UNIX KSHKey resource for system/reports testing for conversion from Oracle EBS to Oracle HCM Fusion for HR/Benefits. Modified Oracle Fusion Benefits enrollment configuration for user requirements: Eligibility Profiles and Rates, Fast Formulas, Life Events. Project Leader for coordination with offshore to test HR Reports and Interfaces. Tested HR and Benefits Interfaces and coded revisions where necessary. Completed data conversion of HR data for newly acquired subsidiary into Oracle HR by creating a spreadsheet-enabled data import of converted data using Oracle APIs. Over 2,000 employees in 15 countries across Americas, EMEA, and Asia Pacific imported without errors or discrepancies. The spreadsheet-enabled import is fully reusable. Assisted in conversion from ADP Payroll to Oracle R12 Payroll. Both projects were highly visible and had high impact for cost savings.Performed key role in setting up year-end benefits enrollment in Oracle Advanced Benefits for incorporation of a new subsidiary. Ran new Benefits Program copy for the new subsidiary and set up new enrollment and eligibility rules and rates, including Fast Formulas for eligibility and rate calculations. Developed and automated all new benefits enrollment/eligibility interfaces including Medical, Dental, Vision, Health Savings Account (H.S.A.), Flexible Spending Account (FSA). Defined enrollment interfaces using PL/SQL or Oracle System Extract using Extract-specific Fast Formulas. Performed conversion of month-end payroll earnings reports used by Finance from an old platform accessible only by IT to a user-accessible report run from Discoverer Business Intelligence. Show less