Jegor Andrejev Email & Phone Number

North Shields, Gb

Newcastle Upon Tyne, England, United Kingdom

Newcastle Upon Tyne, United Kingdom

Worked as Commercial Data Analyst for a global law firm in Transform department that was created to redesign and improve how legal projects and matters can be delivered through innovation and technology. Supported EMEA Commercial, Resource Management, Pricing, Legal Projects Management, Products teams, actively worked in collaboration with Finance, HR, Revenue, Billing, Compliance departments. Became an expert in Power Bi through continuous learning, improving, creating reports and interactive dashboards using advanced DAX with no previous experience before starting the role. Converted all operational Excel reports into Power BI Reports

Newcastle Upon Tyne, United Kingdom

• Played a key role as the new Mercury system advisor and Financial Management Associates (FMA) assistant/administrator• Was responsible for PAS, TAX, 2 Global clients, Actuarial code set-ups including checks on all documents, metrics (budget), approvals, resource mix, client acceptance• Guided Engagement Managers through creating, extending budget as well as Price Approving Framework, write up/down process and code closure, billing, credit notes, holding code time and expenses transfer

United Kingdom

Birmingham, United Kingdom

● Responsibility for the recruitment and selection of suitable candidates for businesses includingJaguar Land Rover and DHL Supply Chain● Played a key role assessing an average of 15 candidates per day as part of the pre-employmentprocess, this included the introduction, interview, induction training as well as drug and alcoholtesting● Managed the booking of training, forklift assessments utilising the in-house system Infinity aswell as submitting Disclosure Scotland CRB checks, efficiently updating all data on the systemincluding CRB, pool pending and register trackers maintaining accuracy and compliancethroughout● Adhered to all industry standard guidelines and protocols handling sensitive information,securely maintaining records for audit purposes● Utilised excellent communication skills building strong and productive relationships bothinternally and externally at all levels● Achieved against deadlines and forecasted labour requirements, fulfilling daily volume targets

Stratford Upon Avon/Sutton Coldfield

● Responsible for the management of numerous food and beverage activities within this leadingorganisation which has a number of 4* hotels, working at Ettington park Hotel in Stratford until April2016 before moving with the company to New Hall Hotel and Spa in Sutton Coldfield● Managed all activities to an exceptional level, this includes the restocking of the bar, providing anexceptional customer service, overseeing complaints and issues through to resolution and thecompletion of financial transactions● Maintained an excellent stock knowledge, completing the stock taking process in an accurate andtimely manner● Completed extensive liaison with customers, providing product and service expertise, demonstratinga comprehensive knowledge of whiskies and wines● Directly responsible for the management of administrative process, inputting till receipts onto anExcel● Plays a key role during numerous events which includes large scale conferences and weddings, thisinvolves guest numbers ranging from 40 to 250● Supervised and led temporary employees to ensure achievement of all objectives● Ensured full cash control, working with a minimum figure of £3,000● Continually drove revenue and profitability through the promotion of branded products and cocktails● Successfully rewrote all food, drinks and wine menus

Coventry, United Kingdom

● Successfully oversaw all activities within this busy off license store, working on a part timebasis whilst studying and acting in the capacity of assistant manager● Built and developed excellent customer relationships, ensuring a quality service isparamount, providing product and service knowledge and dealing with enquiries and issuesthrough to resolution● Played a key role within the merchandising process, ensuring full pricing management andthe delivery of engaging and attractive product displays● Utilised extensive skills within Word and Excel when completing store orders, conductingcomprehensive supplier liaison● Managed all financial transactions accurately and in a professional and timely manner● Effectively completed all additional tasks which includes maintaining the company website● Provided ongoing support and business guidance to the proprietor, using excellent financialknowledge acquired from studies