Personal details

Sergey M. - Remote

Sergey M.

Timezone: Eastern Time (US & Canada) (UTC-4)

Summary

Creates Obeject-Oriented, fast and efficient solutions with Python and C# Writes elaborate and performant SQL queries and stored procedures Expertise in the T-SQL, Netezza/IBM PureData SQL; Oracle PL-SQL and data modeling Developed web services, web sites and code modules in Python and C# for efficient data access Has extensive UNIX/Linux engineering and development and Windows development experience

Work Experience

Senior Database/Python Developer(VP)
Bank of America Merrill Lynch | Dec 2014 - Present
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)
Database Developer (consultant)
Bloomberg LP | Jun 2012 - Nov 2014
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)