We provide IT Staff Augmentation Services!

Senior Sap Bi/bw Consultant Resume

0/5 (Submit Your Rating)

Evansville, IN

SUMMARY:

  • SAP BI /BO Certified Consultant with 9 years of experience.
  • Professional experience in analysis, design, development and implementation of business applications that includes SAP BW/BI/HANA/BOBJ and strong exposure towards other ERP Systems
  • Involved in Multiple Projects which includes Full life cycle implementations in 3.X/7.0/7.3 versions, upgrade from 3.X to 7.0 versions and 7.0 to 7.3 versions. Enhancements and Post Production Support in the areas of HR, Logistics, Inventory, PM, PP, SAP CRM and SAP SRM Modules.
  • Experience on HANA and Business Objects Data Services
  • Good Knowledge in SAP HANA data modeling using Attribute View, Analytic View and Calculation View
  • Hands on experience in HANA modeling. Created multiple schemas and table definitions.
  • Experience in creating Attribute views, analytical view and calculated views. Experience in applying privileges.
  • Experience on Business Objects tools like webi, dashboards.
  • Experience in working multiple projects and managing them.
  • Experience in Presales activities of business intelligence solutions.
  • Hands on experience in developing SAP Business Objects solutions over SAP BI/BW using WEBI, Universe, Lumira, analysis office and Design studio
  • Experience with Onshore - offshore business model with managing Onshore delivery as a Team Lead.
  • Strong planning and organizing with demonstrated ability to master new concepts quickly, in corporate the latest technology, and develop business solutions that increase efficiency, productivity and profitability
  • Analytical, methodical, communicative team player and leader / architect. Very successful in the integration of SAP within a business and in the integration of the SAP modules with each other. Worked as SAP BI BW /BO, IP,, SAP ECC Implementation/support Consultant and Developer.
  • Implemented five BW Full life cycle projects along with various modules of SAP R/3: FI/CO, SCM, SD, MM Logistics, PP, FM, OF, Procurement.
  • Full project implementation and post implementation and production support experienced in U.S.A, possesses excellent technical, written and verbal communication skills.
  • Interaction between end users and assisting the same
  • Understanding the business process and documentation
  • Proficient in data modeling using BW extended star schema model
  • Proficient in Evaluating Requirements and implementing BI solution for Clients
  • Extensive Experience Implementation, Developments as well as Production Support projects
  • Performed extensive Logistic extractions, Finance and generic extractions
  • Worked on queries using Bex Analyzer and Bex browser.
  • Extensively used Multiproviders, structures, variables, exceptions, conditions, restricted and calculated Key Figures in reporting
  • Experience in Performance Tuning.
  • Proficient in handling support projects. Analyzed and corrected production problems as they occur in the SAP BW system.
  • Hands on Experience in implementing BW 7.3 Graphical Data Modeling objects such as Hybrid InfoProvider, Composite InfoProvider, Semantic providers
  • Report development on manufacturing modules like SD MM, PM, QM and integration experience with FICO.
  • Implemented business intelligence requirements on Plant Maintenance (PM), Purchasing (MM), Quality maintenance (QM), CO-PA and customizing them as per the client requirement.
  • Created many complexes and customized reports for specific business requirements and also involved in new features of SAP BI security like Analysis authorization.
  • Analyzed and translated the client's business requirements and functional specifications into technical specifications, data flow diagrams and data models.
  • Extensively worked on SAP ECC as a source system for generating reports using BEx Query Designer
  • Organized Restricted and Calculated key figures for InfoCubes and ODS using variables.
  • Created reports using Query Builder of the BEx browser to execute and present results of queries in workbook.
  • Created and worked on WAD reports.
  • Having thorough knowledge on BW Architecture, workflow and process chain.
  • Extensively worked with PSA in Monitoring the Data Transfer from Source Systems into BW
  • Worked on HANA Studio
  • Worked on Creating Information Models
  • Worked on Attribute View, Analytical Views, and Calculated Views.
  • Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies
  • Loading data into table definitions, suspending data loads, resuming data loads. Creating information objects (packages, attribute views, analytic views, calculation views
  • Good understanding of LSA++ Architecture
  • Worked on Start and End routines in Transformations
  • Experience in enhancing the DataSources
  • Experience in developing user exits for reporting.
  • Experience on Webi
  • Experience on SAP Business Objects 4.0
  • Experience on SAP Business Objects 4.0 Web Intelligence, OLAP Analysis and Universe Design
  • Integrated BO with SAP ECC and SAP BI 7.0 to build Universes.
  • Designed, Developed and Maintained Universes by defining joins, cardinalities between tables applying contexts and alias tables to remove cyclic dependencies
  • Experience on Data integrator and Data Services.
  • Experience on SAP Business Objects Lumira.Knowledge on Design Studio.

PROFESSIONAL EXPERIENCE:

Confidential, Evansville, IN

Senior SAP BI/BW Consultant

Responsibilities:

  • Involved in the Estimation of Change Requests in Delivery and Dispatch
  • Analyze the process document to understand the report requirements.
  • Well Coordinated with Process Team in Analysis of Defects, Gathering of Technical Requirements, Gap analysis and CR Estimation
  • Design technical document for data model as per the requirements.
  • Design technical document for report requirements and Design of data models.
  • Well Coordinated with Development Team in Different Locations for the development of Change Requests, Code, Development, Testing and Transportation of Delivery and Dispatch Area
  • Given guidance for Team members for Analyzing the documents and provided my inputs and guidance to grow them in D&D and deliver the deliverables in Time
  • Consistently produces excellent quality of deliverable, and regularly comes with up innovative solutions
  • Streamlined the data flows for optimized performance
  • Unit testing the requirements, analysis of performance issues and reviews.
  • Involved in transports using Rev-Trac across the systems (Dev, QA and Prod) and resolved issues during transports
  • Coordinated with Different Functional Leads (OTO, OTC) for Analysis of Cross Domain Area Defects
  • Involved in rectifying the issues for other functional areas by giving my suggestions to respective functional Owners
  • Automation of loads and issues resolutions.
  • Being cooperative to extend work hours when work load demands, and worked Saturdays and Sundays to deliver work at stringent time lines as part of Go-Live activities.

Environment: ECC, SAP BI 7.0, BEx Analyzer, BEx Web Analyzer, Web Application Designer, SAP ECC 6.0 (FI/CO,CO-PA,SD,IM,MM

Confidential, Chicago

Senior SAP BI/BW Consultant

Responsibilities:

  • Lead the Technical team and delivered all deliverables well before the time
  • Transportation of BW data flow from Dev to QA and then to Prod.
  • Extensively worked on implementing SAP HR Business intelligence requirements on Personnel Administration, Personnel Time Management, Learning solutions
  • Worked on HR data sources like 0HR PA 0 (Employee) and 0HR PA 1 (Personal Actions).
  • Activated BI Content for Personal Administration (0PA C01, C02 Cubes) to analyze Personal data such as Head Count based on nationality, gender, Language, Personnel area employee group and organizational unit.
  • Worked on HR Reports such as Employee Master, Employee Movement and Leave liability.
  • Resolving the issues occurred during Transportation
  • Installation, activation and enhancement of Standard Business Content for PP modules.
  • Worked on data extraction from DB System for Inventory and sales.
  • Performed LO-Cockpit extraction to pull data from ECC SD modules into BI system extracting the Header and Line item data from the Sales and Distribution (SD) module (Sales Order "LIS 11 VAHDR/VAITM", Shipping/Delivery"2LIS 12 VCHDR/VCITM", and Billing "2LIS 13 VDHDR/VDITM").
  • Extracted data from MM inventory (material management- 2LIS 03 BF data sources), and PP
  • (Production Planning and controlling) modules and compared with POS-DM data.
  • Worked on Inventory Data Sources like 2LIS 03 BX and 2LIS 03 BF.
  • Developed Reports like Inventory Aging, Delivery Status report and Open/Back Order Report.
  • Worked on Generic extractors to pull the Sales, Contracts, Delivery and MM Data from legacy systems using DB and UD connection
  • Extensively involved in data reconciliation between various systems SAP ECC, Legacy Systems
  • Created HR reports using Business Objects Webi, dashboards

Environment: SAP BI 7.1,NetWeaver 2004s, BEx Web Analyzer, Web Application Designer, BI Accelerator, SAP ERP 6.0 FI/CO,SD, MS Office 2007, MS SQL Server, BO XI

Confidential -NY

SAP BI/BW/HANA & BOBJ lead Consultant

Responsibilities:

  • Understanding the business challenges and translating them into requirements and developed Analytics and Reporting Queries according to Business Requirements.
  • Implementing a custom end-to-end solution using SAP HANA
  • Design and Development of HANA data models
  • Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies
  • Loading data into table definitions, suspending data loads, resuming data loads using SLT. Creating information objects(packages, attribute views, analytic views, calculation views Graphical )
  • Hands on experience in HANA modeling. Created multiple schemas and table definitions. Experience in creating Attribute views, analytical view and calculated views. Experience in applying privileges
  • Involved working with content models, attributes and measures, hierarchies.
  • Monitoring and troubleshooting data loads.
  • Created data models with the use of Analytical views and calculation views
  • Created Attribute View, Analytical View
  • Calculation View (CE Functions)
  • Loading data into table definitions, suspending data loads, resuming data loads using SLT. Creating information objects(packages, attribute views, analytic views, calculation views Graphical )
  • Involved working with content models, attributes and measures, hierarchies.
  • Monitoring and troubleshooting data loads.
  • Extensively worked on SAP ECC as a source system for generating reports using BEx Query Designer.
  • Worked on Upgrading BW7.0 to BW7.3
  • Closely worked with end users in identifying, Analyzing and documenting necessary reporting requirements to build Business intelligence solutions.
  • Build and enhanced BI objects that include Info Objects, Data Sources, Transformations, DTP, DSO, InfoCubes, Multi-providers, Info set and Open Hub.
  • Integrated BO with SAP ECC and SAP BW 7.3 thru BICS and UNIV.
  • Designed, Developed and Maintained Universes by defining joins, cardinalities between tables applying contexts and alias tables to remove cyclic dependencies.
  • Hierarchies are implemented to support drill down reports.
  • Customized queries using navigational attributes and filters in BEX analyzer and used customer exits as per client requirements.
  • Several complexes-cross tab reports and sub-reports are published using Crystal Reports and Business Objects Reporter.
  • Implemented appropriate BO reporting tools for report requirements using Design Studio, Analysis Office, BO Explorer, Lumira.
  • Worked on Dimension Filters, Cascading Filters, Panel and charts to develop Dashboards using design studio
  • Designed report templates with BEX Analyzer and Web Analyzer using key figures, features, hierarchies, variables, properties, exceptions and conditions in the query definition.
  • Provided end user
  • Reviewing and Coordinating SAP BI Team's Transport Requests to different landscapes
  • Worked on BW Enhancement for PM/ SCM Modules
  • Developed Web Intelligence 4.0 reports using BICS Connection.
  • Created Reports with several types of Graphical Representations such as Pie, Bar charts, and Graphs involving complex calculations.
  • Created user Prompts, Conditions, Filters, Alerts, Breaks, and Sorts for various reports to specify the reporting parameters as per business requirements.
  • Worked on advance features like set Section and subsections and merge dimensions.
  • Developing Dashboards for SD and FI functional areas

Environment: HANA 1.0, ECC 6.0, SAP BI 7.0/ 7.3, and BO 4.1 FI, Logistics, BOBJ Webi, and Xcelsius dash boards

Confidential, AR, Bentonville

SAP BI/BW Consultant

Responsibilities:

  • Worked as an Onsite Coordinator
  • Worked on Fit/ Gap analysis for a existing Sales Reporting solution on the BI system including a system analysis part
  • Prepared Functional and Technical design documents
  • Ensure the documents are reviewed as per the standard template.
  • Extensively worked with Planning Workbench, Planning Layouts, Planning Sequences in BI IP
  • Worked on FI-AR, AP, GL, AA extractors and reports
  • Worked on extraction (COPA) Profitability Analysis and developed reports.
  • Developed sales reports on YTD, MTD, Overall sales analysis, sales by product, Top 5 products on sale etc.
  • Experience in the OLTP extraction of data of SAP LO-Cockpit, MM, generic extractions,
  • Enhancements and extraction from flat files, non-SAP systems and DB connect
  • Created Web templates using WAD
  • Analyzed report performance for statistics and implemented proposals for aggregate creations and indexing. Tuned queries using Partitioning, Aggregates and Multiproviders.
  • Used BW Accelerator (BWA) to Index BW Data for faster query performance.
  • Created formatted financial reports using Crystal Reports
  • Created Adhoc Reports for sales, finance, purchasing using Business Objects Webi
  • Created dashboards for financial, sales, purchasing KPI’s.

Environment: SAP BI 7.0/FI/SD. BEx Analyzer, and SAP R/3.

Confidential

SAP BW Consultant

Responsibilities:

  • Developed Capital Spending Report using Generic Extraction which is used to track the costs incurred on each Internal Project for the organization.
  • Worked Extensively on LO extractions and Generic Extractions.
  • Worked on CRM - Sales, Services reports
  • Extensively worked on in performance tuning by using Indexes, DB statistics, compression of Info Cube and maintaining and rolling up the Aggregates.
  • Worked Extensively on Reporting using Bex Analyzer such as free characteristics, Restricted Key Figures, Calculated Key Figures, Variables, Structures, Exceptions, Filters, Conditions, Report To Report Interface
  • Worked on Enhancing the Customer Exits for newly added Query variables and newly added R/3 fields.
  • Experience in BI Analysis Authorization.
  • Proficient in using standard security administration tools such as Profile Generator for Authorization Profiles/Roles Administration and User Administration.
  • Process all 2nd level IT support tickets, which related to BW data loading, reporting WAD, etc.
  • Update the Break-Fix business process document with all process changes.
  • Review the Break-Fix business process document periodically.
  • Provide support during Maintenance delivery, Release delivery and other special activities.
  • Segregate the requests
  • Import requests to pre-production system
  • Import requests to production system
  • Execution of Regression test cases in IWT (BI-Testing) system.
  • Create a Query Fast Track Transport for Power User in IWX (BI-Sandbox).
  • TCS in the role of Change Manager to create/release bug fix transport requests in IWE.
  • Update the Authorizations business process document with all process changes
  • Review the Authorizations business process document periodically
  • Analyze missing authorization
  • Assigning appropriate profile to the concerned users required, get the approval and forward to User
  • Admin team and get it assigned accordingly
  • Implementation of OSS Notes.

Environment: SAP BI 7.0. BEx Analyzer, Reporting Designer, Visual Composer, SRM5.0, SAP R/3 4.6C FI/CO,, SD,MM, HR, Oracle 9.2/10.2, ECC 6.0 Windows 2003, MS Office 2003, MS SQL

Confidential, Beaverton, OR

SAP BI/BW Consultant

Responsibilities:

  • Prepared Functional and Technical design documents
  • Created Web templates using WAD
  • Lead the Technical team and delivered all deliverables well before the time
  • Enabled WAD reports as part of the Internalization
  • Conducted performance testing of BW system
  • Involved in unit testing of Web templates
  • Prepared Test cases and performed Informal Unit Testing.
  • Given to the Team members
  • Updated 3.x Transformations to 7.0 version
  • Enhanced the dataflow as per the new Report Specifications

Environment: SAP BI 7.0. BEx Analyzer, SAP ECC 6.0 (FI/CO,MM,HR/HCM), SRM 7.0, Oracle 11.2, BO XI 3.1 Sp2 and 4.0, Xcelsius and SAP R/3

Confidential, Tennessee

SAP BI/BW Consultant

Responsibilities:

  • Created and Maintained Data Source, Info package, Transformation and DTP for DSO objects, InfoCubes, Multi providers, Virtual providers, Infosets and master data.
  • Worked with Info Cubes like Customer, Deliveries, Sales Overview, Delivery Services Vendors
  • Evolution, purchases, account payables, account receivables and Data Sources like Customer, Sales Order, Delivery, Billing and Sales Orders/Delivery, Vendors Evolution, purchases, account payables, account receivables.
  • Modified existing queries on various Info Cubes related to SD and FI. Worked on Query building, Filtering, Free Characteristics, Restricted Key Figures, Calculated key Figures, Variables, Conditions and Exceptions using BEx Analyzer.
  • Identified the LO (logistics) extractors mapping the business requirements, activated and transferred the relevant data sources.
  • Created and Maintained DSO objects, Info Cubes, Multi providers, info set and master data targets.
  • Data loaded from Flat file to Data Providers like DSO, Info Cube and Master Data targets.
  • Involved in R/3 Extraction from SD, FI and created the customized Data Sources.
  • Worked on Performance Tuning like Aggregates, Roll up, Compression and Collapse.
  • Data source migration from BW 3.5 to BI 7.0.
  • Analyzed end user requirements and raised tickets to proper resolution groups.
  • Coordination and communication with the onsite team
  • Late batch notifications on finance environment
  • Running BW Report in BAP production system to determine current Open documents and execute the A/P Open Documents Report in R/3
  • Validating data to the difference between BW - BW and BW- R/3 system output report
  • Report availability and job monitoring for the respective loads in production systems
  • Copying data flow and reports to either production BW systems and Validating data
  • Generated and Maintained Aggregates and Rollup activities on InfoCubes as part of the Info Cube Management
  • Solved tickets raised by end users by using Service desk tool
  • Maintained work history for all the tickets until it is closed down.

Environment: SAP BI 7.0/ SD/ FI. BEx Analyzer, SAP R/3.

Confidential, Glendale, CA

SAP BW Consultant

Responsibilities:

  • Worked with functional consultant for mapping the source data (R/3) to target Data Sources in BI. Configured Custom cubes, Aggregates, queries.
  • Monitored the development of data model to satisfy the functional requirement by implementing queries and cubes using business content.
  • Worked on transformations to translate the business processes into end reporting objects.
  • Worked extensively on extractors 2lis 11 vahdr (Sales) delivery, billing and shipping,
  • Worked with the users for defining the reporting needs and helped design/develop flexible queries and pre-calculated reports using BEX reporting features like variables, exception and conditions in Sales and distribution area.
  • Designing the data model to extract the data from SAP R/3 and resolving the data loading errors based on user requirements, creating the customized queries.
  • Involved in Data Modeling, Extraction loading and reports creation in BEx Query designer.
  • Involved in performing production support activities
  • Actively involved in Rectification of Load failure Errors like Master Data Loads, Transactional Loads.
  • Manually loading data to data targets on daily basis, Weekly basis and monthly basis.
  • Transfer Data from R/3 to BW using Generic Extractors like database tables and function modules.
  • Created a report according to the requirement from the client with some of the restricted key figures & with other objects.
  • Monitoring of process chains and refreshments for every month.
  • Monitoring of Portal servers and solved App support Mails.
Environment: SAP R/3 SAP BW 3.5 / SD. BEx Analyzer, and SAP R/3.

We'd love your feedback!