We provide IT Staff Augmentation Services!

Sr. Sap Consultant Resume

Stow, MA

PROFESSIONAL SUMMARY:

Over Ten Years of experience in SAP BI/BW and FI/BI completed two SAP full lifecycle implementations, gaining experience in gathering business requirements, Gap analysis, Asap methodology, blueprinting, white boarding solution with business users, 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.

SAP HANA Net weaver BI/BW/BO Expertise:

  • 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.
  • Experience working on Project Systems, Asset Management, Accounts payable and Accounts receivable reports and requirements.
  • Extensively worked on Process Chains of Events, Data source Enhancement, OLTP data extraction , Loading (Full /Delta Up-Load), Monitoring, Remote Cube DTP, Data Mart and Open Hub Service, Performance Tuning, Aggregates, BW Transports, RSRT, Query tuning, Building aggregates, Indexing and BIA.
  • Extensively worked on OLTP extractions using LO Cockpit, CO-PA, LIS, FI, HR, generic datasource customization, function modules, 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.
  • Excellent techno-functional skills for cross-functional modules like FICO, G/L, SD, MM, HR, BPS/IP, BCS, BOPC, and PP modules in SAP R/3.
  • 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, Business Objects Web Intelligence, Data Services and/or other enterprise reporting tools.
  • 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, Ad-hoc Queries.
  • 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.
  • Active participant in transferring and synchronizing projects between ARIS and Solution Manager.
  • Strong Hands on experience in developing ABAP programs BAPI, EDI, ALE, IDOC, and RFC interfaces.
  • 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
  • Manage tasks and engagements with little or no supervision.
  • Experience with functional designs, converting functional designs into technical designs, detailed design, hands-on programming, performance tuning of RICEF objects, SQL, PLSQL, ABAP tracing, ETL and Data Mining.
  • Expert in SAP BW/BI Integration with APO, HR and CRM. Strong Domain Experience in the Areas of Consumer Electronics, Food & Beverages, Manufacturing, Pharmaceuticals and Life Sciences.

BI Integration Expertise:

  • Good experiences in Data Extraction from APO live Cache from DP and SNP planning areas. Familiar with APO 4.1/5.0 systems with its embedded BW 3.5 and BI 7.0 systems.
  • Good Knowledge in Payroll, Benefits, Personal Administration, Org. Management and Public Sector Management. Strong APO, HR CRM, MDM & BW Reporting Experience.
  • Familiarity with CRM5.0 systems with its embedded BW3.5 and BI7.0 systems. Good Exposure on Business Partner Relationships, Asset Management reporting, Territory Management and Project Systems.

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.1 Ehp1/7, SAP BW (3.5/3.1C/3.0B), Visual Composer, SAP BOBJ/BO (XI 3.1/R2/6.5), SAP ECC (6/5), SAP R/3 (4.7/4.6C/4.6B/4.5B), Portal KM, Solution Manager /ARIS Visual Composer, BI Integration with SCM/APO, HR, and CRM, Solution Manager /ARIS, Reporting

Operating Systems: Sun Solaris, HP-Unix, Win NT 4.0, Windows 95/98/2k/XP/Vista/7

RDBMS: Oracle10/9/8.x, MS SQL Server 2000, MS Access

Tools & Utilities: ABAP/4, SQL, IDOC, RFC’s, DBconnect,

Web Technologies: HTML, XML, ASP, JavaScript, VBScript, Servlets

PROFESSIONAL EXPERIENCE:

Confidential, Stow, MA

Sr. SAP BI/BW/BO Consultant

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

Responsibilities:

  • Played key role in Project Blueprint/Realization/GO-LIVE/Sustain phases of SAP BW -SAP BOBJ development project.
  • Worked on reports like Inventory Management, Gift Card Transactions, Bose Payment Plan.
  • Developed data model for NPD intellect for Canada and US data.
  • Siebel open hub codes extraction logic was developed to generate the flat file from BW send to BO server using open hub and generate report on BO.
  • On demand access to US data from Europe system was developed and scheduled loading using process chain.
  • 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. Used Cognos and Informatica for ETL & reporting.
  • 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.
  • Design schemas in HANA modeler and developed Calculation views Attribute/Analytic using tools on HANA models for a Pilot Project.
  • 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.
  • 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.

Confidential ,Commack, NY

Sr. SAP BI/BW Consultant

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.

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. Used Cognos and Informatica for ETL & reporting.
  • 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.
  • Design schemas HANA and developed Calculation views Attribute/Analytic using tools on HANA models for a Pilot Project.
  • 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.

Confidential, San Diego, CA ,

SAP BW/BI Consultant

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

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.

Confidential, Houston, TX

SAP BW/BI Consultant

Environment: Sap Net weaver 2004S, ECC5.0, SAP BW 7.0,SD, FI,MM, Oracle 8i, Windows NT, Business Explorer, WAD.

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.

Confidential, Louisvilly

COSAP BW/BI Consultant

Environment: SAP R/3, BI7, BW 3.5, APO 5, SRM 4.0, ABAP/4, , Business Explorer, WAD, SD, MM, FI, CO-PA

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.
Confidential, Canonsburg, PA SAP BW Consultant

Environment: SAP 4.7, 4.6C, BW 3.5, ABAP/4, Oracle 8.0, UNIX, Business Explorer, SD, MM, FI, CO-PA.

Responsibilities:

  • Analyzed, designed and implemented OLAP cubes and reports in SD, MM and FI/CO modules based on end-user requirements.
  • Designed, developed and implemented Info Sources for BW.
  • Responsible for Sales and Distribution, Purchasing, Inventory Management, FI and CO InfoCubes.
  • Extraction for LIS, LO Cockpit, SD, FI-GL, FI-SL and CO-PA modules.
  • Used BW Content extractors to extract data from SAP R/3 to BW. Generic R/3 Data Extraction.
  • Created/Modified Info-Sources for Master Data (Attribute and text) and Transaction Data.
  • Modified the user exits to populate the custom fields added to the Datasources. V3 Updates, controlled by pull/push principle from OLAP system.
  • Created/Modified and activated Transfer Rules and maintained Communication Structures.
  • Created and Scheduled Info-Packages for Delta Initialization and Delta data loading.
  • Set the Update Rules for InfoCube and uploaded data into the InfoCube.
  • Developed ODS object to load transaction data from Infosources and defined update rules.
  • Loaded transaction data into PSA, updated data to ODS from PSA and activated ODS for reporting.
  • Created Info-Packages group to schedule Info-Packages to load master data.
  • Developed reports in Bex Analyzer/Web Application Designer. Used enhancement-RSR00001 for user Exits for Bex Reporting.
  • Developed custom Bex Queries against the InfoCubes and ODS objects using Bex Analyzer.
  • Extensively used calculated and restricted Key Figures. Created variables for the queries.
  • Created Drill through Queries from summarized InfoCube report to detail ODS data.
  • Published reports on the Web using BW Templates.
  • Trained Power users on utilizing, developing and administering BW Queries.
Confidential, San Antonio, TXSAP BW Consultant

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.
Confidential, Clayton, MO SAP BW Consultant

Environment: SAP R/3 4.0B, ABAP Query, Modules: MM, SD, FI and PP

Responsibilities:

  • As a team of three, performed the tasks of data design, data modeling, data extraction and BEx reporting.
  • Involved in gap analysis, study of business content for the client’s requirement.
  • Setting up customized InfoCubes with optimal star schema, InfoCube partitioning for query performance. General ledger (0FIGL C01), accounts payable transaction data (0FIAP C02), published key figures (0COPA C01) and quick start (0COPA C03) is customized according to the client requirement. ODS objects are created for data staging before InfoCube loading.
  • Worked on InfoSources for general ledger (0FI GL 1), accounts payable transaction data (0FI AP 2), Profitability analysis quick start (0CO PA 3).
  • Involved in creation of update rules, modifying communication structures and support InfoPackage creation, and delta load.
  • Setting multiple source systems including flat file. Setting ODS, and Combination ODS from different modules. Done SAP delivered business content loading.
  • Setting transfer rules, writing transfer routines, writing update start routine, and update routines. Handled event scheduling and Monitor settings.
  • Resolve and implement BW query debugging (Day to Day) and change requests. Developed web reports using BW’s Business Explorer. Published reports on web using Web Application Designer. Involved in testing reports based on various roles. Created Ad-hoc reports.
Confidential, Minneapolis, MN BW Consultant

Environment: SAP R/3 4.0B, LSMW, ABAP Query, And LDB, Modules: MM, SD and PP

Responsibilities:

  • Worked for BW-CRM integration area like Survey Confirmations, Activities, Campaign Management, Opportunity management, Warranty Claims, Project Management system, Territory Management System, and Logistics.
  • Build and enhance BI objects such as InfoObjects, InfoCubes, Multi Providers, InfoSources , Update Rules, ODS, Extractors, Infosets, Aggregates, Process Chains, Start/ End Routines, User Exits, and BADI.
  • Configured SAP Business Warehouse in support of requirements from the business community and projects. This includes both SAP BW objects and the CRM Based BW Extractors/User Exits.
  • Responsible for timely delivery of systems solutions, configuration and business process results within a project or enhancement request.
  • Involved in activating standard InfoCubes in SD and FI modules like 0SD C03, 0FIAP C02, 0FIAR C02, 0FIAR C03.
  • Involved in Performance tuning for extract structures, queries with aggregates and data load performance.
  • Loaded transaction data into PSA and updated data from PSA to ODS and finally activated the ODS to enable reporting.
  • Analyzed and corrected production problems as they occur in the SAP BW & CRM system.
  • Configure, validate and promote requested enhancements to existing BW/CRM solutions.
Confidential India BW/ABAP Consultant

Environment: SAP R/3 4.0B, LSMW, ABAP Query, And LDB, Modules: MM, SD and PP

Responsibilities:

  • Created report to provide information about all the materials which are kept under inspection on date, selection are based on Plant, Material No., Storage Location, Batch no., For QM, MM Modules.
  • The above reports display the Sales Order and corresponding customer number in basic list. The details of sales order could be obtained by clicking on the sales order no., similarly details of customers are obtained by clicking on customer no. Selections are based on Year, Sales Order, and Customers.
  • Created process to upload data from Legacy System to SAP system for customers.
  • Designed user friendly screens using Workbench tools- Screen Painter, Menu Painter for End users.
  • Assigned Transaction Codes and Area Menu to Module Pool Programs for specific users.
  • Generated reports using ALV Grid and Simple ALV.
  • Created logical systems and Partners profile.
  • Created IDoc to transfer data from one client to another using communication process ALE.

Hire Now