Vikram B. Divekar

Contact: +1-971-***-****

E-Mail: adjxyq@r.postjobfree.com

Address: ***** ******** ** *** *** Eden Prairie MN 55344

PROFESSIONAL PROFILE

15+ years of professional experience of which over 12 years in SAP as Lead BI Consultant with strong leadership & interpersonal skills. Expertise in Native HANA 2.0 SPS 03, HANA WEB IDE, BW on HANA, SLT, BI, BO, BODS, Tableau, Power BI, Analysis Office & HANA SAC (Analytics Could).

Experience in working with cross functional & Non-SAP teams, worked as a Lead consultant for projects like on-site & offshore models in areas of SD, MM, FI, CO, PP, PM, S&P in domains like Manufacturing, Retail, Banking & Pharmaceuticals.

Experience in multiple Implementation and support projects of BW on HANA, Native HANA, BW 7.x, Tableau, Business Objects Data services, BO, Power BI & SAC.

AREA OF EXPERTISE

Technical Expertise :

SAP HANA:

oExpert level Architectural and Modeling experience

oExpert to work in SAP HANA EE

oComplex Modeling using different types of views like Attribute view, Analytic view, calculation view and Analytic privileges using eclips or SAP WEB IDE

oScript based Calculation Views using Table function, SQL Script

oHANA development artifacts : XS Odata, XSJS, Core data services (CDS) to create tables and views

oPerformance Optimization / tuning using execution plan, cockpit, and remodeling.

oSAP HANA Data provisioning using SDI flow graph development, SAP Landscape Transformation and SAP Data services, Flat File Uploader for SAP R3/ECC and non-SAP systems.

oText Analysis with custom directory development and fuzzy logic

oSAP HANA Extended Application(XS), Job Scheduling

oSAP HANA security roles, authorizations and Application Life cycle Management

Analytics:

oSAP Lumira: Data Access and Visualization Extensions

oSAP AO, SAP Design Studio, SAP Cloud platform, tableau, Power BI

oSAP Predictive Analysis : Time series, Clustering, Outlier and Association algorithms for the decision-making process

oSAP Business Objects XI R2/R3 tools such as Universe Designer, Information Design Tool 4.1, Web Intelligence 3.1/4.1, Infoview/Launchpad, Xcelsius 2008/Dashboard Designer and Desktop Intelligence

oWeb Intelligence reports development using multiple functionalities such as Merge Dimensions, Filters, Drill Functionality, Ranking, Graphs, Breaks, Crosstabs and Hierarchy

oBuilding and designing BI reports, dashboards and all forms of user-facing analytical functionality using Webi, Dashboards leveraging SAP HANA database.

oHands on experience in creating the Business Intelligence reporting & Visualizations using HANA datasource

oAnalytics cloud connections for on-Premise & Cloud based including SAP HANA, Business Objects and cloud for Analytics

oTransform (Join or extract data from non-sap sources using Views or apply business logics using SQL) and Visualize the data from various source systems in Analytics cloud, Tableau & Power BI.

oVisualizations & Dashboards using Tableau Desktop & Design Studio

SAP BW:

oWorked on BI 7.0 Data warehousing workbench: Production support of Info objects, Info Cubes, Data Store Objects (DSO), Multi providers, Info Sets and Open Hub Services.

oExtensively worked on DTPs, Transformations, Start, End and Expert routines, Info Cubes, DSO Objects, reconstruction, remodeling, repartitioning, open hub destinations, multi providers, Info sets and BI Accelerator.

oMigration of DSO’s and Cubes to “In memory optimized” info providers to support HANA database.

oExperience of pre and post migration activities of database migration option to HANA.

oCreated process chains for deleting and recreating the indexes and for loading master data (texts and attributes) and the transactional data.

oInvolved in Transactional/Master data loading, Scheduling, creation/monitoring of process chains and resolving of various data load errors.

oExperience in transporting objects from Development to Production

oCreate packages to copy the forecast, plan and budget data.

oConfigure data manager extraction from ECC and BI system for the actual, plan data

SDLC:

oWell versed with complete SDLC from Requirement gathering, development thru deployment

Technical

Software Products : SAP HANA SP12, SAP BI 7.0, SAP BO 4.0

Admin Tools : SAP HANA Studio, SAP HANA Information Composer

Data Provision : SLT, SAP Data Services, Direct Extractor Connection, Flat file Uploader

Reporting : Excel, Business Object Explore, Webi, Dashboard, Lumira, SAP PAL, SAP Analytic cloud

Language Tools : HANA SQL scripting, Javascript, HTML5, CSS

DatabaseTools : SAP HANA Database, SQL 2005 and 2008

Employer : MSRCOSMOS (SubContracted with Cognizant Technology Solutions US Crop.)

Project : Cargill Datalake Application and support

Period : From Jul 2018 to Jan 2021

Environment : SAP HANA, SLT, SDI / SDA, SAP Analytic Cloud, SAP AO, Design Studio

Cargill, Incorporated is an American privately held global corporation based in Minnetonka, Minnesota, Minneapolis suburb, and incorporated in Wilmington, Delaware. Founded in 1865, it is now privately held corporation in the United States in terms of revenue. If it were public company, it would rank, as of 2015, number 15 on the fortune 500, behind McKesson and ahead of AT&T.

Objective: Data Lake will have consolidated data repository across Cargill Business Units to provide a unified view of master and transaction data to enable analytics, and operational data consumption, including Strategic Pricing, Supply Chain and Financial Reporting. It will be single source of the truth for all data and analytic needs across the organization with the ability to collect and own accurate data at the right level of granularity from various points within Cargill.

Responsibilities

Responsible to design and develop more than 15 data lakes for Cargill which are consuming SAP and Non sap data

Provided and implementated recomandations to improve data hopping at Cargill and reduced IT cost by

1.5 million / year

Review current SAP HANA and Hadoop architecture for pre build cargill datalake

Optimized more than 100 hana views as per best practices, decrease computational memory from 450 GB to ~8 GB and brought stabilization in current ecosystem

Moved custome T-Code logic into SAP HANA and reduce load from transcational system

Eliminate unplanned downtime in analytic area by setting up query execution threshold limit & visualization plan for RCA

Replaced Hadoop scoop jobs & Store procedures in HANA by implementing SDI

Designed and developed flowgraphs by using SDA and brought real time data for reporting

Implemented XS Jobs for near realtime data

Replaced scripted calculation views and rank node by implementing Table functions

Improved reports performance by 10X by optimizing HANA queries

Provided recomandations and helped business users to improve CRQ approval process

Coordinated business analysts and team of 11 offshore developers to deliver the project on time without any customer escalations.

Brought HCI logics and filter conditions in the HANA DB layer and reduced load from HCI

Conducted, facilitated and lead UAT working sessions with business users for signoff.

Designed, developed and migrated SAP HANA artifacts (Caluction views ) from lower environment to production by using delivery units

Managed epics, features, product backlog, Stories and task in azure devops for each sprint.

Actively participated in sprint planning and rectrospreactive session

Employer : Cognizant Technology Solutions US Crop.

Project : Analytic Solution Development

Period : From Dec 2017 to Jun 2018

Environment : SAP HANA, SLT, SAP AO, Design Studio

American Water is a public utility company operating in the United States and Canada. It was founded in 1886. Most of American Water's services are locally managed utility subs

idiaries that are regulated by the U.S. state in which each operates. American Water also owns subsidiaries that manage municipal drinking water and wastewater systems under contract and others that supply businesses and residential communities with water management products and services

Objective: Reduce load from ECC, by providing a BI analytical solution to the user, for decision making. It will be the batch job free solution for real-time reporting.

Responsibilities

Responsible for delivering the following analytic solutions by using HANA and SAP BO

Field service representative – Customer Notification

ZIQ08 – Replace meter order generation

Developer Refund Report

BPU Regulatory Reports

Closely worked with American Water business users in Project design, roadmap, detail designs and Development approaches.

Developed MVP as per sprint and moved to production by using CHAMP

Conducted periodic demo with business and taken the deliverables sign off as per sprint

Worked with PM for the backlog development in Jira

Extensively used HTA for HANA views promotion in different landscapes

Involved in creating a technical design document for each of the reporting areas

Extensively involved in the training of the end users and creating training documentation

Developed HANA views, Scripted Views and SAP AO, Lumira, Webi reports

Employer : Cognizant Technology Solutions US Crop.

Project : VDM (Virtual Data Mart) Implementation

Period : From July 2017 to Nov 2017

Environment : SAP HANA, SLT, SAP AO, Design Studio

Objective: Creating VDM by pulling data from various data sources to build interactive apps for business users by adopting scrum methodology.

Responsibilities

As HANA lead, managed the entire development efforts at onsite and offshore

Worked with SAP HANA architect lead and influenced key architectural decisions

Hands-on experience in using JIRA for managing agile VDM projects

Active involvement in business user discussions

Coordinating with the Functional team, Business team and converting requirement into SAP HANA artifacts.

Design and develop an architecture for VDM

FIT Gap Analysis, Finalized KPIs and replicated tables at SAP HANA for VDM development.

Conducting team meeting, monitoring development and managing road-blocks for SAP HANA VDM development

Development of VDM for Device Management, Revenue, Account Receivable and Inventory

Conducting prototype demo with business users

Prepared Go-Live plan and involved in migration activity of all VDM from Quality to Production

Setup staging environment for VDM

Mentored and trained junior SAP HANA resources

Employer : Cognizant Technology Solutions US Crop.

Project : Customer One View

Period : From March 2017 to July 2017

Environment : SAP HANA, SDI, SAP BO, SAP XS, SQL

American Water embarks on a journey to improve and enrich front-line employees experience through leading technologies in the field that makes work easier while also transforming and improving the relationship between American Water and its customers.

Responsibilities

Provisioning of tables from SAP ERP (ECC, CRM, SRM)

Provisioning of HANA 1.0 views as Virtual tables in HANA 2.0

Design & Development of SDA/SDI flowgraphs in HANA2.0

Scheduling & Monitoring of SDA/SDI data flow objects in XS

Testing for flowgraphs for data accuracy & performance

Design & Build of HANA models in HANA 1.0 on base tables

Design & Build of HANA models in HANA 2.0 on target tables for desired output structure

Testing of models for data accuracy and performance

Provide data extracts from HANA as per requirement

Role testing of XS Job scheduling - Work with Security & Basis

Work with security in defining roles & access in the new 2.0 system for developers and applications (service id)

Work with basis on setting up new HANA 2.0 environment and SDA/SDI components

Setting up of Schemas for Virtual tables and C1V target tables - HANA 2.0

Coordinate with Basis on setting up SLTs (CRM & SRM)

Transport Management with Basis whenever needed

Taken Code backup as desired and developed Cutover Planning & execution

Coordinate with Infosys in defining source system mappings and business logic

Coordinate with Infosys in testing data from HANA for accuracy and tweaking mapping logic

Coordinate with AppOrchid in understanding & defining data requirement and data enablement

Coordinate with AW for release planning, scoping and delivery

Employer : Cognizant Technology Solutions US Crop.

Project : KPI Implementation

Period : From Nov2016 to March 2017

Environment : SAP HANA, SAP BODS, SDI, SAP Fiori, SQL

KPI will be the centralized, single “source of truth” repository containing pre-built, data-driven business performance metrics (i.e. KPI’s) for the following American Water regulated business functions: Finance, Supply Chain, Customer and Enterprise Asset Management

Responsibilities

Involved in full life cycle implementation, which includes Analysis, Requirements gathering, Development, and Reporting and Testing process.

Played role of HANA Solution Architect/Team Lead and managed a team of 4 developers.

Designed the Data Model, Data Provisioning through SLT y working closely with basis consultant and hybrid models for SAP UI5 Reports

Developed calculation views (Dimension, Cube) and Scripted Calculation views for windows functions.

Designed, developed and implemented oData services for SAP UI5 application

Migrated SAP HANA models and oData services using delivery unit and developer mode from Dev, Quality environment

Optimized SAP HANA models and filtered data at the bottom level by using input parameter mapping

Created Technical documents

Involved in UAT and sign off from the functional consultant.

Employer : Syntel Consulting Inc.

Project : 4010, POLK and Concession Analysis

Period : From Jan 2015 to Nov2016

Role : Technical Specialist

Environment : SAP HANA, SAP BODS, SDI,SAP BO, SAP PAL, SQL

Daimler Trucks North America LLC, formerly Freightliner Corporation, is an automotive industry manufacturer of commercial vehicles headquartered in Portland, Oregon, and is a wholly owned subsidiary of the German Daimler AG.

Responsibilities

Collecting requirements from Business, PM and DTNA Management.

Creating schemas and providing all required permission for native SAP HANA development

Using SDI / BODS as a Data Provision tool to bring data from DB2 to SAP HANA tables

Lead the BODS to SDI interfaces project

Worked on various aspect of SDI like Data Sink, Template Table, Filter, Sort, Pivot table etc. and involved in Data cleansing activity

Developing Attribute, Analytical and Calculation views in SAP HANA environment and extensively using their features.

Optimized HANA models through proper placement of joins at respective levels

Coordinating with SAP HANA admin to migrate, created views in delivery units, from development environment to testing environment or Production.

Implementing Level Hierarchy and Time Dimension attributes for granular level data reporting.

SAP HANA Extended Application(XS) services used for job scheduling.

Designed and developed Financial reports (Consolidated balance sheet Analysis, Consolidated income statement report, Monthly Comparison Balance sheet and Income Statement Analysis, Expense Reports for QTD and YTD)

Developing hierarchy for drill down reporting purpose at SAP Predictive Analysis and Lumira

Currency conversion to convert CAD into USD

Extensively involved in Project design, roadmap, detail designs and Development approaches.

Developing calculated attribute and calculated measures at analytical and calculation views

Filtering data using input parameters and / or Variables at HANA modeling

Conducted performance tuning of HANA models using SAP visualization perspective

Reviewing code, HANA development and documentation prepared by peers and juniors

Development, Unit Testing, Integration Testing, Training Documentation and end user training

Trained the business users in using Lumira for self-service way reporting

Created Universes on top of HANA calculation views and developed the Webi reports

Worked with BODS functionalities Project, Job, Work flow, Data flow, Data store to import the tables from ECC to HANA

Single Web Intelligence reports on multiple data sources (SAP and Non – SAP) and extensively used Prompts, Variables, Drill down, Breaks, Sections, Conditions, input controls

Creating interactive dashboard using SAP Dashboard 4.0 based on QaaWS, SAP Universe etc.

Worked with Design studio, created analysis application, worked with data sources, analytic components, Basic and container components

Developed Store Procedure to calculate cumulative chart for SAP Lumira story boards.

Implemented Time series, Clustering, Outlier and Association algorithms in SAP Predictive Analysis using SAP HANA database

UAT testing for developed views and reports, Bug fixing activity with SAP testing team.

Maintaining daily / weekly MIS and Project status

Employer : Syntel Consulting Inc

Project : Sentimental Analysis

Period : From Mar 2014 to Dec 2014

Role : Technical Specialist

Environment : SAP HANA, SAP Lumira, J2EE, SQL

Integration of Social media platform with SAP HANA database to get the customer sentimental on real time basis about product features likes / dislikes area of interest, customer geography. So, company will consider all the parameter and could deliver best product in next release.

Responsibilities

Presented customer sentimental analysis demo to Syntel board

Integrated twitter crawlers with SAP HANA database with the help of JAVA developer

Implemented Text search analysis on SAP HANA table and created index tables for views development

Developed analytics and calculation views on top of sap HANA index table and other tables

Developed advanced SQL Script procedures for integrating SAP and non-SAP data into Unified HANA Model.

Performed various data massaging operation like datatype conversation, table alteration using SQL

Created jobs and schedules for data updation in SAP HANA tables on regular interval using SAP XS engine.

Created Level hierarchy at Attribute and Calculated view and developed calculated measure at SAP Lumira for sentimental ratings. Story board in SAP Lumira

Developed line charts, area charts, Pie charts, geography bubble charts using SAP HANA datasource and Implemented drill down, ranking functionality.

Employer : Syntel Limited.

Period : From Sep 2013 to Mar 2014

Role : Technical Specialist

Environment : SAP BO, UDT, Webi, Dashboard, Teradata

FedEx SmartPost is a great solution for online retailers, catalogers, fulfillment houses and direct marketers who are looking for a cost-effective means of shipping low-weight packages to residential customers.

Responsibilities

Handle team of 4 SAP BO software engineers for Fedex – Smartpost Project.

Perform SAP universe development to generate custom business reports (SAP Web intelligence, Dashboard etc) as per client requirement.

Perform impact analysis on SAP BI reports in order to resolve SAP BI issues

Created several Universes using Designer according to the requirement.

Created various User defined objects including Dimensional, Detail, and Measure objects and tested them to ensure correct mapping of data.

Improved the performance and reduced the coding with the use of @functions (@aggregate aware, @select, @prompt, @where).

Created new and modified existing Hierarchies in the universes to meet Drill Analysis of the user’s reporting needs.

Defined Alias and Contexts to resolve loops and also tested them to ensure that correct results are retrieved.

Performed integrity testing of the Universes

Trained end users to use various functionalities of Business Objects and provided technical support.

Created different types of reports such as Master/detail, Cross Tab and Charts as well as integrated graphical representation of reports such as Bar charts, 3D charts and Pie charts etc.

Developed Web Intelligence reports making use of several Queries (Union, Intersection, Minus).

Used Prompts, Conditions to restrict the data returned by Query and used Filters to restrict the unwanted data to be displayed on the report.

Used Alerts to draw attention to a particular block

Used multi-dimensional analysis (Slice & Dice and Drill Functions) to organize the

Worked extensively with the major functionality of BO like Breaks, sections, Group values, Sorts, List of values (LOV),Pre-defined conditions, Calculations and Ranking.

Used Report conversion tool to convert single Deski report to Webi.

Exported reports into PDF, CSV and XML formats as per the client requirement.

Employer : Syntel Limited.

Period : From June 2013 to Jul 2013

Role : Technical Specialist

Environment : SAP HANA 1.0, SAP BO 4.0, SAP BODS, MS SQL 2008, MS-Ofiice

Responsibilities

Coordinating with HANA In-House team and management

Collecting requirements from project manager for pre sales slide deck.

Creating and modifying slide deck as per requirement and suggestions

Analyzing project scope, effort estimation and consultation on resource planning activity for project scope documentation

Consulting with cross vertical project manager regarding SAP HANA capabilities and usage

Developing and upgrading SAP HANA course for incumbents.

Training resources on SAP HANA technology as per HA 100 (SAP HANA Introduction) and HA 300 (Implementation and Modeling) course

Developed Attribute, Analytical and Calculation views in SAP HANA environment and extensively used their features to showcase HANA capabilities

Employer : Angel Broking Pvt. Limited

Period : From Oct 2012 to June 2013

Role : Sr. Manager

Environment : SAP HANA 1.0, SAP BO 4.0, SAP BODS, MS SQL 2008, Asp.net, Flat Files

Angel Broking wants to implement SAP HANA for Risk Management application to get instant overview of Stock Market condition. It will help to risk management analysis to square off the client position as well as the portfolio Manager to instant decision

Responsibilities

Involved in information gather phase

Migrated MS SQL Database into SAP HANA

Created Users, Roles, Privileges, Packages, Schemas as part of HANA Security and Development

Designed and implemented SAP HANA data modeling using Attribute View, Analytic View, and Calculation View.

Executed Data Extraction Transfer Loading (ETL) using SAP Data Services 4.0 to import csv files into SAP HANA tables to reflect exchange live rates application

Involved in SAP HANA Security including User Management, Roles, and Privileges

Reporting, Accessing Analytical and Calculation views from EXCEL.

Involved in Information Design Tool - Creation of Data Foundation, Universe for HANA reporting.

Developed Web Services for SAP HANA database and deliver to ASP.NET developers to consume data in .net based applications

Employer : Angel Broking Pvt. Limited

Period : From April 2008 to Sep 2012

Role : Sr. Manager

Environment : Query Designer, and Web Application Designer, SAP Business Objects 4.0 (Universe Design Tool, Information Design Tool (IDT), Web Intelligence report, Dashboard Design (Xcelsius), Live Office).

Responsibilities

Generated reports involving complex queries, sub queries, Unions and Intersection.

Web Intelligence reports included the utilization of master details, cross-tabs, slice and dice and drill mode as per the requirement of the end-user

Tuned and Enhanced Universes with SQL Queries for the Report Performance.

Experience in SAP BO 4.0 Universe Information Design Tool (IDT), Web Intelligence Reporting, SAP Dashboard 4.0 (Xcelsius) and Crystal Report 2011.

Performed configuration of Business Objects 4.0. Involved in adding new group/user, assigning universe access to users.

Designed enterprise SAP Dashboard 4.0 using combination of Information Design Tool (IDT) and Live Office connectivity.

Trained the users to get them familiar to Business Objects in order to help them run the system on their own.

Involved in System Integration Testing (SIT)

Involved in meetings with business users in order to gather business requirements and prepared business blue print based on those requirements.

Created summarized reports, which includes display of Plan/Actual variance measures, analysis of full cost by cost center, overdue analysis, and analysis of payment history.

Angel Broking Pvt. ltd, Mumbai (Jun’05 – March ’08) as Asst. Manager - Ecommerce

Worked on .net technology from classic asp to .net 4.0. Developed lots of asp.net related projects, which were web based, and desktop-based applications. If require then produce separately.

CERTIFICATION

SAP HANA - SP04 certification from SAP Bangalore on 18 Oct 2012.

ITIL Foundation Certification in IT Srv. Mgmt. certification

TRAININGS UNDERGONE

SAP HANA Training, HA100&HA300 (SAP HANA Introduction, Implementation & Modeling) at SAP Bangalore

SAP Business Objects, at Syntel Ltd.

Microsoft .NET Concepts & Development

SCHOLASTICS

PGD (E-Commerce) - Welingkar Institute of Management Development & Research, Mumbai in 2009.

B.Sc. (IT).–V.G. Vaze College, Mumbai in 2005.

Contact this candidate