Post Job Free

Resume

Sign in

Oracle Application Techno Functional Consultant

Location:
Mississauga, ON, Canada
Posted:
March 25, 2015

Contact this candidate

Resume:

Professional Summary

. **+Years of experience in IT industry with 3+Years of client facing

experience in US.

. Experience in Oracle ERP including Developing, Customizing, Designing,

Testing and Implementation of Oracle Financials and Manufacturing

modules.

. Expertise in SQL* Plus, PL/SQL, Oracle Forms, Oracle Reports, EDI,

Discoverer, XML Publisher, BI Publisher, Workflow, Java Script & Oracle

Application Framework.

. Having a extensive Techno Functional experience in Oracle Application

Modules like Order Management, Inventory, WIP, Purchasing, Account

Receivable, Account Payable.

. Experienced in data conversions and Migrations using Interface tables

and APIs from Feeder and Legacy systems to Oracle Application 11i suite

& R12.

. Involved in development of RICE components using SQL, PL/SQL, Developer

2000, XML Publisher as per Oracle Applications coding standard.

. Good experience in using Application ImplementationMethodology (AIM)

. Involved in all phases of Software Development Life Cycle.

. Developed Loader Control scripts for different conversions and

interfaces using SQL Loader.

. Proficient in functional knowledge of HRMS, Order to Cash, Procure to

Pay and Financial business processes with order to cash(O2C), procure-to-

pay(P2P) and END-END cycles of Oracle Applications E-Business Suite and

accounting-to-financial reporting functions.

. System Administration activity to provide support to apps users for any

technical issues.

. Excellent interpersonal, communication skills and understanding of

Business applications.

Skills

Oracle Applications : Oracle Applications 11i, R12

Oracle ERP Financials : Accounts Payables (AP), Account Receivables

(AR),

General Ledger (GL), Cash Management (CM), Fixed Assets

(FA), Project Accounting, TCA

Oracle ERP Manufacturing : Inventory (INV), Bill of Materials (BOM),

Work in Process (WIP), Purchase Order (PO), Order Entry/Order

Management (OM), Shipping and Advanced Pricing.

Operating Systems : MS-DOS, UNIX, Linux, WINDOWS NT/XP/2000/98

Languages : SQL, PL/SQL.

Development Tools : Developer 2000, XML Publisher, Oracle Forms

10g/9i/6i, Reports 10g/9i/6i, Discoverer 10g/4i Reports and Work Flow

Builder

Database Tools : SQL*PLUS, SQL*Loader, TOAD

Client Tools: HP Quality Control, Kintana, Clearcase. Service desk.

Certification

Bachelor of Science, M.S. University, Baroda, India

Master of Computer Application I.G.N.O.U., India

Oracle Certified Associates (OCA Database 9i) Database track:

Creating/Migrating/Upgrading Database, Database architecture.

Professional Profile

Employer : iGATE Ltd. (Formerly Patni Computer

Systems Limited), India

Currently on H1B on US Work Visa on US Project. Also

I am having Canadian PR.

Title : Project Lead

Dates of employment : June 2006 to Till Date

Client: Motorola Project: LE/OU Separation Jul-2014

-Present

Role Description: Onsite Consultant

. Performing Key role for Quote to Order stream to analyze the requirement

for Legel entity separation.

. Onsite lead on Rebranding and customer facing doucments design,

Development & testing activity.

. Worked on Oracle R12 Platform using technologies like Pl/Sql, Oracle

Forms, Oracle Application Framework(OAF) using JAVA technology.

. Actively participant from R12 side for R12 application integration with

downstream Service systems with the use of Service Oriented

Architecture(SOA).

Client: Motorola Project: PSION Integration Dec-2013 -Jun-

2014

Role Description: Onsite Technical lead

. Performing a Key role in P2P,Demantra conversion and related GAP analysis

for integrations.

. Play a key role in designing & technical analysis on ARC integration for

their communication devices to develop design from weblogic to oracle

application.

. Worked on Oracle R12 Platform using technologies like Pl/Sql, Oracle

Forms, Oracle Application Framework(OAF) using JAVA technology.

. Actively participant from R12 side for R12 application integration with

downstream Service systems with the use of Service Oriented

Architecture(SOA).

Client: CMC,USA Project: Oracle Application Rollouts Mar-

2012 -Nov-2013

Role Description: Onsite coordinator & Project Lead

. Worked on moving their Cardiff, Singapore, Australia business to Oracle

applications from their old Navision ERP system for HRMS,Purchasing,

Order Management, Inventory, Costing, Account Receivables, Account

Payables, and General Ledger operations.

. Worked as Offshore Lead/Onsite Lead on the project, which had onsite and

offshore based model.

. Provide customized flow from telesales entry to order booking & finally

work order creation Process flow.

. Worked on Oracle R12 Platform using technologies like Pl/Sql, Oracle

Forms, Oracle Application Framework(OAF) using JAVA technology.

. Actively participant from R12 side for R12 application integration with

OBIEE systems with the use of Service Oriented Architecture(SOA).

Client: Gexpro USA Project: OA Supports and Project Jun-

2010 -Mar-2012

Role Description: Offshore PMO Team/Onsite Level2 support

. Provide the technical design for solution to split the Order line based

on Quantity on Subinventory to manage the stock on inventory.

. Played key role on architecture movement to third party vendor to do GAP

analysis on oracle RICW component.

. Key resource while migration of DB from 9i to 10g to analyze the changes

required on existing system.

Client: Opnext Inc., U.S.A. Project: EDI Implementation for Arrow Jan-

2010 -May-2010

Role Description: Team Member, onsite

. Provided End to End solution from Customer order placing to Invoicing

through EDI 850/855/860/810 process.

. Development and update of technical design/migration documents MD070s and

MD120s.

. Resolving of technical / functional issues at client place and

communicating/coordinating on the issues with the offshore team.

Client: New York Stock Exchange, U.S.A. Project: Financial Systems

Integration (NYSE) Apr-2008 -Jan-2010

Role Description: Team Member (onsite)

. Working as Onsite Coordinator for support related activities for Oracle

AR, AP, PO, iSupplier, iProcurement.

. Performing Onsite Support and Interacting with the client on various

forums to discuss the status of the project, clarify any queries

regarding the functionality etc.

Client: Toshiba, JAPAN Project: TMC Version Upgrade Apr-2007 -Mar-2008

Role Description :Team Member (onsite)

. Contributed as a tech lead for development team at onsite.

. Retrofit customizations (767 Objects) from 11.0.3 to 11.5.10 include

forms conversion. PL/SQL, Web PL/SQL, Functions etc.

Client: JDSU, USA Project: Oracle JDSU Acterna PHASE II

Feb-2007 -Mar-2007

Role Description: Programmer

. Customizations of Oracle Reports related to various modules.

. Preparing deliverable documents such as High Level Technical Design

(MD070).

Client: Motorola Ltd., UK Project: Russia Buy Sell (Legal Entity)

Dec-2006 -Jan-2007

Role Description: Analyst

. Design & developed custom processed based on Customer Requirement based

on oracle standard.

. Customizations in PL/SQL, Oracle Forms and Oracle Reports.

Client: Experian Ltd., UK Project: Sharpowl Replacement Project Sep-

2006 -Dec-2006

Role Description: Team Member

. Creation of Clone database script in Apps Schema.

. Worked on HRMS, Oracle Projects Modules.

. Creation of Migration script for Migrate data from SQL Server to Oracle

Database.

Employer: Axtel Industrial Ltd. India Project: In House ERP Aug-

2003 -June-2006

Role Description: System Administrator & network Officer

. Responsible of Forming Backup Strategies for getting up to point of data

back in case of Failure.

. Developed customized forms & Reports using forms 6i & Reports 6i.

. Involved in Sql Query tuning.

Employer: Absolute Software Solution,India Project: Customized ERP Mar-

2002 -Aug-2003

Role Description: Team Member

. Provide Technical support & worked on enhancement request on Oracle

forms/report based ERP software.



Contact this candidate