Andrey Ampilogov

Andrey Ampilogov Email and Phone Number

Data Analytics | Excel | VBA expert @ Upwork
santa clara, california, united states
Andrey Ampilogov's Location
Portugal, Portugal
About Andrey Ampilogov

Results-driven data analyst with a decade of rich experience in Microsoft Excel and VBA programming. Adept at handling diverse data tables, from unstructured to relational databases, across multiple industries such as finance, construction, healthcare, economics, pharmaceuticals, petroleum, retail, education, and more. Fluent in both English and Russian, I possess a comprehensive skill set to deliver data-driven insights and optimize business processes.If you have Excel I can create almost anything with it: a dashboard, CRM, database, data manipulation application, reporting tool, and more.More details:https://ampilogov.notion.site/Resume-eef61c6868134e18a6d1039930f9b19a?pvs=4

Andrey Ampilogov's Current Company Details
Upwork

Upwork

View
Data Analytics | Excel | VBA expert
santa clara, california, united states
Website:
upwork.com
Employees:
69122
Andrey Ampilogov Work Experience Details
  • Upwork
    Data Analyst | Stata | Excel | Vba Expert
    Upwork Sep 2015 - Present
    Worldwide
    Freelance is an alternative way of thinking and doing business - build relationships, arrange meetings in different time zones, manage work that can last several hours or half a year.That is also a way of delivering finished and, in most cases, reproducible solution for a Client.70% of my work is about analytics in Stata, the way of building and managing datasets, testing models and producing clean outputs in an academic style. Another 30% is Excel-related: building programs in VBA (from simple spreadsheet development to developing add-ins or complex engineering systems), optimisation tasks (using solver or writing my own algorithms/code), stock accounting system in a motorcycle store, and many more others.My clients are all over the world: Russia, Sweden, UK, US, Australia, Lebanon, Singapore, France, Germany, Canada, Switzerland. That's a great opportunity to develop and empower communication, personal and business acumen, lightness of thinking - that every situation can be resolved in a clean and pleasant way for all sides of the job.In general, I've done 50+ jobs on UpWork. Contacted hundreds of people. Tested thousands of aspects of my persona, both professional and personal.And I'm ready to move forward somewhere else. Feel free to contact me.My personal page on UpWork:http://www.upwork.com/o/profiles/users/_~017027c06b3c001d71/
  • Arima Analytics
    Expert In Econometrics And Data Analysis
    Arima Analytics Dec 2018 - Present
  • Sed'Moy Kontinent
    Spss Programmer
    Sed'Moy Kontinent Aug 2014 - Aug 2015
    Moscow, Russian Federation
    — Being at the core of company, suggesting and developing solutions which directly affect company business;— Being an IT specialist, data scientist, statistician/econometrician, and an ordering party at the same time;— Reports-on-demand for HR, Operations, top-management;— Developing of self-ordering system for millions of goods;— Automation of ETL and reporting processes using SQL, IBM Cognos, Microsoft Office products;— Development of optimization and distribution algorithms for HR and Operational departments.
  • Alfa-Bank
    Senior Analyst
    Alfa-Bank Jul 2013 - Jul 2014
    Moscow, Russian Federation
    — Development and implementation of an algorithm for optimal distribution of bank’s employees in branches all over Russia. — Distribution of data from/into departments, Development of data warehouse in Microsoft SQL Server;— Ad-hoc analysis (analytics and modeling for business requirements);— Identification of potential high-insolvency clients using empirical scoring models;— Development of identification model of clients with best possible offer;— Business process optimization using Lean Six Sigma methodology;— Broad usage of VBA to program algorithms and analysis.
  • National Research University - Higher School Of Economics
    Researcher At The Laboratory For Institutional Analysis Of Economic Reforms
    National Research University - Higher School Of Economics Feb 2011 - Jul 2013
    Mosow
    — Database normalisation, statistical analysis of distributions, errors, patterns in data;— Application of theoretical and empirical models on actual data;— Presentation of research results at international conferences and workshops of the HSE;— Parsing web pages into database using VBA in Microsoft Excel.
  • The World Bank
    Short-Term Temporary At The Computational Tools Department
    The World Bank Jul 2012 - Sep 2012
    Washington D.C. Metro Area
    — Processing data in Stata using matrix language, regression analysis, vector arithmetic;— Application of classic and modern statistical models including regression analysis, probability models, — Development of students’ college choice model;— Analysis of outliers, patterns in data, bottlenecks in models outcome.
  • Bona Mens Audit
    Junior Auditor
    Bona Mens Audit Jun 2010 - Dec 2011
    Moscow
    — Contributor to unique financial analysis methodology;— Improved calculation and reporting process from two days to 35 minutes;— Verification of more than 200 companies financial and industrial data;— Restoration of data from corruption (like human errors);— Analysis of oil&gas industry using data from SPARK-Interfax, FIRA-Pro, NCB;— Expanded the methodology with a scoring model.

Andrey Ampilogov Education Details

Frequently Asked Questions about Andrey Ampilogov

What company does Andrey Ampilogov work for?

Andrey Ampilogov works for Upwork

What is Andrey Ampilogov's role at the current company?

Andrey Ampilogov's current role is Data Analytics | Excel | VBA expert.

What schools did Andrey Ampilogov attend?

Andrey Ampilogov attended Higher School Of Economics, Northwestern University School Of Law.

Who are Andrey Ampilogov's colleagues?

Andrey Ampilogov's colleagues are Grace Narit, Laiq Ahmed, Muhammad Talha, Yaseen Khan, Muhammad Roheel Ashraf, Osman Goni, David Damchevski.

Not the Andrey Ampilogov you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.