We provide IT Staff Augmentation Services!

Bi Architect And Developer Resume

SUMMARY:

  • Architect, Technical Lead, Lead Analyst and Senior Developer.
  • 12 years of SAP BW (7.3)/ SAP BI.
  • 60+ life cycles in SAP BW / SAP BI
  • Ramp Up of SAP HANA Native and SAP BW HANA
  • 5 years of BOBJ (BI 4.) and BODS (BO Data Services 4.0) (with integration to SAP BW, ECC, Oracle, DB/2).
  • 8 years of SAS (Chief Consultant with the company SAS).
  • 6 months of Vistex.
  • SAP MDM as well as Master Data Management in BW.
  • Strong in integration of non - SAP data (Teradata, Oracle, DB2, SAS).
  • Executive Coach, Management and Workshop Lead (managing projects with up to 80 people).

EXPERIENCE:

Confidential

BI Architect and Developer

Responsibilities:

  • Vistex data into BW: Billbacks, chargebacks, rebates, incentives. Extractors, data model / development for CSA (Contract and Sales Analytics).
  • Knowledge about master data model and objects in Vistex. Testing of data in Vistex (A*, /IRM/*) tables against BW.
  • Extraction of IP data sources and data modeling.
  • BOBJ Universes, WebI reporting and Xcelcius dashboard on top of BW/Vistex data.
  • CSA reporting including exceptions, overrides, price matrix, commitments.
  • GPO Admin Fee Reporting.
  • Assignment of account aggregation.
  • GTIN (EAN/UPC) assignment from MARM.
  • ECC views/extract structures and generic extractors with delta.
  • Leading workshops gathering requirements.
  • Create blueprint, data model, define mappings to 5 different source systems (ECC/Vistex, CRM and 3 non-SAP: Medi, M2M, Pointman).
  • Create MDM model that consolidates master data from SAP and non-SAP source systems.
  • Develop 8 DSOs,3 InfoCubes, 3 MultiProviders, Process Chains, 2 Universes.
  • Enterprise Objects used in MDM. Enterprise objects created in SAP BW with Source Systems indicator (compounded).
  • Enterprise Objects containing both ECC and CRM data.
  • Extensive work with Vistex as data source. Deep knowledge about data model in Vistex.
  • Data model (design and develop) including billing, credit memos, write offs and link with contracts (from CRM).
  • Start and Endroutines with lookups into Master Data DSOs.
  • Mockup of reports in WebI as well as Xcelcius dashboard, BOBJ 3.1.
  • Document data models in Visio (high level InfoProvider as well as Entity Relationships, project plan in Microsoft Project, documentation uploaded on Sharepoint.
  • Produce status reports and brief senior management.

Confidential

BI Architect

Responsibilities:

  • Business Objects POC / BI 4.0 SP2.
  • Define and implement Business Objects (BI) 4.0 SP2 and integrate with SAP BW 7.01 SP10. Set up users, groups, folders, connections for Business Objects.
  • Define destinations (BI inbox, FTP, email).
  • Grouping of services to secure scalability and performance.
  • Install of s to secure SSO between BO and BW.
  • SSO and replenishment role for BW-BI integration.
  • Define standards and organizational requirements for implementing Business Objects (BI) 4.0. 4 Crystal Reports Enterprise reports. 2 Analysis edition for Microsoft (Excel) workbooks.
  • 1 Analysis edition for OLAP report.
  • 2 WebI reports.
  • Sessions with business understanding requirements (formatting, publishing, self-service).
  • Roadmap for Business Objects.
  • Roll out and implementation plan.
  • Review of data mart layer / reporting layer in BW and usage of BEx -> Fit for Business Objects.
  • Functionality matrix (capabilities) for Business Objects suite.
  • Documentation of install.
  • Architecture drawings using Visio.
  • Conducted workshops and sessions with business.

Confidential

SAP BI Architect

Responsibilities:

  • Leading business intelligence architect with responsibility for architecture, design, review, tools, data model, reporting tools, security and governance.
  • Responsible for both BW and BO (BOBJ + Data Services).
  • Design and implementation of Logical Data Warehouse model that included BW, Teradata, Oracle and DB/2.
  • HANA (BW) and HANA Native Ramp UP (HANA Studio Modeling and Netweaver 7.3) Big Data / Big Insight POC evaluation (Hadoop and NoSQL).
  • Reponsible for architecture including BW, Data Services, Xcelsius, Crystal, WebI, LiveOffice, Universes, BO Integration Kit for SAP and BW, Teradata, Oracle, DB/2, SAS, SAS Enterprise Guide.
  • Documentation and recommendations for usage of Integration Kit for SAP. Implementation of BO Monitoring through CCM. Implementation of BO Data Services as ETL tool for non-SAP data sources.
  • Integration of reporting repository in BOBJ with ETL repository in Data Services.
  • Assessment of BO Data Services for Data Profiling (max, min, count, median etc) and Data Quality Management (parsing, correction, standardization of name and address, duplicate matching).
  • POC for integration between Teradata and BW. Created remote cube in BW that links to Teradata. Assessment, architecture and design of MDM model aligning 3 data warehouses (BW, Oracle, Teradata).
  • Based on CIF model and inspired by Gartners ENS approach. Implementation of Crystal on ECC. Including considerations for security model, infosetsvs open SQL, approval process etc.
  • Usage of WebservicesQaaWS and new WebiWebservices. QaaWS versus LiveOffice considerations. Usage of BICS on BEx instead of older methods.
  • Implementation of BO Analysis edition for Microsoft Office 1.2 (up to SP5 + before called Advance Analysis) including integration with BOE (connections).
  • Building multiple workbooks using both stylesheets, dynamic charts, applying filters, formulas, using variables including prompts etc.
  • Have used components to create better user experience. Storage of workbooks both locally and in BOE environment. Experience with both regular data sources and input-ready data sources (for planning e.g.).
  • Access to both infoproviders and BEx queries in BW.
  • Extensive design and usage of BOBJ tools including design of Universes. Security models including trust levels 1-3, SAP roles, LDAP, BOBJ access groups and folders, SNC (between BOBJ and SAP), WebSeal + governance of security models. Integration of two LDAP systems.
  • Conducted multiple workshops and sessions with business stakeholders.
  • Upgrade to SAP BW Netweaver 7.3 Upgrade to SAP BO XI 3.1 SP3, 3.2 and 4.0 Logging of activities in BO. Used for performance assessment of BO environment.
  • Extraction of CSS data (customer, customer account, service account, installed service, site, billing) Design and architecture of Project and Production Support + Enterprise Adhoc Environment.
  • Implementation of integrated planning (IP) module for service sale based on CRM data.
  • Design of multiple dashboards via Xcelsius including review.
  • Architect for BI data from CRM including review.
  • Requirement gathering and translation into functional requirement documents and technical design documents.
  • Considerations and road map for IP versus BPS and BPC.
  • Review of IP implementation for CRM (very comprehensive implementation including APD for Marketing Research).
  • Logical and physical modeling of data warehouse using Erwin Data Modeler and Saphir option for ERP.
  • Done 4 different Best Practice workshops with architects, leads, developers, project leads etc.
  • Topics ranging from Advanced Data Modeling in BW, Implementation of CIF, Integration of BW and BOBJ, Choice of Crystal, WebI and Xcelcius.
  • Refresh strategies for BW landscape. Definition of naming standards for BOBJ and BODS.
  • Evaluation of SAP SSM tool and recommendation for implementation.
  • Daily work with build and run organizations as well as security, basis and infrastructure.
  • Reporting directly to General Manager of Confidential .

Confidential

Sr. BI Architect

Responsibilities:

  • Setup and Configuration of Web Services in SAP BW.
  • Create XML for Analysis (XML/A) (both discover and execute methods).
  • Create XML Query Result Sets. Define MDX statements on MultiProviders in SAP BW that generates XML files used on SOA.
  • Integrating separate upgraded BW systems (1 running ABAP and another running J2EE) and implementing 7.0 functionality based Java stack functionality. Advising client on ESA and SOA scenarios.
  • Connecting SAP BW with Web Services through .Net based ASP application and Visual Studio + java based Websphere application.
  • Mapping XML output of BW to VoiceXML for voice based customer system. Design of Business Object Architecture including BW, BWA, BOE, XI SDK, CR Server XI, Crystal Reports XI, BO OLAP Intelligence, BO Excel Add-In, Premium addition to BOE, BO Explorer.
  • Defining and implementing security considerations for transport level, message level as well as implementing proxy security.
  • Defining roles and authorizations for technical user. Coaching and knowledge transfer of architects, developers, Basis and java resources at client.
  • Implementation on using Analysis Process Designer (APD) + load of data marts in direct update DSOs. Guidance on using BIA and implementation of mart.
  • Project management through whole life cycle.
  • Documentation of services and integration using Visio.

Confidential

Sr. BI Consultant

Responsibilities:

  • Purpose is to create Java based webservices into SAP (ECC + BI) that integrates SAP data, function modules and BAPIs into 3rd party SOA architecture.
  • Java integration through WebAPI in SAP BW.
  • Execution of Remote Function Calls through SAP JCO (Java).
  • Usage of more than 20+ meta based driven RFCs. Advisory role.
  • Creation of User Stories (design of user interfaces) used by Product Management.

Confidential

Sr. BI Architect

Responsibilities:

  • Upgrade strategy, project plan, check list (pre upgrade and post upgrade as well as delta extractions), status reports, alpha conversions, dual stack versus double stack considerations.
  • FI/AR reporting including Dunning Blocks and bucketing of late AR.
  • Serial number link with delivery documents. Reporting on location of inventory used for government reporting.
  • Master Data Management of SAP and non-SAP data including master data attributes.
  • Modeling of data including slowly changing dimension scenarios.
  • SAP BW APO / SCM Project including Demand Planning and Forecasting, Supply Network Planning, Distribution Planning.
  • Extraction of APO data including reporting on all SCM modules.
  • Extensive usage of APD as well as BEx queries using variables (especially for FI/AR reporting), structures as well as enhancements.
  • Created Planning Area and Layouts in SAP BW IP.
  • Extraction of Repairs, Issues, Returns for Demand Planning (DP).
  • Extraction of Distribution In/Out Plan (Purchase Requisitions and Purchase Orders) for SCM S&OP.
  • Extraction of Distribution In/Out Actual (Movements) for SCM S&OP.
  • Extraction of Purchases Actual / Plan for SCM S&OP.
  • Extraction of Production Actual / Plan for SCM S&OP.
  • Extraction of Inventory Actual for SCM S&OP.
  • Data modeling of feed to SCM for planning.
  • Backup Cubes for APO CTM, APO DP, APO S&OP, APO SNP.
  • Detailed research of Order to Cash + Procure to Pay for SCM extractions.
  • Open STR, Partial conversion STR-STO, Partial conversion STO-GI, Complete conversion STO-GI, Partial Conversion STO-GR, Complete conversion STO-GR, Partial conversion PR-PO, Partial conversion PO-GR, Complete conversion PO-GR, Open Planned Orders, MRP relevant stock.
  • Extraction of Sales Order, Schedule Line and Delivery documents for SCM extractions.
  • Export data sources, reading APO data and creating planning version based reporting structures as well as backup of planning data.
  • 8 different reports in BEx including extraction of structures (regions maintained per plant) + 0prod hier hierarchy.
  • Attended work shops for strategy on Business Object implementation including advising on approach and choice of BOBJ tools.
  • Pre-analysis of BIA and configuration.
  • Strategy for using aggregates on Cubes versus BIA.
  • Extraction of contact person relevant information for different department types (tax and hard$ payer) from KNVK and ADR6 and modeling into 0customer attributes. Alpha conversion of infoobjects.
  • Conversion routines to manipulate non-SAP data feeding from PSA into 1st Staging Area.
  • Extract also of non-SAP data delivered as flat files on FTP server (AL11).
  • Enhancement of 2LIS 02 SCL extractor to include ZZ fields from EKET.
  • Generic extractor on PLAF (planned orders), MARD (inventory), AUFK/AFKO (production).
  • Creation of Database Views in SE11.
  • Extensive performance optimizing ABAP code in Start Routine, Update Routines and End Routines.

Confidential

SAP BI Architect

Responsibilities:

  • Advisory on implementing new Global SAP ECC environment in combined SAP BI / Oracle Data Warehouse.
  • Scoping of project, high level project plan, resources and methodology.
  • Business Architect role.

Confidential

SAP BI Architect

Responsibilities:

  • Evaluate data extraction and loading process assessed for redundancies and performance enhancements.
  • Logical portioning analysis.
  • Custom code efficiency.
  • DTP configuration.
  • PSA retention.
  • Aggregate usage and efficiency.
  • Compressions.
  • Process Chain redesigns.
  • BW landscape synchronization.
  • Query and Report design (including structures, CKF/RFK, variables and variants). Tool usage evaluation.
  • Query execution and navigational steps. BI Governance (standards, naming standards, controls and monitoring, development strategy).
  • Develop comprehensive tuning plan Review areas of concern during discovery Develop action items - plan based on outcome.
  • Make recommendation for development and configuration.
  • Implementation of Solution Manager End to End Root Cause Analysis, Trace and Exception and Workload.
  • Usage of BI Statistics (TCT).
  • Assessment of BIA versus cube strategy.
  • Assessment of usage of Business Object reporting tools and options for integration to SAP BW.
  • Install and usage of BI Administration Cockpit
  • Documentation in Word and Visio.

Confidential

Sr. BI Consultant

Responsibilities:

  • Performance Monitoring of SAP Systems including Automated Flows for solving issues with System Integration, Data Flows (Process Chains) and Query Performance.
  • Definition of tables and remote functions calls used to identify backend processes. Development on Work Flows for solving issues with SAP BI.
  • Support of SAP Basis Team, Architects and Developers.
  • Direct contact with Cisco’s largest clients running SAP and using Tidal Intelligent Automation and Tidal Horizon.
  • Upgrade to Patch 16 and implementation of BI Administration Cockpit in SAP Enterprise Portal.
  • Install and usage of BI Statistics (TCT).

Confidential

BI Technical Lead

Responsibilities:

  • SAP BI Technical Lead for a SAP BI 7.0 upgrade and new strategic BI platform.
  • Responsible for estimate of resources, project plan, milestones, deliverables. Design of roadmap and enterprise architecture design.
  • Lead architect on building new Enterprise Data Warehouse covering primarily supply chain (PS/SD->MM->PP) and defining OTD (on-time-delivery) performance within storage locations and in-/outbound of plant. 2LIS 03*, 2LIS 04*, 2LIS 05*, 2LIS 11* and 2LIS 12* extractors + generic extractors.
  • SAP Visual Composer Dashboard with integration to BEx containing Perfect Order Fulfillment KPIs.
  • Entry variables and structures in BEx Query Designer.
  • Usage of APD for adhoc analysis and testing.
  • Creation of roles and deployment of Visual Composer in SAP Portal.
  • Design of data marts and BEx queries including performance optimization.
  • Knowledge transfer sessions where key topics are discussed: pro/cons and discussion of scenarios for usage.
  • MDM services integrating non-SAP reporting characteristics and modeling in SAP BI.
  • Modeling of historic source system master data with current master data from R/3. Design of InfoProviders such as DSOs (write optimized), BasicCubes and Multiproviders.
  • Design of queries, definition of entry variables as well as a few user exit variables.
  • Production Flow through Process Chains using new 7.0 features including scenarios handling.
  • Multiproviders based on portioned data using hints for optimization of queries. Aggregates and utilization based performance.
  • Client optimization of SAP Visual Composer application (parallel loading of multiple iViews).
  • Coaching of Siemens IT Strategy Group on building up SAP BI competencies (SAP BI Developers, BI Architect, BI Analyst, BI Testing, BI ABAP).
  • Data model documented in Saphir. Landscape and integration documented in Visio.
  • Requirement gathering and translation into functional requirement documents and technical design documents.

Confidential

SAP BI Advisor

Responsibilities:

  • Advisory role on how to deal with issues from earlier enhancements impacting financial reporting.
  • Focus on Cost Center Reporting, Profit Center Reporting and Product Costing.
  • Focus was primarily structure of cost objects and distribution and how R/3 impacted options for reporting in SAP BI.
  • Scope included distribution from MM/PP processes.

Confidential

SAP BI Architect/Lead

Responsibilities:

  • SAP BI Lead working closely together with clients BI Manager. Responsible for project plan including staffing of resources, estimates, miles stones, deliverables and cutover tasks including support.
  • SAP BI 7.0 with integration to Business Objects.
  • Report conversions from Business Object into BEx.
  • Requirement gathering from multiple business areas and alignment of needs and processes between different plants.
  • Responsible for workshops, Blue Print, realization, project plan and off-shore team. 0HR PA*, 2LIS 03*, 2LIS 04*, 2LIS 05*, 2LIS 02 *, 0EC PCA *, 0CO PC *, 0CO OM CCA * extractors and multiple generic extractors particular.
  • HCM data model consisting of personal administration (PA), organizational administration (OM), Benefits.
  • Design of model including history with options for tracking status and changes. Data sources for PA, OM and Benefits + relelated T* tables for master data.
  • Design of InfoProvders such as DSOs, Cubes and Multiproviders for reporting.
  • HR data model dealing with non-accumulated data and time dependant attributes.
  • Design of queries and data marts used by BEx Query Designer.
  • Performance improvement included.
  • Improvement of reporting for WIP as well as “four walls reporting”.
  • Integration to Business Object reporting in Crystal and WebI as well as “One Stop” Data Warehouse via Business Object Data Integrator's SAP Integration Kit.
  • Review of other methods to integrate such as Business Object Universe Builder.
  • Considerations of security models for different Business Object reporting tools.
  • Installation of Business Object Enterprise XI 3.0 (java web application server and IIS + several SQL system databases e.g. MySQL).
  • Configuration of SAP BW to Business Object (patches, ABAP transports, single sign-on, authorizations incl. authorization objects).
  • Authentication through CMS (central management console).
  • Integration of historic Oracle data into new SAP BI data model.
  • Requirement gathering and translation into functional requirement documents and technical design documents.
  • Conducted multiple workshops with business.

Confidential

SAP BI Architect/Lead Consultant

Responsibilities:

  • SAP BI Lead on version SAP BI 7.0 implementation. Responsible for methodology, project plan and estimates.
  • Guidance of SAP Basis team on configuration of SAP BI environment.
  • Coaching/ SAP BI competencies in SAP BI as well as R.3 functional modules SD, FI/CO, CO-PA. Design of DSOs, Basic Cubes and Multiproviders for reporting.
  • Implementation of partitioning and using hints for query optimization.
  • Design of queries including structures for re-usage across infoprovider.
  • Implementation of entry variables. Integration of historic non-SAP master data with SAP master data (customer, material and account).
  • MDM model for global reporting codes for multiple not-aligned source systems.
  • Conversion of material groupings into global product catalogs used in SAP BI for reporting.
  • Cockpit with maintenance and monitoring of MDM conversions.
  • Model for clean up and alerts on wrong MDM master data assignments.
  • Integration with Hyperion Essbase and export of data via XML.
  • Report Conversion of reports from Hyperion Essbase into BEx.
  • Advanced reports via BEx Query Designer, BEx Analyzer (including Excel workbooks).
  • Analytical Process Designer (SAP BI APD) for adhoc analysis and financial reconciliation models between GL, CO-PA and BI reporting.

Confidential

SAP BI Architect/Lead

Responsibilities:

  • BI Lead for assessment on new highly complex data modeling tool called Kalido that gives business the opportunity to define business models directly.
  • Ownership of project plan managed and estimates of resources.
  • Weekly status reports sent to senior management.
  • Design, realization and evaluation of prototype covering financial risks.
  • Tool evaluation and recommendation to senior management in Confidential .
  • Staff augmentation of Confidential resources and consultants.

Confidential

SAP BW Lead reporting to Confidential BI Manager

Responsibilities:

  • Responsible for project plan and time estimates for tasks.
  • Weekly follow up with senior management and BI team members.
  • Project supporting Qoute to Cash, Procure to Pay and Finance area.
  • SAP BW business content used to integrate with Business Object Data Integrator (Business Object Data Services) using SAP Integration Kit.
  • Documentation of Data Model behind extractors 2LIS 11*, 2LIS 13*, 2LIS 02*, 0PS DAT*, 2LIS 05*, 0FI GL*, 0FI AP*, 0FI AR*, 0FI AA*, 0CO OM *, 0EC PCA*, 0CO PA*.
  • Full documentation including mapping of tables in SAP R/3 (including keys), data sources, info sources, DSOs and InfoCubes.
  • Requirement gathering and alignment of processes and reporting across multiple business units across divisions and globally.
  • Responsible for workshops both with Business and IT.

Confidential

SAP BW Lead

Responsibilities:

  • Lead architect and responsible for workshops, design and implementation at Ofcom, Transport of London (TfL) and B&Q.
  • Implementation of large projects covering all aspects of SAP BW. Including BW BPS, BW Data Mining, CRM Analytics and 3rd party integration.
  • Advising clients about architecture strategies, data warehouse strategies, 3rd party strategies, service oriented architectures.
  • Ofcom: Evaluation of Business Content in SAP versus options in PeopleSoft.
  • B&Q: Implementation of SAP BI APD analysis of SD/CRM and MM data. Extraction from Source System and reports in BEx.
  • TfL: Lead Integration Architect for financial reporting platform including Crystal Reports for external reporting to other government offices.

Confidential

SAP BW Lead

Responsibilities:

  • Lead architect and responsible for workshops/design/architecture and implementation
  • Implementation of large projects covering all aspects of SAP BW and 3rd party integration.
  • Advising clients about architecture strategies, data warehouse strategies, 3rd party strategies, service oriented architectures.
  • DONG: Definition of strategy for choosing reporting platform for SRM data.
  • TOP Danmark: FI-CO based reporting and definition of key master data tables in Insurance Data Warehouse.

Hire Now