Executive Summary:

Having ** years and * months of professional experience in Business Intelligence projects across various industries like Banking, Oil/Gas, Retail, Manufacturing, Foods and Beverages.

Good working knowledge on Installation and Configuration of SAP Business Intelligence tools i.e. Business Objects, SAP Lumira Discovery and Designer

Proficient Working Knowledge on BW on HANA modelling components such as Composite providers, open ODS and ADSO etc.

Basic knowledge on ArcGIS tools like Arc GIS desktop and Arc GIS server.

Moderate knowledge on open source reporting tools like Google Analytics, D3.JS and Viz Hub.

Good Knowledge on SAP Vora and SAP Leonardo (IoT) tools.

Expertise Working knowledge on BO BI 4.0 i.e.: IDT (Information Design Tool), UDT (Universe Design Tool), BO Architecture, BO Administration, Upgrade Management Tool and concepts of HANA In-Memory Technology.

Experience with HANA Modeling such as Creation of Attribute Views, Analytical Views and Calculation views and Integration with BO suite of reporting tools.

Well versed with Analytical, Object, Package, System privileges and Roles on Security of HANA.

Extensively worked with variables, filters, conditions, breaks, sorting, drill down, slice and dice, Master/Detail, Cross Tab, Charts and alerts for creating Business Objects WEBI reports

Proficient Working knowledge with large data volumes and managing challenges from a BO reporting standpoint.

Having good working knowledge on integration of SAP BW system with Business Objects.

Extensive working knowledge on Configuration, Administration of Business Objects 4.0/3.X with windows environment.

Well versed with BO CMC Promotion Management activities while promoting jobs from Development to Production system.

Having good understanding of BO Admin activities in Instance Manager, CAL’s, Roles creation and permissions.

Experienced in Developing of Complex WebI Reports using BO XI R3.1/BO BI 4.0/SBOP 4.2

Expertise working knowledge on Data Warehousing projects across SAP BO systems.

Strong working knowledge on Star schema and Snowflake schema modeling.

Experience in creating Queries using the BEx Query designer by defining rows, columns, filters and free characteristics; providing drill down functionality in reporting using Bex.

Worked with core AWS team on Various POC’s in building Visualizations charts with Amazon Quicksight

Proficient working knowledge in RDBMS concepts, SQL, PL/SQL programming and MDX knowledge.

Academic:

M.Sc. Computer Science – Liverpool Hope University, Liverpool, UK, 2011.

B.Tech Information Technology - J.N.T.University, Hyderabad, India, 2006.

12th Std, Sri Chaitanya Junior College, Hyderabad, 2002.

10th Std, Ramakrishna High School, Hyderabad, 2000.

Certifications:

Open SAP Certified in Data Science in Action - Building a Predictive Churn Model

Open SAP Certified in Touch IoT with SAP Leonardo

Open SAP Certified in Spatial Analysis with SAP HANA Platform

Open SAP Certified in SAP Leonardo – An Introduction to Blockchain

Technical Skills:

Hardware/Operating System: Windows XP/2000/NT, UNIX, RHEL 7.2

ETL/Reporting Tools :SAP BO 4l1/4.2, BOXI 3.1/ 3.2

Visualization Tools : SAP Lumira, Tableau, Amazon Quicksight

Programming Languages: C, Java, Python, ABAP, SQL, UNIX Shell Programming

Database: Oracle 12C,SQL Server 2005/2012, Sybase,My SQL, DB2, AWS Redshift, SAP HANA

Work Experience:

Company

Agilisium Consulting, Chennai

End client name : UMG (Universal Music Group)

Project Title : Royalties

Team Size : 6

Role : Specialist – Data Integration (SAP Business Objects, HANA)

Domain : Music Industry

Project Dates : Feb 2017 – till now

Project Description : This project is Migration of on prem servers to AWS Cloud systems to reduce TCO and easier scalability with less maintenance of servers. Moreover, Royalties DW need to be migrated from Oracle to Amazon Redshift to improve the performance bottlenecks. Also, Supported BO reporting platform to global users on helping them on various data issues and product bug issues.

Environment: SAP BO 4.1 SP6, SAP BO 4.2 SP6, Tomcat 7, Oracle 12c, BI Launch Pad, CMC, Web Intelligence, SAP Lumira, Promotion Management Tool, Windows server 2008 R2, Redhat Linux 7.2, Amazon Redshift, SAP HANA, Oracle 11g, Amazon Quicksight, SAP Analytics Cloud.

Monitor business objects cluster servers to make sure system available to global users.

Created and configured Lumira server and presented dashboards to users.

Recycling of servers logging, temp and tomcat folders for month end reporting.

Installed and configured business objects servers in AMAZON cloud instances.

Monitoring, investigating and optimizes data models and reporting performance on SAP HANA

Manages complex and large datasets in a HANA (and BW) environment

Implemented data models with SAP HANA using analytical and calculated views. Advised on the modelling approach and best practices

Replicates and loads data into SAP HANA from different data sources (e.g. SAP Landscape Transformation (SLT), SAP Data Services, or Direct Extractor Connection (DXC)).

Worked on Object Packages, Publications and adhoc reporting using WebI documents.

Supported desktop intelligence users on various issues.

Monitoring the prelim and quarterly data loads and execute bunch of reports to users on successful load of ETL process.

Worked on creating auditing reports for users based on MySQL database.

Enhanced user experience on scheduling reports and enable them for auto restarts in case if the reports are failed due to database or connections unavailability.

Universe applications are migrated from Oracle DB to Amazon Redshift, rebuild the universes and replaced various formulaes like to_char, decode, Initcap and Joins.

Complex reports are developed for various business scenarios.

Responsible for end to end delivery like applications enhancement, business change process.

Project Title : ODS (Operation DataStore)

Team Size : 6

Role : Technical Lead – Business Objects

Domain : Music Industry

Project Dates : July – till now

End client : UMG (Universal Music Group)

Project Description : This project serves as reporting and analytics for the Physical sales supply chain for Europe and US regions.

Environment: SAP BO 4.2 SP4, RHEL 7.2, AMAZON Redshift, Tableau, SQL Server 2012, BI Launch Pad, CMC, Web Intelligence, Promotion Management Tool, AWS, Putty,SAP Analytics Cloud, SAP HANA, Win SCP.

Installed and configure(d business objects 4.2 SP4 standalone servers for physical inventory sales.

Configured LDAP authentication for UAT and PROD servers.

Modeled Business Warehouse modelling components such as Info objects, Data store objects, Multi-providers, Virtual providers, Open hubs.

Created users, groups and security rights for folder, application and universe access.

Created variables, filters, conditions, breaks, sorting, drill down, slice and dice, Master/Detail, Cross Tab, Charts and alerts for creating Business Objects WEBI reports

Recycling of servers logging, temp and tomcat folders for month end reporting.

Resolved various reporting and data issues during the testing phase.

Ability to comprehend complex technical and logical concepts and adapt quickly to change

Built Geo- Maps functionality for Artist Royalty reports on global for quarterly audit report.

created Dashboard and Agenda in Digital boardroom.

created smart discoveries and machine learning scenarios.

Perform build/ development in SAP Analytics cloud as per standards and guidelines.

Created customer workshops and educational sessions around SAP Analytics cloud and data integrity concepts and tool functionality.

Company

PWC(Trowano), Mumbai

Project Title : HMCL

Team Size : 6

Role : SAP BO Principal Consultant

Domain : Manufacturing

Project Dates : Sept 2016 – Jan 2017

End client name : Hero MotoCorp

Project Description : Served as Analytical lead in creating various Reports on BW systems for Sales and financial needs of Hero MotoCorp.

Environment: SAP BO 4.1 SP5, SAP BI 7.5, BI Launch Pad, CMC, Web Intelligence, Dashboards, Promotion Management Tool, BEx Query Designer, RSRT.

Developed WebI (Column, Combined column, Line ) reports and charts with multiple data providers based on BEx Queries via BICS.

Administered data models in SAP HANA, including setting of information validation rules, managing schemas, the importing/exporting and transporting of data models.

Performed SAP HANA modelling and scripting including writing complex stored procedures and HANA views using SQL.

Installed and configured Design studio in client environment and basic user training has been given.

Created interesting visualizations using Webi for Model wise and Country Wise sales.

Worked with merging dimension, calculation contexts and variables in Webi report.

Participated in UAT and helped users in understanding technical aspects of a report.

Developed basic dashboards using SAP Dashboards tool.

Performed validation testing for multiple data providers report using excel VLOOKUP formulaes and various other formulaes.

Project Title : Working Capital (Finance)

Team Size : 14

Role : SAP BO Principal Consultant

Domain : Foods and Beverages

Project Dates : July 2016 to Aug2016

End client name : Pepco Co

Project Description : This project needs COPA financial reports to analyze Actual vs Plan sales information across Pepsi Co Products, Plants and various other sales organizations.

Environment: SAP BO 4.1 SP4, SAP BI 7.4, Universe Designer Tool, BI Launch Pad, CMC, Web Intelligence, SAP Lumira, Design Studio, Promotion Management Tool, BEx Query Designer, RSRT.

Designed FSD’s and TS for the new report development as a part Integration project.

Developed WebI reports with multiple data providers based on BEx Queries via Universe Designer.

Worked with complex variables on presentation of data such as Formatting, Days calculations, Input controls and report filters.

Developed Column, Combined column and pie charts using WebI rich client.

Worked on complex formatting in WebI report charts.

Developed complex dashboard reports using WebI.

Participated in user testing and changes have been incorporated as suggested by user while performing UAT.

Project Title : VELOCITY

Team Size : 8

Role : SAP BO Principal Consultant

Domain : Manufacturing and Retail

Project Dates : Feb 2016 to June 2016

End client name : D’décor Home Decor

Project Description : This Project is upgradation of BO servers and supporting inhouse reporting needs and trained end-uses on SAP Business Objects suite of applications.

Environment: SAP BO 4.1 SP6, SAP BO XI 3.1, SAP BI 7.4, Universe Designer Tool, Web Intelligence, Upgrade Management Tool, Promotion Management Tool, BEx Query Designer, RSRT, Oracle 11g, SQL Server 2012.

Installation and configuration of SAP Business Objects 4.1 SP6 in client environment.

Carried over Post-Installation steps such as sizing by analyzing client business requirements.

Created APS, WebI severs required for the usage of business need.

Migrated objects to BO 4.1 from BO XI 3.1 using UMT as a part of functional upgradation project.

Performed Post Migration Activities to test all objects are transferred correctly to new system.

Promoted jobs from BO Development server to Production server using Promotion Management.

Worked on complex report variables and updated fiscal year across 80 daily and monthly publications.

Worked on several publication issues and raised OSS incidents as required.

Created new BO users and mapped to associated groups using CMC.

Worked on sizing of the Business Objects 4.1 system and created additional APS and altered the command parameters.

Designed FSD’s and TS for the new report development as a part Integration project.

Participated in user testing and changes have been incorporated as suggested by user while performing UAT.

Improved the business objects reports performance at various levels such as Server, Report.

Trained the BO end-users on BO 4.1 system.

Company

Innovatz Solutions, Malaysia

Project Title : COMPASS - DOWNSTREAM

Client : CWB Jakarta.

Team Size : 15

Role : Technical Lead –SAP BO

Domain : Banking

Project Dates : Aug 2014 to Jan 2016

Project Description : This reporting environment needs to be built it from scratch due to their core banking mechanism has been changed from Thaler to Oracle Flex.

Environment: SAP BO XI 3.1,Universe Designer, Web Intelligence, Desktop Intelligence, SQL Server 2012, SSIS, Oracle Flex Cube, DQ (Information Steward).

Involved in preparing the Functional specification documents for reports required by various operations and functional teams across financial and regulatory.

Assisted in defining data standards (elements, definitions, naming conventions, data structure requirements, etc.) master data specification including business rules, definitions and clearly defined ranges of acceptable values for the critical attributes within the domain

Interfaces with Business and Information Technology (IT) team members, taking a support role in the analysis, research, and resolution of master data issues specific to SAP Master Data specification

Participates in the development of data definitions, business rules and processes that support and enforce data quality standards

Ensures Master Data Manager and data owners are kept informed of changes in data standards and processes within their domain

Conducted impact analysis on the existing system and documented.

Designed, developed and tested 45 reports in short period of time, including SIT and UAT preparation.

Prepared the four universes to meet the reporting needs of the business.

Interacted with data mart developers to resolve any data issues during the SIT and UAT.

Followed the Agile approach to pass the reports SIT and UAT.

Maintained and supported existing Business Objects Reports and BO environment

Responsible and accountable for all Business Objects Development deliverables, ensured to support SIT and UAT teams.

Company

Mindteck, Malaysia

Project Title : BOSS Operational Reporting (STRS)

Client : HP Malaysia.

Team Size : 5

Role : Senior SAPBO Consultant

Domain : E-commerce.

Project Dates : Nov 2013 to Aug 2014.

Project Description : This project analyzes sales across various countries, and which needs to be analyzed and create OLTP reporting environment to serve the needs of global users.

Environment: SAP BO XI 3.1, Universe Designer, Web Intelligence, SQL Server 2012, Microsoft SSIS, SSAS & SSRS, Toad, PL/SQL.

Worked with project managers and other corporate resources to code new functionality and enhancements.

Created new mappings and updated old mappings according to changes in Business logic.

Conducted impact analysis on the business requirements.

Involved in Deployment and Administration on SSIS packages with Business Intelligence development studio.

Worked with cross functional Business and IT teams of business analysts, data modelers, solution architects, dba's and project managers during all SDLC phases

Company

J-Soft, UK

Project Title : Data Access

Client : Tibco Software Inc

Team Size : 12

Role : SAP BO Consultant and Spotfire Visualization

Domain : Financial, HR

Project Dates : July 2011 to 25th Oct’13.

Project Description : This project served as intergrading of SAP BW system with their inhouse product Tibco Spotfire and comparative analysis of BO product. Created various business objects reports and Spotfire visualizations for the P&G project.

Environment: SAP BO XI 3.1/4.0, SAP BI 7.0, Tibco Spotfire 6.0, Universe Designer Web Intelligence, CMS, Crystal Reports 2011, Upgrade Management Tool, Business Explorer (Query Designer/ Analyzer/ WAD), SQL Server 2005, Oracle 10g, Toad, PL/SQL.

Roles and responsibilities:

BO Developer:

Created data visualizations on top of SQL Server cubes, SAP BW using in DB and In-Memory functionality.

Worked with in house experts in building Tibco Spotfire visualization to replicate scenarios in Business objects and Performance across reports.

Developed five large universes (UNX) Using Information Design Tool 4.0SP2 with Single & Multi Source data sources.

Converted Universe (UNV) to Universe(UNX) using the IDT Tool 4.0 SP2

Extensively worked with Information designer tool IDT 4.0 using Projects/Shared Projects, Data Foundation, Business Layer and Security Profiles.

BO Administrator

Installation, configuring and clustering of BOXI R3 on Production, Development and Testing Environment.

Setup of web servers, security model and linking to a few existing databases.

Creation of Users/User Groups, categories, Connections and Custom Access Levels BO3.1/4.0.

Taken Backup/Restore and Migrate of Business Objects Content using Import wizard/ UMT.

Administered and monitored the scheduling of reports to end users.

Company

Annik Technologies, India

Project Title : ROS

Client : GAP Inc

Environment : Business Objects XI R2, SAP ECC 5.0 ABAP, LSMW, Conversions, Object oriented

Domain : Retail

Team Size : 6

Role : BO Analyst

Project Dates : Sep 2008 – Aug 2009

Project Description : This project servers as reporting environment for GAP product sales on quarterly, Annuals sales across US regions.

Roles & Responsibilities:

Performed Administration tasks for our Project, Which Included Creating Folders, creating users/ Groups on Central Management Console and giving Appropriate Access levels.

Scheduled the Reports & E-mail them to the necessary departments through CMC/Infoview.

Company

TNS, India

Project Title : AMLANDO

Team Size : 15

Role : Data Analyst

Project Dates : July 2006 – Aug 2008

End client name : Kantar Group

Project Description : This project serves as Creating ALV reports on monthly and quarterly for EPM team.

Roles & Responsibilities:

Extensively worked with Business Users on regression testing the Monthly/Quarterly Reports and convey the errors/issues to Developers and get them fixed on tight deadlines.

Created ALV reports for business requirements.

Contact this candidate