Bohdan Duda, Phd Email & Phone Number

Lviv, Ukraine

I've been responsible for:- Discovery phase- Generating Power BI reports - Building Multi-language reports- Constructing various measures to analyse the data effectively- Collaborating with designers to craft visually appealing dashboards- Embedding the reports into the portal - Conducting demonstrations for customers and stakeholders to exhibit the capabilities of the reports- Compiling comprehensive documentation for the completed reports, including the development of documentation templates for the team- Providing consulting support to the customer's team in different streams- Coordinating the activities of the BI team- Participated in Agility Health RadarUsed tools: Power BI,Translations Builder,DAX Studio,Bravo,Tabular Editor,Excel,Draw.io,JIRA,Confluence,Lucidchart,Slack,Parabol.Like Resource Manager I'm responsible for:Employee’s Onboarding and Adaptation facilitationContribution to Employee’s continuous Growth and DevelopmentEmployee’s Performance GuidancePeople (in my unit) Risks evaluation and mitigationStaffing facilitationEmployees’ Exit managementOperational Tasks performance

Lviv, Ukraine

Pustomyty Raion, Lviv, Ukraine

Lviv (Pustomyty)

developed a system for transforming reporting from the Ukrainian chart of accounts into Canadian (was responsible for its operation);based on Power BI created a comprehensive system of analytical reports for daily monitoring of the company's financial performance;developed an excel form of product costing for each individual product based on its drawing;optimized and partially automated the system of writing off raw materials;improved the culture of using Excel in the company, taught other employees to automate work with the help of Power Automate;- responsible of permanent budget controlling and plan-fact analysis (improved an existing file);- receivables analysis and communications with clients;- treasure (cash flow control and payments approval);- permanent analysis of sales (ABC analysis, top and flop products, margin ets);- calculating budget for next year: other operating expenses. personnel costs, material costs, depreciations, sales etc.…- control of profitability;-analysis of planning and production orders;- warehouse management analysis;- other analytical and production ad-hoc analyses;- intensively using of Microsoft Power BI;- automatization of reports due to Power Query and Power Pivot;- working in 1C, OneStream, Power BI, Excel, ets

Lviv, Ukraine

Lviv Region, Ukraine

- budget planning (other operating expensis, depreciation, personnel cost, material cost, sales, etc)- budget control (plan-fact analisys);- bonus calculating (managers and customers);- management report (detail describing all finance aspects of previous year);- transfer pricing report;- controlling fuel consumption (fuel car report);- receivables analysis;- managing bank transactions (currency payments, documentary, FX, etc.);- permanent analysis of sales (prices. maring, trends...);- calculation of profitability, cost, etc.- preparing statistical reports (1-P, 1-PE, 1-Price Prom… etc);- other analytical analysis such as top debitors, credit limits, rate analysis, allocations, margins ets;- making excel training for employees of company (macros; power query; macros and power query; power pivot; dax formulas, visualiations etc);- creating dashboards using Microsoft Power BI (transforming data, normalizing data, creating a data model, working with DAX);- working in SAP, SAP-BW, 1C, Power BI, Excel, ets

Lviv, Ukraine

Few freelance projects in Microsoft Power BI:- sales analysis: analysis b2b sales and analysis shops sales;- finance reports (balance, P&L, Cash-Flow).

Lviv Region, Ukraine

- audit conducting ( I have auditor's sertificate of qaulity control);- development of recommendations for optimization of problem aspects business activities of the customer;- formation of analytical reports in Excel, Microsoft Power BI: description of procedures and justification of the received data;- Customer business evaluation based on the analysis of its data array;- submission of a report on controlled transactions and transfer pricing documentation

Львів

- investigation of internal and external incidents fraud (including development of recommendations on prevention the emergence of similar situations in the future );- translation of legal acts (directives) from English into Ukrainian ;- implementation of changes to the existing legal acts of the bank ;- development of new internal legal acts of the bank ; - anti-fraud controls (Chairman of the Anti-Fraud Committee);- monitoring of personal operations of employees ;- keeping a list of related persons of the bank (including reporting to the National Bank of Ukraine );- introduction of methods to prevent compliance risks ;- creation of educational presentations ;- monitoring of bank processes and products for their correspondence requirements of the legislation ;- creating analytical reports in Oracle BI and Excel

Львів

Львів

Portfolio management of problem loans: knowledge of claims and lawsuits; experience with debtors (telephone conversations, trips to debtors); skills for writing up-to-date findings on the appropriateness and adequacy of provision; monitoring of mortgaged property, experience with experts in valuing property and trading organizations in selling it from trading, acquisition of property skills on a balance that has become the property of the bank as a mortgagee; experience in representing the interests of the bank in courts and other bodies of state power; experience working with large masses of information.

збір документів для оформлення кредиту, розрахунок фінансового стану позичальника, розрахунок окупності кредитного проекту, презентація кредиту на кредитному комітеті, перевірка цільового використання кредитних коштів, здійснення реструктуризації негативно класифікованих кредитів

Phd In Economics

International Financial Reporting Standards

Qaulity Management Systems

Postgraduate, Economy And Management Of The National Economy

Master, Banking And Financial Support Services

Specialist, Commercial Law

Cap/Cipa, Taxation