Michael Gaines Email & Phone Number

San Francisco, California, Us

New York, Ny, Us

• Rolled out large integrations on both customer, and internal facing products, and established after care for current organization• Campaigned bringing in customers via API, and less through EDI. Receiving data 10% earlier compared to last year.• Maintained, and administered data warehouses, and reporting facets.• Rolled out self service reporting for different OUs to empower end users to consume and analyze data.• Introduced Validation and repositories to the organization to establish best practices such as Data Quality, ETL, and Automation• Maintained large scale healthcare data sets; create intake process to streamline best practices, and alleviate bottlenecks• Aligned key stakeholders to ensure High Trust Certification to assure Public Launch• Oversees all Customer facing reports, and administer Tableau ServerIndustry: Healthcare

Las Vegas, Nv, Us

• Rollout large-scale integration to Enterprise Resource Planning (ERP)• Develop software and systems on test driven development and continuous integration practices; establish monitoring and automation processes• Create efficiencies in proprietary software by re-developing back-end code• Implement Self-Service Business Intelligence (BI) and Reporting• Perform analysis and troubleshooting of queries using Relational Database Management System toolsets• Identified key areas of improvement for the Customer Service team, using SQL, Python, and Power BI I developed a velocity driven report that saved 120 hours of labor each month• Perform application development, server, storage migration, backup, and high availability for optimal performance and efficiency• Provide supervisory oversight and execute Database Administrator (DBA) Managed Services partner duties on priority support issues• Lead technical projects from start to finish that impact organizational change management & project management guidelines:o Developed custom APIs to communicate inbound and outbound with large-scale shipping providers such as: UPS, USPS, FedEx, and many otherso Created custom Electronic Data Interchange (EDI) workflows to optimize data View/Get requestso Conducted multiple upgrades to ERP (Microsoft Dynamics GP)• Provide database solutions and responsible for application development• Work with and educate our e-commerce/web team to make good schema design choices and write optimized queries• Integrate DBA operational goals into proactive processes within development streams• Assist Development and Support team with technical and troubleshooting production issues• Strong understanding of how to maximize SQL Server application scalability, performance, recoverability, and maintainabilityPrograms: Microsoft SQL Server, Microsoft Visual Studio, VMware, Microsoft Office Suite (Teams, Power Automate), Aruba Central, SSMS, SSIS, ManageEngineIndustry: Supply Chain, Warehouse

Las Vegas, Nevada, Us

• Integrated back-end Workday data across omni-channel reporting facets• Developed software to clean and investigate large data sets of numerical and textual data• Integrated with external data sources and APIs• Supported rich data visualizations to communicate complex ideas to customers and company leaders• Collaborated with the Information Management and Information Technology organizations and all MGM Properties (local andregional) on an enterprise-wide basis to execute on the ongoing strategy to assess Business Intelligence tools• Delivered the Business Intelligence dashboard strategy, including strategic, tactical, and operational dashboards, subject areaanalysis, and support of performance management methodologies• Identified and executed process improvement opportunities• Recommended and implemented corrective actions to resolve issues associated with Business Intelligence toolsPrograms: Microsoft Power BI, JIRA, Oracle, Teradata, Atomic Automation, BTEQ, Microsoft SQL Server, SSISIndustry: Hospitality, Food and Beverage

Las Vegas, Nv, Us

• Oversaw inventory management blueprinting phase which included gathering and mapping business requirements related to sales and distribution (SD) and materials management (MM) functions applying SOPs for best business practices• Collaborated with departmental leadership to develop action plans based on results derived from data analysis reports• ERP SME that determined and then implemented the best solution to rollout company-wide that addressed business pain points• Oversaw workflow KPI analysis and implements continuous improvement strategies to optimize software usage and improved overall performance• Administered Microsoft SQL Server 2012• Created backup maintenance plans for databases on SQL server• Programmed scripts for back end development• Created SQL queries and provided result data set for reporting needs• Developed and implemented new ERP systems and upgraded existing ones depending on project needs• Assisted multiple departments with reporting needs pertaining to WMS system and ERP• Partnered with ERP manager to automate invoicing for sales orders and purchase orders• Partnered with CTO to introduce enterprise wide implementations for automation• Presented, provided, and monitored training to over 100 team members• Liaisoned between the business and IT team• IT Support:o Installed, configured, maintained, secured, troubleshooted server-based hardware, software, and other related componentso Created and maintained Microsoft Active Directory Users and GroupsIndustry: Supply Chain, Warehouse

Las Vegas, Nv, Us

o Installed, configured, maintained, secured, troubleshooted server-based hardware, software, and other related componentso Created and maintained Microsoft Active Directory Users and GroupsSkills:End user supportActive DirectoryExchange ServerWindows 7, 8, and 10ImagingHardwareMicrosoft Server 2008 r2Microsoft Server 2012 r2Network troubleshootingAnti Virus, Anti MalwareOffice SuiteNew PC DeploymentXeroxServer InstallationIndustry: Supply Chain, Warehouse

Bachelor’S Degree, Management Information Systems, General

Associate Of Science (A.S.), Business Administration And Management, General