Reeves Smith Email & Phone Number

Littleton, Colorado, Us

• Designed a reliable backend for logistics management reconciliation analytics using Snowflake, Netsuite, and Airbyte.• Developed a comprehensive marketing analytics system on Snowflake, leveraging the power of Stitch, Airbyte, Dagster, dbt, and Snowflake Scripting.• Designed and implemented auto industry data integration from CRM into Snowflake, leveraging the power of MuleSoft and Snowflake Scripting.• Implemented a comprehensive clinical studies data integration and analytics solution for a major Pharmaceutical client utilizing AWS Redshift, Apache Airflow, and EMR.• Successfully set up Active Directory Integration and AWS PrivateLink for Snowflake configuration.• Created a high-performance Snowflake Analytics platform on AWS, seamlessly integrating Spark for a Financial client.• Designed an efficient Master Data Integration solution that connected an on-premises ERP system to Salesforce, utilizing MDS, Azure SQL, and Logic Apps.• Implemented a large-scale data integration on Snowflake, handling approximately 1.5 Petabytes of data for IoT network traffic. • Successfully migrated Snowflake's ETL processes from PowerShell/SnowSQL to the more reliable Apache Airflow.• Deployed and operationalized an R Model in Azure Machine Learning to facilitate seamless integration with Salesforce.• Implemented a Cluster Model in Microsoft Azure, effectively operationalizing it through a mobile application tailored for the Real-Estate industry.• Designed a robust Enterprise Data Warehouse architecture catering to the needs of a large casino and gaming client operating across multiple business systems and countries.• Conducted a comprehensive audit of a Healthcare Business Intelligence and predictive application, resulting in the delivery of a redesigned and improved architecture.

San Francisco, California, Us

Austin, Texas, Us

Seattle, Wa, Us

• Designed and developed a Master Data Services model to manage accounts, cost centers, and other financial entities effectively.• Built a comprehensive and integrated ETL Framework specifically tailored for Oil and Gas industry financials and production data.• Undertook the redesign of a Healthcare Business Intelligence application, enhancing its capabilities to provide deeper insights and analytics within the organization.• Offered architectural guidance and recommendations for scaling an Analysis Services Tabular model.• Led a team in resolving application performance issues with a resort application.

Fredericksburg, Virginia, Us

• Assumed leadership of a technical team in the design of the application architecture for financial reporting in military appropriations.• Effectively transferred the project onto the DOD network (MCW) while ensuring full accreditation was obtained.

Irvine, Ca, Us

• Provided leadership to a team that successfully delivered a robust Business Intelligence Framework on SAP, Oracle, and SQL Server for a client in the Oil and Gas industry.• Accomplished the successful delivery of the pioneering CountERPart offering, which combined Microsoft BI and SAP technologies, within Neudesic.• Designed and developed a highly reliable integrated ETL Framework within Integration Services, seamlessly connecting to SAP ECC and BI/BW systems.

Littleton, Co, Us

• Successfully completed the migration of Business Intelligence applications for a Banking client to a new infrastructure.• Designed the architecture for a financial reporting application, incorporating Disaster Recovery (DR) measures.• Executed a robust implementation of a Master Data Management process, utilizing SharePoint and Integration Services, to ensure seamless data governance and integration across the organization.

Redmond, Washington, Us

• Designed an efficient Business Intelligence Solution for a School District, facilitating the migration from MicroStrategy 8.• Conducted performance tuning to optimize an Oil and Gas application, allowing for a reduced load window.• Successfully addressed and resolved performance issues related to MDX/Analysis Services, resulting in reports meeting business standards.

Santa Monica, California, Us

• Redesign of key financial aspects within the Vongo Data Mart (Pre-Netflix Streaming Service), utilizing Sybase IQ Columnar.• Developed analytics reports in SQL Server Reporting Services 2005, extracting data from both Sybase ASE and Sybase IQ databases.

Us

• Designed and developed an Analysis Services 2005 Data Mart specifically tailored for Financial business processes.• Designed and Configured companywide reporting architecture and standards

Louisville, Ky, Us

• Created customized ASP.NET C# Web Forms to seamlessly integrate custom reports within the Infinite Campus system.

Us

• Developed integrated ETL of external data providers into the Groople.com website• Responsible for reporting architecture in SQL Server Reporting Services against source system and Analysis Services 2000 Data Mart

London, Gb

• Lead DBA for SQL Server performance tuning and deployment issues with the JD Edwards OneWorld ERP application• Wrote the JD Edwards SQL Server 2000 Tuning Guide and presented it at the Quest Global Conference 2002

• Designed and developed a configuration management application and database specifically tailored for asset management within the Utilities industry.• Created an N-Tier enterprise facilities management application, leveraging ADO and SQL Server 7.0/2000 technologies.

Aurora, Co, Us

• Designed and Developed SQL Server ETL process to load external data into accounting software application

Basking Ridge, Nj, Us

• Designed and Developed Visual Basic client-server applications utilizing Access and SQL Server• Created custom Excel automation and reporting solutions

Bachelor Of Science - Bs, Applied Mathematics

Aviation Technology

General Studies