Name : XYZ                                                                                                  E-mail ID: ABC@gmail.com
Phone No.: xxxxxxxxxxxxx                                                       Current Job: SAP BPC Consultant

 

OVERVIEW

Overall 4 years of IT experience and 1.5 years of experience in SAP BPC NW with 1 full BPC implementation in 7.5 version, 2ndBPC project experience of few months in 10.0 version and currenty working on 3rd BPC project in 7.5 version.
Have experience in both Planning process and Consilidation process as a Techno-Functional.
Gained good knowledge of BPC 10.0 NW by having experience in 2nd project & by doing self learning by creating dummy project, for more details refer Self learning tab.
Completed Finance certification exam CFA (Chartered Financial Analyst) Level 1 and CFA Level 2 from CFA Institute USA.
Basic Understanding of BW for BPC.
Basic Understanding of BADI and also working on BADI to implement one client's complex requirement , since BADI works on OOPS concept and I have already 1.5 years experience in OOPS (C++) concept.
Interact with Business Users and the Stake holders of the project to get the Functional and Technical requirements and analyze As-Is model and define the To-be model
Created and Maintained Application Sets(Environment),Dimensions and Applications(Models) in BPC 7.5&10.0
Created and Maintained Input Template in both BPC 7.5&10.0
Created and Maintained Reports Template in both BPC 7.5&10.0
Developed Business Logic such as Dimension Formula, Script Logic, and Business Rules in both 7.5 & 10.0 version.
Created and Maintained Transformation Files and Conversion files in both7.5 and 10.0 version.
Performed Data Loads in SAP BPC NW from flat files. • Performed Data Loads from SAP BW Info Cubes to SAP BPC NW Applications.
Worked on Security Setup and Business Process Flows in 7.5 version.
Communicate and co-ordinate with SAP on the product bugs, defects and apply the OSS Notes.
Reconciling the data of SAP BPC Consolidation and Planning Extracts with SAP BI and ECC applications.
Worked on Consolidation Business Rules & logic, such as, Copy Opening, Currency Conversion, Intercompany Matching/Elimination and Account Transformation

SKILL SETS

SAP BPC NW 7.5 & 10.0
TOOLS: Control-M , DSTX , C++.
DATABASE: Oracle 9i
OPERATING SYSTEM: Windows 98/XP, Windows Vista,windows 7, Linux. EXPERIENCE Y&L Consulting, San Antonio Client: Nustar Energy SAP BPC Consultant (April 2013 Current) Version: 7.5 NW Nustar Energy is one of the largest independent liquids terminal and pipeline operators in the USA, has pipeline; terminal and storage facilities that store and distribute crude oil, refined products and specialty liquids Roles and Responsibilities as a SAP BPC Consultant
Analyzing the performance related issues of EVDRE Input Schedule , Reports and also other areas like script logic ,BADI , security etc which is present in the OPEX planning application of Nustar energy.
Using UJSTAT,audit logs and other performance tool like fiddler to get the details logs of Application OPEX in BPC to understand the root cause of the performance issue.
Detail Analyzing the rootcause of MDX or RSDRI statement getting trigger from EVDRE and solving the same by including only that logic in EVDRE which trigger RSDRI statement.
Improve the performance time of Complex Input template from 80 seconds to 15 seconds which was the most critical template in BPC for Nustar Energy.
Reconfiguring the design by removing unnecessary dimension like Segment, Region and Project from OPEX application and accordingly to comply the changes in Reporting, security, logics etc..
Debugging BADI and script logic to check the performance of the logic when running on 23 million of data of ACTUAL, BUDGET and FORECAST version and make changes which is best for performance.
Used custom VBA macros in Reports to get desired results as per client.
Details Analysis as above for the HR Planning Application of Nustar energy.
Fixed issues rose during the BUDGET cycle.
Developed new Input templates and Reports as per user's requirement.
Corrected Transformation and Conversion files for loading HR planning data from Flat file.
Fixed many comments Issues which were raised in day to day issues.
Developed and Maintained Member access profile & task profile for new user.
Learning BADI and trying to build an Input template as per user requirement using BADI to handle complex requirement
Modifying all Input templates and Reports in Opex Application for best performance. Prism Informatics,
Mumbai Client: Idhasoft (India) SAP BPC Consultant(Feb 2013-March 2013) Version: 10 NW Idhasoft is an IT service & consulting company having operation in 4 continents. Roles and Responsibilities as a SAP BPC Consultant
Created and Maintained Report Templates in 10.0 using EPM Editor & dynamic formatting as per user requirement for their consolidation process.
Created and Maintained Input Template in 10.0 using EPM Editor & dynamic formatting as per user requirement.
Develop Dimension formula and Script logic in 10.0 for consolidation process.
Worked on Transformation and converison file and loaded data from BI to BPC.
Validate data in BPC with BI & finance team and fixed all issues.
Worked on Dimension to modify property for reporting purpose.
Used EPM function while developing Input Template & Reports ie EPMContextMember , EPMSelectMember , EPMMemberProperty , EPMMemberOffset etc..
Prism Informatics, Mumbai
Client: Hemas (Srilanka) SAP BPC Consultant (May 2012-Jan 2013)
Version: 7.5 NW Hemas is a leading public quoted company in Sri Lanka engaged in a diverse set of business activities, focused on Healthcare, FMCG, Leisure, Transportation, Power and New Ventures.
Roles and Responsibilities as a SAP BPC Consultant
Created Application Sets HEMAS for process Fixed Forecast Planning, Budgeting, Rolling Forecast, IFRS and Consolidation in BPC 7.5 NW.
Created and Maintained Revenue/Cost Planning Applications for all Hemas business sectors ieHealthcare, FMCG, Leisure, Transportation, Power and New Ventures .
Created and Maintained Income Statement, Balance Sheet, Cash Flow and KPI Ratio Application for Planning Process used in Hemas.
Created and Maintained Legal, Rate and Ownership Applications for Consolidation process used in Hemas.
Created Transformation and Conversion files for both Transaction data and Master data for Income Statement, Balance sheet & IFRS Application.
Loading Transaction data in SAP BPC from flat files for Non-SAP Entities used in Hemas.
Created and Maintained Input Schedule for all Revenue/Cost application that is for all sectors in Hemas to input plan data.
Developed Reports using Dynamic Templates & EVDRE for all process used in Hemas.
Developed VBA Macro to handle Time engine and for other user requirement.
Developed complex Dimension formula in C_ACCT dimension in Legal Application for consolidation process.
Developed Script logic in planning process ie Sending data from one application to other, calculation etc
Security setup for all Application & Users • Configuring Business Process Flows for all Application/Process and assigning respective user to BPF.
Communicate with SAP on the product bug(Data retrieval issue) where SAP released special note for it and apply the OSS Notes
Maintaining the Rates in the RATE Application for USD & LKR
Worked with BI team for BPC Process Chain development to load the financial data to Staging DSO and subsequently to the FIGL Cube of BI from where we load transaction data in BPC. (this comes under consolidation process where if the value of GL is less than zero then it should come under liability or else it should come under Asset.
Reconciling the Transaction data for BPC Consolidation and planning process for almost 20 entities of Hemas with BI and ECC.
Worked on Consolidation Business Rules & logic, such as ->Copy Opening: To load last year last month data to opening balance for current month under FLOW dimension F_100. ->Currency Conversion: To convert USD currency to LKR. ->Intercompany Matching/Elimination: To book intercompany transaction between entities of Hemas and eliminate the same. ->Consolidation of Investment: To develop reports at group level ->Account Transformation: Generated Cash Flow using this rules.
Developed complex Rolling forecast reports ie showing 24 months data for 6 sectors in one report for Actual, budget and Plan Data
Developed complex Account, Time, Datasource, Flow& other dimension for Consolidation process.
Worked on Journals,to input JV entries in consolidation process.
Created & maintained Info Objects, Transformations, DTPs, Info packages and scheduling the data requests and Activating InfoObjects, InfoArea and InfoCube.
Load Data from the PSA to the Data Target.
Created and Maintained Data Manager Packages and Process Chains HSBC Software Development Center Project: Global Payment System (GPS) >DSTX. Software Engineer (Feb 2011  May 2012) Domain: Payments Services in Banking. Data Stage Transformation Extender (DSTX) is an IBM product used as a middleware for complex transformations.
Roles and Responsibilities in DSTX as a Developer
Maps and type tree Development in DSTX tool as per client requirement.
Develop and maintain Maps for US region to help transformation of payment for FED & CHIPS so that outgoing payment are transformed such that it is acceptable by FED/CHIPS.
Develop and maintain Maps for UAE region to help transformation of payment going via SWIFT and NET payment channels.
Develop and maintain Maps to read Payment coming from any outgoing channels and convert into the format which is acceptable for GPS.
Creating the scenario in the development env for any defects raised in production env for countries US ,CA , UAE and providing fix for the same.
Roles and Responsibilities in DSTX as a support
Generating executable format and deployment of maps on production server during implementation for different countries like US , CA , EU , NZ , UAE , BD etc..
Resolving different issues found different testing environment like IST, UAT and OAT example- >Are maps able to convert the payment as per IRSD document.
Verify all maps with unit testing where it is checked that for all possible input whether the output file is getting generated.
Supporting end to end batch which includes making track of every task is running in proper way. HSBC Software Development Center, Project: Global Payment System (GPS) >C++. Software Engineer (Aug 2009  Jan 2011) Domain: Payments Services in Banking. C++ is a coding language on which the Global Payplus product has been developed from scratch.
Roles and Responsibilities in C++ as a Developer
Interface Development in C++ on GPS which are more specific to HSBC business.
Write rules which are internal to GPS are used to generate payment/file in particular format.
Defect fixing which are raised during production (live) or any testing environments.
Validating C++ code with the IRSD and FRSD document which are developed by Business Analyst.
Interaction with the Fundtech for any clarification required for the Interface development.
Involvement with IT BA for impact analysis and development estimates.
Test Case validation as per the FRSD and the IRSD document developed by BA.
Creating the scenario in the development env for any bug raised in production env for countries US ,CA , UAE and providing fix for the same.
Roles and Responsibilities in C++ as a support
Support from Interface side during the implementation of GPS for Countries like US , CA , EU , UAE etc..
 Supporting end to end batch which includes generation of EOD (end of day) files and send it to backend for reconciliation.
Analyzing and provide workaround fixes during the batch run for different testing environment ie IST, UAT and OAT.
Helping Testing team to validate whether the High Value payment are getting processed as per the client requirement.
Fix Configuration and setup while implementing new testing environments for every release.
Communicate with our internal environment to guide them to fix env issues related to testing env.
Involvement in the Defect Prevention champion meeting(DPC) to understand the root cause of all defect raised on monthly basis and find a resolution to avoid that root cause.
HSBC Software Development Center,
Project: Global Payment System (GPS) >Control-M tool. Software Engineer (Aug 2009 Jan 2011) Domain: Payments Services in Banking. Control-M is a workload automation (traditionally called batch scheduling) software tool which have the set of tasks in sequential manner that are run during batch.
Roles and Responsibilities Extensively involved in Daily processing and monitoring of Jobs.
Solve errors if any particular jobs failed during batch. SELF Learning BPC 10.0 Details
Created Dummy project for Revenue Cost Planning for Ford motor company.
Created & Maintained Model for the Revenue & Cost planning for Ford small cars.
Created dimension
Account, Category, Entity, Product& Time.
Account Dimensionhas members for revenue generated by selling cars, all expenses members to manufacture cars & Income statement.
Product Dimensionhas 4 smalls
cars of Ford
Focus, Fiesta, hybridand Fusion.
Created Input template&Report using 5 different method ->  Using Report Editor
Using EPM Pane
Creating directly in a sheet using member Recognition and the Local Member Recognition features.
Using EPM Function
Using Default Dynamic templates
Used different Dynamic Formatting feature to format the Input template & Reports like using hierarchy, Member property etc
Used Dimension formula&Logic script for the Business logic.
Used almost all feature present in Report Editor i.eSorting, Filtering, Local Member, Ranking, Exclude Members, Read Only Data.
Familiar with all features present in Sheet Option&User Option.
Used the Local Member Recognition Concept.
Used bellow EPM Function to develop Template/Report ->
­ EPMAxisOverride
EPMContextMember
EPMSelectMember
EPMDimensionOverride
EPMMemberProperty
EPMCommentsFullContext
EPMSaveComments
EPMMemberOffset
EPMReadOnlyData
EPMEnvDatabaseID and many more.
Used the Custom Member concept in the Template/Report. Used the EPM Pane, Context Pane&Member Selectorwhile creating Template/Reports. Used VBA Macro in Template/Reports. CFA curriculum CFA(Chartered Financial Analyst) is a certification course in finance provided by the CFA institute USA. The finance areas covered in this course are: 1) Alternative Investments 2) Corporate Finance 3) Derivatives 4) Economics 5) Equity Investments 6) Ethical & Professional Standards 7) Financial Reporting & Analysis 8) Fixed Income Investments 9) Portfolio Management 10) Quantitative Methods

EDUCATION

B.Tech in Information Technology Mumbai - 2009 -Pass Level 1 & Level 2 exam from CFA Institute USA - 2011
- See more at: http://www.itlearnmore.com/sap-bpc-consultant-resume/#sthash.tR6lF8NX.dpuf


Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque volutpat volutpat nibh nec posuere. Donec auctor arcut pretium consequat. Contact me 123@abc.com

0 comments:

Post a Comment