We provide IT Staff Augmentation Services!

Sap Hana Consultant, Sap Bw On Hana Consultant Resume

Marysville, OH

CAREER OBJECTIVE:

  • As a seasoned professional, proactive team player, highly motivated assiduous individual looking to offer skills, knowledge and expertise in the areas of SAP techno - functional areas including SAP HANA, SAP Could, SAP Analytics, SAP BW and related by providing excellent top notch business solutions to companies and clients looking to provide top of the line - real time solutions to their clients using new fields of technology in these areas.
  • Expert in SAP HANA and HANA Cloud Integration with awesome cross functional and interpersonal skills to understand the business, effective communication skills, highly resourceful, very disciplined, voracious reader and quick learner, I am always striving for newer opportunities to learn and apply new technologies, thereby assisting the organization to overcome any challenges and accomplish their goals.

PROFESSIONAL PROFILE:

  • Extensive knowledge with over 11 years of experience in diversified areas of Modelling and Implementation of SAP BW/BI .
  • Experienced on end-to-end implementation of SAP BW and SAP HANA data models using ASAP and Activate Methodology.
  • Expertise and experience in areas of SAP HANA Modelling including SAP Cloud, S/4 Hana, SAP UI5 and Fiori, SAP Lumira, SAP BO 4.1 Tools like UDT and IDT, Web-Intelligence, Crystal Reports, Dashboards, Live Office, SAP BO Explorer, and ETL tools like SAP BODS 4.1 and SLT for HANA.
  • Experience in SAP BW and SAP BEx tools such as BEx Analyzer, Query Designer, WAD, Report Designer and Broadcaster, and Information Broadcasting.
  • Effectively interact with Clients to understand the business processes across various SAP functional areas like SAP HR, CRM, SRM, PP etc. and execute in-depth understanding of business requirements thereby converting it to Blueprint.
  • Excellent communication, managerial and interpersonal skills, apart from Strong research, analytical, organizational and customer service skills. Aspiring and ardent individual, decision maker; well organized, resourceful , and ability to work well independently and as a team.
  • Enthusiastic and committed to professional excellence , Quick Learner, Flexible, Reliable, conscientious, stay abreast on SAP BW, HANA, BI tools and new technologies with SAP, OpenSAP courses etc.
  • Received SAP BW ( C TBW55 73 : SAP Certified Application Associate - Modeling and Data Management with SAP BW 7.3 & SAP BI 4.0 ).
  • Received SAP HANA ( C HANAIMP131 : SAP Certified Application Associate (Edition 2013) - SAP HANA ).
  • Several s from OpenSAP including SAP BW powered by SAP HANA, SAP Business Suite on SAP HANA, Rapid Deployment of SAP solutions, HANA Cloud apps and more.

TECHNICAL SKILLS:

Applications: SAP HANA, SAP BW, SAP BO, SAP BODS, SAP ECC, SAP Hana Cloud, S/4 HANA 1611, Hadoop.

OS and Databases: Oracle, MS SQL, SAP HANA, HADOOP.

Modules: SAP HANA, SAP BW 7.4, SAP FICO, HR, MM, SAP PM, PP.

Methodologies: ASAP, SAP ACTIVATE, AGILE, SCRUM

Test tools: Zendesk AND Jira.

New Technologies: SAP HANA Cloud Integration, S/4 Hana 1611, SAP Lumira, SAP Fiori and UI5HANA Vora, RoamBI

Others: JAVA, Eclipse, Fortran 77, ABAP, JS, MS Office- Excel, Access, Publisher, etc.

SAP HANA EXPERTISE:

  • Technical expertise with particular emphasis on SAP HANA In premise and On-cloud - Design, Development, Modelling and Implementation, including Gathering Business Requirements, Developing data models and front-end reports in the SAP HANA and SAP BW.
  • Involved in full implementations on SAP HANA. Proficient in all phases of SAP HANA Modelling and Implementation, Data Extraction using BODS 4.1, SLT and DXC, SAP HANA Information models such as Packages, Attribute Views, Analytic views and Calculation views with graphical and script based models, also SQL and CE Functions.
  • Expertise in SAP HANA Information Models designing Attribute Views based on Master Data Tables in the SAP ECC, Analytic Views based on Info cube and Graphical Calculation Views by including the data analytic views using Unions, Projections and Joins based on the business logic. Replicate Master data and Transaction Data Tables Using BODS 4.1 and SLT from SAP source systems to HANA
  • Well versed with SAP HANA Studio, Modeler and Administrative perspectives and Navigation views. Skilled in loading the data into SAP HANA Database from SAP ECC, Flat files and other Databases.
  • Experience with designing SAP BW data Flows (DSOs, Transformation, and DTPs) on the BW on HANA database Scenarios and importing them to HANA studio.
  • Designed the Business Data Flows with SAP BW LSA++ Architecture using Composite Providers, Virtual Providers, Info Cubes, DSOs, and Data Sources for the SAP BW on HANA DB Scenarios.
  • Involved in importing the BW models from SAP BW system (using HANA DB) to the HANA Studio, also involved in migration of SAP BW cubes and DSO’s to In-Memory Cubes and DSOs.
  • Import and export the HANA Models between systems using Delivery Units.
  • Technical expertise and experience on SAP HANA Administration activities like Monitoring SAP HANA systems and services with system monitor, performance tuning, adding systems, setting modeler ps, import/export delivery units etc. Having good hands on skills in SAP HANA Security activities like User Management, Assigning Roles to users like assigning Analytic Privileges to Views in HANA and Managing Analytical Privileges to enable course grained and fine grained access control.
  • Configured and Consumed SAP HANA Models in BI Clients such as SAP Business Objects Tools like WebIntelligence, Crystal Reports, BO Live Office, SAP Lumira, SAP Design Studio and MS Excel. Created Web Intelligence Report and Analysis for OLAP reports on the BEx Queries using BICS connectivity. Created the Universe for the SYS BIC column views of SAP HANA and developed the Web Intelligence Reports on the Universes.
  • Experience on BODS 4.1, and integration using BODS as ETL, CMC, as well as SQLScript using CE Functions in SAP HANA. Knowledge on HANA SQL Script, Stored Procedures and Decision Trees etc.
  • Created POC using knowledge and technical expertise with SAP Predictive Analysis and other SAP HANA libraries, including HANA Cloud Integration, SAP Fiori Application with SAP UI5 and S/4 HANA.
  • Worked on SAP Business Data Warehouse Design, Gathering and Analyzing, Business Requirements, Development, Modelling and Implementation, Developing data models, data extraction, data loading, testing and end user documentation in the SAP Business Warehouse Environment. Implemented full life cycle implementations, Production Support and Upgrade Projects for different modules in SAP BI/BW.
  • Create documentation for Data Mapping, Business Rules, Data-flow diagrams, Report Specification and follow SAP Business Warehouse best practices to support business requirements.
  • Proficient in all phases of BW application Modelling and development, Data Extraction, InfoCube Design and Reporting with Business Explorer and Business Objects Tools.
  • Design, develop and test, Data Models, Data Mart InfoCubes-Transformations, Aggregates and Update Rules where needed.
  • Worked on the ETL process by Designing, creating and maintaining ODS Objects, Info Cubes and Multi-Providers per the Business requirements. Installation, activation and Enhancement of Standard Business Content objects for SD, MM, FI, PP, PM, SRM modules.
  • Extensively worked with R/3 and Flat File loading for Transactional Data, Master Data and Attributes Experienced in extracting data from SAP R/3 systems using different extract structures like LIS, LO Cockpit, Generic extractors, using Delta update mechanisms for uploading the data to BW from R/3 in specific intervals.
  • Worked on Info Cubes, Multi Providers, Data Store Object (DSO), Info packages, Transformations and DTP. Worked on extracting master data and transactional data from flat files and SAP R/3.
  • Enhanced Data Sources as per the Business requirements. Also created Field level routines, Start routines and End routines and routines at info package level where required.
  • Set up and scheduled Job Scheduling and process chains, creating custom Data Sources to extract data from OLTP systems to BW through Persistent Staging Area (PSA) and Monitoring and Error Handling in PSA. Created, Scheduled and Monitored Process Chains for daily, weekly and monthly loads. Transportation of BW data flow from Development to QA and Production systems.
  • Comprehensive processing of data extraction from SAP R/3 and Performance Tuning of Queries by maintaining Aggregates, Compression, Partition, Indexing of Info Cubes and use of Statistics.
  • Excellent BW reporting skills- BEx WAD, BEx Analyzer and sound knowledge on Information Broadcasting Tools. Experience with Bex Query Design and BEx Analyzer in building Queries and saving in Workbooks (Excel work sheets) and created Custom Queries using Conditions, Query Filters, Exceptions, Variables, Structures, Calculated Key Figures, Restricted Key Figures and Hierarchies and formatting in RRI. Worked on BEx variables Customer Exit and Replacement path. Used BICS connectivity to call the BEx Queries and develop report in Web Intelligence
  • Experience with Business Objects Reporting Tools including Information Design Tool, Universe Design Tool, Web Intelligence, Crystal Reports, Dashboards and BO Analysis.

PROFESSIONAL EXPERIENCE:

Confidential, Marysville, OH

SAP HANA Consultant, SAP BW on HANA Consultant

Environment: SAP HANA 1.0, SAP BI 7.3, SAP EHP, SAP BO 4.1, IDT

Responsibilities:

  • Documented the Functional and Technical Specifications for SAP HANA and SAP BW on HANA DB requirement based on the business flow for MM ( using MARA, LFA1, etc), FI (DS - using 0FI AP *, 0FI AR *, 0FI GL *), SD( KNA1), CO (0CO PC *) modules in the existing Legacy systems.
  • Implemented using ASAP Methodology - included -- Phase 1 Project Preparation, Phase 2 Business Blueprint, Phase 3 Realization, Phase 4 Final Preparation Phase 5 Go-Live and support.
  • Created Attribute views, Analytic views, and calculation views as a part of HANA Modelling using HANA Studio. Implemented the business models Attributes views, Analytic views using SAP Tables FI, MM, SD, and CO.
  • Loaded data using Flat files to the column and Row - based tables created in SAP HANA.
  • Created the Attribute views in HANA Modeler using the Master data tables in SAP ECC 6 source system.
  • Created the Analytic Views using Transaction tables in Data foundation and joined the Attribute views in the logical join section.
  • Created restricted columns, calculated columns, Input parameters and variables according to the technical specifications.
  • Triggered the Replication of the Master data tables and Transaction data tables from SAP ECC to SAP HANA through Data Provisioning in HANA Studio. Used BODS and SLT as ETL tools where necessary.
  • Created the Graphical Calculation Views using the Analytic views, transaction tables. Used Unions, projections and aggregation in the Graphical Calculation Views to union, filter and aggregate columns of the calculation views.
  • Used SQL and CE-Functions to develop calculation views for complex scenarios. Imported and exported the business models from Development - quality and Development - production systems using Delivery units and Developer mode options.
  • Reconciled the data with the source system and HANA using data preview and SQL statements using where, group by, having, order by clauses.
  • Used the various HANA studio Functions like Conversion, String, Mathematical, etc and Date to suit the business requirement using calculated columns.
  • Called the Calculation and analytic views to BO 4 IDT Tool. Created the Data foundation, Business layer and published the universe to WebI. Developed the WebI Reports Using the universes built on HANA Calculation and Analytic views. Created Visualization Reports using SAP BO Explorer tool.

Confidential, Irvine, CA

SAP Developer - SAP HANA/BW

Environment: SAP HANA 1.0 SP11, SAP BW 7.4, SAP ECC 6.0, SAP BODS 4.1

Responsibilities:

  • Using Activate Methodology - Various phases including Prepare, Explore, Realize and Deploy - In the Prepare and Explore Phases- Created the Business Blueprint in consultation with the Business process owners and end users undertaking workshops with superusers.
  • Documented the Functional and Technical Specifications for SAP HANA and SAP BW on HANA DB requirement based on the business flow for MM, HR, FI, CO, SD modules in the existing Legacy systems.
  • Co-ordinated projects using Activate Methodology using MS Project and solution manager including outgoing support, optimization and e-.
  • Resolved issues on issue log and centralized repository of project documents.
  • Conducted workshop for the blueprint and end-user approvals.
  • Established project documents and cut-over plan for Go Live and Support. Troubleshooting and support on post-go live and re SuperUsers.
  • Created Attribute views, Analytic views, and calculation views as a part of SAP HANA Modelling.using HANA Studio. Implemented the business models using SAP EHP Tables .
  • Loaded data using Flat files to the column and Row - based tables created in SAP HANA. Extracted data using SLT and also used BODS as ETL in certain scenarios.
  • Worked on designing SAP BW data Flows (DSOs, Transformation, and DTPs) in the BW (on HANA database) Scenarios and imported the DSOs, Info cubes to the HANA studio tool.
  • Extracted data using LO-Cockpit, for Logistics extractors for the BW on HANA DB business flows.
  • Used various T-codes including, but not limited to RSA1, RSA3, RSA5, RSA6, RSA7, BSORBCT, LBWE, LSMW, SE11, SM37, SPRO, LISTCUBE, LISTSchema.
  • Various Datasources used including 2LIS 03 BF, 2LIS 03 BX, 2LIS 03 UM ( for inventory management), 2LIS 02 SCL, 2LIS 02 ITM, 2LIS 02 HDR ( for purchasing ), 2LIS 11 *(for sales), 2LIS 13 * ( for billing ) etc.
  • SAP Tables used like KNA1, MARA, LFA1, MAKT, MARC, VBAK, VBAP, MSEG, BSEG, etc.
  • Created SAP BW Business flows using Transient Providers - Analytic Indexes, Info Cubes, DSOs, and Virtual Info Providers (RSDD HM PUBLISH). Migrated SAP BW Info Cubes and DSOs to In-Memory based Info cubes and DSOs in the new SAP BW 7.4 Environment.
  • Created restricted columns, calculated columns, Input parameters and variables according to the technical specifications. Used the various HANA studio Functions like Conversion, String, Mathematical, etc to suit the business requirements in Calculated Columns and Calculated Columns.
  • Created the Graphical Calculation Views using the Analytic views, transaction tables. Used Unions, projections and aggregation in the Graphical Calculation Views to union, filter and aggregate columns of the calculation views.
  • Imported and exported the business models from Development - quality and Development - production systems using Delivery units and Developer mode options.
  • Created the Composite providers in SAP BW 7.4 using the Transient Providers - Analytic Indexes, Info Cubes, and Virtual Info Providers according to the technical business requirements.
  • Implemented Start, Field, and End Routines to filter and transform the records in the data loading process.
  • Reconciled the data with the existing BW Reports with the new HANA Models.
  • Developed the BEx Reports using BEx Query Designer for the BW data targets and called the BEx reports to WebI using BICS Connection.
  • Created and scheduled the process chains for Finance, Controlling, Sales and Distribution, Plant Maintenance and Inventory Scenarios.
  • Transported the BW objects from the SAP BW Development to Quality, loaded the data for the business flows and reconciled the data with SAP EHP (ECC) as a part of the Unit Testing.
  • Transport and Imported the Data flows from BW Development system to Production.
  • Called the Calculation and analytic views to BO 4 IDT Tool. Created the Data foundation, Business layer and published the universe. Developed the WebI Reports using the universes built on HANA views. Created Visualization Reports using SAP BO Explorer tool, SAP LUMIRA and others.
  • Created POC for SAP HANA Cloud, established connectivity, exposed to Cloud using Eclipse and SAP HANA Cloud Platform. Also used S/4 Hana to establish models post data migration project.

Confidential, San Francisco, CA

SAP Developer

Environment: SAP HANA 1.0 SP05, SAP BW 7.3, SAP ECC, SAP BO WebI

Responsibilities:

  • Involved in complete lifecycle implementation of the project from gathering user requirements, analyse business process, gather requirements, preparation of technical specifications documents, designing and developing reports, Integration testing, unit testing (UAT) to Go live production support.
  • Developed the Attribute Views based on Master Data Tables in the SAP ECC. Developed the Analytic Views based on Transaction Data Tables in the SAP ECC for SD, FI, and CRM modules.
  • Created Row or Column based Custom Tables based on the structures in SAP ECC and populated the data using SQL statements and Flat Files import function in HANA Studio.
  • Created the Analytic Views based on Info cube models in SAP BW/BI system. Created the Graphical Calculation Views by including the Analytic views using Unions, Projections and Joins based on the business logic.
  • Created the necessary Calculated Attributes, Restricted Measures, Calculated Measures and Input Parameters using the HANA studio tool. Used the HANA studio Functions like Conversion, String, Mathematical and Date to suit the business requirements in Calculated Attributes and Calculated Measures.
  • Involved in importing the BW models from SAP BW system (using HANA DB) to the HANA Studio as Analytic views and Calculation Views.
  • Imported and exported the HANA Models from development to Production system using Delivery Units. Reconciled the data with the existing BW Reports with the new HANA Models.
  • Called Various Views to BO 4.0 IDT Tool to create Universes. Created the Data foundation, Business layer and published the universe to WebI. Created Reports Using the BO WebI tool on the universes.
  • Created the Visualization Reports in Explorer 4.0 based on the Analytic Views, Calculation views and Universes using measures and Facets on the Information Spaces. Created Dashboard reports using Design Studio and Dashboards.

Confidential, Fresno, CA

SAP BW/BI Consultant

Environment: SAP BW 7.0, BEx Designer, BEx Analyzer, SAP ECC 6.0.

Responsibilities:

  • Involved in Discussions with the client regarding Business Requirements, Information validation and blueprint setup.
  • Identified and installed the BI content objects related to Billing, Inventory and Budget.
  • Extracted data from ECC using the Logistics procedure for Sales and Inventory. Extracted historical MSSQL data for Sales and Budget using the UD Connect.
  • Involved in writing Start Routines, Field Routines and end routines.
  • Extensively worked on SD info cube 0SD C03 and data sources 2LIS 13 VDHDR, 2LIS 13 VDITM, 2LIS 13 VCITM and financial data providers, multi provider’s 0FIAP M40 data sources 0FI GL 40 according business needs in SAP BI.
  • Enhanced the Billing and Inventory data Sources according to requirements.
  • Developed Queries using RKFs, CKFs, Exceptions, Variables, Conditions, Cell editor, Replacement path, etc. Developed ABAP Code for Year-to-Date and Period-to-Date in CMOD.
  • Transported all the ECC and BI Objects from Development to Quality and Production Systems.
  • Created, Scheduled and Monitored Process Chains for the above flows.
  • Involved in UAT with the Business Users in BI Quality system.
  • Re-designed the Objects and made changes to the Flows and Reports to meet Requirements after UAT.
  • Created the BO WebI reports by calling the BEx Queries using BICS connectivity. Created the Tab - wise reports for the Sales and Billing in WebI..

Confidential, MN

SAP BOBJ Developer

Environment: SAP BI 7.0, BI Launch pad, SAP ECC 6.0, SAP NETWEAVER PORTAL, SAP Business Objects 3.1/4.0, IDT, Universe Designer, Webi, Dash boards/Xcelsius, Crystal Reports, Life Cycle Manager, CMC, CMS.

Responsibilities:

  • Involved in participating Project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
  • Worked on Gathering, analyzing, documenting business requirements, functional requirements and data specifications about the financial system for Business Objects Universes and Reports.
  • Helped in preparing the technical documents and updated with recent changes and test cases.
  • Extensively used Central Management Console (CMC) in BO 4.0 for creating users, setting up security, scheduling reports, assigning privileges for development and Test environment.
  • Worked with team to set up AD authentication & configuring the Single Sign On (SSO) and production support team in resolving and trouble-shooting issues.
  • Involved in creation of universe using BO 4.0 Information Designer Tool (IDT).
  • Extensively Worked on BICS connection with Xcelsius 2008/Dashboard design 4.0 and created innovative Dashboards for the existing Summary level Reports using QAAWS.
  • Involved in working with Xcelsius Web-connectivity components such as Web-Service Component, Live Office Connector etc. to establish live connectivity to the dashboards with the database tables, views and BO universes.
  • Depending on the user requirements provided Different types of Visualizations in Dashboards using charts like Bar, Pie, Line etc. Developed critical reports like drill down, Slice and Dice, master/detail for analysis.
  • Published Dashboards to the users and involved in sharing Knowledge with Team members
  • Conducted sessions to the end users in working with the Business Objects user module, Dashboards and provided technical expertise.
  • Generated Reports using Universe as the main Data provider and also personal data files provided by users.

Confidential, Houston, TX

SAP BI/BO Consultant

Environment: SAP Netweaver 04s (BI 7.0), ECC 6.0, CO, SD, BEx Analyzer, BO XI 3.1.

Responsibilities:

  • Involved in complete lifecycle implementation of the project from gathering user requirements, preparation of technical specifications documents, designing and developing reports, Integration testing, unit testing (UAT) to Go live production support.
  • Interacted with the Business Users to analyze the business process and gathered the requirements.
  • Designed functional and Technical specifications for Implementation and Development of BO XI 3.1 over SAP BI.
  • Involved in development, integration testing, UAT to Go live production support.
  • Extensively worked on BEx reporting and workbooks, including RRI, cell definitions, variable offsets, exemptions, conditions, RKF’s and CKF’s.
  • Defined BO Classes, Objects, in the Universe, defined Cardinalities, Contexts, Joins and Aliases and resolved loops in Universes using Table aliases and contexts.
  • Created Universes over BEx queries and Infocubes of SAP BI using Universe Designer
  • Extensively worked on CMC and INFOVIEW to create Web Intelligence Reports.
  • Created WebI reports with Complex Calculations to get Alerts for Xcelsius Dashboards.
  • Checked the Universes for Integrity and exported to the Repository to make resources available to the users and groups and Created Adhoc Reports by accessing the Universe.
  • Successfully implemented transports of BOBJ in SAP BI environment.
  • Created (Master/Detail, Cross tab, Chart templates) reports using Crystal Reports.
  • Extensively worked on SAP Life Cycle Manager (LCM), transported objects from one environment to another including security rights using this brand new tool.

Confidential, Rubbermaid, GA

SAP BI/BO Consultant

Environment: BW 3.5, SAP ECC5.0, FI, SD, MM, SRM, APO, and Data Stage

Responsibilities:

  • Involved in the knowledge transfer sessions from business users/application owners for the project.
  • Understanding the Business process, Business requirements and landscape of BW system; involved in data model design and documentation.
  • Activated the business content for FI AR & GL, SD Sales and Billing & Product Costing.
  • Worked on custom extractors as well as business content extractors for both master data and transaction data. Modified data sources and Info sources to add new characteristics.
  • Worked on Sales document Header, Item, and Schedule line items data sources and ODS objects.
  • Developed ODS object to load transaction data from Info Source and defined update rules.
  • Created various Info Cubes (Billing Cube, Delivery Cube, and Sales overview cube), assigned dimensions to the characteristics and activated Update rules for the Info Cubes.
  • Created and Scheduled Info Packages for Delta Initialization (Full Load + Selection Conditions) and Delta data loading in to Info Cubes Via PSA, ODS objects.
  • Created process chains, variants to automate the manual loads. Extensively worked on service desk tickets, development and production support.
  • Extensively worked on BEx reporting, Created restricted key figures and formulas in the reports.
  • Monitoring daily, weekly and monthly loads and sending the load status reports to business users
  • Involved in Delta issues, process chain failures and table space issues.

Hire Now