Shajee Ahmed

E-mail: ac4pjq@r.postjobfree.com

Oracle Techno-Functional Consultant

PERSONAL PROFILE

Over 20 years of experience in IT Industry. Out of that about 10 years experience is in the area of managing & leading Oracle applications projects. Areas of expertise include Project Management, Solution Architect, Functional Project Lead. Has rich Automotive Industry experience and have worked for leading Automotive companies in Jeddah, Saudi Arabia.

As a Techno-Functional Consultant for Omar.A.Balubaid Company, I have been actively involved in implementing and developing Oracle Supply Chain Management based solutions and I also have good working knowledge of Financials and TCA.

Current responsibilities include performing–Functional and Technical work on Oracle Applications. Functional responsibilities include business process analysis, requirements gathering, functional gap analysis, application design, configuration, module setup, test script generation/execution, writing training guides, training end users and production support. Technical responsibilities include interfacing with users, identifying technical and functional gaps, estimating work, architecting system interactions, designing custom solutions, programming, leading developers, scheduling, producing documentation and providing post production support.

Authorized to work in the US for any employer

AREAS OF EXPERTISE

Technologies: Oracle Developer Forms/Reports, BI/XML Publisher, SQL, PL/SQL, SQL*LOADER,

TOAD, Workflows administration, Alerts, Oracle database 11g/10g/9i/8i,Shell scripting.

Functional : Oracle Apps R12/11i, Inventory, Purchase Orders (P2P), I-procurement, I-sourcing, I-supplier, Order Management (O2C,Drop shipments, Move orders),Warehouse Management,Advanced pricing, Advanced Supply chain planning, GL, AP, AR, Fixed Assets, Cash Management, Tele sales, Marketing, Scripting and AOL.

Industry : Automotive and FMCG.

PROFESSIONAL EXPERIENCE

Techno-Functional Consultant at Balubaid group of companies Ltd. Jeddah, KSA.

July 2005 -- Onwards.

Worked as Techno-Functional Consultant and implemented multiple end to end Supply Chain management and CRM based solutions for Automotive, Real Estate, Service Equipment and Restaurant businesses and provided post production support and currently providing business solutions for changing requirements of the businesses.

Environment : Oracle 12.2 & 11.5.10, OM, PO, AP, AR, GL, BOM, INV, WMS, Tele sales, Scripting, Marketing,Oracle 11g, PL/SQL, SQL*Plus, UNIX, Shell Scripting, PL/SQL Developer, Win Scp, TOAD, Putty, Workflow 2.6

Responsibilities :

Worked on all the phases of Software Development Life Cycle including Analysis, Design, Development, Testing, Implementation, Production Support and Maintenance.

Prepared AIMS Functional and Technical documents for requirements, design, and implementation steps with data conversions, test plans and functional user training guides for all the phases of the project.

Responsible for gathering the requirements from Business users and Coordinating with other team members in designing and implementing the process.

Responsible for doing the map/gap analysis and configuring the system for the SCM and CRM business flows.

Responsible for configuring the system in the test instance for conducting the Conference Room Pilots.

Responsible for doing Conference Room Pilots (CRP) to demo the business flows to business users and document the issue logs and rectify the issues and close the issue logs.

Responsible for configuring the production system and preparing the setup document BR100.

Extensively used TOAD, PL/SQL Developer for developing Oracle stored packages, functions, procedures.

Designed, coded, tested custom applications with an integration to Oracle Applications or other custom applications.

Customized standard Oracle Reports and developed new XML publisher as per business user requirements.

Developed new Oracle Forms using template form and customized existing forms and custom.pll .

Created Stored Procedures, Functions, Packages, Triggers and other database objects using SQL and PL/SQL.

Configured Warehouse Management Rules Engine to optimize the Picking rules and Put away rules.

Configured Advanced Pricing module to enable the multi-level price breaks and customer specific

pricelists using qualifiers and modifiers.

Performed production and non-production support by solving tickets of all severity (P1 to P4).

Mentoring team members in their assigned tasks and helping them for any issues.

Trained the end users with the new process using Conference Room Pilots (CRP).

Worked on System administration, Workflow Administration, Trading Community Architecture (TCA), Multi-Org environment, Alert Manager, AOL Administration (registering applications, forms, reports, functions, menus, concurrent programs, value sets, flex fields, alerts, forms personalization).

Senior Systems Analyst at Balubaid group of companies Ltd. Jeddah, KSA.

March 1997 To June 2005.

Worked as Senior Systems Analyst and designed, developed and implemented new software systems such as Used Cars system, Branches Ordering and Planning system and Vendor order processing system and using Oracle Forms & Oracle Reports and integrated these systems with the EMIS) Enterprise Management Information system. (Product of ESI, Buffalo, USA.)

Responsibilities :

Designed, developed and implemented “USED CARS SYSTEM”.

This project includes following modules :

Product Configuration

Purchase Orders

Repair Orders

Transfer Orders

Sales Orders

Designed, developed and implemented “BRANCHES ORDER & PLANNING SYSTEM”

This project includes following application areas :

Available Models With Options & Colors

Yearly vendor sales Forecast

Yearly branch sales forecast vendor wise

Models monthly sales/order forecast

Branches Detail Monthly Order

Submit Detail monthly Order

Review Monthly Order

Accept Monthly Order

Financial Approval Of Monthly Order

Monthly Order Approval

Monitor Branch Ordering

Ordering & Planning Reports

Sales Status Reports

Monthly Order Report/Division

Monthly Order Report/Models

Designed,developed and implemented “VENDOR ORDER PROCESSING SYSTEM”

This project includes the following application areas.

Automated purchase order generation

En-route notification

Distribution of en-route shipment

Distributed shipment report

En-route shipment query for branches

Automation of branch transfer shipments.

Designed, developed and Implemented the Migration Project of EMIS “Distribution System”. The Migration Project was done from SQL forms 3.0 to Oracle Forms Builder 5.0,(Rpt)Report Generator1.0 to

Oracle Report Builder 3.0

This system included the following modules.

Product configuration

Inventory control

Purchase orders

Sales orders

Transfer orders

Physical inventory

Car reservations

Customized and maintained the EMIS system to meet the dynamic needs of business and developed various transactional and analytical reports.

EDUCATION

Bachelor of Technology and Computer Science Engineering (B.TECH)

References can be provided upon request

Contact this candidate