Ryli Dunlap

• Developed stored procedures, table schemas, and views for data models in a data lake: Snowflake, SQL
• Developed a test harness used by a team of ~10 developers to create unit tests for stored procedures: Snowflake, Python, pytest, SQL
• Assisted in loading data into a datalake and verifying data quality. Resolved data quality issues caused by bugs in stored procedure code and improved unit test coverage of stored procedures from 0 to over 90%: Snowflake, SQL, Airflow, Python, pytest

• Maintained middleware that supports various 3rd-party user identity and authentication services, print subscription management, and metered paywall access: Python, Flask, Zappa, AWS
• Designed, implemented, and deployed a new version of the middleware to address increasing demands of scaling to additional markets and integration with 4 external APIs. This is currently in production serving thousands of users and averaging ~10-20 queries/second: Python, Django, Zappa, AWS (Lambda, Aurora, ElastiCache)
• Maintained and added features to existing web-based tools used by developers and support staff to resolve customer account and identity management issues: Python, Django, JavaScript, JQuery, AWS
• Worked with front-end developers utilizing React to design the API and back-end for updated account management tools: Python, Django, Zappa, AWS (Lambda)
• Maintained and updated various reporting jobs. Wrote scripts to generate reports and user account audits: Python, AWS (Lambda), SQL

• Maintained and added features to a web-based development tool used by embedded software engineers of photolithography machines to visualize and analyze automated test results and data: Python, Django, MySQL, JavaScript, Bootstrap 4
• Developed new front-end UI functionality and implemented enhancements to existing UI elements. Converted ad-hoc elements to utilize highly-reusable open-source JavaScript and CSS libraries such as ag-Grid and Bootstrap 4.
• Refactored existing Django templates and views to utilize an API-based design. Developed new API endpoints and modified front-end components to utilize these new endpoints: Python, Django, Django Rest Framework, JavaScript, JQuery
• Developed Python and JavaScript libraries to normalize relational JSON data, thus reducing REST payload sizes and minimizing code complexity in the Python and JavaScript codebase.
• Developed custom Django form widgets and related frontend assets to improve reusability and adhere to DRY principles: Python, Django, JavaScript, Bootstrap 4
• Completed the ASML Software Academy: 3 weeks of software development process and Agile training. Gained familiarization of photolithographic processes used in the semiconductor fabrication industry and development of related embedded software.

• Maintained and added features to a leads routing and bidding system: Python, SQLAlchemy, MySQL
• Maintained and added features to a data portal used internally for querying metrics, campaign settings, and reporting: Python, Tornado, SQLAlchemy, MySQL, JavaScript
• Developed and maintained tools and scripts, deployment scripts, various scrapers/crawlers, and utility programs for internal use: Python, Fabric, MySQL
• Developed automated testing to ensure proper synchronization and consistency of data across various systems in the technology stack: Python

• Developed Python applications to support data collection from semi-autonomous railway track inspection vehicles.
• Developed and implemented a cloud-based data portal to enable operators and clients to view and analyze data collected by robotic vehicles in near-real time: Python, Ubuntu, AWS, Amazon IoT, PostgreSQL, Flask, Django, RabbitMQ, JavaScript/React

• Completed the LEAP training program (Mainframe Track). This included business acumen training as well as technical training on IBM z/OS series mainframe and related technologies: ISPF, JCL, COBOL, CICS, DB2
• Developed and maintained online (CICS) and batch programs for z/OS in support of trading and brokerage platforms.

• Worked on a team that helped rewrite software components critical to the business in need of optimization.
• Assisted with identifying and implementing changes to improve reliability and maintainability of code encompassing core business logic.
• Assisted with the consolidation of several systems and processes into one cohesive product developed in Ruby/Rails.
• Developed integrations to automate interactions with 3rd party payment portals and APIs.
• Developed the front-end component of a web-based business rules engine using JavaScript.

• Worked on a team responsible for the creation and maintenance of a dashboard tool to track statistics of other company software development projects.
• Implemented tools to assist with the tracking of code quality and helped to eliminate technical debt.
• Worked primarily with open-source technologies such as Spring MVC and AngularJS.

• Worked on a team with four other students to create a functional testing framework for the 1-800 Contacts website.
• Developed an automated browser testing solution using NodeJS, Grunt, Selenium, Intern, LeadFoot, SauceLabs, and Python.
• Won first place at the Summer 2015 Neumont University Project Showcase in the Enterprise Projects category.

• Maintained and developed new features for call center software utilizing Python, Django, PostgreSQL, Cassandra and FreeSwitch.
• Assisted clients with generating reports from large amounts of data consisting of call records and related performance and usage statistics.
• Provided technical support to call center personnel and assisted with troubleshooting and resolving technical issues and software bugs.
• Worked in the Philippines for two months interviewing and training a Philippines-based development team in Python, Django, and proprietary tools
• Developed APIs and integrations with 3rd party APIs to support various client needs.

• Assisted with the construction and maintenance of rail signals and grade crossing warning devices.
• Conducted various tests and troubleshooting of new and existing signal installations and related equipment including wiring, relays, and electronic control systems.
• Developed training aids such as this signal aspects quizzer: transvec.com/bnsf_signals.

• Performed data entry tasks involving Microsoft Access and Excel.
• Designed and developed a customer rewards site using Django, Python, and MySQL.

• Tested customer-facing retail website and internal customer/order management software for correct operation.
• Submitted bug reports and tracked progress of bug corrections.
• Ensured that bug corrections functioned correctly.
• Performed regular regression testing of new software builds prior to release and deployment.
• Assisted software developers with troubleshooting.
• Occasionally performed call-center duties.

• Employed safe lifting techniques while loading boxes often weighing in excess of 85 lbs. onto carts and vehicles.
• Assisted the store safety committee and participated in the 'safety bucks' program. Provided feedback and suggestions to management on implementing enhanced safety measures.
• Retrieved carts from the parking lot at regular intervals and in all weather conditions. Adhered to safety precautions while maneuvering rows of carts around vehicles in a busy parking and loading dock areas.
• Organized large home-delivery orders and prepared merchandise for shipment. Completed relevant paperwork.
• Worked varying shifts and hours including weekends and holidays. Regularly volunteered to work additional shifts during periods of high customer volume often resulting in work days in excess of 12 hours.
• Employee of the month May 2010.

• Enlisted MOS: 15J (OH-58D Electrical/Armament/Avionics Systems Repairer).
• Served as an Information Management Officer and SharePoint information portal administrator as an additional duty while enlisted.
• Selected to attend Warrant Officer Candidate School and Rotary-Wing Flight Training.
• Honorably discharged as a Warrant Officer (WO1).
• Earned 3 Army Achievement Medals.

• Cumulative GPA of 3.9
• Selected to present in Neumont University’s 2015 Capstone Project Invitational
• Neumont University President’s List (Quarters 1-10)
• Student of the Quarter (Spring 2015)

• Taught 9 hours of English classes to non-native English speakers at 3 different skill levels.
• Developed lesson plans and curricula.

• Completed Primary and Instrument Flight Training for the TH-67 helicopter.
• Operated aircraft within prescribed parameters and in accordance with given regulations and procedures with a strong emphasis on safety.
• Performed pre-flight and post-flight inspections of aircraft.
• Maintained aircraft and equipment logbooks and records.
• Conducted flight planning and completed related paperwork and forms.
• Developed the flight school training aids at www.transvec.com.

• Honor Graduate

• Distinguished Honor Graduate.
• Earned the Military Skill Identifier of 15J.
• Completed Basic Electronics Training.
• Maintained armament, electrical, communication and avionics systems on OH-58D Kiowa scout helicopters.
• Conducted troubleshooting to identify and diagnose malfunctioning equipment.
• Performed various repairs and preventative maintenance in accordance with technical publications and safety directives.
• Ensured forms, tags, and maintenance logs were completed accurately.

• Served as the Business Professionals of America Chapter President from August 2004 - June 2005.

A program for Linux that allows a violin to be used as a MIDI controller for existing audio and DJ software such as Mixxx

An online poker training site allowing users to learn poker and play with other real players for free using play money/credit.

A Java-based desktop application with a piano-roll interface allowing users to visually compose, arrange, and playback music using MIDI.

IT Proficiency

• Python, Django
• Java
• HTML, CSS, JavaScript (JQuery, Knockout)
• Databases (SQLite3, MySQL, PostgreSQL), SQL
• Source control (mainly Git, but also familiar with Subversion, Mercurial, and TFS)
• Linux, Vim, *NIX command line tools
• Ada

Certificates and Licenses

• FCC General Radiotelephone Operator License (Ship Radar Endorsement)
• Military Equipment Operators Course (HMMWV series truck)
• CELTA (Certificate in English Language Teaching to Adults)

• Billy Mitchell Award (Civil Air Patrol)
• Eagle Scout