Developer Data
Resume:
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
*****@*****.***
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