We provide IT Staff Augmentation Services!

Sap Erp/hana Architect/consultant Resume

Dallas, TX

SUMMARY

  • 12 years of experience in software Industry as a SAP BI/HANA Architect.
  • 7 years of experience in SAP HANA 1.0/2.0 and 3+ years of experience in SAP BO.
  • 7 years of architecting and building data systems working with teams as big as 80 and as small as 4 in onsite/offshore model.
  • SAP Certified Application Associate - SAP HANA 1.0
  • Strong and experienced team player, with excellent communication and interpersonal skills. Proven ability to work independently.
  • Able to learn new technologies, concepts and Business processes quickly, evaluate their applications, and apply them to business need when appropriate.
  • Involved in development and implementation of SAP BI. Worked extensively on various functionalities of BI. Assist in the solution architecture for a landscape that includes SAP S/4HANA, BI, BW, BPC, HANA, and Fiori.
  • Expertise in RRB (Resource Related Billing) scenarios and in DIP profile configuration with multiple industry sectors
  • Worked on SAP HANA implementation projects with both native HANA, SAP BW on HANA, BW/4HANA and S4 HANA.
  • Worked on Data Modeling, Data Provisioning, Reporting, Security and Authorization aspects of SAP HANA 1.0
  • Complete Migration of SAP Hana DEV, Test, Training, Production data from Microsoft on promises to MicrosoftCloudAZURE including building SAP Production system incloud, installing Host agents, Diagnostic agents, SQL Server, Did Log transfer, and Cut over activities in power Confidential and Visual Studio environments.
  • Experienced with SAP ERP data on On-Promise and Cloud Implementations.
  • Experience with cloud infrastructure providers (e.g. AWS, GCP, and Azure).
  • Exposure on SAP ARIBA and S/4 HANA Connectivity with Cloud Integration Gate way (CIG).
  • Participate and drive scoping and discovery sessions on customer SAP cloud initiatives.
  • Architect secure migration methods to move workloads from On-Premises to defined cloud providers.
  • Worked on installations of SAP HANA SDI configurations and SAP HANA cockpit environment.
  • Experience with Data Virtualization, Azure Data Lake, Data Factory, HDInsight and Azure Analytics.
  • Experience in SAP Business Objects Universe Design, Web Intelligence and Tableau report development. Knowledge on Big Data, Analytics and IoT technologies.
  • Experience working on HANA Enterprise - Modelling including Attribute Views, Analytical Views, Calculation Views, SQL scripting, CE functions, Analytical Privileges.
  • Experience with system setup, system refresh, client copies, TMS.
  • Excellent knowledge and experience on: HANA Optimized Info Cubes, HANA Optimized DSO's, Transient, Composite, Hybrid Providers, Publishing HANA Model in SAP BW, Import SAP NetWeaver BW Model to HANA, BW/4HANA.
  • Good exposure toABAPtools for S/4HANA - ADT for Eclipse, SAPcoreABAPData Dictionary and latest CDS views.
  • Exposure on S4 HANA deployment options and knowledge of new S/4HANA features.
  • Experience in migrating the Standard DSO and Info Cube to HANA Optimized DSO and InfoCubes.
  • Excellent issue resolution skills which are raised over BW on HANA migration.
  • Experience in Importing BW models (Info Cube, DSO) in HANA as Analytical view.
  • Good understanding and experience in providing security restrictions on models using Analytic Privileges and assigning to Authorization roles for different types of users in SAP HANA.
  • Experience in Data-Provisioning techniques using SLT (SAP Landscape Transformation) to perform real-time data replication into SAP HANA and near time data loading into HANA using SAP BODS.
  • Expertise on BW on HANA, HANA LIVE VDM, HANA LIVE Browser, SLT, Information Models.
  • Worked on all technical aspects of SAP BI and familiarity with right from SAP BI Administration Workbench.
  • Proficiency in analysis, development, implementation of Standard / Customized Info Cubes, DSO, BEx Analyzer, BEx Browser.
  • Extensive experience in creating/configuring Info Objects, Transformations, and Info cube, Communication Structure, DSO, DTP, Error handling, Info packages, Scheduling, Monitoring.
  • Worked extensively on Aggregates, Compression, Partitioning, Navigational Attributes to improve data load and query performance.
  • Worked extensively on Extraction (Flat File, Business Content, LO Cockpit and Generic Extractions. Experienced in Activation and Installation of Business Content.
  • Experience in creating Queries & Reports in BEx Analyzer, BEx Browser and Customized/Configured Queries using Calculated Key figures, Restricted Key Figure, Filter, Exceptions, Variables, Conditions and Structures.
  • Experience in creating web reports using WAD.
  • Experience in building Multi Providers as per query needs.
  • Knowledge on Process Chains, Performance Tuning, Enhancements, Open Hub Service.
  • Worked on SAP ERP green field implementations and designed SAP HANA solution architecture based on client needs. Solid understanding of HANA functional architecture/Infrastructure.
  • Strong experience in OLAP/OLTP Data Modeling using Entity Relationship, Multidimensional/Star Schema and Extended Star Schema models.
  • Development, testing, documentation, requirement analysis, End user documentation, Data extraction, Data modeling, Data loading, Reporting and Production Support.
  • I have worked in IBM Lab for SAP Solutions on SAP BW, SAP BO and SAP HANA as a core team member. During that period, I have supported them for CO-PA RDS solution for SAP HANA which is presented in SAP Teched 2012 Las Vegas as well.
  • Worked on Creating Attribute Views, Analytical Views, and Calculation Views (Graphical, Script) using HANA Studio.
  • Experience with SQL Script, PL/SQL, Stored Procedures, Function Calls, Designing tables, data loads and Core Data Services (CDS).Good exposure on XS Advanced features and capabilities.
  • Worked on LSA++ architecture of BI 7.4 on HANA, BW/4HANA and tested all the functionalities for BW on HANA migration using DMO.
  • Worked with LCM (Life Cycle Management Console) to Transport the objects in System Landscape (Dev, QA, and Prod).
  • Having knowledge on creation of WEBI, Explorer, Dash Boards and Excel Reports onHANAInformation Models. Created Universes using IDT and Reports using Xcelsius and WEBI onHANADATABASE (BO XI 4.0).
  • Having knowledge on Data Replications SLT and Business Objects Data Services.
  • Having knowledge on Data Replication methods ETL (Data Services), Trigger Based and Log-Based Replication.

TECHNICAL SKILLS

ERP Packages: SAP R/3 version 4.6C, 4.7 Enterprise.

Data Ware Housing: SAP BIW versions 3.0B, 3.1c, 3.5 and B.I 7.5, SaP S/4 1610

OLAP Tools: SAPBI/BO 4.0,HANASPS09/10/11, Webi 4.0

Operating Systems: WINDOWS 2000/2003/NT/XP

Data Bases: Oracle, DB2, Hadoop and HANA 2.0

Languages: ABAP/ 4, SAP HANA SQL Script

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

SAP ERP/HANA Architect/Consultant

Responsibilities:

  • Extensively involved in Project design, roadmap, detail designs and Development approaches.
  • Analyzed the requirements, by talking to the functional and end users of the reconciliation system and performed gap analysis.
  • Established the best modeling and recommended strategies and architecture for SAP HANA.
  • Built HANA information models (Attribute views, Analytical views, Calculation views, and Column/Row based tables) in HANA design studio for efficient data integration.
  • Setting-up, and knowledge of the Transport Management System (TMS) enabling changes throughout system environment.
  • Defined web-based data access by building consumption models in HANA XSJS (server-side JavaScript) exposing HANA artifacts to client applications.
  • Experience in working with BW4HANA with SAP and CDS Views and extractors and SAC reports.
  • Created and maintained Business Objects reports in Web Intelligence Info View and BI Launchpad.
  • Scheduled daily, weekly and monthly company turnover reports of Web Intelligence as per the business requirements.

Environment: SAP BI 7.4, SAP R/3 4.7, AWS and HANA 2.0

Confidential, San Jose, CA

SAP Native HANA Consultant

Responsibilities:

  • Leading and implementing multiple native HANA projects in Global Supply Chain domain while closely working with different business users, analysts, strategists and solution managers for Universal Order Visibility (UOV) initiative.
  • Implemented cloud\hosting strategy and migrated key business applications to cloud\hosted based.
  • Integrate SAP HCM to Success factor and then transfer data to HanaCloudthrough HanaCloudIntegrator (HCI).
  • Extensively involved in Project design, roadmap, detail designs and Development approaches.
  • Architecting and developing complex HANA-XS information models such as Analytic/Calculation Views (Graphical/Scripted), SQL procedures (.hdbprocedure) and CDS entities (.hdb/.hdbdd).
  • Integrating and consuming data from Hadoop in HANA for data archiving project using Smart data access (SDA) connectivity. Coordinating with DBA and implementing security.
  • Defined web-based data access by building consumption models in HANA XSJS (server-side JavaScript) exposing HANA artifacts to client applications.
  • Created reports using Web Intelligence tools with Business Objects Universe as the Data provider.
  • Extensively used Web Intelligence reporting functionalities such as Filters, Ranking, Breaks, Formulas and Alerts etc. Developed new reports using Business Objects functionalities like Queries, Cross Tab, and Master Detail etc.
  • Recommended best practices and consultative approach for implementing integration using the HanaCloudIntegration platform.
  • Created and maintained Business Objects reports in Web Intelligence Info View and BI Launchpad.
  • Performed source system/data analysis, data profiling, meta data management using Information Steward. Implemented the generic and specific profiling rules, perform rule binding, build scorecards to assess the data quality and provide the inputs to business for data cleansing.
  • Presenting demo’s by showcasing new HANA features and capabilities and how it can efficiently solve client’s current use cases. Coordinating with Informatica ETL team for data integration/data quality and advocating them for efficient data loading strategies.
  • Participating in peer design review sessions and also providing recommendations to the client for efficient HANA data modeling strategies

Environment: SAP HCP, SAP BI 7.4, SAP R/3 4.7 and HANA 2.0

Confidential, Silicon Valley, CA

SAP HANA Architect/Modeler

Responsibilities:

  • Worked with project business requirements and involved in preparation of client SOW and lead project delivery for green field implementations.
  • Managed the project processes of the S/4 HANA, SAP ERP (SD, MM, P2P, O2C, and Logistics), Solution Manager 7.2, BW/Analysis4Office/integration scenarios on PO/PI systems.
  • Mapped business requirements to the technical architecture design and information model in SAP HANA.
  • Involved in full life cycle implementation, which includes Analysis, Requirements gathering, Development, Testing, Reporting, Go-live and Post Go-live support.
  • Managed BODS & ABAP teams to build ETL jobs and load programs and led the migration of data of around 50+ objects across mock cutovers, dress rehearsals, and final cutovers.
  • Worked on multi system landscape architecture and integration aspects between heterogeneous system technologies in the areas of HANA Implementation, Modelling, Security & Authorization, Data Provisioning, SAP HANA Administration, reporting.
  • Conducted "as is" and "to be" workshops with business SMEs to gather requirements, performed Fit/Gap analysis for P2P/R2R objects - Vendor Master, Source List, finance, Open AP etc.
  • Performed source systems analysis, feasibility analysis of the functional requirements. Identified the risks in advance, get the impacted teams together to resolve them before they become issues.
  • Involved in creating Packages, Schemas, Tables and Information views like Attribute views, Analytic views, and Calculation views(SQL Script based and graphical based).
  • Implement HANA development best practices and develop performance optimized solutions.
  • Good exposure on various components of SAP HANA. Worked on SAP LM and CTS++.
  • Worked independently with minimal supervision and ensure timely deliverables.
  • Developed models in HANA studio and tested by replicating the data using SLT and BODS.
  • Worked on HANA stored procedures with parameters from BODS.
  • Developed Advanced Models using either by SQL Script or Calculation Engine (CE) functions or CE Operators.
  • Designed and DevelopedSAPHANAartifacts such as Attribute Views, Analytic Views and Calculation Views. Created Composite Calculation views that includes variables, input parameters and calculated columns.

Environment: SAP BI 7.4, SAP R/3 4.7, S4 HANA 1709 and HANA 2.0

Confidential, San Jose, CA

BI/HANA Consultant and SAP HANA Modeler.

Responsibilities:

  • Involved in creating Packages, Schemas, Tables and Information views like Attribute views, Analytic views, and Calculation views(Sql Script based and graphical based).
  • Tested BI reporting performance and data loading performance by reconciling the results in Oracle and HANA databases.
  • Good exposure on various components of SAP HANA.
  • Worked on latest features of SAP BI 7.4 and fixed various issues after BW- HANA Migration.
  • Worked on LSA++ architectures and reduction of staging layers. Designed LSA++ data flows with SPO’s.
  • Developed use cases in HANA side car and tested by replicating the data using SLT and BODS.
  • Worked on HANA stored procedures with parameters from BODS.
  • Designed and DevelopedSAPHANAartifacts such as Attribute Views, Analytic Views and Calculation Views.
  • Created Composite Calculation views that includes variables, input parameters and calculated columns.
  • Developed Advanced Models using either by SQL Script or Calculation Engine (CE) functions or CE Operators.

Environment: SAP BI 7.4, SAP R/3 4.7 and HANA 1.0, Tableau 8/9.0.

Confidential, Chicago, IL

BI/HANA Consultant and SAP HANA Modeler.

Responsibilities:

  • Tested all the BI existing functionalities are working fine in HANA similar to ORACLE database. This will ensure business continuity with planned DB migration.
  • Worked on In Memory optimization of cubes for all the functional areas.
  • Tested the benchmarking of all the cubes before and after DMO migration to HANA DB.
  • Involved in creating Packages, Schemas, Tables and Information views like Attribute views, Analytic views, and Calculation views(sql Script based and graphical based).
  • Tested BI reporting performance and data loading performance by reconciling the results in Oracle and HANA databases.
  • Good exposure on various components of SAP HANA.
  • Worked on latest features of SAP BI 7.4 and fixed various issues after BW- HANA Migration.
  • Worked on LSA++ architectures and reduction of staging layers. Designed LSA++ data flows with SPO’s.
  • Performed technical smoke tests while HANA DB migration.
  • Developed use cases in HANA side car and tested by replicating the data using SLT and BODS.
  • Worked on HANA stored procedures with parameters from BODS.
  • Designed and DevelopedSAPHANAartifacts such as Attribute Views, Analytic Views and Calculation Views.
  • Created Composite Calculation views that includes variables, input parameters and calculated columns.
  • Developed Advanced Models using either by SQL Script or Calculation Engine (CE) functions or CE Operators.

Environment: SAP BI 7.4, SAP R/3 4.7 and HANA 1.0

Confidential, Brooklyn, NY

BI/HANA Consultant and SAP HANA Modeler

Responsibilities:

  • Cross checked all the BI existing functionalities are working fine in HANA similar to ORACLE database. This will ensure business continuity with planned DB migration.
  • Implemented few functional use cases to show case the faster and flexible reporting results to the business process experts.
  • Tested BI reporting performance and data loading performance by reconciling the results in Oracle and HANA databases.
  • Used control-M tool and triggered end to end loads from source extraction to loading the reporting layer for cross checking the data loading performance and the behavior of loading and observed the change in DSO activation time.
  • Participated in LSA++ optimization workshops and designed CCA LSA++ data flow with SPO’s(8 logical partitions are trimmed into 3 logical partitions in LSA++)
  • Performed; technical smoke tests while HANA DB migration.
  • Developed COPA use case in HANA side car tested by replicating the data using SLT.
  • Worked on replicating data using BODS into HANA.
  • CreatedSAPHANAmodeling views such as Attribute Views, Analytic Views and Calculation Views.
  • Created complex information models using Graphical Approach and SQL Script Methods.
  • Created variables & Input Parameters, restricted and calculated measures including various aggregation types such as Min, Max, and Sum etc.
  • Create various privileges such as sql privileges, object privilege for the users inHANAStudio.
  • Experience in working with Content models, Attributes, Measures and Hierarchies inSAPHANA.
  • Provided guidance and advice toSAPCustomers, Pre-sales and Solution Architect resources on the development ofHANAsolutions

Environment: SAP BI 7.3, SAP R/3 4.7 and HANA 1.0

Hire Now