As the architect I was responsible for design of the Performance Monitoring solution for Flight Plan Management System across multiple environments for 30 airlines. This multitenant solution provides the following features:• Collection of data from the servers/databases particular to airline’s environments:  Performance Monitoring  SQL Extended Events  SQL Alerts  SQL Queries• Transfer collected data to Sabre Center • Sabre Center provides:  Configuration management for Airline/Environment/Server specifics  Operational functionality for collection of airlines data  Reporting analysisThis solution will make Flight Plan Management System more stable, and prevent flight scheduling delays, and increase the quality of airline service operations.Designed and developed three-tier solution: • Center database including Configuration, Operation, Security schemas • Center Rest Web Api to collect data from the airlines • Center Dashboard Web Api database interaction for Center Dashboard web application • Center Dashboard web application provides the following features:  Administering: • User/role/authorization • Airline/environment/server/metrics configuration • Reporting configuration  Integration reporting system (SSRS) Tools utilized: REST Web API, Windows PerfMon/PLA, Visio, C# .Net Core 2.0, MVC, Entity Framework, Spark UI framework, AJAX, SQL Server 2016, SSRS 2016, GIT, Rally, NLog

Market leader in consumer financial services with over 2500 centers nationwide providing short term lending, tax preparation and other financial services. As an architect, designed product applications including:• Team Dashboard: Designed and implemented intranet-based utility application providing tools for executives, QA team and production support, as well as the developer team, that increase performance and product quality. • Tools: web and log analytics, ad hoc reporting, DB tables compare tool, Web SQL Scripts management studio, production support set of utilities for accounts and loans corrections, and template studio for XSLT validation, editing, saving into DB and producing HTML and PDF output.• Application uses active directory and windows authentication security and provides administration of user/roles and database connectivity. • AAWeb: Internet application to increase customers by 50% within 3 years.• Designed custom web analytics system. Participated in design and implementation of internet based applications: https://www.advanceamerica.net• Application provides customer registration, customer loan application process, application online pre-approval, customer account management system, payment processing and custom web analytics.• LoanGuard: Supported and enhanced Silverlight application for customer support and loan processing administration, improving customer service by 370 customer service representatives.Tools utilized: MS Silverlight 5.1, Windows 2012/Win7, IIS 7.5, Visio, C# 2012, MVC 4, Entity Framework, CodeMirror, Kendo UI, AJAX, ASP.NET, SQL Server 2012, Excel, ADO.NET, XML, XSLT, CSS.

Project: QPR – Windows Service Multithreading Notification system for scheduling quarterly performance reports for 2.5 M clients. Each client can have 7-24 different complexity reports. System also provides XSL-FO to PDF conversion of processed reports, packaging and delivering to the Print and Mailing facility, as well as e-delivery. Project: CPR – Composite Performance Reporting System (Windows Service Multithreading Notification system for scheduling composite performance of quarterly reports for Strategies/Scorecards for FAs). Project: MVCSQL – Intranet based utility application. Application has the functionality of connecting to any environment of databases such as SQL Server, DB2, and Oracle. Application has intellisense SQL editor and allows the creation of categorized SQL scripts with versions, storing them and executing against target environment. Also, it allows getting results with Save and Export options. As well, application provides data transferring functionality between different environments/databases, which is capable of transferring over 1-M rows simultaneously within 3-7 minutes. Application uses windows authentication security and provides administration of user/roles and db connectivity.

Banking Core Framework - standardizes and centralizes Data Access (ORACLE, SQL Server), Security, and Exception Management in a multi-project environment; simplifies development and increases productivity of web-based applications. OFAC Screening Utility - maintains compliance with the Office of Foreign Assets Control (OFAC) provisions of the USA Patriot Act, specifically those related to Web Cash Manager Application (WCMA) transactions; helps transfer all available information relevant to these transactions from WCMA to the Regulatory List Screening Utility (Mainframe). Designing web services for deposit slip and check validations in Check21 (AccountLookUp, DepositSlip, StopFile, Retirement) using X4ML (for mainframe access) and SQL Server.Redesigned and developed BCPublic website with CMS http://business.ml.com.

Projects: Visa Card Rewards - Call Center and Marketing operation support with powerful web based application. Banking Core Framework - standardizes and centralizes Data Access (ORACLE, SQL Server), Security, and Exception Management in a multi-project environment; simplifies development and increases productivity of web-based applications. OFAC Screening Utility - maintains compliance with the Office of Foreign Assets Control (OFAC) provisions of the USA Patriot Act. BullsEye - simplifies the use of Online Landing Application Processing for Financing Advisers and Credit Managers. Check21 - speeds up the process of scanning and validating account deposits from approximately six days to one. Designed the Banking Core Framework and made aforementioned common components. Designed and implemented database driven security module including administration front and backend functionality. Designed and implemented the new Rewards Adjustment Process. Optimized the backend process of loading data from different vendors and catalogs. Added various maintaining processes for providing flexibility in order to satisfy different business requests.Designed and implemented batch and real-time applications and back end processes of the OFAC Screening Utility including retrieving/calling data processing from Mainframe by using ShadowDirect ODBC connection; automated data transfer to Mainframe. Develop and created tables, views, stored procedures, and triggers to support ETL and applications.Integrated Pipeline application into BullsEye intranet application (design and implementation) including application and database optimization and enhancements.

FieldMaster Pro - Software solutions for service contractors and field service companies that optimize operations by enabling remote data exchange and comprehensive back office automation. By combining wireless technology with 'best of breed' business management software application enables to improve overall productivity.Designed and implemented a DHTML web-based Dispatch Board for a multi-user environment with complex visually rich functionality. Designed and implemented an Equipment History Interface on the server end. Built interactive web-based Inventory Control system, which incorporates a majority of features used by Windows Explorer by using Web Services and built Web Server Controls. Designed and implemented Web Services application for integration our mobile solution with user’s existed full office operational processes. Designed and implemented a Windows CE Pocket PC based application used by various service technicians.

Participated in design and implementation of Microsoft joint venture, which utilizes multiple Digital Dashboard Components (ASP Factory) against OLAP Server. Designed and administered IIS 5.0, SQLServer 2000 and Analysis Services 2000.Developed data archive and restore processes for Information Module using Pivot Table control, MDX queries along with WEBcomponents. Designed and developed Flexible Application Management website which provides a multilevel diverse plug and play environment. Developed automatic process of installation and configuration of Website, SQLServer Databases and OLAP Database.

Project: WebRequest, Event CalendarInternet/Intranet document management system (WebRequest) to provide quality projects control.Designed and developed the WebRequest applications for managing internal projects. Developed status reportnotification via email system. Built web security component based on company's requirements. Designed and implemented Event Calendar to provide intercommunication between worldwide branches of SAP.

Project: Candidate Maintenance, Forum Analysis, Bulk Distribution, ACESA complex process of migration existing MUMPS system to Windows based Internet/Intranet enabled front end using Oracle databaseas back end. Developed and implemented multi-tier client/server and WEB enabled applications, which maintain the processing ofpersonal, educational and financial information for various law schools throughout the US and Canada. Designed processes of custom installation on the end user machines based on client specifics and security reasons. Designed and implemented various application specific search engines, processes of shipping LSAC publications to improve andextend functionality of processing information through Internet on-line with LSAC representatives. Developed scheduled automatic processes of reading scanned data from flat files and provide data load into Oracle database with e-mail capability through a notification system. Participating in Internet based development for on-line Registration and Form

Project: PEO Partnership 2000A complex process of transferring data from a non-relational data file structure to the MS SQL Server based database with capabilitiesof Internet/Intranet editing by the authorized users.Designed the MS SQL Server database, built DDL scripts (deployment of the database), developed and implemented load streams.Developed and implemented a three-tier Internet/Intranet based application. The application, accessible via any web browser, provides a rich functionality to view, analyze and edit data depending on user's credentials.The application manages Client Information, Employee Information, Benefit Information, Tax and 401(K) Information. The functionality also includes various payroll-related calculations, such as vacation, holiday, sick time, etc. An important part of the system is its Power Search Engine, enabling users to perform sophisticated searches with a quick response.

Projects: Multiple projects for various clients. Designed and implemented the access authorization module used in a data-warehouse backed application. The application, interfaced via any web browser, provides abilities to view, analyze and make future prognostications for electrical and gas usage based on personal or company identification. Participated in the logical data warehouse design. Created reporting application and multiple reports, utilized various reporting tools Participated in development of the application that allowed automatic creation of dynamic hyperlinks so users can drill down on fully formatted and styled statistical reports for a more detailed year-quarter-month-week-day information. The users are provided with printouts based on the state or country of interest according to the state/country legal and international requirements such as special formatting, calculations, warnings, etc. Was responsible for the database and reports analysis and implementation.Developed a multi-tier application providing data transfer (ETL) and control functionality between the company enterprise database, a user's centralized database and each client site, including algorithms allowing automatic filtering out some redundant data.

Developed some specific import/export functionality for the bar-coding systems to achieve data synchronization between Sybase based databases and the main enterprise level mainframe based database. Designed various modules for the CAICM. Designed multiple real time and batch reports using stored procedures.

Designed and coded numerous calculating and report generating modules for the company's payroll system. Developed Database and Inventory control system for a small electronic store. Developed applications for inventory control systems and statistical analysis.

Developed and implemented several processes for merging payroll and financial systems master files with transaction files. Maintained a system for cooperative work of company's human resource department.