CERTIFIEDC

INDRASENA

SUMMARY: 248-***-****

SAP certified professional with 15+ years of overall experience with extensive multiple global Implementations, roll outs, upgrades and supporting client’s SAP systems in Finance space BPC BI Functional/Technical Skills

• Proficient in design, configuration and deployment of Planning and Consolidation solutions using SAP BPC NW 10.1/10/7.5/7.0 with end-end integration with ECC.

• Developed project plans, statement of works, blueprinted the requirements, architecture and design diagrams, realization plans, testing strategies, design, transport and system check out procedures, go-live checks.

• Experienced in Reporting, Data Modeling, Data Extraction and Performance Tuning.

• Strong Expertise in extracting data from SAP ECC (LO Cockpit, Finance, COPA, SL, HR).

• Developed highly flexible data models to handle complex business reporting requirements using Info sets, Multi Providers, Remote Cubes, Cubes and DSO Info providers

• Data Modeling, Data Extraction, Generic Extraction, Data Loading (Full /Delta Up-Load), Scheduling, Monitoring, Info-objects, Info-cubes, Info-Source, Hierarchies, Logical Information System, LO Cockpit, Multi-Cubes, ODS objects, Process Chains.

• Understanding of Finance strategy and operations within targeted industries and consulting service lines

• US GAAP, IFRS, FASB Knowledge

• Strong team management skills with excellent communication skills, interpersonal, analytical / problem solving skills, motivated teams, a quick learner with excellent work ethics, team oriented with strong analytical.

• Leadership qualities and organized teams for producing high quality work. SAP BPC

• Requirement gathering; translating the requirements into BPC BI specific mapping; analyzing AS-IS Business processes; specifying TO-BE design.

• Prepared Business Requirement Documents (BRD), Business Blue Print (BBP) and Application Design Documents (ADD’s).

• Creation of Application Set, Dimensions, Properties and maintaining members, Applications and applying Dimensions, Business Rules, Transformation, Data Load

• Script Logic Programming (Dimension & Worksheet) for Currency Conversions, Inter Company Eliminations, Security Set up (Task Profile, Member Access Profiles, Users and Teams), Work Status Settings, Business process Flows (BPF).

• Loading Transaction Data using a Flat File, NW BI Info Cube using Standard Data manager Packages.

• Creation of EPM/EVDRE (dynamic & static Reports) reports to optimize the reporting Capabilities, Input Schedules for entering data and Live Reports.

• Set Up of Currency Conversions, Inter-company Eliminations

• Planning (SG&A,S&OP,FP&A,APO)

SAP BI

• Implementation & Up gradation Experience on BI7.0/7.3

• BW Modeling – Requirement gathering; translating the requirements into BW specific mapping; analyzing existing business processes; specifying design.

• Strong experience in Info Cube (Real-Time Cubes, Basic cubes, Multi-cubes & Remote cube) design, Info Sources, Info Object maintenance, ODS Objects, Aggregates, Process chains, BEx Analyzer,

CERTIFIEDC

• Experience in creation of Master and transaction Data Sources by using views/tables & SAP Queries, Data source Enhancements, variable exits for BEx Reports & Routines in Update rules and Transfer rules as per client requirement.

• Reporting Authorizations, Authorization Objects & Roles.

• Skills to write Routines as per design & debug the ABAP Routines.

• Customizing using of variables, various planning functions.

• Process chain maintenance for day today schedules. EDUCATION:

Bachelors in Engineering

Masters in Business Administration

SAP Certified Business Objects Planning and Consolidation 10.0 SAP Certified HANA 1.0

Certificate ID: 000*******

• SAP Simple Finance on S4/HANA SAP Academy training TECHNICAL SKILLS:

EPM: SAP BPC 7.0/7.5 NW MS EPM (BPC) 10.0/10.1MS and NW version. SAP Technical: SAP FIORI SAP BPC 7.5, EPM 10, SAP HANA 1.0 and SAP BI NW Business Intelligence: SAP HANA BW 7.3/7.0, 3.5/3.1/3.0 DATABASE: MS Access, SQL Server, DB2, HDB and Oracle. ERP: SAP Simple finance, S4 HANA, SAP ABAP/BADI’S/ ECC 6.0, R/3. Others: MS-office, MS Excel, VB, Macros, Power Point, VISIO, Project. Methodology: Agile, Pivotal Tracker, ALM

EXPERIENCE:

HOME DEPOT

Sr SAP BPC Lead Consultant Nov 2015 to Till date

Environment: SAP BPC 10.0/10.1 NW/BW 7.3/7.5 HDB, Linux Role: Sr SAP BPC lead

Responsibilities/Deliverables: BPC 10.1/10 NW Planning and forecasting Development and production support.

Project Description: THD_IT_Finance, THD_Capital/Finstats, THD_Marketing/HD.com/FINANCETHD Environments/Models

NTT DATA Boston MA USA Nov 2012 Mar 2015

PROJECT SYNERGY CONSOLIDATION

Sr SAP BPC Lead Consultant

Environment: SAP BPC 10 NW/BW 7.3/AIX/DB6

• Requirement Gathering, Blue Print Documentation

• Functional/ Technical Spec Documentation

• Extracting Data Source FIGL_10(Leading ledger) from ECC and Replication in BW CERTIFIEDC

• Create BW cube using Standard Info Objects, DSO/Transformations/DTP

• Create BPC Legal Consolidation Cube Using Custom Info Objects

• Extracting Master Data/Hierarchy/Transactional Data from Source System (ECC to BW)

• Create Model Consolidation/Finance/Rate/Ownership

• Create Required Dimension for Consolidation/Rate/Ownership Model

• Loading Master Data/Hierarchy/Transactional Data Using BPC Data Manager

(Transformation/Conversion Files) BW to BPC

• Create Custom Data source ZTCURR for FOREX rates

• Build Custom Process chains to Automate Master Data/Hierarchy/Transactional Data From ECC to BW to BPC

• Currency Conversion/IC Elimination Using the Script Logic

• Carry forward Balances/Data collection/Validation of Financial data

• Reconciliation of Data from ECC to BW to BPC,

• Reconciliation of Balance issues

• Create Test Scripts for Business to Validate the Reports

• Drill Through BPC to ECC

• Create Financial/Management Reports

• Create Consolidation Reports

Bank of America LA CA USA Nov2011 –Oct 2012

(BALBOA/QBE Insurance)

SAP BPC consultant

Environment: SAP BPC MS 5.1/7.5 (UPGRADATION)

• Replication of BALBOA Application set (Actuals, Allocation, and Plan) In Outlook soft 5.1 to QBE (Actuals, Allocation, and Plan)

• Involved in LLD/HLD Design and Documentation Up gradation of Outlook soft 5.1 to SAP BPC MS 7.5

• Data from MIRD-BALBOA Staging-SQL server loaded to BPC cube with Data manager packages

• Data Upload Structure with conversion & Transformation Logic

• Converting old reports (EVGTS) static to EVDRE Dynamic reports

• Build PL Consolidate/BS/TB/Trend/Variance Reports using EV functions

• Build Reports from multi dimensions in rows/Columns with Nested Expansion

• Build Input Schedules using EV functions

• Interacting with the team and the users to get the desired inputs

• Map the Loads and integration with SQL Server Data

• Worked with Default/allocation for script logic. DAIICHI-SANKYO NJ USA March 2011 – Oct 2011

SAP BPC consultant

Environment: SAP BPC NW 7.5

Daiichi Pharma BPC Planning and Consolidation

• Planning Project Design and Documentation

CERTIFIEDC

• Reports and Input templates design and build

• Setting up the Legal, Ownership and Rate application

• Setting up the Entity groups and dynamic hierarchies for defining the ownership.

• Setting up the currency translation rules.

• Setting elimination rules for consolidation.

• Created the business rules for Carry forward balance, validation, Account calculation, Inter company Elimination.

• Created journal templates for passing inter company entries.

• Defined the script logics for Currency conversion, Carry forward balance, Account calculation, Inter company Elimination

• Conversant with EV functionalities, EVDRE, EVPRO, EVCVW, EVTIM, EVMNU, etc

• Map the Loads and integration with SAP ECC data

• Analysis interacting with the team and the users to get the desired inputs

• Maintenance and Building new Objects within BPC and BI

• Maintain User access association to BPF to mimic custom menus Hoshan Pan Gulf (HPG) Aug 2010 – Jan 2011

SAP BPC consultant

Environment: SAP BPC NW7.0 Sales Planning Implementation R/3, ECC 6.0, SAP-BI FI, CO Integration, Sales Planning and Implementation in BPC

• Developing Customer specific data model with Dimensions & Applications along with Dimension and application Parameters

• Setting up Work Status, Designing the BPC Security.

• Configuration of Work flow using Custom Menu

• Design Data upload structure with transformation & conversion logic.

• Worked with allocation for script logic.

• Moving data from one application to another application using BADI.

• Developed extraction plans and worked closely with ETL to retrieve the desired data from ECC

• Developed customized Input Schedule, like Cost Center Planning Schedule, HR Input Schedule, Opex Data input schedule

• Developed Customer Specific Dynamic & Static Reports

• Conversant with EV functionalities, EVDRE, EVPRO, EVCVW, EVTIM, EVMNU, etc

• Create Input Schedule to upload the planned data into different application.

• Use EVDRE function to create dynamic report.

• Developed Nested Report, Comparison Report with different EV Functions.

• Run Allocation function to allocate sales dollar amount to different entities on the basis of the parameter defined.

Safety Kleen, Dallas, TX May 2009 to Jun2010

BI CONSULTANT

Project: Upgrade to BI 7.0 (Technical & Functional - Front End and security alone) Safety Kleen is the leading provider of cleaning, environmental and re-refining solutions. Key activities Performed:

• Made sure the BI object are in active state before PREPARE is complete. CERTIFIEDC

• After Upgrade, we made sure the BI global settings are complete.

• Ran the SAP recommended HASH Jobs (3) to ensure that the old PSA's And requests were hashed into the new table for enhancing the performance.

• SSO (Single Sign-On) between Portal and BI is complete and working.

• Established the custom branded web template for web reporting.

• Customized the Portal Theme to suite the Clients branding theme.

• Upgraded the Front End GUI to 710 SPS 2.

• Migrated 3.x Queries to 7.x Queries individually.

• Migrated 3.x web Reports to 7.x formats.

• Migrated 3.x reporting variants to 7.x format.

• Switched the flag to use the appropriate templates for the reporting(BEx Web Designer, Report Designer, etc.).

• Locked the use of 3.x functionalities.

• Implemented new 2004s security system replacing the existing BW 3.xversion.

• Switched to new 2004s Analysis authorization.

• Testing of all objects at all levels were doing during the migration.

• Applied some of the patches for the issue noticed in the new environment(Query designer, Variables value format, incomplete migration of query elements, etc)

• Assisted BI Basis/DBA team in establishing the SAP recommended parameter values for Database, J2ee engine.

Volkswagen of America, MI Jan2006 – Dec2008

BW CONSULTANT

Implementations of BW (ET - 2000)

Phase 3

• Pricing Books – Gathering requirements and designing Info Cubes, ODS Objects, Multi Cube for Pricing Books for the parts.

• Process Chains - Designed Process Chains for daily extraction of data.

• Alpha conversion - Performed Alpha conversion to convert Inconsistent internal characteristic values.

• Open Hub - Created Info Spokes for Billing, Warranty, Objectives, Legacy Billing and exported the Data to SAP R/3 to publish the reports to dealers through the existing portal

(Parts on Command) which is connected to the source system.

• Hierarchies – Created Hierarchies for customer, warehouse movements and the data loaded by flat file.

• Production Support – Providing production support and attending to extraction problems. Phase 2

• Billing - Extracted the Billing at Item level data (2LIS_13_VDITM) into ODS and Info Cube. Manipulated the data in Update routines to match the custom requirements of the client.

• Sales - Extracted the data using 2LIS_11_VAITM (Sales at Item level) and created ODS and Info cube.

• Shipping - Created Info Cube and extracted to be delivered qty to restrict the size of the Info Cube, using data source 2LIS_12_VCITM.

• MultiProviders (Billing, Warranty, Objectives, Historical Data, external data & stock, nonstock)

Designed MultiProviders on Billing, Warranty, and Objectives & Historical Data to produce Parts Statistical Reports, which are to be used extensively by the Field Account Executives. These reports have replaced the Field laptop Application that was laborious and time consuming.

CERTIFIEDC

• Warranty - Using DB Connect extracted warranty information on weekly basis from the view created in Business Objects.

• Web Reporting - Designed the Web Template. Released multiple queries in single template and assigned them to the roles in PFCG.

• Authorizations - Involved in the creation of roles and authorizations.

• Production support - Creation of User Ids, assignment of roles and authorizations.

• Transports - Extensively did the transport of Objects into Quality & Production using STMS. Phase 1

• Warehousing - Created a generic data sources on tables LTAK (WM transfer order header), LTAP (WM transfer order Item), LTBK (transfer requirement header), LTBP (transfer requirement Item). Created ODS for Item level data and Info cube for Header level data.

• Purchasing - 2LIS_02_SCL- Created an ODS and Info cube extracted the data from Purchase at schedule line Created update routines for Ordered Qty, Goods Received Qty, Invoiced Qty and respective Values.

• Inventory -2LIS_03_BF- Created a ODS and Info cube, initialized the stock using 2LIS_40_S278.

• Extensively involved in Master data loading and transaction loading.

• Created number of custom queries, Variables using customer exit and replacement path for MTD & YTD calculations, calculated Key figures, restricted key figures, RRI and structures. Environment: SAP BW 3.5B, SAP R/3 4.6C, BEx Analyzer, Web Application Designer, ABAP/4, Oracle 9.2, AIX

NON-SAP PROJECTS

State Farm Insurance, IL June 2003 –Dec 2005

Online Transaction System

Developer / QA Engineer

Online Transaction System (OTS) was developed for online transactions like accessing Personal accounts, Checking balances, payment of recurring bills and transfer of funds between accounts of its customers.

Responsibilities:

• Involved in creating and execution of test plans for their Internet web site application.

• Involved in developing policies and procedures to ensure web site release integrity and analyzed the functional requirements.

• Checked functional test cases and technical specifications.

• Created test cases for each functionality and automated the bug free test cases for Regression testing.

• Performed class mapping of the objects.

• Executed Error Handling and Exception cases.

• Verified images to make sure that they are loading properly.

• Generated the detailed reports of the Bugs, Pass-Fail report, Comparison Chart.

• Worked with development team to ensure that testing issues are resolved. Environment: Win Runner, Load Runner, Java 1.1.7, JDBC, Servlets, JavaScript, PL/SQL, CICS, IMS/DB, DB2, VSAM, FILE-AID, XPEDITOR, JCL

CERTIFIEDC

Nationwide Insurance, OH Aug 2000- May 2003

Management Information Finance System.

Programmer/ Analyst

Nationwide is a major Insurance company in US based at Columbus, Ohio. The company has initiated a major Y2000 conversion project for all of its information systems. Worked with IBM Global Services (IBMGS) team (Tuttle Crossing), which is involved in the Year 2000 conversion project & review.

Responsibilities:

• I am responsible for testing the production-changed systems of MI Finance from Year 2000 standpoint.

• The testing process involves understanding MI Finance systems, their program changes and creating test data.

• The systems are run on test data on respective sensitive test dates and the results are reconciled.

• In this process I am using batch and online expeditor to test the changed programs and Trans file 2000 to migrate the data. The systems are tested in Year 2000 and beyond for a thorough performance test.

Environment: System390, Pentium, MVS/ESA, CMS, TSO/ISPF, PANVALET JCL, COBOL, SPUFI, FOCUS, ASSIST, File-Aid, IDCAMS and PROFS

Contact this candidate