Project Oracle

ABBAS KHAN[pic]

Objective:

Seeking an opportunity as Oracle Apps Technical Consultant, where I

can contribute to my team and organization by working in a highly

effective manner and having commitment to meet, exceed expectations

using knowledge, experience and skill set.

Summary:

Dedicated IT professional with total experience of 4.6 years & 3.6 on

EBS.

Presently employed at Hewlett-Packard Company.

Trained & experienced on Oracle Apps EBS R12.1.1, 11.5.9.

Trained on Oracle Fusion CRM / Sales Cloud, Release 8.

Bachelor of Engineering [B.E] in Information Science, AMC Engineering

College,Bangalore.

Enthusiastic and project-oriented team player with excellent

presentation, communication & leadership skills.

Knowledge Base:

Databases & : Oracle Database 10g,11g,Oracle Apps ERP

Application Suites R12.1.1,11.5.9,

Fusion CRM/Fusion Sales Cloud,Siebel CRM 8.0.

: OPA,AR,AP,OM,PO,INV,O2C Cycle,P2P Cycle,

EBS modules/Cycles RICE Components.

Programming

Languages : SQL,PL/SQL.

Fundamentals : CDH,PDH,Forms,Reports,Workflows,Discoverer,

understanding of XML/BI publisher,UNIX,OOPS concept,Oracle

Architecture.

Tools & Utilities : Toad,SQL Developer,PVCS,Perforce,BMC Remedy,

ServiceExchange.

Operating Systems : Windows 7,Fedora Linux Core 10, RedHat Linux

6,Ubuntu.

Professional Experience:

Project # 1

Organization: Hewlett Packard company

Client: Symantec Corporation

Role: Apps Technical Consultant

Duration: June 2013 to Present

Project : Oracle ERP 11.5.9 Sustain Project

Assignment Location: Bangalore, India

Environment: Oracle EBS 11.5.9,Oracle DB 9i,PLSQL,Forms 6i,Reports

6i, Workflows,PVCS,Perforce,BMC

Remedy,ServiceExchange.

Synopsis:

. Symantec is a global giant in security, backup and availability

solutions,

which requires a 24X5 support & 24X7 support during quarter end.

. HP provides platinum level support to Symantec's ERP application,

hence its important that all the issue are fixed within the agreed

SLA.

. Helped the client adhere to SOX & PCI Compliance by following the

standard processes & by mitigating the vulnerabilities in the ERP

system.

Roles & Responsibilities:

. My role would be to provide technical support on the issues related

to transactions, interfaces mainly on Finance & SCM Modules.

. To troubleshoot the issues with an action plan related to

OPA,AR,AP,OM.

. Triaging and analyzing application data and upstream/downstream

integration issues.

. Coordinate and work with vendors for third Party application issues

(such as SFDC, Workday,Sabrix,Streamserve etc).

. Test various scenarios that could have potentially caused the

problem.

. Development of new Interfaces to add additional functionality, that

does not already exist to simplify the business process.

. To work proactively with the business users to identify the exact

issue & to perform tests on non-production instances/UAT testing to

reproduce the issue.

. To identifying the root cause & to implement a code fix or data, may

even involve taking help from Oracle for issues whose complex errors

doesn't fit the known errors, may even need a patch to be applied.

. Drive the high priority SEV 1 & SEV 2 issues independently from the

ERP side with all the dependent stakeholders, cross functional teams,

involve them when needed - Unix, Windows, DBA, network, firewall and

Storage teams and update Business users on regular intervals.

. React to any given technical situation that requires immediate

attention.

. To provide critical support during QEs (Quarter Ends) for potential

revenue impacting issues that need to be fixed ASAP.

. To adhere to SOX,PCI audits when dealing with Change Requests as

audits are performed every quarter.

Out-bound Interfaces:

. Worked on issues related to outbound interfaces from OPA to FF PSA

(Salesforce) via EAI (Tibco) on Project Sync,Funding,Funding

History,

Billing Invoices,Revenue Events & Expense Outbound.

In-bound Interfaces:

. Worked on issues related to inbound interfaces from FF PSA

(Salesforce) to OPA on Timecards, Billing Events & Expense Inbound.

11i-R12 Interfaces:

. To troubleshoot issues pertaining to interfaces between 11i & R12 via

FMW.

Reports:

. Modification of existing Oracle Reports to fix any reporting issue &

discrepancies.

Project # 2

Organization: Randstad India, Kelly Services

Title: Analyst

Duration: August 2010 to June 2013

Project : Data conversion & Enhancements.

Assignment Bangalore, India

Location:

Environment: Oracle Apps EBS R12.1.1,Oracle 10g,11g,Siebel CRM

8.0, PLSQL,Forms,Reports,Workflows,XML/BI

publisher,OBIEE.

Roles & Responsibilities:

. Experience in Data migration, Interfaces and Conversions between

legacy systems to Oracle Apps.

. Strong Technical expertise on AOL, AIM methodology,E-Business Suite

architecture, Oracle SQL,PL/SQL, Database concepts, Oracle Forms and

Reports, Workflow, APIs & Flex fields.

. Performed Customer Conversion, Inventory Item data Conversion from

legacy system to Oracle ERP 12.1.1,Prepare reports, technical design

documents.

. To handle enhancements requests, to add new functionality, either

creation of new objects or modification of existing objects.

Out-bound Interfaces:

. Extraction of the data from the database to the flat file using

UTL_FILE.

In-bound Interfaces:

. Loading of data from the flat files to various modules using

respective interface tables & then using the import concurrent

program to the base tables.

Conversions:

. Developed the module specific conversion program,performed all the

necessary validations using plsql on the staging table,then loading

data into interface tables & then based on validations into base

tables.

Reports:

. Modification of existing RDF Reports to fix any reporting issue &

discrepancies.

. Use XML Publisher to create reports, creating data definitions &

templates.

Siebel CRM:

. Creation Analyses, Segment trees, List Formats across different

Subject Areas using Siebel CRM.

. Worked on Subject Areas like Custom contacts, Custom Accounts,

Install Base, Revenue recognition etc.

. Loading bulk data from flat file to database using SQL*Loader, then

checking for various conditions before providing data to the end

users.

Academic Qualifications:

Degree Institute/ University Year of Passing (%age)

B.E in Information AMC Engineering July,2009 65.6

Science and Engineering College, Bangalore

Pre-University Course Al-Ameen PU College, 2005 61.5

(PUC) Bangalore

Training and Other Projects:

Trained & experienced on Siebel CRM 8.0.

Oracle Database Administration, DBA 10g Certified Professional [OCP].

Sun Microsystems: As part of my 8th semester project, completed a 3

month project (March-May 2009) at Sun Microsystems.

IIHT: completed a course titled "Fundamentals of RedHat Enterprise

Linux5" from IIHT.

Personal Details:

Date of Birth : 25th December 1986

Nationality : Indian

Willing to relocate : Yes

to a different

country

+91.990.23.28.120

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

#49 St Johns' Road,

Bangalore-42

Contact this candidate