Brian Benson Email & Phone Number

Acworth, Ga, Us

Greater Atlanta Area

Researched and led the project of developing a visual recognition application using IBM's Visual Recognition in Watson.Created tasks using Shell scripting to automate maintenance tasks such as creating differential backups, grooming, removing obsolete sessions, and restoring databases.Created at Disaster Recovery process using Bash scripts to have the development Netezza ready to become the temporary production machine. Created and modified stored procedures to load data from an ETL process from an operational database to a BI database.Designed/created/loaded and created utilities for several Netezza databases.Created a training document presented to clients on how to use Netezza and Aginity in their POCResearched Netezza documentation to answer questions posed by clients, such as issues with grooming, gathering statistics, explaining relationships between objects

Greater Atlanta Area

Greater Atlanta Area

Prepared all z/OS DB2 subsystems for upgrade from V9 to V10. Upgrades went perfect except for 1 object out of over 15,000. After the successful upgrade, moved to a User ID remediation project for all DB2 LUW database servers which captured access for each ID and then worked with each Project Manager to remediate each ID.

Atlanta

Perform zOS DB2 DBA Functions. Created a verification document for CATools upgrade. Fulfill DB Request tickets - object modification, security, problem determination. Offer opinions on system performance. Set up of Golden Gate Replication sourcing on the mainframe for an Oracle target.

Greater Atlanta Area

* Support PeopleSoft HR on z/OS DB2 – tasks include implementing DDL upgrades, problem determination, performance problem resolution. Researched heavily to solve a deadly embrace situation that was effecting Payroll processing.* Modified home-grown DB2 Reorg process to using an IBM stored procedure which used more statistics for Reorg determination. * Researched and tested zParm value changes to reduce costs for Image Copy procedures.* Implemented Explain table upgrade procedure in preparation for DB2 v10.

Greater Atlanta Area

* Contracted to move data from archived backups to database. Used CA Platinum Migrator to create a copy database of desired tables. Was originally hired for six weeks to only move data for one project. Finished in under three weeks. Was asked to stay as long as possible for other internal projects.* Set up replication to move data from one z/OS system to another on a continuous basis.* Analyzed SQL using CA Explain and Visual Explain.* Copied production-like database to testing using Hanier's BCV5 tool.* Performed common DBA tasks such as object modification, table rotation, authority management, plan/package maintenance, synonym/alias creation and problem determination.

Greater Atlanta Area

* Served as a DBA representative for data modeling sessions on a 60 table contractor tracking system. Worked closely with data modeler to determine the optimal design for the database. Created and modified logical model using Erwin software. Worked with owners of existing legacy databases in order to find a source for much of the data. Mapped and conformed data for use in the new system. Normalized data and created and distributed physical models. * Served as a DBA and/or technical lead on 3-6 projects at a time all with the goal of supporting installed applications or developing new applications on both z/OS and AIX applications. Supported both Operational and Information Warehouse databases. Tasks included database design, database creation and modification, ad-hoc report generation, problem determination, database maintenance, performance tuning, creation/installation/testing of new code and stored procedures. Also included application monitoring and on-call 24/7 support.* Documented procedures in a test environment to improve performance in the production environment.* Served as DBA supporting the DB2 Tools Technical Sales Support team. Tasks included creating detailed test plans for the team to use for demonstrations to customers. Also insured the tools were properly installed and had error-free interfaces to other products. Gave a technical presentation to approximately 50 DBAs about the z/OS DB2 Administration Tool.* Trained offshore DBA replacements on existing applications in support of IBM’s effort to reduce costs. Often assisted lesser experienced DBAs. Assisted co-workers on other projects with complex SQL queries. Documented procedures before turning over applications.* Analyzed long running queries. In one recent case, was able to decrease query run time from over 20 hours to under 30 minutes.* Created 0 Severity 1 problems.

Greater Atlanta Area

* Designed systems using a formal design methodology. Determined the objectives of the desired system, identified the requirements, created a template, established the programming requirements and advised users what would be best for their needs.* Developed and implemented an on-line system to coordinate information from five key areas to expedite decision making by executives using PL1 and DB2.

* Provided programming and analytical support for large-scale information systems. * Developed a tracking system which reduced paperwork submitted to the Nuclear Regulatory Commission by over 90%. * Assisted in consolidation of data from diverse computer systems to improve analysis by nuclear plant support staff.--- Acting Systems Administrator at Sequoia Nuclear Plant (on loan), 1983-1983* Designed and programmed applications, interacted with users of computer systems, performed cost justification and resolved problems. * Automated a manual preventive maintenance scheduling system which reduced the time devoted to that position by 50%.

* Converted educational programs written for other computer systems to run on UTC's Hewlett-Packard machines.* Assigned IDs for classes.* Assisted students with computer questions.

Mba, Business Administration And Management, General

Master's degree obtained in December of 1983.

Bs, Computer Science: Business Concentration

I performed In 3 plays at UTC including Androcles in "Androcles and the Lion" my freshman year. I worked in UTC's computer administration.