Resume of Harlan R. Cohen

PROFESSIONAL SUMMARY

Manager, Lead Analyst / Developer supporting business applications and databases on a variety of computer platforms. Enthusiastic learner and tenacious problem-solver.

QUALIFICATIONS

· Applications management in Development and Alumni Relations, Purchasing and Inventory. Support of applications in Marketing, Inventory, and Order Management.

· Reports and ad-hoc querying using MS-Access and Crystal Reports.

· Oracle client-server application development using SQL, PL/SQL, and Developer.

· Accustomed to developing applications directly from end-user requirements.

· Familiar with the issues and techniques of synchronizing data across multiple platforms.

· Training and supporting end-users and mentoring associates.

· Experience writing technical documents and topical user guides.

· COBOL and 4GL applications development on mainframe and midrange computers.

· Experience with Comshare Commander OLAP data transforms, loads, and unloads.

· PC Proficient: Microsoft Office Professional, Visio, Outlook.

· Light experience with Oracle Applications 10.7 through 11i, and with Oracle Designer.

WORK HISTORY

John Carroll University University Heights, OH

Advancement I.S. Specialist (Banner/SCT, Oracle 9i, MS Access 2002) 2002 – 2004

Banner 5.x Alumni/Development technical support for Development, Alumni Relations, and Public Affairs. Manager to the Director of Development Services. Implemented queries, extracts, imports, views, and database updates in support of operations. Produced documentation, written procedures, and other material.

Case Western Reserve University Cleveland, OH

Analyst/Programmer II (Infomaker, Oracle 8i, Advance/BSR) 2002

Campaign reporting and other reports for Development Services using InfoMaker for PowerBuilder.

Conley, Canitano and Associates, Inc. Mayfield Heights, Ohio

Senior Associate ‘Employee of the Month’ twice in two years 1994 – 2001

Industrial Fasteners Manufacturer 04/01 – 05/01 (Oracle Applications 11i)

Analyzed order fulfillment workflow and made general recommendations regarding Order Management setup. Produced training material on Inventory ABC Analysis, Cycle Counting, and Physical Inventory.

Health Insurance Provider 04/00 – 03/01 (IBM AIX, Oracle Developer 6).

Produced applications conforming to the HEDIS 2000/2001 industry specifications in PL/SQL 8i and Oracle Reports. Improved data cleansing procedures. Performed technical reviews. Incorporated ODBC and Excel in data validation strategy. Revised support methodology documents such as the Tasks Checklists and the Development Guide.

Hydraulics Manufacturer 11/99 – 03/00 (HP UX and Oracle, Honeywell/Bull DPS88). Resolved operational issues in Payroll and Accounting. Loaded International Price lists into the Oracle Order Management system. Converted batch payroll jobs to Unix shell scripts. Write PL/SQL and Oracle Reports to report various Sales Order activities.

Major Aluminum Manufacturer 03/98 – 05/99 (IBM OS/390, IBM S/36, Compaq OpenVMS and Oracle). Resolved operating issues for professional and clerical staff. Convert Sales Order EDI applications from OS/390 to OpenVMS. Coordinate activities of three analyst/programmers. Support existing Advance Shipping Notice inbound and outbound processing. Prototype Advance Shipping Notice System with Oracle Designer.

Major Retailer 04/94 - 12/97 (IBM MVS/ESA and Datacom/DB, AS/400 and DB2, MS Windows and miscellaneous).

· Designed and developed processes to offload Comshare Commander OLAP data warehouse for loading into Information Advantage (Informix).

· Project leader upgrading third-party’s networked mail order management software from DOS to Windows ’95 under tight deadline.

· Advance price ticketing using bar code printer in warehouse based on warehouse shipping or ad hoc selection (Loftware Windows and AS/400 extracts).

· Led a four person team in developing data extraction, transformation, and load (ETL) applications on the legacy side of Mainframe-AS/400 interfaces.

· Worked with Division Controller to define and develop Retail ‘Shrink’ Reports.

· Part of team performing COBOL ETL for Comshare Commander OLAP.

Conley, Canitano and Associates, Inc. Mayfield Heights, Ohio

Associate 1988 – 1994

Major Manufacturer 11/89 – 02/94 (DEC VAX/OpenVMS, DECNET, TCP/IP, Pathworks, and Rdb). Conduct system development and enhancements in Work in Process, Inventory Control, and Distribution. $100,000 cost savings in automating vendor billing and customer accounts payable. Act as system administrator. Developed two subsystems: Quality Assurance Tracking and Summary Packaging. System supporting twelve plants, the warehouse, marketing and accounting activities.

Various 11/88 – 11/89 (IBM MVS). Assignments at various clients that involved COBOL and JCL programming.

EDUCATION

Certified in Production and Inventory Management. APICS – The Educational Society for Resource Management.

MBA, Mgmt. Information Decision Systems. Weatherhead School of Management. Case Western Reserve University, Cleveland, Ohio.

BS, Management Science. Case Institute of Technology, CWRU. Honors: cum laud, President's Scholarship, N.C. Carlton Prize for Scholarship in Economics..

2004 SCT Summit (Conference)

Banner 5.x Intro. to Alumni/Development (SCT)

Introduction to Java (CWRU)

Data Mining Techniques (using SAS Enterprise Miner) (CSU)

Strategic Management of Resources (APICS)

Execution and Control of Operations (APICS)

Master Planning (APICS)

M/CRP (APICS)

Basics of Supply Chain Management (APICS)

Oracle Designer: Using Forms (Oracle)

Oracle Designer: First Class (Oracle)

MS Visual Basic 5 Learning Ed. (Microsoft CBT)

RPG/400 (CBT)

Introduction to AS/400 (CBT)

Advanced CL and Programming

Introduction to Powerbuilder

Oracle SQL+

Quality in the 21st Century

UNIX Shell Programming

UNIX Fundamentals

Introduction to DB2

CICS (CCAi)

Integrating Macintosh with VAX (Digital Equipment)

SEED – Intro. For New Users

Problem Solving & Decision Making

TOTAL Concepts and DBA

VAX Concepts (SDS)

IBM various (Systemation)

COMPUTER PLATFORMS AND SKILLS