SUMMARY

• Skilled problem - solver with a penchant for creating elegant software solutions. I flourish in environments with a focus on collaboration and where personal ownership is encouraged. I have an innate motivation to learn new things, which helps me adapt to most technologies and professional environments quickly.

PROFESSIONAL EXPERIENCE

Confidential, Denver, Colorado

Senior Technical Integration Consultant

Responsibilities:

• Created Python-based internal web site in a dashboard format to collect and track code quality metrics among customer SaaS instances.
• Assess and design integration patterns for existing and new customer implementations.
• Assist with the hiring and mentoring of new and junior members of the team.

Skills: SQL, Data Modeling, Python, Bash, SaaS Data Integration, HTML, CSS3, Bootstrap

Tools/Technology: Flask, Eclipse, VS Code, Linux, Git

Confidential, Denver, Colorado

Senior ETL Developer

Responsibilities:

• Created an automated code-generation utility using Bash, Python, and sqlplus, enabling our team to develop standardized "source-to-stage" artifacts in minutes, as opposed to days or weeks. This allowed us to turn around data-integration tasks quickly, resulting in high quality, repeatable, and testable products.
• Created a regression suite, using Python, for a Spark ML application, its inputs and results.
• Created queuing and automation solution for a Spark ML application, increasing throughput over 400%. This freed up the team to focus on core functionality and performance.
• Upgraded Spark application to utilizing a more efficient execution strategy, with a more modular design, increasing performance by a factor of 10 and improving maintainability.
• Acted as both Lead and Mentor, on various projects, bringing new or Junior Developers up to speed quickly, with the goal of enabling them to tackle development efforts independently.

Skills: Java, Scala, PL/SQL, SQL, Python, Bash, REST, XML, Agile (Scrum)

Tools/Technology: Informatica PowerCenter, OracleDB, Linux, HortonWork HDP (Hadoop), Hive, Spark, Git, Tortoise SVN, IntelliJ (IDEA), Autosys, SQL Developer, Toad for Oracle, MsSQL, MsSQL Management Studio, CA Autosys

Confidential, Buffalo, New York

Sr. Data Architect, ETL Developer

Responsibilities:

• Designed and developed data-integration solutions for various customer accessible Data Marts.
• Designed Dimension, Bridge, and Fact table structures for an Enterprise Data Warehouse and developed solutions to populate them incrementally, in batch or on-demand methods.
• Reverse engineered long-running C++ file validation application into a simpler and faster script-based solution. The end-result saw run-times reduced from 30 - 60 minutes to less than 60 seconds.
• Created new design pattern for aggregations and sub-result aggregation (window-functions), reducing the number of steps and artifacts needed to produce a specified output.

Skills: PL/SQL, SQL, Bash, Python, SOA, XML, Agile (Kanban)

Tools/Technology: Informatica PowerCenter, OracleDB, Toad for Oracle, Linux, SQL Developer, MsSQL, MsSQL Management Studio, CA Autosys

Jr. Architect, Application Developer

Confidential

Responsibilities:

• Managed a large queue of application defects, performing root-cause analysis, and developing bug-fixes, where applicable. Over the course of my tenure I was able to reduce the defect backlog from several thousand to several hundred defects, categorizing and prioritizing them according to Project needs.
• Designed and developed new interfaces for third-party payroll vendor. The end result was a fault-tolerant, restart-able, and rerun-able solution that significantly decreased time and effort when a production outage occurred.
• Designed and developed WinForms UI and associated back-end stored procedures to deliver data-analytic and visualization specifications. The new UI provided our customers with new insights into application usage, legal compliance, and financial performance specifically as it applies to Labor Costs.

Skills: C#.Net, ADO.Net, PL/SQL, SQL, PowerShell

Tools/Technology: Visual Studio, Team Foundation Server, MsSQL, OracleDB, Toad for Oracle, IIS, MsSQL, MsSQL Management Studio, Quality Center, CA Autosys, ILOG Rules Engine, DevExpress

Confidential, Denver, Colorado

PL/SQL Developer

Responsibilities:

• Modified and Maintained existing Python applications used to ingest transactional data from file imports and web service calls.
• Worked to re-write a poor performing Spring Batch application, refactoring as a Producer / Consumer microservice strategy using JMS Queues.
• Created and modified PL/SQL packages, procedures, and functions to support existing ETL processes and to extend new data mart functionality.
• Assessed aging Inventory Management Data Warehouse for redesign recommendations while ensuring existing report functionality remains available.
• Assessed SSIS packages pertaining to Ingestion, Staging, Transformation, and Data Warehouse loads to find long wronging or inefficient workflows and patterns.
• Generated basic design documents for future development work.

Skills: SQL, Java (Spring) MicroServices, PL/SQL, Python, Bash, REST, XML, Agile (Kanban), Data Modeling, Project Management

Tools/Technology: OracleDB, Oracle WebLogic, Linux, Hive, Git, Eclipse, Toad for Oracle, GoCD Pipeline, SSIS, Microsoft SQL Management Studio, Linux, Git, Tableau