Engineer Sql Server

ALAN W. MCCLANAGHAN

401-***-**** • ****@*************.***

O BJE CTIVE

Extremely talented, driven and highly technical individual with a proven record of accomplishment in

leading the development and delivery of global IT products. Solid leadership and communication skills;

capable of building, motivating and guiding top-performing development teams under intense delivery

schedules. A highly visible history of engineering excellence accompanied with an undying passion for

technology and problem solving. Utilizing my past experience, am interested in another challenging role:

solving problems, envisioning future solutions and technologies while motivating/inspiring team

members towards common goals.

T ECHNICAL S KILLS

Programming/Scripting Languages: .NET (C#/VB), C/C++, Java (J2EE), JavaScript (AJAX), PHP, Perl,

Ruby, Python, SQL

Markup Languages: XML (XHTML, RSS, ATOM), XSL(T), HTML, XUL, XAML

Transport/App Layer(s): (TCP/IP, UDP), HTTP (1.x), SOAP, SMTP, FTP, POP, IMAP, RPC

Operating Systems: Windows (2000/2003/2008 Server, 2000 Pro, XP, Vista),

VMWare/Virtual Server, Numerous Linux/Unix distributions

Web/Application Servers: IIS (5.0/6.0/7.0), Apache (1.x/2.x), JBoss, Tomcat, Exchange

Database/ Object Systems: SQL Server, Oracle (9i, 10G), Cache, MySQL 4.0-5.0, Postgres, SQLite

Source Control Systems: SourceSafe, Rational ClearCase, CVS, SubVersion

SCR Management Systems: Rational ClearQuest, Bugzilla, JIRA

Development Tools (IDE): VS.NET 2005/2008 Team Suite, Eclipse, NetBeans, Zend Studio, vi

Automated Testing Tools: NUnit, MBUnit, JUnit, PhpUnit

Build Tools: Installshield, NSIS, Ant

Development Methodologies: Extreme Programming, Peer Programming, Test Driven Development

Specification Management System: Rational RequisitePro (UML), Media Wiki

Certifications: Richard Hale Shaw C# Boot Camp

P ROFESSIONAL E XPERIENCE

Director – Software Development / Data Center Operations, 9/2007 – 10/2008

Aircuity Inc., Green Technologies Software/Services, 30 Employees

Reporting directly to the CTO; maintain, design, drive and manage the companies IT operations and

software/solutions engineering and roll out procedures. Completely re-architected the companies non

distributed and un-scalable architecture. Guided engineering teams to embrace and apply new

technologies and engineering practices, architectures (service based model, N-tier), and procedures (Test

driven development, build management, SCR management, Media Wiki, Virtual Server technologies)

while developing a new suite of products. Designed and drove the development of the existing data

center, implementing a robust failover and disaster recovery procedure. Reduced IT expenditure by

utilizing Virtual Server technology thus significantly reducing the IT and data center operating costs.

Worked with several venture capital firms and successfully secured an additional five million in funding.

• Completely re-architected pre-existing data center and software architecture to an N-tier

architecture allowing for seamless integration of new platforms and services.

• Leveraging virtualization technology, reduced hardware/software costs while increasing load

testing, development and failover effectiveness and efficiency.

• Working with CEO/CTO; review solution requirements, update specifications, create engineering

task lists.

• Identified, coordinated and carried out complete move of the Data Center to an off-site facility

(Co-Lo), ensuring availability of redundant systems and 24/7 monitoring.

• Turned pre-existing non-scalable system into a truly scalable system requiring just additional

hardware and existing software releases to meet increasing customer demands.

• Trained and assisted engineering team members in learning/embracing new technologies (LAMP

& .NET), architectures (N-tier, Service based), procedures (Unit testing, Peer code reviews,

Wiki).

• Identified “what’s next” regarding technology and solutions.

Director - Generation 3 Global Product Development, 2006 – 7/2007

AGFA Healthcare Formally Heartlab Inc., Global Medical Software, 13K Employees

Operating directly below the VP of Engineering; develop, execute and manage the design,

implementation and delivery of AGFA Healthcare’s next generation of global cardiovascular products.

Manage several engineering teams responsible for HeartStation, Physicians Portal and other global back

office products. Utilizing proven cutting edge technology the G3 group is guiding AGFA into the future

of healthcare IT.

• Oversee engineering architectural/design meetings to provide direction for legacy systems (ASP

3.0, IIS, Oracle, ODBC, C++/MFC) as well as our more recent .NET (Web Services, .NET

2.0/3.0, SQL Server, IIS, Smart Client, C#) based solutions.

• Created load balancing/testing (file system (WFS/DFS), database, web server (IIS)) procedures

for the integration group to aide in identifying system specifications/limitations.

• Working with product management; review solution requirements, update specifications, create

engineering task lists.

• Moderate engineering team code reviews (C#, C++, Java, JavaScript); identify potential

performance/reliability issues and resolution measures ensuring “better” OO coding practices.

• Leverage SCR system and unit testing (NUnit & VS Unit Tests) to ensure proper “bug”

identification/resolution and appropriate regression testing procedures.

• Identified the need for and developed G3Doctor, an IIS diagnostic tool that will attempt to resolve

IIS issues (Application Pool, Security, Configuration) based on rules defined within an XML file.

If the auto-resolution fails an e-mail is dispatched to a member of the support team.

• Responsible for guiding the team(s) with localization tasks, externalization of strings, appropriate

handling/implementation of resources for various language packs.

• Actively coding (C#) as a member of the engineering group; developing core components for

several products (Physicians Portal, HeartStation, State Change Server).

R&D Principal Engineer, 2004 – 2006

AGFA Healthcare Formally Heartlab Inc., Global Medical Software, 13K Employees

Motivating a team of 12 engineers; designed, architected and implemented HeartStation. Utilizing a three

tier architecture HeartStation is fully multilingual localized web based solution, allowing physicians

secure access to editable patient ECG records from any internet connected computer.

• Leading by example, instituted new development and engineering practices: Extreme

Programming, Peer Programming, and Test Driven Development.

• Delivered first ever unit test (NUnit) driven solution to the QA group, cutting our QA iterations

by more than half.

• Identified the need to consolidate system errors across the enterprise; providing the support group

with a more effective issue recognition and resolution process. The subsystem I developed uses

the Windows Event Log with a Web Service to Windows Service. This error reporting subsystem

and process has since been adopted by other products and eventually all products will use this

system.

• Designed and implemented an enterprise wide data abstraction layer using .NET web services

written in C# utilizing SQL Server. Using reflection, dynamically transform XML to objects for

consumers. This solution provides greater performance and stability across the enterprise.

• Designed and implemented application and role based security system using IIS, .NET Web

Services and AzMan (Authorization Manager) which is now utilized by our major solutions.

• The HeartStation GUI (C#) which I designed and developed has now been imitated by all the

major competitors (GE, Philips, McKesson) because of its easy of use, stability and speed.

• Provided never before seen installation process for Hospitals leveraging Microsoft’s “OneTouch”

technology as well as our own custom .msi installer.

• Received a Peer Recognition award for team building, leadership and engineering excellence.

Senior Software Engineer, 2003 – 2004

Heartlab Inc., Medical Software, 100 Employees

As a member of the reporting team, developed many components for Results Management; Heartlab’s

web based reporting system.

• Completely redesigned and rebuilt J2EE based Outbound reporting system responsible for

exporting data to external systems in various formats (PDF, XML, (X)HTML, Text, Word Doc)

via several transmission mediums (TCP/IP, FTP, HTTP, UDP).

• As early adopters of AJAX as an implementation tool; developed many components for the

Heartlab Results Management suite of products. Java, XML, XSL(T), XHTML, JavaScript, and

ASP were just some of the technologies used during this time.

• Developed the first ever .NET application for Heartlab. This application called “NCDR Export

Tool” was a windows forms (C#) based application leveraging SQL Server Stored Procedures

and compressions technologies to produce results for the National Cardiovascular Data Registry.

• Developed automated system for the generation of secure, digitally signed PDF documents which

are now used in the archiving of medical reports. This system, completely built in J2EE using

XML via Web Services is still utilized and relied on to this day with minimal modifications

applied since my involvement. As a side note, before my involvement we gave this product

away, after my involvement we sold it.

IT Consultant, 2002 – 2003

A.M. Technology & Consultants, Technical Solutions, 4 Employees, MA/RI

Started own consulting company focused on delivering solutions for small to medium sized businesses in

an extremely cost effective manner utilizing open source technologies where applicable.

• Provided complete IT management solution for many small/medium sized businesses; from

solution identification to installation and disaster recovery policies and support.

• Developed many custom built web based applications using the appropriate technology for the

job based on client requirements.

• Installed/Managed a myriad of servers for various clients:

1. E-Mail (SMTP, POP3, IMAP)

2. File Systems (WFS, Samba)

3. FTP (WinFTP, PureFTPd)

4. Database (Oracle, SQL Server, MySQL)

5. Web Server (IIS, Apache(1.x-2.x))

6. Streaming Media (IceCast)

Software Engineer, 2000 – 2002

Innosight LLC., Business Consulting Software, 30 Employees

Architected and developed online collaboration software for high level management and executives.

Utilizing many open source technologies; developed software envisioned by Harvard Business School

Professor Clayton Christensen, author of “The Innovators Dilemma” to break down the communication

issues that arise within large companies.

• Developed web based collaboration/communication system using IIS, COM, ASP 3.0, and

JavaScript.

• Developed Java applets allowing users to interact, append, tag, and comment on documents in a

collaborative form.

• Developed instant messaging like client using TCP/IP, UDP and C++/MFC.

E DUCATION

Bachelor of Science Degree, Computer Science, 2000 • Keene State College – NH (GPA: 3.2)

Associate in Science Degree, Safety Studies, 2000 • Keene State College – NH (GPA: 3.2)

R EF ERENCES

Furnished upon request.

A CHIE VEMENT S /I NTERESTS

1999, 2000 KSC tennis champion

Phi Mu Delta National Fraternity: President (1999-2000), Secretary (1998-1999)

Avid automobile fanatic

Contact this candidate