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.

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.

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.

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.