SQL Developer

Был больше месяца назад

160 000 ₽

39 лет (родился 02 ноября 1986), не состоит в браке, детей нет

Москва

Марьино

Занятость

полная занятость

Гражданство

не указано

Контакты

Телефон

Почта

Будут доступны после открытия

Фото, имя и контакты доступны только авторизованным пользователям

Опыт работы 14 лет и 5 месяцев

- Январь 2014 – работает сейчас
- 11 лет и 11 месяцев
Database developer
TTS, LLC, Москва
Обязанности и достижения:
Operate SQL Server 2012 and develop on T-SQL automated clients segmentation analysis for marketing research department. Utilize Integration Services and Analysis Services to maintain five cubes.
- Февраль 2010 – июнь 2011
- 1 год и 5 месяцев
Software Developer Lead
TechnoFarm, CJSC
Обязанности и достижения:
Accomplished Delphi-pattern to design DB-pluggable reports, for this utilized set of VCL (DevExpress, TEXLReport and TXLSReadWrite), and implemented in-house tool to update reports of such type. Organized group of five developers for evaluation of template.
- Февраль 2010 – июнь 2011
- 1 год и 5 месяцев
Senior developer
NefteTransService, LLC MC
Обязанности и достижения:
1. Routes TurnOver Redesigned computing model in SQL Server 2008 R2, that is to say introduced traffic dispersal and calculated aggregates for seven car flow aspects. Improved engine performance, namely implemented multistaged metadata cache and parallelized routes processing by programmatically generating SQL Server Agent jobs, leading to 8-12 times reduction in total computation duration which amounted 30-40 minutes. Created charts and diagrams for vivid depiction of estimated railcar turnaround in Report Builder 3. Utilized Excel COM-interface through PowerShell on virtual machine and accomplished daily delivery of a report approved by CEO for more than 120 employees. 2. Subsidiaries KPIs Architected database tables for capturing responsibility structure of 11 subsidiaries and developed on SQL four reports, where queried car operation tables (500 thousand new operations per day, operative cache-table 43 million, history 530 mn.) and flights table (250 columns, 4 million rows) 3. SQL Server Analysis Services (OLAP cubes) Reduced flights uploading to OLAP cube from 40-60 down to 15-20 minutes, for that replaced Integration Services dtsx-package with PowerShell ETL mechanism. Constructed script extracts achieved Excel-files (30-100 thousand lines) from incoming mailbox messages, imports refined file to DB (using bulk insert), fills tables and runs cube processing. Utilized Business Intelligence Development Studio (BIDS), implemented three new dimensions in cube and established tool to investigate competitive landscape for logistic department, and also invented on SQL shipment sequence recovery algorithm and repaired 73 million rows of flights data warehouse for strategic government. Built cube for estimating time intervals for cars perfoming twofold-operations, for this purpose created 5 duration measures and 15 flight dimensions. 4. Dislocation distribution Applied Visual Studio 2010, DevExperience and web API of Reporting Services (SOAP, class ReportExecutionService) and enhanced car dislocation delivery configurator (C# tool) as follows - designed 6 RDL-templates, implemented GUI-options for compressing outgoing Excel files (Zip Rendering Extension) and implemented SQL procedure for logging and guaranteed delivery. 5. Report Server maintenance. On SQL found source of error in load-unload report and eliminated defect cooperatively with outsource-developers by repairing data of table daily filled with additional 100-120 thousand rows.
- Сентябрь 2008 – сентябрь 2009
- 1 год и 1 месяц
Software Developer
Gambramedical, LLC
Обязанности и достижения:
On Delphi 7 created sync tool for hemodialysis Russian hospitals equipped with hardware-software complex running SQL Server 2005 through using MS SQL BCP utility. Invented bio intuitive interface EVA (ExalisVisualAnalyzer) - physicians GUI tool for retrospective analysis of patients hemodynamics, for that utilized WinAPI (gdi32.dll) through VBA.

Образование

- Среднее специальное образование
- Дневная/Очная
- 2005
State Educational Institution Mocsow Technical Secondary School
Специальность: Software for computing machinery and automated systems, Diploma with mention of excellence
- Среднее специальное образование
- Дневная/Очная
- 2005
State Educational Institution Mocsow Technical Secondary School
Специальность: Business Administration, Additional Education Certificate

Обо мне

Дополнительные сведения:

Strive for result. Languages: T-SQL, Delphi (Object Pascal), C#, Power Shell, VBA. IDE: Delphi (7, 2006, 2010, XE, XE2), Microsoft Visual Studio (2005, 2010). VCL: DevExpress, SDAC, DevExperience, ADO. SQL Server (2000, 2005, 2008, 2008 R2), Services: Reporting, Analysis, Integration (SSRS, SSAS, SSIS). StarTeam, Visual Source Safe (VSS), Jira.