Contract Database Analyst/Consultant
RIC Software
Skills
Microsoft SQL, Microsoft Access, Database, Database Migration, Raiser's Edge, Salesforce, wifi, wiki, SQL database, stored procedures, SQL Server, Visual Studio 2005/2010, SSIS, Team Foundation Server, Microsoft Office, Cisco, Sharepoint, Intranet, SQL and Access databases, Atlassian, Confluence, HTTPS, ColdFusion, Java, ASP, Net, C++, TPC, Crystal Reports, Oracle, Dbase, SQL, server hardware, Macromedia Cold Fusion, programming, SQL Server 2000, Visual Studio 2005, Microsoft Excel, SSRS/SSIS, ETL, EDI, Debugging, Cactus, Macromedia, ColdFusion MX, Foxpro, Mumps
Project history
01/2014
-
03/2014
RIC Software - Omaha, NE
* Analyzed, repaired, and upgraded an in-house proprietary SQL database.
* Analyzed, repaired, and upgraded an in-house proprietary SQL database.
03/2012
-
01/2014
Database Programmer Analyst
Nelnet
Nelnet - Lincoln, NE
* Notable projects: File Slinger, Refunds Rejects Automation Project, Xerox IPAC Process
* Provided customer database support, ad-hoc and daily reports, troubleshooting, testing and
implementation of a wide variety of systems and stored procedures, utilizing SQL Server, Visual
Studio 2005/2010, SSIS, Microsoft Access, Team Foundation Server, and Microsoft Office.
* Notable projects: File Slinger, Refunds Rejects Automation Project, Xerox IPAC Process
* Provided customer database support, ad-hoc and daily reports, troubleshooting, testing and
implementation of a wide variety of systems and stored procedures, utilizing SQL Server, Visual
Studio 2005/2010, SSIS, Microsoft Access, Team Foundation Server, and Microsoft Office.
10/2011
-
03/2012
L2 Technical Support
Cosentry
Cosentry - Bellevue, NE
* Assisted Cisco clients worldwide with troubleshooting, hardware replacement, and server
replacement.
* Assisted Cisco clients worldwide with troubleshooting, hardware replacement, and server
replacement.
03/2011
-
08/2011
Contract SQL Database Programmer
Terrascan
Terrascan - Lincoln, NE
* Coded new stored procedures and modified existing code for a complex proprietary Property Tax
Assessment and Tracking system.
* Coded new stored procedures and modified existing code for a complex proprietary Property Tax
Assessment and Tracking system.
01/2000
-
12/2009
Database Programmer/Analyst
Designed, tested, and analyzed database issues for a variety of clients, first in the Phoenix metro
area, and later in Lincoln, Nebraska. Notable employers and freelance clients include:
* Kenexa
* Triwest Healthcare Alliance
* TPC Enterprises
* DHL
* Shea Homes
* American Express
* Sun Health Corporation
* StarHRG
* Redesigned a complex data system (that involved using Crystal Reports to pull from Oracle, Forest
& Trees to pull from Dbase, and Microsoft Access to merge it all together) into a SQL and Access
solution that saved two days worth of report generation time each month.
* Served as first point of contact and subject matter expert for the ADM Master Inventory database
that tracked all American Express server hardware and software worldwide.
* Managed the operation of an Online Insurance Enrollment System responsible for over forty
thousand insured enrollees and one million dollars in monthly premium.
* Designed, programmed, and tested a Tech Team database for tracking issues and upgrades across
25,000 client systems.
* Rewrote, as part of a three-person team, the "Blue Card" prospect/client tracking database from
Microsoft Access to Microsoft SQL with a ColdFusion front end.
* Designed, tested, and implemented a "Web-Enabled" interface to the Affinity Patient Database
using Microsoft SQL and Macromedia Cold Fusion, allowing Sun Health physicians to view patient
data from all of the seven facilities on a single screen.
* Functioned as Intranet Emergency Support when the Webmaster left with no notice. Learned web
programming and ColdFusion as needed to keep the company Intranet operational.
* Updated, with four team members, over 25,000 DHL shipping computers worldwide with updated
routing and handling data files.
* Worked extensively with cross-functional teams to ensure timely and accurate deliverables.
* Mastered any tools, skills, or languages necessary to complete the project, including:
* Microsoft SQL Server 2000 through 2014
* Microsoft Access
* Visual Studio 2005 through 2010
* Microsoft Excel
* SSRS/SSIS
* Team Foundation Server
* ETL and EDI data translation formats
* Database structure and normalization
* Code documentation and annotation
* MSDOS Batch programs
* Debugging and Troubleshooting techniques
* Crystal Reports
* Visual Cactus
* DBase2
* Oracle
* Landacorp MaxMC
* Macromedia/Adobe ColdFusion MX
* Foxpro
* Mumps
* Affinity
area, and later in Lincoln, Nebraska. Notable employers and freelance clients include:
* Kenexa
* Triwest Healthcare Alliance
* TPC Enterprises
* DHL
* Shea Homes
* American Express
* Sun Health Corporation
* StarHRG
* Redesigned a complex data system (that involved using Crystal Reports to pull from Oracle, Forest
& Trees to pull from Dbase, and Microsoft Access to merge it all together) into a SQL and Access
solution that saved two days worth of report generation time each month.
* Served as first point of contact and subject matter expert for the ADM Master Inventory database
that tracked all American Express server hardware and software worldwide.
* Managed the operation of an Online Insurance Enrollment System responsible for over forty
thousand insured enrollees and one million dollars in monthly premium.
* Designed, programmed, and tested a Tech Team database for tracking issues and upgrades across
25,000 client systems.
* Rewrote, as part of a three-person team, the "Blue Card" prospect/client tracking database from
Microsoft Access to Microsoft SQL with a ColdFusion front end.
* Designed, tested, and implemented a "Web-Enabled" interface to the Affinity Patient Database
using Microsoft SQL and Macromedia Cold Fusion, allowing Sun Health physicians to view patient
data from all of the seven facilities on a single screen.
* Functioned as Intranet Emergency Support when the Webmaster left with no notice. Learned web
programming and ColdFusion as needed to keep the company Intranet operational.
* Updated, with four team members, over 25,000 DHL shipping computers worldwide with updated
routing and handling data files.
* Worked extensively with cross-functional teams to ensure timely and accurate deliverables.
* Mastered any tools, skills, or languages necessary to complete the project, including:
* Microsoft SQL Server 2000 through 2014
* Microsoft Access
* Visual Studio 2005 through 2010
* Microsoft Excel
* SSRS/SSIS
* Team Foundation Server
* ETL and EDI data translation formats
* Database structure and normalization
* Code documentation and annotation
* MSDOS Batch programs
* Debugging and Troubleshooting techniques
* Crystal Reports
* Visual Cactus
* DBase2
* Oracle
* Landacorp MaxMC
* Macromedia/Adobe ColdFusion MX
* Foxpro
* Mumps
* Affinity
Local Availability
Only available in these countries:
USA
