Trifonov Andrey | CV

CV Trifonov Andrey

BI Analyst/Data Scientist. 

I'm interested in development of Business Intellegence systems and Big Data analysis.

My roles in a team could be: 
Software Engineer, Systems Analyst, Business Analyst, Data Scientist, IT Trainer
Work experience
09.2017 - present, MegaLabs, Moscow,
- Developed ETL, integration scripts
- Designed BI-dashboards, data visualization
- Ad-hoc analysis

06.2016 - 09.2017, Rosgosstrakh, Moscow,
Oracle Developer
- Developed BI sytems
- Developed Ad-hoc reports
- Wrote Functional Requirements for Reporting
- Developed Integration scripts

08.2013 - 05.2016, Vimpelcom Russia, Moscow,
Customer Experience Management systems Architect
- implementation in Beeline
- Employee NPS system design and development 
- Data integration process with CRM, DWH, GlassFish systems
- DWH, Big Data ad-hocs
- Creation of Monitoring system, SLA
- Marketing Research pilots functionality in
- Metricell Quality Experience pilot in Beeline

01.2009 - 01.2013 , Vimpelcom Russia, Moscow,
Expert in BI systems
- Developing and support of Financial Reporting System in Beeline 
- Trainer of Oracle DataBase 11g SQL Tuning Workshop in Beeline Universuty
- Ad-hocs for Sarbanes-Oxley Act (SOX)
- Algorithms of inventory accounts payable and receivable activities
07.2008 - 01.2009 , RealTime Consulting, Moscow
Systems Analyst
- Ad-hocs for Sarbanes-Oxley Act (SOX). Outsourcing in Vimpelcom.

07.2006 - 08.2007 , IPG company,
Programmer and developer
- Automation of the air traffic control for Aeroflot Russian Airlines company. 

03.2005 - present , Freelancer
Mobile Application:
Cloud Application:
Advanced WordPress sites:

09.2001 - 05.2004 , Physical and Mathematical School of Moscow Aviation Institute
Mathematics Teacher

2001-2008 Moscow Aviation Institute, department of applied mathematics 
and physics.
Degree: Master-Science (Professional), specialization: applied mathematics and computer 
science, qualification: mathematician, system programmer.

2011-2012  State University of Management (SUM), Master-Science, Accounting
Additional certificates
2011, BusinessObjects XI Report & Universe Design cource
2013, 6.00x: Introduction to Computer Science and Programming MITx (
2013, Oracle Database 11g: SQL Tuning Workshop Ed 2 PRV RDTEX Moscow
2014, Oracle Java SE7 RDTEX Moscow 
2017, Python for Data Science
2017, Tableau Fundamentals

Core skills
SQL, PL\SQL, Python, ETL, Tableau
Oracle, PostgreSQL

Additional skills:
Oracle Database: developer/administrator
SAP Business Objects: universe/report designer
Informatica PowerCenter, Pentaho DI ETL developer
PHP (Yii framework), JavaScript (jQuery), XSLT, CSS, HTML
Java (Android)
Microsoft Office/Google Docs
Big Data hortonworks
Programming languages: PL\SQL, SQL, Java, C#, Python, PHP, Perl, C++, Delphi/Pascal, Prolog.
OS: Windows, *nix
Version Control: Git, TFS
Data modeling, architecture and business proccess design. 
English, native Russian

skype: andrei-trifonov

Location: Russia, Moscow