iPACS Financial Products & Security Master

Project Scope: • Onboarding client and trading data to SAP HANA database, analyzing data sets by creating certain tax calculations • Generating 7+ various integrated business reports for TAX channel leaders Impact: • Constructed reusable scripts using variables, prompts, parameters, SDFs, UDFs that reduced coding effort by 25% Role: • Productized template objects (both HANA and ETL jobs) to reduce redundancy of data load by more than 80% by adopting Data Services and HANA SQL • Developed and enhanced attributes and calculation views in HANA models, ETL jobs for data import and application of workflows, data flows, transformations for data cleansing Tools Involved: SAP HANA, SAP Data Services, REST API, VBScript