Oracle EBS Technical Consultant

ORACLE EBS-TECHNICAL CONSULTANT

OBJECTIVE: To pursue a challenging career in the field of software development, especially in RDBMS, Oracle ERP Modules with an organization can provide challenges with significant professional and technical growth. Very aggressive to learn and work with new technologies.

CARRIER SUMMARY

Overall 5+ Years Hands-on Experience in RICE COMPONENTS i.e.

Development, Extension customizations, integrations and Personalization of screens / reports (using Oracle FORMS / Oracle REPORT / XML Publisher) for E-Business Suits.

Write, debug, database packages, procedures/ Function / Triggers in RDBMS using Oracle Technologies i.e. (SQL, PL/SQL) as per business requirement with SQL/PLSQL Tuning, Code Review, Testing, Training and providing Technical support to Clients.

Defining and handling Oracle ALERTS and Oracle WORKFLOW.

2 Years’ experience in E Business Suite as “TECHNO FUNCTIONAL CONSULTANT”

Onsite-Offshore ERP implementation / Post implementation support for GENERAL LEDGER – GL, AP, AR, HRMS & SCM.

5+ years UAE experience e as ORACLE “TECHNICAL CONSULTANT/ DEVELOPMENT ENGINEER” to :-

Technically fluent in Writing / Debugging, Database Packages / Procedures / Function / Triggers in RDBMS using Oracle Technologies i.e. (SQL, PL/SQL).

Developed GUIs / Reports (using ORACLE FORMS & REPORTS) for Airline Cargo accounting ERP and for Oracle EBS- R12 as well.

5+ Years’ experience in providing

Techno Functional Support for Airline revenue accounting ERP application with End-to-End User Support

Expert in Incident management and providing resolution.

TECHNICAL PROFILE

SKILL SET

LEVEL

YEARs

RICE COMPONENTS using Oracle Forms, Oracle Reports, Interfaces, Conversions

V. GOOD

6+

Oracle ALERTS & WORK FLOW

GOOD

2

Oracle SQL, PL/SQL

V. GOOD

6+

ONSITE- OFFSHORE TECHNICAL SUPPORT for Oracle E-Business Suite (R12)

GOOD

2

XML - BI Publisher

GOOD

1

Oracle Application Framework - OAF

BEGINER

TECHNO FUNCTIONAL CONSULTANT for Cargo Revenue accounting ERP.

V. GOOD

6+

Developing Dashboards and Advance Web Reports using MicroStrategy Tool

GOOD

1

Developing BI-Business Intelligence applications using TABLEAU

GOOD

1

Soft Communication skill for conducting Telecom with Clients

V. GOOD

6+

User End to End Application Training

V. GOOD

5+

Software Development Life Cycle (SDLC).

V. GOOD

6+

Configuration Management System (Al Fusion Harvest CM workbench)

V. GOOD

6+

PERSONAL PROFILE

Worked as ORACLE TECHNICAL CONSULTANT / Sr. ORACLE DEVELOPMENT ENGINEER to provide technical functional support for Oracle based applications / ERP Application.

Hands-On experience in providing technical and functional support of Oracle HR Suite consisting

General Ledger - GL / AP / AR.

SCM & CORE HR, PAYROLL

Hands-On Experience in RICE Components. i.e. (REPORTS, INTERFACES, CONVERSIONS, ENHANCEMENTS)

Write, debug, database packages, procedures/ Function / Triggers in RDBMS using Oracle Technologies i.e. (SQL, PL/SQL) as per business requirement. Developed GUIs using Oracle FORMS & Oracle REPORTS (10g) for Airline Cargo accounting ERP as well as for Oracle E-Business Suite R12.

Experience in full life cycle implementations, SDLC.

Participating in business requirement gathering and documentation and providing Production support for Oracle Financials

Programming experience in Oracle SQL, PL/SQL

RICE, Integration of Oracle EBS with legacy Systems

Data Conversions, API's & Interfaces and Customizations

Developed Customized reports and BI Publisher Templates for HRMS (Core HR, SSHR, Payroll)

Oracle Forms Development, Personalization and Customization 10G

Oracle Alerts (Event, Periodic)

Perform Enhancement (CRs), Customization and development of Screens / Reports for product, Code Review, Testing and providing Technical Functional ERP Support.

Active participant of design review to give the necessary inputs to ensure that the design meets the defined performance with regard to specifications knowledge and product robustness if needed.

Participate in customer service agreement review (SLA) and having telecom with clients for service feedback and to improve the same.

Quality control of work by appropriate review, support and lead process improvement activities

Prepare and update documents i.e. MD70 MD40 & AIM to assist application implementation

Customize system design to meet requirements as per the HR business users.

Enhancement, Customization and developing new screens, reports for Oracle ERP application, performance Tuning, Code Review, Testing, Training and providing Technical support.

Techniques in overseeing the ERP support / Issue resolution and having excellent knowledge of designing ERP functional solutions as per the business requirements.

Prepare and execute test scripts and test cases and ensure all requirements are met.

Troubleshoot and resolve technical issues, especially around Oracle integration programs.

Soft communication skills for conducting telecom with clients around the world to review / feedback of deliveries / services provided.

Having dynamic and robust Professional experience in System Analysis, Solution Architecture, Solution Design, Software Development, code Review, testing, training and support.

Currently working in Agile & Scrum methodology and having good experience to handle backlogs and scrum planning and defining the stories & EPIC.

Good knowledge of Airline cargo related business related ERP application and core accounting application.

PROFESSIONAL EXPERIENCE

Company Name: MERCATOR LLC FZE (https://www.mercator.com/)

Location: DUBAI - UAE

Period: JUL - 2015 Till SEP-2017

Designation: Oracle EBS - Technical Consultant

Responsibilities: -

To Provide Technical and Functional support of Oracle E-Business Suite modules

General Ledger - GL / AP / AR & CORE HR, PAYROLL

Development, Extension Customizations, integrations and Personalization of screen and reports (using Oracle FORMS / Oracle REPORT / XML – BI Publisher for Oracle E-Business Suite R12.

Developing new Reports using XML publisher and Oracle Reports / Discoverer

Write, debug, database packages, procedures/ Function / Triggers in RDBMS using Oracle Technologies i.e. (SQL, PL/SQL) as per business requirement.

Carry out user screens / reports Enhancement and personalization based on business requirements.

Interact with business user to clarify requirements and propose/review design requirement.

Develop detailed functional and technical specification for system configuration, enhancement and to develop reports to meet the user requirements.

Work with other team to ensure technical and functional deliverables meet user requirements and co-ordinate on-time to complete dependent tasks.

Coordinate with support team for any issue/system bug reported and coordinate with concern member to provide resolution to meet the user requirements.

Overall internal and external day-to-day IT operations, providing overall management of technology vendor(s).

Providing Technical and functional business support for Airline’s Cargo Revenue accounting ERP –RAPID (detail is available in link given) for different modules like Flown, Sales, Master data, CCA, Export/Import Billing, Interline, Proration, Incentives, Postal Mail, accounting, Prime, Recharges, interfaces with SIS, ERP, SkyChain) and with other upstream / downstream aviation industry systems etc.

Post implementation of applications, testing and maintenance.

ERP TECHNICAL SUPPORT: Investigate assigned incidents and repair software in all relevant versions as necessary ensuring that all faults are resolved within the applicable SLO.

Active participant of design review to give the necessary inputs to ensure that the design meets the defined performance with regard to specifications knowledge and product robustness if needed.

Perform Enhancement (CRs), Customization and development of Screens / reports for product, Code Review, Testing and providing Technical Functional ERP Support.

Company Name EMIRATES AIRLINE – IT GROUP (https://www.emirates.com/ae)

Location Dubai - UAE

Period Nov-2010 to Jun-2015

Designation: Oracle Consultant

Responsibilities: -

Providing Technical and Functional support of In-House built ERP and provide technical functional support for PURCHASING / INVOKING / STOCK modules along with Airline Revenue accounting system.

Write, debug, database packages, procedures/ Function / Triggers in RDBMS using Oracle Technologies i.e. (SQL, PL/SQL) as per business requirement.

Developing GUIs using Oracle Forms & Oracle Reports (10g) for Airline Cargo accounting ERP

Providing Technical and functional support for Airline’s Cargo Revenue accounting ERP

Post implementation of applications, testing and maintenance.

Customize system design to meet requirements as per customer requirement and co-ordinate in technical, implementation.

Enhancement, Customization and developing new screens, reports for Oracle ERP application, performance Tuning, Code Review, Testing, Training and providing Technical support.

Overall internal and external day-to-day IT operations, providing overall management of technology vendor(s).with

Post implementation support of applications, testing and maintenance. t

Perform Enhancement (CRs), Customization and development of Screens / reports for product, Code Review, Testing and providing Technical Functional ERP Support.

ACADEMIC DETAIL

Title : - Master in Computer Science – MSC,

Period : - 2002 to 2004

University : - Central University of Punjab – Pakistan

Specialization : - Software Engineering

Title : - Bachelor in Science (BSC)

Period : - 1993 to 1996

University : - Punjab University

Specialization : - Science

PROFESSIONAL TRAINNING

Dashboards and data discovery using MicroStrategy

Import data into MicroStrategy to create visually appealing interactive dashboards. Learn how to turn your data into visualizations that enable you to quickly and easily analyze trends and key performance indicators. Analyze your visualization by applying thresholds, drilling, and filters. Easily export the dashboard to share with others and access your data on the go.

Advanced Reporting in MicroStrategy

Create reports, metrics, and filters in MicroStrategy Web. Build perfectly formatted documents and enterprise dashboards most commonly used for financial statements, performance scorecards, and executive reporting applications.

PERSONAL DETAILS

Mobile : 971-**-*******

E-Mail : ***********@*******.***

Date of Birth : 15-05-1975

Visa Status : Transferable Visa

Notice Period : None (IMMEDIATE JOINING)

Driving License : Yes

PROJECT DETAIL

Airlines Revenue Accounting ERP System – RAPID

Title RAPID (Revenue, Accounting, Proration, Interline Billing, Decision Support)

Tools: Oracle (backend), Oracle Form, Reports (GUIs)

Role: Team Member / Developer / Techno Functional Support Engineer

PLEASE REFER TO LINK FOR MORE DETAIL OF ERP WORKED

https://www.mercator.com/solutions/airline-revenue-accounting

*Reference and project detail can be provided if required …..

Contact this candidate