Kirk Mavroulis, Developer in Baltimore, MD, United States
Kirk is available for hire
Hire Kirk

Kirk Mavroulis

Verified Expert  in Engineering

Equity Derivatives Developer

Location
Baltimore, MD, United States
Toptal Member Since
June 18, 2020

Kirk taught himself how to code while in the midst of obtaining his finance degree and it was then, he got to design and build his first app for a mortgage business. In any given situation, he loves to extract the highest level of efficiency. For him, the goal is to create the fastest path for the user, removing all unnecessary steps, and having the data stored in a scalable manner that serves both the app and gives the business insights.

Availability

Part-time

Preferred Environment

SQL Server Management Studio (SSMS)

The most amazing...

...thing I've built was an app, Benefits Wizard; it allows health insurance companies to manage a portfolio of benefit plans year to year with minimal user input.

Work Experience

Application Engineer

2013 - PRESENT
Advanced Discovery | Consilio
  • Supported eDiscovery applications used in litigation support including relativity, early data analyzer, and eCapture.
  • Wrote custom SQL code for a custom application to parse large data files exported from chat applications like Bloomberg Trader Terminal, Yahoo Messenger, and Skype. Used an algorithm to identify the beginning and end of each conversation from a continuous stream of messages based on client rules.
  • Wrote custom SQL scripts to assist in streamlining a client-and-project-manager workflow.
  • Wrote custom data transfer SQL scripts to move the data between applications according to client specifications.
  • Developed relativity applications to support custom reviewer workflows.
  • Acted as a JIRA administrator.
  • Created and managed JIRA projects for departments, company wide, including software support, IT, and client services.
  • Configured custom workflows and automation using a combination of plug-ins and custom code.
  • Worked on a team of developers to create several add-on applications to provide added a functionality to a reviewer workflow in Relativity.
Technologies: Jira, T-SQL (Transact-SQL), Microsoft SQL Server

Lead Systems Analyst | Development Manager

2009 - 2012
Bravo Health | Cigna-Healthspring
  • Designed and contributed to the development of a custom web-based application to consolidate member information from a diverse group of corporate systems and render on one screen. This allowed customer service reps to see all of the details about our members including their plan information, copays, in-network doctors, claims history, premium invoices, and previous call information without having to switch between applications or screens.
  • Developed and designed, with a team, a web-based application called the Benefits Wizard. Allowed for users to configure company-wide benefit plans based on templates and then push changes to primary claims system much the way developers use source control. This eliminated redundant data entry between plans as well as between plan years and reduced user error and improved the consistency and speed in benefit plan configuration.
  • Built a document management application which acted as a repository for all files related to a client. Whether incoming mail, outgoing letters sent by the company, or otherwise. The app could then be called by via a web service to provide information for use in various other applications.
  • Designed and co-wrote a physician engagement application to track key metrics for physicians in our network. This gathers data from other company systems and shows a dashboard of key data to our physician reps for use in engagement with practices and hospitals.
  • Developed SSAS data cubes to provide upper management with increased reporting capabilities without having to rely on canned/delivered reports.
  • Led a team of analysts and programmers who were developing custom applications for business. The team handled the complete lifecycle from requirements gathering, technical specifications writing, database modeling and design, user interface creation, QA testing, user acceptance testing, deployments, and finally, the documentation and user training.
  • Worked with CMS data files for enrollment and eligibility.
Technologies: QNXT, T-SQL (Transact-SQL), Microsoft SQL Server, ASP.NET

Lead Systems Analyst

2005 - 2008
Fidelity Home Mortgage Corporation
  • Designed a proprietary underwriting system to approve or deny load applications based on company rules and credit guidelines.
  • Designed a mortgage-backed security portfolio management platform to track company positions and manage rate risk.
  • Led a team to implement a paperless workflow system to streamline loan origination, underwriting, funding, and the delivery process.
Technologies: T-SQL (Transact-SQL), Microsoft SQL Server, VB.NET

Fileshare Content Scrape

A business needed to get a list of files from a large network location and transfer it into a table for the purposes of using the file name to compare to other tables.

Custom Hash and Deduplication Script

I used a HashBytes function to create a unique hash ID for records based on the text input, identify duplicate rows based on this hash value, and use this to identify records per client request.

Personal Stock App

I developed an application to download stock data from Yahoo Finance and load the data into a table that I used to track volume and open, high, low, and closing prices for over 300 stocks. I also wrote algorithms to identify reliable patterns which I used to trade from among these 300 companies. This app saved me hours of weekly trade research.

Bates Range Detector Script

This script intakes a file of Bates numbering (unique start and end numbers per record) and identifies the distinct unbroken ranges among the rows.

Tools

Jira, Microsoft Access, QNXT, Visual Studio 2015, GitHub

Industry Expertise

Healthcare, Banking & Finance

Other

Mortgages, Equity Derivatives, Stock Market, Legal Entity Data, Atlassian Plugins, User Flows, Scraping, Hash, Development, Apps, Scripting

Languages

SQL, VB.NET, T-SQL (Transact-SQL), Visual Basic .NET (VB.NET)

Platforms

Windows

Storage

SQL Server Management Studio (SSMS), Relational Databases, Microsoft SQL Server

Frameworks

ASP.NET

1999 - 2005

Bachelor's Degree in Finance

Towson University - Baltimore, MD, USA

APRIL 2018 - APRIL 2019

Relativity Certified Administrator

Relativity, Inc.

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring