Andrew Walnum Email & Phone Number

Walnut Creek, Ca, Us

San Francisco, California, United States

Implemented Mixpanel tracking plan and built out product analytics.Snowflake for data modeling.Tableau for email, e-commerce, and revenue analytics.Product and team strategy.Budgeting.

Managed and built all analytical and dashboard capabilities for insurance tech startup through collaboration with Executive, Product, Operations, Sales, and Marketing leadership.● Led all analytics initiatives in collaboration with the Executive team at a high-growth insurance tech startup, driving data-informed decision-making processes. Insights led to a 3 times increase in revenue over two years.● Developed and implemented scalable Looker infrastructure and dashboards from inception with LookML skills, enabling real-time insights into KPIs across departments.● Facilitated communication and collaboration between internal teams (Product, Operations, Marketing, Engineering) and external stakeholders to deliver in-depth analytics and build infrastructure. Implemented project management that led to 50% increase in project completion.● Leveraged expert SQL techniques including window functions, aggregate functions, and recursive queries to manipulate and model complex datasets for insightful analysis. Optimized previous queries resulting in 150% decrease in run time.● Utilized BigQuery and Google Cloud Platform (GCP) to construct and optimize data sets, ensuring seamless integration with BI tools and third-party data sources.● Implemented A/B testing that resulted in a 8 times increase in click-through-rate. Increased customer enrollment from 5.5% to a high of 48% in 8 month span.● Managed and mentored team of Junior Analysts and delegated tasks.● Presented key findings of exploratory data analysis to drive product, operations, and executive strategy.● Collaborated with clients to provide high-impact insights into their performance in Westhill’s program and provide recommendations.

Oakland, California, United States

Managed comprehensive financial data inquiries for a prominent law firm with over 1000 attorneys, ensuring accuracy and efficiency in reporting processes.● Executed intricate SQL Server queries to generate ad hoc reports, providing valuable insights to stakeholders across the organization.● Utilized expertise in Aderant to proficiently create and extract financial reports, streamlining reporting procedures and enhancing data accessibility.● Conducted in-depth financial analytics pertaining to attorney full-time equivalents (FTE) and office realization, facilitating strategic decision-making processes.● Collaborated closely with the Director of Finance to develop Power BI dashboards for finance totals, enhancing visibility and aiding in financial analysis and reporting efforts.

Vulnerability management using AWS.

San Francisco Bay Area

Completed an intensive six-month coding boot camp focused on data science techniques and tools.● Mastered SQL for relational database management system (RDBMS) queries, enablingefficient data retrieval and manipulation.● Proficient in utilizing Python for statistical analysis, including techniques such asbootstrapping and regression analysis.● Demonstrated proficiency in Python libraries such as Pandas, Numpy, Scipy, Matplotlib, andSeaborn for data manipulation, analysis, and visualization.● Acquired skills in machine learning using Python, including implementation of algorithms withSci-kit learn.● Developed expertise in building APIs to facilitate data integration and accessibility in variousapplications.

Sunnyvale,Ca

Served as a Data Analyst and GIS technician at Apple Inc. through APEX Systems, operating under non-disclosure agreements (NDAs).● Utilized specialized GIS software to analyze geographic data, ensuring accuracy and reliability in spatial analysis.● Conducted comprehensive content analysis, validation, cleansing, and collection to maintain data integrity and quality.● Implemented quality assurance and quality control (QA/QC) procedures to validate and enhance the accuracy of large datasets.● Analyzed and validated data content from diverse sources including databases, spreadsheets, and websites, synthesizing information to generate actionable insights.● Produced and distributed regularly scheduled and ad hoc reports to stakeholders, facilitating informed decision-making processes.

Greater Boston Area

Focused on geo-isotope data processing and signal processing using Matlab. Operated and maintained Isotope Ratio Mass Spectrometer.Left academia to pursue a career aligned with my goals.

Pleasant Hill, Ca

Work full-time primarily out of the Pleasant Hill office. Responsibilities include QA/QC for environmental data, helping compile work plans and environmental reports, and various field work activities. Field activities involve drilling oversight of well installation, well development, and well destruction, in addition to soil logging, sample collection, and air monitoring.

Worked 10-20 hours in a professional lab setting during the school year and full-time during the summer. Was responsible for preparing samples for stable isotope analysis and laser ablation mass spectrometry using a micromill and dremmel, finding information through primary journal articles, operating scanning electron microscope, and mentoring underclassmen in proper lab techniques and equipment use.

Reno, Nevada Area

Built rock retaining wall for hiking trails in the Reno/Tahoe area. Worked on a well structured schedule to build a connecting trail through Van Sickle State Park. Worked in moderate to extreme weather conditions, carried rocks and heavy equipment, practiced safety techniques in and around work area, and was designated trail crew naturalist.