Oracle Apps Specialist (IT department)
Kuwait Cement Company
Total years of experience :16 years, 6 Months
• Requirement Analysis, Development, Implementation, Testing and Extensions of Oracle Applications R12, 11i in the Financial
• Functional and technical expertise in the modules of GL, AP, AR, OM, INV.
• Expertise in Procure to Pay and Order to Cash full life cycle implementation.
• Proficient in interfaces and conversions between modules through interface tables and APIs using SQL*loader, PL/SQL procedures to transfer data from Legacy systems to Oracle base tables.
• Expertise in SQL and PL/SQL programming, proficient in writing stored procedures, functions, packages and triggers.
• Expert in developing and customizing reports using Oracle Reports 10g/6i XML and BI.
• Extensive experience on Testing on Oracle EBS
• Expert in Customizing the Oracle Application through Form Personalization and Custom.pll.
• Implementation and Customization of Oracle Applications 11i with good Technical Development skills in developing RICE (Reports, Interfaces, Conversions, and Extensions) components in the domain of Oracle Applications E-Business Suite.
• Good experience on Procure-to-Pay, Order-to-Cash
• Excellent working knowledge in the area of Oracle 10g, Oracle 9i, Oracle 8i, Reports6i.
• Knowledge in Oracle Application Framework, Workflow Builder of Oracle Applications.
• Proven ability to conceptualize, design and implement solutions in Performance Tuning.
• Experience in reviewing the Functional Documents and preparing and modifying the Technical Design Document for the development work
• Adaptability to any new business environment.
• Excellent team player and excellent communication and inter-personal skills.
• Worked with the end user for requirement gathering and solution designing.
• Developed customized report for Bank reconciliation.
• Worked on debugging production issues of importing a Journal data.
• Defining concurrent programs, executable, forms, request set, values set
• Worked on the design and approach to correct the customer addresses in production environment.
• Developed an interface to load the new customers in Oracle application.
• Developed Interfaces to create internal Purchase Order Requisitions and Purchase Orders, AR invoice and Receipts, AP invoices and Payment, general Journals .
• Worked on AR, AP, GL, PO to maintain consistency between legacy system and Oracle Apps. The interface components include 'Journal Import', 'Payables Invoice Import', 'AR Invoice Import', 'PO Outbound interface for KCC Vendors', 'Outbound interface for KCC Customers' etc.
• Designed and customized custom Forms using Oracle Forms 10g.
• Accomplishes information technology staff results by communicating job expectations; planning, monitoring, and appraising job results; coaching, counselling, and disciplining employees; initiating, coordinating, and enforcing systems, policies, and procedures.
• Maintains staff by recruiting, selecting, orienting, and training employees; maintaining a safe and secure work environment; developing personal growth opportunities.
• Maintains organization's effectiveness and efficiency by defining, delivering, and supporting strategic plans for implementing information technologies.
• Directs technological research by studying organization goals, strategies, practices, and user projects.
• Completes projects by coordinating resources and timetables with user departments and data centre.
• Verifies application results by conducting system audits of technologies implemented.
• Preserves assets by implementing disaster recovery and back-up procedures and information security and control structures.
• Recommends information technology strategies, policies, and procedures by evaluating organization outcomes; identifying problems; evaluating trends; anticipating requirements.
• Accomplishes financial objectives by forecasting requirements; preparing an annual budget; scheduling expenditures; analyzing variances; initiating corrective action.
• Maintains quality service by establishing and enforcing organization standards.
• Maintains professional and technical knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; benchmarking state-of-the-art practices; participating in professional societies.
• Contributes to team effort by accomplishing related results as needed.
• Handling all insurance operations troubleshooting and data administration in Tazur insurance system.
• Creating reports required for insurance work
• Creating reports using Oracle BI Publisher and Oracle XML Publisher
• developing and implementing oracle forms and reports under oracle 9i 10g 11g Implementing the data model required by the application
• Creating schema objects and implementing rules for data integrity
• Choosing a programming environment for a new development project
• Writing server-side PL/SQL or Java subprograms and client-side procedural code that use SQL statements
• Creating the application interface with oracle forms and reports 6i and 10g
• Establishing a Globalization Support environment for developing globalized
• applications
• Instantiating applications in different databases for development, testing, education, and deployment in a production environment
• Oracle Financial Suite Release 11.5.1/ 12.1.2 support and maintenance
• Creating XML reports and integrate them with (GL/AR/AP)
• Creating special reports for cheque printing for invoices in AP Module
• Converting from 10g to XML Publisher/BI Reports
• Creating reports using Oracle BI Publisher and Oracle XML Publisher
• developing and implementing oracle forms and reports under oracle apps r12 and 11i
• Implementing the data model required by the application
• Creating schema objects and implementing rules for data integrity
• Choosing a programming environment for a new development project
• Writing server-side PL/SQL or Java subprograms and client-side procedural code that use SQL statements
• Creating the application interface with oracle forms and reports 6i and 10g
• Establishing a Globalization Support environment for developing globalized applications
• Instantiating applications in different databases for development, testing, education, and
• Oracle database administrator (creating updating and performance maintenance)
• web developer using asp.net
• Android application developer using java and eclipse
• iPhone application developer, one of my application in app store
• web developer using html and javascript
• HR attendance and leaves software using C#.net and
• RFID System Programming using C#.NET and RFID Tool Kit
• Users and guests controlling system using C#.NET and MYSQL on Linux server
• Web authentications guest portals using Linux Server and CGI
• Microsoft GP 10.0 Administrator
• Sableh project analysis
• Video conferencing on mobile using java J2ME.
• VLC Implementations using Linux shell on Windows + C++.
• Video conferencing on desktop using java J2SE.
• SIP session initiation protocol integrated with Java J2ME and J2SE.
• Oracle Form and Reports Developing (I.T Dept.) as part time
PC and Laptop hardware and software repairing, Epson + HP printers repairing.