Resume
Sam A.,
BIOGRAPHY
|
 |
|
Sam has developed database administration program curriculum and
courseware for four universities. He holds Masters in Computer
Information Systems and he is currently pursuing a doctorate degree in
education. Sam is an author of "Oracle9i Performance Tuning:
Optimizing Database Productivity" and "Database Security and Auditing:
Protecting Data Integrity and Accessibility".
|
EDUCATION
Doctoral Program of Education (2003
Present) School of Education, Johnson Wales University, Providence, RI,
USA
Master of Science in Computer Information Systems (1996 1998) Metropolitan
College, Boston University, Boston, MA, USA
Honors Bachelor of Science in Computer Information Systems (1990 1992)
School of Computer Science,
University of Windsor, Windsor, Ontario, Canada
General Bachelor of Arts in Mathematics (1984 1990) Mathematics
Department, University of Windsor, Windsor, Ontario, Canada
Diploma in Electronics Engineering Technology (1981 1983) George Brown
College, Toronto, Ontario, Canada
WORK SUMMARY
Sam is a certified database administrator with fifteen
years of software development, software design, system architect, and
database administration in business, scientific, engineering, telephony, and
financial applications. Sam has fourteen years of teaching and training
experience, he has delivered undergraduate, graduate and technical courses
to major universities and corporations globally.
COMPUTER PROFICIENCY
Hardware: DEC VAX 4000/200, AlphaServer, SUN Microsystems, SPARC, SGI
Server, IBM PCs
Operating Systems: Windows 3.x, 3.11, 95, 98 and NT, Unix, Xinx, Linux, VMS,
OpenVMS, CMS, OS/2, Novell Netware, DOS and DOS
Programming Languages: C, C++, MS Windows SDK, Borland TurboVision and
ObjectWindows, Visual Basic, Pascal, Fortran, Forth, QBasic, PL/I, Cobol,
Clipper, Turing, Assembler, Lisp, Miranda, Prolog, Developer 2000,
PowerBuilder IV
Database Management: SQL, Oracle 5,6,7,8 and 8i Client & Server, Clarion,
CodeBase, Quest, Ingress, Sybase, ODBC, Red Brick, Progress, dBase III & IV,
SuperBase, SQL Windows, FoxPro, Paradox, MS Access
Database Tools: Precise SQL, BRIO, Emarcedero (DBArtisan, Change Manager
DBArtisan Rapid, SQL ER/3 Studio), BradMark DBGeneral (Enterprise Monitoring
Module, Database Administration Module, Tuning Module), Platinum DBVision,
BMC Patrol, Quest SQLab, SQL Expert, Quest TOAD, TOAD DBA Edition, Quest SQL
Navigator, Oracle Enterprise Manager, Crystal Reports, Business Objects,
Forest & Trees, Impromptu, VisualBasic Data Wizard, ADO, DAO, RDO
CASE: Oracle Designer 2000, ERWIN, Power Designer, System Architect, Visible
Analyst and Rational Rose
Tools: Fulcrum Ful/Text, Documentum, FileNet, HI-Screen GUI for Dos and
Windows, RoboHelp, Demo-it, ASPECT GUI, Neuron Data GUI, WinMaker Pro,
InstallShield, Connel Scientific, Halo Graphics Tools, ClearCase, SQA, Lotus
Notes
PROFESSIONAL EXPERIENCE
Employer: EMC² Corporation (Feb 2005Present) Full-time
Location: Hopkinton, Massachusetts, USA
Position: Sr. Product/Education Consultant
Act as
subject matter expert within a focused area of sales, management or complex
technical programs/training. Demonstrate in-depth understanding of EMC sales
methodologies and solutions. Provide consultative support within focus area
to team members, business managers and the field - worldwide. Work cross
functionally with internal and external organizations in order to anticipate
and identify business needs, and drive the development of customized
programs/training solutions. Evaluate both internal and external
program/training offerings for content applicability and effectiveness.
Provide value-added feedback and recommendations to program/training
managers for continuous improvement.
Anticipate business needs for programs/training
Design, develop and execute innovative programs/training
solutions
Audits execution of programs/training for consistency and
continuity - solicits and monitors feedback
Subject matter expert
Qualify instructors to deliver courses in the Symmetrix
Business Continuity program
Consultant to business managers/field
Courseware developer and consultant
Deliver training for the following courses:
Symmetrix Business Continuity Local Replication
Symmetrix Business Continuity Remote Replication
Symmetrix Business Continuity Automatic Replication
Symmetrix Business Continuity Implementation
Symmetrix Business Continuity Design
Symmetrix Business Continuity Oracle Integration
Employer: Price Waterhouse Cooper (PWC) (June 2004 Present) Contractor
Location: Boston, Massachusetts, USA
Position: Sr. Oracle Consultant
Project: TurboDM (Denial Manager)
Developed denial manager database application system to manage health care
denied claims by insurance providers. The application composed of loader
engine to pull 835 files, viewer module, reporting module and productivity
module in addition to maintenance and system configuration. The application
system is developed using Oracle10g Application Developer Suite (Forms &
Reports), PL/SQL and Java.
Employer: Vertex/Zantera Group (Feb 2004 Present) Contractor
Location: Cambridge, Massachusetts, USA
Position: Sr. Oracle Consultant
Provide consultation on Oracle technology, database administration, database
architecture, Visual Basic, ASP and other development tools.
Employer: Upromise.com Inc. (Sep 2002 Feb 2005) Full-time
Location: Needham, Massachusetts, USA
Position: Database Administrator/Architect
Responsible for design, architecture and database administration of Upromise
Investment group database application. Developed data migration tools using
PL/SQL and SQL*Loader. Developed data verification tool using PL/SQL and
SQL. Implemented enterprise database separation. Assisted in the design of
database application. Performed all tasks of application database
administrator. Optimized performance of the database. Performed SQL tuning
on all queries used by the application. Designed a data model for migrating
legacy data to Oracle database. Architected disaster and recovery strategy
for UII applications.
Employer: Thomson Course Technology (Sep 2002 April 2005) Contract
Location: Boston, Massachusetts, USA
Position: Author
Authored two text books:
Oracle9i Performance Tuning: Optimizing Database Productivity
Database Security and Auditing: Protecting Data Integrity and
Accessibility.
Employer: University of Phoenix (Sep 2003-December 2004) Part-time
Location: Cambridge, Massachusetts, USA
Position: Adjunct Professor
Provided lectures for POS/410: SQL for Business
Employer: Advanced Career Technologies
Location: Framingham, Massachusetts, USA
Position: Curriculum Developer
Program Curriculum Development: Developed in-class and hybrid
curriculum for Oracle 8i, 9i and 10g New Features database administration
program, this includes lesson plans, exercises, workshops and projects.
Curriculum is used at: Clark University, Skidmore College, John Hopkins
University, and Farleigh Dickenson College.
Employer: Clark University, College of Professional Continuing
Education/CCI (Nov 1998 Present) Contractor
Location: Framingham, Massachusetts, USA
Position: Computer Instructor/Oracle Lead Instructor
Oracle9i Database Administrator Program: Windows NT, data
communications and networks concepts, data modeling, Oracle SQL and PL/SQL,
Oracle Architecture, Backup and Recovery, Tuning and Troubleshooting, and
Net8 Architecture.
Oracle8i Database Administrator Program: Windows NT, data
communications and networks concepts, data modeling, Oracle SQL and PL/SQL,
Oracle Architecture, Backup and Recovery, Tuning and Troubleshooting, and
Net8 Architecture.
Enterprise Developer Series: System Architecture, Object Oriented
Programming, Visual Basic, MS SQL Server, UML, VB.NET, ADO.NET, ASP.NET,
DHTML and JavaScript
Client/Server Program: Oracle SQL*Plus, PL/SQL, Visual Basic
(introduction, intermediate, and advanced), HTML, JavaScript, VBScript, ASP,
Object Oriented Programming, building OCX controls, and advanced
client/server database application programming using ADO technology.
Employer: Technology Business Group/Bridgewater State College (June
2002 Present) Contractor
Location: Holliston, Massachusetts, USA
Position: Oracle Instructor
Oracle9i Database Administrator Program (Worcester Technical
Institute, Waltham MA): Database Administration, Backup and Recovery, and
Performance Tuning
Oracle 8i Database Administrator
Program (Bridgewater State College, Bridgewater MA): Oracle Fundamentals,
Oracle SQL, PL/SQL, Oracle Architecture, Backup & Recovery, Tuning and
Troubleshooting, and Net8 Architecture.
Introduction to JavaScript ( OKeefe Tech, Framingham, MA): Provided
lectures, exercises and workshop in JavaScript to students
Linux (Dean College, Franklin, MA): Introduction to Linux
Administration and Linux Network Administration
Employer: Boston University, Metropolitan College (Sep 1998
Present) Part-time
Location: Boston, Massachusetts, USA
Position: Computer Science Professor
Provided lectures for the following courses:
CS682: System Analysis & Design
CS579: Database Management Systems
CS382: Information Systems for Business
CS201: Introduction to Programming with C++
Employer: Northeastern University, State of the Art Program (Jun 2001
Present) Part-time
Location: Boston, Massachusetts, USA
Position: Computer Instructor
Provide lectures for the following courses:
COM 5600: C Programming,
COM 5922: Advanced Oracle Programming with PL/SQL,
COM 5614: C Programming Advanced Topics,
COM 5532: SQL-IN-A-DAY
COM 5551: Relational Database Design
COM 5970: Oracle Database Administration
Employer: Fidelity Investments Veritude (Feb 2001 Dec 2001)
Contractor
Location: Marlborough, Massachusetts, USA
Project: Firsco DBA Group, Digital Library Group
Position: Sr. Oracle Database Administrator/Developer
Administrated and supported a large web-based Oracle 8/8i databases for
development and production. Duties included replication, recovery using RMAN,
standby databases, partitioning and consultation for advanced database
issues and problems. Installed Oracle Applications 11i (Oracle Statistical
Application). Assisted developers in SQL tuning and PL/SQL coding. Performed
database tuning. Re-designed and developed statistical gatherer responsible
for collecting oracle statistics. Developed scripts automating daily and
routine tasks. Involved in storage capacity planning. Appointed as liaison
person for the Unix-Oracle team.
Employer: Manulife Financials (Oct 2000 Feb 2001) Contractor
Location: Boston, Massachusetts, USA
Project: Oracle Design/Development
Position: Database Developer/Administrator
Designed and developed Oracle PL/SQL packages to support Sub Account
Exchange for the WEB. Designed and developed Visual Basic GUI driver for
oracle packages. Designed and developed VisualBasic GUI to load data from
Oracle to MS SQL Server using DTS objects. Performed database optimization
and SQL tuning. Created a data mart model and developed scripts to create
DMWEB schema. Tools used in this projects: Oracle8i, MS SQL Server, MS SQL
Server DTS, Visual Basic, ADO, PL/SQL, SQL, Quest TOAD, ERWIN, Visual Source
Safe.
Employer: Investors Bank & Trust Company (Feb 2000 Oct 2000)
Contractor
Location: Boston, Massachusetts, USA
Project: Database Administration (Development & Production
Position: Database Administrator/Architect
Administrated and supported a large scale Oracle 7.3.4, 8 and 8i databases
for development and production. Performed database optimization and SQL
tuning. Developed monitoring scripts (shell and SQL). Evaluated database
monitoring tools. Developed hot backup script and tablespace analysis
script. Contributed in disaster recovery and high availability strategy.
Contributed to database standards and procedures. Assisted with systems
infrastructure and architecture. Assisted in data design and data modeling.
Primary contributor to database disaster recovery project. Assisted in
design of batch process for loading data. Administered Oracle Financial
Application.
Employer: Compaq (Jan 2000 Feb 2000) Contractor
Location: Marlborough, Massachusetts, USA
Project: Omega Sales System & MFASYS Compensation System
Position: System Analyst
Responsible for analysis of issues and problems for Omega and MFASYS
systems. Resolved and fixed reporting issues. Tools used PowerBuilder, SQL,
PL/SQL, and shell scripting
Employer: Fidelity Investments FESCO (May 1999 Dec 1999)
Contractor
Location: Merimack, New Hampshire, USA
Project: Hughes Time Keeping
Position: Database Consultant
Designed and Developed OFFCYLCE module for the Time Keeping, this included
GUI front-end using Oracle Forms and back-end stored packages, procedure and
functions using Oracle PL/SQL, and designed and developed reports using
Oracle Reports. Developed data migration auditor module using Oracle
Developer 2000 (Forms and Reports), SQL and PL/SQL, Oracle DBMS_JOB database
package. Designed and developed core interfaces using Unix shell programming
and SQL programming. Preformed optimization and tuning using Oracle Trace
and tkprof utility on existing stored packages and SQL scripts. Created,
modified, and automated installation scripts that create database objects
and installs application modules in QA and production. Developed and
enhanced new and existing Oracle reports using Developer 2K. Provided
recommendations and tips in database administration issues such as
optimization, table sizing, and other performance matters. Other tools:
ClearCase, SQA, Lotus Notes, SQL Navigator.
Employer: Maxim Group/Opus Telecom Inc. (Sep 1997 May 1999) Contractor
Full-time
Location: Framingham, Massachusetts, USA
Project: Inmate Tracking System/TeleDebit System
Position: Project Leader/Principal Database Engineer
Project lead of GUI design, database administration, design and development
of TeleDebit System (CellularOne San Francisco). Data modeling, design and
analysis, GUI design, and development of Call Rating module using Developer
2000. Database administration and optimization includes tablespace sizing
and oracle configuration. Architected database disaster recovery plan for
TeleDebit application. Developed a dynamic migration package using Developer
2K, SQL*Plus and PL/SQL. Design of Audit module, License Threshold module.
Conversion of character based TeleDebit System (Price Communications) to
Windows. Administered and developed Oracle Forms for Oracle Financials
Application. Migration of Oracle v6.0 and SQL*forms v3.0 to Oracle V7.0 and
Oracle Forms 4.5. Data analysis and modeling using ERWIN 3.x. System
analysis and design, GUI design using Oracle Forms 4.5 & 5.0 on Oracle 7 and
8. Unix shell scripting, development of PL/SQL triggers and stored
procedures, Unix and database installation, configuration and optimization.
Reports development using Oracle Reports 2.x & 3.0.
Employer: Spectrum Telecorp (Apr 1998 Dec 1998) Contractor
Location: Merimack, New Hampshire, Massachusetts, USA
Project: Spectrum Report Generator SRG/Call Rating Modeling
Position: Database Consultant
Reports development using Oracle Reports. Development of report generator
SRG (GUI and command line) using Oracle Forms and Proc*C/C. Data modeling,
design and development of local call rating.
Employer: Oracle Corporation (Apr 1997 Sep 1997) Contractor
Location: Boston, Massachusetts, USA
Project: Order Tracking System (United States Army SCP)
Position: Principal Consultant
Data analysis and modeling, system analysis, design and development.
Database configuration, design, administration, and setup. Tools used are
Oracle 7.3.2, SQL*Plus, Designer 2000 and Developer 2000, Forms 4.5,
SQL*Loader, ReportWriter.
Employer: Fidelity Investments (Apr 1996 Mar 1997)
Contractor Full-time
Location: Marlborough, Massachusetts, USA
Project: FIIS Production Support/Application Support
Position: Project Leader/Senior Technical Consultant
Duties include team infra-structure, procedures, tasks delegation, training,
support analysis and assessment, database administration, system
administration, development of Issues and Resolution System, Software
include: Red Brick, Oracle, Sybase, Documentum, FileNet, BusinessObjects,
VisualBasic, C++ and shell scripts.
Employer: AIT Corporation (Oct 1995 Apr 1996) Contractor
Location: Ottawa, Ontario, CANADA
Project: Ion
Position: Software Engineer
Software development in PowerBuilder 4 and SDK for Windows 3.11. Duties
include GUI design and implementation, data modeling, modification of
existing language class (using OOD/OOP).
Employer: Detecon AlSaudia/CGI Group
(Saudi Arabia; Oct 1994 Oct 1995) Contractor
Location: Riyadh, Saudi Arabia
Project: Saudi Arabia Frequency Management System and Problem
Reporting System
Position: Department Manager/Senior System Analyst
Managed computer department of SFMS project. Functions included are software
design and development, software optimization, documentation, database and
system administration, staff supervision. Implemented disaster recovery plan
for SFMS database application. Oracle SQL*Forms and report development and
administration for Oracle Financial Applications. Designed & Developed:
modules of SFMS and Problem Reporting System using Oracle 6 & SQL*Forms 3.0,
Windows applications Detecon Directory System and Books Library System using
Clarion and VB. Conducted research for an upgrade of SFMS using Oracle 7 and
PowerBuilder.
Employer: Air Navigation Data (Sep 1994 Jan 1995) Contractor
Location: Ottawa, Ontario, CANADA
Project: PathFinder v3.0
Position: Software Developer
Software development in Borland C++ TurboVision, C/C++, and CodeBase
database Engine. Duties included conversion from Pascal to C then building
system interface using TurboVision and implementing new database system
features for maintaining data.
Employer: Algonquin College (Jan 1993 Dec 1995: 6 semesters)
Part-time
Location: Ottawa, Ontario, CANADA
Project: C++, C & Qbasic Language
Position: College Instructor
Provided lectures, labs and prepare assignments and exams.
Employer: IAT (1994 1995) Contractor
Location: Ottawa, Ontario, CANADA
Project: Advanced Computer Training
Position: Computer Instructor
Provide training for C language, Advanced C language, Lotus 123 for Windows,
Data Modeling, System Analysis & Design, GUI for Windows, UNIX and other
topics.
Employer: Willis Business College (Jan 1994 Aug 1994) Contractor
Location: Ottawa, Ontario, CANADA
Project: Software Development/Analysis Program (SDA)
Position: Computer Instructor
Provide lectures and training for SDA program; courses are: Computer
Concepts and Programming, DOS, DOS Applications, Windows Applications,
Pascal, C, dBase IV, Oracle, System Analysis and Design, Object Oriented
Programming in C++, UNIX, and Database administration.
Employer: DCW Consultants (Jun 1994 Jul 1994) Contractor
Location: Ottawa, Ontario, CANADA
Project: National Warehouse Survey System (DCW v1.0)
Position: System Developer
Developed an electronic data entry for National Warehouse Portfolio
Department using C and HI-Screen GUI. Also wrote routines to import stored
data by DCW to QuatroPro for analysis
Employer: SPS Computing & Engineering Consultants (Mar 1993 Jan
1994) Contractor
Location: Ottawa, Ontario, CANADA
Project: Advanced Computer Training
Position: Computer Instructor
Provide lectures and training for advanced languages: C, C++, MS-Windows
SDK, Oracle 5/6, OracleSQL* Forms and FoxPro. Oracle 5/6 Database
administration, Novell Netware network installation and administration.
Employer: Praxis Training (Jul 1993 Aug 1993) Contractor
Location: Ottawa, Ontario, CANADA
Project: Praxis Testing System (PTS v1.0)
Position: Software Developer
Developed a computerized testing system using C and HI-Screen GUI.
Employer: AVC (Jul 1993 Aug 1993) Contractor
Location: Ottawa, Ontario, CANADA
Project: Video System
Position: Database Developer
Developed video system with member transactions using Clarion and C.
Employer: Omicron International Translation System (Aug 1992 Mar 1993)
Full-time
Location: Ottawa, Ontario, CANADA
Project: VisionTech System
Position: Systems Engineer
Developed translation database system with images for Windows using MS
Windows SDK and Aspect GUI. Developed a text retrieval demo using Fulcrum
Ful/Text. Developed database engine in UNIX. Developed a graphical
presentation slide program using Borland C. Performed various GUI evaluation
and testing. Provided software and hardware support to staff. Assisted in
Novell LAN Network installation and administration.
Employer: JUNORS, The Kitchen Collection (Nov 1991 May 1992)
Contractor
Location: Windsor, Ontario, CANADA
Project: Retail Store Computer System
Position: Database Application Analyst
Developed a database system using Clarion & C with HI-Screen GUI. The
system consists of Inventory & Ordering, Client Card Club, Bridal Registry,
and System Backup.
Employer: George Dubauskas Insurance Brokers Limited (1990 1992)
Contractor
Location: Windsor, Ontario, CANADA
Project: Clients Service System
Position: Software Developer & System Maintenance
Developed Clients system using CLARION Professional Developer. System
maintenance, backups using Batch files and Turbo C. LAN services on AGENA
system.
Employer: School of Computer Science, University of Windsor (1991)
Contractor
Location: Windsor, Ontario, CANADA
Project: 60-104 Computers for End-Users
Position: Teacher Assistant
Responsible for grading assignments and exams. Provided help using
(mainframe systems DOS, VMS, CMS, WYLBUR, MS Windows, WP, dBase III+, Lotus
123 & CMS).
Employer: Proto Manufacturing, Limited (May 1989 Oct 1989)
Full-time
Location: Windsor, Ontario, CANADA
Project: Proto/Denver System for Boeing Company
Position: Software Developer/Electronics Technologist
Assisted in hardware design of metal stress analyzer and developed new user
interface using HI-Screen GUI, CONNEL & HALO graphics embedded with FORTRAN.
Employer: Mathematics Department, University of Windsor (1985 1986)
Contractor
Location: Windsor, Ontario, CANADA
Project: 62-124 & 62-126 Introduction to Linear Algebra for Business
and Engineering
Position: Teacher Assistant
Responsible for grading assignments and exams. Provided office & lab help.
|