SUMMARY

• Over 20+ Years of IT/IS experience in the Analysis, Design, Development, Implementation and Testing of SAP Applications and SAP HANA, SAP BW,
• 20+ Years of experience in SAP HANA, SAP BW on HANA, SAP BW, SAP BODS, SLT, SAP R/3. SAP experience as Techno - Functional Consultant in FI-CO/SD/MM/WM/PP/PM/QM/SM/PS/HR/TEM modules, SAP BW and SAP BASIS.
• Strong experience in developing data models in SAP HANA platform applications using S4/HANA, BW/HANA, Native HANA analytics. Delivered reporting solutions using SAP HANA models for FI, HR, SD, MM, PM, Quality, Volume Metrics. Created Native HANA Views. Well versed with S/4 HANA tables, CDS Views.
• Experience in using data modeling tools like Erwin, Visio to create, manage, enhance data models for data analytics.
• Well versed with using SQL script for HANA platform development for both developing script based calculation views and for stored procedures. Used SQL script for creating stored procedures, table functions.
• SAP HANA optimization using table partitioning, performance optimization.
• Worked on SAP HANA Live project(SAP HANA Live for ERP) in Side-Car scenario. Used SLT to replicate data. Created very complex custom HANA models using reuse views, query views and value help views. Used HANA Live explorer extensively to find the gaps in delivered HANA content and made enhancements.
• SAP EIM experience for data provisioning in HANA using SAP BODS, SLT, SDA for remote data sources.
• SAP BW Certified 12+ years as SAP BW consultant with experience in developing custom data models using SAP BW object for Logistics, FI-CO, FI-AR/AP/GL, PS functional areas. Experience with activating and extending SAP Business Content. Excellent experience in BW customizing.
• Strong experience in delivering KPI reports in Sales & Marketing, Delivery & Logistics, Quality, Volumetric Reporting.
• Experienced in Gap Analysis, User Interaction, Requirements Gathering and delivering Solutions. Strong experience in setting up BW best practices, Performance Tuning to optimize overall user experience.
• Strong understanding of SAP Configuration and Functional Knowledge to understand user requirements. Experience in converting business requirements to functional and technical requirements and design and implement. Experienced in creating Functional Specs, Technical Specs, Test Plans, user documentation and user training documents.
• Back-end: LO-Cockpit, CO-PA, FI/SL extending data sources through Append structures, Business Warehouse Components Extractors, Update routines, Transfer routines for comm structures. Generic data source extraction using RSO2.
• SAP CRM/SCM to BW Integration. Extracting data from CRM/SCM to BW. Activating CRM specific cubes in BW and customizing CRM cubes in BW. Extracting master/transaction data from SAP CRM. Worked on loading data from SCM data sources in DP and SNP area.
• Experienced in Job Scheduling, data loading using Process Chains and info package groups.
• SAP BASIS experience both in SAP R/3 and BW in transports, SAP BW Security, user profile administrations, dump analysis, system logs, runtime analysis, performance tuning, applying OSS notes etc.
• Front-end: Business warehouse components BEx queries using calculated key figures, restricted key figures, filters, structures, hierarchies, variables, conditions, exceptions.
• Extensive experience in SAP ABAP working in FI/CO, MM, SD, PS, SM, HR modules and SAP Script, ALE, IDocs, BDC, BAPI, RFC, Jco, Reports, Interactive Reports, Dialog Programming, and Data Dictionary.
• Team Leadership experience handling on-site and off-shore resources. Strong work experience in global support model to support SAP applications. Mentored many team members of clients located different geo-graphical locations.

TECHNICAL SKILLS

Data Warehousing: BW 7x, 3.1C, 3.0B 2.1C, SAP HANA, BODS, SLT

SAP R/3: 3.1H - 4.7 - ECC

Languages: ABAP/4, SQL, Java, XML, HTML, C, RPG/400, VB

Databases: Oracle,DB2/400

Tools: & Utilities: Visio, MS-Project, MS-Office, Erwin.

Methodology: ASAP

Operating System: Windows NT/98/95/00,Unix/AIX,OS/400

PROFESSIONAL EXPERIENCE

SAP HANA Architect

Confidential, Glendale, CA

Responsibilities:

• Working on SAP HANA/BOBJ Analytics solution for Vistex data for Confidential Health Care and Nutrition business (HCN).
• Created design documents and implemented solution for master data objects like Customer, Material etc for identifying issues with MD creation so that business can maintain consistent MD in SAP ECC sales and Vistex modules.
• Created design documents and implemented solution for Sales transactional data using credits & invoices, COPA from SAP ECC Sales and Claims data from Vistex.
• Created BOBJ self-service and enabled business to create ad-hoc analysis reports.
• Delivered HANA/BO Reporting Solution with HANA Calculation Views, Composite Providers, Web Intelligence and Analysis Office.
• HANA Authorizations/Security: Worked on transferring BW Authorizations to HANA, Roles & Privileges.
• Delivered Technical Specs with ER Diagrams, Build Instructions, Field Mappings, Rules, Filters, Joins, Cardinality, Process Flow and Business Test Scenarios.
• For phase 2 project, working with business to analyze requirements, to create design documents, deliverable planning for Vistex Agreements, Memberships, Billbacks, and Incentives.

SAP HANA/BW Architect

Confidential, Springdale, AR

Responsibilities:

• Worked on implementation of Product Cost Forecasting Solution to enable the business to create costing estimates based on current raw material prices, cost drivers, forex trends, raw material price overrides.
• Sourced the cost component details and product itemization and related master data from ECC using ODP/SLT data sources.
• Using ABAP SQL script Customized AMDP processes to build product itemization data using material BOM structures. Created new CDS views to integrate with other HANA data models.
• Built complex HANA data models to support analytics for Cost & Yield Volume Itemization, Costing Scenario Comparison, Spend Analysis, BOM Scenario Analysis for future BOM changes, Dis-Assembly Costing Analytics.
• Built integrated data models to consume Production Volume data coming from JDE and other sources.
• Used HANA Data Models in BW virtual objects to leverage BW master data for meaningful data analysis.
• Supported Tyson team to work with SAP on technical issues in HANA environment.

Sr. SAP HANA/BW Architect

Confidential, Houston, TX

Responsibilities:

• Worked on reporting solution implementation project for Confidential tax compliance process automation using SAP HANA /BW hybrid solution. SAP BW/HANA is used to interface with Endur for trading information, deals, movements, special ledger, volume tax and local taxes etc with SAP Finance, master data.
• Implemented HANA information models using LSA++ architecture.
• Worked extensively In HANA Studio to build EDAM HANA models to build enterprise wide harmonized HANA models to handle multiple data sources, build data mart/reporting HANA views to take care of business use case specific deviations to deliver to business needs.
• Developed HANA SQL procedures to create time dependent master data e.g customer, vendor, material, plant to track master data attribute changes required by business use case.
• Developed HANA views using table functions using HANA SQL for delivering complex use cases to improve performance and flexibility.
• Extensively used HANA composite providers to create reporting layer to implement hybrid solution using new native HANA models along with existing BW objects to create global reporting solution for both Confidential (HANA Models) and SOPUS (Legacy BW implementation).
• Interfaced SAP Trading source system for FI/GL, Shell GSAP source system for master data and SOPUS transactional data, Endur for trading, movements, billing, special ledger, taxation information.
• Created process automation for data interface monitoring, data reconciliation between all the involved systems for data integrity.
• Crated complex information models using HANA calculation views for trend analysis for volume movements, invoicing, tax filing support and error analysis reports.
• Used BOBJ WEBIs and AO Analysis for creating executive reports and adhoc analysis.
• Used BODS to interface with non-SAP data sources like Endur, and SAP SLT for interfacing with SAP data sources like Confidential SAP, Shell Global SAP source systems.
• Prepared cut-over plan and help execution of the production cut over and post production support for the project.