|
Sr. Technical
/Decision Support Consultant - Martino Rivaplata
mrivaplata@yahoo.com
cell: 404-402-3372
420 E 55TH ST SUITE 4K
New York, NY 10022
Profile
Mr. Rivaplata is a
senior technical consultant who possesses strengths in the project/database
design; technical product / application development; and database/source
mapping and extraction. He is certified professional in Outlooksoft CPM,
Hyperion Essbase, Microsoft Office and Cognos senior developer. He has
mastered both the functional and technical issues utilizing numerous tools,
applications, and platforms. Martino's background and aptitudes lend
themselves to successful project implementations and /or initial client
/user needs analysis through project planning. By consistently working with
either a clients design team or end users throughout a relationship, Mr.
Rivaplata has helped transfer his product knowledge ensuring end-all
success. His future intent is to stay focused on existing technologies that
have been proven successful through his own experiences, and consistently
updating his skills to support new tools and methods in the very dynamic
world that is Business Intelligence (OLAP),ETL,Data Warehousing, CPM,BPM
and CRM. Recently has implemented several Hyperion Essbase, Microsoft
Analysis Services projects integrating them with .NET, ASP.NET and SOAP
technologies.
Career / Project Capsule
–JC Penney Company, Inc. – Plano- Texas
– December 2007 - March
2008.
SAP BPC Outlooksoft
5.2 developer. Developing
project tracking system for IT projects across JC Penney Company, Inc. IT
departments. The application
supports forecasts by project across different IT groups within JC Penney
organization. Designed
Microsoft SSIS packages to support the data load from FMS (system that
holds data for software and capital expenses), Oracle Project Accounting
(system that holds data for software in an expense basis), and Microsoft Project
Server which holds data for hours and rates for contractors, consultants
and associates. The ERP data
source for this application is JD Edwards/Peoplesoft, Khalix, Oracle
Project Accounting and FMS.
–Crosstex Energy Services – Dallas- Texas
– November 2007 -December 2007
Hyperion System 9
planning business rules development, web forms, calc scripts. Quality
assurance of existing application.
Designed staging database off of Peoplesoft to ensure incremental
updates to Hyperion system planning and Analytical services.
–Ray McDermott – Houston- Texas
– April 2007– October 2007
Designed and
migrated Hyperion System 9 application Link processes into Data integration
Management (DIM). Design
Hyperion Server infrastructure for Hyperion planning, HFM. Built CAPEX planning cubes, design
ETL routines from different data sources. Design, develop Workforce
planning application for human resources planning and impact analysis on
income statement applications. Technologies used Hyperion System 9.3.0.1
suite of products. Develop HAL process for project generation and GL
account mapping. Design a Microsoft ASP page to allow users to enter
projects description remotely. This ASP page will integrate with HAL
executable in order to move project and GL numbers to Hyperion System 9
planning and Analytical Administration Services. Designed Hyperion System 9
planning web forms, business rules, Maxl and Esscmd scripts. Developed
reports using Hyperion System Web Analysis, Financial Reporting and
Interactive Reporting.
–Constellation Energy – Baltimore- New
York – November 2006– February 2007
Redesigned CNE
(Constellation New Energy) Appset using Outlooksoft. User training
development, test cases to validate all input and report templates, ETL
procedures using Microsoft SQL Server 2000 DTS. Design a .NET visual basic
application to automate the development of the CEO monthly financial report.
Developed several MDX
calculations to get the weighted averages for metrics such as Weighted
Average Gross Margin, Weighted Average Term. Develop .NET application to
execute Hyperion Essbase API functions via webservices.
–The Blackstone Group – New York City- New
York – July 2005– October 2006
Develop Portfolio
Reporting System using Outlooksoft CPM. The portfolio reporting system increased
operational and strategic oversight of Private Equity’s Portfolio
Companies (“PC”).
This is accomplished by obtaining timely and appropriate financial
and key operating information directly from each PC and Banker through the
portfolio reporting system developed. This system produces presentation
quality reports for monthly financial reporting packages, annual LP
Advisory meetings, quarterly portfolio reviews, and other internal/external
meetings. Technologies used in this project, Microsoft .net 2003 to write .NET
webservices calls to Outlooksoft CPM, transact SQL for data loads and
Microsoft ASP .net. Develop data extraction procedures to move data from
Hyperion Essbase into Microsoft Analysis Services. Develop .NET application
project named “PCRS”
which keeps track of approval status for Entity, Scenario (such as budget,
actual, or forecast) and time period dimensions. It uses webservices
functions to determine the status of the data intersection as follows:
Submitted by Inputter, Submitted by Reviewer, Approved by Blackstone,
Rejected by Reviewer and Rejected by Blackstone. Develop Portfolio Company
Excel Add-in to allow Outlooksoft administrators to add and/or delete
portfolio companies as they are bought or sold. Other technologies used for
this project: Hyperion Essbase 7.0, Business Objects, JD Edwards. Developed
.NET applications to automate remote client tasks using Hyperion and
Microsoft Analysis services using WebServices.
–Mylan Laboratories – Morgantown- West
Virginia – March 2005– June 2005
Report and input
schedule remap and development to support existing Outlooksoft EAP
applications. Develop complex reports using visual basic object to support
Account Receivable credit analysis, estimated net sales reports, finance
corporate analysis implementing dual drill down from entity dimension into
account dimension. Develop monthly Accounting reporting package including
dynamic line and pie chart graphs, net sales trial balances, statement of earnings, Other Assets
and intangibles. Upgrade from
EAP into Everest 4.2 is under development.
–New World Pasta – Harrisburg- Pennsylvania
– Jan 2005 – March 2005.
Development Cognos
DataWarehouse using Cognos Eapps for JD Edwards. Developed cubes for sales
department for forecast, reporting and consolidations. Developed automated process to feed
DataWarehouse from SQL Server JDE transactional databases using Cognos
Decision Stream. OLAP cubes were designed using Cognos Transformer and
Impromptu query definition files, data from JDE Edwards is loaded into
Cognos datawarehouse via nightly SQL agent jobs, cubes are refreshed via
Cognos scheduler. Cubes support forecasting, daily sales, retail analysis,
Siebel deductions and customer profitability.
–Evian Water Coca Cola – Atlanta- Georgia – October 2004
– January 2005.
Development/Maintenance/
DataWarehouse and OLAP database for budget/forecast, reporting and
consolidations of Evian worldwide operations. Developed automated process to feed
DataWarehouse from IBM DB2/ JDE transactional databases. OLAP cubes were
designed using Hyperion Essbase 6.5; data from DataWarehouse is loaded into
Hyperion Essbase via nightly batch processes to refresh cubes. Develop
several .NET applications to execute Hyperion Essbase API functions via
webservices. Tasks such as running Essbase Calc Scripts from remote offices
were possible using .Net webservices.
-Cingular Wireless - Atlanta, Georgia
- September 2004 - December 2004
Senior technical
TM1/Applix developer. Implemented Applix/TM1 cubes by extracting data from Oracle
Financials. Developed input and report templates using TM1 Microsoft Excel
add-in. The implementation also required to deploy the excel templates over
the web, by using Applix web components. The project also required ETL
automation to load TM1 Applix cubes via nightly process from Oracle
Financials general ledger.
–Whitney National Bank – New
Orleans- Louisana – May 2004 – September 2004.
Develop OLAP
management reporting system for reporting, budget/forecast, eliminations
and allocations processes using Everest Outlooksoft. Developed custom reports and input
templates to automate the budget and forecast process. Design and implement
load process and transaction drill through process for all field offices in
the country. Developed portal
with business performance management key performance indicators to support
business decisions for headquarters and field offices. Develop several
custom MDX calculated dimension members to support related calculations
between balance sheet and income statement accounts.
–American Golf Corporation – Los Angeles - California
January 2004 – April 2004
Convert
existing mainframe reporting-budget/forecast information system into an
OLAP based reporting – budget/reporting system based on Microsoft
Analysis Services using Everest Outlooksoft as a front end. Developed
metadata and load process to support budget and forecast processes.
Developed American Golf Web Portal to allow CEO, CFO and field managers to
access actionable information. Developed daily data loads as well drill thru
to transactional databases. Developed several custom MDX dimension members.
–British Petroleum Amoco – Houston Texas
– June 2003- December 2003
Senior technical
Outlooksoft developer. Developed BP/Amoco business performance management
portal. Budget and forecast input templates were developed to support
business budget and rolling forecast procedures for headquarters and field
offices. Developed custom reports and input templates to support business analysts. Developed BP/Amoco deep water
business performance key performance indicators analysis tools to support
business decisions making for budget and forecast and reporting for CFO.
Developed load processes and data warehouse integration ETL procedures.
- Cingular Wireless - Atlanta, Georgia
- August 2001- May 2003
Senior technical
Outlooksoft developer. Developed Cingular Wireless budget, forecast and
reporting OLAP cubes. Developed headquarters budget input template and
field budget input templates as well as forecast input templates. Also,
several drill-down reports were built to drill into detail accounts for
expense and revenue accounts. Field budget input template deployed to over
100 field offices around the country, it will allow business analysts to
submit and retrieve budget data from centralized data warehouse and several
Essbase Cubes. Developed Cingular Wireless Managers Analytical Portal, for
Finance department, using a combination of ASP pages and static HTML
reports. Allocation templates were created to zero out expenses from
corporate headquarters and debit them to the field based on statistical
drivers. Developed a visual basic script using DSO objects to automate
writing domain login ids into the databases roles. Project also required
periodically data and metadata sync between Essbase cubes and Microsoft
Analysis services cubes to that purpose I built an Essbase VBA API template
to retrieve metadata changes from Essbase cubes to find changes in metadata
and data. Managed more than one hundred budget analysts across the country
to perform budgeting tasks using templates I designed.
-Wyndham International - Dallas, Texas
- May2001 - August 01, 2001
Senior technical
Outlooksoft developer. Developed over 100 budget input templates
incorporating the first ever use of sum of conditional `EvSnd' across
multiple cost centers and multiple expense and revenue drivers. The project
also required building several report templates in WebExcel. The
implementation also required to deploy the excel templates over the web, by
using Outlooksoft web components. Another goal of this project was to
deploy the budget process over the web so field managers can revise and
enter budget data using My Outlook.
-Darling International - Dallas, Texas
- April 2001 - May 2001
Senior technical
TM1/Applix-SQL Server 2000. Implemented Applix/TM1 cubes by extracting data
via SQL stored procedures from MS SQL Server 2000 databases The project
also required building several budget templates in Microsoft Excel and have
those templates connected to Applix/TM1 cubes. The implementation also
required to deploy the excel templates over the web, by using Applix web
components.
-SPL Worldgroup - San Francisco, California
- March 2001 - April 2001
Senior technical
Outlooksoft developer. Implemented Microsoft analysis services cubes by
extracting data via DTS (data transformation services) from Oracle data
marts (data marts were build using Informatica) into 2 cubes.
Budgeting/Planning cube and currency exchange cube. The project also
required building several budget templates in Everest WebExcel. The
implementation also required to deploy the excel templates over the web, by
using Outlooksoft web components. The goal of this project was to deploy
the budget process over the web so field managers can enter budget data
from their laptop offices.
-DocuCorp Software - Dallas, TX
- March 2001-April 2001
Senior technical
lead. Built a visual basic for application front-end for budget analysts.
The program allows analysts to insert or update rows in the budget database
tables (Sql server 2000) by entering data directly into a programmatically
customized Excel spreadsheet. Data sources for this project included
Essbase cubes data, SQL server transaction tables, and multiple text files
and CSV files.
-Brown & Root Services-Houston, TX
- April 2001-July 2001
Senior technical
lead. Implemented Comshare DecisionWeb using Microsoft SQL server 2000
transactional tables and Microsoft analysis services cubes. Developed
multiple views of operational data, accounting and key operating
indicators.
-Felcor Lodging Trust - Dallas, TX
- Jan 2001-March 2001
Senior technical
essbase/api visual basic developer. Built a visual basic program that
automates collection of data from hundreds of Microsoft Excel Spreadsheets
sent to headquarters from field offices. The program read, transform and
load the data into a summarized Essbase cube. In addition the program is to
run scheduled weekly directly from the server located in headquarters.
-Westlake Petrochemicals Companies - Houston, TX
- June 2000- Dec 2000
Senior technical
Hyperion Essbase lead for 4-man team. Implemented Hyperion 6.0 models for a
national known plastics manufacturing company. Exported data out of SAP via
Acta (ETL tools). Implemented numerous DataMarts from Financial to Sales
for this corporation using Hyperion Integration server. The data was
extracted from Oracle tables and loaded into Essbase via HIS. Designed a
corporate-wide information system using Arcplan - Dynasight 3.0 (a GUI
application that allows clients to interact via web and client server). The
system allows all the departments in the corporation to access its own data
via the corporate intranet. In addition, customer will be able to log in to
this system via Intershop Enfinity e-commerce application that is linked to
Arcplan via HTML and ASP pages. The project also required the development
of several Essbase API applications to automate the generation of balance
sheet, income statement and ad-hoc reports for the analysts in the
corporation.
-Felcor Hotels - Dallas, TX
- August 2000- Dec 2000
Senior technical
Hyperion Essbase developer for the developing of several Essbase 6.0
database emphasizing the using of attributes for the second largest hotel
holdings co. in the United States. This project required collecting data
from a variety of sources coming from different management companies. The
majority of data resides in SQL server 7.0/2000 databases that were
extracted via automated DTS packages and then loaded into Essbase.
Developed an enterprise information system using Hyperion Analyzer 5.0. The
system uses the corporate intranet for access and helped the asset
management team and top officers to access key operating data from their
laptops. Several Crystal
reports were also designed and developed in this phase.
-US-Home - Houston, TX
- August 2000- October 2000
Essbase API
developer for an excel front-end menu for the second largest homebuilder in
the United States.
The system allows analysts to produce balance sheets, income statement and
ad-hoc reports without retrieval sheets. The front-end saved significant
amount of time and helped analysts to concentrate in analysis rather than
in extracting and manipulating corporate data, designed and developed a
visual basic program that automates the collection, calculation and loading
of data into Essbase. The program read over 100 spreadsheets sent from the
divisional offices, performed calculations and consolidations and then via
a batch file loaded the data into Essbase.
-Cornell Companies - Houston, TX
- January 2000- June 2000
Lead Developer for
first documented Showcase implementation via Lawson Analytical Architect.
Built DataMarts from financial through productivity models. Requirements
included full lifecycle development from project plan, through database
design and implementation and training. Automation via Visual Basic and
other administration tools. Front-end delivery via Wired for OLAP.
-Legend Airlines - Dallas, TX
- December 1999- February 2000
Designed an
enterprise-wide operational statistical and financial planning application
that provides upscale travel services from love field to national
locations. The solution was built in a UNIX environment using Hyperion
Essbase OLAP Server as the foundation and included Hyperion Essbase Excel
Spreadsheet Add-In and Wired For OLAP for the UI, Visual Basic for
Applications for administrative tools.
-American Airlines - Dallas, TX
- June 1998- November 1999
Designed, built,
and implemented an enterprise wide budgeting application and a planning
application for the largest Dallas
airline corporation in order to provide timely, accurate, and consistent
financial reporting and forecasting in an interactive analytical
environment. Hyperion Essbase 5.02 was used to designed cubes. Included
budget package, monthly spending package, monthly headcount variance
package, labor group headcount matrix, SQL 7.0 database maintenance and
administration (stored procedures, ADO objects to retrieve the data into
Excel), Access VBA maintenance and development, Essbase databases administrator,
A-Cubed template designer, monthly forecast of passengers boarded, DB2
administration, SAP business forecasting modeling, Unix system Icaps,
Technical support for 45 airport analysts. The applications employed the
Hyperion Essbase Excel Spreadsheet Add-In along with Visual Basic for
Applications for the UI. 3 Essbase cubes were built to support
budget/forecast models, reporting cube and the function cube to handle
headcount based on volume and capacity for each airport.
-Arthur Andersen Technologies Solutions -
May1997- Aug 1997
·
Visual Basic developer
·
Beta site testing for major tax software general
availability release
-Southern Methodist University-
Aug1997- May1998
·
Finance Department teacher and research assistant.
·
Beta site testing for TM1/Arbor-Essbase olap
databases.
·
Accounting Department teacher assistant.
Education
· SOUTHERN METHODIST
UNIVERSITY, Dallas, TX
– May 1998
Major: Finance/Accounting/Information
Systems
Certifications:
Applix TM1 9.1 Certified Developer, Best
Practices Developer –
April 2007
Hyperion Planning System 9 4.1 -Hyperion Certified Professional
Design Lead - Feb 21, 2007
Hyperion Planning System 9 4.1 -Hyperion Certified Professional
- Feb 28, 2007
Hyperion
Financial Management System 9 3.51 – Hyperion HFM Certified
Professional
Hyperion Essbase Certified Proffesional -
Sep 09, 2000 – Essbase 5.02,
Essbase 6x , Essbase 7x
Outlooksoft CPM 4.2 SP3 - Microsoft
Analysis Services Professional – April 2004
Microsoft Excel Expert Certified
Professional – April 2004
Microsoft Certified Professional
Microsoft Certified Solutions Developer
– Candidate March 2007
Microsoft Certified Database Administrator
– Candidate March 2007
Arcplan Enterprise Certified Professional
– March 2007
Other Information
|
Information Technology Skills: (Premier
skills are bold.)
|
|
Description
|
Level
|
Experience
|
|
Outlooksoft EAP, Everest 3 + , 4 +
|
Advanced
|
5 Years
|
|
Excel (VBA)
|
Advanced
|
5 years
|
|
Cognos Version 7 Series 2 –
PPES,IWR,DS,Upfront
|
Advanced
|
2 Years
|
|
Arcplan - Dynasight 3.0 – arcplan Enterprise 5.0-
|
Advanced
|
3 Years
|
|
Cognos Eapps for JD Edwards – Sales,
Inventory Apps
|
Intermediate
|
1 Year
|
|
Finance/Accounting
|
Advanced
|
5 years
|
|
Capacity Planning
|
Advanced
|
2 years
|
|
Essbase Server 5.0 - 6.0 -6.1 -7.12
|
Advanced
|
5 Years
|
|
Hyperion Integration Server 1.0/2.0/6.1
|
Intermediate
|
2 years
|
|
Showcase/Essbase Server 3.0
|
Advanced
|
1 year
|
|
Hyperion Scorecard, HAL, HFM
|
Intermediate
|
1 Year
|
|
Oracle 8i, 9i, 10i
|
Advanced
|
5 years
|
|
.NET Visual Studio – WebServices -
SOAP
|
Intermediate
|
4 years
|
|
Applix TM1 Cubes – Applix 9.1
|
Intermediate
|
2 years
|
|
Visual BASIC 6.0
|
Intermediate
|
4 years
|
|
Lawson Analytic Architect
|
Intermediate
|
1 year
|
|
JD Edwards
|
Intermediate
|
1 year
|
|
Toad - Sybase Software
|
Intermediate
|
2 year
|
|
DB Artisan - Embarcadero Technologies
|
Intermediate
|
2 year
|
|
Crystal Reports 8.0
|
Intermediate
|
2 years
|
|
Cold Fusion
|
Intermediate
|
2years
|
|
Acta Rapid Marts
|
Intermediate
|
2 years
|
|
A3 Templates Essbase Vision/Fortune
|
Intermediate
|
1 year
|
|
HTML Programming
|
Intermediate
|
2 year
|
|
DreamWeaver
|
Intermediate
|
2year
|
|
Wired For OLAP- Hyperion Analyzer
|
Advanced
|
3 years
|
|
Windows Operating System
|
Intermediate
|
6 years
|
|
ActiveX
|
Intermediate
|
2 years
|
|
Microsoft SQL Server 97/00 / 2005
|
Advanced
|
8 Years
|
|
| |