SUMMARY:

• Strong programmer with 20 years of development experience and in the top 25% of Confidential contest .
• Passionate about software development. Has both desire and ability to see and prevent problems with software on early stages and to keep software code entropy from exploding, which translates to constant long term budget for any project and robust bug free functionality.
• Produced sophisticated generative and data manipulation techniques, that achieved high levels of development productivity and software quality.
• Hands - on experience in object-oriented design, asynchronous, and multi-threaded programming, client-server and n-tier architecture, designing databases, graphic user interfaces, and Web development.
• Takes a recognized creative approach to issues, and known for writing flexible, reusable, and supportable, quickly-evolving software.
• Espouses code organization, and efficient communication between developers, staff, and users.

SKILLS:

• DRY Coding
• ASP.NET
• Visual Basic
• SQL
• JavaScript, jQuery
• LINQ
• C# .NET
• ASP.NET MVC
• MS Access

TECHNICAL SKILLS:

Coding: reusable, succinct, generative, multistage, declarative, functional, OO, DRY, asynchronous, multithreaded, aspect, agile, iterative, metaprogramming.

Design and implementation: C#, generics, VB.NET, C++, COM/DCOM, DTD, XSD, multi-tier, API, patterns, closures, lambdas, inheritable data structures, CQRS, Event Sourcing, integration, post production.

.NET Framework: 4.0, 3.5, 2.0, 1.1, C#, XML Web Services, WCF, reflection, Windows services, BizTalk 2009, Azure, VB, ASP.NET, ADO, LINQ, DLINQ, Regex, crypto providers, attributes, serialization.

Graphic user interface: DHTML, MS Access, WinForms, single-page interface (SPI), mobile apps, data-driven UI.

Web development: JavaScript, jQuery, Confidential, JSON, single-page application (SPA), XML, ASP.NET, MVC, Web API, RESTful, HTML, CSS, VML, ASP, FireBug, Dojo, FireFox, Google Chrome, IE, eSignature, VoIP, IVR.

Database: SQL, Dynamic SQL, MS SQL Server, CTE, ETL, CLR, SPs, functions, triggers, query speed, transactions, locking, XML, XQuery, geography spatial data, .Net Entities, ADO, SSRS, Crystal Reports, warehouse, MS Access

OS: DOS; Windows 8, 7, XP, 2000, NT, 9x, 3.x

Other: Git, TFS, Subversion (SVN), Visual Source Safe (VSS), Visual Studio 2015, 2010, 2008, 2005, 2003, 6.0; MS SQL Server 2014, 2008r2, 2005, 2000, 6.5; OneNote, Lync, MS Office 2007, 2000, Intel 8080 assembly

PROFESSIONAL EXPERIENCE:

Confidential

Software Design Engineer, Knoxville, TN

Responsibilities:

• Involved: C#, .Net Code First, SQL, JavaScript, Git, Linq, jQuery, Twitter-Bootstrap, ASP.NET MVC, HTML, CSS, agile.
• Bug fixes, improvements, refactoring of internal .Net website.
• Architected and implemented business layer as set of classes, nested classes and generics; regular and flat tables browsers excel export component; data cloning SQL script

Confidential

.Net Developer, Agoura Hills, CA

Responsibilities:

• C#, SQL, ASP.NET MVC, Visual Studio 2013, TFS, agile, scrum.
• Worked on user stories and fixed bugs in mortgage banking enterprise web application dealing with escrows.
• Conducted technical interviews of potential candidates for open C#/SQL position with the company.
• Simplified SQL code by deduplication with cascading calculations and CROSS APPLY (see PTII-6).
• Implemented set of views and record printer SP for easier research of current state of data.
• Documented the environment in C# by implementing a way to write strictly defined documentation (see PTII-1).

Confidential

Systems Developer, Grand Island, NY

Responsibilities:

• Involved: C#, Visual Studio 2013, XML, XSD, DTD, Regex, LINQ, System.Xml.Linq, Reflection, Git, SourceTree.
• Architected and implemented relational abstraction of proprietary Mortgage Cadence data structures. Achieved excellent result of quality and maintainability. Made customers happy with speed of making bug free code changes.
• Mapped data from big flat array of legacy Mortgage Cadence fields into C# objects of MISMO XSD schema using LINQ.
• Transformation of XML tree from one form into another to fit desired schema and see list of significant differences.
• C# library for convenient handling of minor XML adjustments for situations when XML is close, but does not comply with desired schema (reorder, removal, additions, conversions of XObjects).
• Library of SQL closures extending capabilities of SQL language (see PTII-5).
• Google email filtering and routing in JavaScript; phone calls handlers and IVR in Go and Twilio (see PTII-9).

Confidential

R&D Software Engineer, Getzville, NY

Responsibilities:

• Involved: SQL 2014, SQL CLR SPs, 2008r2, ETL, .NET 4.0, 2.0, C#, JavaScript, Confidential, ASP.NET MVC, jQuery, Visual Studio 2010, TFS, “TFS baseless merge”, C preprocessor, DDI, XQuery, code generation, multi-tier, data-driven UI, post production support.
• Implemented new features and fixed malfunctions in various branches and tiers of mortgage banking products.
• Architected and implemented data migration SQL scripts allowing auto detection of source column types and auto fit into destination column types, remapping row identities, validating results and reporting discrepancies. Achieved extraordinary low number of bugs of ETL migration code, by implementing substitute of SQL insert/merge statement, which allows defining existence of a row declaratively and avoid duplication of columns list inside insert and select part of insert/merge statements. See PTII-6. Reusable code from data migration gradually evolved into SQL coding framework that I called “SQL Closures” (see PTII-5).
• Refactored and solved problems with windows performance counters feeds. Implemented command line tool to import/export/set/delete categories and counters and/or instances. Implemented reusable code to create hierarchical counters instances where higher levels show aggregated lower levels data. Inserted additional feeds to monitor MVC handlers and exceptions. Implemented C# custom attribute relying on PostSharp.
• Converted old encryption SQL XPs to SQL CLR SPs. Implemented framework for CLR SP stub generation, dll serialization and unit testing that allows addition of new CLR SPs in a matter of minutes.
• Designed and implemented:
• Updatable view and trigger for selecting/updating fields inside XML column using XQuery.
• SPs for declarative definition of tables, columns, indexes and views.
• .h file for C preprocessor to generate multiple SQL lists from one definition using macro polymorphism PTII-14.
• 3-stage SP deployment process where 1st stage creates SP, 2nd stage invokes that SP in build mode to self-adjust, 3rd stage unit tests that SP. Next stage is performed after all other SPs pass previous stage.
• Refactored form view SP by making it self-adjusting and generating list of own parameters from view definition. That way the scope of change was contained within one file.
• Proposed to implement revolutionary approach to solve branching and merging problems, see PTII-2.

Confidential

Sr. Software Engineer, Tonawanda, NY

Responsibilities:

• Involved: .NET 4.0, C#, Data Warehouse, ETL, SQL 2008, ASP.NET MVC, HTML, CSS, JavaScript, Confidential, jQuery, WCF, Visual Studio 2010, SVN, D/LINQ, Entity Framework, ADO.NET, BizTalk, MS Access, Azure, spatial data, post production, CQRS.
• Logic that translates combination of needed grouping and aggregate fields to Dynamic LINQ query dlinq.alpav.com
• Restructuring of resulting data set producing data series in addition to raw data for JavaScript UI to consume
• Interpolation and moving average for trend data.
• Data Warehouse star schema with simple and complex dimensions. ETL and complex reusable SQL Stored Procedures importing dimensions with extraction of data groups to produce optimized one-to-many dimension.
• Analyzed SQL queries performance plans and tuned up data warehouse indexes
• Achieved 10x performance gain by optimizing C# reflection code with delegates, caching and streaming.
• Achieved another 5x performance increase by hosting database in RAMDisk.
• JSON Web Service API for multi-tiered UI-to-service and service-to-service communication.
• Fixed bugs and implemented new features in rich JavaScript jQuery UI.
• Architected and implemented a novel approach (PTII-4) to delivering ad-hoc SQL queries via an internal website.
• Developers were often tasked to write custom SQL queries and email back results in Excel. Users often made similar query requests, and the users could not re-run the prior request themselves.
• Solution is called "SQL Server Pages" (named after Active Server Pages) since it uses *.SQL files placed in folders to be executed by this web server engine just like a web page. Besides queries, the SQL files can be written to produce menus, submenus, and even join to an existing Excel file from a shared folder as a data source.
• This solution is more rapid for development than SSRS since no report configuration is needed, just a file deploy.
• Orchestrations for BizTalk 2009. Designed SOAP API and reusable classes for BizTalk communication.
• Implemented serializable string tree to make quick ad-hoc changes without refreshing BizTalk service links.
• Post production support of existing system that is mix of ASP.NET, ASP, SSRS, MS Access with SQL Server backend.
• Developed form definitions upload to Azure.

Confidential

Software Engineer, Grand Island, NY

Responsibilities:

• Involved: .NET 3.5, C#, ASP.NET, MVC, HTML, CSS, JavaScript, Confidential, JSON, jQuery, FireBug, Dojo, SQL 2000, 2005, Visual Studio 2008, VSS, SVN, .NET Compact, WinForms, ADO.NET, LINQ, Entity Framework, single-page application (SPA), single-page interface (SPI), MVC routing, ISAPI Rewriter, post production support.
• Architected company public website, implemented parts of it and supported it in production.
• Achieved outstanding runtime website performance on old Pentium III server by keeping search on browser side that loads pre-generated JSON files with data and does not depend on SQL requests.
• Made Confidential content searchable by Google and Bing crawlers utilizing server side DOM with Jaxer.
• Custom pages are separate HTML files injected into main DOM tree on client side.
• Architected and implemented queue of orders - dojo table with volatile data and many concurrent users. In order to achieve robust bug free interaction with users regardless of timing of their actions or server response in transaction-less browser1-server-browser2 communication, implemented 2 phase transactions when item status first switched to pending state on user UI and then switched to acquired state or busy state if another user concurrently switched to pending state first.
• Implemented reusable JavaScript library to share between web apps g.js (see PTII-10):
• DOM node and object waiters, object tree path navigator, jQuery extensions deftag.js, jquery-ext.js bject mixer that inherits one tree from another for deep structure avoiding namespace pollution sl.js queue of component initializers to control sequence of initialization regardless of sequence of inclusion
• Converted PowerBuilder application into C# Windows Service; enhanced WinForms desktop VB.NET application.
• Implemented order tracking WinForms app for mobile device, interfacing with barcode scanner and database.
• Organized development process: (SVN source control, declarative SQL definitions, standard naming, shares, docs)
• Mentored junior developer regarding JavaScript UI for public server. The mentorship gave great results and Confidential website got excellence award in 2009 for being the best and fastest website in promotional products industry.
• C#, VB.NET, ASP.NET 1.1, ASP3, HTML, CSS, JS, Confidential, jQuery, SQL 2000, VSS, MSAccess 2000, XML, Crystal Reports, WinForms, VC++, COM, DCOM, Event Sourcing, IVR.
• Confidential buttons on existing ASP3 pages with asynchronous ASP3 callbacks
• EDI with eSignature companies with XML over HTTP/HTTPS.
• SQL triggers to distribute calculations in time and keep denormalized information in sync for better speed.
• Inheritable security settings tree stored in SQL table and results caching for SP speed.
• Converted MS Access reports and MailMerge word docs into HTML ASP.NET reports browsed by invoked IE.
• String tree code generation library for easy compact text generation and manipulations. Used With…End With, using(…){} blocks to synchronize code structure with output structure. See PTII-8.
• Load/save links between C# objects and SQL Server objects, XML elements and registry keys; AndNotOr PTII-3.
• HTML reports with data compression (presentation of similar items as common part plus list of differences).
• SQL tables, SPs and viewer/editor UI for movie theater ads reservation data inheritance (see PTII-7).
• Project dependencies scanner that produces 4Mb HTML+VML file using sophisticated data pushing generative technique (see PTII-8) to place information into different parts of one html document within same programming block. VML shapes made it visually attractive and compact. It took me only 2 weeks.
• CRM application in MS Access that was sold to multiple companies and had monthly renewable licensing model.
• User Access control of various MSAccess UI elements with tree of MS-Windows folders.
• AgentCOM library with asynchronous COM API for responsive COM-driven reliable and simple UI; PTII-14.
• Action-Event pattern to define sequence of actions and events for automated tests of COM servers.

Confidential

Software Engineer

Responsibilities:

• Client-server app, CRM for brokerage, acct app in: SQL, FoxPro, ASP, HTML, MS Office VBA, Forth, Prolog, Embedded
• Real-time data collection, calculations and output through COM port to a printer device.
• Programmed 4-digit display to show and modify configuration, statistical and debugging data, reading clicks and combinations of 4 buttons on front panel below display.
• Implemented this embedded software in Intel 8080 assembly.
• Algorithmically in assembly solved Confidential and achieved pleasant buttons functionality (can click fast, no undesired double clicks).