Sergey Melikhov

Implements business logic API in SQL and Python for the Volcker Rule regulatory compliance data warehouse. Contributes to the database and application design Works on data processing, aggregation and analysis (Python, QzTable) Developed efficient, reliable, low-latency data replication from RDBMS to OODB, thus enabling implementation of a user-friendly and responsive UI (Python, multiprocessing) When early on the project, reviewed and stabilized available code base with use of methods of structural an OO development, applied to dynamic SQL Deals with 10+billion row tables, joined with many configuration, correction and override tables Created database query regression test tool with Python Resolved performance issues of the original SQL code and reduced code duplication Suggested and implemented better practices for code maintenance and performance. (Environment: IBM Netezza 7.2, 1 billion row tables, SQL, Python, Quartz, Aginity, Toad Data Point, Agile/ SCRUM)

Developed OLTP and data warehouse parts of a sales support system (SQL Server 2008, Stored Procedures, Functions, Types, schema design, static and dynamic SQL, tens of million row tables, SVN source control, VS2010 database projects, VS2012 SSDT, ER Studio) Improved performance of the legacy database objects (T-SQL) Created a highly configurable, data driven ETL framework (T-SQL) Developed web services (C#/.NET) ,configurable SSIS packages and ETL scripts for UNIX (Perl/KSH)

Performed system and database design, front and back-end development for the application intentory system (MS SQL 2005/2008, C#, ASP.NET, SVN, data caching, stored procedures, etc) Data analysis, database and query design for the infrastructure efficiency system ( MS SQL 2000, T-SQL, UDF, Stored Procedures ) and for a employee spending efficiency system ( ORACLE, PL/SQL, Packages, Stored Procedures ) ETL (DTS, C#/.NET, Enterprise Library, AutoSys, SVN source control)