We provide IT Staff Augmentation Services!

Sap Bi/bo Consultant Resume

Brentwood, TN

Professional Summary

  • Sr. SAP BI/BO consultant having over 8 years of professional experience which includes over 7 years of SAP BI/BW experience, 2 years of SAP BO experience and 1 year of SAP ABAP experience.
  • Experienced in Pharmaceuticals, Automotive, Financial Services, Retailing, Food processing, Manufacturing, Energy, Technology, Oil and gas Industries.
  • Having very good technical skills, functional knowledge of SAP ECC application areas like SD, MM, and FICO and Planning Tools: BPS, IP.
  • Experience using BWA (Business Warehouse Accelerator) extensively.
  • Involved in 3 full cycle implementations, which includes Gap Analysis, Requirements gathering, Blue printing, Development, Testing, Reporting, Go-live and Post Go-live support.
  • Delivered optimized solutions which helped in reducing the processing time and thus improving the efficiency of the Business Process.
  • Handled End User and Corporate Trainings for SAP BW 3.5/BI 7.0/BI 7.3.
  • Excellent communication skills and Won Appreciation from the clients worked.
  • Subject Matter Expert to explain technical terms, single point of contact to provide solution to clients operating with a strong sense of urgency.
  • Ability to work under pressure with cross-functional, cross-geographic and cross- cultural teams. Exceptional ability to quickly master new concepts and technologies.

SAP BI 7.0 Expertise

  • Worked with the creation of Info Objects, Data sources, Transformations, Data Transfer Process, Info cubes and Data Store Objects.
  • Worked with Process Chains to monitor the data loads and ensure quality data.
  • Worked with all the DTP processes to extract the data from the PSA.
  • Worked on Error Handling procedure.
  • Proficient in OLTP extractions of SAP LO-Cockpit, SD, FI, MM, APO, generic extraction, flat files & using DB Connect for legacy data.
  • Implemented the data extraction process on BI 7.0 that includes installation of the Business content, creating data transfer processes (DTP) using the graphical UI provided by new BI 7.0 features.
  • Developed Start routines, End routines and Expert Routines using ABAP to incorporate Business logic and perform data manipulation.
  • Using BEx Query Designer to define complex queries, defining Exceptions, Conditions which are later deployed in variety of scenarios like Excel workbooks and web applications.
  • Expertise with BI reporting for Data Analysis with BEx Analyzer, Web Application Designer (WAD) and implementing BEx Queries, Variables and Workbooks.
  • Migration requirements related to BEx Query Designer, BEx Analyzer and BEx Web Application Designer.
  • Knowledge in creating Multi providers and Info sets.
  • Experience in Performance Tuning using Aggregates, Rollup, Multi Providers, Indexing, Partition, and Compression.
  • Knowledge in SAP BI 7.0 security authorization concepts: create authorizations, profiles, assign profiles to users etc.
  • Worked on the Planning scenarios for financial and sales applications using IP.

SAP BW 3.5 Expertise

  • Extensively worked on different types of Info objects, Data sources, Info Sources, Info packages, PSA, Info Cubes, ODS, Multi providers, Info sets, Business content, Update rules, Communication Structure, Transfer rules.
  • Undergone Implementation of BW which includes Data Loading (Full /Delta Up-Load), Scheduling, Monitoring, Process Chains, Performance Tuning, Data marts.
  • Activated, Installed and Extended Business Contents based on Gap Analysis established on user requirements.
  • Expertise in Data Loading (Initial / Delta Up-Load), Scheduling, Monitoring.
  • Worked extensively in Front-end Business Warehouse Components like Queries, Calculated key figures, restricted key figures, Structures, Variables, Exceptions and Conditions.
  • Worked extensively on Data Extraction from SAP R/3 using LO Extraction, Scheduling, Monitoring, BEX Analyzer, BEX Browser, Workbooks, and Report-to-Report interface.
  • Creating Line item dimensions, optimizing data loads, defining Info Cubes aggregates, Roll-ups, Compression, Info cube Partitioning, indexing, Remodeling, query optimization.

SAP BO Expertise

  • Universe Designer: creation of universe from BI Info Cubes, queries and databases.
  • Web Intelligence: creation of reports from universe and formatting of reports.
  • Info View: creating corporate dashboards from dashboard builder in info view and link your reports to the dashboard.
  • CMC: create and give access to other applications and maintain user authorizations etc.
  • Query as a web service: created the query and publish the query as a web service.
  • Xcelsius/Dashboard: created excellent dashboards.
  • Crystal reports: create the reports from SAP BI Info Cubes and create the report from query as a web service.
  • Dashboard builder: created corporate dashboards and link the reports to the dashboards and linked the dashboards to the dashboard.
  • Used the Information Design Tool (IDT) to establish connection and created different resources for BO Reporting. Created WEBI Report, OLAP Analysis report, Crystal report, Dashboard (Xcelsius) and Live Office Reports.
Technical Skills

ERP: SAP ECC, SAP R/3.

Data warehouse Tools: SAP BI 7.3, SAP BI 7.0, SAP BW 3.5, SAP BO 4.0 and SAP BO XI 3.1.

Languages: ABAP/4, C, C++, Java, VB, HTML, DHTML.

Operating System: Windows 95/98/NT/XP.

GUI: SAP GUI.

RDBMS: Oracle9i.

Professional Experience

Confidential, Brentwood, TN Jul 2012 - Till date
Role: Sr. SAP BI/BO Developer
Responsibilities

  • Generated the Technical Design Documents for Procurement, New-GL and CCA.
  • Implemented Reporting Financials for Profitability Analysis.
  • Implemented Hybrid Provider for CCA to get direct access to data from ECC and replicated data from SAP BI.
  • Created reports on Purchasing Data Cube in existing flow.
  • Activated Business Content specific to the requirement.
  • Created Virtual Provider in SAP BI 7.3.
  • Used the Information Design Tool (IDT) to establish connection and created different resources for BO Reporting. Created WEBI Report, OLAP Analysis report, Crystal report, Dashboard (Xcelsius) and Live Office Reports.
  • Created Dashboards, WEBI Report and Crystal Reports.
  • Created OLAP Analysis Report.

Environments: SAP BI 7.3, SAP BO 4.0, SAP ECC 6.0.

Confidential, Lebanon, NJ Nov 2011 - Jun 2012
Role: Sr. SAP BI Developer
Responsibilities

  • Conducted requirements gathering workshops with key business users to understand existing challenges.
  • Reviewing the functional specifications and generating the technical specification and design with gap analysis.
  • Conducted end user training on BEx Query Designer and Analyzer.
  • Helped coordinate meetings on project status, open issues, and overall progress to goal.
  • Worked with functional team to perform extensive testing on queries before coordinating the production change requests (transports) with SAP Basis team.
  • Involved in end to end design and development of Sales and Operations development starting from extraction to front end reporting.
  • Used BWA to improve the query performance.
  • Perform analysis and recommendation for implementing BWA (Business Warehouse Accelerator).
  • Performed extensive Performance Tuning in the system (BW Statistics, DB Statistics, Compression, Aggregates, Partitioning and Repartitioning.
  • Created Exception and Customer Sales Operations Reports.
  • Created Start, End and Expert routines according to the requirement.
  • Created Multi providers and enhanced queries for optimal performance.

Environments: SAP BI 7.0, SAP ECC 6.0.

Confidential, Scottsdale, AZ Aug 2011 - Oct 2011
Role: Sr. SAP BI/BW Consultant
Responsibilities

  • To accommodate P2P process in BI, Extracted data using FM extractor from ECC to BI and then modeled IP s in BI and generated reports on top of MP.
  • Developed Static and Dynamic cubes for GL reporting.
  • Modeled Mail AR and Premium Billing aging and details cubes.
  • Extracted data from Aging cubes to files using OHD.
  • Generated reports for Mail AR and premium billing.

Environments: SAP BI 7.0, SAP BW 3.5, SAP ECC 6.0.

Confidential, Charlotte, NC Jun 2011 - Aug 2011
Role: Sr. SAP BI Consultant
Responsibilities

  • Involved in High level Design & development of SAP BI Backend Data modeling and Frontend Reporting.
  • Conducted requirements gathering workshops with key business users to understand existing challenges.
  • Created OHD for extracting data from different source DSOs for different ledgers.
  • Created alternate Hierarchies for 0COSTCENTER and 0PROFIT_CTR master data and loaded through flat file.
  • Created Average Daily Balance variance reports to compare BI and Source System data.
  • Ensure that all periodic schedules like daily/weekly and monthly are successful.
  • Analyze the errors occurred while uploading the data if the request fails and make the latest data available in data target.

Environments: SAP BI 7.0, SAP ECC 6.0.

Confidential, Alpharetta, GA Jul 2010 - May 2011
Role: SAP BI/BO Consultant
Responsibilities

  • Extracted data using view from ECC to SAP BI and modeled IPs and then generated Road Permit Status, Road permit Stock and Nil Permits reports on them.
  • Extracted data using view from ECC to SAP BI and modeled IPs and then generated Labor Cost analysis report on it.
  • Modeled IPs and generated Sales Comparison Report for Yearly, Monthly, Weekly and Daily.
  • Created start routines, End routines and Transformation rules according to the requirement.
  • Validating user input in the initial screen of the sales report using Customer Exit.
  • Ensure that all periodic schedules like daily/weekly and monthly are successful.
  • Analyze the errors occurred while uploading the data if the request fails and make the latest data available in data target.
  • Installed relevant business content objects as and when required.
  • Conducted requirements gathering workshops with key business users to understand existing challenges.
  • Understand the client requirements and developing the Reports and dashboards using business objects tools.
  • Building of the Universes for the reports using Business Objects Designer.
  • Successfully Integrated SAP BI with SAP business objects XI3.1.
  • Developed Various Reports in Web intelligence to track Sales periodically.
  • Organized data in reports by using filters, ranking, alters and sorts.
  • Created Crystal Reports with hierarchies and Filter.
  • Developed highly formatted reports using Crystal Reports on top of BEX Queries.
  • Created, designed and implemented Universes, WebI, Crystal Reports and Xcelsius Dashboards.

Environments: SAP BI 7.0, SAP ECC 6.0, Business Objects XI 3.1.

Confidential, City of Buffalo, NY Jun 2009 - Jul 2010
Role: SAP BI/BO Consultant
Responsibilities

  • Designed and developed new BI models optimized for reporting and satisfying the business needs.
  • Created Generic data source to extract Sales activities transaction data for
    reporting to sales activities analysis such as Sales Activity status, Customer, Start & End of sales Activity.
  • Generated pending PO and PR report.
  • Performance tuning of queries & data load by maintaining query read mode,
    Aggregates, Index & Statistics & Compression.
  • Involved in Transporting the BI objects from development server to Quality
    server for Integration & Pre- production testing before UAT.
  • Detected/resolved data Cardinalities and loops, checked integrity of Universes.
  • Involved in developing Universe and reports on SAP BI including DSO, Info Cubes, Multi Providers and BEx Query development.
  • Measure Objects and dimension objects were created keeping in view of the end-user requirement.
  • Defined business objects standard reports & ad-hoc reports and Created report templates for consistency in the look and feel of the reports.
  • Developed complex reports using Business Objects functionalities like Slice and Dice, Drill down, Cross Tab, Master detail and Formulas etc.
  • Implemented dynamic charts and graphs in dashboards to improve look and feel using Xcelsius.

Environments: SAP BI 7.0, SAP ECC 6.0, Business Objects XI 3.1, 4.0

Confidential, Greenville, SC Dec 2008 - May 2009
Role: SAP BI Consultant
Responsibilities

  • Responsible for data extraction, reconciliation and reporting.
  • Responsible for loading time dependent and time independent master data and hierarchies.
  • Created Start routines and End routines using ABAP in transformations to update characteristics and key figures in the Info Cubes.
  • Performed Remodeling on already existing Info Cubes to add new key figures and characteristics.
  • Designed process chains for daily master data loading, transactional data loading from ECC.

Environments: SAP BI 7.0, SAP ECC 6.0.

Confidential, India. May 2008 - Nov 2008
Role: SAP BI Developer

Responsibilities

  • Created & Scheduled Info Packages and populated DSOs, Info cubes with full and Delta Update.
  • Uploaded Transaction Data from the Flat File as the Source System.
  • Used Write-optimized DSO's for staging huge volumes of data.
  • Created a routine to select a file dynamically on Application server which comes from portal to SAP BI every day.
  • Created Factory calendar for scheduling the Info package on particular day of a week at particular time interval.
  • Monitoring of Info packages and analyzing the reasons for frequent failures of Info packages.
  • Wrote routines to handle Invalid characters.

Environments: SAP BI 7.0, SAP ECC 6.0.

Confidential, India Apr 2007 - Apr 2008
Role: SAP BI Developer
Responsibilities

  • Involved in all phases of Implementation of Secondary Sales Analytics Project in Britannia.
  • Developed ABAP Routine at Info Package Level to schedule the daily delta loads automatically in background at particular time intervals.
  • Developed IOS, DSOs, Info Cubes and Multi providers to model the data in BI and loaded the data from MS-SQL using UD Connect.
  • Developed ECO (Effectively Covered Outlets) reports as per the client requirement.
  • Developed ABAP routine in Transformations to calculate Universe Count.
  • Extracting Master & Transaction Data using Generic Data Sources from OLTP.
  • Setup the Statistical Setup for the LO-Cockpit and used the V3 Update for Delta Management.
  • Developed validation program in Process chains to generate Error log on File validation, Invalid data and Availability of Master data.
  • Involved in Info Cube maintenance i.e., Compression, Roll-up.
  • Designed various types of Queries and generated reports using BEx Analyzer.
  • Environments: SAP BI 7.0, SAP ECC 6.0.

Confidential, Singapore Jan 2007 - Mar 2007
Role: SAP BI Developer
Responsibilities

  • Reviewed system statistics and other measures to identify the need for aggregates, indexes, compression and other performance improvement techniques.
  • Responsible for compression and partition of certain cubes for enhanced performance.
  • Proposed archiving strategy for future based on Time characteristics.
  • Improved query performance and data load using OLAP cache.
  • Created Variables, Restricted Key figures, Calculated Key Figures, Filters in the BI Queries. Built code for specific User exit variables and replacement path variables to capture the requirement for Year-to-date, Quarter-to-date and Month-to-date.
  • Implemented the real time cubes, aggregation levels, CVCs, planning functions, fox formulas and planning sequences for IP applications.
  • Designed and developed process chains (RSPC) for transaction data loads with the help of info Packages.

Environments: SAP BI 7.0, SAP ECC 6.0.

Confidential, Saudi Arabia Jun 2005 - Dec 2006
Role: SAP BW Developer

Responsibilities

  • Design, Review & understanding of technical specification / functional specification.
  • Development of BW Objects as per the technical specification by adhering to Quality Standards.
  • Design and development of Freight Costs visibility reports in BW. This involved requirement analysis from the client, design of ODS, Cube, reports etc.
  • Created Transfer Structure, Communications Structure, Transfer Rules and Update Rules for Info Sources, ODS objects and Info Cubes.
  • Generated transactional Data sources and Master Data Info sources (Texts, Attributes).
  • Extensively worked on LIS in extracting master data and transaction data from SAP R/3 and loaded into SAP BW.
  • Created Multi providers and enhanced queries for optimal performance.
  • Created Info Packages and Info Package Groups and scheduled them in order to load Master Data and Transactional Data from SAP R/3 as well as Flat File Source Systems into BW.
  • By using the generic extraction tool extracted data from source system and also performed delta operations to meet client requirements.
  • Extensively worked on Query building, Structures, RKF, CKF and Variables using BEx Analyzer.

Environments: SAP BW 3.5, SAP R/3 4.7.

Confidential, India Jun 2004 - May 2005
Role: SAP ABAP Developer

Responsibilities

  • Developed an ALV report providing the information about sales order details for a particular sales document number and further navigates to the material master and sales order transactions when you select particular item fields.
  • Developed an ALV list which gives purchase order header and item details for a particular order number and date.
  • Developed a daily material receipt report, which gives detailed list about the goods receipt as per the plant details, storage location and movement type.
  • Developed application using Module Pool which gives sales order and customer details for a particular customer using controls with validations and search helps.
  • Developed an interface which will transfer the purchase order details from legacy system to SAP system by using the standard BAPI.
  • Generated a BDC program to migrate material details from legacy system to
  • SAP R/3.
  • Implemented a BADI enabling a value range checks for document type through create material transaction.
  • Implemented a function exit to Predefine Sold to Party for every order type and sales area values that has provided in sales order create transaction.
  • Modified standard layout set of MEDRUCK for purchase order as per the client specification.

Environments: SAP R/3 4.7.

EDUCATION
  • M.C.A in Computer Science

Hire Now