ORACLE APEX DEVELOPER
Yemen Mobile
مجموع سنوات الخبرة :16 years, 3 أشهر
Recently I have been working with Oracle APEX Developer and I have built more than 7 applications.
Most of them was integrated with Oracle EBS 11i.
• Over 7+ years of extensive experience as Oracle Application Technical Developer in implementation, upgrade and customization of Oracle e-Business Suite Applications 11i. This includes system study, design, development, post implementation maintenance and support of Oracle EBS.
• Oracle Certificated in Install, Maintain, Patch Oracle apps.
• Work with on-site team in completing the day to day development activities.
• Solid working knowledge of software development life cycles.
• Proficient in SQL, PL/SQL, Oracle Reports, Oracle Workflow, Oracle Forms, Oracle RDBMS 9i, XML Publisher, Toad, AME, Discoverer and modified the formats using XML.
• Technically proficient in RICEW components (Reports, Interfaces, Conversions, Extensions, Workflows).
• Experience in customizing oracle workflows such as the PO approval process, Leave Absence Request Order/Line Flow to send user notifications based on the business requirement.
• Designed and developed custom USER APPROVAL WORKFLOW to meet the client application’s user creation and maintenance according to the business requirement.
• Worked on the Email notification program to notify the users on recent customer creation failure in Accounts Receivables using Workflow Builder.
• publisher for customizations as per client specification.
• Work with 3rd party teams for project delivery.
• Creates / delivers correspondence, presentations, and other materials for end user training.
• Create Oracle Service Requests.
• Writing Fast Formulas.
• Extensive experience in Customization, debugging, Production and support of various modules in Oracle Applications with major focus in Inventory (INV), Purchasing (PO), General Ledger (GL), Accounts Receivable (AR), Cash Management (CE), Accounts Payables (AP), Fixed Assets (FA), Human Resource(HR), Payroll(PAY), Self Services(SSHR).
• Fair Knowledge in customizing existing OAF Screens.
• Excellent Knowledge in customizing forms and reports as per business needs.
• Experienced in Customizing Oracle Forms with Forms Personalization using Custom.pll and Zoom functionality with sound understanding of Application Object Library (AOL).
• Personalized Oracle standard and custom Forms using oracle forms builder as per the Client requirements.
• Developed Master Detail forms using TEMPLATE.FMB and registered them in Oracle Application.
• Dextrous in Customizing Oracle reports and developing new reports by using Oracle Report 6i/10g and XML Publisher (BI Publisher).
• Worked on XML Publisher reports using RDF and Data Template.
• Developed several Ad Hoc reports using Reports 6i.Developed complex reports using lexical parameters, bind variables and several SQL dynamic queries.
• In user edition, developed various crucial financial analysis reports (for all modules).
• Designed and created new custom applications using Forms 6i tool (Goals and Performance).
• Extensively used API ex. create Move Orders and MISC transaction.
• Strong Knowledge of Application object Library (AOL).
• Hands-on experience in Concurrent Programs, Custom Forms, Reports and Flex Field Customizations, Data Conversion, Data Migration, Report Generation and Developing Interfaces within several modules in Oracle Applications.
• Proficient in development of interfaces and conversion programs to integrate Oracle Applications modules to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader, UTL_FILE, Oracle packaged APIs etc.
• Designed menus and responsibilities to different level of users in the organization.
• Experience with Oracle Supplied Packages such as DMS_SQL and UTL_FILE.
• Expertise on designing and implementing Oracle Alerts and Lookups.
• Developed Alerts in Inventory and Human Resource Modules.
• Expertise in requirement analysis, system design, Data Flow Designs, support, development, testing, documentation and design reviews.
• Expert in developing Technical design documents (MD070), Technical Test documents (TE020).
• Write technical design documents for conversions, extensions, interfaces, and reports. Troubleshoot issues, including creation/follow-up of Oracle service requests (SRs).
• Strong in Performance Tuning, UNIX shell scripting.
• Ability to handle user defined errors by developing Error-Handling Package using PL/SQL.
• Interacted with users, fixed the bugs, developed test plans and provides daily production support.
• Proactively tuned SQL queries & Views using Explain Plan, Hints and indexes, SQL trace.
• Worked on Auto Invoice Interface Program to validate and load credit memos, debit memos and invoices from legacy system.
• Create Interface and procedure to migrate data from INV to FA.
• Designed and implemented custom Employees Trust Utility in INV with. Implementation involves design and development of various objects using Oracle SQL & PLSQL, Oracle Reports and Oracle Forms.
• Developed more than 40 new various report in all Modules.
• Customized GL journal transactions Report.
• Worked on journal import interface program to import journal data from legacy system into GL Base tables.
• Used FNDLOAD to migrate Concurrent Programs and Data Definitions in Various Instances.
• Excellent Expertise in System Administrator responsibility to create users, responsibilities, Values Sets and Request sets.
• Developed UNIX Shell scripts to FTP the flat file from External Server to Oracle UNIX Server location. Automated the process of encrypting and archiving.
• Developed custom templates for the Fixed Assets, Human Resource, Inventory and payables reports by calling sub templates in XML/BI Publisher.
• Created custom templates with Data Definitions for XML Publisher and Developed reports using reports and registered as XML reports in applications.
• Submitted Service Request with Oracle Support in different Scenarios, for providing Solutions to the Bugs identified during Production support resolved various bugs, working in collaboration with Oracle Support.
• Developed PL/SQL scripts for validating the data and Storing the data into MTL_SYSTEM_ITEMS_INTERFACE and then populating the base tables by running the ITEM IMPORT Interface.
• Developed new custom forms to display the employees profits.
• Developed PL/SQL procedures, functions, packages, triggers to validate the data and insert the validate data into Oracle Standard interface tables.
• Created various (Back-end) PL/SQL code to implement business rules through procedures, functions, and packages using SQL*Plus Editor.
• Involved in the day to day activities of production support of Oracle applications environment in AP, AR, PO, INV, FA, CE, HR, PAY, SSHR and GL.
I have worked as an Oracle Developer sql, plsql, forms and reports.
I have graduated from Taiz university with computer science bachelore degree. All courses was in English language.