MICHAEL CRNKOVICH, CPA

Software Engineer

SUMMARY

I am a passionate, curious, and driven software developer with an interest in functional programming and data-focused problems. I have experience working with Python, Javascript, SQL (Postgresql), Linux, and Docker. I am transitioning from 10+ years in finance/accounting, where I wrote code part-time in order to organize datasets effectively, to seeking full-time software development opportunities.

RELEVANT EXPERIENCE

Paws Data Pipeline, Code For Philly

[Git, Docker, Javascript, React, Python, Flask]

Designed and built the initial dashboard for the PAWS Data pipeline in React. The dashboard enabled PAWS to be able to upload, download, view, and search for data from various sources in the organization.
Meets weekly with the Paws Code for Philly team

Postgresql Database Design

Set up a Postgresql database to compare against the current Excel-based workflow and data storage. Implemented data-modeling, data-loading, and stored procedures to clean and transform all data. The database enabled multi-year queries to be run in seconds instead of 45 minutes(est) with an Excel workflow.
Utilized a data extraction process in Microsoft Power Query to transform a monthly file
Created a simple data pipeline to transform and load a complicated Excel file into a Postgresql database

Data cleaning command line script

[Python]

Led the implementation of a data analytics software(IDEA) for the Firm
Created a command line script to convert an Excel file formatted as a report from the Quickbooks application to a database-style format, which enabled users to quickly filter, sort, and create pivot tables for summary data.

SKILLS

Python
Javascript
Bash
SQL
Linux
Git
HTML/CSS
Leadership
Consulting
Systems Thinking