Data Sap
Resume:
Summary
*+ years of IT Experience in SAP HANA/BW/BO which includes key roles in Design, Development, Migration/Upgradation and Production support.
Experience in 3 Full life cycle implementations in SAP BI/BW and 1 in SAP HANA project. Involved in all phases of implementations starting from Requirements gathering, Gap analysis, Blue Printing, Realization, production Support and Documentation.
Thorough understanding of SAP BW/BI and HANA Architecture including Modeling custom Infoobjects, infocubes, DSOs, Data Sources, HANA Views, HANA In-Memory Optimized Infocube and Data Store Object.
Thorough understanding of SAP ERP Functional areas - FI, MM, SD, PP, APO, CRM, SRM, FS-PM and FS-CD.
Worked on SAP HANA implementation project with SAP BW on HANA Landscapes.
SAP HANA, BW HANA architecture, design and data modeling expertise.
Developed data models using SAP HANA studio and SAP BW powered by HANA.
Worked on Importing BW Models into HANA, In-Memory Optimized Infocube and Data Store Object.
Worked on Transient Provider/Virtual Provider Based on a SAP HANA Model, Operational Data Provisioning (ODP), Open ODS Views, Data provisioning using SLT replication, Data services for SAP and non-SAP systems.
Experience working on HANA Enterprise - Modeling including Attribute Views, Analytical Views, Calculation views.
Proficient with BW Admin Workbench, Data Extraction, BODS, Transformation (ETL) and Loading, Transport management, Bex 7.0 Analyzer, query performance tuning, and aggregates.
Worked on Info Providers like SPO’s, Info Cubes, DSO’s, Multi Providers, Open Hub and Master Data Objects.
Extraction and enhancement of datasources from ECC, FS-PM, FS-CD and CRM systems. Worked on LO Cockpit, FIGL and Generic Extractors.
Involved in Performance tuning of InfoCubes, Reports and Data loading.
Involved in enhancement techniques like User Exits, Customer Exits & BADIs.
Well versed on Creation of Start, End, Info Package, BEx Routines & DTP Filters using advanced ABAP.
Worked on Inbound and Outbound interfaces. Have created Open Hub Destinations and APD’s using BEx queries as source
Involved in Basis activities, Created User IDs and User Authorization Role Maintenance, Data center migration, Transport request collection activity for moving the objects from Dev to QA to PRD system.
Expertise in integrating BOBJ reporting tools includes WEBI, Xcelsius/Dashboard Design, Crystal Reports, Business Layer and Data Foundation in the Universe/Information Design Tool
Experience in creating the Universes and Resolving Loops Using Contexts and Aliases. Extensively used Business Objects reporting functionalities such as Master Detail, Slice and Dice, drilling methodology, Filters, Ranking, Sections, Graphs and Breaks
Extensive experience on Prototyping the new technologies like SAP Design Studio, Analysis for office, SAP Lumira and CRM Integration with BOBJ.
Expert in Data Extraction, Transforming and Loading (ETL) using Business Objects Data-services xi3.2, 4.0(BODS).
Working knowledge on Ticketing tools like Remedy and HPQC & Mange Now which are commonly used in support environments.
A motivated individual and a quick learner, committed to teamwork, multicultural experience. Able to communicate clearly and honestly with clients, peers and managers.
Technical Skills
ERP : SAP ECC 6.0/5.0, R/3 4.7, R/3 4.6C
ETL Tools : SAP BI 7.4,7.3/7.0, BW 3.5, BODS 4.0
SAP Modules : FI, MM, SD, CRM, APO, FS-PM and FS-CD
Reporting : SAP Business Objects 4.1/ 4.0 /3.1, Web Intelligence, Crystal Reports, Lumira, BEx
Analyzer, BEx Reporting (BW 7.3/BW 3.5),
SAP Applications : SAP BW/BI, SAP HANA
Languages : ABAP, SQL
Databases : Oracle 8i / 9i, SQL Server, HANA
Professional Experience
Client: BB&T, Winston-Salem, NC Dec 2014– Till Date
Role: SAP BW/Hana/BO Consultant
Environment: BW 7.0/7.4, SAP HANA 1.0, Business Objects 4.1, FI, Bex Analyzer, Universe, Web Intelligence Reports.
Responsibilities:
Working on SAP Finance Technology Roadmap initiative and responsible for Analyzing, Developing, testing and supporting the SAP BW Applications.
Responsible for SAP BW/BI, SAP BO and SAP HANA Project development lifecycle from Project preparation, Blue Print, Realization, Requirements gathering, Functional technical design documents, Development, Unit testing, Integration testing, User Acceptance Testing, Go-live and Post Go-live support.
Developed complex data flows with the objects DSOs, Info sources, ADSOs, Info cubes, SPOs, Composite Providers and BEx Reports.
HANA Design Studio and Modeling: Extensively worked on SAP BW HANA Data Modeling using ADSO’s, Composite Providers and Attribute/Analytic/Calculation Views with complex calculations Designed/ Optimized composite providers for scalability. Pushed complex BEx Query calculations to Calculation views.
Created Analytical Views to support multi-dimensional lease reporting requirements by joining Fact table (data foundation) to modeled dimensions (attribute views) in the Logical Join node.
Created Calculation Views using database tables, attribute views, analytic views and created SQL Script based calculation views, SQL Procedures to address complex business requirements
Used Information design tool to create connections to SAP HANA databases, create data foundations, Create Business Layer and publish these connections and layers to the SAP BO repository.
Worked on SAP BEx Formulas, Structure, CKF, RKF, Customer Exit Variables (used function modules approach), Conditions and Exceptions.
Worked on Business Content, functional tracks like FI-AA (Asset Accounting), FI-AP (Account Payable) FI-GL, data sources and data ware housing team.
Created new data flows as per LSA++ architecture.
ABAP for SAP BW, Expert, End, Start, Field Routines, BADI for Extractor Enhancement. Development of Reports using SAP Business Objects Web Intelligence.
Worked on Export/Import on objects in HANA.
Created Business Layers in IDT as per reporting requirements.
Created and maintained WeBI and Crystal Reports, Dashboards for new reporting requirements.
Involved in transporting the BO objects across landscape via LCM
Experienced in creating user profile and mapping user groups.
Client: MediBank June 2014 – Dec 2014
Role: SAP BW/HANA Consultant
Environment: BW 7.0/7.3, Business Objects 4.1, CRM, FS-PM, FS-CD, FS-PRO &QUO, Bex Analyzer, Universe, Web Intelligence Reports.
Responsibilities:
Responsible for understanding the business requirements, performed gap analysis, created functional, architectural designs, reviewed Data Modeling designs with functional team.
Worked in complete BI flows for master and transactional data consisting of various SAP Modules like FS-PM, FS-CD, and CRM.
Created generic datasources using Table/View, Function Module to extract data from FS-PM, FS-CD, and CRM source systems.
Created transactional DataSources and Master DataSources (Texts, Attributes and Hierarchies).
Enhanced standard extractor to populate the custom fields using Classes.
Involved in writing Routines (Start, End and Infopackage).
Installed the Standard Business Contents for all standard InfoObjects with Transformations, DataSources, Infocube, DSO etc.
Created Write-optimized and Standard DSOs as per business requirement in different BW layers.
Created Open Hub Destination to load the BW data to 3rd party system.
Worked on transportation management to Analyzing transportation and logistics information on a strategic level for vast amounts of data.
Involved in the activity of Process Chain creation for Master and Transaction data.
Involved in the Transport collection activity for moving the objects from Dev to QA system.
Involved in Support and Monitoring activities after go-live.
Helped Quality assurance team while testing the various reports.
Performed unit testing, system testing and user acceptances test (UAT) for universe, reports and security management.
Client: Juniper, Sunnyvale, CA April 2013 - June 2014
Role: SAP BW Consultant
Environment: BW 7.0, Business Objects, CRM, Bex Analyzer, Universe, Web Intelligence Reports, Crystal Reports.
Responsibilities:
Involved in the Design & Implementation Phase and Build Test Phases, Process Design Documentation.
Data flow analysis is done using Queries/Workbooks in BW 3.5 System, Technical Upgrade BW Dev to BI 7.0 Dev, Post Upgrade Analysis (DEV environment).
Involved in Unit Testing, Data loading, Execute Workbooks, Integration Testing, and User Acceptance Test.
Extracted data using LO Cockpit, data sources from R/3 CRM source systems.
Worked on new data flow capabilities like DTP (Data Transfer Process), RDA (Real Time Data Acquisition) and enhanced & graphical transformation capabilities.
Worked on Real Time Info Cube and Data source object and also new and enhanced administration and monitoring features (BI Administration cockpit).
Designed Front-end Queries using BW components like Calculate & restricted key figures, Structures, Variables, Exceptions and Conditions, Workbooks using Bex Analyzer, Bex Browse.
Worked on integrating BI 7.0 with Enterprise Portals 7.0 also for publishing BI Web Templates, Reports from BEX Web Analyzer, Query Designer and Web Application Designer into Enterprise Portals.
Tested the new features if BI 7.0 which includes new data flow, re-modeling, integrated planning, Real time Data Acquisition, enhanced features of Process Chains.
Testing has been done by taking the scenarios existing in the current BW 3.5 implementation and creating the same in BI 7.0.
Monitor and Support & Troubleshooting of Existing Data loads by using Process Chains. Participating in the Status Meeting with the Business.
Advising the Client regarding the Performance Improvement.
Client: Micron, Boise, ID May 2012 – April 2013
Role: SAP BI Consultant (Enhancement & Support)
Environment: SAP BI 7.0, SD, MM, APO, Business Objects, Crystal Reports
Responsibilities:
Responsible for understanding the Business Process, Landscape and Architecture for BW system.
Involved in Ad-hoc query development and data mining.
Created and monitored Process Chains using RSPC transaction code.
Loaded data into PSA (persistence Staging Area) and data targets in parallel.
Installed and analyzed BW statistics to know the usage of aggregates.
Developed Reports using BEX Designer.
Performed filling up the aggregates to fill the summarized data from cubes to the aggregates, roll ups to fill the aggregates with the changed records and attribute change runs to realign the aggregates.
Designed and configured BW for the flow of data from R/3, Non-SAP Databases and BW system.
Extracted data from Non-SAP system, Relational database systems i.e. Oracle and MS SQL Server, using DB Connect.
Extensively worked on Process Chains development, Daily/Weekly/Monthly Background scheduling of Process Chains, Monitoring, in both BW and APO systems.
Performed LO-Cockpit extraction to extract the Header and the Line Item data from the Sales and distribution (SD) module (Sales Order “2LIS_11_VAHDR/VAITM”, Shipping/Delivery “2LIS_12_VCHDR/VCITM”, and Billing “2LIS_13_VDHDR/VDITM”).
Enhanced standard business content during the process of LO-Cockpit extraction.
Extracted data from MM (Material Management “2LIS_03_BF” data sources).
Performed compression/collapse to move the request ID’s from F to E table in the Fact Table.
Performed flexible and direct update to load transaction and master data.
Client: Shell-GSAP, Houston, TX Nov 2011 – May 2012
Role: SAP BW/ BI Consultant (Upgradation & Support)
Environment: SAP BW 3.5/BI 7.0, Bex Analyzer, BEX Web Application Designer, SD, MM, PP, APO, SRM, ECC 6.0.
Responsibilities:
Involved in the Design & Implementation Phase and Build & Test Phases, Fit – GAP Analysis, Process Design Documentation.
Data flow analysis is done using Queries in BW 3.5 System, Technical Upgrade BW 3.5 Dev to BI 7.0 Dev, Post Upgrade Analysis (DEV environment).
Performed upgradation of BW 3.5 to BW 7.0
Involved in Unit Testing, Data loading, Execute Workbooks, Integration Testing, and User Acceptance Test.
Knowledge in SAP Net Weaver BI 7.0 upgrades service market place.
Involved in Basis related issues coming in BI 7.0 and fixed the issues.
Worked on new data acquisition capabilities (new Data Source concept, enhanced remote- access capabilities).
Extracted data using LO Cockpit, data sources from ECC 6.0, CRM source systems.
Worked on new data flow capabilities like DTP (Data Transfer Process), RDA (Real Time Data Acquisition) and enhanced & graphical transformation capabilities.
Worked on Real Time Info Cube and Data source object and also new and enhanced administration and monitoring features (BI Administration cockpit).
Worked on functions of new BEX Query Designer in the state-of-the-art BEX Web Application Designer, Excel-based application design with the new BEX Analyzer and New capabilities with Information Broadcasting and Modeling of BI applications using the BI kit of the Visual Composer.
Extensively worked on Extraction of Data using open Hub (Info Spokes).
Tested the new features if BI 7.0 which includes new data flow, re-modeling, integrated planning, Real time Data Acquisition, enhanced features of Process Chains.
Testing has been done by taking the scenarios existing in the current BW 3.5 implementation and creating the same in BI 7.0.
Monitor and Support & Troubleshooting of Existing Data loads by using Process Chains.
Resolving the SAP tickets according to priority based created in the remedy Tool.
Participating in the Status Meeting with the Business.
Advising the Client regarding the Performance Improvement.
Involved in close Interaction with the Content Owners and Service Line Mangers for different lines of Business.
Client: Coke, Atlanta, GA May 2009 – Nov 2011
Role: SAP BI Consultant (Enhancement & Support)
Environment: SAP BW 3.5/BI 7.0, Bex Analyzer, MM, SD, ECC 6.0.
Responsibilities:
Responsible for understanding the Business Process, Landscape and Architecture for BW system.
Involved in Ad-hoc query development and data mining.
Created and monitored Process Chains using RSPC transaction code.
Loaded data into PSA (persistence Staging Area) and Data Targets in parallel.
Installed and analyzed BW statics to know the usage of aggregates.
Developed Reports using BEX Designer.
Performed filling up the aggregates to fill the summarized data from cubes to the aggregates, roll ups to fill the aggregates with the changed records and attribute change runs to realign the aggregates.
Designed and configured BW for the flow of data from R/3, Non-SAP Databases and BW system.
Extracted data from Non-SAP system, Relational database systems i.e. Oracle and MS SQL Server, using DB Connect.
Performed LO-Cockpit extraction to extract the Header and the Line Item data from the Sales and distribution (SD) module.
Enhanced standard business content during the process of LO-Cockpit extraction.
Extracted data from MM (Material Management “2LIS_03_BF” data sources).
Performed compression/collapse to move the request ID’s from F to E table in the Fact Table.
Performed flexible and direct update to load transaction and master data.
Client: Weyerhaeuser, Federal Way, WA Aug 2007 – April 2009
Role: SAP BI Consultant (Development & Support)
Environment: SAP BI 7.0, ECC 6.0, Bex Analyzer.
Responsibilities:
Designed and developed functional specifications, technical specifications for Bex queries on top of SAP BI/BW, R/3 systems as per the system landscape.
Working on BI 7.0 Data Warehousing Workbench: designing functional/physical data model, backend configuration, testing, cutover/go-live planning, production support of Info Objects, Info Cubes, Data-Store Objects (DSO/ODS), Multi providers, Info sets and Process Chains.
Extracting master data / transactional data in to BI landscape (data from both SAP R/3 and external source systems) with custom extractors, modifications/ enhancement (user-exit) of business content extractors, generic extractors, transports and process chains.
Created and enhanced Info Providers, MultiProviders, Transformations, and Data Transfer Process and extensively worked on designing process chains.
Performed system analysis, identified Info providers to meet business requirements.
Developed flexible queries using filters, navigational attributes, variables in Bex to facilitate data analysis in a drill down or summarized way to give detailed level of information.
Reviewing the model changes, Performance monitored data loads and modified Start routines, End routines, Field routines without changing the functionality.
Transporting of the developed objects to Quality and Production boxes.
Prepared test cases for Unit testing and involved in User Acceptance testing and Quality testing.
Prepared the technical Quality documentation.
Preparation of end user training documentation.
As a part of Production support involved in monitoring load failures, Delta loads, documenting and monitoring the performance of the system.
Contact this candidate