We provide IT Staff Augmentation Services!

Bi/bo Team Lead Resume

4.00/5 (Submit Your Rating)

SUMMARY:

  • Over eight years experience in the field of ERP Implementations, SAP functional, SEM - BPS, BI-IP, BI/BW Lead, BI/BO Integration.
  • Over three years Team Lead experience for the BI Projects and Support.
  • Experience in BI- Business Objects Integration
  • Experience in creating universes and reports on top of BI Bex queries, Multi cubes and Info Cubes
  • Troubleshooting errors during BO integration with SAP BI.
  • Experience in BO report scheduling and BO report bursting.
  • Over three years of SEM-BPS experience.
  • Created and managed the user groups with object level security.
  • Created many complex reports in sales and finance area as per user requirements.
  • Involved in development of business objects universes and reports on top of BW.
  • Created multiple universes and reports in full client and Webi as per the requirements
  • Created and managed the user groups with row level and object level security.
  • Created many complex reports in sales and finance area as per user requirements.
  • Scheduled reports using BCA.
  • Experience using Import Wizard for reports, universe and database connections migration
  • Created Prototype reports using BO Voyager
  • Got trained in Application foundation 6.5.
  • Involved in creation of Sales, Inventory and Finance dashboards for Upper management
  • Created Sales In, Sales Out Dashboards for Go Live.
  • Excellent experience configuring SEM BPS planning applications for Sales & Profit Planning, Expense Planning, Income Statement Planning, Resource Planning and Balance Sheet Planning. Configuration experience includes Planning Objects like Planning areas, levels, functions, layouts etc in BPS, Aggregation levels, Filters, planning queries in IP and Info cubes, transformations, DTP, DSOs, Multi providers in BI/BW.
  • Info Cubes, Data store objects, Info Objects, Data transfer process, Transformations, Start and End routines, Analysis authorizations using RSECADMIN, Scheduling reports using Info Broadcasting, Open Hubs, New delta handling techniques, Business Content Installation, Web Queries, Portal, Info Broadcasting.
  • Info Cubes design, Info Sources, Info Object maintenance, ODS Objects, Info sets, Hierarchies, Multi providers, Update rules, Transfer rules, Info Packages using AWB.
  • Created indexes on BIA, Scheduled index fill up using Process chains
  • Very Hands on experience in BW 7.0 new implementation and up gradation from 3.5
  • Experience in migrating the existing BW 3.X security concept to BI 7.0
  • Experience in migrating the BW 3.X workbooks and queries to BI 7.0
  • Extraction data from flat files, legacy systems,DB2, Oracle, Sbase, Multiple R/3 systems and APO
  • Experience in working with IDocs, ALE, EDI, BAPI Interfaces middleware systems, MQ Series.
  • Experience working in CRM reporting for Campaign Management, Channel Management, Marketing Management and Service Management Analytics using BW
  • Hands on experience in working with Demand Planning (DP) as well as Supply Network Planning (SNP) and used to send data from BW to APO systems.
  • SD, FI-CO, FI-SL, COPA, PCA, CCA, HR, AP, AR, MM, PD, PP, APO, CRM.
  • Functional requirements analyst - Requirements gathering from end users, Delivering Functional Specs and converting to technical specs.
  • Developed the sales dashboard and published it in the SAP portal for executives.
  • Data source enhancements, generic extractors, user Exits and Logistics Cockpit configuration and customization, Data extraction from flat files for Master data and Transactional Data, update/transfer rules creation, Business Content Activation, Direct and Flexible update of Master data.
  • Created BW Data marts in APO environment, developed queries based on the data marts of APO.
  • Business Explorer Analyzer (BW3.x, BI 7.0), Query Builder, Info Set Query, Web Reporting.
  • Knowledge with MDM Objects and Clients MDM content Integrator MDM Analytics in BW
  • Data load management, event processing, experience also in Scheduling Start Process and Process Chains of Events, Data source Enhancement, OLTP extraction data, Loading (Full /Delta Up-Load), Monitoring, Remote Cubes, Data Mart and Open Hub Service, Performance Tuning, Aggregates, BW Transports.
  • Reporting, User Exits, Custom modifications.

TECHNICAL SKILLS:

ERP: SAP R/3 6.0/5.0/4.x/3.x/, SAP BW 7.0/3.x/2.x, SEM-BPS 3.5, BI-IP 7.0, APO4.1/3.0, CRM, MDM5.5

Functional Areas: FI, HR, AP, AR, SD, MM, PP, APO, CRM,FSCM,DM,IM.

Databases: MS Access, SQL Server, and Oracle8i/9i/10g

Data Modeling: Star schema, Snow Flake, Tools (ERWIN, MS VISIO)

Data Warehousing Tools: Data stage, Informatica, Business Objects, Cognos

Languages: ABAP, C, C++, Java, SQL, PL/SQL, VB, VB.NET, Perl, PL/SQL

Reporting Tools: BEx and Web Application Designer (WAD) 7.0/3.x, Business objects XI R3,XI R2, 6.x, 5.1.x, WEBI, Voyager, Crystal Reports, App foundation 6.5.,MS- Excel, Crystal reports 8.5

Dash Boards: Xcelsius, BI WAD 7.0/3.x

Web Technologies: HTML, DHTML, XML, JSP

Operating Systems: UNIX, SUN Solaris, Linux, Windows 95/98/NT/2000/XP/VISTA, MS-DOS

PROFESSIONAL EXPERIENCE:

Confidential

BI/BO Team Lead

Responsibilities:

  • Was the Team Lead and responsible for the project deliverables.
  • Created Functional and technical specification for BI Reporting.
  • Was responsible for BI-BO integration
  • Imported users from SAP and created the user security in BO CMC
  • Installed BO Dev, Quality and Production Severs
  • Was responsible for troubleshooting BI-BO reports
  • Created variables in BO universe
  • Responsible for Migration of report, universes and database connection using Import Wizard.
  • Created prototype reports using BO Voyager.
  • Created Sales, Finance, COPA, Marketing and Vendor transactional and master data report in Business Objects
  • Experience in merging BO queries and creation of Sales, Delivery, Shipment and Finance reports.
  • Created and modified universe, universe parameters
  • Actively involved in report scheduling and bursting
  • Worked with SAP on resolving the BI-BO integration issues.
  • Worked actively with users for collecting reporting, security requirements
  • Trained users in creating business objects reports.
  • Created user manuals for creating reports in business objects for power users.
  • Created GO-Live sales dashboard in Xcelsius for upper level management,
  • Actively involved in Performance tuning
  • Maintained extensive technical documentation throughout the project
  • Worked on LO-Cockpit FI-AP,AR,IM,CO,DM,CM, P2P, GTS extractors
  • Build the data sources using Function Modules
  • Created Info Objects, Transformations, Data Transfer Process and Data targets to load Master and Transactional data from ECC to BI system.
  • Implemented BI Accelerator(BIA) to improve the Query Performance
  • Created indexes in BIA.
  • Scheduled process chains to rollup the BIA indexes

Environment: BI 7.0, Business Objects XI R3.1, Voyager, Info View, Crystal Reports,CMC, Xcelsius, ABAP/4, R3 5.0, SD, FICO,P2P,AR,AP,IM,CM,DM,COPA, BEx, Web Reporting, WAD, VC Code, BADI, Macros, Oracle, Windows VISTA, Apache, Tomcat

Confidential

BI Team Lead

Responsibilities:

  • AFS: Design and developed the AFS Master data for Material, Customer, and Grid fields like Color, Frame size, Gender etc
  • Was the Team Lead and responsible for the projects and the Production Support.
  • Created Functional and technical specification for Business Planning Process of the AFS Business in helping forecasting monthly and yearly.
  • Created several Planning areas and multi-planning areas for actual and various planning versions, planning levels, planning packages, planning folders, and data slices. Developing Planning functions and parameter groups such as formula using FOX, copy, repost, revaluate, currency translation, distribution, and allocation.
  • Created IP Templates Aggregation levels in IP, manual planning layouts, planning functions for Sales pricing, product costing and expense planning and worked with variables and new functionalities.
  • Used IP for Cost Center Planning and BPS for Sales, Margin and COGS planning.
  • Created allocation functions in BI for allocating the expenses to customer/product level.
  • Created Global Planning sequences, used them in process chains for executing in Background.
  • Used characteristic relations for deriving attribute values and creating Characteristic combinations.
  • Used FOX and ABAP exits for complex functions in planning.
  • Maintained extensive technical documentation throughout the project
  • Worked on LO-Cockpit Extraction for the Inventory Management i.e. 2LIS 03 BX(Stock Initialization), 2LIS 03 BF (Material Movements), and 2LIS 03 UM (Revaluations) and also responsible to send the IN - OUT Stock actual information to APO system
  • Extractor Enhancements: Enhanced the 0FI GL 4 extractor to do multiple loads per day - which facilitates the use to see their G/L data with 30 mins delay instead of one day delay
  • Enhanced the 2LIS 03 BF,BX and UM extractors with Grid fields as well as with custom structures (AFS specific)
  • Build the AFS specific data sources using Function Modules and activated the AFS specific data sources from SAP - AFS Consumption Order - Delivery - Schedule Line Data (2AF SD SLS 2), AFS Sales Order Schedule Line Data (2AF SD SLS 1)
  • Created Info Objects, Transformations, Data Transfer Process and Data targets to load Master and Transactional data R/3 system into BW system.
  • Build some VC (Virtual Characteristics) code to solve some of issues in the executive reporting
  • WAD reporting and Publishing, Reporting Agent, Information Broadcast:
  • Responsible for the Executive sales dash board which uses charts, Jump queries, Drill down reports, HTML programming and complex data levels combination
  • Generated SD cubes using standard LO cockpit extractor, data is extracted from R/3 using standard Info sources like Billing-item-2LIS 13 VDITM, Deliveries-item-2LIS 12 VCITM and Order-item-2LIS 11 VAITM
  • Implemented BI Accelerator(BIA) to improve the Query Performance
  • Created indexes in BIA.
  • Scheduled process chains to rollup the BIA indexes
  • Involved in the Production support on Weekly basis as well as Ticketing (Heat) basis
  • Involved in the design part of lot of on going issues in the APO, BW, CRM, Retail systems

Environment: AFS, SEM-BPS 3.5, BI-IP 7.0,BW 7.0/3.5, ABAP/4, R3 5.0, SD, FICO,MM, BEx, Web Reporting, WAD, VC Code, BADI, Macros, DB2, Informix, WindowsXP, HYPERION system, Windows

Confidential

Sr SAP SEM-BPS Consultant/ BW Lead

Responsibilities:

  • Rolled out a full Profitability Analysis and Planning project in SAP configuring CO-PA, BW and SEM-BPS. Upgraded BW system from 3.5 to 7.0.
  • Involved in all phases of project from Blueprinting, Configuration, Development, Integration Testing, Cutover, and Training to Go Live.
  • Completely responsible for the Design and Configuration of the COPA, BW and SEM-BPS modules for the flow of actual and plan data to/from R/3 and SEM/BW.
  • Completely responsible for SEM BPS development for custom developed Planning Areas for Sales & Profit Planning.
  • Used FOX for complex planning functions involved.
  • Designed the Planning Layouts with WEB Interface for Planning Sales at different levels of aggregation for different Sales Managers, Product Managers and the Regional Directors.
  • Was the Project lead for the BI7.0 Upgrade project from BW 3.5.
  • Was the Team lead for BI production support.
  • Responsible for migration of 3.5 analysis authorizations to BI7.0 using RSECADMIN.
  • Created new roles in RSECADMIN and assigned it the Composite roles which were assigned to the users.
  • Managed the BW and SEM Security by creating Roles and Authorizations for different users.
  • Worked in the new SAP 7.0 GUI rollout to the users
  • Responsible for migration of workbooks from BW 3.5 to BI7.0.
  • Using new features of BW 7.0 DTP, Data store objects, Transformations, Data source tree navigation, convenient flat file extractions, ETL extractions and reusable transformations
  • Creating reports in Bex analyzer (BW 7.0) and training end users and BW developers on this new functionality and advantages of new options added to this version
  • Worked with BI accelerator to improve the Performance
  • Created and maintained indexes on BIA.
  • Scheduled index rollup job using process chains.
  • Experience in working with BI 7.0 business content.
  • Worked on Integration Test scripts preparation was the major task in the up gradation plan
  • Researching on the issues in BW7.0 and working with new features and advantages in the BW 7.0 architecture
  • Worked with SAP in resolving many issues for upgrade like Bex Analyzer 7.0 issues, data load issue between Data stage (ETL tool) and SAP BW.
  • Coordinated between basis and BW team and was responsible for monitoring the BW size growth.
  • Worked in Info Broadcasting for broadcasting the commission reports to the sales agents.
  • Extensively worked on COPA extractors and Profitability reports, FI-GL, AR and AP modules
  • Used 0FI AA 001 (Annual Values) extractor to do some Asset Accounting Reporting
  • Worked on LO-Cockpit Extraction for the Inventory Management i.e. 2LIS 03 BX(Stock Initialization), 2LIS 03 BF (Material Movements), and 2LIS 03 UM (Revaluations) and also responsible to send the IN - OUT Stock actual information to APO system
  • Worked on building Sales Overview Info cube for summarized sales, deliveries and Billing Information. Also Created Multiprovider on Sales, Deliveries and Billing Info cubes Sales Analysis, Daily Booking and Shipments, Gross Margin, Price and Currency Impact, Sales Trend etc report from COPA and SD info cubes
  • Worked on custom reports like vendors without materials, materials without vendors, spend data by material group, consolidated spend history, and purchase price variance.
  • Assigned data sources, maintained transferred rules, update rules, routines and managed data loads for both master and transactional data for ODS, and Info Cubes
  • Involved in Developing front-end queries using Query Designer and Web Application Designer, publishing results on the web, creating roles and assigning reports to the roles (PFCG)
  • Developed different types of queries like Jump Query, Pre query and reporting variables and VB Macros and standard report templates
  • Created and Scheduled Jobs, Process chains (RSPC) and Info packages to load and monitor
  • Worked on scheduling and bursting Bex reports using Info Broadcasting.
  • Extensively did the Performance tuning to ensure Data load and Query performance. Used Aggregates on cubes, Indexes, Compression techniques, Zero record eliminations and RSRT to debug reports
  • Involved in the preparation of business process documentation and knowledge transfer to the other team members.
  • Actively involved in requirements gathering, Reporting specs design, reporting consolidation, source systems switching.
  • Involved in Business objects development on top of BW
  • Created multiple universes as per the requirements.
  • Creating and managing the user groups with row level and object level security
  • Created many complex reports in BO in sales and finance area as per user requirements.
  • Scheduled reports using BCA
  • Created reports in WEBI.

Environment: SAP GUI 7.0/6.40, SEM-BPS 3.5, BW 7.0/3.5/3.0b, R/3 5.0,6.0,SD, FI-CO, AP, AR, CO-PA, ABAP/4, Data Stage 7.5.2, Oracle 9i, Bex Analyzer and Browser, WEB Reports, ALE, ALV, IDOC, Business Objects 6.5.2, Web Logic 7.5, MS Excel, Windows 2003S/XP/NT, MS Project.

Confidential

Sr SAP BW Consultant

Responsibilities:

  • Completely responsible for the Design and Configuration of the SEM-BPS for the flow of actual and plan data to/from R/3 and SEM/BW.
  • SEM/BW tasks include studying the Business Process and Designing the whole Landscape and Architecture for SEM-BPS and BW configuration.
  • Completely responsible for SEM BPS development for custom developed Planning Areas for Sales Merchandize & Inventory Planning. Used FOX and ABAP for complex planning functions involved.
  • Extensively used ABAP function Modules for complex planning functions and better performance.
  • Designed the Planning Layouts with Interfaces for Planning Sales at different levels of aggregation for different Sales Managers, Product Managers and the Regional Directors.
  • Created different layouts for Daily Sales planning, Monthly Category planning and Store level planning.
  • Different layouts and functions for Planners, Forecasters and Administrators
  • Extensively worked on APO extraction and reporting.
  • Created remote cubes for real-time operative reports directly from Live-Cache on the planning areas in APO.
  • Integrated Actual Inventory data with plan data from APO in BW and created consolidated reports
  • Created process Chains, Data load strategies for different versions at different times. Used Events to trigger the process Chains after completion of Jobs in APO.
  • Created reports like Inventory status report, Inventory aging report and Actual Vs Production Plan report on APO and Inventory Management data.
  • Implemented FI-CO, SD, HR and Profitability Analysis project in SAP configuring BW. Upgraded BW system from 3.0 to 3.5
  • Involved in all phases of project from Blueprinting, Configuration, Development, Integration Testing, Cutover, and Training to Go Live.
  • Was the team Lead for the Production support team and managed the Off shore team after going Live.
  • Actively involved in BW standard business content installation, data modeling and designing Info Cubes and ODS Objects with various aggregate levels
  • Designed and developed custom Info cubes, ODS and Info objects to support the multidimensional data model for SD and MM
  • Created SD cubes using standard LO cockpit extractor, data is extracted from R/3 using standard Info sources like Billing-item-2LIS 13 VDITM, Deliveries-item-2LIS 12 VCITM and Order-item-2LIS 11 VAITM
  • Created HR Employee data models using extractors 0HR PA 0 and 0HR PA 1.
  • Responsible for setting up of Delta extractions specific to LO cock pit Extraction.
  • Worked with business users for Head count reports, Performance reports, Pay roll adjustment reports
  • Created Sales queries like Billing, Booking and Backlog queries by customer, Sales area and region.
  • Created Reconciliation Queries for users for data analysis and to tie up with Source Data.
  • Extensively used, Exceptions, Conditions while creating queries.
  • Created and involved in the development of Accounts Receivable and accounts payable Transaction data, Line Items, Payment History cubes.
  • Created Formula Conversion Routines using Transformation Library to create formulas for Concatenation, Date Change and String Manipulation.
  • Used job-scheduling tools (process chains and event handling) to load data.
  • Was involved in creation of AR, COPA Queries like payment history, Overdue analysis, Due date for net payment analysis etc.
  • Created operating concern attributes, characteristics and value fields, maintain derivation tables, structures and rules for profitability Analysis (CO-PA). Defined PA settlement structure and CO-PA cost center assessment.
  • Used Key Dates as part of HR query building for Time dependent Master data
  • Worked extensively creating BEX queries Using Navigational attributes, Filters, Exceptions, Conditions, Structures, Cell definitions, Jump queries (RRI), Variables, Hierarchies, Created templates for WEB Reports
  • Used Key Dates in query building for Time dependent Master data
  • Expertise in writing user exits for reporting, writing routines in update rules and transfer rules and in using functional modules.
  • Created custom report called forecast variance report which compared actual data from 2LIS 02 ITM and planned data from APO Data Sources.
  • Generated Data Sources in APO. Created real-time reports out of remote cubes in APO.
  • Created Backup info cubes for multiple versions of plan data in APO.
  • Worked on Conversions of existing reports of R/3 and other reporting environments to BW.
  • Involved in Performance tuning for various loading issues from source systems, Maximum size of a data packet, no of processors. Query performance issues like using appropriate objects while construction of Query. Building Aggregates, using line dimensions managing dimension tables
  • Extensively used ABAP Routines in Transfer Rules and Update rules to load and update data into Data Targets
  • Mainly responsible for the maintenance of the data models, data loads, reports after go live.
  • Conducted Training for End-users and Project Team members. Developed BW training documentation for different users based on their roles.
  • Actively involved in requirements gathering, Reporting specs design, reporting consolidation, source systems switching.
  • Involved in Business objects development on top of BW
  • Created many sales reports in BO on top of BW in 6.1b.
  • Involved in testing and reconciliation of BO reports.

Environment: SAP SEM-BPS 3.5, BW 3.5/3.0b,APO 3.0,SAP R/3 4.7, FI-CO, AP, AR, CO-PC, CO-PA, HR, ABAP/4, Oracle 9i, BEx Analyzer and Browser, WEB Reports, ALE, ALV, IDOC, Batch Data Conversion (BDC),Smart Forms, Web Logic 7.5, MS Excel, Windows NT, MS Project.

Confidential

Sr SAP BW Consultant

Responsibilities:

  • Interacted with management and identified Business requirements, analyzed reports in Controlling, Cost center allocation and Purchasing application areas.
  • Enhanced the existing info cubes as per the user requirements.
  • Created the Cost Center accounting info cube for all costs and quantities for marginal costing on cost centers that were transferred from the connected source systems Designed and developed the Profitability analysis cube and then connect a productive Profitability Analysis application (CO-PA) to an SAP BW System quickly and with minimal effort.
  • Used the SAP delivered queries to analyze your live data in SAP BW for testing and demonstration purposes
  • Extensively used ABAP Routines in Transfer Rules and Update rules to load and update data into Data Targets
  • Created Formula Conversion Routines using Transformation Library to create formulas for Concatenation, Date Change and String Manipulation
  • Created Info sets, Multi Providers, Queries and workbooks; user variables, calculated key figures, restricted key figures, structures, conditions, exceptions and reporting agents.
  • Created, Scheduled and monitored info packages and created process chains to load data from R/3 and flat files, perform aggregate rollups, index maintenance, master data and ODS data activation
  • Thoroughly analyzed Short Dump and Application Log reviews to debug errors
  • Developed front-end queries using Query Designer & Web Application Designer and published results on the web. Built formula variables and also processed variables using replacement path and customers exit. Developed different types of queries like Jump Query, Pre Query. The results from the Order view cube will be used to query from resource view cube. Queries were developed to jump from summarized cubes to other ODS or Cubes for further details
  • Got trained in business objects
  • Involved in development of business objects reports
  • Created reports by using many advanced reporting techniques like Drill down, Cross tabs, Alerters, Hyperlinks etc.

Environment: BW 3.0b/3.0a, SAP R/3 4.6c, FI-CO, FM, MM, SD, CO-PA, PCA and CCA, ABAP/4, Oracle 8i, BEx Analyzer and Browser, WEB Reports, ALE, IDOC, Batch Data Conversion (BDC),Smart Forms, Web Logic 7.5, MS Excel, Business objects 6.1b/6.5, Webi 6.1b/6.5,Windows NT, MS Project.

Confidential

Sr SAP BW Consultant

Responsibilities:

  • Implemented FI-CO, SD, PD, HR, COPA in SAP configuring BW.
  • Involved in all phases of project from Blueprinting, Configuration, Development, Integration Testing, Cutover, and Training to Go Live.
  • Involved in designing, configuring and maintaining the Data Models for BW.
  • Generated SD cubes using standard LO cockpit extractor, data is extracted from R/3 using standard Info sources like Billing-item, Deliveries-item, Order-item, Booking, and Shipment.
  • Created operating concern attributes, characteristics and value fields, maintain derivation tables, structures and rules for profitability Analysis (CO-PA). Defined PA settlement structure and CO-PA cost center assessment.
  • Worked on Conversions of existing reports of R/3 and other reporting environments to BW.
  • Extensively used ABAP Routines in Transfer Rules and Update rules to load and update data into Data Targets
  • Created, Scheduled and monitored info packages and created process chains to load data from R/3 and flat files, perform aggregate rollups, index maintenance, master data and ODS data activation
  • Developed Queries using virtual key figures and virtual characteristics. Developed code in Variable exit, captured values entered by user and subsequently used in Virtual User exit code. Optimized the logic to execute code based on Query selection for a given Cube

Environment: BW 3.0a/2.1c, SAP R/3 4.6c, FI-CO, PD, SD, CO-PA, ABAP/4, Oracle 8i, BEx Analyzer and Browser, WEB Reports, ALE, IDOC, MS Excel, Business objects5.1.6/ 6.1b, Webi 6.1b,Windows NT, MS Project.

Confidential

SAP BW Consultant/Sr Functional Consultant

Responsibilities:

  • Involved in the requirements gathering phase to understand the business requirements and converting them to technical requirements
  • Designed and developed custom Info cubes, ODS and Info objects to support the multidimensional data model for SD and MM
  • Generated SD cubes using standard LO cockpit extractor, data is extracted from R/3 using standard Info sources
  • Actively involved in BW standard business content installation, data modeling and designing Info Cubes with various aggregate levels
  • Created Accounts Payable and Accounts receivable Cubes based on the reporting requirements. Modified standard Info sources like 0FI AP 3 and 0FI AR 3,0FI AA 001
  • Improved Query performance by fine tuning the Reports using restricted and optimized code execution process based on query being executed. Involved in performance tuning for update rules and transfer rules
  • Developed User exit code for Data source Enhancements, Reporting variables
  • Created Info Packages and Info package groups to trigger loading jobs in sequence based on an event triggered on R/3 source system. Developed a function module to trigger all BW jobs from R/3 source system

Environment: SAP BW 2.1c/2.1b, SAP R/3 4.6c, FI-CO, IM, MM, SD, Oracle 8.1.0.4, ABAP/4, AWB, BEx Analyzer, WAD, ALE, IDOC, ODS, Report Agent, SQL Analyzer, LIS, COPA, Windows NT,MS-Excel.

Confidential

SAP Techno-Functional Consultant

Responsibilities:

  • Involved in writing the technical specifications for reports, interfaces and conversions
  • Involved in performance tuning the reports using Run Time Analysis, SQL Trace, SQL interpreter.
  • Created custom segments that are used for extending basic IDoc type
  • Used User Exit SUSR0001 for tracking the user information before logging into the SAP
  • Used User Exit for converting the quantity from base unit of measure to alternate unit of measure for the extended IDoc to load safety stock and forecast
  • Involved in loading transport orders and Independent requirements from Legacy system to SAP R/3 system using session and call transaction methods.
  • Developed screens for user-defined transactions and writing of associated modules mainly for data entry in Created tables
  • Involved in Development & maintenance of function modules for various utilities
  • Created a report to give the goods receipts by Date, Material Valuation by plant
  • Developed a program that processes the data for all materials created in specified plant/s after the check date
  • Created interactive and classical reports to list the various details of the new materials.
  • Development of reports using logical databases & ALV Grid Reports in MM, and PP.
  • Developed Tax Depreciation Year End Recap Report
  • Developed a report for revaluated assets and interest posted for each fiscal year

Environment: SAP R/3 4.0b, FI-CO, MM, SD, PP, ABAP/4 Development Workbench ALE, IDOC, RFC,BDC, Excel, Windows, Oracle 7.3, SQL Analyzer.

Confidential

ABAP Programmer

Responsibilities:

  • Involved in the development of specific reports required in the areas of FI-CO, MM and SD modules
  • Involved in active interaction with the functional consultants, tailoring and developing the applications as required by the end users.
  • Developed both classical and interactive reports for freights, stock valuation ledger report for plants, stockyard location and external processing agents and generated reports for purchase order listing.
  • Involved in the data migration from legacy system to SAP R/3 system. Developed Data Load programs for transfer of data from EXCEL files (created from Oracle legacy system)to SAP R/3 for BOM’s, Material Master, Customer Master using session method and call transaction methods.
  • Created print programs and layout sets for quotation, sales order confirmation, delivery note, invoice and purchase orders using Medruck layout set.
  • Involved in configuration of ALE layer in SAP. Defined ports, RFC destinations and Partner Profiles.
  • Carried out the following steps in the ALE layer: Receiver determination, Data selection, Segment filtering, Field conversion, Dispatch control, Error handling in Outbound and Inbound processing, setting up communication system and monitoring IDoc processing and RFC communication

Environment: SAP R/3 4.0b, ABAP/4 Development Workbench, MM, SD, FI/CO modules, ALE, Windows, Oracle 7.3

We'd love your feedback!