Sql Server Management

D aniel J. White

* ****** *****

Clayton, NJ ****2

Email: ******.*.*****@*******.***

Home: 856-***-**** Cell: 856-***-****

Summary

Information Technology professional with over 20 years of professional experience, which includes 10+ years of

leadership. A strategic thinker with a specific focus in leading software development, support and technical

operations teams (permanent and contractors, both on-shore and off-shore), improving operational efficiencies to

deliver on business goals.

Accomplishment H ighlights

• Provided vision, strategy, and plan to refurbish and modernize the information system infrastructure,

p roviding a foundation to introduce a new Services Oriented Architecture (SOA), standardizing

technologies to a Microsoft Platform, providing business the f lexibility and agility needed to make

changes in business decisions without the typical long development efforts associated with revamping

Legacy systems to support change. Enabled an AGILE approach to the SDLC engaging a ‘shoulder to

shoulder’ work relationship with business partners. Reduced overall cost for the environment and

resources as well as reducing and stabilizing overall IT software development operational expenses.

P rovided business agility to an organization hampered by, and long-rooted in, t raditional application

a rchitecture.

• Directed an Extract, Transfer and Load (ETL) effort to migrate all of the organizations key data from

a Legacy Oracle DB environment to a new SQL Server Enterprise database to support the new SOA

A rchitecture.

• Directed a multi-year $2 Million offshore IT Managed Services Engagement. Defined standard

operating procedures, service level agreements and communication protocols. Resulted in significant

i mprovements in system stability and adherence to project schedules.

• Defined and implemented a 2 year roadmap. The roadmap formed the bases for annual operating

p lans/budgets and guided the management team to strategically align objectives, structure teams and

define t raining/development plans to support long-term goals.

• Reengineered the Software Development Methodology enabling a geographically distributed team to

deliver software that aligns with customer expectations. Resulting methodology ensured consistency

and repeatability of procedures and responsibilities across all aspects of the SDLC; planning,

analysis, design, development, integration, testing, implementation, post implementation / “burn-in”

and support.

• Implemented measureable Quality Controls to ascertain client departments overall satisfaction with

I T. Resulted in continued increase of client department satisfaction score over a two year period.

• Led the effort to define and implement the organizations first IT Service Level Agreements,

measuring the production support teams’ performance toward meeting the defined commitments and

establishing improvement plans in areas of deficiency.

• Int roduced and championed project management concepts to the organization for the entire Software

Development Lifecycle for all IT related projects, including a project work stream for efforts high in

complexity, risk, and duration that require a more r igorous planning process as well as a work stream

for sustained engineering efforts, low in complexity, r isk and duration.

P rofessional Experience

American Board of I n te rnal Medicine May, 2008 – P resent

D i rector, I T Systems Development and Support

• Department head responsible for IT Project Management, Technical Architecture, Software Engineering,

Quality Assurance and Application Support functions.

• Established a highly efficient and responsive software development team, including developers, QA

testers, DBA’s and database developers. Strategically building a team from 8 FTE developers and a DBA

to a staff of 17 FTE and 40+ off-shore resources with a development budget over $6 Million. This increase

i n resources is in line with the overall growth of the organization and provides the appropriate resource

m ix to meet the current project demand, based on the organizations strategic initiatives, within the client

departments.

• Developed the enterprise-wide systems and technology strategy, as well as managing applications

development and a portion of systems operations.

• Conceived the IT vision and strategy to modernize the company’s technology infrastructure via a new

Services Oriented Architecture (SOA), establishing standards, governance policies and procedures and

methodologies for IT and business operations. This new architecture is a Microsoft f lavor with a mix of

web site, control and service development utilizing a Layer 7 XML Gateway, .Net, C#, ASP.Net, AJAX,

SiteCore Content Management System (CMS) (also known as an Enterprise Content Management (ECM)

solution), BizTalk, Entity Framework and SQL Server as its primary technology base.

• Directed an Extract, Transfer and Load (ETL) effort to migrate all of the organizations key data from a

Legacy Oracle DB environment to a new SQL Server Enterprise database to support the new SOA

A rchitecture.

• Experience leading support efforts improving efficiency via the use of IT I L service management

methodology and concepts.

• Managed and enhanced a Legacy environment supporting the current physician portal utilizing

technologies like .Net, C#, VB.Net, ASP.Net, Classic ASP with some Delphi, C++ and Oracle forms

applications all interacting with a series of Oracle 10/11 databases.

• Established architect teams to share best practices, explore synergies and portfolio rationalization

strategies.

• Consolidated all decentralized ABIM software within the IT department, providing the ability to apply

common standards, measures and SDLC processes to all requested development efforts.

• Revamped Project Management and Planning processes resulting in defined priorities and ability to

accurately allocate resources.

• Sponsored and implemented numerous strategic Business and IT development initiatives, creating a

robust portfolio of web-based systems to support critical business activities.

• Built and maintained an IT Roadmap for the delivery of planned initiatives supporting business needs

• Pioneered the Company’s “off-shore” operations in Hyderabad, India. Providing an efficient model for

expanding IT resources around temporary organizational project initiatives and aiding in the facilitation

of off hour support.

• Developed, implemented and championed the organizations first project management processes and

methodologies (Waterfall and Agile; as well as a Hybrid of both) for IT related projects across all client

departments.

• Revamped production support processes and recruited new leadership for managing the day to day

p roduction support activity resulting in improved service responses.

• Deployed key technologies with major workflow changes to provide immediate cost reductions while

simultaneously improving service quality and productivity.

• Defined, implemented and managed IT efforts to the organizations first IT Service Level Agreements.

• Championed software quality, process improvement programs, including selection and implementation of

SDLC, and automated software testing.

• Aided in process re-engineering efforts with client departments.

• Built and fostered technical partnerships with ABIM sister boards, societies, and vendors enabling the

sharing of knowledge and systems to help reduce design time and operating costs.

• Managed IT software development budget of $6MM while meeting or exceeding operating goals.

• Advised Executive Management on IT investments and ensure alignment of Business and IT strategies.

• Manage vendor contracts and contract relations.

Comcast May, 2004 – May, 2008

Team Lead and operationa l manager of Retai l and Residenti a l Systems

• Daily manage the workload for four application developers and numerous consultants for all project

deliverables assigned to the Retail and Residential Engineering team.

• Integral and key manager and hands on lead developer for a Fortune 500 company.

• Met daily with executive sponsorship, division heads and peers within other divisions for I.T. support and

requirements gathering and status reporting.

• Routinely provide production support for all Comcast retail applications during normal work hours as

well as off hour support.

• Typically lead in defining, planning and implementing new and sustained engineering initiatives for the

Systems Engineering team.

• Regularly provide t raining on the use of the Retail and Residential applications to internal users and

Comcast partners.

• Lead in the design, architecture and development of the Order Management System on a new corporate

w ide BEA platform leveraging BEA’s Aqualogic Service Bus, Aqualogic BPM, and Weblogic Portal to

support all phases of the order life cycle.

• Devised the Online Engineering team’s first standardization of development procedures by implementing

standard Patterns and Practices for all projects within the Online Engineering department.

• Developed the department’s security standard for all publicly accessible web services in line with WS

standards and regulations.

• Created and maintained functional specification and requirements documentation for all applications.

• Implemented and maintain the Change Management process for the Retail and Residential team for all

application code and documentation.

• Subject matter expert and primary application owner of over 35 applications implemented and supported

by the Retail and Residential Engineering team.

• Primary I.T. liaison to all company partners and affiliates to provide development support and guidance

for all publicly accessible applications.

• Designed, developed, implemented and maintained many mission critical, highly visible, systems and

reports for both internal and external users or customers. These applications were web based

applications, web user controls and web services written in C#, ASP.Net, VB.Net, Classic ASP, HTML, VB

Script, SQL Server Stored Procedures within a backend XML messaging system interacting with a mix of

SQL Server and Oracle databases.

• Created and developed a report monitor for an easy to view dashboard of all ftp’d reports for over 10

d ifferent Comcast Affiliates. This monitor was writ ten in VB.Net and t ransfers encrypted activity

reports, via .Net’s TCP protocol, and verifies the placement of those files on the affiliates designated

servers.

• On call for Tier V support and maintenance of all online engineering applications - available 24/7.

TotalTech Consultants, L.L.C. Janua ry, 2002 – Janua ry

2005

Pa rtner, D i rector of P roduct Development

• Extensive "Pre-sales" experience by researching the business practices and meeting with the perspective

client or current client, defining any known issues, defining the end-user group, perform requirements-

gathering with the users and then architect and design the best solution for the customer provided as

p roposals or proof of concepts.

• Extensive "Post-sales" experience through installing and implementing, t raining and follow-up

maintenance of proposed solutions to customers providing in-depth technical support and t raining as

needed.

• Meets with clients on a regular basis to perform requirements gathering insuring that products are

delivered to the clients specifications.

• Designed many custom applications utilizing .Net, C#, VB.Net, and ASP.Net utilizing MS Access and SQL

Server databases.

• Architects scalable database designs for clients and perspective clients allowing for future company

g rowth and off site data backup.

• Provided desktop and network support for clients and perspective clients solving issues ranging from

connectivity to print sharing.

Flight Explorer Ma rch, 2001 – May,

2004

Senior Programmer/Analyst

• Managed the work f low of 3 direct reports as well as numerous consultants and provided daily status

updates to the executive management.

• Key developer responsible for design, development, implementation and maintenance of the company’s

p rimary software solution. This application was built as both a web based application and client

application written in C#, ASP.Net, VB.Net, Classic ASP, HTML, VB Script, SQL Server Stored

P rocedures within a backend XML messaging system interacting with a mix of SQL Server and Oracle

databases.

Keystone Me rcy Health Plan September, 2000 – Ma rch,

2001

P rogrammer/Analyst

Chubb & Son I nsurance M ay, 2000-

September, 2000

P rogrammer - Personnel Resource Pool (PRP)

I B M Global Services 1998-

2000

I/ T Special ist - P rudentia l Hea lth Ca re (P HC) Account

County of Cumberland 1997 -

1998

PC Technician/Network Engineer

U nited States Navy 1992 - 1996

Yeoman, Petty Officer Thi rd Class

Professional Associations and Affiliations

• Health Information and Management Systems Society (HIMSS), Member

• MedBiquitous Consortium Technical Steering Committee, Member

• Healthcare Information Technology Standards Panel

Technical Skills

• P rogramming Languages: SOA, BizTalk, .Net 2010, .Net 2005, .Net 2003, C#, VB.NET, Visual Basic

6.0, Visual Interdev, Macromedia Flash MX, Swish 2.0, Java, Aqualogic BPM, BEA Workshop, Aqualogic

Service Bus, Weblogic Portal, Visual C++, Crystal Reports, SQL Server, MS Access, Oracle Client, SQL,

T-SQL, API, ODBC, ADO, ASP, HTML, MS FrontPage 98, NetObjects Fusion 4.0, C++, Pick Basic, DB2,

I MS, MVS COBOL I I, SAS, MicroFocus Mainframe Express, JCL, TSO, ISPF, Fileaid, Expediter, Abend

A ide.

• Databases: SQL Server, Oracle, MS Access, RDBMS, ADO.Net, ODBC, ADO, DB2, SQL, Dbase 2.0/5.0,

Lotus Notes, Universe.

• Software Applications: M KS ALS, MS Visual Studio 2003/2005/2010, MS SQL Reporting Services,

MS Visual Source Safe 6 (VSS), MS Office Suite (including expert knowledge of MS Visio), MS Project,

I nternet Information Services (IIS), Seagate Crystal Reports, MS Visual Interdev, ForeFront HTML

Help, MS Office Suite, Lotus Smart Suite, Macromedia DreamWeaver, Macromedia Fireworks, Adobe

Photoshop, etc...

• Operating Systems: W in95/98/2000/XP/2003/2008, Win95 NT4.0, Unix, NetWare 3.x/4.x, I MS, Zeke,

M VS/VS (TSO/ISPF), DOS, Unix, BEA Platform.

• Ha rdware: I BM PC and compatibles, various network servers.

Education

Cumberland County College, Vineland, NJ

• Computer Information Systems, A.A.S. Degree

Related T raining

Management/Leadership T raining:

• ITI L Foundations; Dale Carnegie Program, Team Leadership Concepts; Work Flow

M anagement; Business Communication for Managers; Stress and Time Management

Development T raining:

• WinDev Conference – Boston (Training in .net framework, Visual Basic.Net, ASP.Net, C#,

etc…), BizTalk 2010, Visual Basic 5.0/6.0, MS Access, Java, SQL, DB2, Dbase 2.0/3.0, COBOL I I,

Zeke, I MS, DB2, SAS, HTML, C++, Pan Valet, ChangeMan - actively pursuing a MCSD

Certification.

M i lita ry courses and t raining:

• LAN Management, Dbase 3.0, MS Windows, MS Suite, MS Dos 6.2, Corel Draw, Harvard

G raphics and Typing.

• Total Quality Management, Yeoman "A" School, Naval Leader Development Program, Equal

Opportunity, Sexual Harassment, Drug and Alcohol Prevention, Naval Rights and

Responsibilities, Classified Material Control, Counter Intelligence Awareness, Suicide

Awareness, Basic Seamanship and First Aid.

Personal

• Earned the Navy Commendation Medal, Good Conduct Medal, National Defense Medal, Meritorious Unit

Commendation Medal and numerous Letters of Commendation and Appreciation during military career.

• Selected as Sailor of the Quarter and runner up for Sailor of the year at last command.

• Maintained a high-level security clearance of Secret for full length of naval career.

Contact this candidate