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 and Developing SQL Views, Functions, Stored Procedures (heavy TSQL and dynamic SQL), and Tables based on the business logic needed to successfully merge data from various data sources.- Designing Dimensions and Facts in the Enterprise Data Warehouse that store data relationally and efficiently so that it can be effectively leveraged by downstream reporting suites.- Documenting ETL Architecture and the Master Data Flow to enhance cross-team collaboration.- Creating and implementing test case scenarios for migrated ETL processes as well as Dimension and Fact tables.

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 the business logic needed in order to successfully transform data from various disparate sources.- Documenting Software Architecture, Logical Data Models, and Schema Designs to enhance cross-team collaboration.

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 integrate JIRA cloud API into Power BI reports. - SSAS and Power BI Data modeling and data architecture- Power BI Report Server Administration- Migration of SSRS into PBIRS paginated reports with MS Report Builder

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, Transform, and Load into multiple DBs including the Microsoft MDS/MDM platform.- Designing and creating SQL Views, Functions, Stored Procedures, and Tables based on the business logic needed in order to successfully merge product data from various disparate sources.- Documenting Software Architecture, Logical Data Models, and Schema Designs to enhance cross-team collaboration.

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 Procedures, and Tables based on the business logic needed in order to successfully merge product data from various disparate sources.- Documenting Software Architecture, Logical Data Models, and Schema Designs to enhance cross-team collaboration.

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, and Sales reports to drive margin improvement. - Leveraged in-depth knowledge of business operations and legacy applications to develop a new Utilization Reporting Suite, which included designing a complex data model to measure the hours and tasks completed by the operations team from 5 departments and over 100 employees across 4 countries.- Responsible for the architecture and implementation of reporting data marts used to facilitate file creation, reporting, and data integrity auditing. - Implemented development requests of existing schema, modules and reports to solve a variety complex business problems.- Documented Software Architecture, Data Models, and Schema Design to enhance cross-team collaboration. - Collaborated with DBAs and Application Architects in the management of DB Views, Functions, and Table design based on the business logic needed.- Primary tangible deliverables included SQL scripts, QVD data marts, UI/UX designed Qlikview reporting modules, Excel pivot tables and charts, HTML web pages, and data flowcharts.- Languages: SQL, QVD ETL (Qlikview), C#, CSS, HTML, XML - Tools: SSMS, SSIS, SSRS, Visual Studio, TFS, Qlikview, JIRA

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 company.- Provided technical support and troubleshooting for issue levels 1, 2, & 3 pertaining to all applications. - Used SQL to update, manage, and troubleshoot environment issues and design features.- Gathered business requirements and converted them into actionable Development Requirements.- Created user stories, process flow models, and UI mockups that articulated technical requirements for Developers and training for business users.- Coordinated TFS check-ins, Branch and Master Build code deployment for test environments.- Use of MS Excel, MS Visio, MS Project, MS Visual Studio, TFS, SQL, Jira, Confluence, Jitbit, and SharePoint.

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 a dynamic spreadsheet for PMs to manage projects more efficiently.

- 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