Vesoh M Fabian

Skills: SAP BI BO HANA

**** ********* **.

McKinney, TX. 75071

ac3o82@r.postjobfree.com

240-***-****

Professional Profile:

•8+ years of experience in working with SAP Business Objects Suite and SAP BI/BW, EDW and ETL

•Experience in 2 full life cycle implementations in SAP BO following ASAP methodologies which involves Documentation, Requirement analysis, Blue Printing, Gap Analysis, Realization, Data extraction, Data modeling, Data loading, testing, production Support, End user documentation, Reporting and Go-Live check

•Experience in Installation and Configuration, Creation of repositories and security configurations; Performance tuning and optimization of BI solutions including capacity planning, migration procedures, and usage analysis

•Experience in interacting with Business Users to analyze the business process and requirements and transforming requirements into screens, designing/analyzing database and documenting

•Expertise in business warehouse components - Info Objects, Standard and Custom Info Cubes, DSO\'s, Info packages, DTP\'s and Transformations.

•Worked on BW system, Data Warehousing concepts including data modeling, ETL, Query, Report Design, BW Web Reporting and Open Hub Service

•Worked on various kinds of Performance Tuning techniques such as Aggregates, Rollups, Indexes, partitions, and Info cube compression techniques.

•Experience in Design and Development of Universes using Business Objects Enterprise products namely - Business Objects XI R3/R2, Crystal Reports and Xcelsius

•Worked extensively on Designer, Web Intelligence (Web I), Desktop Intelligence (Desk I), Crystal reports, Xcelsius and Central Management Console (CMC)

•Experience in Integrating Business Objects with SAP BI

•Knowledge of Migration and Upgrades to Business Objects XI 4.0

•Expert in writing complex SQLs for optimized Reports and optimizing existing reports

•Developed various reports using Desktop Intelligence and Web Intelligence using the Universes built

•Experience in implementing Business Objects report management with Finance, Sales and Marketing

•Extensively used calculations, variables, prompts and sorted inputs, drill down, slice and dice, alerts for creating business objects reports

•Provided Technical Assistance/Support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces

•Created the Universe and report check list templates, which are used as check points before moving the migrated objects into QA and Production environments

•Worked closely with the Architects to address the performance issues from the server side

•Generated reports with complex, business views, ad-hoc reports, dashboards, list of values (LOV)along with user acceptance test (UAT)

•Published Crystal Reports on to Business Objects Info view and provided access to the end users

•Expertise in using Import Wizard to migrate reports and universes between different environments like development, testing and production

•Experience in creating users and user groups, restricted access of the users as needed using Central Management Console (CMC). Involved in managing users, groups, folders and published reports

•Experience in Star-Schema Modeling, Snowflake Modeling, Fact, Dimension tables and Dimensional modeling

•Experienced on creating dashboards using Crystal Xcelsius 2008 by importing data files to create the visualization utilizing QAAWS and Live Office.

•Created Executive dashboards for the upper management showing summary metrics for the Key Performance Indicators (KPI\'s)

•Strong planner and organizer with demonstrated ability to develop business solutions that increase efficiency, productivity, and profitability

•Resolved performance issues by writing stored procedures and command objects in crystal reports and performed unit testing, system integration testing, and user acceptance testing at various levels

•Articulate with excellent communication and leadership skills and the ability to develop creative solutions for challenging client needs

•Experience on SAP HANA Enterprise Edition.

•Experience working on OLTP and OLAP data sources.

•Experience on Data modeling on Master Data and Transactional data. Good understanding

•of star Schema and Multidimensional Modeling.

•Experience with SAP HANA Security including User Management, Roles, and Privileges

•Experience with SAP HANA Administration including managing schemas, data model

•objects, Delivery Units, import/export content and Auto documentation.

•Experience with SAP HANA data modeling and creation of Attribute View, Analytic View,

• and Calculation View, Analytic privilege by using HANA Studio.

Experience with SAP HANA programming including SQL, SQL Script(v2).

Experience with creation of SQL Function and Procedure in HANA Studio.

•Experience with SAP HANA Replication Technologies. Triggered based (SLT)

Modules worked-on - SD - Orders, Delivery, Billing and Conditions

•MM - Purchasing, Vendor Evaluation and Inventory management

•FI/CO-General Ledger, AR, AP, Special Ledgers, CCA, CO-PA

•SCM (APO) - Demand Planning, Live-Cache, Supply Network Planning

•SEM - BPS (Business Planning & Simulation) and

•CRM - Campaign Analysis and Service Management, TPM, TCM

Data Warehouse:

•Designed and implemented Star schema, Snowflake schema and Multi-Dimensional modeling

•Designed the overall data warehouse architecture (e.g., ETL process, ODS and Data Marts), technical requirements, technical and data architectures for the data warehouse

•Provided executive level product support for the data warehouse initiatives

•Defined and Directed key business drivers for the IT and data warehouse projects

•Derived project scope that directly support the key business drivers

•Evaluated and Recommended data warehouse technologies (e.g., ETL, DBMS, Data Quality, BI tools)

•Designed the ETL process, including data quality, testing, information access and delivery effort for the data warehouse

•Defined and directed the implementation of security requirements for the data warehouse and supporting applications

•Defined and directed data warehouse meta data capture, access effort and meta data standards for the data warehouse

Business Objects Enterprise Administration:

•Responsible for designing Business Objects Architecture for high availability and failover

•Completed capacity planning for Business Objects to support large number of End-users

•Experience in installing Business Objects XI R2 and Business Objects XI 3.x on multiple windows servers

•Clustered multiple Business Objects servers together for load balancing

•Expert in migrating or upgrading from lower versions of Business Objects to Business Objects XI 3.x

•Configured Business Objects Auditing and configured auditing on all services

•Setup Business Objects Audit reports to monitor system

•Experienced in Business Objects Clustering and performance tuning of Business Objects XI R2/3.x system

•Expert in Business Objects XI R2 & Business Objects 3.x Server configuration

•Expert in setting up User, Groups and Folders and their security

•Experience in full life cycle implementation of Business Objects XI R2 & Business Objects XI 3.x

•Expert in Supervisor module of 6.5.1 and previous versions.

•Expert in designing/maintaining security using Central Management console in XI R2 & 3.x

•Expert in using Custom Access list for user and group management in Business Objects XI 3.x

•In depth knowledge of Business Objects 6.5/ XI/3.x suite architecture.

•Used LDAP security authentication in Business Objects XI R2/3.x

•Applied multiple patches and monthly hot fixes when required

•Created and tested backup and restore for Business Objects Servers

•Set up a Business Test and System Test Environment in one Test Environment using two universe domains but one document domain in Business Objects 6.5

•Support Production Reporting environment on 24/7 basis.

•Resolved BOXI server administration issue within SLA

•Worked as Subject Matter Expert (SME) for Business Objects to use in OLTP/OLAP reporting

•Responsible for designing of Business Objects Architecture and user authentication.

•Worked to Integrate Java front End application with Business Objects using Java SDK

•Link of Web I reports would display on User screen and user can open any report without User ID/PW

•Deployed single sign on between Java Application and Business Objects

Business Objects Universe Design and Web I Reporting

•Proficient in working on Business Objects Reports design on OLTP/OLAP system

•Created Advance Objects in Business Objects Universe Designer for reporting

•Created ALL values prompt and match pattern prompt using wildcards for Web I reporting

•Customized List of Values (LOVs) to have ALL values selection prompt in Web I Reporting

•Arranged LOV data as A-Z index using Cascading LOVs for easy selection on Web I Reports

•Knowledge of Applying Table Mapping Access Restriction using Designer

•Expert in using Index Awareness Primary Key and Foreign Key for faster execution of reports

•Excellent in training users to develop Reports/Universe and use Business Objects XI R2/3.x

•Created security at object level and row level in Business Objects XI R2/3.x Reports

•Extensive development knowledge creating reports and universe for complex calculations and business functions.

•Setting up Alerts and Data Tracking in Business Objects Web Intelligence Reports

•Used variables and functions in Business Objects 6.5.1/XI R2 and XI 3.x

•Expert in providing ad-hoc reporting capability

•Expert in Using Import Wizard for migration of reports from one environment to another

•Expert in resolving Business Objects Loops and Traps

•Created Publication for delivery to the End users

•Created Universe for development of Dashboards to monitor Drug dispensing/Distribution

•Created aliases and contexts to resolve universe problems

•Created universe using aggregate aware so that summary report runs on summarized tables

•Used Data Synchronization to merge data from multiple universe into single block in a document

•Used Combined queries and sub-queries to design Advanced Web I Reports

•Worked with Input and Output calculation context to display required calculations in the block

•Expert in resolving issues identified from Integrity check.

•Created multiple universes on SAP BI 7.0 Info cube and BEx Queries

•Developed many Web I reports over SAP BI 7.0 BEx queries and info cubes

Business Objects SAP BI Integration

•Installed SAP GUI on Business Objects servers for SAP connectivity

•Worked with SAP BI team to Import SAP transport required for SAP integration

•Installed Business Objects SAP integration Kit for SAP BI 7.0.

•Enabled SAP authentication through CMC

•Imported SAP users and Roles

•Configured SIA for Secured Network Communication (SNC) on Business Objects servers

•Configured SNC setting on CMC

•Configured program ID, Gateway Host and Gateway service parameter on registry of BW publisher service

•Worked with BI team to configure RFC destination and Create Business Objects enterprise definition on SAP BI servers

•Used optional variables, mandatory variables, and variables with default values of SAP BI in OLAP universe and Web Intelligence

•Leveraged delegated search for SAP variables in Web Intelligence reports on OLAP universes

•Created OLAP universe with hierarchies and hierarchy node variables

•Used hierarchy and hierarchy node variables in web Intelligence

•Used Key date variable and key date variable dependencies in Web I reports

•Created smart Measures using Database delegated functions

•Used custom calculation in OLAP universes

•Created Xcelsius models with QaaWS and SAP variables

•Created Crystal Reports on SAP R/3 ABAP functions

•Developed Business Objects OLAP universe and prepared reports on SAP Info cube

SAP BI and BEx Queries:

•Knowledge and basic understanding of Info Object, Info Area and Info Cube in SAP BI 7.0

•Knowledge of user defined Hierarchies and Time dependent Hierarchies

•Knowledge of Restricted, Calculated and properties of Key figures

•Knowledge of Use of variables for flexible reporting

Crystal Reports XI R2/2008

•Expert in development of Crystal Reports XI/2008

•Created Grouping and Hierarchy in Crystal Reports

•Created multiple reports over SAP BI 7.0 data

•Defined Grouping and Sections

•Created multiple Sub-reports

•Expert in Optimizing reports based on Report Processing Model

•Created reports on Multiple BEx queries/Info cubes

•Expert in optimizing poor performing Crystal Reports

Xcelsius/QAAWS/ BI Widgets/Live Office

•Expert in creating Executive Dashboards for management

•Expert in requirement gathering, documentation, design and development of Dashboards

•Created multiple connected Xcelsius model

•Used multiple charts, slider, gauges for Xcelsius dashboards

•Created connected Xcelsius models on Universe using QAAWS

•Used Live Office connectivity to created connected Xcelsius dashboards on old canned reports

•Expert in displaying Web Intelligence Report Part and Xcelsius dashboard part in BI widgets

•Used Business Objects XI 3.x widgets to display Web Intelligence report part and Xcelsius dashboard part on Users’ desktop on Windows XP service Pack 2

Management

Team Lead

Good team leading skills and the ability to work well with different levels of people

•Excellent Communication Skills including verbal, Written and presentation skills

•Manage customer expectations with strong facilitation and negotiation skills

•Self-starter and eager to learn new technologies with strong Analytical skills

•Committed to customer service and teamwork

•Expert in managing team in Onsite-Offshore model

•Easily adopt changing technologies to bring more values to the organization

•Create functional specifications, operational definitions and detailed design

•Excellent in using Excel/MS-word and other MS-Office tools

Technical Expertise:

•Databases/ERP: Oracle 7.x, 8.x, 9i/12c, DB2, IDS, SQL Server 2005/2014, MySQL, Teradata, HANA

•Development/DBA Tools: SQL, PL/SQL, SQL Developer 3.0

•Testing Tool: Test Director, Jira 3.6.2 and Mercury Quality Center

•Data Analysis and BI Tools: Business Objects XI R2, Business Objects XI 3.x, Business Objects XI 3.x BI widgets, SAP BI 7.0, Crystal Report XI/2008, Xcelsius Enterprise, QAAWS

•Packages: MS-Office (Excel, Word, PowerPoint, Visio), MS-Access, windows servers, Apache Tomcat, WebSphere,

Educational Background:

•Bachelor of Science in Information Technology

Professional Experience:

Client: FMC Technologies Dallas TX. January 2014 –Present

Role; SAP Business Objects Developer on HANA

Project: Dashboard and Data warehouse project

The business intelligence project involved creating eight executive dashboards and several Web Intelligence Reports for the team using SAP Business Objects BI 4.1 toolset.

These dashboards and reports represent business through various dimensions so that the Executives can better evaluate their clients and business.

• SAP HANA Security including User Management, Roles, and Privileges

•SAP HANA Administration including managing schemas, data model objects, Delivery Units, import/export content and Auto documentation.

• SAP HANA data modeling and creation of Attribute View, Analytic View, and Calculation View, Analytic privilege by using HANA Studio.

• SAP HANA programming including SQL, SQL Script(v2).

•Creation of SQL Function and Procedure in HANA Studio.

SAP HANA Replication Technologies. Triggered based (SLT) and ETL based (BODS 4.0).

•Data extraction using BODS 4.0 from SAP and NON-SAP data sources.

•Data extraction and Data Provisioning (Load and Replication) using SAP LT Replication Server (SLT) from SAP and NON-SAP data sources.

• Data extraction from flat files to HANA.

• Information Composer(IC).

•Create connectivity to HANA from SAP BOBJ 4.1 suits of products.

•Universe creation from Information design tool from HANA DB.

•Experience on connecting various reporting tool to HANA DB using MDX and BICS protocol.

•Analyzing the business requirement and building Universes and creating complex ad-hoc reports

•Performed Business Objects administration tasks including installation, user creation, assigning user rights and permission to Universe, connection, reports and folders.

•Performed migration of universes, reports and user’s security between environments

•Involved with development of data mart in a fast pace Agile Scrum development environment.

•Developed universes with IDT by defining joins, and cardinalities between tables. Addressed cyclic dependencies issue by either applying contexts or creating aliases.

•Created many complex Web Intelligence reports (used multiple data providers, Sub Queries, cross tab, Charts) which includes special field, user variables.

•Analyzed various connectivity options to optimize performance and design process of dashboards including QWAAS and Live office.

•Created dashboards with drill down, dynamic visibility functionalities and user interactive Pop-up windows to show additional details of data.

•Created and documented multiple Web Intelligence reports, dashboards and Universes.

•Created Event based recurring report Schedules that gets triggered based on the ETL loading.

•Conduct Business Objects training and workshops.

Project: SAP Business Objects migration / upgrade from XI 3.1 to BO BI 4.0

•Managed a Business Objects consolidation project. Involved with day to day administration and management of the project.

•Involved with testing and performance tuning several key components of the Business Objects system.

Client: Wells Fargo, Dallas. March 2012 – December2013

Role: SAP Business Objects Consultant

Roles and Responsibilities:

•Work as part of the IT Finance group developing a strategic Business Objects reporting platform.

•Involved with several small and large size Business Objects projects initiatives working in different capacities including developer, administrator and technical co-coordinator.

•Act as a liaison between the core BI Technology team (maintains BOE infrastructure) and end users, coordinating migrations and other technical issues.

•Spec and design complex universes and reports in close coordination with the users.

•Interface with the support team in India for troubleshooting Business Objects technical issues.

•Performed administrative tasks – security, access control, monitoring, report automation and troubleshooting.

•Coordinate development efforts with onshore and offshore development team.

Achievements

•Involved with higher level decision and strategic planning for the environment.

•Implemented the low-level design and specifications of the SAP Business Objects Enterprise platform.

•Participated in change control and provide impact analysis for any change requests.

•Designed and implemented the security model for SAP BO XI Release 3 environment.

•Developed complex OLAP universes and WEBI reports for various Initiatives.

•Designed and demonstrated a dashboard proof of concept using Xcelsius 2008.

Environment: SAP Business Objects product suite version XI R3, SSAS 2005, SSIS 2005, OLAP, Universe Designer, Web Intelligence, Crystal Reports, XCelsius 2008, Informatica, SQL Server 2005

Role: VOLVO CONSTRUCTION EQUIPMENT, Hagerstown, Maryland

Duration: Aug 2010- Feb2012

Role: BO Admin/Developer

Confidential, is a Business Unit of Volvo Group (Headquartered in Gothenburg, Sweden) which mainly concentrates in production of Engines and Transmissions for North and South American Markets. The Hagerstown Facility is one of its kinds, where product innovation and quality improvement, are key for its success. This facility still uses its legacy system called Cullinet for inventory management and accounts settlement. Recently they have planned to switch over to SAP and Business Objects (for Reporting).

Responsibilities:

•Co-ordinate with the Architecture Design team on the New SAP Finance System

•Actively work on design, development, and documentation of reports generated in Web Intelligence and Crystal Reports

•Generated Xcelsius Dashboard reports for Executive management for clear representation of data

•Responsible for manage, deploy and configure the entire infrastructure on Central Management Console (CMC)

•Customize user access levels and give specific user access to different users

•Executed performance testing with 3000 users (including 150 Hagerstown users) to make sure application and Business Objects reporting is working fine if application is used by all counties

•Many optimizations were done in BOXI to support 3000 concurrent users

•Prepared Documentation and provided production support for the created reports

•Created many Ad-Hoc Reports based on user requirements and feedback

Client: National Healthcare Billing Management, Pensacola, FL. Jan 2008 - July 2010

Role: Business Objects Administrator/Developer

National Healthcare Billing Management, is one of the leading National Healthcare Billing Management and Technical Solutions Company in US. Its focus is to develop and deliver quality healthcare technologies to providers and employers who can deliver healthcare to communities. In doing so, it has increased its client base substantially since it was founded in 1995.

Contact this candidate