Arul
Sebastian
8/20 Metha nagar main road, AminjiKarai
Chennai - 600 029, India
E-mail: arul_sebastian@hotmail.com
Ph: (91) (044) 3742158
I have 11 years of experience in the field of
Information Technology specializing in the Internet Development, Object
Oriented Programming, Relational Database, Data warehousing, Graphical User
Interfaces and Client/Server architecture.
I have
worked in India for over six years for Patni Computer Systems, E-comm
Solutions, and HCL Technologies.
I have worked in the USA for over three and half years for two companies, Cambridge Technology Partners and HCL Technologies America. I have worked on projects for various clients including Hewlett-Packard, Silicon Graphics, Ryder TRS and LeCroy Corporation.
I have
worked in Belgium for a year with HCL Technologies Belgium, on a client
project in GTech Europe, a company developing software for Belgium and
Netherlands Lottery Systems.
As a
‘Senior Software Developer’ I have worked on Requirement analysis, Design, Data
Modeling, Development, Debugging and Testing, Quality Assurance, Configuration
Management and Documentation of the various phases in a project life cycle.
Technical Skills Summary:
·
RAD – Visual Basic 6.0
·
OLAP – Hyperion Essbase XTD 6.5.1
Educational Qualification:
M.Sc Computer Science, Bharathidasan University, 1990-1992
Projects :
Hospisoft:
Hospital management System which addresses all the major functional areas of
hospitals, provides the benefits of streamlined operations, enhanced
administration and control, better response to patient care, cost control and
improved profitability.
Pharmasoft:
Total pharmacy software that helps pharmacists to effectively use the computer
for complete billing and inventory Management
Diagnova:
Gives all the power that helps the lab to capture the patient’s information,
sample collection, test results, Billing, Report generation and inventory.
Ophthonova:
Created for Ophthalmologist to maintain Patient details & history file,
Optical examinations, Diagnosis, treatment and disposition
Electronic
Medical Records: EMRS helps store all the physical case records after scanning
in a data warehouse. Data can be retrieved based on Patients name, Date of
Discharge, Doctor who attended the patient or disease.
Medical Appointments: Helps the
hospital to maintain the schedules of all the visiting doctors and Doctors can
maintain the schedules of all their visiting hospitals and fix appointments of
the patients.
Scopynova: Gives all the power
that helps the doctor to capture the diagnostic images of the patients through
medical equipments like Endoscopy, Laproscopy and Ultrasound scanners very
effectively with ease.
Tools and
Technologies: Windows 2000/98, SQL Server 2000 and Visual Basic 6.0
Roles and
Responsibilities: Worked as a Project Leader gathering requirements, Design,
Develop, Test, Debug, implement in client locations and document.
HCL Technologies Belgium, Brussels, Belgium, Project Leader, Jan 1999 - Feb 2000
Client:
GTech Europe, Brussels, Belgium - Project: Belgium and
Netherlands Lottery Systems: This system is a set of software components that
implements various functions needed to run a lottery system. The main system is
comprised of three components Online Transaction Processing, Gaming environment
Management system and the GUI front-end. The OLTP system handles the day-to-day
transactions and logging. All financial and Retailer information is kept in
data warehouse. The communications system enables the Lottery terminals to
connect and transact with OLTP component of the Pro Sys. Another system
supports the management of the Lottery and System Products through GUI front
end.
Tools and
Technologies: UNIX, Windows NT, ORACLE 8i, Visual Basic 6.0, C++ and C.
Roles and
Responsibilities: Worked as a project lead implementing Instant Lottery System
and mainly the System Administration, Inventory and Validation modules.
Cambridge Technology Partners, San Mateo, CA, USA, Technical Team Leader, Oct 1997 - Nov 1998
Client:
Ryder TRS, Denver, Co, USA - Project: Enterprise Application Suite: RYDER TRS
departed from its parent company Ryder Systems Inc. and decided to build their
own Truck Rental computer systems. This system is a set of enterprise
applications that are based on a Client/Server model replacing an existing
Mainframe System. Move Management, Customer Care, Dealer Admin, Vehicle
Management Systems, Dealer Processing, Point of Sale and Accounts Receivable
are some of the applications that are part of this enterprise suite.
Tools and
Technologies: UNIX, Windows NT, ORACLE 7 and Visual Basic 5.0.
Roles and
Responsibilities: Involved in the development of Customer care application.
Review the data model using ERWIN, Administer ORACLE database. Build user
interface screens like customer Administration, Customer search, Customer
Mapping, Special Rates, Agreements and Quotes, Dealer management and Security
using Visual Basic.
Client:
Silicon Graphics, Mountain View, CA, USA - Project: Holodeck web Project:
In order to retain and enhance market share in the graphic workstation market,
SGI had taken a new strategic direction. Wintel (i.e., Microsoft Windows
NT/Intel microprocessor) desktop PCs were added to SGI’s Unix-based desktop
product. In order to support the product offer, a web site with state-of-art
e-commerce and community features were developed.
Tools and
Technologies: Microsoft Visual Source safe, IRIX, Windows NT, ORACLE 7,
Netscape Enterprise Server, Dynamo application server, and Trilogy.
Roles and
Responsibilities: Worked as a configuration manager using Microsoft VSS and
Build Manager. Involved in the administration of ORACLE database instances.
Client:
Hewlett Packard Santa Clara, CA, USA - Project: Quest and Quest Plus:
This system is a data warehousing and supply chain management solution for
Hewlett Packard. Test the system for Business requirements and correctness and
accuracy of the results.
Tools and
Technologies: HPUX 10, Windows NT, ORACLE 7, Hyperion Essbase and Visual Basic
4.0.
Roles and
Responsibilities: Fix bugs during system integration and user acceptance
testing. Update and test the DBA scripts for the oracle data warehouse. Debug
and optimize the SQL
Client:
MUSE Networks, Cambridge, MA, USA - Project: MUSE: MUSE is an
Internet based subscription service that helps the business communities to
communicate and share information over a secured channel. This system is being
developed for Shipping Industry Information Directory database and Personal
Internet Manager a tool working with an Internet web browser supporting Java to
provide a window to the virtual communities such as shipping industry. The
system provides facilities to create, search and organize vCards (Business
Cards) in the personal address book. It allows the user to participate in
discussions and create discussion groups. User can participate in Net
Conferencing (audio/text) by using the vCards of the desired person. User can
also receive filtered NEWS depending on his profile.
Tools and
Technologies: Windows NT, Microsoft SQL Server 6.5, IIS, Microline component
Toolkit and Visual J++.
Roles and
Responsibilities: Designed the subscription service as a JAVA applet based upon
a prototype in Visual Basic. Established connectivity to SQL Server database
from JAVA using IIS native protocol called IDC. Involved in the database design
and development of the software.
Client:
LeCroy Corporation, White Plains, NY USA - Project: LAN Monitor: LAN Monitor
is a network - trouble shooting tool for the corporate Local Area Networks. The
data packets travelling through a LAN are captured using an Oscilloscope and
stored in the database. The network administrators can use this data through a
tool to troubleshoot the problems. Also, the performance of the LAN can be
measured using the analysis tool.
Tools and
Technologies: Windows NT, Sybase, Visual Basic and Visual C++.
Roles and
Responsibilities: Designed and developed the used interface using Visual Basic,
Administered SYBASE database as a DBA.
SBT
Professional Series (ODBC Version): This is an up sizing project. The software
was in Foxpro and already available in many operating system/platforms. The
project was started to develop a Client/Server version with ORACLE 7.0 as back
end and FoxPro as a front-end. The inventory module was chosen to serve as a
prototype model.
Tools and
Technologies: Windows NT, Foxpro and ORACLE
Roles and
Responsibilities: Normalize the data structures. Create and maintain table
index, constructs, stored procedures and triggers in ORACLE 7.0. Design and
Develop data population utility for handling the Inventory module.
OFFICE
VISION: This is an Information Management System, Comprising modules for the
control of the manufacturing process. All activities of Purchase, Sales and
Processing are handled. A well-organized data flow between modules reduces data
entry to a minimum. Order acceptance, GRN Requisition, Demand Note, Delivery
note, Invoice Bill, Sales Order, Stock Ledger, Stock statement, stock
valuation, etc. can be produced.
Tools and
Technologies: MS DOS and Foxpro.
Roles and
Responsibilities: Design, analysis and coding the reports specified above.
Implemented FIFO, LIFO and Manual Lot Selection methods.
·
Sex - Male
·
Marital Status - Single