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.