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 mart contained data for millions of subscribers.• 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 organizational goals, and save the organization millions of dollars in licensing and training fees on a going forward basis.• 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.• Architected and built a data mart, containing many financial calculations such as NAV, DPI, MOIC and IRR, for a private equity organization.• Built a billing code database for a major telecom organization; used as a division wide source of record.• Helped architect and build a work order data mart for a major telecom organization to capture specific business metrics related to orders. The data mart is used as a division wide source of record for multiple reporting projects.• Built multiple commission calculation engines for major telecom organization. Responsible for paying commissions to nearly 2,000 individuals.• Re-architected existing platform to solve for growth and changing requirements for major education district.• Architected and built solution for major education district to submit confidential data to a state agency.

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.• Miscellaneous IT related duties including on-site server monitoring, backup monitoring and first line contact with IT support provider for on-site servers.• Data Processing for direct mail campaigns using BCC MM2010 software.• Documentation Development.

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 support and end user training. Other responsibilities include data analysis, report development, workflow development, and management of all data processing and variable data processing operations.• 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.• Develop simple and complex MS Excel spreadsheets to manage internal needs and customer specific projects.