We provide IT Staff Augmentation Services!

Senior Hana Developer Resume

PROFESSIONAL SUMMARY:

  • 12+ Years of software development experience in SAP Native HANA/SLT/BODS/BW/ABAP/Tableau.
  • Around 4 years of experience in SAP Native HANA (Modeling/Performance Tuning/SQL).
  • Around 4 years of experience in SLT and BODS(Config/Replication/Monitoring/Transformations).
  • Around 8 years of experience in SAP ABAP and BW.
  • Involved in all the phases of the project like Gathering Business requirements, User meetings, Analyzing the Business process, Implementation, Designing, Preparation of Technical specs, Configuration, Customization, Unit/Integration testing, Go - live and Post-go-live support.
  • Worked on 3 Hana Implementation projects.
  • Expertise in SAP Hana Modelling.
  • Migrated Attribute, Analytical Views to Calculation Views.
  • Proficient in Variables, Input parameters, Calculated columns, Filter expressions, Input Parameter mappings with procedures.
  • Good hands on experience in Procedures, Table Functions and Hana SQL.
  • Worked on HANA Cloud Platform (HCP) and On-premise environments.
  • Created Input Parameters and applied filter expressions at DB level and replacing Variables with Input Parameters.
  • Usage Left-Outer-joins/Referential Joins, maintain cardinality and Join Properties.
  • Handled complex transformations and complex logics in BODS.
  • Creation of Calculated columns at top level node of the Logical View.
  • Handled complex logics in Table Function where graphical modeling is not supported.
  • Table partitions and Table Re-distribution with admins co-ordination.
  • Expertise in Performance Tuning of HANA models by implementing all the Best practices.
  • Configured SAP ECC and CRM systems to HANA
  • Configured ECC and CRM table settings and applied Event/Field related rules in LTRS
  • Replicating/Drop/Suspend and monitoring the tables in LTRC
  • Created complex Jobs, Work Flows, Data Flows, and Scripts using various Transforms (Integrator, Quality and Platform) to successfully load data from multiple sources into a desired target.
  • Extensively used Data Services Management Console to schedule and execute jobs, manage repositories and perform metadata reporting
  • Extensively worked on Data Source Enhancement using Customer Exit (FMs and Classes) and Badi (Multiple Implementations).
  • Worked Routines (Start, Field, End and Expert routines). Ability to identify the suitable routine based on the scenario.
  • Expertise in design and development of Generic Data Source Extraction using Table, View, and Info set Query, Domain and Function Module with Full and Delta functionality.
  • Extensively worked on Customer Exit Variables using Customer Exit (Dynamic FM, Dynamic class and Dynamic Subroutines approaches) and Enhancement Spot/New Badi (Multiple Implementations).
  • Migration of Customer Exit to BABDI’s.
  • Expertise in Info Package and DTP routines, Debugging, Performance tuning of various objects, Code reviews and designed the documents for best practices in BW environment.
  • Extensive experience in BI Architecture, Extended Star-Schema, Multi- Dimensional Modeling, Data Flow Strategy, Defining Dimensions, InfoCubes, Composite Providers, Hybrid InfoProviders, Virtual Providers, Advanced Datastore Objects, Open DSO, SAP HANA-optimized DSOs, SAP HANA-optimized Infocubes, MultiProviders, Symantic Partition Objects (SPOs), InfoSets, DataSources, InfoSources, InfoObjects, PSA and DSOs.
  • Expertise in designing, developing, configuring, installing SAP BW objects DataSources, InfoSources, InfoObjects, ODS/DSO, InfoCubes, MultiProviders, InfoSets, InfoSpokes / Open Hub destinations, APDs, Transfer Rules, Update Rules, Transformations, Start / End / Expert Routines, DTPs, InfoPackages, Process Chains and Activation & enhancing the business content.
  • Experience in activating standard business content, extending and enhancing InfoCubes according to the requirements, Datasource enhancements, User Exit Variables (CMOD), Virtual Key Figures and Start Routines.
  • Extensive experience in designing and developing Extractors, Tables, Views, Extract Structures, Function Modules in SAP ECC/CRM and legacy systems.
  • Solid experience in Data Modeling, Extraction, Cleansing, Loading, Scheduling, Monitoring, Delta Management and Reporting.
  • Characteristic relations, Data slice, planning functions, planning sequence, FOX coding
  • Expertise in front-end Business Warehouse components (BEx Analyzer, Query Designer) for Queries, workbooks, Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions, Conditions, R/RI, Ad-hoc Queries and Web application designer, Web Items.
  • xtensive experience in support, Data Loads, Validation and Troubleshooting of Transaction and Master Data, Change Management, Transport Management, Roles & Security, System Checks, Performance Tuning and Process Chains.
  • Tables, Data Elements, Views, Domains, Search Help, Lock Objects, Table Maintenance Generator.
  • Extensive experience creates and using Internal Tables.
  • Subroutines, Function Modules, Macros, INCLUDE Programs
  • BAPI’s, ALES’s, IDOC’s
  • BDC (Call Transaction/Session Methods), File Handling, LSMW (Using BAPI/IDOC)

PROFESSIONAL EXPERINCE:

Confidential

Senior HANA Developer

Environment: Hana 2.0(SP2), SLT, BODS 4.2

Responsibilities:

  • Replicated 175 CRM tables to HANA system using SLT in DEV, QA and Production systems.
  • Developed HANA Models for Service Orders, Service Request, Service order quotations, Service Confirmation and billing request for Tableau reports.
  • Developed HANA foundation Models for Service Contract Quotations, Service Contracts, Service Agreements, Service Plans, Service Plan Simulation and pool contracts for user tableau reports
  • Developed HANA Models for Complaints and returns and in-house repairs for user tableau reports.
  • Developed HANA Models for Service Operations-Billing-documents, billing requests, billing due list items and service Monitor for tableau reports.
  • Success factors will send data to shared drive everyday midnight by using scripts.
  • From Share drive, BODS job will post data into oracle tables (around 70 tables)
  • From Oracle tables data loads to HANA system through BODS
  • The following HANA models created for User Tableau Reports
  • Student Completion Status
  • Student Component Master
  • Student Curriculum Master
  • Student Enroll Seat
  • Student Master Data
  • Student Org Master
  • ISU
  • Developed data foundation for Hyperion Buffer and Demand planning user upload the forecast data for Accessories, Instruments, SYSKAD and Systems
  • Developed data foundation for inventory projection data.
  • Developed HANA Simulator Model for Confidential Surgery System.
  • Load SFDC Account, Install Base and Contact data to HANA system using BODS for creating Simulator Models.

Confidential

HANA Developer

Environment: Hana 2.0, SLT, BODS 4.2

Responsibilities:

  • Developed HANA Models for Confidential Statistical and Safety Reports.
  • Developed Multiple HANA Models, Procedures and Table function using Maintenance Plan, Task List, Operations, Functional Locations, Schedules, Calls, Work Order data.
  • Worked on AMBBS Asset Management for Gas and Electricity.
  • Create custom HANA SQL and stored procedures.
  • Assist in creating transports, maintain change list, move views from one environment to other environment using HALM.
  • Worked on SAP-PM extractors 2LIS 17 I3OPER, 2LIS 18 I3OPER, 2LIS 17 NOTIF and 2LIS 8 NOTIF
  • 0UC MTR DOC, 0UC BILLORD

Confidential

HANA Developer

Environment: HANA SPS08

Responsibilities:

  • Technical Upgrade of the existing SAP ECC system to the latest release and database migration from the existing database to SAP HANA.
  • Technical Upgrade of the existing SAP CRM system to the latest release and database migration from the existing database to SAP HANA.
  • Closely worked with BASIS team pre-and post-upgrade for successful deployment.
  • Created multiple landscapes and tested before go-live.
  • Applied several notes after post upgradation to avoid the dumps.
  • Created multiple calculation views graphical modes and SQL scripted models.
  • Prepared pre and post upgrade checklists.
  • Closely worked with CRM users after post go-live.

Confidential

Sr. SAP BW Consultant

Environment: SAP BW 7.5

Responsibilities:

  • Involved in designing Functional specs and writing technical specs.
  • Requirement gathering and gap analysis.
  • Implemented LSA (layered scalable architecture) for data historical data retention
  • Designed the technical document for the entire solution.
  • Used DTP routines, filters and OLAP variables for loading current and previous week data.
  • Involved in preparing test data for the solution for testers.
  • Created process chains for master data and transaction data.
  • Collected transports for the entire solution.
  • Involved in the cut-over activities for loading data in quality.
  • Used DSO look-ups at start routine and end routine.
  • Created Bex Reports for Business objects universe.
  • Created structures and variables for the reports.
  • Involved in integration testing and reconciliation testing for the entire data set.
  • Involved in fixing defects raised by the business users.

Confidential

Senior Software Engineer

Environment: SAP BW 7.5

Responsibilities:

  • Created planning queries on top of aggregation level
  • Created planning sequence, planning filter, planning functions using RSPLAN
  • Define locking mechanism using data slices.
  • On top of retile planning queries, created the Microsoft office work books
  • Extensively worked with FOX coding

Confidential, Huston, TX

Senior Consultant

Environment: SAP BW 7.2

Responsibilities:

  • Worked as a SAP BI/BW/BO consultant for utility project.
  • Involved in support tickets analysis and assign tickets to relevant team member as priority.
  • Worked on issues as a support team member in order to resolve the tickets in different modules SD, PM and FI-CO
  • Contribute and provide extensive support to team members where ABAP coding required.
  • Worked on SAP BO report issues and provide my support in BO to my team members.
  • Create OLAP connections to SAP BW using BICS connections.
  • Create WEBI reports on SAP BW Bex queries.
  • Prepared the resolution documents, test scripts and update the FS and TS documents.
  • Worked on move the transports from development to quality and production systems without fails and check the dependent objects.
  • Monitoring the daily scheduled jobs and clear the failed process chains in production.
  • Prepare and update the daily status to onsite team members.

Confidential

Senior Consultant

Environment: SAP BW 7.2

Responsibilities:

  • Involved in designing Functional specs and writing technical specs ISU(Electricity)
  • Requirement gathering and gap analysis
  • Implemented LSA (layered scalable architecture) for data historical data retention
  • Designed the technical document for the entire solution
  • Used DTP routines, filters, and OLAP variables for loading current and previous week data
  • Created unit test document for the entire solution
  • Involved in preparing in test data for the solution for testers
  • Involved in writing start, end routines and filed level routines for fetching the data according to the requirement
  • Created process chains for master data and transaction data
  • Collected transports for the entire solution
  • Enhanced data sources for according to the gap analysis
  • Involved in the cut-over activities for loading data in quality
  • Maintained manual configuration of master data
  • Used DSO look-ups at start routine and end routine
  • Created Bex Reports for Business objects universe
  • Created structures and variables for the reports
  • Used BADI’s for data source enhancement and front-end variables

Confidential

Senior Consultant

Environment: SAP BW 7.2

Responsibilities:

  • Implemented in newer SAP version 7.4
  • Involved in modeling the standard DSO’s, Direct update DSO, Basic info cube.
  • Designed Reports in query designer using CKF, RKF, Formula, variables.
  • Extracted transaction and Master Data from ECC and Flat files.
  • Retraction data from BPC to BW for various modules like SD, Finance and project systems by using APD tool
  • Create the Data source using Function Modules
  • Developed the Hierarchy files by using ABAP program
  • Created Data Transfer Process (DTP) to transfer data within BI from one persistent object to another object.
  • Used Direct Update DSO in the process of APD (Analysis Process Designer).
  • Used Write-Optimized DSO (Data Store Object) to load data into BI system.

Hire Now