We provide IT Staff Augmentation Services!

Sap Bi Resume

Seattle, WA

Objective:

  • Over 10 years of IT experience, 10 years in SAP BI/BW, SAP R/3 with experience and expertise in back end modeling and front end development.
  • Involved in 9 Projects which includes Full life cycle implementations, upgrade from 3.X to 7.0, Enhancements and Post Production Support in the areas of SAP Financials (FI/CO), IS-Retail, AR, AP, AA, GL, HR and Logistics (MM, SD, PM) modules.

Experience Summary:

SAP BI IP Experience:

  • Working experience with Planning Modeler which includes Planning Sequences, Planning Functions, Aggregation levels, Input-ready queries, Planning Cubes, etc.
  • Working experience with Disaggregation, Data Slices, Character Relationships, Filters as part of planning modeler.
  • Developed several Classes for different complex planning functionalities with ABAP language.

SAP BW 3.x/7.0 Experience:

  • Analyzed the business requirements and translated into dimensional data models by using extended star schema techniques.
  • Experience with BI/BW components including InfoCubes, DSO’s (ODS), Multiproviders, Transformations, DTP’s, Infosources, Business content, Info objects among others.
  • Enhanced the Standard Business Content Infoproviders by adding new Info Objects to reflect modified R/3 Business Process.
  • Performed Data load management, worked also in Scheduling Process Chains of Events, Data source Enhancement, OLTP extraction data, Loading (Full /Delta Up-Load), Monitoring, Remote Cubes, MultiCubes, Data Mart and Open Hub Service.
  • Daily meetings have been setup with the end users for designing the reports and extensively trained the client on BI7.0 (NetWeaver 2004s) BEx Analyzer.
  • Extensively Worked on Reports like Dashboards and Scoreboards for high level Management.
  • Worked with UD connect to extract the data from Oracle.
  • Expertise in BW Performance Tuning: Experience in Performance tuning of Queries by maintaining Aggregates, BIA, Compression, partition, indexing of info cubes and use of statistics for the same. Extensively used variety of techniques to boost the performance of BEx Query.
  • Worked extensively on Calculated and Restricted Key figures, variables, workbooks, security roles and profiles.
  • Extraction, Transformation and Loading of Data (ETL) - Preparing SAP R/3 for defining the loading strategies, initial and delta data loads using IDOCs and PSA (TRFCs) loading, scheduling and monitoring data loads.
  • Customized the postproduction data model and generated Adhoc queries as per the specifications.
  • Gathered business requirements from Management and Users to design the overall layout.
  • Coordinated integration testing with process teams to validate data and seek end user acceptance.


SAP BW ABAP Experience:

  • Developed several Classes for providing solutions to the planning development..
  • Strong ABAP programming skills including customizing extractors, Function modules, writing Start routines, Transfer routine and Update routine.
Business Objects Experience:
  • Develop and fine tune universes based on BEX query and setting standards.
  • Worked extensively on BO Web Intelligence Version 4.0.
  • Created several WEBI reports using the BICS connectivity.
  • Created several OLAP connections for creating the WEBI reports.
  • Worked on BOBJ security, Connections, etc using the CMC.


SAP CRM 4.0 Experience :

  • Created several reports like Complaints aging, Daily counts, Days to resolve complaints, Follow-up Reports, etc.
  • Experience in maintaining master data for different levels of Business partners, products with good understanding of the CRM table relationship.


PROFESSIONAL EXPERIENCE:

1.

Client

Confidential,Seattle, WA.

Duration

Jan 2012 to Present

Role

SAP BI/BW Consultant

Environment

SAP BI 7.0, BOBJ 4.0, Xcelcius 4.0, SAP ECC 6.0.

Responsibilities:

  • Developed Info cubes, Multi cubes, ODS objects and extracted Master data and Transaction Based Data in FI AP, AR, AA, GL and COPA Modules.
  • Developed Complex Financial Comparative and Trend Reports to provide the variances between actual and budget by account for Netsales, S G & A, Operating Income, Fixed Cost, Labor, etc.
  • Developed Cost center based authorization object to provide data level security for the users accessing the report based on their departments.
  • Worked on Financial Extractors involving extraction of General Ledger Direct Line Items & Transaction Figures.
  • Created the Costing Based COPA data source, and extracted all the value fields data into the COPA Infoproviders.
  • Created several COPA reports based on the Cost Elements.
  • Developed and maintained queries with Restricted Key figures, Calculated Key figures, Selection, Formulas, Variables, Conditions and Exceptions.
  • Optimized the performance of the Data targets (InfoCube, ODS, MultiCube…) by Loading the Data through proper selection criteria and maintained the request for each data load to compress it in the future.
  • Developed several Reports based on FICO application area.
  • Actual/Plan Analysis by Cost Center
  • Reports on Assets by Cost Center
  • Cumulative comparable analysis of G/L Balance by selected Periods
  • Comparative analysis current year with prior year of GL Breakdown Periods
  • Developed various dashboards for providing a high level details on Monthly Financial, Plant Analysis and Profitability Analysis using Xcelcius 4.0.
  • Created several BOBJ WEBI reports by BICS connectivity using the CMC and InfoView.
  • Ran various S_ALR* reports for reconciling custom and standard BI reports.

2.

Client

Confidential,CA

Duration

Sep 2011 to Feb 2012

Role

SAP BI/BW Consultant

Environment

SAP BI 7.0, SAP ECC 6.0., BO 3.1

Responsibilities:

  • Worked on Data model, Design and Development related to Objective Setting and Appraisals and E-recruitment for NBCU.
  • Written Technical Specifications for both the Appraisals and E-rec.
  • Analyzed the possible use of BW Business content DSO’s such as Appraisal, Requisition status, etc. and developed these available standard reports in E-rec Business content to speed up the implementation
  • Developed Performance management, Time to fill, Open Requisition reports.
  • Performed enhancements for both the transactional and master datasources and written the ABAP logic for the enhancements in order to provide the data.
  • Created process chains and addressed several performance issues for the client on the existing system.
  • Worked on BO for developing the WEBI reports of Performance management, Erec Reports .

3.

Client

Confidential,Oregon

Duration

Nov 2010 to Sep 2011

Role

SAP MAP/BI IP Consultant

Environment

SAP BI 7.0, SAP ECC 6.0.

Responsibilities:

  • Implemented Merchandise Assortment Planning using IP(Integrated Planning) for Nike Retail system.
  • Used Planning Modeler for accomplishing the Planning functionalities.
  • Written Technical Specifications based out of Planning Functional Specifications for Nike Retail.
  • Implemented several Planning Functions, Planning Sequences, Aggregation Levels and different layouts for retrieving the Plan data for Nike Retail.
  • Created Web Planning Layouts in BI-IP using Input Ready Query and Web Application Designer.
  • Written several Classes for providing solutions to the planning development.
  • Created several Multiproviders, Planning Cubes(Realtime Cubes), Queries and Webtemplates for Planning.
  • Worked on BWA, in resolving several performance issues.
  • Worked on Disaggregation, Data Slices and Character Relationships as part of planning modeler.
  • Created several Seeding, Generation Combinations, Actualization and data load chains.

4.

Client

Confidential,LA, California

Duration

Sept 2010 to Nov 2010

Role

SAP BI Architect

Environment

SAP BI 7.0, SAP ECC 6.0.

Responsibilities:

  • Implemented Plant Maintenance at Sempra Energy Utilities by gathering the required Functional and Technical Specifications.
  • Activated PM data sources for Maintenance Notifications “2LIS_17_I0NOTIF”, Activities “2LIS_17_I0ACTY”, Cause “2LIS_17_I0CAUSE”, Item “2LIS_17_I0ITEM”.
  • Activated Standard BI cubes for PM Notifications “0PM_C09”, Orders “0PM_C04” and Measurement Result “0PM_C08”.
  • Worked extensively on maintaining the Master data for Functional Location, Equipment’s, Pipeline, Address for the field Equipment’s, etc.
  • Created several Exception, Master File Proof and Asset History Reports.
  • Conducted several User training sessions and testing sessions with the Users before going to Go-Live.
  • Performed Various Validations during the process of testing the Developed BI objects.
  • Written several ABAP Routines, Customer Exits to fulfill client’s reporting requirements.
  • Created Several Workbooks and worked extensively on Performance Tuning for the data loads and for increasing the query performance.
  • Worked extensively on various maintenance activities to increase the system performance, by doing Compression, PSA Deletion, Change-log deletion, etc.

5.

Client

Confidential,Georgia

Duration

Aug 2009 to Sep 2010

Role

SAP BI/BW Lead

Environment

SAP BW 3.1, SAP BI 7.1, SAP ECC 6.0.

Responsibilities:

  • Involved in Functional specifications and converting it to technical specifications for POS(Point of Sales) design.
  • Activated IS-Retail datasources “0RT_PA_TRAN_CONTROL”, “0RT_PA_TRAN_TOTALS” and “0RT_PA_TRAN_MOV_FIN” for getting POS data for store systems.
  • Created datatargets for “Totals Transaction” and also quarterly based datatargets for “Sales Transaction Details” to optimize the datavolume.
  • Involved in several meetings with the merchandising team and also with the SAP to get the requirements and fine tune the specifications.
  • Gathered several requirements for MAP regarding the Assortment Planning development and also worked on developing the Store Hierarchies, master data planning and Activating the Planning sequences.
  • Extensively worked on MM datasources “2LIS_03_BX”, “2LIS_03_BF”, “2LIS_03_UM”, to get inventory data.
  • Created several reports like “Sales Accountability”, “POS transactional detail”, “In stock Analysis by Article”, “Out of stock Report”, “Gift Card Differences”, etc.
  • Created Sales and Delivery, Billing InfoCubes for sales overview.
  • Developed ODS object to load SD Sales Order, Delivery note, Billing document Data from Business Content delivered Infosources, defined the update rules.
  • Created web templates for all these reports and published them at Federated Portal.
  • Implemented BIA to increase query performance to handle huge data volume.
  • Creation of alerts, and also using Macros. And also involved in extraction of data from R/3
  • Worked on BW Cube Development, Extensive Web reporting, BEx reporting experience with Macros and Excel functions Custom development. Automation of running reports.
  • Worked extensively on various maintenance activities to increase the system performance, by doing Compression, PSA Deletion, Change-log deletion, etc.
  • Created several reports like Complaints aging, Daily counts, Days to resolve complaints, Follow-up Reports, etc.
  • Activated CRM standard datasources for the data availability of Business Partner, Services, Marketing, etc.
  • Activated standard CRM. infoproviders like Service orders 0CSRV_C01, Compliants 0CSAL_C09, etc for accomplishing the clients requirement.
  • Upgraded BW system to SAP Net Weaver 7.1 from SAP BW 3.1 and also upgraded the SEM system from 3.2 versions to 6.0.
  • Checked for inactive Update & Transfer Rules and activated the same. All inactive and update rules which are not required were deleted.
  • Checked for inactive Info cubes and activated which are required and deleted which are not required.
  • Ensured that all delta queues are empty in SAP Source System.
  • Tested Integrated Planning by creating a scenario using real-time info cubes multiproviders and input-ready queries.
  • Tested the ETL process with new data flow using emulated data sources. Also tested the old dataflow for the data sources which are not emulated and cannot be uploaded using new data flow process i.e. Transformations and DTP (Data Transfer Process).
  • Closely worked with testing department for developing and implementing test scripts.
  • Performed Unit, Integrity tests and data consistency was verified with ECC 6.0
  • Upgraded both SEM BCS and BPS and also the entire front end objects.
  • Created Test Plans for all the queries and placed them in the HP quality Center.
  • Migrated all the queries, Workbooks and Webtemplates to BI 7.0.
  • Collected all the migrated queries and transported them to both QA and Production systems.
  • Validated data at all the levels after the completion of Upgrade.
  • Collected them and transported to Quality and Production systems.
  • Extensively trained the client on BI 7.0 Data Modeling which includes installing Business Content; creating InfoObjects, InfoCubes, DSO – Data Store Objects, Transformations, DTP – Data Transfer Process, Info Packages, DataSources, Process Chains, and Source Systems.

6.

Client

Confidential,New Jersey

Duration

May 2008 to Jun 2009

Role

SAP BI/BW Consultant

Environment

SAP BW 3.5, SAP ECC 5.0. Business Objects.

Responsibilities:

  • Configured and customized applications for HCM, SD and MM modules.
  • Worked HCM Standard Extraction from Business Content like Payroll(PY), Personnel Administration(PA), Organizational Management(OM), Benefits(BN) and Time Management(TM).
  • Worked extensively on LO-COCKPIT extractors. Installed relevant SAP business content. Used LO structures for extracting Purchase orders, delivery, billing information.
  • Designed ODS and Info cubes for FI-AP and FI-AR data.
  • Generated reports on purchase orders info to display the percentage variances between the quantities in the PO and the quantities actually delivered.
  • Created various data models, ODS and cubes based on business requirements and business transaction types like service ticket, complaint and follow-ups.
  • Involved in performance enhancement features such as cube partitioning, Indexing, maintaining aggregates and compression.
  • Worked with generic extraction to extract data for Initial and Delta load data from SAP R/3 source system to BW.
  • Worked on DB connect to extract the data from Oracle and written ABAP code for writing the data directly to the DSO.
  • Gathered information regarding the business requirements from Management and Users to design the overall layout.Created iViews, HTML views in Visual Composer and integrating with SAP Enterprise Portal. Involved in various kinds of User Acceptance Testing on new developments and performance testing.
  • Enhanced the Info Cubes by adding custom Info Objects as per user requirement.
  • Created Transfer/Communication Structures, Transfer rules and Update rules for ODS and InfoCubes.
  • Extensively Worked on Reports like Dashboards
  • Created reports on Business Objects.
  • Created Universes and worked with the client to gather the requirement for created the Dashboards on Business Objects.
  • Loaded Master data (attributes, texts, hierarchies) from flat files to the InfoObject.
  • Created reports using Business Objects.

7.

Client

Confidential,Novato, CA

Duration

Jun 2007 to Apr 2008

Role

SAP BI/BW Consultant

Environment

SAP BI 7.0, SAP ECC 6.0.

Responsibilities:

  • Identified the necessary Business Content using content browser and content analyzer, mapped the business process requirements with the available Business content. Installed and activated the relevant Business content for master data and transactional data.
  • Implemented standard Business Content FI-GL FI-AP and COPA cubes for transaction figures reports.
  • Prepared Technical specifications for the Functional Specifications.
  • Implemented the data extraction process on BI 7.0 that includes installation of the Business content, creating data transfer processes (DTP) using the new BI 7.0 features.
  • Worked on ABAP Routines, User exits & Customer exits.
  • Written ABAP User exit for customizing the standard BI 0FI_GL_10 datasource.
  • Designed and implemented a custom extractor to extract FI tables from R/3 into BW.
  • Using BEx Query Designer (new layout, Exception Aggregation) 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, BIAccelerator, Web Application Designer and implementing BEx Queries, Variables and Workbooks.
  • Worked extensively on modifying the web templates in WAD using HTML, XHTML, and other web technologies.
  • Worked on dashboards using SAP Enterprise Portal.
  • Involved to an extent with concepts of Aggregation Levels, Filters, BEx Query, Workbooks, BI variables, WAD and Characteristic Relationships
  • Provided input, recommendations, and resolutions for technical issues.
  • Transport Organizer – maintained transport throughout BI landscape.
  • Created Queries for both FIGL and BCS cubes.
  • Written the User exit for populating the data for the fields, which have been appended to the extract structure.
  • Created Different Rule Groups for the Transformations.
  • Written ABAP Program for the Customer Exit Variable for calculating “Year To Date” value with the help of the user entry variables.
  • Worked with UD connect to extract the data from Oracle.
  • Loaded data for Master Data objects (Attributes, Texts and Hierarchies).
  • Created Process chains and Meta Chains for loading Master data and also for loading Transactional Data.
  • Involved in performance tuning by maintaining aggregates, compression, partitioning, indexing of info cubes.
  • Created queries in the BEx and also created variables, text variables, structures, calculated key figures, restricted key figures, exceptions, conditions and RRI features.
  • Designed the Workbooks for all the queries as per the USER requirement.
  • Daily meetings have been setup with the end users for designing the reports and extensively trained the client on BI7.0 BEx Analyzer.
  • Created Open Hubs and performed the process of retraction to get the data back.
  • Extracted Hyperion data through the Open Hubs for the reconciliation.
  • Worked extensively on the Copy Transports.

Education:

  • Bachelor of Engineering in Computer Science.

TECHNICAL SKILLS:

SAP BI/BW Versions:

BI 7.0, BW 3.5, 3.1C, 3.0B, 3.0A, 2.1C, 2.0B.

ERP:

ECC 6.0,ECC 5.0, 4.7, 4.6C,

Front ends:

BEx Analyzer, Web Application Designer

Languages:

ABAP/4, JAVA, SQL, PL/SQL

Operating systems:

UNIX, Windows95/98/2000/NT, XP

Scripting Languages :

JavaScript, HTML, DHTML

Hire Now