Project Oracle
Resume:
Title:Research Assistant
*******@*******.***
Document
Source below
NAME: siddiqui, ishaaq
ADDRESS: ***** *** ******* ** ****
ADDRESS2:
CITY: San Antonio
STATE: TX
ZIP: 78233
CANDIDATE ID: 2259529
US CITIZENSHIP: US
Citizen
EDUCATION: Master Degree
EXPERIENCE: 10
WILL RELOCATE: Open
-
JOB WANTED: Any
RATE NEEDED:
TELEPHONE: 210-***-****
EMAIL: *******@*******.***
HOMEPAGE:
HOTTEST SKILLS: Oracle Database 9i, 8i, 7.x, Oracle Express, SQL Server, MS Access,Java,
PL/SQL, Servlets, EJB, C, C++, UNIX C-Shell, Awk, SQL*PLUS,Pro*C, JavaScripts, HTML,Perl
REVISION: 29-OCT-01
YOE: 10
RESUME:
12900 oak terrace drive
San Antonio Texas
78233
(Cell)
*******@*******.***
Work Permit: Permanent US Resident
Objective: Looking for a position to work as Oracle DBA/Software
Engineer/Project
Lead/Sr C, C++/Oracle Developer in Unix/NT environment.
Summary:
Have overall 10 years of experience as Oracle DBA (9i, 8i, 7.x)/ Web
Administrator with
Unix and NT environments and in the areas of Analysis, Design, Development,
Documentation, and Implementation of Systems and Web applications for very
large-scale
databases. My experience encompasses extracting and loading data in Oracle
database,
Database monitoring and problem resolution, Database development, tuning and
administration to include database replication, recovery and backups,
performing Oracle
upgrades and account maintenance, Provide proactive monitoring to prevent
crashes and to
quickly provide problem resolution, Provide customer support and insight in the
best
methods of database, structured programming using Java, Pro*C, PL/SQL,
SQL*Plus, C and
C++. Developing PL/SQL, ODBC, EJB, ECO/Java and CORBA Applications. Have
excellent
communication skills.
Previously working in the Data Warehouse team and developing applications Using
PL/SQL,
H.T.M.L, JAVA Scripts, C, C++ and DBMS_SQL.
I also had an opportunity to work on Oracle express, a multidimensional
database, to
build reports for the General Ledger, i.e., Financials. Most of the
applications were
developed using Object Oriented Tech.
Education:
MS
in Computer Science and Engineering
BS
in Computer Science and Engineering
Awards: Appreciation award from General USAF, Pentagon
Certifications:
Certified Oracle DBA
Certified Developer/2000
Certified Oracle Programmer
Certified RDBMS Developer
Training: Oracle 9i database
Principles of software development.
Developing Complex Database Models
Oracle Administration 1,
Oracle Administration 2,
Oracle Tuning and Troubleshooting
C and C++ programming
Java programming
Technical Experience:
Databases: Oracle Database 9i, 8i, 7.x, Oracle Express, SQL Server, MS Access
Web Servers: 9iAS, Oracle Application Server 4.x, IIS and Fast track server
Client Tools: Oracle Developer, Desighner/2000, and Erwin
Operating system: Sun Solaris OS 5.5.1, HP- Unix 11.0, Sco-Unix, Windows NT,
Windows
2000 and Linux.
Programming Languages: Java, PL/SQL, Servlets, EJB, C, C++, UNIX C-Shell, Awk,
SQL*PLUS,
Pro*C, JavaScripts, HTML, Perl
Utilities: Sql*Loader, Sql*Navigator, Discover, Erwin.
Most of the applications were developed using Object Oriented Tech.
Applications:
Innovative development through Employee Awareness program data System (IPDS)
Cross-Oracle Security/Role Management.
Project tracking And Timesheet System.
Payroll Monitoring System.
Food and Civil Supplies System.
Bank Maintenance System.
Airline Ticketing System.
Payroll System.
Unix Utilities in MS-DOS.
Professional Experience:
Employed as a software consultant responsible for Database designing,
Creating
web cartridges, managing the forms, reports and graphic servers, programming,
testing
and Implementation of systems for the following Clients.
Software Consultant
CLIENT: Society of International Telecommunication and Aeronautics (SITA)
PROJECTS: Fares, BIR, CARGO, and Ticketing (4)
11/2000
-PRESENTPOSITION
: Oracle Database (DBA), Application Server (9iAS) and Developer Server
Administrator.
URL: http://sita.int
http://sitagroup.sita.int
Operating System; Sun Solaris, HP, NCR and NT
This is an open system project for the airlines used store and calculate the
airfares
for all the airlines. I was assigned as the project lead to build this system
from the
beginning. The project was accomplished on time and following were my
responsibilities.
1. Gathered all the project requirements with the users and documented.
2. Designed the normalized data model through Erwin diagram.
3. Developed the project prototype through designer and demonstrated the
users.
4. Proposed the software and hardware requirements to accomplish the task.
5. Installed and configured the oracle 8.1.7 database on the Sun Solaris
box.
6. Tuned the database for its optimal performance.
7. Designed and developed the physical/logical data model.
8. Extracted and loaded the data from the mainframe into the oracle
database
through sql*loader
9. Instructed and involved with the developers while developing the front-
end
application with java and pl/sql utilities.
10. Tuned the application for its optimal performance.
11. Designed, developed and implemented the backup and recovery plan
through veritas
netback up.
12. Provided comprehensive oracle DBA support (24/7)
13. Created instances for development, testing and production.
14. Developed procedures for production database operations.
15. Experienced with oracle utilities like export, import, stored
procedures and
triggers.
16. Experienced with database tools for analysis, reporting and performance
(Toad,
Spotlight and Enterprise Manager)
My Role as Web Administrator:
1. Complete enterprise edition installation of Oracle 9iAS 1.0.2.2 server
on SUN
and NT
2. Install and configure different components like Oracle9iAS Database
Cache,
Oracle9iAS Forms Services, Oracle9iAS Reports Services, Oracle9iAS Web Cache,
Oracle
HTTP Server, Oracle Advanced Security, Oracle XML Developer's Kit, Oracle
Business
Components for Java (BC4J) and more.
3. The above components were properly configured to take effect in
production.
4. Port allocation.
5. Configure the oracle 9iAS to interact with the oracle database.
6. Complete migration from OAS 4.0.8 to Oracle 9iAS
7. Complete installation, migration and configuration in development,
testing and
production environments.
8. Complete configuration of SSL
Environment: Sun Solaris, HP, NT, Oracle 8.1.7, oracle 9iAS
CLIENT: US AIR FORCE, TEXAS.
PROJECT: Innovative development through Employee Awareness program data System
(IPDS)
11/1997
-11/2000POSITION: Oracle Database
(DBA), Application Server (OAS) and Developer Server
Administrator
.
URL: https://ideas.satx.disa.mil (Production)
http://ipds.afmia.randolph.af.mil (Training)
http://idea1.satx.disa.mil (Development/Testing)
Operating System: Sun, HP-UNIX 11.0
About the project:
Developed this project using Oracle developer completely and was deployed on
the web
using Oracle developer server 2.1 and 6.0.
The whole project was designed, developed and implemented in production within
just one
year and was highly appreciated by the general from pentagon for the hard work.
Now in a process of converting this entire application to Java using
Jdeveloper. Responsible for writing server side business logic using Java
servlets, EJB
and Java classes, and creating Java cartridges.
IPDS is an on line web based system which is now worldwide. All the US air
force bases
through out the world are using this application. The process is as follows.
There are
four major modules in this module. The submission, evaluation, award and
administration
modules. The submitter submits an idea by accessing the submission module and
after the
submission is completed it goes to the evaluation module for evaluation of that
idea.
After the evaluation and if it is approved then it will go to the award module
where the
tangible/intangible amount is calculated. All will be notified electronically.
My responsibilities:
1. Was responsible for designing of the overall IPDS system.
2. Designing of the IPDS database model.
3. Developing the IPDS prototype. The prototype was developed using
designer/2000
and oracle application server.
4. Complete installation, configuration and administration of oracle
database.
a. Managing of the database users who are worldwide.
b. Tuning the database.
c. Taking the backups.
d. Database monitoring and problem resolution (24 x 7).
e. Provide proactive monitoring to prevent crashes and to quickly provide
problem
resolution.
f. Provide customer support and insight in the best methods of database.
g. Managing 3 database instances Production, Development and Testing.
h. Provide training to operations staff for off shift coverage.
5. Complete installation, configuration and administration of Oracle
Application
Server.
a. Creating and managing of the virtual directories.
b. Creating and managing of the web listeners.
c. Security administration for the web applications.
d. Creating and administration of Cartridges.
e. Creating new DAD, PL/SQL agents.
f. Installation of secured socket layer (SSL)
6. Complete installation, configuration and administration of
Developer/2000 server.
a. Creating forms reports and graphics cartridges.
b. Deploying the forms, reports and graphic applications on to the web.
Environment:
Database: oracle 7.3.4 and 8i
Web server: oracle Application Server 4.0.8.1
Development tools: Oracle Designer 2.1.2, 6.0 Oracle Developer 2.1,6.0
Operating system: Sun, HP- UX 11.0 And NT server
CLIENT:
GENERAL ELECTRIC, Schenectady, and N.Y.
PROJECT: Cross-Oracle Security/Role Management.
06/97
TO 11/97
POSITION: DBA/Software Engineer
.
Developed detail analysis, design, Data modeling and development of the Cross-
Oracle
Security/Role Management system. This project was developed for The purpose of
security
of the applications in the Data warehouse. Wrote procedures for all the below
tasks and
grouped together to form a package.
This project was completely user web interface. Developed the entire web pages
for the
below tasks and procedures were written using HTML, PL/SQL AND Java scripts.
Created
database triggers. Most of the procedures were written in DBMS_SQL.
My responsibilities:
Granting roles to users on remote database.
Creating the users on remote database.
Revoking the roles from remote database
Password suspension process
GE Employee VS Non GE Employees processing.
Create an add role form on the web.
Granting / suspending of the Roles/Users were completely from web.
Granting / suspending of roles through E-MAIL.
Sending warning messages to the users to change the password through EMAIL.
Creating, Granting, Revoking of the users, roles were cross Remote database
links.
Environment: Sun Solaris OS 5.5.1,Oracle Application Server, Windows NT, Oracle
7.3,
HTML, PL/SQL, C, C++ and Java.
CLIENT:
GENERAL ELECTRIC, Schenectady N.Y.
PROJECT: Project tracking And Timesheet System.
04/97
to 06/97
POSITION: DBA/Software Engineer
.
Developed detail analysis, design, data modeling and development Of the
Project
Tracking and Timesheet system. This project was developed to keep track of the
projects
that was developing in
General Electric. It also keeps track of the time taken by the developers to
develop
different modules on different projects. It also keeps tracks on sub projects.
Environment: Sun Solaris OS 5.5.1,Oracle Application Server, Windows NT, Oracle
7.3,
HTML, PL/SQL, and Java.
CLIENT: Software Technical Services. Norcross, GA.
PROJECT: Payroll Monitoring System.
12/96
to 03/97
POSITION: System Analyst
A Package for managing, retrieving and analyzing the software consultants
Payroll system.
Responsibilities Included:
Designed user interface screens for modules like timesheet inputs,
Personal loan & vehicle loan management, debit notes, invoice etc..
Queries and reports were covered for consultants loan outstanding,
Overtime details, generation, and overdue bills finance requisition
Detailed modules.
Object modeling, stored procedures, database triggers were utilized.
Environment: oracle 7.3 forms 4.5,report writer 2.5, PL/SQL, Windows NT
Developer/2000
CLIENT: Food and civil supplies system Dept. Govt. of India. Bangalore.
PROJECT: Food and Civil supplies system.
03/96
to 12/96POSITION
: Analyst
Developed detail analysis, design, and development of the food and civil
supplies
system. This ambitious project involved the automation of the process for
issuing I.D
cards to citizens. The application included Modules for master entry options,
report
options and transaction entry.
Duties included the customization of user interface with triggers. This system
was menu
driven with extensive on line help. Daily and monthly Reports were developed
for the
customers and products.
Interacted with the users in the development of the system requirements and
responsible
for demonstration and training.
Environment: Windows 95, oracle 7.2,developer 2000 tools - forms 4.5, report
Writer
2.5, PL/SQL 2.3, pro*c.
CLIENT: UCO Bank Bangalore, India.
PROJECT: Bank Maintenance system.
POSITION:
Programmer
11/95
to 03/96
Developed analysis, design, and development of a bank maintenance system. The
system
dealt with the computerization of the bank, which included two modules.
Bank main entry for opening new accounts.
Banktran for account transaction.
This was a completely menu driven package with on line help. Daily and monthly
reports
were developed for the customers and products. Interacted with the users in the
development of the system requirements and responsible for demonstrations and
training.
Environment: windows, oracle 7,forms, report writer, PL/SQL/pro*c, C, C++
CLIENT: Damania airways, Bangalore, India.
PROJECT: Airline Ticketing Reservation
POSITION: Programmer
12/94
to 11/95
Involved in the development of an airline ticketing and reservation system for
use by
airline travel agents. The system accepted customer queries regarding flights
between
any two cities and provided a schedule of all of the direct and indirect
flights between
two cities. Also stored Details such as the distance between the different
cities and
timings If arrival and departures.
Environment: Unix, oracle, forms 3.0,report writer and pro*c, C, C++
CLIENT: Siddaganga Institute of Technology, Tumkur India.
PROJECT: Payroll System.
POSITION
: Programmer05/90
to 12/94
Involved in the development of a system to computerize and automate payroll
Functions
for the organization. The system incorporated functions for Staff movement,
allowance
and deduction calculations, and monthly salary processing and other functions.
Also
responsible for the development of
Various program modules. Prepared system documentation and trained Users on
the system.
Environment: Unix, oracle, PL/SQL, sql*plus, sql*forms, sql*report writer,
pro*c, C, C++
Contact this candidate