Learn Data Skills
Beta
Dean Pangelinan

Dean Pangelinan

Sr. Business Intelligence Strategist

MERGE (formerly Blue Moon Digital) | Tracy, CA

Technologies

My Portfolio Highlights

My New Track

SQL Fundamentals

My New Course

Introduction to R

My New Track

SQL Fundamentals

Quantitative detective, uncovering the truth hidden in the depths of data.

My Work

Take a look at my latest work.

course

Data Manipulation in SQL

course

Introduction to the Tidyverse

course

Introduction to R

course

Data Manipulation in SQL

My Certifications

These are the industry credentials that I’ve earned.

Other Certificates

DOMO MajorDomo Certification v2.0

DOMO Domo Technical Certification

DOMO Domo Professional Services Certification

Databricks Databricks Fundamentals Accreditation

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to R
Data Manipulation in SQL
Introduction to the Tidyverse
Intermediate R

My Work Experience

Where I've interned and worked during my career.

MERGE | Aug 2021 - Jan 2025

Sr. Business Intelligence Strategist

• Served as the primary DOMO platform administrator and subject matter expert (SME) for a global pharmaceutical client, leading feature deployments, troubleshooting technical issues, and coordinating vendor support on behalf of enterprise-wide Digital Marketing & Analytics stakeholders. • Built a centralized Data Mart to ensure seamless transition from Universal Analytics (UA) to Google Analytics 4 (GA4), integrating disparate schemas to maintain reporting continuity and future-proof analytical dashboards. • Designed and implemented scalable, high-performance data pipelines, eliminating bottlenecks and reducing costs by replacing load-intensive MySQL and Redshift ETL/ELT dataflows with optimized pipelines under a monthly consumption model. • Established automated data governance measures, implementing QA alerts and auditing protocols to maintain data accuracy, consistency, and compliance with internal policies and industry regulations. • Frequently optimized ETL/ELT pipelines and data mart strategies to enhance efficiency, scalability, and integrity. • Mentored junior team members through knowledge-sharing sessions and structured code reviews, providing constructive feedback to reinforce best practices, improve code quality, and elevate development standards.
Show More

Blue Moon Digital, Inc. | Apr 2021 - Aug 2021

Sr. Business Intelligence Strategist

• Managed client engagements as the primary contact for a portfolio of more than a dozen DOMO implementations, overseeing onboarding, championing platform adoption, and supporting accounts across multiple industries, while delivering scalable, high-impact solutions to evolving business needs. • Developed and delivered prototypes and proof-of-concept (POC) dashboards to client stakeholders and senior leadership, demonstrating best practices in data visualization, leveraging emerging technologies, and showcasing key DOMO features to promote enterprise-wide data democratization. • Led the deployment of DOMO as a secure, scalable data warehouse and BI reporting solution for a nationwide cannabis testing enterprise, securing a multi-year partnership and ongoing platform support agreement.

Robert Half | Dec 2017 - Jan 2021

Marketing Data Analyst - Technical Solutions, Global Marketing Analytics

▪ Served as the department’s primary DOMO developer, partnering with data stewards and process/program owners to automate data pipelines and integrate global Marketing & PR KPIs into RH’s DOMO data platform. ▪ Collaborated with global Marketing & PR stakeholders to define business needs, elicit reporting requirements, conduct ad-hoc analyses of complex issues, and deliver data-driven recommendations. ▪ Built and optimized enterprise-level dashboards in the DOMO BI platform, highlighting KPIs of RH’s Marketing & PR efforts on 18 country-specific websites across five global regions. ▪ Maintained high-bandwidth BigQuery ETL pipelines for integration of GA360 & Salesforce data. ▪ Led statistical analysis of market salary data, benchmarking trends and variance for a myriad of role categories across seven industry segments and five global regions for RH’s Annual Salary Guide. ▪ Coordinated vendor/partner support to resolve technical issues with RH’s DOMO implementation.

Robert Half | Nov 2016 - Dec 2017

Marketing Data Analyst (Contract)

(Client - Robert Half corporate Marketing Department | Converted to FTE - December 2017.) ▪ Supported senior Marketing Analytics management in the collection, tracking & analysis of Google Analytics 360, Eloqua, and Salesforce data to “close the loop” in attributing revenue to global Marketing & PR efforts, focusing on high-ROI programs increasing demand for RH’s candidate placement services.

Synergis | Sep 2015 - Nov 2016

Operations Analyst III (@ Google) - 1:1 Care Workforce Data Analyst

(Client: Google, gTech Consumers 1:1Care, Workforce Management, Mountain View, CA) ▪ Supported 1:1 Care Workforce Management Leads, crafting detailed production dashboards tracking KPIs including staff headcount, shrinkage and attrition in Google’s world-wide agent contact centers, and providing data-driven insights from hiring and training initiatives to align monthly staffing forecasts with operational needs. ▪ Engineered and maintained dynamic production dashboards to track 1:1 Care Workforce Management KPIs, enhancing real-time decision-making and introducing automated data/layout recovery protocols via Google Sheets. ▪ Served as liaison for escalations with the gTech Consumers Analytics team for access and data quality issues, ensuring data accuracy and reliability within the within Verint’s Impact 360 Workforce Optimization platform.

Streffco Consultants, Inc. | May 2014 - Jan 2015

Data Analyst (Contract)

(Client: Kaiser Permanente, Infrastructure Management Group, Network Economics and Portfolio Management teams, Walnut Creek, CA) ▪ Crafted SQL pipelines from Kaiser’s BMC Remedy IT Service Management (ITSM) & CA Clarity Project Portfolio Management (RPM/PPM) suites into SAP Business Objects XI Web Intelligence (WEBI). ▪ Assisted the Sr. Business Analyst in optimizing data transformations employing SQL Server Integration Services (SSIS) to facilitate seamless ingestion for Tableau-based analytics. ▪ Completed self-directed training in “Fundamentals of Tableau” as provided to Kaiser by KFORCE.

Canara Inc. | Mar 2013 - Aug 2013

Monitoring Operations Analyst – (Contract)

▪ Generated weekly and ad-hoc reports for global clients, analyzing health and performance metrics of valve-regulated, lead-acid (VRLA) batteries deployed in critical power systems to identify fault conditions, alarm trends, and anomalies in battery telemetry data. ▪ Assisted the CTO in the deployment and evaluation of Expert Microsystems’ SureSense® Prognostic Health Management (PHM) suite as a supplement to Canara’s cloud-based Battery Automated Reporting (BAR) SaaS platform for data-driven diagnostic and predictive analytics. ▪ Pilot-tested Nutonian Eureqa to develop diagnostic and prognostic models for remaining useful life (RUL) of large-scale VRLA battery backup & switchgear systems.

Cardno ENTRIX | Apr 2012 - Apr 2013

Data Analyst

▪ Assisted the QA Manager in tracking and resolving data quality and chain-of-custody issues with electronic project files, including multidisciplinary environmental impact samples, stored in a terabyte-level Oracle UCM (Universal Content Management System). ▪ Conducted quality assurance reviews of structured & unstructured scientific, economic & statistical data, standard operating procedures (SOPs), and QA project plans (QAPPs), applying data validation techniques in support of Natural Resource Damage Assessment (NRDA) technical working groups. ▪ Collaborated with field staff and database managers to generate data archival packages, ensuring accessibility, data integrity, and regulatory compliance for client counsel supporting BP Exploration & Production, Inc., in response to the Deepwater Horizon incident in the Gulf of Mexico.

Canon Recruiting Group, LLC | Aug 2010 - Apr 2012

Contractor, Application Operational Support (AOS)

(Client: Bank of America, Home Loans & Information Technology Division, Concord, CA) ▪ Produced Executive- & C-level dashboards & efficiency reports under tight deadlines, leveraging analytical and data visualization tools to track divisional & departmental performance against KPIs. ▪ Maintained a procedural “run book” and executive tracking log, standardizing workflows for both routine and ad-hoc reporting deliverables. ▪ Piloted exploratory data analysis (EDA) of corporate Technology Associates’ Voice-of-the-Customer (VOC) survey responses, extracting insights to drive data-informed decisions. ▪ Integrated forecast trends & data insights into PowerPoint decks in a SharePoint environment.

Walmart.com | Sep 2009 - Jan 2010

Associate Manager (Analyst), Consumer Insights

▪ Monitored, analyzed, and reported critical qualitative & quantitative metrics across retail merchandising channels and verticals including sites, departments, and categories using SPSS/PASW. ▪ Managed change control processes for ongoing surveys, ensuring precise tracking and evaluation of post-purchase customer satisfaction through Verint (Vovici) Enterprise Feedback Management (EFM).

California State University, East Bay (CSUEB) | Feb 2007 - Sep 2009

Graduate Assistant, Office of Planning & Institutional Research

▪ Designed and deployed surveys of student populations using SurveyGizmo for university-sponsored projects & programs ▪ Performed descriptive & inferential analysis of survey results and metrics using Minitab and SAS. ▪ Published report findings to the university's e-portfolio of institutional demographics (www.csueastbay.edu/ira) leveraging Microsoft Word, Excel, PowerPoint, and Adobe Acrobat. Achievement(s): ▪ Restored CSUEB's institutional demographics e-portfolio from archived legacy data, creating accessibility-compliant reports in adherence to the standards of Section 508 of 29 U.S.C., 794d.

E-LOAN | Oct 2004 - Feb 2006

Telephony Support Engineer, Telecommunications Department

N/A

DIRECTV | Aug 2000 - Feb 2003

Telecommunications Administrator, Information Technologies Group

N/A

Mattel Interactive | Aug 1996 - Aug 2000

Network Administrator I (Telecommunications)

N/A

My Education

Take a look at my formal education

Master of Science (M.S.), STATISTICS (Option in Computational Statistics)California State University-East Bay | 2009
Bachelor of Science (B.S.), MATHEMATICS (Applied) & STATISTICS - DUAL MajorCalifornia State University-Hayward | 2004
Certificate of Completion, Technical Writing Program  · (July 1986 - DecemberChabot College | 1993
Associate-in-Arts (A.A.), COMPUTER SCIENCE (with emphasis in MATHEMATICS)Chabot College | 1993
Associate-in-Arts (A.A.), COMPUTER SCIENCE (General) & JOURNALISM - DUAL MajorChabot College | 1992

About Me

Dean Pangelinan

Dean hasn't filled in a bio text

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free