Eager to help bring technology solutions to organizations with over eighteen years in providing IT analysis and system support for small businesses and also a Fortune 100 company. A self-motivated and organized professional with a proven ability to find innovative and unique solutions for a wide customer audience.
Nationwide Mutual Insurance Company and Nationwide Life Insurance Company
Specialist, Software Engineering -- 2018 - Present
Created a program in Python that runs on Docker and Kubernetes and connects to an Oracle database to query from billions of rows of data submitted for retirement plan contributions and builds a file formatted for loading onto a third-party system.
Increased process efficiency 68 times faster than the previous implementation by converting code written in Oracle PL/SQL which was then used to create external tables and generate reports with comparison data from a vendor partner into an automated process. This helped analyze billions of rows of data in a timely fashion which was critically needed to verify financial allocation and transactional data integrity from a process that previously took 7 hours and now completes in 6 minutes. This is used to verify a data conversion project moving over 2 million account records and over 39 billion in assets.
Develop for, support and maintain a collection of SOAP and REST Web Services which are responsible for processing over $500 million in financial asset allocations for over 18,000 clients and processing loan repayments for over 43,000 members (about twice the seating capacity of Madison Square Garden) with more than $335 million in loan balances.
Developed and implemented an automated task processing system which handles over 40 tasks ranging from looking for and detecting fraud and improving customer quality assurance, to automating ETL (Extract Transform & Load) process for vendor conversion data.
On-boarded "Contrast Security" scanning software into test regions for the 9 Web Services I support and manage and then remediated found issues to improve system security.
Created and implemented a continuous integration (CI) pipeline using Concourse, which automates builds from GitHub using Maven, Docker for image creation and Artifactory and Harbor to store image builds, and integrated Sonar security code scanning, and then a continuous deployment (CD) pipeline using Harness to automate deployment of Web Services back-end server and code to Kubernetes and also the endpoint code to Apigee.
Specialist, IT Analysis - 2012 - 2018
Maintain a collaborative relationship with our integrated application services departments and work closely to resolve issues as they arrive.
Developed and executed a plan for analysis and forecasting of IT service requests with over 94% accuracy.
Perform root-cause analysis for complex issues regarding financial and transactional data.
Provided security analysis of customer portals for vulnerabilities and investigated Internet-related security and privacy events and financial breaches.
Hosted "lunch and learn sessions" with our forward facing technical support team which resulted in a deeper understanding of our systems so front-line employees are better equipped to service customers.
Introduced continuous improvement initiatives to improve customer satisfaction and reduce IT workload.
Develop and execute SQL scripts to perform maintenance tasks across thousands of tables of relational databases with billions of records which are all interconnected for Nationwide Retirement Plans record-keeping system and websites.
Sr. Analyst, Business Consulting - 2008 - 2012
Provided technical support of Nationwide websites and desktop applications used by Nationwide Financial Operations, Third-Party Retirement Plan Administrators, Retirement Plan Sponsors (Employers), and Payroll Providers.
Constructed and modified SQL scripts to query databases and create ad-hoc reports for customers and to research problems with data sent to Nationwide.
Located and restored data from our UNIX archives and analyzed files rejected by the system.
Initialized and maintained the establishment of secure data transfers between Nationwide and their customers electing to send sensitive data electronically.
Provided analysis for the Nationwide Customer Contact Center to identify common call types which allowed them to increase availability to accommodate increased call volumes during periodic intervals.
Commercial Processor - 2006 - 2008
Was responsible for accurate locating and importing data lost or compromised during the automated database transfer and notifying parties impacted from issues arose in the process.
Built a database and analyzed data from Crystal Reports to provide a return on investment (ROI) analysis of process change implementation.
Bell-Haun Systems, Inc.
IP Network Technician / Systems Trainer 2005 - 2006
Consultant for handling network and computer related issues.
Maintained IP Network hosted and digital keyed phone systems.
Administered maintenance upgrades to office computers.
Developed user guides for phone system deployments.
Conducted on-site training of phone systems and programmed additional changes
Leve Agri-Man, Inc
Levering Farms, Inc
TD Landscape & Maintenance, LLC
External Consultant 2005 - Present
Maintain and deploy computer assets and provide troubleshooting
Advise on computer assets and acquisitions
Configure and maintain local private network
Provide off-site file directory backups to reduce downtime in the event of hardware failure
Diagnose and fix computer hardware and operating system issues
Configure and maintain email and domain name services.
Oversaw implementation of IT expansion
Expanded / Upgraded Network
Mount Vernon Academy – 1993 – 1997
The Ohio State University – Electrical Engineering – 1998 – 2000
Columbus State Community College – Computer Science – 2001