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?s 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?s 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.
