Thao (Kathleen) Lam
Alexandria,VA
Summary
Self-motivated Senior Data Analyst skilled in requirement analysis, software development, and database management. Self-directed and proactive professional with more than 10 years of vast experience collecting, cleaning, and interpreting data sets. Natural problem-solver possessing a strong cross-functional understanding of information technology and business processes.
Overview
13
13
years of professional experience
1
1
Certification
Work History
Data Engineer
SecurePro, Inc.
Leesburg, VA
07.2023 - 03.2024
- Support US Air Force government clients with business needs.
- Lead most projects and coordinate responsibilities among team members to complete deliverables on time.
- Cleanse, validate, and transform data to ensure accuracy and consistency; develop and maintain data flow diagrams, data models, dashboards, and reports to support business decision-making.
- Collaborate with stakeholders to understand data requirements and provide data-driven recommendations; conduct ad-hoc data analysis and provide insights to answer specific business questions.
- Collaborate with solution architects to define database and analytics engagement strategies for operational territories and key accounts.
- Integrate multiple sources of structured and unstructured datasets into a single platform.
- Plan the migration of current reports from Tableau to Power BI.
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.
- Developed dashboards in Power BI to provide real-time business intelligence insights.
- Created and designed business intelligence databases, spreadsheets or outputs.
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.
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.
- Created and implemented an iterative knowledge transfer process among multiple stakeholder groups.
- Maintained database systems to store and manage large amounts of information.
- Generated automated reports using software such as Microsoft Access or Excel.
- Designed visualizations that accurately represent complex datasets.
- Tested new releases before deploying them into production environments.
- Maintained data integrity and performed routine data audits.
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 of 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
- For business strategy implications not limited to Patch/Update Deployment but also Vulnerability Scans and asset allocation, etc
- In a single or bulk execution basis
- 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 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
- Microsoft SQL Server
- Data Warehouse
- Business Requirements
- Agile Methodologies
- Scrum
- Business Analysis
- Requirements Gathering
- Business Intelligence
- SDLC
- User Acceptance Testing
- Microsoft Power BI
- SharePoint
- Data Management
- Microsoft Excel
- Data Mining
- Data Modeling
- Tableau
- Data Analytics
- Data Warehousing
- Database Administration
- SQL and Databases
- Database Design
- Technical Support
- Problem-Solving
- Analytical Skills
- Adaptability and Flexibility
- Multitasking
- Task Prioritization
- Data Acquisitions
- Decision-Making
- Risk Analysis
- Big data technologies
- Continuous Improvement
- Time Management
- Problem-solving abilities
- Teamwork and Collaboration
- Quality analysis
- Attention to Detail
- Report Generation
- Written Communication
- Effective Communication
- Professionalism
- Data Migration
Certification
- MCSA: SQL 2016 Database Administration, 12/01/19
- Microsoft Power BI Data Analyst, 06/01/23
Clearance
SECRET
Personal Information
Title: Senior Data Management Analyst
Timeline
Data Engineer
SecurePro, Inc.
07.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, 12/01/19
- Microsoft Power BI Data Analyst, 06/01/23
Similar Profiles
Edgar RomeroEdgar Romero
Fire Alarm Inspector/ Alarm Technician at SecureproFire Alarm Inspector/ Alarm Technician at Securepro
Thao (Kathleen) LamThao (Kathleen) Lam
Data Engineer at SecurePro, Inc. (KPMG)Data Engineer at SecurePro, Inc. (KPMG)
Randall EllisonRandall Ellison
Legal Admin at Legalinc Corp.Legal Admin at Legalinc Corp.