SAP BPC Consultant - Worked on two full life cycle SAP BPC implementations. Over 8 yrs of experience as a Software Developer. Experience in development of EVDRE reports, Input schedule and Journals. Experience in business process modeling, Data modeling and develop design document for BI/BW data load with ETL tools

Education:

Diploma in Computer Science

Professional Experience:

Confidential, (San-Diego) 02/11 -Present

SAP BPC/BI Consultant

• Worked on SAP BPC 7.5 NW Planning/Budgeting/Forecasting implementation from Blueprint to implementation and going live.
• Developed Business Process Flows to guide end-users through pre-defined sequential tasks that span across the different departments within the organization.
• Involved in data extraction and conversion between BPC and non-ERP systems with extractors and ETL tools.
• Developed custom Process chains to support master data and transaction data loads fromBI to BPC.
• Created Package links to bundle more than one packages and to run sequentially.
• Used Modeling functions such as Spread, Trend and weight to distribute the allocation to base members.
• Worked on setting up Security and Audit settings to ensure user entitlements and access rights.
• Worked exclusively on Work Status and integrating the Work States with Business Process Flows.
• Configured drill-through functionality in Reports to see the underlying data from external databases.
• Involved in SAP BPC implementation, configuration, and upgrade and environment management.
• Maintained Document Types and Sub Types from Web Admin Tasks Action pane.
• Used Content Library to publish Documents. Developed BPC Live Reports using drag and drop option and included interactive chart. Developed BPF, Audit and Work Status Reports.
• Maintained the exchange rates in the Rate Application. Developed Business Rules and Script logic for Currency Conversions.
• Loaded data into Dimensions and Applications from an external source using a flat file. Collaborated with IT and business partners to identify source data fields and to define the transformation rules.
• Managed Work Status at Application Set and Application level, to control data input and to lock the data for period close.
• Extensively used EV functions to create worksheet logic for local calculations. Maintained comments in Input Schedules and report using EVCOM functions.
• Migrated Appsets from Development to testing and to production using Transports Management System
• Gather requirements and design infocubes, ODS Objects and Multi cubes.
• Design Process Chains for daily extraction of data and maintenance for day-to-day schedule.
• Involved in master data loading and transaction loading.
• Design and develop master data for further analysis
• Mapping data from source to target, create transformation,PSA and DTP
• Export data to SAP R/3 to publish the reports for Bex Query design.
• Map loads and integration with SAP ERP data.
• BI error analysis and skills to debug.
• Worked with SAP BW components including BW Administrator Workbench
• Data extraction from flat files, DataSource, InfoObjects, DTP, PSA, InfoProvider, Multi Providers and Process chains.
• Performed Business data modeling and analysis and have thorough understanding of relational data structures, Extended Star Schema and OLAP concepts.
• Good understanding with data modeling using MDM and BW extended star schema models.
• Experienced with BI InfoObject, Infocube and MultiProviders. Worked on SAP NetWeaver, BW workbench and have in-depth knowledge on UJ* tables and corresponding transaction codes.

Confidential, (India) 11/08 -08/10
SAP BPC/BI Consultant

• Worked on SAP BPC 7.0 NW Planning and consolidation implementation.
• Developed Data Model for BPC Account Based model from BI KPI's.
• Created Application Set from APPSHELL. Developed Applications, Dimensions, Properties and Hierarchies
• Configured Application Set and Application parameters for Journals and work status settings.
• Involved in data extraction and conversion between BPC and BW systems.
• Worked on Setting up Security features with Task profiles and Member Access Profiles.
• Integrated SAP BPC Data Manager Packages with SAP BI process chains.
• Developed script logic files using ABAP, BADI, MDX and SQL.
• Created EVDRE Input Schedules, Reports and Journals, Script Logic and Business rules. Also used
• Worksheet formulas, and Dimension Formulas for G/L Accounts, P & L, AR, AP, Income Statements which involved Budgeting and Forecasting.
• Worked on month end closing consolidation Reports.
• Performed reporting and data collection using Distributor & Collector functionality.
• Extract data from SAP and non - SAP systems into BPC/BI/BW with ETL tools
• BI mapping Master Data to Source Data, create Transformations

Confidential, (India) 11/02 -05/05

Oracle PL/SQL Developer

• Developed PL/SQL Packages and Procedures to populate data in datamart for generating reports.
• Followed CMM level 3 for development activities.
• Developed/modified stored procedures as per new change control requests.
• Developed Visual Basic macros for excel based adhoc reports.
• Mafatlal Consulting Services(INDIA) 05/99 -06/02 Java Developer
• Involved in design and development of web interface using JSP, Servlets, JavaScript and JDBC for Administrating and managing users and clients.
• Developed Web Pages using JSP, Java Applets, and JavaScript, DHTML and graphics tools.
• Created GUI to design template for further analysis

Skills

• Specialization: SAP BPC 7.5 Netweaver and Microsoft , Business Intelligence (BI/BW), Enterprise Performance Management (EPM), Enterprise Information Management (EIM) and BO.
• Programming languages: Oracle PL/SQL, Java, C, C++, Visual Basic, VB Macros, Java Script
• Database systems: Microsoft SQL Server, Microsoft Access, Oracle, DB2, Sybase, Microsoft SQL Server,Microsoft Access, SAP, Informatica PowerCenter 9.0.1, Teradata Database 12.x BTEQ Power Point, MS Word, MS Excel.