SAP Consultant

Sunhith Dinnae

(Senior Sap Consultant)

Email: *********@*******.***

Contact: 469-***-****

Summary:

. 7 years of experience in Business Intelligenc

(BI/BO/DS/Lumira/Designer Studio) enterprise solutions that include

Business Objects architecture, software deployment, infrastructure

maintenance, business objects and system administration, BOE Security,

Universe/ Report/Dashboard development, documentation, Production

Support and user training.

. Experience in Analysis, Design, Development and Implementation of Data

Warehousing and other applications using Object Oriented Analysis,

Design and Methodologies serving various business areas that includes

Pharmaceutical, Financial, Insurance and Telecom domains.

. Strong Knowledge in all phases of Software Development Life Cycle

(SDLC) to support various Business Objects Enterprise (BOE)

Applications.

. Experience in Installation, Configuration and Administration of

Business Objects versions 6.5/XIR2/3.1/4.0/4.1 on Windows and Unix

Machines in a multi-tier environment on a 12-node cluster and applied

latest Service Pack and Fix Pack patches.

. Installed and Configured SAP tools like SAP Integration Kit and Life

Cycle Manager and applied Patches.

. Successfully configured third party authentications like Windows

Active Directory, LDAP and Windows NT.

. Expertise in Designing and Implementing of Security Model for BOE.

Successful in implementing the three-level security in Business

Objects (User Level, Object Level and Data Level Security) and

maintained 8000 users by creating multiple Custom Access Levels.

. Expertise in designing and deploying Universes, Business Views, Web I

Reports, Full Client and Crystal Reports (8, 9, 10, XIR2, 2008).

. Periodically backed up the entire environment.

. Databases: 7 years of solid database experience in Oracle 11g/10g/9i,

DB2 8.0/7.0/6.0, MS SQL Server 2000/7.0, (database triggers,

materialized views, In-line views, Packages, stored procedures,

functions, and database constraints), SQL Loader, SQL*Plus, PL/SQL and

oracle DBMS Packages, oracle supplied utilities, Developer 2000 (Forms

6i/5.0, Reports 3.0/2.5), TOAD, Rapid SQL.

. Recognized for good understanding of business needs, excellent

communications, and strong client support. Ability to effectively

perform multiple tasks in multiple projects, meet all target dates,

establish and maintain customer loyalty.

. Participated in project planning sessions with project managers,

business analysts and team members to analyze business requirements

and outlines proposed solutions.

. Good Experience in designing the Road-Map for Infrastructure

implementation that includes Pre-installation prep, Installation

process, server configuration, clustering and security implementation.

Technical Skills

Business Business Objects XI3.1/XI R2/6.5 (Supervisor, Designer,

Intelligence Info view, Business Objects SDK, Xcelsius, Lumira, Voyager,

QaaWS, Web-I SDK, Broadcast Agent, Publisher, Designer,

Supervisor, Auditor, Application Foundation Dashboard

Manager, Report Writer, BO Set Analyzer, Application

Foundation 6.0/2.5 & Dashboard Manager), Crystal Reports

XIR2/2008, Life Cycle Manager, SAP Integration Kit,

Designer Studio

Business Functional Requirements Gathering, User Interviews,

Analysis Business Requirements Gathering, Process Flow Diagrams,

Data Flow Diagrams, Data Analysis, Requirements Analysis,

Design, Data Modeling, Data Architecture, Data Flow, Data

Cleansing, Lumira

Databases Oracle 11g/10g/9i, IBM DB2 UDB 8.0/7.0, MS SQL Server

2005/2000/7.0/6.0, Teradata V2R5/V2R4/V2R3, Sybase

12.x/11.x.

Programming Unix Shell Scripting, Kernel Programming, Perl Programming,

SQL, PL/SQL, SQL Plus, Transact SQL, ANSI SQL, VB, Java, C,

C++

Operating Windows 2008/2003, UNIX, SOLARIS.

Systems

Tools SQL Plus, Toad, Erwin, MS VISIO

Web Servers Apache Web Server, Tomcat, IIS and IBM Web Sphere.

Third Party LDAP, Windows AD, Netegrity Siteminder, BIG IP F5 Load

Tools Balancer

DWH Concepts RDBMS, Data Warehousing, Relational and Data Modelling

Data Business Objects Data Integrator/Data Services, Data

Warehouse/ Federator and Informatica 7.1.

ETL

Education Qualifications

Master of Business Administration M.B.A

(Project Management / Information Technology & Software Tools).

Bachelors of Technology B.TECH

(C.S.E).

PROFESSIONAL EXPERIENCE

Luxottica Retail, Cincinnati, OH

Jan'13 - Jan'15

Role: Senior Business Objects /Data Services Consultant

Responsibilities:

. Actively participated in designing Landscapes of Business Objects

Enterprise(BOE), after thorough analysis and user requirements.

. Analyzed and collected the user requirements/specifications for BOE

Infrastructure enhancement. Documentation of entire BOE XI 3.1 SP2 up-

gradation process.

. Documentation, Up-gradation and Configuration of all the BOE

environments from BOE XI 3.1 SP1 to SP2, FP2.1.

. Enabling Secure Socket Layer (SSL) protocol for all network comm.

between clients and servers of BOE deployment.

. Configured the SNC connectivity for SAP to import all SAP roles to BOE

environment in all BOE environments.

. Responsible for entire Server Management of BOE that includes

configuring of BOE servers (services), Adding/Deleting/Cloning of BOE

Servers (services) and enabling/disabling server tracing.

. Installed and configured Business Objects 3.1 and Crystal reports 2008

on Windows 2008 R2 servers and applied the latest Service Pack and Fix

Pack.

. Installed and configured Apache Webserver, IIS servers and Netegrity

Siteminder.

. Clustered 12 Serves in the production environment to maintain High

-Availability and tested the failover capability.

. Applying LA Fixes (BOE Patch files) provided by SAP Business Objects

on all three environments to fix the identified issues in Voyager, web

Intelligence and other BOE applications.

. Validating all BOE applications after SP2 up-gradation and resolving

the identified issues with various BOE applications.

. Working closely with onsite SAP team in troubleshooting, analyzing and

resolving the issues that are identified in Voyager, web intelligence

and other BOE applications and improve the system stability.

. Designed and implemented the new security model for the BO 3.1

environment.

. Successfully configured the Windows AD authentication and implement

Single-Sign On functionality using Siteminder and Apache web-server.

. Configured the Single Sign On functionality for the open-doc reports

to access BO from third-party applications.

. Migrated the content from XIR2 to 3.1 using Import Wizard.

. Tested and verified that the data match in XIR2 and BO 3.1 and was

involved in Bug-fixing.

. Promoted the tested content form Development to IT, QA and Production

using Life-Cycle Manager.

. Documented the entire Installation and Migration procedure.

. Managed over 4000 users and 50 user groups.

. Created new server groups and added multiple servers to handle the

load and work efficiently.

. Worked with SAP Technical Support to troubleshoot various Deployment

and performance issues.

. Worked with DBA's and System Administrators to back-up the repository

and database and scheduled daily and weekly back-ups for both

environment and repository.

. Member of the Production Support team and provided 24*7 support to

keep the environment up and running and continuously monitor, tune and

upgrade the environment.

. Expertise in deploying OLAP tools, Materialized Views and partitioning

techniques for highly responsive Decision Support Systems.

. Experience in Creating, Testing and Executing Data Integrator jobs

using Data Integrator Designer to transfer data from source to target.

. Created Run Books for Automatic scheduling of Data services jobs

delta loads .

. Prepared operational guide for the Data Services jobs which runs

for history and Delta loads and works as hand help to the technical

support team .

. Created the Intermediate staging area and loaded all the data from the

Legacy.

. Created the data stores for both legacy and ECC for loading and

reading the data.

. Loaded the data into Customer master tables KNA1, KNB1 etc.

. Loaded the data into BW using the ABAP Data flows.

. Has good knowledge on the modeling integration for the BW 7.3 and the

DS 4.1.

. Worked on the source systems of BW 7.3 in which the data services is

new option

. Extracted the data from legacy (Teradata) using data services and

loaded into the BW 7.3 upto the PSA level.

Environment: Business Objects 3.1/XIR2, Tomcat 5.5.20/5.0.27, Xcelcius

2008, Crystal Reports 2008, SAP Integration Kit, Life Cycle Manager,

Windows AD, LDAP, Apache Web Server 2.2, IIS, Netegrity Siteminder, Windows

2008 R2, Windows 2003, F5 Big IP Load Balancer, WebI, Publication Wizard,

Import Wizard, Dashboard Manager, Reporter, Designer, Business Query, BO

SDK, Web Intelligence 2.x/6 and Info View, Windows XP, server 2003, Oracle

7.x/8.x/9/10g, DB2, Teradata, Informatica Power Builder 8.6, Erwin Tool,

SAP Business Objects Data Services 4.1/ 4.0,XI 3.2 SP1(Designer, Repository

Manager, Management Console, Server Manager)

BMC Software, Austin, TX

Feb'11 - Jan'13

Role: Senior Business Objects Consultant

Responsibilities:

. Installation, migration, configuration, maintenance, technical

support and troubleshooting of Business Objects Enterprise platform

and Crystal in a shared environment.

. Leveraged Business Objects tools to make best use of resources and

ensured optimum performance of the tool.

. Defined architecture standards and best practices for BO

implementation and conceived reusable frameworks for BO and get

them developed.

. Designed and implemented Business Object Web clustering

infrastructure design.

. Migrated Business Objects Enterprise XI environments to new

Business Objects XI 3.1 environments that included conversion of

reports. Identified and resolved the production issues arising from

the migration.

. Performed tuning on the Business Objects Enterprise performance and

implemented the load balance on the servers.

. Installed client SDKs and client/server SSO configuration with

Windows AD authentication.

. Created multiple Universes for ad-hoc and canned reports based on

the relational data model that will replace the existing Stored

Procedures as the data sources.

. Solved schema-designing problems by creating aliases, defining

contexts and using features available in Designer to separate

queries on measures or contexts

. Implemented Object and row level security in Universe to

incorporate security at Business level.

. Demonstrated Crystal's strength by enhancing the report performance

the reports mainly by universes to develop Crystal Reports.

. Created Master/Detail Reports, Cross-tabs, Charts and Applied slice-

and-dice, implemented different level of hierarchies for drill

techniques.

. Developed and tested the reports based upon data generated by AA

transaction and customer information systems using Crystal Reports.

. Performed QA on the reports, data to make sure they are on par with

the reporting specifications.

. Involved in conversion of Crystal Reports using stored procedures

and views to the reports using the new universes created.

. Worked with Business Users on regression testing the Enterprise

Reports.

. Optimize and improve the performance the performance of existing

data warehouse and BI applications.

. Conducted user end training to the users to make them understand

the data models, building queries using Universe and use the

Business Objects tool.

Environment: Business Objects 3.1/XIR2, Tomcat 5.5.20/5.0.27, Xcelcius

2008, Crystal Reports 2008, SAP Integration Kit, Life Cycle Manager,

Windows AD, LDAP, Apache Web Server 2.2, IIS, Netegrity Siteminder, Windows

2008 R2, Windows 2003, F5 Big IP Load Balancer, Reporter, Designer,

Business Query, BO SDK, Web Intelligence 2.x/6 and Info View, Windows XP,

server 2003, Oracle 7.x/8.x/9/10g, DB2, Teradata, Informatica Power

Builder 8.6, Erwin Tool

BankOfNewYork-Mellon, Pittsburgh, PA

Dec'07 - Feb'11

Role: Business Objects Administrator

BNYM is a multinational corporation based in New York. The project scope

was to build financial and CRM module data marts for customers by pulling

data from EBS and builds universes and reports to meet their specific needs

Responsibilities:

. Business Objects Enterprise environment setup, server

installations, implementation, upgrades, Configured Report

Servers and made sure the environment is highly available.

. Migrate, upgrade and test the Business Object XIR3

content/environment

. Setup, execute, and test the assigned programs utilizing BO XIR3

WebI and DeskI tools

. Troubleshooting BO XI installation and migration issues.

. Created of Web Applications using Wdeploy and deployed them on

Websphere using Admin Console in all environments.

. Performed Server administrative tasks, including Manage Services -

Starting - Stopping Server Services, Publishing, Migrating,

Importing etc.

. Involved in Installing Clustered Business Objects 6.5SP2 in

Distributive environment.

. Experience in Performing the Server management and User management.

. Migrated the reports from Development to QA to Production.

. Performed all the Administrative Tasks like setting up new Users,

Groups and assigning security at both Folder level and Universe

level.

. Performance tuned Business Objects Data Integrator XI jobs to

ensure optimal performance.

. Extensively used Data Integrator to cleanse and populate target

database.

. Developed more than 25 Full client and thin client (WebI) reports

for all modules and update to version 6. Exporting universe to the

repositories to make resources available to the users.

. Responsible for Universe Designing, Hierarchy Building for Data

Analysis and applied conditions in Business Objects.

. Identified and road mapped the Business Requirements (functional &

technical) with the Business users, which acted as a base for the

project initiation and implementation.

. Created Repository with multiple universe and document domains for

Development and Test Environments and distributed the BO Main key

among the enterprise.

. Set up groups and users for Business Objects deployment. Managed

user profiles using Supervisor and Set object-level security and

row level security restrictions, to restrict sensitive client.

. Business Objects Enterprise environment setup, server

installations, implementation, upgrades, Configured Report

Servers, testing

. Gathered Customer, User and Owner requirements; analyzed and

documented them.

. Extensively used Business Objects Designer to design and maintain

Data warehouse Universe.

. Created Data Flow Diagrams (DFD) to define the data element flow to

the most granular level to translate data requirements to ETL

processing

. Maintaining web crystal reports and SDK controls

. Developed web application interface with WebI SDK, ASP.

. Created Add-Ins and Macros based on the end users requirement using

VBA (BO SDK).

. Prepared business process models; used Visio to create use case

diagrams.

. Determined user/business/functional requirements.

. Worked on evaluation of Metadata Interchange between Modeling Tool

(Erwin 3.5), ETL Tool (Informatica).

. Documented Meta data definitions.

. Customization of Business Objects using Enterprise SDK. Modified

the look and feel of the WebI and integrated the reports with the

intranet portal.

. Designed logical / physical data models and defined primary key,

foreign key using Erwin tool.

. Scheduled and monitored reports using Broadcast Agent Console.

. Deployed the development and QA domains to reduce the server loads

and to increase the performance.

. Trained end users in understanding the reports. Functionalities

such as Slice and Dice, Prompt, Drill mode and Ranking were used

for Multidimensional Formatting

Environment: Business Objects XIR3/XIR2/6.5, Crystal Reports XIR2, Data

Integrator XI, Informatica Power Center 8.1/8.0/7.1.2, Dashboard Manager,

Windows 2003/2000/NT, SQL, Oracle 9i, T-SQL scripts, TOAD], Oracle9i,

PL/SQL, WebI, DESKI, Broadcast Agent, Business Objects Designer, Web

Intelligence, Desktop Intelligence, Windows 2000 Server.

Contact this candidate