SME – Worked on Performance tuning in Data loads, Query performances & Information view of HANA.
• HANA - Creation of Attribute Views, Analytical Views, Calculation Views, Procedures.
• Data Modeling – Design and maintenance of Advanced DataStore object, Composite Provider, Open ODS, Info-Cubes, Multi-Providers, ODS objects with consistent star schema and efficient multi-dimensional data modeling techniques.
• Data Extraction – Creation and customization of data sources, Transformations, Start Routines, and End routine & expert routine. Scheduling and monitoring of data loads.
• Automating the data extraction using Process Chains & 3rd party tools using Control-M & Autosys.