Benjamin Olson Email & Phone Number

Saint Paul, MN, US

Vadnais Heights, MN, US

- Migrating SAP Business Objects Data Services ETL processes responsible for Global Supply Chain data into an SSIS SQL Server Global BI eco-system.- Developing parameterized, re-usable SSIS packages to Extract, Transform, and Load data into multiple databases. Typical data flow consists of SAP / Prism ERP System > ODS / ODS > STG / STG > EDW.- Designing.

Minneapolis, MN

- Developing Informatica Workflows and Mappings in order to Extract, Transform, and Load data into multiple location types such as Peoplesoft/Oracle and SQL Server.- Developing CA Workload Automation applications to schedule automated execution of jobs, as well other ETL process management.- Designing and creating SQL Views, and Stored Procedures based on.

Bayport, Minnesota, US

- Developing SSAS Tabular models using SSDT 2017 Azure and OnPrem- Working with Github and Azure for source control and DevOps- Building Power BI reports leveraging Dax, Power Query, and M languages- Setting up team workspaces and building dashboards in Power BI Service- Configuring scheduled refreshes on an Enterprise Gateway- Leveraging Mulesoft to.

Cottage Grove, MN, US

- Leading development team meetings. Facilitating code reviews and designing application architecture.- API back end design, integration, and implementation. - Managing and Administrating Databases including but not limited to maintenance plans, query optimization, storage specifications, and migration plans.- Developing SSIS packages in order to Extract.

Cottage Grove, MN, US

- Gathering technical business requirements, in order to build out a Data Warehouse that consists of various disparate data sources > SSIS > SQL/TSQL > MDS/MDM > ODS > DW > PowerBI.- Developing SSIS packages in order to Extract, Transform, and Load into multiple DBs including the Microsoft MDS/MDM platform.- Designing and creating Views, Functions, Stored.

Minneapolis, MN, US

- Gathered business requirements, built SQL scripts and QVD/ETL data marts and developed interactive front-end user dashboards that provided business operations with valuable financial data.- Developed Global Shared Services and Corporate Finance data marts and reporting dashboards to provide business leaders with KPIs such as Work In Progress, Revenue.

Minneapolis, MN, US

- Developed the Business Architecture for a Project Management Application by comparing, contrasting and merging two different workflow applications to account for the most efficient ways of feature implementation.- Designed DB tables and Developed SQL queries to solve business problems and deliver Key Performance Indicators for the leaders of the.

Minneapolis, MN, US

- Developed Business Intelligence methods to save the company over $60,000 in a one year period.- Analyzed data for weekly P&L / BI Reports to improve resource allocation methods that led to continuous cost savings.- Developed Process Models for improving position efficiency that led to continuous cost savings.- Achieved Employee of the Month for creating.

- Developed and managed the sales and marketing, product development and graphic design of multiple product lines.- Managed logistics for manufacturing and producing final products.- Designed, created and administered the company website.

- Management of all Audio Visual related aspects of Banquet events including: Running the Live Audio Console, Audio Design and Placement, Projectors and Lighting Placement.- Achieved ‘Employee of the Month Award’ June, 2011.

- Coordinated work duties for The University of The Nations Campus.- Taught English to disadvantaged children in Japan, Thailand & Micronesia.- Managed the Logistics and Finances of an outreach team to Micronesia.

Bachelor Of Science - Bs, Business Administration, Management And Operations

Associate Of Arts And Sciences (A.A.S.), Audiovisual Communications Technologies/Technicians