Previous Job
Previous
HANA Modeler/San Ramone, CA 4 mth+ contract (NTTJP00006772)
Ref No.: 18-01211
Location: San Ramone, California
Position Type:Contract
Visa Required: US Citizen, GC, EAD-GC Only No H1B or OPT
Day to Day job Duties: (what this person will do on a daily/weekly basis)  Hands on HANA SME required to build a data warehouse on HANA using SAP data, non-SAP data and implementing a reporting layer on top. Enable Finance Adhoc reporting  using  HANA DB :   - Build the data model to enable Finance/OTC reporting - Customize HANA Views and Datasets for 3rd Party Data (non SAP) - Automate  loading of  non-SAP data into HANA DB (payment files, shipment files, SQL DB-RFO) - Define SAP ECC Datasets needed to meet OTC business outcomes - Customize HANA Views for SAP data - Evaluate data access needs (Query, Report and Dashboarding tools) - Enable connectivity of selected reporting tool to HANA DB - Document data model, technical specification - Provide post go live support, researching remediating issues, improvements etc.. Basic Qualifications: (what are the skills required to this job with minimum years of experience on each)   5+ years on HANA Modelling - SAP HANA Modeling and Reporting and building universe for HANA reporting. Expertise in SAP HANA Administration, Performance Optimization, Modeling using Different types of views, SQL, SQL Script topics. - Knowledge of SAP HANA LIVE extension and modification. - Complex SQL scripts. - SAP HANA Security including User Management, Roles, and authorization - Reporting, Analytical and Calculation views - Develop Web Services for SAP HANA database and deliver to ASP.NET developers to consume    Travel:  Need Locals Degree: Bachelors in Computer Science or equivalent work experience   Nice to Have; (But not a must)    Experienced with Extraction Transfer Loading (ETL) connecting to  SAP HANA tables. (extraction and load) SAP analytics reporting / any other analytics tool on top of HANA DB
Good to have : Experienced with Extraction Transfer Loading (ETL) connecting to  SAP HANA tables. (extraction and load) SAP analytics reporting / any other analytics tool on top of HANA DB