http://www.GregoryHart.net

2349 Shirecrest Cove Way, Lutz, Florida 33558

(813) 242-2770 [O] ~~ (813) 242-2772 [F]

GSH@TampaBay.rr.com

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

Master of Science – Computer Information Technology

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

·