Sap Bi/bw Financial Accounting Resume
0/5 (Submit Your Rating)
PROFESSIONAL SUMMARY:
- Over 15 years of Business software development and consulting experience in which 10 + years of SAP experience in SAP BW/BI, BPC 10/ 7.x ver. for NW/MS, SAP - BO XI R 4.0/3.x, Crystal Reports 2008/2011, SAP HANA, SAP BODS, SAP ECC, SAP R/3 4.7, SAP CRM in the business areas FI/CO, COPA, IPM, MM, SD, PP and HR. Applications Integration, Data Integration, Business requirements analysis, Process Re-engineering, Gap-Analysis, Design, Development, Testing and Implementation of SAP Applications.
- Experienced and involved in 7 Full Life Cycle Implementation of SAP BI/BW Financial Accounting, Controlling, Profitability Analysis, Intellectual Property Management (IPM) and Logistics applications.
- Expertise in Multi Dimensional data Modeling, Star Schema and Extended Star Schema, Design, Development and implementation of InfoProviders (InfoCubes, DSO/ODS, MultiProviders, InfoSets, Master data objects, etc.), Data Extraction, Transformation, Translating and Loading the data (SAP and Non SAP) from different Source Systems like SAP ECC, SAP CRM and SAP PC Flat Files Data into SAP BW/BI system for FI/CO, IPM, Project Systems (PS) and Logistics Applications.
- Enhanced SAP standard extractors and Customized the Data Sources, Transfer routines and Update routines/transformations in fulfillment of Global Business Requirement Definitions for FI/CO, IPM and Logistics Applications.
- Excellent experience in Global Production System Support in the areas of SAP Financials (FI/CO), GL, AR, AP, CCA, PCA, COPA, IMP and Logistics (MM,SD,PP) modules and the end-users.
- Excellent experience in BW system upgrade activities BW 2.1C to 3.0/3.1C, 3.3 and 3.5 and BW 3.x to BI 7.0/7.3 and prepared the test plans for the BW/BI System upgrade.
- Involved in BW DEV., QA. Systems refresh activities and BW Production system migration activities.
- Expertise in Data Integration from SAP BW/BI to BPC 10/7.x version for NetWeaver and BPC 10/ 7.x version for MicroSoft (Outlook Soft) from SQL Server 2008/2005 to BPC applications such as Cost Center Planning, Balance Sheet, P&L, Operations, and Reporting through SSIS Packages and SQL Analyzer (SSAS) for OLAP analysis.
- Created Analysis Process Design (APDs) for Financial and Logistics Applications Data Analysis and Ad-hoc reporting.
- Proficient with Business Objects Universe-Designer, Universe Builder, Web Intelligence reports - InfoView and Voyager, Desktop Intelligence, WebI Rich Client, Live Office, Query as a Web Service, Crystal Reports 2008, Xcelsius 2008 Reports and DASHBoard Reports.
- Excellent experience in the development of SAP BI-BOBJ OLAP Universe Design by using SAP BI-InfoProviders (InfoCubes, DSO objects, InfoSets and Multiproviders) and BEx. Queries are as back-end Source to the Business Objects System.
- Good Technical skills in SAP HANA, SAP BO XI 4.0, SAP Data Services (SAP BODS), Informatica 9.0, Crystal Reports 2008/2011 SAP-XI and BPM integration.
- Self-starter, result oriented ability to multitask with exceptional organizational and management skills.
- Quick study/understand who rapidly assimilates into organization and employs the new ideas, concepts, methods and technologies to support business objectives. Thrive in both independent and collaborative environments.
- Energetic and self-motivated team player at ease in high stress and fast-paced environments.
- Strong leadership and collaborative skills to work in a cross functional team setting with different levels of Business leadership, Business Users and IT teams.
- Data Warehouse Architecture and Multidimensional Data Modeling - Designed and Development of InfoCubes, MultiCubes and RemoteCubes based on the data analysis and reporting needs, defining complex routines.
- Extraction, Transformation and Loading of Data (ETL) - Preparing ECC 6.0, SAP R/3,SAP CRM, Non SAP data marts for SAP BW using the methods like LO CockPit extraction,COPA extraction, SAP delivered Standard/Customized extraction and Flat Files extraction. Defining the loading strategies, initial and delta data loads using IDOCs and PSA (TRFCs) loading, scheduling and monitoring data loads.
- Build, enhanced SAP develevered standered and customised BI objects such as InfoObjects, DSO Objects, InfoCubes, MultiProviders, InfoSources/Data Sources, Master and Transactional Data Transformations, InfoSets, Aggregates, Process Chains and Extractors and User Exits.
- Excellent hands on experince in SAP and Non SAP data integration to BPC 7.x/10 version for NetWeaver and Micro Soft.
- Reporting and Analyzing SAP BW data - Defining queries using the BEx Analyzer & Browser to deliver SAP and non-SAP BW information in an organized fashion. Executed the reports from 3rd party reporting tool by pulling data directly from BI.
- Work with Basis, Security, and Database Analysts to ensure that BW application and database is optimized.
- Perform research of OSS notes and support packages and their impact on the implementation.
- Prepare project related documentation (functional design, technical design, test scripts) during the different stages of a project.
- Support the on boarding and of BW Power Users which includes providing technical of key BW toolsets such as BEx Web analyzers, Query designers and Business Objects reports.
- Develop and drive the implementation of BW best practices and standards for the team.
- Design complex, custom BW solutions or component objects translating complex requirements into an optimal BW design.
- Interact with the Business Users to gather requirements, prioritize work, develop enhancements to the existing system, coordinate testing, and perform change management / for BW reporting and applications.
- Performance and sizing tunning- Otimizing data loads, index management, defining InfoCubes aggregates,query optimization.
- Excellent experience in BW/BI system upgrade activities and The DEV., QA. System refresh activities and Production System migration activities
- SAP BO XI 4.0/3.1, SAP BI-BO integration and SAP-XI and BPM integration.
- Involved in the preparation of High-level architecture Business Objects Process flow and High-level graphical representation of Sources and Targets.
- Involved in the understanding of different source systems, in the process of designing an ETL Process.
- Worked on Data transfer process(DTP), Data warehousing workbench, DSO’s, remodeling toolbox, tree search, generic search, DSO object structure.
- Worked in error handling using error stack, temporary data storage, Process chain, flexible execution path.BPC 7.x/10 NW and MS SQL Server 2008 Data Integration:
- Worked extensively in data integration from SAP BW/BI system to BPC 7 NW system to load Actual/Plan/Forecast data.
- Data Extracted, Translated and Transformed by applying the business rules and Loaded from SAP ECC (R/3) to SAP BW/BI system and from SAP BW/BI system to BPC 7 NW system.
- Implemented Data Integration from SAP and Non SAP Actual/Plan data to BPC applications Cost Center Accounting Planning, Profit Center Accounting Planning, Balance Sheet, P&L, Operations and Reporting.
- Implemented Data Integration from SQL Server 2008 database though SSIS Packages to BPC applications Cost Center Planning, Operations, Reporting, Gross Margin Food Services and Consumers applications.
- Excellent experience to manage the AppSets, Applications/Model, Dimensions and Attributes and the Data Manager ObjectsSAP R/3 Release: ECC6.0, 4.7, 4.6C.
- ABAP Development Workbench, Data Dictionary(DDIC)
- Data Conversion and Data Load (BDC Session/Call Transactions)
- Involved in User - Exits enhancements for R/3 data extractors, Development and Maintenance of Function Modules.
TECHNICAL SKILLS:
SAP BW/BI Release: SAP Net Weaver 2004s -BI 7.3/7.0/ 3.5/ 3.1 c/ 2.1cSAP BPC Release BPC10/7.x version for NetWeaver and Micro Soft.
SAP Reporting Tools: SAP BO 4.0/3.x, Crystal Report 2008/2005 and SAP Data Services (SAP BODS)
SAP Release: SAP ECC/R/3 4.x/3.x