Peningo Systems, Inc.

Resume of Candidate: PEN18

Rate: email us at info@peningo.com for rate information

Contact info:  For information on this candidate please email us at  info@peningo.com                    

Career Summary



Over sixteen years of experience encompassing all aspects of Data Warehousing and utilization of OLAP technology. Hyperion Consultant / Senior
Hyperion Developer with an expertise in Hyperion Planning, Hyperion Essbase, Hyperion Proof-of-Concept development, HyperionAnalyzer, Essbase Calc
Scripts, Wired Analyzer, Integration Server, Application Link, Enterprise, Pillar, Lawson Analytic Architect, Budget Architect, Scorecard, Business Objects,
Arcplan DynaSight, DataStage, VB, Access, Excel, VBA, Lotus Notes and Crystal Reports. Microsoft certified solution provider.


Professional Background



Nov 2003 - Present IBM /County of Montgomery, Montgomery County, PA

Hyperion Planning Consultant



·         Responsible for installation of all Hyperion products. Developed installation guides and procedures. Troubleshooter all Hyperion problems
successfully.

·         Worked as senior instructor and consultant for company deployment of Hyperion Planning. Worked as Lead with team to develop the Hyperion
Planning architecture and layout. Worked with team on installation of all Hyperion Planning components including installation of SQL database setup and
interface.

·         Utilized Hyperion Application link to load data from Lawson and Legacy systems. Responsible for setting up all dimensions. Performed detail
analysis of current accounting data that would be used to populate dimensions and members. Developed MS Access programs to assist with Data load.
Utilized Hyperion Essbase data load features to load data into Hyperion Planning. Developed all Load rules, and Calc scripts in Essbase.

·         Responsible for developing the security plan which was used to set up company security in Hyperion Planning, Essbase, Analyzer and Reports.

·         Responsible for teaching administrators how to produce reports, business rules, and forms.

·         Developed all Training material, created all training databases. Training material was used for over 500 users.

·         Responsible for teaching Administrators, Power users end users Hyperion Planning and Reports. Set up all Hyperion Planning Business rules.
Produced planning calc strips in Essbase.

·         Utilized Hyperion reports to produce reports for budgeting team.

·         Developed complex Hyperion Planning applications utilizing different Plan Types with different dimensionality.



July 2002 – 9/2003 Morgan Stanley – New York City, NY

Hyperion Planning Consultant



·         Worked as senior instructor and consultant for company deployment of Hyperion Planning. Worked as Lead with team to develop the Hyperion
Planning architecture and layout. Worked with team on installation of all Hyperion Planning components including installation of Oracle database setup
and interface.

·         Utilized Hyperion Application link to load data from SAP and Legacy systems. Responsible for setting up dimensions. Performed detail analysis of
SAP data, that would be used to populate dimensions and members,

·         Responsible for developing the security plan which was used to set up company security in Hyperion Planning, Essbase, Analyzer and Enterprise.

·         Responsible for teaching administrators how to produce reports, business rules, and forms.

·         Worked with Hyperion Team to develop training materials for over 1200 end users. Utilized Dreamweaver to develop training material.

·         Responsible for teaching end users Hyperion planning and reports. Set up all Hyperion Planning Business rules. Produced planning calc strips in
Essbase.

·         Utilized Hyperion reports to produce reports for budgeting team



February 2001 – April 2002 Health Care of America – Nashville, TN

Hyperion/Lawson Consultant



·         Developed Essbase cubes utilizing attributes new to Essbase 6.0. Developed load rules for Dynamic dimension builds and loading of data.
Developed very complex calc scripts.

·         Utilized Lawson Analytic Architect to build Essbase cubes. Utilized Hyperion Integration Server to extract data from DB2, Teradata, MS SQL server,
and Oracle databases to build Essbase Cubes with drill back capability. Developed views in Executive Viewer, Hyperion Analyzer and Lawson’s E-
Scorecard.

·         Performed Essbase, Pillar, Analyzer, Integration Server, Planning, Enterprise, Arcplan and crystal installs. Provided detail training in Essbase,
Analyzer, Arcplan Planning and Pillar.

·         Worked as senior consultant for financial budgeting staff producing reports in Hyperion Planning. Responsible for setting up all data loads form
external data into Planning. Responsible for security setup. Set up all Hyperion Planning Business rules. Produced planning calc strips in Essbase.
Utilized Hyperion reports, Arcplan, and Analyzer to produce reports for budgeting team.

·         Manage team of consultants to Extract data from Legacy systems, Lawson DB2 and link these databases to Multiple Essbase cubes via the Arcplan
DynaSight.

·         Utilized Hyperion Integration Server and Application Link as an ETL tool to move data from legacy systems into Essbase.

·         Senior level developer of partitioning. Utilize link partitioning to reduce cube size and cut processing time for loading and calculating of large
Essbase cubes.

·         Used Lawson’s Analytic Architect to build several Datamarts. Strong experience creating PR, HR, AC, FIN, GL, PO Datamarts. Strong experience with
setting up attributes, list views in Lawson. Worked with the latest version of Lawson products. Datamarts were built directly to Essbase and Flat files
which were used to load into Essbase.



May 2000 – January 2001 Hartford – Fort Washington, PA

Project Manager/Lead Essbase Consultant



·         Hands-on Project Manager Utilized RUP Methodology on projects developing Performance Measurements for company and department. All
performance measurements where then loaded into Essbase cubes & Pillar, that produced a company scorecard. Worked as team lead and Senior
Essbase and Pillar consultant.

·         Expertise with Hyperion Integration Server, SQL interface SQL drill thru, and Partitioning. Expert with Essbase Command language and Wired
Analyzer.

·         Developed and automated all ETL processes. Project encompasses over 19 source systems. Some of the Source systems were Oracle, MS-SQL,
Sybase, DB2, Siebel, Hyperion Pillar, CMS, and Lucent Phone, Mainframe ISAM files, Access, Excel, HTML and text files. Data from all source systems was
automatically feed daily into multiple Essbase cubes

·         Utilized Hyperion Pillar 4.6 to provide data feeds to Essbase Databases.

·         Worked with senior management and team on Project plan. Responsible for and co-ordinate all aspects of Project Scope, Business Requirements,
Assumptions, Vision Plan, Risk Analyses, Communication Plan, Design Specifications Use Cases, Testing Plans, Training Plan and Implementation Plan.
200 new users were trained to use Wired Analyzer and Spreadsheet Add-in to do custom reports on Essbase cubes.

·         Assigned all team members and department members their duties and assignments. Responsible for making sure all work is completed on time.
Ability to motivate and lead team members to reach organization goals and objectives. Very strong verbal and written communication skills. Above
average ability to manage multiple projects and priorities. Strong ability to research, recommend and deploy. Excellent ability to work effectively with End-
User.





August 1996 – April 2000 American Express – Fort Lauderdale, Florida

Project Manager/Lead Analyst



·         Utilized Essbase OLAP to produced Inventory, Finance and Sales reports of company data coming form Oracle, Lotus Notes, and Access. Worked
with Finance department developing Essbase business rules, what if scenarios and modeling. Worked as team lead and Senior Essbase consultant.

·         Power User utilizing Essbase Partitioning. Able to effectively utilize HIS, SQL interface and Flat file data loads. Power User utilizing SQL drill thru.
Expert with Essbase Command language. Utilized Wired for OLAP.

·         Developed multidimensional cubes, outlines, calc scripts, load rules and reports. Developed dynamic outlines using parent-child, level build and
generation build methods. Performed Essbase database tuning and administration. Designed Reports utilizing Excel and Business Objects. Taught
Essbase Excel SpreadSheet Add-in classes to end-users.

·         Responsible for updating Essbase outlines with inventory components for non-compliant internal and external systems. Developed enterprise
migration strategy, which included multiple strategies and approaches. Worked with team on baseline compliance standards.

·         Designed the Disaster Recovery database, which focuses on a recovery strategy for non-compliant Y2000 systems and major disaster recovery.
Utilized Datastage ETL tools and Oracle SQL to extract and provide data for Essbase Dataloads.

·         Worked with senior management on conceptual design, feasibility, and functional specifications. Responsible for and co-ordinate all aspects of
Disaster Recovery, planning, inventory, design and implementation.

·         Design testing procedures for unit testing, stress testing, and assurance testing for all Essbase reports. Installed Essbase 5.0 and future upgrades
on UNIX and NT operating systems.

·         Assigned all team members and department members their duties and assignments. Team lead using Custom Essbase commands using VBA.
Responsible for making sure all work is completed on time. Ability to motivate, lead and develop team members to reach organization goals and
objectives. Very strong verbal and written communication skills. Above average ability to manage multiple projects and priorities. Strong ability to
research, recommend and deploy. Excellent ability to work effectively with End-User.

·         Worked with Hyperion Pillar performing detailed budgeting analysis at various US sites.



December 1994 – August 1996 BurgerKing – Miami Senior Analysis/ Lead Programmer

·         Developed and supported databases designed in Lotus Notes, Access and Visual Basic: BK Yellow Pages, Restaurant Visitation, Volunteer
Information, and others. Utilized heavy formula and macros.

·         Converted Access tables to Lotus Notes Databases. Developed protocol and procedures for doing file transfers.

·         Responsible for managing team members. Duties included interviewing, hiring, evaluating, training and scheduling all members of team.

·         Worked with senior management on conceptual design, feasibility, and functional specifications. .



December 1991 – December 1994 Ryder – Miami Computer Analysis/ Programmer



·         Developed and supported databases designed in Lotus Notes, Access and Visual Basic: Customer Information, management discussion, inventory
tracking, and others. Utilized heavy formula and macros.

·         Converted Lotus 123 spreadsheets and macros into Lotus Notes Databases. Developed protocol and procedures for doing transfers.

·         Conducted pre training post training, end user training, system administration training, Help desk training, and installation training.

·         Worked with transmission and switching products.

·         Worked with management on conceptual design, feasibility, and functional specifications. .



May 1983 – December 1991 Department of Defense – Lakehurst

Computer Analysis/ Programmer



·         Developed and supported Mainframe databases using COBOL, CICS and IMS. Worked with JCL, VMS, ISAM and VSAM file formats.


Education



·         Rutgers University BS- Mechanical Engineering, Minor Computer Science May 1981

·         Rutgers University, MBA - Information System, Finance, Accounting, May 1983

·         Digital Equipment Corp., Novell CAN, May 1992

·         Digital Equipment Corp., Novell CNE, June 1992

·         Compu/1 Computer, Power Builder, June 1994

·         Compu/1 Computer, Power Builder data windows, July 1994

·         Lotus Notes App. 1 3.0, Sept 1995

·         Lotus Notes Admin. 1 3.0, Sept 1995

·         Lotus Notes App. 2 3.0, Dec. 1995

·         Lotus Notes App. 1 4.0, May 1996

·         Lotus Notes App. 2 4.0, May 1996

·         Visual Basic 4.0, Nov. 1996

·         Microsoft WOSA 1, Jan. 1997

·         Microsoft WOSA 2, Jan. 1997

·         Lotus Notes App 3, Nov 1997

·         Essbase Fundamentals, Nov 1997

·         Essbase Pillar. Nov 1997

·         Essbase Partitioning, Dec 1998

·         Lawson Budget Architect Oct 2000

·         Lawson Eanalytics Feb 2001

·         Lawson Analytic Architect May 2001

·         Hyperion Planning Aug 2001

·         Arcplan Insight Aug 2001

·         Arcplan Dynasight Nov 2001



General Skills

I have extensive knowledge of networks, computer hardware and software programs. I have expertise with the Microsoft software products and
operating systems, along with UNIX. Worked with Microsoft Project, Visio, PowerPoint, Freelance; Lotus Script, Basic, GW Basic, Qbasic, Dbase 2 to 5,
Rbase, Paradox, FoxPro, HTML, Internet, CCMail, Lotus Notes mail, Outlook and MSExchange


Professional Organizations



·         Gold Coast Visual Basic User Group

·         Independent Computer Consulting Association

·         Miami Unity Optimist President

·         UOTB Treasurer


References

Given upon request