Post Job Free

Resume

Sign in

Data and Reporting Soecialist

Location:
Coeur d'Alene, ID
Posted:
December 31, 2022

Contact this candidate

Resume:

Martin White

**** *. *** – Coeur D'Alene, ID ****4 – 208-***-**** – adudhj@r.postjobfree.com

Expert Information Technology Specialist who is a consistently Successful Information Manager, Visual Basic Analyst and Database Specialist providing user interface in the development of cutting-edge information organization, improving work-life culture and enhancing functionality with custom business solutions. Continuing to innovate with analytics and reporting has been a primary focus for my career. Automation is something that has also come to add value to the companies I have worked with in my career.

Computer Skills:

Programming Languages:

o Visual Basic/Development, Structured Query Language (SQL) Savvy, o Learning C#

o Python 3.5, 3.7, 3.8

o SAS 8.2 Enterprise Guide

Microsoft Office Competence:

o SharePoint 2016

o SharePoint 2013 and 2010

o Power BI

o Outlook (Exchange 2013) including web app administration o Access, Word, Excel, PowerPoint, Project, SQL Server 2005 Implementation, Design, and Maintenance

Database Experience:

o MSSQL (2014 and 2016) SQL Server Analysis and Reporting Services (SSRS) o Oracle 10g, 11g, and 12c SQL installation and interaction o MSSQL (2012 and 2014) SQL installation and interaction

Custom Report Design

Excellent Problem Solving Abilities Targeting Faster Data Retrieval

Customized Database Design

Employee Friendly Interface Technology Creation

Active Directory/GPO

Familiar with Linux Ubuntu, PC linux, Mandriva and some tools and terms

Proficient running, punching down, and terminating Ethernet Cat6 cable Professional Achievements:

Business Intelligence Analyst February 2022 - Present Idaho Forest Group - Athol, ID

Worked with Windows Task scheduler Export, Transformation, and Load processing from flat files to database

Utilized SQL, SSIS, and Power BI to produce dashboard solutions for management business analytics. Innovative thinking and customer services provided to best support production needs.

Worked with Contractors and vendors to manage customer needs while providing business dashboards to be used for business data analytics

Used SQL Service Integration Services (SSIS) package, Windows Scheduled tasks, and Batch file language for scheduled ETL processing. Python was an alternative language available as needed based on project scope. Data And Reporting Analyst 2020 - 2022 US Bank Corp – Coeur D' Alene, ID

Worked with Windows Task scheduler Export, Transformation, and Load processing from flat files to database

Worked with PowerBI building reports for KPI and management purposes

SharePoint 2016, Maintaining central documentation repository

SharePoint 2010 and 2013 to 2016 migration assistance moving lists and document libraries to the new SharePoint platform.

Documented critical software and built Team SharePoint dashboard / wiki solutions

Accessing Internal systems remotely with Citrix

Utilized python 3.5, 3.7, and 3.8 to work with file prep and cleanup tasks.

Utilized Toad and SSMS to access various data sources utilizing SQL language to analyze data. Data Control Specialist 2019-2020 Health Resource Group (HRG)- Spokane, WA Troubleshooting proprietary database automation scheduling software (JobAgent), including log analysis and file manipulation to help with Export, Transformation, and Load processing from flat files to database importing

Worked with MSSQL database 2016 technology, including Microsoft SQL Server Reporting Services (SSRS) 2014 building reports for KPI and management purposes

SharePoint 2016, Maintaining central documentation repository

Documented critical software and built Team SharePoint dashboard / wiki solutions

Accessing client systems remotely with Citrix

Data Control Specialist (Contract to HRG) 2018-2019 Volt Workforce Solutions - Spokane, WA

Assisting with Data Automation Visual Basic (VBA) programming

Also worked with documentation utilizing SharePoint to assist with migration from network to web technology

Remotely access virtual environments by way of vSphere and other VMWare utilities

Built Excel form to help with month end processing

Innovation focusing to improve process by audit and review converting spreadsheets to SharePoint solutions Software Support Specialist 2017-2018 Pathology Associates Medical Laboratories (PAML)- Spokane, WA Troubleshooting Horizon Medical software, Oracle 11g, Windows Server 2008, Windows Server 2012 R2 Worked with Oracle and MSSQL database technology, assisted troubleshooting Toxicology department VLAN SharePoint 2013, attended Seattle SharePoint Conference 2017 for training

Documented critical software and maintained central repository in SharePoint

Microsoft CRM dynamics utilized for contact management database

Completed Introduction to python programming training via Microsoft Online Training course Software Support Specialist (Contract to PAML) 2016-2017 Volt Workforce Solutions - Spokane, WA Assisting with Windows Server 2008, and Windows 2003 Server decommission project Also worked with hardening and securing Windows 2003 Servers to become legacy critical systems Remotely access client work stations by way of Webex technology and TightVNC software Software Support Specialist 2015-2016 VPI Quality Windows - Spokane, WA

Troubleshooting software including Maintenance Coordinator, Windows Server 2008, and MSSQL 2012

Time management of multiple projects related to Main ERP Cantor Window Manufacturing Software Microsoft Outlook 2013 and exchange web app administration

Documented SOPs for critical systems to ensure future of fluid training opportunities

Crystal Reports, SQL Reporting Development, Network switch, Printer configuration, Microsoft Automation Software Support Specialist 2012 - 2015 AssetWorks Inc. - Spokane Valley, WA

Troubleshooting proprietary software including IIS, Windows Server 2008, and Database Functionality

Time management of multiple projects while on a direct phone queue with clients

Remotely access client work stations by way of Webex technology. Utilize SQL to make logical decisions IT Guru/ Local Facility Contact 2010 - 2012 Anchor House - Coeur d’Alene, ID

Troubleshooting various computer related and system issues including audio, visual, MS software

Have been considered for reporting solutions in regard to facility and industry specific data Founder and Developer 2010 - 2011 Martin R. White - Post Falls, ID

Custom Programming and Interface development for clients to Manage Information

Develop User-friendly Computer instructions to target specific Clients software applications

Educate clients on benefits of automated Reporting by means of database technology Implementation and Development 2009 - 2010 SUNSHINE MINTING INC - Coeur d’Alene, ID Reviewed template documentation for formula and functional accuracy as well as developing a logically organized folder structure for data storage.

Analyzed QA and Production functionality to promptly report data based on current data entry & increased productivity to bridge an internal departmental relational gap.

Collaborated with Supervisor to create customized QA Computer related Instruction.

Designed automated reporting database to manage production statistics and performance. Reviewed template QA documentation for formula and functional accuracy as well as developing a logical folder structure to order data storage

Assistant Summer Youth Event Planner - Coeur d’Alene, ID Summer 2009 Planned and directed an end of summer youth event

Education & Professional Development:

Cornerstone Online Learning

Business Reporting: Getting Started with Power BI Desktop for Data Analysis - 2021 Data Analytics Using Power BI: Concepts - 2021

Data Analytics Using Power BI: Data Sourcing and Preparation - 2021 Data Analytics Using Power BI: Data Modeling and Visualization - 2021 Business Reporting: Visualizing & Merging Data in Power BI - 2021 Microsoft Online Learning

Microsoft SharePoint 2013 Essentials – 2018

Introduction to Programming with Python – 2018

Software Development Fundamentals – 2018

Introduction to XAML – 2018

Windows 10: Top Features for IT Pros – 2018

New Horizons Learning Center

WRITING QUERIES USING MS TRANSACT SQL – 2010

IMPLEMENTING A MS SQL SERVER 2005 DATABASE – 2010

ACCESS 2003 Level 2 – 2007

ACCESS: IMPROVING EFFECTIVENESS OF DATABASE – 2007 ACCESS: ANALYZE DATA WITH ADVANCED QUERIES – 2007

Bachelor’s Degree in Mathematics (Computer Science Minor) 2006 YORK COLLEGE - York, NE Associate’s Degree in Science

YORK COLLEGE - York, NE 2004



Contact this candidate