Lead SAP HANA Developer
Power International Holding
Total years of experience :11 years, 6 Months
• Develops data models for high performance projects and deliverables.
• Building HANA views using SDI/SDA and ETL process using Data Services
• Develop Data Models, Planning Models, Planning Functions in SAP Analytics Cloud
• Dashboard Development using SAP Analytical Cloud for Digital boardroom and PowerBI
• Creation of Stories ndash hierarchies, Dashboards, Geo Maps, Linked Analysis in SAP Analytics cloud
• Use of HANA 2.0 Web IDE SPS 2, 3, 4, Cloud Foundry, SAP Haas, GIT HUB, Multi-Tenant Application, Containers, Table Functions, Stored Procedures, CDS Views and Flow Graphs, Data Archival
• Design and build data flows including Info Objects, Open ODS View, Advanced DSO (ADSO), Composite Provider, Transformations, DTPs and Data Sources
• Design, implement and support robust data modelling solutions in SAP BW/4HANA, requiring integration of data from multiple SAP solutions like SAP S/4HANA, SAP Ariba and non-SAP data source
• SAP predictive analysis for data for trends and patterns
• Use predictive modelling to increase and optimize customer experiences, revenue generation, ad targeting and other business outcomes.
• Creates various machine learning-based data models to develop data driven solutions to complex business problems.
• Responsible for understanding the business change needs, accessing the impact of future changes & capture & analyze data
• Implements analytical models into production by collaborating with software developers and machine learning engineers.
Maintaining the system integrity of all sub-components (primarily HDFS, Sqoop, Hive, and Spark).
Worked on deployments of jobs inHadoop environment.
Transferring data using Sqoop from MySQL to HDFS.
Creating hive tables for HDFS data which we transferred from database.
Used Spark framework functionality to speed up the process.
Used Scala language to write spark framework.
Spark core and Spark SQL functionality used.
Monitoring system health and logs and respond accordingly to any warning or failure conditions.
Knowledge of Migration from another environment to Hadoop.
Ingestion into Hadoop and Teradata
Design and implement Data Lake Infrastructure Architecture
Responsible for Business Analysis and Requirements Collection
Providing technical leadership in the Big Data space (Hadoop Stack like M/R, HDFS, Pig, Hive Elastic Search
Flume, Sqoop
Running scrum meetings (Scrum Master)
Manage and mentor a team of 4 Developers
Loading data from HIVE into Teradata according to mapping requirement-using transformations such as
Using Python and Azure Cloud, developed a process to integrate on-premise customer data with on-line customer data.
Reports Automation Using Powerbi, Python Dash, Hive
Loading of Data with BODS and using SAP HANA SDI as per the Solution & Data Architects directives
•SAP HANA modelling of Calculation & Analytic views in accordance to best practices and development standards
•Testing of ETL's, Data and Views
•Deployment of developed artefacts for QA and releasing to Production
•BOBJ universe development
•Reporting, Analysis and Dashboard requirements gathering and documentation
•BOBJ OLAP Analysis development
•Webi Report Development
SAP Analytics Could Story/Dashboards development
SENIOR BIG DATA INTEGRATION DEVELOPER
Sasol
Data ingestion between systems
•Integration SQL Server and Azure Data lake
•Creation of tables in Hive utilizing Cloudera based as per ingestion requirements
•Create & maintain Metadata catalogue of all objects in the Data Lake
•Spark core and Spark SQL functionality used. i.e., RDD, PairRDD, Dataframe and Dataset.
•Data products via ETL jobs from Hive as source to various other sources \[Hive, SQL, SAP\]
•Sqoop Big data management integration with Hadoop and Teradata
•Data ingestion and integration
•Database Management
•Teradata data modelling
•Hadoop Ecosystem
•Complex file processing on Hadoop
•Data Integration on Hive and Hive mapping and Hive targets
•Spark Mappings and Informatica Hadoop optimization
•Data Processing - using Spark framework to process streaming data Sorting and Statefullnes in Hadoop
•Elastic Search
•Hadoop, Hive, Impala, Spark, SparkSQL, Sqoop
Ensures Interfaces are developed and maintained according to best practice and standards
•Maintain current interfaces Build new interfaces using a custom template
•Provide operational interface support
•Provide ad hoc after hour interface support
•ETL integration with BODS with SAP and non-SAP data sources such as SAP ERP, SAP BW, SAP, SQL Databases and applications
•Working with Business or Functional users and translating Functional Specifications into ETL technical field specifications.
•writing complex SQL procedures/functions
SAP HANA landscape using functionalities like data provisioning, Modelling and Administration, and Information Composer.
•Well versed with replication methods like SAP Landscape transformation and Business Objects Data services.
•Comprehensive Modelling in creating various views like Attribute, Analytic and calculation views.
•Designing the extraction, Transformation and Loading Jobs from SAP ECC 6.0 EHP7, and Oracle 11g source systems into target
•Develop Data marts using SAP Data Services 4.x.
•Developing Universes to support reporting requirements using Information design tool while writing production reports
• Data ware-house design
•Developing integration jobs between Production systems and the data marts
•Server administration in UNIX- environment installation and
•day-to-day management PI, NetWeaver BPC, and BOBJ application
•SAP on HANA planning, installation, troubleshooting, and performance tuning
•Performing SAP HANA backups via SAP HANA studio
•Migration into SAP HANA via Data services using idocs from Oracle legacy systems
Build Jobs, post analysis of the requirement
•Designing complex transformations including ABAP Flows.
•Build Workflows with scalable possibilities
•Build the Transforms with logic to allow performance and re-usability of the Transforms
•Utilising scalable scripting language and utilise the rich set of built-in functions in SAP Data Services
•Advising the Customer on high performance parallel transformations and grid computing as well as hardware, resource and network requirements
•Debugging and profiling data while understanding complex data impacts across the organisation
•Integrate and implement Information Steward Cleansing Packages and Rules.
•Import ATL Cleansing Package. Load it into SAP Data- services; validate connections, functions, transforms and queries. Test output and feed back to business/IS customer
Investigating production issues by recreating them on test systems
•Administering all database objects including tables, clusters, indexes, views
•Implementing and maintaining database security.
Bachelor in computer science