Stephen Tahmosh
41 Sunnyside Lane
Braintree, MA 02184
stahmosh@cstent.com
(781) 843-4300
click for pdf version
|
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, Object Oriented Modeling techniques. |
|
Database Design and
Administration |
In-depth Hands on and
Management experience in the administration of an Oracle 8i, Sun Solaris
E10000 High Availability (clustered) environment using Oracle Range
partitioning and a variety of 3rd party products for reliability
and availability. Relational Database
Design / Database Administration: ·
Oracle
Versions 5 – 8i (and 9i on Windows 2000), Parallel Server (7.x) , Symmetric
Replication (7.x), SQL*Net (1.x, 2.x, 8.x, 9.x), Oracle Internet Directory
(2.1.1/8.1.7 and 3.0.1/9i), Oracle Advanced Security (9i) , Oracle LDAP
Naming (8i and 9i) ·
Oracle
9i DBA OCP Certification: ·
Passed: Oracle9i SQL, Database Fundamentals
I, Database Fundamentals II ·
Pending
availability: Oracle 9i
Performance Tuning ·
Certificate
of Mastery in Oracle7 Database Administration (Chauncy Group, 1996) ·
ERWin
ERX 1.1, 2.0, 3.5.2 (including Web Publisher) 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
(Adstar Distributed Storage Manager – ADSM), Veritas Cluster Server, Volume
Manager ·
SQL,
PL/SQL, SQL*Loader, exp/imp SQL*Forms (2.3, 3.0, 4.0, 4.5) 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: ·
iPlanet Enterprise (Web) Server 3.6,
4.1, 6.0, Directory Server 4.1, 5.0, Application Server 6.0 Java Development Tools ·
Forte
for Java 1.0, 2.0, J2EE 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. ·
Tivoli
Management Environment (TME 2.5, 3.0) ·
BMC
Patrol, Compuware EcoTools, Landmark PerformanceWorks, Platinum DB-Vision ·
Sybase
ESSM, DBMX’s (now Tivoli’s ) Oracle7 ESM |
|
education |
M.S., Computer and
Information Systems, Dartmouth College.
M.B.A., Babson College B.S., Accounting,
Bentley College (Passed the CPA exam at the first sitting) |
|
REFERENCES: |
Furnished on request |
Experience
|
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, Veritas Cluster Server, 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 Oracle Dictionary (sql.bsq file) sizing
·
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
Database Configuration Assistant (DBCA) to register database with Oracle Internet
Directory (OID)
Used
Enterprise Security Manager and Oracle Wallet Manager to add users and obtain
digital certificates (using Thawte Certificate Authority)
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.
·
Relational
Data 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.
Identified 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 Hitachi’s TPBroker.
Researched Inprise’
Integrated Transaction Service (ITS) and Hitachi’s TPBRoker / HiEM Enterprise
Monitoring.
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 evaluated
include ERWin, Silverrun, System Architect, Bachman/Analyst, Excelerator. Methodology Tools pursued include 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.
Commonwealth of Mass. Office of MIS |
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.