We provide IT Staff Augmentation Services!

Abap, Bw/bi, Abap Consultant Resume

OBJECTIVE:

Seeking a challenging career in SAP Technical consulting arena where I can contribute and augment my technical and functional knowledge and willing to utilize my skills and abilities in SAP domain that offers professional growth while being resourceful, innovative and flexible.

PROFESSIONAL SUMMARY:

  • A highly Self - motivated professional with around 8 years of professional career in IT services including 6.5 years of Experience in SAP BW, SAP ABAP along with almost 1.5 years of experience in SAP HANA as HANA modeler.
  • An Effective blend of good business knowledge with extensive Technical knowledge utilized to deliver projects which include end to end implementations, Support, Roll out and Upgrade projects.
  • Certified SAP HANA and ABAP professional consistently pursuing new challenges to stretch abilities expand knowledge and bring new ideas to Team.
  • Implemented full life cycles using ASAP methodology across various modules of (PM,SD,MM,PP,WM,FI-CO) in SAP BI/BW & R/3 that includes gathering business requirements, analyzing the business process, performing AS-IS Analysis, Identifying and analyzing the Gaps, Implementation, Designing, Configuration, Customization.
  • Keep pace with frequent updates and releases typical of new and emerging technologies in HANA.
  • Extensive Ability to think in customer perspective while handling any project/Requirement.
  • Good communication skills, interpersonal skills, self-motivated, quick learner.
  • Experienced and Expert in developing all kinds of Generic Extractors to BW and enhancing Standard Extractors using User exits and BADI’s.
  • Experience and Expert in Data warehouse design and data extraction from SAP and non-SAP data sources, implementation of business requirements in data transformation processes and loading data
  • Developed different BW objects (Multi-cubes, DSO, InfoCubes, Data sources) and responsible for data loading (master data and transactional data), experience in performance tuning in SAP-BW like compression, aggregates and BWA indexes.
  • Experienced with creating, modifying and activating Info Areas, Info sets Info-Objects, DSOs, Info-Cubes and Multi-Providers according to the reporting requirements
  • Experience in developing ABAP Code in CMOD and in routines for different enhancements
  • Developed and scheduled data extraction using process chains from SAP R/3 Source Syste
  • Developed various queries, workbooks and reports using BEx
  • Experience in automating loads using Process chains and use of BW Monitor to supervise data loading.
  • Experience in building complex Bex queries and user exit variables
  • Experience in integrating SAP BW 7.3 with SAP Business Objects 4.0
  • Created BEx Reports providing insight of Business Intelligence to aid the analysts in decision-making using Formulas, Selections, Structures, Calculated Key Figure, Restricted Key Figure and Customer Exit
  • Experience in BI Performance Tuning by maintaining Aggregates, Compression, Partitioning, and Indexing of Info Cubes
  • Prepared BW development standards, design and development process documents to share with the team
  • Excellent Production support skills in data loading, performance issues, data compression activities, archiving and reporting related issues
  • Hands on experience in loading data from Bex Query into Direct DSO using APD
  • Experience in analyzing theStandard and Custom Programs for identifying the Objectand their restrictions and experience in CallingFunction Module for filling the field values
  • Involved in Implementation, Support activities and Experience in SAP Versions ECC 6.0
  • Having Good knowledge on Functional data flows and Table information in ECC system.
  • Experience in Developing ALV Reports, Interactive Reports / Drill-Down Reports, Blocked reports, and Conventional Reports (Print Lists); BAPI / RFC Function modules; Dynpro User Exits / BADIs / Enhancements, ABAP Workbench Tools ABAP Dictionary, ABAP Editor, Function Builder, and Transactions, ABAP Data Dictionary Z Tables.
  • Experience in writing Z Programs (including Module pool programs) from scratch, and fixing existing ABAP programs..
  • Experience in Debugging of different SAP Business Processes.
  • Good experience of configuring ALE and IDOC's Interfaces.
  • Good experience in, designing and developing layouts and forms using SMARTFORMS and SAP Scripts.
  • Experience creating Generic Extractors (view/function module) in ECC to data transfer from ECC to BW system.
  • Have Very Strong Basics and Good knowledge on SAP HANA Architecture & Landscape
  • Experience on SAP HANA Data Provisioning (LT, DS), Data Replication, Modeling and Reporting
  • Have hands on experience on modeling in creating Attribute, Analytic and Calculation Views
  • Experienced with SAP HANA programming including SQL, SQL Script
  • Good understanding and experience in providing security restrictions on models using Analytic Privileges and assigning to Authorization roles for different types of users in SAP HANA.
  • Experience on Native HANA and SAP BW powdered by HANA
  • Worked on all kinds of Join Types in SAP HANA
  • Experience in creating Stored Procedures, Triggers, Decision Tables, Temporary Tables and History Tables.
  • Experience in Designing the BW models specific to HANA
  • Knowledge on Composite Providers, Transient Providers and Analytical Index
  • Knowledge on Open ODS and Advance DSO.

PROFESSIONAL EXPERIENCE:

Confidential

ABAP, BW/BI, ABAP Consultant

Responsibilities:

  • Material Lead time calculation is completely automated.
  • Eliminate outliers. (Standard FM is Developed).
  • Automated with heavy calculations in the processing program.
  • Simulation enabled.
  • Notification and reporting.
  • Historical consumption based
  • Simulation before we see test results by enabling.
  • Automated via back ground jobs.
  • Decision making by enables user interaction in ALV.
  • Graphical Analysis using 3D.
  • A New transaction for CQ was developed.
  • Work flow process triggered with notifications at different levels.
  • All approval levels were configured in AAE engine.

Confidential

BW/BI, HANA, ABAP Consultant

Responsibilities:

  • Enhanced Existing Plant maintenance Dash board
  • Created Preventive maintenance measure data.
  • Developed 5 extractors (2 Function module extract, 3 view extractors in R/3 to pull preventive maintenance data.
  • Enhanced 3 exiting Data sources by implementing user exits and BADI’s.
  • Created 9 info providers (2 IO and 8 DSO’s) in BW to pull preventive maintenance data (maintenance plan, maintenance item, cycle’s data, measuring point’s data, Task list data.
  • Developed 8 New queries with drilldown to respective areas of preventive maintenance data.
  • Enhanced queries with new additional data as per the client requirement to cater the need of both general and equipment/FL task list
  • Created 4 APd’s to link all task list data from maintenance item level
  • Created 3 process chains to regularize the loads in production.
  • All new reports are shown in Dash board build in using FLEX.
  • Developed/Enhanced two Extractors, DSO's, APd's, Bex Reports for 2 Kpi's
  • Role Based KPI - A BW report to show the PM course completion of all the employees by Organization, cost center and employee at course level and by roles assigned for employee.
  • Technician Based KPI - A BW report to show the technician course completion details for particular discipline by organization and cost center and further details by course certification type, discipline type, etc.
  • Developed the complete back end functionality of DASH BOARD executive summary for 14 KPi's.
  • Developed around 84 queries.
  • Developed around 60 Apd's.
  • Created 6 process chains to pull information for each level of organization hierarchy.
  • Developed routines, transformations to meet the business requirement
  • Developed the functionality of Radar display in dashboard
  • Developed 2 queries separately for plant and organization which has inbuilt formulae to calculate radar values which are scaled to 100 % from various ranges.
  • Created DSO which will combine data from 2 info providers and merge several orgunits into one single org units by routine coding.
  • Created complicated CKF's to calculate radar percentage values.
  • Developed Webdynpro application for user to assess the quality of the notifications entered in PM module.
  • The assessment can be done by user as well as special privileged group called CMS and accordingly authorization object are developed to only populate plants they are authorized for.
  • Header is automatically created based on authorized Maintenance Plant and Previous Month
  • A special privilege is given to CMS users. They will be able to create/delete/modify any notification assessments at any time point of time
  • Minimum 10 notifications or 10% whichever more shown up on screen with the criteria like M2 type notifications, approved notifications, excluding rejected notifications etc
  • A link to documentation of the CMS best practice document is made available for reference
  • A link to BW report is made available for any previous snapshot by Plant, Cost Center, Org Code
  • Enhanced existing Equipment analyzer with Functional location by enhancing existing 30 queries which can show various reports pertaining to PM activities for Equipment/ Functional location
  • Introduced F4 functionality with 16 fields to search Equipment/Functional location by various selection criteria
  • Prepared UAT and UFT documents.
  • Enhanced the current design with 2 more business levels to view data by division and admin department.

Confidential

HANA/ BW Technical consultant

Responsibilities:

  • Involved in Business and Architecture discussions. Writing the technical specifications, standard modeling and Implementation documentation for HANA.
  • Created master data objects as Attribute views, joined multiple master tables when necessary and used in Analytical and Calculation views where entities are relevant.
  • Created Analytical Views to support multi - dimensional reporting by joining Fact table (data foundation) to modeled dimensions (attribute views) in the Logical Join node.
  • Created Calculation Views using database tables, attribute views, analytic views and created SQL Script based calculation views, CE function, SQL Procedures to address complex business requirements.
  • Created calculated attributes, calculated measures, restricted measures, calculated columns, filters, hierarchies, variables, input parameters to satisfy reporting requirements using SAP HANA IMCE studio.
  • Gained extensive knowledge in SAP HANA Data Provisioning using SAP LT Replication Server (SLT) while working with SAP Team for a POC project.

Confidential

ABAP/IDOC Technical Consultant

Responsibilities:

  • Configuration and mapping fields of IDOC DELIVRY05 with message type DESADV.
  • IDOC WHSCON enhancement to update container number and seal number to delivery.
  • Developed Smart forms packing list, Delivery note, Invoice.
  • Implemented Exits for Blocking Sales order quantity after creation of Sale order.
  • Routines to control packing list, Delivery note.
  • User exits to restrict Quantity in sales order and Delivery
  • Development to split TO based on the entered quantity in Delivery using FM L TO CREATE DN
  • Tabbed block Selection screen design and validation
  • Goods movement 311 using BAPI GOODSMVT CREATE
  • Batch Creation using BAPI BATCH CREATE
  • Tabbed block Selection screen design and validation
  • Goods movement 311 using BAPI
  • TO creation from Transfer requirement using
  • ALV docking container with immediate Update.
  • PP report to view all material grades and the different available stocks.
  • Developed interfaces with IDOCS with Message type WMTORD and basic type WMTOID01
  • Interfaces IDOC enhancement of inbound idoc WHSCON while confirming the TO.
  • WMTORD outbound enhancement to update few fields in IDOC
  • User Exits in WHSCON to change the storage unit of the incoming idoc while confirmation.
  • User Exit in WHSCON FM to do goods movement to consume wooden pallet and stretch wood for mixed pallet scenario.
  • User Exit to automatically update time and date of Task creation and giving user a grace period of 1 day to finish the task.

Confidential

SAP BW ABAP Focal

Responsibilities:

  • Identified the scope of implementation as per the client requirements.
  • Created Technical Document from the functional Document.
  • Identified and Installed Cubes, DSO's, Data sources and info sources from business content.
  • Created data source by using generic extraction in order to bring the data from different tables based on the business logic and the data from ECC to BI.
  • Extracted Accounts Payable (0FI AP 4) and Accounts Receivable (0FI AR 4) data from ECC for developing DSO (Day Sales Outstanding Reports, Late Pay Metrics Reports) and procurement data from ECC using the Purchasing Header (2LIS 02 HDR), Purchasing Item (2LIS 02 ITM), Schedule Line (2LIS 02 SCL) and COPA to extract data for Invoice Proceeds related to FI Work stream and areas like APO for Demand Planning.
  • Enhanced Purchasing Header (2LIS 02 HDR), Purchasing Item (2LIS 02 ITM), and Schedule Line (2LIS 02 SCL) with custom Fields such as Over delivery limit, under deliver limit, business Line etc to meet the end user reporting needs.
  • Identified the reports and Installed from Business content.
  • Created Process Chains for automation and performance Improvement.
  • The account receivables data is captured at Company code, Credit control area, Customer, Chart of accounts, G/L Account, Document type, Posting Key, Fiscal year, posting period wise.
  • Day to day interaction with the end users collecting information and to further discuss any issues relating to the reports.
  • Developed front - end reports using BEx Analyzer, used Restricted and Calculated Key Figures, Variables, Exceptions, and Conditions.
  • Developed Workbooks based on different Info providers upon the user requirements and broadcasted.
  • Involved in Manual Testing and User Acceptance Testing of the reports.
  • Collecting the various Objects into transport Requests and release them from Development System to Quality environment.
  • Co-ordinate with Basis team for transportation of objects to Quality system as per Landscape.
  • Maintained high utilization on the Project.
  • Prepared documentation for the new functionalities.
  • Ensured timely and good quality delivery of the project, which was well appreciated by the client
  • Worked as a buffer resource in PDM project as ABAP- BI/BW consultant and worked on below scenarios.
  • Generic extraction using FM approach and Views/Tables.
  • ABAP coding in Routines.
  • Enhance Standard BI/BW Extractor Using User exits & BADI,
  • Upload Master Data from Flat File to Info Objects.
  • Creating Process Chains for DSO,Remodeling info cube.

Confidential

Developer

Responsibilities:

  • Installed Business Content and activated theSAPdelivered Standard Info Cubes and Info Sources
  • Worked on Generic Data Extraction (RSO2) to create Data Sources for transaction and master data
  • Enhanced extract structures for Master Data to bring additional fields in to BI and created custom Data Sources for transaction data to meet the business requirements.
  • Advised the functional team about the impact in BI and with the extractors when they require a configuration change in ECC
  • Worked on ABAP Routines, User exits & Customer exits per requirement,
  • Developed new BEx Queries, workbooks based on the different Info Providers
  • Create CKF and RKF as needed and adopt performance on all queries
  • Created queries in Query Designer and deployed to the Portal
  • Created over BEX queries and assigned them to roles by department.
  • Created Process chains and Meta Chains for loading Master data and also for loading Transactional Data.
  • Provided Post Implementation Production Support includes Monitoring the Process Chains Daily, Weekly and Monthly. Troubleshooting and Correcting the Data Load Errors
  • Resolved Tickets Raised by Users.
  • Enhanced the Existing Reports based on User Requirements to include New Functionality.
  • Created Generic extractors for custom table and loaded data into BI.
  • Created/Modified custom Info cubes, DSOs, Transformations, Info packages, DTPs as per the requirement.
  • Prepared Technical specifications for the Functional Specifications.

Confidential

SAP ABAP- BW Developer

Responsibilities:

  • Prepared BDC reports to upload the data from legacy systems
  • Worked with BW consultants in writing ABAP code in Routines, testing Data sources.
  • Helped BW team in creating FM approach & View/table approach during data source creation

Confidential

Developer

Responsibilities:

  • Developed a Module Pool Program for Mass change of Approver Ids for a Purchase Requisitions
  • Developed a classical Report using ALV oops concept to get a detailed report on “ Purchase Requisition Approval Status”
  • Report Solved issues with ALV grid layout.
  • Developed a Report to obtain changes done to the PO quantities or Net Price
  • Developed a Report to obtain Price and Quantity variance between PR & POs at item level

Confidential

Developer

Responsibilities:

  • Developed & Redesigned 19 interfaces from SAP to Confidential to pass the data from SAP to Confidential database ( MySQL DB) where PHP scripting language is used to build the frontend interface.
  • After gaining experience in project, analyzed the current scenarios, discussed the same with SAP solution architects and Proposed new technologies ( BI/BW, XI/PI ) to client by preparing POC and so far successful in implementing XI/PI and partially Workflow.
  • Automated many processes which are followed conventionally.
  • Reengineered the entire interface logic for optimization of Confidential project to increase efficiency.
  • Worked around the service order transactions like IW33, IW24, MB51, VBAP, and IW73 in technical and functional roles.
  • Designed flow chart using MSVISO for all the interfaces to explain the logic flow.
  • Provided logic to fetch material cost of an service order
  • Provided logic to get the shipped date/closed date of a service order which was critical to the project. provided logic to fetch task list details, material movements, characteristic values, incoming and outgoing material, base part dash part relationship,
  • Mapped SAP fields Business Need for one the reports which shows material statistics.
  • Took the responsibility of the issues related it to SAP by carrying a depth analysis from technical and functional point of view to provide the solution.
  • Improved the debugging skills by working on different scenarios finding the route cause of the issue
  • Successfully implemented XI/PI - File to File Scenario in project to pick files from SAP Application server to target server in Confidential
  • Worked as a buffer resource in PDM project as ABAP- BI/BW consultant and worked on below scenarios.
  • Generic extraction using FM approach and Views/Tables.
  • ABAP coding in Routines.
  • Enhance Standard BI/BW Extractor Using User exits & BADI,
  • Upload Master Data from Flat File to Info Objects.
  • Creating Process Chains for DSO,Remodeling info cube...

Confidential, Long Grove

Developer

Responsibilities:

  • Developed A.R.E -3, A.R.E -1 (Excise invoice forms) in SMARTFORMS from scratch.
  • PP module - Developed Program to Import Customer Forecast Data into Planning Type and updating the relevant data to S550 DB table.
  • Created Basic IDOC and Message IDOC, Assigned Message type to Basic type ( ORDRSP )
  • Developed logic in Smart form to display address (sold to and ship to) based on the check in SD module.
  • Worked on scripts in different modules SD( V2 to V7), WM,MM for Output types by Changing layout according to the user requirement
  • Worked on Transfer Order( TO ) print program ZRLVSDRB,OMLV configuration part and solved the issues like Auto print is not coming after TO creation ( LT31), Number of copies printed is not in a desirable way., Form not printing the items as a combined list, Print code not appearing in form, Maintenance of text elements in the program
  • MM module - Completed Enhancement development (ENH0026) -where the user should not be allowed to create Purchase orders for items which are having MRP generated Requisitions and Manual requisitions together in one single Purchasing document.
  • FI module - worked with standard program like CHALLAN UPDATE FOR CUSTOMER AND VENDOR.
  • SD module - worked with various reports and routines, enhancements explaining / modifying logic according to the user requirement.
  • Debugged Driver program and Script and provided reasons for wrong population of data and non display of data in scripts.
  • Created 6 routines in T-code MC1D with the required logic for MM module
  • Created 3 pricing routines in T-code VOFM with the required logic for SD module
  • Solved issue in FICO module by creating FM with the required logic for updating check number in Certificate ( j1incert) in the script form TDS certificate for vendor.
  • Provided POST - GO LIVE SUPPORT for client resolving issues on priority basis

Confidential

Developer

Responsibilities:

  • Usage of Optimizer, a proprietary tool of INTELLIGROUP, for faster and cost-efficient upgrades.
  • Upgradation of Obsolete SAP ABAP Work Bench objects, namely Tables, Structures, Includes, Reports, Function Modules, Module Pools, Forms & BDC Programs in SD/MM/FI/CO Modules.
  • Rectified the population of BDC screens flows, fields and OK codes which differ from the BDC flow in the target version from that of the old version in Tcodes like FB01 SM02
  • Replaced all Obsolete Function Modules making them compatible with the newer version. Suggested many alternative solutions proving optimized solution for the issues raised.
  • Preparation of Change Documents & Unit Test documents.
  • Rigorous unit testing and maintenance during the development phase to cater to the client’s changing requirement
  • Peer Review of Deliverables.
  • Daily Delivery Tracking & Issue Tracking.
  • Checking and preparing the documents in accordance with the Intelligroup Quality Standards.

Confidential

Developer

Responsibilities:

  • Analyzing Objects as per Client requirements
  • Developed Smart forms in HR module in the specified Areas like Absent management, Employees Onboard form
  • Worked with complex Driver Program built in with ABAP-OOPS concepts.
  • Developed ALV report for a monthly basis to report on quantities of Products that are produced, imported and sold.
  • Prepared TS for the Functional Specs Provided.
  • Rigorous Unit Testing was done was for all possible cases to ensure the proper functionality of the Smart form.
  • Prepared TPV (Third Party Vendor Developers Checklist ) for all the smart forms developed

Hire Now