SUMMARY:

• Oracle Applications Techno functional consultant with 9 years of experience in implementation, Customization, Interfacing, Techno Functional Analysis, Solution Delivery, Project Management of end to end software solutions
• Extensive experience in Implementation, Migration, Customization, Upgrade and support of various modules in Oracle HRMS with major focus in Core HR, Payroll, Absence management, Self Service, OTL & Oracle Fusion Cloud Performance Management.
• Experience in implementing Oracle Fusion Cloud Performance Management in Co - Existence model with Oracle E-Business Suite R12
• Implemented Oracle Fusion HCM(R10) Core HR, Payroll, Benefits, Absent Management, Talent Management
• Experience in HCM Extracts, mass data updates/uploads. Experience in HCM Data loaders
• Experience using Fast Formulas in Payroll Calculations, Accrual Plans, Benefits Administration, Validation of Element Inputs or User Tables, Assignment Sets, Absence Duration
• Experience in Oracle Fusion Compensation Management, project exposure on managing compensation, base pay, Individual compensation, personal contribution, Workforce compensation, Compensation budgets.
• Experience in other Oracle modules like AR, AP, System Admin and Application Developer, Cash Management, Advanced Collections as well.
• Experience using Fast Formulas in Payroll Calculations, Accrual Plans, Benefits Administration, Validation of Element Inputs or User Tables, Assignment Sets, Absence Duration
• Project exposure in Oracle Advance Benefits, Oracle Time and Labour
• Proficient in business process study (As Is & To Be), gap analysis, cost benefit analysis, business process modelling, process flow & interface design to suit business requirements
• Adept in pre-project studies, project effort estimations, and customer demos/ customer trainings.
• Skilled in managing and negotiating with stakeholders having diverse cultural environments with the accountability of informing them on current and future scenarios, by acquiring feedback on critical issues and taking suitable actions to ensure positive experience and increase in user adoption.
• Expertise in building teams and developing skillsets across technologies, domains and functions in accordance to the business development strategy and sales pipeline / forecast.
• Extensive experience in executing end-to-end projects in domains like Insurance, Airline, Retail and properties, ERP HRMS, Self Service Portals (Employee, Customer, Supplier), Bespoke Application Development etc. as per quality & time norms.
• Strong experience of leading & implementing all phases of Software Development Life Cycle using waterfall / agile/devops methodologies.
• Proficient at HRMS User Hooks, fast formula, Conversions, Interfaces, Data migration API and Alerts.
• Strong programming experience in creating Procedures, Packages, Functions, Triggers and other database objects using SQL and PL/SQL.
• Pro skills and handled projects with a combination of technologies - Oracle PLSQL, AME, Oracle Forms and Reports, Oracle workflow . Proficient experience in HP Unix, Shell Scripting .
• Adept in configuring exceptional approvals through Oracle Approval Management Engine (AME).
• Worked for prestigious clients like Aviva Insurance (General and Life), Emirates Group & Emaar.
• Focused & committed team player having an Entrepreneurial bend of mind, with an interest in innovative ideas which can turn into excellent projects.
• Appreciated for cordial relationship maintained with customers and ensuring customer satisfaction without comprising on the any quality parameters.

TECHNICAL SKILLS:

Development Technologies: Oracle PLSQL, UNIX Shell scripting, Oracle Forms and Reports, Forms personalization, AME, Oracle Workflow, Alerts Management.

Tools: Toad, PLSQL developer, PVCS Version Manager, Microsoft Visual Source Safe, Data loader, Assyst, JIRA, HP - Quality Centre

Databases: Oracle 10g, Oracle 11g, SQL*PLUS, SQL*Loader, SQL* Developer

Application/Web Servers: Oracle Applications 11i, Oracle Application Rel12.1.1, Rel12.1.3.

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Techno Functional consultant

Responsibilities:

• Participate in business, functional analysis of internal HR applications and contribute to solution design and implementation.
• Develop efficient HR applications to ease employee service and management for the company.
• Support existing applications to ensure smooth operation of the HR department.
• Document all the HR and payroll process as per organizational standards and share as guidelines for future use of HR coordinators.
• Developing Low Level Design
• Developing interfaces between legacy systems and Oracle EBS
• Implementing critical code and data fixes.
• Data Loading through Oracle SQL * Loader
• Developed interfaces through Oracle Advance queues
• Developed complex queries, joins, stored procedures, functions, triggers, packages in PLSQL for various business requirements
• Experience with masking, unmasking of data
• Extensively worked on Performance tuning
• Created Materialized views and DB Links
• Invoked SOAP/REST Web services using UTL HTTP API in PLSQL
• Generated and Parsed XML in PLSQL using XMLElement, XMLForest, XMLAttributes, XMLSerialize, XMLConcat, XMLSequenceType, XMLType, XMLAgg, XMLPI, XMLComment, XMLPARSE, XMLRoot, XMLCOLATTVAL, XMLCDATA, DBMS XMLGEN, SYS XMLGEN, SYS XMLAGG, XMLTABLE, XMLParser, XMLDom, XSLProcessor
• Triger Email Notification in PLSQL through SMTP
• This project is to decommission the EPsoft legacy systems and implement Oracle HCM suite as one stop shop for HR processing. This project includes the implementation of Core HR, Payroll, Absence Management, Time and Labor. Implement Oracle Fusion Cloud Performance Management in Co-Existence model with Oracle E-Business Suite R12.

Confidential

Oracle HRMS/Payroll consultant

Responsibilities:

• Project owner for Confidential entities Dubai Opera, Emaar Malls and properties.
• Participate in business, functional analysis and contribute to product / solution design.
• Managed and coordinated with a team size of 6.
• Engage in business requirements of the client and coordinate with development counterparts on the business needs.
• Develop effective relationships with clients and partners to exchange information and meet business & operational objectives.
• Have performed impact and risk analysis for the project.
• Documented all the HR and payroll process as per organizational standards and submitted to client.
• Report on SLO compliance and ensure smooth run especially around payroll period.
• Assisted HR/Payroll users in handling 40 odd payrolls processing every month.

Confidential

Business Analyst

Responsibilities:

• Liaise with business users to identify cost effective and productive areas of improvement to current operational procedures.
• Prepare/Review solution design and implement modular, extendable and accurate solutions.
• Collaborate with customers in outlining business processes and recommend/implement process improvement case studies.
• Gather user requirement on system enhancements
• Track and manage deliverables from development team. Ensure no slippage of deliverables.
• Accountable for Quality deliverables.
• Document Standard operational procedures and user manuals.
• Conduct training sessions for business units on the all application across HR landscape.
• Head and manage various teams across the SDLC phase of the enhancements/projects.
• Manage the second level user support for the end user community on functional clarifications. SLO tracking for all applications.
• Held presentations to Business users on prototypes, conduct meetings, convert requirements and solution into IT documents, engage users for testing (User Acceptance testing), deliver quality applications to users and train the users.
• Involved in both functional and technical analysis which enables effective gap analysis and propose effective solution.
• Develop effective relationships with clients and partners to exchange information and meet business & operational objectives.
• Delivered solutions for major Emirates departments like Dnata Airport Operations, Emirates SkyCargo, Emirates Engineering and Emirates Airport Services and worldwide employee portal of the company.
• Delivered ERP solutions ( Oracle HRMS ) for several in-house applications.
• Have implemented new process rules within my team with the aim of achieving zero defect and have been successful in delivering the same. My delivery model has been widely acknowledged and practised by other IT business streams in my organization.
• Invoking SOAP/REST Web services using UTL HTTP API in PLSQL
• Developed D2k Forms and Reports
• Extensively worked on Performance tuning
• Developed complex queries, joins, stored procedures, functions, triggers, packages in PLSQL for various business requirements
• Experience with masking, unmasking of data
• Have delivered many key projects in HR systems.

Confidential

Responsibilities:

• Attendance management for around 10000+ employees across 60 stations across the globe has been centralized with this implementation. Oracle absence management integrated with HR Self Service was rolled out to emirate employees working out of Dubai. Also, handled user training for HR admins on the new application rolled out.
• Design and development of the Pension & Provident Module which involves the complex payroll calculations.
• Developed new Exceptions & Variance reports to be used in Monthly Payroll Processing related to PFPS.
• Created multiple common Web Services to be used for Internal projects and across the Emirates Group for obtaining the HRMS related data from Oracle ERP such as Element Details, SIT Details, EIT Details, Element Entry, Batch Element Entry, Lookups, etc.
• Created various XML Publisher Reports and Oracle Alerts.
• Implemented complex Payroll calculations using Oracle Fast Formulas.
• Developed various interfaces to be used for interfacing PFPS data to integrating systems like Candidate Portal, Employee total rewards (ETR), Oracle ERP etc.
• Around 30 + enhancement per quarter were handled by me. These enhancements included automations, integration, regulatory changes and internal HR policies change implementation, and rollout new employee services.
• Decommissioning the in-house built performance management application with Oracle Fusion Cloud Performance Management in Co-Existence Model with Oracle E-Business Suite R12. Built both inbound interfaces and outbound interfaces using HDL data loaders and HCM Extracts respectively.\
• Implemented Goal Management
• Implemented Performance Management
• Implemented Talent Review
• Implementation of Oracle Fusion HCM R10
• Implement CORE HR
• Implemented Payroll
• Implemented Benefits
• Implemented Absence Management
• Experience in HCM Extracts, mass data updates/uploads
• Implementation of Oracle Fusion Compensation Management.
• Manage Compensation
• Manage Base Pay
• Manage Individual Compensation
• Manage Personal Contributions
• Manage Workforce Compensation
• Manage Compensation Budgets
• Administer Workforce Compensation
• Analyze Total Compensation

Confidential

IT Analyst

Responsibilities:

• Provide leadership to teammates through coaching and mentoring.
• Participate in peer-reviews, identify and encourage areas for growth and improvement within the team.
• Reviewing the requirements, design, and code for the changes and the new capability enhancements in accordance with established standards.
• Conduct POC and submit proposal to further translate them into projects.
• Coordinating with the Business users to understand the enhancements required and issues faced.
• Carrying out Operational Acceptance for all projects going live.
• Guiding the team towards requirement understanding and resolution of issues
• Ensuring smooth run of period closure activities.
• Implementing critical code and data fixes.
• Invoking SOAP/REST Web services using UTL HTTP API in PLSQL
• En-queue and De-queue from Oracle Advance Queue
• Developed D2k Forms and Reports
• Extensively worked on Performance tuning
• Developed complex queries, joins, stored procedures, functions, triggers, packages in PLSQL for various business requirements
• Experience with masking, unmasking of data