SUMMARY:

• Around 10 years of experience as a SAP BI/BW HANA with Qlik Technical Consultant and involved in the Implementation and Support projects for various modules like SD, FI, BW with HANA, PP 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.
• Experience in developing SAP UI5 Fiori reports on HANA using SAP WebIDE.
• Experience in HANA modeling and good understanding of SAP HANA architecture.
• Migrated objects for Financial & Customer master into SAP HANA system.
• Created SAP HANA optimized objects to improve performance.
• SAP BW Data Modeling, Data Extraction, Business Content, LO Data Extraction (SAP ECC 6.0 and Flat Files), Data Loading, Scheduling, Monitoring and Reporting.
• Created objects like Info-objects, Info-sources, DTP, Info-package, Info-Cube, DSO objects (Standard, Write-Optimized), Multi providers, Info set, Transformations, etc. Performed extensive CO-PA, LO Cockpit and generic data extractions
• Extracted Data from multiple systems like SAP, DB2, and GIPSIS etc into QlikSense.
• 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.
• Configured and implemented BW reporting using BeX analyzer/browser, Report Designer and Web Application Designer (WAD).
• Expertise in front-end BeX Components such as Calculated key figures, Restricted key figures, Structures, Variables, Conditions, Exceptions and Workbooks.
• Experienced in Performance tuning of queries using aggregates, table partitioning, compression and indexing of Info Cubes.
• Worked on Data Modeling, Data Provisioning, and Reporting aspects of SAP HANA 1.0.
• Expertise in developing HANA Data Models including Attribute Views, Analytical Views, Calculation Views, basic SQL Scripting, and Analytical Privileges.
• Extensive working knowledge of HANA Optimized InfoCubes, Advanced DSOs, Composite Providers, Generated Calculation Views from SAP BW.
• Expertise in developing different BW objects using eclipse BW Modeling Perspective such as ADSOs, Composite Providers, and BeX Queries. Expose BW objects as External HANA Views and use them in HANA Calculation Views.
• Manage, Lead, and Coordinate with offshore team to oversee the build/development and testing of BW/HANA objects.
• 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.
• Excellent problem-solving skills with a strong technical background and good interpersonal skills.

TECHNICAL SKILLS:

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

Data Dictionary: Structure, Domain and Data Elements.

Business Intelligence: SAP BW and BI 7.X with HANA, QlikSense

Reporting Tools: BeX Report Designer, Web Application Designer (WAD).

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.

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

PROFESSIONAL EXPERIENCE:

Confidential, Detroit, MI

SAP on Native HANA with Data Migration consultant

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
• Developed front end UI5 Reports such as Delta Requisition, Price Mismatch between Contract and PO, Accrual report to calculate open commitment for Materials and Services for business users.
• 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.
• Developed HANA Information Data Models (Attribute, Analytic, and Calculation Views) and BW objects such as ADSOs, Composite Providers, and BeX Queries using eclipse-based BW Modeling Perspective.
• 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, Build apps and automated apps in QMC 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
• 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.

Module: MM, SD, FI, PP, Back Office, BW, HANA

Confidential, Boston, MA

SAP BW/BI on HANA with Qlik and Data Migration consultant

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.
• Responsible for Sales and Distribution, Purchasing, Inventory Management, FI and CO Info Cubes.
• Extraction for LIS, LO Cockpit, SD, FI-GL, FI-SL and CO-PA modules.
• Created/Modified Info-Sources for Master Data (Attribute and text) and Transaction Data.
• Expertise in Design and implementing the solution (creating the Technical Documents) for the Functional Specs on Enterprise HANA for modules SD, MM.
• Expertise in GAP evaluation with Technical, Functional requirements with End/Business User.
• 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.
• Extensively worked on LO Extraction Cockpit to extract Logistics data from Source System( R/3).
• Imported the Master Data Flat Files (CSV, Excel) to tables in HANA.
• 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. Created the stored procedures and scheduled those using ABAP to load the snap shot information into HANA tables.
• Creating the Master data info objects to read data from Attribute views.
• Worked ABAP on HANA, SLT Replication.
• Good Knowledge on Analytical privileges.
• Developed complex BeX reports.
• 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.

Module: CRM, Data Migration, Back Office

Confidential, Plano, TX

SAP BW/BI on HANA with Qlik and Data Migration Lead consultant

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.
• Lead offshore resource for on time delivery of MOCK, Cutover & Go-live.
• Generate weekly status report for design, build, load & load reconciliation which helped leadership for decision making.
• Prepare data objects dependency chart which helped data team to priorities dependent objects load and expedite the load cycle.
• 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.

Module: CRM, Data Migration, Back Office

Confidential, DC,KS

SAP BI/BW consultant

Responsibilities:

• USDA has selected SAP’s to streamline its Customer Relationship Management processes is for the implementation of the Farm Service Agency's Modernize and Innovate the Delivery of Agricultural Systems, or MIDAS project.
• MIDAS is aimed at modernizing how the FSA delivers farm program services and benefits to producers, farmers, and ranchers through its more than 2,200 offices in the United States
• Confidential international implemented the project for SAP ECC 6.0 implementation.
• Responsibilities:
• Preparation of the technical specification by understanding business functionality from the functional specifications, according to the client's requirement.
• Worked with SAP applications like MM, FI, SD, PS, SRM
• Administrating through BW Administrator workbench using Info Providers, Info Objects, Info Sources, Source Systems, and PSA, Sub functional areas to create and monitor the objects that are involved in multidimensional Analysis.
• Created DSO for incoming sales orders according to sales organization, distribution channels, and ship-to-party customers.
• Worked on BI ABAP - Start Routines, End Routines and Field Routines.
• Worked extensively on Performance tuning in improving the load and read performance by maintaining indexes, partitioning, aggregates, query properties etc.
• Extensively worked on business-critical reports like Mfg PI sheets and Asset Management and Reconciliation Reports.
• Prepared templates for reports gathering requirements from the business.
• Meetings on status, issues, and overall progress on a regular basis.
• Completely responsible for the Design and Configuration of the LO extraction Cockpit, the building flow of data from R/3 to BW.
• Configuring LO extraction involves identifying the required dates and building the business logic characteristic derivations and rules, transfer of billing documents, Enhancements required for Sales Analysis and Set up extractors for BW.
• Completely responsible for the Configuration of the LO extraction Cockpit, the building flow of data from R/3 to BW.
• Customizations - Extract structure enhancements, generic extractors, user exits and worked on customized delta built up for the data sources.
• Generated standard and costumed reports using BeX Query Designer.
• Modified report content and export reports in multiple formats based on user input Wrote documentation for users on how to select necessary parameters and date frames for different selections.
• Involved in various testing procedures, user training, on-site support and maintenance.
• Extensively worked on HP - Quality Center as per the project requirements.
• Extensively worked in Unit Testing and Integration Testing.
• Worked as Business Analyst by taking the requirements from business.
• 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.
• 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.
• 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.
• 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.

Environment: SAP ECC 6.0 Implementation.

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

Confidential, Michigan

SAP Technical consultant

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 client’s 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.

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

Module: SD & MM IS-Oil