Data Sap
Resume:
DOSAPATI SUMAN
Sr. SAP BI/BW CONSULTANT
*****.********@*****.***
Ph: 614-***-****
SUMMARY:
. Over 8 years of experience in SAP BI/BW and completed two SAP full
lifecycle implementations, gaining experience in gathering business
requirements, Gap analysis, Asap methodology, blueprinting, prototyping
with users, detailed design, hands-on configuration, system test
planning, system test execution, UAT - User Acceptance Test planning and
execution, super user training, Go-live or cutover planning, and support.
. Worked in two SAP BW/BI full life cycle implementations, as well as
upgrades. Analyzed feasibility study for NW 2004s BI for Upgrade and
creating Production Support environment.
. Worked on Blue Print, Data Modeling, Designing, Documentation,
Development to till Go Live and Support.
. Extensive experience and expertise in SAP BI/BW Extraction (Generic
/Standard), Modeling and Reporting (i.e. Back-end and Front-end). Good at
implementing SAP BW with different SAP data source.
. Strong in Configuration of Data targets, Datasources, Info objects,
Keyfigures and Multiproviders
. Configuration of Transfer Structure, Transfer Rules, Start routines,
Transfer routines, Update routines and End Routines.
. Extensively worked on Process Chains, Data source Enhancement, OLTP data
extraction, Loading (Full /Delta Up-Load), Monitoring, Data Mart and
Open Hub Service, Performance Tuning, Aggregates, BW Transports, RSRT,
Query tuning, Building aggregates, Indexing.
. Extensively worked on OLTP extractions using LO Cockpit, CO-PA, FI,
generic datasource customization, master data, and Customer defined
tables (z-tables) extraction.
. Extensive experience in Multi-Dimensional Data Modeling, Extended Star-
Schema, Data Flow Strategy.
. Proficiency in Performance Tuning using Rollups, Partition, Compression
and ticket resolution.
. Wrote various ABAP queries for field's selection, data modification and
updating to targets.
. Expert in SAP BI Business Explorer and SAP BI Web Application Designer.
Worked on SAP Business objects including Universe Design, Web
Intelligence, Crystal Reports and Xcelsius.
. Experienced with providing users with access to data by building reports
and queries using tools including SAP BW BEx Query Designer/Analyzer,
Crystal Reports and Business Objects Web Intelligence.
. Expertise in front-end Business Warehouse (Bex Suite) components for
Queries, workbooks, Calculated Key Figures, Restricted Key Figures,
Structures, Customer Exits, Variables, Exceptions, Conditions, RRI.
. Development experience of Extractors, InfoObjects, InfoSources, ODS
Objects, Basic InfoCubes, Transactional InfoCubes, InfoPackages, Volume
sizing estimates and establishing Dataclasses, Roles and Authorizations,
Infospokes.
. Strong on End-to-End SAP BW Configurations and Customizations from
Extraction.
. Served as liaison between application development team and technical
operations staff.
. Excellent communication and presentation skills. Reputed for dedicated
teamwork, solid work ethics and Commitment to achieving various Goals
and key objectives. Good academic performance, analytical, and
problem-solving skills
. Knowledge on BODS and SAP HANA.
Other Expertise:
. Focused on reuse, granularity, modularity, compos ability,
componentization and interoperability or applications and technologies.
. Communicate effectively with client, project management and team members.
. Experience in technical and functional upgrade.
. Deep understanding and adhered to standards and compliance requirements
(both common and industry-specific). Strong understanding of BI tools,
procedures and principles.
. Serviced identification and categorization, provisioning and delivery,
and monitoring and tracking
. Strong proficiency in both principles and execution of data modeling and
solution architecting
TECHNICAL SKILLS:
SAP SAP Net weaver 2004s BI 7.3/7.0, SAP BW
(3.5/3.1C/3.0B), SAP BOBJ/BO (XI 3.1/R2/6.5), SAP ECC
(6/5), SAP R/3 (4.7/4.6C/4.6B/4.5B), BI Integration
with SCM/APO, HR, and CRM, Reporting
Operating Windows 95/98/2k/XP/Vista/7
Systems
RDBMS Oracle10/9/8.x, MS SQL Server 2000, MS Access
Tools & ABAP/4, SQL, IDOC, RFC's, DBconnect
Utilities
Web Technologies HTML, XML, ASP, JavaScript, VBScript, Servlets
PROFESSIONAL EXPERIENCE:
Client: Adobe/ San Jose, CA
Aug'14-Till
Date
Role: Sr. SAP BI/BW Consultant
Responsibilities:
. Played key role in Project Blueprint/Realization/GO-LIVE/Sustain phases
of SAP BW.
. Lead as f-functional consultant to delivery and qualify SAP BI/BW
definition and requirements, gap analysis, technical design
build/development, testing and roll-out. Implemented SAP BW with
different SAP data source.
. Extensively used ABAP Routines to modify/update data and develop reports.
. Identified the extractors on the R/3 OLTP systems and defined the
Transfer structures on the source and target systems. Created BW
components like Queries, workbooks, Calculated Key Figures, Restricted
Key Figures, Structures, Variables, Exceptions, Conditions, R/RI.
. Extensively involved in scheduling BWA on cubes and monitoring the BWA.
. Created Attribute, Analytical, Calculation views on structure in SAP HANA
modeler.
. Extracted Cost Center hierarchy & Cost Element hierarchy into BW using
respective data sources 0COSTCENTER_0101_HIER & 0COSTELMNT_0102_HIER.
. Performed LO-Cockpit extraction to pull data from R3 SD modules into BW
system extracting 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.
. Experience organizing process chains with transaction RSPC and analyzed
process chain load for optimal performance issues and updates for
necessary automation process requirement.
. Worked as CRM Techno-functional consultant to develop reports like
"Activity Monitoring Report", "Opportunity Monitoring Report", "Territory
Monitoring Report" etc.
. Used SAP BW for DataStage to extract, transform and load (ETL) the data
from various data sources FI/CO, SD, MM, and HR including the legacy
systems and developed reports.
. Active participant in full-cycle implementation of SAP BW and BOBJ (from
project planning to go-live and post go-live support).
. Experience Bursting of dashboards data source to deliver personalized
dashboard with embedded offline viewing, linking of two reports for
Passing parameters and flash variables.
. Experience implementing break/fixes, report enhancements, debugging,
troubleshooting and performance tuning (load failures/deadlocks) various
complex issues.
. Thorough knowledge of Security permissions, authorization objects, and
roles within SAP BW and BOBJ, including SAP Authentication.
. Experienced with providing users with access to data by building reports
and queries using tools including SAP BW BEx Query Designer/Analyzer.
. Experienced with enterprise-wide data modeling, database design, and
building data structures and data mapping routines in SAP BW to support
the data and reporting requirements for all areas of the organization.
Environment: SAP Net weaver 2004s BI 7.3 Ehp1/7, FI, SD, SAP BOBJ/BO (XI
3.1/4.0/R2/6.5), ABAP/4,ECC 6.0, Oracle, Business Explorer, SAP HANA
Modeler 1.0, SAP Design Studio 1.0
Client: Vivint/ Provo, Utah
July'12-July' 14
Role: Sr. SAP BI/BW Consultant
Responsibilities:
. Played key role in Project Blueprint/Realization/GO-LIVE/Sustain phases
of SAP BW -SAP BOBJ development project.
. Lead as f-functional consultant to delivery and qualify SAP BI/BW
definition and requirements, gap analysis, technical design
build/development, testing and roll-out. Implemented SAP BW with
different SAP data source.
. Generated several Consolidated (BCS) financial statements to accommodate
different accounting principles. Used the consolidation monitor to
execute the consolidation tasks and to monitor the entire consolidation
process.
. Extensively used SQL, PLSQL and ABAP Routines to modify/update data and
develop reports.
. Identified the extractors on the R/3 OLTP systems and defined the
Transfer structures on the source and target systems. Created BW
components like Queries, workbooks, Calculated Key Figures, Restricted
Key Figures, Structures, Variables, Exceptions, Conditions, R/RI.
. Created reports Finance "Days Overdue analysis", "FX Monthly", "FX Global
Exposure", "Payment History by Document Type" and "DSO Analysis by
Period" reports.
. Experience in creating Multi currency, Balance Sheet analysis, Profit &
loss and cash flow statements.
. Activated profit center accounting cubes (0PCA_C01, 0PCA_C02), accounts
payable cubes (0FIAP_C02, 0FIAP_C03), accounts receivable cubes
(0FIAR_C02, 0FIAR_C03) Sale cubes (0SD_C01, 0SD_C02, 0SD_C03, 0SD_C05)
from Business Content.
. Generated Cost Center "Plan/Actual" report which provides an overview of
the situation of primary and secondary costs and "Internal Order" report
to provide an overview of the actual and planned costs incurred during
reporting time frame on certain internal orders.
. Extracted Cost center statistical key figure actual for headcount into
0CCA_C03 InfoCube from data source 0CO_OM_CCA_3.
. Experience organizing process chains with transaction RSPC and analyzed
process chain load for optimal performance issues and updates for
necessary automation process requirement.
. Worked as CRM Techno-functional consultant to develop reports like
"Activity Monitoring Report", "Opportunity Monitoring Report", "Territory
Monitoring Report" etc.
. Used SAP BW for DataStage to extract, transform and load (ETL) the data
from various data sources FI/CO, SD, MM, and HR including the legacy
systems and developed reports.
. Active participant in full-cycle implementation of SAP BW and BOBJ (from
project planning to go-live and post go-live support).
. Experience Bursting of dashboards data source to deliver personalized
dashboard with embedded offline viewing, linking of two reports for
Passing parameters and flash variables.
. Experience implementing break/fixes, report enhancements, debugging,
troubleshooting and performance tuning (load failures/deadlocks) various
complex issues.
. Thorough knowledge of Security permissions, authorization objects, and
roles within SAP BW and BOBJ, including SAP Authentication.
. Experience in Unit testing, system testing, integration testing and
performance testing. Hands-on development experience with Business
Objects WebI, Universe Designer, Live Office, Query as a Web Service
(QaaWS), Lifecycle Manager, and Xcelsius.
. Experienced with providing users with access to data by building reports
and queries using tools including SAP BW BEx Query Designer/Analyzer,
Visual Composer, Crystal Reports, Business Objects Web Intelligence,
reporting with MDX integration and/or other enterprise reporting tools.
. Experienced with enterprise-wide data modeling, database design, and
building data structures and data mapping routines in SAP BW to support
the data and reporting requirements for all areas of the organization.
Environment: SAP Net weaver 2004s BI 7.1 Ehp1/7, FI, SD, SAP BOBJ/BO (XI
3.1/4.0/R2/6.5), Visual Composer, ABAP/4,ECC 6.0, Oracle, Cognos,
Informatica, Business Explorer, BCS, BPC, Crystal Reports.
Client: BASF/ Atlantic, New Jersey
June'10-May'12
Role: SAP BW/BI Consultant
Responsibilities:
. Involved in the Blueprinting phase, Gathering business requirements,
analyzing existing SAP system and other interfaced systems and
participated in the ETL architecture of Finance and Controlling modules
using BI Administration workbench.
. Involved in Full life cycle implementation of BW BPS involves
transitioning from BW-BPS to BI- IP.
. Worked extensively on FI-CO, SD, HR, COPA. Loaded the data from ECC to BI
and used initialization with delta update and full update methods. Used
SAP BW for DataStage to extract, transform and load (ETL) the data from
various data sources HR,PP, SD, and FI .
. Key person to maintain/manage and code User Exit programs for CRM
Services, Activities and Opportunity Management and Logistics.
. Worked on CRM-BI IP integration to load data in to planned and Actual
cubes.
. Developed data model for Actual and planned data with CRM-BI IP for
report requirement of target Customer sales.
. Extensively worked for BW-CRM integration area like Services, Survey
Confirmations, IBase, Activities, Opportunity management and ECC
Logistics and FI.
. Worked as CRM Techno-functional role for data sources like
0CRM_SRV_PROCESS_H, 0CRM_SRV_PROCESS_I, 0CRM_OPPT_H, 0CRM_OPPT_I and with
ECC data sources like 0FI_AP_4, 2LIS_02_HDR, 2LIS_02_ITM, 2LIS_13_VDITM
and its corresponding DSOs and Cubes.
. Created second level DSOs on top of 0CRM_OPPH, 0CRM_CNFI, 0CRM_PROH,
0CRM_PROI and created End Routines to do look ups on different master
data objects to make the data in linear line.
. Written Implementations for BADIs like CRM_BWA_MFLOW to fill data in to
enhanced fields to improve performance of data loads.
. Enhanced 0DOC_NUM master data InfoObject with CRM Service Order
information to make synchronize the relation between Service Order to
Purchase Order.
. Extracted the data from HR modules and uploaded the data into HR Info
Cubes for 0PY_C02 Payroll data, 0PABN_C01 Benefits, Staffing Assignments
0HR_PA_OS_1, 0HR_PA_CM_1 and 0PT_C01 Time and Labor Data and worked on
transformations.
. Created Generic Extraction from user defined tables and created
transformations using ABAP routines.
. Extracted non-SAP systems data like Oracle, BODS, Teradata using UD
connect and did flat file extractions.
. Designed and created complex process chains to automate the data load and
data target administration.
. Developed Analytical Reports with multiple parameter fields, multiple
expressions and multiple grouping for hierarchy levels and published them
using the Business Objects Enterprise XI.
. Created WEBI reports with Variables, Prompts and Complex Calculations to
get Alerts for Xcelsius Dashboards.
. Implemented analytics across the organization and used tabs on company
performance via flexible management dashboards and scorecards and
implemented index awareness.
. Checked the Universes for Integrity and exported to the Repository to
make resources available to the users and groups and Created Adhoc
Reports by accessing the Universe.
. Generated complex and large reports to show information from service
order to Purchase Order to Account payable using RRI to meet the business
user's requirement.
. Build complex new queries with variables, calculated key figures,
restricted key figures, customer exit variables and authorization object
variables.
. Created test cases and closely worked with business users to test the
queries and documented data model for backend objects and front end
queries for production support.
Environment: SAP ECC 6.0, SAP BI 7.0, SD, MM, PP,FI, PCA, SCM, ABAP/4, IP,
Business Explorer, Xcelsius, Crystal Reports with MDX, BOBJ/BO (XI
3.1/3.2), WEBI, Query Designer, Report Designer
Client: Magneti Marelli/ India
Jun'09 -
May'10
Role: SAP BW/BI Consultant
Responsibilities:
. Involved in the development of the user requirements, testing, initial
phase of production and thereby possessed a good understanding of
complete life cycle implementation of SAP BW.
. Gathered user requirements for creating reports such as Geographical
Sales Lead Report (sales prospect monitoring), Daily Billed Report
(revenue monitor) based on KPIs and studied the business content to suit
the clients requirements
. Extensively involved in installing and customizing the standard BW
business content to pull information from various source systems
including SAP R/3, Oracle and flat files to load the data into
InfoProviders.
. Worked in the areas of purchasing and extracted data from DataSources
like 2LIS_02_ITM, 2LIS_02_SCL and 0FI_AP_3. Also extracted and populated
data into LO InfoCubes from DataSources 2LIS_11_VAITM, 2LIS_11_VASTH and
2LIS_12_VCITM.
. Worked on custom reports like vendors without materials, materials
without vendors, spend data by material group, consolidated spend
history, and purchase price variance.
. Created custom report called forecast variance report, which compared
actual data from 2LIS_02_ITM and planned data from 2LIS_03_S194.
. Customized InfoObjects to match report requirements by creating variables
in BEx and creating InfoCubes based on the data content. Created
MultiCubes such as Demand cube, Supply Cube and Inventory Cube.
. Created the required InfoSources (for flexible upload and direct upload)
and InfoPackages to load the appropriate data into ODS via PSA for data
staging. Uploaded transaction data into ODS objects from flat files and
Oracle 8i. Multiple ODSs then fed the data into the InfoCubes and
InfoObjects.
. Created and maintained transfer rules, transfer routines, update rules,
and update routines to maintain data consistency.
. Extracted data, initialized delta for uploading of transaction data from
R/3 systems by V3 updates. Monitored the data load.
. Designed and built the generic data source on VEKP, LIKP tables of R/3 by
creating view on both tables on delivery numbers and document types.
Wrote user exits and customized delta built up for these DataSources
using V3 update.
. Created Conditions, Exceptions, Structures, and Variables to use them in
BEx Reporting.
. Worked with Info Package groups and Process chains for effective
scheduling and automation of various data loading processes.
. Resolved Query Performance issues using transactions like RSRT, RSRTRACE,
ST03N, RSDDSTAT, and BW Statistics. Involved in fine-tuning the
performance by creating aggregates based on BW statistics, creating
InfoCube partitions, data indices, optimal packet size, and data
compression.
. Developed authorization objects and profiles to restrict the access to
the data model and queries.
. Worked with OpenHub feature for creating InfoSpokes in extracting the
master data of the logistics, and material for exporting to a different
SQL server.
. Responsible for the creation of Naming Convention document and other
Documents for InfoCubes, ODS Objects, InfoSources, InfoObjects.
Environment: Sap Net weaver 2004S, ECC5.0, SAP BW 7.0,SD, FI,MM, Oracle 8i,
Windows NT, Business Explorer, WAD.
Client: Godrej/ Mumbai, India
Mar'08 -
May'09
Role: SAP BW/BI Consultant
Responsibilities:
. Involved in complete life cycle update (from preparation, business blue
printing, realization and go-live) of SAP BW & APO in SD, MM and FI
modules.
. Performed LO-Cockpit extraction to pull data from Sales and Distribution
SD module into the BW system. Customization of datasources in CO-PA, LIS,
HR, FI/CO and LO Cockpit to match the business requirement.
. Extracting the data from MM (Material Management 2LIS_03_BF data
sources), and PP (Production Planning and controlling) modules.
. Wrote reports in SD Open sales Order report, which covers all
organization levels, delivery status, shipping details and partner
function details. The tables used were VBAP, VBPA, VBAK, VBUP, VBFA,
KNA1, and MARA.
. Help project team in extracting data, interfacing BW with APO. Loaded
Demand Planning and ATP relevant data from I2/APO into BW.
. Created ABAP routines in Update rules, Info Objects. Used custom exits in
creation of Variables. Used debugging process for verification of
extraction process.
. Worked on BI 7 for GATP relevant reporting on APO and Prepared the Sizing
document by using Quick Sizer tool.
. Designed the Data flow for extracting Sales and Shipment Data from R/3 to
APO/BW.
. Extracted data from the Planning Area (DP). Involved in Creating Planning
Area's, Planning Book and generating CVC.
. Designed and developed several BEx Queries for LAG reports (ACTUALS VS
FORECAST).
. Performed CTM Job for transportation. Filled Setup Tables.
. Built an interface by using tscopy for master data load in SNP from
legacy database.
. Installed Business content for Sales & Operations Planning of SCM PP in
BW side.
Environment: SAP R/3, BI7, BW 3.5, APO 5, SRM 4.0, ABAP/4,, Business
Explorer, WAD, SD, MM, FI, CO-PA
Client: MIC Electronics/ Hyderabad, India
Jan 07- Feb- 2008
Role: SAP BI/BW Consultant
Responsibilities
. Involved in complete life cycle implementation (from preparation,
business blue printing, realization and go-live) of SAP BW in SD, MM and
FI modules.
. Created Info Objects, Data Sources, Info Sources, Data targets, Info
Packages and Info Cubes to load Master and Transactional data from SAP
R/3 system and flat files into BW system.
. Created and mapped source and target structures, loaded transactional
data and master data, set up delta load using SAP Standard extractor
program. Created transfer rules and update rules.
. Installed and extended standard Business Content based on client
requirements for enhancing Data sources for transaction data, master data
and texts.
. Created, Maintained and modified existing queries on different Info Cubes
related to SD, MM and FI/CO modules. Extensively worked on Query
building, filtering data, Structures, Variables and conditions.
. Created a custom Start Routine, Update Rules and Transfer Routines to
meet the business requirement.
. Schedule of Process Chains for Hourly/ Daily / Weekly Loads as and when
required.
. Involved in the preparation of Technical specifications and maintained
all the technical documents of all the objects and their user manuals.
. Designed custom ODS for sales order line items relevant to demand
planning.
. Involved in extracting data from custom data sources i.e. Generic
Extraction.
. Involved in the Integration testing in quality of Objects.
. Designed custom info provider for Delivery analysis and to load large
volume of data from SAP R/3 4.6C Source systems.
. Extensively involved in Design and creating Processes Chains to automate
the process of loading data into data targets
. Designed ODS object for MRP and loaded data. Developed an interface
between legacy system Windmills and BW to extract data and developed
reports Sales by customer and Sales by materials.
. Worked on Info Cube to develop income statement report.
. Involved in transporting objects in system landscape and in production
support.
. Designed loading strategies for master data, initial load of
transactional data and delta loading of both master data and
transactional data.
. Developed ABAP routines at Info package level for data manipulation and
restriction.
. Defined strategy to set up the historical data to load into BW and
improved performance by running parallel setups.
. Developed Transfer rules, update rules and Start routines to incorporate
Business logic for data manipulation.
Environment: SAP BW3.5/3.0bSAP R/3 4.6B/4.6C/4.7, BEx, SD, MM, PP, FI.
Contact this candidate