Matthew U. Garduno

ad24gi@r.postjobfree.com

408-***-****

SUMMARY Data Analyst with Project Management skills, experienced in SQL, R, Python, Dataswarm, Tableau, Power BI, Salesforce, Excel (Macros, VLOOKUP, analysis), data cleaning/ Data integrity, Data Governance, ETL, AWS, web/data scraping, Quant/Statistical analysis, Predictive Modeling.

EDUCATION California State University, Stanislaus Turlock, California

Bachelor of Arts in Economics May 2012

Bachelor of Science in Business Administration May 2012

Concentrations: Entrepreneurial Strategy, and Management Leadership

EXPERIENCE

Meta (Via infoTechSourc) Campbell, CA

Sr. Data Analyst (Supply Chain & ops) Oct-2023 – Current

•Program manager for Global printing and Global IT VM supply chain

•Build and manage global processes, and ensure Security & FTC compliance

•Build and maintain KPIs, dashboards, and data pipelines for core programs (Python/SQL)

•Perform root cause analysis (Python/SQL)

•Create and publish global SOPs for core programs

•Identify process gaps and bottlenecks for global programs

•Automate processes for global programs

•Manage global logistics for IT infrastructure for core programs

•Ensure supply chain efficiency by maintaining on time PR/PO/invoicing

•Create inventory systems with live data, enabling in the moment decisions for global team, bringing stockouts to zero.

Apple (Via infotreeglobal) Campbell, CA

Sr. Data Analyst (Supply Chain & PM ops) June-2022 – June-2023

•Perform monthly, and quarterly, sales analysis reporting to management for global sales teams, using python, excel, SQL, and tableau.

•Developed and maintain internal tools, developed using Python, SQL, and C# to address; demand planning, aggregate and consolidate data, supply chain approval, etc.

•Technical Program management

•Automation engineering (python/SQL)

•Data integrity, Data Governance

•Evaluate internal processes and identify opportunities for automation

•Collaborate with internal and external teams to identify opportunities to gain efficiency in current and future business processes.

•Supply chain planning (ERP)

Apple (Via Artech) Campbell, CA

Sr. Data Analyst (Supply Chain Ops Analytics & PM) March-2021- March-2022

•Developed and maintain internal tools, developed using Python and C# to address demand planning, aggregate and consolidate data.

•Program management

•To deal with Silicon wafer shortages, developed ad-hoc tools and reports to track hour-by-hour demand and supply. Developed risk-based reporting on 30/60/90 days out for demand and material availability.

•Perform ad hoc data analysis

•Supply chain planning (ERP)

•Sales operations analytics

•Perform predictive modeling for inventory and manufacturing

•Automate CTB, waterfall, demand/supply, and other supply chain reports

•Build and maintenance internal tools for supply chain team

•Transform/normalize data, Python & SQL, Data Governance

•Data migration management

•UAT testing

•Build and maintain weekly, monthly, and quarterly reports

•Manage short and long-term projects with multiple stakeholders

Facebook (Via ERG) San Mateo, CA

Sr. Data Analyst (Supply Chain Ops & analytics/Project Manage) Oct-2019-Aug-2020

• Perform ad hoc data analysis

• Build financial reports/analysis

• Sales operations analytics, AWS

• Perform predictive modeling for WW inventory and manufacturing

• Build Demand and Supply models for manufacturing supply chain

• Manage short and long-term projects with multiple stakeholders

• Analyze, forecast, and report on project progress

• Manage Salesforce data (data integrity/ Data Governance), loading large data sets (data loader)

• Create reports, dashboards in salesforce

• Create/edit reports and dashboards in Tableau

• Transform/normalize data, Python & SQL

• Automate reporting using SQL

• Perform ETL tasks, build data pipelines, Snowflake/Hive

• Automate channel inventory reporting & reconciliation

• Automate sales data reporting

Santa Clara Family Health Plan San Jose, CA

Sr. Data Analyst (G&A Team/Project Manage) Nov 2018 – July 2019

• Perform ad hoc data analysis with clinical data

• Implement case management system

• Manage short and long-term projects with multiple stakeholders

• Analyze, forecast, and report on project progress

• Use data to drive process decisions and prioritize tasks

• Build data pipelines (SQL & Python) to create a central “source of truth”

• Automate reporting using SQL

• Ensure project milestones and deadlines are met

• Delegate work/tasks to team members on my projects, track progress

• Manage Salesforce Data - maintain data integrity, Data Governance, and dedupe

• loading large data sets (data loader) in salesforce

• Build & maintain Salesforce dashboards & reports

• Create Salesforce custom objects and fields

• Create/maintain SQL & SAS queries, and perform analysis

• Build ad hoc analytical tools: Python, R

• Build and manage Tableau dashboards based on business needs

• Prepare & build processes for HIPAA data/asset management

• Prepare monthly, quarterly, and annual report submissions for federal & state audits

• Perform analysis in Excel, Python, and R when applicable

• Clearly communicate priorities, duties, and timelines to stakeholders

Facebook (contractor) San Mateo, CA

Data Analyst (Logistics and Operations/Project Manage) April 2017-Oct 2018

• Perform ad hoc data analysis

• Build financial reports/analysis

•Sales analytics & reporting

• Manage short and long-term projects with multiple stakeholders

• Analyze, forecast, and report on project progress

• Manage Salesforce data – maintain data integrity and dedupe

• Edit & maintenance APIs using Python

• Use data to drive process decisions and prioritize tasks

• Ensure project milestones and deadlines are met

• Delegate work/tasks to team members on my projects, track progress

• Basic knowledge of SQL, queries, and analysis

• Build data pipelines in Hive (SQL/HQL & Python)

• Automate reporting using SQL

• Build and manage Tableau dashboards based on business needs

• Assist in several asset reconciliation projects

• Prepare & build processes for FTC data/asset management compliance audit

• Develop and improve processes for logistics and operations using quantitative methods

• Perform analysis in Excel, Python, and R when applicable

Facebook (contractor) San Mateo, CA

Data Integrity/Rater (analyst) August 2016-April 2017

•Review/edit Facebook "pages" data

•Identify relevant patterns in rated data for engineers and data scientist

•Marketing analytics and A/B testing

•Communicate effective approaches to organizing/rating data with stakeholders

•Improve and prepare data for engineers

•Work with in-house data management software

•Employ industry standard data integrity techniques

Salesforce San Francisco, CA

Data Analyst Sales Operations (Contract) October 2015-April 2016

• Reconcile data between multiple data sources and systems

• SQL Queries and database management

• Perform predictive modeling for regional and WW sales

• Build sales team weekly/monthly/quarterly reports

• Build territory rating process and carve sales territory WW for each sales team

• Build data pipelines to feed salesforce & SQL databases (SQL, Python, dataloader)

• Create scripts using R and Python to analyze and migrate data

• Build Macros, Pivot tables, and VLOOKUPs in Excel

• Maintain data integrity throughout the organization database

• Generate reports and build dashboards in Salesforce

• Jr. level Salesforce admin tasks and systems auditing

• Marketing analytics

• Sales analytics & reporting

• A/B testing; Marketing Email campaigns

• Build and run Salesforce reports

• Build dashboards and custom tables in Salesforce

•Create Salesforce custom objects and fields

Account Executive (B2B Sales)

•Spent several years in B2B sales prior to 2015.

•Sold hardware, software, technical services, and staffing.

SKILLS

Analytical: Regression analysis, linear programming, business financial analysis, VLOOKUP’s, pivot tables, automation, and macros.

Computer

Languages: R, Python, SAS, SQL, C#, HTML

Contact this candidate