Pinjakan (Pinja) Sachithananthan
Certified Oracle Specialist

pinjakan@yahoo.com

OVERVIEW
8 years experience in Architectural Design, Development and Implementation
More than 6 years of Database Administration in Oracle (7.3 to 9i) in both Windows and UNIX
Extensive Oracle: Backup & Recovery, RMAN, Tuning, Replication and Configuration
Proven experience in Oracle Developer (2000 ? 6i), Programmer 2000 and Designer 6I
Extensive knowledge on data access tools like PL/SQL, Developer and TOAD
Oracle 9i Real Application Cluster including Data Guard (physical and logical)
Oracle 9i Replication: Snapshots and Multi-Master Replication
9iAS/Oracle Lite administration and configuration
Strong backend development skills in Oracle, SQL Server 6.5/2000
Excellent skills in Web Technologies like VB Script, Java Script, HTML and DHTML
Worked on the UNIX technologies like SCO Unix, IBM-AIX, HP-UX, Solaris and Linux systems
Course Author / Trainer / Mentor for database technologies; extensively worked with Oracle Corporation providing consulting, training and support.

EDUCATION

Masters in Computer Science 1994 - 1996
A.V.V.M. Sri Pushpam College, Bharathidasan University, India.

Bachelors in Computer Science 1991 - 1994
P.S.G. College of Arts and Science, Bharathiar University, India.

TRAINING / CERTIFICATIONS

Oracle Certified DBA ( 8i & 9i )
Oracle Certified Developer 6i
Diploma in RDBMS

TECHNICAL SUMMARY

Installed / configured Oracle databases on HP-UX, Solaris, AIX, Linux and Windows systems
Installed and configured Oracle Management Server (OMS) for the clients
Installed and configured 9iAS (Internet Application Server) on Linux & Win NT systems
Participated in business-process modeling, data modeling, database design and program flow
Managed multiple databases including: Tuning, Replication, Backup and Recovery
Performed SQL tuning & performance tuning on various sizes of databases
Wrote security packages (monitoring security flaws) and scripts to verify & backup databases
Provided training and guidance in Oracle 8i / 9i to clients / users ? as team-lead
Involved in client/user requirement meetings and discussed solutions
Served as both Project Manager and Database Administrator
Form design, coding structure, front-end screens, backend pkgs and scheduling processes
Migrated the database from Oracle 8 to Oracle 8i
Managed the mirroring of data from the UNIX-based merchant system
Involved in System Analysis, Designing, Programming, Testing, and Implementation

Operating Systems
Windows 3.11, 95/98, Windows NT/2000, Open VMS, SCO-UNIX, HP-UX, Solaris, Linux, AIX

Databases
Oracle 6.x / 7.x / 8i / 9i (8.1.7/9.2.0), Sybase. Informix, Access 2000

Languages
Oracle SQL, PL/SQL & Pro*C, Microsoft SQL, Unix shell scripts, Visual C/C++, VB Script, Java Script, HTML, PL/SQL Server Pages & Cobol

Tools
OEM (Enterprise Manager), Legato NetWorker (Minimal), Oracle Warehouse Builder, Discoverer,
RMAN, MIG utility, 9iAS, Net-8, ODBC, Developer 2000 / 6i, Designer 2000 / 6i, Programmer2000
SQL-Loader, Export-Import, SVRMGR, Toad, and Universal Installer
SQL Server 2000 (DTS and T-SQL)

PROFESSIONAL EXPERIENCE

dB Professionals, Roselle IL Apr '03 - current
Consulting responsibilities include: database administration, software development / deployment and technical consultation on projects, remote administration and on-site / off-site contracts.
Client: GIST, Inc. Chicago, IL Database Instructor
Role: Set-up the Real Application Clusters (RAC) infrastructure and provided high level consulting on planning and implementing RAC Setup on RedHat Linux 2.1 with 2 nodes
Installed and configured RedHat Advance Server 2.1 and configured the common SCSI storage to create RAC Instances.
Installed and configured Oracle Cluster Manager (OCM) on Linux
Installed, created and configured 9.2.0.2 RAC databases on Linux
Setup Oracle Enterprise Manager (OEM) to manage RAC
Trained DBAs on RAC, Data Guard, SQL and PL/SQL, Oracle core Administration, RMAN and Performance tuning.
Environment: RedHat Linux Advance Server 2.1, Oracle 9.2.0.2, OEM, OCM 2.1

Client: MedRemote, Inc. Chicago, IL Database Specialist
Role: Provided remote services and support
Installed, created and configured 9i (9.2.0.2) databases on Linux
Setup Data Guard on 9i Rel. 2 database in the test environment with two standby databases in different locations.
Maintained and Troubleshot Data Guard in the production environment
Managed Data guard using Oracle Enterprise Manager (OEM)
Mentored and Transferred knowledge to the Client DBAs
Environment: Red Hat Linux Advance Server 2.1 (7.3), Oracle 9.2.0.2, OEM

Oracle Corp.(Teymi HF), Iceland Mar '01 to Feb '03

Project: Oracle Database Configuration, Administration and Specialist Support
Teymi HF has a big customer base, handling all the support for Oracle Tools & Databases in Iceland. Support included Installing and configuring new databases as per application requirement, administering, maintaining, troubleshooting, Database backup/recovery and applying the required patches / upgrades to the existing databases. The work also included technical support to the developers and custom application interfaces.
Role:
Installed / configured Oracle databases on HP-UX, Solaris, AIX, Linux and Windows
Installed and configured Oracle Management Server (OMS) for the clients.
Installed and configured 9iAS (Internet Application Server) on Linux & Win NT
Provided technical specialist support on Oracle to various client in eastern Europe
Worked extensively with clients/users on interfacing custom applications
Participated in business-process modeling, data modeling and database design
Managed multiple databases duties: tuning, replication, backup and recovery
Performed SQL tuning & Performance tuning on various sizes of database
Wrote Security check package to monitor any security flaw and scripts to verify & backup databases
24/7 technical support on databases and tools including debugging
Provided training and guidance in Oracle 8i / 9i to clients / users
Environment: Oracle Databases (8, 8i and 9i), PL/SQL, Designer 2000, Metalink, WebIV, OTN, SQL Navigator, RMAN, Legato NetWorker, and Oracle Tools on Unix (HP-UX, Solaris, Linux) & Win NT.


Nikko Computer Systems (Singapore) Pte. Ltd., Singapore Jul '96 to Mar '01

Project: Retail / Supermarket System (Yaohan Best-Denki, Singapore)
The system was developed for a Supermarket to handle and semi-automate most of its processes. The system handles purchase, sales, stock, accounting and imports. The system is integrated with the POS machines and FAX machines for inputs and outputs. It also handles client database and home delivery system. The project comprises of Purchase module, Sales module, Warehouse module, Import module, Interface module and Accounting module.
Role:
Installed / configured Oracle databases on SCO-UNIX, HP-UX, Solaris and Windows
Tuned Databases for performance
Managed multiple databases duties: tuning, replication, backup and recovery
Performed SQL tuning & Performance tuning on various sizes of database
24/7 technical support on databases and tools including debugging
Provided training and guidance in Oracle 7.x / 8 / 8i to clients / users
Led the team of programmers
Involved in client/user requirement meetings and discussed solutions.
Performed form design and coding structure for the project.
Created object libraries and form templates.
Developed packages, stored-procedures and database triggers
Configured network and peripheral interface
Provided training to team members
Environment: Oracle Database (7,8 & 8i), Developer2000, PL/SQL, Designer 2000


Project: Retail / Merchant Management System (Yaohan, Hong Kong)
The system automated the management of retail and wholesale business involving daily transactions, stock maintenance and accounting. It was designed based on the system in Singapore, for the same Japan based international retail business concern. This has been implemented in Hong Kong. The project included Transaction module, POS Machine interface module, Purchase module, Inventory module, Accounting (A/P, A/R and GL) modules, etc?. It comprised more than 100 forms (both GUI and character mode) and 150 Reports. The data is in two languages, Chinese and English and was implemented using two database instances.
Role:
Handled the project in the strength of Project Manager / Database Administrator.
Installed / configured Oracle databases on SCO-UNIX, HP-UX, Solaris and Windows
Tuned Databases for performance
Managed multiple databases duties: tuning, replication, backup and recovery
Performed SQL tuning & Performance tuning on various sizes of database
24/7 technical support on databases and tools including debugging
Provided training and guidance in Oracle 7.x / 8 / 8i to clients / users
Was In charge of a team of two Analyst programmers and four junior programmers.
Met with clients/users and discussed requirements and solutions.
Performed business-process Modeling, data modeling and program flow.
Designed, developed and administered the database.
Coded the backend packages, engines, and scheduling processes.
Provided training / guidance in Oracle tools to the programming staff.
Environment : Oracle Database (7,8 & 8i), Developer2000 (Forms4.5 , Reports2.5), Programmer2000, PL/SQL, Pro*C and Designer2000


Project: Investment / Finance Package
The package was developed for a major private credits and investments company, which had branches in and around South East Asia. The system handled multiple currencies in accounting. It automated the issues like credit limit control, keeping track of repayments and overall maintenance of individual accounts at any point of time. The project was divided into modules such as accounting (A/P, A/R and GL), client management, credit management, investment management and payroll. As the system was implemented in various countries, the database had to be synchronized using remote access service at the end of the day taking into consideration the multi-currency aspect.
Role:
Was the Senior Analyst Programmer / Project Manager in a team of twelve
Was in-charge of all aspects of the database (Installation, Migration & Tuning)
Made backup scripts for the oracle databases.
Had recovered Database to the point-of-crash.
Involved in client/user requirement meetings and discussed solutions
Participated in System Analysis, data-modeling, and system design
Coded the required packages / backend procedures and front-end screens
Designed and implemented the database during the project life-cycle
Maintained the system and database for the client while in transition
Environment: Oracle Database (8 & 8i), Developer 2000 (Forms 4.5, Reports 2.5), Designer 2000, PL/SQL and Pro*C


Project: Internet Home Shopping (E-Commerce)
The system enables shopping and payment through the Internet. It was developed for a leading superstore chain in Singapore. This project was developed in association with UOB (a leading bank in this region) and NETS (Electronic money transfer and cashcard service organization). It consists of Order Module, Payment Module, Database Connectivity Module, Bank Interface Module, and Merchandising Interface Module.
Role:
Took over the project management from former manager.
Interacted with clients to study their requirements and requests.
Migrated the database from Oracle 8 to Oracle 8i.
Maintained the database for the client.
Took care of the mirroring of data from the Unix based merchant system.
Included various packages into the backend to facilitate easier, faster order tracking.
Environment : Visual Basic 6, Java, JavaScript, VBScript, HTML/DHTML, Oracle 8 - 8i, PL/SQL, and Website Pro 2.0 on WindowsNT


GraySoft Computers., May '93 to Jul '96
Chennai, India.

Project: Cold storage Distribution System
The project is a market distribution system developed on Oracle environment, for a cold storage chain in South India, for daily business transactions through their supermarkets in Singapore. The scope of the Project includes converting the existing System on SQL* Forms to Oracle / Developer 2000 platform along with additional features. Their whole business has kept in track through this package, with Oracle 7.3 as RDBMS on VAX VMS with Developer 2000. The system includes Purchase, Sales, Inventory, General Ledger, Accounts Payables / Receivables and Master Management as sub-systems. Also to capture their daily transactions from the POS (Point-Of-Sales) machine.
Role:
Worked on the development and maintenance of Application System.
Involved in System Analysis, Designing, Programming, Testing, and Implementation.
Gathering user requirements, preparing specifications and coding.
Provided User Training to staff at the Head Office.
Environment: Oracle 7.2, Oracle*Forms 4.5, PL / SQL 2.2, Open VMS V6.1 on Windows95 and Windows NT


Project: Leasing and Asset Management system
The system was developed to automate leasing and finance services of a major client in Chennai. It includes modules like Asset management, Leasing management, Credit management and Accounting. The system was implemented in several major cities and inter- connected to each other.
Role:
Worked as a programmer in the development of the project
Assigned to do the Leasing and Accounting modules
Incorporated the screen design and coding for most of the forms in Leasing modules
Developed the internal reports for the Accounting module
Also involved in the installation/configuration of the Oracle Server.
Participated in the design and set-up of the network environment
Environment: Developer 2000 and Oracle7.2 Server on Windows NT


Project: Internal Petty-Cash Management Module
The package was developed for a private banking / financing company, with branches in most of the large towns in India. The module, part of a larger accounting package, automated the issues like teller cash management, daily cash balancing, and keeping track of payments and receipts of cash throughout the day. This had to be done in-line with the other modules, so as to link the module into the overall accounting package.
Role:
Involved in the project development as a junior programmer in a team of seven.
Worked on around 55 forms and 40 reports.
Environment : SQL*Forms, SQL*Reports and Oracle 6 on UNIX


Project: Printing Management System
The system was developed for a publisher dealing in printing and import / export of books. The project was divided into modules such as accounting, import/export management, print-management, inventory and payroll. The developed system was able to generate quotations for print orders when the no of pages / colors, size and type of paper used were given. It also handled quotations for imports/export depending on exchange rate and freight charges.
Role:
Was involved in the project development as programmer in a team of four.
Worked with coding and screen design.
Trained by senior developers in analysis and system design
Environment : Visual Basic, Oracle 7.2 on Windows NT