Post Job Free

Resume

Sign in

Oracle Management

Location:
Bethesda, MD
Posted:
June 02, 2015

Contact this candidate

Resume:

[pic]

Raghav Seth

acp0b1@r.postjobfree.com, 732-***-****

** ******** **, ******, ** 08820

I am a U.S. citizen and I am a professional in Oracle Applications R12

(12.1.3)/11i ERP systems. Have been in the IT industry for more than twenty

six years and have worked with various industries/systems, in the areas of

systems analysis, design, development, and implementation of computer

applications. Skilled in all Technical & Functional aspects of Oracle

Applications R12/11i. Experience includes multiple full Oracle ERP SDLC

deployments for Oracle Applications R12/11i, and as an Oracle Apps System

Admin. As a technical team lead, managed projects and a team of developers

both on-site and offshore.

My expertise includes:

. Accounts Payable, Accounts Receivables, General Ledger, Customer

(TCA), Inventory, Purchasing, Order Management, Oracle Projects and

Grants modules.

. RICEW developer with extensive experience in the design, development

and customization of Oracle Workflows, CUSTOM.PLL, Flexfields,

Concurrent Programs, Oracle Reports, Interfaces using APIs, BI

Publisher, Conversions and Extensions.

. Oracle PL/SQL, Oracle Workflow builder, Oracle Forms 9i, Oracle

Reports 9i, BI Publisher.

. Developing documents for technical design, functional design and

testing scripts following AIM methodology.

. Creating Users, Responsibilities, Processes, User Profiles.

Administration of Concurrent Process/Manager, Request Group/Set,

Workflows, Printers etc.

. Defining user requirements, business data analysis. Develop and

deliver end-user training.

. Project management activities including develop and manage project

plan, manage tasks, activities and project team.

. As technical team lead, managing the developers, monitoring and

controlling the development activity and the completion of the

deliverables in a timely manner.

Clients:

. Office of Chief Financial Officer (DC Government), Apollo Group Edu.,

SunGard Availability Services, United States Secret Services, Oracle

Corp., US Marine Corps, SUN Microsystems, Symantec Corp, Pfizer

pharmaceutical, Scholastic Inc, Associated Press, and Birla Horizons

International.

Skills Summary

Oracle Applications R12 (12.1.3)/11i:

. General Ledger

. Accounts Receivable

. Accounts Payable

. Order Management

. Purchasing

. Customer (TCA)

. Inventory

. Supplier

. Oracle Projects and Grants

.

Engagement Experience:

. Oracle Applications R12/11i Technical Lead/Developer

. Upgrade from Oracle Financial 11i to R12

. Designed and Developed Oracle Applications AIM Documents

(Functional and Technical)

. Developed Technical, Unit Testing, Test Scripts Documents (MD.070,

TE.020, TE.040)

. Integration Test Lead

. Change Management Lead and Version Control Lead

. End User Training

. Post Production Support

Custom developed applications, using Oracle Client-Server technology:

. Inventory

. Purchase Order

. Sales Order

. Supply Chain

. Production Planning & Control

. Bill of Materials

. Workshop Payroll

. Manufacturing Receipt & Issue

. Accounting system

. CRM

. Banking/Financial

. Examination Processing system

.

GUI Experience:

. Oracle Workflow Builder

. Oracle Forms Builder 3.0/4.5/6i/9i

. Oracle Reports Builder 4.5/6i/9i

. Forms Personalization

SAP R/3 System:

. Time Management

. Payroll

Databases:

. Oracle 5.0/6.0/7.x/8i/9i/10g/11g

. IDMS

Hardware & Operating Systems:

. SUN Solaris

. UNISYS 6000

. HP 9000

. ICIM 6000 series

. IBM 370 VM

. DEC/Alpha

. UNIX

. LINUX

. HP-UX

. OSVS1

. VAX/VMS

Programming Languages:

. SQL

. PL/SQL

. Pro*COBOL / COBOL

. JCL (Mainframe)

. ABAP/4

. UNIX Shell

Tools:

. jDeveloper

. BPEL/SOA Suite

. PVCS/SVN

. HP Deployment Manager

. SQL*Loader

. Discoverer /BI Publisher

Professional Experience

SRA International, VA (June 2014

to present)

Oracle Applications upgrade from 11i (11.5.10) to R12(12.2.3).

. Conversion of various modules (General Ledger, Receivables, Payables,

Inventory, Purchasing) from 11i to R12 version.

. Oracle code remediation of database Packages, Procedures, Oracle

Applications upgrade from 11i (11.5.10) to R12(12.1.1).

. R12 Code version control and code deployment lead

CRGT Inc., VA

(March 2014 to May 2014)

Oracle Database Support for Navigation software systems for the USPS client

. Developed database procedures and packages for the support of maps and

navigation

Deloitte Consulting LLP, VA :

(Jun. 2012 to March 2014)

FDA (UFMS Project): O&M Support of Oracle Applications

. Fixing issues/codes in modules General Ledger, Payables, Receivables

PBGC: Oracle Applications upgrade from 11i to R12.

. Conversion of various modules (General Ledger, Receivables) from 11i

to R12 version.

. Oracle code remediation of database Packages, Procedures, Oracle

Applications upgrade from 11i (11.5.10) to R12(12.1.1).

. Implementation of General Ledger, Receivables.

GXS, MD :

(May 2012 to June 2012)

Oracle Applications upgrade from 11i (11.5.10) to R12(12.1.1).

. Post Production support for Accounts Receivables, General Ledger,

Accounts Payables.

. Oracle Applications upgrade from 11i (11.5.10) to R12(12.1.1).

CIBER Inc, CO :

(Dec. 2010 to Apr.2012)

Oracle Applications R12 Implementation

While employed with CIBER Inc., I am currently working with the

following client:

Office of Chief Financial Officer (DC Government): Oracle Applications R12

Implementation

(Dec. 2010 to Apr. 2012)

. Managing a team of technical developers

. Updating the project plan and managing the tasks as per the project

plan

. Responsible for the implementation of the following modules: Payables,

Receivables, General Ledger, Purchasing, Oracle Projects.

. Conversion of data from the external systems to the Oracle EBS.

. Developing interfaces between the Oracle EBS and the external systems

. Requirements gathering and communication between all team members and

client

. Design the system and develop system architecture

. Design and develop the technical design document and the code for:

o Payables: Suppliers conversion, inbound and outbound interfaces,

Data conversion of Invoices

o Receivables: Customer conversion

o Oracle Projects: Projects, Tasks, Budget, Funds, Awards

conversion

o Purchasing: Requisitions and Purchase Orders conversion

o Customization of the Account Generator workflow for AP Invoices,

Purchase Orders and Requisitions

o General Ledger: GL Journal Interface (Import Journals)

Apollo Group Inc, AZ :

(Sep. 2010 to Nov. 2010)

Oracle Applications upgrade from 11i (11.5.10) to R12(12.1.1).

. Modified objects (PL/SQL procedures) for Accounts Receivables, General

Ledger, Accounts Payables, in order to upgrade from Oracle Financial

11i to R12.

SunGard Availbility Services, PA :

(May. 2010 to Sep. 2010)

Oracle Applications R12 customization. As technical lead managed a team of

developers and the following activities/tasks:

. Accounts Receivables:

o Designed, developed and implemented the customized solution for

the calculation of the Invoice tax for the invoices being

generated for US, Canada and UK, in a Multi Org environment.

Customized the AR Statement report in Discoverer.

o Designed and developed procedure for the update of customers and

sales reps to the collectors.

. General Ledger:

o Design and development of reports in Discoverer for the printing

of transactions belonging to different transaction types in a

given period for a particular org.

. Purchase Order Requisition:

o Customized PO Requisitions workflow in order to generate default

accounts and generate expense charge account.

o Customized CUSTOM.pll for the PO Requisition form.

Global Computer Enterprises, VA :

(Sep. 2009 to Mar 2010)

Oracle Applications upgrade from 11i (11.5.10) to R12(12.1.1). Oracle

Applications R12 Implementation

While working with GCE, I worked for the following client:

US Secret Services : Oracle Financials R12 implementation

(Sep. 2009 to Mar 2010)

. Accounts Payable. Conversion of data from the legacy applications to

the Oracle Financials database. Interface between Compusearch PRISM

and Sunflower Assets module with the GL module.Developed the technical

design and code for the interface data in AP modules.

. Performed the impact analysis of doing the upgrade from version 11i to

R12.

. Upgraded the modules AP and GL from Oracle Financial 11i to Oracle

Financial R12 version

. Created EUL for Discoverer Admin. Developed reports in Discoverer and

BI Publisher.

Oracle Corporation, CA :

(Aug. 2006 to Jun. 2009)

Oracle Applications 11i Implementation

While employed with Oracle Corporation, I have worked with the

following clients:

US Marine Corps : Oracle Financials 11i implementation

(Dec. 2007 to Jun. 2009)

As technical lead managed a team of developers and the following

activities/tasks:

. Development of the technical design document and the code for:

o Purchasing: PO Requisition Interface and PO Receipts Interface.

Purchase Order USSGL transaction code generator

o Purchasing: Uni-directional and bi-directional data

synchronization of the PO interface data from one database

instance to the other database instance.

o Developed test scripts for integration testing.

o Inventory: Item Interface (Item import), Inventory On-hand

quantity Interface, Inventory Miscellaneous Receipt/Issue

inbound interface. Data synchronization of Item Subinventory.

o General Ledger: GL Journal Interface (Import Journals). .

Developed the technical design document for the extension: Funds

availability check at the unit level.

o Suppliers: Data conversion of Suppliers, Supplier Sites and

Supplier Contacts.

o TCA: Customer conversion. Data synchronization of TCA Person

Party.

o Accounts Payable: Data conversion of Invoices.

. Change Management & Version Control Lead. Got the recognition for the

successful migrations in a timely manner. Designed and developed the

system for the migration of all development objects to various

database instances. Used HP Deployment Manager tool for the migration

activities. Managed the version control of various development

objects. Used the PVCS version control software tool, for this

purpose.

. For data synchronization across the different database instances, used

the BPEL/SOA suite and XML Gateway technology.

. Developed and customized Oracle Workflows, using Business Event System

(BES) technology. The Workflow raises the Business Events. Developed

custom workflows, business events, subscriptions, PL/SQL code.

. Worked in close co-ordination with the Functional team and the Testing

team for the successful completion of the integration testing phase.

. Developed infrastructure and plan related with the testing, migration

and the conversion schedules, so as to conform to the overall project

plan.

SUN Microsystems, CA: Oracle Financials 11i implementation

(Apr. 07 to Dec. 07)

. General Ledger module and the Accounts Receivables module: Provided

solution/support to the various problems/issues related with the

implementation phase.

. As a technical lead managed the development efforts with the

development team in India

. Got recognition of work for resolving various issues in a timely

manner.

Symantec Corp., CA: Oracle Financials 11i - Oracle Workflow support

(Apr. 07)

. Workflow administration and tuning: Provided solution to the various

problems/issues related with the extended Workflows.

. Provided guidelines for the improvement in the performance of the

Workflow and the Workflow Purge process.

Pfizer Pharmaceuticals, Dublin, Ireland: Oracle Financials 11i

implementation (Aug. 06 to Apr. 07)

. Accounts Receivables Open Items conversion. Created the Technical

Design document.

. Developed Data Conversion procedures (PL/SQL code).

. AR Open Items Conversion, Customer conversion, Open PO, PO Receipts,

and Inventory items conversions.

. Developed Test scripts and did the testing of the data conversion

activities.

Scholastic Inc., Secaucus, NJ:

(Jun. 05 to May 06)

Oracle Financials 11i implementation

. As a technical lead, managed the development activities in-house,

Chicago and in India.

. Accounts Receivables: Auto Invoice Interface, Customer Conversion

(TCA). Customized AR Statement report, Aging report.

. Order Management: Customized Workflow for the Sales Order Entry.

. Forms Customization: Customized CUSTOM.pll library module.

. Developed technical designs of various objects like Workflows,

Packages, PL/SQL Procedures/Functions, Concurrent Processes,

CUSTOM.pll and Reports

. Designed Security mechanism: User Profiles, Responsibilities and

Access rights. Managed and monitored the migration of the customized

objects to the Test environment, QA environment and the Production

environment. Administration of Concurrent Processing, Request

Group/Set, Workflows, Printers, register of new objects in Oracle

Apps, etc.

Associated Press, NY :

(Dec. 97 to Jun.

05)

Oracle Financials 11i implementation (in the year 2004)

. Performed in the role as technical lead and an operational Oracle Apps

DBA.

. Worked on the implementation of the following modules: Accounts

Receivables, Accounts Payables, General Ledger.

. Worked on the customization of Reports.

. Developed data conversion procedures.

. Managed security and authorizations.

Billing Systems, Financial Accounting Systems:

. Involved in the requirement gathering, design, development and

implementation of Billing

systems and Financial Accounting systems, using Oracle client-server

technology.

. Developed the system using Oracle Forms 6i and Oracle Reports 6i.

. Developed various database triggers and packages, procedures and

functions using PL/SQL.

. Involved in the implementation of the systems and imparting the user

training.

. Managed various Oracle processes, objects, user privileges, security

and authorizations.

SAP R/3 System Implementation/Time Management & Payroll:

. Configured the Time Management module and the Payroll module of SAP

R/3 system.

. Developed various Personnel Calculation Rules, related to the

calculation of different types of overtime and holiday worked.

. Developed Sub-Schema and Schema in the Time management module in the

SAP R/3 system.

. Developed various interfaces, in order to transfer the employee data,

time data, and payroll data to the SAP R/3 system.

. Developed various reports using ABAP/4 programming language in the SAP

R/3 system.

. Worked on all aspects of ABAP/4, like Reports, Schema modification,

Transactions, ALV, Logical databases, Function module, Includes and

Performs.

Birla-Horizons International Ltd. (Dec.

96 to Dec. 97)

. Designed and developed the Member Revenue Share system. Conceived the

system of collecting the International Sales data. The system

increased the sales of Member photos to the International level.

. Developed procedures/triggers for the periodic checking of the

consistency of financial data. In case of any inconsistency, it

automatically takes some corrective action and generates a report.

Mapped user specifications and source data elements to logical data

models.

. Managed and coordinated the process of conversion of applications in

Oracle Forms 4.5 and Oracle Reports 2.5 to Forms Builder 6i and

Reports Builder 6i.

. Managed the process of conversion of applications Y2K compliant.

Tata Unisys Ltd., Delhi, India

(Jul. 93 to Dec.

96)

. Custom developed modules: Accounts Receivables, Accounts Payables,

General Ledger, Sales Order, Inventory, Purchase Order, Supply Chain,

Production Planning & Control, Bill of Materials, Workshop Payroll,

Manufacturing Receipt and Issue Accountal system, Rolling Stock

maintenance, Plant Maintenance system, CRM, Banking/Financial system

and Examination processing system.

. Extensively used Oracle Forms 4.5/6i, Oracle Reports 4.5/6i, PL/SQL,

Pro*COBOL, SQL*Loader to develop the custom develop system/modules.

. Designed the system using Turbo Analyst CASE tools, ER diagrams,

logical and physical database design.

. Conducted various corporate level trainings for the clients.

HCL HP Ltd, Delhi, India

(Jul. 88 to

Jul.93)

Oracle Client Server technology, Custom developed system/modules

. Conceived the idea of generation of the slips (schedule) for an

extended period of time. This helped the system in getting the regular

and consistent supply of sugar cane, in the form of raw material to be

used in the Sugar Cane processing plant. It also helped in maintaining

the consistency at the various levels of production.

. Designed and developed the Examination data processing system and the

printing of the examination mark-sheets, certificates and the

compilation of the examination results.

. Designed and developed the Production Planning & Control (PPC) module

to generate automatic production planning schedule for the different

workshops of the factory based upon the sales order, inventory of raw

material and the stock.

. Set the ground rules and designed procedures for the easy migration of

data from the legacy system.

. Conducted several customized training courses in Oracle technology,

for senior executives of various organizations, after studying their

requirements, background and objectives.

. Database Administration: For the custom develops application,

designed, developed and created the database and the database objects.

Education:

. Indira Gandhi National Open University, Delhi, India.

Master of Business Administration (Operations Research)

. Rajasthan University, India.

Master of Arts (Economics)

. Delhi University, Delhi, India.

Bachelor of Science

Training:

. JAVA programming

. Oracle SOA Suite 10g: Services Orchestration

. Oracle 11i/2.6: Implement Oracle Workflow Ed. 3

. Oracle Release 11i Financial Applications

. Oracle Developer 2000

Certification:

. Oracle Database SQL Expert (10g)

. Oracle L1 Project Management Certification (Oracle Corp.)

Awards and Recognition:

. Got award for the recognition of work from SUN Microsystems, CA.

. Got the recognition of work as a Change Management and Version Control

Lead, on the project with US Marine Corps



Contact this candidate