Balaji Raj

Business Intelligence SAP Certified -BPC,BW,HANA,S4 SAP BW HANA Tableau

Domains: Finance, COPA, SD, CRM Sales, CRM Services, Inventory, MM and refurbished Life cycle.

Data Warehouse: SAP Business Intelligence/ Warehouse, SAP BPC, SAP HANA, Oracle, Tera data, Mongo DB, Hive, BO

Data Visualization: Tableau, Analysis Office, Business Objects, SAP BeX, Xcelscius

Data Virtualization: Composite DV (Cisco Information Services), Smart Data Access

Implementations: 2 Full Cycle Implementations(BW) and 1 Implementation (SAP BPC 11)

Roles: Solution Architect, Onsite Lead, Team Lead, Team member, Center of Excellence, Trainer, Business Analyst

Professional Summary:

More than 14 years of IT industry experience encompassing a wide range of skill set and roles

Worked in Germany for few years in Dusseldorf and Essen. Worked also in Belgium and France.

Extensive knowledge in Tableau, SAP BI, SAP HANA, Business Objects, Mongo DB, Composite DV, a part of Data lake for Big data, Alteryx, Hadoop.

Worked extensively in SAP BW, BPC,HANA and Tableau modelling.

Worked on defining design and implementation of SAP BPC 11.0 planning models for forecasting. A full cycle implementation of Finance forecasting cycle for various models was done.

Extensive experience with analysis, design, development, and implementation of integration and BI solutions

Proficient in analyzing and translating business requirements to technical requirements and defining architecture

13 + Years of experience in SAP BI tools.

SAP Certified BI Solution Consultant, BPC,HANA 2.0 and S4 HANA. Total 4 certifications from SAP.

Worked in multiple software implementations from concept to completion, played several key roles like BI Solution Architect, Project Lead and developed expertise in the areas of solution architecture, business analysis, business process design and improvement, SAP BI thought leadership, BI Center of Excellence setup and BI education, among others.

As a part of SAP BI Center of Excellence, developed expertise in the areas of bridging the gaps between IT and the business, integrating process re-engineering and continuous improvement into BW projects, creating and maintaining architectural standards, centralizing and formalizing the housing and reuse of code, promoting standard methodologies, tools and education.

Good communication skills, interpersonal skills, self-motivated, quick learner, Excellent team player overseeing fast-paced, time-critical project environments. Recognized as a creative and effective trouble-shooter and problem solver at all times

Experience in working with the teams across the globe.

Worked in various Proposals for new client bids, various Conferences and client presentation were given and we did win few of the client engagements.

Technical Expertise:

Skill Area

Experience (in Years)

Enterprise Package processes(SAP Business Intelligence Implementation Methodology)

13

Tableau

3

SAP BPC 11 and 10 -Embedded Netweaver

3

Mongo DB extraction and architecture

0.6

ETL & Data Quality(ETL & Data Quality - ALL)

10

Manufacturing(Manufacturing - ALL)

4

Reporting, Analytics & Visualization(SAP Business Objects)

2

SAP Functional(SAP CRM)

1

SAP Functional(SAP FICO)

4

SAP HANA and BW on HANA

4

SAP Technology(SAP HANA)

4

SAP Technology(SAP NetWeaver - EP)

13

SAP Technology(SAP Solution Manager)

2

Education:

Bachelors in Information Science & Engineering: Acharya Institute of Technology (Affiliated to VTU Vishweswariah Technological University), India.

Certifications & Achievements:

SAP Certified Business Intelligence Solution Consultant

SAP Certified BPC Consultant

SAP Certified HANA 2.0 Consultant

SAP Certified S4 HANA Implementation scenarios for Architects

Manufacturing Domain Industry expertise (Infosys Integral).

PM Elite Lite - T200 Certification (Infosys Internal)

P200-ESAP-SAP-EHS(Infosys Internal)

SAP HANA Application Consultant training.

Given various training related to SAP BW across locations.

Involved in training Business users for the reports and BW applications.

Trained on SAP BW on HANA

Trained on Predictive analysis tool like Altyrex

Professional Experience:

Ameri100

Client: Epson

Role: Business Intelligence Consultant Apr-2019 – Till date

Location: North America(Long Beach,California)

Responsibilities:

Lead the overall implementation and Architecture of SAP and non -SAP landscape.

The overall system consists of SAP BPC 10.1 Classic and IBP, PowerBi, SAP BW HANA and legacy systems.

Understand the reporting needs and find out the long term and short term solutions for self-service reporting.

Maintenance and development of SAP BPC planning based on the new requirements along with the already implemented planning applications.

Develop dashboards in PowerBi based on the requirements by Business to shift over from excel reporting to dashboard reporting.

Analyze on the architecture to find out the red flags and proper building of KPI’s to be based on front end or backend tools.

Work on authorization concepts and develop POC’s for requirements related to it for PowerBi, Lumira or SAP BW/HANA.

Infosys

Client: Microsoft

Role: Technology Lead Feb 2018 – Apr-2019

Location: North America(San Jose,California and Redmond,Washington)

Responsibilities:

Playing the role of lead and Onsite coordinator.

Full scale implementation for BPC models for forecasting on Embedded BW4HANA in progress.

Build Forecasting models on Embedded BPC 11 NetWeaver.

Green field implementation of 5 models based on BW4HANA and BPC.

Custom and Corporate hierarchies built on data extracted from non-SAP systems.

POC for various types of hierarchies which can be used by various models and hence scalable features.

Since embedded use of FOX formulas to create planning functions and sequences.

Data extraction from CDS views from S/4 HANA Central Finance.

HANA Analytical models build from Revenue and Bookings reporting. Attribute views, analytical and majorly Calculation views were created to create virtual data marts.

Full scale implementation for BPC models for planning on Embedded BW4HANA in progress.

Analysis is going on to use have few BPC models to be taken from BPC to Out of box Predictive models in HANA and then feed them back to BPC.

Bw4Hana implementation in progress for the underlying data marts from various Non-SAP sources.

Co- ordination with Business for requirements and specifications.

Co-ordinate with Tableau COE/Power BI to get the details of newer versions, test few features and use it for the performance issues faced in our project.

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

BODS extractors creation and maintenance for both SAP and Non-SAP data sources.

SLT and ODP frame work used for data extraction .

POC’s on the new technological roadmap to find the right fit of technologies.

Open ODS views with SDA were used for reporting and reconcilation

Worked on few analytical reports from SAP S4 HANA.As a part of this worked on CDS views and the implementation part of it .

Implemented transformations with BADI, ABAP routines with field level and expert routines as well.

Infosys

Client: Cisco

Role: Technology Lead Dec 2015 – Feb 2018

Location: North America (San Jose,California)

Responsibilities:

Implementation of the Tableau dashboards with proper data blend.

Played the role of lead and Onsite coordinator.

Development of Tableau charts for specific KPI’s.

Experience with Tableau for Data Acquisition and data visualizations using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.

Implementation custom design planning by understanding user requirements.

POC for using BPC 10 for planning needs and find out the fit -gap analysis.

Understand the previous planning based on Standard BPC 10.0 and conversion of the same to embedded BPC 11.

Change from Account based to Key figure based model to bring in more flexibility along with keeping the business understanding intact.

Look in for options to derive key planning metrics like Intelligent pricing, Reservations based on BPC or data science.

Started on POC for building embedded BPC planning in S4 HANA Simple finance embedded instead of using data uploads to a different system like BW.

Restricted data for particular users using Row level security and User filters including customizations based on specifications.

Developed Tableau workbooks from multiple data sources using Data Blending and Cross DB joins.

Generated Tableau Dashboard with quick/context/global filters, parameters, calculated fields, interactive views, trends and drill downs along with user level security

Currently working to use Data Prep tool of Tableau for a building a business layer.

Data retrieval, transformation from HANA and Hadoop Data lakes.

HANA Analytical models build from Revenue and Bookings reporting. Attribute views, analytical and majorly Calculation views were created to create virtual data marts.

Process to convert Analytical and attribute views to calculation views were being analyzed/

SLT used to retrieve Supply chain data for reporting on near real time.

Blend data for different systems from to develop data patterns and charts.

Co- ordination with Business for requirements and specifications.

Analyze the data, patterns and statistics to come up with new KPI’s to help business. We used predictive Analysis tool Alteryx for this aspect and some part of HANA Analytics.

Few patterns like Intelligent pricing, Inventory Build and stock were designed using predictive algorithms by the means of tools and raw data analysis.

Heterogeneous data sources were used to get the proper threading and analysis.

Data virtualization on Composite DV for from heterogeneous source systems.

Work on data warehousing design for the increasing complexity of KPI’s and develop data mining options.

Co-ordinate with Tableau COE to get the details of newer versions, test few features and use it for the performance issues faced in our project.

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

Reports based on SAP BW were translated to Tableau and some were based directly from Calculation views from HANA along with Data models where required.

Work on Mongo in the migration phase to design and convert all Oracle structures and data to Mongo.

POC’s on the new technological roadmap to find the right fit of technologies.

Worked on few analytical reports from SAP S4 HANA.

HANA SECURITY & TRANSPORT- Creating Analytic Privileges, Setup data level authorization and privileges at SAP HANA Database, Creating User, Roles & assigning the respective Privileges

Environment: Tableau 9.3,10.2, Tera Data,Oracle 11G,SAP HANA, Hadoop, SAP BW, Alteryx, Business Objects,CIS,S4 HANA Analytics

Infosys

Client: Cisco UOC

Role: Technology Lead Jan 2014 – Dec 2015

Location: India

Responsibilities:

Implementation of the HANA for Supply chain.

Design and build Calculation views in HANA.

Replace the existing oracle objects with HANA objects with modifications to suit HANA implementation methodologies.

Design models in LSA++ architecture to enhance performance of analytical engine of HANA.

Analyze where we need to use BW models and merge data from Tera data without any data persistency.

Use the features such as Mixed scenarios, virtual data marts to report the required amount of data.

Segregate the design to understand the types of objects which needs to be created like attribute views, Analytical views etc.… upon analyzing the data.

Calculation views to be consumed in Tableau for dashboards and co-ordination with Tableau team to get the right mix of complexity.

Created Calculation views by Hana Native Queries as well as Graphic Modelling tool.

BO Webi reports developed for consumption of data.

Develop back-end design, construction and unit testing of the Advanced DSO, Info Cubes, Composite Providers, Multi-Providers, and Info Packages.

Experience with proper data architecture, PSA maintenance, Info Packages, Data Transfer Process (DTP), Delta functionality, Flexible Master data staging, and debugging loads using the Data load Monitor.

Working with SAP BO tools set like SAP Universe designer, Web Intelligence, Analysis For Business Explorer, Xcelsius (Dashboard) and SAP BI tools like Query Designer, BEx Analyzer, BEx Web analyser and Application designer.

SAP Native Hana Data Modeler Developer to utilize HANA Data Modeling for custom Revenue Accounting solution

Extensive and thorough IT know-how regarding web technologies and solutions

HANA SECURITY & TRANSPORT- Creating Analytic Privileges, Setup data level authorization and privileges at SAP HANA Database, Creating User, Roles & assigning the respective Privileges.

Good Experience in Creating Repository, adding Users and Groups, Assigning Password, security, Assigning privileges to Documents and Universes. Designed, implemented and migrated complex Universes and Business objects Reports, Created classes, subclasses, objects, Cardinalities, Contexts, joins, external Strategies, prompts. Extensively used Tableau for specifications such as Master Detail, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.

Environment: SAP HANA SPS 9, Oracle 11g, SAP BW for HANA, Business Objects, Tableau

Infosys

Client: Atlas Copco NV(Atlas Copco Act! Global Template)

Role: Technology Lead Jan 2013 – Jan 2014

Location: Belgium and Germany

Responsibilities:

Business co-ordination for the use of the newly created Global implementation.

To identify the key areas where specific changes could enhance business usability.

Resolve all the escalations with proper business discussion and design the technical changes accordingly.

Identify the glitches in technical solution to find out a permanent solutions to the changing process.

Develop BO reports and Data warehousing layer according to the enhancements.

Onsite co- ordination and follow-up with Offshore team for technical design and development.

Work on WeBi, Xcelsius and Analysis office reports for changes and enhancements.

Experience in creating virtual characteristics, key figures using both user exits and BADI’s and user exit variables

Change or create new models in SAP BW

Environment: SAP BW 7.3 and 7.0, SAP BO

Infosys

Client: Atlas Copco NV (Atlas Copco Act! Support)

Role: Technology Lead June 2012 – Jan 2013

Location: Belgium

Responsibilities:

Team Lead for the entire support project related to BW.

Handle and co-ordinate the overall support activities for the recently developed models

All the tickets for the modules such as Finance, CRM, Sales and Inventory.

Activities included analysis and root causing the solution

Identify long term and short term solutions for problems identified.

Prepare the required transition plans for Project and Support teams.

Perform the month end activities for co –ordination between Finance and BW reporting perspective.

Interact and understand the functional activities in source systems like CRM Services, Sales, Finance to provide root cause and finding the appropriate fix.

Month end activities and verification with teams who would be putting in financial figures and performing monthly closing.

Extracted data from SAP R/3 using LO Cockpit, Generic and Business Content Extractors.

SAP BI ABAP – Created Update rules, Transfer rules, Transformations, Start Routine, End Routine, user exit and function module code for generic data source.

Environment: SAP BW 7.3 and 7.0, SAP BO

Infosys

Client: Atlas Copco NV Implementation

Role: Technology Analyst Sep 2011- June 2012

Location: Belgium

Responsibilities:

Stream lead for CRM Services module implementation in BIBO.

Green field implementation of BI part of CRM services.

Full cycle implementation from scratch with only the table names in hand.

Analyzing the table data and vigorous discussion with functional CRM folks to prepare the blue print and design the whole application in BI for CRM services.

Handled a team to work on the planning and technical objects and reports.

The reports were in WebI, Analysis office and Xcelcius dashboards.

Data sources were analyzed, new custom data sources were designed and flows for our project specific implementation was done.

HR related objects and data sources were also engaged to get the services related information.

Worked extensively on standard and custom defined LIS, LO extractors. Installed relevant SAP business content. Used LO structures for extracting sales order, delivery information. Logistics Cockpit configuration and customization

Environment: SAP BW 7.3 and 7.0, SAP BO

Infosys

Client: Air Liquide GmBh

Role: Technology Analyst Nov 2008- Oct 2011

Location: Gemany and India

Responsibilities:

Played role of an Onsite coordinator and Team member.

Working on Bex Analyzer, WAD, Report Designer and BW 7.0.

Main task involved working on Change requests for specific modules.

Involve with business to understand their requirements and work on the respective Change requests.

Part of the work also related to checking the support incidents and analyzing the root cause to solve the issue.

Worked extensively on standard and custom defined LIS, LO extractors. Installed relevant SAP business content. Used LO structures for extracting sales order, delivery information. Logistics Cockpit configuration and customization

Point of contact for all Upgrade tasks and new module integration also including new company codes in the system etc.

Worked in Germany as the Onsite coordinator to involve in Business discussions and getting the requirements done in system.

Worked extensively with BEx Query Designer, BEx Analyzer and Web Application designer for creating custom and enhanced reports.

Solid experience in Front-end BW queries, workbooks and templates, RRI, Calculated and restricted key figures, Variables, Information Broadcasting and publishing reports in the Portal.

Environment: SAP B

W 7.3 and 7.0, SAP BO

Infosys

Client: Novartis OTC BW ORBIT

Role: Senior Systems Analyst Mar 2008- Nov 2008

Location: India

Responsibilities:

Team member of the Support team

Involved in creation process chains and their objects for keeping the system running since the whole BW system was newly commissioned.

Solve the daily incidents which would come up.

Work towards the stabilizing of the system and maintain dependencies.

Environment: SAP BW 7.3 and 7.0, SAP BO

TCS

Client: Ultimatix (Management Information systems)

Role: Systems Analyst Dec 2004-Jan 2008

Location: India

Responsibilities:

Maintenance of the Billing systems.

Modules such as AR, AP was implemented in PL/SQL and the front ending was based on Java.

Build the database objects and job scheduling to ensure all the reporting structure of Billing are working fine.

Involve in change request of reports and the underlying tables

Environment: Oracle PL/SQL,JS

Contact: 408-***-****

Email: ac9lt3@r.postjobfree.com

Contact this candidate