Developing new and supporting existing internal .NET applications - desktop and backend. Mostly C#, sometimes VB.NET.Adding new functions and supporting existing internal VB6 applications (more than 100 of them) – desktop and backend. It also includes MS Access apps and VBScript scripts.Developing new MS SSRS reports.Dealing with data in MSSQL databases, that are used by the applications above. Handling Data Update Requests from users.Developing new and supporting existing MSSQL procedures that are used by the applications above.Dealing with some MSSQL DTS packages.Troubleshooting all the above, isolating and resolving problems.

Contractor at Deloitte, LLC. Working on “Delaware Eligibility Modernization” and “Child Care” project in Deloitte Consulting LLC. Planning and developing complex WCF-services and business logic from legacy COBOL sources. Developing complex SSIS ETL packages. Designing and developing the dynamic web front-end screens using all modern ASP.NET features and third-party controls (DevExpress). Providing a code review, testing and fixing a defects on a daily basis. Technical environment: C# 4.5, IIS, MS SQL-2012, WCF services, MS Entity Framework, SOA, ASP.NET, WebForms, SSIS for MS SQL 2008-2014, TFS.

•Planned and built Enterprise-wide Human Resources Directory (64000 employees, 4000 departments) combined with hardware inventory database with several web-intranet frontends and flexible and powerful reporting mechanism, using C#, MSSQL, WCF, Winforms, Webforms, MSMQ and OData•Developed Intelligent analyzer and data bridge for distributed HR-accounting system databases, between 1C HR database and Enterprise Human Resources Directory using C#, MSSQL, XSD•Developed several docflow and reporting applications using own object-relational mapping framework using C#, Winforms, MSSQL, SSRS•Improved enterprise docflow/EDI system in area of attachment storage – converted all TIFF-attachments to PDF format (via iTextSharp library), so the database usage dropped 6 times - from 1 terabyte to 170 gigabytes (C#, MSSQL)

•Planned and developed information system of Custody - for two-way EDI in Agency Sales Network and Registrar Interaction for Asset Management Customers using C#, WCF, WPF, MSSQL, MS Access.

•Designed, developed and supported software modules, web sites and web services - automated calculating of car insurance using C#, ASP.NET and WCF

•Participated in development of fast C# MSSQL-based ORM Framework (PioFramework) and code generator for it - allows create complete data model C# classes, SQL CRUD procedures and functions, and necessary Windows Forms (list controllers, entity forms, filter forms etc.) in few clicks, now given to open-source: https://github.com/lmedvedev•Participated in planning, design and development of company’s Asset Management information system, which consisted of the following parts (subsystems):1.Enterprise-wide securities directory with daily updated quotes from different data sources.2.Mutual funds back office accounting system (serving 11 funds with more than 2 million shareholders)3.Trust management back office accounting system (serving about 200 clients)4.Complex and durable portfolio management system5.Company’s reporting system with set of management and operational reports6.Company’s website with daily updatable mutual funds NAVs (net asset values).All these subsystems initially were made with VB6, VBA (MS Access), classic ASP and Oracle 7, then with my direct participation migrated to .NET (starting .NET 2.0), C#, MSSQL, SQL-CLR, ASP.NET, SSRS, SSIS. The final versions used were .NET 3.5 and MSSQL 2008.

•Planned and developed storage-management system with Borland Pascal, dBase4, VB5, VB6 and MSSQL