We provide IT Staff Augmentation Services!

Sap Bw/hana Solution Consultant Resume

3.00/5 (Submit Your Rating)

Naples, FL

PROFESSIONAL SUMMARY:

  • Over 13 years of IT experience in Analysis, Design and Development of SAP applications in the areas of SAP BW/BI,SAP HANA Native, SAP ABAP on HANA, HANA Live, Power BI and Qlikview reporting.
  • Experience in information and data architecture, system upgrades, requirement analysis, solution design, enhancements, implementation and support.
  • Excellent Team Player and Team handling Capabilities.
  • Good interpersonal relations, strong communication skills, hardworking and high level of motivation.
  • Experience Techno - Functional consultant with a solid understanding of various business vertical and processes.
  • Various end to end life-cycle implementations using BW/HANA in SD, Purchasing, Pricing, Delivery, FI-GL, AP-AR, COPA, & FICO,QM,MM,PP,PS, HR, SRM, CRM,SCM, DBM, VIM.
  • Worked on SAP BW 7.4 migration to SAP BW 7.5 on HANA
  • Hybrid and Native HANA development using SAP BW, HANA, MSSQL DB data and Oracle Data.
  • Excellent knowledge on: Advanced DSO, Open ODS view, Transient provider, Embedded analytics, HANA live, HANA database artifact, Procedure, CDS,BW4HANA, HANA Optimized DSO’s, Transient, Composite, Hybrid Providers, Publishing HANA Model in SAP BW, Import SAP Net Weaver BW Model to HANA.
  • Experience with SAP HANA data modeling using Attribute View, Analytical View, Calculation view, Stored Procedures, Table Functions, Decision tables & Analytical Privileges.
  • Experience as Functional and Technical Consultant in implementing SAP BW on HANA, BI/BW, SD, MM, PS, HR,PC (Product Costing),SAP COPA, WM, EWM, TM, VIM and FI-CO (GL, AR, AP and Assets) modules.
  • Involved in more than more 11 full life cycle implementations (including SAP BI 7.5 edition for HANA) from blue-print to Go-Live stages.
  • Extensive experience with Requirement Gathering (from process design owners, Business Groups, Power Users and End users), Business Blueprint (Identifying Reports, Gap Analysis, Enhancements), Realization (Design & Development of BI objects) and Post Production Support.
  • Creation of HANA database table functions, Calculation view,
  • Advised Basis and source system owners on necessary privileges, connectivity, and configuration around Smart Data Access (SDA) for remote data querying.
  • Replication of data to HANA from both SAP and non-SAP Systems using SLT, BODS.
  • Created, Importing, and Exporting SAP Native HANA Data Models.
  • Functional SAP experience in Material Management, Purchasing, Inventory Control and general SCM
  • Developed dashboard reports using SAP Lumira to include all the required KPI's
  • Merging the datasets created from multiple data sources and creating visualizations/stories.
  • Manipulating the data in the Prepare windows and creating calculated measures and other objects in the visualization screen.
  • Connecting to SAP BI platform to consume the universes and build datasets, visualizations and compose stories.
  • Create Lumira documents with different kinds of charts and extensions. Compare the data visualization in multiple tools like Lumira/Explorer/Dashboard/Web Intelligence.
  • Publish the datasets to Business Objects Explorer
  • View/Refresh/Edit/Save the Lumira documents from BI Launchpad.
  • Send/share the Lumira documents to other users in the organization (BI Inbox/email etc).
  • Extensive experience in Business Objects Client tools like IDT, Universe Designer, Crystal reports, WEBI BO Explorer, and Analysis for Office, SAP Lumira.
  • Experience in development of SAP Universes in Designer against SAP BI Cubes and BEx Queries.
  • Good Working Knowledge on Business Objects (BOBJ) - SAP BI Integration.
  • Created formatted reports using Crystal reports.
  • Developed Dashboards using Xcelsius and Lumira

WORK EXPERIENCE

Confidential, Naples, Fl

SAP BW/HANA Solution Consultant

Responsibilities

  • Migration of BW 7.4 to BW 7.5 edition for HANA
  • Re-organize and redesign the global datawarehouse reporting solution consisting using data from SAP HANA, SAP BW, SAP BI and other relational database like Microsoft SQL DB.
  • Delivered enterprise global reporting KPI template for Product Costing, OTC, Supply chain, Financial Supply chain, Finance, Manufacturing and Warehouse management business users
  • Build a scalable LSA+ architecture for the BW on HANA datawarehouse
  • Worked on COPA extraction on the datasource 1 CO PA CCA
  • CO PA configuration (CO-PA Cost Based & Account Based, Real and Planning, CO-PA reports developed
  • Coordination between user requirements and CO PA functional team.
  • Determination of Profitability Matrix using COPA, Sales and Product Costing data from COPA
  • FIGL report reconciliation with COPA reports
  • Responsible for migrating a stabilize BW datawarehouse to SAP HANA and subsequent planned migration to
  • SAP BW4HANA connected to Business suite.
  • Activation of Hana Live report and real time reporting using enterprise HANA live reporting
  • Create various ABAP CDS views and reuse some of the HANA live view as extended views in ABAP
  • Customized and created different real time report using SLT as data provisioning.
  • Design real time reports using a combination of HANA live report and historical data from BW
  • Enterprise business reporting using SAP BO 4.2 and SAP FIORI
  • Created SAP HANA information models such as Procedure and Hana Views (Attribute, Analytics and Calculation views) with graphical and SQL Scripting, SDA (Smart Data Access), SDI, and reporting on SAP HANA Live (Analytics) and performed ETL scenarios with SAP HANA (using Data Services/SLT/Sybase replication), and Predictive Analytics on SAP HANA
  • Created Schemas, imported tables and loaded data to table and copied standard content from SAP to local repository using SAP HANA
  • Design enterprise Qlikview and Qliksense report
  • Worked on a large scale and data volume based applications.
  • Worked on SQL scripts to load the data into QlikView applications.
  • Worked on migrating applications from QlikView to Qlik Sense and took part in resolving critical compatibility issues during migration.
  • Responsible for gathering requirements, business, and technical rules, implementing QlikView and Qlik Sense applications.
  • Implemented Incremental load & Binary loads to optimize the Reports and for performance tuning.
  • Loaded the data from multiple data sources to build the consolidated Dashboards.

Confidential, OH

SAP HANA/BW Solution Consultant

Responsibilities

  • Full life cycle of SAP HANA implementation, which involve Requirements gathering, Blue printing, Development, Testing, Reporting, Go-live and Post Go-live support.
  • Established the best modeling and recommended strategies and architecture for SAP HANA.
  • Build SAP, Non-SAP data flows to create information model for user consumption View Calculation View.
  • Worked on trigger based data replication for SAP ECC using SAP Landscape transformation (SLT).
  • Established the best modeling and recommended strategies and architecture for SAP HANA.
  • Assists BI COE Team to define HANA Modeling standards and best practices, release management process, validation, and testing process
  • Migrated HANA content from development, testing environment to Production environment using delivery units.
  • Developed Real-Time Information models to support SLT replicated tables from SAP ECC.

Confidential, Houston, TX

SAP BW/HANA Solution Lead/ Consultant

Responsibilities:

  • Requirement gathering with the business community and all the SCM business analyst
  • Designing and developing the Technical specification document based on the functional specification document.
  • SAP HANA Live rapid-deployment solution to support faster, easier analysis of operational data on in-memory platform.
  • Strong experience in carrying Functional, Integration, Latency, Performance, reliability testing for various Business Objects Enterprise suit products.
  • Established the best modeling and recommended strategies for BOBJ environment and architecture for Native SAP HANA.
  • Responsible for blueprinting, requirement gathering, design, strategy and eventually the build of SAP HANA.
  • Responsible for blueprinting, requirement gathering, design, strategy and eventually the build of SAP HANA.
  • Performed pre-migration activities for BW on HANA implementation from 7.3 to 7.4 and optimized BW modeling objects as per the need for BW on HANA.
  • Created functional and technical specifications for Data models based on BW on HANA.
  • Designed and created Master data HANA Attribute views.
  • Designed and created Analytical and Calculated Views as per the reporting needs.
  • Extracted data from legacy system to HANA database using Data services.
  • Created analytic indexes and composite provider based on HANA View and BW Infoproviders as per the reporting needs.
  • Worked on redeveloping of Bex web templates to Design studio with a different User Interface using different customized cascaded style sheets.
  • Created a Complex dashboards for Supply chain, sales, production planning, HR Head Count and FI.
  • Developed flexible queries with variables using filters, Navigational attributes, Restricted Key figures, Calculated Key figures, Reusable structures and Currency translation factors in bex.
  • Worked on post go live production support in monitoring data loads, fixing and improving performance of load issues and investigating in finding root cause for data issues and worked extensively on support tickets.
  • Enhance most of the 2LIS 02, 2LI 03, 2LIS 05, 2LIS 04, 2LIS 11,12,13 and other related Logistic datasource in ECC based on the Technical specification requirement.
  • Production planning capacity report for both ECC and APO
  • Build custom Function module based generic extractor for SAP Vendor Invoice management and replicated these datasource into BW
  • Developed various transformations to cleanse the data and enhance the master and transaction data using Formula Builder and start and transfer routines with ABAP4 to suit the business requirements
  • Populated various data targets like Infoobjects, ODS and Infocubes, with Master data and Transactional data from ECC 6.0, legacy systems using flat file interface via Data Staging area (PSA).
  • Open Hub interface to transfer data from BI to Flat Files to load to an external system.
  • Worked with Datamarts, Myself source, Generate export Datasource and Replication
  • Created DTPs, Infopackages for Full, Initial, Early init, Delta and Full repair loads for both Master data and Transaction data
  • Created process chains using various process to automate data loading, activation of DSO, compression, drop and create indexes, attribute change run etc.,
  • Performed huge data loads into DSO and Infocubes from ECC as well as the legacy systems
  • Debugging the Extractor checker, Start routines and End routines
  • Performance Tuning - Evaluated statistical performance and provided recommendations for optimization. Improved data load and query performance by doing compression, aggregates, and partitioning.
  • Developed Queries to access data from various BW Infoproviders like DSO, Infocubes, Infoobjects, Multiproviders and Infosets using BEx query designer
  • Created Jump queries (using RRI), Restricted Key Figures, Calculated key Figures, Filters, Conditions, Variables and Structures
  • Created various interfaces from BW to various non-SAP systems using APD and OPEN HUB.
  • Reporting Strategy for business objects. Designed Self Service Model for Adhoc Reporting.
  • Designed Training Material for User Adoption for BI tools.

Environment: SAP BI 7.31/7.4, SAP S4 HANA, HANA 1.0 SP9/SP10, Simple Finance 2.0, HANA Live, ECC 6.0, PS, PM, QM, FI, HR, BPC, WEBI and Design Studio.

Confidential, Shelton, CT

Sr SAP BW/BOBJ Consultant

Responsibilities:

  • Expert in requirement gathering, documenting the requirements, designing and then implementing the solution for different complex Requirement.
  • Involved in the overall design and implementation of SAP Business Intelligence solution which includes analysis, design, development, performed reviews, support and tuning of large, complex integrated reporting systems.
  • Applied deep understanding of SAP BW to design solutions, troubleshoot issues both on the SAP BW and Business Objects side to maintain satisfactory report generation performance.
  • Expert in evaluating and recommending best approaches and tools to support business and technical requirements.
  • Designed Real Time reporting in SAP BW on HANA with for the QM Inspection Lots and Reporting in the Business Objects WebI and crystal reports.
  • Configured SAP tables in SLT for real time data Replications.
  • Created Composite providers for Real time reporting.
  • Worked on the Forecasting Reports from the APO/ECC systems
  • Created Attribute Views, Analytical Views and Calculation Views in Hana Studio
  • Prepared Technical Specification and Design Documents for the ETL (BusinessObjects Data Services), SAP BW Development for the Microsoft SQL Server 2008 Source Data.
  • Developed Custom Objects in SAP BW (InfoObject, InfoSource, HANA Optimized DSO, Transformations, HANA Optimized InfoCubes & MultiProviders).
  • Developed Flat File Interfaces in SAP BW
  • Interacted with SAP BODS offshore team for the ETL Development.
  • Created Reports for ULTA Salon analysis in BEx, BusinessObjects Dashboards & Web Intelligence.
  • Interacted with the Business Analysts and Finance Users during User Acceptance Testing and Resolved the UAT issues
  • Involved in SAP Transports, Cutover Activities and Historical Data Loads from the Source.
  • Data Validation with the Source System
  • Created New Process Chains to automate the Data loading Process.

Sr. SAP BI CONSULTANT

Confidential

Responsibilities:

  • Involved in Full cycle Implementation of Integrating the functional areas MM, SD and FI/CO with BI. Responsible for Design of data models, comparing the model with delivered contents and implementing the business logic with delivered contents along with modifications.
  • Good functional knowledge of Sales & Distribution (Sales Orders, Deliveries & Billing), MM (Purchasing), FI and general business process of SAP R/3.
  • Activated Sales and Distribution, Purchase Info cubes and DSO objects from the Business content and customized according to business needs.
  • Performed statistical setup for purchase, Sales, Billing and Shipment and extracted the data to BI.
  • Customized Lo Cockpit data source to include custom defined fields and populated those fields using customer exits before the setup.
  • Worked on CRM-Sales, Marketing Analysis, Account Plan, Lead Management, Opportunity Management, Activity Management and Interaction Center verticals.
  • Created complete data flow from CRM which includes extractors, Infoproviders, Transformations, DTP’s and Process Chains.
  • Worked on Extractors 0CRM SALES ACT 1, 0CRM LEAD H, 0CRM LEAD I, 0CRM OPPT H, 0CRM OPPT I, 0CRM ACCPLN ATTR, 0CRM SALES ORDER I.
  • Worked with the datasource 0BPARTNER HIER to load Account Hierarchy data into 0BPARTNER and involved in extracting the Marketing attributes data using the datasource 0CRM MKTATTR ATTR.
  • Enhanced the extractor 0CRM SALES ACT 1 to pull the ‘Activity Completion Date’ and ‘Account Plan ID’.
  • Used LO extract structures for extracting sales order, delivery-billing information.
  • Extended standard Business Contents based on client requirements using User Exit and Function Module.
  • Involved in different phases of the project including Project preparation, Blueprint phase and Realization for the BW international Implementation.
  • Interacted with the Management and Business End Users to identify the reporting Requirements.
  • Prepared Technical Design Documents based on the Functional Specification for the new business requirements.
  • Referred Global Templates in the solution Manager to understand the Business Process.
  • Extensively worked on SAP Financial Accounting (FI) and Controlling (CO) Reporting and Interfaces.
  • Created Costing-based profitability analysis CO-PA DataSource for International operating concern.
  • Activated and Extracted data for various dataSources for FI/CO from ECC to BW
  • Created Open Hub Destination to distribute the SAP BW data to Oracle Essbase in the Flat File Format.
  • Developed Queries in BEx Query Designer
  • Created Web Intelligence document based on BEx queries.
  • Created prompts, formula variables, charts, tabular reports, cross tabular reports using Web Intelligence.
  • Setting up security and roles in Configuration Management to control user access to the Web Intelligence documents.
  • Analyzed and Fixed the QC Defects that were raised during the UAT by Business Users
  • Created the Change Request (CR) for the New Requirements that was not part of the Functional Specifications and followed the Standard Process.
  • Designed and Created Process chains for the FI/CO Data Loads and Coordinated with the Control-M Team to define the Predecessor & Successor Job information.
  • Involved in the BW Transport Management, Cutover and Production Supp

Environment: SAP BI 7.0, SAP ECC, CRM, SD, MM and FI modules, Windows 2000/NT.

Confidential

SAP BW CONSULTANT

Responsibilities:

  • Responsible for developing BW data models and designs, configuring custom and delivered content BW objects, analyzing BW reporting requirements, developing detailed reporting specifications.
  • Thorough understanding of the Functional specifications and outstanding issues related to specifications.
  • Frequent meeting with the functional team to resolve the outstanding issues and regular updating of functional specifications.
  • Responsible for developing High level Data flow and revising the Gap Analysis.
  • Worked on extractions from heterogeneous Source System including SAP and non-SAP, Developing SAP BW Objects, applying Extended Star Schema modeling principles in Data Design, and used expert knowledge of data warehousing concepts.
  • Developed basic cubes for Premium’s, Claim’s, and Sales data.
  • Built various Multi providers on Premium, claim, Sales, Profitability Cubes.
  • Extensively involved in setting up of procedures for extracting data from SAP R/3 by using generic extraction.
  • Developed infosources and Written several routines in Update and transfer rules.
  • Developed Infospokes on Premium and Claims Cubes to extract the data so as to correct the data in production system.
  • Created extractors to extract CO-PA data for the relevant Operating Concerns from SAP-R/3 into SAP BW and created corresponding InfoSources, ODS Objects and InfoCubes in BW.
  • Extensive knowledge in FICO- Finance & Controlling (General Ledger, AR and AP).
  • Designed and developed ProcessChains (RSPC) for master data loads and transactional data loads with the help of info packages. And these process chains are scheduled for periodically.
  • Extensively worked on setting up authorization objects, roles, transporting them, and involved in testing reports based on various roles.
  • Interacted with management and end-users to gather the requirements.
  • Configured and Installed Business Content extractors in various functional areas like SD MM and FI/CO to meet the user requirements.
  • Extended Extract Structures/Info Sources based on client requirements using Function Modules & User Exits.
  • Implemented LO Cockpit extraction for Sales Orders, Delivery, Billing, Purchasing and Inventory Management
  • Extracted data for various data sources from Purchasing, Material Management, Sales and Distribution, HR, FI-GL, FI-AR, FI-AP and CO-PA data from ECC to BI.
  • Extracted HR payroll data, Benefits and Travel expenses from ECC to BI
  • Extracted data from different sources systems like flat files
  • Enhanced new Info Objects to be mapped into InfoSources/Communication structures. Created transfer rules and update rules for data consolidation and cleansing.
  • Extensively worked on Transformations and DTPs.
  • Created DSO objects to stage the data from different data sources and transferred the ODS contents into various data targets and Info Cubes based on the requirement
  • Checked for data consistency and modified the data in PSA before loading them to data targets

Environment: SAP BW3.5, SAP R/3 4.6C/4.7, ABAP/4, FI/CO modules, Windows 2000/NT.

We'd love your feedback!