Scroll To View More
Zachary Woodworth, T-SQL Developer in Plano, United States
Zachary Woodworth

T-SQL Developer in Plano, United States

Member since May 13, 2016
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.
Zachary is now available for hire

Portfolio

Experience

  • Microsoft SQL Server, 9 years
  • T-SQL, 9 years
  • ETL Implementation & Design, 8 years
  • SSRS, 7 years
  • SQL Server Integration Services (SSIS), 7 years
  • Crystal Reports, 6 years
  • Agile Software Development, 5 years
  • Kanban, 3 years
Plano, United States

Availability

Part-time

Preferred Environment

SQL Server, TFS, SSIS, SSRS, Visual Studio

The most amazing...

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

Employment

  • 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: SQL Server, SSRS, TFS
  • 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, SSRS, Oracle, TFS, SSIS
  • 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: SQL Server, SSIS, SSRS, Crystal
  • 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: SQL, Access, DTS packages

Skills

  • Languages

    T-SQL, Java, Visual Basic, C
  • Tools

    SSRS, Microsoft Access, Crystal Reports, Visual Studio, TFS
  • Paradigms

    Kanban, Agile Software Development, ETL Implementation & Design, Scrum
  • Storage

    SQL Server Integration Services (SSIS), Microsoft SQL Server, SQL Server Management Studio
  • Platforms

    Oracle
  • Other

    Business Intelligence (BI)

Education

  • Bachelor of Science degree in Management Information Systems
    2000 - 2006
    Oklahoma State University - Stillwater Oklahoma
I really like this profile
Share it with others