Alex Kornilovski

Alex Kornilovski

Summary

I have more than 12 years of professional experience, of which 6 years in various roles servicing financial industry; banking; information architecture; business processes optimization using business intelligence tools.

I am a well seasoned Business Intelligence Architect and Project Manager with an extensive knowledge in BI field, OLAP, Data warehousing, ETL and reporting technologies as well as knowledge of Fixed Income and P&L systems. I have a deep knowledge of vector based programming and systems (K/Q/KDB, APL, J, VCL) in application to financial and telecommunication industries.

I have over 2 years experience managing some major development projects for the US branch of a Russian IT services and business intelligence solutions provider company, ZAO "Otido".

PATENTS:

Database System and MethodsUnited States Patent 7249118Used as the basis for Liquidity Management Systemimplementation by Aleri Inc

Specialities: 

Business IntelligenceStructured Finance/Fixed Income

Vector-based systemsProject ManagementRisk ManagementData Modeling/Architecture

Work History

Work History
Sep 2008 - Present

Enterprise Data Warehouse Architect

http://www.blackstone.com

  • Responsible for design and managing development effort for Blackstone’s enterprise data warehouse
  • Managing team of offshore developers.

Environment: SQL Server 2005/2008, SSAS 2005/2008, SSIS, SSRS 

Jun 2005 - Sep 2008

VP

Bank of America
  • Managing team of four developers.
  • Sole architect and project manager ofthe bank-wide Business Process Management system using SSAS2005 and ASP.NET
  • Sole architect and project manager of the bank-wide real-time P&L estimation/reporting system using Panorama dashboards and ASP.NET.
  • Sole architect and project manager of the Data Warehouse and OLAP cubes infrastructure for the Global Structured Finance and ABS/MBS departments.
  • Extensive MDX query development for Reporting and Analytical purposes using ProClarity and SQL Server Reporting Services products.
  • Design and implement data warehouse based on Sybase IQ DBMS using Informatica and SQL Server Integration Services. This includes the handling of new data, slowly changing dimensions etc.
  • Developed several analytical cubes for financial analyst/traders for viewing and analyzing current and historical data using MS AS 2000/2005.
  • Developed and implemented reporting Infrastructure using SQL Server Reporting Services 2005

Environment: SSAS 2005, MSAS 2000, SSIS, SSRS, Informatica, Sybase IQ, ProClarity and Panorama.

Mar 2001 - Jun 2005

Senior Software Architect

Aleri
  • Design and develop static and transactional vector-based OLAP engine (VCL/K).
  • Responsible for performing competitor analysis of Microsoft OLAP.
  • Responsible for the design, development, and deployment of the company’s proprietary vector-based data manipulation engine written in VCL (a K dialect).
  • Develop, design, and maintain the transactional Minimal Recalculation Engine that accepts messages from Tibco Rendezvous, MQ, and other adapters (VCL/K).
  • Gather and document business requirements from clients: Lehman Brothers; Barclay’s Capital; Deutsche Bank; UBS.
  • Cooperate with clients to design and develop real-time analysis tools.
  • Design and implement algorithms for distributed calculations in the data manipulation engine.
  • Design and implement tools to implement data export from Aleri’s engine to the conventional databases.

Environment: VCL, K, UNIX, Windows 2000, MS SQL Server.

Feb 2002 - Dec 2004

VP of Development

Otido Ltd.

·Managed new business development initiatives and pilot projects.

·Designed and implemented pilot project for Moscow Government Real Estate Commission using MS AS 2000, VB.NET, ProClarity and Oracle.

·Designed and implemented a pilot project for German Railway System using K, KDB, and J programming language.

Nov 1999 - Mar 2001

Senior Software Developer

http://www.cognos.com
  • Developed and implemented a prototype of the OLAP calculation engine that uses sparse datasets.
  • Responsible for the design, development, and maintenance of Cognos’s E-planning application for planning and performance management solutions.
  • Maintained and developed new functions for the Cognos’s E-planning application.
  • Rewrote a TCP/IP interface for J programming language.
  • Internationalized Cognos’s E-planning application.

Environment: J, APL, Windows NT, MS SQL Server.

Dec 1997 - Nov 1999

Lead Developer

http://www.accordfinancial.com/
  • Responsible for the design, development, and maintenance of Accord’s in-house software providing automation of the factoring business.
  • Independently completed Y2K compliance project.
  • Developed and implemented modules, tools, and user interface components.

Environment:APL, HP-UX 10, Windows NT.

Education

Education