Mark Damm Email & Phone Number

Idaho Falls

Oak Brook, Il

Support of the McDonald's Saba LMS

Buffalo Grove, Il

Benefit Builder developmentOracle 11g PL/SQL development and support of a highly visible custom Java/PL/SQL interface from SFDC to RxClaim that loads prescription drug programs. Data is loaded from Excel and converted via XML/XSLT to views that load the plan data into the database and then to RxClaim. This is a new application that offers plenty of opportunity for improvements, SQL tuning, and logging. Also involved in testing of deployments and upgrades. Use TOAD for testing, deployments, and monitoring

Bloomington/Normal, Illinois Area

Oracle 11g SQL, Forms & Reports 10g, and PL/SQL development and support for company's Illinois Agricultural Association application.

Dover, Nh

Oracle 10g PL/SQL development, support, and designed technical solutions. Maintained code that interfaced with the nightly processing, created output files, and processed plan calculations for agent pay. Informatica 8.6.1. Supported and developed workflows and worklets for nightly processing and reporting for own instance of Informatica.Actuate. Developed pay reports viewed externally for payees. Supported unsupported instance of this product and how it interfaced with Oracle.Centive. Supported and extended UI application for maintaining payee and payee plans and reporting. Supported unsupported instance of this product.Perl scripts. Developed and supported scripts used by Informatica to interface to Oracle, create output files, and FTP.Off hours support of portfolio.

East Longmeadow, Ma

ERP Implementation – September 2008 through September 2009Technical implementation team member that extracted EDI, Open Invoice, Order History, Order Notes, BOM, and PO data via PL/SQL from Oracle Financials 11 for corporate wide ERP implementation. Did analysis, specifications, coding, and acceptance testing. Worked with people from different corporate locations. Did additional reporting BOM and INV. Provided SQL for custom bar-code printing application.Supported and updated MatrixOne software to interface with a different ERP system.Oracle development and support Developed reusable code that was added to our nightly data warehousing package to add reporting information for BOM for a new Discoverer report.Provide periodic 24x7 support to a PL/SQL stored procedure package that ran daily sales reporting report.Oracle 11.0 support and maintenance.Experience in OE, AR, Inventory, FA, and PO.UNIX shell scripts maintenance and development.

Camp Hill, Pa

Daily Shipping and Sales Report rewrite – November 2006 Rewrote Stored Procedures application used for the daily sales and shipment report. Originally written to access 10.7 OE schema, it was modified to read 11i OM schema. Legacy SQL was tuned. Also performed unit testing.Developed custom GL Accrual reporting system – January 2005Derived custom PL/SQL stored procedure and Oracle Forms application for monthly GL HPL Accrual reporting.Oracle 11i Implementation – March 2006 through October 2006 Technical implementation team member that installed and tested Oracle Financials 11i for company’s financial software. Implemented functional A/R set-up. Loaded legacy system data, tested, and created implementation documentation. Functional and technical experience in OM, AR, and GL modules. Experience with 10g database.Oracle 11i SupportSupported AR interfaces; lock box, invoicing, customers.Supported GL ADI application.UNIX shell scripts maintenance and development.Followed Sarbanes–Oxley standards

Birmingham, Alabama Area

Oracle development and supportSupported companies Oracle Financials 11i software. Developed custom financial reports.Functional and technical experience in OM and AR modules.

Franklin Park, Il

Oracle 11i Implementation – February 2002 through September 2002Technical implementation team member that installed and tested Oracle Financials 11i for company’s financial software. Integrated Vertex Quantum for Sales and Use Tax 2.0 PL/SQL software for use in the Oracle Financials AR and OE system. UNIX shell scripts maintenance and development.Oracle 10.7 NCA Implementation - February 2000 through August 2000Integrated Vertex Sales and Use Tax 1.3 PL/SQL software for use in the Oracle Financials AR system. Provided technical and functional installation. Tested final install to verify correct installation. Installed windows TDM software.

Greater Chicago Area

Programmer/analyst involved with legacy mainframe applications and client server data migration. Developed COBOL and CICS programs, using VSAM databases.

Software Engineering, Computer Software Engineering, 3.44

One class short of degree

Computer Career Progrm, Mainframe Programming

COBOL, CICS, VSAM

Bachelor Of Engineering (Be), Mechanical Engineering

I received a bachelors degree in Mechanical Engineering

Associate Of Science (A.S.), Engineering