Zachary Woodworth, Developer in Plano, United States
Zachary is available for hire
Hire Zachary

Zachary Woodworth

Verified Expert  in Engineering

Software Developer

Location
Plano, United States
Toptal Member Since
June 18, 2020

Zachary is a highly task-oriented, flexible, and intuitive SQL developer with experience working diligently assigning tasks, maintaining projects, and double-checking his work for errors. He is especially skilled at tasking himself to turn out a quality product within a constricted timeframe.

SQLT-SQL (Transact-SQL)ETLMicrosoft SQL ServerSQL Server Management Studio (SSMS)SQL Server Integration Services (SSIS)SQL Server Reporting Services (SSRS)Data MigrationMicrosoft Visual StudioCrystal ReportsMicrosoft AccessAgile Software DevelopmentOracleBusiness Intelligence (BI)Java

Availability

Part-time

Preferred Environment

Visual Studio, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), TFS, Microsoft SQL Server

The most amazing...

...thing I've coded is an ETL and reporting solution that gathered information from over 250 servers and 40,000 databases.

Work Experience

Database Consultant

2015 - PRESENT
Springpoint Technologies
  • Created SSRS reports.
  • Worked with the client to understand database layout (including Kronos) and the location of data.
  • Archived legacy reporting solutions and migrated to the current server.
  • Optimized existing reports and SQL stored procedures.
  • Consulted and offered advice with clients for best reporting practices.
Technologies: TFS, SQL Server Reporting Services (SSRS), Microsoft SQL Server, T-SQL (Transact-SQL), SQL, ETL Implementation & Design, ETL, ETL Development, ETL Testing, Data Migration

Database Consultant

2015 - 2016
Robert Half Technology SPS Program
  • Migrated legacy Actuate and MS Access reporting to Oracle stored procedures.
  • Created an SSRS reporting solution.
  • Consulted and offered advice to clients on best reporting practices.
  • Taught myself Oracle to optimize stored procedures and reporting.
  • Worked with clients to understand data to quickly generate stored procedures and reports.
Technologies: SQL Server Integration Services (SSIS), TFS, Oracle, SQL Server Reporting Services (SSRS), Microsoft SQL Server, T-SQL (Transact-SQL), SQL, ETL Implementation & Design, ETL, ETL Development, ETL Testing, Data Migration

Database Developer

2010 - 2015
Realpage, Inc.
  • Created highly complex SSIS packages using various data transformations like conditional splitting, For Each loops, multi-casting, merging, derived column conversions, parallel processing, and script components.
  • Redesigned and completely revamped mapping of department transactions for internal billing products.
  • Fine-tuned various procedures and reports generated by current and former colleagues using SQL 2008/2012 and provided better logic for current projects.
  • Developed reports using SSRS and suggested templates for the reports project.
  • Taught myself Crystal to improve and maintain historic reports.
Technologies: Crystal, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Microsoft SQL Server, T-SQL (Transact-SQL), SQL, ETL Implementation & Design, ETL, ETL Development, ETL Testing, Data Migration

Information Services Team Lead

2007 - 2010
MOSAIC
  • Led or contributed to various service groups within IS to support program operations in web-based and handheld technology environments.
  • Understood program operation/utilizing proprietary software applications and mainstream technologies such as MS SQL Server, MS Access, DTS packages, and T-SQL.
  • Created a staging database for temporary processing of data, consolidating data, and loading into a target database using ad-hoc queries.
  • Worked on the migration of DTS to SSIS packages.
  • Created reports and deployed them to handheld devices using propriety software.
Technologies: DTS, Microsoft Access, SQL, T-SQL (Transact-SQL)

Sample Code

This custom code was developed specifically for a previous job. Its purpose is to analyze a group representing an application with one or more applicants for an apartment and determine the potential factors that could have influenced their application score. These factors include bankruptcy history, eviction records, criminal background checks, and more.

Languages

SQL, T-SQL (Transact-SQL), Crystal, Java, Visual Basic, C

Paradigms

Kanban, ETL, Agile Software Development, ETL Implementation & Design, Scrum, Business Intelligence (BI)

Storage

SQL Server Integration Services (SSIS), Microsoft SQL Server, SQL Server Management Studio (SSMS), SQL Server Reporting Services (SSRS)

Other

ETL Development, ETL Testing, Data Migration, Development

Tools

Microsoft Access, Crystal Reports, Microsoft Visual Studio, Visual Studio, DTS, TFS

Platforms

Oracle

2000 - 2006

Bachelor of Science Degree in Management Information Systems

Oklahoma State University - Stillwater Oklahoma

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring