Eric Elewokor
Senior SAP BI, BPC, & SAP HANA Solution Architect
Phone: 937-***-****
acvkn1@r.postjobfree.com
Profile
Over 10 years of IT experience
Certified with BusinessObjects
Experienced in BI 7 upgrade assessment, SOW, sales and presentation to clients
Experience with system architectural design for SAP and legacy system integration with SAP BI
Designed and architected BusinessObjects BI4.1 landscape design for scalability and user growth.
Experience with Enterprise Portal, WAD and Design Studio
Lead installation and upgrade of BOBJ 4.0 to 4.1
Performed BOBJ upgrade from 4.1 to 4.2
Worked with End Users on new BOBJ 4.2 functionalities
Performed migration from BOBJ 3.1 to 4.0 and performed upgrade from BOBJ 4.0 to BI 4.1
Configured complex integration for BO 4.1 in a clustered environment with SAP BI, ECC and SQL EDW
SAP BI 7, BW and SEM BPS. About 6 years of work experience with all aspects of BW / BI planning, designing, and implementation of analytical solutions in diverse industry sectors.
Involved in SAP HANA migration to BW on HANA
Extensive white paper design and use of ASAP methodology for complex BI initiatives to manage scope and budget.
Experience with Rapid Mart Installation and configuration to client need
Extensive work with BOBJ BI4.1 security integration with BW & HANA
Worked with HANA Studio in a HANA Enterprise environment with SLT between ECC and HANA
Extensively worked in the designing of performance optimization strategy for BW Data warehouses
Experienced in G/L Accounting, Accounts Receivables and Accounts Payables, Cost Center Accounting, Internal Orders, Profitability Analysis.
Excellent experience in Extraction (Lo-Cockpit, FI/CO, HCM, SD, CRM, MM, GTS) of Master data and transactional data and Performance tuning.
Experience with Non-SAP source of data extraction using Universal DataConnect (UDConnect)
Experience with Business Objects, Xcelsius Enterprise 2008 with integration with crystal report, LiveOffice and Bex
Insight with best business practices and technology to optimally drive client business processes
Lead and implemented BusinessObjects and BW upgrade (BW 7.3 to 7.4 & BI4.0 to BI4.1) with HANA migration
Extensive experience with SAP Sales tax reporting
Expertise in executing SEM BPS functionality, creating Planning Packages
Extensive experience in system analysis and design methodologies, excellent communication skills and ability to work well in a team and manage multiple assignments at the same time.
Extensive experience in client training in Data Warehousing and Reporting Analytics.\
Experience working with BPC 10.1 with US Elimination.
Experience with SIX SIGMA integration with SAP implementation.
Implemented Two (2) Full life cycle Projects involving SAP BPC . Implemented BPC for Financial Planning for Income Statement and Balance Sheet and Headcount.
Expertise in creating BPC reports, input schedules, Data Manager packages (Including custom SSIS packages), Advanced Script Logic, security setup, Currency conversions, Intercompany Eliminations using Logic and Business rules.
Extensive experience with Datawatch Monarch
Knowledge on migration to SAP BPC 10.1(Netweaver version) from BPC 7.5(Netweaver Version)
Involved in BPS implementation for Sales and Profit planning,, P&L Planning, Balance Sheet Planning and Cost Center Planning
Extensive experience with Banking industry with Reporting for multiple Loan Financing areas like Mortgage, Auto loan, personal and business accrual reporting.
Extensive experience with Financial States Balance sheet, income statement, Profit and Lose, AR and AP aging reporting.
SAP BI/BW Training Highlights
Trained client on Enterprise data warehousing concept, data modeling concepts and performance tuning techniques. This covered BW310, BW330 and BW360; trained technical team on migration process from SAP BW 3.5 to Netweaver 7.0
Also trained client on front-End report design and advanced reporting; trained on BI security based on new BI authorization concept (BW305, BW306 and BW365).
Performed knowledge transfer for technical integration of Netweaver BI and CRM 2007, for BI reporting within CRM UI
Performed multiple training of power/super users on Analysis for office and OLAP, Lumira, Webi, Bex and Design Studio.
Performed knowledge transfer to technical team on HANA
SAP BOBJ & BPC/CPM Highlights
Application sets, Dimensions, Excel Reports, Dynamic Templates, Input Schedules, SSIS data manager packages, Transformation and Conversion files, BPC Functions, Custom menus, BPFs, Macros, etc
Integration of BPC with BusinessObjects and SSO configuration
Configuration of BOBJ Secure Network Communication (SNC) for server side trust
Develop SAP HANA data models using HANA Studio
Modeled HANA security specific to schemas, packages and analytical privileges.
Integrated BusinessObjects 4.1 Analytic solutions including Web Intelligence, Crystal Reports, Analysis for Office (AO), BO Explorer, Lumira and SAP Dashboards with SAP HANA Solutions.
S4/HANA Simple Finance, S4/HANA IBPF, SAP Fiori SAP BPC, SAP BW-on-HANA & SAP HANA
Extensive experience in S4/HANA Finance (SAP Accounting, SAP Cash Management & S4/HANA IBP)
Extensive experience in SAP S4/HANA Business Suite on HANA & SAP S4/HANA Data Aging
Extensive experience in SAP Fiori & SAP S4/HANA IBP / Embedded BPC & SAP HANA
Extensive knowledge of Techno-Functional experience in SAP BW-on-HANA, SAP BPC, SAP Bank Analyzer
Over 12 years of Consolidation, Financial Planning, BS, P&L, Cash-Flow, Liquidity Planning & AML Reporting
SAP Simple Logistics & Simple Finance (sFIN - Universal Journal, Central Finance - SAP Accounting Powered by HANA)
SAP Simple Finance (sFIN - SAP Cash Management Powered by HANA)
SAP Simple Finance (sFIN - Integrated Business Planning for Finance – IBPF, Embedded BPC )
Financial Consolidation, Planning, Forecasting & Reporting (Expert)
BS, P&L & Cash Flow Reports in sFIN, BW, BPC & Bank Analyzer (Expert)
Sales Process Flow Contract, Sales, Delivery, Shipping, Billing & AR (Expert)
AML, Anti Money Laundering Modeling, Risk & Regulatory Compliance Reporting (Expert)
Data Modeling & Architecture (BW, HANA, sFIN, SAP S4/HANA Business Suite) (Expert)
SAP 4/HANA Business Suite, SAP Simple Finance & Data Aging in SAP s/4 HANA Finance (Medium)
SAP Simple Finance IMG, SAP Fiori, S4/HANA IBP and Embedded BW Configuration (Medium)
SAP BW-on-HANA (Expert)
SAP BW NLS on SYBASE IQ and SAP 4/HANA Business Suite Data Aging (Expert)
SAP SLT & DXC, HANA Modeling, Monitoring, Admin, Security & Authorization (Expert)
SAP BPC 10 & 10.1 Implementation & Optimization (Expert)
SAP Bank Analyzer (Expert)
One year experience of SAP S4/HANA Business Suite and SAP Simple Finance implementing (SAP Accounting, Asset Accounting, SAP Cash Management), Central Finance, SAP IBP / Embedded BPC and SAP Fiori
Expert Guided Implementation (EGI) – SAP Simple Finance (SAP Accounting Powered by HANA, SAP Cash Management Powered by HANA & IBPF by SAP AG
Working on second SAP S/4HANA Simple Finance project, implementing full Suite of SAP Accounting powered by SAP HANA, SAP Cash Management powered by HANA, Asset Accounting Powered by HANA, SAP Integrated Business Planning for Finance (IBPF). Implementing Data Aging (Data Temperature) for SAP Business Suite on HANA
First SAP Simple Finance 1511 project implementation was the Implementation of Central Finance without migrating multiple ECC environment. Configured SAP SLT for the data transfer from five ECC to the Central Finance / Universal Journal. Extended a major enhancement of line-item table ACDOCA.
Working on Cash Management Powered by HANA
Setup of Exposure Hub
Completed SAP Accounting Powered by HANA
Configured BW for IBPF
Configured BPC Embedded for IBPF
Configured Analytical & Calculation Model in HANA for IBPF
Converting two BPC Standard Planning Applications to IBPF
Configured BusinessObjects Analysis for Office
Configure OData / SAP Gateway & SAP Fiori
Implemented SAP Fiori app (Transactional, Analytical & KPI)
Completed initial setup, FPCG Role Setup in SAP Gateway & Gateway IMG Setup
Configured SAP Fiori Catalogs and Tiles
SAP Gateway transaction SICF and IMG SPRO Configuration & Activation
Industry: Manufacturing March 2016 – Present
Client: ArcelorMittal
Project Description: SAP S /4 HANA simple Finance & simple Logistic
Role: Senior S 4/HANA Architect
Configured Embedded Analytics
Configured SLT, ODP and Smart Data Access doe embedded analytics through HANA Studio
Created several Core DataService (CDS) views for complex requirement
Activated and utilized standard CDS views for Sales, Trial Balance and Income statement
Created multiple Open ODS Views via HANA Studio
Utilized real time reporting through Analysis for office via CDS view in S 4/HANA
Created Analytic, attribute and calculation views.
Built universes using Information Design Tool (IDT) on HANA views
Industry: Utility June 2015 – Feb. 2016
Client: SnoPud
Project Description: BOBJ, BW and HANA Integration
Role: Senior SAP BI, BOBJ & HANA Architect
Setup Analysis for Office and OLAP to work with BOBJ and HANA for SSO
Created Analytic, attribute and calculation views.
Built universes using Information Design Tool (IDT) on HANA views
Worked with Lumira, Dashboard Designer, Webi, Crystal Report and OLAP Analysis
Trained super/.power users in Lumira story boards and Xcelsius
Created Design studio dashboards
Worked extensively with HANA security reporting
Worked with management to setup strategy for Business Objects suites with relation to HAHA
Installed and configured BusinessObject and integrated with HANA
Deployed S/4 HANA Rev. 1511 with simple Finance
Worked through issues with S4/HANA Embedded Analytics predefined content
Worked to model and resolved issues with
Implemented ABAP managed Core DataServices (CDS)
Modeled Transformation for S/4HANA using CDS to have real time reporting in BOBJ
Worked on real time credit management reports coming from S/4 HANA Simple Finance
Created attribute, Calculation views for complex reporting requirements
Implemented KNOA reports into BOBJ
Setup Analysis for Office 2.0 and integrated with BOBJ platform for scheduling
Implemented over 200 Reports for Collaborative Lifecycle Management (CLM) with BOBJ integration
Developed the enterprise wide reporting strategy for the Business Intelligence suite.
Industry: HelthCare December 2014 – June 2015
Client: McKesson
Project Description: BOE, BODS & BPC integration
Role: Senior SAP BI, BOBJ & HANA Architect
Designed and proposed entire enterprise architecture for BusinessObjects and SAP HANA
Deployed SAP S/4 HANA with integration of SAP Fiori
Deployed S/4 HANA for the cloud
Deployed SAP HANA simple finance and simple logistics
Performed hardware sizing exercise for BOBJ clustered environment and HANA
Installed HANA DB for Native HANA and BW on HANA for performance compares
Configured HANA Live for Purchasing, Finance and Sales.
Exposed BW infoProviders to HANA Views
Extensive BW development and upgrade work
Expert in creation of Analytic views, calculation view and store procedure
Configured BOBJ and HANA Security
Created multiple universes using IDT on top HANA views
Setup Analysis for Office and OLAP to work with BOBJ and HANA for SSO
Created Analytic, attribute and calculation views.
Worked extensively with HANA security
Helped created complex HANA enabled Webi, Crystal reports and AO
Created Packages, restricted attributes and calculated attributes
Created input parameters and variables within SAP HANA
Loaded data into HANA using DXC
Installed and configured BOBJ on a cluster of 16 VMware servers with separate tomcat and CMS machines.
Created Lumira story boards for mid-level managers
Lead trouble shooting efforts/issues from the migration of BOBJ 3.1 to 4.1
Performed installation/upgrade and migration of BOBJ 3.1 to 4.1
Industry: Pharmaceuticals April 2014 – December 2014
Client: Alexion Pharmaceuticals
Project Description: BOE, BODS & BPC integration
Role: Senior BOBJ/BODS & HANA Architect/Developer
Sizing the Servers based on the volumes of data, number of jobs that could run at the same time and number of users
Designed Performance tuned Landscapes to avoid Network Latency and Client Connectivity issues for SAP BOBJ DataServices and SAP BOBJ Enterprise
Experience in setting up Development, Test and Production environments and also in setting up the migration standards for SAP BusinessObjects Data Services.
Selecting the compatible software versions for different components and installing them without any installation errors
Huge experience in Installing Data Services 3.x and 4.x, Cleansing Packages, Address Directories, Data Quality Management for SAP ERP/CRM, RFC Servers between BODS and SAP, Data Insight, Business Objects Enterprise 3.x and BI Platform 4.x, Information Steward
Hands on experience in Registering the repositories in the Data Services Management console, configuring RFC Services between SAP and BODS, creating the Job Servers and Assigning the local and profiler repositories and Page File configuration for BODS Cache
Configuring SAP Authentication between SAP and BOBJ Enterprise, receiver Port configurations for Adaptive Processing Job Servers with in BOE to troubleshoot Client Connectivity for BODS 4.0 Designer and registering BODS repositories within BOBJ CMC for 4.x versions and managing the user rights
Configuring Real-Time jobs and Web Services for SAP Data Quality Management for SAP and running the Batch and Server RFC’s for both Online and Batch processing of addresses from SAP ECC and CRM
Configuring the Repositories(Central, Local and Profiler), configuring the Data Stores for different sources and targets with multi configurations and maintaining the Substitution Parameters configuration
Creation of Job Servers, Job Server Groups and Access Server, configuring the Web Services for Real-Time Jobs, Batch Job Scheduling and Monitoring, monitoring of System Performance and troubleshooting the performance related issues, the Citrix/Client Connectivity issues and SAP Connectivity issues using RFCs
Code migration using central Repositories, Repository and ATL Export across the landscape, Creation of users and assigning appropriate rights and setting up the Degree of Parallelism for data flows wherever required to tune the job execution performance
Updating the Address Directories required for Data Quality Management jobs for address cleansing on a monthly basis
Heavy experience in handling the SAP Basis activities required to perform for integrating SAP ERP and SAP Netweaver BW with SAP BusinessObjects Enterprise/BI Platform, SAP BusinessObjects DataServices 3.x/4.x and SAP BusinessObjects Information Steward.
Deploying the transports(Cofiles and Data Files) related to BOBJ Enterprise and BODS into respective SAP ABAP systems using STMS
Creation of TCP/IP RFC(registered Server Programs) connections in SM59 to provide connectivity between SAP and BODS
Configuring the Shared drive on the SAP Servers which will be used by ABAP Data flows, creation of Source System within SAP BW for BODS to push data into SAP BW using BODS Batch jobs
Configuring the Logical System, Partner profiles, Inbound and Outbound IDOCs
Installing the FLDQ Add-Ons in SAP ECC and CRM for Data Quality Management using SAINT, activating the appropriate BC Sets for Global Data Quality connector and doing the SPRO configuration required to enable the Address Check and Duplicate Check for Customer, Vendor and Business partner Master Data
Validating the syntax for the Function Modules under the function groups ZAW0 or /BODS/BODS which will be called remotely from Data Services
Install BI 4.1 Platform on 12 servers on AIX using silent installation technique.
Configure BI 4.1 platform
Establish connection to external FRS on SAN
Reconfigure Adaptive Processing Server to detailed specification
Reconfigure settings of BI server to specification
Installed SAP BOBJ IPS 4.1 SP2, SAP Data Services 4.2 SP1 and SAP BOBJ Information Steward on a single server with proper sizing considerations.
Implemented EPCF Eventing Framework between SAP MDG and SAP Information Steward to send data to MDG from IS.
Implemented the RDS Data Quality Remediation (DQR) with SAP NWBC for providing the framework for correcting the data using SAP MDG and SAP IS.
Setup the repositories in Oracle Database for IPS, IS and DS and completed the post install configurations for both IS and DS.
Created connections for various SAP sources within Information Steward including the connections for Data Review and Failed Data capture.
Conducted workshops with Data Stewards and Data owners to identify Global, Local and Cross-System Data Quality validation rules and categorized the rules into different Data quality Dimensions.
Generated the standard profiling reports using IS Data profiling features like Column, Dependency, Redundancy, Uniqueness, Address and Content Type Profiling.
Developed Custom Profiling Rules within IS for Material Master, Customer and Vendor Master Data and captured the failed data into a database and generated the profiling reports as per the user requirement.
Used the Match transformation in DS jobs to identify duplicates and provided the data back to IS for Business User review using the Match Review configuration. Again after the completion of Review, posted the corrected data back to the sources using DS ETL jobs.
Developed complex Data profiling jobs for scenarios like MRP Profiling and Material Discontinue Profiling using DS and provided the discrepancy reports for user validation.
Identified the Master Data non-matches in various sources against the client of record. And filled the gaps and corrected the data discrepancies using DS Jobs and posted the corrected data back to SAP.
Installed and Configured the AIO Repositories to support migration of Master and Transaction data objects to new SAP ECC 6.0 system from SAP R/3 system.
After Data Profiling and Cleansing the data, migrated the data for various transaction and Master Data Objects using SAP BP for Data Migration (AIO Packages). This includes the objects from MM, SD, FI, PP, PM and CO.
Customized standard AIO Jobs whenever required to simplify the ETL Code as per the requirements.
For custom object migration, generated the files for LSMW load jobs using SAP BusinessObjects Data Services ETL Jobs.
Designed the universes on top of Failed Data Repository tables to generate pretty reports using Web Intelligence and Crystal Reporting tools.
Designed score cards by implementing all the Global, Local and Cross-System Data Quality rules for providing dashboard view of the Data Quality metrics and trend. Also implemented the Financial Impact Analysis with the approximate Cost $’s for identifying and correcting the data.
Trained the Data Stewards to write their own Data Profiling rules in Information Steward and how to analyze the score cards to assess the data quality on a daily basis
Prepared training documentation for the Data Services Developers and Information Steward Users
Industry: Manufacturing December 2013 – March 2014
Client: Bemis Company
Project Description: BOE, BODS & BPC integration
Role: Senior BW/BOBJ &BODS Architect & Lead
Installed and Upgraded BusinessObjects from BI 4.0 version to BI 4.1 systems.
Proposed multiple clustered BOBJ environment and deployed them all.
Setup Single Sign-On (SSO) Windows AD and SAP BW integration with BOBJ 4.1
Optimized BOBJ performance for SAP BW data source
Developed multiple webi, crystal and Xcelsius reports.
Used Query As Web Service to source data for xcelsius dashboard development
Created multi tab webi reports and scheduled them to a dynamic recipient list
Performed SAP HANA POC for future deployment of BW on HANA
Captured all the statistics for ETL processing in customer designed log tables for future analysis and customized error handling process.
Carried out performance tuning for Business Objects Data Services.
Deployed appropriate version of the ETL builds to various environments.
Designed metadata driven ETL Framework in Business Objects Data Services. Carried out architecture/design, content management, change management, data analysis, data quality and data migration tasks
Set up and configured BI 4.1 Mobile environment
Worked with Multiple data providers including Personal Data files, Stored Procedures and Freehand SQL to create reports.
Configured Local, Central and profile repositories and repositories are associated to the Job server.
Access server is configured for Real time jobs. Scheduling jobs to run daily.
Created Users in Data services management console and assigned roles based on the requirement.
Used the Match transformation in DS jobs to identify duplicates and provided the data back to IS for Business User review using the Match Review configuration. Again after the completion of Review, posted the corrected data back to the sources using DS ETL jobs.
Developed complex Data profiling jobs for scenarios like MRP Profiling and Material Discontinue Profiling using DS and provided the discrepancy reports for user validation.
Identified the Master Data non-matches in various sources against the client of record. And filled the gaps and corrected the data discrepancies using DS Jobs and posted the corrected data back to SAP.
Installed and Configured the AIO Repositories to support migration of Master and Transaction data objects to new SAP ECC 6.0 system from SAP R/3 system.
After Data Profiling and Cleansing the data, migrated the data for various transaction and Master Data Objects using SAP BP for Data Migration (AIO Packages). This includes the objects from MM, SD, FI, PP, PM and CO.
Worked on FI AR/AP for Sales Tax reporting
Customized standard AIO Jobs whenever required to simplify the ETL Code as per the requirements.
For custom object migration, generated the files for LSMW load jobs using SAP BusinessObjects Data Services ETL Jobs.
Designed the universes on top of Failed Data Repository tables to generate pretty reports using Web Intelligence and Crystal Reporting tools.
Designed score cards by implementing all the Global, Local and Cross-System Data Quality rules for providing dashboard view of the Data Quality metrics and trend. Also implemented the Financial Impact Analysis with the approximate Cost $’s for identifying and correcting the data.
Trained the Data Stewards to write their own Data Profiling rules in Information Steward and how to analyze the score cards to assess the data quality on a daily basis
Prepared training documentation for the Data Services Developers and Information Steward Users
Industry: Quality Assurance September 2012 – December 2013
Client: Intertek
Project Description: BOE, BODS & BPC integration
Role: Senior BW/BOBJ/BPC Architect & Lead
Installed and configured BPC, BusinessObjects BusinessIntelligence and BusinessObjects Data Service and clustered all three system to use a single repository.
Upgraded BusinessObjects from BI 4.0 version to BI 4.1 systems.
Migrated BI 4.0 version of reports to BI 4.1
Troubleshoot and fixed all migration related issues with reports and schedules
Created and configured Central and Profiler repositories and connected to BOE CMC
Connected BOBJ Enterprise to MS SQL Analysis service
Created relational universes on top of SQL Enterprise data warehouse (EDW)
Worked on integrating Dataservices with BW 7.3 for right optimized DSO
Sizing the Servers based on the volumes of data, number of Profiling jobs that could run at the same time and number of users
Designed Performance tuned Landscapes to avoid Network Latency and Client Connectivity issues for SAP BOBJ Information Steward, SAP BOBJ DataServices and SAP BOBJ BI Platform/SAP BOBJ Platform Services
Created CRM account management, leads and opportunity reports for marketing managers.
Industry: Utility April. 2012 – September 2012
Client: Perdenales Electric
Project Description: SAP BW for IS Utility
Role: Senior BW Architect & Lead
Involved in new development of BW Data Flow for the application Business area FI, CO, HCM IS-U Billing, FI-CA, Device Management and CRM Interactive Center Reporting. Gathered requirements from End users and prepared the Functional and Technical Specifications for the BW Reporting Requirements.
Involved in gathering the reporting requirements for FI, AM, MM, HCM, IS-U Billing, FI-CA, Device Management and CRM Interactive Center by conducting workshops.
Identified the Standard content for the BW Reports and activated them from the BW Business Content.
Created the Report catalogue after identifying the Standard, Modified and Custom report requirements.
Involved in IT discussions to guide them on the Server Sizing for setting up the SAP BOBJ landscape.
Trained the Client technical Resources on SAP BW and SAP BOBJ Tools to bring them up to speed for the Realization phase.
Involved in creating the Functional and technical specification documents and developed the objects as per the design.
Involved in Code development in ECC and BW as and when required as per the customization requirements.
Involved in handling the complete BI Security at the BEx level and used BEx queries as the Basic layer for the Crystal Reports.
Worked with Basis to guide them in setting up the BOBJ landscape and integrated with SAP BW landscape.
Worked on multiple sales tax reporting for Governance and compliance
Involved in doing the entire configuration required for SAP BW and SAP BOBJ integration.
Established the SSO between SAP BW and SAP BOBJ tools.
Involved in creation of Master BEx Queries for Crystal Reports.
Worked on Dashboard for Sales Tax and hourly sales reporting
Manage end-to-end design / configuration activities for the Sales Tax Compliance project
Used SAP BW Publisher Service to publish the Crystal Reports from Crystal Tool to SAP BW and SAP BO Enterprise.
Created various Dashboards for the purpose of Managers and C-level employees of the organization using SAP BusinessObjects Xcelsius Dashboard tool
Designed the strategy for BO enterprise security on the top of SAP BW Security for Folder level access to different end users.
Installed and configured DQM Solution for SAP ECC and CRM WEB IC Client to cleanse the Address information for Customer and Vendor master data.
Installed SAP BOBJ DataServices, Person & Firm Directories and USPS Address Directories.
Configured Real-time Jobs and Corresponding Web services required for online cleansing Solution
Installed and Configured RFC server between SAP ECC and SAP BOBJ DataServices for Communication through Web Services.
Involved in completing the SPRO configuration required for DQM Address verification.
Involved in Technical and Functional Upgrade of SAP BW 7.01 to SAP BW 7.3
Involved in Technical and functional upgrade of SAP BOBJ Enterprise 3.x to SAP BOBJ BI 4.x.
Worked on converting the .UNV universes to .UNX universes and migrated the BOBJ 3.x code to BI 4.x environment.
Created Analysis workbooks on top of SAP BW BEx Queries and Multiprovider.
Created Interactive Analysis Reports (Formerly known as Web Intelligence) by taking BEx queries as source.
Created and setup Analysis authorization for BW security and integrated with bobj
Developed BW data model for optimum performance
Worked with BW 7.3 upgrade team to install and upgrade BW
Setup SAP BW and ECC with BusinessObjects dataservice & DQM
Installed and configured SAP HANA
Configured SAP HANA with BW and BusinessObjects
Modeled Analytic Views into Calculation views
Created attributes for master data withing Hana to utilize for Analytic views
Created JDBC connection to consume HANA information through Explorer, crystal report and excelsius
Created ODBO connection for consume some finance reports through excel and to gain HANA performance benefit
Worked to evaluate HANA performance thresholds using Hana Studio and HDBSQL to determine the amount of time required by HANA server to process each query after runtime.
Utilized SLT to pull in sales tables to create analytic view in HANA
Worked on CRB Billing reports
Created reporting solution for CRB interaction records coming from CRM and merging with existing order from ERP
Industry: Petroleum Feb. 2012 - March 2012
Client: Conoco Philipps
Project Description: BOBJ migration
Role: Senior BOBJ Lead/Architect
Installed and configured BusinessObject system
Worked on installing and setting up BOBJ clustered environment
Helped designed Bobj security
Performed knowledge transfer with client technical system
Installed and configured BusinessObjects XI 3.1 SP3 on servers running on Windows 2008 64bit
Performed report migration from XIR2 to 3.1
Worked to troubleshoot Webi and Crystal reports migration issues
Installed BOBJ Integration Kit for integration with BW and configured parameters for BW Publisher
Setup security for BOBJ system with access levels and authorization for different users
Created Universes, Webi Reports, and Crystal Reports as
Documented all stored procedures and did thorough knowledge transfer
Industry: Manufacturing & Wholesale July 2011 – Jan 2012
Client: BridgeStone
Project Description: BOBJ with SAP BI Security
Role: SAP BI & BOBJ Architect & Lead
Performed BOBJ 4.0 to over 600 user for BusinessObjects WebIntelligence, Crystal Reports, Xcelsius and Advanced Analysis.
Configured BusinessObjects integration with sharepoint
Configured Bex web with BusinessObjects BI launch Pad
Participated in the workshops with the power users, business analysts and team members to analyze business requirements.
Installed and configured BusinessObject 4.0
Conducted several proof of concept for BOBJ front end tools to the power