Joseph Wagner Email & Phone Number

Hillsboro, Oregon, United States

I am responsible for the design and execution of reliable and efficient data pipelines to deliver documented trustworthy data to the downstream data engineering team. I am also responsible for establishing the mission, strategic methods, delivery framework, and engagement model for source systems and data consumption in conjunction with downstream teams. I work closely with technology teams, business units, stakeholders, and senior leadership to create a standardized process to extract… Show more I am responsible for the design and execution of reliable and efficient data pipelines to deliver documented trustworthy data to the downstream data engineering team. I am also responsible for establishing the mission, strategic methods, delivery framework, and engagement model for source systems and data consumption in conjunction with downstream teams. I work closely with technology teams, business units, stakeholders, and senior leadership to create a standardized process to extract, transform, and load data from source systems into a central repository, and document the data and underlying business processes to add context and value. Show less

Hillsboro, Oregon, United States

Business Intelligence Developer - I analyze real-world data problems and develop practical solutions. My tasks include:Analysis & Documentation: I analyze and document the internal workings of datasets, including the upstream processes which generate the data, the effect of the results on downstream processes, and edge-case scenarios which produce unexpected information.Process Improvement & Automation: I review existing processes, and I design and develop solutions to improve… Show more Business Intelligence Developer - I analyze real-world data problems and develop practical solutions. My tasks include:Analysis & Documentation: I analyze and document the internal workings of datasets, including the upstream processes which generate the data, the effect of the results on downstream processes, and edge-case scenarios which produce unexpected information.Process Improvement & Automation: I review existing processes, and I design and develop solutions to improve their efficiency and accuracy, which often includes automation. Tools used to develop these solutions include Crystal Reports, Windows PowerShell, Excel macros, Access databases with forms, and data marts in Microsoft SQL Server.Reporting: I develop, maintain, and run a number of reports and reporting systems centered on billing and finance. These range from aesthetic overviews for executives (using Crystal Reports) to self-help data marts for proficient users to comb through large data sets (using Microsoft SQL Server). Show less

Portland, Oregon Area

Business Reporting Developer - I transform data with the aim of extracting useful information and facilitating conclusions. My tasks include:SQL Queries: I write SQL queries to pull data based upon a comprehensive set of business requirements. Examples include reports for Marketing, Engineering, Finance, and Quality Control.Macros: I write Windows PowerShell scripts & DOS batch files in order to automate processes. Previously, I also wrote Visual Basic macros to automate mass… Show more Business Reporting Developer - I transform data with the aim of extracting useful information and facilitating conclusions. My tasks include:SQL Queries: I write SQL queries to pull data based upon a comprehensive set of business requirements. Examples include reports for Marketing, Engineering, Finance, and Quality Control.Macros: I write Windows PowerShell scripts & DOS batch files in order to automate processes. Previously, I also wrote Visual Basic macros to automate mass changes using Attachmate Extra.Reporting Server**: I designed, implemented, and supported a Microsoft SQL Server for enterprise and local reporting. This included SSIS ETL, user-defined functions & stored procedures, tables, SQL queries, and SSRS reports. Regular users utilized SSRS to generate their own reports from user-entered parameters. Power users could query the back-end directly.* In Apr. 2011, my title was realigned to better reflect my duties. My previous title was Billing Application Analyst. ** This was part of my duties between Feb. 2008 and Apr. 2012.In Feb. 2008, my department was reorganized. Previously, my duties included those below. After the reorganization, they were dropped in order to focus on reporting and automation.Project Management: I led and executed a number of projects from inception to completion, which included defining the scope, developing a step-by-step plan, executing the plan, and communicating & coordinating with other departments as necessary.Case-Based Support: I provided troubleshooting and support on a case-by-case basis for personnel having difficulty operating the any of the CSG software.Billing System Configuration: From time-to-time, I was tasked with changing configuration parameters, including service codes, rates, packages, discounts, taxes, prerequisites rule sets, provisioning of addressable services & equipment, and securities. Show less

Oshkosh, Wisconsin Area

I served customers by troubleshooting problems with their high speed Internet connection, which included no connectivity, slow speeds, an inability to access email, and password resets. I also provided product and service information relating to high speed Internet access and other new product lines, and I solicited orders for new products and services

Sheboygan, Wisconsin Area

I helped customers find and choose the products that met their needs.