Senior level developer of Business Intelligence application systems, data warehouses and data marts using Oracle, Business Objects XI R3 and other technologies seeking a permanent position or long-term project in the New York Metropolitan area. 

Experience:

Confidential August 2011 to present

• Member of team developing Business Intelligence reporting systems for risk control
• Performed analysis and made design contributions both for Oracle databases and Business Objects universes.
• Conducted numerous small projects to enhance database performance for multiple applications.
• Analyzed query performance and modified Business Objects universes for better response times.
• Developed and/or modified Web Intelligence documents with multiple tables and charts, and hyperlinks between summary and detail reports.
• Carried out extensive work on user data entitlements and access control at both report and universe level.
• Technologies used included Oracle 11g,Oracle SQL Developer and Data Modeler, Business Objects XI R3 (Designer, Web Intelligence/InfoView), MS Excel

Confidential April, 2010 to August, 2011
The company provides metro Ethernet services throughout Long Island, Westchester County, Connecticut and parts of New Jersey.

• Converted a system of operational reports from Oracle Application Server to Business Objects. Improved the turnaround of most reports significantly, sometimes from twenty four hours to twenty minutes.
• Created Publications to replace batch report runs for automatic distribution to internal and external recipients.
• Set up the plan of access control using LDAP authentication and Business Objects security.
• Technologies used included Oracle 8, 9i, 10g, 11g; PL/SQL procedures, functions, packages, performance tuning; TOAD; TOAD Data Modeler; VISIO; Oracle Application Server 9

Confidential Business Intelligence Systems Consultant September, 1993 to April, 2010
Independent consulting practice focused on Business Intelligence and Decision Support.

• Created an Oracle data warehouse for Prada USA Corp to consolidate point-of-sale data from the company retail stores, later expanding this to include wholesale orders and shipments. Led a development team in enhancing the data warehouse to include a feature for on-line annotation of customer service transactions to facilitate communication between the sales and customer service departments, which helped to solve a multimillion dollar problem with vendor returns and excess inventory, and reduced customer service workload by twenty percent.
• Led a team of Business Objects developers at Schering Plough in putting all key corporate reports on line using Business Objects in a project called Compass.
• Managed a data warehouse project with Syncore International using Oracle 7 and Business Objects 4.0, creating a sales information data mart with row-level access security and a library of operational reports as well as a self-service reporting environment.
• Took on assignments in a variety of industries to build or enhance data warehouses and data marts, and to create reports and reporting capabilities with Business Objects and other technologies. My client list included Bell Atlantic, Lucent Technologies, Ciba Geigy, Pfizer International, Schering Plough Corp, ISI Mars, Philip Morris, Prada USA Corp, Merck, Inc.
• Developed reports and charts using MS Excel by downloading data from relational databases and creating pivot tables and other displays, enhanced with formulas (logical, character, mathematical and financial) and conditional formatting.
• Provided consulting services to customers of IRI Express and pcExpress multidimensional decision support language.
• Technologies used included Oracle and PL/SQL procedures, functions, packages, performance tuning, ETL; Express/pcExpress; Business Objects, TOAD, VISIO, MS Excel, Windows, Unix, AIX

Confidential, Developer/Administrator of SPIRIT Sales Management System, 1991 to 1993
Pharmaceutical manufacturing company that later merged with Ciba Geigy to become Novartis Pharmaceuticals.

• Rewrote and administered the SPIRIT sales management system the company had commissioned to help regional sales managers monitor performance of sales reps against syndicated prescription sales data from IMS.
• Restructured the Express data model to reduce the application footprint significantly and reduce the monthly data refresh from ten diskettes per user to one.
• Redesigned the interface and many reports and graphs to improve data presentation and emphasis.
• Provided group training to users during the rollout period, and telephone support thereafter.
• Technologies used: Express/pcExpress; MS Excel

Confidential, Associate Director Applications Consulting, 1988 – 1981
Market research company in consumer packaged goods industry that collects scanner data from grocery and convenience stores, packages and analyses the data and provides brand management consulting services.

• Provided pre- and post-sales consulting in the application of the Express products for decision support in the consumer packaged goods industries, complementing the information services provided by IRI.
• Carried out special assignments for clients with technical requirements that were out of the ordinary.
• Taught advanced training classes in Express and Express Data Server, the company’s proprietary client server application, as well as one-on-one coaching to internal staff and to customers.
• Technology used was IRI Express/pcExpress.

Confidential. Information Specialist and Manager of Financial DSS, 1982 – 1987
This tire and chemical manufacturer was later sold to Bridgestone of Japan.

• Administered a budget consolidation application using FCRS-EPS in an IBM TSO green-screen environment for the corporate Department of Budgets and Analysis
• Modified the application to conform with new FASB accounting rules
• Created a user interface to enable the budget analysts to run the application themselves rather than depend on information specialists.
• Created a Lotus 123 application to collect budget submissions from company departments, upload them to the mainframe, and enter them into the EPS application.
• Eliminated keypunching and transcription errors and reduced the budget cycle from thirteen months to four.
• Moved into the MIS department and converted the budget system from FCRS-EPS to MDS Express, while developing numerous small DSS projects using Lotus 123.
• Became Manager of Financial Decision Support Systems.
• Technologies used included FCRS-EPS, Lotus 123, MDS Express, IBM TSO and VM-CMS

Education
BBA in Accounting