• Work on MGB high operation value projects to provide data analysis and curate data extracts for operation dashboard and quality improvement used by top executives and business operation leaders.• Built complex data analysis and metrics for required daily COVID-19 data submission required by MA DPH (Department of Public Health) and federal government in order to provide treatment and care to patients affected by COVID-19• Create operational and project-related reports for implementation and ongoing support of the Epic Cogito Clarity Application• Write complex SQL programming code to pull critical data elements from various Clarity data models and build ECI/Business Objects Crystal Reports for end users. • Create highly-complex extracts for internal and external requesters using Epic / Clarity data. The extracts include HB rev cycle and PB charge/payment/denials daily transactions, 340B and other Pharmacy related extracts, Clinics and Operational process, encounters, emergency room, lab, medications, radiology/imaging, referrals, OR/surgeries, obstetrics and physical/occupational/speech therapies, etc.• Collaborate with product/business owners, EDW and various teams to build enterprise clinical operational dashboards.• QA and data validation on Clarity to Caboodle data transformation• Work collaboratively with Build Team to perform gap analysis relative to current and finalize report and extract scope • Participate in project meetings as a key contributor with stakeholders from clinical and non-clinical operations• Communicate with various levels of Business and end users to gather requirements and Business needs and translate them into data reporting requirement.

Recovery Compliance Reviewer (remote)Shelter service team member (based on need)

• Supported multiple Go-live reporting on various hospitals under the same large health system - U Penn Medicine.• Converted many legacy reports into Business Objects Clarity reports for various go-lives.• Write complex SQL programming code to pull critical data elements from various Clarity data models and build Business Objects Crystal Reports for end users. • Reporting for both financial and clinical data models such as HB, PB, UB Claims, Optime, ED and Trauma, Inpatient, Ambulatory, Radiology, HIM, Willow, Stork, Transplant, Homehealth, etc.• Communicate with various levels of Business and end users to gather requirements and Business needs and translate them into data reporting requirement.• Create large complex data extracts to replace the internal financial data repository originally supported by internal legacy system as well as for outside vendors. The extracts include HB UB-04 claims, Theradoc, 340B Pharmacy extract, Neurology Practice Based Research Data Extract for Northshore Health System, Operational process, encounters, lab, medications, radiology, etc.• Independently worked large high visible research projects and QI projects, such as radiation treatment of cancer, Optime ERAS Outcome, Opioids Usage in Surgeries/during Hospital Stay, Quality Measures, Nuclear Stress Test for Patients with Chest Discomfort in ED, Respiratory Therapy Protocol, etc. Became coauthor from one research project which abstracts got accepted as a poster presentation at AHA and ACC. • Helped various team members on reporting questions and needs.

• Lead Clarity reporting consultant on assignment to Grady Health System on all data modules including HB, OR, HIM, Williow, ED, Inpatient, Ambulatory, Radiology, Cadence, Beaker, etc.• Lead consultant on current client’s ACO/PQRS, PCMH quality measures and related data extracts for annual/quarterly submission and reporting.• Lead developer for current client’s ICD10 Clarity reports conversion• Create and build major datasets from EPIC Clarity for client’s Qlikview applications on labs and surgical procedures and pharmacy • Create and build complex data transfer process through SQL stored procedures, SSIS packages to transfer hospital EMR data to vendors.• Monitoring the daily Clarity ETL and ensure Clarity tables data integrity. • Create complex stored procedures to extract and analyze clinical and healthcare financial data stored in EPIC Clarity databases • Upgraded to Clarity 2014 in May and did all the ground work relating to Clarity reporting before and after implementation• Perform QA functions to validate the SQL code created by other consultants, verify the result and publish the stored procedures and reports to the production environment.

• Lead Clarity reporting consultant on assignment to a major hospital in Southeast on all data modules including HB, OR, HIM, Williow, ED, Inpatient, Ambulatory, Radiology, Cadence, Beaker, etc.• Lead consultant on current client’s ACO/PQRS, PCMH quality measures and related reporting.• Lead developer for current client’s ICD10 Clarity reports conversion• Create and build major datasets from EPIC Clarity for client’s Qlikview applications on labs and surgical procedures and pharmacy • Create and build complex data transfer process through SQL stored procedures, SSIS packages to transfer hospital EMR data to vendors.• Monitoring the daily Clarity ETL and ensure Clarity tables data integrity. • Create complex stored procedures to extract and analyze clinical and healthcare financial data stored in EPIC Clarity databases • Upgraded to Clarity 2014 in May and did all the ground work relating to Clarity reporting before and after implementation• Perform QA functions to validate the SQL code created by other consultants, verify the result and publish the stored procedures and reports to the production environment.

EPIC Certified Clarity Reports and EMR Systems Reporting Programmer.• Years of experience in writing various in-depth clinical, financial and analytical reports on Clarity inpatient, Willow, ASAP and Optime and across different applications and modules, like to ADT, Candence, HB, etc. In-depth experience working on clinical research grant and projects to analyze the complicated data on patients treatment. • Create complex stored procedures to extract and analyze clinical and healthcare financial data stored in EPIC Clarity databases in addition to other EMR databases.• Lead developer for the Meaningful Use Federal Government Reporting Project.• Create and publish customized reports for end users in SSRS (SQL Server Reporting Services) and Crystal Reports versions XI and 2008. • Develop PL/SQL to extract clinical and healthcare financial data stored in Oracle system.• Work closely with business analysts and end users to gather data requirements, validate reports and document the detailed technical specifications for reports and BI applications.• Perform QA functions to validate the SQL coding created by other developers, verify the result and publish the reports to the production environment.

• Program in SAS to analyze very large quantity and complex data relating to US consumer credit, commercial credit, employment and income to assess to quality and value of the data • Perform in-depth and advance data analysis to facilitate strategic decisions for company management. • Collaborate, code and validate TALX annual income attribute for Premium CPR project.• Apply data mining techniques to identify and analyze new and existing data using SAS and BI tool – Qlikview• Build dynamic ROI reporting dashboard using Qlikview to leverage various data for senior management• Optimize the performance reporting , provide insights on data findings and made recommendations to leverage the data knowledge and improve business process and performance• Interface with internal department and data vendors to gather business requirements, design projects and solutions, manage expectations of effort and scope, develop and implement the strategy for data analysis.• Design, program and create monthly/quarterly data analysis reports or metrics for company management. Automated the regular reports for various departments for better tracking of business performances. • Update and maintain property dataset on the server• Participate in the design, load, update and maintain of data sand box from heterogeneous data sources into SDA server• Write final reports to summarize data analysis projects and present results to senior management

• Performed Database Development involving the creation of complex stored procedures for application reporting and data analysis.• Administered and managed the CRM system (Epiphany) to implement the company email campaigns.• Developed and maintained extraction, transformation, and load (ETL) routines for importing data from heterogeneous data sources into the SQL databases. • Interacted with Marketing, IT, and Customer Care department to gather business requirements, design solutions, manage expectations of effort and scope, develop and implement the data system for business intelligence tools and analysis.• Programmed in SAS to extract data into the SQL database to support BI tool. Design static and customized drill down report queries for end users.• Programmed in SAS to perform in-depth data analysis on company’s business performance and provide insights for customer acquisition/retention strategy as well as marketing promotion and campaign plans.• Used TOAD to pull data from Oracle Data warehouse and created analytical reports for management.• Worked with application developers and developed a database system of NetBank’s customer segmentation tool to evaluate customer risk factor. It provides a GUI for profiling of customers by creating 360 views of customers. The system interfaces with various systems such as DDA, mortgage, upsells using web service.• Worked as Database Designer, Administrator and Team Lead for CRM database. Developed, configured and implemented customer segmentation for email campaigns utilizing E.piphany Campaign Management and Real Time Interaction Advisor.

• Worked with Business, Marketing and Sales teams to gather and validate business requirements for new applications and enhancements, and to determine the design of relational databases for the reporting system• Performed quantitative data analysis on large amount of data to suggest performance measures to report to clients for improved product performance to assist the Sales and marketing team.• Analyzed baseline data and integrate checks and balances into the loading process to validate the data• Created and Automated SQL Server jobs utilizing DTS, triggers and T-SQL stored procedures to migrate data from a staging environment, through the Data Warehouse, into various data Marts for analysis purposes• Lead Developer for Data Warehouse responsible for Design, Implementation, and Maintenance utilizing SQL Server technologies.• Created, debugged and tuned varied complex T-SQL stored procedures to support the Data Warehouse, Data Marts and application reporting. • Automated the data reporting and created customized drill down reports in the BI system for users• Developed and maintained extraction, transformation, and load (ETL) routines for importing data from heterogeneous data sources into the data warehouse. • Optimized the performance of data marts and business intelligence applications by analyzing problem areas.• Performed DBA functions for the SQL Server environments including Backups, Database Creation, Table Creation, Capacity Planning, and More• Created a star-schema data model to allow efficient data access

• Programmed in SQL and mainframe to analyze the Florida Medicaid data on pharmacy spending and disease management such as diabetes, hypertension, sickle cell, etc.• Built Florida Medcaid data mart using SQL server from various OLTP for centralized analysis and reporting• Created and coded complicated programs on mainframe with JCL on annual Medicaid procedure codes and set annual physician’s fee schedule. • Programmed in SQL to perform quantitative data analysis on the large amount of data and produce ad-hoc reports for various departments.• Used SQL Server ETL, Business Objects, Fox pro and MS Access to access various data sources through ODBC or direct database connection. • Used Business Object to create and analyze Medicaid data.• Gathered and Validated reporting and analytic requirements from End-Users and delivered the reports via ACCESS, Excel, and Fox Pro• Used frequency, random sampling and other statistical method to validate data to ensure data consistency and accuracy.

• Gathered and Validated reporting requirements from Business Analysts and created the reports in ACCESS and Excel• Performed data analysis on the state wide mental health data through UNIX data system and ACCESS.• Used Query Facility (Oracle reporting tool) and SQL to extract mental health care and substance care data from the data warehouse resides in ORACLE in UNIX environment.• Converted extracted data into ACCESS or Excel format for reports • Communicated with end users to explain reports generated on their behalf, such as data source of raw data, intermediate steps, methodologies, the final reports, etc.

• Used ACCESS to design a relational database to manage and analyze employment survey data • Programmed d-base to track the occupational employment data• Performed data analysis on Florida employment data system.• Used SPSS to analyze employment and wage data. • validate quarterly report of employment and salary to the federal government