TECHNICAL SKILLS:

Programming Languages: JavaScript, XML, XSLT, XSL FO, Java, VBScript, C#, VB.NET, Microsoft Visual Basic 3.0 - 6.0, Microsoft Visual J++, Microsoft Visual C++, C, HTML, DHTML, SQL-92, PL/1, FORTRAN 77, PASCAL, ASSEMBLER, PROLOG;

Programming Tools: React, Redux, Ramda, Flow, AngularJS, RequireJS, ExtJS, bootstrap, Schematron, ASP.NET, ASP, SAX, CSS, AWT, Crystal Reports, Excel Object Library; MTS;

UnitTest Packages: Chai, Sinon, Jest, Protractor, Jasmine, JSUnit, Selenium, JUnit, Rational Functional Tester, BadBoy

Databases: Couchbase, Oracle, SQL Server, Sybase System, FoxPro 2.X+, dBase III-IV, FoxBase, Clipper 5.X;

Applications: Chrome, Internet Explorer 4.0+, FireFox, Netscape Navigator, SQL-Programmer 1.85-2.2-IX.0, ClearQuest, ClearCase, PVCS, VSS, Microsoft Visio, ERWin 3.5x, BusinessObjects 4.1-5.0, Rational Suite Development Studio, PC Anywhere32, Clipper Tools Library, MS Office, Lotus Notes 4.X, QuarkXPress 3.32, Adobe PageMaker 5.0-7.0, Adobe PhotoShop 3.05-4.0;

Operating Systems: Mac OS, Windows, Novell Netware 3.X;

Hardware: Mac, IBM PC XT/AT compatibles, IBM Mainframe, VAX;

EXPERIENCE:

Confidential

Consultant

Responsibilities:

• Transforming of metadata into client-facing UI logic
• Execution of behaviors
• Proxying of requests from the client to various platform services
• Hosting/serving of the static assets required to run a web application.
• Responsible for architecture and design of various UI Engine components like:
• State tree manipulations via reducers (using Ramda for pure functional style and immutability)
• Memoised selectors (using ‘reselect’)
• Tabs/Nested tiles metadata/data resolution
• Modals metadata/data resolution
• Smart components metadata/data resolution using scope concept
• Created a framework that automatically generates flow types based upon metadata stored in the Couchbase.
• The flow types generator script hits the metadata component-types endpoint to retrieve the most recent component types.
• Then it converts the block-types JSON into the FLOW definitions and stores it in the js.flow file, making them available for precommit hooks.
• This system allows detecting UI Engine/metadata integration issues at early stages.
• Responsible for UI and e2e tests frameworks architecture and development.
• The tests utilize data-driven design where possible and are ran on precommit hooks.

Confidential

Consultant

Responsibilities:

• Technical lead in design and creation of the Axon.Portal and IaaS.Portal systems.
• Created AngularJS/RequireJS-based framework for rapid application development.
• The framework comes complete with the set of bootstrap-styled 2-way bounded widgets, including Google-like global search, searchable treeView capable of rendering both JSON and XML data, Google Charts-based charts directive; system-wide services like Authorization, Validation, CSV-export and the messaging system.
• Data communication layer is comprised of $resource-based components that facilitate REST interactions.
• The landing page uses customizable metro-tiles and strip directives to create rich Windows 8-like metro tiles interface. User settings allow changing tiles’ theme and size, as well as the number of tiles per page. The strip directive provides touchscreen-like capability of grab-and-pull to scroll mini-tiles into view.
• The workflow page creates visual representation of the workflow.
• The workflow is assembled of the AngularJS HTML templates that are loaded dynamically when a respective tile is selected via the strip directive. Once loaded the workflow sections could be moved around using on-screen controls as well as drag-and-drop. Each section encapsulates its own authorization and validation.
• Created static and integration Unit Test suites.
• Designed Powershell scripts that are scheduled to run every day and send the failure reports to the development group.
• As a part of the documentation effort created a system that is mimicking the project folder structure to simplify the information retrieval. In this system each directive, service or tile is designated a file that contains both, functional overview (including step-by-step screenshots) and the implementation notes.

Confidential

Consultant

Responsibilities:

• Designed and implemented various Ext overrides to address existing Ext issues like tree-view scrolling, automatic formatting invalid dates by DateField etc. Overrides also been used to add a desired functionality to the standard Ext widgets.
• Created Java Factories, Screen Configurations, Data Assembler classes and Rule Sets to provide Ext-engine created widgets with JSON configurations.
• Spearheading the latest effort to boost the performance of the most resource-consuming pages by converting them to the AngularJS MVC. The conversion includes search screens, where queries can yield large sets of data and employs the NG Grid.
• Designed custom directives to generate the Ext widgets managed by the AngularJS which allowed automatic two-way binding.
• The new screens are designed to reuse the existing XHR services where possible to minimize the effort.
• Unit testing
• The unit testing is an integral part of the development process. The CityTime UT coverage of the GUI consists of integration testing performed via Selenium and the JSUnit Eclipse plugin to provide a JS testing platform.
• Resolved Selenium issues locating dynamically generated page elements, elements inside of IFrames and Ext-generated elements.
• Provided support on timing issues when running tests in the Selenium environment. Presented a way to simulate events that are not fired if standard Selenium scripting is employed.
• Created comprehensive JSUnit coverage of the system-wide JS labraries. The static data is loaded from external files; mock objects are used in the JS methods to provide test output.
• Designed an extension to the RFT framework that emulates the Selenum’s XPath search capability.
• Created FireFox/Chrome interfaces matching ones in Internet Explorer, like TextRange object and outerHTML method.
• The XML data islands were converted to their equivalents to be used both in FireFox/Chrome and Internet Explorer.
• Addressed various issues where same intrinsic DHML methods have different parameter requirements in FireFox/Chrome and Internet Explorer

Confidential

Consultant

Responsibilities:

• Solely responsible for design and implementation of the SAC Application Access system. The system manages security access on all levels of the SAC application domain: from application down to local web-page objects and table columns.
• SAC Application Access system is built in the .NET/ASP.NET framework. Back end is based on the SQL2000. The data access layer (DAL) is represented by C# assembly that abstracts the access details into DAL classes. Web services are built on top of the DAL to allow a web-based management of the database entities. The UI takes an advantage of ASP.NET user controls to encapsulate the shared functionality like editing an item, showing summary or managing user/group access for an object of any level. To make such an encapsulation possible a set of interface classes is created.
• Designed and implemented IT Miscellaneous Report system.
• The system allows to generate web-based reports (PDF/Excel/Word) based on variable set of parameters.
• The backbone of the system is the hub stored procedure that accepts parameters in the form of XML string. They are parsed into a temporary table using the sp xml preparedocument and later used by report-specific procedures to generate report recordset.
• The later is stored in the cache in the form of XML document. When a modification of the original report is requested, the data being retrieved from the cache, transformed into the ADO recordset that is passed to the Crystal Report template to generate report in the specific format. The resulting file is stored into another level of cache: this is being used when the same report format is called repeatedly.
• UI is built within the ASP framework. The ability to enter variable parameters is realized by the set of report-specific ASP forms that are dynamically loaded using MSXML2.XMLHTTP
• Solely responsible for the design and implementation of the PatchNotes subsystem. The system automatically creates release notes based upon issue information, user credentials and VSS entries.
• The system is conveniently plugged into the existing Production Issue management module that stores production changes in the database. When user is ready to create release notes, the tree-view interface that is reflecting current state of the all VSS Databases/Projects/Files allows choosing files either manually or by entering VSS label (the interface also allows labeling target files/projects.)
• Then the target file list is presented to user for confirmation. When confirmed, the server-side Crystal reports engine creates a Word version of the list that is displayed in the separate IE window.
• Designed and implemented Syndicate Designations application that allows leveraging IPO information for various reporting. The system maintains an audit trial on all allocations and has an ability to allocate syndication percentages for each participating broker. The SQL job that runs at the specific time intervals calculates final FX rate along with the commission in original currency and US equivalent.
• On the database analysis/design stage created MS Visio database model that later produced database objects (tables, keys/indexes, constrains and triggers) creation scripts.
• Created stored procedures that comprise infrastructure for the underlined database objects.
• The UI presents information to the user in the ledger-like web page, with an ability to drill down (expand and collapse in tree-like interface) to the individual percentage allocations without refreshing the whole page (this is achieved by using MSXML2.XMLHTTP.)
• Implementation of the Broker/Currency/Issue lists included manipulating XML data islands along with client side XSL transformations.
• Summary web reports feature allows creating on-the-fly Excel exports with full range of built-in sorting/filtering capabilities. The XSL stylesheet is used to transform XML data into the Excel html export file. The later is used in the report generating ASP that creates Excel version of the report by using AddHeader/Content type properties of the Response object.
• Created Application Action Item system that allows to maintain the action items related to an application/process.
• The UI is designed as a tree-like interface to browse through various process-related items like application, action items, dependencies, responsibilities, contacts etc. The nodes of the tree are represented by the set of the dynamically loaded (MSXML2.XMLHTTP) ASP forms. This technique allows to refresh only a specific tree node when expand action is requested.

Confidential

Consultant

Responsibilities:

• Designed and implemented the XSL FO PDF report generation test environment that sped up creation of the XSL FO stylesheets and reports maintenance.
• Responsible for the creation of common JavaScript functions that are used across the site.
• Participated in all stages of the development cycle, including staging builds, working with BAs, assisting QA personnel and providing necessary help to other developers.

Confidential

Consultant

Responsibilities:

• proposed asset allocations based upon scoring in the system Questionnaire automatic risk profile determination quarterly/annually performed automatic rebalance reallocations to the new/existing fund profiles.
• Solely responsible for the replacement client based OCXs with Java applets.
• I conducted showed that neither native HTML binding nor DHTML methods are not able to provide consistent replacement for this component. In the effort to keep client thin the only acceptable solution was to implement grid functionality in Java applet.
• To accommodate small recordsets created DHTML data-bound grid. The grid is fully object oriented and implements all major TrueDBGrid features like scrollable split support, in-cell editing capability, Rebind() method, etc.
• Solely responsible for the Object Oriented approach integration. As a part of the effort created centralized includable ErrorHandler object with ability to log errors and notify devsupport via e-mail.
• Designed and implemented pure DHTML/JavaScript based data-bound menu system. The effort was undertaken to replace client side Ikonic OCX menu control. The menu system is fully object oriented and can be quickly adjusted for usage with any given Intranet application. The easy of use this Menu object is similar to the Menu control in VB.
• The optimized system extensively uses JavaScript Regular Expressions to perform various custom formatting. This approach allowed to raise effectiveness of the processing by 15-20 percents.
• Using server side scripting provided conditional download of various parts HTML/JavaScript code, that allowed to cut loading time by 33-50 percents.
• Responsible for the enhancements that allowed the application usage under different systems/configurations, from Windows 95 to Windows NT 4.0 and from IE4 to IE5.5

Confidential

Consultant

Responsibilities:

• VB6 migration (resolving RDO/third party controls compatibility issues);
• Analysis and design of International part of the RTS. That’s allowed to keep track of international allocations within the system, set up a new global structure of legal entities along with domestic/international adjustment centers and produce a new level of financial reporting. The subsystem included fully featured audit trial history module with ability to rollback most recent allocations/adjustments. The International part designed as system of polymorphic objects that encapsulate visual interface;
• Phases I-III outdated third party components removal. The list included MicroHelp, VideoSoft and Crescent controls. That major cleanup allowed to dramatically increase scalability and safety level; also had significant positive hit in performance;
• Put down RTS security subsystem that prevents unauthorized users from accessing the system. Authorized RTS users are not allowed to login into the system using workstation other than his/her own. The permission rights separated in three global profiles.
• Month End sub-project to reflect constantly changing universe of business rules;
• Month End library functionality that eliminated using hardcoded numbers in reports/stored procedures. That enhancement has significantly reduced total number of change requests;
• Leveraged Sponsor module that allowed to associate list of sponsors with the particular transaction and produce another reporting view for the revenue figures.
• Solely responsible for the Block Trade Event development and support.
• Developed unique format engine which allows to convert virtually any report made with Crystal Reports, to Excel spreadsheet. This technique especially useful when native Crystal Reports API fails to make the conversion. The engine, which takes a full benefit of using Excel 8.0 object library, is designed as a collection of polymorphous VB classes and implemented as a DLL.
• As a member of a management group responsible for the global Confidential -wide Business Objects’ universes/reports distribution, including setup procedures. The group has concentrated it’s efforts on resolving compatibility issues in the process of migration to higher version of Business Objects and MS SQL server.
• Managing group of developers in analysis and creation of BusinessObjects Universes to produce dynamic system of web-based reports. These included: Confidential HeadCount, as a base for employee management system reports; RTSMaster, the Revenue Tracking System universe to set up revenue Month To Date and Year To Date reports. Analysis included separating Business Objects’ entities out of existing stored procedures along with their optimization.
• The Universe is a system of SQL-based BusinessObjects’ classes that is used to create dynamic reports with anticipated client interaction. The system is an alternative to static Crystal Reports and allows users to create/modify on the fly web-based BusinessObjects’ reports using IE 4.0/Netscape browsers.
• Participated in Self-Evaluation (MD Self-Evaluation) conversion and enhancements, from RDO 1.0 to RDO 2.0 under Windows NT 4.0.
• Solely responsible for design and implementation of BankerLTI system, which summarizes all Confidential bankers activity and allows top managers to analyze and calculate annual bonuses and awards.
• The system is built with VB5/Excel 8.0 Object Library/Crystal Reports API and uses Microsoft SQL 6.5 server backend. To obtain necessary advanced security level the BankerLTI uses Microsoft SQL 6.5 command-line utilities along with extended Microsoft SQL 6.5 stored procedures.

Confidential

Senior System Specialist

Responsibilities:

• Participated in the Letter of Credit (TradeWinds System) application conversion and enhancements for Global Trade & Treasury System (GTS), from VB-3 to VB-4 (32-bit) under Windows NT 3.51 and later to VB-5 under Windows NT 4.0.
• GTS, which is a nominee of the 1998 Annual Smithsonian Institute Award for Business and Finance, is a typical multi-layer Client/Server system, used by Chase in many overseas sites as well as in New York City. Today it consists of VB-4/VB-5 front end with numerous VB-5/C++ in/out process OLE servers. This application uses a Sybase System 11 SQL server back-end.
• Participated in the entire development life cycle, plus QA / UAT testing and enhancements, including Hong Kong and United Kingdom versions.
• Responsible for major enhancements of Customer Information Maintenance subsystem. This system allowed New York users to manually enter and modify customer account information, instead of the usual process involving a mainframe download. This functionality was of importance, since there is no download facility available in NY.
• These changes implied significant involvement of Sheridan and Crescent third party products, as well as introducing a number of Sybase Stored Procedures.
• Designed and implemented Accounts Receivable/Accounts Payable DrillDown function that allows UK users to quickly retrieve charge descriptions which make up an outstanding amount as well as currency and transaction posting date of each fee generated. Implementation included recursive procedures, necessary to drill down into a generated charge tree.
• Documentary Collection Application (TradeWinds System).
• Solely responsible for design and implementation of MultiPayment subsystem (Polymorphic Objects, using Virtual Classes/ Windows SDK) while introducing new payment methods (NY Branch/NY Chips/NY Fed/NY Tape) and NY Chips/Fed/Nostro payment parties business rules.
• The implementation included significant changes in Tables/Stored Procedures Database scheme.
• Introduced new function that implemented Currency and Debit/Credit dependencies. The function stated rules for choosing specific Payment Methods based on local/foreign currencies and debit/credit indicator.
• Created of Chips/Fed and Branch static table maintenance programs accompanied by a number of Sybase Stored Procedures.
• Was solely responsible for design and implementation of the Proof/Tape functionality within Documentary Collection project. Proof area uses this module to journal and control interdepartmental debits and credits. It is also used to record each rejected item and branch credit into the system.
• The implementation included creation of Custom Controls Library that provided the system with functionality to bind Controls to any type of recordset objects created within in-proc OLE servers. The Library was built around MS FlexGrid Control accompanied by a vast majority of Windows API functions.
• Designed a class that allowed a programmer to sink any original Windows event (using Windows Messaging) to a specific Custom Control. (The same method was used while implementing NY Chips/Fed/Nostro payment parties’ business rules).
• Additionally, the Controls used in this function exhibited major speed/memory advantage over the Sheridan Widgets Controls implemented through the rest of the TradeWinds System.