SAP BI/BW Consultant

• May 2018 - Present

• Designed and developed S4/HANA custom CDS Views based on underlying tables for facilitating SAC and WEBI reports.• Developed custom CDS views to combine the legacy data from Z-tables with the operational data in standard S4HANA tables.• Worked as BW/BI consultant responsible for BW extraction and reporting on WEBI and SAC.• Developed, implemented, and managed the extract, Transformation, Load (ETL) process to bring data from Solution Manager source systems into BW using CRM/Solman… • Designed and developed S4/HANA custom CDS Views based on underlying tables for facilitating SAC and WEBI reports.• Developed custom CDS views to combine the legacy data from Z-tables with the operational data in standard S4HANA tables.• Worked as BW/BI consultant responsible for BW extraction and reporting on WEBI and SAC.• Developed, implemented, and managed the extract, Transformation, Load (ETL) process to bring data from Solution Manager source systems into BW using CRM/Solman extractors.• Resolved and optimized issues with Bex Analyzer reports, workbooks.• Worked and resolved issues with Crystal reports, Lumira Designer.• Maintained and managed BOBJ administration for multiple clients, working on access, performance issues involving rebooting of servers.• Designed and developed SAC models for MM modules which is based on live data (CDS views) on HANA system.• Created Dashboard stories in SAC using control inputs, calculations, and conditional formatting.• Developed WEBI dashboard which has combination of different CDS views.• Worked on setting up complex user security in CMC portal for user access to sensitive reports and data. • Developed Bex queries based on composite providers on ad-hoc basis.• Resolved complex process chain failures and data mismatch issues.• Resolved issues as DEV, QAS and PRD were not in sync. Worked with BASIS to sync the 3 systems. Show more Show less