Michael Mcglothlin Email & Phone Number

Falls Church, Va, Us

DOD: JPES – Build, plan, maintain and develop for multiple Postgres clusters on AWS and develop stored procedures, functions and queries to interface with it.• Implemented streaming replication and logical decoding solutions to pass data to downstream processes as it is updated in the system.• Upgraded Database Servers both hardware (AWS) and software.• Support/Backup System administrator for the team using Redhat 7 and AWS.• Worked to develop automated system deployments from Jenkins to AWS so that developers could build a server directly without going to the system admins every time.• Designed and built puppet modules to deploy systems in a fast, stable and repeatable manner.• Applied Government STIGs, both in the servers and the deployment modules.• Developed portions of the surrounding applications in Java.CDC: ISS DME Team - Developed Stored Procedures to support REST Web Services.• Designed Stored Procedures to map FHIR standard framework to SQL Server stored procedures.FEMA Call Centers – Developed ETL and Database flow to generate reports to bill call center agents time to FEMA.• Used Python to make API calls to retrieve json data from a commercial tool and load it to SQL Server.• Exported and Delivered file from SQL Server to Excel utilizing Python.• AWS System Administrator for SQL Server system that supported the project.Electronic Veteran Self Service – Database Development and support. • Supported Oracle Database Development.CSRA Internal Work – Supported internal CSRA timekeeping systems.• Developed Oracle stored procedures for ETL.• Updated PowerBuilder functions to add new functionality.Center for Medicare and Medicaid Systems Trusted Third Party - Developed and maintained Hadoop Cluster and related processes. Supported project systems and architecture including Tableau, Moveit DMZ, and Linux systems.Enabled Hadoop Encryption onto multiple environments.Enabled backup processes for Tableau.Support of multiple Hadoop environments.

Falls Church, Virginia, Us

Falls Church, Virginia, Us

Bentonville, Arkansas, Us

Led development of a cloud based infrastructure for a large, complex reporting website. Oversaw infrastructure development, maintenance, support and deployment for a large team of >120 developers in cloud. Deployed and maintained >20 web-service platforms and multiple web-page hosting platforms. Worked with data movement group to develop and troubleshoot ETL flows to and from Greenplum, Teradata, SAP HANA, and SQL Server, DB2 and Informix Data Platforms.Setup and implemented cloud infrastructure for new team and served as Cloud Infrastructure lead.Setup centralized logging system. Moved >15 TBs of data from one system to another in less than a month. Designed and implemented scripts to alert team if a data service or database was down. Led efforts to move to connection pooling, automated testing, and made web-services highly configurable in conjunction with cloud principles. Managed automated release of Java web-services and HTML/Angular code.

Bentonville, Arkansas, Us

Defined and met customer project needs and designed and implemented Statistical Analytics data flows, ETL flows and data transfer jobs, Data structures and DDL statements.Supported Business Intelligence systems and led teams of employees and contractors to meet customer needs.Designed an automated SAS flow using PERL scripts and the Mainframe to kick off SAS jobs for an analytic process flow. Redesigned a SAS flow to increase efficiency.

Bentonville, Arkansas, Us

Designed and developed multiple Business Intelligence systems, developed infrastructure and provided support for those systems.Worked with customers to understand their project needs. Designed, developed, deployed and maintained business intelligence reports, ETL flows, data transfer jobs, and DDL’s for multiple data base systems. Led teams of employees and contractors to install and support new software and worked with vendors to maintain and keep the software up to date. Troubleshot and fixed server issues and software bugs.Provided the first Business Intelligence reporting dashboards for Merchandising Area and International areas allowing access to key performance indicators in a centralized location saving merchants thousands of man hours each year. Provided KPIs concerning customer satisfaction surveys and call center locations; estimated worth $500K/year.Assisted in bringing Business Intelligence server up-time from 70% to 99%. Managed upgrades to new versions of software being used saving $2M in support costs. Brought in new Business Intelligence platforms. Built ETL flows for >10 projects. Successfully rewrote failed ETL flow in two weeks, saving $10M.

Bentonville, Arkansas, Us

Troubleshot and fixed customer support tickets. Developed changes to Retail Link/Decision Support System reporting tool. Provided data movement and troubleshot/fixed data quality issues.Integrated reporting for new acquisitions in Central America for DSS system. Allowed access to brand information in reporting system providing sales boost estimated at $2M.

Bentonville, Arkansas, Us

Designed database for Unix Security Management System. Assisted in implementation of SSH key system to help meet SOX compliance.

Maintained and installed factory computer systems. Troubleshot and fixed users’ PC issues and installed software as needed.Installed new factory wide flow control and monitoring system to allow more efficient changeovers between compressor models and smoother flow of units between assembly lines.

Baton Rouge, La, Us

Traveled to customers’ location to troubleshoot/fix issues with equipment, deliver supplies and new equipment, and perform installs.

Traveled to customers’ location to troubleshoot/fix issues with equipment, deliver supplies and new equipment, and perform installs.

Bachelor'S Degree, Computer And Information Sciences, General

Diploma, Industrial Electronics Technology/Technician