Post Job Free

Resume

Sign in

Technical Support Oracle Erp

Location:
Brooklyn, NY
Posted:
February 16, 2024

Contact this candidate

Resume:

Adel Al-Haimi

Brooklyn, New York *****

ad3oxr@r.postjobfree.com LinkedIn Adel Alhaimi

Expert MS Access Developer with skills in Oracle ERP Qualifications Summary

Highly dedicated, enthusiastic, and professional Microsoft Access Programmer with more than 15 years of experience in analyzing user requirements or technical specifications as well as developing and implementing Microsoft Access-based software applications, systems, and databases. Capable of designing, testing, debugging, and modifying VBA and SQL programs as well as providing technical support and training materials for end-users. Possess excellent analytical, problem-solving, communication, team-working, time- management, and multi-tasking skills. Ability to identify and fix programming, system, Data, and application issues as well as make effective decisions under extreme pressure. Strong leadership skills as well as the ability to work both independently and in a cross-functional team Technical Skills

• Profound knowledge of Microsoft Access Databases, Forms, Reports, Queries, Macros, and VBA, 1997/2000/2003/2007/2010/2013/2016, and 365.

• Good knowledge of Oracle ERP11i: Financial, HR, SSHR, Payroll, Inventory, and Purchasing Modules.

• Oracle Forms 6i, Oracle Reports 6i, Oracle (PL/SQL), Oracle Database, Toad for Oracle

• Basic Knowledge of HTML\CSS, Python, and C++.

• Working knowledge of WAN, LAN, Routers, Switches, Fiber, and Copper Cabling.

• Knowledge of the following Systems: Reservation System, DCS, Cute, IBE, FFP, Revenue management, Revenue integrity, Cargo, Revenue Accounting “RAPID” and AIMS

• Good knowledge of MS Excel macros and VBA coding.

• Good Communication skills and time management.

• Good with teamwork and independently.

• System Analysis and Design.

• Experience working with relational databases and tables

• Easily adaptable to new learning environments and fast learner.

• Detailed oriented, organized and have good follow through skills Professional Experience

MS Access Database & Application Developer August 2022 – Present Freelancer, NY

• Duties include troubleshooting, debugging and resolving existing problems in MS Access Applications.

• Upgrade older version of Microsoft Access applications and databases to new version of MS Access.

• Modifying existing Microsoft Access database (forms, macros, queries and reports) by creating and altering database objects, and fields to ensure effective and efficient data entry and management. MS Access Database & Application Consultant 2022 – July 2022. JuicePlus, TN

• Duties include troubleshooting, debugging and resolving existing problems in MS Access Databases.

• Support, maintain, and improve more than 12 Microsoft Access applications and Databases.

• Upgrade all Microsoft Access applications and databases from MS Access 2013 to MS Access 365.

• Provide data analysis solutions using MS Access and responsive advice concerning MS Access.

• Modifying existing Microsoft Access database (forms, macros, queries, VBA and reports) by creating and altering database objects, and fields to ensure effective and efficient data entry and management.

• Work closely with management to prioritize business and information needs Senior MS Access, Oracle ERP & Information Technology Consultant 2016 – December 2021 Yemenia

• Duties include integration of MS Access with Oracle ERP financial modules, Human resource modules and payroll to provide top management with data analysis and special reports using MS Access.

• Provide consultations, responsive advice, counsel, education, and service to the Top management and the various Depts. concerning IT, communication issues, MS Access Databases, Oracle ERP, applications, and trends in the IT industry.

• Manage data mapping and connecting data sources.

• Providing project management services for the entire system development life cycle of Microsoft Access Database and Oracle.

• Liaise with the Demand Management function of the department to provide project estimates, scheduling, and completion updates.

MS Access, Oracle ERP & Information Technology Consultant 2006 – 2016 Yemenia

• Supervise the design, creation and development of Database and applications using MS Access and Oracle.

• Providing operational support for existing Oracle ERP, and MS Access applications.

• Designed and developed following applications: Aircraft Maintenance System, Inventory program, RBD Distribution system, and Agencies Incentive system using MS Access 2013 and Oracle 11g.

• Ensure the integrations between various MS Access Databases and Oracle E-Business Suite.

• Upgraded all MS Access applications and databases from Microsoft Access 2003 to 2010.

• Provide tactical planning, development, evaluation, and coordination of the information and communication technology systems for the company

• Frontend and backend Developer with 15 years of extensive experience in all stages of applications development lifecycle, from concept and development through quality assurance (QA) and tuning.

• Prepare plans and strategies to improve the performance and reliability of Data centers, Networks, Communications, and Applications.

• Approve, coordinate, and control all projects related to the selection, acquisition, development, and installation of major information and communication systems for the company.

• Ensure an efficient operation of systems, communications, and networks in Yemenia's offices/stations spread out in Europe, Gulf States, Africa, Middle East, Indian Sub-continents, and South East Asia.

• Develop and maintain the annual operating and capital budgets for company information and technology systems operations consistent with programmatic plans and established financial guidelines. Responsible for monitoring IT activities and costs as related to the overall utilization of resources required to meet programmatic operational requirements

• Provide consultations to the various departments regarding matters related to Oracle ERP. Senior System Analyst – MS Access Developer 2005 – 2006 Yemen Airways

• Gathering and analyzing user and business requirements and providing support to the technical team in designing, developing, and documenting MS Access databases and related systems using VBA and SQL as per established standards and procedures.

• Designing, testing, debugging, and executing reliable and efficient VBA and SQL code for developing new MS Access applications and for enhancing existing applications as required as well as creating and modifying access modules, tables and database templates. Also created SQL queries, complex stored procedures, triggers, and views.

• Designed, developed and maintained the following Applications: Flight operation costs (Fuel, Handling, Landing/ Takeoff, Navigation and Over flying stations), Catering, Agencies Sales and Qualifying, Frequent Flyer, and Branches Ticket and MCO Sales. using a variety of technologies, languages, and programming tools like MS Access, and Oracle Developer 2000, SQL, and PL/SQL.

• Upgrade all MS Access applications and databases from MS Access 1997 to 2003. Systems Manager & MS Access Developer 2000 – 2003 BUCC, TX

• Responsible for overall sales activities, maintenance of existing MS Access Database and application

• Study competition in the market and submit feedback to the Management (head office).

• Developed an inventory application using MS Access Database 2000.

• Ensure timely submission of all reports to headquarters Junior Computer Programmer 1995 – 1999 Yemen Airways

• Worked as a part of a cross-functional team in gathering, analyzing, and converting user requirements into technical specifications as well as in designing, developing, testing, and modifying MS Access database system and applications

• Assisted senior programmers in debugging and modifying assigned application code as well as ensured proper release of new functionalities in existing VBA and Cobol programs as per user requirements or design specifications

• Developed company-wide databases and applications for Financial, Commercial, and Inventory departments, including forms, filters, reports, tables, and queries by MS-Access

• Providing consultations to the various departments regarding matters relating to computerization and office automation and supporting existing hardware, software systems, and desktop applications.

• Programming, supporting, and troubleshooting using Windows-based programs which included MS Access, and Visual Basic.

• Mainframe programming using COBOL and VS (Wang).

• Responsible for Revenue Accounting System.

Training & Graduation

• Bachelor Degree in Computer Science.

Technical University Ilmenau, Ilmenau, Germany, 1995.

• ITIL Foundation: 2013 New Horizon Computer Learning Center Dubai

• Strategic Planning: 2012 Yemen University of Science and Technology Sana'a

• Leadership Skills for Airline Staff: 2007 AACO Regional Training Center Sana'a

• Oracle University: 2007 Jakarta

• 11i eBusiness Suite Essentials for Implementers

• 11i General Ledger Management Fundamentals

• 11i Oracle Payables Fundamentals

• Oracle Discoverer Administrator 10g

• Oracle Forms and Reports Developer 10g

• Basic Leadership Skills: 2006 Sana'a

• Xincon Technology School: 2002 New York

• Oracle DBA Training Program

• UNIX Training Program

Activities

• Member of the IT Committee of Arab Air Carriers Organization (AACO).

• Head of Systems Committee

• Project Manager of Oracle ERP Implementation

• Played a Major role as a Member of the following Committees: Implementation of E-Ticketing, Internet Booking Engine, CargoSpot, Crane (Frequent Flyer program), and RAPID (Revenue Accounting System) Honors / Distinction

• Employee of the Year 2006 Yemen Airways

• Achievement Award 2005 Yemen Airways

• Letter of Appreciation from Security Department 1998 Yemen Airways

• Achievement Award 1997 Yemen Airways



Contact this candidate