Thao (Kathleen) Lam
Alexandria,VA
Summary
Practical Database Engineer possessing in-depth knowledge of data manipulation techniques and computer programming paired with expertise in integrating and implementing new software packages and new products into system. Offering more than 10 years of background managing various aspects of development, design and delivery of database solutions. Tech-savvy and independent professional bringing outstanding communication and organizational abilities.
Overview
13
13
years of professional experience
1
1
Certification
Work History
Data Engineer
SecurePro, Inc. (KPMG)
Leesburg, VA
06.2023 - 03.2024
- Supported US Air Force government clients with business needs.
- Led most projects and coordinated responsibilities among team members to complete deliverables on time.
- Integrated multiple sources of structured and unstructured datasets into a single platform.
- Developed documentation and guides for analytics usage and maintenance.
- Collaborated with Senior Data Engineers and Data Scientists to perform operations and prepare data for analysis (e.g., data cleansing, data integration, data transformation).
- Support delivery of client solutions using analytics, exploratory data analysis, data wrangling, and ETL in Databricks.
- Migrated current Tableau reports to Power BI based on new requirements.
- Gathered analytic requirements from functional owners and translated business requirements to functional specifications.
Senior Data Analyst
T-Rex Solutions, LLC
Greenbelt, MD
11.2022 - 06.2023
- Supported the adoption of technologies at military treatment facilities and installations around the world.
- Worked closely with senior T-Rex Technical Leads, a team of training and communication specialists, DHMS leaders/staff, and DHMS vendors to plan and execute the rollout of training and adoption activities.
- Developed various training dashboards to capture and measure deployment training progress, statuses, and metrics.
- Worked with Python scripts to convert raw data into a clean and structured format for data analysis and reporting.
- Created data visualizations in Tableau to present findings to stakeholders.
- Maintained a library of model documents, templates, or other reusable knowledge assets.
Business Systems Specialist
LUMARK TECHNOLOGIES, INC.
Fairfax, VA
04.2021 - 11.2022
- Created and updated complex Microsoft Excel workbooks containing a primary dashboard worksheet and several backup worksheets to support weekly and monthly metrics collection and reporting.
- Troubleshooted and problem-solved issues regarding different databases, reporting tools, and raw data within the database.
- Understood, developed, or guided activities related to data mapping between data systems (source and target).
- Quality-checked all production reports before submitting them to the client.
- Demonstrated experience using advanced Excel capabilities to include pivot tables, slicers, timelines, look-ups, complex formulas, and other features.
- Developed dashboards in Power BI to provide real-time business intelligence insights.
Senior Data Management Analyst
Cloud Lake Technology
Fort Belvoir, VA
07.2018 - 04.2021
- Supported the DoD IAC PMO as a Senior Data Management Analyst with a focus on both maintaining existing modules and expansion/development of additional modules for the Supplemental Information Management Office Network (SIMON).
- Functioned as lead developer for any IAC database development needs to include data architecture planning and data management considerations.
- Diagnosed and resolved database access and performance issues.
- Developed and maintained databases across the organization, while ensuring elevated levels of data availability.
- Tested new releases before deploying them into production environments.
- Maintained data integrity and performed routine data audits.
- Created SQL queries to extract data from databases for reports.
- Generated automated reports using software such as Microsoft Access or Excel.
Data Analyst/Excel Expert
Boeing
Chantilly, VA
03.2017 - 07.2018
- Resolved customer service issues related to data intelligence solutions.
- Performed troubleshooting of Excel financial data to clean up corrupted files.
- Created access databases to manage and analyze financial data with quick query capabilities.
- Developed Excel slicers, charts, and dashboards to present data in a usable format for upper management.
- Created methodologies, templates, guidelines, checklists, and other artifacts to establish repeatable processes.
- Provided training to Financial Analysts on the new process for monthly data reporting.
- Supported Management with monthly reporting deliverables.
- Built visualizations that enabled users to quickly interpret results from complex analyses.
- Synthesized current business intelligence or trend data to support recommendations for action.
Project Management Analyst
Natoma Technologies, Inc
Arlington, VA
09.2016 - 02.2017
- Supported the PM in all aspects of delivery including developing plans and cost estimates, project documentation, and managing cost and quality control.
- Performed technical analysis using monitoring tools and querying to troubleshoot issues, identified the root cause, and executed maintenance operations.
- Created trouble tickets such as incidents, change requests, and service requests for users.
- Facilitated the daily scrum meeting as a scrum master.
- Assessed project issues and developed resolutions to meet productivity, quality, and client satisfaction goals and objectives.
Business Analyst
Department of Veterans Affairs
Washington, DC
02.2016 - 09.2016
- Provided Program Management Support Services (PMSS) to the Veterans Benefits Management System (VBMS) Program Management Office (PMO).
- Created daily dashboards and reporting for User Acceptance Testing (UAT).
- Created a government timecard to record daily hours and work activities for each team member.
- Used SharePoint to help in the management of data repository, documents, and work items that need to be stored, found, collaborated on, updated, managed, documented, archived, and traced or restored - following relevant compliance with the Veterans Administration policies.
- Collaborated closely with end-users to gather report requirements and ensured proper testing/validation.
- Supported Business Testing (BT) in developing and maintaining artifacts, User Acceptance Testing (UAT) metrics, defect analysis, and generated Excel dashboards and reports.
Quality Assurance Specialist
US Dept. of Agriculture
Washington, DC
04.2015 - 01.2016
- Collected/evaluated Business Intelligence data from systems such as Microsoft System Center Configuration Manager (SCCM), Remedy's Service Asset Configuration Management (SACM) Remedy, Enterprise Mobility Manager (EMM) Active Directory (AD), checklist, surveys, etc.
- Used Remedy IT Service Request Management Suite to assign work tickets to a staff of 30 IT Technicians.
- Provided and supported all Quality Assurance responsibilities for required projects.
- Reviewed documents, such as production reports, and ticket requests reports, seeking process improvement opportunities, with a specific eye for customer-driven gains.
- Served as an 'account manager' in the interest of service delivery to end-users.
- Multitasked as a Project Coordinator, Help Desk Support, Inventory Administrator, and Quality Assurance Specialist.
Project Manager
AT&T Government Solutions, Inc
Oakton, VA
04.2011 - 04.2014
- Provided Project Management expertise and guidance to team members and the customer.
- Analyzed information and situations and implemented actions, independently or through the management team, to ensure project objectives were met.
- Conducted regular status meetings with internal teams and external partners to track progress against established milestones.
- Collaborated closely with senior management on long-term strategic planning initiatives related to projects in the development or execution stages.
- Participated in cross-functional teams responsible for developing innovative solutions for complex problems.
- Implemented effective communication protocols between internal teams working on different aspects of a given project.
- Managed multiple projects with competing deadlines simultaneously.
Education
Bachelor of Science in Information Technology -
Strayer University
12.2014
Skills
Attention to Detail
Big Data Technologies
Business Intelligence
Communication Skills
Continuous Improvement
Critical Thinker
Data Analytics
Data Migration
Data Modeling
Data Security
Data Visualization
Data Warehousing
Database Administration
Database Design
Database Development
Database Management
Database Systems
Effective Communication
Microsoft Access
Microsoft Excel
Multitasking
Organizational Skills
Power BI
Professional Demeanor
Python
Quality Analysis
Relational databases
Reliability
Report Generation
Risk Analysis
Scripting Languages
SQL and Databases
Stakeholder Communication
Tableau
Task Prioritization
Teamwork and Collaboration
Certification
MCSA: SQL 2016 Database Administration
Microsoft Power BI Data Analyst
Clearance
SECRET
Timeline
Data Engineer
SecurePro, Inc. (KPMG)
06.2023 - 03.2024
Senior Data Analyst
T-Rex Solutions, LLC
11.2022 - 06.2023
Business Systems Specialist
LUMARK TECHNOLOGIES, INC.
04.2021 - 11.2022
Senior Data Management Analyst
Cloud Lake Technology
07.2018 - 04.2021
Data Analyst/Excel Expert
Boeing
03.2017 - 07.2018
Project Management Analyst
Natoma Technologies, Inc
09.2016 - 02.2017
Business Analyst
Department of Veterans Affairs
02.2016 - 09.2016
Quality Assurance Specialist
US Dept. of Agriculture
04.2015 - 01.2016
Project Manager
AT&T Government Solutions, Inc
04.2011 - 04.2014
Bachelor of Science in Information Technology -
Strayer University
MCSA: SQL 2016 Database Administration
Microsoft Power BI Data Analyst
Similar Profiles
Thao (Kathleen) LamThao (Kathleen) Lam
Data Engineer at SecurePro, Inc.Data Engineer at SecurePro, Inc.
Priya GuptaPriya Gupta
Senior at KPMGSenior at KPMG
Michael FinleyMichael Finley
Modern Workplace Technical Lead at KPMGModern Workplace Technical Lead at KPMG