We provide IT Staff Augmentation Services!

Sap Hana Architect Resume

SUMMARY

  • More TEMPthan 13 years hands on experience wif SAP HANA Native, BWHANA,HANA Modeling S/4 Hana,Oracle,BODS/BOBJ, SAP R/3 ECC, SLT, Webi, Crystal Report implementation and Post Implementation, Production support, administration and consulting activities wif overall IT experience on a wide range of business applications.
  • 7 years of SAP HANA Design, Modeling, BI/BW HANA experience
  • Extensive experience wif HANA 1.0 / 2.0, S/4 Hana
  • 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.
  • Expereince in Designing, Building, Testing and Deploying a HANA Native solutions using Calc Views, Table Functions, SQL Scripts and Function Modules.
  • Experience in creating SAP HANA information models such as Packages, Attribute Views, Analytic Views, and Calculation Views wif graphical and script based methods, using SQL, SQL Script, and CE Functions as needed.
  • Worked on SAP HANA Data provisioning technology including SAP LT, Data Services - BODS, DXC; Received Data from Multiple modules-FICO, MM, SD.
  • Experience in Importing meta data, Table definitions,performing initial load and Replication, Resuming and Suspendingdata loads using SAP HANA studio
  • Experience in Configuring and ConsumingSAP HANAmodels in BI clients such as SAP Business Object Explorer and MS Excel.
  • Excellent professional experience in Software Development Life Cycle dat includes requirement gathering, design, project implementation, system test and implementation, user support and training.
  • Experience wif Business analysis capabilities (ability to interact directly wif business user to establish requirement
  • noledge of SAP Enterprise Resource Planning (ERP) Central Component (ECC) and Suite on HANA, SAP Business Warehouse (B/W) Suite and B/W on HANA.
  • Experience wif data warehouse architecture and methodologies preferred.
  • Hands on experience in SAP HANA Data provisioning using SAP BO Data Services 4.0. and have noledge SLT Replication server. Gained experience wif DATA Extraction Transfer Loading ETL for loading data from SAP ECC System to SAP HANA System. Having good noledge on SAP HANA Architecture. Well versed wif importing Meta data, table definitions, performing initial load and replication, resuming and suspending data loads using SAP HANA studio.
  • Ability to interface wif all levels in customers and strong abstract thinking wif problem solving skills.
  • Experience in data modeling (SAP BW and HANA) on enterprise data and its utilization.

TECHNICAL SKILLS

  • SAP BI business requirement and blue printing
  • SAP BI functional and technical requirement gathering
  • Team lead and mentoring
  • Knowledge transfer
  • Data Report and Data visualization
  • Cutover activates
  • SAP modules business process and table noledge
  • KPI and Dashboard build
  • 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
  • Programming, problem solving, Design patterns, Research and development, Mentoring/Training, Testing

PROFESSIONAL EXPERIENCE

Confidential

SAP HANA Architect

Responsibilities:

  • Working on IFRS project (FICO) for Mobility (Three layers Landing, NDB(Normalization Database, RAI (Revenue Accounting Items) using SAP HANA Native 2.0, S/4 Hana, SAP Hana Studio, BW,BODS,SLT,SAP Business Objects, BOBJ
  • Involved in business and blueprint gathering discussion.
  • Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
  • 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
  • Designed and implemented SAP HANA modeling using Attribute View, Analytic View, Calculation View and CE- Function
  • Analysed the error data using ETL Tool - SAP HANA database and provide solution to the teams to fix the issue occurred in ETL Process
  • Involved in writing SQL queries to verify data quality, data count and data type in the normalization of ETL Process
  • Analysed the data in Landing, Normalised Database and RAI stages in ETL Process by using the ETL tool - SAP BODS
  • Analysis of the error code and performing reverse engineering to find the cause of error using SAP HANA Studio in Calculation view, store procedure
  • Prepared technical documentation containing all required where about of the assigned error for

Technical Environment: SAP HANA 2.0, S/4 HANA,SAP ECC 6.0, SAP BODS 4.2, Hana Studio,PL/SQL,ETL.,IFRS(FICO)

Confidential

SAP HANA Lead

Responsibilities:

  • Created Technical specifications and standard modeling documents for HANA.
  • Involved in business and blueprint gathering discussion.
  • Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
  • Developed complex calculation view using SQL and CE-Function.
  • Ability to develop and maintain TEMPeffective relationships wif business partners\
  • Created advanced modeling using Hierarchies, derived views, restricted calculated column, variable, input parameter.
  • Worked extensively in Virtual Data Model (VDM) development in Core Data Services (CDS) in S/4HANA.
  • Developed complex calculation view using SQL and CE-Function.
  • Designed and implemented SAP HANA modeling using Attribute View, Analytic View, Calculation View and CE- Function
  • Created advanced modeling using Hierarchies, derived views, restricted calculated column, variable, input parameter.
  • Created web services for querying HANA database from external end user report portal using real time jobs in data services 4.0 designer.
  • Created Universes on top of HANA calculation views and developed the Webi reports and dashboards using IDT Information design tool .
  • Involved in developing test scripts and assisted UAT on SAP net weaver portal using Test ID's for super users, and end users.
  • Integrated BOBJ 4.0 and BODS 4.0 wif SAP HANA1.0.
  • Ability to lead, coach and motivate individuals and develop teams

Technical Environment: SAP HANA 2.0, SAP BW 7.4,7.3, ECC 6.0, SAP Business Objects Enterprise 4.2, SAP BODS 4.2, Hana Studio, Information Design Tool, Interactive Analysis, Dashboard Designer, SAP Design Studio, Advanced Analysis for OLAP and BO Launch Pad, Business Objects Explorer

Confidential

SAP HANA Lead

Responsibilities:

  • SAP HANA information model design and build including Attribute View, Analytic View, Calculation View, Analytical Privileges and Schemas.
  • Designed, implemented and migrated complex Universes and Business Objects Reports and S/4Hana wif Lumira, Created classes, subclasses, objects, Cardinalities, Conditions, Contexts, Joins, External Strategies, Prompts and Aliases for resolving Loops and checked the Integrity of the Universes.
  • Installation/Upgrade to BIP 4.1 SP2/SP3 and Data Services. Installation wif SQL and Oracle Database. Migration from tomcat to SAP NW and providing support for the BOBJ Landscape.
  • User/security administration, system refreshes and Client administration (automation of client copies).
  • Create and restore data backups.
  • Printer or spool configuration and administration.
  • Monitor and manage the servers, background jobs, performance of the system.
  • Installation, Post Installation, Backup and Recovery, Monitoring and Troubleshooting using SAP HANA
  • Migration to SAP HANA using the Database Migration option (DMO) of Software Update Manager (SUM)
  • SAP HANA High Availability Scale Out
  • Developed the security model, Naming conventions, folder structure for HANA 1.0 and BOBJ 4.0 and established the recommended SAP best practices for developing Universes, reports and dashboards from HANA data sources.
  • Used Information design tool to create connections to SAPHANA databases, Create data foundations, Create Business Layer and publish these connections and layers to the SAP BO repository.
  • Designed SAP HANA data models (information Views) and BW InfoCubes /InfoProviders for report consumption.

Technical Environment: SAP HANA 1.0/2.0, S/4 Hana,SAP BW 7.4,7.3, ECC 6.0, SAP Business Objects Enterprise 4.2, SAP BODS 4.2, Hana Studio, Oracle

Confidential, Toronto, Canada

SAP HANA Developer

Responsibilities:

  • SAP HANA information model design and build including Attribute View, Analytic View, Calculation View, Analytical Privileges and Schemas.
  • Developed the security model, Naming conventions, folder structure for HANA 1.0 and BOBJ 4.0 and established the recommended SAP best practices for developing Universes, reports and dashboards from HANA data sources.
  • Used Information design tool to create connections to SAPHANA databases, Create data foundations, Create Business Layer and publish these connections and layers to the SAP BO repository.
  • Designed SAP HANA data models (information Views) and BW InfoCubes /InfoProviders for report consumption.
  • Worked wif exiting BI team to integrate reports using SAP BW/BI/SAP HANA, Webi4 and Dashboard
  • Designed and built multiple universes for information model consumption using IDT.
  • Integrated SAP BODS wif SAP HANA.
  • Developed SQL script procedures for complex reusable scenarios in SAP HANA
  • Created SAP HANA database users, role, analytical privileges for data and data model security.
  • Developed reports on Calculation View/Analytic View using Webi and crystal reports

Technical Environment: SAP HANA 1.0, ECC 6.0, SAP Business Objects Enterprise 4.2, SAP BODS 4.2, Hana Studio, Sql server

Confidential

SAP Hana Consultant

Responsibilities:

  • Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
  • Developed complex calculation view using SQL and CE-Function.
  • SAP HANA information model design and build including Attribute View, Analytic View, Calculation View, Analytical Privileges and Schemas.
  • Developed the security model, Naming conventions, folder structure for HANA 1.0 and BOBJ 4.0 and established the recommended SAP best practices for developing Universes, reports and dashboards from HANA data sources.
  • SAP Business object development in IDT, WEBI, Lumira and Dashboard
  • Created advanced modeling using Hierarchies, derived views, restricted calculated column, variable, input parameter.
  • Build multiple reports and dashboards using Webi, BO Xcelsius, Crystal Report
  • Redesigning stored procedures to accommodate projects for SQL Server 2000 & 2005.
  • Design, Test and Implement Disaster Recovery solutions for clients.
  • Implemented Layered Saleable Architecture Data Staging and Data Modeling, LSA ++ in conjunction wif Graphic Data Modeling
  • Post Consolidation ( Run reports & Reconciliation )
  • SAP HANA(Native modeling) information model build, test and transport
  • SAP HANA Live content deployment for insurance (POC)

Technical Environment: SAP HANA 2.0, SAP BW 7.4,7.3, ECC 6.0, SAP Business Objects Enterprise 4.0, Hana Studio, Information Design Tool, Interactive Analysis, Dashboard Designer, SAP Design Studio, BO Launch Pad, Business Objects Explorer

Confidential

SAP HANA Consulting

Responsibilities:

  • Created Attribute views, Analytical views and Calculation Views using database tables. Created calculated measures, restricted measures and columns, input parameters to satisfy reporting requirements.
  • 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.
  • Used Information Design Tool IDT to create Relational Connection, Data Foundation and Business Layer and publish these connections and layers to SAP BO Repository.
  • Worked wif Business to finalize the reporting and model business and technical requirements
  • Identify and finalize FICO,PSCD and CRM Tables required for phase 1 reporting and analytics
  • Identify and formalized the model build logic
  • Develop Data Services(BODS) jobs from PSCD, FICO and CRM wif complex transformation
  • Develop SLT configuration for real-time data load
  • Develop SAP HANA decision table process to manipulate the data
  • Design and build Attribute View, Analytical View and non-scripted/scripted Calculation view
  • Design and build SAP HANA Model for health insurance premium collection and claims ratio
  • Build explorer and Lumira information spaces for data consumption
  • Design and architect SAP HANA security using Users, Role and Analytical Privileges

Technical Environment: SAP HANA 1.0, SAP BODS 4.0, Hana Studio, SQL

Confidential

ECC/NetWeaver Security Administrator

Responsibilities:

  • Tested & applied security patches for database and applications.
  • Applied support packages and stacks to SAP NetWeaver components.
  • Performed Client Administration, Client Copy, User Maintenance, Locking / Unlocking Users.
  • Performed stopping and restarting SAP application server(s) and SAP database instance during scheduled and planned maintenance.
  • Worked wif customers on R/3 implementations in terms of development, quality assurance, and production performance.
  • Configured Spool System and setting up Front-end Printers.
  • Configured TMS (Transport Management System) and responsible for change requests deployments.
  • Moved Transports to clients in SAP Landscape (DEV, QAS, PROD & TRNG).
  • Monitored and worked to improve overall SAP system performance.
  • Performed SAP R/3 upgrade from 4.6 to 4.7 and performing necessary post installation steps.
  • Performed Client Administration, Client Copy, User Maintenance, Locking / Unlocking Users
  • Used PFCG transaction code to perform the Role Maintenance.
  • Troubleshooting logon, printer and other system issues on day to day bases.
  • 24 x 7 production support.
  • Monitored and worked to improve overall SAP system performance.
  • Performed SAP R/3 upgrade from 4.6 to 4.7 and performing necessary post installation steps
  • Create and restore data backups.
  • Printer or spool configuration and administration.
  • Monitor and manage the servers, background jobs, performance of the system.
  • Performed Operating System Administration: Monitoring disk growth, memory usage and other system resource periodically
  • Performed Client Administration, Client Copy, User Maintenance, Locking / Unlocking Users
  • Manage the SQL DB2/Oracle databases.
  • Monitored and worked to improve overall SAP system performance.

Technical Environment: SAP R3 4.6, ECC 5/6, Net Weaver 04/04s(WAS6.2/6.4), EHP4/5 XI/P13/7,SAP HANA, Solution Manager 4.0/7.0,Window, Lunix

Hire Now