ANNE GUO [email protected] SKILLS • Professional experience in full-stack web and desktop software development with ASP.NET c# MVC5/Web Form, JavaScript, jQuery, Ajax, HTML5/CSS, PowerBuilder, ETL, MS Access VBA • Expert level in T-SQL programming, Database design and MS SQL server administration • MS Office, MS SSIS/SSAS/SSRS, Crystal Report, PowerBI, Angular 2, ASP.NET Core, ASP.NET Web API Services, Hangfire, Dapper, IIS, Erwin, MS Visio, MySQL, PostgreSQL, Slack, J# • Azure, Amazon-Web-Services, Google Cloud Platform/BigQuery, Github, Python3.8, Azure DevOps • Self-motivated, Fast learner, Great problem solver EXPERIECE Independent Consultant Feb., 2018 - Present • Providing high quality IT services to clients using these products: MS SQL server (on premium and Azure), PowerBuilder, MS ACCESS VBA. Lead Developer/DBA, New York City Campaign Finance Board, MIS Jan., 1996 - Jan., 2018 • Being the lead developer of agency’s major web and desktop applications using ASP.NET c# MVC5/Web Form, JavaScript, jQuery, Ajax, HTML5/CSS, SSIS, PowerBuilder, MS Visio, Erwin and T-SQL with MS SQL server 2000/2005/2012/2017/Azure for more than twenty years. The work included database design and maintenance; software design, coding, testing, deploying, maintaining and technical support; complex report writing; process automation; ETL; data comparison; data analysis; document tracking; campaign finance data’s auditing; voter guide and legal processing etc. • As agency’s DBA, responsible for MS SQL server’s installation, maintenance, turning, upgrading, and troubleshooting. Programmer/Analyst, New York City Department of Parks & Recreation, MIS Sept., 1990 – Jan., 1996 • Responsible for system analyzing, design, coding, testing, deploying, maintaining, technical support using FOXPRO/2.5, CLIPPER/.01, DATAEASE etc. Major applications were “Work Order Tracking System”, “Recreation Center Management System”, “Work Experience Program”, “Parks Career Training Program”, “Green thumb System”, etc. EDUCATION Master of Art in Computer and Information Science, Brooklyn College of CUNY, 1989 ©