toptal.com
Contact us: +1.888.867.7001
Cliff Buckley, Database Developer in Sumner, WA, United States
Cliff Buckley

Database Developer in Sumner, WA, United States

Member since September 19, 2022
Cliff is a database developer with over a decade of experience in various roles within IT, from hardware support to management. He has led multiple teams, refactored poor-performing systems, and designed systems from scratch. Cliff excels with SQL, Oracle, Bash, Linux, and data warehouse design.
Cliff is now available for hire
Hire Cliff

Portfolio

  • US RxCare
    Leadership, Analysis, QA Testing, Code Review, Web Project Management, Jira...
  • Elixir Rx Solutions
    Oracle 11g, PL/SQL Tuning, PL/SQL Developer, Ruby, C#.NET, Bash...
  • CVS Health
    C#.NET, Data Architecture, Database Design, Data Engineering...

Experience

Location

Sumner, WA, United States

Availability

Full-time

Preferred Environment

Windows, Linux, Microsoft SQL Server, Oracle, MySQL, Data Warehouse Design, Data Warehousing

The most amazing...

...project I've contributed to was the refactoring of an inventory publishing process and taking it from running in eight hours to just minutes.

Employment

  • Systems Management Director

    2021 - 2023
    US RxCare
    • Joined the company when the source control was scattered across each developer's personal Bitbucket account. Created a central team Bitbucket and got all code moved to this new team workspace.
    • Implemented Jira and Jira Service Manager to organize the teams better, significantly improving communication. Previously, the development team received all requests via phone, email, text, or direct message.
    • Used Confluence as a repository and began documenting the Classic ASP data loads and an updated system to ensure rules between the two were matched before implementation. The company had older software and no documentation.
    Technologies: Leadership, Analysis, QA Testing, Code Review, Web Project Management, Jira, Confluence, Documentation, Git, Bitbucket, Jenkins

  • Software Engineer III

    2013 - 2021
    Elixir Rx Solutions
    • Improved the efficiency of the data loading process for calculating deductible and out-of-pocket balances.
    • Integrated a new rules tracking system (Decisions.com rules engine) to determine eligibility.
    • Refactored the eligibility process to improve visibility into what was being received.
    Technologies: Oracle 11g, PL/SQL Tuning, PL/SQL Developer, Ruby, C#.NET, Bash, Windows PowerShell, ETL, ETL Tools, JavaScript, Stored Procedure, Documentation, Python, Source Code Review, Microsoft Word, Microsoft Excel, Visio, Azure DevOps, Data Validation, Quality Assurance (QA), SQL Stored Procedures, Data Management, Data Analysis, Database Architecture, Oracle Database Architecture, Relational Databases, Relational Database Design

  • Database Architect

    2008 - 2013
    CVS Health
    • Redesigned an inefficient system entirely, which shortened a multi-day running government process so that it would run in just a few hours.
    • Mentored junior developers on database best practices and how to review queries for performance improvements.
    • Worked within an architect team, documented, and educated staff on the best practices through lunch-and-learn sessions.
    • Maintained and created ETL processes for loading a variety of data formats.
    Technologies: C#.NET, Data Architecture, Database Design, Data Engineering, Data Warehousing, Documentation, ETL, SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), TFS, Microsoft Team Foundation Server, Visual SourceSafe, Data Validation, Quality Assurance (QA), Star Schema, SQL Stored Procedures, Data Management, Data Analysis, Database Architecture, Oracle Database Architecture, Relational Databases, Relational Database Design, Relational Data Mapping

  • Data Warehouse Software Engineer

    2001 - 2008
    Oeconnection
    • Rebuilt an inventory publishing process with a team of three others to go from 6–8 hours to process inventory to less than 15 minutes.
    • Built the company's first data warehouse from design to ETL processes.
    • Launched a data analysis intelligence system building data marts off the data warehouse for multiple customers.
    • Completed various database and website tasks as assigned from external members' sites to internal tools (task tracking and a billing system).
    Technologies: Data Warehousing, T-SQL, SQL, Stored Procedure, SQL Server DBA, C#.NET, Data Architecture, Data Engineering, Data Warehouse Design, Database Design, SQL Server Integration Services (SSIS), Documentation, ETL, SQL Server Reporting Services (SSRS), Microsoft Access, Quality Assurance (QA), Data Validation, SQL Stored Procedures, Star Schema, BizTalk, Data Management, Data Analysis, Data Visualization, Relational Databases, Relational Database Design, Database Architecture

Experience

  • Book Collector
    https://github.com/buckleycd/BookCollector

    A simple database designed to track a collection of books. The project is deliberately kept simplistic, so any developer can pick up the design and work with an ORM tool without needing to map to stored procedures. This is a personal project and was not sponsored by clients.

  • Data Warehouse

    Designed and implemented an automotive parts inventory data warehouse using the Dimensional Modeling methodology.

    The warehouse is fed data from an OLTP system, CSV files, and a proprietary format for the parts catalog.

    The warehouse was built within six months with a team of four. The team was responsible for geographic hierarchy, customer dimensions, and some of the reporting.

Skills

  • Languages

    T-SQL, JavaScript, SQL, Stored Procedure, C#.NET, Bash, Ruby, Python, Snowflake

  • Tools

    Jira, DbSchema, Microsoft Word, Visio, Git, Microsoft Excel, Confluence, Bitbucket, Microsoft Access, Jenkins, TFS, Microsoft Team Foundation Server, Visual SourceSafe, MongoDB Atlas

  • Paradigms

    Database Design, ETL, Dimensional Modeling, Oracle Database Architecture, Azure DevOps

  • Storage

    Microsoft SQL Server, SQL Server Integration Services (SSIS), SQL Architecture, Data Validation, SQL Stored Procedures, Database Architecture, Relational Databases, MySQL, Oracle 11g, PL/SQL Developer, SQL Server Reporting Services (SSRS), SQL Server DBA, PostgreSQL

  • Other

    Data Warehouse Design, Data Warehousing, Documentation, Leadership, Source Code Review, Data Engineering, Data Architecture, Data Modeling, Code Review, Star Schema, Data Management, Relational Database Design, Relational Data Mapping, PL/SQL Tuning, ETL Tools, Analysis, Web Project Management, Quality Assurance (QA), Data Analysis, QA Testing, BizTalk, Data Visualization

  • Platforms

    Linux, Oracle, Windows

  • Frameworks

    Windows PowerShell

To view more profiles

Join Toptal
Share it with others
Hire the top 3% of freelance developers TM