Adam Diamond, Software Developer in Los Angeles, CA, United States
Adam Diamond

Software Developer in Los Angeles, CA, United States

Member since September 26, 2019
Adam architects and develops database and BI solutions without any unnecessary complexity that are efficient to develop, can be completed within aggressive timelines, and are easy to understand, maintain, and expand. His preferred environment includes MS SQL Server, SSIS, and SSRS. He has 20+ years of experience and a 100% project success rate - no failures!
Adam is now available for hire

Portfolio

Experience

Location

Los Angeles, CA, United States

Availability

Part-time

Preferred Environment

SSRS, SQL Server Integration Services (SSIS), SQL

The most amazing...

...app I've built was for a large healthcare company, flagging missed ICD9 diagnoses to increase patient HCC scores—increasing revenue by $3,000,000+ per year.

Employment

  • Business Intelligence Database Consultant (SQL Server)

    2013 - 2019
    Circor International
    • Served as a solutions architect, data architect, database developer, ETL developer, and team lead for the corporate data warehouse of purchase and sales data.
    • Worked with business and IT resources across the USA, Europe (England, France, Italy, and Germany), India, China, and Brazil to populate the data warehouse.
    • Successfully led the re-architecture of complex nightly ETL process to populate the corporate data warehouse with purchase, receipt, inventory, and supplier data from 22 separate ERP systems.
    • Created additional algorithmically complex processes to report on “On Time Delivery” and “Baseline Savings” metrics.
    • Created an additional system to create sales forecasts for several business-units of Circor International, using extremely complex and sophisticated mathematical calculations and algorithms.
    Technologies: SQL Server Integration Services (SSIS), MicroStrategy, SQL Server 2017, SQL Server 2014, SQL Server 2012
  • Database Consultant

    1997 - 2013
    Project-based Database Consultant
    • Contributed to a variety of projects including OLTP, data warehouse, ETL, data integration, data migration, production support, pre-production support, new systems development, business intelligence, and performance improvement.
    • Worked with a large variety of clients including Nissan, Toyota, AIG, BofA, Wilshire Associates, USC Marshall School of Business Administration, UCLA School of Public Health, DaVita, Health Care Partners, Yahoo!, and IBM.
    • Acted as the lead database architect and ETL developer of a multi-terabyte POS system, housing data received from POS systems of various clients in the food and beverage industry such as Marriott, Dave & Busters, and Daphne’s Greek Cafes.
    Technologies: PL/SQL, T-SQL, Erwin, SSRS, SQL Server Integration Services (SSIS), MySQL, IBM DB2, Sybase, Oracle, Microsoft SQL Server

Experience

  • Healthcare Industry - Revenue-Increasing Decision Support Application (Development)

    Led the redesign of the HCC application for the Decision Support Team of Health Care Partners (formerly Physician Associates), including developing a set of new diagnosis-analysis reports, allowing medical physicians to consider potentially-missed ICD9 diagnoses that would increase the HCC scores of their Medicare patients.

    These efforts resulted in an increase in Medicare revenue stream by over $3 million beyond company projections, and a 15% increase in projected HCC scores for the following year alone.

Skills

  • Languages

    JavaScript, SQL, T-SQL
  • Paradigms

    Database Design, Business Intelligence (BI)
  • Storage

    SQL Server Integration Services (SSIS), Database Modeling, Database Architecture, Microsoft SQL Server, SQL Server Reporting Services (SSRS), SQL Server 2012, SQL Server 2014, SQL Server 2017, Sybase, IBM DB2, PL/SQL, MySQL
  • Other

    Remote Team Leadership, Project Planning, Embedded Software Engineer, MicroStrategy
  • Tools

    SSRS, Erwin
  • Platforms

    Oracle

Education

  • Bachelor of Science degree in Mathematics
    1991 - 1996
    UCLA - Los Angeles, CA, USA

To view more profiles

Join Toptal
Share it with others