Lead HANA developer and onsite coordinator for SAP HANA projects.

Technology Lead

- Lead HANA developer for an ICT HANA reporting project for Airbus A350 program - Requirements capturing from the client - Recommendations on the architecture of HANA reporting solution - Developed HANA information models, created stored procedures and scheduling of stored procedures. - Created data visualization reports on SAP BO Design Studio - Performance testing and optimization. - Transport of HANA models (views, stored procedures and hdb tables) through HANA change manager.

SAP HANA Lead Developer/Contractor

- Onsite lead for a reporting solution on HANA platform for Airbus A320 program. - Requirement gathering from the business. - Created design/architecture of the HANA reporting solution. - Created information models in HANA - attribute, analytic and calculation views and stored procedures. - Created hdb tables. - SQL tuning and performance optimizations. - Developed testing strategies and test cases. - Worked alongside UI5 team for consumption of HANA models and visualization of data in UI5 reports. - Change recording through HANA change manager and release management activities.

- Primary onsite support for IM Mortgages batch of BODS data loads. - Provided live production batch support and handled and investigated any new incidents. - Logged defects in the HP Quality center. - Prepared defect fixes and created release plans, worked with deployment teams to deploy patch fixes/ releases. - Data quality checks and data cleansing. - Monitoring batch jobs.

BODS Developer and Data Analyst (Contractor for Infosys)

- Offshore HANA developer - Created HANA data models - Created tables structures in HANA database. - Data provisioning - Loaded data from DB2 source database to HANA database through SAP BODS jobs, loaded SAP ECC data through SLT replication server.

HANA Developer/Data Modeler

SAP HANA Data Modeling in SAP HANA. Creating various types of information models in HANA – Attribute views, Analytical views and Calculation views. SLT Replication/creating batch jobs in BODS to load/replicate data in HANA database. Reporting on HANA using front end BO tools like Webi, BO design studio and SAP Lumira. Performance tuning and SQL optimization. Onsite coordinator and understanding business requirements working at client location in Germany and France. SAP HANA implementations done for following clients: McKesson Corporation, Kraft Foods and Airbus. SAP BODS Creating batch jobs using various transformations for data loads. Data cleansing and data integration. Scheduling and monitoring batch jobs and providing support in case of any batch errors. Data visualization tools Worked with data visualization tools such as SAP BO Design Studio, SAP Lumira and Web Intelligence reports to connect to and visualize data from HANA views.

Technology Analyst

HANA data modeler for Asia Pacific BI reporting program

- Key member of the HANA Center of Excellence, involved in HANA POCs for our SAP clients, some of which later converted into full-fledged projects.

HANA CoE team member

Senior Systems Engineer

Systems Engineer

Extensive experience of working on native SAP HANA data modelling projects.
My LinkedIn profile provides more details on this:
https://www.linkedin.com/in/amandeep-singh-b1439a7a/

Extensive experience of working with SAP BO tools.

Extensive experience of working with data migration and ETL tools such as SAP BODS and Informatica.

Personal details

Amandeep S.

Summary

Technical skills

Work Experience