Online
Busy
Away
|
|
|
|
|
|
|
|
Degrees
|
|
Bachelors in Commerce, Bachelors in Computer Applications
|
|
|
My Expert Service
|
|
Business and technical requirements on following modules:
Accounts payable, Inventory, Oracle Process Manafacturing, purchasing and accounts receivable
Functional support in the above modules
Used .net for creating interfaces for locations to enter products and sales data
Worked on production support on above modules
Conversion from parent company to new company in oracle applications 11.5.10 on above modules
Worked in functional/technical aspects of Oracle Internet Expenses and iReceivables
Production support for Oracle Process Manafacturing
Custom built module for ctx payments using .net and tied to Oracle Payables
Custom built module for ibm invoice imaignng using .net and tied to Oracle Payables
Fertilizer equipment systems
Custom.pll and personalization
Workflow notification and customization for purchasing
Customization of invoice number and vendor merge using custom.pll and .net
Worked on various reports and forms in developer 6i
The purpose of this forecasting tool is to provide the Proprietary Products Group and the Business Units a tool that will provide timely forecasting information and analysis on proprietary products throughout the year. This in turn should provide better inventory management by all levels.
Customer refunds –AR
The transition process (in brief) involves payables collecting copies of all utility and solid waste bills from all locations to send to Avista.
Small balance Writeoff
Helena Chemical Company has adopted a new awards/incentive program in order to show appreciation for our customers. Implementation of this program should increase the company's relationship with its customers as as well as increase sales. The name of this program is Loyalty Works
Postitive pay
Hirearchey in GL reports
Did conversion for the AP/AR/GL/PO and vendors for sister concern to 11.5.10.
At present in the conversion process from 11.5.9 to 11.5.10
|
|
|
Experience & Qualifications
|
|
At present working for Chemical Co in Oracle Applications 11.5.10 and also responsible for conversions
Teradyne Inc.,Boston, MA February 2000 – to 2003
Sr. Oracle Developer
Developed functional and technical documentation for implementing Oracle Applications 11I
Used PL/SQL for developing packages and procedures using Dynamic SQL
Shell scripting and host programs for pulling data
Developed queries and views for reporting
Worked on Forms 6i and Reports 6i
Worked on the following modules in Oracle Applications AP, PO, GL, FA, MFG, OM, WORKFLOW , AOL INVENTORY.
Performed Q/A activities to ensure that Reports meet the functional specifications
Created PL/SQL procedures, packages and functions used to load and verify data from vendor feeds into an Oracle Database
Working on Pl /sql packages , procedures, functions, Created views, cusomized forms and reports (6I)
Also writtten a lot of shell scripts which are used to interact with cross modules and AOL
Worked with Custom.pll in customization
Worked with sql loader to load data from flat files and also using pl/sql to create flat files
Provided Database maintenance as required to support the Reports being created.
Worked on many complicated Oracle Reports and Forms 6i used for pulling data into applications on the Oracle 8i database
Used JSP, Javascript, Java Servlets and HTML to create an interface for users to see Distribution details such as booked orders and shipped orders.
Involved in activities on the backend as well as on the functional side of Oracle Applications and the Database.
Information Resources Inc., Waltham, MA November 1999-February 2000
Sr. Oracle Developer
Trade Funds Management System
Performed systems requirement study and user requirement study.
Took a final view on all the user requirements from a QA perspective.
Planned the database changes to be made.
Worked on design using Visual Modeler and Rational Rose for the three-layer model
Designed Servlets Objects and the required connectivity to the database
Designed a Server Side objects using PL/SQL and transact-SQL
Designed the datamodel in MS SQL Server 7.0 and Oracle 8i
Development using Java on the Server for web based applications using Oracle 8i and Oracle Applications Financials Version 10.7 and 11.0 and also Oracle HR.
Development of Java objects at the client for VB 6.0 that accessed Oracle Financials and HR for web development.
Planned Server Side programs.
Travelers Express, Minneapolis, MN March 1999-November 1999
Sr. Oracle Developer
Official Checks Application/Moneygram
Developed PL/SQL packages, ten SQL reports, twelve views and many triggers to support the GUI. Developed ten PL/SQL packages to integrate the Oracle Manufacturing tables and the look tables in the present system. Developed new Forms using Developer 2000 and Forms 4.5 to implement user requirements. Modules worked on include Bill Of Materials and Oracle Purchasing to integrate the current data into Oracle tables with Manufacturing tables.
Performed system requirement study and user requirement study
Took a final view on all the user requirements
Planned database changes to be made and Server side programs to be developed
Used SQL Reports for formatting
Wrote user test scripts for package testing
Used International Project Management Tools for managing the process to handle the release of MoneyGram stock. This was done to issue customers electronically to the vendor with minimal manual large volume data updates. Maintained data integrity of serial number ranges assigned to customers. The project automates the process of tracking and reporting the start of the ordering and provisioning stage until the final completion of the order. The project is web-based and uses Java, JavaScript, HTML, Visual Modeler, VB 6.0 and JDBC. The backend database is Oracle. The tool is designed to be completely compatible with Netscape version 4 and above.
Environment: Database: Or
|
|
|
Available Modes Of Communication
|
|
email/chat
|
|
|
|
|
Contact
VENKAT IYER
|
|
|
|
|
|
|
|
Home » Computers & Programming » Databases » Oracle
» VENKAT IYER
|
|
|