09/06/2022 updated

AD
100 % available

TSQL Database Developer/Database Conversion Consultant

USA
USA
Bachelors
USA
USA
Bachelors

Profile attachments

CV - Allan Davis

Microsoft AccessASP.NETJava (Programming Language)Microsoft ExcelAtlassian ConfluenceC++ (Programming Language)Adobe ColdfusionComputer ProgrammingDatabasesSAP Crystal ReportsExtract Transform Load (ETL)DBaseDebuggingElectronic Data Interchange (EDI)FoxProIntranetMicrosoft Visual StudioMicrosoft OfficeMicrosoft SQL ServersTeam Foundation ServerM Programming LanguageOracle ApplicationsRaiser's EdgeSalesforce.ComMicrosoft SharePointStored ProcedureSQL DatabasesSQL Server Reporting ServicesSQL Server Integration ServicesTransact-SQLWi-Fi TechnologyColdFusion ComponentsDatabase MigrationComputer ArchitectureCisco
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

Languages

ArabicNative speaker

Project history

Contract Database Analyst/Consultant

RIC Software
RIC Software - Omaha, NE
* Analyzed, repaired, and upgraded an in-house proprietary SQL database.

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.

L2 Technical Support

Cosentry
Cosentry - Bellevue, NE
* Assisted Cisco clients worldwide with troubleshooting, hardware replacement, and server
replacement.

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.

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

Contact form

Log in to get in touch

You need to be logged in to use the contact form.

Sign upLog in