Scroll To View More
Kirk Mavroulis, SQL Developer in Baltimore, MD, United States
Kirk Mavroulis

SQL Developer in Baltimore, MD, United States

Member since August 6, 2018
Kirk is now available for hire
Kirk Mavroulis, SQL Developer in Baltimore, MD, United States
Kirk Mavroulis

SQL Developer in Baltimore, MD, United States

Member since August 6, 2018
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.
Kirk is now available for hire

Portfolio

Experience

  • Banking & Finance, 18 years
  • Relational Databases, 15 years
  • Equity Derivatives, 10 years
  • User Flows, 9 years
  • SQL, 9 years
  • Legal Entity Data, 5 years
  • Jira, 5 years
  • Healthcare, 3 years
Baltimore, MD, United States

Availability

Part-time

Preferred Environment

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.

Employment

  • 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: MS SQL Server, T-SQL, JIRA, Relativity
  • 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: ASP.NET, MS SQL Server, T-SQL, QNXT
  • 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: VB.NET, MS SQL Server, T-SQL

Experience

  • Personal Stock App (Other amazing things)

    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.

Skills

  • Tools

    Jira, Microsoft Access, Visual Studio 2015, GitHub
  • Other

    Mortgages, Equity Derivatives, Healthcare, Stock Market, Legal Entity Data, Atlassian Plugins, User Flows, Banking & Finance
  • Languages

    SQL, Visual Basic .NET (VB.NET)
  • Platforms

    Windows
  • Storage

    SQL Server Management Studio, Relational Databases

Education

  • Bachelor's degree in Finance
    1999 - 2005
    Towson University - Baltimore, MD, USA
Certifications
  • Relativity Certified Administrator
    APRIL 2018 - APRIL 2019
    Relativity, Inc.
I really like this profile
Share it with others