Jacob Smith Email & Phone Number

St. Louis, Mo, Us

Granite City, Illinois, United States

- Develop and grow team skill sets in data extraction, modeling, and analysis. - Evaluate current data analytics strategies and work with team in developing recommendations and improvements - Responsible for data analysis and requirements gathering with all levels of the company up through executive levels. - Develop programs and systems to access and gather data as needed from many systems. - Responsible for report, dashboard, and visualization design - Analyze business processes and requirements - Provides systems and guidance on data topics for ERP systems - Maintain a knowledge base through proper, accessible documentation on business intelligence processes including data quality controls, field mappings, and training materials - Identify opportunities to improve processes and strategies with technology solutions - Deliver training and webinars on business intelligence to company

Granite City, Illinois, United States

- Responsible for data analysis and requirements gathering with all levels of the company up through executive levels. - Responsible for data extraction, modeling, and architecture with multiple database systems. - Create reports, dashboards, and visualizations design in tools like SQL Server, PowerBI, Analysis Services. - Act as subject matter expert on other systems and the evaluation of tools like Cognos, Qliksense, Tableau, and cloud analytics solutions. - Provide assistance and guidance on data topics for ERP systems like PeopleSoft, Syteline, HP3000, AS400, and other ODBC-compliant systems. - Develop programs and systems to access and gather data as needed from many systems. - Responsible for leading and managing teams both day-to-day within IT, and cross-departmental project teams.

Granite City, Il

- Work to develop and support a Business Intelligence solution for entire company o Consolidate data from various sites using data extractions and ETL processes o Create standard data models to be used for company dashboards and reports o Research and evaluate which BI tool will work best for company- Assist in application development and support (AS400, HP300, HighJump WMS, etc.)- Administer company’s instance of Cognos BI and other legacy company systems

Granite City, Il

- Install, configure, and support the organization’s network infrastructure. - Assist by analyzing user needs and designing software solutions which includes encoding, testing, debugging and documenting programs and systems. - Lead reporting efforts by develop business reports for entire company using Cognos BI suite- Implement and manage all company communication technologies (voice, video, email, etc.)- Administer company IT help desk and provide IT troubleshooting for entire company. - Be the administrator/developer for IT systems; including: Active Directory, Exchange, VMWare vSphere, MS servers, SQL server, SSIS, Cognos BI, Salesforce, Xenmobile MDM, Citrix, Office 365, Sharepoint, Star2Star VoIP Phone system, Axis Security Camera system, Veeam Backup and Replication, and AS400 (ERP).

Granite City, Il

- Provide technical support for entire company- Leverage Cognos for the entire companyo Write and troubleshoot Cognos reports and querieso Build and maintain both the Cognos Framework as well as the data warehouse (MS SQL Server)o Design and build the upload of company information to the data warehouse using SSIS- Develop and edit programs used for ERP system (IBM AS400/iSeries)- Help administer the network, Active Directory, MS Exchange, MS Servers, and Citrix Xenapp servers- Act as administrator and developer for Salesforce.com (Certified Administrator)- Train users on IT resources, including Cognos

Bachelor, Information Technology

with a Minor in History

High School