Data Manager,Report Building,Logic scripts,BPF's,Bussiness rules,BW/BI
Resume:
MARAM ARAVIND SUKUMAR +919*********
SAP BPC Consultant *******.***@*****.***
PROFILE SUMMARY:
• Overall 2 years Technical experience in SAP Business Planning and Consolidation 10.0 NW & around
6 months experience in SAP BI/BW Module.
• Skilled in understanding existing business processes and mapping them into SAP solution. Provide
technical support to client in customizing application based on their needs.
• A Self starter with a positive attitude, Strong interpersonal & analytical, problem solving skills,
leadership qualities with a track record.
• Currently working in BPC Labs, India.
EDUCATION:
• Bachelor of Computer Science & Engineering from JNTUA, India.
TECHNICAL SKILLS:
• SAP R/3 : SAP ECC 6.0.
• SAP BI/BW : BI 7.0/7.3.
• SAP BPC : SAP BPC 10.0 NW.
• Operating systems : WINDOWS 7,8.1.
• Application Software : MS Office, Photoshop CS, Web Designing.
• Computer Languages : C, C++, HTML, Logic Scripts, Java Scripts, Scratch, ABAP (Basic).
SAP EPM– BPC 10.0NW Skills:
• Dimensions management: Creation of Environment. Dimension Management such as creation, additions,
deletions and maintenance of members in a dimension.
• Model management: Creation, addition and maintenance of dimensions for both reporting and non reporting
models.
• User Security: Creation and maintenance of Users, Teams, Tasks, Data Access Profiles
• Data management: Master Data loaded to a BPC Dimensions and loading of transaction data from BW info
cube/flat file.
• Creation of Reports and Input forms, static as well as dynamically per the client requirement.
• Used Logic Techniques such as Worksheet Logic, Dimension Logic and Script Logics for making calculations
in planning input forms, Execution of BADIs in BPC Script Logic .
• Work status management for data authentication.
• Configuration of Business Rules for Currency Conversion, Balance Carry forward, Account Transformation,
Intercompany Matching settings with Intercompany Data and Intercompany Booking. Also Intercompany
Elimination.
• Creation of Business Process Flows for users to monitor the job completion.
• Generation of BPC Audit reports and Comments.
1
• Involved in configuring the Teams, Member Access Profiles and Task profiles.
• Knowledge about configuration of Distribution and Journals, Consolidations Monitor and Controls Monitor.
• Knowledge for BPC enhancement using Lite and full optimizations, Drill down and Drill Through functionalities.
• Knowledge on bringing Actual data from SAP ECC to BW and to BPC.
• Documentation, training users and supported the BPC system.
SAP BI Skills:
• Had a good experience in Managing, implementing and configuring BI.
• Proficiency in BI Architecture, Data Modeling, BW tool set including BW Reporting (Bex Analyzer, Info Set
Query, and Web Reporting (WAD)), BI Integration, BI Security, Customizations and BI Operations.
• Created Info cubes, DSO, Multiproviders, Info objects, Data Sources, Transformations, DTP, Info packages,
BEx Reports, etc
PROFESSIONAL EXPERIENCE:
PROJECT # 01
Project details SAP BPC NW Implementation
Client IT Company
Role SAP BI & BPC Consultant
Duration Jun 2014 – Till Date
ROLES & RESPONSIBILITIES:
• Created Planning and Consolidation model with the required dimensions.
• Implemented Script logics in various reports.
• Configured the Work status and Business Process Flows.
• Transforming data loads to Planning and Consolidation models from Flat Files and also from BI Info Providers.
• Created and worked on several reports like HR Assumptions Report, Movements Report, Employee Wages
Report, GL report etc.
• Written some allocation rules by loading Headcount and other factors into BPC.
• Developed Logic Scripts for Calculating Ending Headcount for plan Periods, Average salaries and Bonus% per
Department, New Hire Salary and Bonus, Salary Increments, Payroll Tax etc.
• Moving data between different Models.
• Created several input forms for planning like HR Assumptions input, New Hires and Terminations, Known
Terminations, Known transfers etc
• Configured the setup of business rules like Account Transformation, Currency Conversion etc.,
• Involved in configuring the Teams, Member Access Profiles and Task profiles.
• Administered changes to the Model design and functionality.
2
• Developed Transformation and Conversion files, data manager packages for master data and Transaction
data loads from BI.
• Developed Work Status Scenarios.
• Developed US Elimination Business Rules for Inter Company Eliminations and Developed Business Rules for
Currency Conversions.
• Configured Security Profiles and mapped to appropriate Teams.
• Used Script Logics for calculations and developed Input Schedules and Reports using EPM functions.
Developed Reports for Balance Sheet, Income Statement.
• Created Info cubes, DSO, Multiproviders, Info objects, Data Sources, Transformations, DTP, Info packages.
PROJECT # 02
Project details SAP BPC NW Support
Client IT Company in the life sciences industry
Role SAP BI & BPC Consultant
Duration Nov 2013 – May 2014
ROLES & RESPONSIBILITIES:
• Worked on BPC NW Support Project for maintaining the Models, Dimensions, Monitoring the daily
loads, resolving daily tickets, etc
• Daily activities include monitoring the nightly jobs, checking the job logs and variance reports between
BI and BPC.
• Resolve tickets raised by business users to add new /Update Existing the dimension members for
dimensions.
• Some of the issues resolved include validation of data between BI and BPC after the nightly loads.
• Created Data Manager Packages, Transformation Files and Conversions Files.
• Maintenance different packages like, full optimization, Lite Optimization, default, Opening balance,
Year End Process etc.
• Loaded different transaction data from multiple sources like BI/Flat file to Current Period, Exchange
Rate Load.
• Support the Month end Close activities like Infusion of Actual, Running Delta packages from BI to
BPC and BPC to BI.
• Reconciling the data in BPC and BI by running the variance reports.
• Monitoring BI process chains for the jobs related to BPC nightly jobs.
PROJECT # 03
3
Project details SAP BPC NW Support
Client Based IT Service Industry
Role SAP BI & BPC Consultant
Duration May 2013 – Oct 2013
ROLES & RESPONSIBILITIES:
• Worked with Production support of BPC for maintaining the Models, Dimensions, Monitoring the daily
loads, resolving daily tickets, etc.
• Weekly Models, Maintenance of applications Staging, Consolidation, Ownership and Rate
• Resolve tickets raised by business users to add new /Update Existing the dimension members for
dimensions.
• Some of the issues resolved include validation of data between BI and BPC after the nightly loads.
• Created Data Manager Packages, Transformation Files and Conversions Files.
• Maintenance different packages like, full optimization, Lite Optimization, default, Opening balance,
Year End Process etc.
• Loaded different transaction data from multiple sources like BI/Flat file to Current Period, Exchange
Rate Load.
4
Contact this candidate