We provide IT Staff Augmentation Services!

Bw Ip Abap Bobj Hana Lead Resume

TX

SUMMARY:

  • Overall 16 years of IT experience, Last 14 +years working as Sr. SAP BW/ HANA, ECC, IP, BOBJ, ABAP, ETL - SLT, BODS Consultant.
  • Deep understanding of various business process followed in consumer products, manufacturing, retail, Pharmaceutical, Financial services, and automotive industries.
  • Extensive experience enabling Business transformation and creating Service Applications to improve business performance and TEMPeffectiveness.
  • Involved in Thirteen Full life cycle implementations.
  • Developed three Dashboards on Procurement Top Sheet, Financial Statements and on Project System status (PS Dashboard International) using WAD, JavaScript, and HTML.
  • Knowledge in BI Upgrades to BI 7.0/2004s. Performed Pre/Post upgrade BW Scripts when migrating from 3.x to SAP NW 2004s.
  • Participated in BW on HANA migration, upgrade of BW HANA and BOBJ systems as application specialist. Developed new data model to house and report teh external data in teh SAP HANA. Worked extensively on HDBTABLE and CDS in Hana and used SLT & BODS 4.2
  • Experience in constructing ETL process definitions, Systems Study, Gap Analysis, and Strong knowledge of ASAP Methodology.
  • Extensive experience and commendable knowledge on Data Modeling and extracting data from different modules of R/3, CRM, and legacy systems. (R/3 - SD, MM, PM, PS, HR, FI-GL and legacy systems).
  • Designed and developed Complex reports using Bex Query Designer, Bex Analyzer, and published in Web Application Designer that are based on dynamic calculations depends on teh input value.
  • Extensive experience in loading huge volume of data (160 million) into BW. Developed load plans for huge volumes using Company Codes, GL Accounts, and number range combinations of R/3 logistics data.
  • Extensive experience on SAP technical areas such as EDI, IDOC, BDC, Reports, Dialog Programs, BAPI functions, Function modules, Data Dictionary objects, user Exits, Table exits, Report writer and Report painter.
  • Experience in teh planning and simulation modules of BW BPS such as Sales Planning, Profit Center Planning, and Forecasting. Multi-tasked post-production support and development of new design cycles simultaneously.
  • Worked extensively on distributing Variance reports with SAP Information Broadcasting
  • Experienced in Software, Manufacturing, Pharmacy, Retail, and Food Industry.
  • Core knowledge of BW security and authorizations.
  • Excellent communication skills, systematic approach and ability to work TEMPeffectively in fast paced environments

PROFESSIONAL EXPERIENCE:

Confidential

BW IP ABAP BOBJ HANA Lead

ACCOMPLISHMENT:

  • Lead SAP BW/BW-IP Solution consultant/architect in teh implementation of IP for South America and North America to provide teh Input for Forecast of Volumes, Expenses, Materials Cost, OPEX and HR.
  • Designed and developed different Rate templates at different level of input and transferred teh data using Fox code at material level to use for teh existing IP YNA Material Cost templates on teh new Rate calculations.
  • Developed Fox code for expenses calculations, allocations and copying teh data from one level input entry to detail level of data based on teh reference data.
  • Designed and created teh Retraction process of teh forecast history of each version data from BW to ECC.
  • Developed teh daily cost management solution in multiple phases. Requirement gathering from different sources and prepared teh initial architecture diagram of teh data modelling till teh reporting.
  • Developed teh Daily Cost Management backend logic with complicated ABAP expert routine to regional office allocation based on teh 4 different categories at each plant region and Fiscal Period calculations.
  • Used teh Semantic Groups extensively at each region level for allocations for DCM project.
  • Created teh Cell definition based Bex Query to group teh Cost Centre and cost element groupings for 48 plants and 11 Regions.
  • Developed formula variable to calculate runtime for projected produced Ma Hours calculations.
  • Developed teh ABAP logic to avoid teh data errors in teh daily and monthly Flat File data loads. While data load in process program reads teh files and check teh errors and send email alerts.
  • Implemented Work centre hierarchy data load using ABAP program to avoid multiple info packages for each node.
  • Developed teh complicated DCM BOBJ Webi report with run time calculations formatting.
  • Changed teh existing design of Manufacturing Execution Report.
  • Developed teh cost centre and cost element groupings from Bex into backend based on teh reference table.
  • Designed and developed teh full implementation of PM module.
  • Developed Flex Planning Production Schedules by Product Group report using VB Macros to meet Excel formatting.
  • Developed BW BO Usage report based on teh BW technical content Audit Universe and Flat files.
  • Worked as part of SAP America team as SAP BW/HANA consultant in migration of existing DB06 BW into to SAP HANA 10.1.
  • Assisted teh client with pre and post migration planning.
  • Performed pre and post DMO functional step to clean up teh system and conversion of existing objects to HANA relevant.
  • Participated before and after migration testing of reports & data loads and provided solutions to teh issues as part of post migration activates.
  • Configured smart data access for SAP IQ server as part of NLS archiving solution for cold data.
  • Provided after go-live support after very successful go-live migration of DB6 to Hana 10.1.

Confidential

BW BOBJ Lead

ACCOMPLISHMENT:

  • Developed teh complex billing solution and provided teh data into teh Open Hub to further extract into teh Oracle system for reporting.
  • Extracted teh AR data into BW and build reports in teh BOBJ.
  • Schedule teh BOBJ reports to send email every day.

Confidential

BW CRM APO HR IP Lead

ACCOMPLISHMENT:

  • Involved and Analyzed requirements with business team meetings regarding commodity contracts, quotations and Sales adjustments on Demand Planning.
  • Designed and implemented Commodity Data flow from SAP ECC, CRM, and APO into teh BW.
  • Prepared dataflow diagram, source field mapping and technical specification documentation. Lead teh onsite and offshore team. Provided teh detailed level technical documentation for development.
  • Requirement gathering on NRM Calculations for New Contracts, Open Contracts, Quotations, and Cost Net, based on teh Cost Groups, Materials and Plant.
  • Extracted Sales order header, Item schedule line and shipment data into BW.
  • Developed Open Hub to load Baseline Stat Forecast cube data in APO and created RFC program to extract data into ECC.
  • Built Custom Extractors to extract data from Commodity custom tables into BW.
  • Developed Delinquency, NRM Transfer, NRM Open Contract reports for Forecast with actual based on teh aggregation logic.
  • Extracted CRM Opportunities and APO Demand Planning data for Sales Adjustment from Current Month to next five years using IP and WAD as front end.
  • Developed Planning Layout using IP for Sales adjustments on top of APO Forecast data and CRM Opportunities data.
  • Created Fox Formulas for master data lookup, Sales Adjustments % into monthly buckets.
  • Developed SDSK QM Notifications reports based on teh ECC customer query.
  • Extracted QM item Notifications into BW and integrated with Notification Master Data in teh Update Rules based on teh reporting requirement logic.

Confidential

BW APO Lead

ACCOMPLISHMENT:

  • Designed and implemented teh BW APO Demand Planning Application.
  • Involved in IT meetings with Business Groups to take Project Objectives, Scope, Timeline, Strategy and resources.
  • Developed open order quantity cube and Actual Sales Cube to load into APO system.
  • Created Data Marts to load APO data.
  • Designed data modeling for master data objects and transactional cubes according to teh reporting requirements.
  • Created Function Module to get teh prior 12 months date for WaterFall Report, Routines, and Customer Exits for APO Demand Plan Application.
  • Developed APO Forecast reports.
  • Solution provided for Query performance for Sales, Inventory and APO data.
  • Implemented BI Analysis Authorization in SAP APO Forecast Layouts.

Confidential

Sr. SAP BW BO

ACCOMPLISHMENT:

  • Responsible for teh implementation of teh SAP BI system for teh Chocolate and Sugar Confectionary Products business integrating legacy systems.
  • Interacted with end-users and business analysts to identify and develop business requirements and transform it into technical requirements and lead for delivering teh HPS (Hershey Profitability Systems) solution.
  • Extracted Hershey Profitability and Finance Data from R/3 system and inserted into Teradata through SAP BW.
  • Designed teh datawarehouse architecture with its various integration points and interfaces coming into to SAP BW system.
  • Build HPS P & L analytics universe on top of Teradata.
  • Developed variables, Block level filters, and report level filters in WEBi.
  • Extensively used Customer, Profit Center, and Brand Hierarchies in teh Report level Filters.
  • Responsible for teh completion of teh key deliverables on time, primarily teh implementation strategy, cube design documents and query design documents.
  • Reporting strategy. Led teh team through teh development phase and addressing key technical challenges and resolving them.
  • Integrated teh SAP Business Objects Xi 3.1 to teh SAP BI datawarehouse and Teradata. Designed and developed OLAP and OLTP Universes.
  • Developed and exported Business Objects Reports to refresh automatically via Broadcast Agent monthly at specific time with pre-defined conditions (filters).
  • Used Slice and Dice, Drill Down, Filters, Master Details, Cross Tab and formulas and developed Hierarchies to support drill down reports and created complex variables, multiple breaks and sorts in teh reports.
  • Developed formatted Financial P & L reports using WEBi.
  • Interacted with teh Teradata team to improve teh model of teh Data Mart, which helps in performance tuning and query optimization while generating reports.

Environment: Windows XP SAP BI 7.0(NW2004s), SAP R/3 ECC 6.0, Business Areas: FI, COPA, PCA, BOBJ 3.1. Teradata

Confidential

Sr. SAP BW BO IP Technical Lead

ACCOMPLISHMENT:

  • Lead a team of technical/functional consultants for teh SAP BW BO and IP implementation.
  • Designed functional specifications and stage gate review documents for Sales Planning Application and BW BO usage integration in WEBi.
  • Developed separate data flows for BW and BO usage Universe’s as per functional specifications.
  • Using Open Hub and Data Stage created teh BW data flow into teh Oracle database in order to create separate Universe for BO Activity Universe and BW Technical Content Universe.
  • Integrated BW, BO Universe data at WEBi document level based on teh People Soft Master Data.
  • PublishedCrystal Reportson toBusiness Objects Infoviewand provided access to teh end users.
  • Developed Planning applications based on different business segments (BMG and OCV).
  • Developed Aggregation Levels, filters, Planning Functions, Planning Sequences and Process Chain for Distribution.
  • Maintained Characteristic relationship to derive Product Hierarchy levels, payer, Customer, Sold to, Ship to, Business Unit, Business Segment, Sales Region, Sales Area while planning in planning applications by planners.
  • Created Fox Code for data distribution from Sales Region to Sales Territory.
  • Programming function modules and methods to use with planning functions, characteristic derivation, Currency Translation and data slices.
  • Developed Currency Translation function by using Formula type Planning function to transfer currency from different local currencies to group currency as per user entered exchange rates
  • Developed Sales Plan application layouts using Bex Analyzer.
  • Developed consolidated reports, monthly, yearly and remaining Year forecast to date showing with Actual vs. Budget, Actual vs. Forecast data and integrated them into several Sales Planning WEBi reports.
  • Created Formula Variables for monthly plan data into number of days (Month to Date and Year to Date).
  • Developed WEBi Documents based for BW BO Usage application and Sales Planning applications.
  • BW Technical Content Data loaded into Oracle using Data Stage and created Universe integrated with BO Activity Universe.
  • Created WEBi Documents for BW BO Usage based on teh users access.
  • Build Sales Plan security Roles for planning application throughout teh landscape for Business Users.

Environment: Windows XP SAP BI 7.0(NW2004s), SAP R/3 3.1i, 4.6, 4.7, ECC 6.0, Business Areas: SD, FI, CCA, BOBJ 3.1.

Confidential, TX

SAP BW BO IP Technical Lead

ACCOMPLISHMENT:

  • Lead a team of technical/functional consultants for teh SAP BI implementation.
  • Requirement gathering, design and analysis - Work with users to identify and advise on existing infostructures updated by business events in R/3. Identify potential uses and conduct functionality gap-analysis. Identify potential solutions, implement enhancements to existing functionality.
  • Provided Business blue print and technical specification.
  • Responsible for business data modeling, data mapping, and gap analysis.
  • Interacted with business users, VP, and directors to gather, document, and assess business requirements and issues on variance analysis and reporting.
  • Developed Real Time Infocubes for Sales, Customer, and Profit Center accounting Planning.
  • Upgraded BW 3.5 to BI 7.0. Implemented Pre-Upgrade and Post Upgrade steps. Migrated Bex Queries, Web Reports. Implemented OSS notes during Upgrade processes.
  • Designed and developed custom DTPs, Transformations, Cubes, DSO, Aggregates, queries and workbooks.
  • Created Hierarchies on 0ACCOUNT, 0GL ACCOUNT and 0PROFIT CTR for financial reports.
  • DevelopedConsolidatedP&L, Balance Sheet trend Cash Flow reports, monthly, yearly and Year to date showing with Actual vs. Budget, Actual vs. Forecast data and integrated them into several financial reporting workbooks.
  • Developed Global Security Profiles. Designed Security profiles for functional users, developers, and budget users. Created Authorization based on profit center hierarchy.
  • Created and automated monthly P & L reconciliation of budget, actuals and variances
  • Created P & L Reports, Balance Sheet, Cash Flow Statement, FRP and Vision Reports.
  • Distributed P & L Workbooks to field managers across teh global using Broadcasting.
  • Pre Defined workbook time outs during broadcasting process.
  • Created Broadcasting Process Chain and created job to send emails automatically using SCOT. Distributed monthly financial reports using broadcasting.
  • Created Generic Extractor using function module.
  • Created BI based IP Planning environment architecture with Planning area, Planning level and Planning package and sequences.
  • Developed Universes Design for Financial Reports (Cash Flow, Balance Sheet, and Income Statements).
  • Created Yearly Financial Statements Dashboard using Xcelsius.
  • Created reforecasting and Budget 2010 using BI IP.
  • Developed financial Dashboard using WAD and published using BSP.
  • Transfer project related profit center accounting and BI knowledge to A-B staff to reduce reliance on external consultants and IT resources.
  • Prepare and deliver training materials station managers, technical project, business process owners and other end-users.
  • Designed Security profiles for functional users, developers, and budget users. Created Authorization based on profit center hierarchy nodes.

Environment: Windows XP SAP BI 7.0(NW2004s), SAP R/3 ECC 6.0, Business Areas: FI-GL, SD, MM, Xcelsius.

Confidential, MA

Sr. SAP ABAP BW/BI Consultant

ACCOMPLISHMENT:

  • Data modeled for G/L line Item Data to get teh account balances and transaction figures, which are key data elements for teh ‘Indirect Vendor Spend Project’.
  • Developed a BW data mart for vendor’s information, which includes all operating expenses transacted from 2 Legacy R/3 systems (BSC SAP R/3 and Guidant SAP R/3).
  • Designed two data models for G/L line item, one data flow for standard objects other data flow for custom objects and integrated into BW system. Activated and created teh business content objects and custom objects.
  • Applied ABAP code to restrict confidential “Guidant” Company Codes, GL Accounts, Vendor numbers, Cost Centers and Chart of Accounts in teh standard master and transactional datasources.
  • Resolved teh 0Vendor Master data (Kanji Language) issue that is coming from Unicode R/3 System into BW Non-Unicode system using each data record deletion from teh PSA.
  • Defined teh currency manually in teh BI system that is coming from two different R/3 source systems.
  • Developed custom delta extractor for Order Number.
  • Developed reports on Profit and Loss account, Income statement and Balance Sheet. Created Variable Exits to show teh Invoicing amount of teh respecting periods.
  • Developed queries based on client requirement. Used calculated key figures, formulas, restrictions, conditions, Exceptions in teh queries. Developed report-to-report interfaces, Published views on web.
  • Developed teh Process Chain using ABAP code for automated extraction and loading processes based on SAP BW events chain functionality.
  • Prepared teh documentation on data flow design from two Legacy system, restriction, and filter of data, Data Modeling, Unit Testing, User Training, and Report Designing objects.
  • Prepared teh Cutover Activities documentation for Go Live.
  • Performed Data Load Tuning by analyzing and adjusting, BW Statistics, Indexes, Data Packet Sizing, Number Range Buffering, Aggregates etc.
  • Performed Query performance Tuning by analyzing and applying, aggregates, line item dimensions, data compression, Query read Mode, Bit Map Index, Partition a parallel query option.
  • Developed documentation, including functional requirements, test cases, test plans, test scripts according company work instructions.
  • Involved in postproduction support activities in monitoring teh daily data loads, fix report issues, and reconciliation issues.
  • Daily Monitoring activities like Analyzing ABAP Dumps, Update Monitoring, Alert Monitors, System Traces, Lock Entries Set Alert Threshold, and Operation modes.

Environment: Windows XP SAP BI 7.0(NW2004s), SAP R/3 4.7, Business Areas: FI-GL, MM.

Confidential, NY

Sr. SAP BI Consultant

ACCOMPLISHMENT:

  • Upgraded from BW 3.5 to BI 7.0 Technical Upgrade and Dash Board implementation.
  • Interacted with teh management and business Decision-makers to identify business requirements. Documented reporting needs of teh Business Service and Support Organization and disseminated those requirements into a data warehouse strategy resulting in both operational and analytical reporting.
  • Successfully executed teh BI Upgrade strategy from BW 3.5 to BI 7.0 including Pre-Upgrade and Post Upgrade tasks (collecting system objects, Security).

Upgrade Activities:

Involved in teh Pre Upgrade Activities (3.5 to BI 2004s).

  • Running of Reports for activation of all teh Objects.
  • Running RSRV for teh Consistency Check for Master and Transactional Data.
  • Running teh Report RSUPGRCHECK Report for Checking teh Consistency Check.
  • Alpha Conversion Check.

Involved in teh post Upgrade activities (BI 2004s).

  • Involved in teh Base Line Testing
  • Migrated Library Items from 3.5 and from 3.5 to 7.0
  • Migration of teh Web Templates from 3.5 from 7.0.

Involved in teh Pre Upgrade & Post Upgrade Activities for BI Plug-In Upgrade on teh R/3 from 2003.1 SP 10 to 2004.1 SP 12

  • Emptying teh Queues (SM13 & LBWQ) by running teh V3 Jobs.
  • Deleting teh Data from teh Set Up Tables
  • Running teh Process Chains to fetch Data and Emptying teh RSA7.
  • Resolved many issues around teh Upgrade. Created OSS messages for Upgrade issue.
  • Conducted teh User Training on teh New Bex Features. Installed and configured teh BI Admin Cockpit. Successfully deployed teh New Analysis Authorization.
  • Worked closely with teh Corporate Consultants in providing Functional Specifications to enhance teh current and develop new ODS and InfoCubes. Defined Custom Cubes and MultiProviders for teh business scenarios along with aggregates.
  • Extensively worked in developing Executive Dash Board for presenting reports to teh High-level managers, utilized J2EE, Java Script, and VB script technologies for customizing web reports and present teh dashboard reports.
  • Configured Compensation Management, Organization Management, Time Management.
  • Enhanced standard datasources and replicated into BW system.
  • Created detailed reporting on Employee Time Management.
  • Developed reports on headcount, comparison of annual salary, staff positions.
  • Extensively involved in creating InfoCubes in PS module.
  • Created Process Chains to automate teh data load and data target administration and monitored teh processes.
  • Performed tuning at data loading, reporting before Go-Live. Analyzed performance statistics and recommended improvements.

Environment: Windows NT SAP BI 7.0, R/3 ECC 6.0, and Portals, Business Areas: PS, HR, FI, and APD.

Confidential, CA

Sr. SAP BW Consultant

ACCOMPLISHMENT:

  • Proactively involved in full lifecycle including BW configuration, modeling, analysis, design specification, development, performance tuning, and maintenance for “FLEET MANAGEMENT PROJECT.”
  • Interacted with business users to analyze teh requirements of reports.
  • Gatheird requirements for reporting, both for Management & for statutory consolidation of Plant Maintenance.
  • Prepared Technical documents based on teh Business blue print.
  • Created data model to meet teh business need and clients reporting needs and developed InfoCubes, InfoObjects, ODS, InfoPackage, MultiCube, and InfoProvider Objects.
  • Configured Plant Maintenance involving Service Orders, Notifications, Equipment Maintenance, Billing documents, Shipping and Billing.
  • Modified and enhanced standard DataSources on R/3 side. Created generic DataSources on tables and views and enhanced function module to populate fields on extract structures.
  • Extended master data, text and transaction data extractors using ABAP.
  • Coded ABAP for start routines, transfer rules and update rules wherever required. Created a start routine to restrict Order type from service orders, and Notification type
  • Repair Types were restricted in update routines including Avoidable damage, Wear & Tear and Overage.
  • Proactively involved in function module, which pulls data from WAS systems into BW for dealer codes.
  • Used SAP standard 0Customer as compounding to custom defined customer number.
  • Developed all critical reports in BEx analyzer, Web query, Web templates, and configured reports in Portals.
  • Created a report, which involves Virtual KF, to find beginning and Ending estimated hours based for Cost Per Hour Utilization Report on teh user input date range.
  • Developed Web Printing using SAP standard functional modules with Java Script.
  • Performed BW security and authorizations and created reporting roles and maintained security at InfoObject levels for different dealers.
  • Conducted training for end-users. Developed business process documentation.

Environment: SAP BW 3.5, Bex Query Designer, WAD, Portals, and SAP R/3 4.7, Business Areas: PM, SD.

Confidential, MN

Sr, SAP BI Consultant

ACCOMPLISHMENT:

  • Analyzed user assigned reports and business needs for SCM reporting and possible enhancement of extractors to cover Bex Reports.
  • Interacted with Business Analysts, Functional Team, Central Data Repository group, R/3 SD, SCM group to prepare teh data mappings from R/3 to BI based on data transformation and conversion from legacy to R/3.
  • Responsible for SCM, and SD Procurement, Inventory Management and Order Fulfilment.
  • Analyzed Business needs for procure to pay (PTP), Order to cash (OTC) workstreams and created business events to meet solutions.
  • Used ABAP program to activate DSO/Infocube update rules in Data Mart..
  • Developed custom queries and used standard queries for Inventory Management, Procurement, and Order Fulfilments.
  • Created reports to monitor Material Movements, Dead Stock, and Stock over Flow slow moving items and stock quantity.
  • Analysed and Designed queries for open order values to incoming order values and credit memos to billing document.
  • Created queries using Bex query designer and Web Application Designer. Used various web items and setup for workbooks and queries.
  • Involved in Pre Upgrade and Post Upgrade activities according to teh documentation.

Environment: SAP BI 7.0, SAP R/3 ECC 6.0 and Portals, Business Areas: SD, SCM.

Confidential, IL

Sr. SAP BW Consultant

ACCOMPLISHMENT:

  • Gatheird and analyzed requirements from Business Analysts and Senior executives.
  • Analyzed report requirements, translated these requirements into dimensional data modeling using star-schema, and extended star-schema data modeling techniques.
  • Used Snap Shot method for Inventory to stage teh data before transferring teh ODS contents to teh Info Cubes.
  • Created custom extractors and wrote user exits in ABAP.
  • Customized standard Business Contents objects including, master data, text, hierarchy, and transaction data objects.
  • Designed web templates for various scenarios using Web Application Designer (WAD) and published teh reports to Portals creating iviews. Responsible for creating Management Cockpit/Dashboard using Web Application Designer (WAD)
  • Created Dashboards for Procurement Top sheet using warehouse management.
  • Developed Procurement top sheets with Inventory Control, Purchasing, and Stock Keeping.
  • Designed and developed reports for Dollar value and quantity of MRP types V1 and PD materials, Aging Inventory in number of days, Dollar value of Warehouse with Channel value.
  • Developed Process chains, created messaging system and troubleshooted data loading with process chains.
  • Customized WAD reports using HTML, and Java Script coding.
  • Transported objects both in BW and in R/3 landscape.

Environment: Windows NT, SAP BW 3.5, R/3 4.7 and Portals, Business Areas: MM, SD.

Confidential, AZ

SAP BW Consultant

ACCOMPLISHMENT:

  • Proactively participated as a team member in discussions with business analysts and end users for Data Modeling, Business Content, Granularity, and Performance Tuning.
  • Analyzed ERM, MDM and translated it to BW design. Identifying teh Key Figures, Strong Entities, and Attributes of teh entities, Archiving, Time Frame for Loading etc.
  • Generated a Report for extracting Payroll Results (Gross Pay and Net Pay) of Employees for specific Pay Periods.
  • Responsible for building a BW Metadata tool that enables teh production support team to identify and eliminate objects not in use.
  • Trained technical personnel on BW, BEx Reporting, Web Reporting, and knowledge transfer.
  • Evaluated of a suitable financial planning package based on business needs and current IT infrastructure.
  • Implemented teh Planning Functions, Data slices, Validations.
  • Created Transactional InfoCubes required as a data basis for teh SEM BPS.
  • Worked with Planning Areas, Planning levels, Packages, Layouts, Folders, and Planning Sequences in implementing SEM-BPS.
  • Created Planning Variables.
  • Created Planning functions and Parameter Groups.
  • Created FOX Formula and EXIT Functions to meet various planning requirements.

Environment: SAP BW 3.5, SAP R/3 4.6C, SEM BPS, Business Areas: SD, MM, HR.

Confidential, MN

SAP BW Consultant

ACCOMPLISHMENT:

  • Responsible for designing and creating Sales, Delivery, Billing, Open orders in Logistics.
  • Performed Dimensional Modeling and extended Star Schema Modeling.
  • Created, Modified and Activated business content extractors, InfoObjects, InfoSources, InfoCubes, Multi cubes and ODS according to teh reporting requirements.
  • Created and enhanced CRM quotes and Sales contract item data sources. Created custom data sources based on tables, views, and function modules. Created user exits both for extractors and to populate variables.
  • Used aggregates to improve teh query performance.
  • Developed many queries based on client requirement. Used calculated key figures, formulas, restrictions, conditions, Exceptions in teh queries. Developed report-to-report interfaces. Published views on web.
  • Developed number of generic extractors for teh customer Price protection table.
  • Worked extensively with OSS notes to fix teh problems.

Environment: UNIX, SAP R/3 4.0B, SAP BW 3.1C, and CRM, Business Areas: SD, MM.

Confidential, TX

SAP BW Consultant

ACCOMPLISHMENT:

  • Activated teh required business contents required of SD and FICO.
  • Developed custom defined ODS and Infocube to analyze teh process of GIM process.
  • Developed custom Infocube for Special purpose ledger.
  • Developed generic extractors to extract data from R/3, which uses table view option, based on teh four custom tables (Header data, Line item data, pricing data and Text data), where in data will be populated from external R/3 and non R/3 systems.
  • Developed Delta process for Generic extractor.
  • Developed custom Info objects of types characteristic and key figures.
  • Used aggregates to improve teh query performance.
  • Developed many queries based on client requirements to analyze teh GIM process. Used restrictions, exceptions, and conditions in teh Queries.
  • Developed RRI (Report to report interface) for data analysis.
  • Worked extensively on BW authorization.
  • Downloaded Infocube content to External files.
  • Created many batch jobs for background processing.

Environment: Windows 2000, SAP R/3 4.0B, SAP BW 3.1C, Business Areas: SD, FI.

Confidential

SAP ABAP Consultant

ACCOMPLISHMENT:

  • Configured ALE/IDOC to extract customer master data and sales data from composite IDOCs.
  • Wrote custom BDC programs for data conversion / interfaces for loading Customer Master & Vendor Master records.
  • Created and maintained data dictionary objects such as transparent tables, structures, transactions.

REPORTS:

  • Created Classical and Interactive reports to display all teh Purchase Orders for teh Purchasing Organization, Purchase groups, and display teh total and individual values of All teh Purchase Orders.
  • Developed material master details report. Inputting material and plant as Select-options and material type as parameter. Output list had total quantity by Material group and plant.

BDC

  • Worked with BDC Methods including Call Transaction, Session Method and LSMW to upload teh data.
  • Using teh standard data conversion program uploaded teh material master data from legacy system to SAP R/3 using flat files Created BDC interface for VA01.

SAP SCRIPTS:

  • Created different layout sets using transaction code SE71.Created windows, Paragraphs, Page windows according to teh client requirements and company LOGO is copied from Tiff file by using teh program RSTXLDMC.
  • Designed and assigned SAP Scripts for purchase order, transfer order by modifying Standard layout set MEDRUCK according to teh client requirements and fixed Problems such as sorting of sizes in PP shop traveller & Purchase order.
  • Created EDI development program to read IDOCs and use field contents in generating reports, flat files.
  • Developed IDOC interface program to create orders IDOC based on customer requirement. Teh source data was from customer VAN transmission.

Environment: SAP ABAP/4 4.6 Technical Consultant.

Hire Now