http://www.GregoryHart.net

2349 Shirecrest Cove Way, Lutz, Florida 33558

(813) 412-3052 [O] ~~ (813) 412-3051 [F]

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

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

·          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.