Krishnamoorthi
Muthu Subramanian
Blk. 10C, Braddell Hill
#08-11, Braddell View
Singapore 579722.
) 90079241
( 63544879 (Res.)
7 k_muthu_s@yahoo.com
_______________________________________________________________
Objective
Young, pragmatic and analytical with a zeal to make it big in the world
of advanced computing.
Personal Strengths
·
Good problem solving skills
with clarity in finding customers requirements.
·
Good team player with an
innate ability to carry the team along.
Qualification
Bachelor of
Commerce (19951998) in Annamalai
University.
Oracle
Certified Professional - Oracle 9i
Personal Details
Aged 29 years, Single,
Singapore PR - Indian Passport Holder .
Training
Attended
Oracle 9i DBA - SQL Star International in 2002
Oracle 8 DBA - Radiant
Software Limited. in 2000
Dip. in
RDBMS - Software
Solutions Integrated in 1998
Adv Dip. in Systems Management - NIIT Dec 94Nov 97
Work Experience
Webecome pte .ltd
(May-2003
till date)
Consultant
to Opentech Networking Pte Ltd. Singapore
Globesoft,Singapore
(Mar-2003
- Apr-2003)
Consultant
to NEC ,singapore
Software Consultant Freelance
(September 2002 February
2003)
Globesoft, Singapore
(16 Oct. 200014 June 2002)
Consultant
to StarHub Pte Ltd, Singapore
BPL Cellular
Ltd, Coimbatore, India
(24 Mar. 1997 - 13 Oct. 2000)
Systems
Engineer
A joint venture of BPL Cellular Holdings and US West -
Media One Inc., of US.
Raj Computer Systems, Coimbatore,
India
(Dec
1995 Jan 1997)
Faculty/Programmer
Vishnu Lakshmi Traders, Coimbatore,
India
(Dec
1991 Mar 1994)
Data Entry Operator
A
leading Cotton merchant and Yarn trader in Coimbatore.
Programming languages used
Cobol, ANSI
C, TURBO C, Pascal
Software
Packages/Tools/Databases
Sybase 4.1, Oracle 7.x,
Oracle 8, Oracle 8i,Oracle 9i, TOAD
DBA Tool , Discoverer, Developer/2000, Reports,Business Objects ,Informatica, MS-Access
2.0, MS-Access 7.0, VB 6.0, Crystal Reports Sql,Pl/Sql,Sql Loader,Sql talk,Sql
plus.
Operating systems
DOS, Windows 95,Windows 98,
Windows-NT, Windows 2000, Dec Unix 4.2d, Sun Solaris 2.6.
Servers Used
Digital Polaris, Berkley Unix (Internet Server), DEC Alpha 2100, DEC
UNIX 4.2d, DEC Alpha 1200, DEC Alpha 4100, DEC UNIX 4.2d
Project Details
Project 1
Discoverer Adminstrator
·
Involed in creation of report in administrative
modules
·
Involed in development
of reports in administrative and desktop edition.
Client Opentech, Singapore.
Period May 2003 Jun 2003.
S/W
packages Oracle 8.x,Discoverer 4i.
Project 2DBA
and Developer
·
Development of
software using pl/sql.
·
Creation and maintenance of database in development server.
Client NEC , Singapore.
Period Mar 2003 Apr 2003.
S/W
packages Oracle 9.x,Sql, Pl/Sql.
Project 3 Freelance
Period September
2002 February 2003
S/W
packages Oracle 9.x,Oracle 8.x, Developer 2000, Reports,Sql, Pl/Sql,Sql Loader.
The job involves
·
Back-end process of all CDR (Call Detail Record) and tap files (roaming
calls).
·
Ensure that all CDRs & TAP file processed successfully.
·
Create new roaming agreements in the UAT server and the production
server.
·
Configure new patches in UAT server and production server.
·
Generating reports to the system users for analysis.
Client StarHub Pte Ltd, Singapore.
Period Oct 2000 June 2002
Operating
System Sun Solaris.
S/W
packages Oracle 7.x, Developer 2000, Reports,Sql,Pl/Sql,Sql Loader.
Project 5 Oracle DBA (Database
Administrator)
The job involves
·
Installation of Oracle software.
·
Creation and maintenance of database.
·
Assist and advice during object creation to user.
·
System response monitoring for all production machines for 24 hours.
·
Database growth monitoring which includes all table-spaces and rollback.
·
Configuration of database control parameters towards tuning database
performance.
·
Review of database for fragmentation, errors and correcting the same
·
Ensuring database performance.
·
Based on transaction volumes and database size growth, analyse and advise
on capacity planning.
·
Develop necessary tools for monitoring and maintenance of database.
·
Coordinating with users of Oracle system administrators
DEC Alpha 2100 DEC UNIX
4.2d Oracle 7.X.
DEC Alpha 1200 DEC UNIX
4.2d Oracle 7.X.
DEC Alpha 4100 DEC UNIX
4.2d Oracle 7.X.
Production Database -
30 GB
RTX Database
40 GB
Prepaid Database
11 GB
MIS Database
26 GB
Test Database
12 GB
Client BPL
Cellular Limited
Period March
1997 October 2000
S/W packages Oracle 7.x,
Developer 2000, Reports,
Discoverer
Operating
system DEC UNIX 4.2d
Hardware DEC
Alpha 2100
In-charge of
roaming coordination for all Roaming activities. The job involves
·
Creating
new roaming Agreements
·
Testing in UAT
environment and implementing in Production environment.
·
Coordinating
with the clearing house ( Satyam ) for all the roaming file transfer.
·
Generating
roaming reports for users.
·
Involved in
migration team from version BSCS 3.03 to BSCS 5.21.
Client BPL
Cellular Limited
Period March
1997 October 2000
S/W packages Oracle 7.x,
Developer 2000, Reports,
Discoverer,
MS-Excel.
Project 7 - MIS (Management
Information System)
Generate all types of reports to the management for
their information from BSCS. Using Report 2.5, SQL Talk & SQL Plus. These
reports can be periodic or ad-hoc as per user requirements.
Client BPL
Cellular Limited
Period March
1997 October 2000
S/W packages Oracle 7.x,
Developer 2000, Reports,
Discoverer,
MS-Excel,Sql,Pl/Sql,Sql Loader.
Hardware DEC
Alpha 2100
Operating
system DEC UNIX 4.2d
Projects 8 - Front-end
for PIH
Front-end for PIH (Payment Input Handler)
which is implemented in all the branches and it is connected to Head Office.
Period
1
month
Client BPL
Cellular Limited
Software
Used VB 6.0
Role
Design,
Development and Implementation.
Project 9 - Others
credit charges
A system to keep tab of the
OCC passed for GC(Global Card -
consists of all networks) and SC(South Card - Tamilnadu, Kerala and
Chennai) customers aiding in reconciling the same with BSCS System on a daily
basis.
Client BPL
US WEST CELLULAR LTD
Software Used Oracle
7.x, Developer 2000 & Reports 2.5.
Role Design
,Coding and Implementation
Project 10 - Inventory System
System for generating Invoices for Handset Sales,
Deposits,
Sales tax reports, Model-wise Handset Sales,
Branch-wise sales. Also used for Stock Maintenance, Invoice Printing &
other reports. This system is installed in all the branches of Tamilnadu.
Client BPL US WEST CELLULAR LTD
Period 3 Months
Software
Used MS-Access 7.0, Windows
-95
Role Design, Coding and
Implementation
Project 11 - Payroll System
A modular system to tap resources of employees aiding
in calculating and printing pay slips. Consolidated reports, ESI, PF, Loans are
some of the reports of the payroll system.
Client BPL US WEST CELLULAR LTD
Period 2 months
Software
Used FoxPro 2.6a
Role Design, Coding and
Implementation
Project 12 - Receipts &
Inventory System
System takes care of collection of payments for
Handset sales etc, issuing receipts for the sale incurred, issuing invoices for
the handset sales, maintaining stocks of handset. Reports on all modes of
payments, sales of handsets & sales tax reports.
Client BPL US WEST CELLULAR LTD
Period 3 Months
Software
Used FoxPro 2.6a
Role Design ,Coding and
Implementation
Project 13 - Bill Collection
Program
In this program collection of Bill (Invoice) payments
like Cash, Cheque/DD & Credit Card payments are entered. Daily Reports can
be generated for reconciling payments made to bank as well as updating the BSCS
system. Cumulative Collection reports can be viewed and printed daily and
month-wise as well as the total collections as on date. This system is
installed in all the branches in Tamilnadu.
Client BPL US WEST CELLULAR LTD
Period 3 Months
Software
Used Oracle 7.x, Developer 2000,
Forms 4.5 &
Reports
4.5
Role Design ,Coding and
Implementation
Project 14 Form 16a
Form 16a is printed in this program which is issued
to all our suppliers. In this program, data it entered and reports is generated
for individual suppliers.
Client BPL US WEST CELLULAR LTD
Period 3 Months
Software
Used Oracle, Developer 2000
& Reports 2.5
Role Design, Coding and
Implementation
PIH
is process where payment entries (Invoice payments) are updated through this
module. This module is developed in
Centura
1.5.
Client BPL Cellular Limited
Period 1 month
Software Used Centura 1.5
Role Implementation
Project 16 - Payroll System
Data Capturing, Payslip Printing, Reports generation
are done by this system. Reports like PF, ESI, IT & Attendance.
Client Mehta Cotton Traders
Period 3 Months
Software Used MS-Access 2.0, Windows 3.11
Role Design, Coding And
Implementation