SUMMARY:

• 11.7 Years of SAP experience which includes 4+yrs in SAP HANA with strong background
• Hands on experience with In - memory technologies like SAP HANA with exposure to data provisioning, modeling and Administration roles.
• 6 Years of experience as an SD Functional Consultant in configuration and implementation of SAP SD Module with a core competency in SD-LE compliance. Diverse experience includes involvement in all aspects of SAP implementation process from project conception through to complete System Configuration.
• MasterData:Customer master, Material master, item proposal, Material Determination, Customer material info,contracts,Rebate agreements Info Record, Source List, Quota Arrangement and Pricing Conditions
• Sales: Inquiry, Quotation, Sales Order, Rush Order, Cash Order, Back Orders, Scheduling Agreements, Contracts, Rebates and Third party order processing.
• Shipping and Transportation: Delivery document types, Delivery Item Categories, Shipping Point Determination, Picking, Packing, Route Determination, and Shipment Creation.
• Billing: Billing Document Type, Credit Memo, Debit Memo, Pro forma Invoices, Inter Company Billing & Milestone Billing. Pricing and Revenue Recognition. Retro Billing and Invoice list.
• Basic Functions: Maintained Determination Procedures, Condition types, Access Sequence and Condition Records for Pricing, Text determination, output determination and material determination.
• Variant Configuration: Knowledge on Configurable material, Maintained Characteristics, Values, defined Classes & Configuration Profiles. Configured Variant Pricing Conditions, object dependencies for specific characteristic values.
• Batch Management: Determining batches for sales orders and deliveries.
• Good Understanding on Combined sales orders, combined deliveries, combined billing, split orders, split deliveries, and Split invoicing, Stock Transport Order and Intercompany Billing.
• Agreements: Scheduling agreements, Quantity contracts, Values Contracts.
• Interfaces--Salesforce and Change point.
• Good Knowledge on ABAP/4 Programming, Reports, User Exits, ABAP Queries, ALE/ EDI, IDOC.
• Expertise in integration with Finance (FI), Materials Management (MM), Production Planning (PP) and Warehouse Management (WM) modules.
• Experience in writing functional specifications, testing scenarios, creating training material, conducting end user training. Experience in unit testing, integration testing and regression testing.
• Experience in SAP HANA-Data Modeling, Data Provisioning, reports development & security including user management, roles and analytic privileges with SAP HANA Certification.
• Hands on experience in Native HANA modeling. Created multiple schemas and table definitions.
• Created a high-level and detailed HANA implementation and migration plan and develop a training plan for the current development resources
• Designed LSA++ Architecture implementation, Data Flow design & Prepared and conducted HANA overview sessions to various stake holders of the project
• Extracted Data into the SAP HANA Database using SLT, BODS and DXC from ECC, Oracle and Flat files.
• Created Open ODS & Composite providers and Designed dashboards
• SAP HANA Security activities like User Management, Assigning Roles to users and Managing Analytical Privileges to enable course gained and fine grained access control.
• Transported HANA content from development, testing environment to Production environment using delivery units.
• Replicated real time data through SLT for PCA reporting and built different views to achieve business need.
• Hands on experience on Smart data integration (SDI) and used pre-defined HANA Business Library Functions
• Good working experience in SAP ERP systems & S/4 HANA and hands on experience on Tableau reporting tool.
• Well verse with SAP HANA Administration, Performance Optimization, Modeling using Different types of views, SQL, SQL Script topics
• Creation of Calculation Views using Graphical Script and SQL Script for Complex requirements.
• Proficiency ranges from requirements gathering and analyses, cross-team coordination, effort estimation, design/modelling development, testing, implementation cut-over and support activities.
• Knowledge on S/4 HANA -1610 simple logistics.

TECHNICAL SKILLS:

ERP: SAP R/3 ECC 6.0, 5.0, 4.7/4.6c/4.5/4.0.

ETL Tools: SAP BODS

Data Modeling Tool: HANA Studio

SAP Module: SAP HANA, SAP BW 7.5, 7.4, 7.3, 7.0 /3.5, MM, SD, FICO, SCM, HR, COPA

OLAP Reporting tools: SAP BEx Analyser, WAD, Business Objects, WEBI, Dashboard, Office analysis, Design studio, Tableau, Lumira

PROFESSIONAL EXPERIENCE:

Confidential,Englewood Cliffs,NJ

SAP HANA/SD Consultant

• Replicated the ECC-PCA tables into HANA through SLT and build HANA (Attribute, Calculation & Analytic) views, Virtual providers and Bex reports
• Created HANA modeling scenarios and activities such as setting up HANA environment - adding a system, creating schemas and creation of USERs and ROLES, etc.
• Developed HANA Column based tables and SQL Script Procedures, Loading data into table definitions, suspending data loads, resuming data loads.
• Expert in creation of Attribute Views, Analytical Views and Calculation views.
• Good experience in HANA models optimization and performance tuning.
• Prepared all Technical Specifications based on Functional Specifications that outlines required Characteristics, Measures and Business Rules. The Technical Specification outlined the overall HANA design to meet and fulfill the Business Reporting Requirements.
• Attributes Views, Analytic Views and Calculation Views created in HANA Enterprise
• Developed data models for the OTC, Inventory, CA & CCA tables in HANA enterprise.
• Created Hana Security activities like User Management, Assigning roles to user and Analytical privileges
• Created a high-level and detailed HANA implementation and migration plan and develop a training plan for the current development resources
• End to end setup of SLT replication server and good at troubleshooting failed scenarios

Confidential, Chicago IL

SAP SD/HANA Lead Consultant

• Experience in Importing meta data, Table definitions, Performing initial load and Replication, Resuming and Suspending data loads using SAP HANA IMCE(In memory calculation Engine) studio.
• Experienced in SAP HANA implementation, SAP System Landscape transformation (SLT), and SAP HANA data modeling using Attribute View, Analytic View and Calculation Views.
• Led and mentored the project team from both technical and functional perspectives including solution development, requirements identifications, testing, and project management
• Lead and mentored the project team from both technical and functional perspectives including solution development, requirements identifications, testing, and project management
• Managed resource and capacity planning for project and work as part of an interdisciplinary team to achieve project timelines.
• Organized C level workshops & worked closely with functional teams to identify KPI’s
• Expertise in capturing of reporting requirement in documentation for the signoff and call handling systems to reflect changes made during call resolution.
• Provided knowledge, expertise and guidance to the customer in order for new potential projects with accurate cost and resource estimations.
• Ensured that existing processes and procedures are adhered to SAP standards
• Communicated with the business and other key users in an appropriate and constructive manner at all times.
• Recommended to-be report designs based on the KPI’s (Dimensions and Measures) identified for the Reports
• Configuration of Organization Structure like Sale Org, Division, Distribution Channel, Sales Offices etc.
• Configuring SD Documents types, Partner functions, Condition types, pricing procedure, Billing documents types, Account determination, output types
• Looking after Master Data related issues like Customer Master, Material Master etc,
• Participating in design reviews to understand new requirements for rollout countries and fit issues.
• Understand the Business Requirements and work with the technical team in designing and documenting test cases.
• Besides working on Baseline activities for new countries going live, also worked on defect and Change request raised through support process related to SD Module.
• Preparing various testing scenarios for User Acceptance Testing (also conducting Unit testing and Co- coordinating system integration testing team.
• Ensure timely progress of development, test & implementation activities and highlight any concerns.
• Provided support for problems arising out of upgrade and various country roll-outs.
• Involved in troubleshooting SD problems through research, re-creating the problem and developing, executing and validating test scenarios, test scripts and test results.
• Provide Functional/Technical specification to ABAP team for Development of Reports / User Exits.
• Configured Output determination for sales document, Deliveries and Billing documents

Confidential, Racine WI

HANA/SD Consultant

• Designed Data models in HANA Studio.
• Interacted with users in understanding the requirements to built SAP HANA models
• Models creation like Attributes Views, Analytic Views and Calculation Views in HANA Enterprise.
• Loading data from different source systems to HANA using SLT (SAP Landscape Transformation).
• Upload program to create a Contracts on getting the data from a PRICE calculator. Also to upload the LEGACY contract.
• Change point interfaces (determined the optimum logic to accommodate the clients complex scenarios to determine the products quantity and price) - Subscription, consulting products. Sales orders for Educational products-.Automated, and recommended the consolidation of this process to best map the SAP solutions
• Ranges management across Development, Quality and Production boxes for customer, material, sales orders and contracts. Managing scheduling times of various jobs in Data Services Management console based on modules.
• Moving the developed jobs in HANA from DEV to PROD using Export and Import functionality and also Life Cycle Management.
• Creating Currency Conversions in HANA to convert the amounts from local currencies to USD
• SAP RDS (Rapid Deployment Solutions) Operational reporting implementation in HANA Enterprise.
• Creating proper roles and privileges for Different users like Modelers, Business User and Administrators.
• Created technical objects as per the requirements and designed in compliance with standards and procedures. Ensured on time defect free delivery .ensure the code satisfies the design specifications and complies with project standards.
• Collaborated with business analysts, developers and technical support team to define project requirements and specifications
• Configured Batch Management Process with class, characteristics, access sequence, strategy types. Configured new freight condition types and maintenance of condition records to be a part of pricing procedure.
• Configured listing and exclusion, material determination using condition technique, copy rules partner functions, item proposal, material sales status, post goods issue(PGI), picking, packing, delivery types, output procedures.
• Configured billing with various Billing Document types, Invoice lists, Billing Plans and copy control for sales documents, and output determination procedures.
• Involved in pricing procedures, Condition technique setting in pricing, customer hierarchy for pricing, special condition types, free goods, and Rebate process.
• Involved in Special Business Processes: Third Party Order Processing, and Rush Order Processing.

Confidential, Anaheim CA

SAP SD/HANA Solution Architect

• HANA Architect working on design, administration and support of HANA databases
• Excellent expertise in performance monitoring and tuning of HANA
• Expertise in SAP HANA dynamic tiering and troubleshooting dynamic tiering issues
• Expert in data extraction to HANA using SLT and SDA techniques
• Experience in writing complex HANA SQL Scripting, HANA procedures and triggers
• Deep expertise in advanced analytics using SAP HANA SQL Script
• Developed enterprise applications using ODATA/XSJS services and consumed using UI5
• Expertise in HANA modelling of attribute, analytical and calculation views
• Handled end to end implementation in the areas of SD, Procurement, Warranty, SCM & VMS (Vehicle management system)
• Participated in discussions with Stake holders & Business users to understand the business requirement.
• Coordinated with cross functional consultants to understand requirements & suggested to implement solutions
• Prepared project related documentation during the different stages of a project.
• Customer Master with various types of Partner Functions such as Reseller, parent and Child. In addition to configuration of Customer hierarchy. Industry type. Configured required fields. Use of additional fields such as Customer Groups, and Condition groups on the Customer Master for capturing different set of data to determine the different pricing for 081 price allocation and to use this additional set of data for reporting purpose.
• Material Master- about 450 products. These are carefully analyzed for their behavior under different sales and Billing process. Accordingly material group, account assignment groups,
• Item category group, item categories, and higher level item category are designed to achieve the overall process of these material right from sales, to project and to revenue recognition. Other material master fields including material group1, through 4 are used to capture additional information for Reporting purposes. Configured required fields.
• Configured BOM with only child level products carrying pricing components,
• Enterprise Structure configuration-Company codes, Sales organization- Distribution Channel, Division, Sales offices, Sales district, plant assignment.
• Contracts- TBE and TEE, with all relevant assignments and incomplete process. And Contracts for conversion on legacy contract.
• Different set of sales orders to match the business process, and sales order to run the revenue recognition.
• Billing, Billing plans, Milestone, periodic and one time billing plans. OSS note-92655, and USER EXIT on periodic billing to achieve the additional functionalities. Different billing types are maintained, and these are proposed at the time of creating the contract through Date categories. Billing block reasons, copy control, and assignment to item categories, and sales document. Additional Payment terms.
• Copy control, item category proposal from contract to Sales order references. Also copy control on sales document to Billing document.
• Pricing- 081 allocation, and price allocation among the different set of products. Different pricing conditions are defined for this purpose. Developed PRICING ROUTINES to achieve these functionalities.
• Different conditions types are defined based on the CALCULATION TYPEs to accommodate the different unit of measure of the Products to arrive at the correct price.
• Mapping complex Revenue Recognition process to match the price allocations using both time based-A, and Service Based-B rev rec type. And revenue Account determination
• Cancellation procedure configuration based on business requirements of different business groups.

Confidential,Cupertino,CA

SAP HANA Lead

• Created data models using Entity Relationship models like attribute, analytical and Calculation views also created Analytical privileges.
• Created Calculation & Analytical view for the real time data
• Guided the offshore team on creating & maintaining all documentation in solution manager.
• Worked on complex Analytics to provide management on sales and finance data by creating different analytic and calculation views including Royalties and gross values.
• Created Functional and Technical specifications and attended requirement meetings with end users.

Confidential,Pittsburgh,PA

SAP HANA/SD Lead

• Worked on HANA Views, Optimizing Data loads with the use of SLT and minimizing HANA space.
• Building models in HANA Enterprise like Attribute Views/Analytic Views & Calculation Views.
• Creation of Stored Procedures and Calculation Views using SQL Script & CE Functions for Transformation.
• Deriving KPI’s in HANA using Analytic View and Calculation Views.
• Architecting the analytics platform with SAP HANA as major component, DS for ETL and BOBI for Reporting.
• Building Models (Attribute, Analytic and Calculation Views) and Procedures to perform transformation in HANA.
• Building Star schema models along with report specific measures in HANA.
• Building Universe on top Calculation Views from HANA.
• Analyzed, designed and developed Info spokes for both Master and Transaction data to support MDR (Master Data Repository)
• Liaised with customer and provided an accurate estimate of work involved.
• Responsible for peer review of the objects developed by the team and also enforced & maintained strict quality standards.
• Checked the daily time schedule for the production run and ensured that the jobs were finished within the specified time frame.
• Setting up Enterprise Structure- sales org, distribution Channel, Division, and Sales Area
• Configuration of Sales process- Order, item category, schedule line, Delivery, Billing
• Partner Function Determination, account group- one time account group
• Configuration of Returns, credit memo request, and credit memo.
• Unit and Integration of sales order and return process.
• Testing of Inbound and out bound Idocs such as 940 and 856 respectively

Confidential,Camden, NJ

SAP SD Consultant

• Interacted with the Core Team members in Identifying and Understanding the Business Process flows.
• Prototype and conceptual Blue Print Design (BPD) was presented for detailed implementation of SD module.
• Defined and configured Organizational structure and distributional channels and divisions
• Configured Business partner Master data by defining Account groups.
• Worked on: Order to cash (OTC), Sales Documents, Item Categories, and Schedule Line Categories.
• Worked on special purpose order process -Evaluation Order processing.
• Worked on Delivery document types and Billing, Availability Check, Transfer of Requirements, Copy Control, Output Determination, Account Assignment and Route Determination. Worked on system modification (USER EXITS) for Return order process to meet the business requirements
• Configured Item Proposal to add material automatically to sales order of the specific customer.
• Involved in Maintaining and determining the required Pricing Procedures by configuring various Condition Types with the required Condition Tables. Defined the associated Access Sequences, created Condition Tables and worked on the Solved client's various pricing issues using special functions such as exclusion groups, condition supplements, group conditions and hierarchical access. And revenue account determination.
• Worked with ABAP programmer to add new fields to the field catalog and to add ABAP codes in user exits (USEREXIT PRICING PREPARE TKOMP, USEREXIT PRICING PREPARE TKOMK) to transfer data to the communication structures.
• Worked on EDI transactions such as Partner Profiles, IDOC extensions and IDOC types, verification of outbound IDOC.
• Documented and tested all the processes, interfaces, and reports.
• Worked on Integration of SD with MM and FICO
• Worked with EDI team in analyzing the various issues related to IDOC and its segments.
• Created the Test Scripts for Testing. Involved in “Unit” and “Integration Testing” for Order-to-Cash Transactions.
• Worked with the end users for Testing the Functionality and guiding them the functionality through the Test scripts.
• Contributed process-, functional-, business expertise and knowledge to the project.
• Updated technical specifications in FSD for changes and performed unit testing.
• Performed peer review of technical specification and unit test document.
• Collaborated with on-site and offshore track leads throughout each lifecycle activity.
• Implemented OTC, SCM-DP & SNP and MM modeling to object data flows, in order to provide top-level view to the system owner.
• Recommended changes to improve services, lower costs and improve customer satisfaction.
• Ownership of and adherence to support procedures
• Ensured delivery excellence, support processes and quality improvements.
• Participated in periodic governance calls with onsite team & Confidential leads.

Confidential,New York, NY

SAP BI Team Lead

• Organized C level workshops & worked closely with functional teams to identify KPI’s
• Ensured that calls were being prioritized and resolved according to SLA targets & was responsible for all BI application related calls.
• Expertise in capturing of reporting requirement in documentation for the signoff and call handling system’s to reflect changes made during call resolution.
• Exclusively worked on FIGL, COPA, Special ledger extraction & data modelling.
• Provided knowledge, expertise and guidance to the customer in order for new potential projects.
• Provided guidance to business and other key users
• Continually looked for ways to improve customer service
• Ensured that existing processes and procedures are adhered to at all times
• Kept users informed of progress on call resolution.
• Communicated with the business and other key users in an appropriate and constructive manner at all times.

Confidential

SAP BI Team Lead Belgium

• Involved in creation of Info Objects, Info Cubes, ODS, Info Source, Data Source, Communication Structure, Transfer Structure, Transfer rules, Update rules, Update methods, info packages, Transformations and DTP’s.
• Created technical objects as required. Ensured on time and defect free delivery. Ensured the code satisfied the design specifications and complied with the project standards.
• Transported the developed and changed objects from the development system to the production system landscape
• Wrote start/update routines using ABAP programming.
• Developed front-end reports using Business Explorer (BEx).
• Worked extensively on reporting using variables, conditions, exceptions, restricted key figures and calculated key figures.

Confidential

SAP BI Architect

• Involved in reviewing technical specs and completed the prototype in Sandbox.
• Extensively worked on OTM & Shipment and moving the developed objects to the quality- and production environments and also rebounded the transports in case of any failures.
• Maintained the documentation on the developed design solution.
• Created technical objects as per the requirements and designed in compliance with standards and procedures. Ensured on time defect free delivery and ensured the code satisfies the design specifications and complies with project standards.

Confidential

Senior SAP BI Consultant

• Worked/supported on all phases of the project including analysis, design, and development, testing and prepared technical specifications.
• Converted report design documents into technical documents.
• Involved in the creation of aggregates and compression of the Info Cube to improve query response times.
• Transported the developed and changed objects from development system to the QA and production system landscape.
• Developed front-end reports using Business Explorer (BEx).
• Extracted data thru Flat Files into SAP Business Information Warehouse.
• Involved in developing Info Sets and Open Hub services.
• Loaded the data from R/3 to BW and used different update modes like Full, Initialization, Delta and Repair Full.
• Managed and monitored several data loads and corrected the inconsistent data loads.

Confidential

SAP BI consultant

• Worked extensively with the Data Model design for the sales reporting requirements. Worked extensively with Data Warehouse Workbench for Modeling, Monitoring, Scheduling DTP/Info package and Process chains.
• Activated the required Business Content, while customizing the DSO objects and Info Cubes as required.
• Maintained Info Cube, Update Rules and Creation of Info Package and scheduled the data into the Data Targets in the development system as per the work request.
• Involved in high-priority tickets regarding extractions, Performance Issues and also load failures.
• Monitored the process chains and analyzed the reasons for frequent failures of Info packages.
• Maintained reconciliation’s to verify the data in SAP R3 and SAP BW are the same after the data loads.
• Involved in enhancing the required user reports based on the requirements document.

Confidential

SAP BI consultant Switzerland

• Analyzed specific market needs and interfaced with different market coordinators.
• Provided solutions to implementation challenges for market-specific scenarios.
• Coordinated with SAP consultants for interim solutions to problems in standard SAP provided areas.
• Imparted technical and functional knowledge related to the solution architecture to the market specific support desks.
• Participated in enhancement of currently alive Globe Template solution framework.
• Formed new Info Packages to enable data uploading into Info Cubes by scheduling several activities such as data selection criterion and sequence of data to populate.
• Monitored the progress of individual data load job requests and resolved data load issues accordingly.
• Designed Queries, Workbooks (i.e. reports) and other analytical applications in SAP Business Explorer (BEX) Analyzer utilizing Microsoft Excel.
• Organized and performed UAT on SAP BW system with end users.