Senior consultant in charge of designing and developing HR Self Service applications (ESS, MSS) and integration with CRM helpdesk system (HRHD). Implementing new features, customizations and application support towards customers. Worked on HR modules: Job Requisition, Applicant, Workforce Administration, Personal Data, Employment Data, Job Data, Absence & Vacations, Absence History, Workforce Development, Competencies, Position Data, Enterprise Learning, Courses, Sessions.
Also responsible for ETL Dataware housing to a Corporate Data Model (CDM) based on PeopleSoft EPM.Using an Operational Data Store (ODS) based on Informatica PowerCenter interfacing with various source systems like HRMS and CRM to update CDM.
Furthermore QA according to the development standards. Building PL/SQL functions and procedures on Oracle and Javascripts and incorporating it the PeopleSoft applications.
Tools: CRM 8.9 Case management and AAF (Active Analytics Framework), Application Packages, Batch processing by Application Engines and Integration Broker in Oracle 11i environments, MS Infopath (digital forms), Informatica PowerCenter, Javascript, PL/SQL, OEM Oracle Enterprise Manager