Resume of Jerry Francis Page # 1

RESUME Senior BI/BPC Consultant

TC 11/285, Christ Nagar
Trivandrum, Kerala, India
Email : jerry.francis@gmail.com
H/p: +91-9995804579

Profile Highlights
9 years of techno-functional experience in SAP-R3 (FI-CO, SD and MM)
2 years of technical experience in BW 3.0 / BI 7.0 .
3 years of techno-functional experience in SAP BPC MS / NW 7.0 and 7.5
Strong working experience in SAP-ABAP on various advanced ABAP tools
SAP Certified BPC/BW Consultant
7 full SAP R3 implementation cycles, in the roles of Team Lead, Project Lead, Team member
2 BI/BW implementations
5 BPC implementations
Good Communication skills. Committed team player , encouraging total participation
Conducted CPM310 and 320 trainings for SAP Malaysia, KL.
Conducted BPC330 & BPC340 trainings for SAP Malaysia; SAP Education,Bangalore(IND)
Conducted BPC430 & BPC440 trainings for SAP India ; SAP ANZ, Auckland
Functional knowledge in FI-AA, RE-FX, FI-GL, FI-COPA, FI-CCA, FI-PCA
Academic Qualification
Attended IFRS training. (Piron Education, India).
Bachelor of Computer Engineering from Madurai Kamaraj University, India, in 1991.
SAP Certified BW 3.x Solution Consultant (Oct 2004). Certification Id: 0003166565
SAP Certified BPC 7.0 Consultant (May 2010). Certification Id: 0007429463
Trained in SAP Strategy Management (SSM)
Work Experience
SAP Enterprise Performance Management (EPM) skills
Business Planning and Consolidation (SAP-BPC MS 5.1, 7.0 and NW 7.0, NW 7.5)
System setup : AppSet, Application, Dimensions
Security Setup , Business Process Flows , Building dynamic hierarchies
Creating input schedules and report templates using EVDRE
Currency translation , validation rules , elimination rules setup
Development of Script logic and dimension logic , Excel VB scripting
BPC Xcelcius integration and building dashboard models

SAP Business Intelligence (BI) - Technical skills
Modeling : Creation of InfoProviders, InfoObects, DataSources , Transformations
Reporting : Queries using BEx Analyser and Web Application Designer
Extraction : R3 Extraction of Special purpose ledger, Oracle extraction using dbConnect
ListCube programs : Customized for extracting data from InfoCubes.
Setting up process chains

SAP R/3 - Technical skills
Reporting : Simple Lists, Interactive Lists, Drill Down and ALV,SAP Scripts & Smart forms
Batch Interfaces : For loading data into SAP system specific to FI, MM and SD.
Function Library : Development and maintenance of function modules for various utilities.
Dialog Programming : Development of transactions for maintenance of ADD-ON tables.
SAP enhancements : Developed user-exits , field exists in SD and MM modules
ABAP Query , Authorization , Transport Management , User maintenance
SAP Integration with other SAP and legacy systems using Remote Function Calls /FTP
Outbound and Inbound IDOCS using ALE and EDI.
Business Add-Ins (BADI) , Class Builder, Object Programming
Context Builder and Business Object Builder
Good knowledge of various database tables used in FI/CO/SD/MM modules
Good knowledge in the various optimizing techniques and SAP integration with SAP & non-SAP systems
Resume of Jerry Francis Page # 2
Employment History
PMCS, India :Self Employed :Jun2010 till date :Sr. Consultant SAP EPM
CPM Consulting, Singapore :Permanent :Oct2007 Jan 2010 :Sr SAP BPC Consultant
Deutsche Bank, Singapore :Contract :Dec 2004 Aug 2007 :Sr. SAP R/3, BI Consultant
SONY ISSAP, Singapore :Contract :Nov 2000 Nov 2004 :Sr. SAP R/3 Consultant
IVL India Pvt. Ltd., India :Permanent :Feb 1997 Oct 2000 :SAP R/3 Dev Consultant
Other technical skills
Very good in documentation using MS-Office tools
Familiar with SSAD methodologies
UNIX and C , C++ , VB Scripting
SAP Solution Manager , ITS and Business Connector , SAP-SSM, SAP-BPC
Personal details
Date of Birth :01.06.1969
Marital Status :Married
Nationality :Indian
Resident status in Singapore :Permanent Resident
(Currently residing in India)
SAP BPC Training Programs Conducted
SAP Malaysia, KL CPM310 & 320 NOV 2008
SAP Malaysia, KL BPC340 JAN 2010
SAP India, Bangalore BPC 330 & 340 FEB 2010
SAP India, Bangalore BPC 330 MAY 2010
SAP Malaysia, KL BPC 330 JUN 2010
SAP Asia , SG BPC 330 & 340 NOV 2010
SAP India, Bangalore BPC MS 7.0 Workshop NOV 2010
SAP New Zealand, Auckland BPC 430 & 440 FEB 2011
SAP India for IBM, Pune BPC 420 & 440 MAR 2011
SAP BPC Project Summary
A) PMCS, India Apr 2010 till date
1.
Project : Consolidation Project
Client : Lodestone Management Consultants Australia Pty Ltd.
Platform : SAP NW BPC 7.5 (Business Planning and Consolidation)
Role : BPC Implementation Expert

Legal Consolidation Feb 2011 Oct 2011
To give guidance to the project team in implementing the consolidation system using BPC 7.5 NW
Review of Business Blueprint
Review of System design and to provide improvement suggestions.
To give expert guidance during the system build stage
To guide the implementation team to prepare the system for UAT.
To prepare training manual and to provide end user training

2.
Project : Project Athena (Financial Planning)
Client : Prince Court Medical Centre (PCMC), Malaysia
Platform : SAP MS BPC 7.0 (Business Planning and Consolidation)
Role : BPC Subject Matter Expert (SME)
Budget System: July 2010 October 2010
To give guidance to the project team in implementing the budgeting system using BPC
Identify the knowledge gap in BPC and provide proper solution and training to the project team
To give training to the end user on how to use the system to perform their planning activities
To guide the project team in formulating the go-live plan and help them in a smooth transition
Document the solution process and bring the business super users to a level that will help them in using
the system in more effective manner.
Resume of Jerry Francis Page # 3

B) CPM Consulting, Singapore Oct 2007 Jan 2010
1.
Project : Project FPPM (Financial Planning & Perfomance Management)
Client : Jurong Town Council Corporation (JTC), Singapore
Platform : SAP NW BPC 7.0 (Business Planning and Consolidation)
Role : Senior SAP BPC Consultant/ Team Lead
JTC Corporation is Singapores leading provider of industrial real estate solutions and services. They have
set the pace for Singapores industrial growth by developing 6,600 hectares of industrial land and 4.4
million square meters of ready built facilities. In the process, they have housed more than 7,000 home
grown companies and multinationals.

Budget System: April 2009 Jan 2010
Business Blueprint (BBP)
Requirement gathering by conducting BBP workshops with different JTC clusters.
Understand the Flexible Real Estate config and master data in SAP-R/3
Preparation of templates for various planning areas like CAPEX/COPEX/HR/REVENUE
Preparation of the BBP document

Realization
Setting up extractors (CCA/PCA/HR) for pulling data from SAP R/3 to BI
Enhancement of extractors
Data modelling in BI and BPC
COPEX schedules and reports
Manpower cost schedules and reports
BADI for Manpower cost calculation
Movement of data between applications using custom BADI
Cusotmized process menu for various applications using VB script .
Data manager packages for loading Master and Transaction data from BI to BPC cubes
Setting up security profiles and work status in BPC
Preparation of SIT script
Preparation of User Guide and BPC Administration Manual
End user training (45-60 Budget users)

2.
Project : Project CONNECT (Consolidation system)
Client : OLAM International Limited, Singapore
Platform : SAP MS BPC 5.1 (Business Planning and Consolidation - SQL Server)
Role : Senior SAP BPC Consultant

OLAM is a leading global supply chain manager of agricultural products and food ingredients, which
operates an integrated supply chain for 14 products in 78 countries and delivering these products to over
4500 customers in over 90 destination markets. The main objective of project CONNECT is to provide a
single source of Legal and Management reporting in a more structured , efficient and time effective
manner.
Management Consolidation : December 2008 March 2009
(Which includes consolidation of Budget , MIS and BRM figures after adjustments)
The process of management consolidation starts with the origins (around 78) submitting their Trial Balance
as a CSV file. This file is then loaded into BPC (MIS application) using a customised Import package, on a
monthly basis. Reports like Balance sheet and P&L are generated from the BPC system. Product teams
,positioned in Singapore, validates these reports and makes adjustments to the figures for purpose of
management reporting. A final P&L is prepared after the adjustments made by the Corporate team. All these
adjustments are tracked using specific Datasources. VAR and Working Capital which also form a part of the
Final P&L , are loaded separately from Excel files (generated from the RISK system) and loaded into BPC
with the help of Excel Macros (VBA codes). Data thus loaded into the MIS application flows into the BRM
application using BPC script logic. Various reports (Entitywise/Productwise/Accountwise) are generated from
these applications with facilities to Scale in Millions / Display at various levels of entity and product.
Initialization
Requirement gathering, Preparation of BBP and detailed Design Document
BPC administration
Creation of AppSet, Dimensions and Management Consolidaion Applications
Security setting : Creation of users/teams/member access profiles
Setting up work status and concurrent locks with different levels
Setting up Custom Menu for MIS & BRM Appl. with separate menu for Origins & Product Teams.
Script Logic
Currency Translation logic and Budget allocation logic
Data transfer logic to send data from one application to another
Resume of Jerry Francis Page # 4
Data Manager packages
SSIS package for loading Budget Comments from CSV file
Data Manager packages for loading data from text files and Excel files
VB Scripting
VB scripts for generating CSV files by reading the Budget excel template.
VB scripts for generating CSV files by reading the Working Capital and BRM excel templates
Input Schedules and Reports
Complex Input schedules with multiple EVDREs and Reports for MIS & BRM Applications
Generation of various analysis reports with drill down capabilities, pick and choose options.



3.
Legal Consolidation: July 2008 October 2008
The process of Legal/Financial Consolidation starts with the origins submitting their Trial Balance on a
Quarterly basis. These files which comes in the form of CSV format are loaded into BPC (Legal App) using a
customized Data Manager package. Curreny translation rules that were setup in the LegalApp are triggered
at the time of data load so that the Origins can see the figures in USD . Input Schedules are used to make
disclosure entries. There are also provision to load the disclosures from CSV files. Legal Consolidation
package is run after all Origins had submitted their Trial Balance and Adjustments, in BPC. Intercompany
elimination and Consolidation of Investment rules were setup to make adjustments to the figures at the time
of consolidation. Complex authorizations were setup so that Origins can only view their respective data that
has been loaded into BPC . Reports like Balance sheet , P&L , Various Schedules are also generated from the
system.
BPC administration
Setting up Legal Application, Rate Application and Ownership Application and related Dimensions
Custom menu for Legal application
Setting up security profiles
Work status setting
Dynamic hierarchy setup for maintaining the ownership details


Script Logic
Currency realignment logic
Business rules
Multi - Currency translation rules
Adjustment rules (inter-company elimination, cosolidation of investments)
Posting opening balances to the respective consolidation month.
Data Manager packages
SSIS Package for loading data into Dimension tables from ORACLE
Package for loading exchange rates into the RATE application.
Package for loading the trial balance from ORACLE.



4.
Project : Planning Budgeting and Consolidation
Client : MediaCorp Pte Ltd, Singapore
Platform : SAP BPC 5.1 (Business Planning and Consolidation SQL Server)
Role : SAP BPC Consultant

MediaCorp Pte Ltd. has a history of more than 70 years of radio and 41 years of television experience. As
one of the region's most established broadcasters, MediaCorp plays a key role in developing Singapore as a
broadcasting and media production hub in Asia. MediaCorps core business are TV, Radio, New, Press and
Publishing.

Planning & Forecasting: May 2008 June 2008
Preparation of BBP for planning, conduct BBP workshops with client
HR planning and Forecasting Input schedules
CAPEX planning and forecasting Input schedules
Production planning and forecasting Input schedules
Script logic for distributing production costs and pushing data to Sales App.
Generated financial statements
Setting up journals



Resume of Jerry Francis Page # 5
5.
Project : Legal Consolidation
Client : GreatWall Enterprise , Taiwan
Platform : SAP BPC 5.1 (Business Planning and Consolidation SQL Server)
Role : SAP BPC Consultant

Great Wall Enterprise. The Group's principal activities are manufacturing and selling of feeds and edible
oil such as fat and coconut. Other activities include wholesaling and retailing of meat and frozen products
and other miscellaneous food such as flour, corn, noodles, beverage and others, importing and exporting
wine, selling western medicine and medicine for animal, manufacturing chemical fertilizer, and operating
supermarkets. It also does selling, leasing and constructing commercial and residential buildings, operating
supermarkets, selling medicines for animals and providing home services for animals.

Legal Consolidation System setup: January 2008 April 2008
Requirement gathering and preparing BBP for the Legal Consol system
Preparing the detailed system desing document
Setting up the Legal , Ownership and Rate application
Building the respective dimension and settig up the member sheets
Setting up the COA groups and hierarchies
Setting up the Entity groups and dynamic hierarchies for defining the ownership
Setting up the application parameters and work status
Setting up the currency translation rules for standard and historical rates
Setting up the validation and elimination rules for consolidation
Buidling the business process flow for the Legal Consol application
Input schedules for entering the exchange rate for standard and historical rates
Defining the process for loading and processing the Trial Balance to the Legal Application
Reports for checking the data submission , BS , PNL and Cash Flow statements using EVDRE
User authorization and access to perform specific tasks using Security profiles and work status
Script logic for adjustment posting of exchange rate and elimination differences.

SAP R3/BI Project Summary

6.
Project : Order Backlog and Net Sales Margin project
Client : ADIDAS HongKong
Platform : SAP/NW BI 7.0
Role : SAP/BI Consultant

Data Modelling: Oct 2007 December 2008
Creation of Datasources based on Oracle database using DBConnect
Creation of DSO , DTP and Infopackages for the staging and DWH layer
Creation of InfoCubes , Multiproviders for the Reporting layer
Developed ABAP expert routines for transformation in different layers
Creation of order backlog queries using Bex Analyzer.
Desinged and Scheduling of Process chains
Creation of queries using Bex Analyzer
Rollout to other asian countries and testing


C) Deutsche Bank, Singapore Dec 2004 Aug 2007

1.
Project : Global General Ledger (GGL) SAP/R3 FICO implementation & support
Client : Deutsche Bank , Singapore branch
Platform : SAP/R3 ECC 5.0
Role : SAP/R3 FICO Technical Consultant

Inbound interfaces Integration with feeder systems
Daily movements file from E+ to SAP to post in FI and CO-PA .
Balances file from Infinity to SAP to post in COPA.
Interfacing ETS (Expense tracking system) with FI-AP to load Vendor invoices.
Outbound interfaces
Outbound interface for SAP costs to BCS , DW and Finacle.
Sub ledger reconciliation
Sub ledger reconciliation process for Singapore and Australia.
Resume of Jerry Francis Page # 6
DB specific tools
Data Conversion Workbench (DCW) for DB Singapore, Australia and Japan.
Job scheduler for manual trigger/scheduling of background jobs.

2.
Project : Future State Renewal (FSR) SAP-R3 FICO implementation
Client : Deutsche Bank , Manila branch. Philippines
Platform : SAP/R3 ECC 6.0, SAP/BI 7.0
Role : SAP/R3/BI IT Lead, FICO Techno-Functional Consultant

R/3 IT Lead Role
Responsible for the R/3 deliverables. Lead a team of three technical resources.
Work closely with the Finance people in understanding the business requirements and assist the
technical team to deploy the same.
Work closely with other work streams in understanding the integration requirements.

Configuration of Special Purpose Ledger (FI-SL)
Table group definition , Field movements , Defining ledger, Setting up Fiscal year
SL Validation and Substitution
Generic/Standard extractor for FI-SL
Modelling and creation of DSO, Infocubes and Transformations
Desgined process chains for loading data from ETL, extraction from FI-SL

Inbound interfaces
Technical design and development of Inbound interfaces to FI-SL and FI-GL.

ETL integration with R3 using RFC and Object oriented methodology
Establish ETL (Infomatica) integration with SAP R/3
Developed RFC for triggering the SAP standard FI-CO validations during interface run, from ETL using
SAP objects.
Automated posting of movements in FI-SL initiated by RFC call from ETL

D) SONY ISSAP, Singapore Nov 2000 Nov 2004
1.
Project : E3 project SAP/R3 FICO/SD/MM implementation & support
Client : SONY BPC Division, New Jersey, USA
Platform : SAP/R3 4.6
Role : SAP/R3 Sr. Technical (ABAP/4) Consultant

Outbound Interface
Send Demand Forecast details to Tokyo by collecting relevant data from Planned Independent
Requirements and Purchase Order.
Send Receipt Authorization details to Tokyo by collecting data from Stock Transfer Order (identified by a
separate order type), Inbound and Outbound deliveries. Once the interface is run , a report will be
mailed to the concerned users in the distribution list.
Send details of the confirmed Purchase Orders (for a specific order type and model) to Tokyo.
Interface program which will send the SAP FI-GL data to Oracle

IDOCs , ALE and EDI implementation
To transmit invoice to the various Vestcom vendors. The basic type used INVOIC and its an outbound
processing.
PO information sent as IDocs from Customers(Outbound IDocs) are received in the SAP system resulting
in automatic creation of sales orders (Inbound IDocs).
Order confirmation from SAP is sent back to the customers via EDI.
Implementation of user exits in Inbound & Outbound IDocs (SO creation, to map data from Customers
to SAP SO & update of order confirmation in PO)
Additional user defined fields in Sales Order
Creation of new fields in IDoc segments
ALE Customizing
Setting up of EDI connection (Partner profile, RFC destination, ports etc)

Financial Accounting General Ledger
Modified the existing Customer Account statement in FI to suit the business requirements. An Outbound
file transmission to Vestcom is activated at the time of generating this monthly Account Statement.
Developed Travel sheet, a clone of standard layout PSFC_PRINT_LAY, in SMARTFORMS. This is a
replacement to the standard Object List output from the Production Order (CO03)
Resume of Jerry Francis Page # 7
2.
Project : SOAR project SAP/R3 FICO/SD/MM implementation & support
Client : SONY Consumer Division, New Jersey, USA
Platform : SAP/R3 4.7, SAP /BW 3.0
Role : SAP Technical Team Lead
SAP/R3 Sr. Technical Consultant, SAP/BW Technical Consultant
R/3 Team Lead
Responsible for R3 deliveries. Manage a team of 18 technical consultants.
Give technical and functional guidance to the team members
Coordination with business people to understand the requirements and translate and define the technical
design aspects.
Job allocation , Status reporting to the Project Manager in US and Code reviews

Financial Accounting Credit management (Accounts Receivable)
Interface between Oracle and SAP, for maintaining a single point Customer credit line in SAP, by
exchanging the pending order information.
Customize the Credit Master Sheet (F.35).

Business Warehouse - Data Modelling
Creation of InfoObjects Z_C21TBL, Z_SNPT20 and Z_SECURE.
Maintenance screen for certain InfoObjects using Document Change Control techniques (SCDO).
InfoCube for Sales Order which is used in the MultiCube ZMC_CPFRS and having details of the sales
order needed for the CPFR (Collaborative Planning, Forecasting & Replenishment).
InfoSource for the Sales Order and a Transfer Rule to derive Major Product Category.
Extraction of listcube data from the MultiCube ZMC_CPFRS and generation of Forecast Error and
Volatility Metrics report file.

E) IVL India Pvt. Ltd., India Feb 1997 Oct 2000
1.
Project : Works Contract Tax (WCT) implementation
Client : SAP India , Bangalore , India
Platform : SAP/R3 4.0b
Role : SAP/R3 Sr. Technical (ABAP/4) Consultant
This project was managed by SAP India for their client Larsen & Toubro, Mumbai, India.
WCT is meant for organizations involved in EPC (Engineering, Procurement and Construction)
business. WCT will be computed for each of the invoice line items or the goods receipt line items
(if base value is taken from PO) and which fall under the pre-defined scenario by which the
material has been procured. WCT rate depends on whether the project has opted for Composition
tax method and includes taxes like Surcharge, Additional tax, turnover tax etc.
Design & Documentation
Development of module pools and Data transfer programs
SAP enhancements & Authorization objects

2.
Project : International Services Tool (IST)
Client : Siemens Business Services (SBS) , Munich , Germany
Platform : SAP/R3 4.0b
Role : SAP/R3 Technical (ABAP/4) Consultant
Dialog programming and SAP Enhancements (SAP-SD,MM)
Module pool which performs goods movement transactions like MB1A (GI), MB1B (TP), MB1C (GR) and
MB11 using BDC. This program has got a close link to SM and SD modules. It also performs transactions
like IW36 (sub-service order), VA01 (SO) and VA02.
User-exit in SAPMV45A (SO) which validates the storage location with the one assigned to the service
order. It also gives a possible list of storage locations that has been assigned to the service order. User
exit which will copy the service order number to an additional field in VBAK. Stock structure report of
technicians. Work center hierarchy is being used to find out all the technicians that are assigned to a
higher level.

3.
Project : Ausnahmegenehmigungen (KFZ-AG)
Client : City of Leverkusen, Germany
Platform : SAP/R3 3.1h
Role : SAP/R3 Technical (ABAP/4) Consultant , Project Lead
Project lead
Dialog programming, Reports, SAP scripts
*************