Sap Hana consultant
Resume:
Unmesh Salvi
SAP HANA consultant
acy4eo@r.postjobfree.com
linkedin.com/in/unmeshsalvi
SAP HANA consultant with 10 years of professional experience. Currently working as SAP BW Architect for Finance department.
Working as an analytics expert in various BI proposals which include comparison study of different ETL tools fitment, BI effort estimation followed by bidding and sale.
Had worked in five End to End life cycle implementation, mainly focused in design, development and Post go live support.
Experienced in SAP BW for HANA and migrating standard SAP Models to In-memory optimized models and Performance testing.
Native HANA MODELLING - Designing Views (Attribute View, Analytic View, Calculation View), Stacked Calculation Views, Views that needs multiple table functions, counters, Restricted and Calculated measures, input parameters, filters, transparent filters. Debugging Views. HANA Modeling using SQL Script and CESQL scripting. Also trained on XSJS, OData, web services.
HANA SQL SCRIPTS & CDS [CORE DATA SERVICES] - Strong experience on Creating SQL, Stored Procedures with SQL Script and also with Calculation Engine (CE) Functions, Debugging SQL Script using various techniques like – Tracing, Using the SQL Script Debugger.
HANA SECURITY & TRANSPORT- Creating Analytic Privileges, Setup data level authorization and privileges at SAP HANA Database, Creating User, Roles & assigning the respective Privileges. Hands-on experience on all three modes of transport – Delivery Unit mode, Development mode, as well as on the ‘SAP support mode’, Apt in Direct metadata import – mass import of metadata, selective import of metadata.
Also have hands on experience of s/4 hana reporting and HANA live system to extract .sar and import the Delivery unit.
Developed data flows and work flows using BODS. Worked on RDS to implement ETL Replication. Used Rapid Marts for SAP Road Map. Developed ETL transformation.
Experience in Microsoft Power BI (Power Pivot, Power View, Power Query, Power Map)
Worked extensively in business processes across various SAP functional modules like SD, MM PP, PS, EHS, Vistex, and Finance, HR-PA.
Proactive team player, quick learner with excellent interactive and interpersonal skills to communicate with team members, developers, clients and end users at all levels.
Efficiently managed teams of various sizes and worked with the team to achieve company & client's goals
Provided BI trainings to associates, end user trainings to Client after Implementation.
SKILLS
Technical Skills
Functional Skills
SAP BW 3.x to 7.x
SAP HANA
SAP BW ABAP
SAP BODS
SAP EPM/BPC
Experience of Business Content scenarios /Customized reports from following SAP Modules:
Customer Relationship Management (Services)
Sales and Distribution (Sales Analysis)
Material Management (Purchasing and Inventory Analysis)
Finance ( Account Payable, Account Receivable and General Ledger Analysis)
Professional Experience
Putnam Investment [Enhancement & AMS] Massachusetts May 2016 – Till date
Project Scope: Enhancement and AMS related activities for the Putnam Investment in SAP BW system.
Responsibilities:
Working as a BW Architect on SAPBW 7.4 and BPC 10.1 NW version, developed complex models for Finance Dashboard, Revenue Sharing, NASD, Client Profitability, Revenue Recognition, PS, HR-PA, Master data Management.
Build a Master data upload Process from Oracle Database to BW.
Implemented new techniques to improve BW performance.
Using SAP UI5 & Fiori, JSON, D3 for build test apps trying to integrate few existing reports in SAP as an initiation of marching towards Digital Platform.
Using Agile & Scrum methodologies, leveraging agile methodologies in SAP. Meetings with business for quarterly and yearly projects to be implemented, creating Epics and Stories. Actively Involved in Sprint planning, backlog refinement and release management activities using JIRA tool.
Created NASD reports for the Investment fee capping and Revenue tracking. Expose the data through JSON on web.
Managed Profitability & Cost Management (PCM) modernization for production of the Statement of Net Cost and User Fee Reimbursable reports. That project integrated BW and PCM to provide an auditable, industrial strength solution for production of pre-mapped driver files and back end reporting of planning results.
Managed Business Objects Dashboard project. Produced management dashboards for their National Finance Center, Travel, and Help desk business processes.
Leading project on Financial Disclosure Management. Automate the production of Financial Statements using SAP Disclosure Management.
Active on various control boards including Change Control and Integration Board. Experienced in using Solution Manager for managing the control and movement of development across the ECC/BW landscape.
Connecting to Oracle database and created views, materialized views and scripts to get the transactional data and make it EPM reporting ready for Allocation process and generated Graphical reports using D3 reporting model.
Understanding the business requirements and design the flow as per requirement; developing the flow as per design. Revenue Recognition Process was challenging.
Using MDX queries to build report for Micro-strategy to pull the EPM Cube data for MTD, PYMTD, YTD, PYTD, budget and actual data for total firm revenue and expenses.
Using Power BI created Graphical & visual reports based on Bex Query and used Microsoft Power BI (Power Pivot, Power View, Power Query, Power Map)
Conversion of new business Trails Excel model to Power Query and PowerPivot.
Involved in Unit testing, Integration Testing, User acceptance testing etc.
Performance Improvement of daily job process using Materialized view, ABAP code improvement and process automation.
Designed, Developed and Maintained Universes by defining joins, cardinalities between tables applying contexts and alias tables to remove cyclic dependencies.
Hierarchies are implemented to support drill down reports.
Customized queries using navigational attributes and filters in BEX analyzer and used customer exits as per client requirements.
Sent data to SAP ECC using Remote Function module and IDOCS.
3M [Implementation & Rollouts] Minnesota Sept 2015 – May2016
Project Scope: Implementation, Rollouts and AMS related task management for the 3M LLC for SAP HANA systems. Its Enterprise HANA environment for BW7.4 with user all over the globe with local and common objects embedded into system for reporting purpose. Implementing performance optimized BW models in BW as well as in HANA, Exporting data to tools like BI4.2, BEx system for reporting purpose. Making Audit related data available to Auditors.
Responsibilities:
Worked as a HANA Lead with the capacity of team size 15.
Worked on HANA Views, Optimizing Data loads with the use of SLT and minimizing HANA space.
Built and enhanced objects in various business areas like MTD, GTS, CRM, RTR, LEX, HCM, etc.
Developed data flows and work flows using BODS.
Worked on SAP SLT and Smart Data access (SDA) for S4 hana Finance Data Integration.
Worked on Integrate SAP S/4HANA with SAP BW platform with guidance on how to set up the integration and pre-built content delivered with SAP BW environment.
Worked on S/4 CDS views for Accounts Payable with Cash Discount, Accounts Receivable Reporting, Cost Center Plan/Actual Analysis, Profit Center Plan/Actual Analysis, Accounts Receivable Analysis
Expertise in Converting front end business warehouse components like BEX Query into HANA View and Web Application Designer report into WEBI.
Hands on experience in Native HANA modeling. Created multiple schemas and table definitions. Experience in creating Attribute views, analytical view and calculated views. Good Knowledge in Direct Extractor Connections.
Built solution to generate reports using Open ODS and minimized the support activities.
BI project planning including effort estimation, resource alignment & creating an interim project plan.
Analyzed and prepared various documents like, Technical, Functional, business blueprints for reports and Automation process of data loads, etc.
Created Data Archiving Process (DAP) and optimized reporting on Near Line storage (NLS).
Developed data flows and work flows using BODS. Worked on RDS to implement ETL Replication. Used Rapid Marts for SAP Road Map. Developed ETL transformation.
FCA [Enhancement and AMS] Michigan Sept 2014 – Aug 2015
Project Scope: Enhancement & AMS related task management for the Chrysler LLC for SAP BW/HANA systems. Its Multi system environment with user all over the globe with local and common objects embedded into system for reporting purpose. Improving system performance for better output. Exporting data to other system for reporting purpose. Making Audit related data available to Auditors.
Responsibilities:
Working as a BW/HANA lead with the capacity of team size 10.
BI project planning including effort estimation, resource alignment and creating an interim project plan.
Worked with Power BI developer to Create Graphical Reports and generated relevant objects in BW.
Scheduling and conducting workshops for Knowledge sharing, reverse shadowing, enhancement gathering, analytical requirements understanding, etc.
Developed complex ABAP code in the end routines and start routines of the Transformation to satisfy the existing functions and latest business needs.
Analyzing and preparing various documents like, Technical, Functional, business blueprints for reports and Automation process of data loads, etc.
Axalta [Rollout/Business Separation] Delaware Apr 2014 – Aug 2014
Project Scope: Rollout and Business separation from existing system to new system from Multi landscape system into one system. It is a multi-country and business segment into one system project in which all ERP, Planning, BI systems are Merged into one environment. It was one time process and gathered all objects into one system related to Axalta Company from DuPont system.
Responsibilities:
Worked as a BW lead with the capacity of team size 10.
BI project planning including effort estimation, resource alignment and created an interim project plan.
Worked on mirror of source system method for near to 0 downtime of initial data load.
Also Lead the Unicode code conversion for migration of the project.
Scheduled and conducted workshops for Knowledge sharing, reverse shadowing, enhancement gathering, analytical requirements understanding, etc.
Analyzing and preparing various documents like, Technical, Functional, business blueprints for reports and Automation process of data loads, etc.
DuPont [Re Implementation] Delaware Dec 2013 – Apr 2014
Project Scope: Re-Implementation of Multi landscape system into one system. It is a multi-country and business segment into one system project in which all ERP, Planning, BI systems are Merged into one HANA environment. It is long term process and multiple rollouts. Phase 1 just rolled out.
Responsibilities:
Worked as a BW/HANA lead with the capacity of team size 15.
BI project planning including effort estimation, resource alignment and created an interim project plan.
Scheduled and conducted workshops for Knowledge sharing, reverse shadowing, enhancement gathering, analytical requirements understanding, etc.
Strongly worked on ABAP programming for BW with problem solving, and debugging skills
Analyzed and prepared various documents like, Technical, Functional, business blueprints for reports and Automation process of data loads, etc.
Developed various Vistex and EHS Modules related flow in BW system to fulfill the business requirement.
Capgemini India
PPG Groups [Enhancement] Illinois Jan 2013 – Dec 2013
Project Scope: Enhancement/Development on HANA and Implementation on SAP BW on HANA (Source System - SAP CRM 7.0 and Client Legacy Non-SAP Application)
Responsibilities:
Worked as an Onsite Consultant & Coordinator with the capacity of team size 7.
BI project planning including effort estimation, resource alignment and creating an interim project plan.
Analyzing and preparing business blueprints for reports and Automation process of data load.
Strategy definition for data extraction from SAP CRM and Non SAP systems (DB Connect / File System, etc.). Planning and executed the Initialization of data extraction and regularizing delta extraction and Process chain designing using new techniques available in BW/HANA 7.3.
Solution designing of BW Data Model (for Business Content as well as Customized Objects).
Various complex and customized reports for specific business requirements of CRM Lead management module.
Analyzed and translated the client's business requirements and functional specifications into technical specifications, data flow diagrams and data models.
Designed, Developed and Maintained Universes by defining joins, cardinalities between tables applying contexts and alias tables to remove cyclic dependencies.
Hierarchies are implemented to support drill down reports.
Customized queries using navigational attributes and filters in BEX analyzer and used customer exits as per client requirements.
Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies
Loading data into table definitions, suspending data loads, resuming data loads. Creating information objects (packages, attribute views, analytic views, calculation views Graphical and SQL script based)
Worked on RDS to implement ETL Replication and also using Rapid Marts for SAP road map.
Created new data source for Purchase Orders, Purchasing Requisitions, Account Assignment, and Services and extracted the data to Layer 1, Layer 2 DSOs and Cubes.
Created a comprehensive P2P reporting solution on top if the cubes by creating MultiProviders and InfoSets, so that user can link between Purchase Orders, Requisitions and Services with an estimated budget of 1 Million.
Design & developed Non-SAP Delivery consumption Module using customized flat file upload programs with validation and tracking of delivered goods consumption and calculation of incentives for sales team. Used BW system for data upload and DSO and multiprovider for reporting purpose.
IBM GBS
Abbott Labs Illinois Jan 2012 – Dec 2012
Project Scope: End to End implementation of SAP BI (Source System: SAP ECC and Legacy Non-SAP Application)
Responsibilities:
Worked as a SAP BW/BI Consultant within a team of 15 associates.
Onsite Offshore Coordination for Work, Management, etc.
Understanding the business requirements and design the flow as per requirement; developing the flow as per design.
Performed unit testing and Integration testing.
Reporting the bugs in defect tracking system.
Involved in Unit testing, Integration Testing, User acceptance testing etc.
Developed BADIs, Routines in BW System.
Extensively worked on Open Hubs and Delta load Mechanism for file output.
Preparation of design change documents as and when required.
Client trainings after every development module release.
Performed role of project Defect Prevention Analyst to reduce effort & improve quality of development.
Indofil Industries Mumbai, India August 2010 – December 2011
Project Scope: End to End implementation of SAP BI (Source System: SAP ECC and Legacy Non-SAP Application) Indofil Industries Limited is uniquely placed both in Agricultural Chemicals (ABD) as well as Specialty & Performance Chemicals (S&PC) Business.
Responsibilities:
Worked as SAP BW Implementation Consultant and Implemented entire BW project single handed.
Involved in System Study & Business Requirements Analysis & Documentation.
Interacted with the End Users, Business Analysts and responsible for Involved in training sessions to impart knowledge on designed universes and published reports.
Involved in managing full project lifecycle including upfront requirements analysis, documentation, project plan management, user acceptance coordination, production rollout, end-user training, providing post implementation adoption management and customer service.
Applying different Delta mechanisms for SAP as well as Non SAP Systems and Data Staging from several Source Systems.
Worked with several users both at execute as wells as non-executive levels to gather requirements and transformed them into a data model.
Coordinated & groomed the client’s team on various technical as well as application aspects.
Developed complex ABAP code in the end routines and start routines of the Transformation to satisfy the existing functions and latest business needs.
Created various transports, collected the required objects and migrated to the target systems.
Developed various deliverables like BBP, Functional and Technical specs, Data mapping, Data flow documents, Gap & Impact analysis documents, Step by step solution & Transport sequence
Business Objects: Experience in building Universes and Creating Complex and Ad-Hoc Reports using Web Intelligent and Xcelsius.
Experience with SAP Business Objects, Xcelsius, Crystal reports, Live Office and SAP BEx Analyzer, BEx Browser, Query Designer, Web Application Designer and other reporting tools.
Involved in the SAP Business objects Data services (BODS) implementation and POC and exposures to the components like Designer, Job server and Engine and Repository. Key role played in Integration of Business objects and BODS with SAP BW and POC.
Designed and developed the process for extracting, transforming, and loading data using the SAP Business Objects Data Services into SAP BW Data targets. Transformed the data to suit to business needs. Verified and improved the quality of your source data.
ThyssenKrupp Industries, Florida March 2010 – August 2010
Project Scope: End to End implementation of SAP BI (Source System: SAP ECC and Legacy Non-SAP Application)
Responsibilities: Worked as SAP BW Consultant within a team of 15 associates taking care of multiple modules such as PM, MM, SD, QM, PS, FI, HR, etc.
Interacted with the Users, Business Analysts and responsible for Involved in training sessions.
Developed complex queries and reports using different data providers in the same report
Involved in managing full project lifecycle including upfront requirements analysis, documentation, project plan management, user acceptance coordination, production rollout, end-user training & providing post implementation adoption management & customer service.
Created BW Objects, Update rule, Info Packages, Data Targets & Multi providers in accordance to the application.
Implemented Elimination of Internal Business Volume when transactions occur in interim company warehouses. Responsible of Unit test cases.
Prepared Project Documentation and as well as technical documentation for End users and IT core team members.
Siemens Information System Limited
Talecris [AMS] North Carolina, March 2009 – Feb 2010
Responsibilities:
Worked as SAP BW Support Engineer for Enhancement of BI Objects, Query designing, Model designing, ABAP Enhancement.
Early Watch Report actions, Change in Full update to delta update for entire ETL process.
Experience in data extraction from non-SAP sources like flat files, & ORACLE 10.G by creating materialized views.
Extensive work experience in building and designing reports using query designer, analyzer, and publishing using WAD to Enterprise portal.
Expertise in creating and maintaining Process chains, Meta chains for Full/ Initialization / Delta data loads and administration of SAP BI system and ETL Process Monitoring.
Finland Cluster [AMS] Finland March 2008 – Feb 2009
Responsibilities:
Providing support to SBS Germany and SIS Finland clients like Metso OYJ, Metso botnia, Metso minerals, Mera nova, Metso Sweden, Teboil, Outotech etc.
Involved in creating customized ODS and changing the Existing data model of an Info Cube by adding new Characteristics and Key figures.
Worked extensively on LO Cockpit extractions, enhancing data sources, filling setup table, loading the data from R/3 to BW and used various update methods.
Created Workbooks of different layout and style and query with selections, formula and different Variables with User Entry/Default Value, Replacement Path and Customer Exit as per customer requirement.
Performed selective deletion, compression, rollup on cube. Validating info cube and DSO data with PSA and R/3 and finding reason for incorrect data. Actively Involved in Rectification of data Load Failure of Master Data Loads and transaction Loads.
Well versed with full cycle of remedy ticketing tool to deal with CR and tickets opened by clients and also keeping track of all open and pending tickets with different priority.
Mercurius Info Tech Ltd.(August 2007 – March 2008)
LDH System (December 2007 – March 2008)
Role: Developer [Support Project](SAP AMS)
LDH is the leading UK Private Label supplier of canned tomato products, fish, fruit and vegetables, dried pasta and selected other ambient foods to the major UK supermarkets as well as supply for food service and manufacturing industries.
Specifications:
Platform : SAP R/3 5.0 ECC
Team Size: 4
TCODE Used: VA43, VA03, SE80, SMARTFORMS, SO10, SE37, NACE, SE10,etc
Job Description: Coding for Smart forms, Client Support
Modifying Smart Forms for Order Confirmation
QMH System (November 2007 – December 2007)
Role: Developer [Support Project](SAP AMS)
Specifications:
Database: ORACLE
Platform : SAP R/3 4.7 ECC
Team Size: 4
TCODE used: VA43, VA03, SE80, SMARTFORMS, SO10, SE37, NACE, SE10,etc
Job Description: Coding for Basis Report for daily analysis, Development of System overview,
SAP component Installed, client settings, system availability, Background processing, backups and archive, error check, Update termination, lock records, spool request, SAPDBA tools, SAP dumps, Transactional RFC outbound and inbound
Tetrad System (November 2007 – December 2007)
Role: Developer [Support Project](SAP AMS)
The UK based company Tetrad represents traditional hand built craftsmanship combined with modern materials and innovative techniques to ensure a level of quality that is second to none.
Specifications:
Database: MS SQL 2000
Platform : SAP R/3 5.0 ECC
Team Size: 3
TCODE used: VA43, SE80, SMARTFORMS, SO10, SE37, NACE, SE10,etc
Job Description: Coding for Smart forms, Client Support
Modifying Smart Forms for Order Confirmation
Dunlop System (October 2007 – November 2007)
Role: Developer [Support Project](SAP AMS)
The UK based company manufactures passenger, sport, performance, truck and SUV tires.
Specifications:
Platform : SAP R/3 5.0 EE
Team Size: 5
TCODE used: VA03, SE80, SE71, SO10, SE37, NACE, SE10,etc
Job Description: Coding for SAP script, Client Support
Creating SAP script for invoice of order
Education Details
Course
Name of College/University
Year of Passing
Percentage/ Class
B. S. (I.T.)
Usha Pravin Gandhi College of Management Mumbai University
2007
63.00%
GDSCM
Narsee Monjee Institute of Management Studies
2013
First Class
Contact this candidate