Dave’s resume is available for viewing/download in the following formats:
Senior I.T. Consultant with a versatile skill set, multiple professional certifications, numerous work performance awards, and more than 20 years of professional work experience.
David absolutely enjoys working with and learning a wide-range of technologies. Special areas of interest include: micro-optimizing and implementing both multi-threaded and parallel-processing C# .Net code; optimizing SQL Server Views, Stored Procedures, and Functions for maximum performance gains. He is an active contributor to blogs and websites (including his own) detailing tips, tricks, and optimization exploits.
David has also worked across a wide spectrum of organizations in both Australia and the U.S.A. doing application development, server administration, and system design, maintenance, and support. Some of these notable organisations include: Public Trustee of Western Australia (PTWA), Western Australia’s Department Attorney General (DoTAG), U.S. Department of Homeland Security (DHS), U.S. Customs and Border Protection (CBP), U.S. Internal Revenue Service (IRS), Unisys, NASA / Lockheed Martin, and UUNET / MCI Worldcom.
David loves his job, enjoys learning new skills, and takes pride in his work. This is reflected in the Microsoft Case Studies on his projects to receiving personal “Letters of Commendation” from the U.S. Government.
- Visual Studio, Microsoft SQL Server, Microsoft Azure, SQL Server Reporting Services, Microsoft LightSwitch
- WordPress, Adobe Photoshop, Sony Vegas Pro, DVD Architect Pro
- C# and SQL Code Micro-optimization, ETL Development, Technical/Process Documentation
Re-architected Western Australia’s Department of Housing’s business intelligence framework with multiple C# and SQL components to maximize the use of parallel processing. Developed Android and iOS mobile apps for Western Power allowing residents in Western Australia to check their power status from any mobile device. These solutions have been highlighted in Microsoft Case Studies.
Assisted in the conversion of PTWA’s primary client information system from Cobol/Oracle to .NET Windows application with an SQL backend.
Programmed and supported multiple systems for Western Australia’s DOJ including the Integrated Court Management System (ICMS), Fines and Enforcement Registry (FER), and Electronic Transcript Request System (ETRS)
Designed and developed systems to support the U.S. Department of Homeland Security’s Customs and Border Protection division including those used by the Assistant Commissioners.
Appointed principle web developer to design and implement the “Highwaynet” website which was tied into the Virginia Department of Transportation’s (VDOT) highway cameras to provide live traffic video feeds to paid subscribers.
Developed part of the java-based desktop user interface supporting the IRS Tax System Modernization (TSM) initiative.
Installed hardware, laid network cables, and programmed components of the Hubble Space Telescope Ground System located at NASA’s Goddard Space Flight Center.
2012 – Current
Department of Housing and Works (DoH), Perth, WA
David is engaged by the Department of Housing implementing enhanced data transformation (ETL) processes to populate their data warehouse using a custom developed Business Intelligence (BI) Framework solution. He continuously demonstrates his ability to integrate and work with multiple technologies (both new and old) to provide critical functionality required. This included implementing a multi-threaded C# application making extensive use of C#’s parallel processing capabilities. David identified other significant SSIS and SQL coding improvements, utilizing various performance techniques, to considerably reduce the ETL process run times – his current record stands at reducing one process from 4 hours down to 20 minutes!
David’s BI Framework solution draws data from a multitude of sources including, but not limited to: Oracle, SQL Server, Sharepoint Lists, Excel Files, CSV files, PostGres, Microsoft Azure, and more.
This versatile system is so impressive it was nominated for a national award and the reporting from all this data is highlighted in a Microsoft Case study.
Western Power, Perth WA
He held multiple hats on the project, including developer, tester, writing formal documentation, resolving reported issues, and managing client expectations.
The Western Power mobile application is featured in a Microsoft Case study.
Disabilities Services Commission (DSC)
David worked as Senior Consultant for DSC and was an integral part of the team that upgraded the department’s core legacy websites and systems to .Net 4. His role involved in meeting deadlines in a tightly scheduled project to upgrade department’s core systems that has been built in legacy .Net versions to current department standard of .Net 4. This also entailed making sure those applications complied with WCAG 2.0 AA – AAA standards. .Net (both VB and C#), MS SQL Server, LLBL Gen and Telerik technologies were involved in this project. David’s team successfully upgraded, rebuilt, tested, and deployed more websites than was expected or required.
2011 – 2012
Managed and a team of developers and system administrators. Supervised the delivery of applications, websites, and campaigns to clients. Participated in scoping sessions with clients, architecting technical solutions, and liaised with Account Managers, Designers, and supporting developers to deliver high quality code to challenging deadlines.
2002 – 2011
Various locations across Australia and the USA
Public Trustee (PTWA)/ Department of the Attorney General (DoTAG), Western Australia
David’s primary role at PTWA was assisting in the conversion, support, and development of MATE .NET, which is PTWA’s core system developed using C# .NET. During this time David reviewed and provided technical feedback on tender responses, scoped out project designs, and produced multiple design documents.
David maintained DoTAG’s Fines and Enforcement Registry (FER) using C# and VB .NET, implemented SQL Transactional Replication between critical servers, and optimized countless SQL stored procedures. He also designed and programmed the interface to DOJ’s Electronic Transcript Request System (ETRS) used by personnel to request and/or upload transcripts related to court proceedings from Civil and Criminal Court up through the Supreme Court using ASP.NET and PHP.
U.S. Customs and Border Protection (CBP) / DHS, Washington DC, USA
David primary achievements were automating U.S. Customs’ Online Project tracking And Reporting (OPAR) website using ASP, VB Script, and Microsoft Access after reviewing their process. David was chosen as a primary team member to port the system to WebSphere, Java Server Pages, and Oracle.
David’s many other contributions and achievements for DHS included:
- Implementing Crystal Reports to dynamically create and automate multiple views, data charts, and financial reports.
- Developed multiple applications supporting Customs’ operations including a “Helpdesk” and “Configuration Control Board”.
- Served on the US Customs’ Technical Review Committee (TRC) to decide the software and technologies to be approved for use within U.S. Customs service.
N.A.S.A. / Lockheed Martin
David assisted in the programming of a real time monitoring system for NASA’s Hubble Space Telescope using “LabView”. Appointed Principal Network Administrator of NASA’s Central Intercommunications System for the Hubble Telescope Ground System.
MCSA – SQL Server 2012/2014
MCSE – SQL Server 2014 Business Intelligence & Data Platform
MCSD – Web Applications
MCTS – .Net Framework 2.0 Windows Applications
MCTS – Visual Studio Team Foundation Server Administration
MCDST – Microsoft Certified Desktop Support Technician
SCJP – Sun Certified Java Programmer
Bachelor of Science, Computer Science, Virginia Tech, 1996
Transcript ID: 990500
Access Code: MicrosoftTS1
- “GI Delivery Award Excellence Winner”, Unisys Corporation, “completed Western Australia’s Public Trustee upgrade ahead of schedule, exceeding client expectations, delivering quality results, and meeting or exceeding financial targets”, May 2009.
- “Bronze Recognition Award”, Unisys Corporation, “In recognition of your exceptional achievement and contribution to the success of Unisys”, March 2004.
- Letter of Commendation, U.S. Customs and Border Protection, Department of Homeland Security, “having consistently provided expert technical assistance and support to Customs and Border Protection (CBP). He continues to demonstrate a very high level of expertise in the areas of web programming, database development, Visual Basic programming, and a host information technology applications. He is dependable and very thorough in his work. In addition to his professionalism, he is a pleasant person to work with, always ready with a smile or laugh. He exemplifies the highest level of dedication to the CBP mission and is well deserving of recognition by CBP.”, January 2004.
- Letter of Commendation, US Customs Service, “having made incalculable contributions to OIT and to the US Customs Service. He personifies the qualities of an ideal employee who inspires everyone he meets with his positive attitude, generosity of spirit and extraordinary talent. His qualifications have been clearly evident to all with whom he works and have resulted in his continually being relied upon to produce timely, well-thought-out, and very high quality work.”, December 2002.
- “UUNET Customer Service Award”, UUNET Technologies, “for going above and beyond the call of normal duty, presenting a creative or non-standard solution, and demonstrating exceptional follow-through or dedication.”, October 1998.
- “Best of Campus”, May 1996 by the Internet Board of MDL Inc., “for recognition of college students’ “superior” web pages.”