We provide IT Staff Augmentation Services!

Sap Hana / Bo Consultant Resume

Baltimore -, MD

SUMMARY

  • 6+ years of Professional experience on SAP Analytics and expert at managing and delivering SAP projects with a focus on SAP BI/BOBJ and SAP HANA with Strong technical and functional expertise in all phases of the project life cycle, from initial assessment and road mapping to feasibility analysis and conceptual design through Implementation and enhancement and on various project management methodologies.
  • Worked on several complete life cycle Implementations from blueprint to production support.
  • Extensively involved in business requirement gathering and converting the business requirements into preparing the functional and technical specifications accordingly.
  • Worked on implementing SAP BI solution involving overall solution architecture, design and deployment.
  • Experienced in recommending best approaches/practices to clients and evaluating tools to support business and technical requirements.
  • Experienced with data extraction from SAP/Non - SAP Source Systems using SLT, BODS, SDI and SDA.
  • Well versed in SDLC, Waterfall, Agile implementation methodology.
  • Expertise in Lumira, Webi, Crystal Reports, SAP BO Explorer, Analysis for Office/OLAP.
  • Expertise in using Analysis Process Designer to provide solution for complex business requirements.
  • Extensive Experience in Native HANA (1.0 and 2.0) and HANA Studio all aspects Data modeling scenarios (Attribute View, Calculation View, Analytical view)
  • Multi-dimensional modeling using new HANA features like star-join.
  • Extensive Experience in activities of developing schemas, importing table definitions, adding connections.
  • Developed views in HANA using Attribute Views, Analytical Views and Calculation Views with various scenarios including multiple parameters, variables, binding parameters/variables from top to bottom and vice versa.
  • Worked on modeling scenarios to create HANA custom table to materialize data using Stored procedures and created XS job for scheduling.
  • Experienced in SLT and Data Service Models to import data into Native HANA system.
  • Worked on Flat file data source creation in Business Objects Data services (BODS) and imported the SAP BI tables into BODS which serves as the BI data source including importing the HANA tables. Extensively worked in the replication technique using SAP BODS for creating data flows, build HANA models, front end BO tools - IDT, Web Intelligence and BO business explorer.

PROFESSIONAL EXPERIENCE

SAP HANA / BO Consultant

Confidential, Baltimore - MD

Responsibilities:

  • Designed and created HANA Information Models such as Attribute Views, Analytical Views, Calculation Views and Stored Procedures
  • Created SQL based and HANA database tables (HDB) in HANA
  • Apply advanced data modelling techniques, including currency conversion, variables and input parameters
  • Performed SLT replication to migrate ECC tables to HANA for real time replication
  • Created remote connection to Hadoop system and exposed virtual tables in HANA using Smart Data Access - SDA
  • Performed data cleansing activity, transformation and created flow graphs in HANA using Smart Data Integration - SDI and Smart Data Quality - SDQ
  • Created Logical Design Model - LDM and Physical Design Model - PDM using Power designer and created HANA tables by leveraging power designer models
  • Working with different type of joins: Inner Join, Left outer join, Right outer join, Referential join and Text Joins.
  • Created COPA related queries using BO Analysis for Office
  • Pre-and-Post HANA migration activities for BW on HANA including pre-migration housekeeping tasks and post-migration issues fixes.
  • Worked with the business analyst to understand and document the functional requirements.
  • Performed modeling exercise to address the functional specifications
  • Developed reports using the advance Webi functions like, merge query, context measures and ranking.
  • Created several calculation view and analytical view to support the functional requirements.
  • Worked with the SAP Basis team to setup the SLT replication for SAP source and SAP Data Services team to load the non-SAP data in SAP HANA.
  • Design the solution to integrate the SAP and non-SAP data using HANA Studio.
  • Developed analytical views to integrate different tables.
  • Worked on the Life Cycle Management to transport delivery unit.
  • Created universe (using IDT) on HANA views to expose the data in BO 4.0/4.1 Webi.
  • Optimized the SAP HANA view for Ad-hoc reporting using Webi and BO Explorer.
  • Created dashboards with dynamic data from SAP HANA
  • Created dashboards with functionality and features such as What-if analysis, Alerts, Drill Down, Filtered Rows and Dynamic visibility.
  • Leveraged aggregate aware in the ad-hoc universes to dynamically select appropriate aggregate layer (fact table) based on the dimensions selected by the business users.
  • Created, maintained, and updated several universes using Universe Design tool and Information Design Tool.
  • Scheduled Business Object Reports to users using BI Launch pad.
  • Involved in performance tuning and optimization on Business objects reports and Universes.

SAP HANA Consultant

Confidential

Responsibilities:

  • Involved in full life cycle implementations, which includes Analysis, Requirements gathering, Development, Testing, Reporting, Go-live and Post Go-live support.
  • Performed HANA modeling and developed Analytical views for the transactional data, Attribute views for the master data, Calculation views and SQL Scripts.
  • Performed traditional and non-traditional data loads from legacy systems to HANA database.
  • Implementation of Replication technologies SLT with ECC to HANA System.
  • Extensively worked on ETL and Data Profiling from Source systems including flat files, legacy systems and SAP systems using SAP Data services.
  • Worked on HANA performance improvements by analyzing queries in terms of memory consumption, data transfers between nodes and time to process queries
  • Performed data extractions, transformations using BODS from BW and ECC and loaded to HANA.
  • Integrated BOBJ 4.0 and BODS 4.0 with SAP HANA.
  • Migrated HANA content from development, testing environment to Production environment.
  • Created Universes on top of HANA calculation views and developed the Webi reports using IDT (Information design tool)
  • Worked extensively to use the BODS for Project, Job, work flows, Data flows, Datastore tables, functions. These objects are also reused in other data migration objects.
  • Created Data Services mappings involved extensive use of simple and complex transformations like Key Generator, SQL Query Transform, Table Comparison, Case, Validation, Merge, lookup etc. in Data flows, Reverse Pivot, Pivot, Date Generation, Map Operation and Validation.
  • BODS debugging batch jobs, validating and tracing are used during project.
  • Understanding the business challenges and translating them into requirements and developed Analytics and Reporting Queries according to Business Requirements.
  • Created Analysis for OLAP and Webi Reports using the new BICS functionality.
  • Analyzed and translated the client' Confidential business requirements and functional specifications into technical specifications, data flow diagrams and data models.
  • SAP best practice techniques are used for entire projects on data migration, data integration and data quality

Business Objects Developer/ SAP HANA Modeler

Confidential

Responsibilities:

  • Worked at Confidential as SAP HANA Modeler and BO developer.
  • Worked with the business analyst to understand and document the functional and technical requirements.
  • Wrote functional and technical specification based on the business requirements.
  • Developed Attribute, Analytical and calculation views using graphical and SQL Script mode. Developed analytical views to integrate different tables.
  • Worked with onshore and offshore Business model, managed off-shore team of developers and conduct daily meetings to translate business requirements to development team.
  • Created Master Data views for dimensional modeling keeping in mind the global usage of Master views.
  • Helped defined Modeling best practices and package structure for reporting with Architecture team.
  • Created OLAP reports on top of information views.
  • Created reports in OLAP analysis.
  • Created analytic and complex calculation views using SAP HANA modeler.
  • Mapping the input parameters to underlying views and pushing filters to foundation tables.
  • Imported analysis authorizations to HANA as analytical privileges.
  • Transported development objects to Quality system using developer mode.
  • Experience in reporting techniques such as creating calculation views, managing attribute mappings, creating analytic privileges, adding variables.
  • Information Modeling in SAP HANA and Report Generation for Sales and Distribution module towards Comparative Analysis for pricing conditions.
  • Worked on SAP HANA transports using HALM, Delivery units as CST+.
  • Optimized the SAP HANA view for Adhoc reporting using Webi, analysis for office and Lumira.
  • Developed Fix formatted, and self-service reports based on the business requirements using Webi Intelligence and Analysis for office.
  • Created User Prompts, Conditions and Filters to improve the report generation.
  • Created Webi reports Publications in CMC based on User Profile to enable report bursting.

SAP HANA Consultant

Confidential

Responsibilities:

  • Performed end to end SAP HANA Implementation for Several Monsanto Business units Globally
  • Involved in Various requirement gathering sessions with several Monsato Business units across North America, South America and Asia.
  • Worked with the business team for requirement gathering and document requirement in functional specs.
  • Performed data provisioning using BODS and created ABAP data flow to load high volume data from ECC to Hana and developed transformations (Query, Table comparison Merge etc.) that apply the business rules as per business requirements.
  • Created analytic and complex calculation views using SAP HANA Modeler.
  • Mapping the input parameters to underlying views and pushing filters to foundation tables.
  • Designed and created HANA Information Models such as Attribute Views, Analytical Views, Calculation Views and Stored Procedures
  • Converted standard BW models into HANA optimized models and Imported into SAP HANA.
  • Performed fit gap analysis to utilize HANA live views on SAP FI, copied and leveraged standard content after performing custom modeling
  • Created information models for COPA multidimensional reports that include COPA variance and COPA Actual/Plan comparison reports using HANA studio

Hire Now