Project Manager Sql Server

Sam Storer

** *. **** **., *** ***

New York, NY 10010

Cell: +1-212-***-****

***.******@*****.***

Executive Summary

I bring demonstrated success as an innovative, self-directed technology developer and project/ product manager with strong communication skills and high sensitivity to the requirements of real-time business needs and professional staff

Education

Dartmouth College, B.A. Economics

Project Management Professional (PMP) Certification

Skills

ASP.NET , VB.NET, C#.NET - Visual Studio 2003-2005-2008-2010

SQL/ T-SQL - Complex queries, Stored Procedures, Triggers

Database Administration – SQL Server 200*-****-****

VBA Development

Project/ Product Management

Employment History

ActiveHealth Management (New York, NY)

VB.NET Developer (October 2011 - Dec 2011)

Responsible for supporting, reverse engineering and documenting legacy application, extracting business rules and work flow logic (VB.NET, PL/SQL, ASP.NET).

Independent Day Trader and Consultant (San Francisco, CA; Providence, RI, New York, NY)

(July 2009 - October 2011)

• Various development and consulting projects (VB.NET, ASP.NET, C#.NET, Objective C)

• Self-taught basic iOS development (Objective C, C#.NET)

• Acquired PMP Certification

Wedbush Securities (San Francisco, CA)

Director of Capital Markets IT (January – July, 2009)

• Project Manager for integration of Pacific Growth into this acquirer

• Included significant customization of our existing in-house systems, which Wedbush embraced enthusiastically, and continues to utilize today

Pacific Growth Equities, LLC (San Francisco, CA)

IT Director, Partner (1991 – January, 2009)

• Initially, NASDAQ Market Maker, also handling all IT responsibilities, including development of proprietary Trading Platform, which I conceived and built (Lotus 1-2-3, then Access and VB 6)

• System connected to NASDAQ via API, and Instinet via FIX, to receive trade executions

• Managed positions, P&L

• Risk management alerts

• Allowed real-time P&L reporting, EOD, EOM, EOQ, EOY compensation analysis

• Detailed reporting by a variety of groupings -- Security, Analyst, Sales Person, Account

• In 2001 transitioned to IT Director, where, in this small shop, I had broad responsibility and authority, and a small staff. Meant significant multi-tasking and hands-on effort

• Conceived, designed, built, deployed and maintained ‘VanDe’ - our in-house Trading System (SQL Server, VB, VB.NET) (1991 – 2003)

• Trading Platform was rebuilt first as client-server using Access as server DB, then migrated to SQL Server for improved performance and robustness

• As a former trader, I worked closely and well with the trading team to determine and meet their requirements

• Conceived, designed, built, deployed and maintained in-house Intranet, Extranet and CRM System, including comprehensive BI and reporting (SQL Server and VB.NET/ ASP.NET 2003-2005) (2001 – 2009)

• Enhanced and extended Trading System to provide functionality to other areas of the firm

• Worked with all professionals firm-wide -- Sales, Trading, Research, and Executive Committee

• Used strong communication skills and user-feedback loops to improve this system constantly, adding functionality that the professional staff required. My ability to understand the business needs, and my strong interpersonal skills, led to high User Acceptance and utilization

• Reporting and BI systems (SQL, ASP.NET) that provided extensive dashboard views and metrics to all professionals

• Client-facing extranet that facilitated research distribution

• Sole responsibility for design, installation and maintenance of 100-million record transactional database and data warehouse – 90 tables, sub-10GB total size (SQL Server 2000), including disaster recovery, and query and index optimization

• SQL & T-SQL development 1997 – 2011 - Including database design, complex queries, stored procedures

• Legacy code management and debugging

• In-house ETL connectors to Fidelity and Merrill Lynch databases (.NET, DB2; 2001-2009)

• First when we deployed Fidessa, then when we changed clearing firms, we found the new services did not provide nearly the depth or flexibility of reporting that we required

• Consequently, built in-house systems to DataPump (ETL) daily dumps into our SQL Server, which allowed provision of the detailed metrics and reporting required by Sales, Trading, Research, and Executive Committee

Contact this candidate