Luke Lacy Email and Phone Number

Utilize DBT to automate and streamline the process of transforming data, ensuring accuracy and consistency Design and implement robust data models which support strategic decision-making and drive business intelligence initiatives Work closely with cross-functional teams to understand business needs, translating them into data requirements and delivering solutionsDevelop recurring processes to backfill and update models, ensuring data quality and improving transparency with stakeholders Continuously exploring new technologies and solutions to optimize data workflows

Build and maintain the data models and data pipelines that enable attribution tracking and monitoring Built attribution data model and consistently identified areas to improve marketing attribution, provide clarity on primary KPIs, performance drivers and competitive trendsCollaborate with the marketing teams to build growth forecasts, budget plans and real time performance Identified key customer behaviors around LTV and retention, and subsequently created experiments to drive these behaviorsWorked closely the marketing leadership advising on optimization strategies, identifying growth opportunities and improving methods of attribution

Lead experiment review with stakeholders, preparing and reviewing results Built clustering model to assign research segmentations to all users Improved marketing attribution by introducing attribution windows, investigating data discrepancies, adding additional code to run attribution modeling more accurately Support launch of new newsletter to 1.5M users through experiments and analysis of results

Automate A/B testing, reporting and results communication in marketing campaigns driving sales rates up over 150%Developed a data correction algorithm to identify and fix misattributed records, resulting in more accurate marketing reportingRedesigned call reporting to create cleaner data analysis, better monitor the health of the business and improve optimization of marketing campaigns

Own end to end data analysis from building APIs, data ingestion and cleaning, to attribution and reportingBuild and deploy automated, custom Tableau dashboards for each media channelBuild custom attribution models for offline channels, including TVLead modeler on internal MMM to influence quarterly media spend by channel and sales simulations based on different media plansResponsible for data quality checks on IT department to ensure consistent, high quality reporting

Created and automated reporting to agents resulting in +10% cross selling and an additional $20 million in premiumAnalyze customer data to identify potential high loss segments, and highlight high profitability segmentsCreated an insurance policy scoring system based on volume of new business and quality of new business, leading to an increase of average premium and more accurately priced insurance policiesLead weekly training in SQL and R to coworkers and management Explore new technology to automate data processes and increase efficiency

Design and implement statistical tests to measure effectiveness of various marketing programs by identifying high performing programs which had never been previously measuredCombine, clean and manipulate data across various sources to perform detailed analysis in partnership with clients and program managers to answer business questionsCreate new Tableau dashboards that enable end-users to monitor key performance trends, visualize data for quick takeaways, and inform future strategy decisionsExplore and test new ways of processing and manipulating big data sets through tools like Hadoop in order to increase efficiencies in core team projects

Wrote SQL Developer Code to validate over 400 attributes which resulted in enhanced data quality I assisted with creating mapping documents that helped define data requirements to meet the needs of business users Participant in Allstate's Intern Innovation Challenge and designed a winning crowdsourced weather applicationI created and organized 3 successful, well attended intern events for 140 people

The Information/Business Analyst provides enterprise and project-level information analysis support that produces consistent, accurate, and complete information requirements that enhances the analytic and reporting lifecycle throughout the enterprise. In support of the analytic and reporting lifecycle, this position will create solutions and drive design and delivery of Business Intelligence initiatives.