Himanshu has around 5 years of experience in the field of Information Technology with extensive technical skill set and expertise in Data Warehouse - Business Intelligence in the domain of SAP (SAP BW / BI / HANA / BO). Worked in innovative and competitive cross country environment which involves system analysis and design, implementation and development, upgrade, testing and application support including effective team leading.
Worked on 3 Full Life cycle SAP BW implementations. Two Implementations on HANA environment involving extensive use of Information views from HANA into BW.
• Experienced in SAP HANA data modeling using Attribute View, Analytic View and Calculation View
• Experience in various Data provisioning techniques using SLT and BODS
• Design robust and flexible data model using Info cubes, ODS/DSO, Multi-providers, transformations, DTP's, Update rules, Info sources, Data sources, ABAP Programs
• Analyze and recommended report development, data integrity, data design, functional and technical software issues.
• Hands on experience in OLTP extractions from SAP R/3 using LO Cockpit, CO-PA, FI AR, AP, and Generic Extractions, Also extracted data from the flat files.
• Designed queries in BEx Query Designer and created workbooks in the BEx Analyzer using conditions, exceptions, structures, calculated and restricted key figures, character variables, formula variables and user exit variables.