Site hosted by Angelfire.com: Build your free website today!

                           

 

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 customer’s requirements.           

·         Good team player with an innate ability to carry the team along.

 

 

Qualification

 

Bachelor of Commerce (1995–1998) 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 ’94–Nov ’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. 2000–14 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  2–DBA 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.

 

 

Project 4 - Production Support & UAT  

 

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

 

Server Configuration

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

 

Project 6 - Roaming Coordinator

 

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 

  

Project 15 - Payment Input Handler

 

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