Kelly Anderson, CPA, MCSE
Verified Expert in Engineering
Data Engineer and Developer
Laguna Beach, CA, United States
Toptal member since January 19, 2024
Kelly is a data analyst and engineer whose career began in accounting and finance. Over the past 20 years, he has worked for large companies like Netflix, CBRE, and Thomson Reuters. He enjoys all things data and has passed 12 professional exams, helping him keep up with new tools and technologies. This background and continuing education have enabled Kelly to contribute to many successful projects and solutions—including automating the delivery of 1+ million rent statements in eight years.
Portfolio
Experience
- Visual Basic for Applications (VBA) - 15 years
- SQL - 15 years
- T-SQL (Transact-SQL) - 15 years
- SQL Server Reporting Services (SSRS) - 10 years
- SQL Server Integration Services (SSIS) - 10 years
- Tableau - 8 years
- Python - 5 years
- Pandas - 4 years
Availability
Preferred Environment
SQL, Python, Tableau, Pandas, SQL Server Integration Services (SSIS), Visual Basic for Applications (VBA), T-SQL (Transact-SQL), SQL Server Reporting Services (SSRS), Trading
The most amazing...
...thing I've developed is a data-driven SSRS report, which automated the delivery of over 1 million tenant rent statements in eight years.
Work Experience
Production Finance Tax and Vendor Data Engineer (Contract)
Netflix
- Maintained and enhanced data pipelines and reports crucial for compliance with regulatory requirements.
- Collaborated closely with production finance and corporate finance teams to manage and reconcile vendor data across all Netflix productions, concurrently developing processes for aggregating vendor taxable data.
- Facilitated data analysis, aggregation, and reporting to support key reporting requirements with the IRS—demonstrating my strong SQL and Python skills and a deep understanding of accounting and finance fundamentals.
Business Systems Advisor | Senior Business Systems Analyst
CBRE
- Developed ETL scripts and SSIS packages to create data pipelines for moving financial information between accounting systems and internal and external data warehouses for reporting and integrations.
- Executed large-scale data modeling, conversions, integrations, analytics, and visualizations using SQL Server technologies and reporting tools in conjunction with the internal accounting system called MRI Software.
- Designed, developed, and implemented a custom SSRS solution using data-driven subscriptions that successfully delivered 14,000+ emailed tenant statements monthly.
Experience
Test Data Pipeline in Snowflake
https://github.com/anderskd12/Snowflake-Data-Pipeline-Project-using-DBT-Python-Streams-Tasks/Education
Bachelor's Degree in Accounting and Management Information Systems
University of Wisconsin–Eau Claire - Eau Claire, Wisconsin, USA
Certifications
SnowPro Core Certification
Snowflake
MCSE: Data Management and Analytics
Miscrosoft
Certified Public Accountant
Wisconsin Department of Safety and Professional Services
Skills
Libraries/APIs
Pandas
Tools
Tableau, Apache Airflow
Languages
SQL, Visual Basic for Applications (VBA), T-SQL (Transact-SQL), Python, Snowflake
Storage
Databases, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Data Pipelines, PostgreSQL, SQL Server Analysis Services (SSAS)
Paradigms
ETL, Business Intelligence (BI)
Industry Expertise
Accounting
Other
Data Matching, Excel 365, Data Engineering, Data Analysis, Business Requirements, Trading, Dashboards, Data Visualization, Data Build Tool (dbt), Finance, Information Systems, APIs, MRI Software
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