Makarand Jahagirdar Solution Designer SME

Tel: +1-416-***-**** BW/4 HANA BO HANA BPC

E-mail: ady0cv@r.postjobfree.com

Profile

Senior analytics professional with a distinguished career in designing, implementing, and strengthening of BI solutions across large-scale enterprise environments.

Successfully delivered SAP reporting & analytics solutions for oil & gas, manufacturing, public services, CPGs, pharmaceutical and banking sectors.

Strong experience in BW/4 HANA, BW on HANA, SAP HANA modeling and SAP Analytics Cloud.

SAP Certified BW/4 HANA 2.0, SAP Analytics Cloud, and BPC 10.1 & 11 application consultant.

Strong experience in gathering business requirements documenting Fit/Gap analysis, designing functional and technical specifications, developing reports, testing, performance tuning, go-live, and support.

Strong experience in translating business requirements into analytical solutions.

Experience in SAP HANA modeling using calculation views.

Good hands-on experience in SAP Datasphere.

Experience in different data provisioning methods for HANA like SLT and SDA.

Experience in modeling, extraction, and reporting on HANA as a Side Car database and data mart.

Strong experience in doing data reconciliation and troubleshooting issues between BW/HANA and source systems.

Over 17 years of strong experience in SAP BI/BW implementations, rollouts, enhancement and support.

Extensive experience in SAP BW Designing, Modeling, Data Profiling, ETL, Reporting and Optimization.

Experience in new artifacts of BW/4HANA like Advanced DSO, Composite Providers and Open ODS views.

Experience in implementation of BPC Embedded 10.1, BW Integrated Planning (IP) and Analysis for Office.

Experience in Business Objects Lumira Designer, Web Intelligence and Crystal Reports.

Experience in working with agile project management methodology.

Experience in extracting data from SAP S/4 HANA, ECC, CRM, SRM, and other database systems.

Experience in enhancement and support of BPC Finance Planning solutions.

Experience in BW implementation for SAP PP, FI-CO (COPA, PCA, and CCA), SD, PM, MM, and HR processes.

Good understanding of cloud based platforms like MS Azure and AWS.

Experience in implementing SQL scripting using Microsoft SQL Server 2014 Management Studio and Oracle SQL Developer IDE.

Experience in working with ITSM tools like ServiceNow and Remedy.

Around 3 years of experience in SAP ABAP.

Good functional understanding of Manufacturing, LTC, PTP, OTC, and RTR processes.

Good hands-on exposure to Power BI and Qlik Sense.

Proven ability to perform efficiently in multitasking and distributed environments.

Strong consulting skills with a focus on the Client’s needs.

Exceptional troubleshooting skills and problem-resolution skills.

Skills:

SAP Datasphere, BW/4HANA, BW on HANA 7.5, SAP BW 7.4/7.3/7.0, SAP HANA

SAP Analytics Cloud

SAP BOBJ 4.2 – Lumira Designer, WebI, Information Design Tool & Crystal Reports

SAP BPC 10.1 – Embedded & Standard

SAP S/4 HANA, ECC, CRM & SRM

SAP ABAP

Work Experience

Jan 2023 – till date BW/4HANA Developer IBM Canada Ltd.

EWM reporting project at Suncor Energy Inc.

Working on a project to develop new dashboard for the EWM process using BW/4HANA and Power BI.

Created ODP SAP and SLT data sources to replicate standard data sources and tables into BW/4HANA.

Created ODP CDS based data source to extract data from CDS views into BW/4HANA.

Created Advanced DSOs to stage data in multiple layers using Eclipse IDE.

Written transformation logic to handle complex business rules.

Created Composite Providers and BW queries.

Created HANA calculation views based on Advanced DSOs in BW/4HANA.

Integrate BW queries with Power BI for reporting and data visualization.

Actively participated in sprint planning sessions, defined project plan and provided effort estimations.

May 2021 – Dec 2022 Analytics Developer City of Mississauga

Worked as Analytics Developer for Performance Measure Program.

Worked on a project to roll out a dashboard using a Power BI solution.

Involved in requirement gathering, documented effort estimation, functional, technical specifications, and test plans.

Implemented dashboards/reports for different divisions as part of the Performance Measure Program.

Implemented KPI dashboard for Fire services using BO Lumira Designer.

Implemented KPI dashboard for Facilities & Property Management division using BO Lumira Designer.

Configured charts, graphs, KPIs, data sources, and written script in Lumira Designer.

Implemented multiple reports for Facilities & Property Management and Fire division using BO WebI.

Implemented multiple Bex queries, BW data model, transformations, and created/updated source views.

Implemented new universe and connections for a source database using Information Design Tool.

Worked with sources like S/4 HANA, MS SQL & Oracle database systems to extract data to BW for different divisions.

Written SQL scripts to create/update source views using SQL Server 2014 Studio and Oracle SQL Developer IDE.

April 2017 – May 2021 SAP BI Application Designer LafargeHolcim

Worked as a Senior Application Designer/SME on SAP BW/4HANA.

Implemented Sales reporting project using SAP HANA modeling and BO WebI.

Done end-to-end HANA modeling using Calculation Views.

Created a virtual table and connect it to a remote data source using SDA.

Worked on variables and input parameters for catching user input.

Created stored procedures for complex and regular tasks.

Done Performance Optimization using union pruning and calculation view optimization.

Created WebI report based on HANA Calculation View.

Implemented a new KPI report for Cement manufacturing using SAP HANA modeling and BO WebI

Created calculation views in HANA based on SAP PP, PM and PCA tables.

Created a virtual table and connect it to a remote data source using SDA.

Implemented table function in calculation view to handle time-dependent logic.

Created WebI report based on HANA Calculation View.

Troubleshoot and resolved data issues within HANA and WebI.

Implemented a production planning solution for Cement manufacturing process using BPC Embedded, IP, BW/4 HANA and Analysis Office for Microsoft Excel.

Configured BPC Embedded, Models, BPFs, and connection with Analysis Office.

Developed IP naming standards and technical documentation.

Developed planning Advanced DSOs, Aggregation levels, planning filters, and planning sequences in IP.

Developed input-enabled queries on aggregation levels and planning objects in IP.

Developed multiple planning workbooks in Analysis Office for Excel.

Developed planning functions using FOX and ABAP logic as required.

Designed and configured Analysis Office planning workbooks in excel and wrote VB Macros as needed.

Implemented custom planning functionality for data slicing and user access maintenance.

Implemented characteristic relationships and custom value help functionality.

Built trusted relationships with business stakeholders. Delivered unwavering support during UAT and post-go-live.

Implemented multiple enhancements to streamline the application.

Implemented a project to roll out BPC Finance Planning solution for the West Canada region.

Mentored new and existing team members on change and incident management processes.

Implemented multiple projects to integrate LafargeHolcim subsidiaries into SAP solutions.

Designed and implemented a project to decommission some BW systems from the landscape.

Nov 2015 – March 2017 Senior Technical Consultant KPIT Technologies Corp.

SAP integration project to migrate Lafarge product lines into Holcim SAP solution for North America.

Worked on enhancing existing BW data model and reports to fit in new requirements.

Enhanced data sources and transformations to fit in new master and transaction data.

Enhance existing BW objects in classic BW and BW on HANA system.

Troubleshoot issues with custom BW BPS based planning applications for the production planning process.

Configure planning objects in BW BPS to implement planning functionality for the new region.

Developed custom extractors and DSOs to stage quality data from a legacy database system.

Prepared Technical Design Documents for BW changes and reviewed it with the business.

Sept 2014 – Nov 2015 SAP BW Consultant IBM Canada Ltd.

SAP BW rollout project for Bank of Montreal (BMO) Financial Group.

Worked on a project to stage legacy system data in BW.

Done data profiling in the production environment to validate the requirement.

Worked on data extraction from SAP Bank Analyzer.

Developed interface spec to map BW objects with source fields from Ab-initio and flat file source.

Worked on a new project to implement BMO regulatory report for OSFI.

Worked on a project to implement Near-Line Storage (NLS) solution for BW.

Oct 2013 – June 2014 Architect Wipro Technologies Ltd.

SAP BW maintenance, enhancement, and support for customer KONE Corporation.

Lead SAP BW support team.

Responsible for assigning support tickets to the team and ensuring they are resolved within the timeline.

Done design review of existing BW solution and recommended system improvement plans.

Implemented BW housekeeping activities.

Maintained BWA, created/updated Index, did index filling and regularly monitored BWA jobs.

Done technical feasibility check to improve BW query and data load performance.

Regular coordination with customers on ticket resolution.

July 2012 – Sept 2013 Senior SAP BW Consultant IBM India Pvt. Ltd.

Sept 2010 – June 2012 Senior SAP BW Consultant IBM Canada Ltd.

Global SAP implementation project for McCain Foods Ltd.

Responsible for designing and delivering SAP BW reporting solutions.

Delivered new and complex solutions to clients in response to varying business requirements.

Performed Fit/Gap analysis for reporting requirements.

Supported functional team in preparing and submitting GAP documents.

Design BW data model to extract data from CRM, SRM, and ECC systems.

Implemented BW reports for LTC (Lead to Customer), PTP (Procure to Pay), MTD (Make to Deploy), and OTC (Order to Cash) process.

Coordinated with business users in resolving UAT and post-go-live issues.

Involved in the market rollout of solutions for Great Britain, North America, Australia & New Zealand region.

Implement analysis authorization for reports.

Enhanced CRM related data sources for Business Partner, Opportunity and Activity.

Enhanced existing BW data model and report to implement new functionality.

June 2009 – July 2010 SAP BW Consultant IBM India Pvt. Ltd.

SAP enhancement project for Kraft Foods.

Involved in SAP BW enhancement release project.

Support the client in testing the development across all system environments.

Delivered new and complex high solutions to the client in response to varying business requirements.

Responsible for effective communication with the onsite team.

Implemented several BW reports for purchasing module.

Provided BW specific ABAP training to other consultants in the project.

March 2009 – June 2009 SAP BW Consultant IBM India Pvt. Ltd.

SAP HR implementation project for Kellogg’s.

Responsible for designing and delivering SAP BW reporting solutions.

Implemented SAP BW reporting solution for HR module.

Installed business content data for HR Personnel Administration and Organizational Management.

Built custom DSOs as a first layer of data staging, thus enhancing the business content data flow.

Worked on custom development for worker’s compensation reporting.

April 2008 – Feb 2009 SAP BW Consultant IBM India Pvt. Ltd.

SAP BW maintenance, support, and enhancement project for Amgen Inc.

Worked on RFC (Request for a change) to implement additional enhancements.

Understanding technical requirements and preparing technical assessments and effort estimation.

Enhanced custom data source and modified BW data model.

Reinitialized standard data source to reload historical data to bring new functionality to the report.

Reinitialized Inventory to resolve data inconsistency between ECC and BW.

Updated existing Development Specifications (DTS) to include new change.

Prepared Unit Test Plans (UTPs) for the released changes.

July 2007 – March 2008 SAP BW Consultant IBM Switzerland Ltd.

July 2006 – June 2007 SAP BW Consultant IBM India Pvt. Ltd.

SAP implementation project involving implementation of SAP CRM - TPM solution for Nestle Group.

Worked on SAP CRM– BW BPS integration supporting Trade Promotion and Campaign Management.

Configured BW BPS country-specific settings for Nestlé’s new BW/SEM re-design solution.

Worked on configuration changes to modify the planning cube and planning layout as per the requirement.

Involved in the market rollout of the new BW/SEM re-design solution.

Created planning cube, planning layout, and planning profile for the new BW/SEM re-design solution.

Enhanced planning layout key figure setting.

Jan 2006 – June 2006 SAP ABAP Consultant IBM India Pvt. Ltd.

Aug 2003 – Dec 2005 SAP ABAP Consultant Web Development Company Ltd.

SAP maintenance, support, and enhancement project for Nestle Group.

Resolving production support incidents raised by customers.

Done technical feasibility check of the business requirements and provided effort estimation.

Resolved issues with custom-developed ABAP programs.

Resolved issues in the custom-built CRM-PS interface.

Implemented performance improvement plans for custom-developed objects.

Implemented OSS Notes across all environments.

Resolved object inconsistency through SPDD and SPAU adjustments during support pack upgrade.

Education

Master of Computer Application (M.C.A), Osmania University

Bachelor of Science (B. Sc), Osmania University

Certifications

SAP Analytics Cloud

SAP BPC 10.1 & 11.0

SAP BW/4 HANA & SAP BW 3.5

Training

SAP Datasphere through openSAP

SAP Analytics Cloud – Advanced Planning through openSAP

SAP S/4 HANA Embedded Analytics through openSAP

BPC Embedded 10.1 and Analysis for Office 2.6

Merit/Awards

Received multiple Make the Difference (MAD) award from employer LafargeHolcim.

Received IBM Service Excellence award for outstanding contribution in the project.

Received IBM Bravo award for exceptional contribution to the project.

Contact this candidate