Mobile : +974-********
IT Application Development, IT Strategies and Planning, Data Quality, CCL, Cerner Millennium Applications, IT Project Management, IT Service Management (ITSM), IT Healthcare, Clinical Information Systems (CIS), Hospital Information Systems (HIS), Cloverleaf, IT Peripherals, JIRA, Oracle ERP, SAP BI BO, Tableau BI, Qlik Sense, Qlik View BIDW, ETL, Data Quality Management, Integration, HL7 Message, Data Migration, HICT.
Extensively Involved and setting up Electronic Referrals Management System for Sidra and PHCC/HMC.
Build and Setup Labels, Wrist Bands, Consent Forms, Barcodes, Work Sheets, Smart Templates.
Successfully implemented more than 2000+ Peripherals devices for Clinical support (Inpatient & Outpatient) including Label Printers, Front end Printers, Back End Printers, Wrist Bands, Palm Vein Scale System, Scanners, Barcode Readers, and Image devices for HIM.
Health Information Exchange Interface
Bio-Rad Unity for Lab
Reconnect Project for the implementation of interface between Cerner and Lawson ERP
Build and setting up Audit Reports on P2Sentinel Applications.
Actively involved and Customizing, implementing and extracting the Cerner Data through Powerinsight Applications to use for creating KPI and Dashboard reports on SAP BO and Tableau BI Tools.
Build and Setup the interface between Bridge and Cerner for Breast Milk Management (BMM) Applications.
Build and Setup the interface using Cloverleaf Interface suite and HL7 message.
Involved and hands on experience in setting up Patient Portal System to access the patient records through on-line which is help to the Patient to see their diagnosis result, Lab results from remotely.
Actively involved and managed the implementation of ICD 10 AM Code transition from ICD 9 and SNOMED CT Code.
Successfully implemented the Patient Level Information and Costing Systems (PLICS) Project for Finance .
SharePoint Portal Development
Interface between Cerner and Oracle ERP system.
Advanced Supply Chain Management (ASCP) System
MBA, M.Sc., (Computer Science), ITIL
Post-Graduation in Information Technology with around 26+ year’s experiences in IT industry on utilizing my experience in various positions such as Senior Specialist - Reporting, Clinical Applications Specialist, Digital Transformation Specialist, Clinical Informatics systems Specialist, Techno Functional Consultant for Oracle ERP (E-Business Suite R12), IT Strategy and Planning,Integration Specialist, Change Management(CAB),IT Management, Consulting, Quality Process improvement, Quality Management, Business Process Management (BPM) Systems Development, Testing and Data Quality Lead.
Having 12+ year’s experiences on Senior application Specialist on the implementation of Cerner Millennium (CIS/HIS) applications such as (Powerchart, Firstnet, CPOE, Power Orders, Power Notes, ERM/ESM, Pharmnet, Supply Chain Management, Revenue Cycle Management, Contracts Management, Surginet, Oncology, Radnet, Pathnet, Power Insight, Dynamic Documentation, and XR Reporting)
Worked as a Data Quality Lead with experience as IT Consultant on the setup of Data Warehouse (BIDW), Data Management, Data Migration, ETL, and all System Testing.
Having 9+ year’s experiences on Technical & Functional Support for the implementation of Oracle ERP EBS R12, D2K Forms and Report Tools, SAP BI BO, and Microsoft GP ERP Solutions.
Actively involved and managed implementation of many larger projects such as SAP BI BO, Power Insight, and Gettinge, TDOC, Pyxis, Swiss log systems, and implementing the Clinical/Hospital Information System (Cerner Millennium) for Sidra Medicine, Hamad Medical Corporation, Primary Health Care Centers and Tawam Hospital.
Professional Certifications/Exams: Power Insight, Tableau 10 for BI, Python, Erwin Data Modeling and RDBD, SAS Analytics and BI, SPSS, SQL Server, PL/SQL.
And also having hands on experience in CCL (Cerner Command Language), HTML, VB, SQL Server, ASP, C++, Java, Oracle DBA and PL/SQL, Microsoft Power BI, MS Visio, Big Data Analysis, HP ALM (Automation Tools), ITSM tools, and Agile Framework Methodologies in Project Management.
Experience in Hardware/ Connectivity Network knowledge
Nellai Trading & Contracting Services LLC
Senior Consultant (Oracle ERP System)
August 2019 – Present
Currently working as Senior Consultant for the implementation of Oracle EBS R12 ERP System.
Technical and Functional support for the implementation of HRMS, Payroll, WMS Warehouse Management System),I-Supplier, Mobile Supply Chain Management (MSCM), Inventory Optimization, Order Management and Advanced Supply Chain Management (ASCM)
Build and support for the implementation of Oracle Advanced Planning, Demand Planning and Global Order Promising.
Support for Configuring iPayment, Receivables GL, and Budgeting and Planning implementation.
Build all MD,BR and RD documents (MD050, RD050,BR100 and BR030).
Senior Specialist CCL - Reporting,
Clinical Applications Department, IT Department
May 2014 – June 2019
Setup and Build on all Clinical Applications in Cerner Millennium (EMR/EHR) and provide SME on all Clinical Informatics system and perform all programming.
Create new CCL programs and maintain the existing Cerner standard CCL (Cerner Command Languange) programs for Clinical including reports and data extracts.
Build and Setup all label programs to use for Inpatient & Outpatient system in Hospital (Registration, Scheduling, ADT, Pharmnacy, Radioly, and all Pathology labels).
Responsible for maintaining and writing new EKM rules in Cerner to automate tasks that will result in increased patient safety and improved care
Extensively involved and rollout of an Electronic Referrals (EReferrals) System for transfer the patient appointments information Primary Health Care Corporation(PHCC) Centers or Clinics / Hamad Medical Corporation Clinics to Sidra Clinics
Sidra CCL Lead for the design and implementation of a Health Information Exchange solution(HIE) which integrates summary level patient clinical information from primary and secondary care providers in Qatar and is made available to clinicians at the point of care.
Creating KPI Reports and Analyze Data using SAP BO Web Intelligence and Power Insight.
Setup Users and user profiles for access of SAP BI BO.
Build Smart Templates to retrieve clinical data, PowerForms data etc. using CCL scripts.
Create Dynamic Documentation incorporating CCL Smart templates, Bedrock smart templates and create Auto Text using CCL and HTML.
Create Custom Component for MPages using CCL and HTML.
Good experience for setup Core functions on Bedrock application
Having experience to upgrade the Bedrock application and Mpages 6.2
Configuring and Managing HIE system
Development of using Cloverleaf Integration suite
Providing solutions using CCL in all possible areas of applications in Cerner.
Creating Helix Flat files involving CCL and VB Script.
Configuring Surginet Reports thorugh SNreport builder tools
Creating and Maintaining CCDA document
Configuring the CCDA interface Setup in SI_Manager
Configuring and Managing all opsjobs and opsjobs templates.
Having good knowledge and experience on Cerner Nodejs, JSON and XML
Having good knowledge for Gathering and Analysing with the clients and their requirements.
Successfully implemented from ICD9 AM code to ICD 10 AM transition project.
Successfully implemented the Reconnect project for the interface between Pharmacy and Lawson ERP.
Successfully implemented the Patient Level Information and Costing System (PLICS) project using custom CCL script.
Involved in designing, customizing,developing and implementing the Patient Demographic Banner settings.
Actively involved in System Testing, Functional Testing, Unit Testing, Integration Testing, Peripheral Testing, Performance Testing, Post and Production System Validation Testing.
Successfully Built the Infection Control Reports (Medium and High Alert Controls)
Build and Setup the Mpages for Womens health, Pediatrics and Ambulatory Clinical Worflow summary.
Involded in developing and customizing the Visit Summary for Pediatrics and Womens Health.
Successfully build and implementing all Discharge Readiness Reports.
Involded Configuring and implementing all peripherals for IP and OP services in the Hospital (Label Printers, Scanners, Palm Vein scanners (Biometric scanners), Image RIO, Nice Label Printers, and Leica Cassette Printers,
Having good knowledge to build and setup all clinical workflows in Pathology, Pharmacy, Core Applications build, HIM, Carenet, Ambulatory workflows, Power Forms, Power trials, Clinical Documents, Radnet, SCM and Revenue Cycle Management, Charge Build, and Physician Docmentation workflows.
Responsible to creating the reports through CCL scripts in Cerner (Millennium) for all modules.
Successfully creating and implementing on all types of Labels, Reports, Wristband Labels and Blood Bank Tags as per the Requirements for the Hospital .
Responsibility to design, develop and troubleshoot of Cerner Millennium Applications
Developed, customized and implemented the Pharmacy Batch Labels (IV-Intermittent, IV Continuous, and Unit Dose labels, and Batch Reporting).
Involved in developing, customizing and implementing of all Laboratory Labels (All Specimen Labels, Slide Labels, Cytology Labels, AP Specimen Labels, Micro Labels, Histology and Cytology specimen Labels, Helix Blood storage Bin labels and Blood Transfusion Tags and Labels ).
Successfully design, develop and Setup KPI Dashboard and Audit reports for reducing the Patient average waiting time to calculate based on the Patient Visiting Time, Patient Length of Stays (LOS) and Average Waiting Time for ED.
Developed Cerner Dashboard system and Decision Support Ssytems.
Built all types of codes for Billing and Charge Master like LIONC code, HCPCS, CPT Procedure code, Gren Rain Code, IR-DRG Code and ICD 9 & ICD10 AM Diagnosis codes.
Create the Audit reports to validate between the RDM data (Staging Server) and Cener DCW.
Collect all relevent data by defining data requirements and data collection process
Design and implmentation of reporting analysis solutions using SAP Business objects
Create the Scripts to run on HP ALM (Automation Tools, Load runner) to troubleshoot the system performance.
Involved in Developing, Customizing and implementing the Change Management Services using HP ITSM tools Incident Management (IM), Request Fulfillment (RF), Change Request (CR), RACI, and Change Proposal (CP)..
Create document for IT business processes and Procedures.
Prepare IT Policies and Procedures, Business analysis and customer service management.
Prepare training materials for incident Management reports,Request fulfillment, Change Log request, and KPIs on HP ITSM tools.
Designed and maintained the JIRA tools (Agile functionality services) for issues and project tracking tools
Analysis the current business requirements for clinical systems and preparing the source data extract template and make sure this templates will extract all datas which is satisfies with enduser.
Prepare Data Quality Reports and Assessments (KPI report will be generated based on the Management Requirements)
Having good experience to collect, Design and Develop all the MPages, Templates and Physician documents from End User, Application Analyst/Project Analyst requirements.
Involded in developing the flat files using on VB Script and CCL Script for HELIX Protocols worksheet for Pathology department projects.
Developing and customizing the interface TDD for Inbound using OPPE, HL7 Message and Cloverleaf Integration Suite.
Successfully built all clinical documents through content management.
Successfully collect and maintain the PEARL CCL request from the end user and to build their requirement.
Successfully deleiverd all clinical reports, HIM Reports and Audit Reports.
Involved in design, build, customizing,configuring, testing, and troubleshooting experience on Cerner Millennium Applications.
Dell services (Qatar)
Hamad Medical Corporation, Qatar
Data Quality Lead (Data Warehouse)
October 2012 – June 2014
Collect all relevent data by defining data requirements and data collection process
Design and implmentation of reporting analysis solutions using Business objects
Data Mapping: Analysis the source data to complete the data mapping by discussing with the business users
Addressed inconsistencies between mapping documents, ETL specifications, and business macro design documents for the client, helped profile data to ensure data quality and useful content
Develop ETL rules for each subject area from various source systems.
Analyze the current source systems of HMC/PHCC and create the source data extract template to use for extract all datas which is satisfies the Source system, HL7 Message format and the Target system.
Analyze and compare from the current legacy system (Medicom and EMR viewer) and provide Data Quality Report.
Create and implement business rules on Legacy data to migration.
Verify extracted data and deliver data quality report.
Review and approve extracted data to proceed Transformation.
Provide data quality improvements and suggestions.
Identification of Duplication records (Patient) and Merge process.
Overall responsible on Source data to be migrated.
Verify migrated data in backend through CCL reports.
Verify transformed and migrated data in Cerner Application.
Analysisng all the source systems datas and create the reports on governance team to measures all the critical data in the source system and analyse and assessment for the clinical areas which will be migrated to the Target system Cerner CIS Solutions and other 3rd party Applications like 3M, My Care (Patient Billing), Oracle ERP, Gettinge (Cssd Applications), and ipurse (Budget Control).
Create manual document for Data Quality Improvement Plan (All Current Business activities and guidelines to improve their quality of Data)
Prepare Data Quality Reports and Assessments (KPI report was generated and impnenting the process for corrections)
Idetification of the Data migration/Preparation needs, prepare proper templates, Validate data before and after upload
Identify the user requirments for training, prepare training documentations, conduct training as per project guidelines
Validation Data Profiling Reports
Create all Dash Boards and BI reports using SQL, Miscrosoft Power BI)
Create ‘AdHoc’ Reports are generating for the management through powerfull tool (SSRS)
Create Data Validation reports
Prepare the complete project plan activities to implement of CIS solution
The data has been checked by Quality, Mapping all the fields with legacy system into target system throiugh HL7 message format.
Create & verfiy of all test plan activities, Test tresult documents and Test reports
Identify the high level scope of testing required within each trail load
Create Scripts and documents for trainers and End users reference.
Create the CCL script to validate the trasfer data from Legacy into Target system (Millennium) for all modules.
Develop the Adhoc reports to keep track for the migration data from Target system and validate each and every applications in Cerner Millennium with some screen shot also take for verification and this report will provide into the customer verification.
TAWAM Hospital (SEHA), Al-AiN, UAE
Senior System Analyst/ HIS Application Specialist, ERP Technical Specialist
Oct 1996 – Dec 2012 (16 Years)
I had actively participated in establishing IT department (Year 1996) and implementing various IT systems required for Hospital, successfully delivered around more than 25 strategic projects . I have joined as a System Analyst and promoted to and handed various strategic roles and responsibilities in IT. And I had worked with the following major departments/sections in the Hospital IT division.
1.Materials Management and IT Supply Chain Management
2.Vendors Management and IT Procurements
4.IT Strategic Planning
5.Project Management Office (PMO)
7.IT Finance and HRMS/Payroll Services
8.IT Budgeting and Billing
10.Biomedical Division – IT Services
Technical and Functional Support for the full cycle (SDLC Cycle) implementation of Oracle ERP (EBS) R12 including Oracle Financials, Oracle SCM, and Oracle HRMS/Payroll
Setup Warehouse Management System (WMS)
Implement I-Supplier and I-Payment
Setup Mobile Supply Chain Management(MSCM)
Build Inventory Optimization - (Min-Max Planning, EOQ)
Successfully implemented the Advanced Supply Chain Management (ASCM)
Technical and Functional Support for full cycle implementation of the interface between Oracle ERP- EBS and Cerner Millennium Applications (Pharmacy, Supply Chain Management, Charge Services, Billing and Revenue Cycle Management)
Successfully Implement the interface between Cerner Pharmacy Requisition into Oracle Purchase Requisition.
Setup and migrate Item master, Vendor and Manufacturer profiles into Cerner and Oracle ERP
Build Forms and Reports using D2K report tools.
Create Audit reports to cross verify the activities of both stock movements and Issues.
Build all MD, BR, RD (MD050, RD050, BR100, and Br030) Documents for the End user reference .
Build KPI reports to analyse the interface applications data such as Pharmacy, SCM and Finance (GL) .
Setup the Par Level for implementing the inventory optimization methods
Technically support to build reports and queries on PL/SQL, Oracle Reports, Oracle Forms, and Oracle Workflow, XML/BI Publisher, Alerts and API.
Good experience in design and development the Integration and Data Conversions.
Senior Application Analyst for implement the Cerner Millennium Hospital Information Systems (HIS) Project
Responsible to setup all Core functions
Responsible for configure all Routings and Contributor system Alias
Setup All orders Catalog, Power Plans, Demographics Banner settings and Clinical Event Creation
Good Knowledge to update all conversation and Document Routing on Registration Management
Responsible for setup Appointment Type, Department setup, Resources for Scheduling Management
Good Knowledge to setup all Inventory Locations, Locators, and Surginet Preference Cards
Responsible for creating the Formulary items, Fill Batch Parameters, Remapping of Formulary Products to Order catalog and Add or Remove IV sets and Medication Order sets.
Good Knowledge to setup for Post–Acute Organization Relationships and Organization Linking
All old system data was successfully migrated.
Responsible for mapping all old system data to the new system Cerner & Oracle ERP.
Good Technical Knowledge of PL/SQL, SQL, Oracle Reports, Oracle Forms, and Oracle Workflow, XML/BI Publisher, Alerts and API
Good experience on implementation of Oracle EBS R12
Design and Development experience with Integration and Data Conversions
Perform on Functional support in Finance, SCM, HRMS, and Manufacturing
Expertise on collecting user requirements, map those with product features, Gap Analysis and recommendations for process changes/customizations
Expertise and experience on the Powerinsight (BI Tools)
Follow the implementation project documentation process and documentation preparation
Planning and performing CRPs and working with end users for UAT
Identification of the Data migration/Preparation needs, prepare proper templates, Validate data before and after upload
Identify the user requirements for training, prepare training documentations, conduct training as per project guidelines
Responsible to setup the ETL functions and successfully transform through SQL Server.
Successfully completed all quality check while transformed the data with right data in right place.
Experience on the implementation of Clinical Charge Services team to review, update and upload Charge Description Master (CDM) related attributes of clinical solutions and patient services.
Expertise as Integration Specialist for billing & charging master to setup for Pharmaceutical items with Green Rain Code (GRC) and for Medical consumables are matched with the proper Healthcare Common Procedure Coding System (HCPCS Code) to use for the billing areas mainly like Cathlab, Endoscopy, Nuclear medicine, Occupational therapy & Operation theaters.
Setup the Organizational approval Hierarchy in HR system depends on their positions.
Supported the development of Asset tracking system
Supported the area of procurement, Logistics, Pharmacy and Finance (Cerner, ERP Oracle )
Tracked all information about Invoice Matching with Receiving profiles and Purchase Orders.
Maintained the Purchase Requisition enquiry through On-Line
Prepared all reports for Supply Chain Management, & Pharmacy.
Created and Maintained the Stock item on stock master
Implemented the method for re-ordering the items (Consumable & Pharmacy) by ROP & ROL method in Cerner Millennium.
Implemented & Trained to use of the online requisition through Cerner & Oracle for the end user
Prepared annually Physical Count on Cerner & Oracle
Prepared document and scripts for End user training and Train the Trainers.
Developed the test script for Unit Test, System test, and Functional test
Maintained the Vendor Information and Manufacturer Information applications in Cerner & Oracle.
Developed the reports of all transactions by Cost Center and by Sub-Accounts
Maintained the report and issues log for all computer related programs for Supply Chain Management, & Pharmacy related issues.
Maintained & managed all the functions related to Item master, vendor information, manufacturer information, Main OR (Operation theatres) pick list items with insurance information in Cerner.
Successfully implemented and support for the Charge Services module in Cerner Millennium.
Maintained all tasks related to SurgiNet module with SCM.
Created & maintained the Cost centers & Sub-inventories in Cerner.
Very Good experienced to setup all functions like Ops-Jobs, & through coded on CCL Programming in Cerner to extracted the data from back end as delivery.
Senior System Analyst/Programmer for the In-house developed applications to use for the Hospital (for Healthcare)
Developed and Managed ADT Application for Admission and Clinical department
Build ER Application system and setup to use for Emergency department and Recovery Room.
Developed Radiology Procedure applications and Stock Control System to use for Materials Management department and Radiology department.
Build and implement the Procurement Applications to use for Tender, Bids, Short Tender, Contracts and Purchase order preparations, Shipment Clearance, Vendor Management.
Build the core application for Centralized Oncology Patient registry System
Successfully develop and implement TOL (Tawam On Line – Intranet)
Build Pick list and setup Stock Control System for OR Department
Develop core applications: Centralized Inventory Control System (Receiving, Distribution, Inventory stock, Monitoring Vendor Management, ROP, ROL, Requisition and Blanket agreement)
Developed and successfully implemented HR System and Payroll System to use for HR Department (Employee information, Appointment letters, Contracts and etc.)
Developed EHC System (Employee Health Clinic system) to use for EMR/EHR
Create and setup Asset Management System
Setup the Insurance / Revenue /Denial System to analyze the Billings, Charges and Denial rate of the Insurance scheme.
Al- Razi Pharmaceuticals Co., Al-Ain, UAE
Dec 1994 – Jun 1996 (2 Years)
Built and implemented the system for planned preventive Maintenance program for hospital use.
Developed Stock Control System to maintain the entire Pharmaceuticals product with Expiry and lot numbers.
Implemented payroll system for the Al-Razi staffs
Developed and maintained all finance related information are in FoxPro applications.
Developed reports for management request.
Techno Computer Prints PVT. Ltd
Apr 1993 – Dec 1993
Developed the package of Import and Export system for client requirements. And this project was implemented within 6months durations and successfully implemented.
Sikkim Manipal University
Bangalore, Karnataka, India
Master of Business Administration (MBA)
Trichirappalli, Tamil Nadu, India
Master of Computer Science (M.Sc.,)
Trichirappalli, Tamil Nadu, India
Bachelor of Computer Science (B.Sc.,)
Certifications and License
Certified Python Programming Language
Certified Tableau 10 & 2018 for Business Intelligence (BI)
Certified Six Sigma (Master of Black Belt)
Certified ERwin Data Modeler and Relational Data Base Diagram
Power Insight Advanced Training
Certified for the achievement of Joint Commission International Accreditation (JCIA), Tawam Hospital
Certification of Appreciation for HIS implementation Systems Project (Cerner Millennium) from Tawam Hospital
Certification of Appreciation for Oracle ERP – E-Business Suite implementations for Tawam Hospital
Certification of Appreciation for HIS Data Migration(ETL Migration into Cerner Millennium)
Certification of Participation for Cerner Middle East Regional User Group Meeting on April 2012.
Certification of Appreciation for successfully given the Training for the Clinical end users at Al Rahba Hospital and involved Go-Live support for implementing HIS System for Al Rahba Hospital, Abu Dhabi, UAE.