Mike Lanza Email & Phone Number

San Francisco, California, Us

- Supported GTM Marketing operations through the development of a GA4 data pipeline utilizing Fivetran connectors and Looker.- Ongoing monitoring and supporting department Census syncs, Fivetran pipelines, and daily dbt runs to identify and resolve long running models and other operational inefficiencies- Reduced daily dbt job run time by 1 hour in the first week of employment through refactoring long running models and using incremental dbt run configurations with proper clustering

Philadelphia, Pa, Us

• Designed and developed the 30+ data models and attribution logic in the Directed Acyclic Graph(DAG) for our New UserAttribution data model, consisting mostly of marketing datasets (Appsflyer, Braze CRM, Segment, and Singular).• Active Contributor to the company’s dbt repo, participating in Agile development sprints coordinated by a technical PM. Domains include by not limited to Marketing, Attribution, App Eventing, Ops, and Customer Lifecycle.• Researched and implemented data cost reduction techniques to reduce Snowflake compute on longest running daily models (>10 billion rows) by optimizing incremental dbt run configurations with proper clustering, saving the company~$15k per year.• Participates in company-wide Looker support role troubleshooting errant Looker Explores, Dashboards, and datasets being used by stakeholders across all departments in the company.• Converted transactional coupon usage data into standardized dimension and fact datasets ready for stakeholder analysis.

Philadelphia, Pa, Us

• Designed, developed, and maintained Looker Explores and dashboards used by the Product Organization to monitorKPIs that I created to identify pain points in the User Signup Flow and measure the impact of new app features.• Collaborated with the Growth Marketing team to design, develop, and maintain Looker Explores, Dashboards, and dbt models used for their Weekly Business Reporting needs.

Philadelphia, Pa, Us

Philadelphia, Pa, Us

• Technical lead of the agency’s BI Solutions Team responsible for uncovering reporting efficiencies and insights through the development of custom BI tools.• Collaborator and contributor to the development and implementation of the agency’s custom reporting solution utilizing Redshift, Azure cloud tools, SQL Server, and PowerBI, standardizing the full agency’s deliverables and reducing the average report generation time from 40 hours to 4.• Designed, developed, released, and maintained the agency’s first ever HCP digital media planning tool, identifying ideal publisher mixes for placing media in front of the largest possible target audience.• Revamped client taxonomy process and reduced monthly data QA from 7 hours to 20 minutes while reducing error rates from 25% to <5% and expanded the process and methodology to the entire agency.• Hosted ongoing trainings and demonstrations for junior employees to grow team skillset around various software and automation techniques.• Fostered new data relationships with a variety of digital media publishers to grow business and expand the agency’s HCP analytics offering.• Collaborated with 3rd party data vendors to develop advanced patient outcomes measurement plans and effectively determined the impact of TV on script behaviors within a niche disease state.• Orchestrated all aspects of client quarterly business reviews from initial slide design and insight development to traveling and presenting findings to marketing VPs in the healthcare marketing space• Worked with internal teams, clients, and publishers to create measurement plans, dashboards/reports, and data exports, effectively aligning them all to client business objectives, internal KPIs, and publisher contracts

Exton, Pa, Us

•Daily responsibilities include utilizing ETL tools to import, cleanse, transform, validate, and model data from a variety of sources.•Identify, analyze, and interpret trends in complex data sets using statistical techniques and present findings to clients through standardized reports, dashboards, and storytelling presentations.•Work directly with project stakeholders and leadership to discuss findings, facilitate decision making, and document and deliver repeatable analytic solutions.•Provide assistance with proof of concept, data correlation, data integrity, and process development activities that require coordination of efforts across multiple areas within the team.

Thorofare, Nj, Us

• Project manager for new laboratory equipment and medical devices in development (Released latest product line 2 months ahead of schedule).• Responsible for timeline management, product and component design optimization, cost analysis, vendor selection, performance and safety testing, regulatory approval, product manufacturability, and release to market.• Develop test protocols and perform data analysis utilizing Python and the Pandas, Numpy, and Matplotlib packages to validate material usage in new product design.• Liaison to the global business division responsible for RMA root cause analysis and resolution in addition to product portfolio expansion in global markets.

Thorofare, Nj, Us

• Drove assembly process improvements through statistical analysis of production and return data based on Lean/Six Sigma principles using Excel and Python with the Pandas, Numpy, and Matplotlib packages.• Developed custom software, reports, and dashboards using VBA, Excel, MySQL, and Python to improve the capture and analysis of assembly data in real-time (automated reporting process and reduced generation time from 2 days to 10 minutes).• Resolved in-process production failures as they occurred to identify key areas for improvement (reduced Block Heater build time by 25%).• Lead Monthly Quality Meetings and implemented action items to improve production efficiency based on custom insights and production KPI’s.• Analyzed all future and current product design changes to provide alternate solutions and improve manufacturability. • Managed, developed, and implemented a company-wide Non-Conforming Material Process to identify top scrap contributors based on volume and value (Reduced Scrap Material by 10%, $200,000).

Aston, Pa, Us

• Managed all production lines and met KPI goals on a weekly and monthly basis.• Resolved production issues through research and statistical analysis of historical test data by implementing solutions to prevent future occurrences (Improved production yield by 40%).• Developed custom software utilizing Excel, VBA, MySQL, Navicat, and .NET to record and analyze production data through the generation of summary reports and dashboards.• Increased production output, reduced testing time, and reduced material scrap using time studies and other Lean/Six Sigma production practices (Reduced calibration and validation time by 20%).• Generated detailed flow charts and written procedures to visualize and document production processes.

East Norriton, Pa, Us

• Provided support and development for the Trackwise and Master Control software suites at various client sites within the US.• Developed detailed documentation including process flow charts and test scripts to illustrate document life cycles and validate software.

Philadelphia, Pa

• Identified reliability concerns in Top Priority Circuits through the analysis of historical data and generated work orders to improve circuit performance and prevent reoccurring outages.• Created the company-wide Pole Hit Program to identify telephone poles out of compliance and strategically relocate them to reduce the occurrence of pole hits.• Managed an underground cable database to monitor current and future cable upgrades.• Performed customer callbacks during major outages and analyzed outage history for potential reliability concerns.

Singapore, Sg

• Supported the research and design of ultrasonic transducers in wire bonding machines.• Developed custom software to automatically perform testing and generate reports utilizing VBA. Software reduced run-time from 2 hours to 2 minutes.• Created user manuals and additional documentation for all programs developed and instruments used in testing.