SQL Developer/ETL Specialist

GREGORY HARVEY

916-***-**** • Elverta, CA • *****************@*****.*** • Linkedin.com/in/greg-harvey-5b5a8312

SQL DEVELOPER/Data Specialist

Database Engineering Development Management

Versatile, innovative strategist recognized as an accomplished SQL Developer with 20+ years of wide-ranging experience encompassing the technical and managerial leadership of SQL development, infrastructure, and managing DBA projects. Directs the translation of customer requirements into effective technical solutions and determines if proposed projects are technically possible and safe, ensuring the quality of all projects. Commended throughout career for formulating effective plans, improving ROI, and achieving consistent year-over-year growth. Notable success in directing a broad range of initiatives and implementing solutions supporting overall objectives. Ability to build data warehouse from the ground up. Building pipelines from fast moving OLTP database into FACT/Dimension and CUBE data models. Setup and monitoring SQL Server Databases.

SIGNATURE COMPETENCIES

Project Management Machine Learning T-SQL Development

DevOps Database Administration Troubleshooting

Horizontal & Vertical Scaling Database Design Problem-Solving

Data Modeling Team Building E-commerce Development

Performance Management Training & Coaching Critical Thinking

LEADERSHIP IMPACT

Trusted Technical/DBA Development Partner who consistently delivers quantifiable value by leveraging emerging technology and business insights to optimize value.

SQL Development strategist with an entrepreneurial mindset and a contemporary approach to solving diverse business problems through technology innovation, scalability, and reliability.

A results-driven, Decisive Leader who is highly skilled at building relationships, managing change, creating measurable procedures, and counseling/developing individuals and teams.

In-depth expertise in SQL Development Technology, business continuity, and leading projects through the complexities of varying priorities and agendas.

EXPERIENCE

Intercare Health / Avon Risk Database Engineer May 2025 – Present

Converting ETL data from existing and new clients into the Claim enterprise system

All DBA functions

Performance and tuning existing scripts utilizing TSQL high level techniques.

Resolving issues and creating reports on the Claim enterprise system.

Woodland School District Systems Engineer (Robert Half Contract) Sep 2024 – May 2025

Converting ETL data from Aries (SIS) into ClassLink portal supporting School district teachers and Principals

All DBA functions

Performance and tuning existing scripts utilizing TSQL high level techniques.

Resolving issues between multiple applications between Students and Teachers.

Including migrating Clever/RapidID to ClassLink utilizing MS SSIS packets

GREGORY HARVEY Page 2

EliteBco, Puerto Rico Conversion Specialist (Contract) Jul 2024 – Aug 2024

Converting ETL data for Puerto Rico government into Deloitte databases

Performance and tuning existing scripts utilizing TSQL high level techniques.

Updating Python scripts.

Reconciliation of data and code to assure quality for delivery.

Safe Credit Union, Folsom, CA Senior Data Engineer Jun 2021 – July 2024

Lead designer for a new data warehouse project; reverse engineering current data warehouse data model.

Recreated a new data warehouse in MS SQL from the Oracle platform; the CORE system was SPECTRUM with Fiserv’s Informent data warehouse attached; the new CORE is DNA with a new data warehouse on the MS SQL platform.

Medallion principles, organizing data into Bronze (raw), Silver (cleaned), and Gold (curated) layers to support analytics and business needs. Worked in a SCRUM agile environment using JIRA.

Created all custom reporting and processes from existing reports mapping to new data CORE structure.

Collaborated closely with data analysts, data scientists, and other data consumers within the business to gather and populate the data warehouse table structure, which is optimized for reporting.

Created and supported the ETL to facilitate the accommodation of data in the warehouse. Utilizing SSAS and SSIS ETL

Oversaw Power BI development by utilizing FACT and DIMENSION tables, building CUBES and PIVOT.

Alluma, Sacramento, CA (Health-e-Arizona Gov) SQL Performance Engineer/Lead May 2014 – May 2021

Provided technical leadership and support for various products and applications that required performance engineering, testing, and analysis. DBA function working with AlwaysOn. Monitoring SQL Server for performance

Assessed current operations; identified weaknesses and inefficiencies.

Developed software or automation solutions; helped train employees on using the new technology.

Assessed solutions after implementation and adjusted them as necessary.

Converted poor-performing stored procedures into efficient-performing procedures; converted non-relational schema into a high-performing data model.

Trained developers on T-SQL converting cursors into set base SQL along with many other unique techniques for high-performing queries; the company met government deadlines and reduced penalties for downtime.

Performed development using FACT tables and Dimension / Power BI. Utilizing SSAS and SSIS ETL

California Correctional Health Services, CA Senior Database Engineer (Consultant) Jun 2013 – May 2014

Designed and performance-tuned the Dental Scheduling Tracking System.

Developed a historical feature to track inmates moving from bed to bed and other facilities with precise real-time data without affecting legacy code.

Modified code to be sub-second using expert knowledge for performance and tuning.

Performed performance and tuning for the medical system with SSRS coding and reports and acted as the Business Intelligence (BI) expert.

Created CUBES in SSAS and ETL (SSIS) into Fact and Dimension tables for high-end data warehouse solutions.

Designed ETL code from existing flat files and Excel spreadsheets utilizing SSIS features.

GREGORY HARVEY Page 3

First Corp Solution Database Administrator Apr 2013 – Jun 2013

Converted data from various State and County offices from text files, XML, and others into MS SQL Server via bulk copy utility.

Created new SSRS reports and updated existing reports.

Designed a system for backups and created a system for fail-over.

Maintained existing batch jobs to help monitor the system.

LexisNexis Database Administrator Dec 2012 – Apr 2013

Set architectural standards for Databases and related technologies by performing research, design, development, testing, and production environments.

Ensured continued availability and performance by creating, maintaining, and administering databases to standards.

Conducted Installation, maintenance, security, performance monitoring and tuning.

Administration of Sybase ASE, Oracle, and MS Server.

EXPERIENCE CONTINUED

Previously:

Blue Shield of California Database Administrator (Contract) Oct 2012 – Nov 2012

Purple Communications Database Administrator Jun 2011 – Sep 2012

Artech Information Systems Database Administrator Mar 2011 – Mar 2012

Vision Service Plan Conversion Specialist Sep 2010 – Mar 2011

TechSoup Global Inc. Database Administrator Jun 2009 - Sep 2010

CERTIFICATIONS & EDUCATION

MCTS Certification, Tech Skills Sacramento, Sybase Training Center Internal Courses, Replication Server 15.0, I/Q Data Warehouse, ECMap (EDI x12) NEON/Sybase, E-Biz Integrator (MQSeries) NEON/Sybase, Informatica, Select Training Centers: Novell CNE, SA-285 Solaris 2.x System Administration, Microsoft Windows Train the Trainer, Microsoft NT Train the Trainer, High School Diploma

TECHNICAL PROFICIENCY

Hardware: Aberdeen NAS Servers and storage, Dell EqualLogic NAS/SAN for isci, IBM SAN. Set up complete LAN

systems (cables and software), Change disk drive memory, upgrade motherboards, modems, and related

parts of the microcomputer systems, Laser-jet printers.

Software: MS SQL, Sybase 12.5.3/15.0, Oracle 9g/10g/11g/12g, SolarWinds Network Performance Monitor, Enterprise Portal, Replication Server, KornShell, Windows NT, UNIX, DBArtisan, LightSpeed, e-Biz Integrator (MQ Services), ECMAP (EDI), Informatica, Office 2007, Exchange Server, Veritas Backup Exec, Fox Pro Windows, MS-DOS, SQL relational database, communications packages, Jira, Git, Python, New Relic, DevOps

Contact this candidate