Lisa Chen Email & Phone Number

• Working at HR, to create dynamic store procedure to calculate employees’ incentive commission payment with Caliber’s rule.• Create SSIS package to load Retail and Non-Retail commission data from SFTP to SQL Server commission database tables. Create ICP metrics .csv file using dynamic sql. Then Load to Xactly every month. • Passing variables Load_Flag value using Execute SQL Task container to check ETL Status.• Using Xactly Incent UGI tool to maintain Employee’s organization tree and calculate commission payment.• Set up user’s account & profile information using Xactly Incent• Customer server using server-now ticket system

• Successfully updated BCBS, Cigna and Aetna Health insurances financial data of IPANS to Sql Server 2019 every month. • Using health insurances’ raw data to do data analysis and to create excel reports and Power BI reports under clinic group business requirement.• Using Diag-code and CPT-Code knowledge to create payable by various insurance expenses for patients with diabetes using Excel and Power BI. • Using members and attributes providers’ health insurance raw data to create PMPM (Per Member Per Month) chart reports using Excel and Power BI tool.• Successfully loaded each clinic office Patients’ ECW data to Sql Server 2019.• Comparison ECW and Availity systems raw data and create comparison report with business requirement.• Using MCP and MCT knowledge of BCBS health insurance to build business model of IPANS and made MCP value down.• According to the high CPT paid value to IPANS Providers by health insurances, using SQL Query to look for Insurance paid value of IPANS which was not match standard. • Created SSIS package to check if source file(Health IX .txt file) exist, then add to Sql Server 2019 database table.• Created Health IX daily report with patients’ attribute providers information.• Created SSIS package for LabCorp .txt file using complex SQL query, then remote loaded file to LabCorp SFTP server using FileZilla.• Using Smartsheet to track more details and hold team worker accountable for the tasks • Using Dax and Power query to create Measure with LY YTD values etal.• Create Power BI report with filter, chart, then Public report to clould• Configure connection manager of CData D365FinOp and D365BC, using CData to extracted source data from Azure.• Using SQL query to do Data Source performance turning with large data source set • Extracted data from EntityDataSource. • Using the input variable and executing the SQL statement using the EXEC command

Bachelor'S Degree, Computer Science

Master'S Degree, Computer Science, Grade