Ya-Lin Daphne
Rockville,MD
Summary
Results-driven Systems Analyst with expertise in system analysis, data management, and SQL development. Proven ability to enhance software functionality and optimize system performance.
Overview
24
24
years of professional experience
Work History
Systems Analyst
Westat
Rockville, MD
09.2001 - 05.2025
- Analyzed system requirements to enhance software functionality.
- Collaborated with cross-functional teams to define project scope and objectives.
- Evaluated existing systems and recommended improvements for efficiency.
- Conducted user training sessions to ensure proper software usage.
- Implemented data management protocols to maintain data integrity and security.
- Supported troubleshooting efforts to resolve technical issues promptly.
- Provided support for end users in troubleshooting system issues.
- Designed, developed, tested, documented, and maintained new applications and software components.
- Resolved escalated issues from help desk personnel related to system functionality.
- Identified areas for improvement in current systems architecture and proposed strategies for optimization.
- Analyzed user requirements and implemented system changes to improve efficiency.
- Provided training sessions for end users on how best utilize the company's systems.
- Deployed updates or patches to existing systems in order to maintain optimal operation levels across all environments.
- Designed database architectures to support application development and data management.
- Developed and optimized SQL queries for data retrieval and report generation.
- Implemented data integrity checks to ensure accurate and reliable information storage.
- Collaborated with cross-functional teams to gather requirements for new database features.
- Conducted database performance tuning to enhance system efficiency and responsiveness.
- Monitored database performance and provided troubleshooting for any issues or errors encountered.
- Created stored procedures, triggers, tables, views and functions using T-SQL.
- Provided technical support for end users by resolving complex SQL queries and optimizing their performance.
- Provided support to clients in understanding and manipulating data to obtain value through SQL and ETL technical processes and visual analytics tools.
- Utilized various tools such as SQL Server Management Studio, Toad Data Modeler, Visual Studio Code and Red Gate Software products for development purposes.
Education
BS - Hotel Management
UMGC
Gaithersburg, MD08-1999
Skills
- System analysis
- Data management
- SQL development
- System architecture
- Application development
- Project coordination
Timeline
Systems Analyst
Westat
09.2001 - 05.2025
BS - Hotel Management
UMGC