Nick Ostendorf
Education
- 2017-2022
- BS, Computer Science; Georgia College & State University (Milledgeville, GA)
- Graduated May 2022
Experience
- 2023-Present — Atlanta, GA
- Franklin Street - Senior Data Analyst
- Lead engineer for in-house CRM platform with a team of 6 engineers (both .NET Framework 4.8 MVC and .NET Core 6.0 with React frontend)
- Led development on integrating Elastic Search and a Change Data Capture into our CRM for faster searching and data synchronization
- Developed and maintained a sophisticated data migration tool using Python, Flask, Redis, Celery, MS SQL, and orchestrated deployment on an Azure Kubernetes cluster, facilitating seamless data synchronization between systems
- Designed and implemented ETL Logic Apps to efficiently import data from multiple APIs into the database, ensuring data accuracy and availability for reporting needs
- Provided mentorship and training to team members, fostering skill development in data migration, Power BI reporting, and ETL development
- May 2022-March 2023 — Atlanta, GA
- Franklin Street - Data Analyst
- Created and managed dozens of Power BI reports, including a comprehensive report consolidating company-wide deals and financial data over various time periods, offices, and locations, catering to both C-suite executives and employees
- Utilized Python, MS SQL, and various dashboard/visualization tools to extract data intelligence and perform data analysis
- Collaborated with Data and IT departments to process data and generate reports for associates and clients
- 2021-2022 — Atlanta, GA
- Franklin Street - Intern
- Spearheaded data cleaning and restructuring efforts for decade-old company data as part of the Data Initiative Team
- Automated data deployment processes using Azure services, ensuring employees had access to up-to-date information
- Collaborated across business lines to support data-driven decision-making
Technical Experience
Sports Analytics Dashboards
- Designed and implemented an architecture combining Python, Flask, MySQL, and public sports APIs to serve web applications for sports analytics
- Created interactive dashboards showing NCAA basketball and MLB statistics, live scores, betting lines, and player matchup data
- Built data scraping and processing pipelines to automate daily updates of player and team statistics
Golf Pool Application (In Progress)
- Developing a React/Vite application that allows users to create and join tournament pools to compete with friends
- Implementing user authentication, dynamic leaderboards, and real-time tournament tracking
- Creating an intuitive interface for selecting players and viewing standings across multiple tournaments
| Skills | Programming Languages |
|---|---|
| - Highly Organized | - Python |
| - Solution Focused | - C#/Java |
| - Operations Management | - PHP |
| - Goal Oriented | - C/C++ |
| - Interpersonal Communication | - SQL |
| - Team Leadership | - JavaScript/React |