David M. Hagen
**** **** *** **., ******, TX ****8; 512-***-****
*************@*****.***
PROFESSIONAL EXPERIENCE
United States Military Academy, West Point, NY
ColdFusion Consultant Jan 2015 –Present
Requirements gathering to convert SharePoint site to ColdFusion
Programmed the Admissions Committee site to track and enroll cadets to the Military Academy
Created data tables, updates, inserts with MS Sever Management Studio
Technology used: ColdFusion 10, CFCs, CFML, HTML, JavaScript, Dreamweaver
Discover Financial Services, Chicago, IL
Senior Applications Developer - Contract Position Sept 2013 –Dec 2014
Lead developer for internal training web site accommodating over 1000 users across the United States
Application was written in ColdFusion 10 using MySQL for the backend database accessed through SQLyog
Created an Entity Relationship Diagram with MS Visio 10
Created data tables, views, relationships, queries, indexes and stored procedures
Technology used: ColdFusion 10, CFCs, CFML, HTML, JavaScript and jQuery’s data grid; jqGrid, MS Visio 10, Dreamweaver
Austin Board of Realtors, Austin, TX
Senior Applications Developer - Full Time Employee Mar 2012 –May 2013
Website administrator for ABor.com – ColdFusion and IIS Admin,
MSSQL 2008 data analyst focusing on reports for internal clients
Upgraded Abor.com from ColdFusion 5.0 to ColdFusion 10
Lead developer for Abor.com and company intranet site – built several applications on both
Lead the charge to incorporate Perforce version control in our environment when there was none.
Created functional requirements documentation which was adopted by all departments for new projects and turned those requirements into technical documentation and disseminated to the team which expedited story boarding sessions.
Lead workshops with key stakeholders to manage requirements, milestones, deadlines and expectation.
Capture meeting minutes on projects that I was not the lead and posted those on our SharePoint Server – MOSS 2012
Programming in ColdFusion 10, HTML 5, CSS3, JavaScript, jQuery on MS Server 2008 platform with the backend using MSSQL 2008
Served as Network Admin backup and MS Exchange backup
Working with both Project Management Institute (PMI) and Agile mythologies as vehicles for successfully completing the Software Development Live-Cycle (SDLC).
Northwest Vista College, San Antonio, TX A
Senior ColdFusion Developer - Contract Position Feb 2011 –Aug 2011
Enterprise-wide conversion of student registration system, HOLA, from ColdFusion 5 to ColdFusion 9.0.1
Create stored procedures, jobs, triggers, tables, indexes, primary and foreign keys in MS SQL 2008
Added Object-Oriented Programming via CFCs and AJAX
Created extJS 3.0 data grids for reporting intelligence
Reports created are downloaded in HTML, PDF, Word, Excel and Email.
Code created for single college that will be used to upgrade all satellite colleges in San Antonio under Alamo.edu.
Worked with key stakeholders for requirements, QA, bugs fixes and Regression Testing
Integration of BANNER data for student information
Setup development, staging environments both code and database
Configured Subversion for version control.
Used ColdFusion 9.0.1, Windows Server 2008, MS SQL Server 2008, JavaScript, AJAX, Dreamweaver CS5, Flash CS5
Sterling Jewelers, Inc. Akron, Ohio A
Senior ColdFusion Developer - Contract Position Oct 2010 –Nov 2010
Enterprise-wide conversion of multiple applications from ColdFusion 6 to ColdFusion 9
Migrated, Configured and Installed Databases for stores like Jared – The Gallery of Jeweler and Kay Jewelers
Added Object-Oriented Programming via CFCs and AJAX
Thoroughly tested all applications prior to Unit Acceptance Testing
Used ColdFusion 9, Windows Server 2008, JavaScript, AJAX, Dreamweaver CS5, Flash CS5, Contribute CS4
Texas Higher Education Coordinating Board Austin, TX A
Senior ColdFusion Developer - Contract Position Mar 2010 – Oct 2010
Built secure Internet Web Portal for Texas’ colleges and universities to upload school reports used to determine funding grants by the Texas Legislature.
Involved in requirements gathering, design, build, testing, training and implementation
Object oriented programming via ColdFusion, ExtJS, jQuery, JavaScript, Ajax
Created database ERD and built tables, indexes, constraints, stored procedures in MSSQL Server 2008
Used MoveIT DMZ Java API and SSL certificates to securely upload and download reports
Authentication into LDAP server from ColdFusion
Session creation, tracking and destruction using Application.cfc
Pearson Publishing San Antonio, TX
Senior ColdFusion Developer - Contract Position Sept 2009 – Mar 2010
Converted version 4.5 code to version 8.0 using ColdFusion Components (CFCs)
Used Dreamweaver for development and testing prior to sending code to QA server.
Debugged and fixed existing JQuery code.
SQL Server 2008: wrote queries, stored procedures, indexes and scripts.
Used Subversion as source control by updating, merging, diff merge and committing on daily basis.
Used HP Quality Control Center for bug tracking, work flow and Change Management.
Participated in the full SCRUM / AGILE process for development and Time-Boxed meetings
TrialSmith.com Austin, TX
Senior Developer - Contract Position Oct 2008– August 2009
Wrote ColdFusion Components (CFCs) to create Object Oriented scalable and reusable code.
Used Dreamweaver CS4 for development and testing.
Used AJAX to create asynchronous Data Grids.
Developed Custom Forms to encapsulate read-only PDFs with sensitive user information.
Created Primary and Foreign Keys in Tables, Indexes and T-SQL Scripts.
Wrote queries as Stored Procedures in MS SQL Server 2005
Encapsulated INSERT, UPDATE and DELETE queries with CFTRANSACTION to either commit or rollback in case of errors.
Used Common Table Expressions (CTEs) in MS SQL Server 2005 to perform recursive queries used to return hierarchical data.
Debugging and Quality Assurance testing
City of Austin – Budget Office Austin, TX
Senior Business Analyst May 2007– Sept 2008
Architect for ColdFusion 8.0, IIS, Windows 2003 Servers, MS SQL Server 2005
Administrator for Defect Tracking Management System (OnTime 2008)
Managed and created Scopes of Work, Functional and Technical Requirements.
Created Primary and Foreign Keys, Indexes and T-SQL Scripts – MS SQL Server 2000,2005
Created Primary and Foreign Keys, Indexes and PL\SQL Scripts – Oracle 9i,10g
Configured MS SQL Server 2005 on Fiber Optic Switches with dedicated second NIC card to reduce ODBC/JDBC traffic behind the F2 Load Balancer.
Responsible for tracking project deliverables, resources and deadlines using MS Project 2003
Responsible for Software Configuration /Management (SCM) to identify, control, account and authenticate enterprise applications for lowering Total Cost of Ownership (TOC
Perforce Version Control Administrator
ColdFusion 7.0/8.0 Web Server, IIS, F2 Load Balancer and Network Administrator
Westin Engineering, Inc. Austin, TX
Senior IT Consultant April 2006– April 2007
Wrote Stored Procedures and Triggers in SQL Server 2005
Application Architect
Developed and Administered ColdFusion Knowledge Management Portal
Wrote reports in ColdFusion Reporting Module and Crystal Reports 10
Project Manager for successful implementation of Laboratory Information Management System at Trinity River Authority. Lead effort to assist TRA to convert business requirements to technical specs
Red Oak Consulting, a division of Malcolm Pirnie, Inc. Austin, TX
Senior IT Consultant August 2004 – April 2006
Lead developer for enterprise-wide financial application in ColdFusion 6.0/7.0 and FLEX 2.0
Designed and programmed complex security layers (roles and groups) using CFCs
Configured Commercial-Off-The-Shelf XML graphing tool for executive Dashboards
Created Entity Relationship Diagrams (ERD).
Object Oriented Programming with ColdFusion CFCs
ColdFusion, IIS Web Server Administrator
Optimized JRUN memory spikes, leaks via JAVA garbage collection, threading and heap size.
Principal code reviewer during code complete breaks.
Configured and installed ColdFusion, SQL Server and other supporting apps on development, testing, training, staging and production environments.
Created Primary and Foreign Keys, Indexes and T-SQL Scripts – SQL Server 2005
Created Primary and Foreign Keys, Indexes and PL\SQL Scripts – Oracle 10g
Glasseye International Austin, TX
Lead Developer August 2002 – August 2004
Lead developer for design, development, implementation, testing and training of an Internet / Intranet / Extranet based applications with SQL Server Backend.
PVCS Tracker to track software defects
Used Perforce for version control
Developed Windows-like application with ColdFusion and DHTML with floating windows within Internet Explorer.
Developed XML Web Service for online digital currency for external client.
Developed full life-cycle financial tracking and reporting system using C#.NET and ADO object grids
NexGen Solutions, Inc. Austin, TX
IT Director January 2001 - August 2002
Managed a team of 10 comprised of business analysts, programmers and database administrators.
Prepared department budget forecasts, business case justifications and created IT Master Plan
Presented project fitness assessment based on ROI
Senior Internet Architect March 2000 – January 2001
Configured Active Directory, Network Security on Cisco Routers and Switches
Lead Developer for Nationwide Advertising Portal using ColdFusion, HTML, JavaScript, Regular Expressions (RegEx), LDAP for internal access, SSL encryption for external advertisers
Programmed Automatic Payment System between ColdFusion and VeriSign Financial
Developed General Ledger for Accounts Receivable.
Installed, Administered, and programmed stored procedures, triggers and jobs in SQL Server 2000
Duplicated Database efforts on redundant server as part of failover and disaster recovery plan
Eliminated network congestion at collocation
NEC Irving, TX
Programmer, Database / Network Administrator June 1999 – March 2000
Responsible for designing, developing and managing information training portal using ColdFusion, LotusNotes. SQL Server 7 database programmer and administrator. Developed tables, indexes, stored procedures, triggers and programmed T-SQL. Configured and administered Windows NT network domain user accounts and TCP/IP connectivity. Provided server installation and support.
GTE / Verizon Irving, TX
Database Programmer March 1998 – June 1999
Consolidated multiple MS Access databases to redundant SQL Server 7 servers. Reconciling database silos, enhanced performance and security, and develop stored procedures and triggers based on functional requirements. Programmed in VBA for MS Access and Excel.
Nichols Advanced Technologies, Inc. Austin, TX
Software Support March 1997 – March 1998
Lead support specialist for company’s flagship Library automation product. Developed enhancements to core software engine using Visual Basic for Application and MS Access.
American Express Austin, TX
Financial Advisor October 1996 – March 1997
Supported client’s goal of financial independence through coordinated and conservative investment strategies.
Ned Granger Law Firm Austin, TX
Office Manager May 1993 – October 1996
Client service, payroll, network administrator and legal researcher. Upgraded the office from a single type writer to 4 networked computers and created first client contact and accounting system in MS Access to track, expenses, accounts receivable, court dates and meetings.
Texas House of Representatives Austin, TX
Legislative Aide May 1991 – May 1993
Supported Representative with research and writing of legislation. Attend and reported on various committees based on citizen interests and concerns. Liaison to citizens, interest groups and other staff members in the House and Senate.
EDUCATION University of Texas, Austin, TX, Political Science / Economics, May 1992
AFFILIATIONS & CERTIFICATIONS
ColdFusion 4.5 Advanced Training Certification, Houston, Texas 2000
FLEX 2.0 Beginning / Intermediate Training, Austin, Texas 2007
Project Management Institute, Austin Chapter Member Since 2004
LIMS (Laboratory Information Management System) Certification, 2006
JAVA 2.0 Intermediate Training, Austin, TX 2002