Mike Lott Email & Phone Number

Georgetown, Tx, Us

Employed T-SQL, SSMS, SSIS, and Stored Procedures to monitor, ensure validity, create new and update existing data flow processes containing mission critical data for business users. Developed and maintained internal applications, utilizing SQL Server databases, T-SQL, C#.NET, Angular, HTML and CSS. Converted numerous legacy systems to newer architecture based on the Microsoft stack. Some were very complex. Created new SQL Server databases, tables, views and stored procedures to support new applications and processes. Interacted with multiple, varied databases, including Oracle and MySQL, to access data and research issues at the source.

Lakewood, Co

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

General Services Administration Offices - Fort Worth, Tx

Supported the nightly data flows 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.

Dallas, Tx

GUI and Database development, Network and Systems Administration, Technical Support, sometime snack supplier and occasional minor miracle worker - small shop, many hats. Supported and developed additions to Visual FoxPro GUI system. Supported 30-40 users in two cities, including all aspects of systems support, network troubleshooting and email support and configuration. Assisted in setup and maintenance of Exchange Server and clients. This involved mainly Tier 1 and Tier 2 support.Performed analysis, created technical specifications and oversaw development of new system, developed in .NET.

Round Rock, Tx

Design and implementation of IT and software systems and processes. Technical Project Management. Assistance in maintaining data in SQL Server databases. Small internal development projects. Served as Systems Analyst for all internal software systems. Most of these were .NET systems, developed in C#. Interfaced with internal and external clients, partners and developers regarding changes or fixes needed within these systems. Provided specifications, unit testing and demonstrations of new functionality. Helped to maintain SQL Server databases by maintaining, importing and exporting data and validating existing data and stored procedures. Managed development performed by offsite development team, which included technical specifications, code reviews and unit testing. Created internal apps to aid management in numerous tasks. This development involved Visual FoxPro, Transact-SQL, VBScript and XML. Aided IT team in Tier 1 and Tier 2 support when needed.

Round Rock, Tx

Responsible for all technical processes involving imaging, integration and configuration of large numbers of computers and other hardware. Designed, setup and managed internal networks for imaging and application deployments.Created, updated and corrected technical documentation for processes and infrastructure.Engaged in programming and scripting tasks involving Visual FoxPro, VBScript, SQL, Access, Batch files and XML.Identified and addressed numerous problems in existing processes and applications at Dell Computer's Americas Merge Center (AMC) which, in some cases, involved research and development of new processes - sometimes using new technologies - to improve quality and/or productivity. Served as a technical consultant to TriFusion and Dell Operations Managers throughout entire life cycle of AMC projects.Involved in management of most or all aspects of numerous large, key projects; discovery, technical setup, documentation, training, staffing, operational setup and execution - from start to finish. Teams included from 2 to 30 techs, depending on project scale.Engaged in hardware, software and network support when necessary. Supported PCs, Macs, Dell (Windows OS) servers and printers.

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.

Participated in development of internal Customer Relationship Management software. The system was developed in Visual FoxPro and used various database products on the back-end – mainly SQL Server and Sybase. Customized and maintained CRM system for specific clients. This sometimes also involved designing and implementing changes and/or additions to the schema of the database. Created and maintained numerous import and export processes – involving many different kinds of file formats. The processes often included cleansing and validation of the data.

Oklahoma City, Oklahoma Area

Development and maintenance of commercial and internal websites. Maintenance of reports and report generation processes. Administration of email and web server.

Norman, Ok

Development and maintenance of long distance billing and mailing system. FoxPro development.