SUMMARY:

• Seeking an opportunity to apply my knowledge and over 20 years of experience to design and implement an effective and maintainable enterprise software solutions.
• .NET, high quality C# and DB design/development/coding.
• Multiple industries experience: Financial, Health Insurance, Real Estate, Healthcare, Biotech, E - Commerce, Electronic device low level development etc.

TECHNICAL SKILLS:

Technologies: .NET, WCF, RESTful web services, Web API, Entity Framework, WPF, MVC, WinForms, SQL server, Oracle, XML/XSL, ASP.NET, Silverlight, Windows 32 API…

Programming languages: C#, T-SQL, Typescript, PL/SQL, Borland Delphi, CSS, VB.NET, Java Script, C, Turbo Pascal, Assembler x86, Fortran 4/77…

Databases, tools and other applications: Microsoft SQL Server 7 - 2016, Oracle 7.3 - 11g, CA Erwin, Red Gate SQL compare, Ants profiler, MS SSIS and DTS for ETL, Tibco Turbo XML, Visual Studio, ReSharper, Oracle Failsafe, Interbase v4-5, TOAD, Direct Oracle Access (DOA) and Infopower components for Delphi, Report Builder, ODBCExpress components for Delphi, BDE, Paradox, DB2, FoxPro/FoxBASE, Crystal Reports, Microsoft Visual Source Safe, Microsoft Visio, Meran PVCS, MKS, Perforce, CVS, TFS…

EMPLOYMENT:

Confidential, Orange, CA

Sr. Software Engineer

Responsibilities:

• Refactored existing internal WCF services to make them scalable (moving to load balanced environment).
• DB changes to make code run in multithread and avoid deadlocks (SQL Server)
• Removed dependency between different modules and moved parts of WCF service calls to internal method calls (Dry IoC dependency injection, moving code to new common modules etc.)
• Removing and rewriting static classes to be able to run different parts of services in parallel using NCache as a synchronization mechanism between app servers.
• Performance improvements (backend services).
• Monthly billing process was improved from 6-7 hrs to 1.5 hrs. Invoicing was also improved more than twice.
• Testing and fixing bugs related to load balanced services execution.

Confidential, Irvine, CA

Sr. Software Engineer

Responsibilities:

• As part of a team designed, implemented and supported various parts of iMP (intelligent mortgage platform) - the web based mortgage origination system that consists of 2 web SPA: Loan Center and Consumer site.
• C#, RESTful web API, Type Script, Entity Framework, SQL server, Visual Studio 2015
• Designed and implemented integration modules with various vendors
• Performed daily TFS merges for my team branch. Performed code reviews and refactoring of code in all layers of application.

Confidential, Carlsbad, CA

Sr. Software Engineer

Responsibilities:

• As part of a team redesigned DB for processing obtainment requests and renewals, including DAL layer. (ERWin, SQL 2012, C#) Implemented SQL CLR rule based aggregated functions to use in T-SQL. (C#, Visual Studio 2013) Implemented multithreaded processing of the AJAX calls on server side to improve response performance (TPL, .NET4.5, IIS)
• Participated in redesigning DAL layer to change from code first to DB first approach in Entity Framework 6.
• Normalized and moved an existing supplier related data from a flat table to a new table structure, implemented an address book. (ERWin for DB design, Visual Studio 2013, Entity framework (code first), SQL server 2008/2012), Fixed a number of bugs in existing code (MVC controllers and models, existing stored procedures)
• Rewrote a number of stored procedures to centralize a part of business logic using table/scalar functions, moved parts of SQL code to C# (Linq queries) and some performance sensitive implementations to stored procedures
• Implemented a number of enhancements/fixes to the existing MVC/ASP.NET/Kendo UI application, in house scheduled console apps and Windows services.

Confidential, Irvine, CA

Sr. Software Engineer/Data Architect

Responsibilities:

• Designed and implemented DB schema, interfacing procedures and .NET classes for multithreaded LogBook logger - service based logging system.
• It allows logging information to WCF service and if no success - it automatically switches to log4net configuration. (.NET 4.0, task based parallel programming, VS2012, producer/consumer and singleton patterns, C#, Erwin, SQL Server 2008R2).
• Implemented WCF Data Service using EF6 and WPF forms to access the service (server paging for huge record sets, Telerik GridView/Pager, C#, VS2012, SQL2008R2) Implemented a number of WPF forms using MVVM pattern. (VS 2012, MVVM Light, C#, WCF, EF 6, Erwin, SQL server 2008R2)
• Designed and implemented .NET configuration service/client classes/DB. It gets app.config XML data from WCF service call (based on app name and environment ID), creates a local config file and forces .NET to use that file. (C#, Erwin, SQL 2008R2, VS 2012).
• Research and use WPF forms from VB6 GUI (using InteropForms/C#) and from Silverlight (trusted in/out browser app). Reuse the same C# GUI code from VB6 and from SL5, preparing to convert very old VB6 code into WPF and SOA…
• Using Telerik and other 3rd party libraries implemented media viewer.
• It converts text and picture formats to PDF and uses Telerik’s PDFViewer control (WPF and Silverlight).
• Format conversion can be done on server (WCF service) or on client side.
• Converted and cleaned up a huge 62 projects SOA/Silverlight 4/ Visual Studio 2010 solution into VS2012/Silverlight 5 Using Task Parallel Library (TPL) to significantly improve a performance of C# methods (including recursive methods). .NET 4.0, Visual Studio 2010, Red-Gate ANTS Performance profiler and ReSharper, LINQ, SQL server 2008R2.
• DB Reverse Engineering with Erwin and review schema, find/fix bottlenecks and data inconsistencies, Implemented WPF based tool to convert proprietary HTML based data in DB to text format (Visual Studio 2010, C#, Entity framework, SQL 2k/2008).
• Fixing numerous bugs in .NET/C#/SQL code. Performance optimization of some reporting stored procedures (rewrite code, use indexed views etc.) - SQL2008R2 Built WiX MSI installer project (it does a lot of configuration changes during installation as a part of main Install Shield project including registry changes, XML config file changes and s). (Visual Studio 2010/12, WiX 3.7/3.8)

Confidential

Sr. Software Engineer

Responsibilities:

• Designed and developed a prototype ASP.NET app to convert existing desktop client/server LIMS (Log Inventory Management System).
• C#, Visual Studio 2012, DevArt LinqConnect ORM (Linq to Oracle and Linq To SQL), DevExpress controls for ASP.NET, SQL Server 2008R2, Oracle 11G.

Confidential, Irvine, CA

Sr. Developer

Responsibilities:

• Designed and implemented DB schema for preprocessor to transfer Epicor employee’s records from SQL server based Ultipro HR to Oracle HR (Erwin, SQL Server 2008).
• Implemented SSIS package and stored procedures to transfer Ultipro HR records, finds the updated and new records and updated fields and populates the output tables in preprocessor. (Visual Studio 2008, SQL server 2008) Fields validation in Oracle HR (Oracle 11G, PL/SQL, Oracle SQL developer).

Confidential, Aliso Viejo, CA

Sr. Developer/DB Architect

Responsibilities:

• Designed and implemented Web portal configuration tool. (SQL Server 2008R2, Erwin, C#, VB.NET, Visual Studio 2010, WinForms, Telerik controls, Linq).
• Performed DB analysis, performance tuning and redesigned table structure.
• Analyzed implied relationships and applied referential integrity (conversion scripts, fixing bad data, normalization, rewriting procedures, functions etc.).
• ERWIN, SQL server 2008, Tuning Advisor, Profiler Supporting existing applications, fixing bugs, DB side performance optimization including indexed views (MS SSIS packages, SQL management studio, SSRS, Profiler, Visual Studio 2008/2010)

Confidential, Irvine, CA

DB Architect/Developer

Responsibilities:

• Designed and implemented a new EMI DBs (Erwin for DB modeling and E/R diagrams, SQL Server 2008R2/SQL Server Express/Oracle 10 XE).
• Designed a new DB schema/sprocs/triggers/views etc for CIP system for the dairy industry (OLTP), implemented stored procedures/functions/views and triggers for web GUI (ERWIN, SQL server 2005) Debug/Fix numerous bugs and supported existing product installations that collect data from Confidential concentrator PLC and use it for analysis and production process improvement/savings (VB.NET, Linq, SQL Server 2005/2008, SSIS packages)
• Reverse engineered old versions of DB (including replacing triggers with foreign keys)
• Expert level experience architecting and designing SQL Server database
• Extensive experience with SQL performance optimization (including indexed/materialized views, partitioning and use of filtered indexes) Deadlocks resolution, parallel data processing and reporting from OLTP live data

Confidential, Tustin, CA

DB Architect/Sr. Software Engineer, officer

Responsibilities:

• Designed and implemented ratings warehouse to store raw data and ratings history from 3 major rating agencies.
• SQL Server 2005, Visual Studio 2008, Erwin Designed and implemented dynamic valuation module that uses XML and SQL expressions for step-by-step valuation of user-entered expressions (including matrix calculation to valuate test thresholds).
• SQL server 2005 and Visual Studio 2005 for XML/XSD design, SSIS packages.
• Designed DB structure and implemented web interface for CDO trustee report collection/data entry and job assignment/tracking for outsourced team in India (Erwin, C#, ASP.NET 1.1, Infragistics .NET components, Microsoft Enterprise Libraries, SQL Server 2000).
• Designed and implemented batch processing application to copy/move/rename files/directories according to the deals logic/configuration in DB. (C#, SQL server 2000, Infragistics .NET components, Microsoft Enterprise Libraries).
• Designed and implemented Trustee Processor classes/modules/application to import data and process jobs on per-trustee basis (C#, SQL server 2000).
• Supporting and fixing bugs in current CDOSuite system (asp pages, VBScript, JavaScript, SQL server 2000). SQL server performance tuning and rewriting most offending stored procedures. SQL Server 2005.
• Various small in-house projects/patches/fixes.

Confidential, Orange, CA

Sr. Programmer Analyst

Responsibilities:

• Supported and enhanced Empower application including Oracle stored procedures (Delphi 6, Oracle 8.1.7i) Code optimization and performance tuning (Empower dynaforms, Delphi 6, Oracle stored procedures/queries)

Confidential, Livonia, MI

Database Architect/Sr. Software Engineer

Responsibilities:

• Designed DB/XML schemas and as a part of development team implemented Workflow processing system - DB driven distributed application to process production data on 24/7 basis.
• The processes (universal modules for processing production data according to the XML configuration received from DB) are communicating with SQL server using XML (process communication, data exchange, job configuration).
• The processes are running on a number of workstations, DB is controlling the execution and data flow, sending to the processes job configuration, receiving back status information/data/results and automatically unregistering processes in case of expiration/failure and enable the next available process to continue the processing. (MSSQL 2000, Erwin, Turbo XML).
• Designed and implemented Workflow web site to control daily workflow processing, (VB.NET, ASP.NET, SQL server 2000, DTS, BCP, MS IE Web controls, C# for .NET components and Web Services, MD5 password protection, Java Script and DHTML)
• Designed and implemented multithreaded “lazy” log writer class (C#, sync objects, multithread) to write log file from the process (multiple processes may share the same log file and logging is not slowing down main processing thread(s)). Supporting, fixing bugs and converting legacy pre-workflow applications written on Delphi 3-5. (Delphi 3-5, C#, Sybase)

Confidential, New York, NY

Programmer Analyst

Responsibilities:

• Designed and implemented DB structure, COM interfaces and classes for security routines.
• It is validating user account and checks if user is allowed to perform a particular method of the interfaced object within the user’s “company entity” on role-based principles (Delphi 5, SQL server 2000, ADO, COM, and extreme DUNIT for testing). IBM MQ Series access classes design/implementation (on-demand dynamically load MQ Series Client or Server DLL for client or server installation, multithreaded calls support, business layer API) - transfer messages between MQ Series queues and SQL Server tables using COM business classes - company’s proprietary BondFire architecture (Delphi 5, Microsoft SQL Server 2000, ADO).

Confidential

Software Developer Analyst

Responsibilities:

• Analyzed business requirements, designed database structure and implemented the Portfolio Management System - web based portfolio allocation system to manage client’s portfolios in groups and individually with advanced online graphical reporting system.
• System allows sell/buy securities on a master account level (group) and splitting the transactions between client’s accounts according to their model portfolio; optimized rebalancing within master account; suggestions on what to buy/sell in order to maintain model portfolios.
• Microsoft Visual Studio.NET, ASP.NET, C#Oracle 8.1.7i, XML, JavaScript, Delphi 5 CGI, Tee Chart components, Adobe PDF Distiller and ReportBuilder 6 for online web reports in PDF format)
• Developed service application to manage user groups, price data import from FoxPro 2.6 to Oracle (Delphi 5, Direct Oracle Access components for Delphi, ADO, and Oracle PL/SQL). Upgraded to Oracle 11G and performed various DBA tasks ( )

Confidential

Consulting Associate

Responsibilities:

• Designed and implemented multithreaded database access classes and IBM MQ Series access module for corporate Transaction Gateway Server (TGS) to significantly increase the performance of the wireless financial transactions (ODBC Express components, Delphi 4, Oracle 8.0.5, NT4 cluster server, TCP/IP and UDP sockets).
• Transaction time has been decreased from 45-50 to less than 10 milliseconds (limited only by the network speed).
• Strong object oriented application design and implementation in multithreaded, distributed environment. Oracle queries, stored procedures, triggers and views optimization Database and application maintenance in 24/7-production environment (including NT4 cluster server and Oracle Failsafe)