Joshua Schlichting

Experienced developer with a strong background in Python, C#/.NET, and SQL.


Experience

Technical Architect

Sallie Mae Bank - IT
  • Develops modern software solutions to remove dependencies on outdated technology using Python.
  • Leads the development efforts of business automation solutions using Python, and Netezza SQL, to drive down operational costs and decrease corporate risks.
  • Analyzes legacy IT processes and identifies potential areas for improvement, optimization, and automation.
  • Gathers requirements from various business and technical partners to uncover areas of risk for continued monitoring in Netezza databases.
  • Leads the development of reporting solutions using Python, .NET, SAS, Data Toad, and Aginity Workbench for Netezza to provide high quality and actionable results.
  • Provides architectural oversight to the team on reporting structures and methodologies to ensure consistency and accuracy.
  • Develops key metrics for monitoring activity and identifying areas of risk.
  • Assists the business analyst team in the discovery and design phases to develop high quality and sustainable solutions for our business partners.
  • Act as a change agent to influence new and improved ways to achieve high quality strategies for technical solutions.
  • Works directly with business and technical partners to fully understand areas of risk or customer disruption.
  • Provides leadership support to uncover full population identification by thoroughly investigating all impacted systems.
  • Develops remediation plans to ensure complete coverage and minimal disruption to internal and external customers.
  • Provides support to other members of the team to improve technical solutions and advance operations.
  • Assist with problem solving exercises, as needed, to all members of the business and technical teams.

March 2017 - Present

Reporting Anaylst (.NET (C#) /SQL/SAS Developer)

Sallie Mae Bank - Business Optimization
  • Work in Visual Studio (using C#, ASP.NET MVC, JavaScript, jQuery, Razor, HTML, CSS, and Bootstrap) to develop reporting wiki page, providing the company with a central location to find information and meta data related to all reporting and data feeds.
  • Develop with Visual Studio (C# and FlexCel for Excel), batch file scripting, and SAS E-Guide to automate routine work, reducing man-hours lost to manually performed tasks. These tasks include executing SQL queries, producing Excel workbooks for executive level reporting, and production data feeds necessary for daily bank operations.
  • Support back-end of reporting wiki website by developing a normalized relational database and appropriate entity relationship diagrams for such.
  • Work with project managers and department leaders to design, develop, and implement new data feeds needed to improve the call center’s ability to support customer inquiries.
  • Query/analyze databases and information systems using Microsoft SQL Server Management Studio, Aginity Workbench for IBM Netezza, SAS Enterprise Guide, Data Toad and more.
  • Monitor hundreds of scheduled tasks to ensure that databases are being fed current and accurate data.
  • Update stored procedures, tables, and functions as business needs change and evolve.
  • Prepare and present data/reports to all levels of management.
  • Create data views to facilitate customer reporting needs as well as the needs of the reporting team.

January 2015- March 2017

Education

Pennsylvania State University

Master's Degree, Software Engineering
2019 - Current

University of Phoenix

Bachelor's Degree, Software Engineering

GPA: 3.8

2013 - 2016

Community College of the Air Force

Associates Degree, Instructor of Technology and Military Science
2011 - 2013

Community College of the Air Force

Associates Degree, Aviation Maintenance Technology
2010 - 2012

Skills

Programming Languages & Tools
Frameworks
Tools
Workflow

Interests

I should first say here, that programming IS my interest. It's what I do, at work, and at home. It's my #1 passion. Aside from that, I enjoy reading about quantum physics, pondering about how the universe works, and listening to the Joe Rogan Experience pod cast. While I don't care for MMA, I really enjoy listening to Joe Rogan and the guests he has on his show from the science community.

Outdoors, I enjoy riding my dual sport motorcycle through the mountains of Pennsylvania and Tennessee.


Awards & Certifications