| | | 20,000+ Fresh Resumes Monthly | |
|
|
| | Related Resumes SAP BODS, BI/ BW, ABAP, HANA, Snowflake Ellicott City, MD Sap Basis Hana Herndon, VA Sap ECC,Hana and Fiori Administrator Ilchester, MD Project Management Sap Hana Ashburn, VA Sr. SAP analytics consultant South Riding, VA SAP Consultant Germantown, MD SAP EWM CONSULTANT Fairfax, VA |
|
Click here or scroll down to respond to this candidate SAP HANA BODS DeveloperCandidate's Name EMAIL AVAILABLEPh: PHONE NUMBER AVAILABLEProfessional Summary Having 6+ years of Extensive experience as Sap Developer on SAP HANA, SAP BODS & BW experience on implementation and support projects including data modeling, extraction and report creation. Produced estimates for projects. Had worked on multiple projects, coordinated design efforts within streams, handled interdependencies.Key Function Areas:HANA: Hands on experience in HANA modeling. Created Attribute views, analytical view and calculated views in Hana Classic and XSA. Configured and Extracted data from SAP ECC and SAP BW to HANA Data Base using SLT, BODS and DXC Methods of Data Provisioning and SDA and SDI from SAP to Non SAP and vice versa. Optimization of the modeling using Calculation Engine (CE) operators in SQL Script and created Stored Procedures. Experienced in creating Input Parameters and variables, Calculated columns, Restricted columns etc in Hana. Knowledge on tables of S/4 Finance like Acdoca etc. Application of HANA In-Memory concepts. Had done Performance Tuning in HANA Database. Had created Technical Specifications. Had compared Object Versions and validated information models. Had worked on Back-up and recovery. Experience in sizing and scaling of SAP HANA. Knowledge on Hana CDS Views, table functions, AMDP. Had created Odata services. Experience in Hana SQL Join types. Experienced in transporting the Native Hana Content from development, testing to Production by using delivery units. Experience with s4/hana migration initiatives in sap OCM/SOM modules. Experience in SAP UI developments and installations tools. Understanding of creating dashboard stories in SAP Analytics cloud. Experienced in Evaluation and detailed presentation to compare As-is and Hana Proposed scenario. Participating in all Technical discussions, Meetings and requirements gathering, Prepare Functional / Technical Specification blueprint and mounting the discussion points.BODS: Extensively used ETL Methodology for data Extraction, transformation, loading data using Data Integrator. Familiar with creating Jobs, Workflow, Data Flow and Scheduling Batch Jobs and migrating jobs in Data services. Experienced in creating Variables, input parameters and loading Flat files in Data services. Good knowledge on creating SAP BW connection to interact with SAP BODS using RFC connection. Goodhands-onexperienceonData provisioning using SAPLandscapeTransformation(SLT), Smart data Access and SAP Data Services. Created multiple data store configurations in Data Services Local object library with different databases to create unified data store. Good understanding on different types of transformations like Query Transformation, Merge, Case, Validations, Map Operations, History Preserving and Table Comparison transformations etc. Used LOOKUP functions to derive the column in BODS ETL by lookup table of type validity tables. Strong experience in DWH Technologies (Netezza, SQL). Performed SAP data Migration by using Business Objects Data Services as the ETL Tool. Manage data provisioning, migration and cleansing from legacy to target system using BODS. Experience loading data using LSMW, IDOC and Files. Experienced on SAP BODS Information steward like creating the rules, binding the rules, score card setup and data profiling.BW on HANA: Knowledge on creating HANA-optimized Datastore Object and HANA-optimized Info Cube for faster reporting, to accelerate data loads, simplify data modeling and to allow faster remodeling of structural changes. Knowledge on ADSO, Composite providers, BEx Query using BW Modelling in Hana Studio. Knowledge on creating Virtual Infoproviders, Transient Infoproviders and Composite Providers in BW on top of HANA Model. Knowledge on creating DB Connect to load data from HANA to BW.
Knowledge on Layered Scalable Architecture plus plus (LSA++) with SAP HANA.TECHNICAL SKILLS:Data ExtractionSAP DS/BODS, SLTData ModellingAttribute view, Analytic views, calculation view graphical and Scripted Views, Procedures and views, currency conversion, time dimensions, Hierarchies.Reporting ToolsSap Analytics cloudPerformance Tuning&AdministrationMigration of Hana Models, delivery units& partitioning and compression.ETL Sap DS/BODS,InformaticaDatabase MS SQL.Project: Southern California Edison (SCE)Location: San Francisco, CA May 2022- Till Date Roles & Responsibilities: Data modelling in creating Native Hana artifacts like Attribute View, Analytic and calculation view. Created Stored procedures and migrated to different environments of Hana. Created Native Hana modelling Scenarios and Activities such as Adding System, creating Schema and content models, Attributes, measures, Hierarchies. Created input Parameters and variables based on the business requirements. Transported Hana Content from development, testing to production environment using delivery units.
Loading data into Hana Database using SLT, BODS. Bringing data from ECC and flat files. Experience in importing meta data, Table definitions, performing initial load and replications, resuming, and suspending the data loads using Hana Studio. Created high level and detailed Native Hana implementations and migration plan document. Evaluation and decision detailed presentation to compare as is and Hana proposed scenario. Extensively used ETL Methodology for Data Extraction, Transformations, Loading
Using Data Integrator. Created Jobs, Workflows, Data flows, Formats, Data store, Scripts. Involving Migration, UAT & solve the issues raised by users. Had done unit testing to test the data based on user requirement. Troubleshooting the performance issues.Environments: SAP HANA XSA 2.0 SPS07, BODS 4.2 SPS14, SAP ECC6.0, S/4 HANA 2023, SQL Scripting.Project: Novartis
Location: Hyderabad, India June 2021 May 2022Roles & Responsibilities: Create Jobs, workflows, data flows as per project requirement. Scheduled the batch jobs based on user requirements. Loading data into Hana Database using BODS fromSAP BW &ECC and flat files. Created Datastore which is used to set up connection with Hana database. Data modelling in Native Hana using Attribute View, Analytic and calculation view. Transported Native Hana Content from development, testing to production environment using delivery units.
Involving Migration, UAT & solve the issues raised by users. Prepare technical or functional document based on requirement. Extract source data using BODS and SLT to Hana to perform Native Hana modelling. Configured Email Notification to the Business users when the rules refresh happened. Testing step by step Business review with client and IT Team.Environments: SAP HANA XSA 2.0 SPS07, BODS 4.2 SPS14, SAP ECC 6.0, SQL Scripting.Project: Landmark GroupLocation: Dubai, UAE Jan2019 June 2021Roles & Responsibilities: Performed Native Hana data modelling and developed Analytical views for Transactional data, Attribute views for master data and calculation view as the final model in Hana Studio. Creating input parameters, variables, calculated columns, restricted columns on top of views in Native Hana. Extract the Netezza data into Hana by using SDA connection. Reconcile the Netezza data with Hana Data. Experienced in SAC performance by using AUTOIT Tool. Pull the data usingVirtual table creation with SDA Connection Analyzing the Stored Procedure to test for Sales and Stock and had gone through the LLD documents. Preparing Technical specification document to capture the Logics and dataflows.Environments: Sap Hana1.0, BODS, Sap Analytics Cloud, Netezza, SQL Developer, AutoIT Tool, BINGO Tool.Education:Bachelors in computer science and engineering, JNTU Kakinada. |
