
khalid Abdelhameed Faqeer
Oracle Functional Consultant & Business Analyst at Al Tala’a Int’l Transportation (Hanco)
Jeddah, Saudi ArabiaWork Experience
Oracle Functional Consultant & Business AnalystFull Time
Al Tala’a Int’l Transportation (Hanco)
Feb 2012 - Present -13 yrs, 4 months
Saudi Arabia , Jeddah
- Job Details:• Develop business architecture using requirements such as scope, processes, alternatives, and risks. • Analyze client’s business requirements and processes through document analysis, interviews, workshops, and workflow analysis. • Conduct 5+ levels of testing including functional, user acceptance, and performance to verify the client’s needs are met • Communicate client’s business requirements by constructing easy- to-understand data and process models • Lead and Support all business readiness activities including end user training, product testing and rollout Key Performance Indicators (KPI), Application Development & Enhancements Maintenance and Version Control User Training. • Consulted on company business processes and implemented new policies, practices and standards in terms of managing and prioritizing the key concurrent jobs that directly affect the month end financial closures of company businesses. • Map Business Requirements to Oracle Modules and Perform Gap Analysis, Solution Design. • Work directly with target audiences and subject matter experts to determine needs, establish tasks and milestones, and acquire relevant information to produce and deliver materials. • Mapped the Legacy system functionality to what was available in the Oracle applications for HR, Payroll and SSHR modules, identified gaps and offered solutions. • Prepared the Oracle Application Setup documents (BR.100) and the Functional Design documents (MD.050) for the new requirements of the company. • Testing the Standard Functionality of Core HRMS and Payroll. • Resolving Technical and Functional Issues for Implementation. • Development of as-Is and To-Be business Processes. Preparation of solution Design for Oracle payroll. Coordinating the technical team members at the Onsite. Assisting in the Technical • Preparing Test scenarios, Training Materials, and User Guides & User manuals. • Defining Elements, Element sets, Assignment sets, Consolidation set and Element links. • Provided training and conducted practice and Business Requirements definition sessions. Supported the production environments and users on a daily basis by resolving user issues. • Conducted CRP1 sessions to demo the out of box functionality on the service modules. • Designed and developed reports using xml publisher and crystal reports. • Worked on Accrual plans set ups and modifying the existing setups. Involved in all the year-end activities related to payroll. • Setting up Business Group, Organizations, Job, locations, key and descriptive flex fields. • Load the setup data using the data loader. Setup Lookup codes, Person types, assignment types, custom payroll elements, balances and fast formulas.
Oracle Functional Consultant & Business AnalystFull Time
ProSol Technology - STC Project
Jul 2011 - Jan 2012 -6 months
Saudi Arabia , Riyadh
- Job Details:• Engage client to gather software requirements/business rules, and ensure alignment with development teams • Translate stakeholder requirements into different tangible deliverables such as functional specifications, user cases, user stories, workflow/process diagrams, data flow/data model diagrams. • Identify and reconcile errors in client data to ensure accurate business requirements. • Draft and maintain business requirements and align them with functional and technical requirements. • Reviews department’s policies and procedures. Act as Project Coordinator to facilitate processes. Updates and maintains the policy and procedures repository. Creates templates and guidance for policies and procedures. • Validates and documents processes, guidelines, authority levels and workflows. Collects information necessary to respond to inquiries and issues related to policy and procedures. • Perform internal analysis and implementation of R12 EBS. Develop Business process flows for HR, CRM, Fleet and Inventory and identify the gaps. • Present the identified gaps and work with business owners/users in the design sessions. Mapped the future state process requirements in system. • Develop project documentation including BR100 and Project Functional Design Documentation (MD.50). • Reviews, analyzes, and translates complex business requirements and processes to requirements to take advantage of best business practices embedded within the ERP. • Leads the design and review workshops with technical and functional resources at all levels, including management. • Monitors progress of tasks against plan, working with project manager to identify and resolve all issues that could affect project scope time frames. • Create charts drawings to clearly convey complex information. Prepares reports, presentations, and summaries for senior Management as required.
Oracle Techno-Functional ConsultantFull Time
ProSol Technology - AwalNet Project
Apr 2011 - Jun 2011 -2 months
Saudi Arabia , Riyadh
- Job Details:• Actively participate in the design, development and maintenance of interfaces to and from the Oracle E-business Applications. • Work closely with the Business Analysts and Functional Consultants to gather requirements for reports, interfaces, extensions and conversions for e-Business applications. Create and deliver training programs to support tools, concepts and processes. • Elicit requirements, document and review as-is business processes, develop to-be processes, write requirements, develop test cases and participate in execution of test cycles. Provide post-production support. • Understanding Business Process, Mapping of the business requirements in Oracle Applications, Identifying the gaps, Suggesting Customization or Work around in application. • Preparation of Project Documentation, such as Test Scripts, Standard Operating Procedures, Training Material and Set Up Documents such as MD.50, BP.80 and BR100. • Setup elements, element links, costing, payrolls and cost centers. • Defining Elements, Element sets, Assignment sets, Consolidation set, Element links. • Proficient in Oracle Applications implementation with PL/SQL, SQL*PLUS, TOAD, SQL Loader, Data Loader, Database Triggers, Procedures, Functions, Oracle Reports 10g/6i Oracle Forms 10g/6i. • Setup elements, element links, costing, payrolls and cost centers. • Defining Elements, Element sets, Assignment sets, Consolidation set, Element links. • Data Conversions through Interfaces and APIs and Custom Development using Oracle Applications Coding and GUI Design Standards, Concurrent manager, flex field’s setup, Integration Testing, documentation (AIM). • Developed Reports in BI Publisher/Xml Publisher. • Developed simple to Complex worksheets, pivot reports using Discoverer Plus and shared the workbooks with users and responsibilities. • Worked on performance tuning like Explain Plan to improve the performance of various custom PL/SQL Packages developed. • Involved in Registration of Concurrent Programs, Executables, Creation of Responsibilities, Request groups, Menus, Submenus, Values sets, Forms, Functions in System Administration.
Sr. Software Engineer (Oracle Forms / Reports)Full Time
ICT Systems - Saudi Ports Authority
May 2009 - Mar 2011 -1 yr, 10 months
Saudi Arabia , Riyadh
- Job Details:• Participate in all phases of software development life cycle including functional analysis, development of technical requirements, prototyping, coding, testing, deployment and support. • Establish and maintain effective communications and relationships within and across teams, business areas, and vendors. • Maintaining highest levels of customer (user) satisfaction. • Assists developers with difficult Oracle PL/SQL code needed for queries, triggers, and stored procedures • Control all changes through a formalized change request process • Provide end-user support in post-deployment phases • Provide on-call and after hours support for production systems. • Develop database packages to support development activities. • Develop complex technical objects in accordance with the technical development standards and best practices. • Front-end and back-end development using Forms 10g/9i/6i, Reports 10g/9i/6i, Discoverer 10g/9i, SQL, PL/SQL and Oracle 11g/10g/9i/8i. • Developing various database objects like Packages, Stored Procedures, Functions, Triggers, and Tables, Indexes, Constraints, Tables, Views, Indexes, Constraints, Sequence, Synonyms, Database link, Views, materialized views, Analytic functions, Roles and privileges and others in Oracle 11g/10g /9i database. • Create PL/SQL tables and global variables and also using IN and OUT parameters with TYPE, ROWTYPE, PL/SQL tables and PL/SQL records. • Created scripts to create new tables, views, queries for new enhancement in the application using TOAD to create new workflows for Company. • Designed and Developed Oracle database Tables, Views, Indexes, and Synonyms with proper privileges.
Education
Bachelor's Degree in Science
osmania universityJan 2001
Skills
- Gap Analysis
- Project Documentation
- Change Management
- Go Live Support
- Public Relations (PR)
- Proposal Preparation
- Presentation Skills
- System Testing
- Human Capital Management (HCM)
- Data Analysis
View More
Languages
Arabic
FluentEnglish
Fluent
Training & Certifications
PMP Preparation Training
Prepcast·2015ITIL Preparation Training
Online·2015ISO 9001:2008, Certificate of Course Completion
ISO·2014Oracle E-Business Suite 12 HRMS
Genysis·2010Oracle Certified Associate
Oracle·2002Oracle Application Server Administration workshop
Oracle Academy·2000Oracle Development (SQL, PL/SQL, Oracle Form & Report 6i)
Oracle Training Center·1999