sergey kryukov

* Compiled key assumptions, risks and opportunities for the budget from 6 countries * Prepared analysis of top brands by profitability and country * Identified key drivers of performance and analyzed price and volume effect on sales by country and brand

* ACHIEVEMENTS: * ● x8 faster reporting with Excel VBA & SQL ● 3 fully automated processes ● 2 interactive KPI dashboards developed * FUNCTIONS: * Analyzed business processes and acted as a liaison between IT and business to drive change management initiatives * Led a project to automate client reports with SQL and Excel VBA macros and decreased execution time from 2h to 15min * Initiated and executed a project to automate workflow for submission of sales reports using Excel VBA macros and SharePoint * Developed 2 interactive KPI dashboards used to simplify decision making on call center performance evaluation * Queried and analyzed big data from various sources, developed and prepared finance, operations and sales reports * KEY SKILLS: * Report Preparation, Financial Reporting, Business Analysis, Financial Analysis, Business Process Automation, Data Analysis with Excel VBA & SQL, SharePoint

* Performed in-depth market research identifying company’s strengths, weaknesses, and opportunities for growth * Prepared marketing plan that helped increase attendance by 20% and raised product sales * Developed MS Excel database to organize sponsors' information * KEY SKILLS: * Market Analysis, Data Research, Data Analysis, Business Strategy, Budgeting, Forecasting

* Built relationships with clients over the phone through actively listening to their needs and recommending appropriate products and services resulting in excellent customer satisfaction rating * Processed over 1000 customers’ orders annually and directed it to the engineers to ensure optimal workload * Organized and maintained a customer database using MS Excel and 1C * KEY SKILLS: * Customer Service, Excel VBA, Database Management, Data Analysis

* Installed equipment and product displays according to the planograms * Managed inventory and placed orders when necessary * KEY SKILLS: * Customer Service, Team Work, Inventory Management, Attention to Details, Manual Labour

Finance Business Partner at Novartis

Activities and Societies: Student Club Leader at Touch of Love (Help The Homeless Project), Canada