Andre Satge Email & Phone Number

Dunellen, Nj, Us

Oklahoma City, Oklahoma, Us

MyCare is a personalized behavioral health telehealth platform created to eliminate barriers to accessing immediate, on-demand assessments and counseling. We've integrated with EMRs and offer real-time GPS tracking, data analytics, and seamless collaboration with first responders, providers, patients, case managers, and others to access licensed, professional behavioral health services anywhere, anytime.MyCare is HIPAA-compliant, giving clinicians an expanded, secure connection across multiple devices. The platform gives providers the capability to document patient care, analyze patient needs, and track lab results and medical records.

Madison, Wi, Us

• Engaged in data integration projects for the health and technology consulting firm’s clients, delivering customized solutions involving Azure, SQL Server, SSIS, and Epic Clarity / Caboodle products and platforms. • CENTURA HEALTH – Lead Developer creating ETL products and data marts to load Epic and non-Epic data into and out of Caboodle. Integrated IBM Analytics software with Epic Caboodle tables, developing Logic Apps solution to orchestrate API calls. Designed database schemas, views, stored procedures, snapshot columns, and slowly changing dimensions. Created measure calculations for HEDIS dashboards.• THOMAS JEFFERSON UNIVERSITY HOSPITALS - Developed scalable and re-usable inbound frameworks for data ingestion with Azure Data Factory. Designed data pipelines to integrate and load hospital / clinical data from Epic software into Synapse Analytics. Ingested Web and API data into ADLS Gen2 data stores with Databricks. Migrated SSIS Projects and Packages into ADF. Incorporated Azure DevOps, GIT, and Jira tools to support lifecycle development.• EL RIO HEALTHCARE – Developed and implemented ETL solutions for the Data Engineering team. Integrated Epic and NextGen data sets, developing and orchestrating ETL workflows and data mart / warehouse loads to on-premise SQL Server and Azure Synapse / ADLS Gen2 environments. Built and debugged data mapping flows, filters, transformations, derived metrics, aggregations, and other calculations.

Yonkers, Ny, Us

• Developed SSIS and Azure Data Factory based ETL software, APIs, and interfaces, integrating legacy medical center systems with Epic Clarity and Caboodle, in support of the Hospital’s clinical, operational, and analytical processes. Led requirements gathering with stakeholders, conforming business rules, metadata, and logical mappings. Ingested and generated file output based on clinical format specs (HL7, HCFA, FHIR).

Brooklyn, Ny, Us

• Developed end-to-end HIPAA compliant SQL Server SSIS ETL solution to replace manual chart abstraction and consolidate all the workflows for PQRS Meaningful Use reporting. Extracted and transformed hospital, clinical and provider source transactional data, delivering output according to various clinical file format specs. Managed the entire project, through test, deployment, and knowledge transfer. Exceeded project goals of 80% automation by delivering a 100% fully automated product. Administered NextGen servers.

Paris, Ile De France, Fr

• Functional, technical, and language liaison between France, New York, and offshore IT teams, for legacy mainframe migration project. Coordinated ETL and application development across various SQL Server and VS releases and versions. Defined logical data maps, and developed SQL scripts for cleansing, conversion, validation, reconciliation, etc. Modernized VBA and MS Access code with dynamic server stored procedures.

New York, Ny, Us

• Led entire SQL Server platform upgrade and migration of standalone servers to virtual instances, as well as re-design of hundreds of complex packages into SSIS. Received DOT award of recognition for carrying out flawless server migrations for critical agency applications with zero downtime. • Developed secure interfaces and APIs between City agency databases (DoITT, FDNY, City Hall, Permits, Bridges, Sidewalks, Signals). Managed GIS databases and supported back-end development of the MTA Train Time application.

New York, Ny, Us

• Administered production SQL Server clusters for Chase Credit Card division. Migrated DTS Packages to SSIS. Enforced stringent JPMC change control and deployment policies. Maintained SQL scripts and SPs.

Psychology

Engineering Science

Data Science For Healthcare