Michael Oak Email & Phone Number

Essex, Vt, Us

·Collaborate with multiple teams to design and implement integrations between ERP and MDM systems·Automate creation of new products using Microsoft SQL·Create documentation for internal and external stakeholders·Leverage Powershell and SQL to transform data and transfer files

·Collaborate with external and internal stakeholders to design and implement MDM solutions using Precisely EnterWorks ·Install and configure EnterWorks in the Cloud and on premise·Use a combination of MDM tools, SQL queries, Velocity Template Language (VTL) transformations, and PowerShell scripts to integrate the MDM and ERP solutions·Design and implement automated workflow solutions to improve efficiency and ensure data accuracy·Document and train users to ensure they are self sufficient after go-live

· Performed troubleshooting and resolved software and configuration issues during implementation to ensure deliverables were met· Resolved database deployment issues using Microsoft SQL Server Profiler and Management Studio· Eliminated repetitive manual tasks and ensured correct configurations were applied by scripting the installation and configuration of Windows and Linux software· Configured and deployed e-commerce software using Octopus Deploy· Streamlined production releases with PowerShell scripts leveraging the Octopus Deploy API· Trained employees on implementation and release best practices and processes· Improved the quality and efficiency of releases by documenting the existing release process and implementing improvements to it· Supported new development initiatives by building and maintaining TeamCity and ProgGet environments

· Collaborated with project managers and customers to create SSRS reports for Microsoft SQL Server· Enabled support staff to independently resolve cases by designing and deploying SSRS subscription dashboards· Automated import, transformation, and auditing of marketing emails using SSIS

· Performed triage and support for HL7 interface between revenue cycle management application and EMR system· Installed, configured, and supported Business Intelligence software running on Microsoft Windows/SQL environments· Provided technical support for Revenue Cycle Management software running on IBM AIX servers· Educated and collaborated with customers to implement proactive monitoring alerts, allowing customers to manage their own reporting servers· Resolved a high volume of customer cases while maintaining a high customer satisfaction rating and low turn around time

· Installed, configured, and supported Radiology Information System software running on Microsoft Windows and Microsoft SQL Servers· Reduced support case volume related to a major Crystal Reports conversion by creating SQL scripts and quality checks to automate and audit report conversion and testing· Redesigned the process for migrating Microsoft SQL Server databases between environments and developed SQL scripts to automate that migration, improving productivity and reducing errors