Swift performs deterministic and non-deterministic forecast calculations for pension and retiree welfare plans. Enhanced Swift engine/functionality by implementing multiple tasks i.e. Import customization with rebuild, Swift Compare functionality, channel splits, stochastic splits etc.

Web application is written using JavaScript/JQuery and asp.net to generate Swift Usage Report. Back end is oracle interfacing with a WCF service hosted as a rest end point. The application also has the ability to upload/download files to the server.

C# Console Application to Migrate Oracle data Base Table data to Azure SQL Server. Used parallel Programming technique to enhance performance and upload time by utilizing multiple cores/processors capacity of the server.

A WPF application to convert existing swift workbooks to enable them to run on Azure HPC Cluster and

Also to maintain/enhance current implementation of swift stochastic process.

C# API to query HPC Cluster/Node properties and/or start Nodes from client by executing PowerShell Scripts on HPC cluster Head node from client machine. The tool creates a remote session with the headnode to execute the script.

TFS API for TFS integration with swift Release tool to enable automate TFS manipulation from the Excel VBA Based tool.

Distributed budgeting is a Single Page Workflow Application (SPA) to negotiate and generate hospital budget through multiple approval processes as an excel workbook. The project is a combination of traditional server-side processing for implementing the business logic and angular based web frontend of MVC pattern. JavaScript/Angular client side synchronizes data to and from the server via calls to a Custom RESTFUL web service/API. Data is separated from HTML using lightweight and language independent JSON data-structure. Backend consists of document database Mongo and SQL server. Request from angular client flows through a message queue system implemented by multiple services written in c# which gets the work done by manipulating the data access layer. Data access layer consists of a service layer where all business logics are implemented and a generic Data Source access layer. Excel object model was used to import/export data to and from SQL server and populate the excel workbook as budget. N-unit was used for C# unit tests, Q-unit and Jasmine was used for JavaScript and Angular unit test.

The Scheduler is the master scheduling process in charge of monitoring and orchestrating the flow of scheduled jobs for all of DSS applications. Users can schedule all processes that manipulate or access Data Ware House data from this one point. Scheduler server can execute any number of executable programs. When a process is to be run in a non-interactive mode (batch), it may be submitted to the Scheduler as a job. Jobs are grouped into streams. Such jobs might include data loads and transfers, summarizations and reports, queries, stored procedures, or scripts. Job control information is stored in the Schedule file which needs to be updated with new or updated job information in each release. C# based Scheduler conversion tool performs that task. Enhanced the tool to Replace the old model streams with new models depending on three conditions, one to one, split or merge. Custom jobs in old streams were also moved accordingly.

VB based driver tool to install DSS (Decision Support System) along with all its component including web application, desktop tools, services and database content along with registry settings. Worked on enhancing the tool, adding new features.

A web-based .net application created to Insert/Edit/Update employee/user info from the employee Database (SQL Server 2005) and to run report including export into Excel spreadsheet. Defined classes and collections to hold employee info, user info, roles etc.

Swift performs forecast calculations for pension and retiree welfare plans. It can reflect accounting and contribution policies that correspond to a variety of calculation standards. Swift can be used to perform both deterministic and stochastic forecasts. It is also used as the source of calculations for the Channel, a tool through which we can provide clients the ability to monitor funded status and perform forecasts themselves.

Implementing Stochastic Calculation on Azure HPC Cluster

Swift azure stochastic calculation is a hybrid application. The Azure HPC cluster executes swift Excel workbook computations in parallel with minimum latency,maximum performance and ensure that these are within acceptable bounds for reasonable user experience. The results of individual computations are written to an Azure Sql Database via calls to a Custom Azure WebAPI through workbook custom macro calls. The process also communicates results back to an on premise oracle database via an on premise xml web service.

• Enhanced swift engine to enable stochastic calculation through the azure cluster. Due to the unique nature of Microsoft HPC service for excel and excel macro framework, Implemented C# API to submit Web requests to the stochastic WebAPI through excel HPC macro framework
• Implemented a Stochastic Data Service Web API to interface with SQL Server Database on azure
• Implemented User interfaces for integration with azure
• Data Base Updates including creating/fine tuning Stored Procedures, tables, functions etc.
• Swift HPC cluster property optimization for optimal cluster usages like the amount of max and min resources, auto grow shrink, Spin up required nodes on demand, optimal node size /number, use of broker node etc. for optimizing performance and reduce cost.
• Swift HPC cluster is based on a queued model, Users experience a delay due to queue warm-up or waiting for required resource. Implemented Scheduler rest API utilizing Microsoft HPC Scheduler Rest API interface to provide periodic updates on nodes availability, queue progress etc to maintain a reasonable balance between cost and desire.
• Swift has a separate charting utility that pulls both raw data and post-calculation stats from the database. Implemented an updated charting tool to enable creating Charts using Azure HPC Data.
• Implemented a WCF exposed MSMQ within the current workflow for a reliable, asynchronous communication between swift stochastic HPC client and server to enable multiple user run calculation concurrently in a failsafe manner.
• Analyzed Azure VM performance and storage structure and suggested suitable VM/Storage options to meet the Performance, throughput and scalability requirement of the most demanding stochastic simulations for investment modeling.