Manager Sql Server 200, 2005, 2008, 20012 T-SQL developer

Robert S. Petrarca, Jr.

** ******** *****, ********, ** 02816 H: 401-***-**** C: (401) 256-

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

Career Overview

An articulate, client-focused and results oriented developer with

proven success providing timely and comprehensive technical software

solutions. Self-motivated and innovative problem solver possessing

extensive knowledge across a wide range of technical disciplines with

work experience in large companies, small businesses and government.

Qualifications

Microsoft T-SQL Development N-tier application

development

Relational DB design and architecture Source code and

system documentation

Customization & integration of COTS products Scheduled tasks and

jobs with VBScript

SQL Database administration Microsoft SQL DTS Package

Development

Development exposure to SSIS, SSAS and SSRS Technical lead and

project management

Technical Skills

MS SQL Server 2000-2012, MS Visual Studio 2008-2012, VB.NET, C#.NET,

MS Office Suite 2003-2012, MS Team Foundation Server 2012, ASPX,

classic ASP, Windows, FTP, SharePoint 2012

Work Experience

2013 - Present Turino Group Software, Providence, RI Custom Software (MS

SQL2012, TFS, VS2012)

Senior Database Developer

. Coded for, maintained and administered over 70 databases comprising

trial surveys for 2 Microsoft Windows 8 retail sites as part of a

Microsoft Preferred Vendor company.

. Architected and developed databases to support custom software

designed for the RI Department of Transportation and internal

company projects

. Led a team of 2 developers, coordinating project assignments

deadlines and work schedules.

2013 (Feb-Sep) Saylent Technologies, Franklin, MA Banking technology

software

Software Engineer

. Develop enhancements for and support the Card360 software product

(SQL, C#.Net, TFS, javascript)

2011 - 2013 Admirals Bank, Providence, RI (5/13/2011 - 2/18/2013) Banking &

lending services

Senior Applications Developer

. Successfully integrated BMC Track-It! applications and services

into the IT workflow improving response time to customer requests

and service outages.

. Technical lead for the development team that deployed a new SQL

based loan management and reporting application to administer the

company's loan portfolio utilizing unique amortization rules not

found in COTS products. Coordinated meetings and testing schedules

to keep project tasks on time.

. Developed, maintained and managed security for sub sites off the

company's first SharePoint-extranet.

. Improved SQL Server administration DR efficiency utilizing SQL

Agent, DBMail and T-SQL to automate backup jobs, file transfers and

other processes.

2008 - 2011 Bank Rhode Island, Lincoln, RI (9/15/2008 - 5/10/2011) Personal

and small business banking

Senior Applications Developer

. Set new standards for application development by separating

backend, business intelligence and presentation layers into more

manageable and supportable code

. Transformed a multiple Access DB & HTML intranet application into a

comprehensive ASPX/SQL 2008 application and information content

platform.

. Developed project tracking software to support all technical

project development across the company.

Work Experience (continued)

2008 Citizens Bank, Smithfield, RI (7/16/2008 - 8/15/2008) HR Training

Services

SQL database developer

. Wrote T-SQL code and DTS packages to automate Excel based new hire

training reports.

. Mentored full-time sponsor on T-SQL code development, best

practices and techniques.

2000 - 2008 Abacus Management Technologies, Cranston RI, (2000-2008) Health

Benefits Consulting

Senior Software Engineer

. Technical lead for the development and fielding of the Enrollment

Advantage system - the company's first successful web based,

commercial product - in partnership with Blue Cross Blue Shield RI.

. Managed the team that maintained and upgraded the Enrollment

Advantage system for the duration of its 3-year lifecycle.

. Architected and deployed a new real-time call center support system

(C#, ASPX) to replace an older, customized vendor based system.

. Designed and built the data portion of the company's Quality Report

product for communicating health benefit analysis to customers.

. Maintained excellent customer relationships by providing continuous

input and feedback through technical specification, data models and

project analysis for all company initiatives.

1994-1999 One Beacon Insurance (formerly CU Insurance), Foxboro, MA

Personal and commercial insurance

Lead Software Developer (1996-1999)

. Designing and implementing the technical architecture for the

company's first and most sophisticated web-based policy processing

system.

. Project manager for the business merger and expansion of the

agricultural insurance division.

Software Developer (1994-1996)

. Developed one of the first and most successful document imaging

systems in the company. Cited in a company newsletter for

continuous company success and improvement.

Additional Experience

1989-2009 US Army Signal Officer, US Army & Rhode Island National Guard

2005 - 2006 Deployed with the 43d Military Police Brigade to Baghdad

Iraq.

. Managed 6 soldiers that installed and operated voice and data

communication systems for 6 installations supporting 3500 troops

over an 800KM area.

. Project manager for communications systems being installed in all

government facilities for our unit

2002-2003 Deployed with the 43d Military Police Brigade to Guantanamo

Bay Cuba,:

. Managed 12 soldiers/sailors/airmen that installed and operated

voice and data communication systems in support of the Guantanamo

Bay Navy Base.

. Project manager for communications systems installation across the

base.

1991-1993 United States Army FT Drum, NY

Automation Acquisition Officer

. Responsible for the requisitioning, purchasing and distribution of

$10 Million annually in automation hardware and software across the

10th Mountain Division.

1991-1992 United States Army Camp Greaves, Republic of Korea

Battalion Communications Officer

. Managed 12 soldiers responsible for the installing operating and

maintaining of all voice and data systems supporting 1000 soldiers

on 2 installations on the Korean demilitarized zone.

Education and Training

2013 Microsoft Exam 70-461: Querying Microsoft SQL Server 2012

2008 Bryant University 2-day project management corporate seminar

2004 MS SQL Server 2008 Database programming & administration courses

1998-2002 6 Master's Courses, Bridgewater State College

1990 BS Computer Science; University of Rhode Island

Contact this candidate