Dag S. Email & Phone Number

Portland, Oregon, Us

Leads the Data Science & Engineering Team to craft data-driven solutions using a broad range of technologies. Design, develop, and maintain efficient, cost-effective cloud and on premise applications to best support company directives.Currently migrating company SQL Server Analytics warehouse to Snowflake with dbt and Azure DataFactory.

Designs and develops programs and methods to consolidate and analyze data from structured and/or unstructured data sources to generate innovative solutions and predictive modeling. Identifies and produces meaningful insights from complex, multidimensional datasets big data through the knowledge and application of data mining, machine learning, pattern recognition and learning, predictive analytics, advanced algorithms and statistical modeling. Applies predictive modeling and advanced algorithms to create actionable insights and solutions to apply to business products, services or solutions.Leads the technical design, development and implementation of global software and data management solutions. Manages all aspects of project lifecycle, from understanding the business needs and gathering requirements, to full-stack software development and data architecture, to training and systems support. Works closely with colleagues from technical and business areas to deliver effective and dynamic solutions with the flexibility to adapt to changing business requirements.

Lead the technical design, development and implementation of business software applications. Manage project lifecycles and integrate solutions within multiple business environments. Support users and maintain applications.● UPC Scanner. External site for field reps to collect inventory using a handheld scanner, submit data, receiving inventory reports based on submitted data and ability to email those reports. JQuery, Javascript, Bootstrap, CSS, C#, Linq, .NET Web API, Http Attribute Routing, SAP .NET Connector 3.0, MS SQL Server 2008 R2, T-SQL● Inventory App Enhancements. Added submission and reporting options for inventory requests to support internal department. JQuery, Javascript, Bootstrap, CSS, C#, Linq, .NET Web API, Http Attribute Routing, SAP .NET Connector 3.0, MS SQL Server 2008 R2, T-SQL● Manage SQL Server transition. Move data, processes and reporting from 2008 R2 SQL Server solution to externally developed 2012 SQL Server solution. T-SQL, SSIS

Portland, Oregon, Us

Lead the technical design, development and implementation of business software applications. Manage project lifecycles and integrate solutions within multiple business environments. Support users and maintain applications.● SQL Server Upgrade. Worked with consultants on the creation of SQL Server solution to replace current 2008 R2 setup. Part of the documentation, design, review and testing of development system. Collected and reviewed development specs to ensure project met business requirements. T-SQL, SSIS● Inventory. External site for reps and customers to query real-time inventory from SAP. Single code base provides inventory from multiple warehouses and regional sizing. JQuery, Javascript, Bootstrap, CSS, C#, Linq, .NET Web API, Http Attribute Routing, SAP .NET Connector 3.0, MS SQL Server 2008 R2, T-SQL● Sales Order Upload. Online site for the validation and upload of sales rep orders to SAP. Fields are validated against customer information tables and allowed date ranges. Ability for users to view and search order upload history. AngularJS, Jquery, Javascript, Bootstrap, CSS, C#, Linq, .NET Web API, Http Attribute Routing, PapaParse, Angular UI-Grid, MS SQL Server 2008 R2, T-SQL● Sales Reporting. Automatic generation of Excel reporting for sales reps based on daily extracts from SAP Business Objects. Reports are uploaded to an external website for distribution. Multi currency reports support global reps. VBA, MS Access, MS Excel, MS SQL Server 2008 R2, T-SQL, SSIS, SQL Server Agent, Windows batch scripts, 7zip● iOS Application Support. Maintained and expanded Objective-C codebase written by third party. Objective-C, XCode, App IDs, Certificates and Provisioning Profiles● General Development and Support. Develop and maintain various automated processes and databases for Sales Dept. VBA, MS Access, MS Excel, MS SQL Server 2008 R2, T-SQL, SSIS, SQL Server Agent

Software developer at a company providing desktop and iPad based catalog solutions.● iPad Forecasting Application. Assisted with the development of an iPad-based sales forecasting solution for multinational corporations. Met with business owners to gather requirements, developed process flow that aligned with business needs and took part in application design. C#, Mono● Support. Maintained Perl scripts for an online catalog application.

Herzogenaurach, Bavaria, De

Directed and executed the design, development and implementation of various sales applications for corporate and regional sales managers, CFO and sales operations. Streamlined the integration of applications within multiple business environments. Ensured coordination of IT resources to guarantee timely project support, provided training and post go-live support for business users.● Targeting. Online application for managing the setting of sales targets - gross, invoiced and net - with a focus on profitability. Ability to create pro-forma P&L statements in multiple scenarios. One of four applications developed to assist Sales, Finance and Marketing with the setting of sales targets and account plans. Javascript, C#, .NET Web Services, MS SQL Server 2008 R2, T-SQL● Account Planning. Online application for the creation and review of sales account plans. Plans are measured against dollar and margin targets from the Targeting application. ExtJS, Javascript, C#, .NET Web Services, MS SQL Server 2008 R2, T-SQL● Forecasting. Automated forms for the creation, modification and collection of sales account forecasts. User plans created in the Account Planning application are used as the initial forecasts. VBA, MS Access, MS SQL Server 2008 R2, T-SQL● Trade Terms. Application for the creation of standard account discounts based on a set of defined criteria. Discounts are used in the Targeting application P&Ls. VBA, MS Access, MS SQL Server 2008 R2, T-SQL● Pricing Requests. Online application for managing submission and approval of non-standard pricing requests. JavaScript, C#, .NET Web Services,MS SQL Server, T-SQL● Reporting. Managed a centralized, self-service reporting and information intranet site for Corporate and Field Sales, Sales Operations, Marketing, Finance, Warehouse and Customer Satisfaction. Automated the daily creation and distribution of sales reports. VBA, MS Access, MS SQL Server 2008 R2, T-SQL

Herzogenaurach, Bavaria, De

Designed, developed and managed applications that increased efficiency of sales reporting and reduced headcount, while increasing data transparency and accuracy.● Automated Business Analyst Reporting. Developed databases that automated production and delivery of standard and ad-hoc reporting to Regional and Corporate sales management. VBA, MS Access, MS Excel, MS SQL Server, T-SQL● Salesman Samples. Organized and automated the process of buying, distributing and invoicing salesman samples and reporting. VBA, MS Access, MS Excel, MS SQL Server, T-SQL● Training. Tested business processes, wrote documentation and delivered training for SAP implementation.

London, ., Gb

Designed and implemented applications for Marketing, Finance and Sales teams that increased efficiency of business processes and accuracy of data. Applications automated data transfers, simplified data maintenance and combined financial, sales and marketing data.● Account Planning. Online business planning and forecasting application for Marketing managers. ASP, JavaScript, VBScript, MS SQL Server, T-SQL● Custom Catalog. Application for generating dynamic catalogs based on selection of styles, sorts, filters and layouts. VBA, MS Access, MS SQL Server, T-SQL● Data Migration. Migrated Marketing and Finance databases from MS Access to web based applications. ASP, MS SQL Server, T-SQL● Process Automation. Designed and built databases for the automation of data transfers to and from AS400. VBA, VBScript, JavaScript, MS SQL Server, T-SQL, DTS packages● Support. Designed and created scripts for DI-Diver business intelligence software