Andrey Ampilogov Email & Phone Number

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/

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.

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.

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.

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.

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.

Bachelor Of Economics, Quantitative Economics, Gpa - 7.75/10

Causal Inference Workshop