We provide IT Staff Augmentation Services!

Sr. Sap Bi/bo/hana Lead Consultant Resume

Newark, NJ

SUMMARY

  • 11 years of experience as a SAP BI/BO techno - functional consultant with 3 complete life cycle implementations involving data modeling, data extractions, report development.
  • Extensive SAP experience with SD, SCM, PM, PP and FI/CO Modules.
  • Worked on multiple projects with end to end solution including Business Requirements, Data Modeling, Data Architecture, Application Design, Infrastructure Planning, Project Management, Prototyping, ETL Design, Reporting Architecture, Development and maintenance.
  • Good Experience on Universes, Infoview, Live Office, WebI, QAAWS and Xcelsius Dashboards using Business Objects Enterprise.
  • Worked on Oracle 10g/11g and SQL Server 2008/2014 Data warehouses for creating BO Universes using Business Objects reporting tools.
  • Good exposure to Qlikview Reporting tool as well as SAP HANA Data Model.
  • Proficient and sound knowledge with Planning, Multidimensional data modeling using extended star schema, Design Implementation, and User Training of SAP Business Intelligence.
  • Extensive experience in SAP BI 7.4/7.3/7.0//3.5/3.1 configuration, OLTP Extraction and Reporting.
  • Worked on BW upgrade from 3.5 to 7.0 as well as 7.3 include Web templates and BEx Reports.
  • Expertise in BW Components like Info Objects, InfoSources, Update rules, Transfer rules, InfoCubes, ODS, PSA, InfoSpokes and Info Packages, Queries, Calculated key figures, restricted key figures, variables etc.
  • Worked extensively on CRM, BPC, 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 InfoCubes, 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, Error handling is using PSA, Multi-Cubes, Query development, RRI and Documentation.
  • 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.

TECHNICAL SKILLS

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

Data Warehouse: SAP BW 7.4/7.3/7.0/3.5/3.1 C, BO XI 4.0/3.1

Languages: ABAP, C, C++, JAVA, Visual Basic and Crystal Reports

Database: Oracle 11g/10g, SQL Server2008/2011 MS - Access 2000/2008

Tools: Ms-Office, MS Project

Operating System: Windows, MS-DOS, Unix

Web Skills: ASP, HTML, Java Script and VB Script

PROFESSIONAL EXPERIENCE

Confidential, Newark NJ

Sr. SAP BI/BO/HANA Lead Consultant

Responsibilities:

  • Build solutions to extract data for FI-AP, FI-AR data from SAP ECC and SAP BW to load the Staging for downstream reporting.
  • Extracted the Sales data from open hub tables in BW to provide to downstream BI
  • Programmed several Start routine, end routine and field routines in Transformations at various level to meet business requirements.
  • Designed DSO, Infocube and Multiprovider for KPI Data flows in BW system depending on reporting requirements.
  • Provided best practices and recommend solution for enhancing architecture between SAP BW as well as SAP ECC.
  • Built generic data sources based on function modules and views to capture newly and also changed records into BW.
  • Built BEX queries based on reporting needs utilizing CKFs, RKFs and variable selection functionalities.
  • Performed the loading data into table definitions, suspending data loads, resuming data loads, Creating the information objects (packages, attribute views, analytic views, calculation views graphical and SQL script based)
  • Worked on HANA LIVE models for consuming data.
  • Developed Attribute views, Analytic views and Calculation views for Sales, Inventory and Finance tables replicated from ECC to HANA via SLT.
  • Designed, developed and debugged various Information Models (Attribute, Analytic and Calculation Views) to model data for reporting team.
  • Worked on SAP HANA data provisioning, Delivery units and Schema Mapping.
  • Design of HANA schemas, table relations and database objects.
  • Gather customer requirements and showcase analytic solution build using SAP HANA.
  • Involved in rapid-prototyping using HANA platform for various customer scenarios.
  • Prepared documentation on SAP BO Functionality and also train users/Supervisors about SAP BO IDT Universe and WEBI.
  • Built PruTrust IDT Universes on underlying ODBC connection using Microsoft SQL Server 2014 as source system.
  • Worked on complex join condition between tables in Data Foundation Layer.
  • Built Dynamic Native filters in Business Layer without scanning underlying Data Foundation table values.
  • Created Stored Procedure Universes with input parameters to report daily client account balances.
  • Prepared Data Dictionary spreadsheet to rename Business Layer Objects as well as comments section if needed.
  • Implemented LDAP Authentication on newly installed SAP BO 4.2 System.
  • Configured authentication dropdown menu on BI Launchpad screen and also defaulted LDAP Authentication using Wdeploy Administrator Tool.
  • Imported Windows users into SAP BO system using LDAP Authentication.
  • Created Users, User Groups, Folders and access levels within SAP BO CMC system.
  • Worked on security to user groups using Folder, Application, Universe, Connection and Advance access level.
  • Experienced in SAP BO Hot and Cold backups using Repository files and data base files.
  • Created stored procedures with in SQL Server to load Data content into tables (SQL Server Data Warehousing) using Linked Server (DB2 is source system) methodology.
  • Created New Tables (.ddl files), Indexes, and Unique Keys with in SQL Server system.

Environment: SAP BI 7.4, SAP ECC 6.0, SAP BO XI 4.2 and SQL Server 2014.

Confidential, Wichita, KS

Sr. SAP BI/BO/HANA Consultant

Responsibilities:

  • Conducted meetings with BPO’s (Business Process Owners) to gather SOR (Statement of Requirement) for Functional Specs.
  • Worked on KPI Project including Delivery, FICO, Quality Maintenance as well as Production Planning reports.
  • Activated and enhanced standard LO Cockpit data sources.
  • Analyzed Data content in Production System for Delivery reports to bridge gaps for business requirement.
  • Programmed several Start routine, end routine, expert routine and field routines in transformations at various level to meet business requirements.
  • Worked on BEx Query Designer in designing queries using filters, variables, navigational attributes and structures to facilitate flexible, detailed drill down data analysis to the required level of information (RRI).
  • 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.
  • 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.
  • Involved in Blue Print Preparation stage and recommended installing Business Objects for better reporting analysis.
  • HANA system creation - Data provisioning - Modeling - Consumption.
  • Created the Brand new POC system using the SPA HANA studio.
  • Developed Attribute views, Analytic views and Calculation views for Sales, Inventory and Finance tables replicated from ECC to HANA via SLT.
  • Created Users, Roles, Privileges, Packages, Schemas as part of HANA Security and Development
  • Designed, developed and debugged various Information Models (Attribute, Analytic and Calculation Views) to model data for reporting team.
  • Worked on converting ageing DESKI reports into WEBI reports by analyzing underlying Universes as well as Customized SQL Queries.
  • Analyzed Business Objects old Universes and Reports. Designed and developed new Universe and Report as per the requirements.
  • Performed Unit Testing, Integrated Testing coordinating with Business Users. Provided Functional & Technical Documentation as required by Client.
  • Migrated Universe and Reports from BO XIR3.1 to BO 4.0.
  • Creating Cardinalities, Contexts, Joins and Aliases for resolving Loops.
  • Checking the Integrity of the Universes.
  • Developed derived tables for complex Sql in Universe.
  • Modified Universe after analyzing areas of business and user requirements.
  • Developed complex reporting and formulas.
  • SQL tuning of reports to increase performance.

Environment: SAP BI 7.3, SAP ECC 6.0, SAP BO XI 4.0/3.1, Oracle 9/10g and SQL Server 2008/2013.

Confidential, St Cloud, MN

Sr. SAP BI/BO Lead Consultant

Responsibilities:

  • Worked on SAP BI 7.3 SPO (Semantically Partioning Objects) to handle huge amount of source data.
  • Worked with BAPI/IDOC integration using BODS to Extract or Load data.
  • Gathering requirements from Business Users to prepare functional specification and develop technical Specifications.
  • Design flow: BW data extract from SAP and Non- SAP sources and providing this as source to HANA where calculation views are created on top of which the base universe is created. Making use of those universes to build Dashboard, WEBI and Explorer views which are internally integrated.
  • Installed BO products including, Web Intelligence, Performance Manager, Crystal Xcelsius and continued Infrastructuresupport.
  • Analyzed Business Objects old Universes and Reports. Designed and developed new Universe and Report as per the requirements.
  • Created IDT (Information Design Tool) connection to build WEBI reports on top of BEX Queries through BICS.

Environment: SAP BI 7.3/7.0, SAP BO 4.0 and SAP BODS 4.0

Confidential, Milwaukee, WI

Sr. SAP BI Consultant

Responsibilities:

  • Created Open hubs using BEX query as source objects to send data into third party tools.
  • Worked on Calendar and Fiscal year calculations (YTD and MTD etc) in BEX Queries as well as in Infocube for Monthly Closed Reconcile data.
  • Worked onSAP BI7.0 upgrade project which involves pre and post upgrade activities (data integrity check for various objects like PSA, Info objects, DSO’s and Info cubes).
  • Created test cases and scenarios to do validation in Development and Quality Environment.
  • Handled all the issues related to authorization of existing roles and also BI7.0 analysis authorization.
  • Created and also migrated the Queries, Workbooks, Web Templates, Views, Data Flow from BW 3.0 to BI 70.
  • Added additional Web items and some of the 3.x Web items have been removed in the new version of the BEx WAD during migration to the NW 7.0 version.
  • Experienced RSZCOMPDIR table, which contains listing of query objects, internal names, and content release level during migration of Web templates.
  • Coordinated with BASIS Team on source system connectivity after system copy, unicode pre conversion as well as post conversion steps.
  • Extensively involved in creating and Publishing web reports.
  • Worked on BW upgradation including Web templates and BEx Reports.
  • Implemented BW Web reporting and well versed with Web Publisher Wizard to publish views on the web.
  • Worked with BEx Broadcaster to schedule monthly sales reports as e-mail to the users.
  • Created BEx queries using Restricted Key Figures, Calculated Key Figures and Variables to check data consistency.
  • Worked on the performance tuning of reports using RSRT transaction.
  • Worked on upgrade as well as migration of BW 3.5 (Info sources, Data sources, Transfer rules, Update rules and Routines) to BW 7.0 as well as BW 7.3.
  • Worked as Business Objects Admin created rolls and groups in Central Management Console and based on the profile give access to Business user.
  • Developed Documentation on Business Explorer and Reporting for the End User.
  • Used SQL scripting in calculation views such as CE plan operators for the better performances and to meet the complex business requirements.

Environment: SAP BI 7.3/3.5, SAP HANA 1.0 and SAP BO 4.0

Confidential, Plano, TX

Sr. SAP BI Consultant

Responsibilities:

  • Worked with BW Team in Capstone Project ITC2 fix as part of UAT (User Acceptance Test).
  • Programmed several Start routine, end routine and field routines in Transformations at various level to meet business requirements.
  • Enhanced 0FI AR 9 Data source to get customer credit limit and risk category.
  • Designed DSO and Cube on 0FI AP 4 Data source for Account payable aging reports.
  • Worked on FI-AR, FI-AP and FI GL Line Item InfoCubes and InfoSources for loading the data from SAP R/3.
  • Worked on BO Dashboard POC to connect BI/BWA queries to create dashboards.
  • Worked on upgrade as well as migration of BW 3.5 (Infosources, Data sources, Transfer rules, Update rules and Routines) to BW 7.0 as well as BW 7.3.
  • Worked with BPC team to load General Ledger Actual Data from BW Infocube (ZNGL O10) to BPC system,manipulate and store into Cons cube (/CPMB/ZGIIKTC)
  • Involved in BW-BPC integartion for Project system Data loads.
  • Worked on Calendar and Fiscal year calculations (YTD and MTD etc) in BEX Queries as well as in Infocube for Monthly Closed Reconcile data.
  • Worked on SAP BI 7.3 SPO (Semantically Partioning Objects) to handle huge amount of source data.
  • Created Open hubs using BEX query as source objects to send data into third party tools.

Environment: SAP BI 7.3 and SAP BO 4.0

Confidential, Naperville, IL

Sr. SAP BIBO Consultant

Responsibilities:

  • Worked on Smithfield Foods Healthcare SQL database migration into SAP BW System using FTP Process.
  • Designed Flat file Data sources, DSO’s and Info cubes for Medco and Catamaran Data Providers.
  • Recognized Master data and Transaction data flows which are coming from single Flat file.
  • Reconciled Medco and Catamaran Transaction Data at DSO level using mapping documents provided by two Data Providers.
  • Created authorization relevant info objects to setup security design for all Smithfield Foods IOC (Independent of Companies) and imported all the way to Business Objects system.
  • Involved in FTP server setup to transfer files from Medco and Catamaran files and will further be mapped to Smithfield internal server (BI System).
  • 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.
  • Conducted workshops with IT and Business to understand the reporting data requirements, and the current data integration architecture to support these requirements.
  • Created IDT (Information Design Tool) connection to build WEBI reports on top of BEX Queries through BICS.

Environment: SAP BI 7.3, SAP BO 4.0, Microsoft SQL 2008.

Confidential, Oklahama City, OK

Sr. SAP BIBO Consultant

Responsibilities:

  • Extensively worked on the expert routine to load data from Inventory cube for Store Obsolescence report.
  • Designed and enhanced BW extractors for PM module implementation.
  • Worked extensively on PM, MM, FI and SD modules.
  • Activated and enhanced standard PM as well as PP 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.
  • Designed Data model architecture for PM Datasources as staging, consolidated and reporting layers in BW system.
  • Built BEX queries based on reporting needs utilizing CKFs, RKFs and variable selection functionalities.
  • Programmed several Start routine, end routine and field routines in Transformations in PM as well as SD module.
  • Enhanced standard PM Data sources (2LIS 17 I0NOTIF and 2LIS 17 I3HDR) in ECC to get statuses of Notification and Maintenance order respectively.
  • Built complex Webi reports by combining 3 OLAP universes using Merged Dimension
  • Prepared User manual/authorization roles and also trained business users about Webi functionalities.
  • Exclusively worked on Webi by using variable calculation, merged dimension, section, Input Control, Ranking, Query filter as well as Table filters functionality.
  • Built Cross Table, Column and Stacked Charts according to functional requirement provided by business users.

Environment: SAP BI 7.3, SAP BPC 10.0, SAP BO 4.0, SAP ECC 6.0, SD, MM, FI, PM modules.

Confidential, Commack, NY

SAP BIBO Consultant

Responsibilities:

  • Worked on DR impact analysis for Call Activity and Call and Change by analyzing all the objects where DR Sales Force, Territories and any logic related to sales force needs to be added.
  • Added newly created DR Sales Force info object to the call activity cubes and also changed the logic in the end routine as well as expert routine.
  • Created structures, function groups, function modules for call activity item/header and CPR alignment cubes to process result package in the end routine.
  • Created Auxiliary Objects (DSO’s and Info Cubes), transformations, DTPs to renumber DR call data from last 8 Alignment Periods.
  • 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 enddate as a keyfigure 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 Enddate (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.

Environment: SAP BI 7.1, SAP BO 3.1, SAP CRM 5.0, SD, HR, CRM modules.

Confidential, San Diego, CA

SAP BIBO Consultant

Responsibilities:

  • Generated BO exclusive reports in BEx Query Designer using filters, calculated key figures, and restricted key figures.
  • Attended business workshops to gather requirement for Xactly Phase 2 implementation.
  • Worked with users to analyze and translate business requirements into technical designs.
  • Prepared Xactly file layout for decommissioning of existing ICM (Incentive Compensation Managemant) system.
  • Involved in analyzing the gap between Xactly and BW fields mapping for infusion data.
  • Installed and Enhanced LO Cockpit DataSources in Sales and billing and developed the corresponding InfoCubes and ODS objects according to the reporting requirements.
  • Extracted the data using application-specific extractor 2LIS 11 VAITM, 2LIS 11 VASCL, 2LIS 11 VASTI and 2LIS 13 VDITM to DSO’s and to the respective Cubes for the performance measures of each sales position.
  • Created generic data extractors to get material product hierarchical levels from user maintained table in SAP ECC system.
  • Programmed several Start routine, end routine and field routines in Transformations to meet the business requirements.
  • Worked on Open Hub Functionality to send booking and billing cube data to the external systems through flat file for Xactly implementation.
  • Created BEx queries using Restricted Key Figures, Calculated Key Figures and Variables to check data consistency.
  • Worked on the performance tuning of reports using RSRT transaction.

Environment: SAP BI 7.0, SAP BO 3.1, SAP ECC 6.0, SD and FI modules.

Confidential, Pittsburg, PA

Sr. BI Consultant

Responsibilities:

  • Worked with business to scope the project and helped business users create Functional Specs.
  • Enhanced standard extractors to fulfill the Business requirements.
  • 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, InfoCube Partitioning and InfoCube Compression
  • Extracted data from BW InfoProviders 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.
  • Worked extensively on BEx Analyzer and customized the reports creating variables, exceptions and conditions
  • 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.

Environment: SAP BI 7.0, SAP BO 3.1, SAP ECC 6.0, SD module.

Confidential, Portland, OR

BW Consultant

Responsibilities:

  • Involved in complete life cycle implementation of SAP BW for FI, CO-PA, and LO.
  • Extensively involved in creating and Publishing web reports.
  • Worked on several ongoing issues in Sales, Finance and Planning functional areas
  • Designed and developed Demand planning cubes which have the ability to report on the product demand data. This InfoCube contains the data at the material, plant, planning country level, which is loaded from Advanced Planner Optimizer (APO) live cache.
  • Extracted Schedule line, authorized futures data from BW toAPO.
  • Extensively worked on reporting using BEx Query Designer, Analyzer. Created calculated and restricted key figures, variables, exceptions, conditions, jump queries and customer exit variables to meet client requirements.
  • Worked on Open Hub to extract Sales/billing data to external systems using Info Spokes
  • Enhanced Sales Order schedule line and delivery item extractors and created generic extractors to get Partner functions data
  • Designed and implemented all the required Info Objects, Data store Objects, Transactional ODS, Transformations, Start routines, DTP’s.
  • Created Indexes on Master data tables, repartitioned the InfoCubes using Repartitioning Tool.
  • Involved in Unit, Integration and User acceptance testing during Cutover.
  • Created manuals for references and involved in training end users.

Environment: SAP BI 3.5, SAP ECC 6.0, Cognos, SD and FI modules.

Confidential, Boulder, CO

BW Consultant

Responsibilities:

  • 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 reporting and well versed with Web Publisher Wizard to publish views on the web.

Environment: SAP BI 3.5, SAP R/3 4.7, SD, FI, MM and CRM modules.

Confidential

ABAP Consultant

Responsibilities:

  • Work included studying the source data in external system and subsequently identifying and mapping the corresponding Transaction programs, Screens and fields in the SAP system.
  • Designed and coded a BDC program for Sales order that updated records in the Sales order screen or will create new sales order depending on the source data file from external systems using VA01 transaction
  • Created BDC programs to interface with different sub-systems. Interface programs included Material Master and Customer Master. The interfaces were both on- line and in batch processing modes to load and modify master data in logistics & SD modules.
  • Development of SAP Scripts and reports for Goods Issue Note, Good Receipt Note, Transfer Note, Non Conformity Report, Bank and Cash receipts etc
  • Coded report program to display the number of new customers added in a month.
  • Coded report program to display pending orders that haven’t been invoiced.

Environment: SAP BI 3.1C, SAP R/3 4.6C, SD and FI modules.

Hire Now