Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Timeline
Generic

Lucas J. Lam

Norristown

Summary

SQL Developer and Data Analyst with 5+ years of experience crafting complex SQL queries, including Common Table Expressions (CTEs), subqueries, and joins, to support data-driven decision-making. Proficient in advanced SQL techniques, database optimization, and data visualization tools such as Qlik Sense and IBM Cognos. Adept at managing Agile projects using Jira and leading cross-functional teams to deliver actionable insights that enhance organizational efficiency and performance.

Overview

8
8
years of professional experience
1
1
Certification

Work History

Management and Program Analyst

Department of the Navy
10.2023 - Current
  • Developed complex SQL queries using CTEs and joins to extract and analyze HR data from systems like USASTAFFING and HRLINK
  • Created and maintained data dictionaries to ensure data accuracy and consistency across multiple systems
  • Led Agile projects using Jira, including creating Epics, Stories, and Tasks, and supporting Scrum ceremonies
  • Presented data insights through SQL-based analyses and concise visualizations for executive decision-making

HR Specialist (Information Systems)

Department of the Navy
07.2022 - 10.2023
  • Designed and executed SQL scripts to integrate and cleanse large datasets, enhancing reporting accuracy
  • Utilized Databricks and Qlik Sense to create dashboards, resolving data discrepancies and improving accessibility
  • Provided technical support and user training for HRIS systems, boosting adoption and operational efficiency

HR Specialist (Information Systems)

Department of the Navy
07.2021 - 07.2022
  • Simultaneously managed roles in the MAHRS Training and Liaison Branch and the MAHRS COVID Team:
  • - Training and Liaison Branch: Created data reporting services using HRLINK; developed training strategies and evaluated program effectiveness; authored reports and briefs for leadership
  • - COVID Branch: Managed a 16-member team for COVID-19 compliance; implemented SOPs for tracking and reporting health data using Qlik Sense, ensuring accuracy for 250,000+ employee records

HR Specialist (Information Systems)

Department of the Navy
10.2019 - 07.2021
  • Provided HRIS services to Naval Research Laboratory, Naval Supply, Naval Air Systems Command, and Naval Intelligence
  • Managed account access for HRIS platforms such as MyBiz+, DCPDS, and HRLINK, ensuring system functionality and user compliance
  • Troubleshot and resolved performance management and data reporting issues for multiple Naval commands
  • Authored SOPs to standardize processes, improving operational efficiency across HR systems
  • Analyzed complex HRIS data, creating custom SQL reports to support recruitment, operations, and awards management

HR Specialist (Recruitment)

Department of the Navy
06.2018 - 10.2019
  • Conducted full-cycle recruitment, including job analysis and candidate assessments
  • Developed recruitment strategies leveraging various hiring authorities and executed Pathways and Direct Hire appointments
  • Applied SQL to analyze recruitment metrics, improving process efficiency

HR Recruiter Intern

World Prime Communications
05.2017 - 08.2017
  • Managed candidate pipelines and prequalified over 100 applicants daily
  • Coordinated onboarding and ensured compliance with hiring documentation

Education

Bachelor of Business Administration - Human Resource Management, Management Information Systems

Temple University
Philadelphia, PA
05.2018

Skills

  • Advanced SQL
  • Database optimization
  • IBM Cognos
  • Qlik Sense
  • Jira
  • Confluence
  • Agile Methodologies
  • Oracle Databases
  • MySQL
  • HRIS platforms
  • Requirements gathering
  • Risk assessments

Accomplishments

  • Authored 100+ SQL-based reports, enhancing Navy and Marine Corps personnel decision-making processes.
  • Optimized SQL queries, reducing data processing time by 30%.
  • Implemented Jira workflows, improving project tracking and increasing task completion rates by 20%.
  • Standardized data dictionaries for large datasets, ensuring reporting accuracy across HR systems.

Certification

  • Lean Six Sigma – Green Belt
  • Google IT Support Professional Certificate
  • Lean Six Sigma – Yellow Belt

Timeline

Management and Program Analyst

Department of the Navy
10.2023 - Current

HR Specialist (Information Systems)

Department of the Navy
07.2022 - 10.2023

HR Specialist (Information Systems)

Department of the Navy
07.2021 - 07.2022

HR Specialist (Information Systems)

Department of the Navy
10.2019 - 07.2021

HR Specialist (Recruitment)

Department of the Navy
06.2018 - 10.2019

HR Recruiter Intern

World Prime Communications
05.2017 - 08.2017
  • Lean Six Sigma – Green Belt
  • Google IT Support Professional Certificate
  • Lean Six Sigma – Yellow Belt

Bachelor of Business Administration - Human Resource Management, Management Information Systems

Temple University
Lucas J. Lam