Русский|English

CV Trifonov Andrey

BI Analyst - Data Scientist. 
Aim: working as a Software Engineer.

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, http://www.megalabs.ru
Analyst
- Developed ETL
- Ad-hoc analysis

06.2016 - 09.2017, Rosgosstrakh, Moscow, http://www.rgs.ru
Oracle Developer
- Developed BI sytems
- Developed Ad-hoc reports
- Wrote Functional Requirements for Reporting
- Developed Integration scripts

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

01.2009 - 01.2013 , Vimpelcom Russia, Moscow, http://www.beeline.ru
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, http://www.ipg.ru
Programmer and developer
- Automation of the air traffic control for Aeroflot Russian Airlines company. 

03.2005 - present , Freelancer
Portfolio
Mobile Application:
PiratesPlayer
ShopList
Cloud Application:
customerex.ru
pslublu.ru
Advanced WordPress sites:
zemlemeria.ru
namgarfolk.com

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

Education
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 (edx.org)
2013 Oracle Database 11g: SQL Tuning Workshop Ed 2 PRV RDTEX Moscow
2014 Oracle Java SE7 RDTEX Moscow 
2017, Python for Data Science

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

Additional skills:
Oracle Database: developer/administrator
SAP Business Objects: universe/report designer
MySQL
PostgreSQL 
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, Subversion
Data modeling, architecture and business proccess design. 
 
Languages  
English, native Russian

Contacts:
+79031336121
andrei.trifonov@gmail.com
https://www.linkedin.com/pub/andrei-trifonov/b5/13b/6a3
skype: andrei-trifonov

Location: Russia, Moscow