KAMAL MALAV

Atlanta, GA • +1-678-***-**** • ad2wdw@r.postjobfree.com • LinkedIn • Authorized to work in US (L2S Visa) Education

Bachelors of Engineering (B.E.) in Information Technology (2002-2006) Profile Summary

16+ years of experience as Senior Technical Manager/Senior Designer in various SAP analytics products

(BW4HANA, BW on HANA, Native HANA, BODS, BOBJ Reporting Tools & SAC). Deep expertise in delivering complex large scale projects covering wide scope (Implementation, Rollout, AMS, Upgrade and Data Migration) for Fortune 500 companies. Established people manager and experienced in stakeholder management for cross-geographical teams across US, Europe, UK. Technical Skills

• Domain: Retail, Global Commercials, Finance and Order to Cash

• Tools: SAP, Microsoft Azure, HPQC, Service Now, Visual Studio Team service

• BI Tools: SAP BW4HANA, SAP BW on HANA, SAP HANA, SAP BODS, MS Azure

• Reporting Tools: BOBJ Reporting Tools(WEBI, Analysis for Office), SAP Analytics Cloud

• Programming Languages: SAP ABAP, SQL

• Soft Skills: Senior Technical Interviewer at Shell Petroleum and Accenture Certifications

• SAP BI7 certified: Issued in March 2009

• Microsoft Certified: Azure Fundamental issued in Aug 2022 Professional Experience

Shell Petroleum - Bangalore, India (2019-2023)

Projects: GPMR to GSAP migration (BW4HANA, BOBJ, SAC), Reshape Reporting Changes (BW4HANA, BOBJ), Retail Data Hub (Microsoft Azure), Compass Migration (Microsoft Azure), PAPM Strategic changes Role: Senior Designer/Senior Product Manager

• Safeguarded reporting of metrics for senior management by migrating GPMR (BW 7.0) to GSAP (BW on HANA) (~30+ BOBJ reports and 5 SAC Dashboards). As part of this, redesigned the BW solutions by using new features like ADSO, Composite Provider, SAC reports

• Having knowledge of ODP based extraction and ABAP CDS view creation for BW extraction

• Owned critical activities like Info object creation, Customer Exits, Deployment plan for all COBs as part of BW migration project

• Provided the ~30+ BOBJ Reports (WEBI and Analysis for Office) to business for business insights

• Created the universes using IDT and UDT by joining multiple tables/view to create the business reporting layer

• Created the Business objects reports (WEBI and Analysis for Office) using Universes, BEX queries

• Ensured business continuity and made reporting self service via. Azure migration project from Oracle to Microsoft Azure using ADF, SQL DB and DataBricks notebooks (~10 reports)

• Developed a strategic solution to fix issues occurred during upgrade in PAPM project for cost allocation for 5 COBs

• Successfully completed UAT/Hyper care testing sign offs by co-ordinating with business stakeholders from multiple countries

• Developed the overall emerging Technologies Analytics Strategy, including technology planning, technical integration and validation planning

• Created the HANA artifacts (Attribute view, analytic and calculation views) based on business requirement

• Developed scripted HANA views, Table functions, Procedures and ADHOC SQL queries to fulfill the ADHOC business requirement

• Collaborated with stakeholders and functional leads to identify work scope, solution requirements, technical and functional systems need and priorities, resource requirement as well as Work break down in details for phases with quality management

• Provisioned the data to connected applications for external reporting via ADF, ABAP wrapper and BODS (~15 interfaces)

• Organized and conducted 10+ sessions for new business users across 3 countries to explain the available reports usage and significance

Accenture - Bangalore, India (2015-2019)

Projects: Dupont one (SAP BW, SAP BOBJ), Dow Chemical Data migration (SAP HANA and SAP BODS) Client: Dupont, Dow Chemical

Role: Associate Manager

• Delivered Dupont one BW project to cater to BW data flows and reporting requirements (~20 BO Reports)

• Supported the Finance books closure activities (MEC and QEC) for Dow Chemical AMS project and delivered CIPs to reduce the tickets (~250 Tickets Per month)

• Developed complex objects like Purchase order, purchasing contracts (Including service Contract), PIR and source list for Procure to Pay work stream by preparing the data flow models for different relevancy rules and validation rules

• Built the mapping document to identify the relationship between multiple table required for the objects to design the IDOC mapping to load the data to target system via BODS

• Created BODS Projects, Jobs, Job Schedule, Work Flows and Data Flows

• Utilized various transformations such as Query Transform, Case Transform, Merge Transform, Validation Transform, Row Generation Transform, lookup, Table Comparison Transform, History Preserving Transform, Date Generation Transform, Pivot Transform, Reverse Pivot Transform, SQL Transform

• Performed the cutover activities to load the data for cutover objects within provided timelines and corrected all the IDOCs errors by analyzing the loaded data (~96% success rate)

• Ensured the data load quality (~200 Reports) by creating the missing configuration reports, system readiness reports, preload and post load reports

Mindtree - Bangalore, India (2013-2015)

Project: Unilever Fusion (SAP BW and BEX Reporting) Client: Hindustan Unilever

Role: Technical Lead

• Mitigated 15+ monthly critical issues by performing data analysis & RCA to ensure business continuity

• Ensured system uptime by DVM (Data Volume Management) analysis on regular basis and optimization of query and BW flow

• Successfully delivered the Adhoc BW solutions and new reporting requirement/Dashboard for sales/ Finance reporting

IBM Limited - London, UK & Bangalore, India (2007-2013) Project: Shell Global SAP (SAP BW 3.X, SAP BW 7.0, BOBJ Reporting) Client: Royal Dutch Shell

Role: Onsite Analyst (London, UK 2010-2012) / Developer (Bangalore, India)

• Developed the BW solutions for MM (Inventory management, Purchasing), Finance (COPA, PCA), Retail

(Site Profitability Reporting)

• Created BW artifacts (Info objects, DSO, Info cubes, Multiproviders, BEX Queries, Web Templates) to develop data flow, reports and dashboards

• Designed and developed data flows including Transformations, DTPs and DataSources, Develop process chains to load and monitor data loading, Build, Test and publish of BEX reports, BEX Workbooks and BEX Web applications

• Created ABAP artifacts (Function module based datasource, user exits, customer exits and transformation routines)

• Played the onsite Technical Analyst role at Shell Client location to manage the onshore offshore team Professional Achievements

• Received CIO Award for project delivery, at Shell Petroleum

• Received OPA awards/ACE Awards for contribution in project, at Accenture

• Received Shell Star Award/Excellence Award for the best contribution in Project, at IBM

Contact this candidate