SUMMARY:

• A highly accomplished and experienced information technology professional with a background in system design and development.
• Extensive expertise in implementing Oracle ERPs and customizing Oracle for unique business requirements.
• Excels in the design of new systems, from requirement gathering through implementation. Additional strengths in requirements analysis, upgrades, technical support, testing and technical writing.

TECHNICAL SKILLS:

Operating Systems: UNIX

Languages: PLSQL, Oracle Pro*C

Databases: Oracle

Working Knowledge: Discoverer, BI Publisher, UNIX shell scripts, PVCS, TOAD, Oracle forms

Exposure to: Oracle Forms customizations, OBIEE, Agile development, jav

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Oracle Developer

Responsibilities:

• Created system documentation for both standard Oracle processes and customizations supporting more than a dozen sales channels, and led user training sessions for the revenue accounting (Oracle OTC) system for a commuter rail line.
• Worked with an outside consulting firm in creating requirements for data interfaces between the Oracle revenue accounting system and a new Microsoft Dynamics AX ERP system being implemented.
• Created Oracle forms customizations within Oracle Order Management to limit updates of sales orders.
• Changed a bank statement interface and reconciliation process to create miscellaneous cash receipts for small negative transactions for one sales channel.
• Changed an existing settlement file interface to accept negative amounts for credit card refunds for one sales channel.
• Created a new interface of conductor sales from UP Railways to the Oracle ERP system using unix shell scripts, sqlldr, custom PL/SQL and the Oracle Order Management open interface process.

Confidential, Chicago, Illinois

Oracle Developer

Responsibilities:

• Supported Oracle supply chain functionality. Worked principally with Purchasing (Procure to Pay) and Advanced Supply Chain applications.
• Collaborated with logistics and strategic sourcing groups, documenting user requirements and testing changes to Oracle customizations.
• Developed complex code using PL/SQL, including database triggers, indexes, packages, procedures, custom tables, Oracle supplied packages, dynamic sql. Experience with performance tuning using explain plan and hints.
• Worked with the IT groups that supported Oracle Financials and a custom manufacturing system.
• Made changes to a major customization, changing the cutoff time for plant scheduling from midnight to 6 a.m. Worked with consultants cloning this customization for a new product line.
• Served on team for a segregation of duties project that went live in January, 2015.
• Worked with business users and a consulting firm implementing Vertex tax software. Created test data in Purchasing and interfaced to AP, creating unit testing and system testing data.
• Supported an upgrade to Oracle release 12.1.3. Began work for R12.2 upgrade.
• Provided production support for 75 plants.

Confidential, McHenry, Illinois

Oracle Developer

Responsibilities:

• Functioned as Oracle developer, working with Oracle Financials, Marketing, Lead to Order and Customer Service applications.
• Worked closely with a large technical support group using the Oracle customer service application.
• Served on team that upgraded Oracle ERP from R11 to R12.1.3. Supported user testing, researched problems with Oracle support, resolving problems with previously stable functionality in receivables.
• Integrated acquisition companies to Oracle ERP, creating responsibilities, profile options, users, views and reports, and supporting user testing.
• Wrote unix shell scripts to perform functions, including loading data, notifying employees of changes to orders and service requests, and listing all purchased products for customer, including version levels and expiration dates.
• Acted as Discoverer administrator, working with users to resolve issues.

Confidential, Arlington Heights, Illinois

Software Developer, Networks Sector

Responsibilities:

• Served as Oracle developer, business systems analyst, and subject matter expert for Oracle Project Accounting and Accounts Receivables modules.
• Collaborated with large international team to implement an Oracle Order to Cash ERP that supported all supply chain and financial processes for the entire networks sector, replacing a large number of legacy systems. Wrote business and technical requirements for interfaces to support financial processes. Supported initial and subsequent organization implementations of system, eventually adding nearly 30 countries.
• Rewrote major component of Oracle ERP, creating interface between order entry and project accounting to support milestone invoicing and revenue recognition for long - development cycle products. Created revenue recognition and invoices sent to accounts receivables.
• Worked closely with business users from nearly 30 countries to develop requirements for financial statements (invoices, credit memos, reports) sent to customers, satisfying legal requirements and business practices of each country.
• Developed SOX (Sarbanes-Oxley) audit programs, using Dynamic SQL, database links, and LDAP to produce reports used by external auditors and to end-date inappropriate system access. Implemented program in five systems and two sectors, replacing manual stand-alone SQLs processes and end-date updates.
• Created sales revenue register report program that tracked revenue at sales order line level; this was later used as basis for development of financial data warehouse.
• Developed several Oracle forms to support custom business processes, including allocations and sales commissions.
• Supported two Oracle applications, project accounting, and accounts receivables, which interfaced with custom order entry system for Confidential Networks North America facility, including Oracle upgrades.