Posted by on February 27, 19102 at 17:52:43:

S.Kalyanaraman 16, Vellala Street,
Purasaiwalkam,
Chennai - 600084
India

Email: calyanram@hotmail.com

Education: University of Madras
------------ Bachelor in Commerce Madras, India 1996

Loyola Institute of Business Administration - IC
Diploma in Compouter Applications Madras, India 1997

National Council for Labour Management
Diploma in Business Adminstration. Madras, India 1998

BrainBench
Certified in Oracle PL/SQL Jan 2002

Computer ProfessionalCourses Attended:
--------------------------------------
Vision Software Private Limited
(An authorized VAR of Informix)
Informix SE, Rapid 4gl
Dec'96 - Feb'97

Igenesis Software Inc.,
Certificate in C
Mar'98

Software Technology International LTd
Certificate in Oracle 8i DBA

Skill Summary Around 5 years of experience as in the field of
------------- application software development. The focus was
mainly on Database Applications and INFORMIX database admin.

Experience in the field of application development Using INFORMIX, RAPID 4GL, POWERBUILDER 5.0/7.0 ORACLE 8.0. I handled many projects as a Programmer/InformixDBA.

ENVIRONMENT
-------------
Operating Systems : DOS, UNIX,WINDOWS 95
Languages : C,C++
GUIs : POWERBUILDER 5.0/7.0, VB
Databases : INFORMIX ODS, ORACLE 8i,
FoxPro 2.6a

Work Summary
---------------

Working as a Software Consultant in Vision Software from
Sep 2002 - till date

Title : Sales and Marketing System
Client : Vision Software Private Limited.
Duration : sep 2002- till date
Work Location : Chennai (India)
Front end : Rapid 4gl
Backend : Informix
Role : Development and Testing.

Project:
-----------

This system is developed for the pharmaceutical engineering company having three sub-companies. It is based on the concept of Customer Relationship Model. It generates and stores the information about complete sales cycle from lead to invoice. The Activity Reporting follows each transaction and then Customer Need Analysis done by customer interface person there is a separate database maintained for each sub-company and each module of each of them. The system consists the mainly three modules viz.; Masters, Pre-order transaction and Post-order transaction

Worked as a Software Consultant in Mastech Malaysia Sdn Bhd.
from Dec 2000 - May 2001

Responsibilities include:
-------------------------
.Tasks included evaluations for performance gain, optimization of existing software, specifying hardware and software purchases, software development and testing, user training and support, supervising the computer operators, and coordinating work loads with the warehouse.
·Used all tools available for database operations and performance tuning like Onmonitor, Server Instance Manager, Onbar, Ontape, Onmode, Onspaces, Onparams, Onstat, Load, Unload, Dbload, Dbunload, Dbexport, Dbimport
·Used all tools in Unix to check the performance like Top,vmstat,iostat,sar,ps
·Individually re-analyse the system, talk to the users and understand the problem faced by them
.Design of Tables,Indexes and Fragmentation.
·Track the existing problem and carefully re-modify the program

Title : Shipment Performance Report
Client : Agilent Technologies sdn bhd.(Malaysia)
Duration : Dec 2000 - May 2001
Work Location : Penang(Malyasia)
Front end : Rapid 4gl
Backend : Informix ODS
Role : Enhancement

"This Project takes care of the shipment done by Agilent Technologies, which in turn takes the datas and generates reports based on the shipments made. In this system the modules which derives measures of type (A,B,B+ ..) which has specific meanings. The reports generated based on this shipment details are helpful in decision making. Ontime shipment details, Late shipment reports are generated. These reports are run through shell scripts which are written and put on cron jobs which will run as soon as the shipment details are entered. All the interface programs are written in HP UNIX shell scripts and scheduled in Maestro

Worked as a Programmer in Vision Software Private Ltd.,
from Mar'97 - Nov 2000

My duties are designing, coding, testing and also performance tuning,
database allocation and administration of existing databases.

Title : Enterprise Management System
Client : HCL INFOSYSTEMS (INDIA) LTD
Duration : MAY 2000 - July 2000
Work Location : Chennai (India)
Front end : POWERBUILDER 7.0
Backend : ORACLE 8.0
Role : Testing.

Responsibilities:
-------------------
Interacting with Project Leader, Module Allocation, Reviewing
Error Checking and maintainenece.

PROJECT:
----------
Enterprise Management System deals with Inventory Management,
Purchases, Sales, Warehousing & Finance. Quality Assurance
Management plays an important role in compeleting package.
As a part of the team which studies the integeration of the
various modules in EMS package. My role involves the following procedures

*update test plans

*Screen design of modules.

*Testing of various modules. (Master Modules)

Screen validation testing, functional testing, volume testing,
boundary testing.

Title : Financial Accounting System
Client : Vision Software Private Limited.
Duration : April 99 - April 2000
Work Location : Chennai (India)
Front end : Rapid 4gl
Backend : Informix
Role : Development and Testing.

Responsibilities:
---------------------
Interacting with Project Leader, Module Allocation, Reviewing, Coding,
Error Checking, Maintenance, Training end users.
· Creation and Granting new roles and privileges
· Object creation and maintenance
· Database performance monitoring and tuning
· Routine database operation (e.g. startup, shutdown)
· Emergency operations like database recovery.
· Export / Import
· Interaction with other groups within the company to implement various product / tools
· Optimized the SQL statements and the CPU utilization of query.
· Use Onstat ,pfread,mpread and top (Unix) tools to monitor the performance of Informix Instance and CPU respectively.
· Use SET EXPLAIN and checked the performance of SQL statements.

PROJECT:
----------
Financial Accounting System deals with mainly with Finance.
Vocuher generation Banking transactions , trial balance ,
Bank reconciliation Statement, Cash flow and
Fund flow statements, Bill of exchange .
Quality Assurance Management plays an important role in compeleting package. As a part of the team which studies the integeration of the various modules in Financial Accounting package. My role involves the following procedures

*update test plans
*Screen design of modules.
*Testing of various modules. (Master Modules)
Screen validation testing, functional testing, volume testing,
boundary testing.

Title : Inventory and Invoice Monitoring System
Client : Vision Software Private Limited.
Duration : December'98 - March '99
Work Location : Chennai (India)
Front end : R4gl
Backend : Informix
Role : Design and Application Development

Responsibilities:
-----------------
· Complete Core Coding and Development in Informix-4gl
· Wrote multiple SQL for data checking, DDL activities, and testing.
· Involved in Performance Tuning of SQL statements.
· Used ONSTAT commands to trap the performance of SQL and system.

PROJECT:
-----------
This package covers the master maintenance of customer products
and vendors. The package does payment and record types of
customers as regular and ordinary customers. In this
inventory module the main feature is reorder level.
It checks the level and prompts to user accordingly.
Based on the mode of payment decided the bill is generated
automatically and segregated by payment as cash, cheques
and credit cards.

* For every transaction stock in hand is prompted
* Various queries regarding stock are produced
* Reports on unmoving products is generated and prompted
* Various reports on daily, weekly, monthly are generated.

Title : Retail Gas Distribution System
Client : Vision Software Private Limited
Duration : June '98 - November'98
Work Location : Chennai (India)
Front end : Powerbuilder 5.0
Backend : Informix
Role : Design and Application Development.

Responsibilities:
--------------------

Object creation and maintenance
Database performance monitoring and tuning
Routine database operation (e.g. startup, shutdown)
Emergency operations like database recovery.
Export / Import
Involved in Performance Tuning of SQL statements.
Used ONSTAT commands to trap the performance of SQL and system.

Project:
-------
This package covers the family details which contains individual
listings of family members. The listing of products are taken
care by the system. Transactions were not allowed by the system on
Sundays. Depending upon the salary of the family, products are issued. If the month has fifth week transactions are not made on that week. Also daily, weekly and monthly reports are generated.

Title : Sales Order System
Client : Vision Software Private Limited.
Duration : January'98 - May'98.
Work Location : Chennai (India)
Front end : Rapid 4gl
Backend : Informix
Role : Design and Application Development

Responsibilities:
-----------------
Performance Tuning of the database.
Creating SQL statements that explored the SYSMASTER database.
Performance enhancement by checking Data Distributions using UPDATE STATISTICS and tuning Virutal Processors (VPs

Project:
---------
Sales Order System is an integration of two modules.
* Inventory Module
* Sales Order Module
This feature performs updating of stock table performed internally.
There are different features in this system such as customer
information, generation of sales quotations for customers,
generation of sales order from partial quotations.
A report on pending sales order will also be generated.

Title :Travel Registration Information
Client :Vision Software Private Limited
Duration :July'97 - December ' 97
Location :Chennai (India)
Front end :Powerbuilder 5.0
Backend :MSACCESS
Role :Design and Application Development

Project
--------

This system provides easy access to the booking details for
a travel agency which books tickets for flights, train and
buses on behalf of customers. This system provides various
reports pertaining to free seats on the flight/train/buses on
any specified route. This system also provides a miniature data
maintenance module to maintain the billing for the customers and
other customization required for the travel agencies with respect
to the client specification.

Personal Profile
-----------------
Date of birth : 30.01.1976
Sex : Male
Nationality : INDIAN
Marital status : Unmarried
Passport Number : A6608313
Valid Upto : 2008

Hobbies :Hearing Indian music and surfing computer
References:Available on request