Helen CAI Tel: 360-***-**** (h)

**** ** ***** ****** 360-***-**** (cell)

Vancouver, WA 98686 Email: ad4fut@r.postjobfree.com

Demonstrated Skills:

Platform: Solaris, HP_UX, Windows, SSH.

Languages and Tools: C/C++, PL/SQL, Shell Script, Pro C.

Databases and Tools: Oracle, SQL, PL/SQL, Crystal Report, Oracle Report/Form, Oracle Developer Suite, Oracle Discoverer, Toad, SQL Server 2008 R2, T-SQL.

Full software development life cycle and customer support.

Course works accomplished: Oracle J2EE, Oracle Java Programming, Oracle Fundamentals I, and Advanced PL/SQL

Clarity Data Model - Resolute Professional Billing Certification - Epic 2014

Summary of Projects accomplished

Design and Develop Crystal Reports in Epic Ambulatory, Willow and Professional Billing with CLARITY and EDW.

Design and Develop custom reports for PeaceHealth HR, Payroll and Finance in LAWSON

Design and develop PL/SQL procedures, functions and packages with PL/SQL to support applications development

Support and maintain electronic student information system and implement and develop custom reports

Design, develop and support health care claims systems.

Performance tuning the electronic claim systems.

Database conversion among different DBMS (Sybase/Oracle/SQL Server).

Work Experience:

Vancouver Housing Authority Nov 2018 – Present

Data Analyst Sr. (SQL Server, SSIS, SSRS, Crystal Report)

Working with SSRS and Crystal report to develop and implement the system and custom reports.

Epiq System Jan. 2018 – May 2018

Data Analyst Sr. (SQL Server, SSIS, SSRS, SSMS, SSDT, TFS)

Working on Wells Fargo CPI (Collateral Protection Insurance) project that provides payments to eligible borrowers who obtained a Wells Fargo vehicle loan. Worked claim process to provide payments to customers who have CPI incorrectly attached to an automobile loan.

Work on a new project initial data load for importing initial data. I worked on pre-qualify data files processes, loaded original data into database, then wrote scripts to move the imported data to the InitialDataStaging table as mapped by business rules. Cleanup bad characters, non-printable characters, remove multiple spaces, set blank strings to null and capitalizes all values data in InitialDataStaging. Used Melissa data to verify address data and setup flag for the data that is missing most components. Standardize data and de-duplicate data, then populate data into final tables and built initial data process statistics.

Work on new pull criteria for the Acknowledge letter batches to pull back out the previous entries in the mailing table and suppressed mailing table, then insert new mailing using the revised criteria and record the exclusions in the suppressed_mailings table. The process will record all exclusion reasons

Worked on summaries of payment Pull criteria for total of mailed count, cashed count, Undeliverable-Not Voided Count, Undeliverable Voided Count, Voided-Past Stale Date Count by each BatchID

Worked on Allied Insurance Verification data. Build new database objects to handle data of Insurance Validated information on Facilitator Build for Call Center When the borrowers have WF loans with multiple policies, the process indicated the customer is overlapping insurance policy and CPI policy. Improve payment or denial process.

Vancouver Housing Authority Nov. 2017 – Dec. 2017

Report Developer Sr. (SQL Server, SSMS, SSRS and Tebealu)

Developed and implement the system and custom reports.

Legacy Health Feb. 2017 – May 2017

Report Developer Sr. (Oracle/SQL Server, Crystal Report, MSOW)

Working on Credentialing Process Improvement Project to conversion Legacy reports in MSOW developed with Crystal Reports on SQL Server into Oracle based reports. I also develop new custom reports for Legacy credentialing and privileging process and support new MSOW system.

Built a new Delegate Practitioner Roster Report, which including verification and review of applicant’s identity, background, training and expertise. It is used to confirm the applicant to meet Legacy criteria for medical membership & appointment. The report also review the applicant’s qualified and competent to hold the privileges requested at a specific facility.

Developed a report provide information to verify internal Legacy systems that the same data the Payers are using to process claims. The report lists billing providers and the ID numbers assigned to them by specific Payers for specific products (aka health plans).

Developed System Wide Complaints report to track conduct complaints and its investigation process. The report can be used for a historical to list all open complaints in each Legacy facility. It also can list all complaints both closed and open for an individual practitioner. It will be reviewed by medical staff leaders and used to assess a practitioner’s behavior.

Developed on Reappointment Status Report to implement reappointment process.

Developed Medical Allied Staff Activity report to trace changes in practitioner privileges, categories, and resignations. Three medical staff committees at each Legacy hospital will review it.

Developed Provider Enrollment Status Report to provide information to internal Legacy teams in real time such that they know when it is permissible to schedule patient appointments for new providers and when to release claims for those same providers. The report list providers, the locations and departments in which they provide services and the status of enrollment for each of the health plans managed by the Payer Enrollment team.

Providence Health & Service Dec. 2015 – Aug. 2016

Epic Clarity Healthcare Business Intelligence Analyst- Level 2 (Oracle Toad, Crystal Report, SQL/PL-SQL, CARITY, Epic Ambulatory, MyChart, TFS, Tableau )

Working in HI Ambulatory R&A team to providing the highest level of the customer support and work in myChart area with the customers to provide the necessary data to meet their needs.

Worked on the project of MyChart activations Providence dashboard to consist with the Success Measure Scorecard. The dashboard was not built using the same definitions as the Success Measure Scorecard. The primary difference is how activations are being attributed to each region. The initial ask of the report was to identify the number of active patients for a region, not for where they signed up. Not all patients have a PCP. The baseline data for each report is different. No column of myChart activations consistently defined in Epic at the patient level. In order to attribute them to a region, both the dashboard and the measure are using the patient’s last encounter and using that encounter location to attribute to a region. In order to attribute them to a region, both queries are using the patient’s last encounter and using that encounter location to attribute to a region. The queries are broken down to department, until patient level to figure out discrepancy between two reports. I modify the queries of ETL process and the Crystal Report with new pull criteria, change mapping table.

Develop HIM Release to myChart report, which provides a summary of patient activity for ROI (release of Information) records released to MyChart. The report is summarized at the Region, Department and Patient level. Additionally, the report can drill down to get detailed patient information, Release ID, action type, action date/time and the comments associated with this action.

Worked on the procedure of Dynamic ETL tables from different data sources.

Worked on Kiosk project to deploy Kiosk reports in Providence environment

PeaceHealth Sept. 2011 – Oct. 2015

Application Developer Sr. - (Lawson, Oracle Developer Suite, Crystal Report, SQL Server 2008 R2, SQL/T-SQL, EPIC’s Clarity Data Model, Resolute Professional Billing)

Worked in PeaceHealth Analytic Services Team (AST) to provide services and support clinical decision-making and improvements. My job responsibilities include: data collection, analysis, report design and delivery of information

Epic/Clarity, EWD, SQL Server, Crystal Report

Worked on Medicaid patient volumes for Meaningful Use CY 2014 project. Lead information gathering for the WA, SW, OR and AK state patient volume reports. Created several store procedures for patient volume calculated by dividing the number of Medicaid encounters during any representative and continuous 90-day period in the preceding calendar year. According to the CMS required, the report contains providers Summary, Provider Detail, and Provider Collapsed Detail, the total encounters and broken down into individual visits.

Worked Epic Integration Reports project, involved to create template, build tracker for installation and move the report into different Epic environments.

Developed and implemented data extract processing to develop comprehensive measures of operational and clinical performance

1.HON: download all Inpatient, Outpatient and Recurring/Series/Cycle accounts

2.Huron: Developed an extract process of a weekly summary file that contains Epic Key AR for metrics Saturday through Friday for Huron.

3.Medisync: Chart notes for Providers for Medisync

4.Worked on pharmacy report that Pharmacy can validate prices attached to medications are “actually correct” to avoid risk of revenue loss by Pharmacy. Prices are set per facility without validation of Pharmacy purchasing or validation of prices.

Worked on TSOC

Lawson, Oracle

Work on ETL data from Lawson into Maximo.

Design and Develop custom reports for Lawson HR, Payroll, Finance and Supply Chair by using SQL/T-SQL and Crystal Reports.

Work S3/LTM data comparing project to monitor and verify Lawson data quality and integrity between Landmark and Lawson.

Work on data interface project to extract, transform and load Lawson health care working hour and summarized data into OHM Web application.

Create report by extracting data from Provider Scheduling system (SQL Server) and Lawson (Oracle)

Use SQL analytic and aggregation functions to query, process, analyze data, and automate reports.

Nike Inc July 2011 – Sept. 2011

Sr. Oracle Database Engineer – (Oracle Developer Suite 10g, PL/SQL, Oracle 11g)

Develops data definition consistent with data management standards & conventions and data mapping.

Maintain and monitor quality of data in and out of database

Collaborates DBA and data model designer to develop alternative solutions for meeting

Complex and conflicting requirements

Design and develop PL/SQL procedures, function and package to support applications that combine data from existing sources, tailored to specific user groups & business needs

Ensure consistency and establish data standards

Report analyst duties, e.g. design and develop automated actionable reports to inform managers in a timely fashion

Xerox Corporation January 2011 – April 2011

Sr. Oracle Database Engineer - (Oracle 10g/11i, PL/SQL, Oracle BI, Crystal Report, Oracle Essbase Spreadsheet Add-in, Oracle APEX)

Analyzed, designed and implemented a data mart for reliability reporting, which uses OBIEE and APEX at the front end. My responsibilities include analyzing and extracting source data from several enterprise and 3rd party databases with tools like Essbase, Crystal Report and Oracle data pump, designing and implementing ETL process, installing and configuring OBIEE components including repository, Answers and Dashboard.

Portland Public Schools District October 2004 – June 2010

Sr. Oracle Developer - (Oracle Developer Suite 10g, PL/SQL, Oracle Report and Form, Toad, eSIS, data warehouse, ETL)

eSIS ® is an enterprise wide, web based, education data management system.

My responsibilities include analyzing/developing custom reports and underlying stored procedures, integrated testing of upgrades and fixes; patching upgrades; data mining and analysis, data maintain and transferring, feasibility analyzing, systems deployment and support.

Designed and developed custom reports. Some reports are selected by the host company for other districts.

Develop/maintain/support/enhance eSIS data

1.Generate scripts to upload other system transportation data into eSIS tables.

2.Import and export eSIS data according to user requirements (state report).

3.work on Resolution & troubleshooting issues

4.UNIX shell scripting

5.Work Oracle TAR's with Metalink.

Designing and creating procedures with PL/SQL for K12th Intelligence Dashboard ETL processes.

Regence of BCBSO, Portland, USA March 1999 - Jan 2004

Lead System Analyst - (Solaris 2.6, Oracle, SQL, C/C++, PL/SQL, SQL*Plus, SQL Loader, SQL Navigator, Pro*C).

Worked on health care insurance claim systems. My responsibilities include systems analyzing, Application and project support, structured methodologies, Data flow diagrams and flowcharting, business process modeling, system design, tool evaluation and feasibility analyzing, systems deployment and support.

I also gained the depth knowledge of systems analysis relating to large and small systems, medical record workflow, admission and registration workflow, including data extractions and they interrelate with system capabilities

Designed and developed a claim entry system, which consists a claim entry GUI in Windows and process tools in UNIX.

Maintain and support the legacy claim systems, which processed claims submitted by physicians electronically, my responsibilities included

Analyze production problems, trouble shooting and on call.

HIPAA compliance project: recognizing, changing and coding in the claim system with new HIPAA standard that required new safeguards to protect the security and confidentiality of electronic healthcare information.

Format ITS claims when passed to ACPS from EMC.

Redesign ITS Home claim pending logic.

Generate claims report for THIN providers by designed/coded store procedures with PL/SQL

Generate a new job to eliminate duplicated data file to be processed in EMC system

Redesign pending logic for Professional Component claims.

Used new COB pending logic for medical and dental claims

Redesign claim number reel assignment to following standard protocol as was assigning non ICR claims.

EMC Claim system performance tuning. It involved:

Establish a tuning environment

Using Oracle tools to analyze SQL statements.

Install, configure and use third party SQL tuning tools such as Embarcadero SQL Tuner, SQLab to monitor database transactions dynamically.

Enhanced claim systems performance technologies by working cycle of analyzing tables/queries and recreating indexes and etc.

Upgrading the claim systems, including Solaris, Oracle database server and claim systems.

Create an environment and verify the proper functioning of the new release.

Plan and coordinate the testing of the new release for the database and the application

Redesign makefiles with new options and links to new library and compiler.

C++ code changed to match new C++ library

Pro*C/C++ SQL statements and PL/SQL procedures changed to match Oracle 8i, 9i

Nortel Networks, Ottawa, Canada Aug. 1997 - Jan. 1999

Senior Software Designer - (HP-UX, C/C++, OO technology, UML and Rational Rose, CCS7, Call Processing, signaling)

Designed and developed telephone billing system in different platforms, involved full development cycle from analysis of customs requirements, high-level and detail design, coding, testing, and documentation follow the established Nortel processes.

Education and Training:

B.Sc. in Computing Mathematics, Lanzhou University, China

References: Available upon Request

Contact this candidate