We provide IT Staff Augmentation Services!

Sap Bw / Bi Consultant Resume

5.00/5 (Submit Your Rating)

SUMMARY:

  • Fifteen years’ experience (Functional & Technical) in ERP - SAP (BW - Ver. 7.1, 7.3 & 7.4 / ECC R/3 - Ver.4.7 & 6.0 / BI / BI-IP (CPM - Ver. 1.0, SP03) / SAP NetWeaver 7.3 / BW Security & Authorization / BASIS (Security) / PP / MM / SD / SRM / AM / PS / PM / HR / FI (AR, AP, GL) / CO / AA / FM / COPA / CATS - SFT / REFx / IM / ABAP Query Reporting / ABAP Interface Development / Portal), Data Warehouse, Enterprise Application Integration (EAI), Supply Chain, Business Analysis, Business Intelligence, Reporting Requirements, Process Mapping and Project Management. With an excellent understanding of “Data Architecture, Data Modeling, MDM & ETL, LO Cockpit, BI Predictive Analysis” concepts through experience in integrating data at logical / physical levels, data warehouse concepts, have gained proven expertise to elicit requirements & develop constructs of conceptual & logical data models to support business requirements
  • Nineteen+ years of IT & eight years of Supply Chain Management experience, with knowledge in Telecommunications, Retail, Manufacturing, Utility, Mining, Construction and Public sectors (Provincial and Federal Governments)
  • Eight years expertise in SAP Business Objects Enterprise XI 3.1 / 4.0 / 4.1 / 4.2 (BOBJ), Business Objects Analysis For MS Office, SAP Xcelsius, SAP BO Data Services, SAP BO Lumira, SAP BO CMC, SAP Solution Manager, SAP HANA, SAP Design Studio, SAP Lumira ; hence, the complete suite of SAP Business Objects BI, Web Intelligence (WEBi), Query Designer, BI Launch Pad and SAP BEx components; along having knowledge of HTML, CSS & JavaScript
  • Excellent Query Reporting skills with competency in Non-SAP data (Microstrategy, Cognos, Tableau, Crystal Reports, Access, Excel, Bi-Query, MS Share-point, etc.)
  • Involved both in GreenField / BrownField Projects

PROFESSIONAL EXPERIENCE:

Confidential

SAP BW / BI Consultant

Responsibilities:

  • Extracted SAP BW data, mixed / matched data in order to produce different reporting requirements for Ministry of Finance, on a project led by Ministry of Climate Change, for Budget / GL Expenses. Broke down various reports by Function (General Public Services, Social Protection, Economic Affairs, Environment Protection, Affairs and Services, etc.); Cost Center - Ministry Wise (Cabinet Secretariat, Commerce & Textile Energy, Communication, Defense, Defense Prod., Edu., & Stand In Higher Edu., Finance, Food & Agriculture, Foreign Affairs, Labour & Manpower, Law, Justice & Human Rights, Petroleum & Nat. Res., Planning & Dev., Religious Affairs & Interfaith, Science & Tech., Water & Power, Women Dev., Railways, Eco. Affairs & Stat., Info. Tech. & Telecom, etc.); Classification Wise (Health and Social Services, Water Resources, Transport, Disaster Preparedness, Energy, Health and Social Services, etc.)
  • Worked on Support work for SAP BW / BI, for end user requirements of a client UniSys

Confidential

SAP Business Warehouse / Business Intelligence Developer

Responsibilities:

  • Created Data Models (InfoObjects, etc.) for Master Data & loaded / maintained Master Data in them. Performed “ETL” monthly in SAP BW for Sales type reports to update the Target numbers for the Finance, Sales & Marketing, for their “Financial Data Management / Analysis”. The reports eventually fed into SAP Business Objects reports, for different users
  • Performed LO Extraction in Logistics Cockpit for Sales & Distribution (SD) Extractor, (2LIS 11 VAHDR). First, in SAP ECC, checked the DataSource Installation (RSA5 / RSA6), maintained the Transfer Structure / Re-generated the DataSource (LBWE); then Replicated the MetaData, in SAP BW. In SAP ECC, Activated the DataSource & maintained the Update Mode (LBWE), deleted data in Setup Tables (LBWG), filled in the Setup Tables (SBIW / OLI7BW). Confirmed with Extractor Checker (RSA3). In SAP BW, performed ETL to bring the data in InfoProvider(s). In SAP ECC, checked the Delta Queue (RSA7), maintained the Job Control (LBWE) and analyzed the Job Overview
  • Created various Data-Targets and Info-providers like InfoObjects, InfoCubes, DSOs (ODS), InfoSets, Multiproviders, Semantically Partitioned Objects, InfoPackages, DataSource creation & replication; and Transformations, DTPs to load Master / Transactional data from ECC 6.0 / Flat-File Interface to target
  • Worked on customization and enhanced Standard & Generic / Customized Extractors to support business needs for the Material / Vendor analytics (T-Code: RSA6 - Append Structure). Reconciled the data between BW and source system
  • Have solid working knowledge of building Database Views / Generic DataSources. Created Customized DataSources using Database Views, Tables, InfoSet queries. Analyzed DataSources / Extractors (T-Code: RSA2 / SE37), based on Function modules. Have working knowledge of Update Rules, Transfer Rules, Attributes (Display, Exclusive, Navigational, Time Dependent, Time Dependent - Navigational Attributes, Compounding, Transitive). Developed custom Query reports
  • Performed monitoring / maintenance of InfoCubes by checking “Statistics” and maintaining “Indexes”, accordingly. Created “Aggregates” and performed “Compression”, whenever necessary
  • Created, revised and maintained SAP BEx queries in Query Designer. Performed data mapping from InfoProvider (in SAP BW) to BEx Query Designer to Universe; and from there to SAP Business Objects Documents. Created, amended and maintained several BO reports for different business
  • Performed User Administration in Business Objects Central Management Console (CMC). Responsible for User Security & Rights, tracking Objects, managing DataSources & Connections, refreshing Universes, scheduling & hence, complete Administration of reports / publications including Auditing, Server Management - starting, stopping, restarting, enabling, disabling, etc.
  • Have excellent understanding and working knowledge of SAP Master Data & EDI / 3PL Integration. Updated SAP BW Master Data Records for Cost Centers through Error Stack into the Target, after performing all sorts of Error Handling; and provided proper Test Documents. Have working knowledge of Conceptual, Logical and Physical Data Modeling, Relational Data Modelling / SQL Server, SQL databases and Unstructured / Semi-Structured Data; & Microsoft Windows Server 2012

Confidential

SAP BW / BI Developer / SAP Business Analyst

Responsibilities:

  • Worked around the implementation phase of front & backend Cross Application Component - SAP Commercial Project Management (CPM)
  • Deep experience in Data Management practices and Data Governance including Data Dictionaries, Governance Standards and Policies, Metadata Management, Data Error resolution. Helped map legacy system data with the SAP tables’ fields, etc.
  • Helped activate BI Contents for SAP PS (SAP BW 7.4), confirmed in T-Code: RSA5 / RSA6, managed Transformations, performed data loads; monitored / investigated issues around Real Time Access (RDA) InfoPackages using Daemons. Mapped data, investigated / fixed errors between SAP BEx and BW; and CPM Workbooks and BW. Installed patches in BW back-end (SM30), and coordinated with SAP Germany to investigate / fix errors. Investigated IDOCs
  • Experienced in DSO / InfoCube design as per business requirements. Skilled in loading (Full / Delta Up-Load), Monitoring of data, hence have experience in all facets of SAP BW including Data Modeling, Data Acquisition, Transformation, Loading and Performance Tuning. Skilled in creation of ABAP Data Dictionaries, defining Metadata Management approaches and Governance processes (T-Code: SE11 / SE12). Have working knowledge of ABAP OLAP Variables
  • Designed and Debugged ETL process to extract data from Sources systems (DB2, Flat files), Transformed as per business requirements and loaded the data into Dimensional Data Models to support BI Reports, Dashboard, Scorecards, etc. Have knowledge of SAP BODS Objects & Functions like: DataBase, DataStore, Batch / RealTime Jobs, WorkFlows, DataFlows, Data Cleansing, Address Cleansing, Change Data Capture, Template Table, Functions, SQL Queries, Query Optimization and Monitors. Extensively used almost all the Transformations like Case, Map Operation, Merge, Query, Row Generation, Validation, Table Comparison, Key Generation, History Preserving
  • Provided suggestions / recommendations / / support on setting up KPIs
  • Helped users in analysis, design and development of Cognos reports. Published “Packages”, generated reports and have them “Scheduled” to go out on certain times, for different users. Have knowledge of Cognos Framework Manager & Dimensional Authoring Techniques using cubes; ODS, EDW, Big Data, along with Virtualization

Confidential

SAP BI Reporting Lead

Responsibilities:

  • Developed a Solution Architecture that reflected the integration of business logic, processes, and data mappedto defined business requirements, and guided the Solution Delivery Team in the implementation of the SolutionArchitecture, for a Global SAP Project. Contributed in the Design, Development and Support of SAP BI and BW solutions
  • Vale IT SME for BW / BI on SAP Implementation program, mainly working on “Order-to-Cash” and “Procure-to-Pay” streams; coordinating, administering and supporting activities related to Data Design, GovernancePlanning and Development
  • Liaised with the counterpart in Brazil implementation to ensure alignment and standardization of the legacy systems & SAP, processes and hence, the complete solution. Participated in the development of Data Architecture, Policies, Standards and Guidelines, related to the Enterprise-Wide Integration of Data

Confidential

SAP Business Systems Analyst

Responsibilities:

  • Designed, analyzed and implemented relational and multi-dimensional databases. Involved in buildingSemantic layer and reporting solution using SAP Business Objects 3.x / 4.x, collaborating with client SMEs and the project team to develop and implement the solution, and assisted with deployment activities. Developed report prototypes and reviewed / fine-tuned report deliverables
  • Extensive experience in Business Objects (XI 3.1 / 4.0), SAP Query Designer, SAP BEx (WEBi) (7.30 - SP3), Xcelsius (2008 - SP6), SAP Business Objects Analysis For MS Office (1.4 - SP6), Microstrategy (8.x), Cognos (10.x), Crystal Reports, Bi-Query, Actuate & SQL
  • Designed, developed and implemented 75 plus reports for Supply Chain Management, Finance, Project Systems, Plant Maintenance, etc. that included BO functionalities like getting data from Multiple Data Providers, Prompts, Slice and Dice, Drill Down, Cross Tab, Master Detail and Merged Dimensions, Multiple Queries, Combination of Chart and Tables, Query within a Query, Report-To-Report Interface (RRI), etc., to name a few. Maintained report specifications for changes to existing production reports to be fully compliant with government regulations
  • Expertise in debugging / troubleshooting Business Objects reports against SAP Business Warehouse
  • Responsible for publishing and scheduling Business Intelligence documents to large number of end users. Deployed Business Objects reports to SAP Enterprise Portal. Assisted in designing / organizing a material / documentation for educating internal customers, for business intelligence tools
  • Created Business Objects 4.0 reports on the top of BEx queries, using BICS connection. Worked inBEx Query Designer on designing queries using Filters, Variables, Conditions, Exceptions, Navigational Attributes, Global Structures, Calculated and Restricted Key Figures
  • Created various Data-Targets and Info-providers like InfoObjects, InfoCubes, DSOs (ODS), InfoSets, Multiproviders, Semantically Partitioned Objects, InfoPackages, DataSource creation & replication; and Transformations, DTPs to load Master / Transactional data from ECC 6.0 / Flat-File Interface to target
  • Worked on customization, and enhanced Standard / Generic / Customized Extractors, to support business needs for the Material / Vendor analytics. Reconciled the data between BW and source system
  • Have solid working knowledge of building Database Views / Generic DataSources. Created CustomizedDataSources using Database Views, Tables, InfoSet queries. Developed custom Query reports
  • Adhered to all Ad-hoc report requests that included extracting / compiling data in SAP, Excel and Access.Have expert level query analysis skills in SAP by using SAP ECC R/3, Query Designer, BEx Analyzer, R/3ABAP Query Reporting Tool (Quick Viewer SQVI), Portal (SCM, SRM, Procurement, BI Supply Chain)
  • Created reports after mapping Functional requirements of Buyers with Material groups / other related information, in order to help streamline the Supply Chain buying processes; and developed WSIB reports from scratch, tested / implemented, and trained users on them. Generated monthly audit reports. Maintained Access databases for monthly, quarterly & yearly spend; and prepared Tax Reports using BMO Online Reporting Tool to extract data, format / transform. Handled issues related to Shopping Carts, SAP Business Workflows, and created reports to track and manage the problems, in SAP SRM Portal

Confidential

SAP Business Intelligence (BI) Analyst

Responsibilities:

  • Ensured consistent standardized solutions to align with and collaborate in the refinement of data architecture
  • Developed Queries to access data from various SAP BW InfoProviders like DSO (ODS), InfoCubes, InfoObjects, Multiproviders and InfoSets using BEx query designer. Reconciliation of BI reports with the ECC & legacy data. Performed analysis for loading and query performance. Worked with Navigational attributes, both time dependent and independent
  • Conducted a Fit-Gap assessment between the SAP BI toolset functionalities and the client’s needs andRequirements. Resolved data inconsistency issues between ECC 6.0 and BW 7.0
  • Skilled in SAP BW / BI in large volume, with strong expertise in front & back end development of

We'd love your feedback!