Financial Analyst, Productivity Analysis, FP&A, P&L, Excel, VBA

Gregory Filatov

**** **** *** **, *** #*G, Brooklyn, NY 11224

718-***-**** ***********@*****.***

EDUCATION

Universität des Saarlandes, Europa Institute (Saarland, Germany)

• MBA in European Management (October 2017)

Zicklin School of Business, Baruch College (CUNY)

• BBA in Finance (September 2012)

WORK EXPERIENCE

Rose International (02/2015– 06/2016)

Siemens Healthineers, Financial Analyst II (LT Contract)

• Analyzed DX Productivity results to determine accuracy and completeness of information

• $150+ million cumulative yearly savings with 3000+ measures

• Prepared and updated multiple Productivity financial reports

• Prepared and updated monthly Headcount reports

• Managed monthly close process

• Audited and updated Productivity measures prior to monthly close

• Supported Procurement department by pulling CTE (Currency Translation Effects) data and updating related reports

• Supported Productivity system reports by monitoring user compliance and managing user rights

• Modified Excel files with advanced functions and macros to simplify reporting process

Robert Half – Salaried Professional Services (06/2014 – 12/2014)

Tiffany & Company, Financial Analyst (ST Contract)

• Assisted with weekly and monthly sales forecast for over 100 stores in North America

• Pulled, reviewed and analyzed P&L data for North America and Canada utilizing Business Objects, Hyperion Essbase and Excel

• Developed completely automated templates foe sales professionals to be used by store managers in North America

• Automated headcount templates for US Regions and Canada

• Analyzed international tourism for Tiffany stores outside of United States

• Assisted in preparation of monthly business review binders for upper management

OpenLink Financial, Junior Financial Analyst (ST Contract)

• Completely automated P&L Forecasting updates entry for instances that were missing unique identifiers with reverse match to spot new entries

• Greatly enhanced P&L Forecasting model to speed up the entry process and eliminate a possibility of human error

• Performed weekly P&L forecasting and Monthly Revenue-by-Client updates with Transfer Pricing adjustment

• Assigned unique IDs for revenue entries; matched them with contracts and entered missing information to prepare a transition to SalesForce

• Extensively used excel skills utilizing regular and nested functions including index match, lookups, -if, -iserror, etc. on daily basis

Robert Half – Accountemps (03/2013 – 10/2013)

Thrive Metrics, Professional Services Analyst (Contract)

• Was the first analyst to work for the company and, with minimal guidance, delivered the first report in under two weeks after initial hiring

• Developed new data analysis models based on client’s requests

• Created custom reports on organizational, divisional and departmental levels

• Created and maintained complex spreadsheets for data visualization and interpretation

• Made custom data presentations with statistical analysis and summary

Federation of Protestant Welfare Agencies (03/2011 – 06/2012)

Accounts Payable Clerk/Administrative Assistant Intern

• Provided accounting and record-keeping functions for FPWA’s member agencies (150+)

• Additionally, was trained as Group Purchasing Services (GPS) agent to substitute a resigned employee

• Processed check requests for Emergency Food and Shelter Program (EFSP) participants (40+)

• Completely digitized document storage mirror-imaging physical documents with their electronic equivalents for ease of access

• Consolidated Emergency Food and Shelter Program documents for audit semi-annually

• Performed monthly internal audit review to avoid discrepancy in the information entered by FBS department

SKILLS AND OTHERS

• Skills: Highly proficient in MS Excel (pivot tables, h/v-lookup, index match, macros, financial functions, nested functions)

PowerPoint; advanced Essbase (Hyperion), One Puma Web; basic Business Objects, Tableau, SalesForce

• Languages: Fluent English, fluent Russian

• References: Upon request

Contact this candidate