Oracle Developer / UNIX Developer / Technical Team Lead - PL/SQL, SQL*PLUS, SQLLOADER, RHEL 6, Oracle LINUX, Oracle XML DB
U.S Citizen ? Born in the United States of America.
Benny Tate II is a seasoned IT Developer with over 20 years in the Information Technology industry specifically working with oracle Applications, oracle Databases, SQL, oracle XML DB, EDI, and other oracle Development Tools. Some of Benny?s outstanding qualities are the ability to design, develop, and implement complex oracle projects. Benny has experience implementing oracle's EBS 12 Application Servers and 11gR2 Databases on Red Hat Enterprise Linux 6.3 (ie RHEL, oracle Linux). He also has experience upgrading to oracle EBS 12.1.3 environments. He is very much a team player and has a great ability to communicate difficult scenarios in a manner that makes it easier for all (IT and Non-IT persons) to understand their purpose and functionality. At one of his most recent assignment at the Salt River Project, in Phoenix, Benny works directly with the Management, oracle DBAs, and Business Analyst as a Senior Programmer/Analyst, developing software and conducting oracle Database performance tuning.
UNIX and its variants 20 years
(AIX, HP-UX, RHEL, oracle LINUX, CYGWIN)
oracle DB 11gR2, 10g, 9i, 8i, 7, and 6 20 years
oracle EBS 12, 11.5.10, 10.7 & 10.5 7+ years
e-Commerce Gateway (EDI), OM, AR, AP, & GL
oracle XML DB toolset 4 years
IBM/MRO MAXIMO 4.03, 4.1, 4.1.1, 5.1, 5.2, 6.2, 6.2.5, 7.5 10 years
Summary of Environments and tools:
Implement and Administrate SVN Subversion and Repositories (UNIX/LINUX servers)
Tortoise SVN Windows Client
UNIX Shell Scripting
oracle PL/SQL development
oracle XML DB development
oracle SQL Developer IDE
AllRound Automations PL/SQL Developer IDE
SQL Server 2008R2
AS2, FTP/SFTP/HTTP/HTTPS script development
Informix Development Tools 4GL/ISQL
JAM Procedural Language (JPL)
JAM Screen Builder
oracle GEMMS Manufacturing Version 3.2 and 4.1
Microsoft Access database querying
Scribe SQR procedural language
People Soft Maximo/oracle PL/SQL Interface stored procedure
Visual Basic development (connections with oracle database)
PVCS/SCCS version control
Microsoft Visual Source Safe (VSS)
IBM (previously owned by MRO) MAXIMO 4.0.3 ? 7.5
MAXIMO Enterprise Adapter (MEA/MIF) XML integrations
MAXIMO Application Designer
Eclipse Java IDE
Cimage Novasoft/DocuMaster integration with oracle database
PaSTA Work Assignment/Forecasting
oracle Virtual Box
Specific Areas of Expertise:
? Data Analysis/Migration/Cleanup - Ability to design and develop oracle stored procedure, scripts, and SQL to satisfy the most complex business or data analysis requirements.
? SQL Performance Tuning - Ability to comprehend, revise/tune the most complex SQL statements, table relationships (normalization), and indexes.
? oracle XML DB toolset ? oracle XML integration. Register XSD schemas with oracle database; Create oracle XML objects via xsd schema; Generate XML message documents from database; Absorb XML into database while validating against XML schema
Ben R. Tate & Associates, Inc. ? January 2006 to Present
Senior Software Developer
Electronic Data Interchange-Integrations (EDI-INT) ? Benny has developed and administers the FTP, SFTP, HTTP, HTTPS, and AS2 connections for transmitting EDI messages between business and the trading partners. Benny has developed the EDIINT Email notification of events,such as if networks are down between EDI trading partners.
oracle development for Hologic. Delivered Proof of Concept and followed up by developing final product to Hologic for absorbing of FedEx EDI XML documents into the oracle Apps R12 database (11gr2). This XML integration [absorbing and generating of XMLs] is developed using oracle?s XML DB toolset to register XSD schemas, absorb/validate XML documents against XSD schema; mapping normalized oracle views to the XML Type tables. As well as generating XML documents from existing Hologic oracle Apps tables to be sent back to FedEx. The XML DB tools are wrapped in PL/SQL packages that Benny has written and launched via shell scripts scheduled from the oracle Apps Concurrent Mgr.
oracle Applications Developer for Smiths Medical global projects (US, UK, Italy, and EU). Design and develop custom PL/SQL packages for EDI transactions such as Tradacom Invoices and Credit Memos, OB10 Invoice and Credit Memos, Italy FarmaFactoring Invoices and Credit Memos, X12 810 Invoices. Benny has also designed and developed custom interfaces between oracle Apps AR and OM Modules for US and UK for Order Management Backorders and AR Invoices. The Projects required Benny to perform Con-Current Manager setups in oracle Apps. Benny designed and developed Shell scripts to archive and SFTP the EDI transactions and manipulate data files.
Ben R. Tate & Associates, Inc -
Benny administers oracle 11g databases (11.2.03.0) on BRTA?s (the company) servers running oracle Enterprise Linux (RHEL 6). The servers and installed databases operate 24x7 and are down only when making bare metal backup or swapping hardware. BRTA use the servers for development, testing and when building Proofs of Concepts for our clients or potential clients. Benny administers Subversion (SVN) repositories for BRTA?s project documentation and source code. Tortoise clients connect via HTTPS to the SVN repositories. In addition to bare metal backups, file system folder structures are mirrored between servers for redundancy for immediate cutover in event of hardware failure. Client machine local SVN ?working? repositories are synched to cloud.
Salt River Project (SRP) - November 2001 to June 2013
Independent Contractor - oracle Technical Team Lead
SRP is a very large supplier of electrical energy and water for the State of Arizona and Southwestern USA. Benny was on contract with SRP since 2001 and into 2013. What began as a 3 month project has been extended a number of times to be over 11+ years, which gives an indication of the quality of his work and how well he works with other professionals in the office.
During his time as a contractor at SRP, Benny has had the opportunity to work with a variety of different business groups with his primary role of supporting the oracle database application, Maximo, which was originally an Asset Management product of MRO and has since has been bought by IBM, and also supporting all of its upgrades, customizations and interfaces.
Maximo is used by SRP for planning/scheduling/tracking Work assignments of maintenance, repairs, and equipment installations in all areas of SRP business... Hydroelectric Dams (Theodore Roosevelt Dam, for example); watersheds and canals; all equipment at the Power Generating Stations; as well as the electrical transformers, power lines and street lights, etc. in Arizona.
Maximo is also used for managing (tracking location and calibration) of SRP equipment/assets; Inventory Management; and Procurement Management.
Maximo Upgrade Releases
4.0.3 --> 4.1 --> 4.1.1 --> 5.1 --> 5.2 --> 6.2 --> 6.2.5 --> 7.5
Primarily responsible for the database upgrades and data migrations via MRO/IBM supplied scripts and Benny?s own custom PL/SQL procedures and SQL scripts. Running of the Maximo Integration and Validation upgrade tools and Maximo?s Database Reconfiguration tool.
Since version 6.2 of Maximo Benny has been using the Maximo MEA/MIF for importing data via XML Import. Importing data via the MEA/MIF integrations into the oracle database ensures that the Maximo Business Object rules, workflow or any custom user exits (java) are executed, guaranteeing that data integrity is maintained.
SRP uses their own proprietary change request system to track support tickets/incidents/change requests. As a member of the Maximo Technical Support team, Benny is responsible for responding and resolving these production incidents and change request.
This can be anything from a new integration with another system or the adding of custom Java user exits, tables/fields within the database, to adding of new application screens, tabs, and fields. Benny?s development is split between Java, PL/SQL and oracle database performance tuning.
Benny?s first responsibility at SRP was to port their Sybase database system over to oracle. This involved rewriting the triggers and stored procedures in PL/SQL ? and then building load scripts to import the data. He is also responsible for training SRP?s technical team of 10 people on how to understand and use oracle and its various development tools.
MAXIMO is a work order tracking system that allows SRP to keep track of work assignments out in the field for SRP?s customers and also within the power generation plants themselves. The application allows entering/maintaining of work orders, trouble calls, crew assignments, SRP equipment inventory (using location and equipment hierarchy). It interfaces with various forecasting tools to estimate schedule start and completion times for the work assignments. Interfaces between oracle and the mainframe systems exist for transmitting work order information as well as financial/payroll data. The interfaces rely on the labor, crew assignments and work orders data that are kept within the oracle database.
Each SRP Power Station usually has its own implementation of MAXIMO on a single oracle database. For each production environment Benny works with 3 additional databases for development, testing and, training. There are currently 11 production environments running MAXIMO on oracle databases. Benny played an instrumental role in the merging of 6 power stations into a multi org/site oracle database. These all share the same application but each retains it?s primarily organization/reporting/query structure by using the site-id elements in the tables. The environment for this very large database is 11g (11.2.03) and runs on HPUX servers.
SRP?s current project is to combine all of the Maximo systems into a single database. Similar to the merge mentioned in the above paragraph but this time it will be into a Maximo 7.5 environment. Benny is responsible for all Data Migration. The team is upgrading each Maximo systems to 7.5 independent of each other. Once these are each upgraded to 7.5 the individual systems will merge into an empty ?clean? Maximo 7.5 database using the Maximo MIF XML Import tools.
Avnet - February 2000 to October 2001
Independent Contractor - PL/SQL development and SQL performance tuning.
Avnet is one of the world?s largest value-added distributors of semi-conducts, connectors, passive and electronic components, and RF & Microwave devices. Benny was responsible for the PL/SQL procedures needed in a number of their projects.
One project included the backend interfaces that reads 20+ data feeds from the Mainframe system and loads the data into oracle for use by the front end Web Applications. These interfaces use SQL*LOADER to read from flat files into oracle staging tables. A PL/SQL stored procedure is then called which performs the deltas to move the data into the oracle web application tables. The SQL statements were efficiently tuned performance.
IMS Inventory Forecasting Reports - involved the writing of PL/SQL procedures that can be grouped into three categories:
? DATALOAD: Programs which load forecasting and inventory data into the oracle tables from the Manugistic and mainframe systems.
? REGISTER/LOGIN/AUTHORIZE: Front-end procedures called by the web application. Used for registering a user and logging them into the system (also includes authorization procedures).
? REPORTS: Front-end programs that query the forecasting data and return the results to the front-end web applications using Reference Cursors.
Another project implemented into production was Avnet?s new Electronic Marketing Web Site. Benny trained and led a team of 5 other developers in designing and developing all of the stored procedures which access the web content to be stored in the oracle tables that the team designed.
The project involves three modules:
? The first is the Content Management module which uses Java/HTML/property-file mix of front end screens which call the stored procedures. The stored procedure APIs maintain the content (add, delete, update, etc.).
? The second module is for Workflow and Content Migration into production. Stored procedures handle the workflow of the content (working, ready for launch, live) and also migrates the data from the Content Management database (staging) to the Content Display database (production).
? The third module is for Content Display. This module uses stored procedure APIs to query content that exists in the production database (Content Display database) and return that data to the Java front end for displaying to the user. This database design involves the use of many LOB data types for storing various content types.
Shamrock Foods - December 1999 to February 2000
Independent Contractor - PL/SQL developer and SQL performance tuning for Shamrock Foods.
Shamrock Foods Company specializes in the manufacturing and distribution of quality food and food-related products. Benny was responsible for maintaining all interfaces between the transportation routing system, the Order Entry system and the Warehouse Management System. He was also responsible for the end of day batch processes used to purge older data and building of audit reports.
The interfaces involved the passing and receiving of flat files using a queue monitor and ftp. It required being on call 24 hours 7 days a week. The interface programs involved a mixture of UNIX shell scripting, Pro*C and PL/SQL. The tables involved contained many millions of rows.
W. L. Gore & Associates - August 1999 to December 1999
Independent Contractor - PL/SQL developer and SQL performance tuning.
W. L. Gore is an international company with about 7500 employees around the world and manufactures medical products and high-performance fabrics. Benny was responsible for developing and implementing an exception handler package to be used by W. L. Gores' data load procedures. This error handling often involved changing 'batch' insert and update statements to use cursor functionality in order to trap errors to a specific record and still continue processing. The interfaces also used DBMS_SQL to disable the primary key of the target tables and then re-enabling the primary key after loading the table. Any constraint violations are logged when attempting to re-enable the constraints. Benny created and utilized oracles DBMS_SQL (dynamic SQL) procedures and PL/SQL tables (containers/arrays) for executing these DDL statements and for logging the exceptions to error log tables. This error handling is being implemented in W. L. Gore?s entire batch loading packages. It has proven to be very effective and has shortening the research time down to 15 minutes each day for what had taken hours for an operator to track down various data integrity problems.
Benny developed PL/SQL procedures, which are being called from Visual Basic 6 routines. These PL/SQL procedures query the necessary W. L. Gore oracle tables and places the record results into temporary tables to be queried by Crystal Reports.
General Electric / Honeywell - October 1998 to August 1999
Independent Contractor - oracle Financials Analyst & Developer
Benny was responsible for developing the Requirements Document for the implementation of oracle's Order Entry and Accounts Receivable modules in GE/Honeywell's largest division. He was also responsible for writing the Technical Design documents to handle many of the gaps between standard system functionality and Honeywell's requirements - such as handle UPC Codes, Sales History, and Shipping. Much of the research for the requirements gathering involved being able to read and understand mainframe COBOL code and convert its functionality to oracle relational database structures and requirements. Performed maintenance and enhancements to GE-Honeywell custom forms (screens). Performed customizations to oracles Web Customer 2.0.
Valspar Corporation - January 1998 to November 1998
Independent Contractor - Technical Team Leader
The Valspar Corporation is one of the largest global coatings manufacturers (such as paints and varnishes) in the world with more than 9,500 employees. Benny led a team of 6 to perform Y2K renovations bringing all source code into Y2K compliance. This involved creating a complete inventory of all custom programs totaling over 1600 files then analyzing each program. Several Interfaces are involved connecting multiple HP-UX machines. An Informix database is used for the manufacturing Order Entry front end. oracle's relational database is used for GEMMS Manufacturing and oracle Financial Applications (AR, AP, & GL). The source code was developed in PL/SQL, Pro*C, SQL scripts & SQL Loader files, JAM screen builder & JAM Procedural Language, Informix 4GL, oracle Reports & Forms 2.5, UNIX Shell Scripts.
Dallas Systems Corporation (DSC) - March 1993 to January 1998
Technical Team Leader
Benny was responsible for leading the company's most crucial application, the Yard Management System. This system tracks the truck and trailer equipment movement within a warehouse yard, tracks when equipment leaves the yard, controls any jockeying that takes place within the yard, and captures equipment performance and movement history. Benny designed its relational database tables, on-line transactions, handheld computer screens, and yard control analysis screens. He also designed and wrote its interfaces to other DSC systems - such as Warehouse Management System, Transportation Resource Planning, etc. Led a team of six Program Developers who coded, tested, and implemented the Yard Management System. The source code was primarily developed using Informix 4GL on an IBM Risc AIX system.
AAFES (Army & Air Force Exchange Services) - 1991 to February 1993
Independent Contractor ? System Analyst, Developer
From 1991 to 1993 Benny designed, developed and implemented the Daily Operations Subsystem for the Army and Air Force Exchange Services nationwide retail system. The programs were written in dbAccess 4GL using SQL and oracle RDBMS. The subsystem included extracting item movement and cash/sales data from remote PCs, processing it, and then sending data back to the RPOS PC. Developed on-line screens to adjust item movement, track critical item sales, and capture customer information. The sub-system also rolled-up weekly, monthly, and annual performance table data and purge old data from the retail tables.