David Lozinski

lozinski@yahoo.com

Executive Profile

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.

 

Skills

  • Visual Studio, Microsoft SQL Server, Microsoft Azure, SQL Server Reporting Services, LightSwitch

  • C# .NET, Visual Basic .NET, SQL / T-SQL, NoSQL, ASP .NET, Classic ASP, HTML/DHTML, JavaScript, Knockout JavaScript, CSS, Perl, PHP, Java

  • WordPress, Adobe Photoshop, Sony Vegas Pro, DVD Architect Pro

  • C# and SQL Code Micro-optimization, ETL Development, Technical/Process Documentation


Career Highlights

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.


Experience

2012 - Current
Senior Consultant
Perth, Australia

 

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

 

David was a core-team member who developed a mobile application for Android, iOS, and Windows Phone, to better communicate power outages and notifications to end customers. This involved using several technologies including Durandal/Knockout JavaScript, C#, NoSQL, Windows Azure, Json, and web services.

 

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.

 

Decmil

 

David designed and implemented enhancements to their SiteDiary websites. This included the development of stored procedures, SSRS reports, C# and ASP.NET code, and JavaScript. David was responsible for liaising with the business stakeholders in identifying requirements to performing their technical design and implementation.

 

 

Market United
2011 - 2012
Technical Director
Perth, Australia

 

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.

 

 

Unisys Corporation
2002 - 2011
Senior Consultant
Australia and 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
Consultant
Greenbelt, Maryland

 

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.

 

Qualifications

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

 

Microsoft Transcript

https://mcp.microsoft.com/authenticate/validatemcp.aspx

Transcript ID: 990500

Access Code: MicrosoftTS1

 

Notable

Awards

"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."

 

Clearances

Previously held a U.S. Customs and Border Protection Background Investigation Clearance.