Jeremy Baker
Profile
Seeking a position where deductive reasoning, data analytics, and SQL development skills will be applied and enhanced.
Summary of Strengths
Data Analysis
Database Developer (SQL, SQL SERVER)
ETL
Software Engineer (VBA, C#)
Proficient with MS Office (Word, Excel, Outlook, Access)
Advanced MS Excel (Pivot tables, VLOOKUP)
Web development (HTML, CSS, JavaScript)
Troubleshooting and problem solving
Polished and confident speaker
Conveys complex information simply
Adaptability and flexibility
Confidentiality
Detail oriented
Employment
Healthcare Professionals Federal Credit Union Richmond, IN
Accounting Auditor (contract) 06/2008 – 05/2017
Responsible for $17 million average daily balance reconciliation, root-cause analysis for all posting
anomalies, and correction of entry errors. Spearheaded projects to ensure credit union compliance
with Federal audits. Other value added initiatives included:
Developed MS Access database with data extracted from company software to pinpoint anomalies for escalation to manager
Proposed and implemented adjustments to journal entries
Generated loan report totals each month group by percentage rate
Created loan analysis and breakdown report each month
Sure-Tech Labs Indianapolis, IN
Software Engineer 04/2016 – 12/2016
Provided LIMS software and database support, which included interfacing lab instruments with LIMS, real time problem solving and troubleshooting, automating email reports for customers, and implementing preplanned preventive measures to resolve issues encountered during the previous year.
Projects
Database – HCPFCU
Developed a database for finding atm posting errors that were causing daily totals to be out of balance. The database pinpointed to the day and transaction where the error occurred. The project lead to beneficial procedural adjustments to significantly reduce the occurrence of atm posting errors. The database was also converted from MS Access to SQLSVR with a webpage display and with Access coding being rewritten as SQLSVR procedures.
Calendar
I researched how the Gregorian, Julian, and Hebrew calendars were designed and how they function. After learning how they corresponded to each other I developed a table with corresponding dates.