SUMMARY:

• 8+ years of Techno - Functional experience in SAP BW/BPC/FI/HANA/ABAP in developing functional and Technical modules in Financial Planning, Forecasting, Budgeting, Reporting and consolidation.
• End-end Implementation experience of driver based Sales and Operation planning including Product Volume, Revenue, COGS, Purchase, CAPEX, OPEX, HR planning, AR, AP, Inventory planning etc.
• Experience in Design, develop and implement business planning and Consolidation Structure.
• Experience in requirement gathering, blueprint, project plans, testing plans, contingency and cutover plans, and post-implementation support.
• Defined and agreed on deliverables and milestones with stakeholders and communicate to senior management.
• Experience on System Maintenance, Implementation, and production support.
• Implementation and Migration experience on SAP BPC 7.0, 7.5, 10.0, 10.1(Classic and Unified) BPC on HANA and to cloud on NW Versions.
• Exposure in Embedded BPC with office Analysis for reporting.
• Experience in Project tracking products like HPALM, TFS, REMEDY and SERVICE NOW on different stages of the requirement in Dev, QA and Production environment.
• Experience in Developing planning info cubes and configuring the info cubes to the Models
• Experience in assigning the aggregation levels to the planning models and developed the Query.
• Experience in Developing the input Query and accessing the Query to the EPM add-in for reporting and input forms.
• Experience in Developing the Fox formulas and debugging them.
• Experience working in Agile Methodology to design the scope of the sprint and deliver sprint in committed timeline.
• Handled pre and post migration, upgradation issues, tasks and critical production issues from Business side.
• Experience in product upgrade, patches and installations on various versions in BW and BPC.
• Worked on Enhancements, Change requests and performance tuning for AMS and Continuous Improvement projects.
• Experience in copying the Environment, created Models, Dimensions, Dimension Members, Hierarchies and Loading Master data and Transaction Data into BPC Applications using Flat File or from SAP and Non-SAP systems.
• Excellent hands on configuration and customizing skills in CostCenter Accounting, ProfitCenter Accounting, Profitability analysis and Internal Order.
• Developed Transformation and Conversion files to load the data to BPC through Data Manage packages.
• Worked extensively on Logic Scripts and BADI’s for Multi-Currency Translations, Allocation, and Business Calculations.
• Expertise in writing VBA, logic Scripts, SQL, MDX scripts.
• Created Backup and restore, optimization techniques as a part of weekly maintenance activity.
• Created Users, Data Access Profiles, Task Profiles, and Teams in Security
• Creating customized Input Schedules EVDRE Grid Reports with EVDRE formulas and Custom Templates, drill down, Drill through and adding Macros.
• Experience in configuring Time dependent Hierarchies in BW and BPC.
• Experience in Consolidation in Intercompany Elimination, Matching, Booking, Account transformation, Balance carry forward.
• Developed HCM Model and loaded the feed from People soft to BW and to BPC HCM model for Head Count Planning.
• Configured Drill through in BPC to drill down the data from BPC to BW for data reconciliation.
• Configured SPRO parameters in Model and Environment Level.
• Developed BADI’s for logic calculations and between Intra-App Applications data transfer.
• Developed Process Chains for retraction of data from BPC to BI using APD.
• Gather the business requirement and design the planning, forecast, budgeting requirements.
• Created Vale types in BW (Categories in BPC) for data loading on MTD, QTD and YTD data loading.
• Legal Consolidation reports: Income Statement Report, Balance Sheet report, Audit Report and Intercom any matching & elimination, Cash Flow report, Consolidated Summary of Operations and Consolidated Balance sheet by Company code etc.
• Automating month end process using Business process flows to facilitate users to close the month end reporting.
• Transported objects between the Environments (DEV, QA and Production)
• Supported on all system, server and Configuration Related issues.
• Worked on data extractions from heterogeneous Source System including SAP and non-SAP Systems.
• Created EPM Reports and Input forms using BPC Web, EPM-Excel interface, and ad-hoc reports.
• Extracted data from Source system (SAP ECC) or Non-SAP system using process chains and Data manager packages.
• Worked in the areas of GL, AP, AR & AA in Finance Module and CEA, CCA &PCA in Controlling Module.
• Experience in configuring SAP FI-GLFI-ARFI-AP, FI-BA, FI-AA, Cost Center Accounting and Profit Center Accounting during implementation.
• Worked on Customer Analysis including Payment History, Cash Discount Overview and Credit Limit Display.
• Expertise in ECC functional areas include SD, PP, PM, MM, FI, HR, AFS, CRM, SCM, APO and TPM to feed data to BPC.
• Worked on Credit Management and Customer Correspondence Periodic Statement, Invoice Processing and Reporting.
• Configured Account Determination required for integration of FI-SD (Order to Cash) to post billing and customer invoices.
• Created financial statement version, reports using financial information system. Enterprise Structure in Controlling: Setting up of controlling area, assigning company codes and creating standard hierarchy, creating CO version and defining control indicators.
• Created Cost Center Hierarchy, Profit Center Hierarchy, Created Cost Center Categories, Profit Centers, Activity Types and Statistical Key Figures.
• Experience in Profitability Analysis (CO-PA) created the operating Concern; Configured the Costing based profitability analysis. Defined and configured the reporting characteristics, value field and profitability segments used in profitability analysis.
• Designed specs for development of FI/CO Reports and Layouts. Generated reports using tools like Report Writer, Report Painter.
• Developed SAP BW Objects, applying Extended Star Schema modelling principles in Data Design, and used expert knowledge of data warehousing concepts.
• Expertise in converting the business requirements into Functional and Technical Documents and their design, and implementation of complex business requirement KPIs using SAP BW and also in native HANA modelling.
• Design of information models in HANA, interfacing with BO, Validation of data with ECC, Report Unit testing, Integration testing, system testing, presenting ROI to the users.
• Proficient in SAP BW modelling, Reporting and extraction. Extensively worked with SAP BW Data Sources, DSOs, Info Cubes, MultiProviders, Info Objects, Info Sets & APDs and ECC standard/Custom extractors, Strong expertise on Business explorer query design, and authorization setting for Queries.
• Worked on BWA index activities on info cubes and multi Providers for Query Performance.
• Designed, developed Multiproviders, aggregates, Filters, Planning functions and planning sequences.
• Developed applications using Input ready and Planning Sequence in MS Analysis for Office.
• Designed developed forms to capture Base Budget Adjustment, New Initiatives, and Ranking.
• Extensively worked on query development and formatting techniques in both BEx and Web Application Designer (WAD) of key BW reports and created Web Templates. Designed Info Sources, activated Pre/Post transformation rules, scripted extraction routines for master data, texts and hierarchies.
• Proficient in HANA Modelling, Schemas, Packages, Attribute Views, Analytical Views, Calculation Views with HANA LIVE, Attribute mapping, creation of calculated measures, calculated attributes, input parameters, Variables, Restricted measures, Constant columns, Currency Unit conversion, stored procedures and maintaining analytical privileges Data Provisioning using SLT and BODS meta data import. Involved in Export/Import of models, validations.
• Build complex BODS jobs to perform full/delta loads using Source/Target CDC techniques from SAP ECC to corresponding SAP HANA tables.
• Responsible for defining and documenting SAP BI HANA architecture, capturing and documenting functional (architectural) requirements, preparing estimates and defining technical solutions to proposals (RFPs).
• Expertise in developing complex queries by using Conditions, Exceptions, Variables, Structures, Restricted Key Figure, Calculated Key Figure, Formulas RRI Jump Queries, Ad-Hoc Queries.
• Created extensive use of complex transformations like SQL Query Transform, Table Comparison, Case, Validation, Merge, Map Operator, lookup etc. in Data flows.
• Worked on Process Chains to create and automate data load processes, Monitoring data loads and troubleshooting and fixing the load failures.
• Setup procedure for extracting R/3 data for Customers, Sales Order, Delivery in Sales, and Distribution (SD) using LO-Cockpit. Created info Cubes, DSO, Transformations, and DTP for Data Loading through Process chain from Source System.
• Created Operational Data Source (ODS) to integrate data from SAP R/3 via the Persistent Staging Area (PSA) for reporting purposes.
• Opened tickets with SAP and applied OSS notes as part of trouble shooting and problem resolution.
• Experience with HPQC and TFS ALM (Application Lifecycle Management) to track the status of the deliverables from Dev to Prod including Development, unit test (Dev), Functional & Regression test (QC team) and Acceptance test (Business).
• Experience with Remedy and Service Now to track the production issue based on the priority.
• Ability to co-ordinate collaborative efforts, meet deadlines and manage time efficiently. Hard working with a high level of motivation.

TECHNOLOGY:

Environment: SAP BI/BW 7.0, 7.3, 7.4 SAP BPC 7.0, 7.5, 10.0, 10.1 NW&MS, BEx 3.5, Office Analysis, ECC 6.0, 7.0, SAP FICO, SAP HANA, BO 3.1, 4.1, 4.2.

Programming Languages: SQL, MDX, ABAP.

Reporting Tools: SAP BPC, BOBJ, Lumera, Web I, BEx, Office Analysis, WAD, WEBI, Explorer.

Database: Oracle, SQL Server, (OLTP & OLAP), HANA. SAP BPC(Business Planning and Consolidation)

Environment: Dimensions, Security, Excel Reports, Dynamic Templates, Input Forms, data manager packages, Work Status, Transformation and Conversion files, BPC Functions, Custom menus, BPF’s, EVDRE and EPM Reports, input forms and BADI's.

PROFESSIONAL EXPERIENCE:

Confidential, Warsaw, IN

SAP BPC Solution Lead

Environment: SAP ECC, SAP BW 7.4, BPC 10.1, HANA, SAP ABAP, SAP FICO, Hyperion.

Responsibilities:

• Worked with acquired business team in understanding their current Business data structure and integrated it to the Zimmer BPC structure.
• Copied Environment and Created Models, Dimensions and maintained members and Hierarchies in Dimensions.
• Developed various data extraction procedures for master data attributes, texts and hierarchies and transactional data.
• Worked on creating the Logic scripts for the business calculations.
• Developed the BADI’s (Writ Back BADI’S and Custom Logic BADI’s) and routines to execute in BW transformations and Transformation files in BPC.
• Created Transformation and conversion files to map the data with BW and Flat files.
• Extensively worked in SAP BW Data Extraction from Multiple SAP and Non SAP (Legacy) Systems using Generic Extraction procedures and loading of master data and transaction data using flat files.
• Configured Extractors to extract the Actuals data from ECC to BW to Load it to BPC.
• Worked on the requirements and performed the unit testing and moved them to QC for validation.
• Created Process chains to load the data to BW from other source systems and schedule them BW to load to BPC.
• Created Info cube, DSO, Transformations, DTP, Composite providers, ADSO and Process chains in BW.
• Developed custom Logic BADI to retract the data from BPC to BW DSO for Reporting in WebI.
• Created Analytic and Calculation views in HANA to map the extracted data(DSO) with the GBI and SAH source in DSO(Extracted from BPC)
• Developed WebI reports on HANA views for data extracted from BPC for reporting to acquired business team.
• Created the process of archiving the Flat files in AL11 using custom logic BADI based on the source path to all the acquired companies.
• Developed Logic scripts, Dynamic scripts in Data manager packages to set the prompts and pass the variables to Custom Logic BADI from Logic scripts
• Created EPM reports and input forms using EPM functions and Developed VBA to perform the functionalities like refresh, Input enable cells, copy the data from multiple reports within the report, Save, Refresh and Expand, dynamic selection and several functionalities for multiple sheets for reports and Input forms within the workbook.
• Created reports in office analysis in BPC for reporting (using composite providers and ADSO).
• Created BEx queries, variables, restricted variables, filter and prompt in the query to have the user selections in analysis office.
• Developed macros and VB scripts for Analysis office Reports.
• Created composite providers in BW Modelling in HANA to add the HANA view (data from other source systems) in the composite provider and mapped the required fields from source to target (BPC Fields) to extract the data from HANA View to Composite Provider.
• Created reports in Office Analysis based on the composite provider data.
• Created the process to automate Master data and add the non-existing members in BPC dimension on the fly using BADI’s and Routines (start Routine and END Routines) in transformation files.
• Created Backup and Restore of master data and Transaction data.
• Conducted s to Business in understanding the solution and help them validate the user testing (UAT) and deploy to production.
• Configured Security and Work status for maintaining the users after data submission as part of planning process.
• Worked on FI Consolidation and managed the eliminations in BPC to generate the Income statements and Balance sheets.
• Created Reconciliation reports for data push from BW to BPC between Info cube, BE x report and from EPM Reports.

Confidential, Green Bay, WI

SAP BPC Techno-Functional Lead

Environment: SAP ECC, SAP BW 7.4, BPC 10.1, HANA, BODS, SAP ABAP, SAP FICO, Hyperion, ESSBASE.

Responsibilities:

• Worked with Project owners and business to understand the Business process and gathered requirements based on the current Hyperion design.
• Developed Blue print to design the project structure and integration with SAP and Non-SAP systems to design the Business process based on the current design and requirements.
• Copied Environment from Environment shell, Models and Dimensions including maintenance of dimension members, Hierarchies and dimension properties.
• Developed the automation structure to load the master data to dimensions from SAP and Non-SAP systems.
• Developed BADI’s and Logic Scripts on top down and bottom to top allocation in Budgeting process.
• Developed Logic Scripts, maintained BADI’s and Configured Business Rules for Business calculations.
• Extracted data from Source system (SAP ECC) for actuals to BPC using process chains and Data manager packages.
• Mapped the chart of accounts for source system to BPC using the transformation in BW and Transformation and conversion files in BPC.
• Developed Info cubes, DSO, Transformations, Info Packages, DTP, Info Source, Process Chains in BW to load the data from SAP and NON-SAP systems.
• Loaded master data to dimensions from BW info objects and Transaction data to models through BW info cube, flat file and from other non-SAP source systems.
• Configured BW Extractor to retrieve FI-GL, AR, AP data from ECC to BW cube.
• Created Reconciliation reports for data push from BPC to BI and from BI to BPC between Info Cube, Bex report and from EPM Reports.
• Created Management Book reports and published them using the Book Publications and generated PDF for top level business reporting and for reconciliation purpose.
• Created Transformation and Conversion files to import data into BPC from source system and Flat files.
• Created Input Forms and Reports using EPM Functions.
• Configured Consolidation of Intercompany Matching, Elimination and Balance carry forward rules
• Developed logic Script toto run the eliminations and post the elimination entries for Elim accounts.
• Posted journal adjustments for the Intercompany Eliminations to balance the Net amounts and Liabilities for Balance sheet and Expenses for Income statements.
• Worked on BPC transport activities of the Scripts, Templates etc., across different servers.
• Created the user profiles and provide the access as per requirement.
• Developed reports based on by entity for elimination in Balance sheet and Income statements for MTD, QTD, YTD reporting.
• Experience in configuring SAP FI-GLFI-ARFI-AP, FI-BA, FI-AA, Cost Center Accounting and Profit Center Accounting during implementation.
• Created sales area in SD and loaded the data FI-AR data to BW and to BPC
• Created Company codes, Cost Centers and Functional areas in FI.
• Created cost center groups under the standard hierarchy, creation of cost centers including collection cost centers and allocation cost centers, creation of secondary cost elements. Setting control parameters for actual posting, Allocation characteristics for sender/receiver cost, Configuration of Assessment, distribution and reposting.
• Creation of Chart of Depreciation, Defining Assets class, Account determination, Creation of Asset, Retirement of assets, In-house creation of Assets, Depreciation run .
• Configured House Banks, Bank Accounts, GL Structure, and Posting Rules for automatic assignments
• Loaded the data from Non-SAP system by creating BODS jobs and loaded the data to HANA to perform joins using Calculation views and from HANA loaded the data to BW Info Cube and to BPC using standard Info provider load procedure.
• BW on HANA route was used for Inventory implementation and in the process, developed Info objects, DSO’s, Info Cubes, Multi Providers, Transformations/Update Rules with ABAP routines, Data sources/Info sources, Info sets, Open Hubs, APDs, Process Chains, DTP’s, Info packages, BEx Queries
• Created BODS job to extract Master data and transaction data from other systems to load them to BW application server and used the data manager package to load them to BPC.
• Created the process chains to schedule to run the BODS jobs that will fetch the data to BW and BW application server and scheduled data manager packages to load them to BPC as a part of daily schedule automation.
• Experience in HANA Modelling Schemas, Packages, Attribute Views, Analytical Views, Calculation Views with HANA LIVE.
• Worked on SLT and SDA(Smart data Access) in replicating the tables from DB to HANA studio.
• Created Universe in IDT from Column views using aggregates and measures and published universe to BO for WebI and Explorer reporting.
• Created BODS job by performing aggregation, joins and group by activities and loaded the table from ODS to HANA as a part of ETL extraction.
• Familiarize the team with the customer needs, specifications, design targets, the development process, design standards, techniques and tools to support Business.
• Created reports, cross-tab reports using WebI rich client by utilizing prompts, alert and provided Executive Summary report of Managers and representative performances to Directors as dash boards in Xcelsius bound to Live Office using prompts.
• Experience in HPALM in tracking the project requirements in Development and testing.
• Involved in preparing the functional and Technical spec. Documents and trained the users to gain high-level knowledge about BPC system.

Confidential, Orlando, FL

SAP FI/BPC Lead Consultant

Environment: SAP ECC, SAP BW 7.4, BPC 10.1 Classic, 10.1 Embedded, HANA, BODS, SAP ABAP, SAP FICO, ESSBASE.

Responsibilities:

• Worked in Agile methodology of delivering the sprints for Enhancements and change requests in committed time line.
• Experience in requirement gathering, Design and development of Reports and input templates.
• Performed unit testing, designed technical and functional documentation for newly designed integration and EPM Templates as a part of change request.
• Experience in Loading (Full /Initial/Delta) Transaction data and Master data (Text, Hierarchies, Attributes) from SAP and NON-SAP Systems.
• Experience in Extraction and Retraction of data to BPC from SAP and Non-SAP systems, like BW,BODS,FTP,HC Tool.
• Created info provider in BW to load Actual data from ECC to BW and to BPC using FI GL 16 Extractor and loaded to BPC Model using Delta initialization.
• Loaded the tangible Assets from FI to calculate Depreciation in BPC in CAPEX planning
• Created Process Chains, Data manager packages and Package links and scheduled them for daily loads.
• Worked on BEx Query Designer in designing queries using filters, variables, navigational attributes and structures to facilitate flexible, detailed drill down data analysis to required level of information.
• Developed complex Logic scripts and Member formulas
• Developed Hybrid Info Providers, Composite Info Providers, Input Query for Integrated Planning.
• Performed HR planning in Embedded BPC using RSPLAN in NW 7.4 and reporting in BEx and EPM.
• Developed Fox Formulas in BW to perform BPC business calculations and replace of Logic Scripts for better performance.
• Experience in developing the Write back BADI’s in logic script and troubleshoot them.
• Experience in creating the Routines and configuring them in Transformation files for Data extraction
• Created Transformation and Conversion files for data Extraction and Retraction process in BPC.
• Experience in troubleshooting the default logics and custom logic BADI’s using the EPM templates.
• Worked on intra Model data transfer using Destination APP.
• Extracted FI-GL, AR, AP, AA data from FI to BW and loaded to BPC using load Infoprovider.
• Maintained customer master records, configured the system for daily accounting transactions, worked on closing procedures for post value adjustments and balance carry forward program in Accounts Receivable (A/R).
• Processing, Calculation procedure, Tax jurisdiction codes Configuration for TAXUSX and Knowledge of tax interfaces with Vertex and Tax ware.
• Integrated Asset Accounting, structured and valuated Fixed Assets.
• Involved in the designing of Asset Class, Charts of depreciation, inter-company asset Transfers and balance-carry forward jobs, depreciation areas, depreciation keys, Calculations/reporting and Year-end closing in fixed assets. Designed and configured Asset Accounting to carry out business transactions like acquisitions, retirements and Transfers.
• Loaded the data to HANA from Oracle DB by creating BODS job and developed attribute, Analytical and calculations views in HANA and loaded the column view to BW and to BPC.
• Replicated table ECC to HANA using SAP SLT.
• Worked on creating the crystal reports using BPC data that is exported to BW and to IDT to create BO universe.
• D eveloped Info objects, DSO’s, Info Cubes, Multi Providers, Transformations/Update Rules with ABAP routines, Data sources/Info sources, Info sets, Open Hubs, APDs, Process Chains, DTP’s, Info packages, BEx Queries.
• Worked on work status, security, DM Packages and DM Package Links.
• Worked on EPM add- in upgrade activity.
• Worked on defined process on service desk documentation for the generic user issues.
• Worked with SAP by creating OSS messages on the product issues and implemented the Suggested solution.
• Worked with QC team to help them understand requirement to design the test cases and perform Functional and Regression test.
• Conducted demo’s to the client to help them understand the design and functionality of the new change request.
• Worked on TFS in scoping the sprint and gathering the requirements.
• Experience in integration the team to ensure 24/7 support to business users.
• Experience in performing maintenance and housekeeping activity to improve the system performance.
• Experience in system data backup(TD & MD) and performing the Restore if necessary in NP systems.

Confidential, Fort Lauderdale FL

SAP BW/BPC Sr. Developer

Environment: SAP ECC, SAP BW 7.4, BPC 10.1, HANA, SAP FICO, SAP ABAP.

Responsibilities:

• Work ed with business owners to develop, deploy and support of financial reports for Legal consolidations, Expense Planning areas in BPC.
• Copied Environment and Created Models, Dimensions and maintained members and Hierarchies in Dimensions.
• Developed various data extraction procedures for master data attributes, texts and hierarchies and transactional data.
• Created Transformation and conversion files to map the data with BW for data loads.
• Extensively worked in SAP BW Data Extraction from Multiple SAP and Non SAP (Legacy) Systems using BI Content Extractions LO(SD, PP, PM), FI/CO, SEM, Flat File, and Generic Extraction.
• Worked in designing inbound interfaces to post PO/Non-PO based invoices from legacy systems using BAPI and IDOCS.
• Integrated AP with MM and AR with SD modules with respect to account determination for various clearing and adjustment accounts.
• Customized settings for controlling areas, activated the components/ indicators, assigned the company codes to controlling areas, assigned number ranges.
• Experience in processing inbound/outbound interface files through Process integration (PI/PO), encryption process and file transmission using FTP/SFTP.
• Extracted data from ECC to BPC using Delta by Delta utilization in BPC.
• Created Vale types in BW (Categories in BPC) for data loading on MTD, QTD and YTD data loading.
• Identified the data sources that are required for consolidations in BPC and extracted the data from corresponding BI Cube.
• Experience in working with BW teams to build Vendor open item due report, customer past due report, P&L reports and other reports requested by business.
• Created Backup and Restore of master data and Transaction data between Dev, QA and Prod
• Created complex Logic scripts and BADI’s for Business calculations.
• Worked on intra Model data transfer using Destination App.
• Developed BADI’s for intra application data transfer, clear and for other Business calculations.
• Created data partitioning as a part of Performance tuning.
• Configured Security and Work status for maintaining the users after data submission as part of planning process.
• Worked on FI Consolidation and managed the eliminations in BPC to generate the Income statements and Balance sheets.
• Created info provider in BW to load Actual data from ECC to BW and to BPC using FI GL 12 Extractor.
• Created process chains and configured them to Data manager packages.
• Worked on BEx Query Designer in designing queries using filters, variables, navigational attributes and structures to facilitate flexible, detailed drill down data analysis to required level of information.
• Designed making extensive use of the ODS capabilities, delta management functionality and optimal use of update rules keeping query performance in view.
• Developed input forms and Reports using EPM functions.
• Created Reconciliation reports for data push from BW to BPC between Infocube,Bex report and from EPM Reports.
• Worked on both the managerial and legal Consolidation,like consolidation of investments,GAAPS and IFRS.
• Worked on Consolidation monitor,ownership Manager and consolidation of currency conversion.
• Worked on Intercompany Elimination,Matching,Balance Carry forward rule,Account Transformations and currency conversions.
• Created Complex Reports like P&L Statements, Balance Sheets, Cash flows and 10K reports.
• Configured logic scripts and Business rules for consolidation process.
• Configured currency conversion and reporting currencies like LC, USD and Group currencies.
• Configured Intercompany Eliminations, Matching, Carry forward rules and Account transformation.
• Worked on HPALM in tracking the requirements in both the Development and testing environments.
• Worked on Performance tuning, Trouble shooting, and fixing issues on Data loads and business process.
• Worked with SAP on Product issues and coordination with BASIS to open the connections or applying SNOTES.
• Performed Housekeeping activities to improve the system performance.
• Maintained BPC parameters (Global, Environment, and Model) to keep the system aligned.
• Worked with COE team, End users and Support team for the issue in Data loads, Reports, Business process, Performance, enhancements and Break fixes.

Confidential, Irving, TX

SAP BW/BPC Sr. Developer

Environment: SAP BPC 10.1 NW, SAP BW 7.4, ECC 6.0, SAP FICO, SAP HANA, SAP ABAP, Analysis Office.

Responsibilities:

• Copied Environment from Environmentshell, Models and Dimensions including maintenance of dimension members, Hierarchies and dimension properties.
• Worked on top down and bottom to top allocation in Budgeting process.
• Developed Logic Scripts, maintained BADI’s and Configured Business Rules for Business calculations.
• Extracted data from Source system (SAP ECC) using process chains and Data manager packages.
• Loaded master data to dimensions from BW info objects and Transaction data to models through BW info cube, flat file and from other non-SAP source systems.
• Configured BW Extractor to retrieve FI-GL, AR, AP data from ECC to BW cube.
• Created Transformation and Conversion files to import data into BPC from source system and Flat files.
• Created Input Forms and Reports using EPM Functions.
• Configured Consolidation of Intercompany Matching, Elimination and Balance carry forward rules
• Worked on BPC transport activities of the Scripts, Templates etc., across different servers.
• Created the user profiles and provide the access as per requirement.
• Created Reconciliation reports for data push from BPC to BI and from BI to BPC between InfoCube, Bex report and from EPM Reports.
• Defined Fiscal year variants and assigned them to various company codes.
• Configured posting period variants, posting keys, number ranges, document types, field status groups and tolerance group
• Configured chart of accounts, account group, G/L account master records. Created sample accounts and configured field status groups.
• BW on HANA route was used for Inventory implementation and in the process, developed Info objects, DSO’s, Info Cubes, Multi Providers, Transformations/Update Rules with ABAP routines, Data sources/Info sources, Info sets, Open Hubs, APDs, Process Chains, DTP’s, Info packages, BEx Queries
• HANA Modelling: Schemas, Packages, Attribute Views, Analytical Views, Calculation Views with HANA LIVE.
• Created reports, cross-tab reports using Webi rich client by utilizing prompts, alert and provided Executive Summary report of Managers and representative performances to Directors as dash boards in Xcelsius bound to Live Office using prompts.
• Worked on SLT and SDA(Smart data Access) in replicating the tables from DB to HANA studio.
• Created BODS job by performing aggregation, joins and group by activities and loaded the table from ODS to HANA as a part of ETL extraction.
• Created Universe in IDT from Column views using aggregates and measures and published universe to BO for WebI and Explorer reporting.
• Involved in preparing the functional and Technical spec. Documents and trained the users to gain high-level knowledge about BPC system.
• Worked on Remedy for the enhancements, break fixes in development and test environment.
• Familiarize the team with the customer needs, specifications, design targets, the development process, design standards, techniques and tools to support Business.

Confidential, Chicago, IL

SAP BW/BPC Sr. Developer

Environment: SAP BW 7.3/7.4, BPC 10.0/10.1, SAP ABAP, SAP FI, SAP HANA.

Responsibilities:

• Worked on development of Environment, Models and Dimensions including maintenance of dimension members and dimension properties.
• Loaded master data to dimensions through master data automation and Transaction data to models through BW infocube, flat file and from other non-SAP source systems.
• Created Transformation and Conversion files for data loads
• Developed Logic Scripts and BADI’s for Business calculations
• Migrated BPC 10.0 to 10.1 on HANA classic NW version.
• Trained End users on the latest versions and involved in UAT with users for Defect tracking.
• Experience on post GO-Live activities and implementation of SNotes.
• Created process chains and Data Manager Packages and automated the data load.
• Transported BPC object through interfaces (Dev, Quality, Production) through Transport connection in BW and maintained in sync.
• Created EPM Reports like P&L statements, Cash flow, Balance sheet and input forms
• Created users and assigned to the users to Teams, Task profiles, Data access profiles.
• Extracted data from Source system (SAP ECC) using process chains and Data manager packages.
• Build complex BODS jobs to perform full/delta loads using Source/Target CDC techniques from SAP ECC to corresponding SAP HANA tables.
• Created Consolidation reports: Income Statement Report, Balance Sheet report, Audit Report and Intercom any matching & elimination, Cash Flow report, Consolidated Summary of Operations and Consolidated Balance sheet by Company code etc.
• Data extraction from ECC to BW using different extraction structures such as LIS,LO-Cockpit configuration and customization, MM,FI-CO, New GL, Master Data, Hierarchies and Generic Extractors.
• Created Web Reports, Ad-hoc Reports and reconciliation between BPC and BW to check the data load.
• Worked on Intercompany reconciliation and made enhancements to financial statement.
• Worked on SAP BW modeling, Reporting and extraction. Extensively worked with SAP BW Data Sources, DSOs, Info Cubes, MultiProviders, Info Objects, Info Sets & APDs and ECC standard/Custom extractors, Strong expertise on Business explorer query design, and authorization setting for Queries.
• Created HANA Modeling, Schemas, Packages, Attribute Views, Analytical Views, Calculation Views with HANA LIVE, Attribute mapping, creation of calculated measures, Calculated attributes, Input parameters, Variables, Restricted measures, Constant columns, Currency Unit conversion, stored procedures and maintaining analytical privileges Data Provisioning using SLT and BODS meta data import. Involved in Export/Import of models, validations.
• Design of information models in HANA, interfacing with BO, Validation of data with ECC,Report Unit testing, Integration testing, system testing, presenting ROI to the users.
• Performed reporting in, Month-End closing Quarter-End Closing and Year-End Closing.

Confidential, Lexington, KY

SAP BW/BPC Consultant (Tech Lead)

Environment: ECC 6.0, SAP BW 7.3, BPC 7.5/10.0 NW on HANA, SAP ABAP Cloud NW Version

Responsibilities:

• Created EPM reports and Input forms.
• Created Backup and restore, optimization techniques as a part of weekly maintenance activity.
• Transported objects between systems and keeping them in sync
• Migrated 7.5 to 10.0 to BPC on HANA and post Go-live activities and support.
• Involved in UAT in QA system and trained end users for Defect tracking.
• Data Modelling between BW and BPC System.
• Created Process chains, APD Routine, info cubes, Multi Providers, DSO, DTP, Transformations, and BW Queries.
• Extracted data from Source system (ECC) or from NON-SAP system to BPC.
• Created Transformation and Conversion files to import data into BPC from source system.
• Created Vale types in BW (Categories in BPC) for data loading on MTD, QTD and YTD data loading.
• Created Reconciliation reports for data push from BPC to BI and from BI to BPC between Info cube, BEx report and from EPM Reports.
• Designed script logic and worked on business rule for Currency Conversions.
• Created HANA Modelling, Schemas, Packages, Attribute Views, Analytical Views, Calculation Views with HANA LIVE, Attribute mapping, creation of calculated measures, calculated attributes, Input parameters, Variables, Restricted measures, Constant columns, Currency Unit conversion,
• Scheduling the BPC jobs and monitoring those from BW and BPC end to complete successfully.
• Created custom specific dynamic and static reports, schedulers and live reports and input forms.
• Involved in Client interactions and processed the needs as per the Business Requirement.

Confidential, Mount Laurel, NJ

SAP BPC Developer

Environment: s: ECC 6.0, SAP BW 7.3 BEx 3.5 BPC 7.0/7.5 Versions

Responsibilities:

• Worked on development of Application Sets, Applications and Dimensions including maintenance of dimension members and dimension properties.
• Designed Sales application and, Capex applications.
• Worked on Conversion and Transformation files and Data manager for loading data into BPC.
• Created various Reporting (Finance, Sales) & Non-Reporting Applications (Rate) for planning purposes.
• Migrated 7.0 to 7.5 NW version, involved in UAT testing, USER, and all Tasks as per the Migration Plan.
• Involved in developing Multiproviders, aggregates, Filters, Planning functions and Planning sequences.
• Developed applications using Input ready and Planning Sequence in MS Analysis for Office.
• Developed several planning functions based on Fox Formula.
• Developed applications using Input ready and Planning Sequence in MS Analysis for Office.
• Created EVDRE Reports and input schedules.
• Created data manager packages and configured the packages to process chains and schedules for data load.
• Created reconciliation reports for data loads from BW to BPC.
• Legal Consolidation reports: Income Statement Report, Balance Sheet report, Audit Report and Intercom any matching & elimination, Cash Flow report, Consolidated Summary of Operations and Consolidated Balance sheet by Company code etc.
• Worked extensively with Script logics especially around allocation.
• Worked extensively on EVDRE functions.
• Granted access to specific applications using security setup.
• Customizing business rules and automates the consolidation of investment process.
• Working knowledge on Transports to move data from Development environment to Production environment.
• Worked extensively with Script logics especially around allocation.
• Worked on work status, security, and Data Manager Packages.

Confidential

SAP BW/BO/BPC Developer

Environment: s: ECC 6.0, SAP BW 7.3 BEx 3.5 BPC 7.0MS, 7.5 NW Versions

Responsibilities:

• Involved in creation of Info providers, Info sources, data sources, transformations.
• Integrated BOBJ with BEx for front end reporting, Created Web intelligence reports using Information Design Tool.
• Created Applications, Dimensions, Members and Data manager packages in BPC.
• Worked on script logics for Business calculations in BPC.
• Configured currency conversion using business rules.
• Created data manager packages and configured the packages to process chains and schedules for data load.
• Created reports and input schedules using EVDRE functions.
• Developed various data extraction procedures for master data for attributes, texts and hierarchies and transactional data.
• ABAP programming for start routines, end routines, currency conversion, User Exits.
• Scheduled delivery of reports, ad-hoc execution of reports, metadata, drill-downs/through.
• Involved in Migrating BPC 7.0MS to 7.5NW version.
• Loaded transaction data from MS version to NW version using FTP.
• Worked on SQL scripts to reconcile the data after the migration with BEx report.
• Responsible for business validation and resolving issues during UAT/QA testing and Go-Live and Hyper-Care Support.
• Diagnose complex problems, perform issues analysis and propose solutions and or provide recommendations
• Developed the Technical and unit Test Script Document.
• Created Ad Hoc Queries for the end users and trained the end users in performing the slicing and dicing functionalities.
• Offshore co-ordination for Issue Resolution.
• Worked constantly with SAP OSS and communicating back and forth with SAP and fixing the issues and problems successfully, which cropped during the up gradation and re-development process.
• Build/maintain process chains to load the data build and Maintain Process chain for Data Loads.
• Created global objects Restricted key figures and Calculated Key figures, Formulas, variables.
• Post live support and ongoing support.

Confidential, Dearborn, MI

SAP BI/BW Developer

Environment: SAP ECC 6.0, BI/BW 7.0/BEx 3.5 Version

Responsibilities:

• Assist Business Process Leads and Subject Matter Experts in initial high-level requirement definition and gathering.
• Responsible for the deliverables for Data source development, Enhancements, design and development of End to End BI solution.
• Worked with MM, SD, PP (Production planning) and FI extractors those are 2LIS 11*, 2LIS 12*,2LIS 13*, 2LIS 03* Extractors and also Finance Extractors 0FI GL 4, 0FI AP 4, 0FI AR 4.
• Created functional requirement gathering and BRD (Business Requirements Document Review) and ensure that system design meets business requirements.
• Diagnose complex problems, perform issues analysis and propose solutions and or provide recommendations.
• Worked on creating start routines and end routines in update rules to ensure proper loading of data.
• Consolidate regional reporting systems into a single analytics system, reducing duplication of efforts and resources
• Responsible for business validation and resolving issues during UAT/QA testing and Go-Live and Hyper-Care Support.
• Worked on Inventory cubes for business content DS. Analysed the requirements to implement Snapshot scenario for cumulative key figures. Worked on 2LIS 03 BX and 2LIS 03 BF Data Sources.
• Maintained extract structures for Purchasing, Inventory and Sales & Distribution. Generated data sources & activated the extract structures for the above modules. Scheduled data uploads in cockpit.
• End User Support by handling issues specific to all global and local BW reports.
• Developed the Technical and unit Test Script Document.
• Created Ad Hoc Queries for the end users and trained the end users in performing the slicing and dicing functionalities.
• Troubleshooting the Reporting Issues by Interacting with End Users.