Gregory Hart

PROFESSIONAL SUMMARY:

Tasks Accomplished:

Combination of disparate data sources to build data warehouses using SSIS and other ETL tools.

Usage of the System-Object tables within SQL to script out complicated needs to read a database’s internal structures and implement them in T-SQL scripts and/or SSIS packages.

Creation of well over 10,000 stored procedures.

Creation of well over 500 different databases in complete functionality, created from original specs gathered.

Build and install of multiple web servers and/or database servers inclusive of the operating system, database configuration, and all other relevant server and security settings and configurations.

Build of failover and redundancy needs from inception to production.

Implementation of all appropriate security considerations.

Involvement in a project from the initial planning stages to ultimate delivery a s finished product.

Migration of a team of 80+ users from Windows XP to Windows 7 by creating the template for all clones to be created from, inclusive of configuration of all software, some being as old as 16 bit (VB6 IDE and Oracle 6).

Release Management to production and to Unit Testing (UAT) and to Pre-Production, and finally Production.

Monitoring and Tuning applications to best optimize performance and user experience.

Proactive identification of potential issues, often times thinking 6 steps ahead of the current status to best identify potential future needs or issues that would arise based on current approaches.

Take the lead role on resolving critical application issues and needs at both GUI level, Middle Tier, and also database to timely and accurately meet customer SLA’s.

Role of team lead or Project Manager.

Provided training and guidance to junior team members.

Creation of automated scripts in DOS, PowerShell, and other low-level languages to accomplish seemingly impossible tasks when trying to user more modern languages.

Streamline development timelines for a project to be less than the original slated timeline.

Aggregation of tables to and slicing/dicing/dimensioning data to be most amenable to reporting.

Creation of well over 1,000 Crystal Reports, from inception to delivery.

Correction to existing code to either optimize it and/or correct for any anomalies within its accuracy.

Normalization of poorly designed database structures.

Index optimization and identification of where to set the table cluster and when to use unique indices.

508 training and code development to be compliant with established standards.

Creation of entire web-enabled data-driven applications for large companies such as Verizon, MetLife, ATMS, Advanced Systems Design (ASD), Image Painting of Florida, and others.

Creation of my own server-side scripting language from revising and recompiling the “dll” of VBScript.

Taught classes in Crystal Reports, Database Fundamentals, and also Database Index Optimization.

Scheduling jobs using ActiveBatch

SPECIFIC SKILLS & KNOWLEDGE:

Strengths:

Database/GUI Application Development

Database Development/Optimization

ETL

Ten years of recent Agile Methodology experience.

HTML5, CSS, and JavaScript development for Data driven applications

Pattern Recognition within data and code and Business Level application design

Data Warehousing and Data Dimensioning

Specification gathering of client needs

Bridging the gap between developers and upper level management by expressing complex concepts in terms amenable to all

Project Management / Team Lead

Seeing the “Big Picture” and pulling together a project at its initial stages to best complete success in the most streamlined manner

TECHNICAL SKILLS:

Databases: SQL 6.5 through 2017, Oracle, Informix, DB2, AS400, Access, FoxPro

Data Management Tools:

DTS

ASP

SSIS

SSRS

DOT.net

SSAS

Crystal Reports (All Versions)

Excel

Business Objects Enterprise Server

Crystal Server

TOAD

JAWS, Windows Eyes, and FireEyes

Other Tools:

MS SQL 6.5 - 2017

VBScript

Oracle PL/SQL

C#

T/SQL

P/SQL

Java

XML

HTML5

JavaScript

JQuery

JSON

CSS

Visual Basic (VB6)

Crystal Reports

ActiveBatch

Why me:

Experience and care. I LOVE my work. It is my hobby also, for over 25 years. Most situations I have the experience of "been there, done that, at least once." This allows me to work faster and with greater accuracy than most.

PROFESSIONAL EXPERIENCE:

Centene Insurance Aug, 2019 – Present

5130 Sunforest Dr, Tampa, FL 33634

Senior Application Software Engineer

Database SQL//TSQL Developer/SSRS Developer

Develop database warehouse and mart, develop reporting interface using SSRS,

Develop ETL process using SSIS and automating it through ActiveBatch,

Created logging system for automated processes that were previously run manually.

Modify existing and develop new Stored Procedures

Modify existing and develop new SSRS reports

Modify existing and develop new SSIS packages

Use ActiveBatch to schedule complex job processes

Built many pages in sharePoint for team documentation and interactive data lists

Entity Relationship Diagram (ERD)

Independent Contracting at Image Painting of Florida May, 2019 – Aug, 2019

23110 State Rd 54 307, Lutz, FL

Data Warehouse Developer and Designer

Database SQL//TSQL Developer/SSRS Developer

Created a data warehouse and a data mart from scratch

Created approximately 20 new SSRS reports

Cleaned existing data anomalies

JSON and XML data management and extraction

Power BI

CoAdvantage Nov, 2018 – May, 2019

3350 Buschwood Park Dr #200, Tampa, FL 33618

Database Developer and SSIS and SSRS Expert

Database SQL//TSQL Developer/SSRS Developer

Modify and develop new Stored Procedures

Identify index needs, and provide solution

Modify and develop new SSRS reports

Modify and develop new SSIS packages

Present ideas for new softare relase (SALT Project)

PL/SQL

Power BI

Entity Relationship Diagram (ERD)

JSON and XML data management and extraction

UAMC (Eagle Home Mortgage) June, 2016 – Nov, 2018

4600 W Cypress St Suite 500, Tampa, FL 33607

Database Developer w/ SSIS and SSRS Expert

Database SQL/PLSQL/TSQL Developer

Team Lead for SAP Crystal Reports development.

Daily tasks of creating ad-hoc Crystal Reports or SSRS.

Build of Stored Procedures, User Defined Functions (scalar and tabled), Views, and Triggers.

Optimization of indices.

Optimization os T-SQL executables

Team member in creation of Data Warehouse and Mart

Build Power BI reports and Analysis Services (SSAS)

SSIS, SSRS, and C#, SQL Server 2008 - 2017, and Oracle PL/SQL.

Whann Technologies May, 2015 – May, 2016

313 7th Ave. S, Naples, Florida 34102

Database Developer

Database Migration from FoxPro to SQL.

Team Lead for SQL development.

Improved runtime of scripts from many hours to only a few minutes (over 200 scripts affected).

Daily influence in “putting out fires” within the FoxPro model from previously written processes.

Build of all tables, stored procedures, indices, SSIS, SSRS, and some SAP Crystal Reports.

Gather of customer specs for final product and documentation of all work performed to allow administrative/maintenance team to continue on after I left.

SQL Monitoring to identify issues and to correct and improve performance.

ASD (Advanced System Design) February, 2015 – May, 2015

2120 Killarney Way, Tallahassee, FL 32309

Internal Portal

Database Development.

Database and Application Architecture.

SSIS, SSAS, ETL, Stored Procedures, User Defined Functions, Indices, SSRS, SAP Crystal Reports.

JavaScript, CSS, HTML5.

GUI Development.

Documentation of all facets of the project.

Orcle PL/SQL

Enrollment System for VA Through ASD (overlap) September, 2014 – February, 2015

2120 Killarney Way, Tallahassee, FL 32309

Java Developer

508 Compliance Development.

HTML5.

Java.

JavaScript.

NOTE: This project overlaps with below, I was working for ASD but billed out to 2 contracts simultaneously and billing at 70+ hours per week.

Vetsnet Claims Data Processing Through ASD September, 2011 – February, 2015

2120 Killarney Way, Tallahassee, FL 32309

Database Developer

Application Development.

GUI Developer for VB6 and MS Access.

Hillsborough Area Regional Transit Through ASD June, 2011 – September, 2011

SAP Crystal Business Objects Specialist

Bamboo Buddy January, 2011– June, 2011

Lead Developer of New Software Tool

Database Development.

Database and Application Architecture.

SSIS, SSAS, ETL, Stored Procedures, User Defined Functions, Indices, Crystal Reports.

JavaScript, CSS, HTML5.

GUI Development.

Documentation of all facets of the project.

Baxter Healthcare Corporation October, 2010 – January, 2011

7511 114th Ave, Largo, FL 33773

Data Correction to mis-aligned database and development of data warehouse

Database Development.

Database and Application Architecture.

SSIS, SSAS, ETL, Stored Procedures, User Defined Functions, Indices, Crystal Reports.

JavaScript, CSS, HTML5.

GUI Development.

MS Access

Documentation of all facets of the project.

ATMS (Contract) September, 2008 – October, 2010

Database and Reporting Manager

Management and team lead in the coding and documentation new business tools and existing tools.

SAP.

Crystal Reports.

DTS, SSIS, SSS, ETL, Stored Procedures, User Defined Functions, Indices, Oracle 10G.

Pepsico (Contract) September, 2006 – September, 2008

Crystal Reports Developer and Database Developer

Crystal Reports.

Crystal Enterprise.

DTS and ETL.

Oracle 10G.

MetLife (Contract) May, 2006 – September, 2006

Database Developer

Developed SQL Data Warehouse for reporting.

Lead database administrator.

Coordinated the Pinellas Park office with the IT department of corporate and scheduled from all the data sources different DTS packages to migrate data from the separate sources into one SQL server for reporting

Over 20 Crystal Reports.

Implemented data-driven solutions to resolve FDA Audit needs.

Team lead for 5 participants.

Database Engineers, Inc. (Contract) January, 2004 – May, 2006

Database and Web Application Developer and Project Lead

Moffitt Cancer Center.

University of South Florida.

Publix Supermarkets.

Database Designer/Developer for many small companies with diverse and varying needs.

Rocha Southern Controls

Verizon Data Services 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 DTS Packages.

Worked with data platforms exceeding 3 terabytes in size to create data warehouse and created ETL scripts.

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.

MS SQL and MS Access development.

Wrote all SQL Server-Side Programming (Views, Stored Procedures, Triggers, Constraints, Indexes)

Crystal Reports created and implemented through Business Objects.

Voicestream (WorldCom) May, 2000 – September, 2001

Database Developer (Contractor)

Company Profile:

Database Design.

OS, Software & Hardware Install and Maintenance.

ASP Website Development.

JavaScript, VB, HTML, and CSS.

User Training: Taught classes in Seagate Crystal Report and Fundamental SQL Data Structure to fellow employees.

Primemed (a Network of retail pharmacies) February, 1998 – May, 2000

MS SQL Intermediate Level DBA / Data Analyst

Company Profile: Network of retail pharmacies.

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.

Independent Consulting (Projects were primarily for smaller companies) 1992 – 1998

Report Writing, Database Creation and Implementation, & Application Development.

Image Painting of Florida – Creation of business management application for Painting houses for developers.

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 Web based.

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 Web based front end and Crystal reports for accounting and management. Budgeting module with accounting included.

EDUCATION:

B.A., Business Management; Concentration in Business Finance; Eckerd College, St. Petersburg, FL, 3.8 GPA; 1997

Education in Leading People to Higher Performance, Special Training (no diploma), Cornell University, Ithaca, NY

CONTACT:

Gregory Hart

3428 Ehrlich Rd

Tampa, FL 33618

adhmly@r.postjobfree.com

813-***-****

MY SQL EXPERIENCE:

While going to college, I worked as a cosmetologist. I met my wife at the salon we worked at together, and planned our wedding 2 years later. Once married, we didn't want to work for a salon, we wanted to own our own salon. We rented space on Dale Mabry, and opened shop. On day one, I realized I wanted more visibility to the business activity than a cash register would provide (this was in 1996). I read up about computer programs, and then tried to hire someone to create what I had laid out that we needed. Prices came in around $15,000 - $25,000. I purchased a computer, and Microsoft Office.

I learned FoxPro (the Dummies books), and set out to create the application I wanted. About 2 weeks later, we had a fully functioning POS system that collected all client information and also manage our inventory. I was the receptionist at our salon, so while sitting at the desk during slow times, I continued to add more modules, a time clock, an alert when inventory drops too low and many other features. After about 2 more weeks, it was complete. I sold it to several other salons around Tampa, and everybody loved it. One of my clients saw what I did, and invited me to apply for a job at his business, for $30,000 a year. I immediately fired myself from our salon, hired a receptionist for $5 an hour, and started my career as a software engineer.

I started off building Crystal Reports from a MS SQL database (version 6.5). I was particularly strong in developing the SQL for the reports, and after about a month I got moved over to the database development team. I taught myself all about the SQL system tables and how to use the information within them to automate processes that were previously manual. This progressed to writing scripts that would generate ASP pages for the web. I was having fun, … I could create a fully functional data insert page or data report page or an Excel export through these scripts, instantly. Just run one of my stored procedures using the table or view name, and 500 – however many lines of code were instantly returned to my window as printed text, to be copied and pasted into NotePad, and saved as an “.asp” file.

I continued to learn something new every day about database “magic”, and still learn something new nearly every day. I am extremely strong in index optimization (I’ve taught classes for this), query plan optimization (my biggest improvement was taking a procedure that would take 25 hours to run, and was executed once daily, and reducing the run to about 20 minutes), building data warehouses and marts, building complete databases for applications from scratch, and recognizing the difference of database design when considering if data needs to be inserted or retrieved.

Contact this candidate