Roman Z. Profile | Freelancer

EXPLORE

Data Processing

5.0

(66 reviews)

You're now following

Error following user.

This user does not allow users to follow them.

You are already following this user.

Your membership plan only allows 0 follows. Upgrade here.

Successfully unfollowed

Error unfollowing user.

You have successfully recommended

Error recommending user.

Something went wrong. Please refresh the page and try again.

Email successfully verified.

$15 USD / hour

Flag of UNITED STATES

lafayette,

$15 USD / hour

It's currently 2:42 PM here

Joined October 3, 2013

3 Recommendations

Roman Z.

@dviruki

5.0

(66 reviews)

5.6

5.6

89%

89%

$15 USD / hour

Flag of UNITED STATES

lafayette,

$15 USD / hour

100%

Jobs Completed

100%

On Budget

98%

On Time

21%

Repeat Hire Rate

Expert in Excel, Finance and Accounting

An expert with 12+ years of experience in investment banking, consulting, financial research and analysis, audit and accounting. Formerly employed with a Big-4 audit firm. CFA and ACCA candidate. Extensive experience with VBA, Excel, Word, Access, Powerpoint. Custom solutions in Excel and Google Sheets: • automation using VBA and complex formulas • dashboards, charts and reporting tools • macro and spreadsheet optimization and streamlining • multiple spreadsheets environments • Excel Solver and statistical analysis • Word and Access integrations, PDF creation and e-mail distribution • any kind of data processing and analysis using Pivot Tables, VBA and complex formulas Finance and accounting services: • financial modelling • ratio analysis • financial analysis and business valuations • preparation of budgets, financial and management accounts • academic assignments • Quickbooks Automation of Word, Access and Powerpoint Web scraping and data entry

See all Excel Experts in United States

Contact Roman Z. about your job

Log in to discuss any details over chat.

Portfolio

I create solutions custom-tailored to client's needs. Automation using VBA/macro and complex formulas. Dashboards, analytical tools, Pivot Tables, charts. Any type of data processing and analysis.

Sample Excel work: dashboards, charts, analytics, PivotTable

I create solutions custom-tailored to client's needs. Automation using VBA/macro and complex formulas. Dashboards, analytical tools, Pivot Tables, charts. Any type of data processing and analysis.

Sample Excel work: dashboards, charts, analytics, PivotTable

I create solutions custom-tailored to client's needs. Automation using VBA/macro and complex formulas. Dashboards, analytical tools, Pivot Tables, charts. Any type of data processing and analysis.

Sample Excel work: dashboards, charts, analytics, PivotTable

I create solutions custom-tailored to client's needs. Automation using VBA/macro and complex formulas. Dashboards, analytical tools, Pivot Tables, charts. Any type of data processing and analysis.

Sample Excel work: dashboards, charts, analytics, PivotTable

I create solutions custom-tailored to client's needs. Automation using VBA/macro and complex formulas. Dashboards, analytical tools, Pivot Tables, charts. Any type of data processing and analysis.

Sample Excel work: dashboards, charts, analytics, PivotTable

I create solutions custom-tailored to client's needs. Automation using VBA/macro and complex formulas. Dashboards, analytical tools, Pivot Tables, charts. Any type of data processing and analysis.

Sample Excel work: dashboards, charts, analytics, PivotTable

I create solutions custom-tailored to client's needs. Automation using VBA/macro and complex formulas. Dashboards, analytical tools, Pivot Tables, charts. Any type of data processing and analysis.

Sample Excel work: dashboards, charts, analytics, PivotTable

I create solutions custom-tailored to client's needs. Automation using VBA/macro and complex formulas. Dashboards, analytical tools, Pivot Tables, charts. Any type of data processing and analysis.

Sample Excel work: dashboards, charts, analytics, PivotTable

I create solutions custom-tailored to client's needs. Automation using VBA/macro and complex formulas. Dashboards, analytical tools, Pivot Tables, charts. Any type of data processing and analysis.

Sample Excel work: dashboards, charts, analytics, PivotTable

I create solutions custom-tailored to client's needs. Automation using VBA/macro and complex formulas. Dashboards, analytical tools, Pivot Tables, charts. Any type of data processing and analysis.

Sample Excel work: dashboards, charts, analytics, PivotTable

I create solutions custom-tailored to client's needs. Automation using VBA/macro and complex formulas. Dashboards, analytical tools, Pivot Tables, charts. Any type of data processing and analysis.

Sample Excel work: dashboards, charts, analytics, PivotTable

I create solutions custom-tailored to client's needs. Automation using VBA/macro and complex formulas. Dashboards, analytical tools, Pivot Tables, charts. Any type of data processing and analysis.

Sample Excel work: dashboards, charts, analytics, PivotTable

Financial model for a startup coffee vending business. Over 100 input variables for each of 4 periods, monthly breakdowns and yearly summaries. Incorporates IS, BS and CFS, ratio analysis, and separate schedules for sales revenue and COGS, PPE depreciation, employee-related costs and startup costs and financing schedule.

Financial model

Financial model for a startup coffee vending business. Over 100 input variables for each of 4 periods, monthly breakdowns and yearly summaries. Incorporates IS, BS and CFS, ratio analysis, and separate schedules for sales revenue and COGS, PPE depreciation, employee-related costs and startup costs and financing schedule.

Financial model

Financial model for a startup coffee vending business. Over 100 input variables for each of 4 periods, monthly breakdowns and yearly summaries. Incorporates IS, BS and CFS, ratio analysis, and separate schedules for sales revenue and COGS, PPE depreciation, employee-related costs and startup costs and financing schedule.

Financial model

Fully automated Excel spreadsheet that allows to upload CSV-based raw data, process it and perform statistical analysis based on user-controlled criteria, chart selected data subsets on individual graphs and generate multiple text files with subsets data.

Automated statistical analysis and charting in Excel

Fully automated Excel spreadsheet that allows to upload CSV-based raw data, process it and perform statistical analysis based on user-controlled criteria, chart selected data subsets on individual graphs and generate multiple text files with subsets data.

Automated statistical analysis and charting in Excel

Fully automated Excel spreadsheet that allows to upload CSV-based raw data, process it and perform statistical analysis based on user-controlled criteria, chart selected data subsets on individual graphs and generate multiple text files with subsets data.

Automated statistical analysis and charting in Excel

VBA driven Jeopardy and Family Feud games in Powerpoint.

Powerpoint VBA

VBA driven Jeopardy and Family Feud games in Powerpoint.

Powerpoint VBA

VBA driven Jeopardy and Family Feud games in Powerpoint.

Powerpoint VBA

VBA driven Jeopardy and Family Feud games in Powerpoint.

Powerpoint VBA

902633

Dynamic dashboard for a live casino operator. Headline figures and charts are dynamically updated based on desired KPI, selection of dates and player IDs to report on.

Dynamic dashboard

Dynamic dashboard for a live casino operator. Headline figures and charts are dynamically updated based on desired KPI, selection of dates and player IDs to report on.

Dynamic dashboard

932726

Interactive KPI dashboard for a hospitality industry client. Numeric and graphic analysis per period, vs target and vs previous year, with correct formatting of data presented in graphic form.

KPI dashboard

Interactive KPI dashboard for a hospitality industry client. Numeric and graphic analysis per period, vs target and vs previous year, with correct formatting of data presented in graphic form.

KPI dashboard

I create solutions custom-tailored to client's needs. Automation using VBA/macro and complex formulas. Dashboards, analytical tools, Pivot Tables, charts. Any type of data processing and analysis.

Sample Excel work: dashboards, charts, analytics, PivotTable

I create solutions custom-tailored to client's needs. Automation using VBA/macro and complex formulas. Dashboards, analytical tools, Pivot Tables, charts. Any type of data processing and analysis.

Sample Excel work: dashboards, charts, analytics, PivotTable

I create solutions custom-tailored to client's needs. Automation using VBA/macro and complex formulas. Dashboards, analytical tools, Pivot Tables, charts. Any type of data processing and analysis.

Sample Excel work: dashboards, charts, analytics, PivotTable

I create solutions custom-tailored to client's needs. Automation using VBA/macro and complex formulas. Dashboards, analytical tools, Pivot Tables, charts. Any type of data processing and analysis.

Sample Excel work: dashboards, charts, analytics, PivotTable

I create solutions custom-tailored to client's needs. Automation using VBA/macro and complex formulas. Dashboards, analytical tools, Pivot Tables, charts. Any type of data processing and analysis.

Sample Excel work: dashboards, charts, analytics, PivotTable

I create solutions custom-tailored to client's needs. Automation using VBA/macro and complex formulas. Dashboards, analytical tools, Pivot Tables, charts. Any type of data processing and analysis.

Sample Excel work: dashboards, charts, analytics, PivotTable

I create solutions custom-tailored to client's needs. Automation using VBA/macro and complex formulas. Dashboards, analytical tools, Pivot Tables, charts. Any type of data processing and analysis.

Sample Excel work: dashboards, charts, analytics, PivotTable

I create solutions custom-tailored to client's needs. Automation using VBA/macro and complex formulas. Dashboards, analytical tools, Pivot Tables, charts. Any type of data processing and analysis.

Sample Excel work: dashboards, charts, analytics, PivotTable

I create solutions custom-tailored to client's needs. Automation using VBA/macro and complex formulas. Dashboards, analytical tools, Pivot Tables, charts. Any type of data processing and analysis.

Sample Excel work: dashboards, charts, analytics, PivotTable

I create solutions custom-tailored to client's needs. Automation using VBA/macro and complex formulas. Dashboards, analytical tools, Pivot Tables, charts. Any type of data processing and analysis.

Sample Excel work: dashboards, charts, analytics, PivotTable

I create solutions custom-tailored to client's needs. Automation using VBA/macro and complex formulas. Dashboards, analytical tools, Pivot Tables, charts. Any type of data processing and analysis.

Sample Excel work: dashboards, charts, analytics, PivotTable

I create solutions custom-tailored to client's needs. Automation using VBA/macro and complex formulas. Dashboards, analytical tools, Pivot Tables, charts. Any type of data processing and analysis.

Sample Excel work: dashboards, charts, analytics, PivotTable

Financial model for a startup coffee vending business. Over 100 input variables for each of 4 periods, monthly breakdowns and yearly summaries. Incorporates IS, BS and CFS, ratio analysis, and separate schedules for sales revenue and COGS, PPE depreciation, employee-related costs and startup costs and financing schedule.

Financial model

Financial model for a startup coffee vending business. Over 100 input variables for each of 4 periods, monthly breakdowns and yearly summaries. Incorporates IS, BS and CFS, ratio analysis, and separate schedules for sales revenue and COGS, PPE depreciation, employee-related costs and startup costs and financing schedule.

Financial model

Financial model for a startup coffee vending business. Over 100 input variables for each of 4 periods, monthly breakdowns and yearly summaries. Incorporates IS, BS and CFS, ratio analysis, and separate schedules for sales revenue and COGS, PPE depreciation, employee-related costs and startup costs and financing schedule.

Financial model

Fully automated Excel spreadsheet that allows to upload CSV-based raw data, process it and perform statistical analysis based on user-controlled criteria, chart selected data subsets on individual graphs and generate multiple text files with subsets data.

Automated statistical analysis and charting in Excel

Fully automated Excel spreadsheet that allows to upload CSV-based raw data, process it and perform statistical analysis based on user-controlled criteria, chart selected data subsets on individual graphs and generate multiple text files with subsets data.

Automated statistical analysis and charting in Excel

Fully automated Excel spreadsheet that allows to upload CSV-based raw data, process it and perform statistical analysis based on user-controlled criteria, chart selected data subsets on individual graphs and generate multiple text files with subsets data.

Automated statistical analysis and charting in Excel

VBA driven Jeopardy and Family Feud games in Powerpoint.

Powerpoint VBA

VBA driven Jeopardy and Family Feud games in Powerpoint.

Powerpoint VBA

VBA driven Jeopardy and Family Feud games in Powerpoint.

Powerpoint VBA

VBA driven Jeopardy and Family Feud games in Powerpoint.

Powerpoint VBA

902633

Dynamic dashboard for a live casino operator. Headline figures and charts are dynamically updated based on desired KPI, selection of dates and player IDs to report on.

Dynamic dashboard

Dynamic dashboard for a live casino operator. Headline figures and charts are dynamically updated based on desired KPI, selection of dates and player IDs to report on.

Dynamic dashboard

932726

Interactive KPI dashboard for a hospitality industry client. Numeric and graphic analysis per period, vs target and vs previous year, with correct formatting of data presented in graphic form.

KPI dashboard

Interactive KPI dashboard for a hospitality industry client. Numeric and graphic analysis per period, vs target and vs previous year, with correct formatting of data presented in graphic form.

KPI dashboard

Reviews

Changes saved

Showing 1 - 5 out of 50+ reviews

Filter reviews by:

5.0

$1,026.00 USD

Excel Calculoations

Highly recommended!!

Albert R.

@miamialbert

•

8 years ago

5.0

$147.00 AUD

Bookmaker Analysis

I was so busy and not always in contact. The patience of this freelancer was awesome and I will use him again.

M

Miranda M.

@Manikayla

•

8 years ago

5.0

$55.00 USD

Business & Finance Plan / Finance Expert required

Roman is an Excel Champ .... Brilliant job. Many Thanks I would strongly recommend him to others and shall be hiring again soon :)

Business Analysis

Financial Analysis

Harmohinder Singh G.

@Orangootan

•

9 years ago

5.0

$37.20 USD

Google Spreadsheet Coding

Dviruki was a great contractor who got the job done without any problems. Would hire him again! [06 October, 2015] Would use again!

Google App Engine

Christian R.

@crouletcn

•

9 years ago

5.0

$175.00 USD

Project 8553194 has been deleted

Took on a difficult and long project, no easy tasks and handled the chaos well. I would recommend this Freelancer.

Ross J.

@SSTOTAV37B

•

9 years ago

Experience

Major regional investment company

May 2006 - Oct 2015 (9 years, 5 months)

Over 8 years of invesment and financial consultancy, investment management, financial research&analysis

Big-4 audit firm

Aug 2002 - May 2006 (3 years, 9 months)

4 years of investment consultancy, audit and accounting experience

Education

BA in Economics, cum laude (from a Top-3 ranked institution in the country)

Ukraine

1996 - 2000

(4 years)

Qualifications

Association of Chartered Certified Accountants

2015

Unfinished for personal reasons, 1 exam to complete

CFA Institute

2015

Ongoing

Contact Roman Z. about your job

Log in to discuss any details over chat.

Verifications

Preferred Freelancer

Identity Verified

Payment Verified

Phone Verified

Email Verified

Facebook Connected

Certifications

US English 1

93%

Basic Numeracy 1

92%

Accounting Principles 1

90%

UK English 1

85%

Freelancer Orientation 1

80%

Top Skills

71

30

Data Processing

25

5

4

Browse Similar Freelancers

Excel Experts in United States

Data Entry Clerks

Data Processing Executives

Browse Similar Showcases

Data Processing

Invite sent successfully!

Thanks! We’ve emailed you a link to claim your free credit.

Something went wrong while sending your email. Please try again.

Loading preview

Permission granted for Geolocation.

Your login session has expired and you have been logged out. Please log in again.