- Featured in:
Find out what is the best resume for you in our Ultimate Resume Format Guide.
Additional Data Systems Administration Resume Samples
Sap Bw Consultant Resume Samples
No results found
0-5 years of experience
Study of the Solution environment and documented the requirements including technical specifications and design document.
- Created TS/FS/Test Cases templates, migrated objects from development to quality and from quality to production.
- Customized and managed the modeling of BW.
- Gathered the requirements from offshore Business Analyst and implemented from start to end.
- Have created Queries (reports) mainly for SD, FI, MM, QM and PP.
- Created workbooks over the Queries and maintained via Process chains.
- Environment: SAP ECC6. 0, SAP BI7.0, MM, SD, FICO/GL, PP, QM
0-5 years of experience
Involved in Post-Production support that includes monitoring of process chains and data loads, reconstruction rescheduling .Involved in infospoke development to deliver data to external systems
- Monitored daily BW uploads and LO Cockpit Jobs, re-peat scheduled the Cockpit jobs when daily uploads were delayed, resolved several issues during uploads.
- Developed infospokes to deliver data to external systems as flat
- Developed reports on Info Cubes/multiproviders using BEx Analyzer/Explorer (RRMX) to facilitate summarization of data.
- Created and maintained roles for reports using PFCG. Developed Report-report interfaces (RRI), filtering, conditions, exceptions, variables, currency conversions, drilling, and navigational attributes.
0-5 years of experience
Installation of Business content for G/L(0FIGL_C01) and built Trial Balance Reports.
- Installed Infocube Commitments/Actuals and Budget in Funds Management (0PU_C02) from business Content for Funds Management and configured the extractors for Budget Total Records, Commitment Line Items, FI Line Items, and CO Line Items.
- Enhanced several standard reports like Overall Budget: Assigned Funds in the Commitment Budget, Annual Budget (Periodic Representation) Commitments and Actuals as per client requirement in Funds Management using SAP BEx Query Designer.
- Created BI BEx Reports in Pension Funds, Compensation Management, and Organization Management in BI-HR Reporting.
- Created Personnel Cost Plan (0HR_PA_CM_8) enhancements to include Cost Center. This extractor was one of the data source for the Budget Preparation in SEM-BPS.
- Built Process Chains to run data validation before loading Excel files and to load delta load for R/3 data.
- Performed the end user training, knowledge transfer and production support activities and resolved various issues apart from the above mentioned subject areas.
0-5 years of experience
Technical Responsibility
- Daily Data load Monitoring of the BW jobs. Ensured daily data load from R/3 to BW is successful.
- Created FI-GL jobs for G/L line Item Data to get the account balances and transaction figures.
- Performed data extraction, transformation and loading from SAP and non-SAP source systems into the SAP BW.
- Rectified Universes in Business Objects. Created and scheduled reports on Business Object universe using WEBI.
- Provided Knowledge Transfer to the entry level employees. Monitored and evaluated their work.
0-5 years of experience
Defined Key Performance Indicators (KPIs) and involved in design the data model and its components within SAP BW.
- Utilized Standard Datasources with LO Customizing Cockpit for extracting Sales, Billing, and Purchase applications data.
- Developed some of the most complex business rules by means of update rules/start routines.
- Designed front-end reports using BEx Analyzer, used Restricted and Calculated Key Figures, Variables, Exceptions, and Conditions.
- Created Web Templates to include various reports to make the users to get the reports in a very effective way.
0-5 years of experience
Experienced in modeling, extracting, transforming, and loading (ETL) data into data targets for reporting.
- Found the gap between SAP Business Content and business requirement.
- Enhanced SAP Business Content to meet business requirement.
- Developed Transfer Rule, Update Rule and User Exit with ABAP language.
- Designed, developed and tested queries based on infoProvider with Bex.
- Generated and analyzed sales reports and financial reports.
- Verified sales data and financial data through SQL.
0-5 years of experience
Performed Full life cycle Implementation for [company name]. Gathered, defined, documented requirements, maintained project schedule, designed, developed, tested, and implemented planning model for profit center and cost center planning.
- Analyzed data requirements and translated these requirements into dimensional data models for FI/CO using star-schema and extended star-schema data modeling techniques.
- Loaded Master and Transactional data from R/3 system and flat files into BW system.
- Developed Sales report to display territory sales based on customer, products, product types, and fiscal year.
0-5 years of experience
[company name] finds opportunities to innovate in your industry and create a success story for your business. As the global leader in paper, packaging and wood products, [company name] can partner with you to create solutions in any industry, anywhere we’re needed.
- Responsible for data modeling of the Sales and Distribution Module, and Master data (Customer and Material Master), for the SAP Business Information Warehouse (BW).
- Gathered data by consulting with the functional specs and decided to implement custom made InfoCubes to cater their requirements.
- Worked extensively with Administrative Work Bench (AWB).
- Customized the InfoCubes (Basic Cube, MultiCube), Info Source and InfoObjects.
- Sound knowledge in extending the Business Content based on requirements
- Tailored transfer structures, communication structures and update rules based on the requirements and scheduled the Info-packages for data loads.
0-5 years of experience
Created new target infoCube using source infoCube template. Generated export data source to export data to target cube.
- Customized cubes and assigned dimensions to newly inserted characteristics. Replicated the exported data source to Meta data repository and assigned infoSource.
- Activated and created update rules for newly structured infoCube.
- Created info packages to load data to newly structured infoCube through logical source system.
- Created ODS Objects for sales orders, deliveries and invoice and loaded them by creating and scheduling relevant info packages.
- Replicated various data sources on the BW side and assigned appropriate infoSources to them.
- Worked on the design aspects of basic and multi cubes for sales transactions.
0-5 years of experience
Performed analysis, design, development and Implementation of standard / customized InfoCubes and Data Store Objects for business end-users in the application areas of SD and CRM using BI7.0.
- Involved in creating and maintaining Info Cubes, DataStore Objects, Info Objects, Info Areas, Data Sources, Transformations, Data Transfer Process and Info Packages.
- Installed Business Content Sales and Sales Details, sales and Trade promotion (plan), Sales & Trade Promotion (Actual), Promotion knowledge base InfoCubes and designed and activated Brand Plan Budget InfoCubes to meet user needs.
- Migrated DataSources from 3.x version to BI7.0 version and created several DSO objects which act as data staging engine.
- Data extraction from R/3 to BW by using LO Cockpit (LBWE) initialized the setup tables. Scheduled and Implemented delta mechanism for periodic loads.
- Designed and developed process chains (RSPC) for master data loads and transaction data loads with the help of DTP and these Process chains are scheduled for periodic loads.
- Created custom queries and defined Calculated Key Figures, Restricted Key Figures, Variables, etc. For customized reporting using BEx Analyzer, BEx Query Designer. Designed and developed several web reports using web templates in Web Application Designer.
- Created Planning Areas, Planning Levels, Multi Planning Areas and Manual Planning for the Sales & Trade Promotion (Actual + Plan) and created Variables in BPS.
0-5 years of experience
Involved in full life cycle implementation of SAP BW for FI/CO, SD and MM module and actively involved in ASAP methodology. Involved in Data Modeling, Extraction and Reporting.
- Activating the business content according to the functional requirements and developed various custom cubes both enhanced and generic cubes.
- Worked extensively with 0FI_GL_4 and 0FI_GL_2 Extractors and developed 0FIGL_C01 cube to calculate total credit and debit postings along with generic extraction for Plant utilization reports.
- Involved in the requirement gathering of the industry specific IS-OIL R/3 data
- Extensively used reporting agent to make efficient use of BEx reporting functionalities like exception reporting, background printing and pre-calculated value sets
- Trained users in creating Ad-Hoc reports using BEx Analyzer.
0-5 years of experience
Deployed CRM system for Compaq HP.
- Minimized CRM IT spend by developing timeline for retiring existing legacy system and moving company to a single system. New CRM proved to be cost effective and user friendly.
- Directed rollout of SAP CRM to cover Commercial Order Management Tool, One-Touch order entry process, and central credit management. Carried out initial setup in Middleware, initial delta download, and CRM-BW interface.
- Built queries and workbooks using BEx Analyzer to access data from BW data targets. Day, week, month and year queries used to print reports from the Info Cubes.
- Built business requirements and information template to identify data elements for future reporting needs.
- Analyzed data requirements and translated into dimensional data models that used star schema and extended star schema data modeling techniques. Analysis emphasized actual implementation in BW.
0-5 years of experience
ERP (SAP & BW Related Technologies): Business Information Warehouse 3.0a & SAP R/3 4.0b
- Gathered user requirements for data modeling, and modeled the custom cube along with activation of business content and designed documentation for development.
- Did Gap analysis between Blue print and Business Content.
- Designed Developed and Modified Info Objects, Info Sources and Info Cubes and loaded these objects with Master data and Transactional data from SAP R/3 and flat files by creating Info Packages.
- Extensively worked in Data Mapping Fields between R/3 and BW for Info Cubes.
- Created Variables, Filters, Exceptions, Calculated key figures, restricted key figures, Global and Local structures and other features to meet user requirement.
- Conducted BI presentations, End Users Training, Documentations, Knowledge Transfer Sessions
- Extensively built Info Objects, Info Sources, Info Packages, ODS, Info Cubes
- Worked on DTP to transfer the data to Info cube and DSO.
- Developed business process documentation
0-5 years of experience
Environment: SAP BW3.5, SD, FI-CO, Oracle, BEx Analyzer, WAD, Portal 5.
- Involved in full life cycle implementation of SAP BW for FI/CO, SD and MM module and actively involved in ASAP methodology.
- Upgrade Support for development and user team for Upgrade from BW Ver 3.0B to Ver 3.5.
- Configured BW transactional cubes for SEM (version 3.5) . Setting up planning area and Scheduling Data transfers in between SEM-BPS and BW cubes.
- Created and activated Info Cubes, Info Sources, Multi-Providers, Transfer structures, Transfer rules, Communication structures, Update Rules (both ODS and Info Cube level) and conversion techniques.
- Configured alert monitor, Job schedule monitor, Exceptions handling and user role maintenance. Involved in creation of role based security and authorization for certain Info Cubes and Info Objects.
- Created web reports through report templates in WAD, Training end users in query development-using BEx.
0-5 years of experience
Environment: SAP BW3.5, SD, FI-CO, Oracle, BEx Analyzer, WAD, Portal 5.
- Involved in full life cycle implementation of SAP BW for FI/CO, SD and MM module and actively involved in ASAP methodology.
- Upgrade Support for development and user team for Upgrade from BW Ver 3.0B to Ver 3.5.
- Configured BW transactional cubes for SEM (version 3.5) . Setting up planning area and Scheduling Data transfers in between SEM-BPS and BW cubes.
- Created and activated Info Cubes, Info Sources, Multi-Providers, Transfer structures, Transfer rules, Communication structures, Update Rules (both ODS and Info Cube level) and conversion techniques.
- Configured alert monitor, Job schedule monitor, Exceptions handling and user role maintenance. Involved in creation of role based security and authorization for certain Info Cubes and Info Objects.
- Created web reports through report templates in WAD, Training end users in query development-using BEx.
0-5 years of experience
Environment: SAP BW3.5, SD, FI-CO, Oracle, BEx Analyzer, WAD, Portal 5.
- Involved in full life cycle implementation of SAP BW for FI/CO, SD and MM module and actively involved in ASAP methodology.
- Upgrade Support for development and user team for Upgrade from BW Ver 3.0B to Ver 3.5.
- Configured BW transactional cubes for SEM (version 3.5) . Setting up planning area and Scheduling Data transfers in between SEM-BPS and BW cubes.
- Created and activated Info Cubes, Info Sources, Multi-Providers, Transfer structures, Transfer rules, Communication structures, Update Rules (both ODS and Info Cube level) and conversion techniques.
- Configured alert monitor, Job schedule monitor, Exceptions handling and user role maintenance. Involved in creation of role based security and authorization for certain Info Cubes and Info Objects.
- Created web reports through report templates in WAD, Training end users in query development-using BEx.
0-5 years of experience
Implemented SAP BW 3.5 for SD, PP, MM modules. Involved in analyzing and designing the data flow from R/3 to BW and responsible for deployment.
- Responsible for design, development and extraction of data from R/3 source system into BW from SD and MM using LO cockpit extraction methods.
- Extracted data from data sources like 2LIS_02_ITM, 2LIS_02_SCL, and 2LIS_03_S194 and populated into the procurement info cubes 0PUR_C07, 0PUR_C08, and 0PUR_C09 to evaluate service levels.
- Creating setup tables using 0LI7BW based on the document range for the LO-Cockpit extraction, performing V3 update using LBWE to get the data from the outbound queue of the R/3 system to the delta queue of the BW system.
- Performed LO-Cockpit extraction to pull data from R3 SD modules into BW system extracting the Header and Line item data from the Sales and Distribution (SD) module (SalesOrder 2LIS_11_VAHDR/VAITM, Shipping/Delivery 2LIS_12_VCHDR/VCITM, and Billing 2LIS_13_VDHDR/VDITM).
- Created query “Open Manufacturing Orders” that shows the status of orders that are finally delivered and to analyze target quantities.
- Created reports like confirmed quantity and item purchase orders as requested, complete purchase order quantities delivered and purchase order values.
0-5 years of experience
Performed BW functional and technical audit
- Studied system to isolate issues related to business practices and performance.
- Performed optimization of BW query, aggregates, PSA and InfoCube loads.
- Worked with functional team members and conducted knowledge transfer as related to all aspects of BW as necessary.
- Assisted in data loads, isolated and resolved errors with the rollup of aggregates.
- Gave advice as to setting up standardization for Custom InfoCubes and development classes.
- Primary contact for communication between functional and technical team.
0-5 years of experience
Reenergized a stalled BW implementation.
- Developed data extraction for SD (sales overview), FI-CCA and FI-GL
- Created routines to map sales document categories in Sales Overview info cube
- Analyzed business reporting requirements and installed the necessary objects from Business content
- Designed, developed and modified Info-objects, Info-sources, ODS Objects and Info-Cubes
- Loaded objects with Master Data and Transactional Data from ECC and flat files by creating Info Packages
- Created aggregates and indices for a better query performance and used event-chains to notify end-user of report availability
- Supervised mid-size offshore team in India.
- Spearheaded ‘Netweaver Feasibility Study’ to integrate all applications.
0-5 years of experience
Responsibilities include development of new Info Cubes & Enhancements to the existing functionality as per the user requirements
- Used LO-Cockpit (V3 Update) extract structures and data sources to extract data in SD and MM to facilitate the data to BW.
- Involved in performance tuning for better performance. Created aggregates for specific cubes based on reporting requirements.
- Extensively used Multiproviders for reporting using various Infocube combinations to suit business needs.
- Involved in transporting the objects from the Development to test and then production by fixing the un-imported objects if any and resend them to the basis team to import.
- Extensively worked with the Tech documentation based on requirement changes
- Enhanced Functions of SAP Business Explorer Analyzer.
- Created process chain sequence and dependency specification for the automation of the processes.
- Extensively used Query Designer and Web Application designer to create reports and publish them in the web.
- Created queries using Restricted and Calculated Key Figures. Used Conditions, Variables, Exceptions, Report-Report Interface etc to tune query output as per business needs.
- Implemented BEx and Web Reporting and trained end users on BEx Reports
0-5 years of experience
Project Description/Scope: APO Process Chain Monitoring [Weekend Support]
- To monitor the scheduled APO jobs on weekends, to fix the tickets and critical errors
- Provided solution for various process chain failures in APO production.
- Worked on RSPC, RSA1, SM37 and SP01.
- Monitoring Process chains, Change pointers, repeating the failed steps, restarting the error background jobs.
0-5 years of experience
Environment worked in SAP BI 7.0, SAP R/3 ECC5.0, ABAP/4, BEx Analyzer, FICO, SD, BPS, APO 5.0, MM Windows NT
- Rolled out a SAP BW project for reporting needs on SAP FI, CO, MM, APO and SD data
- Involved in gap analysis and study of business content for the client’s requirement.
- Involved in all phases of the project cycle from Blueprinting, Design Architecture, Configuration, Development, Documentation, Integration Testing and Go Live. Represented BW team in various status meetings.
- Tasks include studying the Business Process and understanding the whole Landscape and Architecture for BW configuration. Worked extensively on data modeling, Extractions and reporting.
- Extracted Data from FI-GL, CO-PA, MM, APO and SD modules using LO cockpit, COPA, and General Extraction methods. Also used DB connect and Flat files for loading legacy data, Adjustments, and data from other sources.
0-5 years of experience
Involved in the full cycle of development and implementation of SAP BW server.
- Analyzed Business requirements to design a data solution.
- Analyzed ERM, MDM and translated it to BW design. Identified the Key Figures, Strong Entities and Attributes.
- Involved in creation of Info Cubes, ODS, Data Sources, Info sources, PSA for data Extraction, Transformation and Loading from SAP R/3 to SAP BW.
- Extracted data in various Data Targets depending on the user requirements like ODS, Info Cube.
- Carried out CO-PA extraction involving creation of data source, activating the business content, replicating data source, creating Info Cube, update rules and finally creating an Info Package to extract data.
- Extensively worked in extractions, LO-Cockpit extraction and others using V3 updates
- Extensively used BEx Analyzer to build queries, queries with maps and charts and worksheets to access data from BW data targets.
- Developed reports using BEx Analyzer and BEx Query Designer as per the requirement of the query.
- Worked with Info Package group.
- Performance tuning – Extensive tuning of the interfaces and reports in the production and development environment. It leads to programs faster by more than 8-10 times.
0-5 years of experience
The smartvalue involved the implementation of SD, MM modules for analyzing the product sales, improving the distribution by fulfilling the order requirements, comparing the value of incoming orders with the value of open orders, estimating the frequency of ordering materials, delivery delays and average delivery time taken by various vendors.
- Involved in complete lifecycle implementation of the project from gathering user requirements, preparation of technical specifications documents, designing and developing reports, unit testing(UAT) to Go live production support.
- Implemented SAP BI 7.0 for SD, MM modules.
- Involved in analyzing and designing the data flow from ECC to BI.
- Responsible for design, development and extraction of data from ECC source system into BI from SD, MM using LO cockpit extraction methods.
- Used formula variable, conditions, exceptions.
- Published reports on the web using web application designer.
- Know Performance Tuning measures like Aggregates, Compression, Partition& Indexes.
- Enhanced the Data source by using enhancement to fill the data into the fields newly enhanced.
- Involved in frequent client meetings to discuss project status.
0-5 years of experience
Involved in the full cycle of development and implementation of SAP BW server.
- Analyzed Business requirements to design a data solution.
- Analyzed ERM, MDM and translated it to BW design. Identified the Key Figures, Strong Entities and Attributes.
- Involved in creation of Info Cubes, ODS, Data Sources, Info sources, PSA for data Extraction, Transformation and Loading from SAP R/3 to SAP BW.
- Extracted data in various Data Targets depending on the user requirements like ODS, Info Cube.
- Carried out CO-PA extraction involving creation of data source, activating the business content, replicating data source, creating Info Cube, update rules and finally creating an Info Package to extract data.
- Extensively worked in extractions, LO-Cockpit extraction and others using V3 updates
- Extensively used BEx Analyzer to build queries, queries with maps and charts and worksheets to access data from BW data targets.
- Developed reports using BEx Analyzer and BEx Query Designer as per the requirement of the query.
- Performance tuning – Extensive tuning of the interfaces and reports in the production and development
0-5 years of experience
Responsible for studying Business process, Data mapping, Function mapping and resolve the gaps in business process.
- Responsible for generating functional specification document from KPI’S for whole implementation by taking inputs from several team members.
- Involved in performing root cause analysis for problems, report status, discuss project issues, and participated in project meetings.
- General Ledger accounting implementation – Balance sheet, P&L financial statements are implemented.
- Enhancement to Balances & Leading ledger 0FIGL_C10.
- Worked on the data source 3FI_SL_LG_SI Single item. Actual & Plan data shown in total record level and line item level.
- Financial Statement queries, Balance display, Remote on cube 0FIGL_V11.
- Involved in development of sales Header, schedule lines, line items.
- Enhanced Deliveries and Number of orders reports
0-5 years of experience
Performed functional migration of SAP BW3.5 to SAP BI7.0.
- Worked in the Design, development and extraction of the data from R/3 system and flat files in to BW
- Created Data Transfer Process (DTP) to transfer data within BI from one persistent object to another object.
- Performed migration of emulated data source.
- Generated Transformations from Transfer rules and update rules in the process of Migration of data flow from 3.5 to 7.0.
- Implemented Start and End routines within Transformations.
- Enhanced Infocube with remodeling concept to make changes, without having to reload data.
- Used Direct Update DSO in the process of APD (Analysis Process Designer).
- Generated Queries using new BEx Query Designer.
- Worked with BEx Report Designer to create formatted reports.
- Actively worked in designing, formatting and delivering financial statements, using Crystal Reports
0-5 years of experience
Environment: SAP BW 3.0b, SAP R/3, Oracle 8i, SD, MM, FI
- Worked with Business Content as well as Creating Info sources, Info objects, Info cubes, ODS Objects, Transfer/update rule process chains
- Uploaded master and transactional data from files and SAP as the OLTP source. Worked extensively on administration workbench (RSA1)
- BEx Query Reporting, using Business Content, Generic extraction. Designed Three Info cubes with daily and Monthly Granularity, extraction from PSA.
- Setup Flat file extraction for legacy data, Assigning Data Sources to the Info Source, Defining Transfer Structure, and Metadata maintenance for the Info Source and Source system. Configuring Metadata in the Administration Workbench for replication and Updating of Data Source from the source system.
- Configured use of restricted key figures, variables, exceptions and calculated key figures in queries. Created aggregates to improve the query response.
- Dimensional modeling and extended star schema modeling.
- BEx Browser, BEx Analyzer, info objects, info cube, loading business content for BW, Loading data via Flat files, developing data extractors.
- Administrating through BW Administrator workbench. Developed basic cubes for sales.
- Used ODS to stage the data before transferring the ODS contents to the Info Cube, Done ODS reporting to give details of delivery items and schedule line items.
0-5 years of experience
Environment: SAP BW 3.0b, SAP R/3, Oracle 8i, SD, MM, FI
- Worked with Business Content as well as Creating Info sources, Info objects, Info cubes, ODS Objects, Transfer/update rule process chains
- Uploaded master and transactional data from files and SAP as the OLTP source. Worked extensively on administration workbench (RSA1)
- BEx Query Reporting, using Business Content, Generic extraction. Designed Three Info cubes with daily and Monthly Granularity, extraction from PSA.
- Setup Flat file extraction for legacy data, Assigning Data Sources to the Info Source, Defining Transfer Structure, and Metadata maintenance for the Info Source and Source system. Configuring Metadata in the Administration Workbench for replication and Updating of Data Source from the source system.
- Configured use of restricted key figures, variables, exceptions and calculated key figures in queries. Created aggregates to improve the query response.
- Dimensional modeling and extended star schema modeling.
- BEx Browser, BEx Analyzer, info objects, info cube, loading business content for BW, Loading data via Flat files, developing data extractors.
- Administrating through BW Administrator workbench. Developed basic cubes for sales.
- Used ODS to stage the data before transferring the ODS contents to the Info Cube, Done ODS reporting to give details of delivery items and schedule line items.
0-5 years of experience
Environment: SAP BW 3.0b, SAP R/3, Oracle 8i, SD, MM, FI
- Worked with Business Content as well as Creating Info sources, Info objects, Info cubes, ODS Objects, Transfer/update rule process chains
- Uploaded master and transactional data from files and SAP as the OLTP source. Worked extensively on administration workbench (RSA1)
- BEx Query Reporting, using Business Content, Generic extraction. Designed Three Info cubes with daily and Monthly Granularity, extraction from PSA.
- Setup Flat file extraction for legacy data, Assigning Data Sources to the Info Source, Defining Transfer Structure, and Metadata maintenance for the Info Source and Source system. Configuring Metadata in the Administration Workbench for replication and Updating of Data Source from the source system.
- Configured use of restricted key figures, variables, exceptions and calculated key figures in queries. Created aggregates to improve the query response.
- Dimensional modeling and extended star schema modeling.
- BEx Browser, BEx Analyzer, info objects, info cube, loading business content for BW, Loading data via Flat files, developing data extractors.
- Administrating through BW Administrator workbench. Developed basic cubes for sales.
- Used ODS to stage the data before transferring the ODS contents to the Info Cube, Done ODS reporting to give details of delivery items and schedule line items.
0-5 years of experience
Environment: SAP BI 7.0, BO, BEx, FICO, COPA, SD, MM, FI(AP/AR/ New GL), ABAP.
- Involved in requirement gathering, Architect, design and development of, BW/BO implementation.
- Architect the solution by using BW/BO that include BW(Info Objects, DSO, InfoCubes, Data Sources, Transformations, routines, Extractors for Master and Transaction Data, Multi-providers, BW Security, BEX Reports and Process Chains) and BO(Universe, Webi, Crystal, Xcelsius)
- Involved in leading and managing BW project implementation plan, co-ordinate with client business team, functional team conducted various training and demo.
- Involved in integrating BW and BO report solution as per the various reporting requirement.
- Involved in design and development of various reports related to SD, MM and FICO.
- Design and developed complex report in BW-using Bex , Jump Query, , Variables, formula variables, Calculated key figures, Restricted key figures, Formula, cell editor, integrated with BO.
- Involved in unit testing, QA, data validation, loading, created test scenarios, fixed the issues and collected and manage transport object to QA and Production.
- Involved in extracting data using DB Connect, Flat file and send data using open hub to the external system.
- Involved in BW cutover activities, this include production system build up, configuration, transport fix, master, transaction data loads, setup tables, initialization, delta loads.
- Investigated various defect find solution, apply OSS notes, raised OSS notes etc.
0-5 years of experience
SAP BW 2.0A implementation with R/3 4.6B system and mySAP.com Workplace
- Gathered customer requirements
- Set configurations
- Managed knowledge transfer of SAP BW
0-5 years of experience
Business Area: Manufacturing
- Involved in testing & resolving SAP BI 7.3 & Hana DB issues.
- Compared Front end reports with 7.0 & 7.3 systems.
- Help identify some of the issues raised by 7.3 system upgrade.
- Work extensively on resolving defect which were raised while testing.
- Extensively worked on getting back 800 GB of space.
- Identified and planned the high consuming DSO’s and Cube & interacted with the user for the retention of the data.
- Automated Selective Deletion through ABAP programs.
- Create Open Hub’s to transfer data into SQL Server DB using SSIS.
- Worked on Production Support.
0-5 years of experience
Experienced in SAP NetWeaver BW 7.3/3.5
- Associated in the complete life cycle implementation of SAP BW, which included Data Gathering, Gap Analysis, application specific Data Extraction, Generic Extraction, Data Loading, Scheduling, Monitoring and Web Reporting
- Worked with DWH Workbench expertise in DSO, InfoObjects, InfoSources, DataSources, InfoCubes, Virtual InfoCubes, DTPs, MultiProviders, InfoPackages, Loading Full/Delta updates, Process Chains, Volume sizing estimates and establishing Data classes, Rules and Authorizations.
- Skilled in loading data using Flat Files and DB connect
- Worked in developing and implementing Crystal Reports, WebI Reports and SAP Dashboard (Xcelsius) and published them on InfoView (3.x and 4.0)
- Expertise in Generating Reports using BEx (Business Explorer) with variables, exceptions, Restricted Key Figures, Calculated Key Figures, conditions, formulas, filters and drilldown methods.
- Expertise in creating reports with Charts (bar chart, Pie chart etc), Cross-tabs and Sub reports.
- Expertise in using Universe Designer over BEx queries and InfoCubes
0-5 years of experience
Worked in development and enhancement of HR project.
- Enhanced HR Master Data and update the HR cube and report accordingly.
- Worked with backend Security and enabled new report available to users.
- Worked in product support and educate the users.
- Worked in Gillette acquisition project for BI development.
0-5 years of experience
SAP roll out project for reporting needs on SAP HR, FI, and LO.
- Full lifecycle responsibilities include blueprinting, design architecture, configuration, development, documentation, integration testing, and go live.
- Studied the business process to gain understanding of the landscape and architecture for BW configuration.
- Performed data-modeling, data extraction, generic extraction, data loading, scheduling, monitoring and reporting for the HR, FI and LO modules.
- Performed structural and functional enhancements to data sources with necessary user-exits for master as well as transaction data in R3. Extracted data into BW from SAP R/3 and flat files.
- Worked on BEx Analyzer and web application designer created queries using BW reporting variables, navigational attributes, and filters. Developed workbooks and used RRI jump queries to drill down to other queries and R/3 Transactions.
- Used calculated and restricted key figures, restricted characteristics, structures, variables, and conditions for queries.
- Developed various data extraction procedures for master data, for attributes, texts and hierarchies and transactional data (full and delta) using LO cockpit and generic extractors for customer-defined tables.
- Worked on BPS planning area, planning level, planning package, and planning functions.
- Developed BPS Web interface to load flat files for the end users.
- Worked on process chains, Meta chains, performance tuning.
0-5 years of experience
- As a BW Consultant set up complete BW environment – RFC configuration, Source system set up( R/3 System & Flat File), BW object creation, Business content activation, Design Role based authorization matrix, Global and Parameter Settings, Metadata upload, IMG configuration
- Requirement Analysis and development of Custom Defined Datasources using Generic extractors based on Table view.
- MDM Preparation and creation of maser data objects, Basic cubes
- Development of operation and marketing queries in graphical form using Bex analyser
- Train the core team on BW administration, custom cube and Bex query development
0-5 years of experience
Environment – ECC 4.7, BW 3.5, BI 7.0
- BW Modeling – Requirement gathering; translating the requirements into BW specific mapping; analyzing existing business processes; specifying design
- Modeling, Business Content, Data Extraction (SAP R/3, non SAP), Data Loading, Scheduling, Monitoring, Reporting and BEx Analyzer
- Info Objects, InfoObject Catalogs, Info Cubes, ODS Objects, Info Sets, Multi Providers, Application Component, Info Sources, Data Sources, Update Rules, Transfer Rules, Communication Structure, Transfer Structure, Info Packages, Info Package Groups, Process Chains and PSA etc.
- Strong experience in Info Cube (Real-Time Cubes, Basic cubes, Multi-cubes & Remote cube) design, Info Sources, Info Object maintenance, ODS Objects, Aggregates, Process chains, BEx Analyzer, InfoSet Query, Query designing, generic extractions, LO Cockpit extractors.
- Experience in creation of Master and transaction Data Sources by using views/tables & SAP Queries, Data source Enhancements, variable exits for BEx Reports & Routines in Update rules and Transfer rules as per client requirement
0-5 years of experience
Sales and Marketing reporting project – (SAP BW)
- Based on sales (SD) data
- Business rules for sales reporting and marketing analysis (brand segmentation)
- Workbooks implementation
- Hands on consultant