Senior Data Warehouse & BI Developer

Mark Lurie

****.*.*****@*****.*** 203-***-****

Professional Profile

Senior Data Warehouse and Business Intelligence Developer with 20+ years of experience delivering enterprise analytics, reporting platforms, and process automation across Technology, Consumer Products, and Financial Services. MBA in Management of Technology. U.S. Army Veteran. Conversationally fluent in German.

Professional Experience

Senior Data Warehouse / BI Developer

HomeServe 2016 – Present

● Re-engineered a legacy daily enterprise reporting extract that no longer met SLA requirements by implementing real-time data sources, improving data accuracy by 50% and ensuring consistent on-time delivery.

● Developed real-time Contractor Management dashboards in Tableau, accelerating executive and manager decision-making and issue resolution.

● Built a comprehensive bonus tracking and reporting system for call center personnel and external business partners.

● Designed and deployed structured reporting and enterprise data-flow solutions using Alteryx Designer across Accounting, Finance, Fulfillment, Marketing, IT, Account Management, Operations, Billing, and HR.

● Served as HomeServe’s Alteryx Server Administrator, responsible for platform maintenance, upgrades, and stability.

● Designed and developed Consumer Product Pricing and Renewals models leveraging Heroku and Salesforce data.

● Delivered Tableau dashboards supporting Partner Operations and Billing teams.

● Automated and deployed interactive, company-wide data delivery applications using Alteryx.

● Led HomeServe’s first successful use of the Operational Reporting Database (ORD), improving collections and reducing fees by $4M.

● Developed a Credit Card Collection Rate dashboard that generated an additional $900K in revenue.

● Improved collections on delinquent accounts by $1M year-over-year through dunning and suspension reporting.

● Partnered with Contractor Operations to develop a weekly claims variance report that validated actual spend prior to underwriting submission, generating $700K in savings. Data Architect

People’s United Bank 2015 – 2016

● Partnered with business stakeholders to gather requirements, design data solutions, and implement enhancements within the enterprise data warehouse.

● Authored technical specifications and ensured accurate implementation of data architecture solutions.

● Managed Data Architecture team projects and resource allocation to ensure timely execution of commitments.

● Provided production support and ad hoc data analysis using SQL to resolve data-related issues.

Enterprise Data Intelligence Manager

GE Capital 2007 – 2015

● Designed and implemented a Risk Data Mart supporting enterprise risk reporting, ad hoc analysis, and ongoing information requests.

● Built a Loss Given Default (LGD) analysis and reporting platform using SAS Enterprise Guide, reducing processing time from four days to one and lowering staffing requirements from four employees to one.

● Automated GE Capital’s $3B pre-approved credit line reporting and Federal Reserve submission process using Lean methodologies, reducing cycle time from four days to half a day.

● Led development of a secure, compliant, multi-generation reporting system providing rapid access to sales and performance data across multiple businesses.

● Modernized reporting architecture using SQL views and JavaScript integration, enabling rapid report creation without code releases.

● Created a portfolio monitoring report using SAS and SQL that increased incremental leasing revenue by $1.5M.

Program Manager, Global Risk Management

IBM Corporation 1999 – 2007

● Managed a four-person development team responsible for enhancing, maintaining, and administering IBM’s global credit risk management systems.

● Implemented IT governance processes and control procedures to strengthen system security and audit compliance.

● Designed credit-scoring models and rule engines supporting deployments in 24 countries across Europe and Asia.

● Developed data-mining solutions to identify unused financing opportunities, reducing turnaround time and operational costs.

● Built and integrated a Uniform Commercial Code (UCC) tracking system with IBM’s U.S. Credit System.

● Developed a new credit-scoring methodology using Moody’s debt ratings for publicly rated companies.

Education

University of Connecticut

Master of Business Administration (MBA), Management of Technology Universität Wien (University of Vienna), Austria

Junior Year Abroad – German Literature; Japanese Language Studies University of Arizona

Bachelor of Landscape Architecture

Technical Skills

SQL Alteryx Designer Alteryx Server Tableau Data Warehousing Business Intelligence Reporting Automation Data Architecture Confluence JIRA

Contact this candidate