Title:No Title
abpg6m@r.postjobfree.com
Document
Source below
NAME: SITAL SINGH
ADDRESS:
CITY: ROHNERT PARK
STATE/PROVINCE: CA
ZIP/POSTAL CODE: 94928
COUNTRY: USA
EMAIL: abpg6m@r.postjobfree.com
PHONE: 707-***-****
CANDIDATE ID: N/A
CITIZENSHIP: US
Citizen
EDUCATION: Not Entered
EXPERIENCE: Not Entered
WILL RELOCATE: Not Entered
RELOCATION INFO: Not Entered
JOB WANTED: Not Entered
HOMEPAGE:
HOTSKILLS:
ESUME
SITAL SINGH,
333 ENTERPRISE DRIVE # 91,
ROHNERT PARK, CA 94928.
abpg6m@r.postjobfree.com
-13 years of overall experience in Application Software
( More than 11 Months of )
- Development, Feasibility Study, System Analysis, System
Design, Re-Engineering, Quality Control and Implementation.
- Performed Information System Strategic Planning.
- Conducted user training and posses hands on project leadership
background
-5 Years experience as an ORACLE DBA
-3.5 Years as an ORACLE DEVELOPER
SPECIALISATION
- RDBMS: OACLE 7.x ( 7.0,7.1,7.3 ), ORACLE 6.0
- DEVELOPMENT: Developer 2000, Forms (4.5,4.0 & 3.0),
TOOLSReports 2.5, PROC, Menu 5.0, SQL Loader,
PL-SQL, SQL
- Languages: C, Shell Programming
- OS: SOLARIS 2.5 & 2.6, AIX 3.0 & 4.0,
SVR 4.0,
UNIX System III & IV, SCO UNIX, HP UNIX
NOVEL LAN ( 2.0 & 3.11), MS-DOS,
WINDOWS NT
- Hardware: SUN, IBM, UNISYS, HP-9000, PCs
WORK EXPERIENCE
Astral Systems Inc
.California
Since March 1998
Client: NLC
( NEXT LEVEL COMMUNICATION )
The complete network solution provider
company ( unique in the word )
Working on latest technology to provide
VIDEO, DATA & VOICE through
Tele lines.
ROLE: ORACLE DBA
Environment: Oracle 7.3, Developer 2000 ( Forms 4.5 ), PL/SQL,
PROC
Solaris 2.5 and 2.6
Project: Working as a DBA for Production Product to
control the services
provided by Communication company of VIDEO,
DATA and
VOICE Jointly, The Customers are like USWEST,
Star Sight etc.
Activities: - Maintenance of Database
- Estimating Database Size for Customers
- Performance Tuning
- Database Triggers and Procedures,
- Constraints and Indexes.
- Backup and Recovery
- UNIX Kernel Tuning related to ORACLE
Client:
NIFC
( National Interagency Fire Center ) a
department of
( USDA United State Department of Agriculture
)
Project: ICBS ( Interagency Cache Business System )
To control the nation wide Inventory for
fire centers
Role: Hired me as Consultant for development on
Developer 2000
by using Forms 4.5 and Report 2.5.
Due to my past experience in Designing and
DBA advised so many
improvements in Design which proved imaging
enhancement in performance
and then got the opportunity to redesign the
Database.
( Big first achievement in )
Environment : Oracle 7.3, Silver RUN, Developer 2000,Designer 2000,
PL/SQL,PROC, AIX 4.0,IBM RS-6000
Activities: System Study
Re-Designing Database
Estimating database size
Performance Tuning
Data conversion from Older System to New System
Development of GUI in developer 2000
Creating database triggers & Procedures
HERO CYCLES LTD
.INDIAOct-1997 to Feb-1998
World's largest bicycles manufacturing company having collaboration
with HONDA Motor Cycles AND BMW Motor cycles.
Project: Hero Computerization Project
( To computerize the Hero Cycles and
Associated
Companies )
Role: ORACLE DBA/PROJECT LEADER
Environment: Oracle 7.3 & 7.1, Developer 2000 ( Forms 4.5 & 3.0 ),
Reports 2.5, PLS/SQL, PROC, AIX 3.0, IBM
RS-6000
Clustered three systems with separate
segments at one
storage location and networking with Windows
NT and
other associated Companies
Project: This project involved computerization in the
following areas including their integration:
- Sales Management System(SMS)
- Material Management System(MMS)
- Financial Management System(FMS)
- Purchase Management System(PMS)
- Production Planning & Control ( PPC )
- Human Resources Management System (HRMS)
Activities: As an Oracle DBA
- Setting of database i.e.
. Maintenance of tablespaces i.e. Creating,
RResigning, Adding Datafiles etc.
. creating dropping Indexes and maintain
Integrity and Referential constraints
. Maintenance of rollback Segments i.e.
Creating & Refreshing
. Managed storage parameters while creating
objects such as tablespaces,
. tables and rollback segments etc.
. Calculated storage requirements while
creating objects such as tablespaces,
tables and rollback segments, and adding
data files etc.
. Performance Tuning - Database, Application
and UNIX Kernel tuning
. Managed multiple instances
. Adopted a backup strategy ( Archive Log )and
managed
security and controlled user access
D.B. Size: 15 GB
Tables: 415
Achievement : The project was assigned to me for
implementation which was not get successful
from last more than one year due to design
bugs and poor database control and
also development bugs within less than six
months time I become successful
to set right the whole thing and got a PRIZE
from Chairman of the Company
RALSON INDIA LTD.INDIAOct-1993 toSept-1997
India's Largest bicycles tires, tubes and parts manufacturing Company
Project: Ralson Computerization Project
Job Title: Manager Systems
Role: ORACLE DBA/PROJECT LEADER
Environment: Oracle 7.3 & 7.1,Developer 2000 ( Forms 4.5 & 3.0 ),
Reports 2.5,PLS/SQL, PROC, SOLARIS 2.5, SUN E-3000,
Novel LAN 3.11, MS DOS & FOXPRO 2.5
Project: This project involved computerization in the
following areas including their integration:
- Sales Management System(SMS)
- Material Management System(MMS)
- Financial Management System(FMS)
- Purchase Management System(PMS)
- Production Planning & Control ( PPC )
- Human Resources Management System (HRMS)
- Export Documentation System(EDS)
- Costing & Budgeting
- Contribution System
- Share Accounting System
- Branch Controlling System ( Software On MS-
DOS & Foxpro to control Nation wide 17 Branch
Offices and data conversion and storing on LAN
and Oracle database at Head office for MIS )
- Management Information System (MIS)
Activities: As an Oracle DBA
- Oracle Installation
- Upgradation and Conversion from Oracle 7.0 to 7.3
- Installation and maintenance of two version of
Oracle
7.1 and 7.3 on one server to use the existing
development of Forms 3.0 and PROC
- Setting of database i.e.
. Maintenance of tablespaces i.e. Creating,
RResizing, Adding Datafiles etc.
. creating dropping Indexes and maintain
IIntegerity and Referential constraints
. Maintenance of rollback Segments i.e.
CCreating & Refreshing
. Managed storage parameters while creating
oobjects such as tablespaces,
. tables and rollback segments etc.
.. Calculated storage requirements while
ccreating objects such as tablespaces,
tables and rollback segments, and adding
data files etc.
. Performance Tuning - Database, Application
aand UNIX Kernel tuning
. Database defragmentation
.. Managed multiple instances
.. Adopted a backup strategy and managed
ssecurity and controlled user access
- Interfacing with other software like Novel LAN,
MS-DOS, Widows
- TCP/IP to configure clients
- SQL NET
: AS A PROJECT LEADER
- Performed Information System Strategic Planning Study,
- System Analysis and determined specifications
- Designed, developed, implemented and performed system
testing
- Interacted regularly with users to re-engineer the
software to their requirement and conducted user
training
- Finally to keep pacewith the latest technology and
emerging requirements
D.B. Size: 15 GB
Tables: 395
Achievement:I got the opportunity of this project when the
organization only
Payroll system running on Novel LAN with
FOXBASE and rest
every thing was manual due to my
extraordinary efforts and skill
I got the status to make that organization
The BEST COMPUTERISED
ORGANISATION in State because The only
organization
which had online & integrated all the
application to control the whole
organization and remote branch offices also
running on Oracle 7.3
Solaris 2.5 and SUN E-3000.
OSWAL SPINNING & WEAVING MILLS LTD.INDIAJuly-1992 to Sept-1993
Leader in Woolen and Yarns Spinning & Weaving in India
Project: Computerization of whole Company at corporate level
Role: ORACLE DBA/PROJECT LEADER
Environment: Oracle 6.0, Forms 3.0, PLS/SQL, PROC,UNIX
SVR 4.0,UNISYS U-6000/65
Project: This project involved computerization in the
following areas including their integration:
- Fixed Deposit System(FDS)
- Sales Management System(SMS)
- Financial Management System(FMS)
- Personnel Management System (PMS)
- Contribution System(CS)
- Share Accounting System(SAS)
- Management Information System (MIS)
Activities: As an Oracle DBA
- Oracle Installation
- Setting of database i.e.
. Maintenance of tablespaces i.e. Creating,
RResizing, Adding Datafiles etc.,
. Creating dropping Indexes and maintain
IIntegrity and Referential constraints
. Maintenance of rollback Segments i.e.,
CCreating & Refreshing
. Managed storage parameters while creating
oobjects such as tablespaces,
. tables and rollback segments etc.
.. Calculated storage requirements while
ccreating objects such as tablespaces,
tables and rollback segments, and adding
data files etc.
. Performance Tuning - Database, Application
aand UNIX Kernel tuning
. Database defragmentation
.. Adopted a backup strategy and managed
ssecurity and controlled user access
: AS A PROJECT LEADER
- Performed Information System Strategic
Planning Study,
- System Analysis and determined specifications
- Designed, developed, implemented and performed
system testing
- Interacted regularly with users to re-engineer the
software to their requirement and conducted user
training
- Conversion from COBOL to Oracle RDBMS
D.B. Size: 1200 MB
Tables: 190
JAGATJIT INDUSTRIES LTD.INDIAJul-1987 to Jun-1992
Asia's biggest under one roof distillery
Project: Computerization of whole Company
Role: Developer's Team Leader
Environment: UNIFY, SQL, PROC, SQL RPT, SQL FORMS,UNIX SVR4.0,
UNISYS U-6000
Project: This project involved computerization in the
following areas including their integration:
- Fixed Deposit System(FDS)
- Sales Management System(SMS)
- Financial Management System(FMS)
- Inventory Management System (IMS)
- Personnel Management System (PMS)
- Milk Procurement System(MPS)
- Maturation Stacking System(MSS)
- Finished Stock Stacking System (FSSS)
- Contribution System(CS)
- Share Accounting System(SAS)
- Management Information System (MIS)
Activities: As a Designer and Developer Team Leader
- Performed Information System Strategic Planning Study,
- System Analysis and determined specifications
- Designed, developed, implemented and performed system
testing
- Interacted regularly with users to re-engineer the
software to their requirement and conducted user
training
- Conversion from old COBOL and BASIC to UNIFY
RDBMS
JASWANT INDUSTRIAL CO. PVT. LTDINDIAJan-1996 to Jun-1987
Data Processing Center for clients
Project: Development of software to meet out the requirement
for data processing of different clients.
Environment : HCL Workhorse-II running on propriety O.S,BASIC,COBOL
Role: Programming in BASIC & COBOL to meet out the
requirement of Clients.
EDUCATION
-BACHELOR OF COMMERCE FROM GURU NANAK DEV UNIVERSITY AMRITSAR
(INDIA)
-POST GRADUATE DIPLOMA
IN PERSONNEL MANAGEMENT
& INDUSTRIAL RELATION
FROM GURU NANAK DEV UNIVERSISTY AMRITSAR (INDIA)
-DIPLOMA IN COMPUTER PROGRAMMING
FROM REGIONAL COMPUTER CENTRE CHANDIGARH (INDIA) &
APTECH LUDHIANA (INDIA)
DATE OF BIRTH: OCT.10,1960
NATIONALITY: INDIA
WORKING STATUS IN : H1-B
QUALIFY TOWORK: REQUIRED H1 TRANSFER