|
Summary & Technical Skills
|
About five years of experience in Information Technology, Including two years of experience as an Oracle Application Development, analysis, supporting, and implementation of Information system in Client Server environment using Developer 2000 and ABAP/4 Screen & Menu Painter as Front End and ORACLE 7.x/8.0 as Back End
Languages : SQL, SQL*Plus 3.2, PL/SQL 2.3, ABAP/4, FORTRAN, LISP
RDBMS : Oracle 7.x/8.0
Operating systems : MS-DOS, Windows 95/98, Windows NT 4.0, Unix (Sun Solaris)
Software/Packages : Developer 2000(Forms 4.5, Reports 2.5), AutoCAD, SQL*Loader and Exposure to Forms 5.0 and Reports 3.0, MSOffice 95/97
|
|
|
|
|
Experience as an Oracle Developer
|
LAKHOTIA COMPUTER CONSULTANTS
Environment : Oracle 7.3, Forms 4.5, Reports 2.5 and Windows NT
Client : SEJAL AUTO LTD.
Migrated data from MSAccess to Oracle 7.3 using flat files with SQL*Loader
Created complete client-server database application for Automotive Repair Shop
Developed interface with the Central Supply Management System
Developed several screens for Inventory, Order Processing, Invoicing, Accounting, Sales, Purchase
Designed User Interface by studying User requirements and provided end-user support & training
Developed packages, stored procedures and functions to maintain transactions & screens
Developed reports on Inventory, Sales, Order Processing, Accounts Payable/Receivable, Forecasting
Done testing and Bug fixing until system had no loopholes
Client : ELECON ENGG. LTD.
Environment : Oracle 7.1, Forms 4.5, Reports 2.5 and Windows NT
Material Management System:
Developed application which dealt with planning and maintaining the requirement of materials
Generated Purchase and Sales orders, B.O.M. and production, customer, vendor, product details
Maintained one transaction, for each item, with which transaction data gets updated
Developed several reports for analysis purposes viz. PO�s for given date or period, List of PO�s Vendorwise, Vendors supplying multiple items supplying given items, Accounts Payable for Vendors
Developed several forms for data entry and provided end user support and training
Developed several stored procedures, functions, database triggers and other schema objects
Client : Gujarat M/c Manufacturing LTD.
Environment : Oracle 7.0, Forms 4.0/4.5, Reports 2.0/2.5 and Windows NT
Financial Accounting System:
Developed data entry forms for Sales, Purchase, Cash, Bank, Vouchers, Employee expenses etc.
Developed reports for Sales, Purchase, Bank, G/L register and Accounts Payable & Receivable
Created Database Triggers for all Accounts related Transactions against Insert, Update and Delete
Developed Stored Procedures for Validating Accounts and Transactions
Supported in migration from Forms 4.0 and reports 2.0 to Forms 4.5 and reports 2.5
Performed multi-tasks, stayed focused and remained organized under pressure
|
|
|
|
|
Experience as an ABAP/4 programmer
|
DSSSOFT TECHNOLOGIES
Environment : MS SQL Server, SAP R/3 3.1H, Visual Basic 5.0 and Windows NT
Wrote Data Extracts programs for the followings
Company Codewise - Financial Yearwise - Document Typewise Data extracts for Document Number, Financial Year, Document date, Ref. Doc. Number Exchange Type
Wrote BDC programs for the followings
To upload vendors and customers from flat files
To extend Material Master MRP1 & MRP2 view from one plant to another
To upload changes of Address and Payment terms for vendors and customers.
Wrote programs for following kind of Basic Listings
Master Listing - Customer Master, Vendor Master, Material Master
Transaction Listing - To call from other Drill-down reports
Wrote following Drill-down & Analysis reports with Graphs options
Company Codewise - Business Areawise - Customerwise Invoices Raised in a Quarterly matrix
Company Codewise - Purchase Organizationswise - Purchase Groupwise - Vendorwise - Material Typewise - Materialwise Purchase Orders Raised (AP)
Cost center - Material Typewise - Materialwise Consumption
P.R. to P.O. Conversion in number of days matrix in following order (1) Purchase Organizationwise - Purchase Groupwise (2) (Purchaser) Userwise - & Datewise
List of Invoices Due in a matrix of next 7, 15, 30 ,.. days
To generate detailed Sales report
Wrote programs for conversion of Material Master e.g. to load current price from a legacy system
|
|
|
|
