Employment

May, 2009 -  Present

Administration, Configuration and Training for System 9.3.2 Hyperion
Marlton, NJ

Main resource for Hill International HR data warehouse

Duties included :
Configuration of Hyperion System 9
Addition of users by provisioning
Train users on Hyperion System 9 workspace
Application of patches
Import jobs, apply security, create database connectivity, apply adaptive states

March, 2009 -  May, 2009
Informatica Architect

Creation of Logistic Mapping for International Logistics Corporation

Duties Included

Installation and configuration of Informatica 8.6.1
Creation of complex source qualifier SQL to join multiple tables
Creation of reusable transformations to reduce redundant coding

Creation of multiple mapplets and mappings to create workflows from source to target
Use of debugger to track invalid data/transformation results
Schedule workflows

January, 2008 -  March, 2009
Remediation Lead

Lead for Remediation of ADIM human resources, part of 800+ TB Teradata data warehouse.

Duties included :
Upgrade of Hyperion system 8.3.1 to Hyperion System 9.3.1
Expert in user of workspace in regards to Essbase, Analyzer, Interactive Reports and Production Reports

Use of SmartCuts to create transparent access to all of the technologies in the System 9 technology stack BQY calling SQR, etc and improve user experience.
Performance and tuning of queries, pre-aggregation, removal of table scans and inefficient code and increase database performance by up to 95%.

Use of the Hyperion Java System Development Kit to automate migrations, user activities, cleanup, notification, etc.
Create and execute proofs of concept to remove excess Topics in BQYs, Locked data models, locked SQL calls, inefficient SQR usage, pre-generation of SQL result sets to pre-load user dropdowns in dashboards and reduce cube load times through the use of pre-aggregation and parallel processing schemes.
Create Javascript UDFs to increase usability and decrease the hit to the Hyperion server.

December, 2006 -  January, 2008
Product Development Architect

Developed SQR Integrator. Data Warehouse product that uses visual commerce objects to create ETL scripts in Hyperion SQR and interfaces with Netezza.

Duties included :
Creation of high, medium and low level design using MicroSoft Visio
Created interfaces to Netezza server and use of NZSQL to create a Human Capital Management System
Creates Hyperion Production Reports ETL scripts that are scheduled in the normal Hyperion workspace or foundation ver 6.5 11
Creation of logical and physical model for both repository and application using ERWIN
Creation of application database and repository database in Netezza
Setup and maintenance of Java Swing development environment to interface Netezza NPS.
Development and testing of application in Java Swing
Development of model that integrates application into Netezza Server

May, 2001 -  December, 2006
ATM Solutions Hyperion/DW Architect

System Support for Brio business intelligence version 6 - 8 and data warehouse implementation for First Union/Wachovia merger ATM/Branch Global Data Warehouse

Duties included : Installation/Upgrade of software used in implementation.
Meeting with Executive end-users and translating business requirements into Business Intelligence design documents
Performance and Tuning of queries.
Developing EIS Executive Information System front ends for data warehouse.
Developing Profitability and Forecasting models for current and future development.
Interviewing business owners and completing system design documents and changing the data architect to conform to those requirements.

May, 2001 -  December, 2001
Data Warehouse Architect

Architect for Informatica data warehouse implementation for US Postal Service

Duties included : Installation/Upgrade of software used in implementation.
Staffing and technical interview duties.
Creation of best practices documents, along with functional and technical specification standards
Meeting with Executive end-users and translating business requirements into ETL Extract, Translate, Load and Business Intelligence design documents
Informatica Administrator duties Server Manager administration
Informatica Developer duties Designer

December, 2001 -  May, 2001
Data Warehouse Architect

Informatica Architect for Informatica/Oracle 8 data warehouse implementation for New Jersey State Decision Support System Recipient, Physician, Encounter Claims, Medicare and Medicaid modules, approx 2 Terabytes.

Duties included :
Installing and configuring Informatica PowerCenter and Powermart 5.1 and Striva EBCDIC file converter
Translating end-user business requirements into ETL design documents
Informatica Administrator duties Server Manager administration
Informatica DBA duties Repository Manager administration
Informatica Developer duties Designer
Developing 800+ map ETL system
Use Flat File and Mainframe inputs, develop expressions, filters, joiners, mapplets to arrive at the end-user business requirements for inserting data into data warehouse.

Training users and developers on Informatica development and administration tools.

April, 2000 -  December, 2001
Data Warehouse Architect

Informatica 4.7 or Sybase ASE/ASIQ data warehouse implementation for North Carolina Community College System Data Warehouse approx .5 Terabyte

Duties included :
Completing impact analysis of significant added functionality
Reconfiguring and rebuilding server environment added memory and disk space
Reconfigured database and disk allocations to reduce disk contention
Executed performance and tuning on existing mappings
Created functional and technical specifications in conjunction with subject matter experts for HR, Curriculum and Staff modules.
Data Modeling using PowerDesigner.
Created the new mappings, tested the new mappings, created new sessions and batches for the mappings
Performed cycle testing and user acceptance test duties, provided DBA support, production support and error handling for 58 colleges with apx. 12000 teachers and 700000 students.

June, 1999 -  January, 2000
ETL Developer

Solicitation of new business and management of developer assignments for business sent to Implementation Science for 250+ hours per week of fixed bid BRIO SQR interfaces, reports and ETL programs hosted by the ADP Corporation 55 hosted midsize companies
Troubleshooting, performance and tuning of 100000 pay production PeopleSoft system in an Oracle environment
Functional and Technical Specification, PeopleTools and BRIO SQR development of 401 k and executive deferred compensation plan interfaces and reports

April, 1999 -  June, 1999
PeopleSoft Developer

Charlotte, NC

Analysis of current materials management system
Analysis of PeopleSoft Projects Costing system in an Oracle environment
Analysis of interfaces of all systems feeding PeopleSoft Projects Costing system
Create interfaces and reports using Hyperion SQR and Intelligence
Performance and tuning of PeopleSoft batch code
Make recommendations for interface enhancement to implement a Projects Estimator system.

May, 1998 -  April, 1999
PeopleSoft Developer

Development of BRIO SQR reports, interfaces and data conversion ETL for PeopleSoft AP, AR and GL Implementation in an Oracle environment.
Development of BRIO SQR reports, interfaces and data conversion ETL for PeopleSoft HR/BEN/PAYROLL Implementation.
Performance and tuning of PeopleSoft batch code
Development of functional and technical specifications methodology for current project.
General support for the user community HR, FINANCE, PAYROLL.

January, 1998 -  May, 1998
PeopleSoft Developer

Development of BRIO SQR reports, interfaces and data conversion ETL for PeopleSoft AP, AR and GL Implementation in an Oracle environment.
Development of Functional and Technical specification methodology for the Insignia Corp.

Workflow specification and development using Business Process Designer and implementation of Workflow using message agent, database agent, advanced route controls, workflow PeopleCode and other workflow tools.
In process of creating PeopleSoft Toolset for impact analysis, BRIO SQR code auto generation, Automated Interface Tool, etc .I hold intellectual property to this toolset

September, 1997 -  December, 1997
Maxim Group PeopleSoft Developer

Write battery of BRIO SQR programs to convert ETL voice response benefits information for 15000 employees for a PeopleSoft 6.0 HRIS project in an Oracle environment. Insertion of historical and current core benefits and employee information for open enrollment.
Interface and reporting development in BRIO SQR, PeopleCode and Reportsmith to meet end-user business requirements.

June, 1997 -  September, 1997
PeopleSoft Developer

Senior Technical Consultant for ADP/CSS and PeopleSoft implementations for multiple clients in an Oracle environment. Duties include :
Reports, interfaces and data conversion ETL in BRIO SQR and Reportsmith to meet end-user business requirements.
Implemented Base Benefits with general deduction codes.
Development of functional and technical specifications methodology for current project.
General support for the user community HR, FINANCE, PAYROLL.

General training of end users in the use of the CSS system.
Development of test cycle methodology.
This project is running concurrently with the below product.

February, 1997 -  June, 1997
CSS Developer

Senior Technical Consultant for ADP/CSS implementation for PRIMUS Corp., A subsidiary of Ford Motor Credit. Duties include :
Provide mission critical support, DBA support and new development for installed PeopleSoft system.
Implemented Base Benefits with earnings and deduction codes.
Planning, pricing and documentation for conversion of system to ORACLE database engine.
Impact analysis and modification to non-ansi compliant embedded source.

Interface and reporting development in BRIO SQR and Reportsmith to meet end-user business requirements. Development of functional and technical specifications methodology for current project to support outsourcing of future development work for critical path tasks that will occur during PeopleSoft Financials implementation.
General support for the user community HR, FINANCE, PAYROLL

November, 1995 -  February, 1997
PeopleSoft Developer

Technical Consultant for ADP/CSS PeopleSoft 4.x implementation for LabCorp of America.
Duties include :
Mapping from INTEGRAL to CSS ETL. Involves working with both subject matter experts and functional consultants.
Implemented Base Benefits with earnings and deduction codes.
Conversion of data using BRIO SQR to validate and populate core and benefits tables. ORACLE SQLPLUS ver 7.2
HTML/JAVA development for local Internet Service Provider.

Technical Consultant for TESSERACT to PEOPLESOFT ver 5.11 conversion for the Allied Signal
Corp.
Duties include :
Impact Analysis of changes to delivered PEOPLESOFT system to meet end-user business requirements.
Modification of PEOPLESOFT system tables using ORACLE SQLPLUS ver 7.2
Modification of the 260000 lines of batch processing code Cobol for Ben Administrator and Payroll.

May, 1995 -  November, 1995
PeopleSoft Developer

Technical Analyst for MSA to PEOPLESOFT 4.x conversion. Duties include :
Modification to current PEOPLESOFT system using Peopletools and Peoplecode.
Writing SQR's to migrate information ETL from MSA system flatfile to a normalized database. ORACLE ver 7.1
Designing and writing programs and a database to automate the modifications to the Peoplesoft benefits and payroll batch processing software.
Complete dataflow diagram for the benefits processing software down to the primitives level and a complete system/screen/database interface flowchart.
Project management responsibilities.

December, 1994 -  May, 1995
BRIO SQR Developer

Lead programmer on development team engaged in writing a nationwide RF/Bar-coding warehouse management system for the Curtice Burns Corporation. Primary responsibilities included screen and database design, coding and testing throughout system. System used SYBASE system 10, C, JAM6 JPL 4GL and BRIO SQR and TRANSACT SQL.

September, 1994 -  December, 1994
SQR Developer

Contracted to Curtice Burns Corporate MIS. Primary responsibilities included LAN/WAN support for NOVELL 3.11 3.12 to the 8 subsidiaries and the development and migration of applications from the mainframe to the server.
Contracted to The Comstock Michigan Fruit Corporation. Primary responsibilities were development of company-wide parts tracking system in Foxpro V2.5. 9/1/94 - 12/1/94
This project ran concurrently with the previous project for Curtice Burns.

March, 1993 -  September, 1994
SQR Developer

Programmer on development team engaged in writing a nationwide RF/Bar-coding warehouse management system for the Curtice Burns Corporation. Primary responsibilities included screen and database design, coding and testing throughout system. System used SYBASE, C, JPL 4GL and TRANSACT SQL, BRIO SQR.
Programmer on development team involved in writing human resources program for the Curtice Burns Corporation. This was on a fixed price contract basis using FOXPRO V2.5.

January, 1994 -  January, 1994

This project ran concurrently with the above project for Curtice Burns.

April, 1983 -  March, 1993

Started as All lines agent for the Metropolitan Companies.
Became Independent under The Travelers and Travelers Equities and Securities Inc
Represented Travelers for medium sized companies September, Section 125 plans, 401 k, Group Life and Universal Life, Health and Dental insurance. Worked in the 50 - 5000 employee market.
Represented the New York State Business Council for employer benefits.
Troubleshooting for Travelers Regional office computer systems.
Went back to Rochester Institute of Technology for Information Systems part time.

1978 -  1982

Navy Frogman serving in Mediterranean, Near East and Continental US

1984 -  1986
National Association of Underwriter

1983 -  1988

President, VP, Master at Arms, et al.

1992 -  1994

Education