Nam Lee Email & Phone Number

• Led Dental Analytics through transition of EHR Systems (Axium to EPIC Wisdom Module). This involved investigation of new Clarity data sources and migrating over 40 reports. Report areas ranged from Dental Finance, Operations and Quality• Led team in the automation of previously manually ran SAS jobs. This resulted in a savings of 1 FTE and improved the efficiency of the team to keep up the growing needs within Kaiser Dental.• Developed operational reports in Tableau that led to the improvement of Dental Access and Affordability. Created reports that focused in on Dental Wait list and Hygiene Ill Time Improvement.• Led Dental Team through the transition of workflow and usage of Agile Process through Jira.• Developed the Dental Practice Group, consisting of Dental Leadership and our analyst team. This team is responsible for prioritizing the work needed to meet dental needs and consulting on use of metrics for performance management

• Developed and improved standardized Report Development process that has improved the efficiency and quality of Business Intelligence products released into COGNOS production environment• Active participant in department leadership team meetings and annual/quarterly planning• Worked closely with Business Partners to achieve goals of KP Insight department• Managed Report Analyst Team through development process making sure that each stage of development (development, QA, UAT, peer review, release) was fully implemented• Led and mentored team members

• Project Lead on Ambulatory Care Services team to provide information and data to Northwest Ambulatory Care business partners• Developed Java Application using COGNOS SDK to modify 100+ customer report views to translate NW Finance changes• Mentored Report Analyst Team to continue full support of Attendance (Ill Time), Imaging and Finance projects

• Designed and built Enterprise Reporting solution using FusionCharts, Reporting Services (SSRS), and Excel reporting engines.• Cleaned data to prepare for warehousing and database creation.• Created databases, stored procedures (T-SQL), SSIS packages to support reporting solution.• Created views, jobs, DTS Services to support operations, reporting, and analysis. Handled most of the DBA responsibilities for Support Reporting Metric Projects.• Converted DTS packages to SSIS packages.• Managed the design and implementation of Enterprise Reporting Solution.• Converted excel based data files to structured SQL Server tables to implement Top 150 Customer management and reporting tool.• Member of the Product Support Team supporting the following Serena Enterprise tools: -Tracker and TeamTrack -Serena ChangeMan Version Manager (PVCS) -Serena ChangeMan Builder and Configuration Builder -Serena ChangeMan Dimensions • Established process in creating real-time and trending reports for development and supports teams in monitoring their metrics and progress throughout application lifecycle process.• Developed, designed and implemented Web-based application for Sales team in modifying and defining the Top 150 Customers.• Active member of the RAPiD team utilizing SCRUM development.• Supported tier two and tier three product issues reported by customers using Enterprise products.• Technical Environment: SQL Server 2005/2000, SSRS, SSIS, SQL Server Reporting Services.

• Member on the Stockamp Patient Progression Implementation Team, installing Stockamp proprietary software into Medical/Healthcare facilities• Led and Implemented Patient Progression Tool in assisting Hospitals and Medical Facilities in improving Patient Flow and Level of Service• Using SQL Server and internal web-based programs, implemented solutions that produced reports for clients at Hospitals to increase capacity and efficiently increase patient processing• Utilizing ODBC and other database connectivity through SQL Server, established connection to various third-party tools such as, ECIN, MIDAS, TeleTracking and NaviCare, to extract data that can be used in Stockamp’s proprietary Reports and Tools

Bachelor Of Science (B.S.), Computer Science

Education record