Brian Marx Email & Phone Number

San Antonio, Tx, Us

Milwaukee, Wisconsin, Us

Consolidate and integrate two teams providing data and analytics for two separate business functions into the BI Center of Excellence to provide consistent, improved business line support. Provide leadership to drive transformative innovation in digital technology. Achieve business goals through improvements in data and analytics architecture, Create automated processes to load, transform, and trend a variety of enterprise data sources for integration in Data Warehouse.

Milwaukee, Wisconsin, Us

Administer SQL Server database and Tableau analytics implementations including scheduling, storage management, performance monitoring, backups, and version upgrades. Migrate database and analytics servers for production and lower tier environments to Azure. Provide fast response validation and troubleshooting support for Data Warehouse. Implement best practice improvements to performance, reliability, scalability, and sustainability for SQL Server database and Tableau analytics server architecture.

Green Bay, Wisconsin, Us

Provide technical vision and expertise. Coordinate the implementation and reliable production use of Corporate Intelligence infrastructure in accordance with industry best practices, regulatory compliance, and enterprise requirements. Created and documented development process and procedure. Provide learning and growth opportunities (both professional and technical) for colleagues and team members. Provide Business Intelligence architecture, processes, and solutions that maximize the business value of hardware and software investment. Ensure quality, consistency, and stability of automated solutions. Manage limited resources to maximize business value.Architect metadata solutions to provide tracking necessary for notification and rapid response troubleshooting of SQL Server environmental issues. Ensure production failures are triaged, communicated, and resolved quickly and decisively.Gathered and documented requirements to architect and build SQL Server data warehouse solutions to facilitate analytics as well as reduce complexity and ensure consistency of reporting logic.Provide architecture and solutions to meet a variety of business needs by leveraging SQL Server, including process automation, importing data for use as operational data store, report refresh automation, creating and loading data warehouse and data mart solutions.Automate existing processes through ETL and export solutions to improve efficiency and reduce risk. Construct templates, document standards, performance tune, and peer review SQL Server objects and processes (SSIS, SSRS, SSAS, tables, views, functions, stored procedures, etc.)Create standard processes, procedures, and templates to implement best practices for various aspects of the Business Intelligence development process.

Green Bay, Wisconsin, Us

Architect data marts (for example marketing campaigns data mart including single attribution model or loans data mart.) Author and performance tune SQL Server stored procedures to implement business logic and update data marts. Author SSIS packages to update data marts and provide ETL and export solutions. Author SSRS reports to provide visibility into meta data.Provide reliable production support (including performance tuning and troubleshooting) for daily, weekly, monthly, and quarterly SQL Server jobs to load operational data store, data marts, refresh reports, import files, and export files.Architect, construct, test, load, deploy, troubleshoot, performance tune, and maintain data warehouse database solutions in SQL Server based on requirements gathered from business users.Construct metadata layer for SQL Server environment including table loads, stored procedure dependencies, report refreshes, email notifications and file exports.

New Berlin, Wi, Us

Work with internal customers (marketing, merchandising, inventory, business development, accounting, etc.) to identify, clarify, and document reporting/analytics needsLeverage both an enterprise-wide data warehouse and replicated transactional databases to author reporting/analytics to meet business needs.Constructed a wide variety of analytics and reporting including marketing driver projections, customer segmentation, lifetime value analysis, marketing channel analysis, repurchase rate analysis, market basket analysis, holiday sell-through analysis, etc.Helped grow, maintain, and better leverage an enterprise-wide data warehouse for business reporting and analytics.Participated in the implementation of an enterprise business intelligence tool (TIBCO Spotfire) including needs identification, RFP, vendor selection, installation, training, analytics build-out, go-live, user roll-out, and analytics consumption.Administration of web analytics platform, Omniture, including testing, troubleshooting, ad hoc analysis, re-implementation project, etc.

New Berlin, Wi, Us

Sussex, Wisconsin, Us

Developed complete standardized database system for use as a data management service provider for B-to-C clientsDeveloped standardized customer database build techniques to perform build projects for clients with shorter turnaround timesDeveloped automated system for performing response analysis reporting to provide actionable information from client marketing campaignsConstructed relational marketing databases to meet the marketing management and campaign management needs of clientsDeveloped computational models for marketing applications including campaign response, lifetime value, and product affinityInterfaced with business team members to understand clients’ direct marketing and information needs.Enhanced and developed data analytics services for direct marketing clients.Created methodologies for report design, QA/QC, auditing, and campaign management.Ensured accurate and reliable methods for campaign performance and integrity.Created ad-hoc reports and analysis to support direct marketing initiativesSupported optimal campaign design and performance through solid response analysis and testing methodsAnalyzed and reported marketing campaign results for multiple clients to present clear, easy to understand action items

• Took initiative to perform innovative and original research• Guest speaker at Southern Gas Association Fall Leadership Conference – 2004, 2005, 2006• Coauthor of “Weathering the Storm: Successfully Navigating Short-Term Forecasting Abnormalities”, paper written for the Southern Gas Association Fall Leadership Conference, Gas Forecasters Forum (Covington, KY, September 16, 2004)• Presented research at 4 research exchanges and poster symposiums• Coauthor of “Forecasting Peak Day Weather Using Heuristically Selected Probability Distributions”, paper submitted to Journal of Forecasting• Organized semester-long graduate seminar on advanced topics in Data Mining• Developed prototype forecasting software• Lead long-term research and development projects• Gathered and presented project marketing materials• Delivered customer presentations• Numerous research presentations• Taught Automatic Control Systems• Taught Digital Control Systems

Mba, Business And Management

Phd, Electrical And Computer Engineering

Master Of Science, Electrical And Computer Engineering

Bachelor Of Science, Electrical Engineering