Post Job Free
Sign in

Oracle Supply Chain

Location:
Toronto, ON, Canada
Posted:
October 24, 2013

Contact this candidate

Resume:

RAB KHAN

*********@*******.***

Cell# 647-***-****

Summary of Qualifications

. 15 + years of extensive experience in the full lifecycle development

of large Oracle based Applications. Responsible for systems analysis,

database design, database development, software testing and

implementation as well as technical support.

. Extensive experience as Senior ERP Architect/ Technical Team lead/

Technical PM. Functional, technical lead, developer, etc.) Activities:

interfacing with users, identifying functional and technical gaps,

estimating work, architecting system interfaces, designing custom

solutions, programming, leading developers including onsite and

offshore developers

. Worked Extensively on prepare and maintaining documentation with using

Application Implementation Methodology (AIM), business requirement

gathering, understanding AS-IS Process, designing solutions (To-Be

Process), performing GAP analysis, documenting RICE (Report,

Interface, Conversion, Extension), components & setup of modules for

data conversion, data migration, CRP, testing, UAT, documentation, End

user Training, Cut off plan, Go-live, and post-production support

MD50, MD70, TE40, CV040 documents.

. Very good understanding of business process flows of Procure to Pay

(P2P) and Order to Cash (O2C) including integration between multiple

modules and their interplay with overall accounting structure.

. As a Techno-Functional consultant extensively involved in interfacing

with users, identifying functional and technical gaps, estimating

work, architecting system interfaces, designing custom solutions,

programming, leading developers, scheduling, producing documentation,

and providing production support

. Extensive Experience in E-Business Suite 11i, R12 including Oracle

Financials (GL, AP, AR, FA, CM), INV, BOM, PA, OM, Install Base, WIP,

MRP, PO and HRMS (HR, Payroll, Advanced Benefits, OLM) modules

. Extensively involved in Forms Customizations using Custom library,

Report generation using Oracle Reports and Discoverer, Creating

extensions/ Interfaces with Oracle E-Business suite 11i/R12

. Solid experience in creation of numerous custom applications, reports,

programs and scripts to extend missing or required functionality, from

Release 10.7SC, 11i and R12

. Thorough understanding for Oracle's open interface tables and related

data conversions for Inventory/Items/ Onhand, OM, Routing, BOM,

Installed Base,WIP, Costing, PO, G/L,AR, AP, PA,HRMS

. Solid experience in creating Data Models including Logical & Physical

design using ERWIN, Designer & ER-Studio.

. Strong experience in creating Technical specifications, developing

code, User acceptance testing, Implementation and GAP analysis

. Very strong in creating functional specification document MD 50 and

converting it into technical specification document MD 70 using AIM

methodology

Technical Skills

Operating System HP-Unix, Solaris, Linux, Windows XP Pro, Windows 2000/NT, AIX &

MS DOS

Databases Oracle 7/8/8i/9i/10g, MS SQL Server 7/2000, MS Access

Languages SQL, PL/SQL, Pro *C, C, Java, Shell scripting, HTML, JavaScript

Tools Oracle Designer 6/6i/9i/10g, Erwin, ER-Studio, Optima, Visio,

Oracle Forms and Reports (9i/10g/6i/6/5/4.5/3.0/2.5), SQL*plus,

SQL *Loader, PRO *C, OWB, Oracle Discoverer, Concurrent

Manager, Oracle InterMedia, Microsoft Project, Workflow

Builder, Jdeveloper

BI Tools OBIEE, BI Answers, BI Lawyers, Dimensional Modeling, Data

Warehouse Design

Enterprise Oracle E-Business Suite 11i/R12 Oracle Financials (GL, AP, AR,

Applications FA), Oracle Purchasing, (Supply Chain, Service, OM, INV, BOM,

PA, HR, Payroll)

Web Servers Oracle 9i/ 10g Application Server, Apache

Networking SQL*Net, TCP/IP, Listeners, Database Links

Hardware HP Servers, Compaq, Sun Ultra 60, Sun Sparc 20, Ethernet Hubs,

Fast Ethernet Switches

Work Experience

Senior Technical Lead/ Architect

Knowles Electronics, Chicago IL

Apr 2012- to-date

Project: Upgradation/ Implementation of Oracle Financials (GL, AP, AR,

FA, CM), OM, INV, WIP,

iprocurement

Project involved implementation and upgradation of Oracle

Financials and SCM modules. My role was Senior Technical Architect

for Inbound/ Outbound Interfaces, RICE component design, Financial

and SCM modules setups/ review. Review architecture and solution

recommendations for Siebel, PeopleSoft integrations into Oracle

11i/R12. Coordinated with Onsite and Offshore team and assign tasks

between them and Provided strategic direction and tactical

recommendations to highly technical, specialized and professional

information systems teams (such as, high level independent

contributors and/or managers).

. As senior technical team lead, created project plan using MS

project, allocated tasks among different team members, track and

document software changes, coordinated with PM for extra effort

required to complete critical tasks and updated Giant Chart

accordingly

. Involved with writing up Technical specifications (MD 70) and

Functional Specifications (MD 70) for

reports/alerts/workflow/customizations and creating high-level

technical design documents

. Extensively involved with analysis, design and development of

inbound/outbound interfaces with other applications like

PeopleSoft, Siebel and legacy systems

. Worked on BR 100, MD50, BP 080, TE 40 and MD 70 documents related

to all major modules like Financials and SCM.

. Worked on future business process flow, identified the gaps, re-

engineer current business process and suggested the resolution.

Lead the functional design and got the business sign off on that,

Reviewed the technical design.

. Responsible for upgradation of all RICE components for major

modules like AP, OM, WIP, GL, AR, FA, PO, CM (Reports, Interfaces,

Customizations and Extensions)

. Extensively involved in testing of reports/alerts/customizations/

interfaces/ shell scripts/ DB objects and changing the underlying

structure as per new Oracle R12 structure and handing it over to

functional consultant/ key users for final testing

. Extensively involved in writing functional specifications for

reports/alerts/customizations (including working with users on

requirements) and creating high-level technical design documents,

(c) generating test scripts, (d) performing quality assurance

tests (prior to user testing), and (e) producing training

materials, etc. Components designed and tested include e.g.: (i)

Sales order conversion into OM (ii) Customer conversion into TCA;

(iii) Invoice conversion into AR (iv) Item conversion into

inventory (v)

Environment: Forms 6i/10g, Reports 6i//10g, Discoverer 9i/10g, HP Service

Desk, Oracle 10g, UNIX,

Windows XP, SQL*Plus, PL/SQL, TOAD, XML Publisher, XML Gateway, Business

Events, Workflow Builder,

Alerts, OBIEE, PVCS

Senior Technical Lead/ Architect

Enbridge, Houston TX Apr

2011- Jan 2012

Project: Implementation and upgradation of Oracle Financials and SCM (GL,

AP, AR), OM, PO, INV, WIP,

BOM, MRP

Project involved implementation and upgradation of Oracle Financials

and SCM modules. My role was Senior Techno-Functional Architect for

Inbound/ Outbound Interfaces, RICE component design, Financial and SCM

modules setups/ review. Review architecture and solution

recommendations for Siebel, PeopleSoft integrations into Oracle

11i/R12. Coordinated with Onsite and Offshore team and assign tasks

between them and Provided strategic direction and tactical

recommendations to highly technical, specialized and professional

information systems teams (such as, high level independent

contributors and/or managers).

. Involved with writing up Technical specifications (MD 70) and

Functional Specifications (MD 70) for

reports/alerts/workflow/customizations and creating high-level

technical design documents

. Extensively involved with analysis, design and development of

inbound/outbound interfaces with other applications like

PeopleSoft, Siebel and legacy systems

. Worked on BR 100, MD50, BP 080, TE 40 and MD 70 documents related

to all major modules like Financials and SCM. Worked on planning

the tasks and assigned and directed the activities of the team.

Participated in a cross-functional projects activities, co-

coordinated the tasks to maintain the seamless integration of the

application with other systems Successfully handled the

functional and technical issues, communicated with senior

management, resolved conflicts that arose and recommended the

optimal approach

. Extensively involved in writing functional specifications for

reports/alerts/customizations (including working with users on

requirements) and creating high-level technical design documents,

(c) generating test scripts, (d) performing quality assurance

tests (prior to user testing), and (e) producing training

materials, etc. Components designed and tested include e.g.: (i)

Sales order conversion into OM (ii) Customer conversion into TCA;

(ii) Invoice conversion into AR

Environment: Forms 6i/9i/10g, Reports 6i/9i/10g, Discoverer 9i/10g, HP

Service Desk, Oracle 10g, UNIX,

Windows XP, SQL*Plus, PL/SQL, TOAD, XML Publisher, Workflow

Builder, Alerts, OBIEE, PVCS

Senior Technical Lead

CAE, Montreal QC

Jun 2010 - Feb 2011

Project: Implementation of Oracle Supply Chain (OM, BOM, INV, AR, GL,

MRP, WIP, Advance Pricing)

Project involved implementation of Supply Chain Transformation for

global rollout of Advanced Pricing / Inventory / Order Management/ and

AR: Lead the Techno-Functional Team for global rollout of SCM and

Core Financial Modules. Lead the SCM and Financial Setups, functional

and Technical Design of the project. Lead the RICE components related

to OM and its integration with AR Lead the technical/ Functional l

teams in developing the extension that included multiple modules (OM/

Pricing/Inventory/BOM, AR and INV) Determined and negotiated the

deliverables and delivery schedule with the client Directed the

activities of the team supporting the project post implementation

Worked on customer conversion, sales order into OM from legacy to

Oracle 11i/R12 system Proactively resolved issues and escalations and

reported status to the management. Worked on cut over activities

related to the RICE components Monitored the progress of the team;

managed scope by identifying changes; estimated the impact to project

schedule and recommended resolution. Managed project progress against

schedule, proactively resolving problems and reported status to the

management Involved in converting MD50 into MD 70 and assigning tasks

among team members.

. Extensively involved with Oracle Corporation in analysis, design

and development of inbound/ outbound interfaces, Financial and SCM

Setups.

. Conducted requirement gathering sessions, consolidated the

requirements from US, Canada and Asia for INV, PO, OM, AR and

Pricing modules.

. Worked on future business process flow, identified the gaps and

suggested the resolution. Lead the functional design and got the

business sign off on that, Reviewed the technical design.

. Configured dev and test instance for development and user testing.

Documented test scripts for user testing. Helped PMO with user

training documentation. Worked on the Order Import API to do

custom validations.

. Lead design sessions with the technical team and cross track

teams.

. Extensively involved in designing and implementing solution

related to brining Siebel Order/ Web orders into OM using XML

Gateway, responsible for Setup related to BOM, OM, INV and PO

modules

. Extensively involved in writing MD 70 for data conversion for

major modules like MRP, INV, AR, OM, Routing and BOM.

. Extensively involved as a techno-functional consultant, solving

day to day problems of users around the GLOBLE (US, Canada, Asia)

Environment: Forms 6i/9i/10g, Reports 6i/9i/10g, Discoverer 9i/10g, HP

Service Desk, Oracle 10g, LINUX,

Windows XP, SQL*Plus, PL/SQL, TOAD, XML Publisher, Workflow

Builder, Alerts, OBIEE

Senior Technical Architect

Harris Corporation, Melbourne Fl

Sep 2009-Jun 2010

Project involved implementation of Supply Chain Transformation for global

rollout of Advanced Pricing / Inventory / Order Management/ and AR: Lead

the SCM and Financial Setups/ review, preparing Technical Design of the

project. Lead the RICE components related to SCM and financials module

Lead the technical/ Functional teams in developing the extension that

included multiple modules (OM/ Inventory/BOM, AR and INV) Determined and

negotiated the deliverables and delivery schedule with the client Directed

the activities of the team supporting the project post implementation

Worked on customer conversion, sales order into OM from legacy to Oracle

11i system Proactively resolved issues and escalations and reported status

to the management. Worked on cut over activities related to the RICE

components Monitored the progress of the team; managed scope by

identifying changes; estimated the impact to project schedule and

recommended resolution. Managed project progress against schedule,

proactively resolving problems and reported status to the management

Involved in converting MD50 into MD 70 and assigning tasks among team

members.

Project: eCommerce, GL Product Accounting, Service (OM, INV, WMS, GL, AP,

AR, FA, WIP, MRP), Oracle

HRMS, Siebel, PeopleSoft

. Purchasing: Designed the customization of PO printing report and

Requisition Import interface.

. OM, Workflow and Shipping: Worked on technical design and

developed a customization that prints the shipping documents after

ship confirmation and re pricing are done. Used Oracle AIM

Documentation.

. OM, Workflow: Worked on technical design for COGS account

generator workflow customization.

. OM, Inventory: Worked on technical design and developed a solution

that enabled automatic loading of attachments for an order using a

cross-referenced item.

. Worked on E-Business Suite R12 integration project with Siebel and

PeopleSoft

. Extensively involved as a techno-functional consultant, solving

day to day problems of users around the GLOBLE (US, Canada,

Europe, Australia, Asia)

. Extensively involved in Creating XML messages using XML Gateway/

Business Events to synchronize OM, INV, GL, AP data from Oracle to

Peoplesoft/ Siebel Applications and vice versa

. Extensively involved in implementing product accounting using

Oracle Client Extension (Standard Costing using Workflow); Order

Line Workflow, PO Account Generator and PO Requisition Account

Generator

. Customize the GL Cogs Account generator using Workflow as per the

client requirements

. Perform Gap Analysis between Peoplesoft Customer data model and

Oracle Customer Registry (TCA).

. Load Peoplesoft Customers into Oracle customers registry(TCA).

Create parties, Accounts and Customer profiles.

. Loaded Peoplesoft Addresses into Oracle Locations and Sites.

. Loaded Peoplesoft Contacts and Telephones into Oracle contacts and

Contact points.

. Loaded Peoplesoft Account associations into Oracle Account

relationships.

. Creating and Monitoring TARs to resolve customer high priority

issues

. Extensively involved in preparing MD50, MD 70 and MD 120 using AIM

methodology

. Wrote the PL/SQL Packages for initiating the business events,

which then calls the XML Gateway maps/ Oracle Workflow to send

messages (Outbound Interfaces) to Siebel/ PeopleSoft

. Involved with creating real time Inbound Interface for orders

coming through WEB and Siebel using Oracle Adapters

. Responsible for Design, Development and Support of Oracle

Financial and Supply Chain interfaces between Oracle Apps and

various other order vectors

. Sales Orders, Discounts

. Item, Item Categories, Item Catalog, Item ON-Hand

. Customer and Supplier Details

. Created/ Modified workflows and Alerts using Workflow Builder/

Alerts

. Extensively used Custom.pll and Forms personalization for Forms

customization

. Involved in creating, modifying and repairing various custom

reports using Report 6i/10g, Noetix Views and XML Publisher

. Designed new Forms and Reports using Oracle Forms 6i/10g, Report

6i/10g that interface with eCommerce

. Created various shell script to move the files to required TOPs

and registered them as concurrent program

. Responsible for creating extensive documentation because of the

SOX compliance

. Responsible for creation of concurrent programs, value sets,

parameters for the generated reports

. Involved in creating, enhancing and optimizing simple to complex

reports using Oracle Discoverer reporting tool. Granted access

privileges to specific users and granted security access to use

related business areas using Oracle Discoverer

. Labeled information in a business area to help end users identify

the information they will want to access

. Improved the association between folders by creating the

necessary joins between folders in the business area

Environment: Forms 6i/9i/10g, Reports 6i/9i/10g, Discoverer 9i/10g, HP

Service Desk, Oracle 10g, LINUX,

Windows XP, SQL*Plus, PL/SQL, TOAD, XML Publisher, Business

Events, XML Gateway,

Workflow Builder, Alerts, Biztalk, Oracle AQ/ DQ

Senior Techno Functional Consultant

Rogers Communications,Brampton ON

Oct 2008 - Aug 2009

Project: NRIS (OM, INV, WMS, PO, GL, AP, AR, FA), Oracle HRMS

. Currently working on NRFS customized application integrated with

OM, INV, WMS, PO, Oracle Financials and Oracle HRMS

. Extensively involved as a techno-functional consultant, solving

day to day problems of users

. Extensively involved as team lead in notifying senior project

leads/ management whenever scope of the project changes and extra

man-months/ efforts required completing the tasks, documenting and

executing changes as per the new requirement

. Creating and Monitoring TARs to resolve customer high priority

issues

. Extensively involved in preparing FRD (Functional Requirement

Document) and DDD (Detailed Design Documents) using AIM

methodology

. Working with the functional lead and stakeholders to evaluate and

identify functional gaps between the application and business

requirements and identify potential solutions.

. Wrote the PL/SQL Package for loading the data from various other

systems including LHO, DOAT, TOE, Rogers.com, PeopleSoft HRMS etc.

. Responsible for Design, Development and Support of Oracle

Financial and Supply Chain interfaces between Oracle Apps and

various other order vectors

. Sales Orders, Discounts

. SKU, SKU Category and ON-Hand details

. Customer and Supplier Details

. Created/ Modified workflows and Alerts using Workflow Builder/

Alerts

. Extensively used Custom.pll and Forms personalization for Forms

customization

. Involved in creating, modifying and repairing various custom

reports using Report 6i/10g, Noetix Views and XML Publisher

. Designed new Forms and Reports using Oracle Forms 6i/10g, Report

6i/10g that interface with NRIS

. Responsible for creation of concurrent programs, value sets,

parameters for the generated reports

. Created various shell script to move the files to required TOPs

and registered them as concurrent program

. Responsible for creating extensive documentation because of the

SOX compliance

. Responsible for creation of concurrent programs, value sets,

parameters for the generated reports

. Involved in creating, enhancing and optimizing simple to complex

reports using Oracle Discoverer reporting tool. Granted access

privileges to specific users and granted security access to use

related business areas using Oracle Discoverer

. Labeled information in a business area to help end users identify

the information they will want to access

. Improved the association between folders by creating the

necessary joins between folders in the business area

Environment: Forms 6i/9i/10g, Reports 6i/9i/10g, Discoverer 9i/10g, HP

Service Desk, Oracle 10g, LINUX, Windows XP, SQL*Plus, PL/SQL,

TOAD, Noetix Views, XML Publisher, Workflow Builder, Alerts, ALSB,

WLI and XML

Senior Functional/ Technical Consulant

Shaw Communications, Mississauga ON

May 2006 - Oct 2008

Project: Oracle Financials, Purchasing, OM, INV, Service, Omnivision,

RTC, CCSA, Oracle HR

. Worked on Omnivision customized application integrated with Supply

Chain (Service, Install Base, OM, INV, BOM, AR, PO, GL, FA and AP)

. As senior software developer/ team lead, created project plan

using MS project, allocated tasks among different team members,

track and document software changes, coordinated with PM for extra

effort required to complete critical tasks and updated Giant Chart

accordingly

. Extensively involved in preparing MD 50 and MD 70 using Oracle AIM

and preparing detailed design

. Working with the functional lead to evaluate and identify

functional gaps between the application and business requirements

and identify potential solutions.

. Extensively involved as a techno-functional consultant, creating

Flexfields, Custom reports, Modification of invoices, creating new

forms and PL/SQL Packages. Worked closely with Stakeholders,

Business users and functional lead to identify the requirements,

preparing technical design specifications using Oracle AIM and

preparing GAP analysis document in collaboration with functional

lead.

. Wrote the PL/SQL Package for loading the data from ALPHA computer

into customized tables and later on loading the Orders, discounts

into Staging tables and Interfaces, this PL/SQL package loads

millions of records daily from ALPHA computers and later on loads

into Interfaces and then Import the orders into transaction

tables.

. Involved in creating, modifying and repairing custom reports

including invoices like Monthly Invoice, Messaging Invoice, RMA

Invoice, Driver Invoice etc using Oracle Reports 6i

. Responsible for creating extensive documentation because of the

SOX compliance

. Responsible for creation of concurrent programs, value sets,

parameters for the generated reports

. Extensively used Custom.pll for Forms customization

. Designed new Forms and Reports using Oracle Forms 6i that

interface with Supply chain, Oracle Financials, Oracle HR and

Purchasing modules

. Involved in providing 3rd tier support to users of Supply Chain,

Financials, HR and other customized application including RTC,

CCSA etc

. Registered Forms, reports, parameters and concurrent programs in

Oracle Application

. Responsible for development, Support, Troubleshooting and

deployment of Forms as well as reports using Forms /Reports

6i/9i/10g and 9iAS

. Wrote various PL/SQL Packages, functions, procedures and stored

procedures to implement the Business rules uncovered in the

Database design

. Involved in creating, enhancing and optimizing simple to complex

reports using Oracle Discoverer reporting tool. Granted access

privileges to specific users and granted security access to use

related business areas using Oracle Discoverer

. Labeled information in a business area to help end users identify

the information they will want to access

. Improved the association between folders by creating the

necessary joins between folders in the business area

. Set up items in a hierarchy to enable end users to drill up and

down the hierarchy to view related information

Environment: Forms 6i/9i/10g, Reports 6i/9i/10g, Discoverer 9i/10g, Mercury

Test Director, HP Service Desk, Visual Source Safe, Oracle 9i, HP-

Unix, Windows 2000/XP, SQL*Plus, PL/SQL, PL/SQL Developer, TOAD

Senior Functional Analyst

SASK Learning, ITO Regina Aug 2005

to-May 2006

Project: Oracle HRMS, Oracle Financials, EAPD Application, SIS

Application

. Achieved a best performance award

. Involved in implementation of various modules of Oracle HRMS and

played an important role in system study, gap analysis,

Organizational Setup in HR, Flexfields creation, defining

positions, grades, grade steps, progression points, jobs,

recruitment activities and competencies etc as per the

requirements.

. Involved in creating, modifying and repairing custom reports using

Oracle Reports 6i

. Responsible for creation of concurrent programs, value sets,

parameters for the generated reports

. Participated in creation of EUL in Oracle Discoverer involves

creation of Business Areas and its respective folders

. Extensively used Custom.pll for Forms customization

. Designed new Forms and Reports using Oracle Forms 6i that

interface with Oracle HRMS

. Registered Forms, reports, parameters and concurrent programs in

Oracle Application

. Involved in Data conversion activities using APIs, Interfaces

. Responsible for Bug fixing in interfaces and Report generation

related to Oracle Financials and HRMS

. Responsible for development, Support, Troubleshooting and

deployment of Forms as well as reports using Developer 9i/10g and

9iAS

. Created various forms and reports based on stored procedures

. Developed Object Libraries and PL/SQL Libraries

. Wrote various PL/SQL Packages, functions, procedures and stored

procedures to implement the Business rules uncovered in the

Database design

. Responsible for development, Support, Troubleshooting and

deployment of Forms as well as reports using Developer 9i/10g and

9iAS

. Created various forms and reports based on stored procedures

. Responsible for Forms/Reports upgradation to Forms/Reports 10g

. Responsible for end user Support, Troubleshooting and Bug fixing

of existing applications

. Created parameterized report using reports 9i/10g, which are able

to query data according to business area

. Developed Object Libraries and PL/SQL Libraries

. Developed and Implement different reusable modules that are

consistent throughout the applications

. Wrote various PL/SQL Packages, functions, procedures and stored

procedures to implement the Business rules uncovered in the

Database design.

Environment: Forms 6i/9i/10g, Reports 6i/9i/10g, JDeveloper, Discoverer

10g, Oracle 9i, HP-Unix, Windows 2000/XP, SQL*Plus, PL/SQL, PL/SQL

Developer, TOAD

Oracle Application Developer

Pontis Corporation, Toronto Ontario

Jun 2005 - Aug 2005

Project: E-Business Suite 11i (Oracle Purchasing (PO)

. Responsible for creating, modifying and repairing custom reports

using Oracle Reports 6i

. Responsible for creation of concurrent programs, value sets,

parameters for the generated reports

. Uploading the reports onto the remote server by using WINSCP3 and

PUTTY

. Using Metalink for problem resolution

Environment: Oracle 9i, UNIX, Reports 6i, TOAD, VPN Client, WinSCP3, PUTTY,

SQL*Plus, PL/SQL

Oracle Application Developer

Ingenium Group INC. Toronto Ontario

May 2005 - Jun 2005

Project: E-Business Suite 11i (GL, AP, AR, PA)

. Involved in creating, modifying and repairing custom reports using

Oracle Reports 6i

. Responsible for creation of concurrent programs, value sets,

parameters for the generated reports

. Participated in creation of EUL in Oracle Discoverer involves

creation of Business Areas and its respective folders

. Designed new Forms and Reports using Oracle Forms 6i that interface

with Oracle Financials

. Designed enhancements to custom forms, reports, concurrent programs

and procedures

. Registered Forms, reports, parameters and concurrent programs in

Oracle Application

Environment: Oracle 9i, UNIX, Forms 6i, Reports 6i, Discoverer 4i,

SQL*Plus, PL/SQL, TOAD, WINDOWS

Senior Oracle Developer/ Data Modeler/ Oracle E-Business Suite 11i

Developer/ Team Lead

Ministry of defence, Riffa, Bahrain

Oct 2002 - Feb 2005

Project: E-Business Suite 11i Implementation (Oracle HRMS, Oracle

Financials and Supply Chain(OM, WMS, INV, BOM, Service)

Environment: E-Business Suite 11i (HR, Payroll, GL, AP, AR, FA, PA, OM,

WMS, INV), Oracle 9i, HP-Unix, Forms 6i, Reports 6i,

Discoverer, Tutorial 11i, SQL*Plus, PL/SQL, APIs and Data

Pumps, Workflow Builder, Oracle Alerts, TOAD

Responsibilities:

. Team lead for 10-15 person team of application developers

. Involved in data conversion from legacy system using APIs and Data

pumps

. Involved in implementation of HR module and played an important

role in system study, gap analysis, Organizational Setup in HR,

Flexfields creation, defining positions, grades, grade steps,

progression points, jobs, recruitment activities and competencies

etc as per the BDF requirements.

. Involved in creating, enhancing and optimizing simple to complex

reports using Oracle Discoverer reporting tool. Report examples

HRMS demographic tabs, periodic HR and pay aggregates for permanent

and temporary employees, HR position control and vacancy reports

. Granted access privileges to specific users and granted security

access to use related business areas using Oracle Discoverer

. Labeled information in a business area to help end users identify

the information they will want to access

. Improved the association between folders by creating the necessary

joins between folders in the business area

. Set up items in a hierarchy to enable end users to drill up and

down the hierarchy to view related information

. Coordinated system development activities with other members of the

project team as required

. Designed new Forms and Reports using Oracle Forms 6i that interface

with Oracle Financials and HRMS

. Developed extensions, conversions and interfaces and integrated the

system with Oracle Applications

. Designed enhancements to custom forms, reports, concurrent programs

and procedures

. Registered Forms, reports, parameters and concurrent programs in

Oracle Application

. Provided documentation of changes and enhancements to custom code

. Involved with System Administration including creating user

accounts and access privileges, menus and report sets, creating

Security Profiles, Menus, Menus Functions



Contact this candidate