Work History
Education
Skills
Timeline
Summary
References
Overview
Hi, I’m

Otis Jackson

Saginaw,USA

Work History

Clinithink
Remote, MI

Senior Dev-Ops Engineer
07.2022 - Current

Job overview

  • Supported AI software to extract text from physician notes and match with SNOMED expressions for predictive diagnosis.
  • Onboarded clients, including University of Utah and Boston Children's Hospital, onto Clix Unlock software.
  • Created homegrown ETL tool using PowerShell and MS SQL for seamless data loading from upstream systems.
  • Designed batch processes in Transact SQL to bulk load millions of records, enhancing data load efficiency.
  • Led installation initiatives for numerous customers, ensuring smooth integration with existing systems.
  • Developed scripts to optimize processes and automate repetitive tasks.
  • Analyzed infrastructure for optimization opportunities, increasing overall system performance.

Inovalon
Remote, MI

Senior Technical Business Analyst
11.2020 - 07.2022

Job overview

  • Led technical implementation of conversion projects from Scriptmed Enterprise to Scriptmed Cloud.
  • Collaborated with Functional Business Analyst to resolve complex application issues.
  • Managed database schema and data migration for transition to cloud environment.
  • Developed pre-validation scripts to ensure data conformity before loading into cloud.
  • Executed break/fix tasks and developed new data entities as required.
  • Conducted UAT testing to validate functionality and performance of applications.
  • Facilitated scrum meetings to promote team collaboration and project alignment.
  • Created BRD documentation to outline project requirements and specifications.

HCL America
Remote, MI

EMR/EHR Project Lead
09.2020 - 11.2020

Job overview

  • Executed seamless migration from Paragon EMR/EHR systems to Cerner with minimal disruption.
  • Coordinated resources and schedules to achieve project milestones efficiently.
  • Analyzed project risks and implemented proactive mitigation strategies.
  • Collaborated with clients to define project scope and requirements accurately.

Allscripts Healthcare Solutions
Remote, MI

Senior MSSQL Database Support Engineer(Sunrise)
09.2018 - 11.2019

Job overview

  • Conducted performance testing on databases to identify and rectify issues effectively.
  • Defined user access levels across database segments to maintain security protocols.
  • Administered databases while monitoring performance, addressing Windows and SQL server issues promptly.
  • Leveraged C# programming skills to optimize functionality of SSIS packages.
  • Resolved performance challenges related to Allscripts Sunrise EHR versions 16 through 18.4.
  • Created and managed reports in SSRS, enhancing data visibility.
  • Executed ETL processes via SSIS, consolidating data from various sources.

McKesson/Allscripts Healthcare Solutions
Remote, MI

Senior MSSQL Database Support Engineer(Paragon)
09.2016 - 09.2018

Job overview

  • Managed database administration for SQL 2005, 2008, 2012, and 2014 versions.
  • Resolved database performance issues through systematic troubleshooting and analysis.
  • Identified application issues impacting database performance and collaborated with development for resolution.
  • Escalated unresolved issues within defined SLA parameters for timely resolution.

McKesson
Remote, MI

Senior AMS Application\ Database Support Analyst
06.2012 - 09.2016

Job overview

  • Administered and troubleshot Onecontent (formerly HPF) to ensure optimal performance.
  • Executed Onecontent upgrades and patches to maintain system integrity.
  • Assisted with interface builds to Onecontent, enhancing integration capabilities.
  • Resolved database issues within Onecontent application to improve reliability.
  • Developed and repaired workflow threads based on client requests in Onecontent.
  • Created and fixed cold templates and HL7 ADT feeds as per client specifications.
  • Configured, set up, and supported RightFax for efficient communication workflows.

ATOS Medical Inc.
Flint, MI

EMR Systems Engineer Technical Team Lead
08.2009 - 06.2012

Job overview

  • Supported McLaren Healthcare imaging and archiving system using McKesson HPF.
  • Developed value-added applications with C# and Java to address organizational challenges.
  • Maintained and administered SQL Server 2000, 2005, and 2008 for optimal performance.
  • Managed systems support in accordance with corporate-defined SLA parameters.
  • Configured HL7 ADT feeds for seamless data exchange with HPF.
  • Analyzed and troubleshot issues related to ADT transmissions during cold feed receptions.
  • Administered EMR systems across several ATOS partner hospitals to enhance workflow efficiency.
  • Executed new HPF system build-outs, including cold feeds and transaction management setup.

Reliance One Inc.
Flint, MI

Senior Database Programmer Analyst
06.2009 - 08.2009

Job overview

  • Developed software to enhance reporting and customer service at Diplomat Pharmacy using C#.
  • Constructed data warehouse to consolidate information from various disparate platforms.
  • Utilized SQL Server 2008 and Oracle 9i for backend database management.
  • Employed SSIS for effective data transformation processes.
  • Performed systems architecture and design work to support application development.

TST Tooling Software Technologies
Grand Blanc, Michigan

Senior Database Programmer
11.2008 - 06.2009

Job overview

  • Designed and developed applications to support tool and die industry demands.
  • Administered SQL server databases to ensure optimal performance and reliability.
  • Created enhancements and bolt-on tools for VISI and AutoCAD using VB.NET.
  • Gathered specifications, authored help documentation, and conducted thorough code reviews.
  • Interfaced daily with management and customers to report project status.
  • Maintained SQL server environment for seamless application integration.
  • Implemented user requirements into application design to improve functionality.
  • Collaborated with cross-functional teams to refine project objectives and deliverables.

Central Michigan University
Mt Pleasant, MI

Web Developer II
09.2007 - 04.2008

Job overview

  • Developed and maintained interactive database-driven web applications for academic departments and student services.
  • Created requirements and specifications documentation based on end-user input.
  • Managed all aspects of SDLC to ensure project success.
  • Utilized ASP.NET, C#, VB.NET, and Transact SQL daily to enhance functionality.
  • Engineered inventory tracking system using ASP.NET 2.0 and C#.
  • Designed SQL Server databases according to client specifications.

EDS
Saginaw, Michigan

Information Analyst
03.2006 - 09.2007

Job overview

  • Developed web-based medical information ERP/RFP system for Medicaid/Medicare on .NET platform.
  • Coded multiple modules for Interchange using ASP.NET 2.0 and C#.
  • Executed full life cycle development for projects in government accounts.
  • Managed project timelines and deliverables for EDS Dow Chemical account.
  • Constructed modules for Open Source Content Management System DOTNETNUKE with ASP.NET 2.0 and C#.

Ellucian Company L.P
Universty Center, MI

Web Services Integration Manager
01.2005 - 02.2006

Job overview

  • Developed and maintained public and internal web presence for Delta College.
  • Managed procurement and allocation of resources for college web initiatives.
  • Oversaw project management, team dynamics, and human resource activities.
  • Interfaced with executive management to align college web directives with institutional goals.
  • Coded applications using C#, VB.NET, Flash, and Classic ASP.
  • Migrated Access databases to SQL Server 2005 for improved data management.
  • Designed Online Orientation for college leveraging Flash, JavaScript, and ASP.

Education

Western Governors University
Salt Lake City, UT

Information Technology

Delta College
Bay City, MI

Information Technology

Skills

  • Leadership and application support
  • Customer service excellence
  • Clinical and information systems management
  • Database analysis and administration
  • Microsoft PowerShell proficiency
  • T-SQL and SQL optimization
  • Root cause analysis expertise
  • Facets workflow management
  • Health plan data management
  • Python programming skills
  • ETL processes knowledge
  • VBNET and C# development
  • VBSCRIPT scripting capabilities
  • Software development best practices
  • Performance tuning and optimization strategies
  • Online learning facilitation techniques
  • Database development expertise
  • Crystal Reports generation skills
  • SNOMED coding standards knowledge
  • Oracle database management proficiency
  • Infrastructure planning strategies
  • Problem-solving techniques mastery
  • Monitoring and logging systems expertise
  • Scripting languages proficiency
  • Software testing methodologies mastery
  • Application deployment strategies expertise
  • Cross-functional collaboration skills

Timeline

Senior Dev-Ops Engineer

Clinithink
07.2022 - Current

Senior Technical Business Analyst

Inovalon
11.2020 - 07.2022

EMR/EHR Project Lead

HCL America
09.2020 - 11.2020

Senior MSSQL Database Support Engineer(Sunrise)

Allscripts Healthcare Solutions
09.2018 - 11.2019

Senior MSSQL Database Support Engineer(Paragon)

McKesson/Allscripts Healthcare Solutions
09.2016 - 09.2018

Senior AMS Application\ Database Support Analyst

McKesson
06.2012 - 09.2016

EMR Systems Engineer Technical Team Lead

ATOS Medical Inc.
08.2009 - 06.2012

Senior Database Programmer Analyst

Reliance One Inc.
06.2009 - 08.2009

Senior Database Programmer

TST Tooling Software Technologies
11.2008 - 06.2009

Web Developer II

Central Michigan University
09.2007 - 04.2008

Information Analyst

EDS
03.2006 - 09.2007

Web Services Integration Manager

Ellucian Company L.P
01.2005 - 02.2006

Western Governors University

Information Technology

Delta College

Information Technology

Summary

Senior DevOps Engineer with proven expertise in system infrastructure management and continuous integration. Skilled in automation tools that enhance scalability and streamline operations. Successfully designed solutions for complex IT environments while leading cross-functional teams to improve productivity. Achievements include substantial operational efficiency gains through targeted process optimization.

References

References available upon request.

Overview

21
years of professional experience