Andrew Vold Email & Phone Number

Denver, CO, US

• Major Projects Include:
• Assisted in architecture and development of a Viewership Data Lake for major telecom organization on Hortonworks HDP platform.
• Built a reporting data mart for major telecom organization using SQL Server 2016 for storage and ETL. Sourced data from JSON files, MongoDB, Oracle, Teradata, and SQL sources. Final reporting created in Tableau. Data.
• Assisted client in learning how to ingest HDFS based files into their current SQL database using Hive tables and SSIS ETL to orchestrate data movement.
• Performed in-depth assessment of the current reporting and analytics tools utilized by a major telecom organization. Created a recommendation for tool consolidation to help remove redundancy, fit the long term.
• Assisted in architecture and development of a financial data mart for an organization with multiple business units. Solution included complex, custom built, row level data security model.

Business Intelligence development.

• Responsible for keeping checking account in balance.
• Assists during fundraising events to ensure proper and accurate money flow.
• Responsible for purchasing goods deemed beneficial for the user group.
• Responsible for increasing group sponsorship.

• Perform DBA role on two SQL Server 2005/2008 production servers.
• Transact-SQL programming.
• Report development and deployment using SQL Server Reporting Services (SSRS).
• ETL development and deployment using SQL Server Integration Services (SSIS).
• Perform Administrator role on 3rd party software application: Duties include daily monitoring and maintenance, upgrade and patch installations, enhancements testing, issue resolution and user support.
• Program VBA projects to automate tasks in MS Excel, Word and Outlook.

• Administrator of an ERP system servicing 250 internal customers. Responsibilities include daily maintenance, upgrade installation, security configuration, disaster recovery planning, testing of enhancements, help desk.
• Develop and deploy departmental and enterprise level business intelligence solutions using Crystal Reports XI.
• Develop and deploy solutions into ERP system to capture key business intelligence information.
• Use project management skills to lead the implementation of complex scheduling module to the company’s ERP system.
• Use project management skills to lead the integration between ERP system and outside vendor software packages using SQL commands inside Visual Basic scripts.
• Develop, document and implement training and workflow process documentation using MS Word and MS Visio.