We provide IT Staff Augmentation Services!

Sr. Bobj, Bw4/hana Consultant Resume

CambridgE

SUMMARY:

  • Having 15+ Years of professional experience engaging with the business stake holders to understanding business needs and provide solutions out of 10 years of SAP Business Warehouse experience encompassing a wide range of skill set, roles and industry verticals.
  • Designed and developed a reporting solution using SAP's Public Budget Formulation module. Responsible for solution design, development, standards, QA, and managed the delivery of user acceptance testing.
  • W orking knowledge and proficiency with Business Objects Reporting tools BI launch Pad, Web Intelligence, Dashboard designer, Dashboard Design, BO Explorer, Crystal reports.
  • Working knowledge on creating universes using IDT on SAP HANA views and reports development on the same using Web Intelligence.
  • Excellent understanding & work Experience of building Complex Universe(s) of Normalized & De - Normalized schemas using Information Design Tool (IDT).
  • Extensively worked on Business Objects 4.1SP5 WEBI, Crystal, and Analysis Office reporting on BW BEx Queries with different features (Sections, Breaks, User Prompts, Variables, Filters ...)
  • Developed web intelligence reports & published it using Business Explorer (BEx), BW source, SQL database (non-SAP) & Webi tools (tables, cross tabs, charts, complex filters, customized formulas and page format layouts) using BW queries.
  • Implemented 5 end to end full-life cycles using ASAP methodology across various modules in SAP BI/BW projects.
  • Worked on Management Work Bench with creating and maintaining Data targets like Info Objects, DSO, Info cubes and Virtual Provides like Info sets, Hybrid Providers and Multi Providers.
  • Excellent knowledge and hands on experience in developing workspaces using AA for OLAP and creating reports in AA for Excel.
  • Worked on BW support project activities (data loading & monitoring and troubleshooting the failures).
  • Experience in system maintenance tasks (Delta queue cleaning, Setup table deletion & validation)
  • BW load/job automation through process chain and Control-M.
  • Worked extensively in HCM, SD, MM, PP, FS-CD and FI Modules.
  • Strong in performance tuning (Data loading and BEX reports) and job failure reduction activities.
  • Worked on SAP HANA implementation projects with both Native HANA and SAP BW on HANA Landscapes based on HANA ASAP 8 Methodology.
  • Worked on Data Modeling, Data Provisioning, Reporting, Security and Authorization aspects of SAP HANA 1.0
  • Experience working on HANA Enterprise - Modelling including Attribute Views, Analytical Views, Calculation Views, SQL scripting, CE functions, Analytical Privileges.
  • Experience in Data-Provisioning techniques suing SLT (SAP Landscape Transformation) to perform real-time data replication into SAP HANA and near time data loading into HANA using SAP BODS.
  • Excellent knowledge on: HANA Optimized InfoCubes, HANA Optimized DSO’s, Transient, Composite, Hybrid Providers, Publishing HANA Model in SAP BW, Import SAP NetWeaver BW Model to HANA .

TECHNICAL SKILLS:

SAP HANA: HANA 1.X (SP3 - SP8).

BOBJ: BI 4.1, BO XI R2/R3, BI launch Pad, Web Intelligence (Web I 4.1), Information Design Tool, Design Studio, Dashboard Design, BO Explorer, Desktop Intelligence (Desk I), BEX Analyzer, WAD, Visual Composer, Crystal Reports, BEX Analyzer, BEX Query Designer

BW Versions: 3.0B, 3.1, 3.5 & BI 7.0, BW 7.3, BW 7.4.

SAP R3 Versions: 4.0B, 4.6B, 4.6C, 4.7 & SAP ERP (ECC 6.0).

ETL: INFORMATICA 9.1, BODS

BI: DW Workbench, DTP, DSO, Transformation Database SQL Server 2000, Oracle 8i/9i/10g.

Applications: Microsoft Office - Word, Excel (Macros), PowerPoint.

Project Management Tools: Solution Manager, MS Project, Rational Rose.

Modeling: ERWIN, Power Design.

Web Technologies: Java, HTML, Java Script, CSS, DHTML, XML.

PROFESSIONAL EXPERIENCE:

Confidential, Cambridge

Sr. BOBJ, BW4/HANA Consultant

Responsibilities:

  • Architected and implemented the roadmap and strategy for BW4/HANA data warehouse where data coming from 19 different Non SAP source Systems and S/4HANA system with presentation lawyer with Firoi and SAP Business Objects 4.2.
  • Involved in designing and implementing Single Sign-on security for all reporting users.
  • Define SAP Best practices for the Enterprise Data Warehouse, Governances, standards, naming conversions, change management Admin support process and procedures.
  • Involved in suggesting BW-HANA Blend scenario solutions for specific requirements where high volume of detailed data reporting is required in real time.
  • Involved in BW/4HANA Modeling Activities for specific report requirement to achieve the real time reporting for high volume data.
  • Involved in providing solutions to the complex requirements using BW4/Hana InfoObjects, AdvancedDatastore objects, Composite Providers and Open ODS views) for BW4/HANA Models
  • Developed Budget Monitoring queries, and Customized Employee and Position standard PEP (Personnel Expenditure Planning) forms.
  • Gathered Functional Requirements from client related to all process areas including Asset Management, SAP FI-CO, FS-CD,PP
  • Created Budget Process Reports - Actuals, Base Budget, Decision Package, and Capital Budget using Webi reports data source form SAP PBF (Public Budget Formulation) module.
  • Developed applications using Input ready and Planning Sequence in MS Analysis for Office 1.4.
  • Designed developed forms to capture Base Budget Adjustment, New Initiatives and Ranking.
  • Responsible for defining KPI and metrics for Business Objects 4.0 Dashboards and source data requirements.
  • Extensively worked on Business Objects 4.2 Lumira, WEBI, Crystal, and Analysis Office reporting on BW Queries with different features (Sections, Breaks, User Prompts, Variables, Filters ...)
  • Involved in defect management during TUT, SIT, UAT testing phases.
  • Provided to BI 4.2 - BI Business Users, team members and created end-user material and documentation.

Confidential, Los Angles

Sr. BOBJ/BW HANA Consultant

Responsibilities:

  • Architected and implemented roadmap and strategy for the self-service BI model for BOBJ across enterprise.
  • Collaborating with cross functional teams to define and convert business requirements, processes and designs into robust and scalable BI Solutions and Developed technical architectures, patterns and guidelines within the BI 4.1 SP5 and BW7.4 SP8 on HANA1.0 SPS3.
  • Involved in designing and implementing BW/BO security for all reporting users.
  • Configured and setup the Table Replication in SLT for ECC and Oracle data real time into Hana. Data replication enhancements created for custom fields when required (during replication).
  • Involved in suggesting BW-HANA Blend scenario solutions for specific requirements where high volume of detailed data reporting is required in real time.
  • Involved in HANA Modeling Activities for specific report requirement to achieve the real time reporting for high volume data.
  • Involved in providing solutions to the complex requirements using BW 7.4 Infoproviders (Transient Infoprovider, Virtual Master Data InfoObjects, Composite Providers, Multiproviders) for HANA Models and resolved HANA Error's like data type mismatch, numeric overflow, etc.
  • Developed Budget Monitoring queries, and Customized Employee and Position standard PEP (Personnel Expenditure Planning) forms.
  • Created Budget Process Reports - Actuals, Base Budget, Decision Package, and Capital Budget using Webi reports data source form SAP PBF (Public Budget Formulation) module.
  • Developed applications using Input ready and Planning Sequence in MS Analysis for Office 1.4.
  • Designed developed forms to capture Base Budget Adjustment, New Initiatives and Ranking.
  • Extensively worked on Business Objects 4.1 WEBI, Crystal, and Analysis Office reporting on BW BEx Queries with different features (Sections, Breaks, User Prompts, Variables, Filters ...)
  • Involved in defect management during TUT, SIT, UAT testing phases.
  • Provided to BI 4.1 - BI Business Users, team members and created end-user material and documentation.

Confidential, NYC

SAP BOBJ/BW HANA Consultant

Responsibilities:

  • Developed all Technical Specifications based on Functional Specifications that outlines required Characteristics, Measures and Business Rules. The Technical Specification outlined the overall HANA design to meet and satisfy the Business Reporting Requirements.
  • Using data provisioning methods like SAP SLT for real time data and Business Object Data Services (BODS) non sap data Flat file upload and direct extraction connection (DXC) to acquire the data into SAP HANA Data Mart.
  • Developed data flows and work flow using BODS (BOBJ 4.1 SP05). Worked on RDS to implement ETL Replication. Used Rapid Marts for SAP Road Map. Developed ETL transformation.
  • Developed the following HANA Data Models: Attribute Views for master data, Analytic Views for Transaction Data and Calculation Views (Graphical and SQL Script) to Join/Union the various Attribute and Analytic Views for report consumption with time dimensions.
  • Created Universes on top of HANA calculation views and developed the Webi reports and dashboards using IDT (Information design tool).
  • Develop SQL scripts and functions for complex reusable scenarios in HANA.
  • Consumption of HANA information Models in BW by creating Composite and Transient Providers.
  • Developed multi-data source challenging reports by merging data from multiple Data Sources using Web Intelligence WEBI 4.1 (BOBJ 4.1 SP05).
  • Designed Web Reports Using Bex Queries (BICS Connection) for HCM and FI Modules.
  • Designed & developed cross tab reports, reports with sub reports (linked & unlinked) and charts using Crystal Reports.
  • Had created reports using SAP BO Analysis Office 1.3 and 1.4 for multidimensional ad-hoc analysis of Headcount Analytics data from SAP BW and HANA in Excel from HCM module.
  • Reports Developed in this Project: Headcount Change in Staffing Level, Human Capital Management Monitor, Leaving Rate, Percentage Distribution of Leavers, Vendor spend analysis.
  • Worked with LCM (Life Cycle Management Console) to Transport the Objects In System Landscape (Dev, QA and Prod)
  • Involved in developing and conducting extensive Unit testing, Integration testing (FIT), Regression testing, User Acceptance Testing (UAT) and documentation.

Confidential

SAP BI/BW HANA Consultant

Responsibilities:

  • Involved in Collaborating with Client managers, DBA's, Reporting team, Business users and other Stake holders to understand SAP HANA, the existing landscape and identify key business use cases for the Poof of Concept (POC).
  • Interacted with Business stake holders in order to understand their structured and ad-hoc reporting requirements, User stories, business rules for finance, sales and marketing domains.
  • Worked on conducting workshops to go over the new tasks with the system administrators and SAP Basis Consultants and also created an application by application migration approach from SAP BW to HANA system.
  • Using Import selective Meta data for SAP BODS 4.1 imported Meta data in the ETL Process prior to on boarding data into sap HANA, created schemas and data provisioned using SAP LT Replication Server (SLT) for Non SAP data from Oracle.
  • Developed Business Object Data Services BODS4.1 jobs to pull external data from Flat files and Oracle into HANA database.
  • Developed jobs to complete remediation of legacy data, data quality management, data profiling using both built in and custom functions.
  • Worked with various transformations like Query, SQL, Key Generation, Merge, Case, Map Operation and Table Comparison in Platform and DI Transforms and extracted data according to the business rules and Technical Specifications.
  • Created master data objects as Attribute views, joined multiple master data tables depending on the requirement, selected key figures and attributes to give context to the master data.
  • Involved in creation of Analytical views to support multi-dimensional reporting by joining Fact table (data foundation) to modeled dimensions (attribute views), selected attributes and measures.
  • Created Calculation views using data base tables, attribute views and analytic views, in order to address complex business requirements created SQL Script based Calculation views.
  • Involved in creation of Calculated attributes, measures, Restricted measures, Calculated columns, filters, hierarchies, variables, input parameters to satisfy reporting requirements using SAP HANA IMCE STUDIO.
  • Used Information Design Tool (IDT- BOBJ 4.1) to create connections to SAP HANA databases, Create data foundations and also created Business layer and publish these connections and layers to Repository.
  • Created Dashboard for Supply chain and Inventory executive dashboards using Design Studio.
  • Extensive working experience with different components of Designer Studio like Charts, Selectors, Text, Maps and Containers.
  • Created reports by connecting to IMCE from SAP Lumira, SAP Business Objects Explorer (BEx) and MS Excel through ODBO/MDX for multi-dimensional reporting.
  • Accessed HANA data as Pivot tables in Microsoft Excel through via MDX provider.
  • Enabled Business Objects Explorer to search data present in HANA.
  • Used Information Design Tool to create Relational Connection, Data Foundation and Business Layer and accessed the data in HANA through BOBJ Crystal Reports, BOBJ Dashboard Design, BOBJ Web Intelligence (Webi), BO Analysis.

Confidential

SAP BW/BOBJ Architect

Responsibilities:

  • Listen to the business stake holders to understand business needs, analyzes complex business requirements, reporting requirements and propose the best solution for them, and convert them into write the functional specification.
  • Worked alongside the database administrator and SAP BW consultant to identify the technical names and sources for the KPIs (key performance indicators) defined by the final user.
  • Implemented data security access with Universe level security and report level security also system security access with integrating the Active directory according to design specification.
  • Designed a Semantic layer based requirements from business a total of 3 Single source Universes and 2 Multi source enable (DB2 AND SQL Server) universe using Information Designer (IDT) for the HCM and FI business.
  • Architected and developed 3 financial dashboards (Variance Price Exchange, Daily Sales, Profit & Loss) using Dashboard Designer and connected source data from SAP BW BEx queries using BICS.
  • Provided Solutions and Developed 2 HCM Dashboards using Dashboard Designer allowing the leadership teams to analyze headcount, compensation and performance trends and metrics for all levels of the organization and source data feed from Universes using QaaWS export dashboard to mobile server as HTML5.
  • Involved and analyzed in creation of 8 Web Intelligence Reports with different functionality like cascading prompts, drilldown, Scope of Analysis, charts, ranking, alerts and implemented with row level security.
  • Worked on BEx Query Designer in designing queries using Variables, Navigational Attributes and Structures to facilitate flexible, detailed drill down data analysis to required level of information.
  • Created 2 Crystal Reports on BEx queries that were built on BEx Query Designer and wrote complex queries including Sub queries for Supply Chain business areas.
  • Migrated 8 Universe designed Universes (UNV files) into Information Design Universes (UNX files) using upgrade management tool.
  • Worked closely with the Database and ETL team to get required table structures.
  • Involved in working with different database environments (PROD, DEV, and QA) and migration of the universes and reports using LifeCycle Manager. Established a change control for each development.
  • Conducted sections for all BI Business Users and created end-user documentation.

Confidential, Columbia, SC

SAP BOBJ, PBF Consultant

Responsibilities:

  • Interacted with Business stake holders to know their business needs and effectively develop and modify Universes and Reports.
  • Implemented SAP's Public Budget Formulation (PBF) software.
  • Designed and developed standard and customized cubes, ODS objects, FM extractors, and MultiProviders for summarizing data.
  • Developed Base Budget Adjustment queries, Financial Plans for yearly and monthly queries, and forms.
  • Developed Continuing Resolution (CR) report to compare latest Financial Plan version to the CR Funding which is used to facilitate analysis.
  • Developed Monthly Analysis report to compare actual obligations and expenditures.
  • Provide complex reports solutions in Web Intelligence using advanced functionality like report level prompts, scope of analysis and ranking data source for both expenditures and revenues.
  • Defined row level security at universe level as per user entitlements, this enabled IT to create one report and make it available to global users based on their rights.
  • Integrated SAP BW with Business Objects and extracted data from SAP Data sources.
  • The development of a total of 6 reports using Web Intelligence, according to functional specification and write the technical specification for each development.
  • Follow the company procedures to migrate from the development environment to QA (quality assurance) all the universes and reports until the production server.
  • Provide to the final users about the correct use of the new business Intelligence elements.
  • Involved in Realization, Final Preparation, Go-Live and Post Implementation, developed production support plan and resolved production support issues.

Confidential, Fort Myers, FL

Sr. SAP BW/BOBJ Developer

Responsibilities:

  • Worked with SAP BI and BOBJ Business users, Project managers and architects in requirement gathering, analysis and creation of best practice architecture.
  • Enabled Single Sign-On (SSO) feature, imported SAP BI roles into BusinessObjects, enabled automatic imports of SAP BI users, managed users and groups in Central Management Console (CMC).
  • Worked with Business Users on design changes and deployed Business Objects Rapid Marts, sourced data from SAP, Non-SAP and flat-file datasources.
  • Created 5 Universes using Universe Designer, worked with tables, fields and joins, involved in resolving loops by creating aliases and contexts using SAP BEx queries.
  • Created/Edit queries and reports in BOBJ - InfoView for multidimensional analysis and trained users on drill-down, cross-tab, triggers, master detail, slicing and dicing, ad-hoc reports by Web Intelligence (WebI), Voyager workspace, scheduling and publishing (to BO Inbox, email, FTP, ..) in multiple formats (html, pdf, ActiveX doc,..)
  • Involved in data extraction from SAP R/3 system, Cognos and Non-SAP systems and scheduled Full Loads / Delta Loads using Process Chains.
  • Created Dashboards and Scorecards integrating reports using Business Objects dashboard manager.
  • Worked with SAP BASIS team in regards to moving Transport Requests and worked with SAP SECURITY team in providing authorizations for Users by assigning specific Roles.
  • Worked with SAP Basis and BI teams and involved in upgrading the SAP BI support package to SP21, installed BusinessObjects Enterprise XI 3.1 Integration for SAP Solutions FixPack 1.x.
  • Involved in developing and conducting extensive Unit testing, Integration testing (FIT), Regression testing, User Acceptance Testing (UAT) and documentation.
  • Worked with Network Administrators and setup .Net framework on VMware with Windows 2003/2008 Server, creation of SQL server 2008 databases, ODBC connections and Java Run-time Environment for BusinessObjects installation.

Confidential, Marysville, OH

Sr.BW Developer

Responsibilities:

  • Responsible for requirement gathering by working with business and technical users, analysts, Project managers, and involved in analysis and creation of architecture that can be considered 'best practice' and scalable.
  • Worked closely with Production Planning (PP), material management (MM), Sales and Distribution (SD), Logistics (LE), Financials (FI) - AP, AR, GL teams involving SAP and Non-SAP team members in creating Order-To-Cash, Procure-To-Pay, Point of Sale (POS) data via DataStage and other integrated solutions.
  • Designed Data Marts as per the System landscape, created Functional and technical BW specifications, considered proper data modeling techniques and data management strategies and created Technical BW Specifications for BW Objects.
  • Captured the BW data elements required by the end users and extensively involved in analysis, design, development, configuration, testing, deployment of BW Objects (Info Objects, ODS, DSO, InfoCubes, InfoSets, MultiProviders, InfoSources, DataSources and corresponding extract, transformation, communication structures).
  • Implemented the BI 7.0 concepts of Transformations and DTPs using the existing datasource migration and involved in up gradation and migration from BW 3.5 to BW 7.0
  • Worked with SAP ABAP team and created code that will result in the highest performance possible.
  • Involved in loads initialization in SAP BW system followed by extraction (LIS/LO Cockpit extraction, FI, CO-PA extraction) from SAP R/3 system and Non-SAP systems and scheduling regular Full Loads / Delta Loads using Process Chains.
  • Provided Knowledge transfer (KT) and to BW team members and Super Users and guidance to team members on Excel-to-SAP project related to Manufacturing during all phases of project.
  • Created Service Level Objectives (SLOs), Solution Documents with the BW team that will guide the production support team when issues occur.

Confidential, Allendale, New Jersey

Sr.BW Developer

Responsibilities:

  • Worked extensively with LO Cockpit structures (2LIS 02 HDR, 2LIS 02 ITM, 2LIS 03 BF) in terms of structure enhancement.
  • Involved in Info Cube maintenance i.e., Compression, Roll-up. Setup the Statistical Setup for the LO-Cockpit and used the V3 Update for Delta Management.
  • Extracting Master & Transaction Data using Generic Data Sources from OLTP.
  • Uploaded Transaction Data from the Flat File as the Source System.
  • Involved in writing update, Transfer and Start Routines using ABAP Routines at Communication Level in BW.
  • Loaded Data into the ODS Object before loading the Data into the InfoCube.
  • Info Package Group Management and Triggering of Event Chains.
  • Sound Knowledge of MultiProviders, Data Mart and Open Hub Service.
  • Data loading was monitored and the failed data packets were analyzed and manually edited.
  • Created multiple queries for sales/purchase stock figures reporting. Defining query in the BEx Analyzer and presenting the result in workbook and integrating the workbook with BEx Browser.
  • Extensively used BEx Analyzer to build queries and worksheets to access data from BW data targets.

Confidential, Parkland, FL

BW Developer

Responsibilities:

  • Designed and developed the Manual Planning Architecture (Multi-Planning Areas, Planning Levels, and Planning Packages) used to capture various Fixed Costs data and perform the necessary calculations. The calculations consisted of several complex FOX Formulas which pulled Data from many different Planning Layouts to perform these calculations.
  • Developed a sophisticated BPS Web-based Planning Interface using the Web Interface Builder.
  • Developed a Business Server Page (BSP) application that hosted the BPS Web-based Planning Interfaces within the SAP Portals system.
  • Coded ABAP User-Exit Variables to populate variables based on Hierarchy nodes and other custom logic.
  • Performed a Data Modeling Performance Optimization analysis to identify more efficient data warehouse processing architecture.
  • Implemented a Web-Based BW reporting infrastructure using a DHTML and JavaScript based menu technology to deliver a Menu Driven portal-like BW Reporting environment. Integrated this reporting application into the Enterprise Portal as an IView.

Hire Now