SR. Oracle EBS Techno Functional Consultant
Al- Tijaria Real Estate Company, Kuwait.
Total years of experience :17 years, 11 Months
• My role as Oracle HCM/Financial techno-functional consultant is implementing and maintaining Oracle ERP HCM (Core HR, SSHR, Payroll) & Financial (GL, Payables, Receivables and Fixed Assets) modules, developing custom forms, Reports, Data upload using Discoverer, XML, and APIs on EBS Release 12.
• Provide support with all required data for upgrading from 11i to R12
• Customize Oracle R11i/R12 application by developing new reports, forms, packages, procedures, OAF
Personalization and new interfaces for HRMS, XML Publisher modules
• Develop APIs/ Conversions to migrate data from old system (PIPS) into Oracle application base tables
• Provide support during implementation of HR, Payroll, Self-Service and Performance Management for flexfields, BG absence, Payroll Fast Formulas, Payroll Elements, AME, etc.
• Resolved issues during the technical upgrade from Oracle HRMS Payroll 11i to R12
• Involved in the monthly Payroll run in terms of supporting, maintenance and operations
• Assisted the HR department staff for the payroll production issues.
• Wrote payroll fast formulas deductions for the advance salary
• Performed balance adjustments to correct employee payroll balances.
• Wrote Fast Formulas to calculate employee's allowances, bonuses based on grade.
• Monitored the Pre-Payroll processes, Payroll process and post-Payroll processes.
• Assist with the process and review of payroll related interfaces results in costing and transfer to GL.
• Doing reconciliation, the payroll amount with the GL
• Implemented Self-Service HR on Oracle EBS R12, Created EIT and SIT and the approver groups for approving the EITs and SITS. Personalize EIT and SIT based on the responsibility
• Worked on the SYSAMIN activities including the creation of users, responsibilities, menus, concurrent programs, request sets and request groups.
• Developed interface in the technical upgrade for transferring the data from the legacy system to the Oracle R12.
• Designed the hierarchy approval workflow for the above applications.
• Added reports in the customized applications developed in the XML publisher.
• Reviewed the test plan in the R12 upgrade UAT.
• Reviewed the users training manual, user guide manual before R12 upgrade Go Live.
• Fulfilled user needs of customizations and resolving the problem requests with functional setup. Provided training material and assistance to the application users
• Involve in creating Alerts & User hooks, Self-Service Personalization and Workflow Customizations
• Gather / define business requirements, convert them into technical specifications, plan resources & schedules for projects and run complex projects right from designing and development till production
• Exhibit demonstrated leadership skills in defining requirements for project risks as well as designing and maintaining technical / project documentation
• Gather / record data from business users, data cleaning, Oracle technical development, purchasing implementation & support, stored functions & procedures, database triggers, packages, etc.
• Identify / document issues & gaps in future environments based on business requirements and configure application modules in line with agreed flows in the development environment
• Involved in requirement gathering and analysis and design of the application
• Provided APEX guidance and support to technical staff on application maintenance
• Used Oracle APEX 5.1 for designing application structure.
• Identify and develop new opportunities, prepare effective proposals and take active leadership role in developing new business with new and existing clients
• Identify business requirements and map them to the Oracle application functionality; identify functionality gaps and develop solutions for the same
• As an Implementation Team Member was also involved in documentation and testing
• Responsible for gathering Business Requirements, creation of Technical Design Documents and user Documents.
• Involved in development of reports based on business requirements and registered them in Oracle applications.
• Defined value sets, concurrent programs, request sets, registering reports and PL/SQL Procedures, and Packages.
• Involved in the development of interfaces/ Conversions to import the data from legacy system into oracle application tables.
• Relational database modeling experience
• Worked on UTL_PACKAGE and SQL*LOADER for the interfaces and conversions.
• Supported production environments and users on a daily basis by responding to emergency requests
• Experience in requirement gathering, Gap analysis and applications design specification
• Analyzing user needs, conferring with users to improve procedures and identifying and solving problems
• Data Migration from Legacy systems and Open Interfaces
• Arranging periodical training sessions for department managers and end-users for newly developed system modules.
• Monitored and optimized performance, resources, availability, and operation of all systems.
• Customizations using oracle client extensions and Oracle workflow builder.
• Familiar with Systems Project Management life cycles and methodologies.
• Business Requirements Mapping for Account Receivables, cost management, work in process and Accounts Payable modules.
• Assisting in developing and testing software applications.
• Experience in Quality control through Development lifecycle
• Provided Training & Conducted Practice & Additional Business Requirements sessions.
• Designed, built and delivered innovative business solutions, focusing on advanced technical strategies, business process design, application development and technical architecture. Help the Ministry of Justice define and implement solutions fast, efficiently, and cost effectively.
• Provided development and maintenance support for proprietary Oracle-based accounting systems.
• Analyzed systems requirements and developed optimum solutions.
• Applying and implementing business rules and system's user interface using Oracle 9i Form Builder.
• Designing required system reports for presenting statistical and listing views of current and historical data.
• Created full life-cycle application support and reporting by interviewing and surveying end-users to satisfy their needs.
• Create databases, configuring them to meet developer and user requirements
• Migrated a number of Oracle databases to and tuned user SQL statements/schema objects.
• Project Lead for architecting and implementing Oracle 10g Expert System in the Ministry of Justice.
• Write stored procedure using PL/SQL, SQL.
• Providing end users’ guidance and technique support for efficient use of the system.
• Added, modified or removed users, roles and privileges, profiles, and other data accesses.
• Develop materialized Views to provide summary information for detailed reporting
• Team lead development of reference database and monitoring systems.
• Performing necessary testing and debugging for all system modules.
• Performing periodical database backups.