We provide IT Staff Augmentation Services!

Business Process Consultant Resume

SUMMARY:

  • Over 12+ years of IT experience with 10+ years in SAP BW/BI with excellent team leading skills and having very good exposure to SAP HANA, SAP BO, SAP ABAP and SAP SEM - BPS
  • SAP certified in SAP BW & SAP Business Objects Web Intelligence 4.0 and SAP HANA
  • Information Technology Infrastructure Library (ITIL) certified
  • Worked on three life cycle implementations of SAP BW using SAP ASAP methodology right from requirements gathering, design, development, performance tuning, testing, documentation and end-user
  • Experience in SAP BW HANA modeling and optimization scenarios and extensive knowledge on SAP BW 7.4 functionaries
  • Work experience in different kinds of projects like Implementation, Upgrade(BW 3.5 to BI 7.0, BW 7.3 ) and Production Support Projects in SAP BI 7.4, BI 7.0, BW 3.5, 3.1C
  • Strong on End-to-End BW Configurations and Customizations from ETL process -Extraction, Staging, Loading, Performance, Transports, and Reporting.
  • Hands on Experience and Technical Proficiency in Data Extraction, Generic Extraction, Data Loading, Data Modeling, ODS/DSO Object, Info Cube, Multi-Providers, SPO, BEx Analyzer, BEx Browser and BEx WAD.
  • Excellent work experience in LOs (Logistics) Extractors for applications in SD and MM areas &Business Content DS of FI/CO Applications.
  • Extensive experience in extracting data from SAP R/3 (OLTP systems), SAP CRM, SAP SRM and external systems like Flat Files and non-ECC data sources
  • Good experience on COPA extraction of CO Module
  • Created customized InfoCubes, MultiProviders, Infosets and ods/DSO objects, Info Source, Transformations, DTPs, Handling Loading Errors, and Mapping Errors.
  • Enhanced the Business Content for Data Modeling in Purchasing, Inventory, Sales, CRM and Utilities Applications.
  • Worked extensively in BEx Analyzer and Query designer in building Queries and saving in Workbooks (Excel work sheets) and created Custom Queries using Conditions, Exceptions, and Variables & Structures and created Aggregates for frequently used queries.
  • Expert in building Web Reports and Dash boards using BEx WAD Designer and BO tools.
  • Good experience of Post production activities like Monitoring loads, Process Chains and Performance Tuning techniques.
  • Expert in Transportation of Objects across landscapes.
  • Good experience in Open Hub Service using InfoSpoke, Information Broadcasting and Analysis Process Designers (APD).
  • Published BW/ BI reports into SAP enterprise portals.
  • Very good experience in Business Flows of Material Management (MM), Sales and Distribution (SD), FI (Finance)/ CO (Controlling), IS U (Utilities) and SAP CRM applications.
  • Have experience in ABAP to write custom codes for transformations, enhancing DataSources and custom variables for reports using CMOD User exits.
  • Strong experience in Upgrade of SAP BW 3.5 to BI 7.0(NetWeaver 2004s) which involves migration of 3.x to 7.0 datasource, creating transformations, DTPs etc…
  • Exposure in SAP-SEM (BPS): Transactional Cube design, Planning Area, Planning Levels, Planning Packages, Planning folders, Manual Planning Function, User Defined and Predefined Planning Function, FOX formula extension.
  • Trained in ETL tool Informatica PowerCenter 8.x Level I Developer.
  • Trained in SAP HANA and Hadoop.

TECHNICAL SKILLS:

ERP: SAP BW, SAP HANA, SAP R/3(ABAP/4), SAP SEM (BPS)

Reporting Skills: SAP BEx, SAP WAD, SAP BO

Operating Skills: WINDOWS'95/98/NT

Languages: SAP ABAP/4, PL/SQL

Internet Technologies: HTML, DHTML, JAVA SCRIPT, VB SCRIPT, ASP, JSP eXtensible Markup Language (XML).

Java Technologies: Java 2SDKJava 2 SDK EEEnterprise Java Beans

GUI Skills: SAP GUI.

Database: ORACLE 8i

MS SQL: SERVER.

Technical Background: SAP BW Certified from SAP with ID 0004211038 , SAP Business Objects Web Intelligence 4.0, SAP HANA Certified (ID 01076902)

Informatica: Power Center 8.x Level I Developer

PROFESSIONAL EXPERIENCE:

Confidential

Environment: SAP BW 7.3, ECC 6.0, SAP HANA, SAP BO

Business Process Consultant

Responsibilities:

  • Lead the SAP BW/BI team for Confidential ‘BI Report Factory’ (Development of Reports using WAD and Query Designer tools).
  • Delivered the Confidential Finance & PRM Analytics reports, GSIM and T&E Projects.
  • Converted the FS requirements into Technical Specifications.
  • Responsible for the delivery of objects from entire realization phase till goLIve.
  • Worked on SAP BW 7.4 objects and HANA based information models and followed LSA 2.0 and extensively worked on HANA enabled InfoCubes and DSO
  • Worked on SAP BO WebI reports.
  • Worked on SAP HANA models
  • Handled the Tickets during the testing phase of the reports
  • Having the daily calls with the onsite Confidential team to discuss on the status of the deliverables.

Confidential

Environment: SAP BI 7.0, SAP ECC 6.0

SAP BW Project Lead Consultant

Responsibilities:

  • Led the SAP BW offshore team to support ERV AMS activities in the BW area.
  • Resolved the tickets with high priority.
  • Needed to play the Project Lead role for the onsite Oil & Gas Client in Norway.

Confidential

Environment: SAP BI 7.0, SAP ECC 6.0 SAP CRM 5.0

Business Areas: CRM, FI-CO, HR

Sr.SAP BW Lead Consultant

Responsibilities:

  • Leading the SAP BW offshore team to deliver the ESAP release 1.1 objects.
  • Having status calls with onsite BW team to keep track of object status and updates by using the tools like PM SMART and APSE(Axon Program Standards of Execution).
  • Involved in designing the RDDs (Report Design Documents) with the new reporting requirements by converting the business logic into BW solution and mapping the source system definitions into BW.
  • Performed the BW Data Modeling Analysis on the existing BW InfoCubes of the Release 1.0 by using programs /SSA/BWT, SAP INFOCUBE DESIGNS and table RSRCUBE.
  • Delivered the Confidential Direct and In-direct Business Analysis on the current data by classifying the business data across Sales Org, Distribution Channel and Division / Purchasing Org, Plant
  • Involved in Z-filed Analysis for the existing CRM data sources like 0CRM SRV CONFIRM H, 0CRM SRV CONFIRM I, 0CRM SRV PROCESS H, 0CRM SRV PROCESS I, 0CRM SALES ORDER I(CRM Sales Order Item).
  • Involved in delivering the BW Phase -1 and Phase 2 objects as per the scheduled time lines.
  • Delivered the BW CRM-CSO(Customer Service Organization) reports and database objects which based on Service Process and Service Confirmation data flows inSAP CRM area.
  • Involved in developing the solutions for Finance-GTR reports using Asset Accounting (AA), New GL14, Cost Center Accounting (CCA) and CO-PA data flows.
  • Performed QC10 steps for the BW back end and frond end reporting objects.
  • Managed and handled BW Defects through MQC during Integration testing and regression test phases.
  • Used RRI techniques for some of the CRM reports.

Confidential, Medford, OR

Environment: SAP BI 7.0, SAP ECC 6.0

Business Areas: MM, IM, PP, FI

Sr.SAP BW Lead Consultant

Responsibilities:

  • Involved in Full Life cycle Implementation of integrating the functional areas MM, PP and FI with BW. Responsible for Design of data models, comparing the model with delivered contents and implementing the business logic with delivered contents along with modifications.
  • Involved in implementing the data flows of inventory management DataSource2LIS 03 BF (Goods Movements from Inventory Management), Purchasing Data (Schedule Line Level) DataSource2LIS 02 SCL, Production Orders: 2LIS 04 P MATNR (Material View from PP/PP-PI), 2LIS 04 P COMP (Component View from PP/PP-PI) etc…using the LO Cockpit.
  • Performed Statistical Setup for Purchase, Inventory Management (Non-Cumulative method) and extracted the data to BW.
  • Used “Queued Delta” method to extract the delta records of MM application.
  • Activated Purchase and Inventory Infocubes and DSO objects from the Business Content and customized according to business needs.
  • Implemented the dataflow for the G/L Details by activating the DataSource0FI GL 4(General Ledger: Line Items).
  • Activated the Business Content master data sources for 0VENDOR ATTR (Vendor Number), 0MATERIAL ATTR (Material Number).
  • Developed Generic Data Sources using RS02 for the Batch materials, data source for shelf life expiration by using views from the base tables MARD, MARA, MCH1.
  • Created transformation, DTPs for the above dataflows.
  • Developed Open Hub destinations to send the BI data to MS Sequel Sever for further reporting.
  • Created process chains for the above dataflows and also created PC for purging the PSA requests periodically.
  • Enhanced the purchasing dataflow (2LIS 02 SCL) with the new fields for PO Address details and enhanced the ABAP code to populate the data for the new fields using CMOD user exits.
  • Participated in SAP BI system refreshes.
  • Resolved multiple issues related to 0BATCH loads by using error DTPs and using RSKC transaction to allow extra permitted characteristics.
  • Resolved data inconsistency issues related to ‘production-order’ dataflows which involved the datasource2LIS 04 P MATNR.
  • Created Open Hubs for the purchasing and inventory DSOs.
  • Worked on information broadcasting to broadcast the reports through emails.
  • Extensively worked onBEx Query designer to create Purchasing reports.
  • Post Production support, which involves daily monitoring of data loads via process chains, trouble shooting and correcting the known errors and escalating the unknown to the SAP support team

Confidential, TN

Environment: SAP BI 7.0, SAP ECC 6.0

Business Areas: IS-U, FICA, FI

SAP BW Lead Consultant

Responsibilities:

  • Led the Deloitte SAP BI team to support the clients like Confidential, NNWW and Confidential .
  • Worked on Utility dataflows like Open Items(0FC OP 01),Cleared items(0FC CI 01), Sales Statistics(0UC SALES STATS 02 and FIGL etc…
  • Ran the transactions for FPBW and FPCIBW mass activities at R/3 for open items and, cleared items extracts monthly or weekly based on client requirements.
  • Loaded data to open and cleared items InfoCubes based on run date and run identification.
  • Worked on some enhancements for the standard extractors 0FC OP 01 and 0FC CI 01 for open and cleared Items dataflows like adding sub G/L account field(HKONT) and worked on CMOD for the code changes to populate the new data fore the enhanced fields.
  • Worked extensively on Sale Statistics datasource(0UC SALES STATS 02) to fix the missing data for certain posting periods using the tcodeEBW DQ SSat R/3.
  • Fixed the GL Details for missing posting periods which invloves the DataSource 0FI GL 4(General Ledger: Line Items).
  • Involved in QA refresh activities: Ran tcodeBDLS to convert the source system changes etc., checked the RFC connections and did all the BW tasks to refresh data.
  • Extensively worked on Transports using the transactions SE01, SE09andSTMS.
  • Activated and made use of Technical content in BI system (SAPBI statistics) to gather the statistics required for performance analysis.
  • Created and maintained aggregates, rollup of data using process chains, after the successful extraction of transaction data and compressed the Infocubes as part Performance Tunning of the BI system.
  • Developed TVA reports using BEx query designer extensively.
  • Created workbooks by including a set of BEx reports.
  • Developed Web reports corresponding to BEx queries using BEx WAD tool.
  • Developed executive dashboards which consist of pie charts, graphs and tables.
  • Published BEx reports in SAP portal.
  • Used Information broadcasting to send reports though emails.
  • As a part of upgrading SAP ECC 6.0, supported BI system activities like running BDLS to change the old source system to new source system, taking care of delta Q’s and scheduling the batch jobs and maintaining the Process chains after ECC upgrade.(ECC 6.0 Post upgrade steps)
  • Provided on-going BI monitoring support such as troubleshooting and resolving issues using the transaction RSPC and RSMO.

Confidential, VA

Environment: SAP BI 7.0, SAP BW 3.5, SAP R/3 4.7E

Business Areas: FI, IS U, FICA

SAP BW Lead Consultant

Responsibilities:

  • Developed the strategy for the Upgrade project from BW 3.5 to BI 7.0
  • Prepared the project plan for BI which involved the time lines and BI tasks.
  • Involved in Migrating the classical 3.x Datasource to 7.0 Datasource for IS U and FI area for both master data and transactional data.
  • Migrated the transactional datasources: Open Items(0FC OP 01),Cleared items(0FC CI 01), Sales Statistics(0UC SALES STATS 02 and 0FI GL 4(General Ledger: Line Items).
  • Migrated the master data sources for the objects like Business Partner, Premise, Contact Number, Contract, Connection object etc.
  • Used the new Transformation process in place of old Transfer and updated rules and created DTPs for the data targets according to the requirement.
  • Modified the update routines and start routines using ABAP objects especially for the 0BUSINESS PARTNER and Sales Statistics dataflows.
  • Resolved migration issues with the help of SAP OSS support.
  • Included the newly created DTPs in the Process Chain for the automatic scheduling of data loads.
  • Migrated all the BEx 3.5 reports into BI 7.0 reports.
  • Worked on migrating work book which contains about 15 reports.
  • Worked on migrating the Exception aggregation settings for the calculated KeyFigures to BI 7.0 version.

Confidential, Bartlesville, OK

Environment: SAP BI 7.0, SAP R/3 4.7E

Business Areas: MM, SD

Sr. SAP BW Consultant

Responsibilities:

  • As a BI Consultant, I supported this client on their enhancements in BI..
  • Involved in creating new Application Process Designers (APD) to export data from BI to csv files.
  • Inserted the new APD in process chains.
  • Created new DSO objects, transformations and DTPs for the new dataflows.
  • Enhancedcouple of dataflows with new navigational attributes.
  • Prepared documentation.

Confidential, FL

Environment: SAP BW 3.5, SAP R/3 4.6 C

Business Areas: IS U, FICA, FI

Sr. SAP BW Consultant

Responsibilities:

  • Monitoring the SAP BW PC loads daily using the transaction RSPC and RSMO.
  • If any issue comes up with the data loads, we need to investigate the issue and fix it accordingly.
  • Based on the Deloitte Edge Tickets which are assigned under my name, I need to look into the ticket issue and need to resolve according to priority level.
  • I need to update the status of each ticket in Deloitte Edge Portal.
  • Worked on Utility data flows like Open Items, Cleared items, Sales Statistics etc…
  • Run the transactions FPBW and FPCIBW at R/3 for open items and cleared items extracts monthly or weekly based on client requirements.
  • Loaded data to Open and Cleared items InfoCubes based on Run Date and Run Identification.
  • Worked on some enhancements to the existing dataflows for Open and Cleared Items dataflows like adding Sub G/L Account field.
  • Worked with the standard extractors 0FC OP 01 and 0FC CI 01.
  • Involved in QA refresh activities.
  • Extensively worked on Transports using the transactions SE09 and STMS.
  • Updated the status of transport request in e-Rooms of Deloitte.

Confidential

Environment: SAP BW 3.5, SAP R/3 4.7E

Business Areas: MM, SD, FICO

SAP BW Consultant

Responsibilities:

  • Involved in implementing Manage Purchasing application in MM,Customer Support Sales - Transaction data flow in SD and Cost Center Accounting(CCA)reporting in CO area.
  • Extensively worked on LO cockpit for the Purchasing Application which involved the Data Sources like 2LIS 02 HDR, 2LIS 02 ITEM and 2LIS 02 SCL and Customer Support Sales - Transaction data flow application which involved the Data Sources like 2LIS 11 VAHDR, 2LIS 11 VAITM for Sales; 2LIS 12 VCHDR, 2LIS 12 VCITM for Delivery; and 2LIS 13 VDHDR, 2LIS 13 VDITM for Billing.
  • Filled the set up tables using the tcode OLI*BW for the applications like Purchasing, Sales Order, Delivery and Billing Document in Sales and Distribution.
  • Activated the Business Content Data Sources 0CO OM CCA 9 (Actual costs) & 0CO OM CCA 10( Commitment line items).
  • Generated Data Sources (Generic) for Master Data, Text and Transaction Data using the transaction RSO2.
  • Enhanced master data DataSource 0VENDOR ATTR with customized fields and populated data using ABAP code in EXIT SAPLRSAP 001 of CMOD enhancements.
  • Involved in extracting data from SAPSRM systems for Shopping cart information (0BBP SC TD 1) and providing text data to EBP user using Generic Text DataSource.
  • Responsible for configuring Info Objects, ODS objects, Info Cubes, Info Set and Multi- Providers for Purchasing data and Sales Overview applications
  • Involved in mapping of data source to info source with Transfer Rules in SAP BW.
  • Involved in mapping of info source with the Data Targets using Update Rules.
  • Loaded Data into the ODS Object before transporting the data into the IC.
  • Involved in Creation of ODS Objects and also worked with various options, which involves activating data in ODS, deleting data in change log and also updating the data in ODS to subsequent data targets.
  • Created Info Packages and Scheduling the data into the Data Targets.
  • Uploaded Transaction Data from the Flat File as the Source System.
  • Involved in Performance tuning aspects of Info Cube maintenance i.e., Compression, Roll-up.
  • Involved in developing KPI Reports for Purchasing application using BEx Analyzer &BEx Browser.
  • Developed flexible queries using Filters, Free Characteristics, Navigational attributes in BEX analyzer to facilitate data analysis in a drill down version to enable the easy access of information at various levels.
  • Involved in Creation of Reports such that the execution time is evenly distributed throughout the Report using Restricted Key Figures, Calculated Key Figures, Variables, Exceptions & Conditions and Structures.
  • Used RRI concept whenever it is required as per the Technical Specifications.
  • Extensively worked on BExWADfor creating Web Reports using Web Templates of type Limited Analytical, Drilldown and Full Analytical Web Templates.
  • Worked on Information Broadcasting to distribute Web Reports through different channels like E-mails and SAP Portals

Confidential, IN

Environment: SAP BW 3.1C, SAP R/3 4.6C

Business Areas: FI, SD, MM.

SAP BW Consultant

Responsibilities:

  • Understanding the specifications provided by the functional consultants, interacting with team to get to know the exact requirements, suggest them the changes where required and then develop the objects as per the evolved specifications.
  • Developed flexible queries using Filters, Free Characteristics, Navigational attributes in BEx analyzer to facilitate data analysis in a drill down version to enable the easy access of information at various levels.
  • Involved in Creation of Reports such that the execution time is evenly distributed throughout the Report using Restricted Key Figures, Calculated Key Figures, Variables, Exceptions & Conditions and Structures.
  • Changing of existing queries suiting the ad-hoc requirement of the client from time to time.
  • Activated and made use of Technical content in BW system to gather the statistics required for performance analysis.
  • Created and maintained aggregates, rollup of data using process chains, after the successful extraction of transaction data.
  • Transport of objects from Development to Testing and Production systems using CTS and Error correction during import.
  • Extensively worked on the Administrative Workbench for Configuring, Scheduling and Monitoring functions and worked on investigating the load failure issues and resolving them accordingly.
  • Post Production support, which involves daily monitoring of data loads via process chains, trouble shooting and correcting the known errors and escalating the unknown to the SAP support team

Hire Now