Yuan Li (Ewen Lee)
Sr. Web Programmer/Analyst
***** ********** ***** ******* ** 22030
703-***-**** (c) *******@*******.***
PROFESSIONAL PROFILE
U.S Citizen, Public Trust Clearance. Over10 years of web development experience with private sectors and government contracts, using ColdFusion, JavaScript, XML, Dreamweaver, Visual Code, SQL Developer, Github, Postman. Familiar with government Section 508 Technical Standards.
Excellent communication skills
EXPERIENCE
From
04/01/2021
To
10/06/2023
Title
Sr. Web Developer
Trigent Solutions Inc
14801 MURDOCK ST, CHANTILLY, VA 20151
U.S Small Business Administration- Capital Access Financial System (CAFS)
Role and tasks: O&M supporting CAFS, system enhancements, creating/updating APIs of CLS and Elend.
From
08/2018
To
03/31/2021
Title
Sr. Web Developer
Alpha Omega Integration System
8150 Leesburg Pike, Vienna VA
U.S Small Business Administration-DSBS, HCTS, PRONET, SBSSCCR
Role and tasks: O&M supporting SAM to SBA data transfer interfaces, HUBZone Certification Tracking System (HCTS), Dynamic Small Business Search (DSBS), PRONET, SBSSCCR, Tasks include 1) trouble shooting, enhancements, data scripts; weekly statistics reports, testing, documentation, CCB, ECCB, releases.2) migration of TSS, NOCMS and SUBNET to AZURE environments; maintaining SAM2SBA and SBA2SAM interfaces, enhancements on DSBS and HCTS
From
09/2017
To
08/2018
Title
Sr. Web Developer
C-MCI
10306 Eaton Place, Suite # 520 Fairfax VA
U.S Small Business Administration-DSBS, HCTS, E8A, PRONET, SBSSCCR
Role and tasks: O&M supporting SAM to SBA data transfer interfaces, HUBZone Certification Tracking System (HCTS), Dynamic Small Business Search (DSBS), PRONET, SBSSCCR, Electronic 8A Reviewing System (E8a), Tasks include trouble shooting, enhancements, data scripts, testing, documentation, CCB, ECCB, releases.
From
08/2015
To
08/2017
Title
Sr. Web Developer
GADDIS Consulting 308 Overdale St, Morgantown, WV 26501 304-***-****
U.S Small Business Administration-DSBS, HCTS, E8A, PRONET, SBSSCCR
Role and tasks: Team lead, O&M supporting SAM to SBA data transfer interfaces, HUBZone Certification Tracking System (HCTS), Dynamic Small Business Search (DSBS), PRONET, SBSSCCR, Electronic 8A Reviewing System (E8a), BDMIS systems. Tasks include trouble shooting, enhancements, data scripts, testing, documentation, CCB, ECCB, releases.
From
08/2013
To
08/2015
Title
Sr. Developer, Team Lead
C3-Systems,
2451 Crystal Drive, Arlington, VA 22201
U.S Small Business Administration-DSBS, HCTS, E8A, PRONET, SBSSCCR
Role and tasks: Team lead, O&M supporting SAM to SBA data transfer interfaces, HUBZone Certification Tracking System (HCTS), Dynamic Small Business Search (DSBS), PRONET, SBSSCCR, Electronic 8A Reviewing System (E8a), Woman Owned Small Business (WOSB) systems. Tasks include trouble shooting, enhancements, data scripts, testing, documentation, CCB, ECCB, releases, mentoring.
From
08/2003
To
07/2013
Title
Sr. Developer
Communications Resource, Inc.
8280 Greensboro Drive Suite 400
McLean, VA 22102
U.S Dept of Education - Data Management Tracking Application (DMTA)
ColdFusion MX application/SQL server 2000, 508 compliant
Developed this new stored procedure driven application using CF MX tags. Modules include single sign on using cfinvoke to access ednet active directory; administration; cfdocument pdf reports; front-end and server-side page validation.
U.S Dept of Education - Audit Accountability and Resolution Tracking System (AARTS)
ColdFusion MX Fusebox/SQL server 2000, 508 compliant
Developed this new stored procedure driven application using CF MX tags. Modules include single sign on using cfinvoke to access ednet active directory; administration; cfdocument pdf reports; front-end and server-side page validation.
U.S Dept of Housing & Urban Development - Client Activity Retrieving System
JAVA application developed in SOAP, XML/Sybase:
Developed internal and external report and administration areas using JSP. Specific tasks include writing modules to check page and user validity and calling stored procedures to display data per business rules.
U.S Dept of Housing & Urban Development - Lenders Assessment Subsystem (LASS)
Personally spear-headed major new development releases for HUD Lenders Assessment Subsystem (LASS), including physical designing, coding and testing. Responsible for analysis, maintenance and development of LASS using ColdFusion 5.0, as the front end tools to talk to Sybase and SQL server respectively. Specific tasks include optimizing LASS to improve performance, making fixes in LASS per clients’ problem reports and making enhancements per clients’ system change requests, which further include coding in ColdFusion, writing Javascript functions and/or writing scripts and stored procedures to run in Sybase and testing and sending out weekly data fix releases. Provided Section 508 compliance training
From:
01/2003
To:
08/2003
Title:
Sr. Programmer/Analyst
Zen Technology Inc.
8120 Woodmont Avenue Suite 260, Bethesda, MD 20814
Continued serving as a Senior Programmer/Analyst with Zen Technology on a sub-contract with the U.S. Department of Housing and Urban Development, supporting the Real Estate Management System (REMS). Major technical responsibilities include:
Completing problem reports and change requests.
Making enhancements to existing functionalities of REMS.
Engaging in new developments per user requests. Analyzing/documenting program specifications.
From:
08/2000
To:
09/2002
Title:
Sr. Programmer/Analyst
Advanced Technology Systems (ATS)
7915 Jones Branch Drive
McLean, VA 22102
Served as a Senior Programmer/Analyst on a contract with the U.S. Department of Housing and Urban Development, supporting the Real Estate Management System (REMS). Major technical responsibilities included:
Developing Web pages that feature various forms of data manipulation, including view, search, change, input and deletion of data.
Using cookie, session, client, application, and CGI variables to maintain application page state/flow and security.
Writing modules and custom tags, including files to achieve code reusability.
Writing JavaScript (js) functions into the js files for front-end validation (date, length, type, etc.) and function reusability.
Creating triggers and indexes to ensure database performance and data integrity.
Writing stored procedures into Sybase and calling them in Cold Fusion to handle complicated queries or queries that were repeatedly used.
Participated in the development of 5 major releases during this time. Specific tasks completed included:
Redesigning screens shared by the DEC and HUD with input from both organizations to provide interim functionality for enforcement processing while the DEC continued to define its process and protocols with HUD.
Adding integration to between REMS and REAC’s Financial Assessment Sub-System (FASS) and Physical Assessment Sub-System. This integration enabled on-line access to Annual Financial Statements from FASS in REMS and Physical Inspection Scores and Reports in REMS.
Completed Section 508 compliance changes on REMS based on APPENDIX E HUD Voluntary Product Accessibility Template, including coding and testing.
Making enhancements to support the first release of the Automatic Renewal and Amendment Management Subsystem.
Automating the process industry participants use to submit 2530 information and the process HUD staff use to review and approve the submissions.
Redesigning screens to incorporate user input into APPS system.
Building mechanisms to compare Industry user input against sources of flags for the HUD headquarters review process.
Building a system that allows a problem property to be flagged by using property ID or name.
Building a three-tier system to track the Previous Participation records that are inheritable from its parent tier.
EDUCATION
Degree
Year
Major Field of Study
Institution
M.S
1998
Computer Science
Southeastern University
M.B.A.
1996
Int’l Business
Southeastern University
M.A.
1987
English
Sichuan University, China
TECHNICAL TRAINING, CERTIFICATIONS AND CREDENTIALS
Certified in ColdFusion 4.5 (Brainbench), 2001
Certified in Javascript (Brainbench), 2001