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
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.
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.
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.
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.
BS, Management
Science. Case
Institute of Technology, CWRU.
Honors: cum laud, President's Scholarship, N.C.
PROFESSIONAL
TRAINING
2004 SCT |
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) |
SCT/Banner 5.x: General,
Alumni/Development, Self-Service.
Personal Computing (personal
productivity and application development): Microsoft Office Professional,
MS Access, Visual Basic for Applications, Crystal Reports, Infacta Group Mail,
InfoMaker (Sybase), Visio, R&R Report Writer, Mail Order Manager, and
Loftware.
Oracle
Corporation: PL/SQL8i; SQLPLUS8i; Developer 2000 Reports and
Forms; Designer 2000; Order Management 10.7; Inventory 11i.
UNIX: IBM,
HP; vi, shell scripting.
IBM OS/MVS MVS/XA MVS/ESA: COBOL,
COBOL II, JCL, VSAM, CICS, DB2/SQL.
Compaq/Digital (Open) VMS: COBOL
(incl. Report-Writer), Rdb, TDMS, CDD+, CMS, MMS, LSE, Pathworks for VMS,
TCP/IP, DECNET, DECNET/SNA, DCL, RMS, FMS, Datatrieve, EDIT/TPU.
IBM AS/400: CL,
RPG/400, DDS, DBU, PDM, and Shared Folders.