Customer Service Data
Resume:
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