EXECUTIVE PROFILE:

• SQL Server, Administrator and Developer/Architect
• Experienced Database Architect/ Project Lead / SQL Server expert DBA / Developer with broad industry experience.

CORE COMPETENCIES:

• Requirements Gathering, Full SDLC Management
• Numerous Data Center migrations/consolidations
• Project management of SQL Server migration projects
• DTS and SSIS Package Development
• Deployment of SQL Server 2008 R2 (clustered and non - clustered)
• Deployment of SQL Server 2008 64 bit
• Deployment of SQL Server 2005 64 bit/32 bit
• Development of Data warehouse and 800+ ETL DTS support packages
• Development of Data warehouse and 100+ SSIS ETL packages
• Deployment of Business Objects 11
• Development of SSAS (data cubes/MDX)
• Deployment of SQL Server 7, 2000, 2005, 2008, 2008r2 Clustered
• Deployment of SQL Server 7, 2000, 2005, 2008, 2008r2 Replication
• Deployment of SQL Server 7, 2000, 2005, 2008, 2008r2 Log Shipping
• Deployment of Crystal Enterprise
• Team Lead for ERP deployments
• Team Lead for SFA and CRM projects
• Technical Lead for FDA monitored projects
• Team Lead for Federal Reserve System deployment of SQL Server 2005
• Author - SQL Server Security Policies for the Federal Reserve Bank of Boston
• Design and installation of the first Municipal WAN in the State of Massachusetts
• Multiple aggressive deployments of SQL 2000 to SQL 2008r2 migrations
• Multiple SQL 2005 to SQL 2008r2 migrations
• Numerous high stakes deployment and upgrade projects

COMPETENCIES:

• Project Management
• Logical /Physical Data Modeling
• SQL Server 2005/2008, SSIS
• SQL Server Upgrades and Migration
• Visual Basic Programming
• Disaster Recovery Planning
• SQL Server Performance Tuning
• SQL Server 2000 & DTS
• Change Control
• Crystal Enterprise Deployment
• Business Objects XI Deployment
• Full Life Cycle management
• SQL Server Clustering
• SQL Server 64 bit
• SQL Server Replication
• SQL Server Capacity Planning
• SQL Server Data mart design
• SQL Server Development

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Responsibilities:

• Team charged with defining and setting standards in technology and design methods for existing products as well as future offerings.
• Team also responsible for defining and setting quality standards and best practices for ETL, Web Services, Architecture/Scalability.
• Goals set for the team include Zero Down Time SaaS and Client Hosted System Upgrades, Scalability - higher performance design and processes, aggressive reduction in Data Warehouse load and update times.

Confidential, NY

Responsibilities:

• Brought in to backfill the DBA position on the clients eBook publishing/distribution and sales project (EMS)
• Scholastic has been a traditional printed publisher of books - this project was on a fast track to shift the company from traditional publishing to electronic publishing.
• The prior DBA suddenly left the company and I was hired to jump in and take over the database design and coding for this project.
• Worked remote, interfaced with management in NYC as well as developers across the globe and the US.
• Responsible for all database design, redesign, coding related to SQL - stored procedures, tuning of prepared SQL and tuning/redesign of existing code and schema.
• This phase of the project went live the week before Confidential .
• Scholastic now runs their first ever electronic book store - leading Scholastics shift from traditional publishing to electronic publishing.

Confidential, Boston, MA

Responsibilities:

• Trouble-Shooting and debugging SQL Server procedures and ETL processes related to clients core product line.
• Daily interaction with client’s customers, QA departments, Build Managers.

Confidential, Nashua, NH

Responsibilities:

• Design and Develop a single SSIS Package which the client’s Hosting group will use to migrate old version of clients Hosted Data Warehouse to newest version of Hosted Data Warehouse.
• Confidential pushing major product upgrade from their SkillPort product version 7 to 7.1 (utilizing major Architecture changes to Data Warehouse portion of product).

Confidential, Boston, MA

Responsibilities:

• Contracted to address critical IT/SQL infrastructure issues including but not limited to, production support, development of disaster recovery and high availability.
• Hardware and systems documentation.

Confidential, Billerica, MA

SSIS Team member

Responsibilities:

• This is a short term project providing additional resources to the clients team of SSIS developers.
• The primary focus is providing ETL services to a larger CRM migration.
• Migration is from a legacy SQL Server 2005 CRM system to a new SQL Server 2008 SugarCRM system.

Confidential, NY,NY/Charlestown, MA

Database Management/Enterprise Architect/Project Management

Responsibilities:

• Managed multiple projects for client, including BPC, DR, HA for all internal applications/server.
• Systems included Great Plain, Data Warehouse and BO infrastructure, Sales Commissions System, Billing Systems and others.
• Responsibilities included, Business Requirement Gathering, Project Planning, Resource Planning and Scheduling, identification of deliverables and benchmarks.
• Existing infrastructure includes a mix of ESX VMs and Physical hardware. Some backend storage on Internal Server disks as well as older, NetApp storage.
• Initially found a mixture of Production and Non-Production systems using same hardware.
• Worked to segregate those to different servers followed by Backups to Replicating Disk (NetApp across CoLos in NYC and Boston).
• Secured new hardware and VMs at each CoLo to migrate and upgrade several production systems utilizing DR plans developed and tested.
• Documented a plan to provide HA via use of a combination of VMs and Clustered SQL Servers. BI initiatives for SQL Server 2005 Data Warehouse and BO Universes.
• Sox compliance for all SQL Server systems - company has just gone public requiring a fast track to compliance. Migration of SQL Server 2000 warehouses to SQL Server 2005 (including rewrites of DTS to SSIS ETL Packages)

Confidential, Waltham, MA

DBA/Project Management

Responsibilities:

• Managed migration projects for Client.
• Client had the need to upgrade and migrate all production database systems to High Availability Clusters.
• The infrastructure includes a mixture of Replication and Logs Shipping for purposes of sharing data.
• Systems include 5 servers to be replaced with 2 single servers and 2 clustered (active/passive) servers.
• Migration to new hardware to include fully documenting all Replication processes as well as Log Shipping.
• Current systems are SQL2005 with the new systems moving to SQL 2008 on Windows 2008 - multiple multi-TB sized databases.
• DR and HA Plans produced and tested for all new systems and processes.
• Project also required the automation of numerous tasks via use of SSIS.
• Monthly custom database extracts generated for multiple clients in excess of 10 GB each.
• Processes evaluated for performance increases and code and process changes tested and implemented as needed.

Confidential, Woburn, MA

DBA

Responsibilities:

• Client poised for tremendous growth but had serious performance issues with their SQL Server based business processes.
• Project is focused on several areas.
• First is to stabilize the current core SQL Servers and to them move on to identification of root causes for performance issues.
• Areas of analysis ranged from core Medical Coding systems through the BI infrastructure - use and design review of all ETL and Data Warehouse designs and processes.
• Business Objects environment also reviewed for efficiencies.
• Second area of focus has been the development of monitoring processes to document poorly performing code and tie back to originating application or interface. Also has included the implementation of performance tuning across numerous production systems.
• Third focus has been to define best practices for both
• Production Support of SQL Server systems as well as best practices for SQL Code review and performance testing of code. Some implementation of Load Testing also included. ETL processing included HL7 feeds.

Confidential, Waltham, MA

SSIS/Data Warehouse Developer

Responsibilities:

• Project has been to scale up and develop the next generation of the companies industry leading product.
• Product analyzes anonymous set-top box data from satellite and cable systems, adds in data obtained from other companies, including consumers' purchasing habits and locations, and updates daily via data warehouse and analytics advertising related data.
• Provides advertisers and client TV providers the ability to target their advertising over these systems.
• Development of several dozen SSIS packages - working under extremely tight deadlines
• Utilization of Partitioned tables for enhanced data loading and data archiving
• Provide database design feedback to development teams with respect to performance and scalability issues

Confidential, Westwood, MA

Database Systems Engineer/ Project Management

Responsibilities:

• Managed multiple projects for client.
• This included numerous system migrations and upgrades, data center migration for all SQL Server database systems.
• Lead DBA for 2 man DBA team supporting primarily SQL Server 2000, 2005 and 2008 systems.
• Responsible for all support issues for production systems and newly deployed OLAP/SSAS data warehouse.
• Heavily involved with several key development projects with outside business partners utilizing replicated databases pushed across internet and vpn connections.
• Have also been heavily involved with process improvement for management of all SQL Server QA management procedures.
• Developed improvements to the Life Cycle as it pertains to testing and validation of SQL Serve.
• Developed and deployed incremental improvements in Disaster Recovery and Preventive Maintenance within the current hardware and bandwidth constraints.
• Most recent project has been the migration of two geographically dispersed data centers to a new centralized data center.
• This has included the definition of hardware requirements and development of strategies and plans for minimizing application downtime given the current sets of technological and resource constraints.
• Technology includes both EMC Clarion and EMC DMX storage. Migrations of several applications from SQL 2000 to SQL 2005.
• Numerous SQL Cluster deployments and upgrades.
• Support of BI group along with additional help with SSRS report design. Key DBA resource for core engineering teams of current and new products.
• Support and development of the SSIS environment.
• Daily management of all ETL processes in Production.
• Responsible for the support of the Development and QA environments. BI Development of SSAS, MDX/Cubes.
• Establishment of a professionally run SQL DBA Group responsible for full ‘ownership’ of all SQL Server database standards and issue
• Central resource for all SQL Server development - stored procedures, functions, ETL processes etc.
• Development and implementation of SQL Server Standards - design and management
• SQL Server Analysis Services - MDX/Cube development
• Design and deployment of Disaster Recovery plans for all production database systems.
• Implementation of Performance and Reliability monitoring of all Product, QA and Development SQL Servers
• Migration plans for Data Center consolidation. Included but not limited to Server migrations, hardware relocations, development of new hardware requirements, acquisition of new hardware, server consolidations.
• Documentation and management of change control procedures for all SQL Servers
• Migration from Clarion to DMX EMC Storage
• Implementation and management of ODS and Data Warehouses
• Implementation of SQL Server 2008
• Technical support for Asian business partners in Korea and China.
• Technical support for business partners in UK and Russia
• Upgrades from SQL Server 2000 to SQL Server 2005 64 bit clusters
• Support of MSMQ Messaging layer running between Game Servers and Database Servers
• Provide 24/7 support for all production SQL Server systems

Confidential, Wilmington, MA

Database Systems Engineer

Responsibilities:

• Further efforts include the development of mission appropriate disaster recovery plans for each of Confidential hosted solutions as provided to their outside customers.
• In addition to traditional Production DBA tasks, duties included architecting new designs for a scale-out of several large OLTP systems.
• This included a combination of mirroring, replication and log shipping.
• Scalability issues addressed via combinations of Log Shipping, Replication (one way and merge), mirroring.
• Disaster Recovery plans (including but not limited to fail over server, clustering, backup planning)
• Identification of key monitoring statistics (performance monitor counters, profiler counters etc)
• Implementation of SQL Alerts for monitoring system performance.
• Database/Architectural work on production designs to meet new scale out needs for new phase of much larger clients.

Confidential, Waltham, MA

Project Manager

Responsibilities:

• Duties include identification of all deliverables, identification of internal services required from various departments, allocation of resources and staff to implement and meet the aggressive project schedule.
• Systems being migrated and tested include a Non-Clustered QA environment, a ‘beta’ environment, Development environment, Clustered Performance Testing environment, Clustered Production environment.
• Environments include direct database access from various business partners as well as multiple application servers accessing each database environment.
• Provided Subject Matter Expertise (SQL Server 2005) to development team charged with upgrading Security/Authentication layer of all Confidential ’s products.
• Provided SQL Server expertise in the development of extensive ‘stress tests’ and ‘load tests’ for all Confidential online products
• Various Performance tuning endeavors
• Worked with Microsoft Engineers to identify and address load specific bugs in the Microsoft SQL Server 2005 product. Resulted in the release of a significant ‘Denial of Service’ related patch

Confidential, Wilmington, MA

Database Architect/DBA

Responsibilities:

• Major new client signed requiring extensive scaling up and out of SQL Server 2005 environment which required considerable re-architecting of the databases involved.
• Tasked with making hardware recommendations and guiding development team towards an appropriately scaled solution required to support 1 TB database (prior systems operating in the 30 GB range).
• Performance tuning, stored procedure rewrites and establishment of design standards for system enhancement efforts.
• Responsibilities also included disaster recovery planning, index maintenance, backup and recovery, implementation of pro-active monitoring for all production SQL Servers.
• Review and document current production systems.
• Prepare Hardware Requirements documentation for new and upscaled clients
• Development of a Data Archiving solution.
• Migration of design to SQL Server 2005 from SQL 2000.
• Migration and rewrite of DTS to SSIS
• Performance management via index maintenance and performance monitoring

Confidential, Norwood, MA

ETL Subject Matter expert

Responsibilities:

• Deliverables include fully documenting all ETL (Data Junction) packages, review of all Client supplied specifications and requirements.
• Quality assessment of ETL processes
• Optimization and enhancement recommendations
• Definition of standards and best practices for future ETL processes Competencies