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
©