We provide IT Staff Augmentation Services!

Sap Bods Consultant Resume

0/5 (Submit Your Rating)

NH

SUMMARY

  • Over 10+ years of experience in Information Technology field with strong emphasis in ETL, Data Warehousing, Information Steward, ABAP and Web dynpro ABAP.
  • Around 8 years of experience with Data Services Architecture design, Admin and Developer as an ETL tool and Data Migration Tool. Over one year experience with Information Steward. Around 5 years of experience with ABAP Developments like Reports, BDC, BAPI’s, RFC, LSMW, Badi’s, ALE/IDocs, and Dialog Programming.
  • Worked on complex Jobs, Work Flows, Data Flows, and Scripts using various Transforms (Integrator, Quality and Platform) to successfully load data from multiple sources into a desired target.
  • Worked on Change Data Capture on both SOURCE and TARGET level and implemented the SCD (Slowly changing Dimension) Type 1, Type 2 and Type 3.
  • Worked on Profiling and Auditing in migration.
  • Strong experience in the integration of BODS with SAP modules and Non - SAP data sources.
  • Monitored the performance of jobs and the Job Server Utilization
  • Created Job Server groups to distribute the work load of the jobs
  • Configure, create repositories and apply security policy on CMC
  • Backup and recovery mechanism implemented by backing up the central repository, FRS and CMS data bases.
  • Worked on both real-time and batch jobs creation and performance optimization.
  • Performs backups on entire system or server settings or and BI content.
  • Configure data stores and push them as ATL to all the repositories for use.
  • Created security roles for users and maintaining of roles to groups.
  • Configured repositories, Moved data between environments, Performance monitoring.
  • Integrated different SAP Systems to data services and configured the data stores.
  • Implemented the Disaster Recovery Mechanism and monitoring of Jobs for improving the performance of Jobs and the Systems.
  • Performance Tuning of Jobs and tuning the DS to SAP Systems by using ABAP DataFlows etc.
  • Worked with Information Steward to define validation rules, identify duplicated, Involved in profiling of data.
  • Worked extensively on custom extractors.
  • Involved from understanding of the legacy system and creating mapping documents with functional team.
  • Involved in creating gap-Anaysis from the existing mapping documents.
  • Used Open Hub Services to push data out of SAP BI using Data Services into RDBMS.
  • Worked on hierarchy flattening to convert the SAP Hierarchies into RDBMS tables.
  • Extensively used Data Services Management Console to schedule and execute jobs, manage repositories and perform metadata reporting.
  • Created repositories (Local, Central, Profile and Cleansing ) and configured them with Designer, Management console
  • Used Match Transforms, Address Cleanse and Data Cleanse Transforms for US Data Cleansing, Canada Data in Data Quality.
  • Extensively workedonData Extraction, Transformation, and Loading with RDBMS, Flat files and XML.
  • Worked with IDOCS to extract and to load data in SAP.
  • Designed Classical, Interactive, OO-ABAP Reports, RF Screens.
  • Developed & Supported Custom tool for Data Migration.
  • Performance Tuning of Reports to optimize the Cost & Runtime.
  • Used Data Migration Techniques - Datasets, BDC’s.
  • Worked on SAP Scripts and Smart Forms as per user specifications and for printing Zebra Labels.
  • Hands on Experience with Dictionary objects - Search Help Exits, Table Creation, Lock Objects.
  • Worked on User Exits, Enhancements, IDocs.
  • Experience in all stages of application development, design analysis, evaluation of customer needs, analyzing functional requirements, technical requirements, testing and business process.
  • Have knowledge on BADI’s, Workflows and Adobe Forms.
  • Have basic knowledge on MM, WM, Yard Management, FI and SD modules.
  • Excellent communication and strong interpersonal skills with the ability to interact with end-users, managers and technical personnel.
  • Performance Tuning - Evaluated statistical performance and suggested recommendations to basis support for optimization. Improved data load and query performance using Compression, Aggregates, Partitioning and Indexing of Info cubes and use of statistics for same.
  • Worked on loading data into different SAP systems like SAP ECC, CRM, PCM, ERP, PPM, WM etc
  • Strong Knowledge in all phases of Software Development Life Cycle (SDLC) such as Analysis, Design, Development, Maintenance, Enhancements, Testing., Migrating, Administrating, security management and production support in Business Objects
  • Implemented Data Cleansing, Transformation Scripts, Stored Procedures/Triggers and necessary Test plans to ensure the successful execution of the data loading processes.
  • Expertise in performance tuning of loading the OLTP Transactions and integration of the data into Data Warehouse(EDW) and data marts.
  • Wide experience in interacting with end-users to gather and document the reporting requirements and giving training to the end users.
  • Expert skills in Data Services/Data integrator in design, creation, and implementation of BODS/BODI Jobs.
  • Performed complex transforms in dataflow using data services.
  • Expertise in Relational Database Systems such as Oracle 11g/9i, MS SQL Server 2008/2005 and MYSQL.
  • Programming Knowledge in Developing SQL and PL/SQL.
  • Excellent in documenting Business Requirements, Technical Designs, Unit Test plans, System Test plans, User Acceptance test plans and User Training manuals.
  • Experience in user training and extensively involved in taking business and technical requirements and basing on that delivered the required reports to the project.
  • Prepared test scripts and test cases to validate data and maintaining the data quality.

TECHNICAL SKILLS

ETL tools: SAP BO Data Services XI 4.0 SP1, SAP BO Data Services XI 3.2 SP1

SAP Net Weaver: Enterprise Portal 7.02/7.3, WebDyn pro ABAP/JAVA.

SAP Technologies: Information Steward, SAP ECC 4.6C, 5.0 and 6.0, Work bench tools, Reports, BAPI, RFC, ALE/IDOC, Conversions (BDC, LSMW), Smart forms and ABAP Performance tuning.

IDE Tools: Net Weaver Developer Studio (NWDS), Eclipse.

Software/Databases: Oracle 11g/9i/8i/7i, MS SQL Server 2008/2005 and DB2

Languages: SQL, PL/SQL, C, C++, Java, HTML

Operating Systems: MS-DOS, Windows XP/2000/NT/98, UNIX

Other Tools: TOAD, MS Office Products (Word, Excel, PowerPoint)

PROFESSIONAL EXPERIENCE

Confidential, NH

SAP BODS Consultant

Responsibilities:

  • Involved in created business rules and data mapping.
  • Worked closely with functional team on analyzing the data gathering requirements.
  • Created and configured Data Stores to SAP BI, ECC, SRM and DB2 Systems.
  • Helped creating the architecture for BODS 4.2.
  • Created System configuration in all 3 (DEV, QA, PROD) environments.
  • Worked on creating local and central repository and providing user roles and maintaining groups and configured job server to local repositories.
  • Worked on DS workbench in designing the jobs based on business needs.
  • Debugged existing jobs and done performance tuning on the existing jobs.
  • Loaded data to different dimensions and fact tables.
  • Used try catch blocks for error check.
  • Worked on profiling of data, creating scoreboards, validation, matching strategy and finding duplicates using Information Steward 4.2.
  • Worked on creating user roles in Information Steward
  • Worked in creating data store connection and using flat files as sources.
  • Worked on cleansing data. Performed Data Quality tests.
  • Worked on validation rules and scorecard in IS.
  • Use control tables to find easy ways to identifying the problem/job failures.
  • Used parameters, variables and Global variables depending on necessity.
  • Shutdown and start up of servers depending on the necessity.
  • Configured repositories in DB2 environment.
  • Worked on DS workbench in designing the jobs based on business needs.
  • Debugged existing jobs and done performance tuning on the existing jobs.

Environment: SAP Business Objects Data Services 4.2(Designer, Repository ManagerManagement Console, Server Manager, CMC, CMS), Information Steward 4.2., SAP ECC, SAP BI, Flat Files, DB2, MS excel 2007, Windows 2008 server/XP.

Confidential, Houston, TX

SAP BODS Consultant

Responsibilities:

  • Involved in creating functional specs and gathering req.
  • Worked closely with functional team on analyzing the data gathering requirements.
  • Involved in created business rules and data mapping.
  • Created and configured Data Stores to SAP BI, ECC and Oracle Systems.
  • Helped creating the architecture for BODS 4.2.
  • Created System configuration in all 3 environments.
  • Worked on creating local and central repository and providing user roles and maintaining groups and configured job server to local repositories.
  • Involved in code promotion.
  • Worked on profiling of data, creating scoreboards, validation, matching strategy and finding duplicates using Information Steward 4.0.
  • Worked in creating datastore connection and using flat files as sources.
  • Worked on cleansing data. Performed Data Quality tests.
  • Worked on validation rules and scorecard in IS.
  • Use control tables to find easy ways to identifying the problem/job failures.
  • Migrated jobs from 3.2 to 4.2 and also performance tuning of the jobs.
  • Used parameters, variables and Global variables depending on necessity.
  • Shutdown and start up of servers depending on the necessity.
  • Configured repositories in Oracle environment.
  • Worked on DS workbench in designing the jobs based on business needs.
  • Debugged existing jobs and done performance tuning on the existing jobs.
  • Loaded data to different dimensions and fact tables.
  • Used try catch blocks for error check.
  • Worked on creating real-time jobs with Webservice for DataQuality.
  • Used the XSD for the Webservice as source and performed Data Quality and produced output to XML and Flatfiles.
  • Setup access server for the real-time jobs and configure webservice with max and min instance for optimizing the Real Time job based on input frequency.
  • Used transaction control to manage commit and rollback and to control the order of execution in a dataflow in DataServices.
  • Supporting the existing jobs, enhancements to the existing jobs and also building new jobs.
  • Analysis on MDM data.
  • Use of global local and parameters as required and passing parameter values to variable level.
  • Moved Jobs between environments, scheduling of jobs.

Environment: SAP Business Objects Data Services XI 3.2, 4.2(Designer, Repository ManagerManagement Console, Server Manager, CMC, CMS), Information Steward 4.0. SAP ECC, SAP BI, Flat Files, Oracle, MS excel 2007, Windows 2008 server/XP.

Confidential, CA

SAP BODS Consultant

Responsibilities:

  • Involved in creating functional specs and gathering req.
  • Created and configured Data Stores to SAP BI, SAP ECC and Oracle Systems.
  • Helped creating the architecture for BODS 4.0.
  • Created System configuration in all 3 environments.
  • Involved in code promotion.
  • Use control tables to find easy ways to identifying the problem/job failures.
  • Created delta logic and full loads based on data.
  • Used parameters, variables and Global variables depending on necessity.
  • Shutdown and start up of servers depending on the necessity.
  • Worked on DS workbench in designing the jobs based on business needs.
  • Debugged existing jobs and done performance tuning on the existing jobs.
  • Loaded data to different dimensions and fact tables.
  • Used try catch blocks for error check.
  • Used transaction control to manage commit and rollback and to control the order of execution in a dataflow.
  • Supporting the existing jobs, enhancements to the existing jobs and also building new jobs.
  • Use of global local and parameters as required and passing parameter values to variable level.
  • Moved Jobs between environments, scheduling of jobs.
  • Worked Supplier self-registration configuration and customization of SAP standard web dynpro applications.
  • Worked on replication of SRM Business partner to ECC using RFC’s and BDC.
  • Developed Remote Enabled Function Modules (RFCs).
  • Developed reservation print smart form.
  • Participated in meeting with SAP functional team and Legacy team for getting the mapping to load the data into Customer Master IDOC(DEBMAS06), Vendor Master IDOC(CREMAS05).
  • Inserted the additional fields in Additional Data A Tab of Header of Sales Order by appending structure in VBAK table.
  • Developed a BDC call transaction program to load Customer Master Data into SAP system from legacy system using transactionXD01.
  • Developed a Report to display all delivery items and customer details based on the particular delivery number.
  • Performance tuning of a custom report which describes the Sale Order Status, in which Tuning is done using proper coding standards, Parallel Cursor and Performance Techniques.
  • Worked on Print Work Bench IS U CA INSTPLAN SF the letter is printed in-house immediately after the plan is created.
  • Installment agreement is given to the customer to sign and accept the arrangements contract of an installment plan.
  • Worked on print workbench FI CA CORR DUNNING SAMPLE SF to create and send payment reminders or dunning letters to the business partners to remind them of overdue payables and to request payment.
  • Worked on user exit AIST0002 to add the custom fields Condition, Criticality, Utilization are to be maintained on transaction AS01 and AS02 for asset master data creation maintenance respectively.
  • The Department of Water debt collection process involves handing over receivable which are more than 60 day overdue to a third party company for collection.
  • The submission file will be generated by running transaction code FP03DM.Enhanced the file format items fields with FQEVENTS Function module FKK SAMPLE 5063.
  • Used WE05 transport code to check the IDOC status.

Environment: SAP Business Objects Data Services 4.0(Designer, Management Console, Server Manager, CMC, CMS),SAP ECC 6, SAP BI, Flat Files, Oracle, MS excel 2007, Windows 2008 server/ Windows 7.

Confidential, Minneapolis MN

SAP BODS Consultant

Responsibilities:

  • Involved in created business rules and data mapping.
  • Worked closely with functional team on analyzing the data gathering requirements.
  • Created and configured Data Stores to Salesforce system, MS SQL server 2008.
  • Helped creating the architecture for BODS.
  • Involved in designing the warehouse architecture.
  • Trained and guided resources on Data Services.
  • Debugged existing jobs and done performance tuning on the existing jobs.
  • Developed DQ jobs used Data Cleanse, Address Cleanse and Match transform to cleanse all Health care information. Performed optimization on the job.
  • Worked on creating real-time jobs with Webservice for Dataquality.
  • Used the XSD for the Webservice as source and performed Data Quality and integration transforms to produced output to XML and Flatfiles.
  • Setup access server for the real-time jobs and configure webservice with max and min instance for optimizing the Real Time job based on input frequency.
  • Loaded data to different dimensions and fact tables.
  • Used try catch blocks for error check.
  • Worked on extraction of data from MDM and different source systems and build and BIG application for maintaining the Vendor hierarchy.
  • Analysis on MDM data.
  • Use of global local and parameters as required and passing parameter values to variable level.
  • Created scripts to pull data from FTP server and trimming the file names, Archiving data.
  • Created scripts to check existence of files before involving the object, email Job Sucess.
  • Performing Audit on the tables loaded, Performed optimization on handling 1 billion records data in one job.
  • Created incremental loads and full loads.
  • Moved Jobs between environments, scheduling of jobs.
  • Worked on documenting the jobs and Performed both unit and system testing.
  • Adding of user and group roles in CMC.

Environment: SAP Business Objects Data Services XI 4.0 SP1 (Designer, Repository Manager, Management Console, Server Manager), Sales Force, Flat Files, Eloqua System, MS excel 2007, Windows 2008 server/XP.

Confidential

EIM Consultant

Responsibilities:

  • Involved with business in getting the understanding of the legacy system and migration using mapping documents and filling up gap-analysis.
  • Installed EIM Suite Business Object Platform with BI and BODS and monitored all the servers.
  • Monitored the performance of jobs and the Job Server Utilization.
  • Created Job Server groups to distribute the work load of the jobs.
  • Configure, create repositories and apply security policy on CMC.
  • Backup and recovery mechanism implemented.
  • Configure data stores and push them as ATL to all the repositories for use.
  • Created and configured Data Stores to iSeries system, made ODBC connections to the system.
  • Helped creating the architecture for BODS and SAP Clients and environment.
  • Trained and guided resources on Data Services and SAP.
  • Debugged existing jobs and done performance tuning on the existing jobs.
  • Installed BPDM jobs in Data services.
  • Gathered requirements from business and mapped it to IDOC.
  • Worked on loading master data in MDM (Single version of Truth) from different source companies data like Genex, CRI, AGS, CLA.
  • Configured ABAP dataflow to get data from SAP and validate the data.
  • Worked extensively on custom extractors.
  • Moved Jobs between environments.
  • Moved Jobs between environments. Analyzing all the all downstream systems and enable data stewardship and/for higher data quality.
  • Worked on Staging the data and modifying the existing BPDM’s.
  • Worked on Objects like Fixed Assets, AP/AR.
  • Worked on scheduling jobs.
  • Analysis of MDM data after loading.
  • Loaded data into SAP using IDOC’s
  • Checked status of posted IDOC and validate the data.

Environment: SAP Business Objects Data Services XI 4.0 SP1 (Designer, Repository Manager, Management Console, Server Manager), SAP ECC 6.0, AS400 (JBA), Oracle 10i, JDE, iseries, MS excel 2010, Windows 2008 server/XP.

Confidential

DATA MIGRATION Consultant

Responsibilities:

  • Created the Local Repositories, Secured Central Repositories, Profiler Repositories using Oracle database and configured the Local, Profiler repositories with Job server.
  • Installed Data Services and Information Steward with IPS and configured different SAP systems to it.
  • Configured Different DataStores like Salesforce, Iseries, MSSQL, Oracle to SAP DS.
  • Wide knowledge on information steward utilities like calculate scorecard, compute lineage Report, purge, update search index.
  • Involved in profiling of data by column, Relationship, uniqueness, concurrency, de-duplication.
  • Involved in creation of data stores, configuring of system variables, substitution parameters, promotion of code.
  • Worked on performance tuning and monitoring of load on existing job and providing support for existing jobs.
  • Debugging of existing jobs.
  • Used different CDC types to load the data into Warehouse.
  • Worked on HR, Revenue Cost, General Ledger, Billing Invoice etc.
  • Worked on scheduling jobs, configuring repositories to users.
  • Worked on configuring central repository to local repositories.
  • Created profiler repository and configured them.
  • Used ABAP Data flows and try, catch, Conditional Workflows.
  • Configured the Data services to connect to the SAP R/3.
  • Used Custom extractors in bringing delta data based on timestamp from SAP R/3.
  • Move the projects from DEV to ST, ST to UAT and UAT to Production using ATL files.
  • Scheduled the Jobs in Management Console.
  • Participated in meeting with SAP functional team to prepare functional mapping and to give suggestion that, what we can achieve by using data services.
  • Prepared the functional mapping to IDOC and prepared GAP analysis.
  • Created the data stores for SAP and Legacy (by using ODBC connection to underlying legacy data base which is DB2).
  • Used the platform and data integrator transforms as a part of mapping.
  • Worked extensively with Address cleanse (Global address cleanse), Data cleanse, match transforms (Firm address match batch) for cleansing the legacy records in customer master, material master, vendor master.
  • Worked on loading General Ledger Data, accounting data, Payroll, AP, AR, Purchase, Fixed assets etc.
  • Used the case, validation, merge transforms in validation process.
  • Worked on Enrichment process to give more detail level data to SAP.
  • Prepared Excel sheets (reference tables for Legacy fields to SAP fields) and worked on the Excel sheets by building logical connection in File formats.
  • Exposure to Data services Architecture Data services objects, Data services design interface, Data stores, Importing metadata, File format.
  • Used the local repository metadata to build a universe (purpose is to generate reports on IDOC status and messages)
  • Worked on creating Universe (IDT) and building reports using Webi.
  • Used Import wizard to import existing User accounts, Groups, Categories, Universes, Reports, Connections and Universe restrictions to BO XI R3 environment.
  • Tested the universes and reports after migration and fixed migration issues related to universes and reports.
  • Designed and maintained new Universes for Standard / Ad-hoc reporting requirements of end users.
  • Created aliases and contexts to resolve loops and traps in the universe.
  • Imposed several joins, filters and alerter to restrict the unwanted data and highlight the required data.
  • Created Custom LOV’s (List of Values), Hierarchies, Complex objects using various @functions and Aggregate Aware objects, derived tables in the Universe.
  • Also involved in migrating reports from different environments (QA, Dev, and Production).

Environment: SAP Business Objects Data Services XI 4.0 SP1 (Designer, Repository Manager, Management Console, Server Manager), SAP ECC 6.0, AS400(JBA), Oracle 10i, DB2, BUSINESS OBJECTS 4.0 SP2 (Designer, IDT, Info view), MS excel 2010, Windows 2003 server/XP.

Confidential

Data Migration Consultant

Responsibilities:

  • Created the Local Repositories, Central Repositories, Profiler Repositories in Oracle 10g and configured the Local, Profiler repositories with Job server and Management console.
  • Installed & configured Data Services XI 3.2 SP1 in Development & Production Server.
  • Configured the Data services to connect to the SAP R/3(RFC connection).
  • Configured repositories by adding roles, scheduling of jobs.
  • Adding user roles and access in management console
  • Configuring Access server and job servers.
  • Worked with Impact analysis and Lineage.
  • Generated Auto-documentation reports and data validation.
  • Worked on the performance tuning of the existing jobs and monitoring the usage of resources.
  • Worked with operational dashboards.
  • Configured data stores, System configurations, substitution parameters and promotion of code.
  • Developed jobs to load the SAP R/3 tables into staging area and developed transformations that apply the business rules given by the client and loaded the data into the target database.
  • Based on the requirements, extracted the data from IBM Main frames by creating data stores using ODBC connection.
  • By referencing AIO CUSTOMER MASTER JOB, created the job to load into customer master segments.
  • Used the query transform and data cleansing, Global address cleansing, Match transform (to cleanse the Firm data) and Associate transform to generate Customer Master Basic data.
  • Used the case, validation, merge transforms and lookup function to validate the customer master basic data(to find whether that record already exist in SAP or not).
  • Using the ABAP dataflow, extracted the data from R3 table and generated the lookup tables.
  • Implemented the Data Enrichment step as per the AIO schema.
  • Moved the jobs into QA and production.

Environment: SAP Business Objects Data Services XI 3.2 SP1(Designer, Repository Manager, Management Console, Server Manager),SAP BW/BI 7.0, SAP ECC 6.0, SAP Netweaver, PPM, SQL server-2008, MS Access 2000, Windows 2003 server/XP.

Confidential

ABAP, ETL (BODI) consultant

Responsibilities:

  • Analyzing and reviewing the functional requirement and preparing technical Specifications.
  • Object Development.
  • Utilization calculation, weekly status reports and reviewing the objects.
  • Implemented Routines for VA01 to display the condition type even if the condition record is not maintained for the customer.
  • Developed Scrap confirmation changes using Module Pool programming.
  • Developed a smart form for displaying month wise sales.
  • Implemented standard objects using Enhancement Framework.
  • Developed Own Custom MIGO (Goods Receipt Screen) to maintain vendors to reduce the End user efforts on calculations of daily Receipt / issue of the Materials from Subcontracting Vendors.
  • Back office follow ups: It’s a Integrated application to support total Internal pre-sales business process. Like communication between power users about quotation, status and maintaining the data of total application.
  • Bank reconcile statement: Transferring all open items from clearing G/L account to main account automatically by selecting records from screen by clicking post button.
  • Customer information centre: It’s a single window for all information for particular customer like quotations, sales orders, invoices, goods returns, delivery Chelan, outstanding, Personal information, tax information and contact person information, etc.
  • Own Marketing Screen.: Developed own application for marketing team management and maintenance as replica of legacy (oracle) application.
  • Used BAPI to post Goods movement through ‘BAPI GOODSMVT CREATE’.
  • Used BAPI to Technically complete the Production orders through Bapi ‘BAPI PRODORD COMPLETE TECH’.
  • Used BAPI to change the sales order item information i.e requirement type through ‘BAPI SALESORDER CHANGE’.
  • Implemented Badi ‘FAGL ITEMS CH DATA‘.
  • Implemented Badi ‘MB MIGO BADI’ Net loss of amount for MIGO transaction when goods Issue by filling the External Amount field.
  • Developed Hierarchy wise costing report for employee wise i.e. the total cost of all employees under a manager (tree structure).
  • Developed daily Cash flow report for various Banks i.e. It will give the current situation of the Funds in various banks.
  • Maximum minimum invoice report on monthly wise, it will shows profit and loss report by product wise.
  • Upload the G/L master data through transcton FS00 by using the Session method.
  • Upload vendor master data trough Transaction XK01 by using Call transaction method.
  • Upload the Material Master Date trough LSMW tool by recording method.
  • Create the Customer master data through LSMW tool by recording method.
  • Upload the Employee master data (Hire, Organizational and Personal info) trough LSMW for Tcode PA40.
  • Daily Finance statement bank wise withdrawn receivables payables.
  • Developed Production card with all production details.
  • Developed Smartform for both Excise Registers-1 and Excise Register-2.
  • Initiated DBA interactions for resource requirements and modifications.
  • Created new mappings and updated old mappings according to changes in Business logic.
  • Performed major role in understanding the business requirements, designing and loading the data into data warehouse.
  • Worked with Impact analysis and Lineage.
  • Generated Auto-documentation reports and data validation.
  • Worked on the performance tuning of the existing jobs and monitoring the usage of resources.
  • Developed jobs to load the SAP R/3 tables into staging area and developed transformations that apply the business rules given by the client and loaded the data into the target database.
  • Based on the requirements, extracted the data from IBM Main frames by creating data stores using ODBC connection.
  • Worked on DS workbench in designing the jobs based on business needs.
  • Debugged existing jobs and done performance tuning on the existing jobs.
  • Loaded data to different dimensions and fact tables.
  • Used try catch blocks for error check.
  • Used the query transform and Associate transform to generate Customer Master Basic data.
  • Used the case, validation, merge transforms and lookup function to validate the customer master basic data Material Master (to find whether that record already exist in SAP or not).

Environment:, SAP ECC 6.0, BODI, SQL server-2008, MS Access 2000, Windows 2003 server/XP.

Confidential

ABAP Developer

Responsibilities:

  • Active participation in preparing Technical Design.
  • Reducing the total cost of the transaction/report by analyzing Database hits and ABAP statements.
  • Effective involvement in performance tuning, code reviews and preparing & evaluating the unit test cases.
  • Enthusiastic participation in project learning activities.
  • Fixing issues during Integration Testing and smoke testing.
  • Implemented Multi-threading concept for long running programs.
  • Maintain the consistency and finding the Missing material requirements in BOM Transfer to Project Planning, Check missing material requirements / functional components.
  • This object contains internally 2 reports and a module pool program to assign the project profiles and network profiles.
  • Developed a report with same functionality like TRX CK84 with additional functionality is needed more detailed analysis of cost estimations (standard price calculation).
  • Developed a report program to post Generate G/L postings for Internal Services.
  • Developed a report is to provide a listing of orders and balances by cost element.
  • Developed Inventory Management level Print Slip.
  • Developed Order Entry Acknowledgment form.

Environment: ECC 6.0

Confidential

ABAP Developer

Responsibilities:

  • Analyzing and reviewing the functional requirement and preparing technical Specifications.
  • Preparing Unit Test Document and Test cases for the developed object
  • Feasibility Analysis
  • Involved in reviewing the Objects.
  • Adding address details of the customer to sales order Smart form.
  • Developed enhancement for getting material description for LX17 output.
  • Developed general voucher Smart Form.
  • Enhanced several custom objects.
  • Developed an ALV report for Purchase Requisition that displays all the open Purchase Orders with the related texts.
  • Developed ALV report for History of outstanding for a particular customer.
  • Created a report to display the Sales order changed history, used the Function modules
  • CHANGEDOCUMENT READ HEADERS and CHANGEDOCUMENT READ POSITIONS to read CDHDR and CDPOS tables.
  • Developed Batch Input Programs to update the Customer master credit management details for a given Customer, credit control area using the transaction FD32.
  • Upload vendor master data trough Transaction XK01.
  • Upload the Material Master Date trough LSMW tool by recording method.
  • Create the Customer master data through LSMW tool by recording method.
  • Developed Excise invoice part-1 and part-2 and attached to the transaction J2I6.
  • Designed Check Printing layout and did modifications: and executed for F-58.

Environment: SAP R/3 4.7EE

We'd love your feedback!