Mariana

Mariana Hurak

KEY SKILLS EXPERIENCE
Total Experience 10 years
Data Analyst 7 years
Health Care Industry 2.5 years
Report Writing 9 years
Sql Server 4 years
Sql Queries 4 years

EXPERIENCE

VisiQuate, Kharkiv
March 2017 to current
Hospital Revenue Cycle Management (HRCM). Analyst, Business Insight II

— Providing ongoing reports and creating new reports
— Interpreting data and analyzing results
— Completion of requests/tasks and participation in projects
— Working with database (EDW, AnalyticsDB), creating SQL queries/procedures
— Creating and application of the Alteryx Workflows
— Creating reports/visualizations in CCBI
— Creating reports on VisiQuate site using existing fields or adding new or writing queries
— Communication with requestors, gather and discuss requirements
— Communication with Support Teams for installed new applications or schedule
procedures, correction of mistakes revealed in the system, etc.
— High-level understanding of Helthcare data sets: Accounts, Transactions, Charges

Anheuser-Busch InBev, BSC, Kharkiv
February 2013 to March 2017
Analytics Department. Demand Planning Specialist

— Creating consolidated reports on sales
— The analysis of history and tendencies of the market for effective forecasting
— Base reporting for forecast of sales volumes
— Working with database, creating SQL queries
 — Communication with users, gather and discuss requirements
— Communication with Support Team and Master Data Team for correction of mistakes
revealed in the system

Anheuser-Busch InBev, BSC, Kharkiv
October 2011 to February 2013
Sales Department. Analyst

— Preparation and analysis of reports on execution of plans and budgets of primary sales
— Calculation of a weekly sales tendency
— Monthly planning of sales of clients
— Communications with Sales, Marketing, Planning departments. Requirements
clarifications
— Working with databases (SAP)
— Working with documentation

Anheuser-Busch InBev, BSC, Kharkiv
January 2009 to October 2011
Logistics department, Logistics specialist

— Work with client’s orders
— Loading of orders to SAP ERP system
— Create reports for analytics
— Preparation and analysis of reports on execution of plans and budgets of primary sales

Education

National Technical University «Kharkiv Polytechnic Institute», specialist degree in Chemical
technology of organic substances
2003 – 2009

TECHNICAL SUMMARY

Skills:
- Microsoft Office (Access, Word, Excel), Windows - MicroStrategy
- Skills in MS SQL server - Alteryx
- SAP - SSIS
- VBA (baseline) - ACE