Database and Full-Stack Developer

Mike Lott

Database Developer Full Stack Developer ETL/Integration Expert Conversion Specialist

512-***-**** ****.****@*****.*** Georgetown, TX www.linkedin.com/in/mikelott

Professional Summary

Seasoned professional with 15+ years of database and data-related experience, in addition to over seven years of full stack development experience in the Microsoft stack. Years of experience working closely with internal and external customers and technical teams and leading development on multiple projects.

Areas of Expertise

Professional Skills SSIS and other ETL processes Creating and enhancing applications Finding and addressing issues in data and applications Optimization of code and SQL Converting apps to different technologies Report Development Working with customers and team Data Migrations

Technical Skills SQL Server and T-SQL SSIS ETL Visual Studio and VS Code Oracle and PL/SQL MySQL

C#, Angular, TypeScript, HTML and CSS APIs Git IIS Python Scripting Testing ODBC

Professional Experience

Senior Business Intelligence Developer, Lumen Technologies Broomfield, CO June 2016 – April 2024

•Used T-SQL, SSMS, SSIS, and Stored Procedures to monitor, ensure validity, create new, and update existing data flow processes for mission critical data for business users. Data was for internal apps and reporting. Some SSRS experience.

•Developed and maintained internal applications and reports, utilizing SQL Server databases, T-SQL, C#.NET, Angular, HTML and CSS.

•Created, Analyzed, Updated or Fixed and Optimized SQL code and Stored Procedures on a regular basis, and also analyzed data from other sources and did troubleshooting, changes in ETL processes, and work with other teams to fix or otherwise update data coming downstream.

•Created new SQL Server databases, tables, views and stored procedures to support new applications and processes.

•Interacted with multiple databases, including Oracle and MySQL, to build and support ETL processes and analyze issues.

•Converted numerous legacy systems to newer Microsoft Technology Stack architecture. Some were very complex.

•Worked remotely 100% of time for the last five years at Lumen.

Senior Developer, Computronix (USA), Inc. Lakewood, CO July 2015 – Mar 2016

•Maintained applications written in PL/SQL. Work also involved creating procedures and functions in Oracle databases, as well as modifying or creating schemas, users, tables, triggers, and other Oracle database objects.

•Customized and configured applications for new customers.

•Authored and modified Python scripts that were also part of the internal systems.

•Worked on various third-party interfaces, which required other languages and sources like C#, XML, and JavaScript.

Senior Development Engineer, General Dynamics Information Technology Fort Worth, TX Sep 2010 – Jul 2015

•Supported the nightly data flow ETL processes for the Office of the CFO of the General Services Administration. Tools included Visual FoxPro and later C# coding to move and manipulate the data, which was stored in Oracle databases.

•Converted multiple complex FoxPro applications to C#.

•Authored queries for Oracle databases and wrote PL/SQL code for table creation, packages, sequences, and triggers.

•Compiled documentation of analysis, design, and testing as well as full system and SDLC documentation.

•Worked for a Federal Agency client with a required government security clearance for this position.

•Worked remotely 80-100% of the time for the last two or three years at GDIT.

Database Application Developer, Industry Consulting Group Dallas, TX Feb 2009 – Sept 2010

•Created and maintained in-house applications using Visual FoxPro 9.0. Work included support of Windows GUI and database maintenance and imports and exports from and to various formats.

•Created new functionality in applications and built reports for business team and executives. Sent data to and from third party sources.

•Led .NET development with VB.NET and participated in design of new .NET systems.

•Also served as IT staff – setting up new users and systems, maintaining email and email server, among other things.

Systems Analyst, TriFusion Round Rock, TX July 2007 – Dec 2008

•Helped to maintain SQL Server databases; including importing and exporting data, cleansing data, creating reports, modifying or creating tables and working with stored procedures and triggers.

•Owned in-house applications; responsible for issue resolution, managing development, and design of new features and integration with other software and processes, including requirements gathering and specifications creation.

•Managed development effort performed by an offshore development team. Created and shared design documents, discussed projects, and tested finished products.

•Built various in-house tools and imported and exported data with Visual FoxPro and C#.NET. Transferred files and data through FTP, SFTP, and Web Services.

Technical Process Engineer, TriFusion, Round Rock, TX Feb 2005 – July 2007

•Responsible for all technical processes involving Dell and Apple products at Dell’s America’s Merge Center (AMC). This included imaging, integration and configuration of large numbers of computers.

•Served as a technical consultant to TriFusion and Dell Operations and Project Managers for entire life cycle of projects.

•Trained technicians in specific technical processes for new projects and then served as technical team lead for the life of projects.

•Created, updated and corrected technical documentation for processes and infrastructure in the AMC.

•Engaged in programming and scripting involving Visual FoxPro, VBScript, SQL, Access, Batch files, FTP, SFTP, and XML.

Programming and Technical Support Consultant, Self-Employed, Austin, TX Jan 2003 – Feb 2005

•Served as a consultant, providing the following services: Software development, web site development, database development, and systems and network support.

•Technologies supported include C#.NET, SQL Server, JavaScript, Visual FoxPro, Classic ASP, and Microsoft Windows system support, among others.

Programmer/Analyst, Harte-Hanks, Inc., Austin, TX July 1998 – Nov 2002

•Participated in development and maintenance of internal CRM software – client-server architecture written in Visual FoxPro with SQL Server and Sybase databases.

•Created and maintained numerous import and export processes – involving many different kinds of file formats. ETL processes were created for multiple imports. Also used FTP, SFTP, and Web Services for file transfers – to and from.

•Created reports and analyzed data for business users

•Maintained and updated stored procedures and SQL Server data and other database objects, and set up ODBC connections for applications and users.

•Earned a reputation for getting clients, internal and external, exactly what they needed.

Education

•Associate of Applied Science Degree in Programming - .NET Emphasis - Brookhaven College, Farmers Branch, TX – 2013 Earned multiple STEM scholarships while attending this school, and was ultimately invited to join the Phi Theta Kappa Honor Society due to outstanding academic achievement while there.

•Training and classwork in the following: C#.NET, VB.NET, ASP.NET, PHP, MySQL, MongoDB, Ruby, Java and Oracle.

Contact this candidate