Adam Diamond
Verified Expert in Engineering
Software Developer
Los Angeles, CA, United States
Toptal member since November 19, 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!
Portfolio
Experience
- Microsoft SQL Server - 20 years
- Database Design - 20 years
- Database Architecture - 20 years
- SQL - 20 years
- Database Modeling - 20 years
- SQL Server Integration Services (SSIS) - 19 years
- Business Intelligence (BI) - 18 years
Work Experience
Business Intelligence Database Consultant (SQL Server)
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.
Database Consultant
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.
Project History
Healthcare Industry - Revenue-Increasing Decision Support Application
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.
Education
Bachelor of Science Degree in Mathematics
UCLA - Los Angeles, CA, USA
Skills
Tools
Erwin
Languages
JavaScript, SQL, Transact-SQL (T-SQL)
Paradigms
Database Design, Business Intelligence (BI), ETL
Storage
SQL Server Integration Services (SSIS), Database Modeling, Database Architecture, Microsoft SQL Server, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server 2012, SQL Server 2014, SQL Server 2017, Sybase, IBM Db2, PL/SQL, MySQL
Platforms
Oracle
Other
Remote Team Leadership, Project Planning, Embedded Software, Microsoft Data Transformation Services (now SSIS), Data Architecture, Data Modeling, Data Engineering, MicroStrategy
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring