Elbert Scott II
Verified Expert in Engineering
Data Engineer and Developer
Dallas, TX, United States
Toptal member since June 6, 2024
Elbert is a data engineer with a 20-year career in information technology, specializing in ETL database development, ETL production support, report development, and configuration management. With extensive experience in ETL development utilizing tools like SSIS and T-SQL, and report creation using SSRS or Power BI, Elbert is eager to contribute to ETL, BI lead positions, and roles in data architecture.
Portfolio
Experience
- SQL - 20 years
- Relational Databases - 20 years
- T-SQL (Transact-SQL) - 12 years
- SQL Server Integration Services (SSIS) - 7 years
- SQL Server Reporting Services (SSRS) - 7 years
- Business Intelligence (BI) - 7 years
- Data Warehousing - 7 years
- Data Modeling - 7 years
Availability
Preferred Environment
Microsoft, SQL Server Integration Services (SSIS), SQL, T-SQL (Transact-SQL), SQL Server Reporting Services (SSRS)
The most amazing...
...data model I constructed included all essential stored procedures for a new margin calculator application employed by a travel nurse placement firm.
Work Experience
Data Engineer
Experis Manpower Group
- Created and modified ERP reports as part of the geographic information system (GIS) reporting team and data visualizations in the Arcadia/Cloudera data visualization tool based on user-provided requirements.
- Developed and modified Cloudera Data Warehouse (CDW) datasets used in existing and newly created data visualizations. Calculated fields were created using the CDV expression language.
- Administered user access using appropriate user roles and CDV workspaces that adhere to the corporate user access policy.
Data Engineer
Salient Management Co.
- Optimized the loading process in PostgreSQL by breaking larger functions into smaller segmented functions organized by date range and record type. This reduced loading time from over 8 hours to less than 5 minutes.
- Created an SQL Server stored procedure to loop through a table with date ranges, which was used in a Dynamic SQL statement to insert data into a dynamically created table.
- Worked with various tools and environments, including T-SQL, SQL Server 2019, SSIS, SSRS, Visual Studio 2017/2019, and SQL Server Data Tools 2017.
Senior Enterprise Data Warehouse Developer
CTI Partners Consulting
- Developed logical and physical data models with entity relationships, forming a denormalized schema to report on healthcare data. A physical data model created data definition language (DDL) statements to prompt a new reporting schema.
- Acted as a part of the enterprise data warehouse (EDW) team and identified all source tables by reviewing complex SQL generated from the source systems' native reports.
- Migrated the financial reports from Excel to SQL Server Reporting Services (SSRS). Translated complex Excel formulas into requirements used for creating SSRS reports.
Experience
Event Management
• The ability to schedule and reschedule events.
• A feature for event organizers to allocate batches of tickets of different categories, such as VIP and Upper Deck, to ticket resellers for an event.
• An interface for customers to buy tickets to scheduled events.
• A reporting feature to show the quantity of tickets available from each ticket reseller.
• A feature to track and display the count of tickets sold and issued by ticket resellers.
• A reporting function to display monthly reseller commission.
Education
Master's Degree in Computer Science
Boston University - Boston, MA, USA
Bachelor's Degree in Computer Science
Jackson State University - Jackson, MS, USA
Certifications
MTA: Database Fundamentals
Microsoft
Skills
Tools
Microsoft Power BI, Cloudera
Languages
SQL, T-SQL (Transact-SQL)
Storage
Relational Databases, Databases, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Azure SQL, SQL Server 2019, SQL Stored Procedures
Paradigms
ETL, Dimensional Modeling, Business Intelligence (BI)
Platforms
Microsoft, Arcadia
Other
Data Engineering, Data Warehousing, Data Modeling, Data Architecture, Data Migration, Software Design, Software Development, Normalization, Reporting, Optimization, Entity Relationships
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