Summary

• Solutions-focused and seasoned professional equipped with 30 years of success consulting, planning, developing, and implementing technology to realize dramatic improvements within diverse industries. Pragmatic and dynamic leader with broad combination of experience across project management, program management, and database programming as well as systems management and optimization. Expertly analyze requirements and define needs to formulate and present comprehensive customized solutions using cutting-edge technology to achieve corporate goals, streamline processes, and elevate technology standards. Efficiently identify and resolve difficult technical issues. Areas of excellence:
• Everything Microsoft: SQL Admin / Developer / Architect : SSIS / ETL / DTS Admin / Developer /
• Architect / SSIS Packages : SSRS Admin / Developer / Architect : SSAS Admin / Developer / Architect :
• TFS Admin: SharePoint Admin: SharePoint Developer Office Developer VB Script Developer .NET Developer C Developer CLR Developer. I've worked many years across all of these fields in operations as well. Technology Architecture Infrastructure Design Communications Needs Analysis Client Relations
• Procedure Development Process Improvement IT Strategy Special Projects Requirement Identification
• Project Management Strategic Planning Technical Support Disaster Recovery Report Generation
• Network Management Team Leadership/Motivation Database Development Database Management
• Database Optimization Database Architecture Mirroring Indexes Triggers Log shipping
• Production databases Database servers Instances Production servers Database backup PODS
• PipeLine Open Data Source Maintenance Plans Alerts Database Maintenance Schemas Replication
• Enterprise Database Environments Security Server Logins Database Logins Active Directory Server
• Logins Production Environment Staging Environment

Experience

Database Administrator

Confidential

Saving the world, one database at a time. This time more BI work it looks like, wrote an archiving SSIS package for monthly and quarterly archiving of tables, and was done.

Senior Database Administrator

Confidential

• At the beginning of this last year I migrated 52 databases from various platforms from 2000, 2005, 2008 R2 to a standardized 2012 Platform. All securities were changed over to a AD schema based group wise security system during the course of the move. We encountered no unexpected issues and the migration was pulled off without a hitch. 138 SSIS Packages were eliminated during the course of this as no longer being necessary, and being converted back into native sql, as the servers were no longer dis-separate platforms on different servers. I also stood up and maintained 4 servers per stack, for DEV, QA, STAGE, and PRODUCTION.
• Currently I handle all of the ETL feeds, The FTP Servers, The TFS Servers, The TFS Build Servers, And The SharePoint Server for the TFS server. I also do production support for any database related issue that comes up. Within the next few months I intend to have fully automated builds going by project for all databases in the company to all environments they are needed in.
• Wrote c assemblies for file transfers, SFTP transfers, network share mappings, usps address validations, and geocoding of addresses and the functions in the databases to use them.6 recommendations available upon request

Senior Database Architect

Confidential

• Wrote/scripted/deployed Stored Procedures and T-SQL code in support of client applications.
• Wrote/built/deployed C Assemblies for Encryption, Secure FTP, and Directory operations for SQL Server.
• Designed, wrote scripts for, and architected an upgrade of 43 databases from SQL Server 2000, 2003, 2005, and 2008 to 2012. Some issues encountered were DDL intermixed with the DML, Linked server references hard coded And named after servers , schema's owned by users no longer with the company, inconsistent naming/coding, dead code which would no longer compile due to the referenced objects not existing any longer, double hop to get 2000 Databases to 2012 through 2008 R2, inconsistent collation, and cross database chaining.
• Created 2012 Visual Studio DacPac Projects from all databases, added references, removed dead code, made buildable, and integrated with TFS source Control.

Senior database developer

Confidential

• PIPER TO PODS data migration.
• Established Enterprise SSIS, SSRS Standards.
• Perform Route Load Express Imports. Support for RLE to business. Facility Manager Support and configuration.
• PODS PipeLine Open Data Source 4.02 Database And GIS Support and Development. 3 recommendations available upon request

Technical Lead

Confidential

Technical Lead/Database Administrator

• Facilitated testing and verification of systems connectivity of components SQL Server, Reporting Services, Epiphany, and numerous data warehouses prior to migration between data centers. Developed and implemented solutions to elevate poorly-performing SQL Server systems to acceptable levels performed analysis of systems and created project plans based on evaluation.
• Expanded data availability for input into warehouse via establishing Q A Analytics Data Warehouse,automating database backup and restore throughout multiple servers.
• Automated data compares between process runs of applications by creating stored procedures procedurespermitted field-by-field comparison of tables with results logged to table for reference.
• Enhanced company's development cycle to enterprise standard through crafting document outliningmethodologies for implementing naming convention, code repository, development environment, QA environment, stage environment, and product environment.

Sr. Solutions Developer

Confidential

• Orchestrated projects with values up to 23.5M consistently delivered routine project reports, status reports, and design changes. Guided programmers, database architects, and team leads encompassing existing technologies at client sites. Executed projects within budget limitations acquired talent resources necessary for project completion. Performed needs analysis on site, conceptualized and established project specifications, and designed and presented end solution in alignment with client objectives.
• Developed SSIS framework currently licensed to Microsoft, Accenture, and 16 international clients.
• Conducted auditing and tracking of package phases for efficient troubleshooting and maintenance.
• Framework decreased build time of new packages utilizing prebuilt packages with cut-and-paste design. Improved total skill levels within parent company and client organizations through mentorship of lower-level programmers and database administrators.
• 1 recommendation available upon request

Senior Solutions Architect Performance Optimizations

Confidential

• Worked in conjunction with Sr. Architect from Microsoft to Design project for Consolidating the Product
• Catalog of many sub groups within Verizon including eSales, PCAT, .Net, Coffee, etc
• Rewrote Stored Procedures to optimize performance as design of tables changed to accommodate the different groups using the consolidated product catalog.
• Wrapped Code for Stored Procedures within custom functions to be universally available to different teams. Wrote Replication Stored Procedures to implement and tear down replication for different environments as needed so that it was not a manual process every time.
• Designed Tables, reviewed business models, and translated data from ORACLE systems into SQL Server. Wrote DTS packages, using custom error handling and udf's to implement common imports to different environments.
• Wrote Job Specs for hiring of Technical writer and Quality Assurance personnel
• Created Erwin Diagrams of previous databases being combined, and current database being designed and implemented, and provided to end users different consumer groups within Verizon.
• Created Visio models of process flows for the design, implementation, and operation of new consolidated models.

Senior SQL Server Architect

Confidential

• Documented entire system hardware, software, down to system level calls within the database. Wrote best practices documents. Created replication topology diagrams, stored procedure usage examples, Erwin diagrams of resulting databases, and compiled help files providing interlinked references for objects in system.
• Identified and provided solutions for issues within the system, took leadership roles in implementing the solution, and reported the results for areas including San, Infrastructure, Network, Active Directory, Implementation, Sql Server, Clustering, DTS, Load Balancing, and many other areas.
• On call 24-7-356 to design, implement, and receive alerts on issues before they became critical in order to insure system uptime. Worked with Microsoft, Vericenter, and others to provide technical expertise in design, implementation, operations, and recovery.
• Assisted VP in building an Operations Group that grew to 9 persons.
• Flew to Hosting Centers to personally lead environment build outs from the rack level up, installing servers, building out databases, application servers, websites, applets, for resolution of clustering issues, and, infrequently, as check ups and meetings with consultants from Microsoft and Vericenter.
• Evolved Databases and Database systems into a Scalable Solution which will continue to evolve for years to come.
• Worked with Warehouse Team to implement Scalability in their systems, providing an integrated system, giving them a common interface, and resolving several design issues.
• Ran regular training sessions within the company for all other DBA's, Developers, and Operations personnel providing assistance with any and all issues encountered.

Senior Enterprise Solutions Developer

Confidential

• Designed, wrote, and implemented a process to scale out the current database for a proposed 30Xperformance increase to accommodate the increased load resultant of a strike. This was successful, with no unplanned downtime.
• Designed Metadata based replication take down and rebuild system. This was a method of setting thepublications and articles in a list, and Sql Server would build out the subscriptions based on this list, using custom stored procs I wrote. The end result was between 3-7 publications per server, using Transactional, Bi-Directional Transactional, and Snapshot methodologies. Each publication contained between 7-300 articles, some vertically filtered, which had to be rebuilt with every build several times a week . For a DBA to do this manually would take days, not to mention the possible errors with so many moving parts. These procs written could take down all publications and subscriptions, and rebuild them in roughly an hour, with a complete re-sync.
• Developed and implemented process and procedure to support builds under a replicated topology, andtrained in-house DBA's on its use.
• Wrote complete documentation on system, including best practices documents, replication topologydiagrams, stored procedure usage examples, Erwin diagrams of resulting databases, etc.
• Worked hand in hand with multiple internal groups to determine usage, changes required, performance tuning needs, etc, of database being scaled up. Gathered requirements, defined needed changes, and assisted in the implementation.

Senior SQL Server Developer / Admin / Architect

Confidential

• Wrote Stored Procedures, Triggers, Backup strategies, Maint. Jobs. Full Life Cycle Development of Importsystem to integrate SQL Server 7.0 databases with AS/400 and Fixed Width Text files into a Sql Server 2000 Data Warehouse.
• Performed Project Management for Data Warehouse Project.
• Performed Hardware Diagnostics and System Optimizations of Sql Server Servers to create systemstandards for IT department.
• Created standards for documentation, and Documented Database and processes. Documents created coveredLogical, Physical, and Entity model of Database. Data Definition Library, and Process and Data Flow models were done in Visio 2002. Compiled Help File was created for the database as well, showing dependencies and inter-dependencies of processes within SQL.
• Set up auditing and tracking system for bug resolution of issues concerning Data Warehouse or FTP forincoming data. Provided Web and Email access to this system for IT Dept and clients.
• Performed requirements gathering to build project plan, interacting with IT, Finance, Marketing, andRemote businesses that provide data feeds, along with client's who will use the data.
• Addressed issues with EBCDIC to ASCII conversions between the AS/400 systems and end servers bywriting custom conversion jobs to handle Un-packing digitally signed packed decimals.

Senior SQL Server Database Administrator, Enterprise Level

Confidential

• Wrote Stored Procedures, Triggers, Backup strategies, Maint. Jobs, VB Applications, Access 97 and 2000applications in support of Electronic Court Document Filings System.
• Worked with Systems Engineer to demonstrate Disaster Recovery techniques to provide accuracy andreliability to the point of guaranteed data recovery in case of failure.
• Worked with Developers and system engineers to move system to remote location in Boston, Ma. AndBellevue, WA. From current live production site in Dallas, with minimum down time Everything completed successfully within Maint. Window with no unscheduled system downtime.
• Worked with developers to develop strategies to provide backup and recovery techniques involving cuttingedge EMC and BCV technology in conjunction with more traditional Log shipping and dump routines.
• Pointed out design flaws and researched solutions to correct said flaws. Designed Active X scripts to workwithin SQL Queries for the purpose of automating Maint functions on servers.
• Did performance tuning to stored procs and queries to facilitate 43 to 1090 increase in performance. Designed OLAP Cubes for billing processes and data warehousing. Reworked indexes on databases to facilitate 5 to 73 performance gain.
• Documented Program flow of main filing application for training and support personnel from Web frontend through exact fields and tables touched and requirements for each step .
• Mentored Jr. and mid level DBA's and development people.
• Responsible for Clustered Systems in all capacities build, maintain, upgrade, etc. 1 recommendation available upon request

Senior SQL-Server DBA

Confidential

• SR DBA in charge of design and implementation of 7 SQL Servers in three environments 21 in total tosupport GTE's DSL service and Online Ordering Availability.
• Worked hand in hand with front end developers to design and support ASP based Web application withsome DHTML components and some Java limited .
• Managed DLCI and Circuit information in database and wrote ALL stored Procs, triggers, migration buildsfor assignment and implementation of circuits.
• Worked with 4 and 8 processor transaction based parallelism enabled databases. Provided 24x7 on sitesupport and put in 31 hour days on occasion as needed to provide 99.3 uptime to application.
• Spotted engineering design flaws and provided solutions to better enable load balancing not only withindatabases but for Web servers as well.

Created system documentation of design for training and support, and maintained documentation as needed. Implemented performance tuning changes to queries and Server configurations to facilitate a 170 to 530 system performance gain in different areas of the application.

Consultant for Customer Support / DBA / Developer

Confidential

• Migrated an existing Access 97, AS/400 customer support database application to Visual Basic 6.0, CrystalReports, and SQL-Server 7.0. Used third party AS/400 DB2 ODBC drivers and Supported AS/400 database and on-going interface of production system with it.
• Designed, Tested, and implemented Software for Tax calculations, integrated Billing, Auditing, Marketing,and Reporting of Commercial Rental Tax Payment Processes.
• Mentored and managed group of four DBA's, seven ASP / VB programmers and completed all projects ontime, with no production errors.
• Researched and communicated customers needs into project specification documents, modeled same, andprogressed project through three environments to production, again within the timeline specified with no appreciable errors in final production system.

Consultant for Finance Department / Developer

Confidential

• Upgraded existing Finance Reporting Application in Visual Basic 5.0 / Access 2.0 / Oracle 7.2 Client/ServerApplication to Access 97 / Oracle 8.0 in order to address and correct Year 2000 problems. Upgrade issues addressed included upgrade of ODBC drivers, SQL-Net 2.3, Oracle Client Side software, Access 32-bit API calls, etc to switch from 16-bit application to 32-bit.
• Corrected several network issues related to the routing of IP traffic to and from the remote servers.
• Check requisitions - full life cycle development of an automated check requisition system in Visual Basic
• 5.0 that replaced manual process and ran from a SQL 6.5 database backend.
• Email program - full life cycle development of email program in Outlook 97, Visual Basic 5.0, and Access 97. Program captured through SQL into SQL Server 6.5 database, then exported network traffic activity to more user friendly Access 97, then into email attachments and routed to the appropriate individuals using outlook object model as medium of transport, then reported activity performed through same medium.

SQL Server DBA / Project Manager

Confidential

• Responsible for database administration of development and production databases in a single 6.5SQL-Server.
• Built and installed Windows NT server/ SQL -Server including loading software, patches, built tables,indexes, stored procedures, and triggers to support migration of information from Access 97 database.
• Suggested and implemented schema changes to facilitate better reporting and data processing using ERWINand Data Architect.
• Performed standard database administration tasks such as automating imports exports, Back-ups, 24 X 7Emergency support, schema design, optimization, SQL programming as support to End-Users, Security Management, etc.
• Migrated Access 97 database to SQL-Server 6.5 to take advantage of RDO, ADO, DAO, and ODBCconnections to a higher end database through different applications which interacted with databases from different clients.
• Rewrote Access 97 front-end for user functionality including ASP web interfaces and Web based mailcapability through Access to Outlook object models and API calls.
• Wrote stored procedures and triggers for the SQL Sever and the code in Visual Basic 5.0 for accessingdatabase and propagating data to the necessary tables.
• Designed, Tested, Implemented, and Supported STAMPS project to facilitate MCI / WORLDCOM mergerand integrate different user / customer databases involved, overcoming schema obstacles, reporting deficiencies, and changing requirements.
• Responsible for interacting with vendors, customers, peers, end uses on requirement gathering, technicalsupport, interface issues, and other help as required.
• Mentored Jr and Mid level DBA's and ASP / VB Developers.