Substantial and current hands-on development experience (4.5 years) with the Cognos Suite: PowerPlay, PowerPlay Enterprise Server, Transformer, Access Manager, Upfront, Impromptu, Impromptu Web Reports, Visualizer, Cognos Script, and MDL Language). Full systems life-cycle experienced. Also has hands-on development experience with Business Objects and Crystal Reports. Has a history of team and project management experience throughout his career both as a consultant and when full-time employed in corporate America. Knows Data Warehousing, DSS, EIS, and OLAP.

TECHNOLOGIES/TOOLS

WINDOWS NT, HTML, FRONTPAGE, BUSINESS OBJECTS, VISUAL BASIC, TESTBASIC, VISUAL TEST, SQA SUITE, SQABASIC, ORACLE, SQL PLUS, MS ACCESS, SQL SERVER, INFORMIX, SOURCESAFE, CRYSTAL REPORTS, ISQL, Q&E, LOTUS NOTES, ARTEMIS, MS PROJECT, UNIX, SABLIME, SYBASE, ORACLE 2000, JAVA, C, DB2, SPUFI, QMF, CICS, COBOL II, IMS DB/DC, PROTERM, ESCORT, OMEGAMON, PROEDIT, DB2 UTILITIES, PLATINUM, WORD, EXCEL, ORACLE CASE

APPLICATIONS & INDUSTRIES

Brokerage, Pharmaceutical, Banking, Human Resources, Telecommunication Wireless and Transmission Configurators, Transportation, Insurance, Marketing, International Billing, Customer Care Centers, Order Processing, Telephony, Financial, Sales Analysis, Manufacturing, Retail

PROFESSIONAL EXPERIENCE

PROJECT EXPERIENCE

4/01/99 - Present
Consultant - Business Intelligence Analyst (Pharmaceutical Company)

- Interfaced with the Finance, Marketing and Pricing to define reporting requirements and project plan for intranet applications for Customer Pricing System
- Developed management reports using Impromptu, Impromptu Web Reports using Oracle
- Designed and created catalogs

1/01/99 - 4/01
Consultant - Business Intelligence Analyst (Computer Manufacturer)

- Designed and developed powercubes and visualizations for PeopleSoft EPM, Workforce Insight, Global and US Census Using PeopleSoft Cube Manager
- Powerplay Enterprise Server 6.6, Access Manager, Upfront, Visualizer 1.5 and Impromptu Administration 6, Oracle 8.x
- Automated security model for HR powercubes using Transformer MDL language and Cognos Script
- Developed drill through, Powercube and Impromptu, and object (measures) modifications using MDL

9/99 - 12/00
Consultant - Business Intelligence Analyst (Insurance Company)

- Interfaced with the Portfolio Management and Global Asset Management Groups to define reporting requirements and project plan for intranet applications for Fixed Income And Equities
-Implemented IIS, Netscape Directory Server and IWR for PGAM
- Developed management reports using Impromptu, Impromptu Web Reports and Powerplay for the Portfolio Management and Global Asset Management Groups organizations for performance analysis using Infomix, Sybase and SQL Server
- IWR server administrator, Impromptu and Powerplay Administrator
- Designed and created catalogs, installed and configured IWR
-Created logical data model for business dimensions and measures-n Defined and designed summary tables from transactional database

2/99 - 9/9
Consultant - Lead Analyst (Pharmaceutical Company)

- Interfaced with National Account Managers and Contract Administrators to define reporting requirements and project plan
- Managed implementation using MS Project
- Developed management reports using Impromptu and Business Objects for the Contract Management organization to use in preparing rebates and analyzing claims from the CARS application, the database was Oracle 8.x
- Created and managed catalogs using Impromptu Administrator
- Designed and implemented executive reports for National Account Managers to forecast product sales

2/97 - 2/99
Vice President - Project Manager (Financial Institution)

- Interfaced with Global Securities Lending business line to define project requirements and dimension maps for OLAP system
- Created logical data model for business dimensions and measures
- Managed, designed and implemented executive reporting application on the client's Intranet using COGNOS Powerplay Web Server and IWR
- IWR, Impromptu, Powerplay and Powerplay Web Server Administrator
- Managed implementation using MS Project
- Evaluated data warehousing reporting tools
- Developed management reports using Impromptu, Powerplay and Crystal Reports
- Developed web pages using HTML and FRONTPAGE
- Reviewed and tested web application for quality and database for data integrity
- Interacted with business line and created business requirements documents for Trade Entry System for use by domestic traders and operations
- Y2K coordinator responsible for project planning, scheduling, test plans, test scripts, BCP/DRP

10/90 - 2/97 Consultant

Consultant - Automation Tools Administrator (Financial Institution)

- SQA Suite Administrator, created and maintained SQA Repositories, Customized reports and provided technical support and training
- Developed custom VB scripts to create issuers and securities for User Acceptance testing
- Created methodology and implemented custom VB programs to test securities in MARS and GlobeNet, also security information broadcasted through FSDX to AIMS
- User Team liaison for automation and technology
- Designed and developed Executive Information System for management reporting using Visual Basic, Access, Crystal Reports and Custom VBX's
- Standardized application naming conventions for workstation and host testing
- Developed tools in Access and Excel for test team


Consultant - Lead Quality Engineer (Communications Company)

- Lead Architect to automate the test environment for Wireless and Transmission configurators in a Client/Server environment (Visual Basic, Access, SourceSafe, Visual Test, TestBasic, VBAssist, Data Widgets, Grid/VBX, QuickPak, TabPro)
- Architect for the Visual Test environment, designed the test suites and configuration management environments using SourceSafe
- Programmed the test suites utilizing TestBasic and API for use by the System Engineers, Quality Engineers and Software Engineers
- Prepared presentations and abstracts for senior management that demonstrated effectiveness of Visual Test and associated cost benefits
- Participated with Software Engineers in developing improved system performance using Visual Basic and Access
- Created test plans, activities, test scenarios, assigned resources and implemented in an automated test environment
- Trained team members to use the Visual Test tool set and programming in TestBasic


Consultant - Quality Assurance Project Leader (Insurance Company)

- Developed Quality Assurance standards for all phases of the system development life cycle
in a Client/Server environment (CICS, DB2, VB, Access, SQL Server, PVCS, WINRUNNER)
- Supervised QA and Test team for Claims ReEngineering, Environmental, Early Warning and Auto Residual Systems in a Client/Server Environment
- Created project plan, activities and managed schedule, resources utilizing Artemis
- Evaluated business charter, business specifications, prototype and technical specifications
- Reviewed application software delivery from outsourced System Integrators


Consultant - Senior Programmer Analyst (Financial & Insurance Services Company)

- Created design and program specifications for claims and diary enhancements
- Evaluated business needs to reengineer diary processing
- Programmed changes and enhancements, updated PROC's and tested and debugged


Consultant - (Services Company)
Implementation Manager and Data Administrator

- Supervised staff of analysts and testers from the systems and user organizations to implement test plan, create test scenarios, tables and test data for the Incentive Administration Systems for both Ground and Air Delivery in a Client/Server Environment
- Managed project plan, activities, schedule and resources using MS Project
- Wrote the System and Acceptance Test Plans and the job descriptions for Test Organization
- Developed a System Test Tracking System that captured and tracked the test cases, test execution and problems encountered using VB, ACCESS and Crystal Reports
- Evaluated test tools and utilized MS Test and ProTerm for test script automation
- Maintained tables for CICS regions and DB2 sub systems and Visual Basic executables
- Created training environment for marketing and management staff
- Maintained integrity of the system and training environments using change control procedures


Consultant - Business Systems Analyst (Telecommunications Company)

- Performed business area analysis, process and logical data modeling for an International Billing System utilizing Oracle CASE Method in a UNIX Client/Server environment
- The system processes customer billing information in multiple currencies and languages
- Analyzed customer care center and network provisioning processing
- Met with management in marketing and financing
- Participated in the integration testing of a WATS/800 Family of Services billing system
- Interfaced with Information Management, Account Inquiry Centers and Billing Control Office
- Created quality control procedures to resolve outstanding maintenance requests
- Implemented process to emulate user input utilizing Escort connectivity software

8/89 - 9/90 (Consulting Services)

Manager Professional Services
- Wrote technical proposals in response to customer systems development needs
- Project Manager for project engagements in the New York Region
- Developed technical training and education programs
- Responsible for account development



10/79 - 8/89 (Consulting Services)

Regional Technical Director
- Project Executive for multiple project engagements at customer sites
- Managed Salary Administration programs and performed employee evaluations
- Interviewed and hired candidates for assignments
- Managed Profit Center for the Mid Atlantic Communications Region
- Responsible for recruiting and account development plans
- Analyzed client needs to develop and implement appropriate business solutions
- Created a corporate Quality Assurance Methodology for project engagements

4/78 - 10/79 (Software Company)

Programmer Analyst
- Designed, programmed and implemented A/R, A/P, G/L and sales systems
- Developed Real Time A/R system

8/77 - 4/78 (European Services Company)
Programmer
- Responsible for the maintenance of online applications for the Dime Savings Bank.
- Developed the first multitasking application for employer.

EDUCATION
Monmouth University B.S. in Computer Science
West Long Branch, NJ

Chubb Institute for Computer Technology Diploma

Oracle CASE Method
INTERSOLV Data Direct
COGNOS Powerplay and Impromptu
HTML Authoring
JAVA

Data Warehousing Institute Member

Keywords:

Showcase Essbase consulting
Hyperion Essbase consulting
Hyperion Pillar consulting
Cognos consulting
Business Objects consulting
Microstrategy consulting
Informatica consulting
Analysis Services consulting
Microsoft Analysis Services consulting
Hyperion planning consulting
Adaytum consulting
Hyperion enterprise consulting
Essbase consulting
showcase essbase training