SUMMARY:

• Around 10 years of experience as a SAP Master Data Technical Consultant and involved in the Implementation and Support projects for various modules like SD, FI, BW with HANA, WF and MM.
• Experience in preparing user manuals for project end - to-end business cycle.
• Interacting with legacy business users to understand business process flow, business logics and to assess major data objects, data volume for data migration.
• Had hand on experience on SAP Data Migration Tools like Cransoft BOA tools.
• Coordinated with business users and business analysts on a regular basis to discuss the business requirement documents and transformed them into technical specification documents
• Interaction with Business Analysts to understand the requirements.
• Involved in Data modeling process while building the logical model, provided input from the ETL design perspective.
• Review the functional design document and understand the requirements.
• Provide the estimation required for the entire life cycle of the project and preparing the project plan.
• Prepare ETL design document and present the same to various stake holders to identify any risks and also to ensure that requirements are being met.
• Designed and delivered BOA Cransoft Interfaces to extract, transform, integrate and load data from various sources.
• Business analysis and reporting, leveraging synchronized data for reliable analysis and accurate reporting.
• Working experience in using Session method and Call Transaction method for batch data communications (BDC) for interfaces.
• Experience in Dialog Programming with screen painter components like custom control, table control and also menu painter components.
• Involved in the developing the Functional specifications, Technical specifications, Code and Unit test plan according to the business requirement.
• Involved in preparing the business blue print documents which supports for various functional areas.
• Developing new enhancements which fill the gap between business process requirement and sap standard process.
• Worked on SAP scripts, Smart forms, Data dictionary and Search helps.
• Worked on ALV Reporting by using Object Oriented Programming and function modules.
• Worked on Modification of SAP standard program using Enhancement framework.
• Involved in the process improvement and performance tuning of programs.
• Gained exposure in the end-to-end development of deliverables from requirement analysis to system study, designing, coding, testing, de-bugging, documentation and implementation.
• Point of contact to Off-shore team to resolve the issues and for any concern in requirement gathering.
• Initiated and documented on lessons learned, acquired knowledge documents and circulated those to use for next projects.
• An excellent communicator with keen analytical ability and proven skills in working with technical as well as non-technical teams with minimal supervision.
• Well efficient in team building activities, mentoring and training the team to boost up the productivity.
• Excellent problem solving skills with a strong technical background and good interpersonal skills.

TECHNICAL SKILLS:

Operating Systems: MS-Dos, MS-Windows 95/98, NT, XP, UNIX

ERP: SAP 4.7EE, ECC 6.0, BW 7.40, HANA Studio

RAD Tools: MS Visual Studio, MS Word, MS Excel, Power Point, Text Pad, PL/SQL Developer

RDBMS: Oracle, Ms- Access, SQL, Qlik Sense

Programming Languages: ABAP/4, C, C++, Centura, JDK2, HTML, PL/SQL, Visual Basic

ABAP/4 Workbench Tools: Object Browser, ABAP/4 editor, Function Builder, Screen Painter.

Data Dictionary: Structure, Domain and Data Elements

Reports: Classical, Interactive, ALV grid

BDC: BDC programs using Batch Input and Call Transaction methods.

Interfaces/Conversion Tools: BDCs, Batch Input programs, Report programs for Master data uploads.

Data Migration: Migration of legacy data to SAP R/3 using BDC

Forms: SAP Script, Smart forms

Performance Work Bench Tools: Runtime Analysis, SQL Trace, Code Inspector.

PROFESSIONAL EXPERIENCE:

Confidential, Detroit, MI

SAP Master Data consultant

Environment: SAP ECC Implementation

Module: MM, SD, FI, Data Migration, Back Office, BW, HANA

Responsibilities:

• SAP Data migration team for Legacy data analysis, Master Data (Materials, Customers, Vendors), and transactional data collection, extraction, cleansing, and transformation to load into SAP
• Interacting with legacy business users to understand business process flow, business logics and to assess major data objects, data volume for data migration.
• Working with business users/owners to gather data migration requirements, design data mapping documents, and define business rules for cleansing, and transformation requirements
• Collection of master data requirements to be processed in SAP, Provide parameters for identifying obsolete inactive records
• Extensive SAP Data Migration experience by conventional method of Creating Tables, Views, Stored Procedures, Functions, and Transformation rules
• Have Extensive knowledge in SAP HANA modeling with BeX and QlikSense as front end.
• Created Attribute views, Analytical views and Calculation Views using database tables. Created calculated measures, restricted measures and columns, input parameters to satisfy reporting requirements.
• Involved in creation of calculated attributes, measures, restricted measures, calculated columns, filters, hierarchies, variables, in-put parameters to satisfy reporting requirements using SAP HANA studio.
• Created Attribute views, Analytical views and Calculation views. Created SQL script for calculation views in order to address complex business requirements of extracting purchase orders information with respect to invoiced amounts, delivered amounts based on the PO history category type and debit/credit indicator.
• Created Open Data source (ODS) view in SAP to access the HANA views.
• Created the BeX queries on top of the Open Data source (ODS) which allow the user to access the BeX queries through the Business Object Analysis.
• Attended SAP BW on HANA Modeling workshops with the knowledge of using composite providers in BW Modeling.
• Developed reports using the Composite provider on top of HANA views.
• Developed and executed queries in the back end.
• Developed over 60 complex Reports without any performance issue in HANA data Model.
• Developed reports using QlikSense for our MM, FI, SRM teams.
• Developed Data extraction and automated jobs in QlikSense.
• Extract the data from ERP systems (SAP, GPSIS, EBOM, DB2 etc) into .qvd and Excel files.
• Develop LSMW and BDC recordings for loading data into SAP.
• Consolidation of Material master, Vendor master, and Customer master data
• Have Extensive SAP Data Migration experience using tools like BackOffice Cransoft.
• Design, develop and maintain data migration programs and manage migration tools like LSMW, BackOffice CranSoft.
• Interacting with SAP functional consultants to understand SAP configuration and data requirements for SAP load
• Analyze and resolve cross-functional data issues across SAP modules and between SAP, legacy applications
• Usage of BackOffice - CranSoft tool for data extraction, governance, and transformation
• Creating Source tables, Target tables, Source rules, Target rules, Views and usage of SQL functions, BackOffice - Cransoft defined functions for data extraction cleansing.
• Prepare and extract data from legacy systems to load into BackOffice - Cranberry/Cransoft Data staging warehouse Migration Toolset
• Used BackOffice tool set functionalities of - Data staging warehouse, Data Construction Server, Data Garage, Data Dialysis, Cranport in Cranberry/Cransoft for the data not available in legacy systems
• Creating temp tables from SAP core tables for data pre Go-live, post Go-live validation for Testing, Quality and Production clients using BackOffice Cransoft tool
• Data reports for the business to identify and drive data cleansing and remediation efforts for post-validation after each data load using BackOffice Cransoft.
• Created Remediation rules and functionality to temporarily fix data problems in a more rigorous, seamless way using BackOffice Cransoft tool.
• Interfacing with key business and project team members to facilitate seamless execution of data migration
• Documenting Data extraction, Cleansing and Migration processes
• Prepared Knowledge Transfer documents and conducted KT sessions for Client employees.
• Understanding Master data requirement, duplication issues and defining a strategy for data consolidation and harmonization.
• Involved in Master Data, transaction data analysis, work requirements estimation, planning of training and testing.
• Documenting Data extraction, Cleansing and Migration processes.

Confidential, Boston, MA

SAP Data Migration consultant

Environment: SAP CRM Implementation

Module: CRM, Data Migration, Back Office

Responsibilities:

• Leading the group in all the migration phases: Profiling, Cleansing/De-Duplication and conversion.
• Experience in managing all stages of data migration from data analysis to pre go-live validations, user acceptance testing, user sign-off, Cut-Over plans, migrating to Dev/QA/ Prod landscapes, and post go-live validations.
• Interacting with legacy business users to understand business process flow, business logics and to assess major data objects, data volume for data migration.
• Integrated with the Legacy business users to get all the mapping fields from Legacy system to SAP LSMW.
• Working with business users/owners to gather data migration requirements, design data mapping documents, and define business rules for cleansing, and transformation requirements.
• Design, develop and maintain data migration programs and manage migration tools like LSMW, BackOffice Cranberry.
• Technical lead for migrating all the objects from end-to-end: ETL, loading using Custom programs, loading using LSMW.
• Responsible to coordinate with clients and ERP Techno/Functional consultants to map existing legacy system data and structures to the SAP ERP system.
• Work directly with clients to validate requirements for cleansing and standardizing existing data and provide custom configurations in unique environments.
• Developed Classic, interactive & ALV Report for Various modules.
• Created a LSMW project to migrate the open accounts receivable from the legacy system to SAP.

Confidential, Plano, TX

SAP Data Migration consultant

Environment: SAP CRM Implementation

Module: CRM, Data Migration, Back Office

Responsibilities:

• Leading the group in all the migration phases: Profiling, Cleansing/De-Duplication and conversion.
• Experience in managing all stages of data migration from data analysis to pre go-live validations, user acceptance testing, user sign-off, Cut-Over plans, migrating to Dev/QA/ Prod landscapes, and post go-live validations.
• Interacting with legacy business users to understand business process flow, business logics and to assess major data objects, data volume for data migration.
• Working with business users/owners to gather data migration requirements, design data mapping documents, and define business rules for cleansing, and transformation requirements.
• Expertise in Design and Implementing the solution (creating the Technical Documents) for the Functional Specifications on Enterprise HANA for modules SD, MM
• Expertise in GAP evaluation with Technical, Functional requirements with End/Business User.
• Worked extensively on HANA modeling and responsible for HANA development deliverables in time, Cutover Activities
• Extensively worked on Calculation Views, Analytical Views, Attribute Views, Star Join CV's, Hierarchies by using Calculation Views, Delivery Units, Import, Export, Filters, Variables, If Else Calculated Formulas, Calculation Attributes/Measures for Inventory Extensively worked on Transposes like Row to Columns, done Currency conversions using Calculation Attributes/Measures & Restricted Calculations.
• Dynamic data selections by using input parameters like Direct, Column, Static, Derived from Table.
• Used Calculation Views for data display as Header and Item Data format.
• Worked on reading the BW models in to HANA and creating the HANA view to achieve the complex reporting requirement.
• Extensively worked on Virtual Provider based on HANA Models & FM.
• Extensively worked on Composite Providers.
• Developed complex BeX reports.
• Building the reports and delivering on time with all the due diligence.
• Co-coordinating with offshore for all the deliverable or issues.
• Creating Source tables, Target tables, Source rules, Target rules, Views and usage of SQL functions, BackOffice - Cransoft defined functions for data extraction cleansing.
• Prepare and extract data from legacy systems to load into BackOffice - Cranberry/Cransoft Data staging warehouse Migration Toolset.
• Creating temp tables from SAP core tables for data pre Go-live, post Go-live validation for Testing, Quality and Production clients using BackOffice Cransoft tool.
• Data reports for the business to identify and drive data cleansing and remediation efforts for post-validation after each data load using BackOffice Cransoft.
• Business analysis and reporting, leveraging synchronized data for reliable analysis and accurate reporting.
• Extensive experience in Creating Source tables, Target tables, Source rules, Target rules, Views and usage of SQL functions, BackOffice - Cransoft defined functions for data extraction cleansing.
• Design all the strategic data migration documents: Data Dictionary Definition (DDD), Logical Data Mapping (LDM) and Data Profiling/Cleansing Plan.
• Responsible for Migrating Customer and vendor from different legacy systems to SAP CRM.
• Technical lead for migrating all the objects from end-to-end: ETL, loading using Custom programs, loading using LSMW.
• Responsible to coordinate with clients and ERP Techno/Functional consultants to map existing legacy system data and structures to the SAP ERP system.
• Work directly with clients to validate requirements for cleansing and standardizing existing data and provide custom configurations in unique environments.
• Developed Classic, interactive & ALV Report for Various modules.
• Created a LSMW project to migrate the open accounts receivable from the legacy system to SAP.
• Implemented Enhancement for updating texts in sales orders for mass changes. The requirement is to provide customer service with an ability to enter a text, which is a reason for making the mass change. This text should be automatically updated in the sales orders, which are changed by the concerned mass update transaction.
• Involved in the process improvement and Performance Tuning of programs.

Confidential, DC, KS

SAP Master Data consultant

Environment: SAP ECC 6.0 Implementation

Module: CRM, FI, PI, BI, WF.

Responsibilities:

• Preparation of the technical specification by understanding business functionality from the functional specifications, according to the client's requirement.
• Review of Functional Specifications in order to validate the estimates and design.
• Developed the Reports which are called by the interfaces to update, insert records in the SAP tables from the legacy system.
• Developed the proxy program for the CRM to interact with Web services from the Legacy system.
• Worked on ABAP proxy development for Credit card and STAR interfaces.
• Developed LSMW objects for Master data objects Vendor Master and Customer data.
• Developed BDC programs to upload the data from legacy system to SAP R/3 system. Experience includes LSMW to load Material Master, Customer Master, and Sales Master data from legacy system to SAP system.
• Used BDC programming like Call Transaction, Session Methods, Recording and LSMW for Data conversion, field mapping and uploading data.
• Designed and implemented data migration from Legacy system to SAP R/3 using BDC. Work included studying the source data in external system and subsequently identifying and mapping the corresponding Transaction, Programs, Screens and Fields in the SAP system.
• Upload the Customer Master data through LSMW using T-Code XD01.
• Uploaded Vendor Master (MK01), Credit Limits (FD32) and Condition (VK11) info records through LSMW.
• Designed and coded BDC program for Open Sales Orders that updates records in the sales order screen or creates new sales orders using VA01 and VA02 transactions.
• Created the custom IDOC type Z1HIRE01 and imported the IDOC into Integration repository.
• Developed an inbound interface program for extracting the purchase order details from SAP system using BAPI function module.
• Created sales order using standard IDOC (orders05) and Distributed customer master and material master data pertaining to particular plant/company code across multiple R/3 systems using filter object type.
• Developed a report program which allows the user to select the file from Application server to insert or update records in SAP tables.
• Created RFC Module to the Organizational Structure in PPOMA CRM transaction, which will assign, remove assignments using Function Module CRM CP DELIMIT POSITION and CRM CP ASSIGN POSITION for the position in HRP1001 tables.
• Customized BI analysis Authorization Object RSR00001 by allowing the user to restrict the assigned State to the current Fiscal year and restricting the unassigned states by displaying messages in BI reports using function module RRMS MESSAGE HANDLING.
• Generated a BDC programs for the post with clearing using FB02 transaction.
• Design and developed Module-pool Program to display all the post with clearing in the ALV grid format.
• Involved in Development for creating Adobe forms
• Developed Tech Spec, Code and Unit test plan for Conversions to read and to upload the data from legacy system to SAP System.
• Completion of ABAP programming deliverables, ensuring that they are coordinated with and meet the requirements of SAP business users.

Confidential, CA

SAP Master Data consultant

Environment: SAP ECC 6.0 Implementation

Module: SD, MM, CRM, FI, APO

Responsibilities:

• Preparation of the technical specification by understanding business functionality from the functional specifications, according to the client's requirement.
• Review of Functional Specifications in order to validate the estimates and design.
• Developed SAP Adobe Interactive form using JAVA Webdynpro which updates SAP database for t-code KB31N using BAPI ACC STAT KEY FIG POST of PS- Module. This form has input fields and dropdown options and SUBMIT to SAP BUTTTON.
• Developed SAP Adobe Interactive form -OFFLINE Scenario using JAVA Webdynpro with which user can fill -in the Adobe PDF form at his convenience.
• Generated an Opening Stock Report for Current Financial Year.
• Developed screens using Screen Painter and Dialog Programming according to the user requirement.
• Developed Tech Spec, Code and Unit test plan for Conversions to read and to upload the data from legacy system to SAP System.
• Developed a Purchases Report, Monthly Dispatch Report.
• Interactive Report for displaying Plant status of a particular Material. Developed an interface using IDOC and ALE to pass out the goods issue data from SAP to the legacy systems
• Worked on designing ALE/IDOC interfaces for various systems to facilitate data transfer. Testing of inbound and outbound process while dispatching IDOC'S from one system to another system.
• Developed a BDC program for Sales Order using transaction VA01.
• Uploaded Material Master Data (MM01) using LSMW.
• Generated a BDC programs to update Material Master, Vendor Master and Customer Master using MM02, FK02 and VD02 transactions respectively.
• Generated a valuation price Report for the material to the current year.
• Customized program SAPM06P and SAP SCRIPT MEDRUCK to customer’s requirement.
• Customized Delivery note program RVADDN01 and Layout set RVDELNOTE.
• Completion of ABAP programming deliverables, ensuring that they are coordinated with and meet the requirements of SAP business users.
• Coordinated onsite-offshore model, work distribution and guide them for various process of development.

Confidential, NJ

SAP Master Data consultant

Environment: SAP ECC 6.0 Implementation

Module: SD, MM, FI, PS.

Responsibilities:

• Responsible for the analysis, design of Interface programs, documentation, testing of out bound interface and custom info types.
• Design and coded program to create Purchase Requisition using transaction ME51.
• Design and developed Module Pool program to combination of Material and Vendor.
• Design and coded program to create purchase order using the transaction code ME21.
• Created a Freight Details Report and a Stock Opening Report.
• Created a vendor and customer analysis reports for Finance Department.
• Generated a Master data report for Finance Department.
• Generated reports for Accounts receivable and Accounts payables to FI module.
• Generated a Batch Input Program to upload Customer Master Data.
• Developed an Interactive Report for displaying Vendor Information.
• Developed Analysis report for Customer Accounts related to FI/CO.
• Developed report program as an enhancement to perform subsequent listing for articles which are not already listed during goods movement and physical inventory
• Upload program using BDC call transaction to upload corrected consumption history values for MRP areas in the Table DVER.
• Worked on Smart form for a purchase order to vendors which are not EDI enabled. The form is then emailed or faxed to the vendor.
• Testing - perform Unit testing and support for Integration and User acceptance testing.
• Involved in interfacing Legacy system master data like material master and vendor master using LSMW.
• Worked with Unicode check, syntax check, Dialog programming modifications and user exits development.

Confidential, Michigan

SAP Technical consultant

Environment: SAP R/3 4.7 EE to ECC 6.0 Implementation

Modules: SD & MM IS-Oil

Responsibilities:

• Developed a BDC program for Various Transaction code in SD & MM IS-Oil process.
• Updating Tech Spec, Code and Unit test plan according modification done in the programs.
• Change to the Smart forms delivery note to add functionality Items total in the delivery note output should be sum of delivery note output net value for all line items in the delivery note output. Output tax should be sum of tax of line items. Final amount should be sum of items total and output tax.
• Design template like Technical specifications, Code review list and Unit test plan for RICEF.
• Developed a vendor aging report by copying the standard report RFKOPR00 and modified it according to the user requirements.
• Developed a conversion program for Sales orders and distribution orders using LSMW.
• Developed a conversion program for Material Master using Direct Input.
• Worked with like modeling function for a new product.
• Worked on the SAP Script layout sets in SD modules. Involved in modification of SAP Scripts for Purchase orders and indents, Delivery notes, and Invoices according to customer needs.
• Customized the Smart Forms for Delivery note and Invoices. Developed Interactive Adobe Forms for sales order and billing documents to email as well as fax the adobe print forms.
• Gained exposure in the end-to-end development of deliverables from requirement analysis to system study, designing, coding, testing, de-bugging, documentation and implementation.
• Documented the test results and worked with the respective teams on issues occurred to get them resolved.
• Scheduling and Monitoring batch jobs for data load and documenting the errors occurred.
• Analyzed and used the existing custom programs for loading the data into the system.
• Point of contact to Off-shore co-ordination, any concern in requirement gathering.
• Worked in all kinds of priorities, supported production fixes/bugs/breaks, escalated issue at right time, Handled off shore resources, Maintain service level agreements SLA and time estimation for the development objects, Prepare Development specifications, Design ABAP solutions, code and test ABAP/SAP Scripts programs.
• Changing address, adding decimals to quantity and removing negative sign to VAT Tax Invoice in the printout.
• Providing best solutions are critically issues within the time line.
• Peer Review of the deliverables in accordance with the clients standards.
• Worked in all kinds of priorities, supported production fixes/bugs/breaks, escalated issue at right time, Handled off shore resources, Maintain service level agreements SLA and time estimation for the development objects, Prepare Development specifications, Design ABAP solutions, code and test ABAP/SAP Scripts programs.