Available on contract plsql programmer/datamodeller with extensive experience in oracle database

From: <maadhav_at_yahoo.com>
Date: Thu, 17 Dec 1998 16:17:17 GMT
Message-ID: <75baqa$s84$1@nnrp1.dejanews.com>

V.R.V MAADHAVAN E-Mail: Maadhav_at_yahoo.com
Phone: (516) 942 2680 (Eve)

Summary :

My current expertise are a culmination of 8 years of professional software development in the areas of Analysis,Design,Development and implementation of client Server applications using Oracle Database.Developed Plsql Stored Procedures,Packages at the server and client side,Used Designer2000 for ER modelling and database designing,Moving different data formats from Legacy System into Oracle Database using Sqlloader control files,Developed different user interface applications with Developer2000,Implementation of Oracle Financials,used Unix Shell Scripts. My experience spans many different corporate enterprise models including trading and other multinational environments. Worked in various roles like Programmer,Analyst,Project Leader,Advisor.

 SKILLS :

ERP Packages		: ORACLE FINANCIALS 10.6(GL,AR,AP,Assets,Sys admin)
Databases			: ORACLE  version 8.03/7.3/7.0/6.0
       Front End Tools 		: SQL* Forms3.0, SQL*Report Writer 1.1,
SQL/PLUS,
                                                    	:  Developer 2000
(Forms4.5,Report Writer 2.5), PL/SQL 2.3,
                                                         	:  PL/SQL 8.0,
SQL Navigator,Toad 5.0,Dbartisan 4.01
Case Tool			: Designer2000 ver 1.3
Communications		: TCP/IP, FTP,Telnet
       Utilities			: Import & Export, SQL* Loader 7.3 &
8.0,Pro*C 8.0,Unix Shell Sripts
       Operating Systems                   : HP-UNIX(9.0 & 10.2), UNIX-Aix,Sco
UNIX, HP-UNIX,Sun Solaris, Windows 3.1,Windows NT 4.0, Windows 95,Ms-Dos 6.20
Computer Systems 		: P-3000,PC(XT/AT) Hp-Workstations,Intel
pentium,RS-6000
Computer Languages	: Cobol,  ' C'

EXPERIENCE   CUSTOMER CARE FRONTEND SYSTEM for Cablevision Systems corporation ,NY -    APRIL98- Current
  DataModeller/PlSql Programmer

Environment : ORACLE 8.0/7.3, PL/SQL.3/8.0, SQL/PLUS, DESIGNER2000, DEVELOPER2000, SQL* LOADER 8.0 Working as a Datamodeller/ Plsql Programmer in project Customer Care Frontend Systems in Oracle database 8.0. Job involves System Study, Creation and management of application systems and Repositary administration.Creation of Entity Relationship diagrams.Transform the entity model into database design with the help of Database design wizard.Later tranform the database design into tables,columns and integrity constraints with the help of Data Diagram. Various system design and datamodel reports were run to check the integrity

of the database design	and test data was input into the database  and the
integrity was  checked	with sql queries  before the database design  was

freezed and released for production.The job also involved writing several stored procedures using Plsql(8.0) in oracle 8.0 server side to populate live data into tables in oracle database from tandem enviroment. Used Sqlloader8.0 to transfer data in text files generated from tandem environment into tables in oracle database for demonstration purpose.These data were retrieved by the front end applications developed in Java environment team by calling the stored procedures in oracle based on the requirement.Have developed user interface screens with Form4.5 for input purposes and used Report Writer 2.5 for report generation. Have done lot of moving data from one database to another.

Pfizer Central Research,NY - Oct'97-Mar'98

Consultant

Implemantation/Customization of Oracle Financials Worked as a consultant in setup and customization of GL,AR,AP Modules and involved in the following activities: SYSTEM ADMINISTRATION : Application Security - Created Users,attached responsibilities and menu depending upon their job requirement giving access only to their relevant areas. Used UNIX Shell Scripts to invoke the SQL*Loader.Developed SQL*loader control files and interface Programs using PL/SQL for validating and loading data from legacy system into AR .

ACCOUNTS RECIEVABLE : Setup: Setup of Banks,Payments methods,Payment formats, and items.Defined Std. customers.
Transactions: Created Invoices,Recurring Invoices,Invoice with Rules,Quick invoices,Done cancellation of Invoices,Applied Pre-payments,Created Debit Memos,Credit Memos,Handled Manual Payments,Stop Payments,Void Payments,Void Payments,Reconcile Payments and Payment Inquires. Reports: Given a Customer Name,report gives invoice No., Invoice Amount,Due Dates.

ACCOUNTS PAYABLE : Setup : Defined- Payment Terms,Distribution Set, Created Vendors and Proximal Terms.
Transactions : Created Std. Invoices, Match the Invoice with Purchase Order, Applied PrePayments,Applied Proration,Created Credit Memos, Expense Report,Quick Invoices, Recurring Invoices,Batch Invoices,Applied Manual and automatic payments.

GENERAL LEDGER : Setup : Was involved in creation of set of books - Chart of Accounts,Defining Accounting Flexfields,Calender,Accounting periods,Define Budget and Encumberance accounts.
Transactions : Created Manual Journal Enteries, Recurring Journal Enteries,Mass Allocation,Reversing Journal Enteries and Posted all above Journals,Created Encumbrance accounts to monitor Expenditure with Budets. Reports : Created reports on budget against Actuals for the specified accounts by defining Row set and Column set . Using FSG generated Income and Expenses report, Profit and Loss
account and Balance Sheet.

FIXED ASSETS : Setting up Corporate Books & Tax Books,Setting up Flexfield Structure such as Category, Location and Asset Key,Define Fiscal Year,Define Calender,Define Prorate Convention,Define Depreciation Methods,Create Asset Category,Quick Addition,Mass Addition,Detail Addition, Transfers, Revaluation,Retirement,Mass Transfers and Mass Changes,Run Depreciation.

PROJECT'S DONE WITH MDV TECHNOLOGIES PVT LTD ,INDIA RPG cellular company,India - June'97 - Oct'97

Consultant

Used Oracle Financials and Involved in the implementation of AIMS(Advanced Integrated Manufacturing System) is a full fledged ERP package(GL,AR,AP,FA,Sys Admin)

 ORACLE GENERAL LEDGER : Setting 3C's i.e Chart of accounts,Calendar, Currency, Responsibilities includes consolidating subsidiary books of accounts into the parent,Management Accountancy functions in terms of preparing budgets,encumbrance accounting , budgetary control. ORACLE ACCOUNTS PAYABLE : Setting up Supplier Profile, Payment Terms and Assignment,Setting up tax structures- the indian scenario warrants a radically different indirect tax structure in terms of setting up excise duty tax structure and central and state tax structure. setting up invoice holds- manual & system. ORACLE ACCOUNTS RECIEVABLE : Setting up Customer Profile and Transaction Profile Setting up of tax structures - The Indian tax structure is complex in terms of setting up of income tax structures and indirect tax structure ,Aging buckets debtors analysis to understand their outstanding towards the company, Setting up corporate books and tax books - The indian law warrants preparation of two set of books. ORACLE ASSETS : Setting up Asset categories ,depreciation tables and prorata conventions, Retirement,Revaluation and translation of assets.

EXPERIENCE IN UNITED KINGDOM COMMERCIAL SYSTEM for AGB Taylor Nelson,UK Mar'96 - May'97

   Project Leader
 Environment : Oracle 7.3,Developer 2000,Designer2000,Pl/Sql , SQL*Loader,ScoUnix

Commercial System in Oracle 7.3 database with DEVELOPER 2000 environment This product was Implemenatated for media industry . I was a team leader involved in finalising the system design with project leader using Desiginer 2000 and involved in the formation of standards and template for the project. I was involved in writing stored procedures,packages on the server and client side using Plsql and integrating with the system testing group,performance tuning of the modules developed by team members.,code reviewing . Description This system takes as input various information and gives a analysis of viewership of different programmes area wise. This information is used by market research agencies and BBC and various satellite channels.

PROJECTS WITH VASANTH COMPUTERS IN CHENNAI, INDIA  HIRE PURCHASE AND FIXED DEPOSIT SYSTEM for Dove Finance ltd,India - jan'95 - Mar'96

Senior Programmer
Environment : Oracle 7.3,Sql*Forms 3.0&Sql*Report Writer 1.1,PL/Sql 2.3,Sql/Plus Sql*menu,Unix

As as Senior Programmer/Analyst involved in the design ,development and integration of the whole system.Data entry screens were designed using Sql menu.Various technics of Sql forms like form level procedures,functions and function key triggers have been used to develop the data entry screens.Database triggers,Procedures,functions were written at the database level to calculate loan interest,fixed deposit interest.Various Mis reports can be generated for the management.Query building concepts in Sql report Writer like parent child relationship,matrix and break groups have been incorporated to develop the above mentioned reports.

FINANCIAL ACCOUNTING SYSTEM for Orient Chemicals Ltd,India. - Feb'94 - Dec'94

 Senior Programmer

Environment : Oracle 7.1,Sql* Forms3.0,Sql*ReportWriter 1.1,PL/Sql 2.3,Sql/Plus

 As a Programmer involved in the analysis,design and development and implementation of a financial accounting system.This system comprises of major transactions like bank statement,bank advice,journal and fixed asset entries,receipt and payments vouchers etc.This system performs multiple activities like updating the relevant modules whenever a monetary transaction takes place using database triggers.Table and column level constraints enforce referential integrity and data consistency.Data concurrency was maintained using the multi-user concept of oracle row level and table level locking.Various reports such as trail Balance,Profit& loss account,Balance sheet,customer wise transactions details were developed using Sql* Report writer 1.1.

EMPLOYEE PAYROLL SYSTEM for New Horsizon Sugar Mills - July'92 - Dec'93

Programmer

Environment : Oracle 6.0,Sql*lForms3.0,Sql*ReportWriter1.1,Pl/Sql 2.3,Sql/Plus,Unix

Involved in the design and devlopment of an Employee Payroll System for an industrial establishment.The various modules are maintenance of employee details,Wage structure,Loan scheme and Grade details.Complex data entry screens and menus were designed and implementated using Sql forms 3.0.Several Procedures and triggers enforce severe validations to ensure data consistency. A processing program written in Pl/sql calculates the monthly salary of an employee. The cursor technique of Pl/sql handles multirow queries efficiently. Various MIS reports can be generated.Advanced features of sql report writer like text objects,run time parameters,break and matrix groups,multipanel reports were used to design report layouts.

Hospital Management System for Ramachandra Medial College,India - Mar'91- Jun'92

Programmer

Environment : Foxpro 2.5,MS-dos/Novell Netware 3.11 Role : Programmer involved in coding of modules only and interacting with the user.

Description : The system takes care of Patient admission, ward transfers, lab investigation, diet for patients, discharge summary, visiting doctors details and calculates amount due to them, ledger posting, P & 1 accounts.

INVENTORY AND INVOICING SYSTEM for Ramachandra Medical College,India. - Sep'90 - Feb'91

Programmer

Environment : Foxpro 2.5,MS-Dos/Novell Netware ver 3.7

Role : Initially training was given and subsequently involved in coding.

Description : The Major objective of the system is to satisfy all information and computations needs related to the preparation of invoice document for exporting various chemicals produced at the factory in Karaikudi district. The system was developed for five different divisions of the group.

EDUCATION :

1.M.Sc(Computer Science) - New Port University,California.
2.Diploma In Oracle Financials ver 10.6.
3.Post Graduate Diploma in Computer Programming and Applications
4.Diploma in Oracle 6.0 and Sql Forms3.0,Report Writer 1.1
5.Diploma in Sybase 4.0,and PowerBuilder3.0
6.Diploma in Unix and 'C' programming
7.Diploma in Developer2000(Forms 4.5,Report Writer 2.5)
8.Bachelor of Commerce from Madras University ,India.








-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own    

Received on Thu Dec 17 1998 - 10:17:17 CST