|
Stephen
Tahmosh |
(781) 843-4300 |
|
Skill Summary: |
|
|
MIS and
Project Management |
Successfully managed
projects from feasibility through production, providing technical and
administrative leadership in areas such as task definition, task estimation,
and prioritization. Successfully
managed a small Oracle DBA team and a small MIS department responsible for
all financial and marketing applications. |
|
Systems Analysis,
Software Design, Database Design |
Conducted
a variety of Requirements Definitions leading to Logical and Physical Data
Models, Functional Specifications, and subsequent application implementation. Designed and implemented software solutions
in multiple environments: relational database, ISAM, flat file systems, 4GL
and COBOL systems, and PC and minicomputer systems. Familiar with Booch and Rumbaugh, and
recently, UML. |
|
Database Design and Administration |
In-depth
Hands on and Management experience in the administration of an Oracle 8i, Sun
Solaris E10000 high availability environment using Oracle Range partitioning
and a variety of 3rd party products for reliability and
availability. Relational
Database Design / Database Administration: ·
Oracle 9i Certified DBA. ·
Oracle Versions 5 – 9i , DataGuard,
Parallel Server (7.x) , Symmetric Replication, SQL*Net, Oracle Internet
Directory (2.1.1/8.1.7 and 3.0.1/9i), Oracle Advanced Security (9i) , Oracle
LDAP Naming ·
ERWin ERX 1.1, 2.0, 3.5.2 (including
Web Publisher), 4.1, Bachman 4.15 ·
Quest Spotlight, SQLab, Space Manager ·
BMC SQL Backtrack for Oracle (2.0.3,
3.2.8), IBM’s Tivoli Storage Manager – TSM ·
SQL, PL/SQL, SQL*Loader, exp/imp
SQL*Forms (2.3, 3.0) XML
Database Management Systems ·
Software AG Tamino 2.3.1.4,
Neocore XMS 2.0 ·
XSLT 1.0, Xpath, XML Schema, DTD |
Applications |
Installation
and Database Administration for Peoplesoft HR (5.01, 5.11) |
|
Development and Deployment Tools |
Experience
Installing, Configuring, and Deploying to the following iPlanet products: ·
Netscape / iPlanet ·
Netscape / iPlanet Directory Server 4.1,
5.0 ·
iPlanet Application Server 6.0 Java
Development Tools ·
Forte for Java 1.0, 2.0 ·
Familiar with many of the Java
Enterprise Edition API’s, including JNDI, JMS, Servlets, EJB. ·
Familiar with XML and XSLT through
Forte Fusion Integration Server Limited
experience with MQ Series (5.0) and Visibroker 3.0 / Hitachi TPBroker |
|
Systems Management |
Comprehensive
evaluation of the following Systems Management tools, resulting in selection
and implementation of Tivoli Management Environment. ·
·
BMC Patrol, Compuware EcoTools,
Landmark PerformanceWorks, Platinum DB-Vision ·
Sybase ESSM, DBMX’s (now |
|
education |
M.S.,
Computer and Information Systems, B.S.,
Accounting, |
|
REFERENCES: |
Furnished
on request |
Experience
|
|
April
2002 – present |
Practitioner
Faculty Member (Part-time evenings) in the Bachelor of Science in Information Technology Program.
Have taught:
Introduction to Operating Systems, Programming Concepts (C, Java, Visual
Basic), Database Concepts, and Database Management.
|
CST
Enterprises |
Jan
2002 – present |
Self-employed
Consultant, delivering application development services in the Relational
Database Management Systems marketplace.
Recent
Engagements:
·
Oracle Database Design and Administration
supporting the Development environment for a Mutual Fund Investment Firm
Senior DBA supporting
the design and technical environment, Leading the migration to Oracle 9i and
high availability DataGuard environment.
·
Database Design and Administration for an
Oracle 9i OLTP application environment supporting Retail Banking applications.
Application Architect participating in requirements definition and systems
design in a WebLogic Server environment.
Evaluation and
recommendation of new technologies to satisfy operational and business
requirements (e.g., job schedulers, reporting, performance monitoring and
management). Specific accomplishments
include:
·
Set up and configured the Oracle 9i
DataGuard Physical Standby Database environment for our OLTP database
·
Maintain the ERWin data model
·
Develop
·
Write XSL Style Sheets to extract and
format XML Transaction Data stored in Oracle
·
Researched and identified Remote DBA
Service Providers and selected an alternative with significant cost savings and
better service
·
Researched and selected a Collaboration
tool vendor product as a replacement for a proprietary consulting-firm provided
solution
|
State
Street Corporation |
Jan
2001 – Nov 2001, Jul 1997 – March 2000 |
Senior Database Services Manager responsible
for a high-visibility Oracle-based application.
Responsibilities
·
Global Corporate Actions
Worked with developers on Database Design (ERWin 3.5.2) , Database
Sizing (comprehensive excel spreadsheets) , Database Performance. Successfully converted from Oracle 8.0.4 (Sun E3500) to Oracle 8.1.7 (Sun E10000), and
Non-Partitioned Tables to Range-Partitioned Tables.
Defined and implemented a DDL Management discipline using sccs and
home grown scripts.
Defined and implemented the complete Physical Database layout
(200GB), including the disk filesystems (Veritas Volume Manager)
Used varied systems software for maintaining availability and
recovery - SQL-BackTrack, ADSM, Autosys, VCS, Quest SQLab, Spotlight
·
Relational Data Archiving
Primary Responsibility for the implementation of CheckMate, a
vendor product for Archiving relational data
Managed the vendor relationship (from initial contract proposals
to working through functional enhancements, requests for fixes).
Designed solution (built application data model, referential
linking rules, and CheckMate extracts) for initial customer implementation
Set up infrastructure to support development and operational
(run-time) environment.
·
Personnel
Brought three new people into the organization in three months and
assisted in their becoming valuable team members.
·
Developed internal
documentation for the following items:
·
Operational SQL*Plus scripts
(approximately 100 of them)
·
Autosys Job documentation,
including functional documentation and schedule
·
Standards for Pinning objects
in the shared pool
·
Standards for Implementation
of Quest Tools (Spotlight, SQLab, Space Manager)
·
ADSM backup and recovery
concepts
·
SQL-BackTrack for
Exports/Imports, and Backup and Recovery
·
New Technologies
·
Implemented Oracle LDAP
Naming,
Initial implementation used iPlanet Directory Server (our
Enterprise LDAP server, though not supported by Oracle)
Subsequent implementation used Oracle Internet Directory (in order
to extend the prototype for LDAP user authentication)
·
Partially implemented Oracle
LDAP Password user authentication (Oracle 9i on Windows 2000 prototype)
Installed Advanced Security option
Used Enterprise Security Manager and Oracle Wallet Manager to add
users and obtain digital certificates
Created Global User (Shared Schema), Global Role, and Enterprise
Role, and mapped User DN to Shared Schema
Successfully connected to OID using SSL.
·
XML Database Technology
Limited investigation of Neocore XML database and Software AG's
Tamino XML Server
Senior
Technical Consultant involved in various Application Technical Architecture
projects.
·
Database Archiving
Organized
and conducted a product evaluation of 3rd party products performing
DBMS Archiving.
Managed
all the technical issues in bringing in 3 vendor products for evaluation.
Identified
Archiving evaluation criteria, and Applications with Archiving Requirements.
Conducted
an in-depth evaluation and selected an Enterprise Archiving Tool (for Oracle,
Sybase DB2, SQL Server, and Datacom)
·
Database Design and Administration
·
For one new project:
Had
sole responsibility for the Database Design (implemented in ERWin, including
entity and attribute definitions), based on user requirements.
Developed
comprehensive sizing projections, based on user requirements.
Forward
Engineered the Database from the Data Model.
Assisted
in ongoing DBA Administration.
·
For another, in process project:
Documented,
through a reverse engineering process, the Application Data Model.
Incorporated
some table design changes and specified Referential Integrity rules to be
incorporated into the database.
Presented
the Application with an Archiving solution.
Developed
complete sizing information in the form of a formula-driven spreadsheet
facilitating size projections for various time frames.
Responsible
for introducing various technologies to Application group:
Oracle
Multi-Threaded Server, Oracle Parallel Server
Quest
Software’s SQLab SQL Tuning tool.
·
Data Modeling Tool Selection
Led
a cross-organization committee in an evaluation of the 4 internally used Data
Modeling tools (Silverrun, PowerDesigner, Visible Analyst, ERWin), culminating
with a selection of ERWin.
Built
a strong justification for the selection of ERWin, though it is the least used
tool within the organization.
Significant
involvement in the establishment of Data Administration Standards.
·
CORBA technology / Object Transaction
Monitors (OTM)
An
application was looking for OTM functionality, and pursuing a switch from
Inprise’ Visibroker to
Researched
Inprise’ Integrated Transaction Service (ITS) and
Organized
and scheduled a conference call with Gartner Group.
Established
that the OTM product set is immature, that while ITS was new and TPBroker was
based on mature technology, there wasn’t a clear basis for making a switch.
·
Workflow technology
Introduced
Vitria BusinessWare technology into the corporation.
Worked
with Neon’s EPE Workflow software during our evaluation.
Participated
in sessions involving IBM and MQ Series Workflow.
|
Sun
Microsystems / iPlanet |
March
2000 – Jan 2001 |
Systems
Engineer focused on iPlanet Application Server and Forte Fusion Integration
Server
Presented
solutions to prospects on iPlanet Application and Integration Servers,
including iPlanet Web Server, and iPlanet Directory Server
Participated
in proof-of-concept implementations, which included implementing and deploying
servlets and EJB’s into the iPlanet Applcation Server
|
Dialogos
|
Jan
1997 – June 1997 |
Senior
Data Architect responsible for designing data solutions to support client
information requirements.
For
one client, defined the requirements for a Data Warehouse, the Warehouse Data
Model, and Data Load System requirements.
With assistance from client business personnel, defined source to target
data mappings.
For
another client, defined a logical data model from legacy system data
structures, loaded the data into an Oracle Database, and transformed the data
into a Star Schema for Data Warehouse Analysis.
Also evaluated Business Objects 4.0 and Cognos’ Powerplay 5.0 for
Decision Support.
|
CST
Enterprises |
Jul.
90 - Feb. 92, Aug. 93 – Dec 96 |
Self-employed
Consultant, delivering application development services in the Relational
Database Management Systems marketplace.
Engagements
include:
·
For the Information Technology and Mutual
Fund Information Services Departments of a multi-national bank:
·
Third Engagement
Sized and rebuilt OPS database. Configured SQL*Net V2. Installed and configured various Oracle7
versions.
Conducted an evaluation of Database monitoring
tools - Sybase ESSM, DBMX ESM, Patrol, Ecotools, Platinum, Landmark.
Installed,
upgraded, supported Peoplesoft HR 5.01, 5.11 environments.
·
Second Engagement
Supported
Oracle6, Oracle7, Oracle Parallel Server Database Administration in an IBM AIX
environment. Performed Software
upgrades, Developed Backup and Recovery strategies, Optimized data migration
efforts. Transferred skills to existing
staff.
·
First Engagement
Participated
in the Database Design process for a Shareholder Reporting Application. Conducted a review of several CASE (Data
Modeling /Schema Generation) and Systems Development Methodology tools:
CASE
Tools: ERWin, Silverrun, System
Architect, Bachman/Analyst, Excelerator.
Methodology Tools: AGS FirstCase,
LBMS Process Engineer, Case Methods Development Corp.’s Synergy.
Supported
the DBA function in a Sybase/Sun Unix environment.
·
For the QA department of a Workflow
Software Development vendor:
·
Supported Sybase, Oracle, and (minimal)
Informix Database environments.
·
Initiated the trial evaluations of
EcoTools and Patrol.
·
Participate in the QA testing of the
product. Developed an Oracle Forms/Reports
application to track product installations.
·
For the MIS Organization within a new
OnLine Information Services organization:
·
Defined, Refined and Documented the
Database Design, wrote Stored Procedures and Triggers, and conducted
Performance Tuning efforts in support of Billing, Revenue Accounting, and
Customer Support Sybase applications.
·
For the Database Services Group of a
Mutual Fund Investment Company:
·
Conducted a complete review of the
database implementation for Brokerage and Mutual Fund Trading systems. Developed the logical data models
representing the physical implementation and identified opportunities for
improvement.
·
Participated in the loading of legacy
data and in the analysis of the data as mapped to the new data structures.
·
For a Consulting Firm, developed the user
interface for a Corp. Self-Insurance Risk Management and Analysis Reporting
System.
·
Using SQL*Forms 3.0 and Oracle*Terminal,
developed a standardized Function Key and Presentation Interface consisting of
over 50 tightly integrated screens and numerous subsidiary screens.
·
For a Supermarket chain:
·
Assisted in the store systems transition
from a Production Oracle/Sun Unix Environment to a Production Oracle/IBM RS6000
Unix environment. Performed Oracle and
Unix System Administration functions in the conversion to the RS6000;
·
Established and implemented User
Interface standards using the Oracle tool set.
Reworked the existing application to conform to the Interface standards,
and developed additional user screens conforming to the standards;
·
Implemented a production database
environment, including space allocation and access methods, which balanced ease
of maintenance with optimized performance;
·
Facilitated and incorporated changes to
the initial database model to account for increased business knowledge.
·
For a Consulting firm:
·
Assisted in the conversion of a Retail
Scheduling/Time and Attendance PC-based product from an MS DOS, BASIC
environment to a Unix, C, and Oracle platform;
·
Translated the I/O routines from
Btrieve/ISAM to C/Embedded SQL.
|
Jan. 93 - Aug. 93 |
Chief
Database Architect responsible for the
definition of data requirements and design of database solutions in an RDBMS
environment
Significant
Accomplishments:
·
Substantially influenced the design of
the first DB2 application developed at the Commonwealth;
·
Defined the Database and Database
development environment for the first Microsoft SQL Server application;
·
Investigated financial analysis and
budgeting tools: Sinper’s TM/1, and Arbor Software’s eSSbase
·
Compared Microsoft Visual Basic,
Knowledgware’s Objectview, and Powersoft’s Powerbuilder.
|
Delphi
Technology, Inc. |
Mar 92 - Dec. 92 |
Managing
Consultant
·
Developed and delivered a presentation
outlining the key new features of ORACLE Version 7
Facilitated discussion on the organizational impacts these new features would
have on a large ORACLE Version 6 customer.
Delivered a related Distributed Database presentation several times.
·
Developed an Oracle-based RAD prototype
of an existing COBOL-based system with SQL*Forms
·
Contributed to the development of an
internal product development effort for an insurance claims administration
application.
|
The
Putnam Companies |
Nov. 89 - Jul. 90 |
Senior
Consultant, Investment Management Technologies.
Designed a Database
supporting Investment Trading and Performance Analysis. Developed a Fixed Income Trading Application
using the Oracle V6 RDBMS and Software Tools:
SQL*Forms v3, SQL*Menu v5, and SQR.
Performed various DBA functions.
|
Oracle
Corporation |
Mar 87 - Nov. 89 |
Senior
Consultant, Post-sales Consulting.
Engagements included
requirements definitions, custom application design and implementation, and
packaged application implementation.
Also taught standard Oracle classes and designed and taught custom
on-site classes.
·
Led a Supermarket chain client in a
strategic IS requirements definition effort. Designed the database to support
the key business functions.
·
Led a six month Client / Consultant joint
development effort of a Service Reporting system for a Company generating
approximately $1 Billion in Service Revenues.
This system was designed specifically to address the key issues of end
user access, data storage and performance, and report selection flexibility.
|
Henco
Software |
Apr 85 - Mar 87 |
Manager
of Information Systems Development for a 4GL and DBMS software firm.
|
Gately
Glew & Associates |
Jul.
83 - Apr. 85 |
Senior
Systems Consultant for a CPA and systems consulting firm.