NANYA B.

A

SAP Enterprise Architect BI BOBJ/HANA Solution Design and Development

mailto: acn3gj@r.postjobfree.com

India Cell: +91-987-***-**** : US Cell : +1-972-***-****

Experience Summary

Over 7 years of experience (with a Masters Degree in Computer Science) as SAP Business Intelligence/Business

Objects and Data Services(DS DI) Consultant with "hands on" 5 complete life cycle implementations involving

data modeling, data extractions, report development & 1 complete life cycle implementation of SAP BI migration

from Microsoft to SAP Netweaver HANA platform.

Worked extensively in development, enhancements and support of BW/BI BOBJ SDK Environments. Worked on

multiple projects with end to end solution including Business Requirements, Data Modeling, Data Architecture,

Application Design, Prototyping, ETL Design, Reporting Architecture, Development and Maintenance. Good

Experience on Universes, Xcelsius Dashboards using Business Objects Enterprise.

Proficient and sound knowledge with Planning, Multidimensional data modeling using extended star schema,

Design Implementation, and User Training of SAP Business Intelligence.

Due to exposure to cross cultural and cross functional organizations in both Europe and USA, am collaborative

and adept towards cross cultural/bi lingual organizations/environments.

Deutsch language proficient and have worked in both onshore/offshore model.

Proficient with Microsoft SQL Microsoft SQL Databases SQL queries SQL Table structure and relational

understanding of the structure. Knowledge and interest in business processes and their key data related

requirements for automation.

Development, enhancements and support of BW BO Environments.

Business objects(BO)components creation for performance management, reporting, planning, query and

analysis.

Business Objects(BO) products include supervisor, designer, user module, broadcast agent, info view,

and business objects software development kit, along with others

Worked on both Enterprise mode and Workgroup mode

Worked on Business Intelligence Consumer Services(BICS) Connectivity, creating OLAP connection and

multi dimensional universes over BeX Queries to connect with BOBJ Explorer 4.0/4.1

Worked on Information Design Tool(IDT) and Universe Design Tool(UDT) in BOBJ Suite

Worked on real time data acquisition through Extraction Transformation Loading functionalities of

Business Objects Data Services (BODS) to SAP Netweaver HANA Platform

Reverse Engineering on the BO 4.0 repositories and extracting information as per business specifics.

Worked on BO landscape and architecture for all repositories and applications from Production,

Staging,testing and development instances including architectural standards, environment, coding,

integration standards and third party tools

Make Enhancements, test and work with End Users.

BW Integrated Planning (BW IP) and/or PAK (Planning Application Kit) and recently BPC 10.0

Real time info cubes and DSO Planning modeller (RSPLAN)model/creating Info Provider, Aggregation Level,

Planning Functions, Filters, Planning Sequences Business Explorer Suite and Advance Analysis

Toolsbuild/creating planning queries/BEx queries and creating input ready queries and developing Fox codes

Trigger Based Data Replication used with SAP Landscape Transformation (LT) Replication Server

Extraction Transformation Load (ETL) based Data Replication used with SAP Business Objects Data

Services to specify and load the relevant business data in defined periods of time from an ERP system

into the SAP HANA database.

Extracted Metadata from the source system into the Target SAP HANA system.

Configured on the HANA Studio the import server to pull data into HANA from SAP Business suite

Lead providing recommendations to client’s Basis, DB and Unix team.

Educated IT and business stakeholders on how best to leverage the BPC 10.X and BI 4.X platforms and

maximize business benefits.

Documented BPC and BI solution architectures for various stakeholder groups.

Provided skill set and work effort estimates for solution realization.

Mapped business requirements to the SAP BPC & BI technology; negotiate with the business teams to

maximize and adopt standard functionality.

Provided technical direction and support including prototype development for functionality demos and

discussion with the business units.

Designed, developed and support solutions built on the SAP BPC 10.X and BI 4.X platforms.

Driving architecture & design conversations regarding BPC and BI solutions, and exercise authority and

vision in decision making.

Leading cross functional issue resolution across teams and resources and serve as a liaison amongst IT

and business teams.

Collaborating with infrastructure team, SAP project teams, Compliance, project managers and Business

Analysts, and business leads as necessary.

Contributed to the SAP BPC and BI systems environment stewardship, and evangelize best practices in

the software lifecycle

Service to internal and external customers in the BPC 10.X and BI 4.X ecosystem.

Providing team leadership and mentoring, sharing knowledge and cross train on solution components.

Industry experience include : Utilities/ISU,Banking,Chemical, Gas, Pharmaceuticals and Manufacturing.

Experience in SAP BW3.5, BI 7.0/7.1/7.3/7.4 ECC 6.0,BW IP, Upgrade from 3.5 to BI 7.3/7.4.

ABAP Programming on BI Routines and CMOD,BADI

Expertise in BW Components like Info Objects, Info Sources, Update rules, Transfer rules, InfoCubes,

ODS, PSA, InfoSpokes and Info Packages, Queries, Calculated key figures, restricted key figures,

variables etc.

Worked extensively on CO PA, FI, LO Cockpit and Generic data Extractions.

Expertise in designing SAP BW interface requirements with both R/3 source systems as well as Non R/3

source systems in modeling of Info Cubes, Info sources.

Worked extensively on performance tuning, BW Statistics, Indexes, Data Marts, process chains, Error

handling in subsequent processing, Business content installation, data cleansing in PSA.

Worked on reports using BEx Query Designer, BEx Analyzer and Web Application Designer.

Created and enhanced Data Sources using database views, InfoSets, and function modules. Hands on

ABAP coding on extractions.

Experienced in ABAP programming techniques including Reporting, Dialog Programming, ALE, SAP

Script and user exits.

Excellent technical, business, communication and time management skills.

Efficient and adept working in cross cultural and cross functional organizations

EDUCATION:

Master of Computer Science (BITS)

Technical Expertise

Elements Particulars

Primary Skills SAP Net Weaver Business Intelligence (BI/BW) &

Business Objects Enterprise (BO), SAP HANA

Operating Systems Windows

Languages Advanced Business Application Programming

(ABAP), C, C++ & SQL

Development Tools SAP – BI/BW, BOE, BIA, BO & HANA Studio

Scripts JavaScript

Database Connectivity MSSQL, Oracle

Databases MSSQL, Oracle, DB2

Configuration Tools BAPI, DB Connect, Flat File Interface, UD connect

Domain Knowledge SD, MM, FI, CO PA, SNP APO, NEW GL

ERP SAP (Systems, Applications & Products in Data

Processing)

Legacy Systems Lotus Notes, SM7 (Service Manager)

Documentation Requirement Study, Functional & Technical

Specification Documents

Client / Server Technologies SAP Web Application Server

Foreign Language known English

Client : Heinz :: June 2014 to Till Date

Role : Business Objects Enterprise / BI Solution Developer for SAP HANA Netweaver Platform - P ittsburgh/PA

Focus on Business Intelligence Tools and Processes connecting through BICS with HANA.

This includes experience with BOBJ SDK Suite,BO/BI SDK usage to perform a number of administrative tasks (schedule,

add user, disable user, etc) BO Explorer 4.1, Universe Design,Web Intelligence,Crystal Reports, Business Objects

Enterprise Architecture and server sizing.Exploring Information Spaces. Navigating through an Information Space.Saving

exploration results as a bookmark.Exploring local Excel files. Data analysis features.Sorting facets Data

highlighting.Facet selection and filtering.Adding a second dimension for analysis in charts.

Client: Chemtura Corporation, Connecticut Feb 2013 to May 2014

Role: SAP BI BOBJ/SDK HANA Lead

Scope: SAP BW IP, SAP BI 7.X Migration to HANA, SAP ABAP Coding, Business Objects Enterprise/BI Solution

Developer Kit (SDK).BOBJ/BI SDK to perform a number of administrative tasks (schedule, add user, disable user, etc)

Note:The BOE / BI SDK is only supported in web applications, thus there are no Windows platform used in this project)

Some of the key highlights for Migration from MySQL Server to HANA DB and post migration system health

checks and monitoring are working extensively on below

Responsibility

Business objects(BO)components creation for performance management, reporting, planning, query and

analysis. Business Objects Enterprise / BI Solution Developer Kit (SDK) for JAVA.

Business Objects(BO) products include supervisor, designer, user module, broadcast agent, info view, and

•

business objects software development kit, along with others

Worked on both Enterprise mode and Workgroup mode

•

Worked on Business Intelligence Consumer Services(BICS) Connectivity, creating OLAP connection and multi

•

dimensional universes over BeX Queries to connect with BO Explorer 4.0/4.1

Worked on Information Design Tool(IDT) and Universe Design Tool(UDT) in BOBJ Suite

•

Worked on real time data acquisition through Extraction Transformation Loading functionalities of Business

•

Objects Data Services (BODS) to SAP Netweaver HANA Platform

Reverse Engineering on the BO 4.0 repositories and extracting information as per business specifics.

•

Worked on BO landscape and architecture for all repositories and applications from Production, Staging,testing

•

and development instances including architectural standards, environment, coding, integration standards and

third party tools

Checking SAP Standard reports ZBW_HANA_CHECKLIST for BW 7.x and higher tables and also

•

Running Report SAP_DROP_TMPTABLES and RSAN_UT_RESULT_DROP_RESULTS (interim) to delete all

kind of BW temporary tables

Reports used SDF/HANA_BW_SIZING for full system sizing and communicating with external SAP

Certified HANA Hardware Vendor

Analysis using SAP standard Function Module: /SDF/HANA_TABLE_SIZE for single tables or list of tables

and observing the database statistics from DB02.

Analysis of SAP standard Report SMIGR_BIG_ROW_STORE_TABS (for row store tables)

Extensively worked on Transaction SPUMG and RSBATCH

Prepare to easily bring new SAP Netweaver BW in consistent state and enable HANA migration with

optimized downtime

Prepare to easily bring new SAP NetWeaver BW system (to be created as

copy) in consistent state and enable that it can immediately start to receive

delta loads after migration to HANA

Making complete reload of data from source system obsolete, handling of transfer structure prefix– an

identifier for distinguishing the transfer structures of data sources of different BW source systems.

Enable migration with optimized downtime:

Downtime in SAP NetWeaver BW system taken for system copy

Monitored with Basis Team to create connectivity to HANA Modeler Workbench.

Enhancements and Support of the BW and BO Environments.

Test and work with End Users/Business.

Leader providing recommendations to client’s Basis, DB and Unix team.

Additional requests like Support packs, system refreshes that needed estimation and prior approvals.

Monitor Database and file system free space to avoid issues

Worked extensively with SAP standard table RSMSSPARTMON on the number of partitions happened at

the database level.

Checking the database backup logs and resolve failures

Analyzing SAP, DB and OS logs for technical issues

Monitoring SAP processes to avoid system operations issues

Monitoring standard SAP housekeeping jobs (ST01/SU03/SM51 likewise)

Monitoring SAP system performance

Monitoring Memory and CPU consumption

PSA Cleanup RSAR_PSA_CLEANUP_DIRECTORY in check/repair mode

Monitoring lock entries and updates terminated

Working as a Finance Analyst with Chemtura Finance Team from Business Function.

Working with SAP BW 3.5, SAP BI 7.X experience with BEx reporting end as a front end reporting tool.

Working with Business Objects suite of applications

Working using Microsoft Excel and VBA.

Coordination with the SAP Basis team and Business Users from Finance regarding the assignment of

data authorizations and SAP BI roles.

Solutions design and implementation, including requirements gathering and data acquisition procedures.

Clientele for Atos IT Solutions and Services North America (formerly Siemens IT Solutions and Services)

Dec 2010 – Jan 2013

Client: Federal Home Loan Bank, Seattle, WA

Role: SAP BI BODS_HANA

Scope: SAP BW BI BOBJ HANA Consultant

Responsibilities:

Data Modeling: Info Cube design, Info Source, Info Object maintenance, ODS object, Multi Provider,

Update rules, Transfer rules, Info Packages, Info Package Groups; Key figure and characteristics – BADI

Restricted and Calculated Key figures,CMOD, Virtual key figures.

Extraction: LIS, LO master data and transaction data (Full/Delta), Flat file master and transactional data,

generic extraction, enhancements and strong exposure to CO PA Extraction.

Reporting: Business Explorer Analyzer Variables Calculated key figures, Formulas, Free characteristics,

Filters, Exceptions, Conditions.

Worked on SD, MM, Sales Overview And GAP Analysis Stock Overview and In FI Asset Payable And

Receivable Cubes OFIAR_C03 And OFIAR_C02,0FIAR_C01 and worked ON Queries i.e Overdue Analysis

And Payment History, Day sales outstanding And Account payable

HANA Database for performance tuning; worked extensively in the Data Services Upgrade.

Business objects Data services is ETL tool which was used to extract data from source (ECC) and then

load into HANA.

Monitored with Basis Team to create connectivity to HANA.

Trigger Based Data Replication used with SAP Landscape Transformation (LT) Replication Server

Extraction Transformation Load (ETL) Based Data Replication used with SAP Business Objects Data

Services to specify and load the relevant business data in defined periods of time from an ERP system

into the SAP HANA database

Extracted Metadata from the source system into the Target SAP HANA system.

Configured on the HANA Studio the import server to pull data into HANA from SAP Business suite.

Worked on Information broadcasting and VBA MACRO EXCEL. Sound knowledge in Visual composer.

Published the Reports on the Enterprise Portal Dashboard

Used RRI TO jump into another query to get detailed data

Good knowledge on transportation and authorization.

Trigger Based Data Replication used with SAP Landscape Transformation (LT) Replication Server

Extraction Transformation Load (ETL) based Data Replication used with SAP Business Objects Data

Services to specify and load the relevant business data in defined periods of time from an ERP system

into the SAP HANA database.

Extracted Metadata from the source system into the Target SAP HANA system.

FERC related reports / queries in BW.

Extensive SAP Experience with FI CO (FI AP/FI AR)

SAP ECC FERC process

Executing the FERC process to perform mapping and populate the FERC accounts with the data following

the mapping rules.

Performance Tuning: Rollup, Collapse, Aggregates, Reconstruction, and Partitioning of Info Cubes, Indexes.

Created IDT (Information Design Tool) connection to build WEBI reports on top of BEX Queries through

BICS

Worked with BPC team to load General Ledger Actual Data from BW Info cube (ZNGL_O10) to BPC

system, manipulate and store into Cons cube (/CPMB/ZGIIKTC)

Involved in BW BPC integration for Project system Data loads

Built complex WEBI reports by combining 3 OLAP universes using Merged DimensionsPrepared User

manual/authorization roles and also trained business users about WEBI functionalities.

Exclusively worked on WEBI by using variable calculations, merged dimension, sections, Input Controls,

Rankings, Query filters as well as Table filter functionalities.

Built Cross Table, Column and Stacked Charts according to functional requirement provided by business

users.

Created report filters in the UDT (Universe Design Tool) to improve WEBI report performance. Worked on

Performance tuning of WEBI and BEX reports by using Query Stripping, BI Indexes, BI statistics,

Aggregates, Partitioning of Info cube and also OLAP based Cache.

Extensively worked on the expert routine to load data from Inventory cube for Store Obsolescence report.

Worked extensively on PM, MM and SD modules.

Activated and enhanced standard PM Data Sources and also Data Modeling in BW system.

Worked on Material Classification Data source configuration and connected as the attributes of material

Info object.

Extensively worked on SAP BW functionality like LO Extraction, update routines as well as developed

custom BW cubes and queries for specific user requirements that could not be met by using Standard

Business Content.Worked on extractions from heterogeneous Source System including SAP and non

SAP, Developing SAP BW Objects, applying extended Star Schema modeling principles in Data Design,

used expert knowledge of data warehousing concepts,

InfoCube data design and reporting

Designed Sales MultiCube over the Sales order, Delivery and Billing cubes to provide visibility of data

across the sales cycle in the same query

Activated Standard Business Content and loaded large volumes of production data into InfoCubes

pertaining to SD & MM.

Configured and activated SAP BW Adapter in CRM to extract CRM related objects into BW.

Extended Activity DataSource (0CRM_SALES_ACT_1) in CRM to add custom fields like owner Id and

buyer contact fields

Created custom Master DataSources using tables, views, domains, ABAP query and set up Delta for

custom fields.

Extensively worked on reporting using BEx Analyzer, created calculated and restricted key figures,

variables, exceptions, conditions, jump queries and Excel properties to meet client requirements.

Implemented BW Web reportingand well versed with Web Publisher Wizard to publish views on the web.

Developed Documentation on Business Explorer and Reporting for the End User.

Involved in translating business process into business and technical requirements.

Created Generic extractors/Cubes/ODS/objects in BI.

Involved in creating Data Sources, Info sources, and Transformation.

Extensively worked on extracting the data from SAP R/3 and Flat Files to SAP BI.

Extracted data from different modules in SAP R/3 like FI/CO, CO PA and SD.

Involved in activating various Business Content objects for extracting Master Data and Transactional Data

from SAP R/3 into SAP BI.

Extensive work done on Process Chains as well as performance enhancing Aggregate tables and system

settings and parameters to speed up loading as well as reading of data.

Enhanced existing master data and transactional data extractors.

Worked extensively with loading Transactional data.

Created Multi providers by defining to utilize the existing data of the Basic Cubes and enhance reporting

flexibilities.

Worked on Restricted Key Figures, RRI Calculated Key Figures, Exceptions, Conditions, Variables and

Filters.

The client had Data Services jobs running on MySQL Server and worked on upgrade HANA Database for

performance tuning; worked extensively in the Data Services Upgrade.

Business objects Data services is ETL tool which was used to extract data from source (ECC) and then

load into HANA.

Monitored with Basis Team to create connectivity to HANA.

Trigger Based Data Replication used with SAP Landscape Transformation (LT) Replication Server

Extraction Transformation Load (ETL) Based Data Replication used with SAP Business Objects Data

Services to specify and load the relevant business data in defined periods of time from an ERP system

into the SAP HANA database

Extracted Metadata from the source system into the Target SAP HANA system.

Configured on the HANA Studio the import server to pull data into HANA from SAP Business suite.

Client : Carbo Ceramics Houston Texas

Role:SAP BW BI BOBJ/ HANA Consultant

Responsibilities:

install and configure production and development BI environment

SAP BA&T Edge BI w/ Data Management

3 Rapid Data Marts (Sales, General Ledger, Inventory)

install and configure SAP Data services (ETL)

Install and configure BI Platform

AD authentication

User setup and reporting groupsPortal layout

Design and build up to 4 BI dashboards (Sales Forecasting Effectiveness, Inventory Snapshot, Logistics

Snapshot, Financial Snapshot)

Knowledge transfer to CARBO personnel, including end user training and technical/functional hand off to

CARBO support personnel.

Client : Akzo Nobel NV Netherlands January 2010 to November 2010

Role: SAP BI BOBJ Consultant

Scope: Spend Analysis Implementation

Based in Amsterdam, Netherlands AkzoNobel make and supply a wide range of paints, coatings and specialty

chemicals – proforma 2007 revenue totaled 14.4 bin. In fact, they are the largest global paints and coatings

company. As a major producer of specialty chemicals they supply industries worldwide with quality ingredients

for life’s essentials. AkzoNobel consists of 19 business units which are soon to be rolled out to 21 business

units.

The application areas covered are

SAP R/3 (4.6C, 4.7 and ECC 6.0)

•

Data Services

•

SAP BI 7.0

•

Responsibility

Pertained to implementation of the Business Units of Phase 2 and Phase 3 of the Client. My responsibility

included monitoring the various test data loads from Data Services Side to BW.

Spend Analysis based job profile included

Preparation of Reconciliation Documents w.r.t R/3 and BI Data.

Scheduling of Process Chains on every 5th and 15 the working day of the month.

Optimizing the Load and Recon Process – improve load and recon process until next load. Reducing time

in the process.

Added Sales force Info Object and also coded in the end routine for the NGPS Monthly Open Hubs.

Changed DTP selections for NGPS monthly Open Hubs which are related Brand Territory Category level.

Validated Open Hubs by matching Product Total Prescriptions with initial staging DSO values.

Created a copy of transports to move BEx Queries from Production environment to development.

Created test cases and scenarios to do validation in Development and Quality Environment.

Worked on formula variable to populate namenda baseline end date as a key figure in the BEx report

using customer exit.

Built BEx queries using restricted key figures and new formulas to validate FPC sales force reports based

on Business Transaction ID.

Built and maintained OLAP universes with custom filters and prompts to meet the ad hoc and canned

reporting requirements in Business Objects.

Utilized LCM (Life Cycle Management) tool for promoting/migrating WEBI reports and Universes from

development to production environment.

Worked on Universes to refresh BEx Query structure and also involved changing the pointer at the OS

level.

Worked on the Physician Call and Change WEBI reports to display Baseline End date (which is coming

from BEx query as a key figure) on the heading of each measure in the report.

Added separate tab to the Internal WAS WEBI reports for the FPC Sales Force and also made sure report

is refreshing on open.

Prepared Design Documentation to the DR project as well as FPC sales force project in the Microsoft

Visio.

Coordinated with Basis Team to move Transport Objects from Development to Production system.

Monitored batch job processes after deploying changes into the Production Environment.

Clientele for Accenture Consulting::British Petroleum /UK EDF Energy UK /BP Thistle Program /UBS

Pharmaceuticals March 2008 – Jan 2010

Role: SAP Consultant / Business Reporting

Responsibilities:

Worked with business to scope the project and helped business users create Functional Specs

Enhanced standard extractors to fulfill the Business requirements.

Ledger assignments for FECR Postings (FECG)

FERC extractors delivered with ECC6.0 and related content on the BW side.

BW content related to FERC_D1 and FERC_D2 data sources.

FERC related reports / queries in BW.

Extensive SAP Experience with FI CO (FI AP/FI AR)

SAP ECC FERC process

Identifying the cost objects (e.g., Work Breakdown Structure (WBS) elements, cost centers, orders, cost

elements, and other cost collectors) relevant for FERC calculation.

Identifying a list of FERC indicators to be assigned later to the cost objects.

Identifying the cost elements relevant as part of the SAP FERC calculation.

Establish the mapping relationships between natural SAP G/L accounts and SAP FERC accounts using

FERC indicators and cost element ranges.

Performing the assignment of FERC indicators to SAP ECC cost objects.

Executing the FERC process to perform mapping and populate the FERC accounts with the data following

the mapping rules.

Created data sources using generic and application specific extraction for FI and SD (OTC) modules and

loaded the business content.

Extracted the data using extractor (LO Extraction) 2LIS_12_VCITM (Sales Shipping: Delivery Item),

2LIS_13_VDITM (Billing Document Data: Items), 2LIS_11_VAITM (Sales Order Item Data) to DSO’s and to

the respective Cubes.

Used both initializations with delta update and full update methods depending on the business

requirement

Extensive experience in performance tuning of queries by maintaining Aggregates, Indexes, Info Cube

Partitioning and Info Cube Compression

Extracted data from BW Info Providers using Open Hub Functionality to external systems through flat files and

separate DB tables.

Created process chains for daily data loads, Aggregates Roll up, etc. Created messages in the process

chains for load failures using emails.

Built BEx queries with Restricted Key Figures, Calculated Key Figures and Variables which would be

utilized to build the Business Objects OLAP Universes.

Designed and developed reports on sales and distribution cubes.

Created a BW report on Sales Analysis Enquiries and a report on Daily Bookings and Shipments using

company code.

Configuration:

Handling configuration work which basically involve diagnosing / analyzing the problem or requirement

suggesting a solution and recommending action.

Validating the configuration requests suggesting rework actions. Carrying out Configuration tasks in the

development environment Creating change request and releasing transport requests for moving the

Configuration to the live Server.

Regression testing:

Conducting test as required in the Pre production server before the configuration is planned in the live

server.

Testing may be of configuration, transaction or quality.

Also includes Support pack testing, System Acceptance testing.

Contact this candidate