Douglas Lecander Email & Phone Number

Fargo, North Dakota, United States

SQL Database/SSIS/Powershell Developer

New Hope, Minnesota

Managed and maintained SQL Server, Microsoft Access, and other database automated, semi-automated and manual processes, as well as Point-Of-Sale (POS) software and hardware installed at 19 schools and within district infrastructure. Solved COVID-19 related need for simplified, reliable remote use of legacy MS Access database applications that connect to on-premises data sources by creating a MS RemoteApps-compatible custom Visual Basic .NET launcher menu for Access front ends, partnering with IT to install on a district server, and training other technical specialists to maintain the SQL Server-based backend for managing applications and users. Worked along other Technology department staff to resolve technical challenges along the way to the ultimately successfully start of the 20-21 school year in early September 2020.

St. Louis Park, Mn

Maintained the corporate reporting SQL Server data warehouse and over one hundred scheduled jobs/tasks running on SQL Server or MS Access automated processes, many of which perform ETL operations from the corporate production Oracle membership database. Performed ad-hoc extracts/reports for internal management and external client companies, frequently on short notice. Developed or enhanced most of the SQL Server Integration Services (SSIS) and Access based automated processes. Built the company’s complex yet highly efficient system utilizing a SQL Server backend along with an automated Access front-end and custom C# dynamic link library (DLL) to consume RESTful Web Services for identity protection customer reporting and initiating secondary processes for Oracle membership database alerts events and member gift card fulfillment. Authored the Secure File Transfer Protocol (SFTP) download/upload automation tool and the Visual Basic for Applications (VBA) Access Add-In used in the BIS department, as well as about half a dozen multiuser database applications used by other departments. Migrated critical Access and Excel VBA projects from 32-bit Office 2016 to 64-bit Office 365, updating numerous Win32 API function calls for 64-bit compatibility. Wrote the VBScript that installs multiuser database applications for employees by copying the frontend application and support files to users’ Windows profiles and adding desktop and start menu application launch shortcuts. Developed HTML-based near-real-time reporting system driven via MS Access and VBA automation to simplify monitoring status of SQL Server jobs and backups, Windows scheduled tasks, synchronization of critical reporting tables, and RESTful web service extracts throughout the workday and when logging in remotely. Created various Access/VBA-based tools to assist myself in database/code development, data migration, and file management.

Minneapolis, Mn

Sole contractor hired for company-wide transition of human resources and payroll systems to a Ceridian web-based solution utilizing an Oracle back-end database. Coordinated gathering and cleanup of existing data from multiple sources. Created data comparison and import/export tools to ensure data accuracy and prevent data loss. Exported all data to Ceridian’s detailed data file specifications and assisted in post conversion data validation.

Planned, coordinated, and executed $9.3 million annual budget for maintaining assigned intelligence aircraft. Ensured management was apprised of fiscal standing and projected spending for current and next fiscal year. Monitored daily expenditures for 39 government VISA accounts and 35 supply accounts. Created and used multi- and single-user Microsoft Access databases to manage and monitor accounts and track status of purchase requests. Coordinated large purchase requests with Contracting department. Approved fund cites for official travel and monitored government travel card use. Developed and submitted annual and quarterly funds loads to Budget department. Developed next fiscal year's operating budget. Corrected funding discrepancies and identified root causes. Briefed personnel on financial responsibilities.US Air Force Job Titles/Ranks Previously Held: Branch Chief, Master Sergeant, Jun 2001 – Jan 2002Chief of Logistics Support, Master Sergeant, Oct 1998 – May 2001Assistant Chief of Network Systems Maintenance, Technical Sergeant, Jul 1998 – Oct 1998Course Manager, Technical Sergeant, Aug 1991 – Jun 1998Technical Training Instructor, Staff Sergeant, Aug 1989 – Aug 1991Electronics Technician, Staff Sergeant, Aug 1983 – Jul 1989