Summary
Overview
Work History
Education
Skills
Certification
Timeline
background-images

Lea Sam

Gardena,CA

Summary

Experienced Data Analyst with a proven track record in KPI development, data analysis, and database management. Adept at learning and implementing new software applications to meet the demands of upper management and stakeholders. Seeking opportunities to leverage analytical expertise and technical skills in a dynamic and growth-oriented environment.

Overview

23
23
years of professional experience
1
1
Certification

Work History

Process Engineer

Kite Pharma/Gilead Sciences
01.2021 - 01.2024
  • Developed and maintained KPI dashboards for Manufacturing Execution Systems, providing critical insights for process improvements.
  • Conducted in-depth data validation and analysis for various internal GMP projects, ensuring data accuracy and reliability.
  • Provided Root Cause Analysis (RCA) Reports on a weekly and quarterly basis, implementing the four levels of analytics: descriptive, diagnostic, predictive, and prescriptive.
  • Partnered with cross-functional teams to execute process development studies and provide technical recommendations for internal applications.
  • Monitored MES PAS-X Server, allocating disk space, traffic usage, server health, and bandwidth for processes.
  • Manufacturing Execution Systems (MES)

Financial Data Analyst

Patricia Barberis, A.L.C.
01.2018 - 01.2021
  • Provided Income and Expense Reports, Aging Reports, and Balance Ledgers in compliance with Generally Accepted Accounting Principles (GAAP).
  • Analyzed the opposing party’s income and expense declaration (FL-150), along with their bank statements and assets, in collaboration with a Forensic Accountant.
  • Conducted monthly reconciliation of the attorneys’ general and trust accounts, maintaining data integrity for all client accounts and transactions.
  • Delivered critical inventory and budget analysis of revenues, providing actionable insights for financial decision-making.

Network Operations Analyst

Patriot Communications, L.L.C.
01.2001 - 01.2005
  • Developed complex formulary reporting integrated with SQL, providing valuable insights into market demographics and consumer behavior.
  • Conducted in-depth analysis using deep dive analytics, uncovering key insights about consumer behavior and trends.
  • Defined logical attributes and inter-relationships, designing complex data structures to enhance database performance and accessibility.

Education

Bachelor of Science - Advanced Database Management and Analytics

Western Governors University
12.2025

Skills

  • Experienced in KPI Dashboard Development
  • Proficient in Python Programming for Data Analysis
  • Advanced skills in PostgreSQL, including Triggers, User-Defined Functions, and Stored Procedures
  • Strong knowledge of SQL and R Programming
  • Skilled in Technical Writing and creating comprehensive reports
  • Expertise in Database Management, including Data Modeling and ETL processes
  • Competent in Data Visualization tools such as PowerBI, Tableau, and SpotFire
  • Knowledge in GitHub for Version Control

Certification

  • AWS Certified Cloud Practitioner - January 2025
  • Validation Number: 21abf6c0eddb4889a0ad578e80495ae9
  • Validate at: https://aws.amazon.com/verification
  • AWS Certified Solutions Architect
  • Expected completion: June 2025
  • Introduction to Database Queries – NYUx 2020
  • Valid Certificate ID: 3a7a6b7e8b1408f18caa0a1ae24119b
  • Advanced Database Queries – NYUx 2020
  • Valid Certificate ID: fa107d173499d920c54015ed39d7e
  • Advanced Database Administration - NYUx 2020
  • Valid Certificate ID: 9e9361c5d084573a25de5d5ecd0a66a
  • Querying Data with Transact-SQL – Microsoft 2020
  • Valid Certificate ID: c77bbbe0eb4e4b1bbf0f40a7bb47e6c
  • SQL for Data Science – IBM 2020
  • Valid Certificate ID: 940102c9eae4ecca9044660192a9ec
  • Analyzing Data with Python – IBM 2020
  • Valid Certificate ID: 4aed587f4d706b5b5e42999cecd8
  • Google IT Support Certification - 2021
  • The Bits and Bytes of Computer Networking
  • Technical Support Fundamentals
  • Operating Systems and You: Becoming a Power User
  • System Administration and IT Infrastructure Services
  • IT Security: Defense Against the Digital Dark Arts

Timeline

Process Engineer

Kite Pharma/Gilead Sciences
01.2021 - 01.2024

Financial Data Analyst

Patricia Barberis, A.L.C.
01.2018 - 01.2021

Network Operations Analyst

Patriot Communications, L.L.C.
01.2001 - 01.2005

Bachelor of Science - Advanced Database Management and Analytics

Western Governors University
Lea Sam