Objective Operational data store or data warehouse business analyst, modeler, architect, designer, or developer.

Experience

Confidential in the City of New York
Confidential New York, NY
Senior Application System Developer 2007 - 2009
Independent Consultant - Data Architect 2005 - 2007

• Migrated the facilities cost allocation database from Access 2007 to Oracle 11g using SQL Developer 1.5 and ERwin Data Modeler r7.2.
• Analyzed, designed, developed, and implemented enhancements to consolidated operating budget business intelligence processing and reporting, using Sybase SQL and Transact-SQL.
• Developed partial dimensional data model standards, model, and data dictionary.
• Analyzed, designed, and documented the BusinessObjects Enterprise XI security interface for business intelligence reporting and reviewed Crystal Reports 2008.
• Analyzed, designed, developed, and implemented interfaces between the InfoEd research administration system and the Financial Accounting System, PeopleSoft and FAHRIS human resource systems, library faculty publication system, and facility space management system, using Oracle SQL and PL/SQL.
• Served as the data architect for the InfoEd implementation project.
• Designed the data architecture of the library faculty publication system.

Confidential
Southern New York office Mineola, NY
Project Manager - Systems 2003 - 2005

Lead the Nassau County Integrated Assessment System (IAS) Assessment Administration implementation project, including converting data for more than 400,000 parcels for five tax years to the Oracle-based system, and maintained the data dictionary for the client.
Conducted business requirements review and status meetings, developed specifications and run guide documentation, and supervised the development of more than 30 customized interfaces and reports for Nassau County.
Wrote Oracle SQL*Plus scripts and developed Discoverer workbooks.

Confidential
Confidential Stamford, CT
Application Development Manager 1997 - 2002
Acting Co-manager of Information Technology 1993
Senior Analyst 1991 - 1997
Independent Consultant 1991 and 2003

• Lead database design for the global commodity Trading and Traffic System from its inception in 1994 to 2002. Maintained the global data model in System Architect and generated Oracle DDL and DML scripts for the system, which handled all aspects of the Glencore group's core business and supported more than $20 billion of sales annually.
• Managed the global Trading and Traffic System project for the United States from 1997 to 2002. Reviewed and evaluated more than 4,000 requests for changes and enhancements to the system. Wrote SQL*Plus scripts to report and update data.

Confidential

• Built the application development, support, and quality assurance staff from three to eight, hiring and coaching each employee and consultant. Guided developers in designing data entry and retrieval windows and reports using PL/SQL and PowerBuilder.
• Designed the data architecture of the Cash Management System from its inception in 2001.
• Supervised the Y2K compliance project including migration from systems on HP 3000 to client server systems using Oracle on HP 9000.
• Managed all aspects of information technology including HP 3000 and 9000 mid-range servers, local area network, approximately 200 personal computers, and voice, E-mail, telex, and fax communication hardware, software, and services, for six months.
• Designed, developed, implemented, and maintained many mid-range and personal computer systems, including Aluminum Pricing, Finance, including cash and letter of credit management, Freight Rate, Future and Option, and Time Chartering systems.

Confidential
Confidential New York, NY
Project Leader for Personal Computers 1987 - 1991
Independent Consultant 1985 - 1986

• Designed, programmed, implemented, and maintained many personal computer systems, including Countertrade, General Ledger Reorganization, Option Accounting and Pricing, Rice Position, and Warrant Inventory systems. The Option systems handled American, European, hybrid foreign currency, and average price options.
• Supervised the personal computer application development staff.
• Evaluated and selected or approved all personal computer hardware and software.

Confidential
Owner 1985

• Designed a product profit reporting data warehouse and evaluated decision support systems and fourth generation languages for Confidential, New York, NY.

Confidential
Confidential New York, NY
Consultant through Senior Manager 1970 - 1985

• Conducted analyses of business systems, administrative procedures, control systems, alternative financing techniques, sales forecasting methodologies, cash flow models, financial feasibility of expansion projects, real-time hospital information systems, and inventory levels and policies for various clients.
• Served as a consultant to several government agencies and hospitals in the fields of data processing and reimbursement methodology.

Education

Master of Business Administration 1970
Concentration in Systems Analysis | Dean's Honor List

Bachelor of Arts 1969
Major in Economics