Prem Aiyer, SAP FICO Training Consultant

Prem Aiyer

SAP FICO Training Consultant

Transport For NSW

Location
India
Education
Master's degree, Management and Finance
Experience
16 years, 6 Months

Share My Profile

Block User


Work Experience

Total years of experience :16 years, 6 Months

SAP FICO Training Consultant at Transport For NSW
  • Australia
  • My current job since March 2017

Key Responsibilities
• Develop Training material for SAP FICO Courses for Implementation for Sydney Trains (SAP Go Live Date - 1st week of July 2017)
• Major courses developed and delivered - FI-GL Entry and Transactions, FI-CO Management Accounting Full Course, Tax Management and Compliance, Business Intelligence (BI/BW) Reporting and Interagency/InterCompany Billing
• Instructional Writer/Trainer creating end user training materials in multiple formats for FI-GL, FI-CO Management Accounting and Interagency Billing Courses
• Set up data in the training environment to support content creation, pilot sessions and end user training
• Instructional Design experience developing SAP NetWeaver training materials using WPB training authoring tool (WPB Producer 9.5.3 version)
• Building Simulations and Work Instructions using Workforce Performance Builder Tool for relevant courses in GL Accounting and Management Accounting for Sydney Trains and all Agencies in Transport Cluster
• Using HPQC Test Scripts to build, test scenarios in UAT and raise defects to Implementation team through Business Analysts
• Building, Testing and delivering training material for Treasury & Banking Course module for Sydney Trains SAP end-users
• Appreciation email from Executive Director of Organizational Development on effective training delivery to Sydney Trains Business partners and Senior Management

Business Solutions Services Manager, SAP FICO at British Council Management Services Ltd
  • India - Delhi
  • October 2012 to October 2016

Key Responsibilities
• Level1, Level2 and Level3 Support on incidents and FICO issues
• Provide SAP FICO Support to all British Council subsidiaries in different countries in areas such as FI-Accounts Payable (FI-AP), FI-Accounts Receivable (FI-AR), Banking, Treasury and FI-AA (Asset management) and Controlling functions such as Work Breakdown Structure (WBS) Related Issues
• Monthly Incident Management, Review and Analysis of Level1 Support Team (Third Party organization SEAL INFOTECH PVT LTD. India)
• DME (Data Medium Exchange Engine) related issue handling for British Council Global Vendors and Customers/Receivables (Non FI-AR FICA/Campus related) across PAYMUL, XML and IDOC (SAP Internal Document) Formats and HSBC, SCB and CITIBANK (Major Platforms)

Other Key projects
• Implementation of New Entity British Council Examinations and English Services India Private Limited (BCEES) including SAP Business process mapping and Testing of products such as IELTS, non-IELTS and other businesses across Scenarios such as Procure to Pay (P2P) inclusive of Service and Withholding Taxes, Banking Setup and Payments, Cash Journal Setups, Asset Related Design and Configuration Testing
• Banking Payments (FI-AP) and Receipts (FI-AR) Auto Clearing Program Enhancements for EFT Bank transfers, Cheque payments and Cheque receipts across BC country regions such as Europe, Wider Europe and Middle-East North Africa (MENA)
• Asset Design, Testing and Implementation for British Council Ukraine and Turkey Company Codes based on specific differences between UK GAAP and Local GAAP Reporting requirements for both Migration and newly Capitalized Assets

ACHIEVEMENTS
• 2 End to End (E2E) Implementations of British Council countries Ukraine and India
• Represented SAP Team at the Global IT Summit Conference held in British Council, Manchester, UK
• Appreciation Email from IS Department Head and Extreme Team Award for India Implementation Project
• Successfully executed British Council Management Services Pvt. Ltd. (BCMS) India Asset Cleanup Project in order to execute first successful SAP Audit by Corp Finance of entire BCMS India Fixed Assets Register to match with Tally figures for Fiscal Year 2013
• Received Personal and Team appreciation related communication for successful project implementation from BCMS Corporate Finance Head and Managing Director, SAP Business Head, British Council, UK and Information Systems Head of the Organization
• Implementation of the New Fixed Asset Process for British Council Globally, with the first Pilot being British Council, Ukraine and British Council, Turkey including FI-AA Integration
\[Configuration including Unique Requirement Scenarios for Ukraine of all phases from Requirement Gathering to Implementation and Go-Live with Post Go-Live (Early Life Support)\]
• Business Visit to British Council London, UK for Requirement gathering for the Fixed Asset Configuration for UK GAAP and Local GAAP for Ukraine and Turkey, including Fit Gap Analysis with Director Finance, Ukraine and Regional Head, Wider Europe
• Received BCMS Award for Fixed Asset Project Implementation for Ukraine and Turkey
• Successfully Implemented Industry Best Practice - Down Payment Clearing Automation Tab in MIRO Screen for SAP ECC 6.0 EHP4 across all British Council (BC) Countries Global Business Scenarios in P2P inclusive of Input VAT (Both Recoverable and Non-recoverable) and Withholding Tax Impacts with SAP FI/MM Integration aspects

SAP FICO/FICA Consultant at HCL Technologies Ltd
  • India - Delhi
  • February 2012 to October 2012

Project Client Consumer Energy, Michigan, US \[IS-Utilities\] \[Part of Offshore Support Team\]

•Support Project for Utilities - Electricity and Gas Products
•Working on resolving Support Tickets
•Minor and Major Enhancements related to Accounts Payable Vendors, Treasury and FI Reports

SAP FICO Consultant with BPC Capability at Accenture India Solutions Private Limited
  • India - Delhi
  • September 2010 to January 2012

Key Responsibilities
• Underwent SAP BPC \[One of the modules of the SAP EPM-SEM Suite for Enterprise Performance Management\] Boot Camp and Hands-on Training in Accenture, Pune Location during October 2010 - 4 Weeks
• Completed Asset building activity on Intercompany Process in BPC - Created InterCompany Match Up Report as part of the asset building activity in SAP BPC Training Server
• Gained knowledge of 3 relevant concepts/sub-topics with regard to SAP BPC Consolidation, namely : EVDRE Form Builder, InterCompany Matching and Validation BADI Concepts
• Helped Team Member gain Training/Knowledge of BPC Forms and Reports

November 2010 - October 2011
Client AIG (American International Group Inc.)
SAP BPC Project Harmony

Key Responsibilities
• Part of Phase I and Phase II of the largest BPC Implementation Project in Accenture named Consolidation Project Harmony for AIG \[(American International Group, Inc.), the 2nd Largest Insurance Company in the world\]
• Helped Team Member gain Training/Knowledge about 2 BPC Forms and Reports Logic, Build Technique and Documentation
• Build, Test and Document 2 Forms and Reports per week - Completed all Build Development Activities for assigned Forms and Reports by February 11, 2011 before the March-end 2011 deadline
• Carried out Dry Run Testing of 5 different Test Scripts and noted Expected Results and Remarks for Errors and system messages generated alongwith screen shots documented in word documents for the following activities, namely -
1. Post Journal Entries for Manual InterCompany elimination and Currency Conversion Package Run and Report Output
2. Post Journal Entries, Run Consolidation Package and check pre and post elimination entries
3. Post Journal Entries, Run Currency Conversion and ICDATA Package and Report Output of Expected Results
4. Post Journal Entries and Run Currency Conversion Package

ACHIEVEMENTS
• Received CPA (Celebrity Performance Award) for Publishing White Paper on Static and Ad-Hoc Reporting in SAP BPC using Formatting with specific techniques used in the AIG Project Harmony Consolidation Project
• Received appreciation mail from Client, Project Manager and Capability Manager for meeting project specific deadlines for Project Harmony with regard to creation, designing, Unit Testing and Checklist preparation and submission for Forms and Reports for Financial Statements submitted by different Business Units in XML

Assistant Manager, SAP FICO at PEPSICO India
  • India - Delhi
  • July 2009 to August 2010

(Accounts Payable, Accounts Receivable, Controlling and Manufacturing Plant Costing)

Key Responsibilities
• COPA Projects Implementation with SAP ABAP Consultant for Snacks - Business Unit for Allocation of P&L Expense categories such as Fixed manufacturing Overhead, Variable manufacturing Overhead, General & Administrative (G&A), Advertising & Marketing (A&M), Sales Tax etc. and upload through BDC to value fields in COPA using KE21
• COPA Project Implementation for Beverages with regard to correction of Customized programs for change in allocation logic from Distribution Channel(DC) to DC-Brand-Pack-Product Category-wise allocation for Segment P&L and Integration aspects between FI/SD
• Daily and month-end support to End-Users through resolution of Queries posted on Solution Manager
• Reconciliation between P&L SAP Actual values FTM (For the Month) and P&L values through Assessment Cycle Run posted and executed through KE30 in COPA
• Resolution of month/period-end activities and background jobs related to
 Assessment Cycles
 Depreciation Run
 Branch Account Posting for AP and AR
 Internal Order Settlement for Maintenance Orders
 Other Orders for settlement of assets acquired through CWIP

• Support for SAP Financials and Controlling Components
• End-to-end Testing of new Configuration such as Plant and Warehouse Creation especially Financial and COPA Impacts including FI/PM Integration
• Handling issues related to Month-end Closing Processes for Beverages and Snacks
• Managing Projects such as Project Fusion with IBM, Chennai for outsourced business process cycles such as P2P, S2C and R2R
• Providing End-user support for resolution of understanding and transactional issues including Month-end closing issues related to Resolution of Purchase Order-Internal Order and Assets related user-end understanding issues
• Implemented Controlling-Profitability Analysis (COPA) Project for Snacks with defined allocation logic for entire Segment Profit & Loss (Segment P&L)
• Creation of GL, Cost Center and Profit Center Report Linkages for India Region and Division (Dubai-AMEA) Hyperion Reporting for Beverages and Snacks

ACHIEVEMENTS
• COPA Projects Implementation with SAP ABAP Consultant for Snacks - Business Unit for Allocation of P&L Expense categories such as Fixed manufacturing Overhead, Variable manufacturing Overhead, General & Administrative (G&A), Advertising & Marketing (A&M) Expenses, Sales Tax expenses etc. and upload through BDC to value fields in COPA using KE21
• COPA Project Implementation for Beverages about correction of Customized programs for change in allocation logic from Distribution Channel(DC) to DC-Brand- Pack-Product Category-wise allocation for Segment P&L
• Executed Annual Product Costing Run for all relevant Plants created under Pepsico India Pvt. Ltd.

SAP FICO Consultant Trainer Faculty at SKY INFO TECHNOLOGIES
  • India - Delhi
  • April 2009 to July 2009

Entire FICO Configuration
•Asset Accounting (FI-AA) Configuration including creation of Asset Under Construction through Internal Orders
•Cost Center and Profit Center Hierarchy including Account Assignment
•New G/L including Splitting Characteristics and Scenarios such as Profit Center and Segment
•Taxes including Sales/Purchases and Withholding Tax
•CO-PC (Controlling - Product Costing) : Manufacturing Production Order Costing with setting up parameters such as : Costing Type, Valuation Variant Quantity Structure Control

Freelance Training as SAP FICO Consultant including ECC 6.0 enhancements, namely:

•Asset Accounting through Investment Management (IM) Module
•New GL Accounting
•Document Splitting
•CO-PA (Controlling - Profitability Analysis)

Package Solution Consultant SAP FICO at IBM INDIA PRIVATE LIMITED
  • India - Delhi
  • September 2008 to December 2008

Key Responsibilities
• Working in the internal IBM implementation project
• Entire FICO Configuration
• Full Life Cycle implementation from Project Preparation, Business Blueprint, Realization, Final Project Preparation, Unit & Integration testing, Go live and Support
• Completed entire Asset Accounting (FI-AA) Configuration including creation of Asset Under Construction through Internal Orders
• Created Cost Center and Profit Center Hierarchy including through Account Assignment
• Activated New G/L including Splitting Characteristics and Scenarios such as Profit Center and Segment in SAP ECC 6.0
• Configured Taxes including Sales/Purchases and Withholding Tax
Key Responsibilities
• Working in the internal IBM implementation project
• Entire FICO Configuration
• Full Life Cycle implementation from Project Preparation, Business Blueprint, Realization, Final Project Preparation, Unit & Integration testing, Go live and Support
• Completed entire Asset Accounting (FI-AA) Configuration including creation of Asset Under Construction through Internal Orders
• Created Cost Center and Profit Center Hierarchy including through Account Assignment
• Activated New G/L including Splitting Characteristics and Scenarios such as Profit Center and Segment in SAP ECC 6.0
• Configured Taxes including Sales/Purchases and Withholding Tax

Operations and Sales Manager at ICICI Lombard General-Insurance Company Limited Mumbai, India
  • India - Mumbai
  • April 2005 to July 2006

(No.1 General Insurance Company in India - JV between ICICI Bank Limited \[No. 1 private bank in India\] and Lombard of Canada)

Key Responsibilities
• Worked with Bank senior management regarding co-insurance products as part of the role with the Process and Operations Team of ICICI Lombard
• Handled Insurance of Agri-Credit Line (ACL - Insurance of Agri-Trader Property) and Retail Warehouse Receipt Finance (RWRF - Insurance of Commodities) which were product tie-ups with ICICI BANK
• Operations role at Mumbai (ICICI Bank Head Office)
• Operations functions at Mumbai (ICICI Lombard Head Office)
• Conducted Pilot Projects of Weather Insurance in Kota, Rajasthan, India (Commodity - Coriander) and Aligarh (Commodity- Wheat : Sales achievement of Rupees 1.5 Lakhs (Indian currency) in 15 days of the pilot) - Period 1ST JAN 2006 - 15TH JAN 2006
• Conducted a first of a kind Cattle Insurance Project with ICICI BANK at Rasoolabad, Kanpur, India in Alliance with a private dairy in Rasoolabad, Kanpur, India
• Exponentially increased sales from Rs. 60, 000 per month to Rs. 6 lakhs per month in December 2005

Education

Master's degree, Management and Finance
  • at Institute of Rural Management AnandIRMABusiness School
  • April 2005

MBA Finance from Institute of Rural Management Anand (IRMA) Business School, Gujarat (Ranked among Top-10 B-Schools: 2005)

Bachelor's degree, B.E. Computers
  • at Pune University
  • August 2000

B.E. Computers, Army Institute of Technology (AIT), Pune University.

High school or equivalent, Maths, Physics and Chemistry
  • at CBSE
  • May 1995
High school or equivalent, English, Maths and Science
  • at CBSE
  • May 1993

Specialties & Skills

sap fico
SAP FICO Consulting
INSURANCE
SAP FICO Business Analyst
CONSULTING

Languages

English
Expert

Training and Certifications

Training Completion on SAP S/4 HANA with Simple Finance On Premise Edition 1503 at British Council (Training)
Training Institute:
ATOS India
Certificate for Completion of SAP PS-CO (Project System - Controlling) Integration Module Training (Certificate)
Canadian Securities Course Certificate Exam (CSC) : Part I and II from Toronto, Canada (Certificate)
Date Attended:
July 2007
NSE Certification in Financial Markets (NCFM) course from National Stock Exchange (NSE) (Certificate)
Prince2 (Project Management Course) Practitioner Level Certified (Certificate)
Date Attended:
September 2015
SAP FICO R/3 version 4.7 (Certificate)
Date Attended:
September 2008