Julia Kovalenko

***** ** **** ** ********* WA ***82

Phone: 503-***-**** ● E-Mail: ade19c@r.postjobfree.com

Professional Summary:

Financial/Revenue Analyst with 3 years of professional experience working directly with the CFO (Chief Financial Officer).

Expertise is building reports requiring knowledge of inner and outer joins, and writing fast and reusable SQL. Proficient in managing master data, including creation, updates, and deletion.

Integration of multiple systems to compile Income Statements and thereby, keeping a regular eye on the bottom line.

Technical Skills: Microsoft Office (Word, Excel, Outlook, PowerPoint), Advanced Excel (VLOOKUP, Pivot tables, macros), Advanced SQL (inner/outer joins)

Bilingual – English and Russian

Lags Medical Centers – Financial/Revenue Analyst July 2017 - June 2020

·Built reports on the back-end using SQL for different departments (Billing, Authorizations & Eligibility, Management & Corporate).

·Developed Profitability Analyses for Services introduced to the company (Durable Medical Equipment, Income Statements by Facility, etc)

·Worked along side corporate and middle management to schedule different types of reports to run on weekly/daily/monthly basis to be delivered in their inbox.

·Consolidated and analyzed financial data, taking into account company’s goal and financial standing.

·Developed the RVU Analysis, trained Payroll, & tracked the progression of productivity from the RVU- structured pay.

·Calculated the RVU per provider from CMS-given values to create new providers’ compensation model based on Productivity.

·Submitted comprehensive data to MGMA for benchmarking data.

·Kept track of the company’s revenue.

·Trained other personnel on how to use eBO report functions.

·Updated reports to reflect the new staff, queues or visit types added to the system.

Silver Years, Inc. – Professional Caregiver Sep 2013 – June 2017

•Daily provided assistance for the elderly with physical and mental disabilities, including driving, chaperoning, feeding, and other various tasks.

•Recorded and signed in clients’ attendance.

•Created and assigned daily duties and responsibilities to the employees.

•Organized and cleaned the facility.

Church of Grace – Youth Leader Volunteer 2013 – Present

•Weekly held life group meetings for 5-10 young adult girls.

•Helped to plan and organize youth events.

•Lead the Welcome Team Ministry, team of 12 people.

•Used Planning Center Software for scheduling.

Education

Washington State University – Vancouver WA Fall 2015 – Spring 2018

Graduated with a B.A. in Business Administration

Clark Community College – Vancouver, WA Fall 2013 – Spring 2015

Graduated with an Associates Degree with honors as a running start student

Contact this candidate