We provide IT Staff Augmentation Services!

Sap Hana Architect Resume

3.00/5 (Submit Your Rating)

Licoln, Ne

PROFESSIONAL SUMMARY:

  • Speaker / Presenter at Sapphire, ASUG and various other events along with webinars across the globe.
  • Very strong understanding of Technology with knowledge in multiple areas of specialization.
  • Complete lifecycle SAP HANA, SAP BW, SAP BI and Big Data projects including upgrade and support Projects.
  • Strong hands on experience in SAP HANA, BW and BI on Linux environments including installs and development.
  • HANA project scenarios include Datamarts, BW on HANA, Rapid Deployment Solutions and Sidecar.
  • Experience in SAP HANA, Vora, SAP Lumira and Hadoop, Data lakes, Analytics and Integration.
  • Solutions architect for enterprise wide deployment, scalability, availability and performance issues.
  • BI Vision, Roadmap Creation and Execution through business performance and effectiveness using Analytics.
  • Conducted design evaluation workshops with senior management and business process experts.
  • Knowledge of multiple languages, multiple platforms and several development methodologies.
  • Experienced in working and communicating with C level and/or Executive Level.
  • Use Case scenarios to help business and IT understand the system and need in much effective way.
  • Great technology skills and the ability to map them to business solutions.
  • Wore multiple hats from a Software Engineer, technical presales to lead to architect and Practice lead.
  • Extensive experience in all aspects of Strategy, Assessments, Workshops, Upgrades, Implementation and Adoption.
  • Worked in multiple countries (India, Singapore and Japan) solving technical issues and suggest effective solutions.
  • Quick learner with a zeal for new technologies and growth with excellent communication and presentation skills.
  • Always positive with a lot of patience and persistence to overcome any scenario.

TECHNICAL COMPETENCIES:

ERP / Data Warehouse: SAP, BW, Oracle

Operating Systems: Linux, Windows

RDBMS / Language: Oracle, IBM DB2, MS SQL Server, SAP HANA, Sybase, Python, SQL Script

HANA Scenarios: Datamarts, RDS, BW on HANA, Sidecar, S/4 HANA, Dynamic Tiering, NLS

Replication Tools: SLT (Landscape Transformation), DataServices, DxC (Direct Extractors), SDA

Reports / Visualization: SAP Business Objects, Lumira, Tableau, Cognos, Microstrategy, Qlikview

Big Data: Vora, IoT, Hadoop

Hadoop Eco System: HDFS, Map Reduce, Hive, PIG, Zookeeper, Sqoop, Flume, Spark, Flink

PROFESSIONAL EXPERIENCE:

Confidential

SAP HANA Architect

Environment: SAP HANA, Epic, Lumira, Spatial Analytics, Business ObjectsResponsibilities:

  • Implement the SAP Net Weaver BW on SAP HANA database platform.
  • Worked initially around BW on HANA followed by deploying, working and modeling BW data on HANA.
  • Enhanced the BW objects related to Sales analysis and financial Dashboard.
  • Created Data flow diagrams, design documents, technical specification and Deployment plan documents.
  • Developed new reports to be used by BI Explorer and WebI.
  • Created Navigational attributes for better reporting functionalities and accessibility.
  • Designed an EDW solution for reporting using SAP HANA as EDW.
  • Transformed InfoCubes and DataStore Objects to HANA - optimized objects.

 Confidential

SAP HANA Architect

Environment: HANA, Oracle DW, Non - SAP Sources, Retail Application, Dynamic Tiering

Responsibilities:

  • Implement the SAP Net Weaver BW on SAP HANA database platform.
  • Worked initially around BW on HANA followed by deploying, working and modeling BW data on HANA.
  • Enhanced the BW objects related to Sales analysis and financial Dashboard.
  • Created Data flow diagrams, design documents, technical specification and Deployment plan documents.
  • Developed new reports to be used by BI Explorer and WebI.
  • Created Navigational attributes for better reporting functionalities and accessibility.
  • Designed an EDW solution for reporting using SAP HANA as EDW.
  • Transformed InfoCubes and DataStore Objects to HANA-optimized objects.

ConfidentialSAP HANA Architect

Environment: BW on HANA, ECC 6.0, Oracle, SAP BI 4.0

Responsibilities:

  • Implement the SAP Net Weaver BW on SAP HANA database platform.
  • Worked initially around BW on HANA followed by deploying, working and modeling BW data on HANA.
  • Enhanced the BW objects related to Sales analysis and financial Dashboard.
  • Created Data flow diagrams, design documents, technical specification and Deployment plan documents.
  • Developed new reports to be used by BI Explorer and WebI.
  • Created Navigational attributes for better reporting functionalities and accessibility.
  • Designed an EDW solution for reporting using SAP HANA as EDW.
  • Transformed InfoCubes and DataStore Objects to HANA-optimized objects.

Confidential

SAP HANA Architect

Environment: HANA, ECC 6.0, J.D Edwards, SAP BW, SAP BI, Non-SAP Applications

Responsibilities:

  • Data volumes, data types and IT environment consisting 3 different ERP's, couple internal pricing and ordering systems made reporting impossible using SAP BW.
  • Existing BW environment was too slow for analysis and reporting for example like purchases by product lines and volumes, store locations, sales channels and many scenarios.
  • Incomplete or inconsistent data in reports due to desperate technologies and no common database to rely upon for all these analysis.
  • Created multiple schemas for all the data sources into data marts and used modeling techniques by interlinking all the data in tables based on relationships with help of strong subject matter experts.
  • Result was a single source of information for all the ERP's and couple of internal systems in HANA.
  • HANA Project was completed successfully in 8 months where as the Business Integration project still had 14 months of timeline for completion.
  • This project hence also resulted in a faster development time, budget and delivery.

Confidential

SAP HANA Architect

Environment: HANA, ECC 6.0, Oracle, SAP BI 4.0, Tableau

Responsibilities:

  • Project scope was to decrease the time involved at various levels of IT architecture from sales order generation, uploading and reporting as well as better accessibility of data for executive level.
  • International presence of organization meant challenges on data security, ownership as well as currency.
  • Sales data of more than 3 GB upload through flat files to the Oracle database on cloud.
  • More than 4 hours for the extraction process and later for consumption by 50 LOB's resulted in cramped decision making on product sales and pricing.
  • Price sensitivity was primary focus along with queries taking more than 7 minutes to be analyzed by LOB's and Executives on purchases by product lines, regions, countries and other key parameters.
  • Key issue also included inability to adapt quickly on pricing and web offers based on market dynamics.
  • Utilized HANA as a data mart approach for the project. The Data sources were SAP ECC, an In-House developed purchasing application and MS excel data which were replicated into datamarts.
  • Query times drastically improved resulting in better decision making to look into new business insights.
  • Data uploads to HANA in near real-time of 5 min duration, resulting in drop of 4 hr timeline.

Confidential 

SAP BW Architect and SAP HANA Consultant

Environment : ECC 6.0, DB2, Oracle, SAP BW 7.3, SAP BI 4.0, HANA 1.0

Responsibilities:

  • SAP HANA was used as a datamart scenario once the OR and COPA RDS were deployed.
  • Extensively worked with the HANA Studio involving modeler and Administration perspective.
  • Used Studio for Provisioning, Modeling and Administration.
  • Created various HANA views utilized for various, Reports and Interactive analysis with SAP BI 4.0 tools with data coming from Finance, Sales, Shipping and Procurement modules.
  • Monitored the HANA appliance for running services, users, trace logs, disk volume and load history.
  • User Management for user creation, roles and role hierarchy, assignment and authentication.
  • Troubleshooting and production support for HANA and BI reporting.

Confidential, Licoln, NE 

Sr. SAP BW Architect

Environment : ECC 6.0, Oracle, SAP BI 7.1, BOBJ, WebI, Xcelsius, Designer

Responsibilities:

  • Involved in the implementation of SAP BI/BOBJ project for building an Enterprise Wide Data Warehouse in the areas of Supply chain Management, Order Fulfillment, FI-GL, AP and AR.
  • Used various tools like - IDT, Data Services, Web Intelligence, Xcelsius and Explorer.
  • Loaded non-SAP data sources into BW using Data Services for data conversion and data migration
  • Created WebI Reports and Dashboards using Xcelsius.
  • Interacted with the VP and Business heads for gathering requirements on Dashboard designs.
  • Created corporate Xcelsius dashboards for the top management.

Confidential ; Houston, TX

BI and BW Applications Manager

Environment : ECC 6.0, SQL Server, SAP BI 7.0, Business Objects Tools, CRM, SCM

Responsibilities:

  • Rendering advice, educate and discuss with the President, executive and senior level business to identify and define business objectives related to high level BI strategies and solutions.
  • Managing the overall BI strategy and technology for SAP BI/BW related tools and technologies.
  • Managed Projects like SAP GTS (Global Trade Services) data integration into SAP BW.
  • Loading of budget data, interest and overheads of company though flat files and creating reports for actual v/s budgeted and analysis on the future trend.  
  • Created many operational reports catering to various users across 26 countries of Sales, Logistics and Finance departments and Vinmar customers.
  • Executive Dashboards to President, CEO and VP’s to see, evaluate and analyze the business and strategy.

Confidential ; Houston, TX.

SAP BI Applications Specialist

Environment : ECC 5.0, ECC 6.0, Oracle, NetWeaver 2004s BI 7.0, BW 3.5, SAP SCM

Roles & Responsibilities:

  • Lead a team of technical consultants for implementing the SAP BW solution.
  • Gathered requirements from functional users in Sales and Purchasing for cross-functional analysis.
  • Monitored the development of data model to satisfy the various functional requirements by implementing queries and cubes using business content.
  • Configured BW objects including generic data sources to extract data from R/3 systems.
  • Developed reports using BEX reporting features like variables, exception, Navigational attributes and conditions in SD and MM.
  • Created SAP BI reports which include Plan/Actual revenue comparison, Order and sales value by sales representatives and Vendor delivery efficiency.

Confidential ; Houston, TX.

Sr. SAP BW Lead Consultant

Environment : SAP ECC 6.0, Oracle, NetWeaver 2004s BI 7.0 & BW 3.5, BOBJ, SalesForce.com

Responsibilities:

  • Daily hands on support of production issues/activities involving system enhancements, defects, break-fix, requirements gathering and end user support.
  • Process Chain monitoring, design and maintenance.
  • Answer, prioritize and log the calls from project team members, systems administrators and end users.
  • Aid in the design of reports, forms, interfaces, and conversions.
  • Facilitate knowledge transfer to other project team members.
  • Ensure that business processes are effectively mapped in the software configuration.

Confidential ; Houston, TX.

BW & SEM-BPS Consultant

Environment : SAP R/3 - 4.7EE, BW 3.5

Responsibilities:

  • Created Basic cubes for actual data and Transactional cubes for forecasting and planning data.
  • Responsible for all types of data transformations using ABAP including currency and Unit conversions.
  • Create complex reports from SD, MM and FI/CO data using BEx Analyzer and Web Application Designer.
  • Developed planning folders to provide GUI planning interface to the end user.
  • Created web enabled planning applications in the form of BSP’s using Web Interface Builder.
  • Implemented Status and Tracking System to integrate planning system across various hierarchy levels.
  • Involved in setting Authorizations required for BPS planning users/Managers.

 Confidential . Santa Clara, CA.

BW Consultant

Environment : SAP R/3 4.7, SEM, CRM, BW 3.5

Responsibilities:

  • Actively involved in information gathering and designing of data models.
  • Developed NSC-OSCAR (NSC-Optimized Service Centre data for Analysis and Reporting)
  • Worked on various BW objects required for sales & service integration for quality reporting.
  • Responsible for daily Loading and monitoring of OSCAR data.
  • Worked with BEx Analyzer, Query Designer and WAD.
  • Uploaded master and transactional data from flat files into SAP BW.

We'd love your feedback!