Sap Bw Bo Hana Senior Consultant Resume
NJ
PROFESSIONAL SUMMARY:
- Over 12 years of experience in SAP BI/BW, HANA, BO, BODS and ABAP.
- Experience in Requirement Gathering, Gap Analysis, Design, Development, Testing, Documentation, Maintenance, Troubleshooting and Performance Tuning.
- Heavy experience in creating Information Models wif in HANA Studio on top of HANA database tables using Attribute, Analytical and Calculation Views
- Having good knowledge on BW powered by HANA, HANA optimized cube, Advanced DSO, Open ODS view, Composite Provider, Transient Provider, LSA++ and SQL Script knowledge.
- Having good knowledge on HANA Data Provisioning and using SAP LT Replication Server (SLT), BODS (ETL Replication), DXC and Smart Data access.
- Hands - On experience in creating BOBJ Analytical reports using HANA Information Models.
- Extensively worked on integrating data wifin HANA from heterogeneous systems for teh purpose of building Cross functional and Cross Business reporting models.
- Hands-on experience wif SQL scripts like stored procedures and CE scripting and well versed wif BW7.X on HANA working functionalities
- Expertise in ETL (Extraction, Transformation and Loading), Multi-dimensional modeling and reporting wif emphasis on performance optimization.
- Experience in using Data Services for SAP ECC and SAP BW both as Sources and Target for Data Cleansing, Data Migration and Data warehouse Projects.
- Strong SAP ECC Knowledge in SAP ECC 6.0 (SD, MM, FI, CO, PP, APO, IS-U, CRM, SRM, and QM)
- Experience in writing ABAP code in Data Source Enhancements using Exits, BADIs, Start, End & Expert routines, Customer Exit variables and implementing Virtual key figures.
- Expertise in Installation and Configuration of SAP Business Content and Info providers for Logistics and Financial extractors.
- Expertise in Design and Maintenance of Data Modeling includes Info Objects, Data Sources, Transformations, DTPs, Info Cubes, DSO’s, Info sets, Multi providers, Info packages, scheduling teh Process Chains and fixing teh process chain failures.
- Experience in Hierarchies, Authorizations, BW Statistics, Archiving, Process Chains and Open hub services. Involved in performance tuning using Aggregates, Rollups, Cube Compression and Partitioning to achieve best possible performance.
- Extensive experience on reporting tools like BEx Query Designer, Analyzer, Workbooks, Broadcasting, Web Template and Web Reports. Exposure on Structures, Variables, Calculated Key figures, Restricted key figures and RRI.
- Designed and Developed Universes using SAP BEx Queries and Multi Provider. Hands on Experience on Information Design Tool. Experience in extracting data into Business Objects environment from SAP BW system. Created WEBI Reports and Crystal Reports as per user requirements.
- Extensively involved in Transport Management - generation of transports, collection of objects in transport requests and moving transports across system landscape.
- Possesses excellent communication skills and strong analytical bent of mind to understand teh complexity of applications.
- Proficient in Collaborating wif end users and problem solving.
TECHNICAL SKILLS:
SAP: SAP BW 7.4, BI 7.x and SAP BW 3.5, SAP HANA
SAP ECC: 6.0, SAP R/3 4.7, SD, MM, FI/CO, SRM and CRM
BEx: , WAD, BEX Broad cast, BODS, Business Objects 3.x, 4.x
WEBI: Crystal Reports2008, 2011 and 4.x for Enterprise
Xcelsius: 2008 (Dashboards 4.x), Design Studio
Operating System: Windows 7, 2000, 98 and XP.
Programming Languages: ABAP/4, C, SQL Script.
PROFESSIONAL EXPERIENCE
Confidential, NJ
SAP BW BO HANA Senior Consultant
Responsibilities:
- Good understanding of various components of SAP HANA.
- Good exposure on Schemas, Table Definitions, Attributes, Measures & Hierarchies in HANA. Developed and implemented SAP HANA Data Modeling using Attribute Views, Analytic Views and Calculation Views (both Graphical & SQL script based)
- Involved in SAP HANA Security including User Management, Roles, and Privileges
- Gathered and analyzed teh requirements to replicate teh ECC content in HANA usingdata provisioning.
- Expertise in Data Provisioning techniques like SLT (SAP and Non-SAP), DXC, SAP BODS and Flat file upload.
- Experience in using Data Services for SAP ECC and SAP BW both as Sources and Target for Data Cleansing, Data Migration and Data warehouse Projects.
- Good exposure on leveraging HANA models in BW and BW objects in HANA by Transient Provider, Open ODS view, Advanced DSO and Composite Providers.
- Extensively used HANA Studio and hands on in using HANA optimized Cubes, variables, Input parameters, Joins and Transformations in HANA.
- Exposure on LSA++ Architecture.
- Involved in gathering teh reporting requirements for SD, CRM, SRM, FI, and MM by conducting workshops.
- Identified teh Standard content for teh BW Reports and activated them from teh BW Business Content.
- Extensively used Data Services Management Console to Schedule jobs, monitor log file and managing access rights to users.
- Designed & developed BODS Jobs and Complex Workflows and Data flows for extraction of data from different data sources. Defined separate data stores for each database to connect to teh source or target database.
- Extensively involved in data source enhancements, generic extractors, User Exits and customized delta built up for teh data sources, Logistics Cockpit configuration and customization using Function Modules and BADIs.
- Extensively worked in BO Data Services, designing Business Objects Universes, creating complex reports using Web Intelligence.
Environment: SAP BI 7.X, ECC 6.0, SAP HANA, SAP CRM 7.0, SAP SRM 7.0, ABAP/4, BEx Analyzer & Query Designer, SAP Business Objects 4.1 (Universe Design Tool, Information Design Tool (IDT), Design Studio 1.2, Web Intelligence report, Crystal Reports 4.x for Enterprise and SAP Data Services 4.x.
Confidential
SAP BW BO HANA senior consultant
Responsibilities:
- Comprehensive modeling experience in creating various views like Attribute, Analytic and calculation views.
- Hands-on experience wif SQL scripts like stored procedures and CE scripting and well versed wif BW7.X on HANA working functionalities.
- Hands-On experience in creating BOBJ Analytical reports using HANA Information Models. Involved in development and deployment of Complex Reports.
- Involved in Initializing teh LO Data sources by activating teh Business Content Data Sources, maintaining teh extract structure, generating teh data source and activating teh data source.
- Prepare reports as per organization requirement in Business Objects.
- Maintaining Reconciliation’s to verify teh data in SAP R/3 and SAP BW after teh data loads. Involved in developing teh reports at teh end of every month.
- Evaluate all data from end users and prepared appropriate dashboards.
- Involved in Load monitoring using RSPC, RSMO and SM37.
- In case of data load failures, involved in analyzing teh error and found teh root cause of teh error and took corrective actions and made teh permanent solutions to failures.
- Monitor master data loads and transaction data loads.
- Involved in period end and year end activities.
- Solved many Data Mismatch tickets by doing Back fills.
Environment: SAP BI 7.X, ECC 6.0, SAP HANA, SAP Business Objects, ABAP Development workbench and SAP Solution Manager.
Confidential
SAP BW BODS consultant
Responsibilities:
- Actively participated in understanding Business Requirements, Analysis and Designing ETL Process from Business Analyst.
- Teh scope of work consists of analyzing functional specifications, preparing technical specification for new enhancements, developing and modifying teh objects assigned.
- Hands on experience in registering teh repositories in teh Data Services Management console, configuring RFC Services between SAP and BODS.
- Experience in creating SAP BW Target data store in Data Services when loading data to SAP BW.
- Used Business Objects Data Services interactive debugger to test teh jobs and fixed teh bugs.
- Scheduled batch and real time Jobs using Data Services Management Console.
- Loaded teh data from R/3 to BW and used Initialization wif delta update and full update methods. Performed Data Extraction and Data Staging using LO Cockpit (LBWE).
- Solving Daily Load Errors while loading teh data from source systems.
- Involved in both teh Activities Monitoring and Production Support.
- Involved in BW Security by providing and controlling teh access to teh user.
- Extensive experience wif teh Administrator Workbench.
- Extensively worked on BEx Analyzer and Browser for building queries and workbooks.
Environment: SAP BI 7.X, ECC 4.7, SAP BODS 3.X, ABAP Development workbench, BEX analyzer/Browser.
Confidential
SAP BW BO consultant
Responsibilities:
- Based on Functional Specification, prepared Technical Specification documents
- Filled teh Gap between Functional Spec and teh business requirements after having discussion wif teh business.
- As per teh requirement, existing target suppose to be enhanced and implemented new data flow to teh existing data flow.
- Experience in analysis and development of ETL data flow design using Business Objects Data Services.
- Extracting data from different sources like R/3 and couple of info providers in BW
- Created and modified respective BW objects like Multi Provider, Info Cube, DSOs, Transformations, DTPs, Data sources, Process chains etc.
- Modified teh existing report as per teh new requirement and created teh Reconciliation report by using query elements like Calculated & Restricted key figures, Variables, Exceptions etc.
- Experience in writing Transformations (Transfer and Update) and End Routines, BW Customer Exits for Global Reporting Variables, BW Custom Logic implementation for automation of Data load activities using Process Chains. Derived teh query logic by enhancing teh Exit Variables in reporting.
- Designed and Developed Process Chains for Master data loads and Transaction data loads. Automated these Process Chains to schedule for periodic loads.
Environment: SAP BI 7.0 Net Weaver, SAP R/3 4.7, BEx, Business objects 3.x
Confidential
SAP BW BO consultant
Responsibilities:
- Involved in Data Modeling and Reporting in SAP BW.
- Installed and Activated standard Business Content objects like Info Objects, Data Sources, Transfer Rules, Update rules, Transformations, Info Cubes
- Expertise in writing teh Start Routine, End Routine, Expert Routine and Info object routines.
- Involved in teh development of Info Objects, Data Store Objects (DSO), Process chains in EDW layer and Created DSO’s, Info Cubes, Multi Providers, Transformations & DTPs, Aggregates and Process chains in ADM layer.
- Interacted wif functional experts to gather teh project/client requirements and conducted GAP analysis
- Developed accounts receivable customers dashboard using Webi and Xcelsius.
- Dashboards using multiple charts, dynamic visibility, and Alert features were designed to support complex requirement scenario.
- Resolved connectivity issues wif Xcelsius dashboards and Web Intelligence reports.
- Worked wif MDX expressions in Universe for creating calculated measures
- Created and enhanced OLAP universes using BEx queries, and developing Webi reports.
- Created Interactive and dynamic dashboards using multiple filters, Alerts, charts, list view, and Gauge and used functions like SUMIF,COUNT and CONCATENATE
Environment: SAP BI 7.x, SAP R/3 4.6, BEx, SAP BOBJ enterprise XI 3.1 SP2, Crystal Reports 2008 SP2, Xcelsius 2008 SP2
Confidential, TX
SAP BW BO consultant
Responsibilities:
- Based on Functional Specification, prepared Technical Specification documents. Filled teh Gap between Functional Spec and teh business requirements after having discussion wif teh business.
- Created and modified respective BW objects like Multi Provider, Info Cube, DSOs, Transformations, DTPs, Data sources, Process chains etc.
- Modified teh existing report as per teh new requirement and created teh Reconciliation report by using query elements like Calculated & Restricted key figures, Variables, Exceptions etc. Extensively worked on BEx Analyzer and Browser for building queries and workbooks.
- Derived teh query logic by enhancing teh Exit Variables in reporting.
- Involved in Designing teh Delta Extraction and Loading Mechanism for teh data from teh Source Systems keeping in view of various Performance Aspects.
- Involved in BW Security by providing and controlling teh access to teh user. Extensive experience wif teh Administrator Workbench
- Involved in Analyzing teh Data Loads & Query Performance activities. Based on teh Statistics, suggested and implemented optimization techniques on a regular basis.
- Performed Reconciliation for teh loaded data wif that of teh source system data. Solved many Data Mismatch tickets by doing Back fills.
- Monitoring process chains for daily loads and weekly loads. Fixed load failures for full & delta loads and resolved many data mismatch issues.
Environment: SAP BI 7.x, SAP BW 3.x, SAP R/3 4.6, BEX Analyzer/Browser, Query Designer.
Confidential, CA
SAP BW consultant
Responsibilities:
- Created and Activated Info Cubes, Info Sources, Multi-Providers, Transfer structures, Transfer rules, Communication structures, Update Rules (both ODS and Info Cube level).
- Extensively involved in extracting data from APO, transform teh data as per teh business logic and send teh data back to APO.
- Involved in writing teh routines to reflect teh changes as of R/3 developments requested by teh business.
- Extensively worked in building Queries by using Calculated & Restricted key figures, Structures, Variables, Exceptions, Conditions, and Cell restrictions. Extensively worked on RRI to enable users navigate from one report to other.
- Designed and Developed Process Chains for Master data loads and Transaction data loads. Automated these Process Chains to schedule for periodic loads.
- Changes to teh existing reports & creation of new reports as per clients requirements.
- Transported developed objects from development to acceptance and quality systems.
- Interacted wif teh Business Experts and Key Users to sort out any issuesthose were highlighted in SIT and BAT and provided solutions by fixing teh bugs in testing.
- Involved in both teh Activities Monitoring and Production Support.
Environment: SAP BW 3.5, SAP R/3 4.6c, APO, BEX Analyzer/Browser