Oracle Supply Chain
Resume:
BALA
[pic]
Oracle Apps Techno Functional Consultant
*****.******@*****.***
. 9+ Years of Oracle Applications experience - specializes in the
development of Oracle software solutions utilizing expertise in
requirements definition, business analysis, design, systems integration,
and implementation.
. Hands-on involvement in business requirement, GAP analysis, process
mapping, solution design, configuration, setups, work arounds,
interfaces, user training and conversion programs.
. Developed functional and technical specifications as well as test
plans and test scenarios using AIM methodology and documents such as
BR 100, MD 50, and MD 70.
. Good Experience in implementing Order-to-Cash and Procure-to-Pay
Business Process flows.
. Strong experience in customizing applications using OAF, JTF, Java,
JSP, ADF and JSF.
. Over 7 years of experience in Implementation and RICEW Customization
of Oracle Applications 11.5.9/11.5.10 and Release 12 modules such as
Oracle financial (GL, AR, AP, FA, CE), Supply Chain Module (OM, INV,
PO, BOM, WIP), QP and System Administration module.
. Expertise in System Administrator activities like managing concurrent
managers, application user setup, defining responsibilities, value
sets, flex fields, registering menus, forms, reports, concurrent
programs, profile options as per the requirement.
. Has very good experience in customizing existing OAF Screens, forms
and reports as per business needs using OAF Substitutions, custom
PLL's, Forms Personalization's respectively.
. Experience in the preparation of Functional Design, Technical Design
documents and System Test scripts for Extensions, Data
Conversion/Migrations, Inbound / Outbound interfaces, Reports,
Workflows, XML Publisher, Forms and Customizations.
. Experience in database programming using Oracle 8i/9i/10g databases.
. Expertise in SQL, PL/SQL, Packages, Functions, Procedures, Triggers,
Views and Indexes.
. Experience in various development tools like SQL Developer,
SQL*Loader, Discoverer 9i,Oracle Jdeveloper 10g/9i, Forms 10g/6i,
Reports 10g/6i.
. Experience in developing UNIX Shell scripts for loading data into
staging tables and understanding of Multi org & TCA architectures.
. Experience in Tuning SQL statements to improve execution performance
using TKPROF, SQL Trace, etc.
. Excellent communication skills, adapt in client interaction and
understanding business applications.
. Pro-actively identify areas of opportunity and work to finding
solutions that meet the business needs of the customer.
. Absolutely capable of working in a fast paced, dynamic, team-oriented
environment with 24x7 support.
Technical Skills:
ERP Applications Oracle EBS (12.0.3) /11i (11.5.8, 11.5.9,11.510.2)/11.0.3
Modules Financials - (GL, AP, AR, FA), Supply Chain - (INV, PO, OM),
Manufacturing - (BOM, WIP), CRM, ASCP, iProcurement, iExpenses,
Service Contracts, TeleService, iSupport.
Methodology Application Implementation Methodology (AIM)
Languages/Framework SQL, PL/SQL, Java, JSP, JSF, OAF, ADF, HTML, XML, C, C++
s
GUI/Tools JDeveloper 10g/9i, Forms 10g/6i, SQL*Loader, SQL*Plus, SQL Developer,
Toad, VSS, PVCS, Forms Personalization.
Databases Oracle 11g/10g/9i/8i, MySQL, MS Access
Reporting Tools Reports 10g/6i, XML/BI Publisher, Oracle Discoverer 10g/9i, Workflow
builder, Optio 7.8
Utilities IE 5.0/5.5, Netscape 4.7/6.0, Mozilla, Putty, WinSCP
Professional Experience:
Client : Maricopa Community Colleges, Tempe, AZ, USA
Duration: Apr' 12 - Till Date
Role : Oracle ERP Techno-functional Consultant
Project: CFS(College Financial System) R12 Upgradation (General Ledger, AR,
AP,FA,PO,CM) and Grants Implementation
Description:
Maricopa Community Colleges had 10 colleges, 2 skill centers and numerous
education centers. MCCCD educates total of 10,254 courses and trains nearly
200,000 persons per year and employs over 12,000 people, has an annual
operating budget of over 1.5 billion dollars and controls assets of over 1
billion dollars.
This project MCCCD's enterprise financial system, College Financial System
(CFS), is used to manage the Purchasing (PO), Accounts Payable (AP),
Account Receivables (AR), Cash Management (CM), Fixed Assets (FA),Grants
and General Ledger (GL) processes by the District Business Services
division, and is used by the campuses to order and receive goods and
services. CFS has over 2,000 registered users and averages about 350
concurrent users per day.
Responsibilities:
. Developed customized solution for Oracle Fixed Assets 12i to resolve
depreciation issues.
. Developed Workflows, Reports, Interfaces, Customizations and
Extensions(WRICE)
. Developed Customers interface in Accounts Receivables (AR)
using Oracle Standard API.
. Import Open AR Invoices using Oracle standard interface tables and
Auto invoice import program
. Developed Scripts for Deduction Over Ride Interface in FA.
. Developed reports for getting payables and receivables from Sub ledger
Accounting(SLA)
. Worked on Grants Account Generator - Project Supplier Invoice Account
Generation workflow (PAAPINVW), PO Account Generator workflow
(POWFPOAG) and PO Requisition Account Generator (POWFRQAG).
. Worked on AME (Approval Management Engine) setups which include
granting access to AME objects for users, Rules, Attributes,
Conditions, Action Types and Approver Groups.
. Worked on AP Invoice Approval (APINVAPR), AP Invoice Approval
Negotiation (APINVNEG), AP Invoice Hold Notification (APINVHDN), and
AP Invoice Holds Negotiations (APINVHNE) workflows from installing the
AME, Creating the attributes, Conditions, Approver Groups, Action
Types and Rules.
. Created the Positive Pay Feed for Wells Fargo using BI Publisher
according to their ARP Standard File Format Specification.
. Worked on R12 version of Remittance Advice using BI Publisher.
. Developed PL/SQL Packages, Procedures, Functions for validating the
invoices and payment information from the legacy system and imported
into Oracle Applications using the Payables Open Interface Import
program and populated the base tables, which involved in Releasing
Invoices from Hold, Approval of invoices and creating of New Invoices.
. Developed the AP Invoice Aging Report by customizing the standard
oracle report, to display the Future Payments and Prepayments in the
report.
. Developed custom API that uses Oracle Process Order API to create and
book the orders.
. Customized the seeded Order Line workflow to handle price notification
and approval for multiple levels of the organization.
. Worked on optimizing the custom views SQL for performance.
. Was involved in Design, Unit Test Plan and Code Reviews.
. Writing custom interface programs and working on Oracle Open
Interfaces to integrate Oracle Applications with other packaged and
custom Applications, which includes Payables Open Interface, Bank
Statement and Reconciliation, Auto Invoice and GL Interface.
. Defining concurrent programs, executables, and value sets, creating
users, defining responsibilities and assigning responsibilities to
users with System administrator responsibility.
. Extensively participated in developing technical documents (MD70,
MD120).
. Creating Database Triggers, PL/SQL Stored Procedures.
. Developed and modified various reports in purchasing module.
Environment: Oracle Applications 12.1.2, Oracle 10g, PL/SQL, SQL, Forms,
Reports, Workflow Builder 2.6.3.5, CVS, SQL*Loader, DB2 and UNIX.
Modules: Financials (AP, AR, GL,FA),CM, OM, PO, Grants ; XML Publisher,
BI Publisher, SQL, PL-SQL, Forms 6i, Reports 6i, Workflow, Putty, Winscp
3, FTP, Optio 7.8, Windows XP and UNIX.
Client : Macsteel Service Centers USA, CA, USA
Duration: May' 10 - Mar'12
Role : Oracle Applications Techno Functional Consultant
Project: MAC-12 Oracle Project (General Ledger, AR, AP, and Supply chain
(PO, OM, INV))
Description:
With 32 locations throughout North America, Macsteel Service Centers USA
offers one of the largest inventories of metals in the service center
industry. . Macsteel Service Centers USA processes and distributes carbon,
stainless, aluminum and specialty metals to customers throughout North
America and Puerto Rico.
This project is MAC-12 Oracle Project implementation focused on financial
modules for various Macsteel division and branches phasing out their legacy
system Stelplan and developing custom Sales Order Form and Discrete
Manufacturing Process. As part of Mid-West region and Eastern Region
implementation and migration, we have customized and set up PO, AR and AP.
As an Oracle Applications Techno-Functional Consultant and part Oracle Apps
implementation team.
Responsibilities:
. Customize and convert existing RDF reports that will run compatible as
per the new multi-org structure and user requirement.
. Develop PL/SQL program that extracts and generate a flat file with the
information from Stelplan. Automate the data load process from
Stelplan by scheduling PL/SQL packaged procedure as a concurrent
program.
. Develop Account Analysis report that shows current A/R balance, credit
limit and past 12 months transaction history for the customer(s)
defined in TCA. This report is being used by credit department in
order to analyze the customer history and approve for higher credit
limits.
. Resolved issues in embedded workflow of Order flow in OM module and
had the modified workflow re-deployed in the instance.
. Worked on MOAC (Multi Org Access) for all the branches in Macsteel.
. Developed reports for getting payables and receivables from Sub ledger
Accounting(SLA)
. Customized Workflow Order routing process and Notification process
based on the approval Hierarchies to notify the stake holders.
. Requisition approval process and order routing process validation
logic has been customized using the custom functions at activity nodes
on the standard workflow processes
. Created and customized reports using XML Publisher in OM, AR, AP and
INV.
. Extensive Experience in Finance API and OM API's like order creation,
order updation and pricing.
. Developed PL/SQL Packages, Procedures, Functions for validating the
invoices and payment information from the legacy system and imported
into Oracle Applications using the Payables Open Interface Import
program and populated the base tables, which involved in Releasing
Invoices from Hold, Approval of invoices and creating of New Invoices.
. Develop Open Purchase Orders report using XML that queries all Open
PO's at header, line and shipment levels and shows the quantity of
goods received and balance quantity of goods to be received against
the shipment line.
. Create and define template and data definitions for Open Purchase
Order report. Conditionally display company logo information based on
run time parameters.
. Developed Sales by Customer Ship-To Location report that shows the
sales information with corresponding order number, invoice number,
Item number, and PO and customer ship-to location.
. Customized PO Approval workflow process using Workflow Builder and
define processes based on the purchasing amount and ship to location.
. Created Views for Discount Price List, Modifiers and Qualifiers for
the modifiers for OBIEE Reporting.
. Created Custom Procedures for Incremental Loads and custom views for
OBIEE Reporting.
. Developed Custom reports, Customized existing reports (Bill of Lading,
Customer AR Aging Report, Inventory Planning Report, Price evaluation
report, Shipping Order, Sales Order Report) according to the
functional specifications using Reports 10g, XML publisher.
. Extensively participated in developing functional and technical
documents (MD70) and (MD50).
. Trouble shoot issues with run time performance of the reports and use
lexical parameters and bind variables wherever required to improve the
performance and integrated system-level tests to comparing actual
results with expected results
. Involved in setting up users and defining resources for AR and assign
roles as per the requirements using CRM Administrator responsibility.
. Worked as member in technical troubleshooting of day to day production
issues
Environment: Oracle Applications 12.1.2, Oracle 10g, PL/SQL, SQL, Forms,
Reports, Workflow Builder 2.6.3.5, CVS, SQL*Loader, DB2 and UNIX.
Modules: Financials (AP, AR, GL), OM, PO ; XML Publisher,SQL, PL-SQL,
Forms 6i, Reports 6i, Workflow, Putty, Winscp 3, FTP, Optio 7.8, Windows XP
and UNIX.
Client : Lion Apparel, Dayton, OH
Duration : Jan'10 - May'10
Role : Techno Functional Consultant
Project: Phase V Oracle Apps Implementation (General Ledger, PO, AR,
AP, OM, iSupplier and PA)
Description:
Lion is a company dedicated to uniform and personal equipment sales and
logistics in the civilian agency, emergency service and military markets.
Lion operates in three markets, the emergency services, military and
civilian agency uniform and personal equipment markets.
This project is the implementation of phase V which involves the
Demand to Build, Order to Cash flow conversions from VAX system into
Oracle system and implementation of Contact Allowance program
Responsibilities:
. Involved in requirements gathering, analysis, development, QA and post-
production support.
. Performed GAP analysis to ensure that the requirements are captured
properly.
. Worked with SQL Loader and PL-SQL Built in packages to convert VAX data
into Oracle Applications as necessary.
. Prepared Module Design technical documentation MD070.
. Developed the BOM conversion code to convert the data from VAX to oracle
system and registered as a Concurrent Program.
. Designed and developed custom program to load EDI 850 inbound Orders into
Order Management.
. Involved in the Personalization of the custom international budget form
so as to fit the US requirements.
. Created custom Shell scripts to handle the loading the data file into the
custom tables and archiving of the data file.
. Came up with the custom code to customize the Outbound EDI 856, 810
documents to add the extra fields as per the business requirements.
. Developed the Contact Conversion code to convert the contact data from
legacy system to oracle system and registered as a Concurrent Program.
. Customized the Order entry form as per the requirements so as to display
the Allowance details.
. Worked on creating the pricelists based on the customer requirement.
. Worked on creation of Contact Allowance maintenance form and handled the
contact allowance conversion to convert the allowance information for
each contact from the legacy system
. Coordinated with the offshore team to get the requests done.
. Daily Development Interaction with Technical leads for status and any
other outstanding issues.
. Worked as a Member of the Production support system to address day to
day issues.
Environment: Oracle Applications 12.1.2, Oracle 11.1.0.7.0, PL/SQL, SQL,
Forms, Reports, Workflow Builder 2.6.3.5, PVCS, Kintana, DB2, Sybase and
UNIX.
Modules: SCM (PO, INV, OM), Financials (AP, AR, GL), XML Publisher
Administrator, iSupplier, Application Developer, OM and PA; SQL, PL-SQL,
Forms 6i, Reports 6i, Putty, Winscp 3, FTP, Windows XP and UNIX.
Client : Southern Company, GA, USA
Duration: Jan 09 - Dec'09
Role : Techno Functional Consultant
Project: GLSCAPE (General Ledger, Supply Chain and Payables)
Description:
Southern Company is a leading producer of electricity; the company owns
electric utilities in four states (Alabama, Florida, Georgia and
Mississippi) and a growing competitive generation company, as well as fiber
optics and wireless communications (Southern LINC).
This project is Oracle E-Business Suite Release 11.5.10.2 implementation
focused on financial modules for each state in different phases. As part of
phase 4 implementation and migration, we have customized and set up GL and
AP modules for Alabama Power and Mississippi Power. As an Oracle
Applications Techno-Functional Consultant and part Oracle COE Team.
Responsibilities:
. This project was an Order management roll out for EMEA countries.
. Work closely with Oracle ESS Team (functional team) to gather user
requirements
. Created custom Invoice Work Bench (XXAP_APXINWKB) form from scratch
using template.fmb.
. Demonstrated and wrote program logic for custom Invoice Routing and
Approval form to work in conjunction with 'Invoice Validation'
program.
. Resolve database dead lock issues with Invoice Validation program and
Invoice Routing and Approval form.
. Define and set up DFF's using Application Developer responsibility for
Purchase Order Header to identify Contract Retention Invoices.
. Wrote PL/SQL packaged procedure to be scheduled as concurrent program
to identify and place payment holds for 'Contract Retention' invoices.
. Provide custom menu using Forms Personalization for Invoice Routing
Approval form to provide users to query and view invoice images stored
in Documentum.
. Created an Oracle Alert to send an alert whenever Custom Invoice
Metadata Update program runs for more than two hours.
. Involved in Planning and implementing data conversion methodology and
programs using PL/SQL to receive invoices from Brainware to Oracle.
. Customize standard Unmapped Subsidiary Accounts report using Oracle
Reports as per the user requirements for General Ledger Consolidation
purposes.
. Create HP-PPM package, add database objects to be deployed/migrated
from one instance to another. Responsible for AP-PPM package migration
from development to production.
. Create Change request (CRQ) using Remedy to deploy the tested
successfully changes from UAT to production. Document and attach
necessary information for Remedy CRQ.
Environment: Oracle Applications 11.5.10.2, Oracle 10g, PL/SQL, SQL, Forms,
Reports, PVCS, SQL*Loader, HP-PPM, Remedy, BugNet, Clarify, Cool
Compliance, Oracle, IBM Maximo and UNIX.
Modules: AP, GL, AR and iExpenses
Client : Dresser, Waukesha (WI)
Duration: Aug'08 - Dec'08
Role : Techno Functional Consultant
Project: Oracle Manufacturing (WIP, BOM), Financials (AP, AR, GL) and CRM
(TeleService) Consultant
Description:
Dresser's Compression and Power Systems Segment is a leader in the design,
manufacture and marketing of natural gas-fueled engines, used primarily for
natural gas compression and distributed power generation. These engines are
sold under the Waukesha.
Responsibilities:
. As a Techno Functional consultant responsible for creating multiple
conversions to support client's migration from a legacy system to Oracle
ERP suite of applications including WIP, BOM, Purchasing, Inventory, and
Order Management.
. Imported Bills and Routings through BOM Interfaces.
. Developed Work Order Interface to import discrete job information into
oracle apps base tables.
. Created Shell script program to call the SQL loader program that
transfers data in data file to staging table and runs the custom
concurrent program to transfer data from staging table to interface
tables.
. Created and customized reports using XML Publisher/BI Publisher in OM,
BOM, PO, AP, AR, WIP and INV.
. Customizing & enhancements on Forms.
. Converted Oracle 6i Reports and SCM reports to BI publisher reports.
. Extensively used CRM API's for upload the service request information
from AFA (Legacy System) to oracle apps ERP.
. Developed custom workflows for tracking service requests, and notifying
users about the status of these service requests.
Environment: Oracle Apps Implementation Release (12.0.3), Oracle 10g,
PL/SQL, SQL, Forms, Reports, Workflow Builder 2.6.3.5, CVS, SQL*Loader, DB2
and UNIX.
Modules: SCM (PO, INV, OM), Manufacturing (WIP, BOM),CRM
(Teleservice,Service Request), SQL, PL-SQL, Forms 10g, Reports 10g, Putty,
Winscp 3, FTP, Windows XP and UNIX.
Client : Sepracor pharmaceuticals, Boston (MA)
Duration: May'08 - Aug'08
Role : Oracle Analyst
Project: Oracle Financials (AP, AR, GL), OPM (Oracle Process Manufacturing)
and ASCP (Advanced Supply Chain Planning)
Responsibilities:
. Supported a pharmaceuticals client in developing database triggers for
their custom requirements.
. Critical process design and validations in Order to Cash cycle.
. Developed the reports and Forms as per the current requirement by using
reports6i and Forms 6i.
. Developed custom reports as per client requirement in OPM Forecasting
module.
. Extensively used SRW packages in Oracle Reports.
. Created Discoverer Reports for GL, AP, AR, ASCP and OPM modules using
Discoverer Administrator and Desktop Edition. Created Custom Folders,
Business Areas, and Workbooks. Assigned Privileges and registered the
reports in Oracle Applications. Customized the Workbooks by adding
additional functionality (conditions, calculations, parameters, sorting,
etc.) and scheduling them for the users.
. Uploaded all the concurrent program details into another instance by
using FNDLOAD commands.
. Validated test scenarios and test cases to ensure that the delivered
unit is valid after incorporating the changes.
Environment: Oracle Apps Implementation Release (11.5.10.2), Oracle 10g,
PL/SQL, SQL, Forms, Reports, Workflow Builder 2.6.3.5, CVS, SQL*Loader, DB2
and UNIX.
Modules: Financials (AP, AR, GL), OPM, ASCP SQL, PL-SQL, Forms 6i, Reports
6i, Putty, Winscp 3, FTP, Windows XP and UNIX.
Client : Tensar International Corporation, Atlanta, USA
Duration: May'07 - Apr'08
Role : Techno Functional Analyst
Project: Oracle Manufacturing (WIP, BOM), Oracle Financials (AP, AR, GL),
SCM (PO, OM, INV)
Description:
Tensar International Corporation is headquartered in Atlanta, Georgia
having offices across the United States of America is a service provider
for specialty products and engineer services. Tensar specializes in cost-
effective solutions for common site development problems. These solutions
are used in development of residential, commercial, industrial, municipal
and transportation infrastructure. The Company has two manufacturing plants
located in Morrow, Georgia and Evansville, Indiana. Tensar Earth
Technologies and Tensar Polytechnologies orders are processed from the
plant located in Morrow, Georgia and North America Green orders are
processed from its plant in Evansville, Indiana.
Responsibilities:
. Getting the functional inputs from the users and worked on the technical
enhancements.
. Analyzed business requirements, designed, implemented business solution
design and development.
. Created and customized reports using XML Publisher in OM, AR, AP and INV.
. Prepared the Technical Design documents, Installation documents and Unit
Test Case documents.
. To send notifications to users by using oracle work flow builder.
. Customized Workflows as per the client requirements.
. Worked with Discoverer so users would have the ability to generate ad-
hoc reports.
. Experience includes application system administration activities such as
user setup, defining responsibilities, value sets, flex fields, data
groups and request groups, registering applications, menus, forms,
reports, concurrent programs, providing support to apps users for any
technical and functional issues.
. Prepared the SQL scripts for creating the concurrent programs, executable
and parameters in Oracle applications.
. Uploaded all the concurrent program, Value sets and Responsibilities
details into another instance by using FNDLOAD commands.
. Creation of Value sets in various Modules of the application.
Environment: Oracle Apps Implementation Release (11.5.10.2), Oracle 10g,
PL/SQL, SQL, Forms, Reports, Workflow Builder 2.6.3.5, CVS, SQL*Loader, DB2
and UNIX.
Modules: SCM (PO, INV, OM), Manufacturing (WIP, BOM), Financials (AP, AR,
GL, FA); SQL, PL-SQL, Forms 6I, Reports 6i, XML Publisher, Putty, Winscp 3,
FTP, Windows XP and UNIX.
Client : PPG BBR Upgrade Project, Pittsburgh (PA)
Duration: Jan'06 to May'07
Role : Techno Functional Consultant
Project: Supply Chain (PO, OM, INV), Financials (AP, AR, GL, FA), OPM
(Oracle Process Manufacturing)
Description: The project is to re-engineer their business processes spread
across the World by the name "Business Breakthrough Re-engineering". This
project involved reengineering and upgrade of 11i Custom objects from
Release 11.0.3 to Release 11.5.10.2 in all modules.
Responsibilities:
. Upgrade of 11i Custom objects from Release 11i (11.0.3) to 11.5.10.2
in all modules.
. Developed Sales order conversion using standard API.
. Developed Purchase order conversion using standard interface.
. Worked on Customer conversion to import data from Legacy System into
Oracle Account Receivables by using Customer Interface. Created
SQL*Loader control programs and validation procedures to execute along
with Customer Interface (AR).
. When an item is created in inventory, workflow needs to be launched
and it should collect the details of the item created and sends a
notification to group of users along with the details and link to
master item form.
. Developed PL/SQL Packages, Procedures, Functions for validating the
invoices and payment information from the legacy system and imported
into Oracle Applications using the Payables Open Interface Import
program and populated the base tables, which involved in Releasing
Invoices from Hold, Approval of invoices and creating of New Invoices.
. Developed Warehouse Rules and Production Batches interfaces in OPM.
. Extracted data from AP tables and sending a flat file (checks cut in a
period) using UTL_FILE package at periodic intervals.
. Involved in Custom.pll and Form personalization.
. Tuned the reports to improve performance.
. Developed the reports and Forms as per the current requirement by using
reports6i and Forms 6i.
. Uploaded all the concurrent program details into another instance by
using FNDLOAD commands.
. Validated test scenarios and test cases to ensure that the delivered
unit is valid after incorporating the changes.
Environment: Oracle Apps Implementation Release (11.5.10.2), Oracle 10g,
PL/SQL, SQL, Forms, Reports, Workflow Builder 2.6.3.5, CVS, SQL*Loader, DB2
and UNIX.
Modules: SCM (PO, INV, OM), Financials (AP, AR, GL, FA), OPM; SQL, PL-SQL,
Forms 6I, Reports 6i, XML Publisher, Putty, Winscp 3, FTP, Windows XP and
UNIX.
Client : Dynea Group
Duration: Oct'04 to Dec'05
Role : Technical Consultant
Project: Supply Chain (PO, OM, INV), Financials (AP, AR, GL, FA), OPM
(Oracle Process Manufacturing)
Description:
Dynea Group implemented a new business structure for its global operations.
Dynea's businesses - panel board, industrial resins, wood and specialty
adhesives, and paper overlays - restructured into four regional structures:
Europe, North America, Asia Pacific and South America through the
implementation of Oracle Apps ERP.
Responsibilities:
. Technical Consultant to implement deliverables on several Oracle
Application R11i implementations including legacy data conversions
into financial and manufacturing modules, custom reporting using
Oracle Reports, and custom real-time interfaces into financial, supply
chain management and manufacturing modules.
. Prepared technical and Unit Test Case (UTC) design documentation.
. Developed Vendor Interface program to load data from legacy system in
to temporary table to validate the data and run the Interface Program
to load the data into base tables.
. Creation of various Oracle Alerts to inform internal users of certain
events, or to send notifications.
. Developed Transfer Rules and Open Inventory Balances Interfaces in
OPM.
. Uploaded all the concurrent program, Value sets and Responsibilities
details into another instance by using FNDLOAD commands.
. Developed Requisition Conversion Program in oracle purchasing.
. Developed Item load conversion program.
. Involved in Custom.pll and Form personalization.
. Developed an interface for monthly import of journal entries from
payroll running on a legacy system by using the journal import
interface provided by Oracle General Ledger.
Environment: Oracle Apps Implementation Release (11.5.9), Oracle 10g,
PL/SQL, SQL, Forms, Reports, Workflow Builder 2.6.3.5, CVS, SQL*Loader, DB2
and UNIX.
Modules: SCM (PO, INV, OM), Financials (AP, AR, GL, FA), OPM; SQL, PL-SQL,
Forms 6I, Reports 6i, XML Publisher, Putty, Winscp 3, FTP, Windows XP and
UNIX.
Client : Telex
Duration: Jan'03 to Oct'04
Role : Oracle Apps Developer
Project: Oracle Manufacturing (WIP, BOM), Oracle Financials (AP, AR, GL),
SCM (PO, OM, INV)
Description:
Telex offers superior sound equipment for aircraft, audio, broadcast,
communications, multimedia and wireless applications.
Responsibilities:
. Customization and enhancement for existing reports and interfaces in the
modules of Inventory, Oracle receivables, Purchasing and Order
management.
. Customized Invoice Print Select Invoices Report - Telex
. Customized Move Order Pick slips Report - Telex.
. Customized Dispatch list Report- Telex.
. Developed Sales Order Acknowledgement Report.
. Developed inventory on hand balances conversion program
. Developed WIP jobs conversion.
. Developed Approved Supplier List conversion program.
. Developed Routings load conversion program.
. Prepared the SQL scripts for creating the concurrent programs, executable
and parameters in Oracle applications.
. Imported the customers into Oracle Receivables using the Customer Import
Program with in Oracle applications. Used SQL*Loader to load the data
from flat file into staging tables, finally into Customer Interface
Tables, and then into Base Tables.
. Creation of Value sets in various Modules of the application.
Environment: Oracle Apps Implementation Release (11.0.3)
Modules: SCM (PO, INV, OM), Manufacturing (WIP, BOM), Financials (AP, AR,
GL, FA); SQL, PL-SQL, Forms (4.5), Reports (2.5), XML Publisher, Putty,
Winscp 3, FTP, Windows XP and UNIX.
Contact this candidate