olena stehlik

senior business analyst

About

Professional Analyst with well-built knowledge of data warehousing and ability to work with different data sources over different platforms. Have extensive experience in managing the analysis of all aspects of marketing reinvestment, finance, and overall operational efficiency. Specialize in coordinating all departments during an operations review maintaining a strong channel of communication with all levels of management with strong knowledge of general accounting procedures. Computer skills: Advanced skills in Microsoft Office, ShowCase 9, SAP Fronted (module SD, FI), IGT & ACSC systems, Brio Intelligence Designer, Cognos 8, IBM Query Studio, SAS Enterprise 4.3; Aristocrat-Oasis system; HALO, Microsoft SQL Report Builder 3.0; Host VizExplorer and Sales Force.

Country

united states

City

durant

Industry

government administration

Skill

analysis, financial reporting, accounting, access, internal controls, account reconciliation, sap, auditing, general ledger, budgets, internal audit, forecasting, hospitality, gaming industry, sarbanes oxley act, hospitality industry, financial accounting, financial audits, gaap, microsoft access, tax

Experience

senior business analyst

choctaw nation of oklahoma

2019-1 - Present · 7 yrs 9 mos

business intelligence analyst

the choctaw nation of oklahoma – division of commerce

2017-3 - 2018-12 · 1 yr 10 mos

* Extract data from databases and data warehouses in order to report and simplify distribution between multiple data systems * Work with Anaplan, Microsoft SQL Server and WebFocus to support Commerce Division operation’s needs * Communicate with business leaders to gather requirements * design and deliver scheduled and ad-hoc reports, including dashboards, complex financial models, and other dynamic reports such as F&B KPI, TP KPI and so on * Create and maintain Labor Cost reports/dashboards and FTE project pulling data from JDE and Kronos * Create Budget model in Anaplan working closely with Gaming and Non-Gaming Analytics team and help implement throughout the Commerce Division, running the summary analysis of the companies to increase their profits and reduce costs.

data and marketing analyst

choctaw casinos of oklahoma

2014-3 - 2017-3 · 3 yrs 1 mo

regional marketing analyst

pinnacle entertainment

2012-4 - 2014-3 · 2 yrs

* Perform market analysis using utilizing SQL databases to forecast market trends and program profitability. * Present the data with the financial calculations * Prepare reports analyzing cross property offers of Profit and Loss * Responsible for data mining and ad hoc analyses/reports

strategic marketing analyst

penn national gaming

2006-1 - 2012-4 · 6 yrs 4 mos

* Perform strategic product analysis of customers operating in the entertainment sector and prepare executive-level analysis and reports on daily, weekly, monthly and quarterly basis. * Provide analysis to determine the efficiency and effectiveness of new promotions and initiatives towards patrons and drive other analytical projects to monitor performance and activities. * Forecast customer behavior, expenditure and revenue throughout the year. * Serve as main source for the Corporate Office in the preparation of monthly standard reports and matrix required for all Penn National Gaming properties. * Maintain database applications analyzing and resolving identified problems. * Investigate, verify and help to implement IBM Cognos into the company, working with Corporate Data Warehouse * Confirming and managing data with CRM administrator and Corporate representatives. * Perform daily audit and monitor internal paperwork control for cage, slot, table games and soft count paperwork.