Adrian Ivan
Senior Financial Analyst at Digital Cable Systems- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English Professional working proficiency
-
Russian Elementary proficiency
-
Romanian Native or bilingual proficiency
Topline Score
Bio
Experience
-
Digital Cable Systems (AKTA)
-
Romania
-
Telecommunications
-
1 - 100 Employee
-
Senior Financial Analyst
-
Apr 2015 - Present
- preparing statutory and management monthly reports: profit & loss, balance sheets, cash-flows, CAPEX (aggregation of statutory and management accounting) as well as statistical/KPI reports: Revenue Generating Units (RGU), home-passed, employees, etc - consolidation and aggregation of group companies reporting: Digital Cable Systems, Akta Telecom and Diplomatic Digital (cancelling P&L and BS group redundancyes) - preparing the capitalisation of costs inside the network assets, partial/total write-offs of the networks/subnetworks - improvement of current working processes within financial department (by implementing and using VBA automation): generating automatic reports, mailing automation to responsible departments, cost calculations and distributions, capitalisation of costs, inventory processing (administration and aggregation of warehouses inventory reports through VBA automation) - maintaining contractual relations for group companies (identification and stipulation intra-group services inside well defined contracts) - following the use of the budget lines for the appropriate destination, framing in the projected values, finding the sources of the variations between the actual and the budget lines - providing support to the responsible departments in order to prepare budgets and forecasts for the following periods - realization and consolidation of the planned budget of incomes and expenses - participation in the development, maintenance and optimization of a useful analysis and reporting system (or tool) for the company's management as base for future decisions (eg productivity, profitability, costs, etc.) - preparing the information necessary for the evaluation of the acquired or pledged networks; IFRS impairment testing of acquired networks - primary administration of SUN Systems financial/ accounting ERP software (changes of current settings/work parameters); maintaining contact with the maintenance / administration service provider of SUN Systems software Show less
-
-
-
METRO/MAKRO
-
Germany
-
Wholesale
-
700 & Above Employee
-
Senior Controller – Corporate
-
May 2014 - Mar 2015
- preparing/supervising/commenting international financial reports related to actual, forecast and mid-term: P&L items: sales, margin, later income, stock evaluation, all operational/administrative costs, allocation of local and international costs, financial result; B/S items: net working capital items (stocks, receivable, payable), provisions; reporting to international controlling department and local financial department - preparing/supervising financial statement on dedicated company activities (delivery, field force, IT) and analyzing the financial impact of new/existing measures on the current company development. - preparing/analyzing internal periodical KPI reports (sales, margin, later income, inventory, stock rotation, stock valuation, stock aging, own branding, productivity, variance analysis) - preparing/analyzing investment proposals by aggregating all necessary information from Operational, IT, Purchasing, Sales; preparing current CAPEX development report on detailed project level. Achievements: - implementing new investment controlling procedure on project level - automation of current working tools in periodical reports Show less
-
-
-
OBI Romania
-
Bucharest, Romania
-
Financial Controller
-
May 2010 - May 2014
- participating in monthly financial closing by checking the accounting bookings (accounts, cost centers, provisions and accruals, investments, stocks, bonus and additional costs capitalization, etc) and checking the reconciliation of bookings between financial and operational systems - preparing and checking monthly P&L reports, cash-flow (Indirect method) - preparing the current/budget/forecast comments regarding significant deviations to budgets (P&L, working capital, investments, cash-flow, net debt to OBI group) - preparing the company budget/forecast by supporting the responsible departments (sales, purchasing, expansion, administrative, financial, etc) and also following the correlation between all data. - preparing any financial report and analyse requested by company management - checking and confirming/invalidating correctness of the data initiated and transmitted by OBI Germany (Inter-company re-charged costs) - preparing the HR P&L positions (Personnel costs, wages, benefits, taxes, accruals) for budget/forecast process together with monthly reporting of HR indicators to group (FTE, costs, etc.) - creating tools (VBA projects) for improving day to day activity in different departments: automatic generating of SAP accounting notes related to bank statements, accrual tool for monthly reporting from responsible departments, marketing budgeting and detailed actual controlling tool, automatic monthly mail sending to stores management the P&L actual and budget details (through Lotus Notes), training support HR tool for new employees, key account management tool for generating customized clients offers, promo evolution overview on item level. Show less
-
-
-
Praktiker
-
Germany
-
Technology, Information and Internet
-
400 - 500 Employee
-
Financial Controller, Assortment Controller
-
Feb 2006 - May 2010
- controlling of cost elements by comparing actual figures to previous periods, budgets and forecasts); - investigate deviations to previous periods, budgets and forecasts by preparing reasonability analyses and detailed checks; - realizing periodical reports to Controlling dept. in Germany: cost of goods sold, stocks & sales reports, personnel reports, inflation and exch. rates reports, IAS P&L report for actual, budget and forecast, - realizing internal reports: monthly package (sales, stocks, internal movements, CoGS, top sold articles, rotation per suppliers, IAS P&L sheet), daily stock and sales report; - data input in the controlling communication management system (MIK system) - comments for P&L lines - actual results against previous year, budget and forecast - preparing forecast and budget components, (revenues and costs) - using and combining financial and operational information in order to realize most realistic forecasts, collaborating with other operational departments in order to prepare as realistic as possible the forecasts and budgets; - keeping the records regarding leasing, services and all other important contracts; - realizing and inputting reports in SAP EC-CS system for forecasts, budgets and current periods (keeping the Praktiker group inter-company reconciliation accounts) - identifying and analyzing the financial-accounting risks and errors and informing the superiors about this issues; - maintaining the organizational relations with following departments: accounting, purchasing, human resources, sales, organization, internal audit and stores. - maintaining the organizational relations with controlling dept. in Germany; - preparing the DYI competitors report; Setting automatic generating tools for reporting and uploading data in main system used. (Monthly reports folder to board members and store managers - automatic creating, zipping and mail delivering through Outlook, automaticaly preparing the upload budget data into MIK System) Show less
-
-
-
Estee Lauder Romania SRL
-
Bucharest, Romania
-
Economist, Administrative Assistant
-
Aug 2002 - Jan 2006
- chief cashier (collecting and depositing the daily cash to the bank, withdrawal of the cash from the bank, daily operations with the bank); - daily sales checking (cash and card); - registering the inputs / outputs of the goods for both companies; - registernig and working out the primary accounting documents (house registry; purchase registry, sales registry etc); - invoicing and distributing the products to the dealers of the wholesale company; - price cost calculation for imports of the products; - working out the monthly declarations regarding the payment of "unemployement taxes", "medical insurance taxes" and submitting them to local authorities; - elaboration of periodical reports regarding sales and purchases and submitting to the greek management team; - administration of the retail selling point: the way it looks; contact with the suppliers; responsible with acquisition of consumable materials; - administrating the product database (over 6000 codes); - keeping the relation with the Teritorial Inspectorate of Labor: working out and submitting documents regarding labouring; - primary administration of the computer network; I applied a one stock balance method for both retail and wholesale activity while no deposit was available for wholesale activity. I implemeted a procedure of calculating the stock value in foreign currency at historical price (the accounting system did not allow foreign currency calculation method). I implemented procedures for automatic data upload of stock movements (in and out-going goods) which significantly improved the work flow. Show less
-
-
Education
-
Academia de Studii Economice din București
Bachelor's Degree, Cybernetics, Statistics and Economic Informatics -
Gheorghe Sincai, Bcharest
High School, Mathematics-Physics