Joseph B. Hill Email & Phone Number

Wayne, Pa, Us

Hanover, Md, Us

Business Analyst assigned to Marathon Petroleum Company providing analysis and support of Law and Business Integrity & Compliance applications. • Discovered application deviations from established standards, wrote waivers documenting the deviations and establishing plans for resolution. Presented findings to software owners and gained approvals for resolution.• Assembled risk assessment documentation and gained owner acceptance of the risks ensuring the confidentiality of critical data. • Coordinated single sign-on and multi-factor authentication implementation for cloud applications, enhancing security and user experience. • Planned and implemented application upgrades keeping systems current.• Analyzed and determined issues with SQL data extractions, documented findings, wrote functional specifications and test plans for resolution, executed integration tests, coordinated user acceptance testing, and implemented resolutions, resulting in elimination of transfer failures.• Wrote SQL queries and scripts to update a third-party Oracle database.

Beaverton, Oregon, Us

Performed as a Senior System Analyst at Cooper Tire Company providing technical analysis, system analysis, design, coding, testing, and support services.• Technical Lead on machine setup utility that communicated attributes and settings from Material, BOM, and Routing master tables to extrusion machines. Project involved setting up interfaces and authorities required for the interaction between the Oracle database and the Factory Talk interface with the PLCs.• Performed basic maintenance and incident resolution of shop floor Access and Excel databases, Visual Basic applications using both VB 6.0 and VB.net.• Designed and implemented archiving system for main production control database. System was dynamically designed to allow its usage on other critical databases. • Designed and implemented production history system to retrieved data from two Oracle manufacturing databases and deposited the data into a third Oracle archiving database.• Modified legacy Oracle warranty claim tracking interface to sunset obsolete interfaces and implement an interface from SAP. Modifications included modifying the claims database tables, remediating the historical data in the tables, and populating the fields from the SAP interface. Remediation and table population was performed using PL/SQL in an Oracle database environment.• Analyzed legacy UNISYS Warehouse Management System COBOL and WFL programs and designed changes necessary to keep the applications running for multiple distribution centers and plants while SAP was gradually rolled out to each location. Also wrote all of ALM test scripts necessary to ensure the accuracy of the program changes. • Resolved long-standing problems with warranty reserves calculations which resulted in management confidence in the reserve amount, leading to a significant reduction in the warranty reserves and increasing profits.• Documented legacy Shop Floor systems, reducing the research time of System and Business Analysts.

Hanover, Md, Us

Served as IBM iSeries Consultant assigned to CU Answers, a credit union software service provider. Designed, coded, tested, and implemented various interactive user interfaces and database updates using RPG ILE in a DB2 database environment.•Created interactive customer lookup function that allowed the immediate availability of current customer account information to Credit Union employees, increasing customer satisfaction.

Grand Rapids, Mi, Us

Worked as an IBM iSeries and AS400 Consultant performing analysis, design, coding and testing services for retail bookstore chain Family Christian Stores.•Interfaced legacy Purchase Order Acknowledgement EDIs into the JDA MMS system, eliminating double entry of the EDIs.•Produced interactive system that highlighted discrepancies between POs and EDIs, allowing users to quickly isolate and resolve discrepancies.

Senior Systems Analyst performing duties on Oracle and JDA ERP module implementation projects.• Systems Analyst involved in the entire SDLC process of a major project to implement the JDA Manugistics Distribution, Fulfillment, and Replenishment systems. The system involved interfacing Oracle’s Demand Forecasting projections system with the JDA systems. •Systems Analyst on several Oracle EBS implementation projects performing the following duties o Gathered and documented end user requirements. o Researched and documented current systems. o Determined and documented gaps as well as defining and documenting gap work around procedures. o Developed technical and functional interface designs. o Wrote and executed test cases; designed and coded defect resolutions. o Established implementation plans and tracked plans using MS Project.• Wrote ETLs for interfaces between JDA databases and existing databases (Oracle, AS/400, Data Warehouse) using Informatica Power Center along with PL/SQL programs that were executed by UNIX Korn Shell scripts scheduled in Autosys.• Coded interface programs in RPG Free with embedded SQL.• Documented the nightly batch process in Microsoft Visio.• Supported the application after the implementation.• Project Lead on Physical Inventory reporting automation project for the Financial Systems department. Responsible for the project communications; end user requirements gathering; technical and functional designs; database design; systems integration; end user training; ensuring that projects followed Circuit City’s lifecycle management processes and technical standards.

Performed analysis, design, coding and testing services for Circuit City Stores and Reynolds Metals Company.

Mahwah, Nj, Us

Performed analysis, design, coding and testing services for Advance Auto Parts and Shenandoah Life Insurance Company.

Bachelor Of Science - Bs, Business Administration–Accounting

Economics