Sujila V

* *******

. Over * Years of IT experience with 7+ years of experience in Oracle

Application implementation, enhancements, customizations, migration,

interfacing and conversions.

. Extensively experienced in the technical and functional aspects of

Oracle Applications R12/11i/10.7, in Financials (GL, AP, AR, PO) and

Supply Chain Management (OM, INV) and Fixed Assets.

. Successfully completed Full life cycles projects with Oracle

Applications 11i (11.5.8, 11.5.6 and 11.5.4) and implementations in

11.5.10, R12.

. Expertise in developing packages, procedures, functions, database

triggers, interfaces and data Conversion using PL/ SQL, SQL * Plus,

TOAD and SQL* Loader.

. Expertise in full suite of Oracle Tools including SQL*Loader, TOAD,

SQL*Plus, Reports 2.5/6i, Forms 4.5/6i, Discoverer3i/4i/9i/10g,

Discoverer Plus 10g and Developer 2000/6i/9i.

. Experience in development and customization of Oracle Reports

(2.5/6i/9i) and Oracle Forms (4.5/6i).

. Proficient in Procure to Pay (P2P), Order to Cash (O2C) cycles.

. Good understanding of data flow in the different modules of Oracle

Applications.

. Proficient in understanding the concepts and hierarchical structure of

Multi Org. Good knowledge of TCA Architecture.

. Good understanding and knowledge of the Apps data model, which helps

in all aspects of development cycle such as building Custom Reports,

data validation, data import etc.

. Involved in Implementation, customization of several Oracle Financial

and Supply chain Applications, Data mapping of Oracle functionality

with Business requirements, historical conversions, interfaces and

customizations.

. Aptitude to swiftly troubleshoot and resolve various Oracle

Applications issues which arise during the Project and the ability

to work in a dynamic, team-oriented environment.

. Excellent Team Player with good problem solving approach having strong

communication, leadership skills and ability to work in a time-

constrained and team-oriented environment.

SKILLS

ERP : Oracle applications R12/11i Financials and SCM modules (AP, AR, GL,

OM, PO, FA and inventory)

Databases: Oracle 8i /9i/10g, MS SQL Server 2000, MySQL

Tools: Toad, SQL Navigator, SQL*Plus, SQL*Loader, Reports 6i,

Discoverer 4i, Oracle workflow, Bi Publisher

Operating Systems : UNIX and WINDOWS XP, NT, 2000

Others: AIM 3.0, SVN

2 EXPERIENCE

Stryker Orthopedics, Mahwah, NJ Jan

14- Present

Role: Techno-functional Consultant

Responsibilities:

. As a part of UDI requirement, Designed, developed and documented

retrofit of RICEW objects.

. Responsible for migration of the entire RICEW objects to production.

. Created MD50, MD70 documents using AIM

. Involved in UAT and cut over plan.

. Developed custom PLSQL outbound APIs to Oracle to send the GTIN data

to other systems like BOSS (system for WMS), GENCO etc.

. Developed several custom procedures for changes in job randomization,

customized the logic for RA Hold notification report, change

interfaces to send extra fields (HTS and Schedule B codes) to the ware

house management system etc. as per the business requirements

. Responsible for creation of new responsibility and users.

. Modified reports in Reports 6i to customize existing AR invoice

reports

. Involved in all phases of the implementation and post-production

support for all the changes involved as a part of UDI project

. Key in Preparing the Functional Specification Documents (FSD),

Business Requirement Documents (BRD) and Functional Testing Documents

. Worked with client customer service vendors to integrate the GS1

barcode feature without affecting existing HIBC barcode.

. Assisted business users and vendors to understand the GS1 barcode

label convention and make sure the data propagates through the Stryker

system to different customer service vendors

. Involved in post-production support in Inventory and OM to the client

. Proposed and implemented validations on the front end data input

through form personalization

. Quick and precise solutions developed for several service improvements

which also includes tracking of the change control

Environment: Oracle Applications R12.1.3, Oracle 10G, OM, AR, INV, report

manager, PL/SQL, Alerts, Workflow 2.5, Reports 6i/10G, Forms, UNIX, TOAD,

Discover

Regal Beloit, Grafton, WI Feb 13-

Dec 13

Role: Techno-functional Consultant

Responsibilities:

. Designed, developed and documented new and retrofit of RICEW objects.

. Updated the existing rice object for r12 upgrade changes.

. Responsible for migration of the entire RICEW object to production.

. Worked on report manager for changes to FSG report.

. Involved in all phases of the upgradation of Oracle Apps from

11.5.10 to R12 (12.1.3). Analyzed, Modified, Redesigned the

Customizations for the R12 environment.

. Worked as a mentor for in-house development team for R12

upgradation.

. Used Data Templates, Bursting features in BI Publisher to

generate Custom reports like Dealer Statements, Commercial

Invoice, and Dealer ACH Payments Reports in R12.

. Modified the custom forms, reports, pl/sql programs for changes

in Bank, Vendor, Payables, and Payments modules tables.

. Designed and Developed a Custom inbound interface to load Parts

information for Claims Service.

. Developed custom forms to have a facility to Query, Modify and

Create the Parts for the Claims Service.

. Involved in the Analysis and Design of the Re-org Structure

Project.

. Worked on modifying the Custom PL/SQL, Forms and Reports for the

Re-org Project.

. Developed custom Sales Order form with query only facility in

the OM Module using the forms6i.

. Developed forms for dealer hierarchy and makes the form

accessible from Sales Orders and Invoice forms through Forms

Personalization.

. Developed Custom 1099 Reports using the Oracle Reports6i and XML

Publisher in AP

. Developed Custom AP Invoices Import to create Invoices for

Dealer commissions in AP

. Developed custom PLSQL APIs to get the Incentive information for

external web applications.

. Implemented parallel process in Billing and other critical

programs to cut short the nightly batch jobs window.

. Coordination with Oracle on SR's.

Environment: Oracle Applications R12, Oracle 10G, GL, AP, AR, FA, PO,

report manager, PL/SQL, Alerts, Workflow 2.5, Reports 6i/10G, Forms,

SQL*Loader, UNIX, TOAD, Discover, JDeveloper, HP PPM (Kintana). IBM AIX

Power systems

HHGREGG, Indianapolis Mar 12-

Jan-13

Role: Technical Consultant

Responsibilities:

. Designed, developed and documented an inbound interface for AR

Invoices.

. Involved in production support.

. Developed PL/SQL Programs for Custom QA Check validation in the

Contracts Module.

. Developed Wrapper Program on top of Pricing APIs to get the list

price for an Item.

. Customized the existing interface program from Contract to OM,

to add the Adjustments for sales order lines as per the Modifier

and Qualifier Setup in Pricing Module.

. Defined the Custom Rule Groups and Rules in the Contracts

Module.

. Created a Custom Report using the PL/SQL and XML Publisher for

Profitability of the Contract.

. Developed Interface Program from Contracts to OM. Used OM

Adjustments tables to create adjustments based on the Modifiers

that Setup in the Pricing Module.

. Performed the Setups and Created a Custom Form to capture the

Credit Card details of the customer on the Contract.

. Involved in the Setup of Expenses Payment Process in AP Module.

. Worked on Performance improvement of Custom PL/SQL Code, Forms

and Reports.

. Developed Conversion Programs to Import pricing information from

the legacy systems for Contracts extension modules.

. Used Oracle Form Personalization for some Form Customizations.

. Used CUSTOM.pll for validations and zoom functionality.

. Developed Workflow for Approval of Adjustment in Receivables

Module based on Position Hierarchy and their approval levels.

. Developed Technical Design Documents for the Form, Report

Customizations using the Oracle AIM Methodology.

. Worked with the Oracle Support Team for TAR/Service Requests for

some issues on the Install Base and Service Contracts.

. Worked with the Business users for gathering the Business

Requirements gathering, Analysis, Functional Test and UAT

stages.

Canon USA, Jamesburg, NJ JUL 11-

Jan-12

Role: Technical Consultant

Responsibilities:

. Designed, developed and documented an inbound interface for AR

Invoices.

. Involved in maintenance of sales representatives in CRM by end dating

the old roles with new and also update the territory.

. Involved in custom consolidated billing process.

. Implementation involves data from different sources to flow to Oracle

Applications through a series of custom and standard programs to

create Order, purchasing and Receivables data and complete the entire

Order to Cash and Procure to pay cycle.

. Designed and developed an inbound interface for bringing the prospects

and account shares from salesforce.com to Oracle.

. Worked on CUSTOM.PLL to default customer specific Price List on the

Sales Order form.

. Worked on Production ticket issues based on priority and provided

regular updates to clients until resolution.

. Developed the OM custom reports in XML Publisher.

. Coordination with Oracle on SR's.

Environment: Oracle Applications 11i/R12, Oracle 10G, GL, AP, AR, FA, PO,

CRM, i-payment, PL/SQL, Alerts, Workflow 2.5, Reports 6i/10G, Forms,

SQL*Loader, UNIX, TOAD, Discover, PVCS, HP PPM (Kintana).

Pampered Chef, Addison, IL DEC 10 - JUN 11

Role: Technical Consultant

Responsibilities:

. Involved in maintenance and production support of interface and

reports.

. Modified/customized AP Invoice workflow using custom hook to meet the

business requirements.

. Designed, developed and documented an inbound interface for AR

Invoices.

. Personalized form AP invoice screen and fnd concurrent request screens

to disable, validate and submit programs.

. Developed program for loading credit card transaction for Mastercard

into I-Expense tables.

. Developed custom reports like invoice prepayment report, undistributed

liability report/extract, uninvoice receipts report to meet the

business requirements using XML Publisher (BI Publisher).

. Developed custom interface and reconciliation report between oracle

and Maximo, used for importing and reconciling purchase orders and

receipts.

. Used CRON Jobs to submit the Concurrent programs and custom Interfaces

as applicable

. Worked with Sabrix team to develop interface for implementing business

requirement for Tax.

. Interacted with the end user during production support by helping them

to develop user required reports and modify the existing as per the

requirement.

. Performance tuning of the PL/SQL objects and report using DB links to

interact with Maximo and other system. During this process I have used

trace, TkProf and Explain plans for optimization.

. Experience using advanced Oracle features like Blob's and XML's.

. Worked on Importing Asset Information into Oracle Assets Using Mass

Additions in Fixed Assets (FA).

. Developed custom alert to send notification on close/open periods,

payments.

. Worked actively to trouble shoot problem and resolve production

issues.

. Involved in R12 upgrade analysis discussions.

. Involved in writing interface for R12 Invoice Interface using XML data

source from third party application.

. Used AOL and System Administrator modules for registering the

developed and customized reports and programs.

. Used HP PPM (Kintana) to migrate PL/SQL packages, AOL objects and

concurrent program to different instances.

. On site offshore co-ordination and knowledge transfer to team.

Environment: Oracle Applications11i (11.5.10.2)/R12, Oracle 10G, GL, AP,

AR, FA, PO, I-Expense, PL/SQL, Alerts, Workflow 2.5, Reports 6i/10G, Forms,

SQL*Loader, UNIX, TOAD

Network Hardware Resale, Santa Barbara, CA May 10

- Nov 10

Role: Techno-Functional Consultant

Responsibilities:

. Involved in development and implementation of positive pay extract for

Bank of west.

. Designed, documented and developed interface between Bank of West and

Cash Management (CM) module for uploading Bank statements.

. Implemented check printing template for Bank of west.

. Written a pl/sql packages using HZ API's for updating and creating the

records into the base tables from the data coming from the staging

tables.

. Developed PL/SQL Package for Customer interface in Accounts

Receivables for generating Electronic Invoice text files.

. Involved in maintenance and Creation of the custom reports and forms.

. Extensively worked on Auto Invoice and Auto Lock Box process and

troubleshooting the process on production environment.

. Involved in development of interfaces for creating and updating Price

lists and modifiers.

. Worked on Customer Data Hub.

. Developed Customizations of workflows.

. Developed Registration Scripts for Moving Objects from one environment

to another.

. Designing of Payment file Structure for various countries.

Environment: Oracle Applications R12, GL, AP, AR, PO, OM, CM, Advanced

Pricing, Install Base, Service Contracts, PL/SQL, Workflow 2.5, Reports 6i,

SQL*Loader, UNIX, TOAD, Discoverer, Developer 10G, I-Expense, I-

procurement, I-suppliers, SVN

DANA CORPORATION, MAUMEE, OH Jan-10 - May-10

Sr Technical Consultant

This project includes implementation and customizing the Oracle

applications (R12) including the interface programs, reports and forms

personalization as per the user and business requirements.

. Conducted study on current system, requirements gathering, requirement

analysis and documentation.

. Responsible for preparing Functional design documents and taking

approval from client.

. Developed PL/SQL Package for Customer interface in Accounts

Receivables for generating Electronic Invoice text files.

. Developed a pl/sql package using the UTL_FILE utility to write the

data into the flat file on the specified oracle ftp directory.

. Created Item Invoice Price comparison XML Publisher report that

generates the report for all facilities at a time.

. Registered customized Oracle reports and XML Publisher reports using

System Administrator and Application Developer.

. Responsible for providing support for the production application,

interacting directly with the end-users, super users, and functional

resources

. Involved in code enhancements for AP and FA Components by adding MOAC

Security profile.

. Coordinate with functional resources and offshore team to complete

deliverables.

. Extensively worked on Auto Invoice and Auto Lock Box process and

troubleshooting the process on production environment.

. Responsible for providing the support and maintain the EDI outbound

(810/invoice, 856/Advance shipping notifications) and inbound

(850/Customer purchase orders) process.

. Work with DBA to migrate new objects in to production environment, Bug

fix and applying Patches.

. Worked on Production ticket issues based on priority and provided

regular updates to clients until resolution.

Environment: Oracle Applications R12, Oracle10g, PL/SQL Developer, XML

Publisher, Discoverer, TOAD, Data Loader, SQL*Plus, Reports 6i, Forms 6i,

Workflow Builder

AGI Shorewood, Indianapolis, IN Jun 08 - Jan 10

Role: Techno-Functional Consultant

Responsibilities:

. Involved in discussions of design, development & implementation of

Oracle Application modules GL, AP and I-Expense.

. Designed Documents for Conversions and Reports (AIM equivalent for

IBM).

. Developed Custom oracle PL/SQL packages to prepare and validate the

AP, Supply chain data from different legacy system and imported the

data to oracle.

. Developed extract program of the GL segment to be used by the legacy

system to meet the business requirements.

. Interface for importing the GL segments from AVM legacy system.

. Devloped an API for Converting the Invoice Payments (AP) and was able

to convert all the Historical Invoice Payment History into Production

. Developed program for Supplier import using AP_PO_VENDORS_APIS_PKG

API.

. Developed custom program for linking Supplier to bank.

. Developed Shell scripts for transferring file from one location to

other server.

. Worked on the data conversion of standard PO's into Oracle Purchasing

using Purchasing Document Open Interface.

. Developed custom reports like invoice payment report, foreign supplier

report to meet the business requirements using XML Publisher (BI

Publisher).

. Developed custom program to load and define the segment hierarchy's in

the data repository used reporting.

. Used CRON jobs to submit the Concurrent programs and custom

Interfaces.

. Worked on string testing the custom oracle application program to

check for correctness of the program.

. Worked on the developing custom forms using TEMPLATE.fmb in Forms6i.

. Worked actively to trouble shoot defects and problem during the string

and user acceptance testing and resolve production issues.

. Interacted with the end user during production support by helping them

to develop user required reports and modify the existing as per the

requirement.

. Used AOL and System Administrator modules for registering the

developed and customized reports and programs.

Environment: Oracle Applications11i (11.5.10.2), GL, AP, I-Expense, PL/SQL,

Workflow 2.5, Forms 6i, Reports 6i/10G, UNIX, TOAD

County of Henrico, Richmond, VA Nov 07 - May-08

Role: Technical Consultant

Responsibilities:

. Organized meetings with the client to gather requirements.

. Involved in studying the existing systems/reports by conducting

meeting with the concerned user and developed report specifications.

. Designed both Functional and Technical Documents for Conversions and

Reports.

. Designed, documented Technical Specification (MD070), Conversion

Mapping (CV040) documents and developed conversion routines, Created

Staging tables, and custom PL/SQL API's to convert

. Developed Custom Reports displaying compensation, payroll costing,

filled and vacant reports, Freeze report as per the business

functionality and requirements using Reports 6i and Discoverer

10G/Plus.

. Developed Customized fast formula to suite the business requirements.

. Migrated job structure and details from legacy system by writing a

conversion program using the HR_JOB_API.

. Migrated positions from the legacy system using HR_POSITION_API API.

. Customized seeded workflow such as Leave approval workflow, time card

approval workflow to suite the business requirement.

. Worked with Administration and User Edition of Oracle Discoverer. In

Administration Edition, created various business areas, user views,

custom folders and joins for reporting. In user edition. Developed

various crucial filled and vacancy reports.

. Involved in tuning the reports using automated summary management in

Discoverer.

. Interacted with the end user during production support by helping them

to develop user required reports and modify the existing as per the

requirement.

. Used AOL and System Administrator modules for registering the

developed and customized reports.

. Used FND Load to migrate concurrent program to different instances.

. Worked with Administration and Desktop Edition of Oracle Discoverer

10G/4I.

Environment: Oracle Applications11i (11.5.10), HR, Payroll, PL/SQL,

Workflow 2.5, Reports 6i, Discoverer 4i/10G, Discoverer Plus, UNIX, TOAD.

Handle Man Company, MI

Mar 07 - Nov 07

Role: Technical Consultant

2

Responsibilities:

. Involved in design, development & implementation of Oracle Application

modules AP, AR, OM, PO, and PA.

. Written conversion programs for AP invoices, AR customers, AR

invoices, PO purchase order, and OM order imports.

. Created staging tables necessary to store data prior to loading data

into customer interface tables. Created SQL*Loader scripts to load

legacy data into Oracle staging tables. Created PL/SQL procedures and

functions necessary for validating and loading the data into interface

tables.

. Developed/Customized reports based on the client's requirement.

. Interacting with and supporting users to get requirements.

. Extensively used AOL and System Administrator modules for set up of

various Concurrent programs, Request sets, Value sets and Descriptive

flex fields.

. Used standard API's for conversion of data.

. Developed the conversion of Customer from legacy systems to Oracle

Applications. Imported external invoices into Oracle Receivables (AR)

through Auto Invoice Program using SQL*Loader

. Customized various reports in AR related to aging, invoicing, customer

balances.

. Migrated the data from legacy systems into the temporary tables in

Account Payables (AP). Successfully designed and implemented the

Payables Open Interface. Activities involved creation of Loader File,

porting Invoices into the AP_INVOICES_INTERFACE and

AP_INVOICE_LINES_INTERFACE interface tables using SQL*Loader and then

using Payables Open Interface to port the data into the actual tables.

. Developed/Customized reports in AP some of these are AP Invoice Hold,

Payment Terms, Invoice Distributions, Debit/Credit Memos.

. Data Conversion of standard PO's into Oracle Purchasing using

Purchasing Document Open Interface. The Purchase orders are validated

using custom programs and eligible PO headers, lines and distributions

are imported into PO_HEADERS_INTERFACE, PO_LINES_INTERFACE and

PO_DISTRIBUTIONS_INTERFACE.

. Developed/Customized reports in PO some of these are PO

Vendor/supplier info, Vendor Payment Terms, PO Requisition reports.

. Worked on Order Import to import open orders from Legacy system.

. Designed and developed the following Order Management reports like

"Pack List Main Report"," Summary Pack List Report", "Sales

Acknowledgement Report", "Order Holds Report".

. Building custom reports using Discoverer 9i.

. Responsible for Preparation of User documentation.

Environment: Oracle Applications11.5.8, AP, AR, PO, OM, PA, SQL*Loader,

Oracle 8i, PL/SQL, Reports 6i, Discoverer 4i, UNIX, TOAD, Windows 2000.

NTPC, India

Feb 06 - Jan 07

Role: Technical Consultant

Responsibilities:

. Involved in Design and modeling of the system.

. Extensively involved in coding of the Business Rules through PL/SQL

using the Functions, Cursors, Triggers, Stored Procedures, and

Packages in the server side.

. Participated actively in the technical and functional discussions.

. Extensively involved in designing the project and coordinating a

highly professional team.

. Interacted with the user group on a regular basis to discuss

requirements and updates.

. Used Forms to provide the interface for the application and Reports to

take periodical reports.

. Responsible for the Instructor module user interface design,

implementation and testing.

. Generated reports and graphs to study instructor utility percentage

every quarter and display the feedback results.

. Was responsible for providing expertise training to end users on the

new system and its user interface and reports running procedure.

Environment: Oracle 8i, SQL, PL/SQL and Forms 4.5, Reports 2.5, Windows NT.

Qualifications:

. Distinction in B-Tech, Electronics and Telecommunications from

Jawaharlal Nehru Technological University

Contact this candidate