SUMMARY:

• Sr. SAP BPC Lead Consultant with 10 Years 10 Months of IT experience in which 5+ Years using SAP BPC involving Financial Planning, Forecast and Consolidations. 8+ Years of Experience with SAP BI/BW. Experience with BW&BPC on HANA. Experience with SAP HANA Studio. Experience with BW ABAP Technology. Experience with Production Support Role.
• As a Lead Consultant, Worked on Requirement Analysis, Estimates, Solution Design, Development, Transports and Test Support of New Implementations and Enhancements in SAP BW & BPC space.
• Experience as an onsite & offshore Coordinator. Experience working with Agile and Waterfall Methodologies. SAP BPC 7.5/10.0/10.1 ; SAP BW 7.0/7.3 /7.4 on HANA; SAP HANA
• Experience with 2 Complete Life Cycle Implementation of SAP BPC Projects Which Include Requirement Gathering, T - specs, Development, Test Support, Migration Activities and Go-Live.
• Interacting with Business to determine Objectives & Priorities. Providing Estimates & Design.
• Self-Motivated Individual with Strong Technical, Analytical and Communication Skills and a very good team Lead.
• Experience with Production Support Role. Handling incident Tickets, Daily Job Monitoring.
• Experience with Performance analysis & Tuning for EPM and BEx Reports.
• Thorough knowledge of the complete life cycle of SAP BW/BPC implementation in terms of extraction, modeling, reporting, planning and Consolidations.
• Worked on BPC Admin. Experience with Creating Environment Shells, Models, Dimensions & Hierarchies.
• Experience working with Dimension Member Formulas, MDX, Script Logic, Business Rule and Process Flows.
• Good Experience with Automating Data Management Package Load Process with Process chains.
• Creating and automating Data Management Packages with loading Master Data & Transactional Data from FLAT FILE and also BW Info Providers.
• Worked on creating Transformation & Conversion Files for Planning & Consolidations.
• Worked on Debugging Data Manager Package.
• Experience with Currency Translations, Ownership Data and Intercompany Eliminations.
• Experienced with ABAP coding in terms of ABAP Programs, input routines, BADI, User Exits and transformation routines.
• Experience Co-Coordinating with SAP on Upgrade /SAP Bug Fixes. Implementing SAP Notes.

TECHNICAL SKILLS:

SAP: SAP BPC NW 10.0 & 10.1, SAP BW 7.4 on HANA, HANA STUDIO, SAP BW 7.3, ABAP .

Non SAP: AutoSys, Tableau, SQL, Java, J2EE, HP Quality Center,IXP.

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

SAP BW/BPC Consultant

Environment: SAP NW BPC 10.1, 10.0 on HANA, BW 7.4 on HANA, HANA Studio, BW 7.3.

Responsibilities:

• Worked on to Design & Development of SAP BPC 10.1/10.0 Planning and Consolidation Project.
• Worked on Transformation and Conversion Files for the BPC Load Process.
• Worked on US GAAP, Local Consolidations. Worked on Automating Data Manager Packages/ BPC Load process from Flat File and Info Cubes.
• Worked on Currency Translations, Ownership Data and Eliminations.
• Experience with Reports, Input forms and EPM format templates.
• Experience with Debugging DMPs using UJD Test Program.
• Experience Debugging ABAP Programs and Function Modules.
• Worked on Performance issues with BPC 10 EPM Reports. Worked on EPM Performance Trace to analyze long running Reports and Optimized the Macros, BADIs and MDX commands.
• Worked on Light and Full optimizations. Worked on Optimize Process chains on Source Info cubes and scheduled the Process chain.
• Created Process Chains to Automate & Schedule Daily & Monthly Loads to BPC Models & Dimensions.
• Worked on BW Master Data and Transactional Data ETL Process with Different Source Systems such as FLAT FILE, ECC, DB Connect, HANAODP and BW.
• Worked on SAP BPC 10.1 Upgrade. Experience with Embedded Model.
• Created and enhanced Data Sources, Info Objects, DSOs, Info Cubes and Multi providers as per the Requirement.
• Worked on Design and Development of BEX and EPM Reports on Info Providers and Multi Providers.
• Worked on native HANA. HANA Studio to Create HANA Views.
• Worked on BW related ABAP Development. Created Wrapper programs around Standard SAP Function Modules.
• Worked on Process chains with Scenarios such as Self Loop Events, Decision, AND /OR Processes.
• Introduced parallel Load Design to Performance tune the BW Load Process. Improved Daily Loads Performance of MD by 100%.
• Defined Hierarchies and Dimensions based on the entity and organizational structure.
• Supported SIT and UAT testing in Q system. Worked on resolving the defects which are raised in integration testing.
• Involved in cutover phase starting from preparation of the cutover plan sheet till go-live.
• Involved in go-live support and given knowledge transfer to support team.

SAP BW/BPC Consultant

Environment: SAP NW BPC 10.0, BW 7.3, WebDynPro ABAP

Responsibilities:

• Worked on SAP BPC Planning, Budgeting and Forecasting Implementation - Data Load, Manual Planning via Input Form, Manual Forecast via Input Form, Automated Planning via Script Logic.
• Worked on Design and Development of GL Related Data Modelling. Data Source, Info Packages, DTP, Transformations logic etc.
• Created Reports on the Composite Providers and Multi Providers. Worked on Creating Calculated Key Figures, Formula Variables and Filters in BEX.
• Performance tuned BEx Queries in SAP BW 7.3. Redefined Aggregates, Replaced Exclusions with Inclusions. Created SPOs for Better Performance of Reports.
• Worked on Design and Development of BPC Dimensions. Load Attributes, Text and Hierarchies to Environment shell using Data Manager Packages.
• Worked on Creating Process chains for loading BPC planning Data from BW Info Providers.
• Responsible for developing BEx Reports using BEx Analyzer.
• Worked on EPM functions in BPC input forms.
• Supported SIT and UAT testing in Q system. Worked on resolving the defects which are raised in integration testing.
• Involved in cutover phase starting from preparation of the cutover plan sheet till go-live.
• Involved in go-live support and given knowledge transfer to support team.

SAP BW/BPC Consultant

Environment: SAP BPC NW 10.0, BW 7.3, SAP ECC 6.0, SAP CE 7.3

Responsibilities:

• Responsible for Supporting Outokumpu SAP SD & MD Module Reporting Systems in BW.
• Supported Production BPC EPM Reports, Process Chains, BEx Queries. Daily, Monthly Load Schedules.
• Worked on design and development of reports Using BEx.
• Responsible for facilitating testing team by providing adequate test data to Testers by extracting Data from ECC, loading into BW cubes up to BPC Models.
• Involved in SAP BPC Security - Worked on Secured Dimensions, Users, Team, Task Profile and Member Access Profile.

SAP BW/BPC Consultant

Environment: SAP BW 7.3/7.0, Sap BPC NW 7.5/ 10, ABAP, ECC 6.0, SAP CE 7.3

Responsibilities:

• Involved in Complete life cycle implementation of SAP BW/BPC, which includes Requirement gathering, gap analysis, application specific data extraction, generic extraction, data loading, scheduling, monitoring and web reporting.
• Worked on requirements gathering, solution design and implementation.
• Involved in process designing for Planning, Budgeting and Forecasting.
• Worked on creating Dimensions according to the available insurance lines. Created hierarchies based on their Relationship.
• Experience analyzing the existing logic in Legacy Systems to implement them SAP BI.
• Responsible for enhancing Custom ABAP applications such as programs, Function Modules.
• Responsible for Developing Extraction and Retraction processes between BPC Models and BW Info cubes.
• Created process chains using standard programs to automate BPC Data Manager Packages.
• Worked on BPC Financial Consolidations. Worked on Script Logic, Currency Translations, Business Rules and Work Status.
• Taken SAP BPC Wipro Internal Classroom training & Certification. Worked on the POCs for Financial planning and forecasting.
• Worked on preparing Test scenarios for Reports and Dunning Modules.
• Supported SIT and UAT Testing. Worked in Defect Fix, Providing Test Data to Team according to the Test Scenarios.

SAP BI/BW Consultant

Environment: SAP BI/BW 7.0, BPC 7.5, SAP ECC6.0, FSCM, SAP ABAP

Responsibilities:

• Complete life cycle of SAP BW BPC implementation in terms of extraction, modeling, reporting and planning.
• Analyze the existing legacy system and recommend the customer on possible improvements.
• Developing advanced BW functionalities support such as currency conversion, time dependent master data support, reporting variable support etc.
• Creation of queries on top of the Info Providers using query designer.
• Modeling and creating BI Objects like Info Objects, DSO, Info cubes, Multiproviders, and Info sets.
• Worked close to SAP BPC Config Team to setup Appsets. Created Models, Dimensions.
• Worked on Data Manager Packages, Extracting Data from BW Info Providers to Models.
• Experience Debugging Data Manager Packages.
• Worked with Basis on Migration Activities.
• Worked with Test Co Coordinators and Business Team to Support FUT, SIT & Regression.
• Experienced on cutover activities, pre and post deployment activities.

Sap BW Consultant

Environment: SAP BI 7.0, NW2004S, SAP ECC6.0, and SQL Server.

Responsibilities:

• Worked on Creating Process Chains to Automate ETL process.
• Created Data Source, Info Package, Transformation, DTP to Load Data to BI System from ECC.
• Worked on Bex Analyzer and Designer. Created Bex Reports on Info Cube.
• Worked on Excel Sheets for Different Data Operations using Excel.
• Worked on integration of SAP Enterprise Portal with SAP ECC, SAP BI systems.
• Analyzed Long Running Jobs and Worked on Performance tuning them.

SAP Consultant

Environment: SAP BI 7.0, SAP EP 7.0, SAP ECC6.0, SAP ABAP

Responsibilities:

• As a Sap Consultant, Involved in End to End Implementation of this project. i.e. from Design to go live and Post Go-live support.
• Worked on Creating Process Chains to Automate ETL process.
• Created Data Source, Info Package, Transformation, DTP to Load Data to BI System from ECC.
• Worked on Bex Analyzer and Designer. Created Bex Reports on Info Cube.
• Worked on Excel Sheets for Different Data Operations using Excel.
• Worked on integration of SAP Enterprise Portal with SAP ECC, SAP BI systems.
• Analyzed Long Running Jobs and Worked on Performance tuning them.
• Involved in Creation of WebDynPro Java applications using NWDS.
• Used different WebDynPro UI elements like dropdowns, tables, images, tree structure, input fields, etc. to develop complex web applications.
• Implemented Table Sorter and Selected Column Sorter in a Table.
• Involved in creation of IView’s for the developed application and using WebDynPro ABAP and Java Templates.
• Worked on Portal Users and privileges, Portal Authentication.
• Experience Customizing the SAP business package applications in WebDynPro Java.
• Created BEX Web Application iView’s in the Portal content using the BEX template.

Confidential

Systems Engineer

Environment: SAP R/3, SAP EP 7.0.

Responsibilities:

• Worked on Requirement Analysis, POCs and Technical Spec for the GE Money Credit Cards Project.
• Involved in installing and establishing the Sandbox systems for the project. Initial set up for SAP Portal is done.
• Worked on Development for the WebDynPro Java Applications connecting with Non SAP Systems.
• Integrated SAP Enterprise Portal with SAP ECC systems.
• Worked on creating IView’s using Different standard Templates.
• Experience in developing enterprise applications using WebDynPro Java.

Systems Engineer

Environment: JAVA, J2EE, VB Script, DHTML, SQL, PL/SQL.

Responsibilities:

• Involved in the Design and Development of Objects using Object Oriented Design in J2EE.
• Responsible for designing the screens for the web application-using HTML, DHTML, CSS and JavaScript for client side validations.
• Development of EJB’s (Session & Entity Beans) to represent each business Object and supporting helper classes and Value objects, Local interfaces.
• Coding for the Notice Board, Messages modules using JSP, Java Script, and HTML.
• Implemented JSP Custom Tags for Reuse Functionality.
• Developed front page components by using swing.
• Developed JSP Custom Tag Libraries and associated with the controller Servlets
• Implemented DAO pattern for database connections and implemented JDBC Connection pools for database transactions and for persistence
• Worked on STRUTS framework with JSPs.
• Worked on VB Script for analyzing the defects and implementing enhancements.
• Maintained Hibernate mapping file for each Java data objects to be persisted
• Worked on Stored Procedures and Triggers for Oracle Database, also developed Views/Joins for the SQL queries.