Data Sap

Kalpana Naik

*********@*****.*** 317-***-****

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

SAP BPC/BI/BW Trained

Certified in MS Dos, D-base and Lotus

Under going training in SAP BPC 10.0 & BO 4.0

Professional Experience:

Bumble Bee (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 from BI 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.

Infinite Computer Solutions (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

Infinite Computer Solutions (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.

Contact this candidate