Алексей Литвинов

11+ years of MS SQL development
7+ years of experience as a DWH team lead
Designed, documented and implemented Data WareHouse for two banks, an insurance company, and a factoring company.
7+ years of experience in all phases of life cycle of DWH implementing (requirements analysis, design, implementation, and test).
 

⦁ DWH Engineering:
- Proficient in requirements design, building, implementation, and test of DWH.
- Experience in SQL developing with large databases (10 TB+)
- Experience with DWH projects in financial company (Bank, Insurance, Factoring)
- Experience with high requirements data quality (for management and analytical reporting)
- Experience with ETL-process improvement (root cause analysis and corrective action: data modify, code correction, code optimization)

⦁ Documentation:  7+ years documenting ETL-process of DWH product

⦁ Architect/Project Leader: 7+ years as DWH architect/project leader responsible for general design and for coordinating work of Department

⦁ Mentor/Trainer:  5+ years experience mentoring developers in SQL. Two colleagues got as Head of DWH Department after mentoring of mine.

⦁ Key skills: MS SQL, SSIS (SQL Server Integration Services), SSAS, SSRS (Reporting Service), OLAP (online analytical processing), CLR SQL (C#), Linked Server setup, MS Visual Studio, Windows Forms C#, TFS, XML, clustered and non-clustered indexes creation, Pentaho, Informatica, Power BI, query optimization, triggers.
 

2014  Moscow State Academy of Instrument Engineering and Computer Science, IT, Automated information processing and control systems, Master
2009  Moscow State College of Informatics and Electrical engineering
Software for computers and automated systems, Base education