We provide IT Staff Augmentation Services!

Hana Technical Architect Resume

Modesto, CA

SUMMARY:

  • Have 14+ years of experience in SAP HANA, SAP BW/HANA along with SAP HANA CDS Views and SAP HANA Scripting Views, SAP HANA SDA, SAP BO, Hana with Lumira, ABAP/4 programming as a technical architecture & team lead
  • Worked with the global clients on complete implementation of S/4 HANA, SAP HANA, SAP BW/4 HANA and SAP BW development, Go - Live support
  • Responsible for the Technical Architect & Design SAP HANA, SAP BW, SAP BO project development lifecycle from project preparation, BBP (Business Blue Print), realization, final preparation, requirements gathering, functional technical design documents, development, unit testing, Integration testing, Use Acceptance Testing, Go-live and post Go-live support
  • Extensively worked on S/4 HANA CDS Views, Enhanced the Existing S/4 Hana Simple Finance CDS Views, Accounts receivables,, accounts payable, sales overview HANA live reports.
  • Consume CDS data model used by SAP S/4HANA can be considered a successor to SAP HANA Live Reports as CDS views as source provides front end reporting using BO WEBI .
  • Key player in the project related to SAP HANA Design, SAP BO Reporting across functional tracks like SD, CRM, MM, PP, QM, SCM demand planning, Generic extraction, HCM, HR, FI-AP (Accounts Payable) FI-AR(Accounts Receivables), FI-GL.
  • Developed complex IDT, WEBI Reports, Dashboards, Lumira visualizations Worked with SAP WEBI reports source as a SAP HANA Information Views, WEBI reports were scheduled on weekly basis, the output was sent in excel format to customer mail box directly
  • Experience in SAP HANA data provisioning using SAP LT replication server (SLT) and data service, SDI.
  • Design & creation of HANA attributes views, analytic views, calculation views, analytics privileges, attribute mapping, and calculated attributes, calculated measure, restricted measure, currency as unit of measure
  • Defined solution roadmap for HANA, BW & BOBJ application integration into Confidential ’s landscape
  • Managed key SAP HANA, BW & Business Objects initiatives with an oversight responsibility to deliver projects on time
  • Good knowledge on building HANA views, SLT, SDI/SDA and ETL process using Data Services
  • Expertise in creating, organizing, publishing and scheduling reports using CMC
  • Experience in test designing, test planning, writing test cases and executing test cases and coordinating defect resolution using HP-QC tool

TECHNICAL SKILLS:

  • SAP ECC 6
  • SAP ECC 5
  • SAP ECC 4.7
  • BI BW
  • BOBJ
  • BODS
  • HANA
  • SAP BW/ 4 HANA
  • SAP HANA Design Studio
  • SQLScript
  • CE Functions
  • PL/SQL
  • HANA 2
  • S/4 Hana Oracle 11g/10g/9i/8i/8.0
  • MS SQL Server 2000/7.0
  • MS Access
  • Mongo DB
  • SAP BW 7.0,7.3,7.3(HANA Powered), 7.4
  • BOBJ 4.2/4.0
  • SAP ECC 4.7,5.0,6.0
  • SAP HANA 1.0/2.0
  • SAP Net weaver 2004S
  • BODS

PROFESSIONAL EXPERIENCE:

Confidential, Modesto, CA

HANA Technical Architect

Module: SAP T&E, FI/CO, CRM, PS, CPM

Environment: HANA 2.0,SAP HANA, SLT, S/4 HANA, HANA Database, Business Objects, Data Services .

Responsibilities:

  • Involved in full cycle of implementation of SAP HANA, SAP BO which includes Analysis, requirements gathering, development, reporting, Go-live
  • Adopted the SAP S/4 HANA Activate methodology for implementing the S/4 HANA
  • Performed impact analysis on the legacy reporting systems to know the usage of the existing data.
  • Designed and Developed the Hybrid HANA\BW Data Models to extract Stable and Current data sets from CONCUR system to support UKIE, Singapore and MENA Expense Reporting
  • Created SAP HANA Modeling - HANA Calculation views, HANA CDS 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.
  • Experience in BW on HANA and Native HANA, S/4 HANA along with BOBJ and BODS ETL Tools.
  • Develop SAP BW On HANA Advanced DSOs (ADSO), Open ODS Views from, Composite Providers, Open Hub Destinations
  • Develop Custom Reports in BEX Query Designer and SAP Business Objects Web Intelligence
  • Involved in Build and Test Plan and Test cases by running multiple busiess scenarios.
  • Analysis, design and implementation of reports SAP (Tableau, BEX, BO Lumira) for the deployment of strategies in the Business Analysis.
  • Worked extensively in Virtual Data Model (VDM) development in Core Data Services (CDS) in S/4HANA.
  • SAP HANA Performance Optimization, Troubleshooting and Performance Analysis.
  • 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)
  • Developed Tableau visualizations and dashboards using HANA Views
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Confidential, St. Louis, MO

BW HANA Technical Architect

Module: SAP T&E, FI/CO, CRM, PS, CPM

Environment: HANA, SAP HANA,S/4, SLT, HANA Database, HANA Live, Business Objects, Data Services .

Responsibilities:

  • Involved in full cycle of implementation of SAP HANA, SAP BO which includes Analysis, requirements gathering, development, reporting, Go-live and Post Go-live support
  • SAP ECC is the data source and SAP Native HANA is the target system where optimized models will be developed for reporting in Business Intelligence Platform (BI 4.2 SP3 Web Intelligence and Analysis for Office tools).
  • Developed reporting solution to support auditing, Analysis and Tax Compliance for EY in GSA, Canada and South Africa.
  • To perform Ad hoc transactional data analysis in real/near real time to support the day to day operations as well support the closing activities
  • Key player in the project related to SAP HANA Models Design across functional tracks like Demand planning, Sales Planning Sales Forecasting Reports, SD, Inventory Reports, Invoice Detail Report, Manufacturing Productivity Reports, Analysis implementation of HANA live reports.
  • Developed SAP BO reporting solution in SAP FI, SAP CO
  • Utilized standard basic SAP S/4HANA CDS views consisting of master data for various consumption CDS query views, Maintained standard runtime hierarchies for profit center, cost center and financial statement versions,Created table functions in case of complex database functions where CDS has limitations in ansi sql
  • Analysis, design and implementation of reports SAP (Tableau, BEX, BO Lumira) for the deployment of strategies in the Business Analysis.
  • Worked with SAP IDT & BO WEBI Reports source as a HANA Calculation Views, SAP BO WEBI Reports were scheduled on weekly basis, the output was sent in excel format to customer mail box directly
  • SAP HANA Data Provisioning using SAP LT Replication Server (SLT), SAP HANA Troubleshooting and Performance Analysis
  • Designed, implemented and migrated complex Universes and Business Objects Reports and S/4Hana with Lumira, Created classes, subclasses, objects, Cardinalities, Conditions, Contexts, Joins, External Strategies, Prompts and Aliases for resolving Loops and checked the Integrity of the Universes.
  • Define and maintain design guidelines related to HANA and BI systems
  • Imported the Hana Views and created a model in Power Bi.
  • Created MTD, QTD and YoY Dashboards.
  • Validated the reports and Dashboards.

Confidential, Minneapolis, MN

BW HANA Technical Architect

Module: SAP T&E, FI/CO, CRM, PS.

Environment: HANA 1.0 SP12,SAP HANA, SLT, HANA Database, Business Objects .

Responsibilities:

  • Designed and Developed the Control Reports to Reconcille data between multiple systems inorder to track the Expense Information in a Given Batch .
  • Worked extensively in Virtual Data Model (VDM) development in Core Data Services (CDS) in S/4HANA.
  • Good knowledge Embedded Analytics in S/4 HANA & Using Emebeed CDS views .
  • Develop Custom Reports in BEX Query Designer and SAP Business Objects’ Web Intelligence, BO lumira.
  • using PL/SQL the Function Editor coding to push data into data base intensively.
  • Designed, implemented and migrated complex Universes and Business Objects Reports and S/4Hana with Lumira, Created classes, subclasses, objects, Cardinalities, Conditions, Contexts, Joins, External Strategies, Prompts and Aliases for resolving Loops and checked the Integrity of the Universes.
  • Extensively worked on S/4 HANA CDS Views, Enhanced the Existing S/4 Hana Simple Finance CDS Views, Accounts receivables,, accounts payable, sales overview HANA live reports.
  • Worked with business in Implementing Hana Live queries in OTC, RTR,
  • Developed ABAP FM to Extract data in BW, Data source enhancemet, User exits.
  • Worked extensively in PTP And OTC area to Create Planning Reports such as OEM Planning, Supplier Planner and Critical .
  • Develop Custom Reports in BEX Query Designer and SAP Business Objects’ Web Intelligence, BO lumira.
  • Develop SAP BW On HANA Advanced DSOs (ADSO), Open ODS Views, Composite Providers, Open Hub Destinations
  • Worked with Functional team and business to convert the requirements to Realtime HANA Reports
  • Key player in the project related Development and Design SAP HANA information Views, CDS Views, SQL Scripted Views, HANA live reports using front end tools BO WEBI and Analysis for office excel.
  • Involved in SAP HANA Security including User Management, Roles, and Privilege,
  • SAP HANA Performance Optimization, Troubleshooting and Performance Analysis.
  • 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)

Confidential, Stamford, CT

SAP HANA Technical Architect

Module: SAP T&E, FI/CO, CRM, PS.

Environment: HANA 1.0 SP12,SAP HANA, SLT, HANA Database, Business Objects .

Responsibilities:

  • Created BW/HANA based complex interfaces to support Expense Appraisal Tool.
  • Developed Macro Based Custom Extractors to Retrive data from TE Clusters in ECC.
  • Created Data flows using BW functionality to store the Expense Cluster Information into multiple ADSO,Composite Providers.
  • Created Hybrid Data Models using calculation views to access expense data from the Cluster data from ECC.
  • Created Data flows to the external systems to implement Appraisal Process in .Netbase systems using OHD
  • Designed MIS Applications to FTP the files from SAP to MS EDW.
  • Extensively worked on SAP HANA Modeling - attribute views, analytic views, 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
  • Developed SAP reporting solution to reconcile the data between the EDW and EAT systems.

Confidential, Topeka, KS

SAP BW/HANA Technical lead

Module: SAP PS, Travel & Expense, Timesheets, SD,Billing, Finance & Controlling, CPM, CRM, C4C, S2P

Environment: SAP BW7.5, SAP BEX, HANA studio PL/SQL, Business Objects front-end

Responsibilities:

  • Created BW/HANA based complex interfaces to support EY Specific reporting systems (EAT, MyEngagements, FR, COE and Marketing Reports).
  • Involved in full cycle of implementation of SAP BW on HANA, SAP HANA on BO which includes Analysis, Requirements gathering, Development, Testing, Reporting, Go-live and Post Go-live support
  • Translate the Business KPIs into HANA & Define the Reporting Layouts Using SAP BO WEBI reports
  • Experience with HANA Live and Virtual Data Mart (VDM). Building custom applications using VDMs
  • Involved in creating custom schema, non-ECC tables and SQL queries in SAP HANA
  • Involved in Data Provisioning from SAP ECC, SAP BW and non-SAP sources via SLT, BODS and DXC, HANA security including User Management, Roles and Analytic Privileges
  • Experienced with different Relational databases like Teradata Hadoop with HANA, Oracle and SQL Server, Created HANA optimized data providers Info cubes and Confidential created in SAP BW
  • H e lpi ng to t he R &A te am in critical iss ues in B EX r ep orti n g
  • Key player in the project related to SAP (ETL, EDW, BEX, BO) across functional tracks like Demand planning, Sales Planning Sales Forecasting Reports, SD, Inventory Reports, Invoice Detail Report, Manufacturing Productivity Reports
  • Analysis, design, and implementation of reports SAP (BEX, BO) for the deployment of strategies in the Business Analysis
  • Involved in full cycle of implementation of SAP BW on HANA, SAP HANA on BO, which includes Analysis, requirements gathering, development,reporting, Go-live and Post Go-live support
  • SAP HANA Troubleshooting and Performance Analysis
  • Lead the interaction between Infrastructure and BI development teams
  • Define and maintain design guidelines related to HANA and BI systems
  • Involved on Data Analysis, SQL, Hadoop integration with HANA.
  • Developed custom Confidential ’s, InfoCubes and MultiProvider for BI and IP reports.
  • Extensively worked on SAP HANA Modeling - attribute views, analytic views, 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
  • Involved data replication from SAP ECC to SAP HANA via SAP Landscape Transformation (SLT)
  • Involved in SAP HANA Security including User Management, Roles, and Privilege
  • Universe Design - UDT, Web intelligence - Webi Information Design Tool - IDT, Crystal Reports, CMC
  • Involved in Information Design Tool Creation of Data Foundation, Universe for HANA reporting
  • Broadcast data via SAP BW Open Hub APD Destinations like Data Warehouse, MDG, CRM, SD IP: Vistex Sales teams
  • Report development on SAP BO 4.0 WBBI & IDT tools, Sales Planning, Inventory reports by the agreed improvements
  • Experience in designing and developing the Universe & IDT and updating the existing Universes to CMC, Scheduling the processes and administering the BO activities. Scheduled the reports in info view
  • Develop Custom Reports in BEX Query Designer and SAP Business Objects’ Web Intelligence
  • Develop SAP BW On HANA Advanced DSOs (ADSO), Open ODS Views from, Composite Providers, Open Hub Destinations

Confidential, Montvale, NJ

SAP BW Consultant

Module: SAP CRM, SAP IS-U, BI.70, SD, FI-GL.

Environment: SAP BW 7.0, CRM, SD, FI

Responsibilities:

  • End-to-End experience: Logical & Physical Data Modeling, Extraction, Reporting, Scheduling, Performance Tuning.
  • Involved in Requirement gathering and analysis
  • Identified Data Sources and the Cubes for BI reporting
  • Enhanced Data Sources based on the Client requirements using LO-Cockpit extraction method.
  • Enhanced CRM Data Sources based on the Client requirements.
  • Designed the TDD for Modeling Specs, RDD for Report Technical Specs, Delivery Check list Document, Data flow diagram Document
  • Tasks included analysis of data requirements and the translation of these requirements into a custom dimensional data models.
  • Activated Business Content objects and designed, developed and modified Info Objects, Info Cubes, Confidential Objects, Transformations and DTP’s
  • Created a Dataflow for Infocubes and Datastore objects to hold the Planning and actual data from CRM and ECC.
  • Created Transformations and customized by adding routines and formula to derive the accounting fiscal period from Date and territory Explosion.
  • Extracted data from CRM and ECC using standard extraction procedures for the Trade Promotions LE and for the Real Time Reporting LE
  • Designed and developed BEx queries with customer exits (CMOD) variables to meet the advanced reporting requirements.
  • Involved in checking Unit testing results and coordinating with the Functional consultants to fulfill the user requirements.
  • Developed Reports to generate Actual/ Plan Funding and the Actual / Plan Spending report for the Trade Promotions.
  • Involved in Transports and fixing the transport issues.
  • Involved in giving training to the end users on the reports.

Confidential, Oklahoma City, OK

Technology Consultant

Module: FI/CO, SD, QM, MM, PM, FI-GL. Trade Management

Environment: BI 7.0

Responsibilities:

  • Involved in Requirement gathering and analysis
  • Participated in discussions & meetings with TMS team to understand the Data flow to be fed to BI system from ZOTM DB Connect
  • Designed the Document Templates for Modeling Technical Specs, Report Technical Specs, Delivery Check list Document, Data flow diagram Document
  • Involved in checking Unit testing results and coordinating with the Functional consultants to fulfill the user requirements.
  • Created an Infocube to Hold the Data of Deliveries and Shipments History Data
  • Created the Data flow from Datasource through Standard Confidential ’s for Actual and History.
  • Generated a Datasources from the Infocube and Confidential ’s to load the Data to OTM system for Actual Freight pay planning.
  • Created Transformations and customized by adding routines and formula to derive the accounting fiscal period from Date.
  • Extracted the Actual Data from OTM System for Actual pay reporting and Accrual Reporting.
  • Developed the Reports and web templates for freight pay reports and published Iveiw in the Portal.
  • Identifying the fields and Data Sources for BI reporting
  • Enhanced Data Sources which has eliminated most of the routines.
  • Development of BI Objects - Info Objects, DSOs
  • Verifying and validate the data with source system data
  • Created Process chains for master data and Transaction data.
  • Performed data loading and fixed various issues
  • Creating and submitting the Ticket Status (Open/Close) report.
  • Preparing Documentation for all the tickets that has been resolved during the week
  • Handled the tickets of priority P1, P2 and P3 by following (SOP) Standard Operating Procedures and never missed the (SLA) Service Level Agreement.
  • Coverage of Problem tickets according procedures in order to meet the SLA for production support.
  • Involved in monitoring the process chains and working on change requests
  • Involved in doing integration testing and maintaining the test Cases.
  • Worked with BI Accelerator, involved in monitoring BIA activities.

Confidential, Washington, D.C

SAP BI Lead Consultant

Environment: SAP CRM, FI-GL, SD, FICO, PM, SAP BW, BEX, ABAP/4, Flat Files, Oracle

Responsibilities:

  • Created many complex and customized reports for specific business requirements and also involved in new features of SAP BI security like Analysis authorization
  • Maintained Process Chains to automate and schedule the data loads
  • Major Responsibilities include Data loading Monitoring /Issue resolution
  • Participated in discussions & meetings with APO team to understand the Data flow to be fed to APO system from BI. Created complex Transformations in BW which had end routines to keep the Data for only a year.
  • Designed the Document Templates for Modeling Technical Specs, Report Technical Specs, Delivery Check list Document, Data flow diagram Document
  • Involved in checking Unit testing results and coordinating with the Functional consultants to fulfill the user requirements.
  • Created an Infocube to Hold the Data of Deliveries and Shipments History Data
  • Created Flat file Data sources to Load Data for Demand Planning and Supply Network Planning.
  • Created the Data flow from Datasource through Write Optimized Confidential ’s to Standard Confidential ’s for DP and SNP.
  • Generated a Datasources from the Infocube and Confidential ’s to load the Data to APO system for Demand Planning and Supply Network Planning.
  • Written Complex Routines to hold the latest version Data in the Confidential ’s from Flat files.
  • Extracted the Planned Data from APO System for Demand Planning and Supply Network Planning.
  • Developed the Reports for Demand Plan Vs Supply Plan, Sales Actual Vs Sales Plan and Supply Plan Vs Supply Actual.
  • Involved in Analyzing the Performance of the queries and improving the query performance by analyzing the Cardinality of the Dimensions of the Info cube.
  • Installed Business Content and designed and activated Confidential ’s to meet user needs. Created several Confidential objects which act as data staging. Scheduled and Implemented delta mechanism for periodic loads.
  • Uploaded master and transactional data from flat files, SAP BW and SAP R/3.
  • Created Custom tables and custom transaction to store user input and load the data into BI.
  • Enhanced the Datasource by adding the required additional fields in R/3 and mapped the same with corresponding newly created InfoObjects on BW side
  • Enhanced start routines and update routine to allow Costcenter exclusions and inclusions as per the user selections.
  • Designed and developed preprocessor report, allocation report and LHRH report.
  • Customized BEx queries to enable new changes YTD information, comparison reports and total consumption days and period reports using customer exist.
  • Developed and Tested Web Reports for drill down functionality including update rules and transfer rules & verifying queries.
  • Created Web Templates and provided web reporting in the organization. Created views and Customized Web reports. And the Reports are made available through the Enterprise Portals.
  • Collected the objects and transported to QA and after testing moved to Production. Provided support in the production environment

Confidential, Mississauga, ON

SAP BW Consultant

Module: FI-AR, FI-AP, FI GL, SD Logistics, MM, Spend Analytics, Inventory 2.0, Spend Analytics, Unit Cost, Manufacturing Productivity, Inflation, Customer Profitability and Customer Sales, Cost Center Accounts, PM, QM

Environment: SAP ERP 6.0, BI/BW, Business Objects 3.x, Data stage, HPQC, REMEDY, Flat Files

Responsibilities:

  • Worked extensively on standard and custom defined extractors. Installed relevant SAP business content. Used LO structures for extracting sales order, delivery information. Logistics Cockpit configuration and customization.
  • Designed the Document Templates for Modeling Technical Specs, Report Technical Specs, Delivery Check list Document, Data flow diagram Documents.
  • Involved in BEx Query Design and formatting.
  • Involved in Installing of Business content objects like Master data objects and different data targets.
  • Setting transfer rules, writing transfer routines, writing start routine, and update routines.
  • Created ODS structures, Info-Cubes, custom Queries, etc.
  • Worked in creating Queries by defining rows, columns and free characteristics providing drill down functionality in reporting using BEx.
  • Extensively used calculated and Restricted Key Figures, exceptions, Structures and conditions for the queries.
  • Extensively worked on utilizing PSA for effective loads and Error Handling.
  • Enhanced Business Content data sources according to the user requirement.
  • Published the BEx queries in to Enterprise portals using iViews.
  • Involved in transportation of objects to Development and Quality servers.
  • Involved in the Integration testing in quality of Objects
  • Involved in solving performance-related issues. Extensively worked in many Performance issue improvements in both loading and Execution activities.
  • Involved in Transporting the BW objects from development server to Quality server for Regression testing and Unit testing.

Confidential, Toronto, Canada

Associate Consultant

Module: SAP BW 3.5, FI, SD Logistics

Environment: SAP ERP 5.0 SAP BI, ABAP/4

Responsibilities:

  • Transporting objects from BW system to BW system and then across to Production Land scape, Carried out the house-keeping before moving the BW to BW
  • Monitering the BW process chains data loads .
  • Heping to the R&A team in critical issues in BEX reporting
  • Carrying the necessary configuration changes as per the business requirement
  • Handling the Business critical tickets with in the SLA

Hire Now