SUMMARY

• SAP Certified, expert with total of 14 years of IT experience, including SAP HANA2.0 XSA, BW on HANA, TABLEAU, PLANNING, BUSINESS OBJECTS and SQL Scripting
• Around 6 years of experience as SAP HANA Enterprise Development including HANA 2.0 XSA
• Worked on HANA Data modeling using calculation views for master data and transaction data. Experience in performance tuning, data sizing, and HANA Dynamic Tiering
• Experience in Security & Authorization objects (Analytic privilege, System privilege, Object Privilege, SQL privilege & Package privilege) and User Management
• Experience with ETL tools such as SLT, SDA/SDI, Flow graphs and BODS (Data Services)
• Experience with SAP HANA programming including SQL, SQL script, Procedures, Table functions, CE - functions, Virtual Data Model (VDM), and Core Data Services (CDS)
• End to end experience in designing, development, Administration and deploying data visualizations using Tableau. Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau
• Extensive experience in SAP BW on HANA, SAP BW 7.5/7.4/7.3/7.0/3.5 configuration, OLTP Extraction and Reporting
• Hands-on experience working with SAP BW on HANA features, standard and custom SAP BW Extractors, complex transformations using ABAP, advanced DSOs, composite providers, exposing BW models as HANA views, mixed scenarios, HANA Analysis process in BW and LSA ++ best practice and performance optimization concepts
• Worked on planning applications such as Integrated planning (IP) and Business planning & simulation (BPS)
• Worked on BW reports using BEx Browser, BEx Analyzer, VBA, and Web Application Designer
• Expertise with SAP Business Objects Analysis for office, edition for Microsoft Office
• Experience on Universes, BI Launch pad, Live Office, WEBI and BO Dashboards using Business Object 4.0 platform
• Experienced in SAP ABAP programming techniques including Reporting, Dialog Programming, BDC, ALE, IDoc, LSMW, SAP Script, BAdIs and user exits
• Worked extensively on SD, MM, CRM, CO-PA, FI, HR, IS-U and Generic data Extractions
• Expertise in Test Models, Unit, Functional, integration and Regression testing all the modules to make sure it is working as expected and data is going through appropriate transformation steps and bug fixes
• Excellent technical, business, communication, and time management skills

TECHNICAL SKILLS

SAP HANA: HANA 2.0 XSA, HANA 1.0, S/4 HANA

SAP BI/BW: BW/4HANA, BW on HANA 7.5/7.4/7.3, BI 7.0, BW 3.5

Data Provisioning: SLT, SDA, SDI, BODS

Reporting Tools: Tableau, Lumira, Webi, BO-Explorer, AO, IDT, Xcelsius and Design Studio

ERP: SAP ECC, SAP CRM, SAP APO

Databases: HANA2.0/1.0, Oracle, DB2, SQL, MS Access 2010, Soteria, Maximo

Project Management: Microsoft Suite (Project, Visio, MS Office, PowerPoint, Excel)

Others: SharePoint

Functional Experience: Manufacturing, Pharma, IS-U, Retail, Oil & Gas

PROFESSIONAL EXPERIENCE

Confidential

SAP HANA Consultant

Responsibilities:

• Gathered requirements for Downstream Sales Volumes, production volumes and Chemicals
• Created solution design architecture and technical specifications
• Designed and developed MDC containers in HANA 2.0 XSA and developed HANA views for master data and transaction data using Web IDE
• Configured GIT and TFS for code versioning control of SAP HANA 2.0 artifacts
• Developed XSA based models of HANA 2.0 and SDI flowgraphs. Created synonyms and virtual tables from different HANA tenants using SDI/SDA remote source
• Configured UI5 and Node JS MTA modules to upload flat files through UI5 portal for monthly manual adjustments and mapping tables
• Created Tableau dashboard for monthly and YTD volumes reporting
• Created Tableau dashboard for monthly plant maintenance balance for Downstream chemicals
• Created Tableau dashboard for 5 Year trend analysis for Downstream production volumes
• Developed Business objects Analysis for office workbook for Global BAR and PO to analyze HANA data
• Participated in Security & Control reviews to understand data security. Setup user roles for Tableau dashboard and region wise roles (North America, Asia specific and Europe) using HANA analytic privileges
• Participated in daily scrum calls using agile methodology. Used TFS for PBIs and daily tasks
• Worked on SQL, SQL Scripting, Table functions and Stored procedures on various requirements such as deriving YTD, Previous year YTD, Data validation checks while uploading CSV files into HANA tables through UI5 and controlling lock mechanism for MEC.
• Scheduled UC4 jobs. Provided extended support to OGM analysts during MEC
• Involved in Functional Unit, Integration and User acceptance testing during Cutover
• Created job Aid documents with step-by-step and provided user training on the usage of new tools for month end process.

Environment: SAP HANA XSA 2.0 SPS03, SDA/SDI, SLT, SAP ECC 6.0, Tableau, SQL scripting, and Oil & Gas.

Confidential

SAP HANA Consultant

Responsibilities:

• Interacted with business users by conducting meetings and understanding the requirements specified in the BRD
• Created solution design architecture, Functionals specifications and technical specifications
• Created Master data objects, Advanced DSO’s, Composite providers and Open ODS views following LSA++ architecture
• Created HANA calculation views for Master data and transaction data
• Leveraged ABAP skills to enhance BW data sources using BADI and CMOD user exit
• Involved in SAP HANA Security including User Management, Roles, and analytic Privileges
• Done SAP HANA Performance Optimization, Troubleshooting and Performance Analysis
• Developed Open Hub interface to send Sales order data to SWIFT DB using BODS for the forecasting
• Created Quality Notification dashboard using tableau for Notification types and defects
• Created Tableau dashboards for Auditing, Inventory layering, missed demand, Projections (Outbound orders, Inbound orders, Inventory position, Order point, and Order up to level)
• Setup input template for sales planning and forecasting using BO Analysis for office. Created Aggregation Levels, Planning Filters, Planning functions, Planning Sequences, Characteristic Relationships using integrated planning.

Environment: SAP BW on HANA 7.5, SAP HANA 1.0, SAP ECC 6.0, Tableau, Integrated planning, SWIFT, Data services

Confidential

SAP HANA Consultant

Responsibilities:

• Involved in full life cycle of implementation of SAP HCI, S/4 HANA which includes Analysis, requirements gathering, development, reporting, Go-live and Post Go-live support
• Extensively worked on SAP HANA Modeling - HANA Calculation views, analytical Privileges, Column store views and performed SQL, Creating Function using PL/SQL the Function Editor coding to push data into data base intensively
• Created a HR-Safety dashboard using Design studio
• Created dashboards using WEBI for HR trainings and Qualifications
• Developed Analysis for Office and OLAP Analysis Reports against OLAP Connections
• Extracted HR data from different applications such as Soteria, Maximo and CaLamp
• Developed SAP BW /4HANA Advanced DSOs (ADSO), Open ODS Views, Composite Providers, Open Hub Destinations
• Native Hana hands-on development experience: creating SAP HANA information models such as Procedure and Hana Views (Attribute, Analytics and Calculation views) with graphical and SQL Scripting, SDA (Smart Data Access), SAP HANA Live (Analytics)
• Created Publications and published various reports in HTML format, with PDF and Excel attachments, to Email and File System (Remote Location)
• Co-ordinated for sign-off from Business users and support team. Migrated objects to production and provided production support.

Environment: SAP BW/4HANA, SAP HANA 1.0, SAP ECC 6.0, Maximo, Soteria, CalAmp, S/4 HANA, Business Objects WEBI, Design studio.

Confidential

SAP HANA/BW Lead Consultant

Responsibilities:

• Migrated aging BW infrastructure to the in-memory HANA database, including all the necessary data objects, and implemented security requirements
• Involved in developing the HANA artifacts Attribute, Analytical view, calculation view, analytic privileges
• Imported and Exported the HANA information views through Delivery unit across the environments
• Designed security for SAP HANA implementation, Created customized roles in SAP HANA DB for developers, modelers, technical admins, end users, and power users
• Created data models in SAP BW and ECC, and built BOBJ WebI and Dashboards for the business analysts to analyze life cycle of different CNP assets and make appropriate investments
• Created and scheduled the customer satisfaction survey report using WEBI for the distribution power delivery unit to request feedback from customers who have received services from Center Point Energy
• Created WEBI Ad-hoc, dashboards/scorecards, and BOBJ Explorer on top of HANA models for the fleet department to manage fuel efficiency, employee productivity, and vehicle maintenance schedule
• Developed OpenHub interfaces for extracting FICA data for the financial auditors
• Leveraged ABAP skills to enhance BW data sources using BADI and CMOD user exit.

Environment: SAP BW 7.3, 7.1, SAP BO 4.1, SAP HANA 1.0, SAP ECC 6.0, SAP IS-U, BEx Analyzer, and ABAP/4

Confidential

SAP BI/BW Technical Lead

Responsibilities:

• Conducts analysis, requirement gathering, estimation and reviews the issues and suggests solutions
• Worked extensively on BW 7.3 data warehousing workbench and customized Info Objects, Info Cubes, DSOs, transformations, DTP’s, Info sets, Multi providers, Semantic partitioning, data flow copy and Composite provider
• Worked on start routine, end routine and transformation routine
• Worked extensively on BW BEx Analyzer in building Queries and saving them as Workbooks (Excel work sheets)
• Architected and Implemented SAP Business Objects Solutions using SAP BW as backend, hands on development experience of WEBI, DESKI, Xcelsius 2008, Crystal reports and Universe Designer (UDT / IDT)
• Developed dashboards in Xcelsius, used dynamic visibility with several components. Used QAWS to fetch data from Oracle database
• Effectively administered and supervised the Business Objects (SAP BI) environment by monitoring/granting permissions and rights to users for viewing, creating and publishing reports.
• Created various reports such as Sales analysis report for YTD, MTD, and QTD, Sales analysis for Actual Vs Plan, Inventory actual Vs plan/Estimate, Balance sheet report, One-month DSI in USD, One-month DSI in Local and AR comparison reports
• Developed enhancements for BPS (BW-SEM) Web page to distribute actual amounts to the posting periods based on the percentages for Cost Centre planning and Profit Centre
• Created real time info cubes and involved in BPS planning process design and mapping, requirements workshop, configuring Planning Area, Planning Level, Planning Functions, Parameter Group, Planning Layouts, Manual Planning, and global planning sequences
• Created planning input templates using web interface builder.

Environment: SAP BW 7.3, 7.1, SAP ECC 6.0, BOBJ, BPS, BEx Analyzer, WAD, ABAP/4, FICO, SD, MM, PP, PM, and WM.