|
MARTINO RIVAPLATA
SAP BPC-NW-MS / SAP BO-EPM-FIM-DS / BI-BW / HYPERION-ORACLE
Technical Functional Lead Planning & Consolidation
Implementation Consultant
mrivaplata@yahoo.com
mrivaplata@dwbis.com
Check LinkedIn Profile:
http://www.linkedin.com/in/martinorivaplata
cell: (646)-460-2506
Professional Profile::::
Mr. Rivaplata is a senior functional and technical consultant
who also grown as manager on multiple SAP BPC-BO EPM projects –is also a
developer 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, SAP BPC-EPM,
Hyperion Essbase, Microsoft Excel, Cognos Applix, Hyperion Planning System
9 and Hyperion Financial Management (HFM). 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),ERP,OLTP,OLAP,EPM,CPM, ETL, Data Warehousing such as
Teradata and Microstragy 7 and version 9. SAP EPM BO Version 10, BPM
dashboards, reports, dynamic graphs and real time reports from centralized
warehouses and SAP CRM. Recently has implemented several Hyperion Essbase, Outlooksoft,
Cognos Planning, Hyperion System 9, Microsoft Analysis Services, SAP BPC-EPM
7.0, and SAP BOBJ, SAP EPM projects integrating them with .NET, ASP.NET and
SOAP technologies. As well as, SAP BPC Legal consolidation processes like BPF,
currency translations, intercompany eliminations, Account Transformations,
Validations, Script Logic, Business Rules, Dim Mbr Calculation (MDX), Excel
based calculations. Also, develops SAP BO FIM apps to integrate source
applications such as SAP ECC and SAP EPM BO Suite of application such as
SAP BO BPC (Business planning and consolidation), SAP BO PCM(Profitability
and Cost Management), SAP BO Sales and operations planning, etc. SAP BO FIM
uses SAP BO DataServices as the ETL tool to move Source data to Target data
using mapping tables. Also developing DataServices jobs to load data from
SAP DataSources to Target.
Career / Projects::::
SAP
Americas BPC430/BPC440/BPC420 Trainer– November 2011 – December 2011
SAP BPC 430 BusinessObjects Planning & Consolidation: Planning
& Reporting. Train SAP consultants SAP BPC four main areas in BPC Planning
and Reporting
·
System architecture and integration.
·
Options for reporting, manual and automatic planning
·
Logic options planning and reporting
·
Business process flows for planning
SAP BPC 440 BusinessObjects Planning & Consolidation: Consolidation.
Train SAP consultants SAP BPC four main areas in BPC Consolidation
·
Setup the Appset and Applications; prepare the dimensions,
properties, logic and business rules.
·
Collect the transaction data, Create reports.
·
Perform consolidation activities such as balance carry
forward, journal entries, currency translation, validation, and
eliminations.
·
Report and analyze the data during and after consolidation
processes.
SAP BPC 420 BusinessObjects Planning & Consolidation:
Administration. Train SAP consultants SAP BPC main areas in BPC
Administration
·
Configure SAP BusinessObjects Planning & Consolidation 7.5
version for SAP Netweaver
·
Understand the system architecture and integration
·
Perform administration
·
Use Logic for planning and reporting
·
Execute data imports
·
Build business process flows for planning
Cpm
Consulting – Dallas, Texas – March 2011 – October 2011
Blueprinting technical approach to Update SAP BPC-EPM
Microsoft applications into SAP BPC-EPM NW 7.0 and SAP BPC-EPM NW 7.5.
Develop BRD (Business Requirements document) and TRD (Technical
requirements document). Scope project in phases, resources and timeline and
post production tasks and maintenance document. Also, developed SAP BO FIM
apps to integrate source applications such as SAP ECC and SAP EPM BO Suite
of application (XI 3.1-3.2) such as SAP BO BPC (Business planning and
consolidation), SAP BO PCM(Profitability and Cost Management), SAP BO Sales
and operations planning, etc. We used SAP BO FIM which uses SAP BO
DataServices as the ETL tool to move Source data to Target data using
mapping tables. Also developing SAP BO FIM jobs that loaded data from SAP
dataSources to Target. Developed Xcelsius dashboards using data from SAP BO
EPM applications via the SAP BPC connector via Excel Add-in Extended
Analytics Analyzer that allows connecting SAP BO EPM Applications and feed
data into Xcelsius cockpits and dashboards. Also developed SAP BO FIM jobs
that transferred data from SAP BO PCM TO SAP BO BPC and drill thru to the
transaction level detail. Developed SAP BO DataServices ETL applications to
perform the SAP BO FIM JOBS to move data from SAP BO PCM TO SAP BO BPC.
Developed SAP BO BPC consolidation reports to validate the
data transferred from SAP BO PCM TO SAP BO BPC and show the detail
transaction data via SAP BPC Drill-Through.
Integration of Hyperion Planning 9.3 for merchandising and
supply chain cost centers data with SAP BPC to finalize reporting for the
entire company.
Integration of HFM 9.3 data for cost center allocations and
eliminations to support both Managerial and General accepted accounting
standards (GAAP).
–Bloomberg
– New York City, New York. – April 2010 – February 2011
·
Managed and Developed SAP BPC-EPM 7.0 Microsoft built 7.0112
(ex Outlooksoft) in a dev server and then Developed/migrate in SAP BPC-EPM
7.0 NetWeaver built 7.5 (ex Outlooksoft) Budget Process, planning and
reporting.
1.
Opex Planning
This process requires the template to continuously
fetch data from SAP ECC and SAP BI. Required changes included:
·
Allow the input of multiple
activity types for a cost center prior to refreshing and sending data to
the database.
·
Developed advanced script
logic for moving data from cube to cube.
·
Minimize the number of times a
refresh is required. The current refresh process is as follows: choose
activity type (refresh), choose cost center (refresh), input hours by month
(save data), and start over if additional activity types are needed.
·
Correct the issue with
expanding the screen and refreshing an additional time so that information
entered will flow to the cover page.
·
Display both labor hours and
dollars on the labor worksheet in the capex template.
·
Migrated SAP SEM BPS templates
into SAP BPC-EPM input templates, call them Free Form SAP BPC-EPM input
templates
·
Developed ASP page to modify
MASTER SAP BPC-EPM data.
·
Developed VBA application in
SAP BPC-EPM input template to multiselect members in Current View and passed
them as comma delimited into the Member Set for EVDRE input schedules.
·
Developed DTS to load master
and transactional data into SAP BI/BPC-EPM, also helped designing Z(ABAP)
program to update master data from ECC into SAP BI/BPC-EPM
·
Develop Extracts from Hyperion
Financial Management to feed Bloomberg’s annual budget and monthly
forecasting management reports.
2.HCM
Planning
This process requires the template to continuously
fetch data from CapEx application data base. Required changes included:
·
Allow the input of multiple
activity types for a cost center prior to refreshing and sending data to
the database.
·
Minimize the number of times a
refresh is required. The current refresh process is as follows: choose
activity type (refresh), choose cost center (refresh), input hours by month
(save data), and start over if additional activity types are needed.
·
Correct the issue with
expanding the screen and refreshing an additional time so that information
entered will flow to the cover page.
·
Display both labor hours and
dollars on the labor worksheet in the capex template.
3.Capital
Planning
This process requires the template to continuously
fetch data from CapEx application data base. Required changes included:
·
Allow the input of multiple
activity types for a cost center prior to refreshing and sending data to
the database.
·
Minimize the number of times a
refresh is required. The current refresh process is as follows: choose
activity type (refresh), choose cost center (refresh), input hours by month
(save data), and start over if additional activity types are needed.
·
Correct the issue with
expanding the screen and refreshing an additional time so that information
entered will flow to the cover page.
·
Display both labor hours and
dollars on the labor worksheet in the capex template.
–Central
Vermont Public Services, Inc. – Rutland- Vermont – January 2010 – April
2010.
·
Managed and Developed SAP BPC-EPM 7.0 built 7.0113 SP1 Eh3 (ex
Outlooksoft) Capital Planning application, to address the following planning
areas:
1.
Internal Labor Planning
As currently configured the planning of labor to
each capital project is time consuming and requires multiple inputs and
refreshes to the template thus increasing processing time for each activity
type (job class code, consistent with actual charging) required for a
project. The template requires that labor hours are entered by activity
types and cost centers one by one with multiple looks to the database via
the expand function. Cost Center managers identify the total available
labor hours by activity type (i.e. job class) in the HCM input template.
This information is then passed to the CapEx application. This pot of
labor hours is then used in the CapEx template to develop the labor expense
for each capital project. This process requires the template to
continuously fetch data from CapEx application data base. Required changes
included:
·
Allow the input of multiple
activity types for a cost center prior to refreshing and sending data to
the database.
·
Minimize the number of times a
refresh is required. The current refresh process is as follows: choose
activity type (refresh), choose cost center (refresh), input hours by month
(save data), and start over if additional activity types are needed.
·
Correct the issue with expanding
the screen and refreshing an additional time so that information entered
will flow to the cover page.
·
Display both labor hours and
dollars on the labor worksheet in the capex template.
Overtime
Currently overtime is planned by total dollars. The
users would like this page set up like the Labor tab and budget by hours,
requiring that we apply an overtime average labor rate. To achieve this
all of the items above would need to be addressed on this page as well.
Additional required changes included:
·
Ability to calculate overtime
using man-hours and average labor rate for each project. We would need to
create an average overtime rates by activity group in a table for this page
to reference.
·
OT hours and dollars need to
be stored in the Capex database
·
Only OT dollars need be sent
to the Finance database, summarized by union and non-union
Capital Overheads
Currently, overheads are calculated in the Finance
application after all budgets inputs are in. Overheads must then be sent
back to the Capex allocation and each project must be opened and refreshed
to bring the applicable overheads in. Calculate fixed rate overheads to
enable users to have fully loaded project costs without an additional step
needed to update overheads via a pull from Finance. Required changes
included:
·
Updates the template so that
once all input are completed, overheads are calculated and the project
manager reviews fully loaded project costs (direct inputs plus overheads).
·
Overheads include payroll
overheads (taxes, non-productive and vehicles), AFUDC, and Capital
overheads. Different projects are subject to different overheads.
·
Calculated overheads by
project need to write back to the cap ex database.
·
Compare the total overheads
calculated in the Capex application to the total overheads calculated via
logic in the Finance application, and put difference to CWIP in Finance
application. See “Capex Overhead Reconciliation” for more detailed
requirements.
·
At the end of the
reconciliation, the fixed rate overheads calculated in the Capex template
will become the “official budgeted” overheads.
Roll Most Current Capital Project Estimates into new Budget Cycle
·
Ensure that for each new 5
year budget cycle, that years 2 through 5 of the most recent estimates are
available in the budget input templates so that project estimates do not
need to be re-entered.
·
Test that information can be
updated in the database without issues or duplication.
2.
II. Forecasting Capability
As currently configured, there is no forecasting
capability built within the HCM or Capex applications. Management has
requested the ability to create monthly forecasts on a periodic basis
(monthly, bi-monthly, or quarterly as deemed necessary at the time)
incorporating changes from Capex and Finance. Forecast capability would
require data flow between these two applications, changes to existing logic
and reports to create full financials for the current budget year.
The forecasting capability addressed the following
goals:
Ø
Monthly Officer-Sr. Leader
Meetings beginning April 2010 for accountability
Ø
Good EPS visibility and
accuracy throughout the year by quarter
Ø Know where / why variances to budget are
occurring; whether they are expected to continue, what the future quarterly
impact will be
Forecast capability allowed for:
Ø
Periodic: O&M components updated
in finance application. Allow flexibility to produce forecast on a
periodic basis (e.g. monthly, bi-monthly, quarterly, etc.)
Ø
Periodic: Capital forecast
updated in capex application. Forecast results need to be passed to
Finance application. Allow flexibility to produce forecast on a periodic
basis (e.g. monthly, bi-monthly, quarterly, etc.)
Ø
Periodic: Develop full
financials (i.e. income statement, balance sheet, cash flow)
Ø
Periodic: Test that capital
and O&M salaries do not exceed total salaries, calculate reconciling
adjustment as an O&M input in Finance Application
Required changes included:
·
Capital forecasts
o
Build an input template for
individual projects by function and their cost components. Should include
multiple columns to portray annual project budget, previous annual
forecast, amount spent to date and an area where forecast information can
be input by month for the remainder of the budget year. Assure drill
through functionality is available on actuals in this report/template.
o
Flexibility for template to
automatically “build out” with correct # of months of actual and forecast
columns. Forecast columns should automatically populate with the previous
forecast data (or original budget data if no forecast has yet been
submitted). Total the 12 prepopulated columns for a “Default Forecast”
total. Actual data should not be able to be changed.
o
A project manager will need
the ability to enter unplanned projects for authorization and on-going
estimate to actual comparison.
o
Project manager should have
option to change the data in the forecast columns, choose the “Default
Forecast”, or choose the previous annual forecast/budget. If the previous
annual forecast/budget is chosen, the template should spread the difference
between the choice and the “Default Forecast” proportionately over the
forecast months.
o
Capital overheads need to be
calculated on a monthly basis.
o
Capability to move updated
capital forecast information, including overheads, into finance application
o
See “Example Capital Forecast
Template”
·
Finance forecasts - 3 forecast
input templates developed:
o
Flexibility for template to
automatically “build out” with correct # of months of actual and forecast
columns. Forecast columns should automatically populate with the previous
forecast data (or original budget data if no forecast has yet been
submitted). Total the 12 prepopulated columns for a “Default Forecast”
total. Actual data should not be able to be changed.
o
Forecaster should have option to
change the data in the forecast columns, choose the “Default Forecast”, or
choose the previous annual forecast/budget. If the previous annual
forecast/budget is chosen, the template should spread the difference
between the choice and the “Default Forecast” proportionately over the
forecast months.
o
Reconcile whether total
forecasted capital salaries plus original budget O&M salaries exceed
total original budgeted salaries.
·
Revised all logic &
reports as needed to get full monthly financials for the current forecast
year
Maintain
ability to provide actual vs. forecast reports for capital and O&M.
3. Fixes and or
Efficiency Gains
HCM Application
Ability to display all changes in the EVDRE
template. As currently working, the template does not display the changes
made by end-users and saved in the database. This information is
overwritten with the base formulas when template is reopened and allows for
data to be overwritten in error easily.
Ability to input and save comments to database for
retrieval.
Finance Application
Ability to incorporate separate assumption sheet
on the template
Ability to input and save comments to database for
retrieval
Ability to provide subtotals within certain
processes
–JC
Penney Company, Inc. – Plano- Texas – December 2007 – October 2009.
SAP BPC-EPM Outlooksoft 5.1(BUILDS 486, 502) and SAP BPC-EPM
7.0 SP3 lead developer. Developing project tracking system for IT projects
across JC Penney Company, Inc. IT departments and Finance department. The
finance application set will be rolled out for budgeting and forecasting to
over one thousand stores throughout the country. The IT 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), Teradata,
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. Develop several journal
entries templates, intercompany elimination schedules, and allocation logic
to manage the consolidations across projects. The ERP data source for this
application is JD Edwards/PeopleSoft, Khalix, Oracle Project Accounting and
FMS. Developed JC Penney Directors project detail forecast, reports and MDX
calculations as well as logic to load data via SQL server Integration
Services Packages (SSIS). Develop ASPX using .NET 2008 to allow JCP
directors to self-service sourcing their projects with domestic and
off-shore resources. Installed and configured SAP BPC-EPM 5.1 SP03 in a
multi-server for all test, development and production environments. Develop
a pilot SAP BPC-EPM 7.0 NetWeaver Platform for a proof of concept.
Develop SAP BW info packages to load transactional data, master data
including SAP BPC-EPM characteristics, Attributes and text into SAP BW PSA
and then develop the DTP (Data Transfer Processes) to load into SAP BPC-EPM
NetWeaver InfoCubes. Develop the process chain to schedule the data
loads into the BPC-EPM NetWeaver infocubes. Integrate Data Extraction using
Teradata nodes to import Master data and data into SAP BPC for planning,
consolidations and monthly forecast.
Developed self-service project based planning for JCP-IT
department. Accordingly to business requirements and business meetings with
CFOs to implement the solution using SAP BPC 7.0- first SAP BPC version
after Outlooksoft acquisition.
Migrate reports and dashboards from Microstrategy 7.0 into SAP
BPC reports and Xcelsius dashboards and reports.
Took the following SAP BPC-EPM training classes for the SAP BPC-EPM
NetWeaver application consultant:
SAP BW NetWeaver 310, SAP BPC-EPM 330 on NetWeaver Platform and SAP
BPC-EPM on NetWeaver for Consolidations.
–MGM
– Los Angeles- California – September 2008 – November 2008.
Worked on a proof of concept to show SAP BPC-EPM features to
MGM senior management. In the proof of concept I developed a cube based on
actual data provided by MGM. The model was based on MGM key performance
indicators and its concept of MGM media ultimates calculations and its
corporate planning. The proof of concept model consisted of following
dimensions (Accounts, Company, Contracts, Customers, Deal Type, Markets,
Products, Currency, Territory, time and version. The proof of concept also
required to develop the input templates, reports and calculations.
–SanDisk,
Inc. – San Jose- California – July 2008 – December 2008.
SAP BPC-EPM Outlooksoft 5.1 SP 03 (Build 5.502)
technical-functional lead developer. Developing planning application for
the financial planning department to manage Human Resources Expenditures,
Operating Expenses, and Capital Expenditures by account, functional
department, division and legal entities. The application supports monthly
annual forecasts by functional departments. The application set was
migrated from Hyperion Planning 9.1 database and converted into SAP BPC-EPM
5.1 application set. Currency translation was also implemented to support
the foreign divisions. Develop the data architecture environment to extract
data from SAP BI into SAP BPC-EPM fact tables. Project also required developing
Bapi object to retract data into SAP BI from SAP BPC-EPM. Develop several
SQL classes and visual basic routines to accomplish the drill-down logic
for the input templates based on the location, legal entity and cost
centers dimension intersections. Configured and installed the Development,
test and production environments for SAP BPC-EPM, to allow database
clustering and web server load balancing. Develop SSIS packages to support
the extraction of data from SAP BI into text files, transform and load data
into SAP BPC-EPM fact tables. Migrate Hyperion Planning database into SAP
BPC as well all the reporting from Business Objects.
–Crosstex
Energy Services – Dallas- Texas – November 2007 -December 2007
Hyperion System 9 planning business rules development, web
forms, and 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, and 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
7.0 API functions via WebServices.
–The
Blackstone Group – New York City- New York – July 2005– October 2006
Develop Portfolio Company Reporting System
(PCRS) 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 Reporting System (PCRS)
client using an 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. Develop ETL routines
using HAL (Hyperion application link) to load data into Cingular Wireless
to CFO monthly reporting package.
–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.
Developed ETL packages to export SRC data into Outlooksoft.
–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 Microsoft Excel front-end menu for
the second largest homebuilder in the United SThe 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 – Hyperion Analyzer.
-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.
Education::::
· SOUTHERN
METHODIST UNIVERSITY, Dallas, TX – May 1997
Bachelor
of Science: Finance/Accounting/Information Systems
Professional Certifications:::
SAP
BPC Outlooksoft CPM 4.2 SP3 - Microsoft Analysis Services Professional – April
2004
Hyperion
Financial Management System 9 .3.1. – Hyperion HFM Certified Professional
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
Essbase Certified Professional - Sep 09, 2000 – Essbase
5.02
Hyperion
Essbase Certified Professional – Feb 11, 2007 – Essbase
6x , Essbase 7x
Microsoft
Excel Expert Certified Professional – April 2004
Cognos
TM1 Application Developer Certified Professional – January 2006
Cognos
TM1 Best Practices and Methodology Application Developer Certified
Professional – April 2006
Arcplan
AG Enterprise Certified Professional – March 2007
Key Training Courses:::
SAP
BPC330_1 Business Planning and Consolidation: Application Configuration; Application
Set Management; Application Management
SAP
BPC330_2 Business Planning and Consolidation: SAP BPC for Excel, Web, Word
and Powerpoint; Administration; Planning and Reporting
SAP
BPC330_3 Business Planning and Consolidation: Planning and Reporting with
EVDRE; Loading Master Data and Transactional Data; Validations; Appset
Parameters and Application Parameters; List of Menu Commands; Transports;
Debugging; Custom Process Types; Connectivity; BPC Statistics; Logging;
Technical Parameters and Internal Programs; Allocations; Work Status; Business
Process Flows BPF
SAP
BPC340 Business Planning and Consolidation: Consolidations; Planning and
Consolidation Framework; Consolidation Logic; Data Collection and
Preparation; Journal Entries; Balance Carry Forward; Account
Transformation; Allocations; Validations; Reporting; Currency Translation;
Consolidation of Investments; Intercompany Eliminations; Intercompany
Matching; Inter Unit Eliminations; COI Equity and Proportional
Key Training Courses:::
SAP
BW310: BW Enterprise Data Warehousing; Data Warehouse Workbench;
InfoProviders; InfoObjects; Characteristics; Key Figures; BI InfoCube;
Extended Star Schema; Data Flow; Loading Master Data from an SAP source
system; Loading Transaction Data from a SAP source system; ETL Processes
and loading Hierarchies; Data acquisition from Other Systems; BI Content;
Other InfoProviders; DataStore Objects; InfoCubes; Master Data; Virtual
Providers and Real-Time Data Acquisition; Multiproviders; BI Infosets;
Administration of Data Targets; System Administration Tasks in BI;
Administration of InfoCubes; Administration of DataStore Objects; Process
Chains; Introduction to Query Performance Optimization in BI; BI
Aggregates; BI Accelerator; BI Statistics
SAP
BPC420 Business Planning and Consolidation: Administration
SAP
BPC430 Business Planning and Consolidation: Planning and Reporting
SAP
BPC440 Business Planning and Consolidation: Consolidation
SAP
BW Business Information Warehouse : Reporting
Hyperion
Financial Management HFM 9.3 : Create and Manage Applications
Hyperion
Financial Management HFM 9.3 for Interactive Users
Hyperion
Planning 9.3 : Create and Manage Applications
Hyperion
Master Data Management MDM 9.3 for Interactive Users
Hyperion
Master Data Management MDM : Administration
Hyperion
Master Data Management MDM : Create and Manage Applications
Hyperion
Performance Scorecard: Enterprise Performance Management Foundation
Hyperion
Data Relationship Management DRM 11.1.2 for Interactive Users
Hyperion
Planning 9.3 for Interactive Users
Hyperion
Financial Data Quality Management FDM 9.0 : Full FDM 4 Fish Processes:
Import; Validate; Export; Load, Calculate on Target, Check on Target
Hyperion
Essbase 5 Fundamentals
Hyperion
Essbase 5 Administration
Hyperion
Essbase Integration Services: Create and Manage Data Structures
Hyperion
Essbase: Calc Scripts
Hyperion
System 9 BI+ Essbase Analytics Bootcamp
Hyperion
System 7x Bootcamp: Design, Build, and Calculate Analytic Services
Databases
Hyperion
System 9 BI+ Financial Reporting : Design Reports for Essbase Analytic
Services
Hyperion
System 9 BI+ Financial Reporting : Design Reports for Planning
Hyperion
System 9 BI+ Financial Reporting : Design Reports for Hyperion HFM
Hyperion
System 9 Planning: Bootcamp
Designing
and Optimizing Database Solutions with Microsoft SQL Server 2008
Cognos
TM1 Application Developer: Crate and Manage Applications
Cognos
TM1 Application : System Administration
Cognos
TM1 : Best Practices & Methodologies – System Design Concepts for TM1
Developers
Arcplan
AG Application design, management and Installation configuration
ALPHABLOX
Analysis Server : Installation & Configuration
ALPHABLOX
Analysis Server: Application Server Assembly
|
Information Technology Skills::::
|
|
Description
|
Experience
|
|
|
|
|
|
|
SAP BPC Netweaver & Microsoft:::
|
|
|
|
|
|
|
|
Outlooksoft
EAP/CPM Everest Versions: 1.0, 2x, 3x, 4x, 5x
|
8
Years
|
|
|
SAP BPC 5.1
SP3; SAP BPC 7.0 Microsoft & SAP Netweaver Platforms
|
4
Years
|
|
|
SAP BPC BO 7.5
sp7 Microsoft & SAP Netweaver Platforms
|
2
Years
|
|
|
SAP BPC EPM BO
10.0 Microsoft & SAP Netweaver Platforms
|
1
Year
|
|
|
SAP BPC320;
BPC330; BPC 340 Netweaver & Microsoft Platforms. SAP BPC420; BPC430;
BPC440 Netweaver & Microsoft Platforms Trainer; Client Custom
Training
|
11
Years
|
|
|
SAP BPC Script
Logic, Business Rules, MDX, K2DTSRUNLOGIC, EVDTSMODIFYPKG
|
11
Years
|
|
|
SAP BPC SSIS
Packages, Custom Packs, SAP BI NW Process Chains, ABAP, Z-ABAP PROGRAMS.
|
11
Years
|
|
|
SAP BPC Data
Manager Dynamic Script
|
11
Years
|
|
|
SAP BPC EVDRE
Report & Input Template Developer; Custom Programming
|
11
Years
|
|
|
SAP BPC
Multi-Server Installation, configuration, patch management
|
4
Years
|
|
|
SAP BPC Client
Installation, configuration, patch management
|
4
Years
|
|
|
|
|
|
|
|
|
|
|
Oracle – Hyperion:::
|
|
|
|
|
|
|
|
Oracle
Hyperion Essbase Server 5.2 – 11.1.2
|
8
Years
|
|
|
Oracle
Hyperion Financial Management 9.3.1-11.1.2
|
6
Years
|
|
|
Oracle
Hyperion Planning 9.3.1-11.1.2
|
6
Years
|
|
|
Oracle
Hyperion SmartView 9.3.1-11.1.2
|
6
Years
|
|
|
Oracle
Hyperion WebAnalysis 9.3.1-11.1.2
|
6
Years
|
|
|
Oracle
Hyperion Reports 9.0-11.1.2
|
2 Years
|
|
|
Oracle
Hyperion Interactive Reporting 9.3-11.1.2
|
2
Years
|
|
|
Oracle EPM
Consolidations Hub
|
1
Year
|
|
|
Oracle
Hyperion Essbase Integration Services 9.3.1
|
1
Year
|
|
|
Oracle HFM
Extended Analytics
|
1
Year
|
|
|
Oracle
Database 8i, 9i, 10i
|
4
Years
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Microsoft SQL Server:::
|
|
|
|
|
|
|
|
|
|
|
|
SQL Server
2000,2005,2008,2008 R2 Database Services
|
14
Years
|
|
|
SQL Server
2000,2005,2008,2008 R2 Management Studio
|
14
Years
|
|
|
SQL Server
2000,2005,2008,2008 R2 Integration Services
|
14
Years
|
|
|
SQL Server
2000,2005,2008,2008 R2 Reporting Services
|
6
Years
|
|
|
SQL Server
2000,2005,2008,2008 R2 Analysis Services
|
14
Years
|
|
|
SQL Server 008,2008
R2 Compact Edition
|
4
Years
|
|
|
|
|
|
|
SQL & Programming :::
|
|
|
|
|
|
|
|
Microsoft SQL
– TSQL
|
14
Years
|
|
|
Oracle PL-SQL
|
4
Years
|
|
|
Hyperion
Essbase Esscmd, Maxl
|
6
Years
|
|
|
Hyperion
Report Script
|
2
Years
|
|
|
BPC Script
Logic, K2DTSRUNLOGIC, EVDTSMODIFYPCKG
|
11
Years
|
|
|
HTML/XML
Programming
|
2
Years
|
|
|
ASP .NET
Programming
|
2
Years
|
|
|
MDX Script
|
10
Years
|
|
|
SSIS Custom
Script
|
10
Years
|
|
|
Excel VBA-
Excel Add-in
|
10
Years
|
|
|
ABAP
|
1
Year
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Windows Operating Systems:::
|
|
|
|
|
|
|
|
Windows 2000, 2003,
2008, 2008 R2 Server Management
|
10
Years
|
|
|
Windows 2000,
Windows XP, Windows Vista, Windows 7 Clients Mgmt
|
12
Years
|
|
|
Windows DOS
commands BAT processing, scheduling
|
14
Years
|
|
|
Windows
Terminal Services Server WTS
|
8
Years
|
|
|
Windows Remote
Desktop
|
8
Years
|
|
|
Citrix Server
– Farm – Citrix Configuration for Apps
|
2
Years
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Web Server:::
|
|
|
|
|
|
|
|
Microsoft
Internet Information Services IIS 1.1.4322 – 3.5 sites, virtual dirs
management, load, configs
|
8
Years
|
|
|
Apache Tomcat
6.0
|
2
Years
|
|
|
|
|
|
|
Application Server:::
|
|
|
|
|
|
|
|
2X
Application Server for Windows Terminal Services
|
1
Year
|
|
|
Essbase
Application Server
|
3
Years
|
|
|
|
|
|
|
Technical Resources Conferences:::
|
|
|
|
|
|
|
|
Hyperion
Solutions Exp Orlando Florida 2007
|
|
|
|
Oracle
Hyperion Technology Network
|
|
|
|
|
|
|
|
SAP ASUG
(America’s SAP Users Group) Orlando May 2009
|
|
|
|
SAP SAPHIRE
Orlando May 2009
|
|
|
|
SAP TECHED
2007 Las Vegas
|
|
|
|
SAP SDN (SAP
Developers Network)
|
|
|
|
SAP SCN (SAP
Community Network)
|
|
|
|
SAP Support
Portal SAP Notes
|
|
|
|
|
|
|
|
Microsoft Applications:::
|
|
|
|
|
|
|
|
Office
Application suite Excel, Word, Access, Powerpoint, SharePoint MOSS
|
14
Years
|
|
|
Visio
Client/Server
|
2
Years
|
|
|
Microsoft
Project Server
|
2
Years
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
SAP BI Business Objects Applications:::
|
|
|
|
|
|
|
|
SAP BI/BW
Workbench; Modeling, Scheduling, Monitoring, SAP BI BEx; SAP BOBJ- EPM;
SAP BW 310 Training; Full workbench data load InfoCubes, MasterData &
DSO; MultiProvider, Infoset,Info Package, DTP, Process Chains, all BW
layers, plus BOBJ Application tools & Xcelsius
|
5
Years
|
|
|
Xcelsius 8.0
Corporate Performance Dashboards
|
2
Years
|
|
|
Business
Objects XI 3.1-3.2 CMC-Universes
|
2
Years
|
|
|
Crystal, Webi
|
1
Years
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
SAP BPC – Oracle Hyperion Functional Areas::::
|
14 Years
|
|
|
|
|
|
|
Monthly Actual
Financial close
|
|
|
|
Rolling
Forecasts
|
|
|
|
Monthly,
Quarterly, Yearly Projections Scenarios
|
|
|
|
Business
Process Flows (SAP BPC BPF), Business Workflows
|
|
|
|
Legal and
Managerial allocations on business drivers; Key performance indicators
|
|
|
|
Elimination of
intercompany balances; US eliminations; InterCompany matching
|
|
|
|
Set business
rules FASBs compliance for subsidiary investments, Goodwill,
Depreciation, minority interest,
|
|
|
|
Consolidation
Tasks: Data Collection; Parent Consolidation; Subsidiaries Consolidation
Groups; Balances carry forward. Data Validation; data load; manual entry;
Accounting formulas data validation tests. Data Calculations; run
calculation business rules; populate calculated account; currency
translations. Data Adjustments; via Journal templates; Elimination
account/entity relationships; account transformation/reclassifications;
allocations. Data Consolidations Processing; set legal ownership
relationships; Set consolidation business rules tables; Apply GAAP, IFRS,
FASBs; Set consolidation groups hierarchies rollup; Run consolidation
aggregation calculation. Data Submitted for Review. Lock data after
Approval. Run Financial Consolidated Statements.
|
|
|
|
Monthly, YTD,
QTD Management Reporting
|
|
|
|
CFO, CEO
Monthly, Quarterly, Yearly budget, forecast, planning reporting
|
|
|
|
|
|
|
|
BI Applications:::
|
|
|
|
|
|
|
|
Teradata
|
1
Year
|
|
|
Microstrategy
7.0
|
1
Year
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Planning & Forecasting Dashboards Applications:::
|
|
|
|
|
|
|
|
SRC BPIMS –
Planning/Budgeting/Forecasting & Reporting & Dashboards
|
1
Year
|
|
|
Khalix
Budgeting Planning & Forecasting
|
1
Year
|
|
|
IBM
Showcase/Essbase Server 3.0
|
1
Year
|
|
|
arcplan -
Dynasight 3.0 – arcplan Enterprise 5.0
|
1
Year
|
|
|
Wired For
OLAP- Hyperion Analyzer
|
1
Year
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ERP Applications:::
|
|
|
|
|
|
|
|
JDE Edwards
ERP – Table Maintenance
|
2 Years
|
|
|
Oracle
Financials 8i, 9i, 10i
|
2
Years
|
|
|
Peoplesoft 9.1
HCM
|
1
Year
|
|
|
Lawson
Analytic Architect 7.2
|
1
Year
|
|
|
Lawson
Strategic Ledger 7.5
|
1
Year
|
|
|
Lawson Information
Architecture Procedures Insight 7.5
|
1
Year
|
|
|
A3
Solutions Templates Essbase Vision/Fortune
|
1
Year
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
COGNOS TM1 IBM Applications:::
|
|
|
|
|
|
|
|
Cognos Version
7 Series 2 – PowerPlay Enterprise Server PPES- Impromptu Web Reports IWR,
Directory Server, Upfront, Framework Manager, Cognos Data Manager,
DecisionStream, Cognos Script, Prompts
|
1
Year
|
|
|
Cognos Eapps
for JD Edwards : Selling G&A, Operations, General Ledger, Human
Capital Management
|
1
Year
|
|
|
IBM COGNOS -
Applix TM1 Cubes – Applix 9.1 Application Developer Certified
|
1
Year
|
|
|
IBM COGNOS TM1
Best Practices Application Developer
|
1
Year
|
|
|
|
|
|
|
Database Application Tools:::
|
|
|
|
|
|
|
|
Toad - Sybase
Software
|
1
Year
|
|
|
DB Artisan -
Embarcadero Technologies
|
1
Year
|
|
|
RDBMS Design
|
10
Years
|
|
|
Data Warehouse
|
10
Years
|
|
|
OLAP
|
10
Years
|
|
|
MOLAP
|
10
Years
|
|
|
ROLAP
|
10
Years
|
|
|
STAR
SCHEMA/SNOWFLAKE 1NF, 2NF, 3NF
|
10
Years
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Industries Experience::::
|
|
|
|
|
|
|
|
Finance/Accounting
|
14
Years
|
|
|
Capacity
Planning
|
2
Years
|
|
|
Training
|
10
Years
|
|
|
Transportation
|
2
Years
|
|
|
Manufacturing
|
5
Years
|
|
|
Real Estate
|
2
Years
|
|
|
Retail
|
6
Years
|
|
|
Utilities
|
2
Years
|
|
|
Oil & Gas
|
4
Years
|
|
|
Banking
|
6
Years
|
|
|
Investment
Banking
|
5
Years
|
|
|
Private Equity
|
5
Years
|
|
|
Financial
Services
|
6
Years
|
|
|
Energy
|
3
Years
|
|
|
Pharmaceutical
|
2
Years
|
|
|
Entertainment
|
1
Year
|
|
|
Wireless
|
2
Years
|
|
|
Telecommunications
|
2
Years
|
|
|
Food &
Beverages
|
1
Year
|
|
|
Semiconductor
|
1
Year
|
|
|
Asset
Management
|
2
Years
|
|
|
Hospitality
|
2
Years
|
|
|
Hotels
|
2
Years
|
|
|
|
|
|
Other
Engagements:
-Migrate
SQL Server 2000 databases into SQL Server 2005 (SQL Server Management
Studio), BIDS (Business Intelligence Development Studio), SSIS (SQL Server
Integration Services), SSAS (SQL Server Analysis Services), SSRS (SQL
Server Reporting Services), Data Mining Services, UDM (Unified Dimensional
Model).
-DTS
packages migration from SQL 2000 into BIDS (Business Intelligence
Development Studio)
-Upgrade
SAP BPC 7.0 to SAP BPC 7.5 SP7, to get Business objects reporting features,
setting ODBO provider, authentication with BO, Data Services (DS) ETL, and
data integration with financial information Management (FIM)
- BI
Migration from Business objects XI R2 to Cognos BI 8.3
-Migration
SRC to BPC: Application architecture differences, Migration strategy and best
practices for migrating SRC to BPC. Report/template development,
interfaces, conversions, enhacements for Excel formulas design and
optimization, data imports, Excel add-in custom development, Excel VBA
utilities.
Languages:::
English,
Spanish, Italian, Portuguese.
Name: Shelly Hendee
Title: SAP BPC Manager
Client: CVPS
Phone Number:802-747-5339
Email ID: Shendee@cvps.com
Name: Shankar Narayanan
Title: Sr. SAP BW/BI - BPC Sr. Technical-Functional
Manager
Client: CVPS
Phone Number:802-747-617
Email ID(1): Nneelar@cvps.com
Email ID(2): Sanki.Er@gmail.com
Name: Jason Lau
Title: SAP BPC Analyst
Client: Bloomberg
Phone Number:718-640-5291
Email ID: Jason.lau@accenture.com
Name: Luciano Tiberia
Title: SAP BPC Project Manager
Client: Bloomberg
Phone Number:770-331-3201
Name: Miguel Ordonez
Title: SAP BPC Security Manager
Client: Bloomberg
Phone Number:732-604-0601 or 347-414-2605
Email ID:mordonez@geller.com
Name: Betsy Doucette
Title: SAP BPC IT Controller
Client: JC Penney
Phone Number:972-431-5479
Email ID:bdoucett@jcpenney.com
Name: Steve Christensen
Title: SAP BPC – BW Sr. Recruiter
Client: Grom -Bloomberg
Phone Number:732-259-7482
Email ID:SChristensen@liquidhub.com
Name: Sutton Keany
Title: SAP BPC Application Developer Lead Manager
Client: The Blackstone Group
Phone Number:917-608-6933
Official Email ID:Keanysa@earthlink.net
Name: Jeff Larson
Title: SAP BPC Business IT Manager
Client: JC Penney
Phone Number:214-207-3252
Official Email ID:jlarson@jcpenney.com
Written References from
flagship Outlooksoft/SAP BPC project in New York City:
From: Steve
Christensen [mailto:SChristensen@grom.com]
To: Keany, Sutton with the Blackstone Group – New York City.
Subject: Martino Rivaplata-reference
Sutton,
Good morning, we are
currently working with Martino on his next opportunity. He provided
your contact information in regards to a professional reference.
Please take a couple of minutes and respond with your experiences with
Martino. Thank you!
1)
What was your working relationship with Martino?
I was the project lead on a portfolio company reporting project
which implemented OutlookSoft. Martino was the lead developer.
2) Did
his performance fall short, meet, or exceed expectations?
Exceeded.
3)
What were some of his strengths/weaknesses?
Strengths
are flexibility, creativity and rapport with the users. Martino was a
big favorite and went out of his way to do a good job.
4)
How did he work and interact with his teammates/managers?
Martino
is a pro and was not difficult to work with at all. He tends to work
best on his own but there was certainly never any issue regarding
interaction.
5)
How would you describe his ability to work with the business to understand
their business needs and tailoring the technology to fit accordingly?
As
I said above, the business became Martino's number one fan. In our
project there was a different set of financial specs for each company (i.e.
different financial years, metrics, etc) and Martino was able to understand
each with ease and weave them into a common data structure. Everyone
was quite happy with his business acumen.
6)
Would you consider him for rehire?
Yes.
He is a specialist and if we were to implement one of the packages with
which he is familiar we would consider him immediately.
Thanks,
Steve
Christensen
SAP
Recruiter
908.483.2000
ext 236
swc@grom.com
Grom
Associates, Inc.
www.grom.com
MORE PROFESSIONAL REFERENCES:
Jeff
Larson, Senior Manager, JC Penney – IT Finance jlarson@jcpenney.com,
phone 214-207-3252
Michelle
Welch, Senior Business Analyst, J Ray McDermott, mwelch@jrmcdermott.com,
phone: 281-236-7211
David
Munns, Senior Database Architect, JC Penney IT dmunns@jcpenney.com,
phone 469-766-0618
Sutton
Keany, Manager IT Application Development – New York City, Keany@Blackstone.com,
Phone:212-583-5310
Avinash
Munimakula, Senior Hyperion Planning/Essbase Architect, Sandisk, San Jose
California, Phone: 646-510-2035
Adrian
Iosifescu, IT President -The Blackstone Group – New York City, Iosifescu@Blackstone.com,
Phone:212-583-5572, Cell: 646-456-4012
Duyen
Tran, Controller President – The Blackstone Group – New York City, dktran_us@yahoo.com,
Phone:714-658-4011
Harry
Moseley, CIO – The Blackstone Group – New York City, Moseley@Blackstone.com,
Phone: 212-583-5900
Michael
Phelps, Controller American Golf Corporation, mphelps@americangolf.com
Jeanine
Williams, Senior IT Systems integration, Whitney National Bank,
jlwilliams@whitneybank.com
David
Denboer, Director of Consulting, Outlooksoft Corpotation, ddenboer@outlooksoft.com
Brad
Olson, Senior Consultant, Outlooksoft Corporation, bolson@outlooksoft.com
Glenn
Miles, Cingular Wireless Project . Glenn.Miles@Cingular.com
Tim
Murphy, Cingular Wireless Project.
Tim.Murphy@Cingular.com
<hr> Member number: 8960 <br> Additional Contact information is available on the <A HREF="8960I.html">Profile Page</a>.<br> Software Contractors' Guild (<A HREF="http://www.scguild.com">www.scguild.com</A>) <br><b> <font size=-2><A HREF="/copyright.html">Copyright</A>(c) 2012 Software Contractors' Guild</b></FONT> </BODY></HTML>
|