Oracle Management
Resume:
SAMIT ROY [pic]
Functional Consultant (Oracle Apps ERP)
Professional Summary:
. Almost 8 years of professional experience in IT fully with Oracle
Applications (ERP) as Functional Consultant.
. Experience in system analysis, requirements gathering, database
design, development, testing, migration, user documentation,
implementation, integration and production support for various
Oracle ERP projects.
. Oracle OCP Certification on Oracle EBS R12: Inventory and Order
Management Fundamentals.
. Six Sigma Green Belt certified.
. Awarded by GE Medical Systems for Outstanding Performance.
. Awarded twice by ALCOA for Outstanding Performance.
. B.Tech in Computer Science & Technology from University of Kalyani.
Key Strengths in Oracle Applications:
. Oracle Apps 11i Consultant providing development assistance to
customers and business professionals.
. Extensive Functional Knowledge in Oracle 11i modules of Oracle
Distribution (Order Management, Purchasing, Advanced pricing,
Inventory and Shipping), Oracle Supply chain Management (SCM) (WIP,
BOM, MRP), Oracle Financials (Account Receivables, Account
Payables).
. Experience in Oracle Discrete Manufacturing.
. Experience in Oracle R12.
. Extensive worked on Oracle Bills of Material, WIP and Oracle
Inventory modules.
. Knowledge in E-Business Tax in Oracle R12.
. Experience in complete business flow of Oracle Order to Cash.
. Extensive worked on Order entry, scheduling, shipping areas of OM
module.
. Knowledge in VAT and tax rules.
. Knowledge in Enhanced handling of Tax on Freight.
. Worked on AR Auto-invoice.
. Worked on Quality Management for General Electric.
. Experience in Oracle Cost Management.
. Worked on Oracle Process Manufacturing area.
. Experience in translation of reports and forms into different
languages using Translation Builder.
. Experience in Forms Customization through Oracle Forms
Personalization and CUSTOM.PLL.
. Experience in performance tuning using SQL Trace, Explain Plan,
TKPROF.
. Strong Functional knowledge in various business flows Order to Cash
(O2C), RMA Cycle, Procure to Pay (P2P) cycles.
. Worked on Oracle Purchasing module.
. Experience in Multi-Org environment.
. Extensively worked on the AIM documents like MD 60, MD 70, MD 50 and
RD 60.
. Expertise in developing RICE components (Reports, Forms, Interface
and Customizations).
. Worked extensively in Interfaces (both inbound & outbound) and API's,
especially on Recipe, Routing and whole Shipping process for Alcoa.
. Proficient in writing PL/SQL Packages, Stored Procedures, Functions,
Database Triggers, Unix Shell Scripts and SQL * Loader scripts.
. Expertise in importing data from legacy systems and integrate it
into Oracle Applications using open interfaces, APIs and utl_file
Packages.
. Experience in Migration of customized Oracle Apps code in UNIX
environment using UNIX shell scripts and using IT Governance tool.
. Experience in Documentation of the Deliverables as per the Oracle
Standards.
. Good understanding of SDLC and version control systems using PVCS
and IT Governance.
. Skilled at application development, identifying potential problems
and resolving all inquiries in an economic and timely fashion while
minimizing customer stress levels.
. Good in analytical, Customer handling, problem solving, communication
and leadership skills.
. Strong process background: Aim processes, Implementation
Methodologies, Strong object oriented analysis, design and
development concepts.
. Worked in the Onsite-Offshore model.
Technical Skills:
Languages SQL, PL/SQL
Technologies Oracle
RDBMS Oracle 8i, 9i
ERP/CRM R12, 11.5.10 - 11.5.8- 11.5.9 - 11.5.7 - 11.0.3
Tools: Forms developer 6i,reports developer 6i,Toad, SQL
Loader, Discoverer, Translation Builder, IT
Governance, Remedy User & Web application, Telnet,
Putty and Clear Orbit
O/S Windows 98/2000 & Windows NT 4.x, UNIX
Professional Experience:
Project : NAPM EBS Implementation
Organization : Oracle Corp.
Client : ALCOA, Knoxville, TN
Role : Oracle Apps E-business Functional Consultant.
Duration : Nov 2006 - till date
Environment : Oracle Applications 11.5.10
Alcoa is one of the largest aluminium produced company in the World. They
produce and transact million of tons of aluminium per year. It involves
extraction of aluminium from soil, refinery, mixing with other elements and
produce different shapes of aluminium metal depending on customer
requirements. They have their several plants and business units in all over
the world to produce metal and fulfil customer requirements. North America
Primary Metals (NAPM) is one of the business units, which handles aluminium
production and transaction to several customers in Canada, North America,
some part of Europe and in Brazil. To track, regulate and maintain this
huge number of transactions per year, Oracle Apps ERP solution has been
implemented in NAPM. This ERP solution makes their whole process easier,
with high efficiency and it saves lot of time, which increases their
revenue per year.
Project involved with new customizations, enhancements on existing
components, bug-fixing, new integration solutions. The modules implemented
are Distribution (Order Management, Shipping, Advanced Pricing,Purchasing,
Process Manufacturing), Shop Floor Transaction, Inbound & Outbound
Interface integrated with Interconnect and TIBCO.
Responsibilities:
. Analysis of requirements and preparation of MD60/RD60 after
discussions with functional consultants and users.
. Worked on Order to Cash workflow starting from Order Entry, book
order, allocation, shipping to load the data to AR through AR auto
invoice.
. Extensive worked on Discrete Manufacturing.
. Created different Item data in master organization and assigned to
different organizations.
. Worked on allocation of material depending on the order requirement.
. Gathered knowledge of client's Multi-Org structure.
. Implement customization to create Routing, recipe for different
Business Units in North America and Europe which automate the
process in Bills of Material and Oracle WIP modules.
. Coding and development of custom reports/interfaces/forms as per
technical specifications. Testing them in coordination with
functional users and obtaining user signoffs.
. Creation of proper test plan and test data for a complete cycle of
any deployment, customization components testing.
. Preparation of deployment plans and coordination with DBAs to deploy
them over UAT and PROD instances.
. Discussion with BPO to get the signoff for PROD migration.
. Migrate the newly developed or enhanced code to UAT, QA and PROD
instances using IT Governance tool.
. Set up any new Tax users and Lookup code related to e-Business Tax,
changing any profile option values for North America and Europe
business Units.
. Knowledge in TCA Geography Hierarchy related to Oracle e-Business
Tax.
. Developed and enhanced Summary Order Status report using report6i for
both Oracle Advanced Supply Chain Planning and Order Management
module.
. Train key users for any new functionalities, enhancements or
customizations.
. Resolve any issues and break fixing on any existing components during
the life cycle of implementations.
. Work with Oracle (TAR) if needed.
. Prepare all documentations for Internal Audit purpose.
. Coordination with other teams like Interconnect, TIBCO for any
integration solutions.
. Regular onsite/offshore coordination to get clarifications from
users/functional consultants over components developed from
offshore.
Environment: Oracle Applications 11.5.10, Order Management, Discrete and
Process Manufacturing, BOM, WIP, MRP, Sys Admin, SQL*Plus, SQL*Loader,
Oracle 9i (SQL, PL/SQL), Reports 6i, Forms 6i, Oracle Workflows,
Translation Builder, Telnet, IT Governance, TOAD, UNIX Shell Scripts.
Project : Alcoa Global Support Center
Organization : Oracle Corp.
Client : ALCOA, Bangalore, India
Role : Oracle Apps Functional Consultant.
Duration : Sep 2005 - Oct 2006
Environment : Oracle Applications 11.5.9
Responsibilities:
. Continuous monitoring of Remedy issue log tool.
. Analysis of any issues which come through remedy after discussion and
get clarified by the requestor.
. Resolved issues on Oracle Discrete Manufacturing module.
. Creation of proper test plan and test data to reproduce the issue in
lower instances for better understanding of the issue.
. Resolved any issues related to Order Management, Shipping areas.
. Worked on Oracle Advance Supply Chain Planning module.
. Analysis of forecasting and planning data.
. Creation of any remedy tickets to apply data fix scripts approved by
the functional analyst and DBA.
. Develop and enhancement in any Discoverer report especially in Oracle
Shipping, Process Manufacturing, Account Receivables modules.
. Resolved issues related to Oracle Cost management.
. Coordination of migration of any code to UAT, QA and PROD instances.
. Analysis and resolved issues related to Oracle Purchasing module.
. Developed an outbound interface using UNIX Shell script, PL/SQL
stored procedures and Oracle standard API's in Shipping module.
. Enhanced custom Forecast process which runs once in a day to
redistribute planning and actual quantity among different Business
Units in North America.
. Work with Oracle (TAR) if needed.
. Created a read-only responsibility to see Financial transactions.
. Implemented form personalization on several Financial and Inventory
seeded forms.
. Prepare all documentations for future reference.
. Coordination with requestor to check if the issue is fixed and get
signoff from them.
. Issues on Order Management, Purchasing, AR, BOM, WIP, Inventory
Management, Oracle Advance Supply Chain Planning and Shipping.
Environment: Oracle Applications 11.5.9, Discrete Manufacturing, OM, INV,
PO, AR, AP, Oracle ASCP, AOL and Sys Admin, SQL*Plus, SQL*Loader, Oracle 9i
(SQL, PL/SQL), Reports 6i, Forms 6i, Discoverer 4i/10G, Oracle Workflows,
Tibco, Remedy User & Web tool, TOAD, UNIX Shell Scripts.
Project : GEHC Oracle Apps Development Support
Organization : TATA Consultancy Services Ltd.
Client : GE Healthcare, Calcutta, India
Role : Oracle Apps Functional Consultant
Duration : March 2003 - August 2005
Environment : Oracle Applications 11.5.9 to 11.5.10
Work involved analysis of client requirements; development of MD70 after
discussion with functional consultants and module experts; design and
development of the programs; testing of developed components; migration to
production, and post migration support like MD120 development and Knowledge
Transition to Production Support Team. The Oracle Apps Modules include
Manufacturing (WIP, BOM), Distribution (OM, INV, PO and SHIPPING).
Responsibilities:
. Analysis of functional specifications and requirement finalization
after proper discussions with Client/Functional Consultants and Module
Experts.
. Worked on Oracle BOM and WIP modules.
. Analysis the multi-org structure and item definition for different
organizations.
. Extensive worked on Oracle Manufacturing and OM modules.
. Preparation of MD70.
. Developed and Enhanced commercial intransit report using report6i for
North America location.
. Use PVCS tool to control version of any new or existing code.
. Coordination with migration team to migrate any enhanced or newly
developed reports, forms or PL/SQL interface codes.
. Register report rdf file to Oracle Application and attach report
concurrent program to the proper request group.
. Created new form function and Menu for any custom forms and attached
them to the Oracle application.
. Using forms6i tool, developed and enhanced custom forms in Oracle
Discrete Manufacturing, Order Management, Shipping modules.
. Implemented inbound and outbound interfaces using PL/SQL stored
procedures and public API's to flow data from EBS to Legacy system and
vice-versa.
. Build a custom Quality management process for General Electric to
improve the transition process between development team and support
team.
. Generated tkprof files and analysed code to perform performance
tunning.
. Coding and Development of Components.
. Implemented email functionality in the existing shipping outbound
interface.
. Perform whole Order Management cycle starting from Order creation to
shipping and Interface trips.
. Experience in Requisition to Pay process.
. Performed AR auto invoice to load data from Order Management to
Account Receivables.
. Train users for any newly developed customizations.
. Preparation of Test plans, Testing and obtaining user signoffs.
. Post migration support to delivered components.
. Helping and Guiding New Team Members.
Environment: Oracle Applications 11.5.9/11.5.10, OM, INV, PO, AOL and Sys
Admin, SQL*Plus, SQL*Loader, Oracle 9i (SQL, PL/SQL), Reports 6i, Forms 6i,, Oracle Workflows, TOAD, UNIX Shell Scripts, PVCS, Optio.
Project : GEHC Oracle Apps E-business support
Organization : TATA Consultancy Services Ltd.
Client : GE Healthcare, Calcutta, India
Role : Oracle Apps Functional Consultant
Duration : April 2002 - February 2003
Environment : Oracle Applications 11.5.9 to 11.5.10
General Electric is a multinational manufacturer and marketer of integrated
systems solutions for their Healthcare, shipping and other businesses. Work
involved analysis of client requirements; development of MD70 after
discussion with functional consultants and module experts; implement and
resolving issues related to Oracle Manufacturing and OM modules; design and
development of the programs; testing of developed components; migration to
production, and post migration support like MD120 development and Knowledge
Transition to Production Support Team. The Oracle Apps Modules include
Manufacturing (WIP, BOM), Distribution (OM, INV, PO and SHIPPING).
Responsibilities:
. Analysis of functional specifications and requirement finalization
after proper discussions with Client/Functional Consultants and Module
Experts.
. Experience in Multi-Org environment and good knowledge of TCA.
. Handling the P2 issues in Order Management, purchasing, BOM, AR on
both functional and Technical issues.
. Worked on Oracle BOM and WIP modules.
. SysAdmin tasks (Concurrent Program registration,form,function and
menu registration,valueset setup, DFF setup,Profile setup).
. Extensive worked on Oracle Manufacturing and OM modules.
. Preparation of MD70.
. Involved in the conversion process to import the item catalogue data
from the feeder system into Oracle Inventory.
. Involved in the conversion process to import the Bills Of Material
data from feeder system into Oracle Bills Of Material.
. Implemented inbound and outbound interfaces using PL/SQL stored
procedures and public API's to flow data from EBS to Legacy system and
vice-versa.
. Worked on Issues involved in Order Management RMA process.
. Taken care of Delivery DFFs for shipping truck number.
. Resolved issues related to Auto trip process.
. Worked on manual allocation and customized allocation process during
shipping.
. Perform whole Order Management cycle starting from Order creation to
shipping and Interface trips.
. Experienced in issues on order scheduling process.
. Performed AR auto invoice to load data from Order Management to
Account Receivables.
. Preparation of Test plans, test data, Testing and obtaining user
signoffs.
. Post migration support to delivered components.
. Helping and Guiding New Team Members.
Environment: Oracle Applications 11.5.9/11.5.10, Discrete Manufacturing,
OM, INV, PO, AOL and Sys Admin, SQL*Plus, SQL*Loader, Oracle 9i (SQL,
PL/SQL), Reports 6i, Forms 6i,, TOAD, UNIX Shell Scripts.
Contact this candidate