Project Oracle
Resume:
VENKATAGIRI NAGARAJAN
*****.****@*****.***
PROFESSIONAL PROFILE
o Seasoned IT professional with 8 years of experience in Oracle based
and related Technologies having comprehensive business/technical skill
set and expertise in business process & technical flow of Oracle
Applications (Order Management,Inventory,BOM,PO,HR,Payroll,Supply
Chain & Manufacturing)
o Extensive knowledge and experience in Implementation and Customization
of Interfaces, Data Migration & Conversion, Integration and
Development.
o Expertise in Oracle SQL Plus, SQL* Loader and PL/SQL programming.
o Expertise in Data Conversion, Migration and Upgrade.
o Experienced in Shell scripting/programming under UNIX. Well versed
with UNIX (Solaris) and K-Shell commands.
o Commendable experience in RICE (Reports, Interfaces, Conversions and
Extensions) components.
o Expertise in Forms 6i and Reports 6i Development.
o Experience in Trading Community Architecture (TCA).
o Ability to work on new technologies like Fusion and BPEL.
o Completed following four modules in CPIM (Production and Inventory
Control Management).
o Basics of Supply Chain Management
o Master Planning of Resources
o Detailed Scheduling and Planning
o Execution and Control of Operations
o Familiarity with CMM and Quality Management standards. Good
Understanding of multiple quality management models and methods (CMMi,
PCM, ISO 9000, and TL-9000), metric definition, and statistical
process control.
o Excellent interpersonal skills, ability to interact with people at all
levels with good communication and presentation skills.
o Proficient problem-solver who envisions business and technical
perspectives to develop workable solutions.
o Motivated achiever who guides organizations in applying technology to
business settings, provides added value, and creates project
deliverables in a timely manner.
AREAS OF EXPERTISE
Oracle Application Modules Programming Languages &Software
Applications
Order Management Oracle Forms 4.5/5.0/6i
Oracle Shipping Oracle Reports 2.5/6i
Oracle Inventory Oracle Workflow 2.6
Oracle Purchasing Oracle SQL/PL-SQL
Accounts Receivables Oracle Application Framework
Accounts Payables
Bill of Materials
Core HR
Payroll
Versions : 11.0.3, 11.5.8 to
11.5.10, R12
EDUCATION
Bachelor's Degree in Mechanical Engineering from PSG College of Technology,
Coimbatore.
PROFESSIONAL MEMBERSHIPS
The American Society for Operations Management (APICS)
PROFESSIONAL EXPERIENCE
Motorola Mobile Devices
Oracle Apps Techno-Functional Consultant
From Nov - 2009 till date
Libertyville, Illinois
Description:
Mobile Devices Accessories business (Companion Product) in North America
operates its Retail businesses sharing the ERP and EDI environment with CHS
(Connected Home Solutions) Business Unit.
Due to Separation of Motorola into two business units, all shared
environments will have to be split and migrated to one of MD owned ERP's.
The EDI platform will be migrated to MD (Mobile Devices) standards.
The scope of this project is to split the shared environments and migrate
to MD ERP. It also consists of migrating customers from CHS to MD ERP.
Duties and Responsibilities:
. Documenting business requirements; Data design and process re-
engineering to fit with the
. Oracle system; Prototype new business processes; Design legacy data
conversion; Configure
. Applications; Create test scenarios.
. Development of extraction programs to extract customers and Open AR
Transactions.
. Created staging table to store the customers identified for migration
and created insert script to load the customer information.
. Customization of Sales Order Acknowledgement Report.
. Modification of Order Import program to align to the new EDI 850
format.
. Developed custom programs: (1) a program to send out updated software
versions to entitled customers (utilizes the standard Oracle order API
to create and book orders) (results in a mass shipment of the new
software version to customers) (PL/SQL - 6000+ lines) and (2) a
program to process a flat file containing inventory (INV) and bill of
material (BOM) data into the open interface tables to load these items
(utilizes the standard Oracle API for Importing Inventory, Items,
Inventory Categories, and BOMs) (results in items loaded without users
having to manually enter them into Oracle) (PL/SQL - 3000+ lines).
Environment: Oracle 11i (11.5.10.1) - (Order Management, Purchasing and
Inventory), PL/SQL, Reports 2.5, Toad 8.5
Motorola Mobile Devices
Project Title: Motorola Mobile Devices - Project Separation - Reorg Phase
Oracle Apps Techno-Functional Consultant
From July - 2009 till Oct-2009
Libertyville, Illinois
Description:
The Separation Project is focused on the Re-Org and Spin of the Mobile
Devices business and the reorganization of Motorola into two distinct
entities namely Mobile Devices and BMS (Broadband Mobility Solutions).
Project Separation- Reorg is a global project that will implement the
virtual separation of Motorola BMS and Motorola MD in Oracle ERP and work
stream applications, allowing separate fiscal reports as well as all
official documents to be generated by these applications. The project is
focused on assessing the impact to the external facing documents and make
configuration changes to the ERP system to support the re-organization of
Legal Entities.
Duties and Responsibilities:
. Understanding Business requirements and developing Customer
Requirement and Technical Design Documents.
. Impact Analysis for External facing documents like Purchase Order,
Commercial Invoice, Pack list, Pallet Label due to the reorganization
of legal entities.
. Creation of common function to identify the new and old company names.
. Development of Sales Order Conversion Program to convert internal
sales orders.
. Code Review
. Development of Unit Test Plan and performing Unit Testing.
. Coordination with System Testing team
. Coordination with Customer and Onsite team
. Training & Coaching team members
. Status Reporting and Project Tracking
Environment: Oracle 11.0.3 - Order Entry, Purchasing and Inventory,
PL/SQL, Optio, Toad 8.5
Cisco - HR IT
Project Title: Cisco - HR IT - OHRMS R12 Enhancements
Oracle Apps Techno-Functional Consultant
From Mar - 2009 till June-2009
San Jose, California
Description:
The OHRMS Enhancements project involved enhancements made to the R12 Oracle
HRMS system implemented in Cisco. The enhancements were made to stabilize
the R12 Oracle HRMS system implemented in Nov 2008.
Duties and Responsibilities:
. Understanding Business requirements (MD50) and developing Technical
Design (MD70) document for HR Interfaces.
. Interface Development for Core HR system.
. Enhancements to Stock Vesting Interface.
. Enhancements to LOA Interface (Leave of Absence)
. Development of Bulk Load Responsibilities program to assign
responsibilities to users
. Unit and System Testing
. Assistance for System and User Acceptance Testing
. Training & Coaching team members
. Status Reporting and Project Tracking
. Coordination with Customer and Onsite team
Environment: Oracle R12 Core HR, Payroll, PL/SQL, Toad 8.5
Motorola - Government and Public Safety Business
Project Title: G&PS Global Ship Commit and Integrity Project (Testing)
Oracle Apps Techno-Functional Consultant
From Oct - 2008 till Feb-2009
Schaumburg, Illinois
Description:
The G&PS Global Ship Commit and Integrity Project involved enabling ATP
(Available To Promise) functionality by applying ATP related patches in
GEMS 11i instances for North America and EMEA regions. The goal of this
project is to improve FSSD (First Schedule Ship Date) accuracy and
achieving 92% OTD (On Time Delivery).
Duties and Responsibilities:
. Impact Analysis of the existing customizations due to enablement of
ATP functionality.
. Developing test cases in the areas of Purchasing, Inventory and Bill
Of Material (BOM)
. Unit and System Testing
. Assistance for User Acceptance Testing
. Training & Coaching team members
. Status Reporting and Project Tracking
. Coordination with Customer and Offshore team
Environment: Oracle 11.5.8 Order Management, Advanced Pricing, Shipping
Execution, Purchasing, PL/SQL, Toad 8.5, Oracle 9i
Motorola - 1. Government and Public Safety
2. Home and Networks Mobility
Project Title: Order Management Transformation
Oracle Apps Techno-Functional Consultant
From Mar - 2008 till Sep-2008
Schaumburg, Illinois
Description:
The Order Management Transformation Program of Motorola addresses business
process transformation of Motorola's Order Management (OM) and
implementation of the same in Oracle Applications 11.5.10.2 environment.
Duties and Responsibilities:
. Understanding Business requirements and developing development
requirements for Conversions and Interfaces.
. Business Requirements Study
. Unit and System Testing
. Development of data migration programs to migrate items and
pricelists.
. Data migration from Oracle 11.0.3 systems to Oracle 11i system
. Data migration from Legacy system and Oracle 11i system
. Preparation of Unit Test Plan
. Training & Coaching team members
. Status Reporting and Project Tracking
. Coordination with Customer and Offshore team
Environment: Oracle 11.5.10.2 Inventory, Order Management, Accounts
Receivables, Purchasing, Advanced Pricing, PL/SQL, Toad 8.5, Oracle 10g
Motorola - Networks and Enterprise
Project Title: BSA (Business System Analyst) Resource Pool
Oracle Apps Techno-Functional Consultant and Business System Analyst
From Apr - 2007 till Feb-2008
Schaumburg, Illinois
Description:
The Networks and Enterprise BSA Resource Pool Project involves doing
enhancement projects in Oracle Application used in Networks and Enterprise
Business of Motorola. This project involves collecting customer
requirements and providing business requirements to the Development team.
Duties and Responsibilities:
. Understanding Business requirements and developing development
requirements
. Preparing Technical Design for work requests
. Co-ordination with development team and prepare system test plan
. Modification of Terms and Conditions in Purchase Order Document
. Development of Procedure to update promise date in sales orders.
. Assistance in Customer Acceptance Testing
. Status Reporting and Project Tracking
. Coordination with Customer and Offshore team
. Implementing Lite Projects in Production
. Knowledge Transfer to Production Support Team after implementation of
Lite Projects.
Environment: Oracle 11.5.8 Order Management, Purchasing, Shipping,
PL/SQL, Forms 6i, Toad 8.5, Oracle 9i
Motorola - Mobile Devices
Project Title: Oracle 11.0.3 Global Support
Oracle Apps Techno-Functional Consultant and Production Support Analyst
From Jan - 2005 till Mar - 2007
Libertyville, Illinois
Description:
The MDb(Mobile Devices) Oracle 11.0.3 Global Support involves providing
enterprise wide support to Oracle Application used in Mobile Devices
Business of Motorola. This project involves working on problem and incident
management which mainly focuses on issues related to production. This also
involves working on enhancements and bug fix.
Duties and Responsibilities:
. Understanding Implementation and Consolidation of requirements, and
providing solutions for the issues raised by business Users, which
includes Oracle Applications Setups, suggest workarounds and Solving
Problem Tickets for Purchasing, Planning, and Engineering and Order
Entry modules.
. Provide techno-functional solutions to resolve Business
requirements/issues
. Co-ordinate with team members and business to resolve existing
queries/issues
. Enhancements to the existing reports and packages
. Understanding the User Requirements and resolving the problem and
incident tickets created by the customer
. To create Standard Operating Procedures for all the problem and
incident tickets.
. Root Cause analysis of Problem Tickets
. Participate in Pre and Post activities of Planned and emergency
downtime and disaster recovery
Environment: Oracle 11.0.3 Purchasing, MRP, Engineering, Order Entry,
PL/SQL, Forms 4.5, Reports 2.5, Toad 8.5, Oracle 8i
Motorola - iDEN
Project Title: iDEN Oracle 11i Migration
Oracle Apps Techno-Functional Consultant
From Sep - 2003 till Dec-2004
Chennai, India
Description:
The iDEN Oracle 11i Migration project involves migrating existing 10.7
Manufacturing and Distribution instances to a common Oracle Apps 11i
instance (version 11.5.9). The project involves development of data
migration programs to migrate master data like customers, items, BOM, Item
Categories etc and transaction data like On-hand balances, Open AR
transactions, Open Sales Orders etc. The project also involves migration of
custom interfaces and development of new interfaces.
Duties and Responsibilities:
. Business Requirements Study
. Unit and System Testing
. Development of data migration programs to migrate items, item
categories, BOM, onhand quantity
. Data migration of customers, price lists and purchase orders from
Oracle 10.7 systems to Oracle 11i system
. Building new interfaces
. Preparation of Unit Test Plan
. Report Customization
Environment: Oracle 11.5.9 Purchasing, Order Management, Inventory, Bill
of Material, PL/SQL, Forms 6i, Reports 6i, Toad 8.5, Oracle 9i
Lakshmi Machine Works, India
Project Title: LMW Oracle 11i Implementation
Oracle Apps Techno-Functional Consultant
From Oct-2002 till Aug-2003
Coimbatore, India
Description:
Lakshmi Machine Works (LMW) is a global player and leading manufacturer of
textile machines. The project involved implementation of Oracle
Applications E-Business suite of products (11.5.8).
Duties and Responsibilities:
. Reports development & Customization in the following modules
. Oracle Enterprise Asset Management
. Oracle Work In Process
. Oracle Order Management
. Oracle Inventory
. Registration Of new Forms & new Reports
. Development of Interfaces
. Development & Customization Of Menus & Alerts
. Development of Database objects.
Environment: Oracle 11.5.8 Order Management, Purchasing, Shipping, Work
in Process, Enterprise Asset Management, PL/SQL, Forms 6i, Reports 6i, Toad
8.5, Oracle 9i[pic]
Contact this candidate