Joseph Wolter Email & Phone Number

Irvine, Ca, Us

San Diego, Ca, Us

Develop corporate and client reporting strategy, oversee tactical decisions for business intelligence tools, and design overall data strategy. Responsible for all client reporting.• Create enterprise data and business intelligence and reporting strategy.• Develop analytical tools, dashboards, and MDM to manage customer accounts.• Design and develop enterprise data warehouse and corporate dashboards.

San Diego, Ca, Us

Develop corporate data strategy, direct and oversee tactical decisions for business intelligence tools and applications, facilitate data strategies for governance, design, implementation, integration and usage. Lead the design and maintenance of Business Intelligence applications (QlikView and Power BI) and identify opportunities where these applications add value. Lead the design and maintenance of the Enterprise Data Warehouse. Assist in the overall management of IS, supporting the Senior Director of IS.

San Diego, Ca, Us

Manages the planning, design, development, and implementation of efficient business intelligence systems and business process improvements in support of organizational objectives and regulatory compliance requirements. Contributes and defines the Company's Information Systems strategy and executes direction of the information systems operations and information security environment.General• Manage and provide leadership to IS staff• Provide support for compliance with all relevant regulatory requirements• Support document management and records control requirements• Partner with lead internal and external technical resources• Work with internal and external auditors to insure IS controls are in compliance, meet regulatory requirements, and best practicesOperational• Direct IS Operations staff, including: helpdesk, network, security, server, and telecommunications• Direct all aspects of IS Operations, including: project planning, budget management, security, testing, validation, implementation, software licensing, and ongoing maintenance• Manage all aspects of database systems, including: data architecture, data quality, and securityBusiness Intelligence• Provide business intelligence (BI) solutions for all organizational BI requirements. • Provide a primary interface to Commercial Operations and CDMA (Clinical Data and Medical Affairs) for business process management in addition to BI solutions. • Research, recommend and manage the implementation of technologies used in the development and management of BI and data warehousing (DW) systems.• Manage all aspects of BI and DW development, including: definition of requirements, project planning, project management, development, testing and validation, implementation, training and ongoing maintenance. • Directly support functional business areas in the planning, implementation and ongoing enhancement of enterprise application systems (team performs functions required of Business Analysts)

San Diego, Ca, Us

Manages the planning, design, develop, and implementation efficient business intelligence systems and business process improvements in support of organizational objectives and regulatory compliance requirements. Fosters the relationship between various departments and IS as a whole by communicating and planning with department leadership.• Manage and provide leadership to Business Intelligence staff. • Provide business intelligence (BI) solutions for all organizational BI requirements. • Provide a primary interface to Commercial Operations and CDMA (Clinical Data and Medical Affairs) for business process management in addition to BI solutions. • Research, recommend and manage the implementation of technologies used in the development and management of BI and data warehousing (DW) systems. Utilize commercial solutions where possible before developing custom solutions. • Manage all aspects of BI and DW development, including: definition of requirements, project planning, project management, development, testing and validation, implementation, training and ongoing maintenance.• Manage and facilitate in identifying areas for process improvement, establishing effective and efficient business processes o Identify and implement the measurement of business process metrics and KPIs• Directly support functional business areas in the planning, implementation and ongoing enhancement of enterprise application systems (team performs functions required of Business Analysts)• Provide support for compliance with all relevant regulatory requirements• Seek innovative ways to improve operational productivity through the introduction of new technologies, systems, methods and controls

San Diego, Ca, Us

San Diego, Ca, Us

• Analyze, Design, Test, and Maintain Business Intelligence End User Tools including dashboards and major reporting applications.• Create and maintain UI coding standards and naming conventions.• Conduct reporting and UI development projects with little direction.o Requirements gathering and documentationo Project planningo Project estimationo Manage project customerso Project executiono Project testing and release planning• Create and maintain UI systems technical documentation in UML.• Provide field support and training for UI applications.• Manage BI projects throughout the project lifecycle and works with BI customers to ensure requirements and business interests are met.• Identify and support data stewards throughout the enterprise including members of the Finance, Commercial, and Sales Operations departments.

San Diego, Ca, Us

Architect WarehouseManage Data Warehouse OperationsDesign SSIS ETL PatternsDesign and build reoprts in SSRS and QlikView

Newcastle Upon Tyne, Gb

• Analyzing business operations and recommending solutions to various issues.• Migrating data from various databases including SQL Server into SAP ready files.• Initiating and designing processes to utilize postal tools such as NCOA and DPV validation.• Creating ad-hoc reports from SQL Server and providing them in Excel.• Designing automated reporting and displaying those reports in SQL Server Reporting Services, both 2005 and 2008.• Adding new features and maintaining existing features for a real-time dash board utilized by sales and marketing team members, pulling information from various sources.

Irvine, Ca, Us

• Database design and development. This includes relational databases for web applications, processing databases, and warehousing databases. For each type of system, I am responsible for the design and building of the stored procedures, DTS, SSIS, ETL, views, triggers, and all the rest of the data manipulation tools.• Application design and development. This includes web applications for e-commerce, CRM, loyalty management, and internal systems. I assisted in the development of a companywide framework based on CSLA to simplify and better control companywide development. Main languages used have been C#, VB.Net, classic ASP (VB Script), VB, and more. I have managed many projects and am familiar with the entire software development life cycle. • Company client access and front end development. I have built web services to provide client programmers access to their data that we have hosted, mainly this uses XML but at times it has been provided through flat files. I have built many web applications using ASP.Net, CSS, and all client side scripting.• Data warehousing and modeling. I have been part of developing household linking projects, managing client list in excess of 50 million records, and appending data to the Experian Consumer Households file and others. Using data from the above, I have provided reports to show what has been successful and what has not.