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.

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.
• 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.
• 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.
• 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.
• 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.

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.
• 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.