Jon Phillips Email & Phone Number

Minneapolis, Minnesota, US

St. Paul, Minnesota, US

US

Minneapolis, Minnesota, US

• Techno-functional PL/SQL consultant supporting the central bank data warehouse.
• Performed data warehousing design and implementation utilizing star schemas, bitmapped indexes, materialized views, and dimension tables.
• Held code review meetings.
• Tested other programmer’s code and fixed their errors.
• Replaced a mainframe processes for generating bank and treasury export flat file with PL/SQL.
• Transforming complex business rules into fast running and reliable database processes.

Bozeman, Montana, US

• A contractor during their r12 upgrade process and continued on into an FTE role.• Updated OA Framework extensions in Oracle JDeveloper to work with r12 base objects. • Updated 50 Financial Oracle Discover reports and supporting views/folders in Discover • Admin to reflect r12 Sub Ledger Accounting (SLA) and Noetix changes. • Provided 11i production.

Bozeman, Montana, US

I was initially a consultant for FICO through Kraut Companies until April 2012, when I began work as an FTE.• Oracle r12 Financials.• Tenrox implementation.• Project designs. • Code reviews. • General troubleshooting. • Full-cycle custom software development.• Oracle EBS r12 implementation, which we completed in May 2012.

Minneapolis, Minnesota, US

• Techno-functional Oracle EBS, as well as a computer hardware and software generalist.
• Developed custom PL/SQL solution to import agent’s time events from Cisco Agent Desktop (CAD) into Oracle Time & Labor (OTL).
• Also developed web PL/SQL for employees to punch in and out via web forms.
• Customized OTL timecard templates.
• Created Oracle Alerts for time reporting issues such as overlapping time.
• Developed packing work order and box contents reports using BI Publisher and IDAutomation barcoding.

Bloomington, MN, US

• Techno-functional Oracle EBS, as well as a computer hardware and software generalist.
• Worked with the Minneapolis, MN and Aguascalientes, Mexico offices of Donaldson.
• Designed, developed, and documented an interface from Oracle AR to a Mexican vendor that produces certified electronic invoices.
• Utilized custom Java code to read invoices and credit memos from Oracle AR tables, serialized the data to XML, and transmitted it to the vendor via their secure SOAP web service.
• Developed processes for Donaldson Mexico freight department users to load customs data into Oracle as shipments are received using Oracle Forms.
• Performance tuned extract queries to ensure minimal overhead and quick processing.

Minnetonka, Minnesota, US

Migrated UNIX Control-M shell scripts from IBM (AIX) to an Oracle Hosted environment (Linux).

Dulles, Virginia, US

• Techno-functional Oracle EBS, as well as a computer hardware and software generalist.
• Lead Oracle functional and development go-to person.
• Organized and managed tasks, including fiscal close.
• Supported Oracle Financials 10.7SC installation.
• Supported modules include AP, AR, GL, FA, and PA.
• Enhanced custom UNIX and Oracle data interfacing processes to reduce the number of IT support tickets and streamline manual processes.

Washington, D.C., US

• Developed requirements for conversion of mainframe accounting system to Oracle Applications 11i financials for the USPS’ International Accounting Branch.
• Developed detailed requirements for interfacing International mailing metrics into Oracle to determine pricing and meet revenue reporting requirements.
• Designed Oracle Forms to reflect Universal Postal Union (UPU) standard forms.
• Performed gap analysis between standard Oracle workflow and custom financial document routing requirements.

Minneapolis, MN, US

• Designed customized plugins for WordPress Multiuser (MU).
• Wrote custom PHP code.
• Converted existing plugs for Word Press to be multi user aware allowing for multiple instances with distinct configuration options.
• Wrote an MySQL stored procedure to automate the changing of database details when moving WordPress MU instances.

Norwalk, Connecticut, US

RoboHELP developer using HTML and WinHelp. Created online form using Python & MySQL. Used bootcamp to set up a wiki and centralized project management for all online help projects. Worked with clients from Glaxo Smith Kline to create an DHTML online help system. Other clients included Lockheed Martin, Price Waterhouse Coopers, Safeway, Ameren and many.

New York, NY, US

Co-author of Beginner's Guide to Flex 3. Published March 2008.

Eden Prairie, Minnesota, US

PHP, Drupal and Coppermine development for a Fabcon website. The PHP site includes a blog, chat and a wiki

Minneapolis And St. Paul, Minnesota, US

• Techno-functional Oracle EBS, as well as a computer hardware and software generalist.
• Lead developer for all projects.
• Trained end users on how to use Inventory Tracking application.
• Oracle application support and upgrades, bug fixes, and patches.
• New installs, on-call, Interface building and troubleshooting for the UofM Facilities Management Department’s Oracle Systems.
• Designed and developed PHP/Oracle based solutions for workstation and server asset tracking and performance monitoring.

Sebastopol, CA, US

Co-authored a Learning PHP & MySQL book for O’Reilly & Associates that hit bookstores June 2006. Writing a second edition now that will hit bookstores June 2007.

Hoboken, NJ, US

Wrote code for a Dreamweaver for Dummies book.

St. Louis, MO, US

• Techno-functional Oracle EBS, as well as a computer hardware and software generalist.
• Manager for the gap analysis and resolution strategies for migration from Oracle 10.7SC and Metrix to Oracle 11.5.8.
• Developed data migration extracts for Oracle 10.7SC for inventory and GL data (including the translation to the new chart of accounts).
• Supported the Oracle Financials 10.7SC and Metrix Open Uptime 3.3.1 CRM systems (100 users with $100M revenue per year).
• Developed upgrade and test plan for 9i databases upgrades.
• Gathered requirements from AR, AP, PO, JE, GL Inventory, Costing, MRP, BOM and Purchasing users to specify ongoing feature additions and business process changes to Oracle 10.7SC applications.

Munich, DE

Developed PL/SQL stored procedures supporting Hong Kong Electrics implementation of SCADA power network control and monitor software.

Bloomington, Minnesota, US

Oracle, telephony, UNIX, and a variety of other programming for former Spanlink Communications, purchased by ConvergeOne in 2014.