Sign in

Sql Server Manager

Forest Hills, NY, 11375
May 05, 2017

Contact this candidate


Charles Li

**** ***** ** - **

Forest Hills, NY *1375



Hands-on manager, full-stack developer, and adjunct professor with eighteen years of experience in system architecture, programming, database design, and QA

Technical Skills

Programming: ASP.NET MVC, C#, VB.NET, RESTful API, SharePoint, Entity Framework, Dapper; HTML5, CSS, JavaScript, jQuery, Json, AngularJS, Bootstrap; MS Office VBA, VSTO; C++, Java, JSP, Java Servlets; PHP and WordPress

Report Design: Crystal Reports, SSRS, Oracle Reports, Excel PivotTables

Database: Microsoft SQL Server 6.5-2014 DBA, T-SQL, SSIS, SSAS; Microsoft Access; Oracle 8i-12c, OBI, Data Modeler, PL/SQL; MySQL 5.5, Workbench; ERwin, programming of stored procedures, functions, and triggers

Applications: MRI Real Estate Solutions, Nexus Payables, Sage 300 Timberline, TimberScan, Kardin, Millennia, Salesforce; SAP R3/BW, OpenText Livelink, Meridian Proliance, Cúram, HP Quality Center, QTP; Photoshop

Work Experience

Independent Contractor

3/2015 – Present Senior Full-stack Developer/DBA

Develop new features, customizations, and bug fixes for e-Commerce websites utilizing C#, ASP.NET MVC, NHibernate, Entity Framework, JavaScript and jQuery.

Program PHP/MySQL to integrate payment system and affiliate websites.

Serve as DBA to manage SQL Server 2008-12 servers with replication on Azure, improve Maintenance Plans and performance.

Clients include Easy Rent Systems, Custom Office Development, Digi South, etc.

New York Institute of Technology

8/2009 – Present Adjunct Professor

Teach programming with Java I & II, database interface programming with JSP, Java Servlets and MySQL, database management with SQL Server 2008-12, SSIS, SSRS, SSAS, distributed database, replication and AlwaysOn.

Taught C++, database design/data modeling with Oracle 11g, web programming with HTML5, CSS3, JavaScript, jQuery, network security, and MS Office at CUNY.

Terra Holdings LLC

Parent Company of Brown Harris Stevens, Halstead Property, RealPlus

1/2016 – 12/2016 Senior Web Engineer

Developed real estate market and web data analytics with SQL Server ETL, C# MVC, RESTful API, Json, JavaScript, jQuery, AngularJS, Bootstrap, and plugins.

Silverstein Properties, Inc.

4/2014 – 2/2015 Senior Applications Analyst

Developed web application for mobile devices with ASP.NET, C#, JavaScript, jQuery, Bootstrap.

Created workflows with SharePoint Designer and InfoPath.

Designed business reports using MRI Report Designer, Crystal Reports and SSRS.

Provided support and troubleshooting of business applications, including MRI, Timberline, TimberScan, Nexus Payables, Kardin, Millennia, Salesforce, and Opera.

Managed production SQL servers (2008 & 2012), Oracle 11g database server, SharePoint 2010/2013, and various application servers.

Independent Contractor

8/2009 – 4/2014 Database Application Developer and QA

Customized and implemented software packages on Oracle/SQL Server for the forestry industry, tested iPhone apps, wrote user documentation, and trained users.

Customized Access, Excel, Word VBA solutions for small businesses.

Developed websites with HTML, CSS, JavaScript/jQuery, PHP, and WordPress.

Performed QA testing of web sites and iOS/Mac OS applications.

Clients included 3LOG Systems Inc. (2013-14), Visual Goodness/Benihana (2013), Custom Office Development (2012-13), Comcast (2009-11) among others.

NYC Dept. of Information Technology and Telecommunications, NY

12/2008 - 2/2010 Director of Operations, HHS-Connect

Managed a team to maintain, support and enhance Access NYC ( developed with Cúram, J2EE, Oracle 11g on Solaris 10.

Tested and provided implementation support for Worker Connect, a composite application used by 10 government agencies and developed with FileNet, DataStage, MDM, and Oracle WebLogic Portal.

Used HP Quality Center to track defects and manage bug fixes; used QTP and LoadRunner to perform automated testing.

Forest City Ratner Companies, Brooklyn, NY

10/2007 – 12/2008 Director of MIS

5/2004 – 10/2007 QA Manager

Managed a team of software developers and quality assurance analysts through the full life cycle of general business and financial applications.

Designed application architectures and technical specifications; developed and maintained web-based financial reporting systems and business applications using ASP.NET (VB.NET and C#), SQL Server and SSIS/SSRS, and CrystalReports.

Developed an Intranet portal of SharePoint team sites, InfoPath forms and workflow system for tracking system development and change activities as well as approvals.

Implemented and upgraded the company’s financial and project management systems (Timberline, MRI, Proliance with Cognos reports).

Managed testing and release process for SAP ERP/BW implementation, system changes, and network and server upgrades; implemented HP Quality Center/QTP (formerly Mercury) for automated testing.

Tested and deployed OpenText Livelink workflows, Web Forms, Live Reports, and OScript code for budget and expense authorization processes.

Identified and analyzed IT risks, proposed internal controls to mitigate risks; worked with both internal and external auditors regularly to monitor the compliance of IT controls as required by Section 404 of the Sarbanes-Oxley Act (SOX).

Wrote and implemented the company’s system development life cycle (SDLC) procedures, quality assurance standards, and change management procedures.

Assisted PMO to prepare project plans and budget for major projects.

NYC Department of Homeless Services, New York, NY

9/2003 – 4/2004 Computer Specialist (Software Programmer)

Enhanced the Client Tracking System using VB, COM+, ADO and Oracle 9i.

Developed business and financial reports using PL/SQL.

Debevoise & Plimpton LLP, New York, NY

5/2001 – 8/2003 Programming Team Leader

Served as lead programmer for this top international law firm and provided leadership in application development; managed a team of six developers.

Using VB 6, VB.NET, SQL Server 2000, and Crystal Reports, developed enterprise applications, including Corporate Staffing, Summer Associate InfoSite, Summer Outing, HR reports, and Elite Accounting Reports.

Programmed Word VBA for automating word processing tasks and integrating Word with the firm's document management system Docs Open.

Designed and implemented an enterprise data warehouse with SQL Server 2000 and DTS, which integrated data sources from HR and accounting systems.

Participated in the firm's major upgrades and system migrations, including Windows NT to 2000 upgrade, e-mail migration from GroupWise to Exchange and Outlook 2000, and Elite upgrade.

Recruited, trained, supervised and evaluated staff.

New York University, New York, NY

5/2000 – 4/2001 Client/Server Developer

Developed and enhanced VB 6 applications for Human Resources.

Using Oracle 8i Forms & Reports, designed and developed confidential financial and personnel reports for NYU's web-based eReports system.

Participated in the development of an ASP web-based student information system.

NYC Department of Housing Preservation and Development, NY

10/1999 – 4/2000 Computer Specialist

Worked directly with the Chief Information Officer to address high-priority and urgent issues related to Y2K remediation of the Section 8 Voucher/Certificate payment processing system, legal case tracking, and materials management.

Analyzed business requirements and recommended solutions.

NYC Department of Design and Construction, Long Island City, NY

10/1996 – 10/1999 Team Leader of Geographic Information System (GIS)

Supervised and trained GIS and web design staff; enhanced the GIS system.

Designed and implemented SQL Server databases; developed client/server applications for managing construction projects and contracts.

Developed and managed the agency's first web site


New York University, New York, NY

Professional Certificate in Business Project Management, Fall 2006

Java programming and Oracle DBA courses

Columbia University, New York, NY

Ph.D. in Urban Planning (incomplete)

University of Cincinnati, Cincinnati, OH

Master of Community Planning

Tsinghua University, Beijing, China

Bachelor of Architecture


Microsoft Certified Professional: Querying SQL Server 2012/2014, June 2016

IBM Cúram Certified Professional, August 2009

Microsoft Certified Technology Specialist: Microsoft SQL Server 2005, June 2009

Microsoft Certified Professional: Designing and Implementing Databases with SQL Server 7.0, April 2000

Contact this candidate