Anthony is available for hire
Hire AnthonyAnthony Baxter
Verified Expert in Engineering
Senior Data Architect Developer
Chicago, United States
Toptal member since June 24, 2020
Bio
Anthony is an analytical and resourceful leader with over 25 years of experience in data engineering, database development, and process design and development. He has deep experience in the financial services industry and a keen ability to understand business and data requirements and customize value‐added applications. He's known for his expert skills in operations and risk management. Anthony is poised and intellectually curious, with executive-level written and verbal communication skills.
Portfolio
Tropicana Brands - Main
Data Management, Data Analysis, Data Governance, Architecture, Data Auditing...
PepsiCo - Omnichannel
SQL, Data Engineering, Microsoft Power BI, Database Modeling, Data Pipelines...
Fay Servicing
Tableau, SQL Server Reporting Services (SSRS), .NET...
Experience
- Data Engineering - 20 years
- SQL - 20 years
- Data Architecture - 20 years
- Business Analysis - 20 years
- Data Analytics - 15 years
- Database Development - 15 years
- Business Intelligence (BI) - 10 years
- Python - 8 years
Availability
Part-time
Preferred Environment
Tableau, SQL Server Management Studio (SSMS), Python, Snowflake, SQL, Microsoft SQL Server, SQL DML, T-SQL (Transact-SQL), Performance Tuning, Visual Basic for Applications (VBA), Excel VBA
The most amazing...
...application I've built implemented my team's mortgage default model that allowed a top five bank to estimate losses for their $6 billion mortgage portfolio.
Work Experience
Data Analyst | Data Engineer
2023 - 2024
Tropicana Brands - Main
- Conducted extensive research using CPG vendor data, US census data, and TBG data to identify new sales opportunities.
- Led data initiatives to migrate Tropicana's legacy systems (SAP, custom) to a streamlined system/data warehouse.
- Took charge of defining MDM rules and data governance processes.
- Collaborated with Tropicana stakeholders to understand and define future project initiatives.
- Assisted in the design and development of enhanced Tropicana reporting frameworks.
Technologies: Data Management, Data Analysis, Data Governance, Architecture, Data Auditing, Product Analytics, Microsoft Power BI, Snowflake, Excel 365
Data Engineer
2021 - 2023
PepsiCo - Omnichannel
- Designed and implemented a data model for a Power BI-built custom reporting dashboard used by C-level and upper-management executives.
- Analyzed CPG data and worked with stakeholders to develop smart solutions to efficiently fit their needs. Ultimately, worked not just as a data engineer but also as a process consultant.
- Functioned as a thought leader on the project, offering guidance on dashboard design and layout, process flow, stakeholder interactions, meeting presentations and agendas, and data transfer architecture.
Technologies: SQL, Data Engineering, Microsoft Power BI, Database Modeling, Data Pipelines, Data Warehousing, Reports, Stakeholder Analysis, Stakeholder Interviews, ETL, PostgreSQL, Microsoft SQL Server, SQL DML, T-SQL (Transact-SQL), SQL Performance, Performance Tuning, Data Queries, Data Migration, Scripting Languages, ETL Tools, Python, Data Modeling, Database Architecture, APIs, Data Integration, Agile, Data Science, Data Structures, Microsoft Excel, Excel Macros, Database Design, Data Architecture, Architecture, Enterprise Architecture, DB, Database Schema Design, Data Auditing, Product Analytics, Excel 365, Visual Basic for Applications (VBA), Automation, Microsoft Word
SVP, Data and Operational Risk
2016 - 2019
Fay Servicing
- Led and participated in the build and roll-out of processes that automated letter generation. The effort involved expert-level data engineering via rebuilding SQL Server database, developing .NET front-end, and redesigning existing vendor data feeds.
- Designed and built ETL packages using Microsoft SSIS, importing data from over 20 third-party vendors in various formats and exporting data to the firm's many financial services clients.
- Functioned as point person on a large-scale government process/data audit. Worked directly with auditors to further refine and confirm needs. Via t-SQL stored procedures, performed complex data requests and provided accurate, heavily-tested data.
- Analyzed processes of a majority of the firm's business units. Provided recommendations on work effort, probability of success, and priority. Led and participated in the process and technical redesigns, focusing primarily on data engineering.
- Led the effort to design and build a custom document management system in a Microsoft Azure and Microsoft SQL Server environment. The effort involved building data pipelines from 10 different sources of documents in the company.
Technologies: Tableau, SQL Server Reporting Services (SSRS), .NET, SQL Server Management Studio (SSMS), Azure, Data Engineering, Data Pipelines, Data Analytics, Business Intelligence (BI), MySQL, Microsoft SQL Server, SQL DML, T-SQL (Transact-SQL), SQL Performance, Performance Tuning, Data Queries, Data Migration, Scripting Languages, ETL Tools, Data Modeling, Database Architecture, APIs, Data Integration, Agile, Data Science, Data Structures, SQL Server DBA, Microsoft Excel, Excel Macros, Database Design, Data Warehousing, Data Architecture, Architecture, Enterprise Architecture, DB, Database Schema Design, Data Auditing, Product Analytics, Snowflake, Microsoft Power BI, Excel 365, Visual Basic for Applications (VBA), Excel VBA, Automation, Microsoft Word
SVP | Chief Technologist of Mortgages and Risk Operations
2006 - 2016
Neuberger Berman
- Designed and built a custom C#/SQL Server application platform called LoanDesk, which functions as the group’s central hub for conducting all forms of its business. Served as the chief data architect throughout LoanDesk development.
- Created ETL packages for both importing data from over 30 third-party vendors and clients and exporting data to accounting firms, investors, auditors, and third-party vendors.
- Used my expert-level t-SQL knowledge and performed a detailed analysis to create ad-hoc reports for upper-level management.
- Created a monthly reporting package detailing performance and analytics related to mortgage loans; presented reports to senior management on a monthly basis.
- Functioned as the point person on a large-scale government process/data audit. Worked directly with auditors to further refine and confirm needs, created detailed complex data requests, and provided accurate, heavily-tested data.
Technologies: SQL Server Reporting Services (SSRS), .NET, SQL Server Management Studio (SSMS), ETL, MySQL, Microsoft SQL Server, SQL DML, T-SQL (Transact-SQL), SQL Performance, Performance Tuning, Data Queries, Data Migration, ETL Tools, Data Modeling, Database Architecture, APIs, Data Integration, Data Science, Data Structures, SQL Server DBA, Microsoft Excel, Excel Macros, Database Design, Data Warehousing, Data Architecture, Architecture, Enterprise Architecture, DB, Database Schema Design, Data Auditing, Excel 365, Visual Basic for Applications (VBA), Excel VBA, Automation, Microsoft Word
Options Trader | Application Developer
2003 - 2006
Geneva Derivatives
- Managed and traded options from our own account on the CBOE floor in the pit that included Apple, Exxon, and Phillip Morris.
- Designed and built VBS-based models and applications used for calculating implied options data (volatilities, interest rates, dividends) which then integrated with industry-standard options market-maker system.
- Created a reporting system used by traders and management to evaluate risk and performance.
Technologies: SQL, C++, Data Analysis, Trading Systems, Trading, ETL, Data Queries, APIs, Data Integration, Data Structures, Microsoft Excel, Excel Macros, Excel 365, Visual Basic for Applications (VBA), Excel VBA, Automation
Technology Consultant
1997 - 2003
Accenture
- Redesigned the process flow at a Fortune 500 company that streamlined their trading operations; also worked on the technology team that implemented the newly-designed process.
- Worked at the Accenture.com Launch Center, the company's foray into online stores. Used SQL, Java, and JavaScript and worked as part of the team that built iFlourish.com, a web store that specialized in healthcare products.
- Designed and built various prototype mobile phone websites, one of which was used by Accenture in the firm's marketing brochures.
Technologies: Data Analysis, SQL, C++, C, ETL, Oracle, Database Architecture, APIs, Data Integration, Data Structures, Database Design, Data Warehousing, Data Architecture, DB, Database Schema Design, Excel 365
Experience
LoanDesk
A SQL-Server and .NET standalone application used by the business team to manage its 20,000 loan, $3 billion mortgage loan portfolio. It consolidated over 15 data feeds and allowed the team to manage all loans in a consistent, well-documented manner. I designed and implemented the complex database schema, oversaw the build-out of the import of the feeds into the database and designed the front-end windows and processes. Once LoanDesk was rolled out, I headed up the decision-making in all upgrades and bug fixes.
Executive Sales Dashboard
A Power BI-based reporting suite designed for sales analysis for executives.
PepsiCo is composed of three silos - Pepsi Beverage, Frito Lay, and Quaker Oats. All data for the three is stored differently in various locations. The project was to create Power BI dashboards that showed sales/analytics at the PepsiCo level.
I had multiple roles on the project:
• As a data engineer lead, I designed and implemented a data model that standardized sales, marketing, and promotion data across PepsiCo's business units. I also guided other team members in automating the data model's population and functioned as a data expert on the project.
• As a dashboard designer and developer, I designed and built dashboards using the above data model and Power BI.
• As a techno-functional analyst, I was the primary intermediary between the business units and developers. I worked to understand the business's needs by interviewing people in various roles and examining currently used reports. In conjunction with stakeholders, I designed reports/dashboards incorporating new analytics (given my knowledge of all available data). I also translated new report designs into technical specifications for developers.
PepsiCo is composed of three silos - Pepsi Beverage, Frito Lay, and Quaker Oats. All data for the three is stored differently in various locations. The project was to create Power BI dashboards that showed sales/analytics at the PepsiCo level.
I had multiple roles on the project:
• As a data engineer lead, I designed and implemented a data model that standardized sales, marketing, and promotion data across PepsiCo's business units. I also guided other team members in automating the data model's population and functioned as a data expert on the project.
• As a dashboard designer and developer, I designed and built dashboards using the above data model and Power BI.
• As a techno-functional analyst, I was the primary intermediary between the business units and developers. I worked to understand the business's needs by interviewing people in various roles and examining currently used reports. In conjunction with stakeholders, I designed reports/dashboards incorporating new analytics (given my knowledge of all available data). I also translated new report designs into technical specifications for developers.
Education
1995 - 1997
Master of Business Administration Degree in Finance
University of Notre Dame - Notre Dame, IN, USA
1992 - 1996
Bachelor of Science Degree in Computer Engineering
University of Notre Dame - Notre Dame, IN, USA
Skills
Libraries/APIs
REST APIs
Tools
MySQL Performance Tuning, Microsoft Excel, Microsoft Word, Tableau, Microsoft Power BI, Slack
Languages
Visual Basic for Applications (VBA), Excel VBA, Python, SQL, T-SQL (Transact-SQL), SQL DML, C#.NET, Java, Snowflake, C++, C
Paradigms
Database Development, ETL, Database Design, Agile, Automation, Business Intelligence (BI)
Storage
Databases, SQL Server Integration Services (SSIS), SQL Server 2016, SQL Performance, Microsoft SQL Server, Database Performance, Database Architecture, PostgreSQL, MySQL, Data Integration, SQL Server DBA, DB, NoSQL, SQL Server Reporting Services (SSRS), SQL Server Management Studio (SSMS), Data Pipelines, Database Modeling
Frameworks
.NET
Platforms
Azure, Oracle, Amazon Web Services (AWS)
Industry Expertise
Trading Systems
Other
Business Analysis, Data Analysis, Data Visualization, Analytics, Data Engineering, Design Leadership, Data Architecture, Process Design, Performance Analysis, Performance Tuning, Data Warehousing, Data Warehouse Design, Data Queries, Data Migration, Scripting Languages, ETL Tools, Leadership, Risk Management, Critical Thinking, Data Modeling, APIs, Data Science, Data Structures, Excel Macros, Architecture, Enterprise Architecture, Database Schema Design, Data Governance, Data Auditing, Product Analytics, Excel 365, Microsoft 365, Business Intelligence Architecture, Data Analytics, Data Profiling, Operations, Trading, Reports, Stakeholder Analysis, Stakeholder Interviews, Data Management
Collaboration That Works
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
1
Share your needs
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
Choose your talent
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
Start your risk-free talent trial
Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.
Top talent is in high demand.
Start hiring