Posted by on August 20, 19103 at 16:39:48:

Mariappan. S.

EXPERIENCE SUMMARY

A total of nearly 11+ years of experience in Analysis, Design, Development and Implementation of Applications using MF Cobol under SCO Unix, MS-DOS and Novell NetWare. Also using Developer 2000, Visual Basic 6.0, FoxPro, and Oracle, DB2 under Windows 95, Windows NT and Novell NetWare. I have worked with the following Systems

· Banking Applications
· Financial Account System
· Share Accounting System
· Chitfunds Accounting System
· Material Management System
· Jewellery Management System

EMPLOYMENT

· Sep’ 2001 – Till date : Working in Data Consultants, Chennai, India as a
Team Leader
· June 1999 – Aug’ 2001 : Worked in Data Consultants, Chennai, India as a
Senior Analyst Programmer
· Nov‘1998 – May 1999 : Worked in Data Consultants, Chennai, India as a
Analyst Programmer.
· Jul ‘1996 – Oct ‘1998 : Worked in Keystone Softwares, Madras, India as an
Analyst Programmer.
· Jan’1995 – Jun ‘1996 : Worked in S. Sm. Softwares, Tirunelveli, India as a
Programmer.
· May 1992 – Dec‘1994 : Worked in M/s. S. Sm. Softwares, Tirunelveli as
a Junior Programmer.

EDUCATIONAL QUALIFICATION

· Resuming B.Com. in Madras University.

· Diploma in Computer Science and Communication Engineering from Sankar Institute of Polytechnic , 1989 – 1992 ( 3 Years)

Training

· DB2 training given by IBM SPC, Bangalore on April 2003.

TECHNICAL ENVIRONMENT

HARDWARE PC Pentium
OPERATING SYSTEM Novell NetWare, Unix, MS-DOS, Windows 95 and Windows NT
LANGUAGES MF-COBOL, Basic, Fortran, Unix Shell Scripts and PL/SQL
FRONT-END TOOLS Developer 2000, Visual Basic 6.0 / 5.0 and FoxPro
DATABASE Oracle 7.x, Oracle 8I, DB2, MS Access and FoxBase

MAJOR ASSIGNMENTS

Organization: M/s. Data Consultants

Data Consultants has developed full-fledged Banking Application Software in the
name of Integrated Banking System (IBS). They have been handling various banking
clients like Tamilnad Mercantile Bank Ltd., Sri Lakshminarayana Co-operative Urban
Bank, Tiruvarur, Gobichettipalayam Co-operative Urban Bank, Little Conjeevaram
Co-op Urban Bank, Tamil Nadu Industrial Co-operative Bank, Egmore, Coimbatore
City Co-Operative Bank, Tirunelveli Junction Co-Operative Bank, Ramanadapuram
Co-Operative Urban Bank , Etc.

XIX. Project: PAYROLL SUB-SYSTEM

May 2003 – Till date

PayRoll system has Entry forms like Employee Service Register, Attendance Master, History Master , Designation Individual, Designation Common,Branch Reference and Pay Fixation . This system has processings like Pay Calculation,Staff Loan Interest calculation and Salary Crediting and Voucher Passing. This project has reports of Designation wise Report ,Branch wise Report, Pay Slip Generation, Employee EPF Report and Employee Payroll Ledger.

As a Team Leader, was responsible for the following :

· Schedule preparation and work assigning to team member
· System Study, System design, Development and Implementation
· Designed the Tables in Oracle
· Involved in writing stored procedure, packages and functions in PL/SQL
· Test case preparation / testing
· Functional Documentation
· Preparation of user documentation

Environment: PC Pentium, Windows NT, Windows 95, Developer 2000, PL/SQL and Oracle 8.

XVIII. Project: MEMBER SHARE DIVIDEND SUB-SYSTEM

February 2003 – April 2003

This project used to maintain a member share system in a Co-Operative urban bank. This project used to maintain a member, share, dividend calculation, dividend warrant online printing, dividend payable and inquiry etc.
As a Team Leader, was responsible for the following :

· Schedule preparation and work assigning to team member
· System Study, System design, Development and Implementation
· Designed the Tables in Oracle
· Involved in writing stored procedure, packages and functions in PL/SQL
· Test case preparation / testing
· Functional Documentation
· Preparation of user documentation

Environment: PC Pentium, Windows NT, Windows 95, Developer 2000, PL/SQL and Oracle 8.

XVII. Project: VOUCHER TRANSACTION SUB-SYSTEM

August 2002 – January 2003

Voucher transaction sub system is the heart of IBS. In this subsystem, we have linked all subsystems such as Savings, Deposit, and Loans etc. In day-to-day transaction, Credit and Debit made between the subsystems and individual accounts through this subsystem. Branch transactions are adjusted, monitored and controlled by the controlling officer, which controls the transactions.

As a Team Leader, was responsible for the following :

· Schedule preparation
· System Study, System design, Development and Implementation
· Designed the Tables in Oracle
· Involved in writing stored procedure, packages and functions in PL/SQL
· Test case preparation / testing
· Functional Documentation
· Preparation of user documentation

Environment: PC Pentium, Windows NT, Windows 95, Developer 2000, PL/SQL and Oracle 8.

XVI. Project: GENERAL LEDGER ACCOUNTS SUB-SYSTEM

April 2002 – July 2002

Branch General Ledger Accounts Consolidation is mainly developed for Head Office. Total Receipts/Payments and Balances is maintained for all general ledger accounts in Head Office for all the Branches. Branch daybook abstracts & Final Audit Memorandum entries are either entered or converted from the Local drive and it will be accumulated daily. This system will calculate the closing balances for GL A/c of branches & Head Office(Amalgamated). This system will generate various reports like missed checklist, due date checklist, trial balance, Balance Sheet, Profit & Loss Account Statement, Director Office Statements(like R & C Statement etc.,) and RBI statements.

As a Team Leader, was responsible for the following :

· Schedule preparation and work assigning to team member
· System Study, System design, Development and Implementation
· Designed the Tables in Oracle
· Involved in writing stored procedure, packages and functions in PL/SQL
· Test case preparation / testing
· Functional Documentation
· Preparation of user documentation

Environment: PC Pentium, Windows NT, Windows 95, Developer 2000, PL/SQL and Oracle 8.

XV. Project: DEMAND DRAFT ISSUE & PAYMENT SUB-SYSTEM

December 2001 – March 2002

Demand Draft is one of the important instruments in the Banking operations. Normally the branches of a given Bank in the name of individuals or organizations issue Demand drafts. These drafts are issued to the specific branches of the Bank including the issuing branch itself. This system handles the Multiple draft issue, Reprinting, Duplicate draft issuing, taking various reports like draft issue register, draft advice generation, commission earned report, Non-Printed drafts reports. The Demand Draft payable reconciles the Drafts with the Advises from the respective Bank. Separate programs for Advice and Draft entry and option for reconciliation and at the end of the day journal will be done automatically.

In this system have Draft Issue /Reprinting, Duplicate draft printing. And also maintain branch code files also. The Important reports are Advice to branch, Draft Issue Register. In draft payment system Advice & Draft entry programs are the Important Data entry programs. Reconciliation is the important processing. The important reports are Draft paid today, advice received today; Draft passed under Ex-Advice today reports. These reports are also generated proper journals.

As a Team Leader, was responsible for the following :

· Schedule preparation and work assigning to team member
· System Study, System design, Development and Implementation
· Test case preparation / testing
· Functional Documentation
· Preparation of user documentation

Environment: MS-DOS under Novell Netware, MF COBOL

XIV. Project: CLEARING SUB-SYSTEM

September 2001 – November 2001

Local clearing instruments like cheques, drafts, interest warrants and the bank is collecting dividend warrant from the customers. These instruments are accompanied by the credit slip or pay-in-slip where in customer’s account number is mentioned. In case if the Cheque returns due to insufficient balance, or for some other reason the amount is debited from the respective account. It also produces Bank wise and Account wise reports. Outstation instruments are also adjusted through Inter Branch Clearing Adjustment (IBCA).

Local Bank cheques or drafts are en cash by customer through the clearinghouse. The Reserve Bank of India (RBI) controlled transaction between banks through the clearinghouse. In some places State bank of India is conducting the clearinghouse instead of RBI. The Important processing of this system are Booking of the Instrument, Merging of that and updated in to the customer account after knowing the realization. While realization the proper journals passed. The important reports are Account wise report and Bank wise reports.

As a Team Leader, was responsible for the following :

· Schedule preparation and work assigning to team member
· System Study, System design, Development and Implementation
· Test case preparation / testing
· Functional Documentation
· Preparation of user documentation

Environment: MS-DOS under Novell Netware, MF COBOL

XIII. Project: LOANS SUB-SYSTEM

February 2001 – August 2001

Loan is a type of advance facility that is given to customer. The loan amount is disbursed either fully or partially. Periodical interest charged on daily products. These loans can be any one of the following types, Term Loans, Jewel Loan, and Key Loan, Loan on Deposit. Term Loan includes interim cash credit pending sanction of term loans and installment credit. The installments can be paid back either fully or partially within the due date. Failing which penalty interest is collected from the customer. This system also handles the Security aspect, limit details for each customer, stock register, history details, insurance details, standing instruction processing, interest calculation, nursing, suit file, write-off particulars, and also used to taking various reports like recall/remainder list, RBI reports, advises.

This system has four major loans type, (i.e.) Term Loan, Jewel loan, Loan on Deposits and Loan on Produce. The purpose of the loan or Pledge or Hypothecation of different item segregates these types. For example if the loan is called jewel loan the security is Pledge of Jewels. All other purpose like Housing, Personal, Consumer and Education loans are comes under Term loan category. And the trial balance will take different by type wise. And also in this system having all statements, Ledgers and Periodically interest calculation facility.

As a Senior Analyst Programmer, was responsible for the following:

· System Study, System design and Development
· Test case preparation / testing
· Functional Documentation
· Preparation of user documentation

Environment: MS-DOS under Novell Netware, MF COBOL

XII. Project: DEPOSIT SUB-SYSTEM

July 2000 – January 2001

If the public deposits in bank are kept for a particular period, then the amount will be calculated at a particular rate of interest, the amount is repayable on expiry of certain period along with interest and such deposits are called Term deposits. This module consists of all the deposits viz. FIXED DEPOSITS, RECURRING DEPOSITS AND CUMULATIVE DEPOSITS.

In Fixed Deposits bank receives money from the public for a particular period at a particular rate of interest. The interest amount will be calculated as simple interest method, and the maturity amount will be given to the customer after the expiry of certain period. In Recurring Deposits, a customer deposits his money in installments. After the payment of all installments, then lumps amount is given to the customer after the maturity. In Cumulative Deposits scheme, a bank receives money from the public and keeps it for a particular rate of interest for a particular period. The interest amount will be calculated and credited to the party account at the end of every financial year-end and the new amount will be the principle amount for the next year.

As a Senior Analyst Programmer, was responsible for the following:

· System Study, System design and Development
· Test case preparation / testing
· Functional Documentation
· Preparation of user documentation

Environment: MS-DOS under Novell Netware, MF COBOL

XI. Project: IN-OPERATIVE SEGRIGATION SUB-SYSTEM

April 2000 – June 2000

Some of the accounts may not have transactions for many years. Those accounts will come in every Friday trial balance which causing waste of stationers and tallying becomes headache. So for maintaining these In-operative accounts this system helps to move the accounts that are not operated for some years to separate files. This system will segregate all the inoperative accounts of Savings Bank accounts and Current Accounts. When an account is again coming into operations that will be moved from inoperative master to original master. Separate interest calculation, Trial Balance facilities are given to this system.

As a Senior Analyst Programmer, was responsible for the following:

· System Study, System design and Development
· Test case preparation / testing
· Functional Documentation
· Preparation of user documentation

Environment: MS-DOS under Novell Netware, MF COBOL

X. Project: SAVINGS SYSTEM SUB-SYSTEM

November 1999 – March 2000

In Savings Account, the customers can deposit/withdraw money based on his abilities and requirements. The advantage of this savings bank account is that the customer will be benefited by the interest for the savings he has made. Different types of Savings a/c are Minor, Joint, Minor joint, NRI etc., Modules include Account opening, closing, Product calculation, Interest calculation, Reports such as Trial balance, Ledger, Statement. Facility for inquires the master details and transaction details. This system handles on-line activities like maintenance of master, passing voucher transactions, transfer of accounts, maintenance of cheque books issue/stop and master inquiry, Product calculation, Interest calculation, Interest crediting for both public and staff accounts is also done. Separate module for segregation of In-operation accounts is done.

As a Senior Analyst Programmer, was responsible for the following:

· System Study, System design and Development
· Test case preparation / testing
· Functional Documentation
· Preparation of user documentation

Environment: MS-DOS under Novell Netware, MF COBOL

IX. Project: VOUCHER TRANSACTION SUB-SYSTEM

June 1999 – October 1999

Voucher transaction sub system is the heart of IBS. In this subsystem, we have linked all subsystems such as Savings, Deposit, and Loans etc. In day-to-day transaction, Credit and Debit made between the subsystems and individual accounts through this subsystem. Branch transactions are adjusted, monitored and controlled by the controlling officer, which controls the transactions.

As a Senior Analyst Programmer, was responsible for the following:

· System Study, System design and Development
· Test case preparation / testing
· Functional Documentation
· Preparation of user documentation

Environment: MS-DOS under Novell Netware, MF COBOL

VIII. Project: Year 2000 Conversion

November 1998 – May 1999

Date Fields were modified to 8 digits from 6 digits in order to accept the date in the format of DD/MM/YYYY instead of DD/MM/YY (e.g. 2000 instead of 00) both in file structure and variables declared in the entire IBS system which includes the subsystems Loans, Deposits, Demand Draft, Clearing, Savings etc., Also Migration Programs have been developed to convert the existing data, which are available in Direct Access Storage Device using Fixed Window Technique.

In this system the date field length is increased and Migration Programs are developed for converting the existing data. The files are available in Direct access storage device, which is possible to convert. We used fixed Window Technique for this process.

As a Analyst Programmer, was responsible for the following:

· System Study, System design and Development
· Test case preparation / testing
· Functional documentation

Environment: MS-DOS under Novell Netware, MF COBOL

Organization: M/s. Keystone Software

VII. Project: EMS - EVENT MANAGEMENT SYSTEM (Precision Events Inc, San Francisco, USA.)

August 1998 - October 1998

The Precision Events Inc. is Event Organizer for Christians Functions. The Main Objective of the system is automated the Buying, Selling and Refund of the Tickets. The System generates all transaction and MIS reports.

As a Analyst Programmer, was responsible for the following:

· System Study, System design, Development and Testing
· Designed the Screens
· Designed the Tables in Ms-Access

Environment: PC Pentium, Windows NT, Visual Basic 5.0 and Ms-Access.

VI. Project: MMS - MATERIAL MANAGEMENT SYSTEM (Madras Hydraulic Hose (P) Ltd.)

March 1997 - July 1998

This System is developed for MADRAS HYDRAULIC HOSE (P) LTD. This Company is the pioneer in manufacturer of Stainless Steel Flexible Corrugated Hoses.
This System covers the following areas:

Purchase Management:

The Purchase Management module efficiently monitors Purchase requisitions, Inquires, Quotations, Purchase orders and tracking pending order supplies and follow-ups. It ensures that status of purchase order is maintained on-line and provides information to other departments.

Stores Management:

This Module takes care of effective inventory management by regulating the process of receipt and issue of items at stores. The system caters to multiple stores locations both in manufacturing and made available-stock/distribution environments. It is designed in such a way that no item can be received or issued from stores without authorized data.

Production System:

This system is used for calculating the production for various processes in the plant. It calculates the efficiencies of machines and workers who are working on it. It also helps the production planning and Control department to plan for the next fortnight. The incentives earned by the worker are calculated from this system. It gives information about the WIP system like the production for the defined processes. It also calculates the wastage at each stage of the Production transactions. It gives input/output matching, stock evaluation & waste comparison with standard / company norms.

Sales System:

This system is mainly used to generating invoice. It also having sale note preparation, Delivery Challan preparation and Invoice preparation. The single or multiple DC is generated for each sale note. The DC is generated in the Sales department.
In Material Management System generates Various Reports as per User Needs

As a Analyst Programmer, was responsible for the following:

· System Study, System design, Development and Testing
· Designed the Screens

Environment: PC Pentium, Ms-Dos and FoxPro.

V. Project: FDS - FIXED DEPOSIT SYSTEM (Protchem Industries India Ltd.)

July 1996 - February 1997

This system is capable of handling deposits of various Schemes Viz., 6 months, Cumulative and Non Cumulative. It handles on line activities like new FD creation, Ledger creation, Renewal of FD’s etc. It includes financial year accounting and income tax deduction.
It gives reports on various occasions like Temporary Receipt, Fixed Deposit Main Receipt, Ledger Cards, Interest Warrant Register, Renewal Advice, Repayment Advice etc. as main. Also having New FD list, Renewal FD list, Partially paid FD list, Closed FD list, Matured FD list etc.

As a Analyst Programmer, was responsible for the following:

· System Study, System design, Development and Testing
· Designed the Screens

Environment: PC Pentium, Ms-Dos and FoxPro

Organization: M/s. S. Sm. Softwares

IV. Project: JMS - JEWELLERY MANAGEMENT SYSTEM (Somasundaram Chettiar Jewellery Mart (P) Ltd.)

October 1995 - June 1996

Jewellery Management system maintains various transactions for day to day activities of Jewellers. This System Contains Purchase, Sales, Accounting and Gold Smith transactions.

Gold or Ornaments are purchased from supplier or some other customer. Then Purchased ornaments are entered in Stock and system gives Serial Number for every ornament. Purchased Gold is given to Goldsmith for making of Ornaments as per the customer requirements.

The Sales is made by two ways, through order or ordinary sales. An ordinary sale, asking the Order numbers, selects the ordered ornaments and directly prepares the voucher and bills. It takes the name of the buyer, address and selects ornaments according to the buyer needs. In both sales stocks is decreased accordingly.
In accounting the customer may have dues. Those dues are directly updated in customer ledger at the time of preparing bills. In Goldsmith transaction, wages are calculated, calculated wages are maintained, to give on request of Goldsmith. Regarding fund day to day activities are entered in daybook transactions and ledger is updated to corresponding head.

As a Programmer, was responsible for the following:

· Understanding the Specification, Designing the Screens, Development and Testing

Environment: AT-486, Ms-Dos and FoxPro

III. Project: SMS - SHARE MANAGEMENT SYSTEM (S. Sm. Shares)

May 1995 - September 1995

This System handles share purchasing and selling. Share is purchased from a Customer or Stock Exchange and Sold to some other customer or Stock Exchange. It maintains Contract Register for Customer, Inward and Outward Register of Certificate, daybook and Ledger. It also generates various reports according to the user needs.

As a Programmer, was responsible for the following:

· Understanding the Specification, Designing the Screens, Development and Testing

Environment: AT-486, Ms-Dos and FoxPro

II. Project: CMS - CHITFUNDS MANAGEMENT SYSTEM (S. Sm. Chitfunds)

January 1995 - April 1995

In the Chitfunds System, there is a need to handle group of chits in various installments (i.e.) Group - 20 installments, Group B – 25 installments etc. This system maintains Group Master, Customer Master. This system also handles online receipt and payment voucher. This system also maintains Chit daybook and ledger for every group, daybook and Ledger. This system generates lot of reports like group wise report, Installments wise report, etc.

As a Programmer, was responsible for the following:

· Understanding the Specification, Designing the Screens, Development and Testing

Environment: AT-486, Ms-Dos and Foxpro

I. Project: FAS - FINANCIAL ACCOUNTING SYSTEM (S. Sm. Finance (P) Ltd.)

May 1992 - December 1994

In the FAS, handles both Deposit and Loan System.
They are collecting deposits from customers and they paid interest at a specified rate. This system covers deposits activities like opening, transfer, renewal, tax deduction, premature renewal, automatic renewal and closing of deposits for Fixed Deposits. The system also allows accumulation of deposit transactions, interest payment and interest calculation periodically for the deposit accounts.

They were gives loans on Specified interest rates and interest calculation. This system covers all the Loan operations like Customer Maintenance and Loan Maintenance. Processing like Closing, Interest Calculation and Other charges debiting are also available. Reports like Trial Balance, Ledger, Statement, Debiting advice and other due reports can be taken.

As a Junior Programmer, was responsible for the following:

· Understanding the Specification, Designing the Screens, Development and Testing

Environment: AT-486, Ms-Dos and FoxBASE

PERSONAL DETAILS

Sex : Male
Date Of Birth : 04-05-1974
Address : 854, LIG - II, Velachery Housing Board Colony,
Velachery, Chennai – 600 042.
Passport Details : V490345 / Valid up to : 24-10-2005
Contact Numbers : Off. - 091-44-24912485, 24915833
Res. - 091 – 44 - 22553689
E-mail – Address : mariappan_ts@yahoo.com