Saikat Banerjee Email & Phone Number

Wellesley Hills, Massachusetts, United States

DEPARTMENT: PEDIATRIC PHYSICIANS’ ORGANIZATIONPROJECTS: DATA WAREHOUSING & ANALYTICS, LEGACY SUPPORT, HEALTHCARE INTEROPERABILITY* Certified in Epic Bridges Interface & Epic Cogito Systems Administration.* Certified in Level 2: Corepoint Integration Engine* Developing different reports using Epic Clarity database, Caboodle data warehouse, SSAS Cubes and legacy data warehouses and publishing on Tableau and SSRS. Created reports for Meaningful Use, Medicaid EHR Incentive Programs and other reports related to COVID.* Handling ETL support incidents on regular basis. SQL development, SSIS package development as needed.* Epic Cogito Infrastructure development & maintenance: Performing Clarity, Caboodle, Cubes, SlicerDicer upgrades & migrations.* Developed views to report efficiency, errors, gaps and volume by linking conversion ODS to Epic Clarity database.* Created reports and dashboards for administrative purposes using Tableau.* Application Integrations using Epic Bridges and Corepoint Integration Engine. Completed integrations with hospitals, medical devices, state registries & agencies.* Designed, developed & deployed interfaces in Epic Bridges and Corepoint Integration Engine.* Expertise in application upgrades, SQL Server upgrades & server migrations including cluster and availability groups.* Handled interface work queues, errors and incidents on regular basis.* Worked with business team and PMO to define project scopes, milestones and timelines.* Actively participated in User Acceptance Testing (UAT), and debugging of systems and solutions. * Performed requirement & gap analysis and identified processes which can be improved and optimized.

Brookline, Massachusets

DEPARTMENT: PEDIATRIC PHYSICIANS’ ORGANIZATIONPROJECTS: DATA WAREHOUSING & ANALYTICS, LEGACY SUPPORT* Developing different reports using Epic Clarity/Caboodle data warehouse, SSAS Cubes and legacy data warehouses and publishing on SAP Crystal Reports and SSRS.* Handling ETL support incidents on regular basis.* Developed views to report efficiency, errors, gaps and volume by linking conversion ODS to Epic Clarity.* SQL development, SSIS package development as needed.* Application Integrations using HL7 in Epic Bridges and Corepoint Integration Engine.

Brookline, Massachusetts

DEPARTMENT: PEDIATRIC PHYSICIANS’ ORGANIZATIONPROJECTS: EPIC IMPLEMENTATION AND DATA MIGRATIONResponsibilities & achievements:* Leading the data conversions team, involve in day to day interactions with clinicians, physicians and end-users to define data requirements, data mapping, modelling and prepare architectural design documents, technical design documents, schema documents etc.* Transformed the data migration strategy into architecture and developed a Operational Data Store for storing standardized and normalized data imported from different legacy clinical databases. Designed and developed all the SQL objects to import, view and export the data.* Analyzing all clinical components present in different databases and map those to target data fields specified in the data warehouse.* Implemented access and change controls on the data warehouse. Also created backup, maintenance and monitor jobs to report all activities on the data warehouse via email/database mail.* Create and maintain database objects like tables, views, procedures, functions using MS SQL Server Management Studio 2014, pgAdmin 4, MySQL Workbench 5.2, Oracle SQL Developer 18.1.0, SSIS packages and SSRS reports using MS Visual Studio 2015.* Designed, developed and deployed SSIS packages to export data from all the legacy databases and import standardized and normalized data into the ODS. Also developed packages to export data from the ODS which can be accepted & processed by the downstream systems.* Working as a certified Epic consultant to map legacy data components into Epic Hyperspace and co-ordinate between Epic team and end-users to finalize clinical workflows.* Installing & maintaining interfaces in Epic Bridges, copy them to different environments, monitor and maintain the conversion work queues. Monitor data conversion interfaces in Corepoint Integration Engine.* Developed views to report efficiency, errors, gaps and volume by linking conversion ODS to Epic Clarity.

York, Pennsylvania

PROJECTS: EPIC IMPLEMENTATION AND DATA MIGRATION, LEGACY SUPPORTResponsibilities & achievements:* Involve in day to day interactions with clinicians, physicians and end-users to understand data requirements, data mapping and prepare technical design document, schema documents etc.* Analyzed clinical components present in Cerner database and map them to target data fields defined by Epic Systems.* Deploying SSIS packages to extract data from legacy systems like Allscripts TouchWorks and Cerner for data migration to Epic Systems. Extracting and transforming data from different homogeneous or heterogeneous systems to Epic using tools like Bulk copy program (BCP), SQL Server Integration Services (SSIS) and Data Transformation Services (DTS).* Create database objects like tables, views, procedures, packages using MS SQL Server Management Studio and Oracle SQL Developer.* Working as a certified Allscripts consultant for ConnectR and AIE interface support, legacy interface performance improvements and error automation in AIE and ConnectR using MS SQL 2012/2008R2.* Developed, improved and optimized T-SQL stored procedures in Allscripts Practice Management Database for increasing processing rate of different interfaces and eliminate manual effort.* Developing clinical and financial reports using SAP Crystal Reports, SSRS, Microsoft Excel etc. and published them for multiple users.* Managing version control and documentation of all SQL Server objects used in ETLs and solutions.* Working as a certified Epic consultant to map legacy data components into Epic Hyperspace.* Actively participating in User Acceptance Testing (UAT), and debugging of systems and solutions. * Performing gap analysis and identifying processes which can be improved and optimized.

Washington, District Of Columbia

PROJECTS: EPIC IMPLEMENTATION AND DATA MIGRATION, LEGACY SUPPORTResponsibilities & achievements:* Involve in day to day interactions with clinicians, physicians and end-users to define data requirements, data mapping and prepare technical design document, schema documents etc.* Working as a certified Epic consultant to map legacy data components into Epic Hyperspace and co-ordinate between Epic team and end-users to finalize clinical workflows.* Installed interfaces in Epic Bridges, copied them to different environments, monitored and maintained the conversion work queues.* Analyzed all clinical components present in eClinicalWorks and Greenway Vitera and map them to target data fields defined by Epic Systems. * Designing, developing and deploying SSIS packages to extract data from legacy systems like Allscripts TouchWorks, Allscripts Professional, eClinicalWorks, Greenway and CodoniX for data migration to Epic Systems. Extracting and transforming data from different homogeneous or heterogeneous systems to Epic using tools like Bulk copy program (BCP), SQL Server Integration Services (SSIS) and Data Transformation Services (DTS).* Created database objects like tables, views, procedures, packages using MS SQL Server Management Studio, MySQL Workbench 6.3 and pgAdmin III.* Worked as a certified Allscripts consultant for ConnectR and GE IDX interface support, legacy interface performance improvements and error automation in ConnectR using MS SQL 2012/2008R2.* Developed, improved and optimized T-SQL stored procedures in Allscripts TouchWorks EHR database for increasing processing rate of different interfaces and eliminate manual effort.* Developed clinical, operational and financial reports using SSRS, Microsoft Excel etc. and published them for multiple users.* Managed version control and documentation of all SQL Server objects used in ETLs and solutions.* Performing requirement & gap analysis and identifying processes which can be improved and optimized.

Hyderabad, Telangana

PROJECT: ENTERPRISE INTEGRATIONS AND DATA CONVERSIONSResponsibilities & achievements:* Interact and work with on-site resources that are responsible for maintaining Allscripts applications at different hospitals and healthcare organizations across US.* Worked as a certified Allscripts consultant for designing, developing and installing different Enterprise interfaces in GE ConnectR and Orion Rhapsody to integrate multiple applications in several healthcare organizations across US.* Developed, improved and optimized T-SQL stored procedures in Allscripts TouchWorks and Allscripts Practice Management Databases for increasing processing rate of different interfaces and eliminate manual effort.* Analyzed all clinical components present in Allscripts TouchWorks and Professional databases and map them to target data fields defined in de-conversion specifications. * Performing requirement & gap analysis and identifying processes which can be improved and optimized.* Created database objects like tables, views, procedures, packages using MS SQL Server Management Studio.* Developing custom T-SQL queries to extract data from Allscripts TouchWorks Database according to data requirements defined by different hospitals.* Developed reports using SAP Crystal Reports and published them for multiple users.* Actively participating in User Acceptance Testing (UAT), and debugging of the system.* Incorporated Lean Six Sigma Yellow Belt concepts for improving quality of projects.

Hyderabad, Telangana

Responsibilities & achievements:* Interact and work with on-site resources to fix issues on different servers and desktops located across the globe.* Provided technical L2 support to end-users and L3 support for complex reach-out incidents.* Attained Wipro Certified ASP.NET Professional certification.

Visakhapatnam, Andhra Pradesh

Responsibilities & achievements:* Interact and work with on-site resources working in different Verizon offices in US to fix issues on servers and desktops.* Provided technical L2 support to end-users and L3 support for complex reach-out incidents.

Bachelor Of Technology, Electronics And Communication Engineering, A

Activities and Societies: * Attended 4 Weeks of Signal Communications (Industrial) Training at Airport Authority of India (AAI). *.

Post Graduate Diploma In Management, Human Resources Management/Personnel Administration, General

Activities and Societies: Worked on a Project titled 'Effectiveness of Training and Development Programs in Sutherland Healthcare.