• Prepare data migration Strategy for migrating data from primitive HIS systems to Cerner EMR system.
• Perform migration from multiple HIS to a single EMR system.
• Perform Data Cleansing activity required for migration.
• Build and complete data migration uploads.
• Creating data normalization workbooks for clients.
• Complete data migration testing.
• Manage data migration changes and project activities and communicate with impacted associates or clients.
• Provide tier 1 troubleshooting and issue resolution for data migration uploads.
• Administer database systems technical design, performance monitoring and tuning, backup and recovery, data and file distribution, reporting, database upgrades, integrations, migrations, and conversions.
• Develop and maintain database administration procedures and operations; cross train on and provide operational support of procedures.
• Responsible for verifying accuracy of data in data extracts and data warehouse.
• Monitor system details within the data warehouse, including stored procedures and execution time, and implement efficiency improvements.
• Troubleshoot and resolve data quality issues, database performance issues, database capacity issues, replication and other distributed data issues.
• Resolve database performance issues by looking at query plans, create appropriate indexes, resolve dead locks, and create table hints.
• Troubleshoot and resolve issues in reports, dashboards, and ETL packages.
• Closely work with other IT teams including Analysts and Product Managers to troubleshoot, modify, and enhance existing BI assets.
• Develop, implement, and maintain change control and testing processes for modifications to databases.
• Working exposure to BI platform like Power BI and/or Tableau
• Develop and maintain Cerner custom rules and custom mPages for a variety of modules.
• Develop, modify and maintain Cerner CCL reports and data extracts.
• Develop, modify and maintain complex custom reports on power Insight. Reports & Analytics Ability to generate both standard and ad hoc reports. Ability to design and assist in developing non-standard/custom reports as required. Ability to create CCL reports and set up operation jobs/monitor delivery of reports ad hoc or at scheduled intervals with working knowledge of integrating data to enterprise analytics platform.
• Analyse requests for new reports, rules mPages, or other custom development, and make recommendations related to best practices.
• Follow client\xe2\x80\x99s documented Demand Management process to obtain approval for changes.
• Build changes in a non-Prod domain, work with user to complete testing, and move to production according to the client\xe2\x80\x99s change control process.
• Provide support for projects and other special application initiatives.
• Troubleshoot errors and provide timely and high-quality customer service.
• Document issues and solutions.
• Work with client users and functional teams as needed.

Bayt