Qualifications

• Verticals: 27 years logistics, transportation 3 years manufacturing 1 year retail
• 2 years Big Data including hadoop, hive, sqoop, pig, impala, hbase cloudera
• 25 years Database technology, architecture, design, management administration
• DBA for Oracle, Sybase, DB2, MySQL IMS
• Other Database exposure for Teradata, Informix, PostgreSQL, SQL Server, Greenplum
• Expert in SQL performance tuning
• Architecture: Enterprise, data solution including Troux
• Technical evaluations recommendations
• Licensing contract interpretation, negotiation vendor management
• 22 years Client/Server and distributed technology on mostly UX
• 10 years BI, Data Warehousing analytics
• 7 years MDM, Data Quality, Data Governance, archiving, ILM, search taxonomy
• Misc: System administration, package installation admin, AppRat CMDB
• Knowledge management using wikis
• Presenter Oracle Open World, Intl Sybase User Group, DAMA, TEDX FedEx
• Strengths: Strategy, Analytics, BI, Technology Management, Architecture, P T, Design, SQL, Databases, Data Architectue, Knowledge Management, Multi-tasking, Sharing, Growing Talent
• Differentiators: Making others better, Collaboration, Wikis, Innovation, Problem Solving

Professional Experience

Confidential

Sr. Big Data Architect

Worked on a short term tactical engagement to introduce Data Quality to a Big Data cloud environment using spock, groovy python. The end client was Scripps Networks Interactive. The assignment was satisfied remotely out of Memphis. Tools used include eclipse, gradle, GGTS, GIT, SourceTree, Bitbucket, Redshift, Hive, Oracle, MySQL, Talend, Confluence wiki and Amazon S3 EC2. Project focus includes customer, content, audience, subscriptions and other media interests.

Autozone, Enterprise Architect

Confidential

Worked on the development of Autozone's next generation data architecture. Tackling a unified view of the customer in hadoop using Cloudera including: sqoop, impala, CDH4, query tools and more. Utilizing Erwin, scripts, Oracle, PostgreSQL, DB2, Greenplum, hadoop, SQL, Excel, Confluence, Mediawiki and more. Engaged in ILM, MDM, data quality, data lineage, taxonomies, metadata, knowledge management, wikis and SOA. Creating and modifying data models physical db designs for CRM, Supply Chain, Security and commercial applications. Architecting a Reference Data enterprise solution to build future applications upon.

Consolidated Staffing, Consultant

Confidential

Engaged in miscellaneous consulting Varsity Brands that includes performance tuning, architecture, optimization and design. The environment includes DB2 UDB 9.7 on virtualized Windows Server 2008 w/ Java clients, Salesforce.com, Pervasive and data propagator.

Federal Express, Technical Fellow, Enterprise Architecture

Confidential

Authored prospective vendor management strategies targeting cost reductions. Participated in Big Data evaluations including HortonWorks, MapR, Cloudera Teradata Aster. Particular attention was paid to the value of Aster functions and our Teradata environment weighed against the generic applicability wider usage of the other stacks. Constructed a tentative next generation BI architecture including DW, DataMarts and Big Data. Delivered a presentation on Big Data to the Midsouth DAMA chapter in November 2012. Developed a solution architecture to support a multi-master database replication system for SenseAware across more than two data centers. Chaired the Data Architecture Council and participated on several other councils. Investigated Oracle database alternatives to lower costs. Worked on data privacy and risk mitigation strategies. Provided input to the current database strategy. Conducted research in nosql databases. Worked on complexity issues, data chain analysis and data in motion research designs. Worked on a DR/BIA team to come up w/ resiliency solutions. Developed a query to stack rank our app portfolio of 4000 applications to construct a runbook. Fulfilled the EA role for Customer Service and Technical Infrastructure for an application rationalization effort. Expanded and evangelized the use of wikis in EA. Utilized sharepoint and sourceforge for knowledge management. Participated in an exadata evaluation. Conducted an evaluation of EA tools. Completed a tactical POC with Troux to assess enterprise adoption. Authored SOW for professional services engagement with Troux. Developed and authored the business case to justify an EA tool purchase. Participated in an enterprise collaboration recommendation. Compiled a business case for the use of MySQL. Participated in the design of a Common Data Service for FedEx using SOA, XML, Oracle, MySQL and Oracle Golden Gate. Worked on a metadata assessment and rationalization effort incorporating an MDM reference scheme. Constructed a presentation on wikis entitled Wonderful Wikis for a FedEx Ted talk. Assembled and delivered a presentation on Oracle EBS challenges. Organized, justified, planned and attended a MySQL training offering for several DBAs. Provided input to various Data Governance efforts. Conducted analysis on our application portfolio and provided input to supplemental staffing to achieve our Data Center migration. Worked on virtualization contract language with several vendors to support some ETL and DI tools. Participated in a data archiving evaluation. Architected an enterprise ILM solution. Authored a BI strategy recommendation to use SQL Server for BI including SSAS, SSIS and SSRS. Conducted an evaluation of light-weight databases to replace Sybase ASA in customer premise automation devices. Selected Derby as a viable, multi-platform replacement projecting savings of 5MM/year.

Federal Express, Technical Fellow, Data Architecture

Confidential

Architected and implemented FedEx's first consolidated, multi-tenant database offering. Created the conceptual design for FedEx's current DBaaS offering using Oracle RAC on Linux. Attended Oracle World 2007 and made a presentation on our Oracle 10G RAC on Linux consolidated infrastructure implementation. Authored the FedEx Database Strategy. Supported various front-line applications. Lead database productization rollout with a matrixed staff of 17. Worked on SOX remediation efforts concerning account provisioning and technical solutions for Oracle on Windows and Sybase on Unix. Participated in database technology management with EADS, Operating Companies and DAAC. Helped with consistent environment initiatives. Worked on various HA-Oracle on Linux architectures. Participated in an Oracle database alternatives evaluation. Mentored and conducted troubleshooting across a staff of about 120 DBAs. Utilized wikis to share technical information and promote knowledge management. Worked on licensing issues and management for Oracle, SQL Server and DB2. Was the TFA for ETL products. Participated in Fusion project reviews, disaster recovery discussions, database design reviews and db2 testing. Assembled a comprehensive list of database tools categorizing them by function and assigning them to various database offerings. Created an XML briefing document. Evaluated and architected an enterprise infrastructure for data sharing.

Federal Express, DBA Advisor, Data Architecture

Confidential

Supported FedExNet 2 database development. Developed a database productization strategy. Participated in database technology management and the DAAC. Chaired database technical leader meeting. Worked on Linux low-cost database standard configurations for mass deployment. Consulted and advising on the usage of Oracle, Sybase, DB2 and related database technologies. Served as the TFA contact for ETL tools in 2002. Authored and published the DBMS selection portion of the DBA handbook. Published a document on data quality. Recipient of team peak award for EC/LHSD as part of the FedExNet 2 group. Authored the database and connection portion of the java technical framework under the TWA initiative. Participated in DB2 tool evaluations and recommendations.

Federal Express, Database Architect, DBA Air/Ground

Confidential

Designed and supported various client/server database applications in the logistics, EDI, supply chain and electronic commerce areas. Deployed FedExNet 2 database infrastructure that include Oracle 8/8i on HP-UX. The legacy data stores resided in Sybase, DB2, IMS. Oracle advanced replication was used in a multi-master scheme on HP-UX 11 64 bit . Recipient of the Five-star award in 2001. EADS domain architect representative for Data Architecture. Served on the Domain Architect Advisory Council DAAC . Developed, authored and published the OLTP database standards. Published a document on metadata usage. Provided database technology and leadership for DB2 infrastructure supporting Peoplesoft and distributed c/s applications. Architected the DB2 connect infrastructure. Attended Oracle World in October 2000 and published a trip report. Made various presentations on database technology. Researched, proposed and helped to implement SAMWrap as a solution for license metering of certain dba tools under a concurrent usage model.

Federal Express, DBA Architect,

Confidential

Designed, developed, supported the OLTP DSS database components of an OO, three tiered, client server application to manage the dispatching, tracking vehicle communication of the Fedex trucking fleet. Software components included Windows/NT clients with Smalltalk, application servers running tuxedo using DBTools.h , a database backend of Sybase ASE 11.5. Upgraded development production servers to ASE 11.5 within eight weeks. Used PowerDesigner Warehouse Architect to develop a star schema to support the DSS component. Ported application to 11.9.2 utilizing row level locking. Authored, co-authored, or advised management of the competitive situation and strategy in DataWarehousing, DataMining, Yield Improvement Knowledge Management areas. These documents were used by the CIO CTO during investor briefings. Mentored a group of 15-20 dbas interns. Participated in a MOLAP evaluation. Worked on an OLAP committee provided technical architectural consulting to the central data warehousing group. Delivered a presentation the '97 Sybase user conference on Data Types: Why Should I Care Published trip report presentation on the web. Providing technical support to 10-20 department members for telecommuting remote office functions. Attended the DCI Data Warehousing conference in Sept '96 and published a trip report. Set up configured PCs for ISDN with windows 95, Exceed, Open/Client, VirusScan, MS/Office, TCP/IP, IPX/SPX, Netscape Navigator, OpenUP. Provide LAN administration, support, direction for local team department as needed. Developed korn shell perl scripts to assist in administration reporting.. Supported various Sybase SQL Server applications on AIX, HP-UX, Solaris, Windows NT ranging from 10.0.2 to 11.5. Conducted performance and tuning exercises. Restructured SQL queries to improve performance. Attended a Powersoft customer consortium on the future direction of the PowerDesigner suite. Attended the 9/96 DataWarehousing conference to research DM/DW tools vendors. Published trip reports on the web. Wrote a perl script to parse database space reports published the content in HTML on the intranet. Engineered database design improvements via partitioning, clustering, table design. Participated in California technology visits. Created internal newsgroups on the Intranet for organized technology discussions. Wrote a perl script to condense sp sysmon observations facilitating performance baseline collection assessment with Excel. Wrote a stored procedure to kill blocked processes. Used Desktop/DBA SQL Server Manager to assist in administration tasks.

Federal Express, DBA Advisor,

Confidential

Lead a project to research and develop a prototype application that demonstrated distributed database usage. The architecture included construction of an n-tier architecture built with Powerbuilder, Sybase SQL Server and Replication Server. Provided technical support, consulting services, and troubleshooting for DBAs and developers in a variety of UNIX client/server RDBMS disciplines. Attended '96 ISUG published trip report on the web. Sat on an enterprise wide Technology Planning Council providing architectural guidance on presented or proposed applications and architectures. Participated in vendor contract negotiations for UNIX RDBMS software licensing. Directed and coordinated competitive benchmarking activities. Conducted a comparison of UNIX RDBMS offerings via research, experimentation, and education. Provided RDBMS positioning guidelines to management and technical support staffs as needed. Built an internal web site using an NCSA web server on Solaris 2.3 to better communicate the group's mission and to aid in the dissemination of technical material. Used a variety of web authoring tools to manage content. Provided primary UNIX system administration support on 6-9 servers covering AIX 3.2.5, 4.1.x, Solaris 2.3, HP-UX 10.0. Designed, developed, supported, and maintained several DSS applications in sales and marketing using Sybase SQL Server 4.9.x, 10.0.x, OMNI SQL Server 10.1, NetGateway 2.x, Mac clients, CICS/DB2 Sybase gateway, and DB2/MVS. Primary CASE modeling tool was ERWIN/ERX. DSS user query tools included Brio query, Forest and Trees, and GQL. DBA tasks included logical and physical database design, performance analysis, tuning, object creation, backups, data loading scripts, account administration, server configuration management, software installation, upgrades, light UNIX system administration tasks on AIX, and application design support. Tools used included: Sybase SA Companion, SQL Programmer, Desktop DBA, and SQL Monitor Server. Supported a document imaging system on Solaris 2.x with Sybase 4.9.2. Supported the design needs of a billing service center project with visual basic clients and HP-UX 9.0 servers. Participated in a cross-divisional team effort to recommend a course of action on selecting a client/server global financials package.

Federal Express, DBA, Revenue DBA Team

Confidential

Lead a staff of technical DBAs supporting a variety of mainframe database environments. IMS/VS and DB2/MVS were the primary DBMSs used in corporate applications. Supported some small transactional mixed mode applications with an IMS/DC front end with both IMS and DB2 databases on the back end. Issues relating to VLDB, query performance, system capacity, and table size growth heavily influenced the designs employed. As a technical design lead it was my job to build quality applications, solve problems, and grow new DBAs. Designed and constructed databases and tables to support an Application Message Routing system that allowed MVS hosts to exchange data with each other and with decentralized UNIX servers in a controlled, predictable, and reliable fashion. Built a database space monitoring system using DB2 tables and utilities to measure, track, notify, and report on IMS FastPath DEDB usage and trends. The system kept track of which areas had been scanned when and allowed for adaptive adjustments to monitoring frequencies based on the current observed state. Used the Insight performance monitor for DB2 to assess performance problems. Used the Bachman CASE tools to assist in logical and physical modeling. Implemented the Uniflow system with IMS/VS FastPath databases that resulted in a 34:1 reduction in transaction volume. Savings of 11-16M transactions per month were realized helping to defer hardware costs. Helped evaluate several compression packages. Infopak was selected. Projected 750k disk savings at the time. Assembled and conducted classes on OMEGAMON for IMS to monitor IMS FastPath buffer usage and performance. Conducted numerous database design reviews for domestic billing, international applications, customer systems, receivables, zap mail, cash applications, visible billing, automated meters, dimensional weight pricing, COD, yield improvement, and scanning applications. Revised, enhanced, and automated a system with SAS and JCL to run, parse, interpret, and store IMS database space usage data from SMU-II for critical databases. The system was later implemented on all full function databases on three different IMS systems.

Confidential

General Services Division

Various analyst DBA positions. Design and implemented a TSO/Focus application to track the performance and reliability of new reprographic products. Provided IMS database design support for an engineering product cost, unit manufacturing cost tracking, and spares management systems. Planned and conducted database reorganizations for a financial planning and reporting system. Provided DBA support for a multinational launch reporting system on a Honeywell DPS-8/CP-6 running IDS/II, a CODASYL network DBMS. Established a technical DBA group in the data center. Was directly involved in troubleshooting of production support for IMS/VS applications throughout the company. Formulated presentations and demos for supported products. Developed DBA productivity tools using ISPF dialog management facilities and CLISTs on TSO/MVS. Modified and maintained a physical IMS control block generation facility. Worked on modifications to the Xerox IMS/VS preprocessor, a precursor to IBM's DBRC. Obtained exposure to SMU II, AOI, DataBasic, DB Prototype, BTS, Data Packer, McAuto screen design aid, SAS, ADF, and Control/IMS. Also assumed responsibility for managing the TI/message mail product.

IBM, Programmer

Confidential

Designed, coded, and tested COBOL applications for a production control and manufacturing logistics system. Software included TSO/SPF, IMS/VS, CICS, and COPICS.