Project Manager Sql Server

Todd Hayes

*** ******** ****, ********, ** *****

Phone: 203-***-**** Email: ****.*******.*****@*****.***

Summary

A hands-on IT manager with a track record of building and leading effective teams. Experience developing and

supporting sophisticated SQL Server databases and stored procedures. Hands-on with a variety of technologies

including SQL Server 2008/2005/2000, MySQL, PHP, JavaScript, HTML, and CSS.

Education

Rensselaer Polytechnic Institute – Troy, NY 1996

MBA, Information Systems and Financial Management

Rensselaer Polytechnic Institute – Troy, NY 1992

BS, Management-Psychology (double major)

Technical Skills

SQL Server (2008/2005/2000) • Visual Basic • VBScript • JavaScript • HTML • XML • CSS • XAMPP Server •

MySQL • Workbench • PHP • Eclipse • SVN Subclipse • Firebug/FirePHP • MS Office • MS Project • Visio

Experience

Royal Bank of Scotland – Stamford, CT Feb 2010 – April 2013

Vice President of Production Services

Led the U.S. component of a global support team that uses a follow-the-sun model to provide 24-hour

n

support for more than 15 regional and global applications (.Net architecture: C# / SQL Server).

Responsible for onboarding new applications to the support team: defining service level agreements (SLAs),

n

arranging training, defining escalation procedures, coordinating support with other regions, configuring the

Bank’s ticketing system, and developing reports on performance metrics.

Debugged SQL Server (2000/2005/2008) stored procedures and functions.

n

Analyzed data to identify data integrity problems.

n

Developed custom reports using T-SQL.

n

Expanded the U.S. team to RBS’s low cost center in Salt Lake City. Hired and trained the analysts for the

n

Utah office and integrated them into the larger global team.

Connolly Consulting – Wilton, CT Jan 2008 – Dec 2009

Manager of Data Services

Led an operations team for an audit recovery firm with six direct reports.

n

Developed functions and complex stored procedures in SQL Server 2008 to data mine clients’ accounts

n

payable data (100MB to 2TB) to identify overpayments.

Emphasis on query optimization and performance tuning.

n

Used Pervasive’s suite of ETL tools to load and transform client data into Connolly’s standard schema.

n

Developed audit reports using MS Access Reports.

n

Collaborated with audit staff to define business requirements.

n

Customized and supported Decipher and ClaimsPlus, Connolly’s proprietary auditing applications.

n

Todd Hayes Page 2

Clayton Services – Shelton, CT Sep 2004 – Aug 2007

Director of Business Analysis

Took charge of a team of 13 programmers suffering from 50% turnover and low productivity. The team

n

supported mortgage underwriting deals for clients that included hedge funds and major investment banks.

Successfully eliminated turnover and restructured the team through recognition and salary raises for key

team members, hiring new programmers, and moving to a ticketing system that simplified deal support.

Project manager for Clayton’s document imaging application. Projects included OCR tuning, and

n

improvements to the user interface to increase the efficiency of human quality checkers. Managed the

integration of six mortgage originators with the document-imaging platform.

Designed and implemented an ETL process for the onboarding of loans to Clayton’s Loan Analysis System

n

(CLAS). Assembled and managed a team of six collateral analysts to operate the onboarding process.

Assisted in the design of a master database to house all of Clayton’s deal data.

n

UBS Investment Bank – New York City Oct 2002 – Aug 2004

Collateral Analyst – Mortgage-Backed Securities (Contract Position)

Responsible for the analysis of mortgage data for the UBS Mortgage Trading Desk. Analyzed data for whole

n

loans and non-performing loans acquired through bulk and conduit purchases to identify and repair

inconsistent or missing data prior to settlement and securitization.

Responsible for the data needs of mortgage traders and structuring analysts. Used CAS, SQL and Excel to

n

support the securitization process.

Praxinet, Inc. – Ridgefield, CT Apr 1999 – Jan 2002

Senior Project Manager

Recruited by a startup-consulting firm to lead high-profile projects, including:

Tishman Speyer Properties, New York City – Provided research on emerging technologies and cost/benefit

n

analyses of competing products to the CIO.

Verizon Communications, Tampa, FL – Developed and implemented an OLAP budgeting application for

n

Verizon’s Finance and IT departments. Ran joint application design (JAD) sessions to gather customer

requirements. Designed the database and developed the budget collection screens and end user reports.

GE Capital Real Estate, Stamford, CT – Assisted the CTO with planning technology initiatives, providing

n

research on emerging technologies and comparative analyses of vendors. Managed a team of eight

consultants in the design, development and implementation of a GIS-based market research tool to support

the originations of commercial mortgages.

Rogers AT&T, Toronto, ON – Brought in to turn around a project in trouble. Managed a team of four

n

consultants to integrate Information Builders’ WebFocus reporting suite with a new billing system for the

largest cellular provider in Canada. Reassessed project scope and developed a realistic project plan that met

both the deadlines and requirements of the overall project.

Claremont Technology Group – Basking Ridge, NJ Jul 1996 – Mar 1999

Project Manager

Worked onsite to develop custom software for key clients including:

Federal Home Loan Bank of New York, Jersey City, NJ – Lead business analyst and quality assurance

n

manager on the development of a custom system to manage FHLB/NY’s residential mortgage portfolio.

AT&T MultiQuest, Basking Ridge, NJ & San Jose, CA – Managed the development of the reporting

n

component of a custom-built 900-number billing system, and provided onsite operations support.

Contact this candidate