• Designed and developed monthly process to populate third party Profitability System. The process consists of 40+ steps, and includes SSIS packages, uploading or downloading files over FTP, publishing reports, data validation, etc. • Designed and implemented multiple data flow processes between mainframe host, internal SQL-based datamarts and third-party applications, including Online Banking platform, SalesForce, Sybase-based SBA system, Oracle-based Construction Lending Origination System, Excel-file based College Loan Processing system, etc.• Designed and developed suite of 120+ executive, operational, and analytical dashboards to visually represent company's data. Data sources included internal datamarts, Excel spreadsheet, and various third-party files, and were combined into nightly updated de-normalized database. Dashboards were created using iDashboard software with SQL Server 2018 backend.• Participated in data mapping and performed migration of 1000+ customers and accounts for a branch acquisition• Created a number of management reporting packages using SSRS 2005/2018.• Designed and implemented a suite of 10+ datamarts. Specific tasks included designing and creating facts and dimension tables as well as designing and creating ETL process for populating the marts.• Converted 40+ legacy Paradox/Monarch/Excel/MSAccess applications into Windows and Web-based .NET applications and SSIS packages.

• Performed duties of Business Analyst and team leader for 4-person team. Responsibilities included training a new hire, managing project load, performing case and code reviews for the team, doing data quality control, and making sure the team continues to complete all incoming projects successfully and timely.

Managed customization and deployment of Microsoft Project 2000 / Microsoft Project Central package. This package served as company’s time tracking, project management, and billing tool. - Supervised installation, configuration, testing, and deployment of Microsoft Project / Project Central. - Created user interface using MS Visual Basic to expose additional functionalities, such as stuffing a project, billing, invoice generation.­ - Created custom reports using MS Access­ - Created new tables, triggers and stored procedures using SQL Server 2000

• Designed and developed three-tier web application for facilitation of the tracking and processing of patient claims for a leading pharmaceutical firm. Specific tasks included:­ Creating VB COM+ objects to provide business logic and database access to Oracle 8 database via ADO, and to transform obtained data to XML.­ Developing user interface using HTML, XSLT/XPath, ASP, VBScript, and JavaScript­ Creating triggers and stored procedures.­ Writing project specification documentation - business requirements, functional requirements, technical specification, user manual

• Developed Intranet application for managing claim settlements. The program provided ability to add, edit, and delete claims, print and issue checks, stored claims and claimants’ information. Used ASP, VBScript, DHTML for presentation layer, VB/COM running on MTS for business logic, and SQL Server 7.0 as backend database. Communication between layers implemented through XML data.• Designed and developed multi-user 3-tier Tax Accounting application using VB6, MTS, COM, ADO, SQL Server 7.0. Specific tasks included designing database; writing triggers and stored procedures; creating COM objects to provide business logic and database access to SQL Server 7.0 via ADO; developing user interface.• Designed and developed People application for the Human Resources department. The application served as a single point of entry for all employee-related information and was intended to be used by all departments of the firm. Specific tasks included designing and implementing database on SQL Server; writing triggers and stored procedures; creating objects in Delphi to manage database access and business logic; designing and developing thin client using Delphi. • Designed and developed, as part of a team, application-writing wizard using Delphi. Given necessary parameters, the wizard builds SQL Server database and creates Delphi or Java objects.• Designed and developed Project Management System database using ER Studio and SQL Server 7.0. • Designed and developed Will Retrieval System to keep track of all estates instruments (wills, trusts, etc) managed by the law firm, as well as complete surveys for these instruments. The system was implemented using VB6, COM, SQL Server 7.0, ActiveX controls, and Crystal reports.

• Designed and developed backend system which connects and synchronizes all parts of Premium Audit Application Suite using COM, VB5, SQL Server• Designed and developed Premium Audit Workbench Management System for maintaining and tracking the life cycle of premium audits using COM, VB5, SQL Server• Designed and developed Premium Audit Workbench application which allows remote users to download data from the server, manipulate these data and upload it back to the server using VB, Crystal Reports, Excel and SQL Server 6.5• Designed and developed reporting application using MS Access and SQL Server 6.5• Created various ActiveX controls (including database aware controls) for Premium Audit Applications• Created and developed application for documentation management using VB 6, ADO and VBA