Senior Hana Sdi Consultant Resume
SUMMARY:
- Having 7.5 Years of Experience in SAP Software Development.
- Created custom Rest Adapter to consume Restful API with OSGI framework.
- Worked in SAP SLT Replication in ABAP,BW HANA SDI flowgraph with AWS S3,SAC.
- Worked in Hive adapter and extensive knowledge on Kafka adapter and Hadoop.
- Handling EIM and AMS, BW - IP planning modeler and BPC activities in Confidential .
- Create HANA objects such as Calculations Views, Stored Procedures, tables, etc. to meet functional requirements for Procurement and HR dashboard.
- Reverse-engineer existing BW Data Flows and rebuild as native HANA solutions
- Ability to write SQL scripts and stored procedures, function calls, designing tables, data loads, and building, modifying, and integrating into HANA views. worked in BW on HANA using all HANA optimized info cubes and ADSO.
- Working knowledge in web based SAP DATA HUB Launchpad with Metadata as source.
- Had a extensive knowledge in SAP HANA VORA for structured hierarchies from HADOOP Data.
- Handful Experience in SAUDI ARAMCO, Confidential, ALMANSOORI for BW/BO And HANA Modelling and VAT implementation in ABAP for KAAR TECHNOLOGIES.
- Done Phase Implementation in BW for HANA 7.5(SGS) and Overview Knowledge on BW on HANA.
- Hands On Experience in BOBJ creation SSO and importing roles users in CMC created Universe.
- Created Dashboards on HCM and Procurement Sales in Xcelsius, POWERBI and ETL like BODS.
- Involved in Data-modeling,Data-extraction,Data-loading,Scheduling,monitoring,reporting LSO,MM.
- Proven Experience as ABAP, ABAP Programmer in primarily HR, FI, SD, MM, PM, EHSM.
- Expertise Knowledge on DDIC, Views, Reports, Smart Forms, Adobe Forms, User exits and BADIs
- Worked on Component Enhancements, WORKFLOW, DDIC,ODATA Function module, BADI s, BAPI s, Proxy interfaces (sproxy), Enhancements, Reports (classical and interactive), ABAP OO, ALV Reports, and SAP Scripts.
- Prepared Technical specification, Technical design review report, Unit Test Reports and unit test review Report.
- Responsible for delivering the code into the production system and providing supportduring System Integration (SIT) phase and UAT Phase.
- Have done peer code reviews, ensuring the standards are followed and documented the same.
- Worked in Shifts in chronological order as per the schedule as per client s Requirements.
- A good team player with good communication skills and possess an ability to work in a team-oriented environment.
KEYSKILLS - BW/SDI/HANA/BO/ABAP:
HANA - Design and integrated exiting BODS and SAP SLT with HANA and Data Load via SAP BW DXC defined Extractor enabling xsengine and import delivery unit HANA from Legacy BW.
BW - Experienced with creation and maintenance of InfoObjects, InfoCubes, DSO, MultiProviders
,InfoPackages and Process Chain according to the reporting requirements,LO and COPA.
BW/ABAP - Experienced in creating Generic DataSources and Enhancing Standard DataSources.
BW - Experienced in creation and maintenance of Transformations, Various Rule Types and Routines and used Structures, Formulas, Calculated Key Figures, Restricted Key Figures and Customer Exit Variables.
BI -Worked in Standard BI Content Installation and Process Chain Monitoring.
S4/SAC - Worked in SAC from CF to NEO from S4 Hana as Source through SAC.
BO WEBI - Experienced in designing Web Intelligence Reports.
BO Dashboard - Experienced in designing Dashboard Reports using Xcelsius Dashboard Tool for better assessment of Business Data and POWER BI Dashboards .
BOBJ-Having Sound Knowledge in LUMIRA DESIGN and DISCOVER
ABAP - Worked in the areas of Data Dictionary Objects, ALV Reporting, BDC, BAPI, Module Pool Programming, Enhancements and Debugging, ABAP ON HANA.
HANA - Have Skillful knowledge pertaining to creation of Calculation view through HANA Studio and Worked on BW For HANA 7.5 .
TECHNICAL SKILLS:
Programming Languages: SAP BW/BO,ABAP,SDI HANA XSA,ODATA,SAP SAC,S4HANA, C++, java
Database: MYSQL,ORACLE,HANA,AWS fileshare S3 Cloud.
Operating System Application: Windows 9X/NT/XP/2000/2007/8 SAP ECC 6.0,ECLIPSE,HANA Studio, XCELCIUS, DS 1.6,BW 3.x,BW 7.4,BW 7.5
PROFESSIONAL EXPERIENCE:
Confidential
Senior HANA SDI Consultant
Responsibilities:
- SAC user stories and Dashboards though ODATA V4 Adapter as S4 HANA as source with linked dimensions.
- Set up of DP agent and Host system for SDI from scratch and Configured SDI file adapter to S3connection.
- Storage Gateway and SMB File share is created with Lambda Scheduler and mounted in AWS S3 bucket. endtoend SDI flowgraph Transforms for CSV, Xlsx, Fixed Width Vendor file using remote source and virtualtable
- Setup SAP HANA SLT with RFC and ECC System using LTR Transaction and replicated ECC and BW Tables.
- Worked on SAP HRF with CV, Vocabularies, TextRuleFramework resulted as View Procedure in bods.
- Created Custom Rest Adapter for REST API Consumption using SDI and its build with OSGI Framework and exported adapter as .JAR file and Imported in DP agent.
- Done Pivoted and unpivot HANA Stored Procedure with Dynamic SQL and used in BODS and SDI.
- Combined Equities and SI Factset Views as single calculation view and called inside procedure.
Confidential
Senior BW HANA Consultant
Responsibilities:
- Done SQL scripts and functions for complex reusable logics in HANA CDS Views, Procedures AMDP Class.
- Created HANA database users, role, analytical privileges for data and data model security.
- Developing reports on Calculation View / Analytic View using Webi Explorer and Configured CO-PA HANA Accelerator/RDS, Sequences.
- Build SAP FI, SD data to build information model for user consumption Attribute View, Analytical View, calculation View .
- Created SLT Replication and has working knowledge in SDA and SDI from HADOOP.
- Created Planning modeler with data slices for planning CBSmodule.
- Created input ready query for planning and attached Documents in Bex queries for analyzing.
- Monitored AMS activity and EAM activities includes Meta chain in BW PRD.
- Debugging background job and analyzing Data Archival write and sub jobs with ADK.
- PDPA activities in Confidential for HCM done in automation of ZReport includes LCP patch upgrade in PRD
- S4HANA POC is initiated by converting Unicode system and SUM upgradation S4HANA .
- SAP Datahub Modeler has Data orchestration, connected operators with port as Pipelining, Workflow and governance sample graph from HDFS Source it parses the data, loads data to Vora Table and consume byother tools.
- Done Data injestion from SAP HANA.
Confidential
Senior HANA Consultant
Responsibilities:
- Created Dimension Calculation views to get master data, Calculation views (with cube or Star Join) to get fact data and utilized Star schema model.
- Creating information objects/Data models (packages, calculation views, Decision tables, Stored Procedures).
- Created HANA models using both physical tables and virtual tables.
- Created Analytic Privileges based on filters required as per the users using the privileges like restriction based in country and region etc. using normal filter and stored procedures upon the data models.
- Created Input parameters, Variables, Calculated columns, restricted columns (KPIs) according to the business requirement.
- Created Calculated Measures and Restricted Measures in Aggregation node to serve different business requirements.
- Worked on performance tuning the HANA models using Explain plan and Visualize plan.
- Discussed feasibility with functional and End to End Requirement gathering from Client for development in realization Phase.
- Created Hana calculation view in development phase for Procurement and inventory Dashboard with complex logic and calculations in MM Module
- Developed Hana Modeling for HR Module for Over time and employee Report with accurate logic.
- Developed Dashboard for Both MM and HR Dashboard in POWER BI and Xcelcius Tool with analysis KPI.
- Created Lumira Designs for supportive Tickets .
Confidential
ABAP/BW Consultant
Responsibilities:
- Done Financial Reports for SGS in S4 HANA for both actual and plan Tables ACDOCCA, ACDOCCP.
- Prepared BBP for Complete Requirement gathering for MM,SD,FI,CO,HR,LSO.
- Done Generic Extractor using FM for both Full and Delta load.
- Done HANA Modelling and consumed Universe for BO Development.
- Worked with SAP BI and BOBJ Business users, Project managers and architects in requirement gathering, analysis and creation of best practice architecture
- Good Working knowledge on creating universes using IDT on SAP HANA views and FI and MM HCM reports development on the same using Web Intelligence .
- Worked with SAP BI and BOBJ Business users, Project managers and architects in requirement gathering, analysis and creation of best practice architecture
- Used Information Design Tool to create Relational Connection, Data Foundation and Business Layer and accessed the data in HANA through BOBJ Crystal Reports, BOBJ Dashboard Design, BOBJ Web Intelligence Webi, BO Analysis.
- Involved and analyzed in creation of 8 Web Intelligence Reports with different functionality like cascading prompts, drilldown, Scope of Analysis, charts, ranking, alerts and implemented with row level security.
- Had a good working experience in SAP Lumira Designer 2.0 and Lumira Discovery.
- Requirement gathering done with End users for MM and HR,LSO modules.
- Installed all Required ADSO data target in standard and gone for custom extractor wherever if its necessary.
- Procurement ADSO like /IMO/D PUR10, /IMO/D PUR11, /IMO/D PUR12, /IMO/D PUR13,/IMO/D PUR14, /IMO/D PUR21.
- Good Working knowledge on creating universes using IDT on SAP HANA views and FI and MM HCM reports development on the same using Web Intelligence .
- Worked with SAP BI and BOBJ Business users, Project managers and architects in requirement gathering analysis and creation of best practice architecture
- Used Information Design Tool to create Relational Connection, Data Foundation and Business Layer and accessed the data in HANA through BOBJ Crystal Reports, BOBJ Dashboard Design, BOBJWeb
- Involved and analyzed in creation of 8 Web Intelligence Reports with different functionality like cascading prompts, drilldown, Scope of Analysis, charts, ranking, alerts and implemented with row level security.
- Had a good working experience in SAP Lumira Designer 2.0 and Lumira Discovery.
- Requirement gathering done with End users for MM and HR,LSO modules.
- Done Realization Phase For SGS With all Required FS And Completed till Bex-Queries/IMO/V PUR01 Q0001,/IMO/V PUR02 Q0001.
- Installed all Required ADSO data target in standard and gone for custom extractor wherever if its necessary.
- Procurement ADSO like /IMO/D PUR10, /IMO/D PUR11, /IMO/D PUR12, /IMO/D PUR13, /IMO/D PUR14, /IMO/D PUR21.
- Done VAT Implementation For Confidential in ABAP with VAT RETURN Report and Invoice inABAP.
- Installed info source for inventory /I /IMO/MMIM IS00 MO/MMIM, /IMO/MMIM IS01, /IMO/MMIM IS02for BX,BFUM Respectively.
- Installed EDW-ADSO for Inventory Reports.
- Material Stock - Quantities - /IMO/D MMIM01. Material Stock - Values - /IMO/D MMIM02.
- Material Movements (Documents) - /IMO/D MMIM10. Stock Overview /IMO/V MMIM01 Q0001.
- Obsolescence and Variance /IMO/V MMIM01 Q0003.
- Done Performance Optimization for the views with Plan View,Plan Execution and Trace..
- Done EMBEDDED BW on ECC For MOC Module implementation With ODP and Transient Provider.
- Done VAT Implementation For Confidential in ABAP with VAT RETURN Report and Invoice in ABAP.
- Created Genic Extractor With Delta Enabled for SAGIA and SAUDIA. loaded Setup tables in LO Extractor for SD- Delivery and billing in Confidential .
- Installed BI content for various modules.
- Installed Tranformation and created DTP for each Info Area targets.
- Done BEX Query for all Data Targets along with multiprovider.
- Done Dashboards and WEBi Reports to attain complex scenarios.
- Complex Scenarios are handled with ERROR DTP and Transformation routines.
- Attained good working Knowledge about 3.x BI contents and various Functional modules.
- Monitored Process chain and meta chain for Delta loads.
- Enhanced Master data for 0Material and 0employee attr Loaded RSDS with 3.x Dataflow with TRCS.
- Done HR Cost Comparison Report and enhanced ZHR035 BI REPORT for Al-Khosamagroup.
Confidential
Senior ABAP Consultant
Responsibilities:
- Created DYN Programming for Cash Management.
- Created WORKFLOW for PO, PR Creation and change for triggering Mail.
- Enhancement in WEB portal SAP Class Implementation.
- Created Overtime reports USING LDB and Logical Database for USER UI5Applications.
- Created SES workflow for Generation Workitems in Email as Hyperlink.
- Created various ADOBE INTERACTIVE FORMS for HR Applications.
- HR Overtime Application, Overtime reports with PDF forms both in English and Arabic.
- Done Workflows for MM module like PO, PR, SES Approval Workflows, Paymentreport
- Trip management workflows in HR side, and ODATA for Business trip.
- Done GOS enhancement for OBJECT LINKS in MIRO and Dialog programs for FI modules.
- Payment Report for QATAR is developed using Native SQL.
- Developed ODATA services for Windows Applications.
Confidential
Senior ABAP Consultant
Responsibilities:
- Created ADOBE FORM Equipment for displaying Item wise Data With Graphic images.
- Created ODATA Services for Personal Data with Service Extension.
- Created ODATA class enhancements for Windows Extension application for PEST CONTROL SERVICES.
- Responsible for leading the technical team size of 6 members for ClientSharqawi.
- Responsible for preparing the Technical Design and also assigning tickets and developments to the team members and reviewing the developmentsin absence of Lead.
- Responsible for developing the application in development system and document the code review checklist with the same.
- Responsible to create the Unit Test Plan document with all the test cases possible for the application.
- Responsible for solving the defect rose.
- Developing Z transaction of ME9A report, budget consumption report ZBD CON
- Worked on HR modules predominately, Developed reports and adobe forms for End Of Service, Employee contract renewal, course booking workflow, Monthly Bank report generation, Idcard forms, Late coming, early leaving, Payroll enhancements and Developing New report for complete HR master.
- Worked on MM interactive reports and reports for Vendor Payment tracking - Displays PO, PR, Quotations to Invoice details for the better understanding of status of documents also worked in Inventory aging report.
- QM Inspection Report: This report was developed both equipment wise and Process Order wise. The Usage Decision for equipment was printed using AdobeForm.
- Enhancement to prompt user in MIGO and also Workflow to send the mails toCreators and also in PO change scenario .
- Developing the Sales order reports from SCRATCH similar to std. transaction VA05N
- Acquired Conceptual knowledge in SD and MM Business flow.
- Getting Trained in SAP UI5 Technology, Java Scripting and creation of O-data from SAP side.
Confidential
ASSOCIATE ABAP Consultant
Responsibilities:
- Expertise in Bapi, Finding Badi, BDC,LSMW and userexits
- Sound knowledge of SAP Technology, ALE, IDOC and RFC systemservices
- Proficient with ABAP Workbench tools (ABAP Dictionary, ABAP Editor, Area Menus, Smart-Forms, and SAP Script).
- Familiarity with standard SAP project management methods and tools.
- Conducted complex analysis, debugging, coding and testing.
- Involved in developing report for Master data in MM,SD and FI Module.
- Developed custom BAPI for Vendor master upload for XK01.
- Involved in developing LSMW in Master Upload for Internal order in FI and PO Migration in MM module.
- Created Smart forms for Purchase Order Line items with augmenting the Currency Enhance the Smart forms for Standard PO address Changes in Transaction ME21n with the ‘Z’ output type attached in NACE Output types MEDRUCK.
- Extensively worked on Object oriented programming ABAP with class, object interface,inheritance, friend function concepts.
- Worked in RFC creation for vendor using class Vmd ei api with method maintain bapi by accessing various line types in its structures.
- Created custom UPLOAD BAPI for vendor to upload vendor master with Pre validation for fields like company code, account groups with return structures BAPIRETURN and stamped the values in vendor master tablelfa1.
- Worked in Migration PRODUCT APPLOAD for Procure to pay process
- MRP, vendor selection, RFQ, potentialvendor,
- PR, PO,GR,IR,AP
- Worked in Migration PRODUCT for ORDER TO CASH process:
- Inquiry,quotation,salesorder,OBD,Billing,AR. Worked in IDOC method:
- MATMAS
- MATMAS01 is Idoc type.
- Extensively worked on modularization technique such as subroutine. have good knowledge in ABAP performance tuning sing se30, abap runtime analysis st22,st03,st05-sql trace, sqvi for finding sql trace for MM01
- Worked in integration of JCO 3.0 with Ecc 6.0 connection for Data migration between SAP system and Non-SAP system.
- Involved in Design, development, optimization and maintenance of Business Objects Data Integrator jobs to extract data from various source systems to data marts/data warehouse, various SAP modules AND Java Connector through IDOCS and BAPI.
- Loaded the source data from staging database into IDOCs CREMAS, DEBMAS to the objects Vendor and Customer respectively.
- Performed processing of IDOCs in SAP ECC in T-Code:BD87.
- Checked on data loads in SAP ECC tables for the respective objects of Vendor, Customer and validated the source data with the target data.
- Configuring STMS configuration and worked in pa30, pa40 for employee hiring and actions and worked in WBS elements.
- Developed ALV reports for purchase orders to compare the ordered quantity with the received quantity
- Pending GRN & GRN AGEING REPORT, Stock tracking report in material management
- Adding columns Vendor Name and Customer Name in T-code FBL3n.