Resume

Sam A.,

 

 

 

We only do consulting. 

No permanent job inquiries please.

 

Click here for Consulting rates.

 

 

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 2005—Present) 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 ( O’Keefe 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.