Resume

Sign in

Sr. Oracle Application Consultant

Location:
Fullerton, California, 92821, United States
Posted:
May 26, 2010

Contact this candidate

PARAMESWAR BHUYAN

Cell Number: 562 *** **** begin_of_the_skype_highlighting              562 *** ****      end_of_the_skype_highlighting, Phone Number : 714 *** ****| E-Mail: eomkj4@r.postjobfree.com

~ Oracle Application Consultant ~

PROFESSIONAL PROFILE

 Over 10 Years of experience in analysis, design, development and Implementation of complex applications using Oracle Applications 11i (11.5.4, 11.5.5, 11.5.9, 11.5.10) and R12 (12.0.3, 12.0.6).

 A seasoned Techno-Functional Consultant skilled in the Implementation and Customization of OM, Quote, Shipping, Adv. Pricing, INV, BOM,WIP,ECO, Configurator, AR,PO, GL, AP, ASCP modules of Oracle Applications in Multi-Org environment.

 Experience in Production support and System Maintenance.

 Expertise in the areas of Distribution & Manufacturing, Oracle Finance covering wide array of consulting and client management responsibilities.

 Experience in Production support and System Maintenance.

 Experience in multiple full life cycle ERP implementations as Functional and Technical.

 Experience in Project Lead, Solution Architecture using Oracle Application Implementation Methodology (AIM) and SDLC methodology.

 Demonstrated experience of working collaboratively with all levels of project organization to ensure smooth and successful implementation of projects.

Specialties:

 Oracle E-Business Suite (EBS, ERP) R11i, Distributions, Supply Chain (SCM), Order Management (OM/OE), Advance Pricing, Inventory (INV), Bill of Materials (BOM), Work In Process (WIP), Engineering Change Order (ECO), Purchasing (PO), Receivables (AR), Payables (AP), General Ledger (GL).

SKILLS SUMMARY

Oracle Applications

Modules • Order Management (OM/OE)

• Inventory (INV)

• Bills of Material (BOM)

• Work in Process (WIP)

• Engineering Change Order (ECO)

• Purchasing (PO)

• Advanced Pricing

• Configurator

• MRP

• Receivables (AR)

• Payables (AP)

• General Ledger (GL)

• Trading Community Architecture (TCA) • iProcurment

• ASCP

• iStore

• Project Accounting

• Siebel CRM On Demand

• HRMS

• Service Request

• Oracle 11.0.2

• Oracle 11i (11.5.10)

• AME

• AOL

• Sys Admin

Programming Languages & Tools • Oracle SQL & PL/SQL

• Oracle Work Flow

• JDeveloper 10g

• Oracle Forms

• Oracle Reports

• Discover Reports

• BI Publisher • Unix Shell scripting

• Oracle Web EDI

• Java, Advance Java, C++

• Eclipse

• Toad

Database • Oracle 10g, Oracle 9.2.0.5/8i/7.x

Methodologies & Engagement • Application Implementation

• Case Methodology

• Fit/Gap Analysis

• Testing

• End User Training • Configuration

• Functional Setup

• Data Conversion

• Data Migration

• Code Combination Migration

• Team Management

WORK EXPERIENCE

Working as an Oracle Application Specialist in MTSI INC, Brea, CA, USA since April 2010.

Worked as Oracle Application Team Leader in Zensar Technologies Ltd, Pune, India from Sep’05 – April’10

Worked as Technical consultant in Chain-Sys India (P) Ltd, Chennai, India from Feb'05 - Sep’05.

Worked as Software Engineer in Botree Software International Ltd, Chennai, India from Sept'03 - Feb'05.

Worked as Software Engineer in IEC India Pvt Ltd, Chennai, India from Jan'01- Oct'03.

Worked as software faculty in Aptech Computer Education Pvt Ltd, Chennai, India from Aug'1999 - Jan'2000.

ONSITE EXPERIENCE

HACH Company, Loveland, CO, USA as Project Co-ordinator.

Intrado Inc, Longmont, CO, USA for Project KT and Gap Analysis.

EDUCATION

1999 Bachelor of Science from Utkal University, Orissa, India.

2003 Masters in Computer Applications from I.G.N.O.U., India.

PROFESSIONAL COURSES / TRAININGS

Higher Diploma in Software Engineering from Aptech Computer Education Pvt. Ltd, Chennai

Functional set up of SCM (INV, PO, OM, WIP & BOM) from Oracle (NAIO), Bangalore.

E-Business Suite Partner Support Champion Assessment from Oracle University

11i10 Discrete Manufacturing Implementation Champion proficiency Assessments from Oracle University

KEY PROJECTS HANDLED

1. Oracle Applications Support & Enhancement

Client Intrado Inc, USA

Role Senior Techno Functional Project Lead

Software Oracle 10g, D2k 10g, Oracle Applications 10.5.10.2,SQL Developer

Modules ORACLE 11.5.10.2 (INV, PO, OM, BOM, WIP, AP, GL, AR,PROJECT,Install base, Service Contract ,Planning,HR)

Intrado INC : For over a quarter of a century, Intrado has pioneered improvements to the 9-1-1 network and manufacturing of sophisticated networking instruments, helping to enhance the quality of emergency response in the United States. Intrado helps telecommunications service providers and public safety agencies save lives by transforming emergency communications services.

Responsibilities:

Responsibilities include preparation and review of technical and Functional specifications, also was responsible for system integrity testing (SIT) and user acceptance testing (UAT) before final migration of the program. Worked on customization of various Report, Forms and Interface. Provided various types of Functional and Technical support for Post production P1,P2 Issues. Involved in technical and function gap analysis and customization process.

Responsibility and deliverables:

• Understanding the Customer business Process

• Creations/Review of technical and functional design documents using AIM methodology.

• Development/Customization of Shell scripts, Interfaces, Forms, Reports,Workflow and Discover

Report.

• Involved in reviewing technical design and code review for the peers and to ensure that the

quality process is maintained at all stages.

• Responsible for conversions, interfaces and customizations.

• Responsible for system integrity testing (SIT) and user acceptance testing (UAT)

• Involved in the development of stored procedures, Functions and Triggers.

• Handled system administration functions

• Have frequent calls with Client/User and the Functional Consultants.

• Developed/Customized various report using Report 6i , XML Publisher and Discoverer

2. Oracle Applications Hach and Hua Migration

Client HACH Inc, USA

Role Senior Techno Functional Lead

Software Oracle 9i, Forms 6i, Reports 6i, Oracle Applications 11i (11.5.10), TOAD

Modules ORACLE 11.5.10 (INV,PO,OM,BOM,WIP,AP,GL,AR,Oracle Workflow 2.6, XML

Publisher 5.6.2/5.6.3,Oracle Alert

Project Description:

Since 1947, Hach Company has manufactured and distributed analytical instruments, test kits, and reagents for testing the quality of water and aqueous solutions, with products for lab, process, and field. Their products are designed specifically for quality, accuracy and simplicity, and today are in use around the world.

The project involved implementation of RICE objects across 11.5.10 for the modules Manufacturing/Distribution /CRM /Financials by converting data from Hua database. The project also involved generating customer facing documents (Using XML Publisher) and Discover Reports. Project went successfully live in Jan2008 and currently phase is support and enhancement.

Job Profile :

• Migrated Supplier details including Supplier site and ASL

• Moved Bill of Materials, BOM Routing data from Hua database to Hach Database using Interface

programs.

• Coped standard alternate routing to primary alternate routing based on various business

protocols.

• Loaded Oh Hand balance from Hua Database to Hach Database based on various business rules.

• Modified various customized reports for Hua specific organization such as

• Dunning report, Po Reports and many more.

3. Oracle Applications Implementation, Support, Maintenance & Enhancement Projects

Client HACH Inc, USA

Role Techno Functional Consultant

Software Oracle 9i, Forms 6i, Reports 6i, Oracle Applications 11i (11.5.10), TOAD

Modules INV,PO,OM,BOM,WIP,AP,GL,AR,Oracle Workflow 2.6, XML

Publisher 5.6.2/5.6.3,Oracle Alert

Project Description :

Since 1947, Hach Company has manufactured and distributed analytical instruments, test kits, and reagents for testing the quality of water and aqueous solutions, with products for lab, process, and field. Their products are designed specifically for quality, accuracy and simplicity, and today are in use around the world.

The project involved implementation of RICE objects across 11.5.10 for the modules Manufacturing/Distribution /CRM /Financials by converting data from legacy system. The project also involved generating customer facing documents (Using XML Publisher) and Discover Reports. Project went successfully live in Jan2008 and currently phase is support and enhancement.

Job Profile :

• Responsible for Supporting Legacy related objects like Order cross over to Legacy.

• Order Ship confirm from Legacy.

• Responsible for delivery for data conversion, customizations and third party integrations.

• Mapping and Data template columns with legacy system

• Scheduling of multiple Data conversion test rounds

• Solution Design for multi lingual reporting using single report definition

• Solution Design for integration of reports with email/fax tool Rightfax.

• Solution Design for Customer Complaints Feedback System as extension

• Overall Status Reporting, Issue Resolution and handling of escalations and onsite communication

• Planning of go live data conversion activities for each phase

• Code development for Rightfax integration

• Develop on hand Reservation Interface Program for manual reservation based on various business

processes.

• Developed and tuned various Discover Reports query for client use in different module.

4. Project: Oracle Applications 11i (11.5.10) Implementation.

Client HACH Inc, USA

Role Technical Consultant

Software Oracle 9i, Forms 6i, Reports 6i, Oracle Applications 11i (11.5.10), TOAD

Modules Oracle (OM,IN,AR ,Advance Pricing Modules)

Project Description :

HACH COMPANY manufactures and distributes analytical instruments and reagents used to test the quality of water and other aqueous solutions. Ranked among the largest privately held corporations in the United States. Project scope encompasses implementation of Oracle Applications 11.5.10.

Contribution :

As a Technical Consultant, was responsible for:

• Development of Sales Order load to Legacy interface, When Sales Orders made in Oracle Apps, the

order related data will cross to Legacy tables and the shipping process will take place in legacy

system. Using various validation and derivation rules (which are in DB2/AS400). Through

concurrent program. It involved every day client interaction

• Development of Sales Order Shipping Interface, When Sales Orders shipped in Legacy System

(which are in DB2/AS400) the shipped orders will cross back to Oracle, using various shipping API

‘S, through concurrent program. It involved every day client interaction

• Development of Advance price list Interface program to import the price list to Oracle application

• Customization of Quotation Report

• Customization of AP Advance Remittance Workflow.

• Developed Legacy Sales Order error tracking Reports

• Developed Hach Commercial Invoice Report

• Developed Hach Commercial Service Invoice Report

• Developed Hach Purchase Order Report

• Preparing Technical Design Document for customizations

• Development of custom objects, Forms, Reports etc

• Registrations of AOL objects

• Writing Extensions/Conversions programs.

• Writing stored procedures and functions using PL/SQL.

• Performance Tuning of the Code and Testing

• Developed Invoice and Open Order FTP Programs.

• Post production support and enhancements in client side

5. Project : Oracle Applications 11i (11.5.10) Implementation Testing

Client Ventana Medical Systems Inc, USA

Role Techno Functional Consultant

Software Oracle 9i, Forms 6i, Reports 6i, Oracle Applications 11i (11.5.10), TOAD

Modules Oracle Application (Financials, Manufacturing, Distribution & Services )

Project Description :

Ventana Medical Systems is the world's leading supplier and Manufacturer of automated diagnostic systems to the anatomical pathology market. Their customers consist of hospital-based histology labs, independent reference labs, medical research centres, and drug discovery laboratories of the largest Pharmaceutical and biotechnology companies in the world. Project scope encompasses regression testing for Oracle Applications 11.5.9.

Contribution :

As a techno functional consultant, was responsible for:

Modules (Financials, Manufacturing, Distribution & Services) to verify that any changes to Oracle Application due to Go-Live for Oracle HRMS will not affect the existing Oracle Apps system. We completed 914 test scripts and generated result logs within a span of 15 days. Engagement model: Dual Shore engagement

6. Project : Oracle Applications 11i (11.5.10) Implementation Testing

Client GreenLight ,USA

Role Techno Functional Consultant

Software Oracle 9i, Oracle Applications 11i (11.5.10), TOAD

Modules : Oracle Application (AP, PO, GL, FA, AR, OM, INV, BOM, WIP).

Responsibilities :

As a Sr Technical Consultant, involved in the development of Query, Using various modules of Oracle apps(AP,PO,GL,FA,AR,OM,INV,BOM,WIP).

Following AIM mythologies in the project documentations.

• Gain an understanding of all SQL queries and be able to develop the same with minimal Greenlight

core team involvement/support.

• Proactively work with the SQL queries and develop these so that they are compliant with Oracle 11i

releases 11.5.7 through to 11.5.10.

• Tune the queries for optimum performance on the Oracle CBO environment without deploying

custom indexes.

• Own and resolve all work related issues.

• Deliver the developed queried and provide Greenlight with the following:

• SQL query

• Data output

• EXPLAIN PLAN output

7. Project: Oracle Applications 11i (11.5.10) Implementation.

Client Michaels Inc, US

Role Technical Consultant

Software Oracle 9i, Forms 6i, Reports 6i, Oracle Applications 11i (11.5.10), TOAD, Discoverer.

Modules Oracle Financials (GL, AP, PO,)

Project Description:

Michaels are the largest chain of Art and Craft stores in US. Project scope encompasses implementation of Oracle Applications 11.5.10.

Contribution :

As a technical consultant, was responsible for:

• Review of ‘Functional Specifications Document’ prepared by functional consultants.

• Prepared Technical Design Document for customizations.

• Developed interface programs (Invoices/PO)

• Development of custom objects, Forms, Reports etc

• Registrations of AOL objects

• Coded common stored procedures and functions using PL/SQL to be used commonly by other

objects.

• Creation of Promotion Package and Installation scripts.

• Preparation of Release Instructions for the new customizations.

• Performance Tuning of the Code and Testing

8. Project: Oracle Applications 11i (11.5.9) Implementation.

Client Stanford Financial Group Of Companies, USA

Role Technical Consultant

Software Oracle 9i, Oracle Applications 11i (11.5.9), TOAD, Discoverer.

Module Oracle Financials (AP, PO, GL, FA).

Project Description :

The Stanford Financial Group is a privately held, wholly owned global group of financial services companies founded by Lodis B. Stanford in 1932. Stanford’s core businesses are private wealth management and investment banking for institutions and emerging growth companies. Project scope encompasses implementation of Oracle Applications 11.5.10.

Contribution :

As a technical consultant, I was responsible for:

Developed conversion program for these

Conversion: Stanford Finance Group of Companies. General Ledger Conversions

• GL Budget Conversion

• GL Statistic Conversion

• GL Balance Conversion

• Review Functional Specifications to understand the requirements in detail

• Developed Technical Specification for these objects.

• Writing stored procedures and functions using PL/SQL

• Preparation of Technical Design Documents.

• Creation of Promotion Package and Installation scripts

• Testing

9. STOCKY (Supply Chain Management)

Client Procter & Gamble (P&G) India Pvt. Ltd.

Role Analyst and Developer

Software Oracle 8I, Dev6i(Form 6I, Reports 6I)

Module SCM

Project Description :

Supply chain management solutions help in the efficient integration of the entire length of the supply chain comprising of suppliers, warehouses, stockiest and stores so that any merchandise that is produced and distributed is done so in the right quantities to the right locations at the right time in damage-free conditions, thereby minimizing total cost of a company, subject to satisfying service requirements.

Contribution :

As a team member, was responsible for:

• Design and Development

• Developing Forms and Reports

• Developing Stored Procedures

• Testing – Unit testing

10. ELIXIR (Spine of Health Care)

Client Kaya Skin Care, Marico India.

Role Analyst and Developer

Software Oracle 8i, Developer 2000

Module Health care and Hospital Management

Contribution :

As a team member, was responsible for:

• Design and Development

• Developing Forms and Reports

• Developing Stored Procedures

• Testing – Unit testing

PERSONAL DETAILS

Date of Birth : 25th March, 1978

Contact Address : 145 S. State College Blvd Suite #180 Brea CA 92821

Phone Number : 714 *** ****



Contact this candidate