Bhalchandra Kunte
***********.*****@*****.***
SUMMARY
Over 14 years of consulting experience that includes over 9+ years implementing Enterprise Data Warehouse and Business Intelligence. I work with the IT and Business teams to deliver scalable analytic solutions utilizing on-premise or cloud technologies. I assess risk, anticipate bottlenecks, provide escalation management, balance business needs versus technical constraints, implement best practices and define processes.
SAP HANA Experience
Lead Greenfield Implementations, migrations and re-engineering activities to address highly complex integrations. Drove the high-quality completion of systems engineering, software/database development and enterprise wide implementation projects for major clients including:
Illumina
Agilent Technology
Verizon
John Deere
Lam Research
Latrobe Steel
Experienced in Designing & Architecting Data Warehouse in Oracle, MS SQL Server, SAP HANA and implementing BI reporting solution in SAP Business Objects and other reporting tools.
Hand on SAP provisioning which includes LT Replication Server (SLT), BODS and Smart Data Access & SDI.
Strong experience in SAP Native HANA Modeling, Scripting, Security and Infrastructure as well as SAP Cloud Connector.
Advanced expertise in SAP HANA, Business Intelligence, Business and System Analysis, Requirements/Gap Analysis, Preparing Functional Designs, and Design & Development of Business Intelligence Solutions and visualizations using Complex SQL scripts, SSRS, BOBJ, Lumira, Power BI and Tableau.
Extensive experience in reporting against OLTP and OLAP Data sources.
Expert knowledge of RDBMS with strong database skills.
My Blogs on SAP.SCN
Parameter Mapping String to Date for filtering base table (Dynamic Dates)
Fun with Dates
IsDate function in HANA
Education
MBA in IT from WGU Texas (USA)
Bachelor of Commerce from Mumbai University (India)
Training and Certification:
SAP S/4 HANA Finance Training.
OpenSAP: Introduction to SAP HANA Cloud Platform
OpenSAP: SAP BI 4 Platform Innovation and Implementation
Solution Consultant SAP NetWeaver 2004s- Business Intelligence (SAP BI 7.0)
Microsoft Certified Solution Developer (MCSD)
Microsoft Certified Application Developer (MCAD)
Project Experience
Delta (Service Industry Project)
Mar 2019 – till date
SAP Architect [AWS, SAP Native HANA 2.0, BOBJ, SAP FICO, Treasury]
Worked closely on full life cycle with Client on FICO/Treasury module.
Planning, designing, implementing, and advancing SAP-based solutions with AWS.
I worked on data and analytics to provide insight on where the company should direct its future investments, while optimizing current features. Participate in strategic planning and the development of company business objectives in conjunction with other senior leaders.
As a key member of the leadership team, develop and maintain meaningful relationships with all internal and external stakeholders.
Worked on HANA data migration to AWS.
Illumina, San Diego (Manufacturing/Service Industry Project)
Feb 2018 – Feb 2019
SAP HANA Architect [SAP Native HANA 2.0, SAP CRM, SAP FICO]
Worked closely on full life cycle with Client on Opportunity module.
Gather requirement, designed developed Opportunity Information model, performance tuning.
Create stored procedure to get SAP HANA Views Lineage from top view to bottom view/tables/stored procedures/functions.
Developed stored procedure for security.
Developed and created Test plans.
Worked on XSJS CRUD Demo.
Installed SAPUI5 files as well as driver required for the Demo project.
Worked with WEB IDE for SAP HANA to create hdbdd/hdbdd files, views and hdbprocedures.
Developed CDS entities, associations, views etc.
Developed OData services, web services to integrate HANA entity, views with front end tool.
Fine tune queries to ensure that their performance is optimum.
SLT Replication of the ERP Tables.
Dorman Products, Dallas (Manufacturing Industry Project)
May 2018 – Jan 2019
SAP Architect [SAP Native HANA, SAP WM, FICO, BOBJ, AO]
Worked closely with senior client BI Director to set overall enterprise BI strategy, Analyzing business goals, rules, and processes across various information systems tools and technologies.
Worked with WEB IDE for SAP HANA to create hdbdd/hdbdd files, views and hdbprocedures.
Developed CDS entities, associations, views.
Developed OData services, web services to integrate HANA entity, views with front end tool.
Created complex HANA scripts and procedures.
Fine tune queries to ensure that their performance is optimum.
SLT Replication of the ERP Tables.
Debug and performance tune SAP HANA views to bring it below 10 sec mark as set by client for 5 million records.
Completed, helped testing and successfully delivered project before allocated time.
Sedgwick Claims Management Services Inc, Dallas (Insurance Industry Project)
March 2017 – April 2018
SAP HANA Architect [SAP Native HANA, SDI, Power BI]
Designed and created database and related objects.
Documented data and prepared data dictionary.
Defined and documented data sources at the field and data type level for legacy systems.
Review target data specifications at the field, type and length level.
Developed Odata Associations, Aggregation, configurable cache settings, Customer Exits for write request.
Strong knowledge of designing of roles & authorizations and implementation of complex security rules and role for SAP HANA. Able to create schema level access control on HANA DB.
Used pre-delivered data sources that are built on the virtual data models to build custom CDS views.
Lead and mentor team comprising of 8 onshore and offshore HANA consultants.
Delivered on-demand reports in multiple rendering formats with standard and data driven subscriptions.
Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
Agilent Technology, Santa Clara (Manufacturing/Service Industry Project)
June 2016 – Feb 2017
SAP HANA Lead [ SAP CRM, SAP FICO, Sales Force, SAP HANA Live, SLT, BOBJ]
Currently working on SAP HANA Modeling /Scripting and Security for SAP CRM Opportunity/COPA (Service Profitability) and Contract Renewals track.
Worked on SAP HANA Live Virtual Data Models (VDM).
Copying SAP HANA live VDMs for CRM.
Tested and customize SAP HANA live VDM.
Created table, sql view, association between entities and user-defined structured using Core Data Service (CDS)
Worked on Performance Tuning models and scripts.
Worked very closely with Business in understanding the functional requirements.
Designed and implemented SAP HANA data modeling using Attribute View, Analytic View, and Calculation View.
Developed complex SQL scripts in Calculation views.
Designed and implemented SAP HANA Security.
Lam Research, CA (Manufacturing Industry Projects)
Oct 2015 – May 2016
Sr SAP HANA Architect [SAP Native HANA, PowerDesigner, SAP HANA Provisioning Tools, MSSQL]
Gathering requirements, scope finalizing, designing technical solutions and preparing the relevant technical specification.
Responsible for effective communication between the project team and the customer.
Migration of application from Legacy Database (MSSQL) to SAP HANA.
Migrated MSSQL objects in SAP HANA which includes stored procedure, trigger, cursor etc.
Worked with PowerDesigner and Information Steward
Installing PowerDesigner and PowerDesigner Portal Server
Building Conceptual and Logical Data Models.
Generated PDM from CDM.
Implementing data integrity checks.
Administering PowerDesigner.
Adding PowerDesigner to Information Steward Metadata management.
Creating Metapedia, configuring match, validation Rules.
Data Quality Scorecard & Monitoring.
Worked with BODS
Gap analysis, package evaluation and implementation.
Deliver ETL and Data Quality Solutions Architecture and Design.
Provide best practice advice to customers.
Migration project which involved DQM, Data Transformation, Validation, Reconciliation etc.
Worked extensively on Smart Data Access (SDA) POC which included following test cases
Creating Batch Dataflow.
Creating Realtime Replication.
Creating Realtime Sources with Transformations.
Creating Source with History Preserving.
Giving an overview of AFM Editor, Palette, Virtual Tables, Scripting and Modeling with Virtual tables.
Developing HANA Artifacts (models) like Attribute View, Analytic View, Calculation View (graphical/scripted), Analytic Privileges, star join (fact view) and database procedure in the SAP HANA Studio platform.
Experience with database procedures and script based calculation views using HANA programming languages like SQL Script and CE functions or native SQL.
Worked on BOBJ tools like IDT, Webi, Lumira, Design Studio etc.
John Deere. Moline, IL (Retail Industry Projects)
June 2014 – Sep 2015
Sr SAP HANA Sr. Consultant [XSODATA, XSJS, BODS, SLT, SAP Native HANA]
Prepared replication blueprint for DB2 to HANA Migration with BODS replication.
Defined real-time XS engine architecture for franchise (dealers) and employees of John Deere.
Designed high level HANA data model for the OLTP solution (XS engine).
Used XS engine and created oDATA services.
Created schema objects (tables, index, functions, sequences, cursor, trigger, stored procedures etc.)
Worked with SQLScript Debugger (Conditional Breakpoints, Watchpoints, Break on Error etc.)
Modeling with Attribute views, Analytical views, Calculation view and scripted Calculation views (using SQL Scripts/CE function Scripts) in SAP HANA for web APIs.
Worked on SAP BODS for DB2-HANA integration and delivered complete e2e real time ETL data migration.
Worked on spatial data and showed how it works with google maps as well as esri maps.
Designed and laid down rules for data fencing and security including user management, roles and privileges.
Set up monitor to analyze which will help to resolve any technical problems.
Used SAP HANA Best practices for using SQLScript as well as for Modeling.
Developed Natural Language Processing facility using HANA search engine to include
Full text Search
Exact Search
Fuzzy Search
Facet Search
Worked on troubleshooting and performance optimization with tools like Explain plan, Visualize plan, Performance Trace etc.
Explored multi-language search support and limitations.
Development, tested and implemented ETL flow in BODS batch jobs for subsequent loads
Migration of application from Legacy Database (DB2) to SAP HANA.
Worked to replicated DB2, ECC tables into SAP HANA using SLT Replication and BODS.
Assisted Sap Basis team for SLT architecture, sizing and installation.
Conducted SLT workshop.
Scheduled initial load and continuous Replication of data into SAP HANA.
Created initial load and continuous Replication of data into SAP HANA.
Configure Monitors and alerts.
Handle Slow Changing Dimension in SLT.
Enowa Inc. Frazer PA (Retail Industry Projects)
Mar 2014 – June 2014
SAP BODS Lead [Implementation of Inventory and Sales Rapid Mart, BOBJ]
Worked as SAP BODS Architect for full life cycle implementation: Design, development, deployment and support in SAP Rapid Marts
Created High level DWH migration strategy and Solution design to upgrade and handling Inventory migration as well as Sales implementation.
Tuned performance for large data files by increasing block size, cache size and implemented performance tuning logic on sources, workflows, and data flows.
Implemented Server groups to use advance performance tuning feature such as parallel data flow, dividing dataflow in to sub dataflow and Degree of Parallelism.
Mapping to the pre-delivered content in the Rapid Marts.
Enhancements& upgrading universe design using IDT, WebI reports, and BO Data Services Jobs.
Monitoring, production support and application maintenance for SAP BO Rapid Marts deployment.
Modified existing crystal reports and created new reports with cross tabs and sub reports based on the client requirements using Crystal Reports 2008.
Designed complex reports based on discussions with user groups and created various objects using built-in functions (like prompt, select, where, and aggregate),
complex report level filters and contexts and complex SQL queries and joins involving case statements.
Scheduled Webi reports and Hyperion reports based on the requirement.
Moved the developed webi, crystal reports and universes between development, QA and production environments using import wizard.
Was involved in training the end users over the newly developed crystal and webi reports.
Experis Inc. Dallas TX (Sales Project)
Oct 2013– Mar 2014
SAP HANA Consultant [POC Projects for Pre-Sales]
Worked with different client like Experis/Genesys Inc /MindExpert/Triade Systems Inc etc
Experience in building HANA prototypes or client solutions.
Experience in making business cases with detail informative documents, power points etc. regarding company’s IT goals and laying down roadmap.
Assisting internal team for choosing the right hardware partners.
Housekeeping which include creating archiving strategy, sizing.
Assisting and recommend internal team to choose right provisioning tool.
Design, development and implementation of SAP BOBJ, including dashboards and KPI reporting.
Coordinate activities with various business and technical leads on other teams such as Basis Admin, CRM, and SAP Financials teams.
Coordinate/delegate technical activities, tasks, milestones and deliverables to assigned project resources or perform activities where necessary.
Implemented SAP HANA Security including User Management, Roles, and Privileges.
Conducting workshop and training to improve SAP HANA knowledge which includes cloud, security, modeling, provisioning tools, reporting and analytics.
POC 1: (Utility Company)
Developed SAP Native HANA and ArcGIS (Geographic Information System)
Created BODS packages to pull data from various sources into SAP HANA.
Created objects in SAP HANA like tables, index, stored procedures etc.
Modeling which includes attribute views, analytical view as well as calculated view.
Configured SMTP, crystal reports servers, webi servers, RAS, Adaptive job servers, CMS servers.
Create Dashboards to display service orders their status and profitability, plan and work schedule, thus improving resource utilization and routing efficiencies while using dynamic maps for incident location and weather conditions.
POC 2: (Consulting Company)
Gathered & analyzed the requirement to replicate the ECC content in HANA using SLT.
Created Technical specifications and standard modeling documents for HANA.
Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
Created Universes on top of HANA calculation views and developed the Webi reports and dashboards using IDT (Information design tool).
Tom’s Shoes, Santa Monica, CA (AFS Projects)
July 2012 – Sep 2013
BI Consultant (Tech Lead) [SAP Native HANA, BOBJ 4.0, BODS 4.0, MSSQL]
Established SAP BO 4.0 – HANA integration and delivered complete end-to-end, real-time sales reporting.
Designed a high-level HANA sales data model for the reporting solution by creating Analytical views, Attribute and the Calculation views as well as Analytic Privileges where ever necessary scripted Calculation view.
Experience in replication scenarios on SAP landscape transformation (SLT) with operational reporting or data mart scenario – HANA Modeling, optimization, partitioning, archiving.
Experience with SAP HANA programming including SQL, SQL Script, and CE Script.
Created Universes on top of HANA calculation views and developed the WEBi reports and dashboards using the Information Design Tool (IDT).
Created Data Integrator mappings to load the data warehouse, involving extensive use of both simple and complex transformations like Key Generator, SQL Query Transform, Table Comparison, Case, Validation, Merge, lookup, etc. in data flows.
Experience with Integrated BOBJ 4.0 and BODS 4.0 with SAP HANA.
Prepared mapping documents capturing all business rules.
Built and supported interfaces from non-SAP to SAP systems and from SAP to non-SAP systems.
BODS DQM was used to clean address.
Developed the security model, naming conventions and established the recommended SAP best practices for developing Universes, reports and dashboards from HANA data sources
Designed WEBi reports and KPI Real Time Dashboard in Dashboard Design for global and regional users
Involved in analysis, design, development, testing, and deployment of the system
Performed unit testing and integration testing.
Delivered zero defect solution for user acceptance testing.
Verizon, Irving, TX (Telecom Project)
Feb 2011 – June 2012
BI Consultant (Tech Lead) [MS SQL 2008 R2, Oracle 11, SSIS]
Worked as Migration lead and managed project deliverable.
Development of logical & physical dimensional models via Erwin using Kimball methodologies.
Developed mappings/sessions/workflows as a part of Data/Object Migration.
Latrobe Specialty Steel Company Inc., Pennsylvania (Retail Projects)
Jan -2008 – Jan 2011
BI Consultant [MS SQL 2008 R2, SAP BODS, BOBJ]
Worked as POC between client and development team.
Analyzed the business logic and developed BO universes, BODS packages and Webi reports to serve the reporting and ETL requirement.
The New Release Inc., Houston (Retail Projects)
Oct 2006 - Nov 2007
BI Consultant [MS SQL 2005 BI, SAP BW]
Worked as MS SQL BI and then SAP BW consultant which was first successful IBM SAP Implementation in mid-market sector (was reported in Huston Chronical newspaper).
Created various MS SQL SSIS routines to push and pull data also build SAP BW objects, BEx queries and reports.
New Century Inc., Houston (Finance Projects)
Mar 2006 - Sep 2006
BI Consultant [MS SQL 2005 BI]
Designed ETL strategies and mapping design
Analyzed metadata from Use Cases to design a Logical Model
Deployed the physical data model on an SQL Server, creating schema objects such as tables, views, indexes, procedures, and triggers
TECHNICAL SKILLS SUMMARY
SAP HANA
Native HANA/ Enterprise HANA/HANA Live, HANA on Amazon AWS, HANA VORA
Programming Languages
T-SQL, PL/SQL, MDX
RDBMS
SAP Hana, Sybase, MSSQL, Oracle, DB2, MS Access, MySQL, PostgreSQL
Design and Development Tools
Visual Source Safe 6.0, Test Director, Visio, Erwin, Toad, PowerDesigner
SAP HANA Data Provisioning
SLT, DXC, BODS, Smart Data Access, SSIS
Reporting Tools
Crystal Reports, BEx, Webi, Report Builder, SSRS, Tableau, Power BI, Tibco