Leejo John Panicker [pic]

SAP BW Consultant (HANA)

acylhx@r.postjobfree.com

609-***-****

Summary

. Over ELEVEN years of experience in IT industry as SAP Consultant with

over FOUR years of SAP Business Warehousing/Business Objects, including

TWO years in BW HANA.

. Worked on SAP HANA implementation projects with both Native HANA and SAP

BW on HANA Landscapes based on HANA ASAP 8 Methodology.

. Worked on Data Modelling, Data Provisioning, Reporting, Security and

Authorization aspects of SAP HANA 1.0

. Experience working on HANA Enterprise Modelling including Attribute

Views, Analytical Views, Calculation Views, SQL scripting, CE functions,

Analytical Privileges.

. Excellent knowledge on: HANA Optimized Info Cubes, HANA Optimized DSO's,

Transient, Composite, Hybrid Providers, Publishing HANA Model in SAP BW,

Import SAP Net Weaver BW Model to HANA .

. Experience in migrating the Standard DSO and Info Cube to HANA Optimized

DSO and Info Cubes.

. Experience in Importing BW models Info Cube, DSO in HANA as Analytical

view.

. Good understanding and experience in providing security restrictions on

models using Analytic Privileges and assigning to Authorization roles for

different types of users in SAP HANA.

. Experience in Data-Provisioning techniques suing SLT SAP Landscape

Transformation to perform real-time data replication into SAP HANA and

near time data loading into HANA using SAP BODS.

. Experience in Configuring and Consuming SAP HANA models in BI clients

such as Lumira, Predictive Analysis Business Objects Explorer MS Excel.

. Experience in Requirement gathering, Gap analysis, design, development,

testing, documentation, maintenance, trouble shooting and performance

tuning.

. BI Design - Info Cubes design, Info Sources, Info Object maintenance, ODS

Objects, Info sets, Hierarchies, Multi providers, Update rules, Transfer

rules, Info Packages using AWB. Proficient in Data modelling using MDM

and BW extended star schema models.

. Strong experience in reporting with SAP BW info providers such as Info

objects, Cubes, Queries. Expertise in reporting with Cognos 8 tools on

different SAP R/3 functional areas combining data from different R/3

function modules (SD, FICO, MM) in BW.

. Implemented SAP BW core business rules (Security (roles), Calculated Key

figures, Restricted Key figures, Query variables) in Cognos tools.

Integrated Cognos Reporting with BW functional areas for detailed

reporting.

. Configured Cognos Connection (portal) and performed Metadata modelling in

Framework Manager. Created models and published packages with Framework

Manager and combined data from SAP BW and Non SAP BW data sources for

reporting. Exceptional ability to quickly master new concepts and

technologies.

. Currently working in SAP BI 7.3 and knowledge of HANA modelling. Capable

of working in a group as well as independently with excellent

communication skills. Strong production support experience, good at

trouble shooting with quick turnaround in fixing the issues.

BW Skills:

. BEx Worked Extensively in BEx Analyser in building Queries, saving it in

Workbooks (Excel work Sheets). BW Expertise in SAP BW components like

Info Cubes, Multi providers, Info Source, Info Objects, Update Rules and

Transfer Rules, Which Includes Data Modelling.

. Reporting Expertise in front-end Business Warehouse Components like

Queries, Calculated Key figures, restricted key figures, Structures,

Variables, Exceptions, Conditions, RRI, and Jump queries.

. Web Reporting Developed Web reports, Web items, customized Web templates

using Web application designer (WAD) and query designer.

. Performance Tuning - Evaluated statistical performance and suggested

recommendations to basis support for optimization. Improved data load and

query performance by doing compression, aggregates, partitioning.

. Customizations - Data source enhancements, generic extractors, user Exits

and Logistics Cockpit configuration and customization, Data extraction

from flat files for Master data and Transactional Data, update/transfer

rules creation, Business Content Activation, Direct and Flexible update

of Master data.

. Experience in the technical and functional system upgrade from BW 3.1C to

BI 7.0 (NW2004s). Business Area: FI-CO, SD, MM, PP.

. BI operations - Data load management, event processing, experience also

in Scheduling Start Process and Process Chains of Events, Data source

Enhancement, OLTP extraction data, Loading (Full /Delta Up-Load), Remote

Cubes, Data Mart and Open Hub Service, Performance Tuning, Aggregates, BW

Transports.

. ABAP - Reporting, User Exits, Customer modifications. Proven success in

performing all reporting features, OLTP Extraction from SAP R/3 into BW

using different extraction structures. Functional expertise in SD, MM and

FI/CO. In-depth knowledge of reporting flow from R/3 to SAP BW.

Production Support:

. ABAP - Reporting, User Exits, Customer modifications. Specifications for

Documented functional and technical production support and project

enhancements.

. Worked with the project team and multiple end-users to resolve accounting

issues and identify opportunities for business process improvements.

Provided production support in BW reporting.

. Participated in identifying and implementing continuous business process

improvements in planning, month-end closing, and consolidation.

Documented functional and technical specifications for production support

and project enhancements. Participated in change management activities.

. Assisted in ongoing communication to SAP and BW end-users on business

process and systems changes, and issues resolutions.

Education

. Master of Computer Application, Anna University, India.

. Bachelor of Science (Computer Science), Kerala University, India.

Domain Expertise

. Retail Domain - Successfully working on projects for COACH

. Pharma Domain - Successfully completed projects for ALLERGAN

. Manufacturing domain- Successfully completed projects for Schneider

and Stanley Works

. Finance Domain - Successfully completed projects for World Bank

Key Strengths

. Consulted clients from different industries such as Financial

Services, Retail, Pharma and different geographies.

. Performed gap analysis to optimize business process while working as a

Subject Matter Expert as a part of a solutions team.

. Designed business requirements and technical design documents,

provided solution that resulted in cost saving for client.

. Identified and tested SAP business process controls in collaboration

with FI, CO, and MM consultants

Key Software Skills/Tools:

Tools

Programming Languages: ABAP & SQL

ERP : SAP ECC 6.0, ECC 5.0, SAP R/3 4.7

ETL Tools: SAP BW 7.3, Informatica

Data Modelling: HANA Studio

Databases: Oracle 9i/8i, SQL Server and MS-Access.

SAP Functional Areas : FI, SD, MM

Operating System : Microsoft Windows 98/NT/2000/XP/7, Unix

Professional EXPERIENCE:

Working as SAP BW/BO Consultant in COACH, New York from January 2016 to

till date.

Worked as SAP BI Consultant in Allergan, California from January 2015 to

December 2015.

Worked as SAP BI Consultant in MMG, Melbourne from January 2013 to December

2014

Worked as SAP Technical Consultant in Schneider, Bangalore from November

2010 to December 2012

Worked as SAP Technical Consultant in World Bank, Kochi from July 2009 to

October 2010

Worked as SAP Technical Consultant in Stanley Works, Bangalore from August

2006 to June 2010

COACH

January 2016- Till date

Coach is a New York-based luxury fashion company. Coach is known for

accessories and gifts for

women and men, including Handbags, men's bags, women's and men's small

leather goods, footwear,

outerwear, ready-to wear, Watches, travel accessories, scarves, sun wear,

fragrance, jewellery, and other

accessories.

The project involves implementation on SAP BW on HANA. Also there were

requirements for building multiple BOBJ Executive Dashboards and Reports

using the latest BOBJ tool (Design Studio).

SAP BW HANA Consultant - Responsibilities:

. HANA and Business Objects Development done across all the business Areas

for the BI Projects: Developed all Technical Specifications based on

Functional Specifications that outlines required Characteristics,

Measures and Business Rules. The Technical Specification outlined the

overall HANA design to meet and satisfy the Business Reporting

Requirements.

. Developed the following HANA Data Models: Attribute Views for master

data, Analytic Views for Transaction Data and Calculation Views Graphical

and SQL Script to Join/Union the various Attribute and Analytic Views for

report consumption with time dimensions.

. Developed data flows and work flow using BODS. Worked on RDS to implement

ETL Replication. Used Rapid Marts for SAP Road Map. Developed ETL

transformation.

. Setup Table Replication SLT for ECC and 3rd party table's real time into

Hana. Data replication enhancements created for custom fields when

required during replication.

. Using data provisioning methods like SAP SLT for real time data and

Business Object Data Services BODS non sap data Flat file upload and

direct extraction connection DXC to acquire the data into SAP HANA Data

Mart.

. Created Universes on top of HANA calculation views and developed the Web

reports and dashboards using IDT Information design tool.

. Develop SQL scripts and functions for complex reusable scenarios in HANA.

. Consumption of HANA information Models in BW by creating Composite and

Transient Providers.

. Developed multi-data source challenging reports by merging data from

multiple Data Sources using Web Intelligence WEBI.

. Designed Web Reports Using Be Queries BICS Connection.

. Designed developed cross tab reports, reports with sub reports linked

unlinked and charts using Crystal Reports.

. Had created reports using SAP BO Analysis Office 1.3 and 1.4 for

multidimensional ad-hoc analysis of Headcount Analytics data from SAP BW

and HANA in Excel.

. Reports Developed in this Project: Headcount Change in Staffing Level,

Human Capital Management Monitor, Leaving Rate, Percentage Distribution

of Leavers, Vendor spend analysis

. Worked with LCM Life Cycle Management Console to Transport the Objects In

System Landscape Dev, QA and Prod

. Involved in developing and conducting extensive Unit testing, Integration

testing FIT, Regression testing, User Acceptance Testing UAT and

documentation.

. Architecting reporting requirements into technical design and

development. Created Info providers & BEx queries to simulate/validate

results achieved from Design Studio reports. Architected the Re-org of BW

objects to maintain standards.

. Created Info objects, DSO's, and Cubes & Multi providers as per the data

model. Defined several transformations as per the need. Performed clean-

up activities for the pre migration of BW on HANA implementation.

Optimized BW cubes for HANA purpose.

. Performed BW functionality, BEx functionality and BPS testing for post

migration process of HANA. Interacted with the Finance Business Analysts

on a daily basis for their KPI & report requirements. Managed, Configured

and Performed Transports between multiple BW environments.

. Used Real Tech Transport Manager to perform transports. Maintained Z

tables in BW to load Master data. Performed BW Master and transaction

data loads on required basis. Created and scheduled Process chain for

daily Delta loads.

. Troubleshooting data and technical issues related to SAP BW. Managed

Client BW environment to co-ordinate development, testing and transports

to Production.

ALLERGAN

January 2015 - December 2015

Allergan is an American worldwide pharmaceutical company, focusing on

ophthalmic pharmaceuticals, Dermatology, neuroscience and cosmetics.

Allergan manufactures markets and distributes more than 55 drugs in US.

SAP BI /BW HANA Consultant - Responsibilities:

. Involved in Collaborating with Client managers, DBA's, Reporting team,

Business users and other Stake holders to understand SAP HANA, the

existing landscape and identify key business use cases for the Proof of

Concept POC.

. Interacted with Business stake holders in order to understand their

structured and ad-hoc reporting requirements, User stories, business

rules for finance, sales and marketing domains.

. Worked on conducting workshops to go over the new tasks with the system

administrators and SAP Basis Consultants and also created an application

by application migration approach from SAP BW to HANA system.

. Using Import selective Meta data for SAP BODS 4.1 imported Meta data in

the ETL Process prior to on boarding data into sap HANA, created schemas

and data provisioned using SAP LT Replication Server SLT.

. Developed Business Object Data Services BODS4.1 jobs to pull external

data from Flat files and Oracle into HANA database.

. Developed jobs to complete remediation of legacy data, data quality

management, data profiling using both built in and custom functions.

. Worked with various transformations like Query, SQL, Key Generation,

Merge, Case, Map Operation and Table Comparison in Platform and DI

Transforms and extracted data according to the business rules and

Technical Specifications.

. Created master data objects as Attribute views, joined multiple master

data tables depending on the requirement, selected key figures and

attributes to give context to the master data.

. Involved in creation of Analytical views to support multi-dimensional

reporting by joining Fact table data foundation to modelled dimensions

attribute views, selected attributes and measures.

. Created Calculation views using data base tables, attribute views and

analytic views, in order to address complex business requirements created

SQL Script based Calculation views.

. Involved in creation of Calculated attributes, measures, Restricted

measures, Calculated columns, filters, hierarchies, variables, input

parameters to satisfy reporting requirements using SAP HANA IMCE STUDIO

. Used Information Design Tool IDT to create connections to SAP HANA

databases, Create data foundations and also created Business layer and

publish these connections and layers to Repository.

. Created Dashboard for Supply chain and Inventory executive dashboards

using Design Studio.

. Extensive working experience with different components of Designer Studio

like Charts, Selectors, Text, Maps and Containers.

. Created reports by connecting to IMCE from SAP Lumira, SAP Business

Objects Explorer BEx and MS Excel through ODBO/MDX for multi-dimensional

reporting.

. Accessed HANA data as Pivot tables in Microsoft Excel through via MDX

provider.

. Enabled Business Objects Explorer to search data present in HANA.

. Used Information Design Tool to create Relational Connection, Data

Foundation and Business Layer and accessed the data in HANA through BOBJ

Crystal Reports, BOBJ Dashboard Design, BOBJ Web Intelligence Webi, BO

Analysis.

MMG

January 2013 - December,2014

MMG Ltd is a mid-tier global Resources Company which explores, develops and

mines base metal deposits around the world and head quartered in Melbourne.

SAP BI Consultant - Responsibilities:

. Interacted with Business stake holders to know their business needs and

effectively develop and modify Universes and Reports.

. Defined row level security at universe level as per user entitlements,

this enabled IT to create one report and make it available to global

users based on their rights.

. Integrated SAP BW with Business Objects and extracted data from SAP Data

sources.

. Provide reporting solutions using 2 OLAP Universes using BOE XI 3.1 -

Universe Designer on top of SAP BEx queries, enabled OLE DB for OLAP and

Info Cubes / Multi Providers, created/modified classes, objects,

dimensions, measures and details.

. The development of a total of 6 reports using Web Intelligence, according

to functional specification and write the technical specification for

each development.

. Provide complex reports solutions in Web Intelligence using advanced

functionality like report level prompts, scope of analysis and ranking

data source from DB2.

. Architect and developed a Campaign Marketing Dashboard that measures

leads and contacts for different marketing channels. Implemented end to

end solution, starting from the Universe, to the Web Intelligence dataset

layer, to the Xcelsius Dashboard.

. Follow the company procedures to migrate from the development environment

to QA quality assurance all the universes and reports until the

production server.

. Provide training to the final users about the correct use of the new

business Intelligence elements.

. Involved in Realization, Final Preparation, Go-Live and Post

Implementation, developed production support plan and resolved production

support issues.

. Worked with SAP BI and BOBJ Business users, Project managers and

architects in requirement gathering, analysis and creation of best

practice architecture.

. Enabled Single Sign-On SSO feature, imported SAP BI roles into Business

Objects, enabled automatic imports of SAP BI users, managed users and

groups in Central Management Console CMC.

. Worked with Business Users on design changes and deployed Business

Objects Rapid Marts, sourced data from SAP, Non-SAP and flat-file data

sources.

. Created 5 Universes using Universe Designer, worked with tables, fields

and joins, involved in resolving loops by creating aliases and contexts

using SAP BEx queries.

. Involved in data extraction from SAP R/3 system, Cognos and Non-SAP

systems and scheduled Full Loads / Delta Loads using Process Chains.

. Created Dashboards and Scorecards integrating reports using Business

Objects dashboard manager.

. Worked with SAP BASIS team in regards to moving Transport Requests and

worked with SAP SECURITY team in providing authorizations for Users by

assigning specific Roles.

. Worked with SAP Basis and BI teams and involved in upgrading the SAP BI

support package to SP21, installed Business Objects Enterprise XI 3.1

Integration for SAP Solutions Fix Pack 1.x.

. Involved in developing and conducting extensive Unit testing, Integration

testing FIT, Regression testing, User Acceptance Testing UAT and

documentation.

. Worked with Network Administrators and setup .Net framework on VMware

with Windows 2003/2008 Server, creation of SQL server 2008 databases,

ODBC connections and Java Run-time Environment for Business Objects

installation.

Schneider Electric Systems

November 2010 - December 2012

Schneider Electric has transformed itself into the global specialist in

energy management, moved into electricity and automation management.

Schneider Electric has become today the solution provider that will make

the most of your energy.

SAP Technical Consultant - Responsibilities:

. Providing application support for SAP ECC 6.0(SD, MM, PM, PP, FI & CO)

. Defining requirements and converting functional specifications into

technical requirements

. Assisting SD, PP,PM, FI-COPA consultants on application issues

. Performance tuning and quality control of developed objects as per the

defined guidelines

. Issue and Resource management

. Outbound Interface for feeding Finance data to PI System,

Outbound/Inbound interface for Vendor Account Reconciliation.

. Managing release cycles, categorizing issues, designing and defining

support strategy and documentation templates, designing and defining

naming conventions, quality control and development guidelines.

. Designing, Defining and Validating the mechanism for transporting objects

from Development into Quality and Production environments

. Designing, Developing and Enhancing Interfaces, Reports, Smart forms,

BAPIs, IDOCS, Modules Pool, BADIs, User Exits

. Analysis of change requests, Review of functional specification and code,

mentoring individual team members.

WORLD BANK

July 2009- October 2010

The World Bank is a United Nations international financial institution that

provides loans to developing countries for capital programs. The World Bank

is a component of the World Bank Group, and a member of the United Nations

Development Group.

SAP Technical Consultant - Responsibilities:

CFP is designed to provide concessional and grant financing for World Bank

in support of country and global environment efforts. The CFP application

consists of certain custom developed modules which are integrated with SAP

FI module.

Responsibilities involved understanding business requirements from

functional consultants and/or business users, converting business

requirements from functional specifications into technical specifications,

testing programs developed by ABAP team members. I was also responsible for

designing and developing the customized module pool programs and ALV

reports, for the custom module related to FI that deals with Installments,

Receipts allocations, commitment and Disbursement of funds.

Stanley Works

August 2006- June 2010

The Stanley Works, is a Fortune500 American manufacturer of

industrial tools and marketer of tools, hardware and specialty hardware

products for home improvement, consumer, industrial and professional use.

Stanley is a global manufacturer, with production facilities in 17 U.S.

states and 14 foreign countries, and is one of the world leaders in hand

tools.

SAP Technical Consultant - Responsibilities:

This project is an implementation project which includes writing technical

specification (TS) for the respective functional specification (FS),

development of object with respect to TS, providing Unit Test Cases (UTC).

As a development consultant, I am responsible for developing and

maintaining Enhancements, Conversions, Forms, Reports, User Exits, and

BADI's and interfaces in SD, PP, MM, WM, QM, FICO modules. My

responsibilities also include, understanding business requirements from

functional consultants and/or business users, converting business

requirements from functional specifications into technical specifications,

testing programs developed by ABAP team members. Performance Tuning and

optimization of code, Code Inspector and Extended program check are also

done as part of development.[pic]

Contact this candidate