MarynaBondareva Profile

0,0

(0 valutazioni)

Stai seguendo

Impossibile seguire l'utente.

Questo utente non consente agli altri utenti di seguirlo.

Stai già seguendo questo utente.

Il tuo piano di abbonamento ti consente un massimo di 0 segui. Cambia abbonamento qui.

Non segui più

Impossibile non seguire più l'utente.

Hai consigliato .

Impossibile consigliare l'utente.

Si è verificato un problema. Aggiorna la pagina e riprova per piacere.

Email verificata.

$10 USD / ora

луганск,

ukraine

$10 USD / ora

Attualmente sono le 6:38 PM qui

Registrato il luglio 15, 2016

0 raccomandazioni

MarynaBondareva

@MarynaBondareva

0,0

(0 valutazioni)

0,0

$10 USD / ora

луганск,

ukraine

$10 USD / ora

Lavori completati

Nel budget

Nei tempi previsti

Tasso di riassunzione

Excel & PowerBI Expert, Analyst, VBA programmer

5 Years Experience in Financial Reporting and Data Analysis (large volume of data, more then 200,000 items). Employment: currently working as Head of financial and analytical Department in a big retail company. Key Skills: -Business Intelligence specialist (PowerBI reporting, dashboarding, DAX, PowerPivot/Query/View) -VBA programmer (you can see some of my projects in my own portfolio or on YouTube channel) - Excellent in Microsoft Office tools namely Excel, Word, PowerPoint, Outlook. - Microsoft Access - Experience in creation of various reports, pivot tables, charts, graphs. - Having strong competency in data interpretation - Excellent in Time Management and Prioritizing Tasks - High level of analytical, numeracy and problem solving skills - Capable of summarising data into clear and readable formats - Creative thinker - Good interpersonal skills - Attention to detail

Vedi tutti i Data Processing Executives in Ukraine

Contatta MarynaBondareva per il tuo lavoro

Accedi per discutere i dettagli via chat.

Portfolio

This program work with unloaded file from DB where the number of rows more than 5000 rows (formats, deletes extra rows, signs and symbols, adds new info) . And after it creates a PDF file from the each row of the file (more than 5000), which contain 40 parameters.

Program bypass limitation of MS Excel in data visualization in one single cell ( in the source file was cells, which contains data for more than 25 sheets MS Word).

#Excel #макрос #VBA #VisualBasicForApplications

Correcting the file from DB and creation PDF (Excel.VBA)

• Auto filling of the cells;
• Creation of the client reference
• Chacking data on dublicates, errors, formats and etc.
• Saving history of documents
• Reporting

#Excel #VBA #macros

DataBase in Excel + Reports Creator + Forms to Fill Info

Preview of PowerBI Report.
To build this report I use 2 sources. During the working process it was built a complex structure of queries and table-connections. The data model auto refreshes if any source is changed. Client can work from browser or from mobile app.

#PowerBI #report #BusinessIntelligence #BI #analytics #visualization #report#reporting

PowerBI Report 2

Preview of PowerBI Report.
To build this report I use 5 sources. During the working process it was built a complex structure of queries and table-connections. The data model auto refreshes if any source is changed. Client can work from browser or from mobile app.

#PowerBI #report #BusinessIntelligence #BI #analytics #visualization #report#reporting

PowerBI report (example of a few sheets)

2895105

https://www.youtube.com/watch?v=Gx7eZSzdF3M

This workbook is a collection of formulas and macros. It was created for the middle management of the company to analyze sales of goods per item, stocks, and for the analysis of orders to suppliers.

This workbook includes 4 Sheets:

Sheet 1 contains detailed information how to unload required files;

Sheet 2 (“2015”) helps user:
A) to see the sales history of the list of goods in 2015 by months only by typing SKU in a designated cell;
B) automatically insert the order to the form and see the history of sales in 2015 for each of the items of the order.
Sheet 3 and 4 («2016» и «2016 Ведомость») perform the same functions as the sheet "2015", but only for a selected period of 2016 year (+optionally calculate the stock and average monthly sales)

PBTeam_The_assistant_for_the_analysys_of_stocks_and_trade

2894964

https://www.youtube.com/watch?v=Qxcx3Nl98Xc

This report is an example of a daily report on the results of operations of the company.

It shows the result of trading business for the every single day, its dynamics compared to selected periods in the past.

This document consists of a list of sheets and includes macros that allow user to automate the routine work for daily data entry.

PBTeam_The_daily_revenue_report

Correcting the file from DB and creation PDF (Excel.VBA)

DataBase in Excel + Reports Creator + Forms to Fill Info

PowerBI Report 2

PowerBI report (example of a few sheets)

2895105

PBTeam_The_assistant_for_the_analysys_of_stocks_and_trade

2894964

PBTeam_The_daily_revenue_report

Valutazioni

Modifiche salvate

Nessuna valutazione da vedere qui!

Esperienza

StroyCenter

apr 2015 - Attualmente

Control over: - financial and economic indicators of the enterprise; - management of stocks; - making orders to suppliers; - implementation of recalculation of goods; - pricing; - margins of goods; - the turnover rate of commodities. Reporting (trade, staff indicators, etc.). Creating automated forms of reports by using Excel VBA (to simplify and to accelerate reporting). Planning sales and other indicators, plan the program of the enterprise development.

LLC ” EpicentrK” (Trade)

dic 2011 - set 2014 (2 anni, 9 mesi)

- analysis of indicators of trade Department, its product composition by groups/suppliers etc.(ABC, XYZ – analysis etc.); - creation of reports ( large volume of data); - preparation, verification of production orders; - control over product assortment; - monitoring of turnover and sale of goods (analyzing and making proposals to exclude the assortment of goods without movement) - control the profitability of products; - training personnel on financial and economic indicators