Parvaiah Kale
Sr. SAP BI/HANA/BODS/BOBJ Consultant
T: 832-***-****
********@*****.***
ROFESSIONAL SUMMARY
Senior SAP BI/HANA/BODS/BO Consultant with 14+ years of relevant Business Intelligence/EDW experience in BI solutions architecture, data migration/conversion/integration and BI Reporting with total of 19+ years of IT experience
Expert skills in utilizing the concepts of various data modelling techniques such as ER Modelling, MDM and ETL for data extraction and development of OLTP and OLAP applications and applied LSA framework and best practices
Experience in creating conceptual models, logical models and physical models for BI applications in EDW and expert skills in architectural, design, development, integration, testing and deployment of BI solutions using various BI tools
Implementation expert in data provisioning from SAP and non-SAP source systems, flat files into SAP HANA and other databases using various ETL tools including SAP BODS and SAP HANA SLT, HANA SDA, HANA Studio
Expert skills in SAP Business Objects Universe design, development using single source, multi-sources to be consumed in Business Intelligence reporting tools including Business Objects Web Intelligence, Design Studio, Dashboards, SAP Lumira, Crystal Reports and Excel reporting with MDX provider for HANA
Has performed various Business Intelligence Roles in the projects such as BI/BO Architect, BO Universe Designer/Developer, SAP Technical Project Manager with more than 14+ years of BI Consultant experience
As a BI lead Architect has prepared BI strategy, roadmaps, architectural designs, development standards, prototype models as proof of concepts, performed evaluation of tools and recommendations with BI/BO/BODS solutions and prepared Blueprint document for solution implementation in SAP ASAP Methodology
Possesses more than 3+ years of specialized HANA development and implementation experience in 3 end-end full-cycle projects with activities of architecture, modelling, data integration/migration from SAP and non-SAP source systems using SAH HANA SLT, BODS (ETL), HANA Studio and development of complex HANA Information Views, HANA performance tuning, HANA Data Security and BI reporting on HANA models using various BO tools
Involved in large migrations/conversions/implementations & BI reporting projects as Senior BI Technical Consultant on projects involving larger teams, complex technology and multi-vendor environments and SAP Landscape environments
Skills in deliverables identification, scoping, acceptance criteria, project planning as a BI Technical Project Manager to manage the deliveries, provide technical guidance to projects teams, prepare development/integration/migration approaches with blueprint documentation with SAP ASAP methodology/Agile(Scrum)/Waterfall) delivery models depending upon the business need in the enterprise transformation projects for BI solutions
Involved in all project SDLC phases starting from due diligence, requirements gathering, analysis and scope identification, performing gap-analysis, design and specifications documentation, SIT & UAT, preparation of cut-over strategy and go-live preparations, user training and support activities including setting up support process
Directed and executed large/medium/small scale projects with multi-vendor, complex technology environments by implementing effective strategies to optimize the resource utilization, elevate efficiency, improve quality
Possess excellent communication & interpersonal skills, very good team player and can work as consultant as with individual responsibilities with in projects teams, comfortable interacting with technical and non-technical audiences, exceptional analytical & problem solving skills with risks and issues management, excellent communicator to project stake holders
Possess domain knowledge relevant to projects worked on in Manufacturing, Banking & Investments, Energy, Retail & Distribution, Health Care, Professional Services( Advisory & Assurance), Media & Federal
Strong techno functional business knowledge in SAP ECC applications i.e. Purchasing, Planning, Sales & Distribution, CRM and Finance and Controlling focusing on SAP BW/BI analytical solutions including modelling, extraction and BI reporting using SAP BI/BO/BODS tools
TECHNICAL SKILLS & AREAS of EXPERTISE
SAP Environment
SAP ECC 6.0, SAP HANA 1.0 (SP9), SAP BOBJ 4.x, SAP BODS 4.x, SAP Lumira 1.18, Design Studio 1.5, SAP BI 7.x, SAP Net Weaver BW, HANA SLT and HANA Studio, MDX, SQLScript, HANA Application Life Cycle Manager, Solution Manager,
Databases
SAP HANA 1.0, MS SQL Server 2005, 2008,2012, Oracle 10g, PL/SQL, ER Modeling, Multi-Dimensional Modeling(MDM), SQScript
ERP Functional
Functional knowledge in SAP R/3 (SD, MM, WM,FI-CO), SAP CRM and SAP SCM focusing on SAP BW/ETL and BI applications development and implementation
Other Tools
MS Visio, MS Project, MS Office Tools, JIRA, HP QC, BMC Remedy, HP Service Center, TOAD, SQL Developer, SQL Navigator, Tableau Reporting
Methodologies
Agile/Scrum/Waterfall, SAP ASAP Methodology, PMP best practices, ITIL, SDLC, UML & OOAD
HANA Development
HANA XS, Fiori, UI5, VDM and HANA Live
Data Migration/HANA Integration
Data Migration / Integration strategy development and implementation in SAP ASAP methodology for projects resulted due to mergers & acquaints, ERP implementations, data warehousing and BI integrated reporting
Assessment of ETL tools and recommendations based data footprint, sources and target systems, designing ETL process for SAP ( ECC/BW) and non-SAP source systems data acquisition into target systems (SAP HANA and non-SAP databases and SAP BW system) using SAP BODS (ETL), HANA Data Provisioning ( SDA - SDI and SDQ), HANA SLT(Real-time – HANA Studio Loader), HANA Import depending on business requirements
Designing of Jobs, Workflows, Data Flows, Transforms, data stores, file formats and data targets using BO Data Services Designer, creation of BODS users, setting up profiles, repository, creation of jobs and admin configurations in CMS/CMC
Data extraction from SAP and non-SAP systems databases ( MS SQL Server, Oracle, DB2), structured & unstructured data, XML and SAP applications data ( ERP data) and SAP BW Data targets and data profiling and cleansing
HANA Modeling/Development/Administration
HANA Schema and Database development, HANA OLTP and OLAP connections creation, development of BO Universe on HANA Column Views and implementation of BI reporting on HANA Information Models
Designing and Modelling of HANA Information Views including Attribute Views, Analytical Views, Calculation Views based on business requirements for BI reporting, Data security with Analytic Privileges, roles and users
Creation of decision tables for what if analysis for simulation reports, designing and development of stored procedures for complex calculation views and HANA development using SQLScript and CE functions
HANA Information Views performance tuning using various table partitions, analysing the SQL query using explain plan and visualization plan for re-writing/adjusting the query, HANA Admin activities such as HANA Security, backup/recovery, HANA LCM and code migrations, users and roles creation
Native HANA Development with XS Engine, OData Services, UI5 and Integration Services and exposure to HANA Live(ERP VDMs) in HANA Live View Browser, Visualization in SAP Lumira and Office Analysis, VDMs integration of Query Views to develop customized calculation views and HANA Side Car implementation
BW/BI/BOBJ Development
Customization & extraction of Logistics Extractors (LO Cockpit, Generic Extraction with in BW System, LIS ), SAP Standard BI Content activation and installation in ECC for identified data sources, replication of data sources in SAP BW, enabling standard BI content for identified info Providers
Creation of custom Info Providers including Info Objects, DSOs, Info Cubes, Multi Providers, Virtual Providers, Composite Providers, creation of transformations, Info Package, DTPs
Perform data loads into data targets, creation of BEx Queries, Performance Tuning using Aggregates, Rollup, Compression and Portioning
Importing Info Providers into SAP HANA and integration with SAP BW for development of composite providers, design and development of BO Universe with BICS connections to BEx Queries and InfoCubes
Creation of Relational and OLAP connections in CMC/CMS and IDT, modelling and development of Universe based on Relational databases, HANA Information Models and publishing the Universe to be consumed in BI tools
Business Objects Reporting/Visualization
BI reporting requirements analysis and preparation of BO architecture for reporting for graphical, tabular, dashboard and visualization reporting depending upon the confirmed business requirements
Designing and development of BI reports in BOBJ tools including Desktop/Web Intelligence, Design Studio, Dashboards Designer, BO Explorer and visualizations in SAP Lumira, Tableau
Business Objects admin activities in CMS/CMC such as user security and access levels setup, folders creation, RFC, OLTP and OLAP connections configuration, reports scheduling, report bursting, code promotion, performance tuning
PROFESSIONAL EXPERIENCE
Dynegy, Houston, TX, USA October 2015 to April 2016
The company generates electricity through their plants and distribute to their customer including households, small industries and commercial entities. The scope of project was to integrate/migrate the data and create BI reports to analyze the power sales & distribution and consumption performance
Environment: SAP HANA 1.0 SP09, SAP SLT, BODS 4.2, BOBI 4.2, MS SQL Server 2012
Role: Sr. SAP BI/HANA/ Consultant
Business requirements gathering, analysis and preparation of data migration/integration approach document with SAP ASAP methodology for all identified BI reports & KPIs, clarify business rules for data migration/transformations, formulate the calculations for business measures, discuss and identify reporting layouts
Define the data migration strategy and provide solution options and recommendations for SAP and non-SAP data migration into SAP HANA, identify the source systems and data sources for schedule/real-time data loads from SAP and non-SAP systems including MS SQL Server, Oracle, SAP ECC(ERP) and Flat Files, setup the SAP HANA SLT and BODS ETL configurations
Define and develop the Data Services designer objects, reusability components, jobs, workflows, data flows, create Data Stores and File Formats with in Data Services
Design and implement the Data Provisioning using HANA SLT, SAP SDA and file import using HANA Studio for data acquisition from sources system into SAP HANA and create HANA Schema and data tables and load/replicate data into target tables and apply the data security and configuration of HANA import server
Create RFC and DB Connections using SM59 and DBACOCKPIT and Configure SLT using LTR/LTRC for data replication from ERP system and MS SQL Server and configure data replication and data loads in HANA Studio and replicate into HANA
Check and monitor the status in SLT server using IUUC_SYNC_MON and MWBMON for relevant tables and transfer status and setup the transformation and filtering conditions in SLT server using IUUC_REPL_CONTENT and LTRS
Perform HANA modeling activities including design and development of HANA Information Models ( Attribute Views, Analytical Views, Calculation Views) and apply data security with Analytic Privileges based business requirements, create stored procedures, complex calculations using SQL Script, calculated columns, input parameters
Apply performance techniques such as table portioning,, Explain Plan and Visualize plan and Query joins review
Expert skills in HANA administration, authorization and roles, user and data security, backup and recovery and tuning
Analyze BI reporting requirements, create BO Universes on HANA information Models in BO IDT and publish them in server and setup security ( creation of data security profiles and apply them to users) for BO and Tableau reporting
Develop BO reports using BO Design Studio, Dashboards, Web Intelligence and SAP Lumira based on business requirements
Coordinate and setup the Go-Live meeting, initiate cut-over activities and go-live activities for release and deployment of developed HANA, BODS and BO components in SAP landscape and coordinate for post deployment activities and support
Nokia Siemens Networks, Schaumberg, IL, USA Feb 2014 to Sept 2015
Design and Develop HANA based Business Intelligence Inventory Management Performance reports for identified KPis and metrics in SCM process as part of Inventory Transparency Management (ITM) project for Inventory and Purchasing operations
Environment: SAP BW/BI 7.x, SAP BOBI 4.x, SAP HANA 1.0 SP7, MS SQL Server 2012, SAP BODS 4.1
Role: Sr. SAP BWBI/HANA/BODS Architect / Developer
Business requirements discussion with business users, understand current SCM Process Purchasing Business Process and Inventory Management, project objectives with respect to identified Business Intelligence reports (KPIs) ( IDOS Report, Risk Report, Simulation Report, Shortages Report)
Identify the data maps (data sources) and source systems, prepare technical specifications (BI/HANA solution architecture, design, modeling, Data flows and ETL) for identified BI reports
Analyze the existing source systems, data sources, legacy data and connection points for data integration/migration to SAP HANA, data security implementation for information Views with respect to business users and data restrictions
Define and evaluate various SAP BI/BW/HANA solutions i.e. 1) BW Info Providers acts as source for reporting, 2) HANA views acts as source for reporting 3) only BW managed schema possible ( HANA acts as database only) for reporting 4) only HANA database and no BW usage for reporting and recommend the best suitable SAP BI/HANA solution
Recommend the best suitable SAP BW/HANA based BI solution as a ‘BW Info Providers’ acts a primary data source for BI reports and HANA acts as secondary data source for BO reports and prepare Blueprint Document with adapted solution
Define and implement Data Provisioning methodology (BW ETL, HANA SLT, BODS) based on the possible scenarios and business requirement to extract/load the data from SAP and non-SAP source systems into SAP HANA database
Create Schema/Tables in HANA for HANA Information Modeling, create templates (CSV/tab delimited files) for Transaction Data (Inventory and Demand) and Master Data (Material, Plant and Buyer) for EMS (Flat Files) and AP3 (MS SQL Server)
Design and develop HANA Information Models ( Attribute Views, Analytical Views, Calculation Views) based on BI reporting requirements and create Decision Tables for Simulation report and discounts calculations based on aging of products
Implement Buyer and Product Hierarchies in Attribute Views for drill down reporting and implement Currency Conversion in HANA using Analytical Views for local currency for Material Inventory visibility for global purchasing group
Create Analytic Privileges for Data Security based on users and data restrictions conditions as per business requirements and develop complex Calculation Views using SQLScript and Stored Procedures
Create calculated columns, restricted columns, input parameters and variables depending on the business requirement and created Analytic views to be integrated with BW Info Provider to create Virtual provider to be combined with Composite Provider to create BEx Query to be used in Query Analyzer
Implement HANA Side Car with SAP Fiori for BI reports performance evaluation based on direct reporting on HANA Virtual Models/HANA XS implementation Vs HANA BI reporting based on HANA Information Views
Provide technical guidance and support to project team in building the SAP BW Info Providers, data sources replication in SAP BW, BEx queries development and technical guidance and troubleshooting support to Business Objects technical team for BO reports development using Web/Desktop intelligence tools i.e. Dashboards, Design Studio, SAP Lumira and Webi
As BI HANA Lead Architect lead the HANA integration/development of approved business requirements, implement, monitor and deliver the project in SAP ASAP methodology with UAT Cut-Over and Go-Live activities and conduct training
Inchcape Plc. Milton Keynes, UK Feb 2013 to Jan 2014
Integrate SAP SD and SAP CRM data with BW on HANA Data Warehouse to create BI/BO reports on HANA models for identified KPIs to measure the sales & after sales performance for working capital, financial summary, EVHC, customer and bonus (Incentives and Payback) reports
Environment: SAP BW/BI 7.x, SAP BOBI 4.x, SAP HANA 1.0 SP5/SP7, SAP Lumira
Role: SAP BWBI/HANA/BO/BODS Architect
Business Requirements gathering, translation of requirements( functional and non-functional) into technical specifications, prepare business Blueprint for HANA migration/development, HANA support strategy and technical design for iPower SAP HANA migration / Implementation for CRM Distribution projects for Inchcape’s Toyota-Belgium business division
Analyze the requirements and translate them into technical specifications, prepare technical architecture, design/modeling including data migration and update blueprint with SAP HANA architecture/modeling, data provisioning and BI reporting
Identify the SAP and non-SAP source systems for ( data sources/extractors) for customers data, Inchcape’s partners data, vehicles sales and after sales data for identified KPIs( EVHC, Customers, Working Capital, Financial Summary, Branch Profitability, Bonuses and incentives, claims from manufactures, after sales survey and performance
Establish the HANA SLT connections to ERP system for SLT configuration to extract the TCURR data for currency conversions for BI Sales and After Sales reports for global users visibility in local currency
Document strategy for Siebel CRM data (customers) migration to SAP CRM data harmonization and validation and extraction and loading into SAP HANA for BI/BO reports implementation and setup the HANA SLAT and configure Import Server in HANA Studio with SAP BODS for data extraction from SAP and non-SAP source systems
Create schema and catalog objects in HANA database for source data for all identified KPIs for reports for data extraction from SAP R/3 (CRM) for customers data, perform file imports from non-SAP systems legacy systems
Design and develop HANA Information Views including Attribute Views, Analytical Views, Calculation Views and create Analytic Privileges for data security, Decision Tables for promotions and what if analysis for sales projections and HANA security based on users and data visibility restrictions, roles and hierarchies in the organization
Create complex calculations in Calculation Views utilizing the SQLScript and Stored Procedures based on business requirements, perform performance tuning on base tables and HANA models using table partition, Explain Plan, Visualization plan and redefine the queries if necessary to improve the response time
Coordinate and ensure OLAP and Relational connections in BO IDT for identified HANA Analytical Views, Calculation Views, and relational connection on HANA tables, BICS connection for BW Cubes, BEx Queries
Setup the BO configuration for BI reporting using validated and approved Business Intelligence Tools i.e. Dashboards, Design Studio and SAP Lumira including Web Intelligence, BO Explorer based on business requirements
Setup and drive the development and implementation activities such as code migration, cut-over activities, release and deployments, Go-Live and Support activities
Implement the project in SAP ASAP Methodology, coordinate and conduct meetings client business and technical teams and project teams for status updates and planning the activities and coordinate with SAP OSS teams for issues resolution
A C Nielsen, Oldsmar, FL, USA Jun 2012 to Jan 2013
Extract the data from local collection centers (MS SQL Servers) into centralized database (Oracle Data Warehousing) to create business intelligence reports to analyze the viewer ship data for decision making in TV ratings assignment
Environment: SAP BOBI 4.x (Dashboards, Design Studio, Web Intelligence), BODS 4.1, Oracle 10g, MS SQL Server 2008
Role: SAP BODS/BOBJ Architect
Gather the business requirements for identified BI Reporting (KPIs and business rules), identify the source systems and data sources, document the data quality requirements for iPad HLS Validator project
Analyze the requirements and translate them into technical specifications and create architecture and design and technical implementation artifacts for data integration and BI/BO reporting for identified reports
Prepare data integration/conversion strategy methodology, define ETL process for data acquisition from source systems into centralized target database system for Business Intelligence reporting
Perform the data modeling activities to create conceptual, logical and physical data models using ER, MDM techniques for EDW & BI solution create database schema and tables using SAP BODS and SAP BOBJ for viewership ratings captured through iPad and TV monitoring devices
Design and implement ETL process ( BODS DI/DQ) for data acquisition from collection centers (Flat Files, MS SQL Servers) to into central database (Oracle), perform data profiling for basic validation, pattern validations and relational integrity checks and cleansing of the data, create jobs, workflows, data flows, transforms, Data Stores, file formats, target tables
Perform BODS ETL admin activities including profile users creation, repository setup and configuration, data services connections in BO CMS, job server configurations, Object Promotion (export/import) and security setup and configuration
Design the BI reporting layouts based on the mockup screens provided by business team, identify report labels, data fields and required charts for interactive reports (Dashboards) in SAP BOBJ tools and IDT, create relational OLAP connection to centralized database, create data foundation, business layer and publish the universe
Configure /fine tune the performance parameters of BO universe by implementing, aliases, contexts and query optimization
Coordinate with SAP BO Admin team and support code deployments and migrated content between environments, report jobs schedules for viewership rating reports and manage objects, reports, universes and database connections within BO and ensure to resolve the issues related to single sign and data security
Coordinate and create, maintain enterprise folder structure, custom access levels for business users and groups and export universe, reports and other contents to repository making it available to end users
Setup new universe connections, access restrictions, checked integrity, cardinalities, optimized query processing time by using key features of Business Objects like aggregate awareness, Indexing within designer and audit the application usage of reports and security through the repository or auditing features
Create Dashboards BO reports using multiple data connections from live office, query as a web service(QAaWS) and BICS and design and configure dynamic visibility and alert features to support complex requirement scenario
Create interactive graphical charts/reports for identified KPIs in Design Studio by using various components charts such as Pie, Line and Column charts with interaction and ad-hoc reports in Desktop/Web Intelligence tools
Integrate the iPad HLS validator system with Nielsen Helpdesk support system using ITIL framework
Motorola Solutions Inc., Schaumburg, IL, USA Feb 2012 to Jun 2012
Create BI reports for identified KPIs to measure the performance on Order Management & Account Receivables (OMAR)
Environment: SAP BI 7.x, BOBI 4.x
Role: SAP BW/BI/BOBJ Consultant
Requirements gathering and analyzing for OMAR (Order Management Accounts Receivable) and Pony Tail data migration for BI reports development and impleemntation
Identify the SAP R/3 data sources / tables from source system for enhancements and replication into SAP BI, enable SAP BI content, create BW info providers, as per the business requirements, perform BW Info Providers modeling, create BW ETL objects and replicate the data (FI-AR, FI-CO) into SAP BW, create BEx Queries and create SAP BOBJ reporting field mappings
Install SAP standard BI content in SAP ECC (extractors/data sources) and in SAP BI (Info Providers, Transformations) for data loading into data targets, Design, create and manage data flows using DTP, transformations and info packages
Monitor Lo-Cockpit activities for procedures like setting up of Update Mode, deleting set up tables, filling up of set up tables and to load data from ECC to BI system for SAP R/3 Logistics (LO) Sales and Distribution data
Create Infor Providers (DSO, Info Cube and Multi Providers) and extracted SD data (Data sources like 2LIS_11_VAHDR, 2LIS_11_VAITM, 2LIS_11_VASCL) of SAP R3 into SAP BW using LO Cockpit (LBWE) extraction, schedule DTP for transaction data loading from PSA to Info Provider using process chains
Design and develop queries in BEx Query Designer and generate reports in BEx Analyzer for tabular and chart reports with drill down and filter capabilities, design and create reporting layouts based on the mockup screens and develop the BI reports using Web Intelligence and Dashboards reports
Deliver the project in Agile/Scrum model and apply SAP ASAP Methodology across all the phases of project and coordinate with the SAP support teams and setup the project in HP Quality Center for post-production support in-line with ITIL
Coordinate and communicate with Customer IT and Business leads to update the ongoing status, work and resolve the risks and issues associate with project releases
PricewaterhouseCoopers (PwC), Tampa, FL, USA Sep 2010 to Feb 2012
Develop/enhance the BI applications and provide the operational support for identified business application for daily operations and analytical applications for strategy and decision-making based on identified KPIs
Environment: SAP R/3 (HCM), BI 4.0 (Dashboards), BODS 4.0, MS Excel
Role: AMS Support Lead / BI Lead Consultant
Review the new application proposals for development/enhancements, and support projects, goals and business objectives and schedule the workshops and meetings to gather and review the requirements
Prepare SAP ASAP Methodology roadmap for BI solution delivery and prepare ITIL framework’s Support Service Strategy, Service Design, Service Transition, Service Operation and Service Improvement Plan documentation and prepare Blueprint document with delivery approach and methodologies for BI applications
Prepare conceptual, logical and physical data models for identified KPIs and analytical reporting for HR Onboarding Process, assurance & advisory, creation of jobs, workflow, dataflow, transforms, target tables creation and mappings, data profiling and cleansing in Data Services Designer with data load into target schema in MS SQL Server
Coordinate with third party vendors involved in the project to get the data files for loading into MS SQL Server database using BODS ( BO IPS) data integration tool and data models creation for BI reporting, create BO universe based on identified data maps and KPIs for BI reporting on performance of support processs
Coordinate with support teams, download the support tickets data in excel format and load the data into MS SQL Server database, create dashboard reports using BO Design Studio to measure the support performance on tickets with SLAs
Coordinate with BO admin team and participate in LCM and CMC/CMS server activities related to code promotion, security setup for reports (authentication, authorization, access levels, rights, folders creation) based on the user groups and user roles assigned to access the reports
Review AMS contract for agreed SLAs, periodically conduct review meetings with customer and support teams to measure the application support performance aligning with ITIL framework, provide technical leadership and continuing support and manage the incident tickets, problem tickets, initiate and manage PTN calls to bring the issues to closure
Track the tickets in HP Service Centre, assign them based on priority levels to appropriate support associates to avoid missing SLAs, assign them to technical resources based on priority levels, conduct team meetings with business stake holders, IT managers and business teams to update the status using PPTs and graphical charts based on BI reports
Identify gaps/weakness in support areas and prepared support service improvement plans, reviewed with customer and implemented the best practices to improve the tickets resolution performance
International Monetary Fund (IMF), Washington D.C. USA Dec 2008 to Jul 2010
The scope of the project was to develop BI Solution/Reports to aid their ICS (International Correspondent System) coordinators to capture the financial healthiness data of IMF member and non-member countries to analyze the data in various dimensions for strategic and tactical decision making at organization level
Environment: BOXI 3.2, Data Services XI 3.2, MS SQL Server 2005
Role: SAP BI/BOBJ/BODS Consultant Lead
Interact with business users, ICS coordinators, Freelancers to gather the business and functional requirements, conduct meetings with IMF internal IT teams to understand the as-is architecture, business processes and analyze the business operations and data maps as part of Requirements collection
Identify the reports for ICS correspondent statistics on proposal submissions, responses, IMF financial lending for developing countries and balances reporting
Prepare technical design