Cell: 317-***-**** Joseph A. Obergfell ** Jordy Court
http://www.linkedin.com/in/joeaobergfell firstname.lastname@example.org Hamburg, New York 14075
C#, VB.NET, Visual Studio .NET 1.1 – 4.7 (and Visual Studio 6), VS2017, VS2019, and TFS
Exact Target API/ Emailing Client
Full Development Cycle, Update Development Cycle
Wordpress/MySQL (on Windows 2008 server hosted locally)
Database Management, Microsoft SQL 2000 and later, Microsoft Access 97 and later, SSRS and RDL/RDLC dev
Windows 2000/XP, various Linux OS
(touched on): AJAX, .NET 3.5/VS 2008 and .NET 4.5/VS 2012 . PHP
Basic Windows 2008 and 2012 server knowledge
M&T Bank (Buffalo, NY): Software Engineer II 10/19-03/2021
Wild Birds Unlimited (Carmel, IN): Senior Developer 10/15-09/19
Create, Alter and maintain Stored Procs, Tables, and Triggers. Alter and maintain data as well as SSRS (RDL/RDLC based reports), SSIS, SSAS tools. This is handling hundreds of thousands of records a month. Certain times of the month, maintaining Fragmentation of indexes and data, rebuild and/or reorganizing indexes. Every so often, re-evaluating the performance of various queries, stored procs, and pulling of the data to ensure ease of SSRS/SSAS reports. Pushing data through SSIS tool for SSAS reports once a month (for Seed Reports).
Developed and maintained multiple software including ETL (DLLs) pulling franchisee data from over 250 stores into a Datawarehouse twice a month, update excel based framework for if/when stores have to submit their reports via excel instead of ETL (mentioned above). Maintain and update current tools ranging from 16 bit windows applications to web based crystal Reports and Report Viewer reports, Maintain multiple databases both Microsoft T-SQL based and Access based, Maintaining Microsoft RMS POS systems on over 200 stores and understanding how their systems are configured as well as understand stores that are still on Lotus and/or QuickBooks I also maintain data for Sales and Seed Cubes (viewed in Excel pivot tables) -SSAS. Goals currently working on: Moving all apps up to latest software tools (off of the lotus and non pos tools), as well as assist in end development for an ordering system via smart phone app and reproducing reports which have been ran at the store level, to also be ran at the main franchise office, but point to the datawarehouse instead of the individual POS databases. As well as streamlining all tools into a central location. Tools used: VB 4/5/6 with MSFT Access 97 and Crystal Reports, Visual Studio 2008, 2010, 2013 tools under .NET 2.0-4.5 VB.Net version and RDL(C) reporting, and SQL Databases ranging from 2005-2012 (pending on database server.)
Fusion Alliance (Indianapolis, IN): Business Analyst 04/15-10/2015
Write up project requirements for various companies which work on ComTrac tool. C# 2013, RDL report writing, Microsoft SQL 2005 (and later), and other tools. Creating write ups with sql queries which identify what is needed in set write ups.
Indianapolis Public Schools (Indianapolis, IN): Systems Analyst; 11/09-04/15
Maintains several projects, either Full life cycle or upgrade cycle (pending on project specs). Pull data for reports including for Indiana Department of Education (IDOE), and several grants. Maintain data for set projects set above, including altering data if set information was incorrectly entered or altered. Working with Report Card team (ensuring report cards are updated properly). Projects completed or working on: Setting Standard Order Procedures (full cycle development), updates from legacy Databases (VAX to SQL 2005) and Projects Textbook Rental (vb.net, Windows App, SQL, Update Cycle, services all students [30,000 or so]) to latest tools, Individual Student Plans (ISP) for alternative ed students (vb.net SQL, asp.net, web development, full cycle development – Services 5000-6000 students/year), ESL Students (vb.net SQL, asp.net, web development, full cycle development), and Calculation Days (vb.net SQL, asp.net, windows development, full cycle development), Student Exit/Withdrawn Forms (vb.net SQL, asp.net, web development, full cycle development), batch coding/stored procedures (downloading data into files, [s]FTP upload to remote server, move files around, and email set files per request). HVAC web app (c# 2010, SQL 2008 – services over 100 schools within the IPS system) – tracking, ordering, maintaining air filters within the various schools. IPS Police app (c# 2010, SQL 2008) – tracking police incidents through the whole process from documentation through final outcome. All tools created and maintained use SQL stored procedures to pull the data. All apps have utilized SSRS/RDL reports to output data for reporting purposes. Sometimes, data is loaded from an external source (ie: school istep results) and inserted into the system.
Visual sourcesafe 6 used, and was starting to move to TFS before I left. Reporting using SSRS and stored procedures to maximize results and report to various resources like the IDOE.
IBJ Media Corp (Indianapolis, IN): Web Developer; 7/07-3/09
Meijer (Camby, IN): Associate: Inventory Analyst/Systems Analyst; 10/03-4/04, 9/04-6/07
Work and maintain Inventory, update Database, maintain POS systems and Windows 2003 Server.
Indianapolis Motor Speedway(Indianapolis, IN): IT internship; 1/06-4/06
Fundraiser Application which allows data entry, inventory tracking, and fund raiser information. Database Development (Using Microsoft SQL and Stored Procedures, ASP.NET and C#) using Microsoft Great Planes, Microsoft SQL 2003, ASP, C# and Visual Studio 2003.
Profits On-Hold Productions/InstaHold Technologies(Fort Wayne, IN): Intern; summer 2004
Web Development (Frontpage and Dreamweaver), Answer Phones, and Communication with clients.
University of Indianapolis Computing Services (Indianapolis, IN): Help Desk; 1/04 – 4/04
Answered Computer Questions, filled out requests to repair network problems
University of Indianapolis
Bachelor of Science Degree, graduated: May 2006 Computer Science Minor: Computer Information Systems
Web Site Development: 1/07-Present (websites by requests)
Asp.NET, C#/VB.NET with Visual Studio 2005-2012; Database Management with Microsoft SQL Server 2005-2012. Wordpress (v 3.6) sites with MySql 5.6). Most sites are hosted on Windows 2008 Standard server which I maintain and own locally.
Adults On the Spectrum: Leader/Owner of social group for Adults with Autism/Asperger’s Syndrome; 8/10-08/16
Bring Adults on the Autism Spectrum together to communicate and interact with each other
Share information on services, paths, and development concepts since coming of Adulthood.
Group’s Wordpress v3.6 (and later) and MySql v5.6, maintained on Windows 2008 Server personally owned and operated
Works alongside Autism Companion Magazine and other local Autism Teams as need basis.
State Level Non For Profit
Working on new tools for next level market in classic asp, odbc, MySQL, and Windows 2012 server.
LOST (Linux Open Source Technology) Club: President on the Executive Board, Founding Member; 10/04- 4/05
Collaborated with the executive board, members and staff sponsors. Created the club, set up times and location.
STIG/MA Club (Science, Technology, and Math): Secretary on the Executive Board, Founding Member; 9/03-4/04
Took minutes and collaborated with the executive board
Appalachia Service Project: in Jonesville, Virginia Construction; 1/03 & 1/04
Built and repaired houses to help less fortunate families in Appalachia
Indiana Autism Sertoma Club: Secretary on the Executive Board, Founding Member; 5/03-1/04
Took minutes and collaborated with the executive board