GHart@GHart.net
GREGORY
HART
SUMMARY
Over fifteen years of professional Information Technology
experience and hands on Business Intelligence and Business Architecture and
Modeling for CRM, ETL, and other core business needs. Heavy focus on Project Work and Project Completion from
inception. Experience includes strong
and current skills with Database Modeling, Development, Architect, and
Warehousing (Star Schema, Snowflake Schema, …); inclusive of DTS Packages,
T/SQL and PL/SQL, Stored Procedures and Views and User-Defined Functions, SQL
Server Integration Services, Analysis Services, Oracle and all aspects of MS
Office platform. Greatest strengths are
in Database Development, Data Migration and validation of Consistency, Database
Tuning to optimize performance, Data Warehouse design, and ETL. Crystal Reports
experience from 5.5 to XI R2. Have taught classes for Crystal Reports at levels for
Beginners, Intermediate, and Advanced level courses. Traditional ASP development (JavaScript, VB Script, DHTML) and
dot.net platforms.
Many projects included project
lead role: responsible for gathering user requirements and project
specifications, management of project resources, decision maker in platforms
and software tools to be used, user sign-off of request, ISO and/or other
necessary documentation, and final user acceptance and training.
Mostly projects with corporate
needs to either update an existing data management system or add enhancements
to an existing system, or to create new data management solutions. Some examples are redevelopment of the
architecture to systems which have been running for an extended period of time,
and may not have been originally built to make the best use of the abilities of
today's more advanced database engines.
Other examples include creating data warehouses for reporting and
extraction purposes when a production level database is being heavily
interacted with by users performing updates, inserts, and deletes. Additionally, many of my projects have
included being Project Lead in gathering initial specifications from end users
with needs for a new system/tool to gather and hold information necessary for
business operations. With such
projects, I often produce solutions not only for the backend functionality of
the database, but also the frontend GUI which the end user interacts.
Another major resource provided
to companies is the creation and automation of reports against their critical
data. Using tools such as Seagate
Crystal Reports, Cognos, SQL Reporting Services, and other reporting tools, I
develop the SQL syntax to be most amenable with server specifications and
ability, and produce meaningful reports with clearly understandable graphic
representations such as charts, graphs, and other visual display to aid in a
fast, high-level overview of the data statistics.
SPECIFIC SKILLS & KNOWLEDGE
Documentation
and Specification Gathering: Role as
Project Lead for many projects.
Gathered initial specs from end users and/or management personal,
created project overview of approach to development, created database backend,
oversaw production of front-end interface and assisted where needed, and
finalized with project documentation and integration of help files.
Databases:
SQL 6.5 through 2005, Oracle 8i through 10g, Informix, DB2, AS400,
Access, FoxPro
Data Management
Tools: Seagate Crystal Reports (Versions 5.5 through XI),
Business Objects Enterprise Server and Crystal Reports Server XI, DTS, ASP,
JSP, DOT.net, ColdFusion, Excel, Self created library of over 8,000 scripts,
OLAP, MS SQL Reporter, ERWin, Visio, Business Intelligence, Enterprise Manager,
TOAD
Graphics
Tools Used For Reporting and web design: Adobe Photoshop
Languages:
MS SQL & Oracle PL/SQL & T/SQL, ASP, HTML, dot.net, XML, Kshell
Scripts (Corn Scripts), ColdFusion,
JavaScript, Visual Basic, VBScript, Java, Basic
EDUCATION
B.A., Business Management; Concentration in Business
Finance;
Eckerd College, St. Petersburg, FL
3.8 GPA; 1998
Special Training
Cornell University, Ithaca, NY
Education in Leading People to Higher Performance
Rockville University - Rockville, Maryland
3.84 GPA; 2004
PROFESSIONAL
EXPERIENCE
PepsiCo (contract) September,
2006 – Present
Crystal
Reports and Enterprise Developer
Manage and update reports, and
create stored procedures, views, and new reports as needed per request of end
users and management. Maintain and
facilitate functionality of Crystal Enterprise server XI R2. Work with Oracle 10G database and maintain
server objects per reporting needs.
Create and review all
documentation for all aspects of development.
Environment: Crystal
Reports XI R2, Crystal Enterprise XI R2 and Business Objects, Oracle
10G, Proprietary Applications
Bayview Financial (contract) August,
2007 – January, 2008
Database
Architect
·
Split of one database into 2 separate data repositories for
SOX compliancy to IPO offering
·
Merge/Replication of the two split databases into a third
warehouse reporting repository with live real-time update
·
Optimization of 19 Triggers to improve performance
·
Optimization of Clustered indices to improve performance
·
Creation of multiple Stored Procedures to handle complex
data manipulations
·
Creation of User Defined Functions to standardize
functionality across code
·
Establishment of Linked Servers and interactions between
data sets
·
Preparation for migration from SQL 2000 to SQL 2005,
ensuring that all development efforts would be compatible and would not require
rewrites
Full documentation provided for
all aspects of project development.
Environment: SQL 2000,
SQL 2005, Proprietary Databases, Proprietary Applications which interacted with
the database
Harte-Hanks (contract) March,
2007 – August, 2007
Database
Architect
Creation of:
38 SQL DTS Packages
36 SQL User Defined Functions
90 SQL Stored Procedures
23 SQL View Objects
195 SQL Tables
6 ".bat" DOS command
line Executables
Importation of 368 Flat files to
generate 192 Gigabytes of data
Regular evaluation and correction
for:
Anomalies in User Specs
Data transference problems between servers
Encryption/Decryption problems
Changes in requirements
"Normalizing" data sets that previously were
"flat" in data approach
Balancing the use/need of indexes to determine how to
maximize load efficiency and also SQL query returns
Creation of the SQL 2005 Server
environment for both the Development Servers and the Production Environment,
it's users, installing and tuning the settings to the needs of the environment,
setting of the operating system of the server to optimize for SQL database
performance, and all other tasks associated with the development of a database
and server from scratch.
Everything was created as a
"first time effort" for projects to be used in all future development
models by the permanent employees. Full
ISO compliant documentation provided for all aspects of project development.
Environment: SQL 2000,
SQL 2005, Proprietary Databases, DOS Commands, Flat Files
Baxter (contract) May, 2006
– March, 2007
Database
Developer
Developed an entire SQL
data-reporting Data Warehouse and was primary database administrator. The Company had multiple disparate data
sources, some of them only accessible through corporate online reports. The data environment had deteriorated to the
extent that critical statistics were being managed by multiple different
resources, and within independent and uncontrolled files such as Excel and
Access, accounting for over 12,000 unique data references. As project lead, I coordinated the Pinellas
Park office with the IT department of corporate (there no longer was an IT
Manager within the Pinellas office) and scheduled from all the data sources
different DTS packages to migrate data from the separate sources into one SQL
server for reporting. Went through the initiative of identifying each separate
data source tool, and replacing it with queried data from the new Report
repository. Developed over 20 Crystal
Reports and merged data repository from 6 disparate data sources and
platforms. Created Crystal Reports to
resolve FDA Audit needs. Was team lead
for 5 participants.
Environment: SQL 2000,
SQL 2005, Oracle, MS SQL, AS400, Infinity, JD Edwards, Siebel, Pilgrim, QDS
(proprietary database), ASP, DOT.net, Crystal Reports
Database Engineers, Inc. (contract) January,
2004 – May, 2006
Database and Web Application Developer and Project Lead
Multiple projects, including:
MOFFITT
CANCER CENTER
Project lead repairing 6 Crystal
Reports, Version XI, to function across the network through a specialized
printer for UPC labels. Completed
project early, so moved to develop an entire online merit increase system for
management to use and document employee evaluations and a merit system which
automatically assigned payroll increases of a percent of the total wage using
many complex algorithms and deeply nested “IF, … THEN” criteria.
Environment: Server 2000, T/SQL, MS SQL,
PL/SQL, Oracle, Oracle Forms and Reports, ASP, DOT.net, ASP, Crystal Reports
XI, Business Objects
University of South Florida
Project lead in developing online
ASP.net application to manage the request of permissions, and distribute eMails
to appropriate approving parties.
Gathered specifications, requirements, documentation, and developed all
tables, stored procedures, views, web code, and DTS packages necessary. All supervisors and team members are open to
a phone verification to confirm their satisfaction with my job performance and
willingness to work with me on future assignments.
Environment: MS SQL, T/SQL, Server 2000,
Oracle, PL/SQL, Oracle Forms and Reports, ASP, DOT.net, Crystal Reports,
Business Objects
METLIFE INSURANCE
Administered to Oracle database
and developed Crystal Reports and Business Objects Platform from an Oracle
database and all supporting Views, Stored Procedures, and permissions, along
with complete documentation and gathering of User Specs and requirements, and
final project sign-off for completed and accepted reports. All supervisors and team members are open to
a phone verification to confirm their satisfaction with my job performance and
willingness to work with me on future assignments.
Environment: Server 2000, Windows XP,
Oracle, Crystal Reports, Crystal Enterprise
Publix Supermarkets
Database Designer/Developer
Designed DTS packages using
Transact SQL and PL/SQL and VB and XML and Kshell scripts and created all
levels of documentation for such. A
short term project involving the transference of data from their Mainframe, a
DB2 database, a proprietary database built on an Oracle platform, and a
resident built Oracle database. Because
of Crystal background, became primary resource for Crystal Reports writing
project that involved the creation of 16 new reports, and correction to
approximately 20 existing reports (environment was backend of Oracle, Database
size exceeded 1 terabyte).
Environment: Sun Solaris, Java, DB2, Oracle,
MS SQL, AS400, Crystal Reports
ROCHA SOUTHERN
CONTROLS
Conversion Specialist
·
Primary Database Administrator
·
Created database, first through modeling using ERWin,
complete with necessary views using Transact SQL, stored procedures using
Transact SQL, table constraints, and functionality. Database needs to mimic the current Timberline file structure
enough to enable 3 times a day import refreshes from DTS to update the date,
until such time that all the front end tools and reporting tools are complete
and the Timberline front end interface can be eliminated completely.
·
Installed Windows Server 2000 and configured such to serve
web pages and asp.net configurations, and installed SQL Server 2000 with all
updates and patches for all software.
·
Design of application involves complex join statements,
complex modeling of table structure, and maximizing the performance of the
database via index design, constraints, and forced data integrity.
·
Created automated scheduled routine with e-Mail
confirmation for managing regular backups of the database and the transaction
log.
·
Established initial logins and user accounts and database
access permissions and privileges.
·
Using SQL Server Agent, scheduled jobs for data transfers
and wrote a logging system to track failures and their performance.
·
Created Graphic User Interface front end for data entry and
retrieval and interface for employees to manage their services performed at
each job site and billing methods.
Interface needs to be able to import into both ADP and Timberline any
necessary information that is collected, and also retrieve real-time
information from Timberline for dropdown lists and lookup references when
performing data entry.
·
Developed over 100 Crystal Reports, all called from the web
interface, most containing sub reports, charts, and graphs.
·
Enabled the data views to be data entry and editing, and
cut the cord from Timberline to have the new application perform all tasks.
Environment: Windows Server 2000, MS SQL, Crystal Reports, ASP, ASP.net,
Crystal Enterprise
VERIZON DATA SERVICES
Workflow
Manager October, 2001 – December, 2003
·
Tool used by manager to be notified when there are outages,
and to have a “Control Panel” for viewing all data results from many disparate
sources all in one central location and organized in a hierarchal structure.
·
Developed all DTS Packages
·
Worked with data platforms exceeding 3 terabytes in size
·
Maximized hardware
resource utilization through data design and index design and code that is
written to make the greatest use of the database engine.
·
Responsible for security administration.
·
Established initial logins and user accounts and database
access permissions and privileges.
·
Using SQL Server Agent, scheduled jobs for data transfers
and wrote a logging system to track failures and their performance.
·
Wrote Database Design and Reporting Web Graphic User
Interfaces.
·
ISO Documentation, data schematics, report definitions with
explanation of formulas used within, functional specifications and usage
documentation, user acceptance test plans, regular meetings with director and
user project lead and ultimately the end users when in test mode.
·
Data platforms of MS SQL and MS Access.
·
Wrote all SQL Server-Side Programming (Transact-SQL, many
"CASE" statements using complex joins and Unions) and developed all
views, stored procedures, triggers, constraints, indexes, and scheduled jobs
through SQL Server Agent.
·
Crystal Reports created and implemented through Business
Objects.
Environment: MS SQL 2000, Active Server Pages, Server 2000, Crystal
Enterprise 8.5, MS Access
QualTool Project
·
Tool used for sales representatives of Verizon while on the
road and at conventions. Allows them to
enter data into a form on the web, and then receive a score back as to the
potential of the customer and whether they are financially worth dedicating the
resources necessary to pursue the opportunity.
·
Wrote Database Design with Data Entry and Reporting Web
Interfaces
·
Developed all DTS Packages
·
ISO Documentation, data schematics, report definitions with
explanation of formulas used within, functional specifications and usage
documentation, user acceptance test plans, regular meetings with director and
user project lead and ultimately the end users when in test mode.
·
Data platforms of MS SQL.
·
Wrote all SQL Server-Side Programming (Transact-SQL, many
"CASE" statements) and developed all views, stored procedures,
triggers, constraints, indexes, and scheduled jobs through SQL Server Agent.
Environment: MS SQL
2000, Active Server Pages, Server 2000, Crystal Enterprise 8.5
Customer
Performance Project
·
Tool used by the Customer Services department to evaluate
Verizon’s performance in the management of their data systems.
·
Wrote Database Design with Data Entry and Reporting Web
Interfaces
·
ISO Documentation, data schematics, report definitions with
explanation of formulas used within, functional specifications and usage
documentation, user acceptance test plans, regular meetings with directors and
user managers and ultimately the end users when in test mode.
·
Data platforms of MS SQL and Informix.
·
Wrote all SQL Server-Side Programming (Transact-SQL, many
"CASE" statements) and developed all views, stored procedures,
triggers, constraints, indexes, and scheduled jobs through SQL Server Agent.
·
Developed all DTS Packages
·
Use of global include and style sheet pages and scripting
with VB, HTML, XML, and JavaScript on ASP and HTML pages.
·
Created the more difficult Crystal Reports, and local
consultant for fellow employees with Crystal Report questions.
Environment: MS SQL 2000, Active Server Pages, Server 2000, Crystal
Enterprise 8.5
COPPR Project
·
Evaluation tool used to evaluate and monitor employees
within the Help Desk services of Verizon data center. Currently in daily
constant use with all Help Desk personal.
·
Wrote Database Design with Data Entry and Reporting Web
Interfaces through Informix database.
·
ISO Documentation, data schematics, report definitions with
explanation of formulas used within, functional specifications and usage
documentation, user acceptance test plans, regular meetings with directors and
user managers and ultimately the end users when in test mode.
·
Data platforms of MS SQL and/or Server Informix and/or MS Access.
·
Wrote all SQL Server-Side Programming (Transact-SQL, many
"CASE" statements) and developed all views, stored procedures,
triggers, constraints, indexes, DTS (Data Transformation Services) import
packages, and scheduled jobs through SQL Server Agent.
·
Wrote all views and stored procedures and tables designs in
Informix code on Sun Solaris Unix O.S.
·
Developed all DTS Packages.
·
Installed Windows Server 2000 and configured such to serve
web pages and asp.net configurations, and installed SQL Server 2000 with all
updates and patches for all software.
·
Data conversion from ACD switch data to MS SQL (middle
stepped with ASCII export) and from Informix to MS SQL and from Oracle into MS
SQL and from MS SQL into Access.
·
Java syntax used for creation of JSP pages (not my forte)
to display my databases and/or collect information from users
·
Use of global include and style sheet pages and scripting
with VB and HTML code and JavaScript on ASP and HTML pages (my forte)
·
Created the more difficult Crystal Reports, and was local
consultant for fellow employees with Crystal Report questions. Initial Crystal
environment was Crystal Reports 7.0, then upgraded to 8.0, and a final upgrade
to 8.5
Environment: Informix, MS SQL 2000, Oracle 8i, Active Server Pages, Both
Unix and NT, Java, JSP, Visual Basic, Access, Mainframe, AS400, Crystal
Enterprise 8.5, Business Objects
VOICESTREAM May, 2000 – September, 2001
Database
Developer (Contractor)
Company Profile: Provider
of connectivity services for cellular telephones and additional advancements in
communication technologies. Primary Responsibility included:
·
Database Design: Developed MS SQL data bases for intranet
web reports inclusive of all SQL Server-Side programming (Transact-SQL), views,
stored procedures, triggers, constraints, indexes, DTS (Data Transformation
Services) import packages, and scheduled jobs through SQL Server Agent. Created
a total of 6 data bases, 4 for retention and raw data import from different
data sources, one for mapping the different data sources into one common
entity, and one containing ideally formatted tables for ease of return of data
on the web. Additionally included are special stored procedures designed to
enable other less experienced members of the team to easily construct powerful
SQL statements.
·
OS, Software & Hardware Install and Maintenance:
Windows 2000 Advanced Server. Installed all necessary drivers, ODBC sources,
manual registration of certain DLLs, file and folder ownerships, permissions to
user groups and accounts, and privileges for SQL database. Installed and configured
MS SQL, Office 2000, and ChartFX interactive chart software. Added and upgraded
hardware.
·
ASP Website Development: ASP design using JavaScript, VB,
and HTML. Web pages with complex data returns which mimic previous Excel
spreadsheet versions done daily by hand. Ad Hoc pages created in ASP using
pull-down menus for easy creation of custom queries.
·
Pie Charts & Bar Graphs Generated From Live Data:
Interactive charts and bar graphs on ASP web pages to reflect dynamic data from
the database.
·
User Training: Taught classes in Seagate Crystal Report and
Fundamental SQL Data Structure to fellow employees.
Environment: Active Server Pages, VB Script, NT, JSP, MS SQL
2000, Access, Excel, Oracle 8i
PRIMEMED (a Network of
retail pharmacies) February,
1998 – May, 2000
MS SQL
Intermediate Level DBA / Data Analyst
Company Profile: Network of
retail pharmacies. Primary Responsibility included:
·
DBA of MS SQL Server to build new tables, stored
procedures, indexes, triggers and constraints, views and, and maintain data
integrity and security and disaster recovery.
·
Wrote Crystal Reports for distribution and interactive web
display using Seagate Crystal Reports.
·
Using MS Access designed front end user applications and
data imports from flat files.
·
Using DOS commands, wrote BCP import procedures.
·
Connected and ran fundamental commands to integrate data
importation into the Windows NT environment from a Unix environment.
Environment: Windows 95/NT, Borland C++, Visual C++ (32 bit), MFC
library, Oracle8i, Source Safe version tracker
INDEPENDENT CONSULTING 1992 – 1998
Report
Writing, Database Creation and Implementation, & Application Development
Projects done during this period
are not the same as the projects itemized at the top of the resume, but were
primarily for smaller companies and represents time of learning real world
experience with databases and data.
·
Image Painting of Florida – Creation of Ground Breaking Application within the Painting Industry
·
KB Homes – Conversion
of Excel Spreadsheets into Access Application
·
CP Ships – 6 month
Chrystal Reports Specialist and Business Objects management contract
·
HydroSpa – Conversion
of Access application into SQL and ASP.
·
Florida Department of Defense – Wrote Crystal Reports against Oracle database
·
Marco’s Hair Salon – Complete P.O.S. Application for front register, web-based online
appointment book, accounting, and inventory, taxes, payroll, and daily
checkouts, and more
·
Bank of America – SQL
Development of DTS, Stored Procedures, and Table Architecture and Development
·
Sea Central Shipping – Conversion of Access Database into MS SQL database with ASP front end and
Crystal reports for accounting and management.
Budgeting module with accounting included.