Managed ETL data pipelines from Epic Hyperspace -> Cache database -> Clarity database -> Star-Schema Caboodle data warehouse. Optimized ETL processes in Epic Cogito Eco Systems resulting 60% reduction on ETL completion time after the first major upgrade. Developed custom data pipelines using SSIS to bring external data into Caboodle (ex: commercial claims, CMS data)Managed reporting content and tools in Epic Cogito Eco environment for Reporting & Analytics team; configured and customized Epic SlicerDicer, SSAS Cubes and Business Objects Universes as well as managed data access for SSH data usersWorked with DBA and System Administrators teams to maintain and upgrade Epic Cogito BI suite; ensured successful data loads to provide timely data service for SSH users after each upgradeTraining and certification:*EPIC Clarity Administration Certified 2016*EPIC Caboodle Administration Certified 2016*EPIC Caboodle Development Certified 2017*Attended SAP Official Training: SAP BusinessObjests Business Intelligence Platform: Administration and Security (BOE310)

Develop SSRS reports with focus on Compensation and Performance; UI and Stored Procedures development; Performance tuning in SQL/T-SQL

Epic EMR system implementation: analyzed and identified the data gaps between legacy systems and Epic, proposed recommendations. Successfully designed the first integrated pharmacy data model after Epic implementation in 2015.DFCI Research Data Warehouse Remediation: data architecture, data model, data process flow re-design and optimization. Acted as the key resource of EPIC data with focus on Beacon (Oncology), Willow (Pharmacy), Inpatient Orders, and integrated Epic data into DFCI Research Data Warehouse (OncDRS) with legacy and Partners Enterprise Data Warehouse (PHS EDW) data

Analyzed and designed MinuteClinic data warehouse pilot using Ralph Kimbal multi-dimensional data model (STAR schema); created SSIS packages to extract, transform, and load (ETL) data from multiple relational databases on different servers to fact/dimension tables in MinuteClinica data warehouse.Conducted gap analysis for the key MinuteClinic Executive Reports during the Epic implementation project; successfully identified data gaps and recommended solution to close the gap between legacy and Epic data was accepted by leadership. Managed, created, and maintained MinuteClinic provider database for 20+ affiliates and data vendor concurrently; optimized provider data management process to support ePrescribing project; led end-to-end testing efforts across MinuteClinic, data vendor, and affiliates to ensure data integrity and successful clinical message routing; designed and created scripts in SQL for production support team to track updates, ensure data quality, and provider activation.Training:SQL Server Analysis Service (SSAS) 2012, Pragmatic Works, Woonsocket, RISQL Service Integration Service (SSIS) 2012, Pragmatic Works, Woonsocket, RI

Coordinated with 40-person senior management/clinical team to design and implement workflow into UniCARE/Pro-filer EMR covering 30 clinical/billing use cases and 80+ programs across the agency. Anticipated 30% error reduction accompanied by dramatic improvements in workflow efficiency.Designed and constructed budget tracking sheets and analysis model in Excel to identify the financial break even point, incorporating labor costs and reimbursement. Identified workforce configuration as root cause of financial losses through scenario modeling for EI program.Architected and implemented the Emergency Services real-time client tracking system for Triage call center. Efficiency improvements through facilitating work progress and real-time patient tracking.Researched and developed the solution to implement the custom built HTML forms and Crystal reports into UniCARE/Pro-filer EMR.Training:Crystal Reports 2008 Level I, New Horizon, Framingham, MA

OTC transaction monitoringRisk Management Information Systems

Company marketing products promotion and sell

System Analyst: Gathered, coordinated, and analyzed business requirements across different teams within corporate finance division; converted business requirements into technical specs, designed pseudo code & test cases, instructed developers on the code change and assisted users with UAT.Developer: Developed 24-HR Banking Information Systems, including real-time and batch programs utilizing COBOL, CICS, JCL, SQL in IBM OS390 mainframe environment.Administrative tasks:Designed and organized training curriculum for 500+ IT staffsManaged 20-person IT consulting team on-siteSupported Compliance Department for internal auditing in compliance with ISO/CMMI standard (CMMO Level II certified) on behave of development team*Best Corporate Internet Bank Award”, 2004 & 2005, Global Finance Magazine