T.J. Hall Email and Phone Number

Owner/Operator of Franklin Take Out Beverage, Ellwood CitySpecific Responsibilities included the following: * Manage a staff of 8 employee's * Maintain an inventory of $80,000 - $85,000 of products * Process weekly orders from 5 Vendors * Enter Purchase Orders to maintain correct Inventory * Perform physical inventory every other month to ensure correct inventory numbers.

Support the applications PAAM (Powerplant) and WPI.Specific Responsibilities included the following:* Using Oracle SQL to develop reports for the End User to help with their daily processing* Developed a process using PL/SQL to load data for the WPI application automatically instead of manually. * Set up reports within the PAAM application for Users to run on demand.* Investigate and resolve job failures.

Perform coding, testing and implementation of software using PL/SQL. Project Management.Specific Responsibilities included the following:* PL/SQL Developer utilizing Packages, Procedures, Functions.* Technical Project Manager for the PSI Metals Software installation at Granges. * Participate in User standard training of the PSI Metals Products.* Plan and facilitate specification sessions with key users and analysts.

Perform analysis, design, coding, testing and implementation of software using PL/SQL.Specific Responsibilities included the following:* Convert Visual Basic Procedures and Function to PL/SQL.* Maintain and install all PL/SQL Procedures and Functions on Schema’s on both IDI & Corporate Networks* Developed new UT Guardian application using PL/SQL and C# code.* Perform application DBA functions when required.

Perform analysis, design, coding, testing and implementation of software using PL/SQL, Informatica and Unix Scripting to support the Business Unit. Specific Responsibilities included the following:* The ICDM Teams Application DBA.* Monitor Monthly, Weekly and Daily processes that load the Oracle DataMart.* Maintain all Metadata for the ICDM DataMart.* Utilize Informatica, Shell Scripts and PL/SQL to provide information to the Business Unit.* Provide technical support to Business Unit when having issues* Research and close Help Desk tickets* Weekly on-call rotation

Perform analysis, design, coding, testing and implementation of software using SQL to support the Enterprise Risk Dept. Specific Responsibilities included the following:* Work with End Users in the Enterprise Risk Department to create reports and provide technical support.* Run month end reports utilizing data from SQL Server, Oracle and DB2. * Perform monthly ETL process to load the Department DataMart.* Extract and format data from multiple Relational DB’s to support customers needs.* Maintain and debug software applications using SQL, VBA and Stored Procedures.* Develop complex SQL queries to work with MS Access, SQL Server or Oracle to create reports for the Business Unit.

Worked in Global IT SecuritySpecific responsibilities include the following:* Information Security point person for Oracle Database Access. * Coordinate activity between the DBA’s and the Security Admin team.* Worked with client to develop a Security Roles & Responsibility document* Provide Technical support for the Database User Security Admin team.* Reviewed daily reports for DB Security Violations and take action when necessary.* Developed a report to ensure database access was not being granted outside of Security.* Perform database audits checking for database Security Baseline violations.* Maintained/installed Oracle User Security Administration Package

Performing analysis, design and programming on the Crew Activity Tracking & Scheduling System utilizing COBOL, DB2, IMS, SAS and various IBM Utilities (IEBGENER, SORT …)Specific responsibilities include the following:* Manage the Optics, Hotel & Sick Time Tracking subsystems and ensure work is completed.* Meet with end user to resolve current issues and develop new applications. * 24 hour support to the user community.* Quickly learn new applications and systems to support the client.* Y2K Conversion