Allan G. Davis Jr.
800 E. 12th St
Crete, NE 68333
[Send email to request phone number] 17-4740
[Send email using form at bottom]
PROFILE
Seeking a challenging and rewarding position that utilizes my skills at
presenting technical information in clear language, and my logical analytical
talents, to the fullest.
Ten years of Database Programming experience, primarily using Microsoft SQL,
Microsoft Access, and Macromedia Cold Fusion MX.
Over twenty-five years total of computer experience, including building,
repairing, troubleshooting, and programming.
EXPERIENCE
Contract Phone Tech Support – July 2009 to Present
PayPal – Omaha, NE
• Provided telephone and email technical support to PayPal clients migrating
their Payflow implementation to version 4.
• Answered technical questions, assisted with coding and troubleshooting, and
provided any technical assistance necessary as over 70,000 PayPal clients
upgraded their websites and billing systems, many on a tight deadline.
• Supported developers in a wide range of technologies and platforms, including
HTTPS, ColdFusion, Java, ASP, .Net, C++, and many others.
Software Engineer – May 2007 to May 2009
Kenexa – Lincoln, NE
• Responsible for all technical phases of survey projects (DB Setup, Survey
Setup, Response Rate, Reporting, & Action Planning).
• Customized surveys; collected, processed, and analyzed data from surveys of
clients (including Fortune 500 companies), like ING, McGraw-Hill, Luxottica, Toys
“R” Us, and Circuit City.
• Generated reports using MS Access 2003, MS SQL Server, SQL Server Reporting
Services, MS Excel, and versions 12 and 13 of Reporting Engine, an in-house tool
that incorporates Access, ASP.NET, and SQL Server.
• Worked extensively with cross-functional teams to ensure timely and accurate
deliverables.
Database Programmer/Analyst–August 2006 to May 2007
Triwest Healthcare Alliance – Phoenix, AZ
• Developed reports and analyzed data using a variety of tools and systems,
including Forest and Trees, SQL Server 2005, MS Access, DBase2, Oracle, Landacorp
MaxMC, Visual Cactus, Crystal Reports, and MS Excel.
• Redesigned a complex data system (that involved using Crystal Reports to pull
from Oracle, Forest & Trees to pull from Dbase, and MS Access to merge it all
together) into a SQL and Access solution that saved two days worth of report
generation time each month.
Consultant/Database Programmer–February 2006 to July 2006
TPC Enterprises – Phoenix, AZ
• Analyzed and diagnosed a series of issues with a damaged installation of
Windows Enterprise Server 2003 and SQL Server 2000, including failures in backups
and purging, blue screen crashes, and system lockups.
• Developed and implemented solutions for a proprietary Accounts Receivable
system using SQL Server 2000, Crystal Reports, and MS Access.
• Designed and tested a replacement Billing Statement in MS Access.
Consultant/Database Programmer–December 2005 to February 2006
Shea Homes – Scottsdale, AZ
• Analyzed, tested, monitored, and repaired Intranet reporting systems utilizing
SQL Server 2000, MS Access, Business Objects, InfoBurst, and MS Excel.
Contract Business Analyst/Database Programmer– August 2005 to December 2005
DHL – Scottsdale, AZ
• Updated, with four team members, over 25,000 DHL shipping computers worldwide
with updated routing and handling data files.
• Analyzed and diagnosed international routing issues.
• Converted and imported EDI data into and out of a number of formats using MS
Access, MS Excel, and a variety of in-house proprietary tools.
• Designed, programmed, and tested a Tech Team database for tracking issues and
upgrades across 25,000 client systems.
Contract Database Administrator– January 2005 to June 2005
Direct Alliance Corporation – Tempe, AZ
• Designed, tested, and repaired Intranet systems utilizing MS SQL, Macromedia
Cold Fusion MX, Fusebox, Visual Basic, MS Access, MS Excel, and Foxpro.
• Worked with standard queries, stored procedures, scheduled jobs, export
routines, and data warehousing.
• Built a “Spiff Tracker” web page that calculated bonus sales commission for
thirty call center employees based on “Monthly Special” sales efforts.
Contract Database Programmer/Analyst – November 2003 to December 2004
American Express – Scottsdale, AZ
• Served as first point of contact and subject matter expert for the ADM Master
Inventory program that tracked all American Express server hardware and software
worldwide.
• Designed, modified, and tested data entry forms and web pages to allow
searches and updates to the inventory database.
• Designed and implemented Data Access Pages using MS Access, VBScript, and
XML.
• Processed user requests for database information, including ad hoc requests,
exception reports, update queries, and “data mining” using MS Access.
Database Administrator - June 2001 to September 2003
Star HRG - Phoenix, AZ
• Rewrote, as part of a three-person team, the Blue Card prospect/client
tracking database from MS Access to MS SQL with a Macromedia Cold Fusion front
end.
• Managed the operation of an Online Insurance Enrollment System responsible for
over forty thousand insured enrollees and one million dollars in monthly premium.
• Coordinated enhancements, trained users, and provided customer support and
troubleshooting.
• Programmed Intranet reporting and query tools for clients utilizing MS SQL
Server, MS Access, Macromedia Cold Fusion and MS Office.
Database Programmer/Analyst - February 2000 to June 2001
Sun Health Corporation - Sun City, AZ
• Programmed and debugged queries for searching, sorting, and updating the
Affinity Patient Database using MUMPS programming and Affinity query language.
• Designed, tested, and implemented a “Web-Enabled” interface to the Affinity
Patient Database using MS 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 Cold Fusion as needed to keep the company
Intranet operational.
Year 2000 Analyst - February 1998 to February 2000
Sun Health Corporation - Sun City, AZ
• Evaluated over 1200 desktop, server, and mainframe systems for potential Y2k
issues in BIOS, Operating System, and application software, and updated systems
as required.
• Contacted business partners to verify Y2k status
• Ensured that the Y2k rollover had negligible impact on Sun Health patients,
systems, or business.
EDUCATION
Bachelor of Applied Science in CAD Technology, Specialty in Virtual Reality -
April 1998
University of Advancing Computer Technology (formerly CAD Institute) - Phoenix,
AZ
Associate of Applied Science in CAD Technology - December 1996
University of Advancing Computer Technology (formerly CAD Institute) - Phoenix,
AZ
Associates Degree - June 1992
Hartnell Community College - Salinas, CA
SKILLS
Over twenty-five years experience in many aspects of computer operation,
maintenance, and programming. Able to quickly and easily learn new languages
and system tools.
Especially skilled at translating technical jargon to English.
• XML, EDI, and other data translation techniques
• Microsoft SQL 2000, 2005, Reporting Services; Microsoft Access 97, 2000, 2003
• Macromedia/Adobe ColdFusion
• Microsoft Office
• Structured Programming/Pseudocode and Algorithms
• Debugging/Troubleshooting techniques
• Code Documentation and Annotation
• Database Structure and Normalization
• Fluent with MS-Dos and all versions of Windows; comfortable with Unix and
Linux
• Seventy WPM typing speed
|
