Contact information

The job seeker has entered a phone number and email.

You can get this candidate's contact information from https://www.work.ua/resumes/6152525

Work experience

Cofounder

from 02.2020 to now (4 years 4 months)
Ukraine Counsellor, Київ (services for foreigners)

https://ukrainecounsellor.com/

Founder

from 10.2016 to now (7 years 8 months)
Qualitative Change, Київ (Not For Profit / Investment Economics Research)

Development of New Economic Paradigm “Qualitative Change. 21 Century” https://qualchange.com/en/

Financial Budget Analyst, FP&A

from 10.2014 to 09.2016 (1 year 11 months)
Netcracker Technology Corporation, (IT industry), Kiev (IT)

Optimizing financial business processes and financial business systems:

•Optimizing processes between OLAP and OLTP data systems in order to increase efficiency;
•Researching on innovations that can add value to the current FP&A processes;
•Establishing data warehouse in order to provide with smooth and efficient data flow between originating databases and Excel application;
•Managing various integrations between different originating sources (accounting source; forecast and consolidation source; revenue forecasting source; revenue pipeline opportunities source; project reporting source, etc.);
•Creating and managing proper reconciliations between systems by various dimensions: legal entity, department, natural account, project, subcontract, org structure level etc.;
•Reaching the various divisions in order to identify the currently established data flow processes, conducting business analytical tasks, establishing new processes in compliance with business needs;
•Creating functional requirements for the preparing of the automatic financial analyses systems on ERP;
•Creating manuals for the “revenue analyst” and “financial analyst” positions;
•Creating flowcharts for the various financial business processes in order to have one convenient source with the logic of business processes that is visually reflected and easy to understand (i.e. avoiding reading functional specifications/requirements in order to simplify and make the logic process easier for comprehending).

Performing and managing FP&A activities for the monthly, quarterly and year-end financial closing:

•Analysis of the direct labor calculation and allocation by function, by type of resource;
•Managing the gross margin reporting on ERP; calculation and analysis of the facilities overhead rates on the quarterly basis; analysis of the gross margin costs in different dimensions; on the quarterly basis creating in Power Point the bridge between gross margin at the GAAP level and gross margin at the managerial reporting level;
•Analyzing of the headcount month-to month changes, identifying the root cause of the major changes;
•Conducting the month end financial/managerial reporting meetings (act vs fcst): discussing and analyzing root causes of the variances between analyzed data based on accounting team inputs, providing the final reports to function owners and top-management;
•Analysis of the intercompany transactions (P&L and CF statements)
•Creating of the financial models for analysis and reporting of the financial positions from the managerial reporting stand point (SDN/NFV analysis (P&L and cash basis), etc.).

Education

Kelley School of business

MSA, Indianapolis
Higher, from 2011 to 2014 (3 years 5 months)

Additional education and certificates

Passed CPA exam

2014, 24

Language proficiencies

English — fluent

Additional information

•English (fluent);
•Interested in economic theories at the fundamental level;
•GAAP, IFRS, SOX; valuation methods: DCF, Venture Capital, Chicago First, Scorecard;
•Proficient in Excel (pivot tables; power pivot; sumif, sumifs, vlookup etc. functions), Access, Word; PowerPoint; Microsoft SQL Server, MySQL server, Adaptive Insight Planning and Sales Instances, SalesForce, ProSeries, Great Plaints, Visio (Flowchart creation), ERP structures; familiar with SPSS, ACL, 1C, NAP, SAP, Frazer;
•Familiar with Programming Languages: C# ,VBA, SQL;
•Excel Add In Development http://easylookups.tilda.ws/,
•Professional table tennis player (Turkey students International Fest champion 2008, Indianapolis champion 2013, USA champion among students in men’s doubles in 2013).