Jim Davitt

More details at linkedin.com/in/j-m-davitt/

• Filled roles as developer, analyst, designer, architect, team lead, and project manager

• An extensive history of successfully designing, developing, and delivering user interface, middle ware, and back-end high performance, highly available, highly reliable systems, databases, and data warehouses

• Focused on delivering product, meeting time and budget constraints, and exceeding expectations

TECHNOLOGIES

C, C++ Pro*C, ESQL/C Oracle, Informix Unix, Linux bash, awk OLTP, OLAP Perl, mod_perl ecpg, ERWin Postgres, MySQL AIX, SunOS grep, sed, ERD, ETL SQL, PL/SQL Connector/C CouchDB, Apache Solaris, HP/UX lex, yacc, &c relational & dimensional SQR, PL/pgSQL sqlplus, sqlldr CGI, FastCGI AWS, Cloud data marts, NoSQL

EXPERIENCE

Verizon

September 2019 - January 2021 Las Colinas, Texas

Database and Software Developer.

Researched and optimized long-running queries, converted PL/SQL to plpgsql, wrote shell scripts, and maintained Perl programs as part of a modernization project moving a client-server product using Oracle to a cloud-based solution using PostgreSQL. Wrote Perl software which migrated database designs and data doing column data type conversions and data translations on the fly. Wrote a collection of Perl packages and Apache mod_perl modules that analyzed database schemas and generated relationship diagrams.

Hilton Worldwide January 2019 - July 2019 Memphis

Designer/Developer.

Designed and developed a suite of programs that compared schema and data among Informix, MySQL, and Postgres databases used to identify discrepancies between schema metadata and replicated table data. The software was written in C, ESQL/C, and Perl using Informix, Postgres, MySQL, Connector/C, ecpg, and Amazon's MySQL and Postgres client libraries and databases.

Hilton Worldwide September 2018 - December 2019 Memphis Designer/Developer.

Produced a collection of Perl programs to aggregate incoming data feeds consisting of millions of transactions per day. Achieved an 85% reduction in database transactions and 25% reduction in processing time. The optimization was needed before the business users could offer dynamic pricing to more customers.

Dollar General March 2018 – August 2018 Goodlettsville, Tennessee

Developer.

Closed a number of Warehouse Management System tickets including enhancements, bug fixes, and file transfers. Upgraded intranet Apache servers enabling HTTPS. Wrote tools which made copies of production databases and gave developers the ability to roll back to pre-test state. Tools used included C, Pro*C, PL/SQL, Perl, Oracle packages and utilities, sqlplus, and sqlldr in AIX and Linux environments.

Hilton Worldwide 2017 – 2018 Memphis

Designer/Developer.

Designed and developed tools used to evaluated data integrity, replication latency, and database performance on cloud-based Amazon Aurora databases. Designed and developed a translator and collection of C libraries which enabled programs written in Informix ESQL/C source code to run against Amazon's cloud-based Aurora DB with minimal modifications. Used Informix ESQL/C, C, Perl, MySQL, Maria DB, and Amazon's Aurora DB on Linux.

Hilton Worldwide 2015 – 2016 Memphis

Bug hunter.

Isolated a variety of memory-corrupting defects that caused sporadic system outages. C and ESQL/C source code was acquired, static analysis tools were evaluated, a framework for performing analyses and collecting results was developed, defects were uncovered, and bugs were eliminated. More than 1 million lines of code (14,000+ files in 2,000+ directories) were analyzed to uncover ~170 defects.

Epsilon 2010 – 2014 Blue Ash, Ohio

Database Designer/Developer.

Maintained and developed ETL processes handling demographic and earning data for multiple loyalty programs supporting between 3 and 12 million members. Designed, developed, and maintained PL/SQL procedures which processed clients' sales records and generated member rewards data (earn, bank, and burn loyalty points) and procedures which provided Java-layer web services with operations on objects stored in the database.

Designed and developed database analysis tools that generated plots of references among Oracle database objects. Designed and developed procedures which captured revisions to procedural packages, procedures, functions, and triggers (somewhat trivial) and revisions to models (non-trivial).

The environment was primarily Oracle (PL/SQL, sqlplus, packages and utilities, etc.) on AIX using ERWin, Allround Automation, Embarcadaro tools, and Quests's TOAD.

Hilton Hotels Corporation 2006 – 2010 Memphis

Developer.

Wrote mapping, geocoding and reverse geocoding, and routing interfaces to the MapQuest software for web applications. Optimized long-running Informix procedures reducing run time from 12 hours to 20 minutes. Designed and developed systems which collected data from external vendors, maintained them in databases, and made them available via XML messages exchanged through HTTP requests/responses. Developed and/or maintained the processes which gathered virtually all the static data (text, images, dynamic driving directions) appearing on the websites associated with Hilton's brands. Tools used include Perl, mod_perl, C, Apache, MySQL, Postgres, Informix, Oracle, Java, and various XML toolkits in Linux and Solaris environments.

Sedgwick Claims Management Services 2003 - 2006 Memphis

Database Analyst/Designer/Developer.

Designed, developed, and deployed data warehouse ETL processes, relational and dimensional data marts, intelligence products, and reports featuring packages, stored procedures, table functions, and pipelines. Designed and developed packages that streamlined claim "count and amount" processing. Optimized long-running processes and, in one case, reduced what had been a week-long report production process to less than two hours. The database used was Oracle 9i and 10g. Software tools included Perl, PL/SQL, Oracle utilities, Crystal, Brio's Intelligence Designer and Report Builder, Embarcadero's Rapid SQL and ER Studio, ERWin, and Quest's TOAD.

OTHER ENGAGEMENTS

Qualia Corporation, The Weather Channel, GE Capital, The Weather Channel, Chicago Board of Trade, Heller Financial, World Com, Information Inter*Clear, Manhattan National Life, Ameritech, Megapulse, Motorola, Abbott Laboratories, Precision Response Corporation, Motorola, Scientific Atlanta, American Airlines, IBM (ASD)

INDUSTRIES

Hoteliers, retailers, marketing, third- party administrators, software companies, broadcasters, finance companies, commodity exchange, insurance companies, manufacturers, call centers, telephone companies, and airlines

PROJECTS

Database design (relational, network, and dimensional), transaction processing,(TPF style using STIF messages and RESTful APIs using XML/JSON/YAML messages), data warehouse and data mart design, business intelligence, re-branding websites, producing websites, user interfaces, system upgrades, integrations, optimizations, system design, data migration, data validation, highly available

services, legacy-to-desktop conversions, database and data migrations

EDUCATION

University of Arkansas Fayetteville, Arkansas

Graduated cum laude with a BSBA.

Studies beyond the degree program included quantitative analysis, digital simulation, forecasting, numerical methods, and heuristic problem-solving techniques

Contact this candidate