SUMMARY

• SQL Server and Oracle Developer with over 23 years of experience in information systems technology including 5 years of Oracle 11i Application Development, Allscripts PM & EHR, Customization, Administration, Testing and support of Oracle Applications (GL, AP, AR, PO, Cash management, Order Management/OE, HR, INV (WIP, BOM, OM, MRP, WSH), Oracle Alerts, System Administration modules) 11i, and Discoverer Reporting using Admin and User layers.
• Including systems analysis and design, data modeling, applications software design, development, implementation, tuning, maintenance, and support.
• Capable of working on a team with management and users to achieve desired results, with excellent written and interpersonal communication skills.

TECHNICAL SKILLS

Languages: C#, .NET, Visual Basic, SQL, PL/SQL, Unix Shell, JAVA, JSP, HTML, XML, CSS, PHP, RPGILE, RPG IV, RPG, CLILE, CL

Operating Systems: SQL 2012, SQL 2010, Unix, Windows, LAN, MS - DOS, IBM iSeries AS400

Database: SQL ( ), Oracle (8i, 9i, 10g), MySQL, DB2, OS400

Tools: Visual Studio, TOAD 10.6, JDeveloper 10.1.3, Demand Solutions, Discoverer, Discoverer Administrator, Oracle Forms, Oracle Reports, BI Publisher, Microsoft Office (Office - MS Excel, MS Word, PowerPoint, MS Outlook, Access, Visio, Live Meeting), WebSphere, Eclipse, Business Objects

Training: ConnectR, 11i Procure to Pay Fundamentals, 11i Order to Cash Fundamentals, 11i Implement and Use Cost Management, 11i Advanced Pricing Fundamentals, 11i Inventory Management Fundamentals, 11i Implement and Use Work in Process, 11i BOM and Engineering Fundamentals, 11i Implement iStore, six sigma yellow belt

PROFESSIONAL EXPERIENCE

Confidential - Lincoln, IL

IBM Administrator/Developer

Responsibilities:

• Designed and managed backups, restores, and security for IBM iSeries 570, and the tape rotation and retention policy was written. Programs were created and scheduled to alert staff via e-mail if tapes were not loaded at the required times.
• Responsible for support of generating interest and principle checks including user training, design, new development and modification of batch and online programs.
• Other responsibilities included analysis, design, development, testing and implementation of ad hoc reports and queries on Kronos time and attendance.
• Mentoring and developing employees

Environment: IBM iSeries 570, OS400 V5R3, Windows 2007, RPG, RPG36, CL, OCL, Query 400

Confidential - Mt Sterling, IL

Programmer / Analyst

Responsibilities:

• Project Lead to convert address to handle international addresses
• Support EDI system make enhancements as new suppliers and customer required.
• Designed web service using json for FedEx ground delieveries

Confidential - Quincy, IL

Application/Analyst

Responsibilities:

• Design and developing reports for SQL Server 2012 Allscripts PM and EHR applications using Crystal reports and SSRS.
• Code, test, and troubleshoot .NET programs for Allscripts PM and EHR systems.
• Customize application to remove waste
• Create read only systems for historical EHR from prior systems
• Setup and maintain Meaningful Use and Stimulus Sets.
• Support upgrades and hot fixes
• Mentoring and developing employees

Environment: SQL Server

Confidential - St. Louis, MO

Oracle Developer

Responsibilities:

• Design and developing interface processes to integrate between Oracle Applications and external systems, by creating custom shell scripts, SQL*Loader, tables, views, and packages.
• Interface ADP to Oracle custom tables using SQL*Loader, shell script and a package taking an excel file created from ADP and appended them to tables on Oracle db. We used discoverer to create the reports for managers and HR.
• Interface to a forecast software named Demand Solutions on a windows 2008 server. The month end reports are taken from Oracle and then put in a custom schema. Compare item forecast setups and categories in the two systems keeping them in sync. FTP is used to load the current month’s data into Demand solutions. Once the forecast manager completes adjustments, the weekly and monthly forecast is extracted and loaded into MRP FORECAST INTERFACE table. The MRP request set is then scheduled with the material manager.
• Interface from a third party ERP system and Oracle EBS 11i into a Shipping Manifest software system Clippership/Agile. Dos batch scripts, shell scripts, and Oracle package are used to create a comma separated file that gets imported daily into Clippership.
• Responsible for development, maintenance and support of custom Java applications on AIS server. This includes the schema, functions, packages, procedures created using TOAD and Java application using JDeveloper.
• Other responsibilities included: ad hoc custom report development; supporting and working with users, and submitting SR’s to Oracle support.
• Developed a trigger against the TOAD Team Coding module to write the dates when all sources get checked into a custom table. This table is used to check the modified date of the object and a report is created when the dates do not match.
• Created a package with procedures to update advanced price lists from different costs. The programs are schedule to update using Oracle 11i requests.
• Created an alert to e-mail the IT Developers when WIP job is in an invalid state. This state of the job requires human involvement to determine what steps are required to complete it.
• Created user documentation using Tutor Documentation

Environment: Unix, Windows 2007 and XP environment, Oracle 9i db, Oracle EBS 11i, Oracle BI Discoverer, Oracle Reports (6i), Oracle Forms (6i), Oracle Alerts, PL/SQL, SQL, SQL*Loader, SQL*Plus, TOAD, Unix Shell scripts, Oracle schema, tables, packages, functions, and triggers.

Confidential - Quincy, IL

Senior Programmer / Analyst

Responsibilities:

• World Ship Integration to Oracle 11i EBS to reduce shipping errors by eliminating manual processes. This allowed freight and handling charges to be processed real time, and allowed our customer to view status of shipment real time on our custom portal application and iStore.
• Managed three contractors for Oracle 11i implementation for reports requirements in all functional business areas using Oracle Discoverer, Oracle Reports (9i).
• Discoverer Administrator and designed the security, setup users, and released reports to users.
• Data conversion for the items for multiple organizations. Worked with the developer doing the BOM and routings to insure data completeness.
• Created BI Publisher templates for Purchase Orders, Invoices, Shipping Manifest, and Physical Inventory Tags.
• Worked with an Oracle Portal Consultant to convert a B2B portal application that I participated in developing using WebSphere and Eclipse.
• Developed the historical data transfer from IBM iSeries to Oracle 10g database to allow historical serial number inquiry into BOM and order text.
• Designed and developed a custom warranty system that processes 5,899 credits with reporting requirements that allowed the employer to reduce warranty by 3%.
• Developed a data warehouse and the extract and load, ETL, process to load the data warehouse. Business Objects on the IBM iSeries were then used to create business intelligence reports for management key performance indicators.
• World Ship Integration to iSeries to reduce shipping errors by eliminating manual processes. This allowed freight and handling charges to be processed real time. This allowed our customer to view status of shipment real time on a portal application.
• Helped to create a web enabled B2B portal for distributors to log in and self service their own request. These requests include order entry, e-mailing themselves documents and brochures, and shipment information using WebSphere and JAVA.
• Designed and developed a drop ship process that generated 24,388 order lines for $8,292,454.579 in sales per year.
• Developed a Kanban bar coded system that allowed the stockers on the shop floor to scan a card thus creating a PO release which was then sent to the supplier for replenishment. This led into the development of a custom auto replenishment system from defined inventory transactions outside the MRP processes.
• Developed the business intelligence system design and security so that maintenance of the database objects will require minimal maintenance for the developers.
• Researched and purchased RF Equipment including access points, wireless handhelds, and PC wedge devices.
• Integrated serial port devices to a metal tag scribing machine using custom print drivers on Oracle.

Environment: Unix, IBM AIX, Windows 2007 and XP environment, Oracle 10g db, Oracle EBS 11i, iStore, Oracle BI Discoverer, Oracle Reports (6i,9i), Oracle Forms (9i), PL/SQL, SQL, SQL*Loader, SQL*Plus, TOAD, Oracle schema, tables, packages, functions, triggers, IBM iSeries 570 with 4 partitions, J2EE Java development, JSP, JavaScript, HTML, CSS, UNIX scripting, Oracle, SQL, RPGILE, RPG IV, RPG, CLILE, CL, PL/SQL, Java, WebSphere, Eclipse