We provide IT Staff Augmentation Services!

Sap Bi Architect Resume

Houston, TX

PROFILE:

  • SAP Business Intelligence(BI/BO) consultant with over 10 years of experience in IT industry with over 9 years of experience in Business Objects/Business Intelligence & Business Warehouse and complete lifecycle implementation in SAP HANA with 5 complete Business Objects/BW lifecycle implementations involving data modeling, data extractions, installation, configuration, report development, administration and performance tuning.
  • 10 years of Business Objects XI 4.0/3.1/3.0/XIR2/6.x/5.x experience - Central Management Console, Central Configuration Manager, Portal Infoview, Web/Desktop Reports OLTP/ OLAP Intelligence, Data Integrator, Designer, Supervisor, Application Foundation, Enterprise Performance / Information Manager, Dashboard Manager, Scorecards, Import Wizard, Report Conversion Tool, Broadcast Agent, Scheduler, Publisher and Auditor.
  • Excellent understanding of the concepts of business process measurement, including the definition and specification of Key Performance Indicators and formulation of metrics
  • Experience serving as lead and facilitator on BI and data management projects
  • Expertise in project management over three full lifecycle implementations
  • Facilitated on Business Intelligence tools and user adoption of WebI, Dashboards, OLAP analysis
  • Subject matter expert in the use of one or more BI technologies.
  • Expertise in concepts of data governance and with the ability to facilitate business-driven data governance initiatives
  • Experience in HANA data modeling with HANA Studio for creation of Attribute, Analytic and Calculation Views
  • Experience with HANA Data Provisioning for data extraction from SAP ECC, CRM and BW to HANA Database
  • Experience with SLT and DXC data provisioning methods.
  • Leverage knowledge of data warehouse and software development methodologies to contribute to the overall planning of projects by recommending approaches, identifying resources, and developing timelines.
  • Work with client architecture teams to validate functional requirements and providing inputs on architecture options.
  • Analyze the reporting requirements with the business users/architects and come up with the technical Specifications for universe and BO reports. Designed and Documented Universe and Report Requirements Definition templates, Security strategies.
  • Successfully installed Business Objects products on windows
  • Provided the client with best practices with design and development process.
  • Experience with administration of System Management Tools - CCM (Central Configuration Mgt), CMC (Central Mgt Console), Data Federation Administration Tool, Upgrade Management Tool
  • Coordinate DBA activities relating to export/import, giving the access rights, creating the users.
  • Coordinate with database administration, setting up users, Backups House Keeping
  • Created and maintained trigger events for event based scheduling for various WebI reports, dashboards
  • Moved BI resources from one repository to another, managed dependencies of resources and rolled back promoted objects, in case of errors
  • Experienced with creating universes and classes, objects and derived tables, store procedures
  • Developed reports with OLAP Universe’s against BW System and OLTP Universe against OLTP systems
  • Experience with Xcelsius Dashboard development with options of Query Browser, BI Services, QaaWS, Live Office, QaaWS, XML etc., as SAP BW Cubes, BEx Queries and Oracle/MS SQL source systems.
  • Expertise in BO explorer, OLAP Analysis, SAP Lumira, Design Studio, Dashboards and Crystal Reports
  • Developed Web Intelligence reports, Crystal Reports and Dashboards for end users
  • Interacting with clients for requirement gathering, system study & analysis of all client job requests.
  • Drafting functional requirements for computer hardware, software and operational procedures using models and diagrams to represent the processes and functions involved.
  • Provide post-implementation, enhancement and maintenance support to client for application.
  • Developing and delivering individual / group coaching and instructional programs, encompassing a wide range of soft skills, operational, management in terms of skills and attitude.
  • Evaluating effectiveness of and development programs and utilizing relevant evaluation data to revise or recommend changes in instructional objectives and methods

TECHNICAL SKILLS:

BOBJ Tools: BOBJ BI 4.1, BI 4.0, Analysis for OLAP(Web, Microsoft Office),Business Objects XI 3.1, CMC, CMS, Universe Designer, Information Design Tool, WebI, Crystal reports, Xcelsius, Dashboard Design, Data Services, BOBJ Explorer, Mobile BI, QaaWS, Live Office, BIWS & BICS

SAP InMemory Computing: SAP HANA, SAP HANA Studio, SAP HANA ONE (HANA on Amazon aws)

OLAP:: Informatica, MS SQL Server Reporting Services, SAP BI 7.3/7.0, SAP BW 3.5, 3.1b, 3.0, BWA 7.2

ERP:: SAP ECC 6.0/5.0, R/3, 4.7/4.6c

Reporting Tools: Crystal Reports, Mini-Tab, Oracle Crystal Ball, SAS

ETL Tools:: Data Services/Data Integrator XI 3.1/3.2, Informatica

Operating Systems:: UNIX, LINUX, Windows

Databases: Oracle 10g/9i/8i/8.0, Sybase, SQL Server 2005, MS Access

Languages: ABAP/4, C, C++, Java, ASP.Net, VB.Net, HTML, XML, PL/SQL

Other Tools:: MS Office 2010/2007/2003 (Excel, PowerPoint, Word, Outlook, Project), Visual Studio, HP Quality Center, Remedy, SharePoint, Illustrator

EXPERIENCE:

Confidential, Houston, TX

SAP BI Architect

Responsibilities:

  • Deployed 3-level BI reporting; 2 Dashboards as Level 1- Aggregated information for executive management , 10 WebI reports as Level 2 - BI reporting for BU managers, Analysts, 5 Crystal Reports as Level 3 - Operational Reporting for assessing weekly business tasks that capture vendor rationalization, procure to pay cycle time.
  • Designed and Developed Multi layered dashboard f or Purchase Order and Spend Analytics using connectivity with Query browser, BI Services and QaaWS.
  • Conducted business workshops current processes and to document and prioritize requirements specifications, business processes and recommendations
  • Evaluated As -Is (Current Landscape) Business Intelligence solution specific to Supply Chain Procure to pay.
  • Evaluated the integration of BW with Business Objects (BO) platform in comparison to best practices
  • Analyzed BO Statistics as a performance measure to track health of BI system and Utilization of KPIs across the organization
  • Documented the system landscape and developed a AS IS high level system design document, Discovery Document , GAP analysis based on understanding of system design & real expectation of the Business Users
  • Evaluated Audit database, Audit Reports and universes to optimize BO system performance
  • Documented the current processes and to prioritize requirements specifications, business processes and formulated a list of 35 KPIs as a Master list.
  • Based on requirements gathered from the business workshops, generated High Priority KPI reports for Purchase Order and Spend Analytics from the Master list.
  • Developed data connection for Invoice and POs(Purchase Orders) from 3 instances of ECC and Provisioned for data extraction from non- SAP system i.e. Power Advocate to Business Objects using IDT
  • Experience with SLT and DXC data provisioning methods
  • Developed Attribute views for all Material group, PO related data and Analytic, Calculation views for differential and inferential Analytics from the Master KPI list
  • Used Upgrade Management tool to migrate Reports, Universe’s from 3x environment to 4x environment.
  • Created users, groups and assigned users to the respective groups as per the need.
  • Developed new reports against BW Source. (BICS connection, Universe (.unv and .unx)
  • Converted existing reports which are based on Universe as the data provider to BICS connection.
  • Developed universe in IDT with Multi source.
  • Used LCM/Promotion Management tool for migrating reports/Groups/Universe’s from one env to another env.
  • Responsible for Unit testing for all developed reports and production Support with BOBJ Universe’s and Reports
  • Enabled Self Service BI for the business by conducting User on Business Object (BO) to enable Power users achieve full utility of BI while leveraging Supply Chain Business Analytics
  • The ranged from exploring basics of BO such as making basic reports changes to advanced reporting features like data mashing, joins and unions to create complex reports and analytics

Environment: SAP HANA, SLT, SAP BODS, SAP BI 4.1, SAP BW 7.3,SAP HANA Business Explorer (BeX), Query Designer, Dashboard Design, WebI, Info view, Analysis for OLAP, Lumira, Web Intelligence, BI Launchpad, BOBJ Explorer,; Business Area: MM,PUR,FI

Confidential, Chicago, IL

SAP BI Architect

Responsibilities:

  • Gathered Requirements for Enterprise Marketing Management EMM Reports provided all the Budget and Forecast (Finance) information for Marketing activities at Confidential
  • Conducted business workshops to understand the various BUs at Kraft and captured r equirements during Story boarding for report development, Blue Printed the requirements for the EMM source reports as a team lead
  • Developed attribute views for all BU Master Data and Analytic view s to understand ROI(Return on Investments) for all marketing related activities using HANA Studio
  • Experience with SAP HANA Data Provisioning and using SAP LT Replication Server (SLT ).
  • Extracted data using SAP Landscape Transformation (SLT) as data provisioning to HANA Data Base.
  • Involved in replication of data from the database to SAP HANA using SAP Business Objects Data Services .
  • Involved in creation of calculation views using SQL Scripting.
  • Created a Multilayer EMM Dashboard mockup which was used to create a dashboard for Kraft CTO and Brand Managers to get a snapshot of all the investment on the Marketing related activities at Confidential
  • Involved in Data Modeling the complete solution for EMM from generating files from External Teradata database and JD Edwards database to build OLTP universes in BO using IDT
  • Created EMM Planning and Spend BeX Reports used as Source reports for BO
  • Created Spend BeX report for WebI report for Business Unit/Category/Brand Managers for all the product lines at Confidential with respect to Finance information for all Marketing activities
  • Created 22 WebI reports , 2 Level 2 Reports based on Analysis for OLAP
  • Created a EMM dashboard in Dashboard Design by adding a Spend and Planning EMM BeX Query using the Query browser and mapped certain components on the dashboard
  • Created a subset of WebI report blocks and used Live Office to fetch data for dashboard
  • Developed complex dashboards to enable multi-level What-if analysis and used Dynamic Visibility
  • Documented User Acceptance test cases and validated test results during user acceptance testing
  • Involved in End User- documentation, conducted Usability and Interaction sessions with power users
  • Prepared weekly reports for the project manager showing progress against outstanding milestones, status, resource requirements, issues, risks and dependencies
  • Experience with administration of System Management Tools - CCM (Central Configuration Mgt), CMC (Central Mgt Console), Data Federation Administration Tool, Upgrade Management Tool
  • Used LCM/Promotion Management tool for migrating reports/Groups/Universe’s from one environment to another environment

Environment: SAP HANA, SAP BODS< SAP SLT,SAP BO 4.1 SP5, SAP BW 7.3, Business Explorer (BeX), Query Designer, Dashboard Design 6.0, Live Office, Information design tool, CMC, Web Intelligence, BI Launchpad, QaaWS, BICS,DataServices, BOBJ Explorer, Analysis for OLAP, Mobile BI, Analysis - Edition for Microsoft Office;

Business Area: SD, FI

Confidential, Ashburn-VA

SAP BW/BI Lead Consultant

Responsibilities:

  • Assessed client needs utilizing a structured requirements process (gathering, analyzing, documenting and managing changes) to assist in identifying business priorities and advised on options
  • Worked with business partners to align technology solutions with business strategies
  • Established liaison relationship with business partners by assessing timelines and critical paths in project management
  • Responsible for documenting functional requirements (including data flows and high-level source to target data mappings) as part of creating advanced self-service BI(OLAP) and Data warehouse environments
  • Modeled the complete solution for internal supplier, service level and back order using ETL to pull data from staging layer using Sales Order, Purchasing and Delivery extractors
  • Designed and developed report in SAP BW for Service Level and Back Orders Report and used the Bex report as the connection to develop a Multilayer Sales Overview Dashboard in BO 4.1
  • Created universe and OLTP connections to map generic data sources in ECC for Sales document category and DSO days
  • Created Order fulfillment report for Sales/Customer Service Managers across all plants with respect to requested delivery data and confirmed delivery date on Sales Orders
  • Configured Auditing data store tables and Monitoring dashboard, relevant universes
  • Utilized Promotion Management tool to move BI resources from one repository to another, managed dependencies of resources and rolled back promoted objects, in case of errors
  • Created backup and Restored Folders/objects from Repository
  • Documented User Acceptance test plans
  • Documented user test cases and validated test results during user acceptance testing
  • Involved in End User- documentation, conducted Usability and Interaction sessions with power users
  • Provided the security access management by creating users/groups and folders
  • Created and maintained trigger events for event based scheduling
  • Broadcasted WebI reports to individual recipients using BI LaunchPad scheduling functionality
  • Worked extensively on data extraction of SAP BI standard data sources and created generic data sources and data modeling by creating custom Info Cubes, ODS Objects, Info sources, Info objects, Transformations, Extractors, Info sources, Info packages, Info objects Catalogs, Data sources, Data Extraction, Business Content, Data Marts, Process Chains

Environment: SAP HANA studio, SAP BW 7.3, ECC 6.0, Business Explorer (BeX), Oracle 10g, Business Explorer (BeX), Business Objects 4.0/4.1, Information design tool, Enterprise Portal, Web Intelligence, Dashboard Design, BI LaunchPad, QaaWS, Live Office, BICS, Information Design Tool, Data Services, BOBJ Explorer, Mobile BI, Analysis - Edition for Microsoft Office; Business Area: SD, MM, HR, SCM

Confidential, El Paso, Texas

SAP BI Senior Consultant

Responsibilities:

  • Designed a complex Dashboard for inventory categorization deployed in all plants across Europe and Asia to be used in materials management using QaaWS, Live Office, BI services to source data from SAP and Non-Sap source systems
  • Involved in requirement gathering, data modeling, scheduling data extraction from source systems
  • Developed several WebI reports for Inventory Categorization based on Stock Consumption and Material Consumption
  • Created OLAP Universes on SAP data (Info Cubes / BeX queries) using Universe Designer and IDT
  • Created OTLP Universes and classes, stored procedures. Resolved loops using aliases and contexts. Created complex joins like outer joins and equi-join & theta joins and checked the integrity of the Universes.
  • Created detailed reports with Drill-down capability using Web Intelligence in BI Launchpad / Info View, worked on Ad hoc Query, Reporting, and Analysis
  • Built universes using Universe Designer from SAP and Non-SAP source systems
  • Created reports with Multi-Level Scope of Analysis using drill down, drill across, drill up in Web Intelligence and Desktop Intelligence.
  • Worked extensively with the major functionality of BO like Breaks, Ranks, Alerter, inserted calculations, Filters, Sorts, and Query Prompts.
  • Created WebI reports from multiple data providers and synchronized data with merged dimensions
  • Developed new reports against BW Source. (BICS connection, Universe (.unv and .unx)
  • Used Promotion Management tool for migrating reports/Groups/Universe’s from one env to another
  • Developed work books using Analysis edition for office.
  • Developed several Dashboard in Xcelsius using BI Services connection.
  • Created complicated reports including sub-reports, graphical reports, formula base and well-formatted reports according user requirements.
  • Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
  • Provided the security access management by creating users/groups and folders.
  • Involved in installation and configuration of BO and BW using SAP BI/ BOBJ Integration Kit.
  • Created linked WEBI reports and Xcelsius dashboards using Open Document (OpenDoc) functionality
  • Used Life Cycle Management (LCM) to transport WebI reports, Web services and dashboards from Development to Test to Production systems

Environment: SAP BW 7.3/7.0, ECC 6.0, Business Explorer (BeX), Business Objects 4.0/XI 3.1, Crystal Reports 2011, Universe Designer, Enterprise Portal, Web Intelligence, Xcelsius, BI Launchpad, QaaWS, Live Office, BICS, Information Design Tool, Data Services, BOBJ Explorer, Mobile BI; Business Area: FI-AR, AP, QM, SD, MM

Confidential, Sanford, NY

SAP BI Senior Consultant

Responsibilities:

  • Designed and implemented the financial dashboard as financial statement actual/actual comparison and Day Sales Outstanding in Confidential US, EMEA, America and Asia Pacific.
  • Involved in implementation of SAP BW for FIAT’s Reporting; extensively interacted with end users in gathering reporting requirements for Sales, Planning and finance data.
  • Integrated the dispute management, collections management with the standard AR line item
  • Designed and developed DSO Overview: Analysis, Top N for complete information on DSO and Payment Terms. The output data was listed by the last 12 fiscal year periods in the BeX Report
  • Developed new reports against BW Source. (BICS connection, Universe (.unv and .unx)
  • Responsible for Unit testing for all the developed reports.
  • Developed several Dashboard in Xcelsius using QaaWS , Live Office connection.
  • Involved in design and development of SAP Business Objects solutions in an SAP BI/BW to map sap data into Universe and reports specifications.
  • Worked with offshore team and functional teams in implementing the solutions.
  • Created reports with Multi-Level Scope of Analysis using drill down, drill across, drill up in Web Intelligence and Desktop Intelligence .
  • Used Business Objects Data Services for ETL extraction, transformation and loading data from heterogeneous source systems
  • Worked extensively with the major functionality of BO like Breaks, Ranks, Alerter , inserted calculations, Filters, Sorts, and Query Prompts .
  • Developed physical inventory WEBI report specific to each country and also developed global reports which has consolidated with the client standards. Developed the reports with 2 tabs as per the requirement with and without zeroes in the key figures.
  • Created complex reports stating revenue generation per year using cascading and user objects like smart measure objects by using @aggregate aware function to create the summarized reports
  • Worked on CMC to create User-groups and worked on security rights. Maintained user profiles and security profiles of new users in the BW systems
  • Extracted data from FSCM for Worklist item , for promise to pay, Customer contact, Dispute management and loaded data to the Data Store Object Worklist Item (0CLM DSO1)
  • Involved in Unit testing and Quality testing, created the documentation as required for the all the development. Used HP Quality center and Documentum for testing and uploading the documents.
  • Involved in go live and also supported the project after go live.

Environment: SAP BW 7.0/BW3,5, Business Objects 4.0, Business Explorer (BeX), MS SQL Server, Enterprise Portal, Web Intelligence, Dashboard Design, BI Launchpad, QaaWS, BICS, BIWS, IDT, LCM, Mobile BI; Business Area: SD, MM, FI/CO

Confidential, Plano, TX

SAP BW/BI Senior Consultant

Responsibilities:

  • Involved in gathering the business requirements from global users and developed POC different solutions. Developed the Technical specification based on functional specifications on working prototype
  • Developed the complete solution for sales and promotion evaluations report by extracting data from the staging layer using Customer-Defined Data Sources in CO-PA
  • Created Xcelsius Dashboards for Net Revenue: Top N Products dashboard using WebI and QaaWS
  • Created Net Revenue and Billing WebI report using dynamic measures, report filters and applied formatting dynamically using Conditional formatting
  • Designed, created and implemented Universes, WebI reports, and Xcelsius Dashboards
  • Created OLAP Universes on BeX queries using Universe Designer
  • Created multi-layered Xcelsius dashboards to display various components and included Filters, List View, table, Line, Column and Pie charts
  • Broadcasted WebI reports to individual recipients using BI LaunchPad scheduling functionality
  • Created WebI reports with multiple data providers and synchronized the data using merged dimensions
  • Involved in End User- documentation, conducted User Acceptance events
  • Used Life Cycle Management (LCM) and transported objects - dimensions, measures, details, universes, connections, from Development to Testing to Production Systems
  • Created roles/iViews in SAP portal for the users to access WebI reports and Dashboards using SSO
  • Developed and implemented Universes by defining joins, cardinality between tables, created derived tables, prompts and queries, Hierarchies, applying contexts and alias tables to remove cyclic dependencies using Business objects Designer.
  • Developed complex Web Intelligence Reports using Merged Dimensions and Ranking features.
  • Used Rich Client tool to pull the data from external source and merged data with existing Web Intelligence report.
  • Extensively used various techniques like Breaks, Sorting, Ranking, Report Filtering, Query Filtering, Alters and sections to develop the Webi reports.
  • Used Open Document features for URL reporting and Report to report linking.
  • Created Dynamic & customizable data visualization Dash Boards using Xcelsius 2008.
  • Working with linking universes and developed webi reports by using multi data providers.
  • Controlling senior management and corporate reports to ensure consistent information delivery and complete data validation.

Environment: Business Objects XI 3.1, SAP BW 7.0/BW3,5, Business Explorer (BeX),ECC 6.0 Universe Designer, Enterprise Portal, Web Intelligence, Dashboard Design, BI LaunchPad, QaaWS, Live Office, BOBJ Explorer, Business Area: SD, MM, HR, SCM

Confidential, Farmingdale, NY

SAP BI Senior Consultant

Responsibilities:

  • Preparation of the Blue print, developing the unit test cases. Documentation of project specifications, project planning and regular status reporting to project manager.
  • Installing business content for.
  • Involved in Gathering, Analysing, Documenting Business requirements, Functional Requirements and Data Specifications for Business Objects Universes and Reports.
  • Worked on HR-Personnel Administration and built Dashboard based on standard BeX report to highlight Headcount/Change in Staffing Level
  • Developed and implemented Universes by defining joins, cardinality between tables, created derived tables, prompts and queries, Hierarchies, applying contexts and alias tables to remove cyclic dependencies using Business objects Designer.
  • Developed complex Web Intelligence reports using Merged Dimensions and Ranking features.
  • Used Rich Client tool to pull the data from external source and merged data with existing Web Intelligence report.
  • Extensively used various techniques like Breaks, Sorting, Ranking, Report Filtering, Query Filtering, Alters and sections to develop the WebI reports.
  • Used Open Document features for URL reporting and Report to report linking.
  • Created Dynamic & customizable data visualization Dash Boards using Xcelsius 2008.
  • Working with linking universes and developed WebI reports by using multi data providers.
  • Validated senior management and corporate reports to ensure consistent information delivery
  • Worked with various business groups and arranged multiple user hands on sessions for ADHOC reporting
  • Created reports formatted to the users according to the user requirements using Business Objects functionalities like Queries, Slice and Dice, Drill Down, @Functions and Formulas.
  • Creating general security and controls at Universe level.
  • Prepared Technical Specification for all Break fix Enhancements for Production Support Issues.
  • Prepared Test sets for User Acceptance testing of all the Enhancements and Break fix Enhancements for production support.

Environment: Business Objects Enterprise XI 3.1, SAP BI 7.0, BW 3.5, ECC 6.0, Business Explorer (BeX), Crystal Reports, Universe Designer, Web Intelligence, Xcelsius, QaawS, Live Office, BOBJ Explorer, Data Integrator, Microsoft SharePoint Portal; Business Area:HR, FI-CO, AP, QM, SD, MM, WM

Hire Now