Sap Bw|hana Consultant Resume
San Ramon, CA
SUMMARY:
- Have 14 plus years in SAP Data Warehouse Architect, Solutions, Delivery, Consulting, Managing, and executing multiple projects.
- Define project scope, goals and deliverables that support business goals in collaboration with senior management and stakeholders
- Discussed with Enterprise Architects on SAP HANA Installation and Operations on how many cores we need to use on the History of Data.
- Lead and implementing multiple HANA Native and HANA/BW projects and closely working with different business users, Analysts, strategists and solution Managers.
- Developed full scale project plans and associated communication documents, defined SAP System Landscape Architecture, worked on SAP Upgrade and Migrations.
- Hands on SAP HANA front end tools like HANA studio (Eclipse), HANA Modeling, SLT, UAT, Analytical Security Features.
- Expertise in creating HANA views including SAP BW on HANA including Composite providers, Open DSO Views, Advanced DSOs and building HANA calculation Views.
- Experience with data extraction from SAP/Non - SAP Source Systems using SLT, BODS, SDI and SDA.
- Worked on SDLC ASAP methodology, DMO for Upgradation and LSA, LSA++ Architecture for Modeling
- Interfacing with clients for business requirement gathering, conducting system analysis and finalizing functional/technical specifications.
- Designing, developing, testing, troubleshooting and debugging of the applications.
- Expertise in using SAP Business Objects Data Services(BODS) 4.1/4.0 (Designer, Repository Manager, Server Manager, Configuring / Controlling Job Server and Web Admin)
- Have good hands on experience in ETL and Data Cleansing applications using Informatica Power Center, Data services, and PL/SQL.
- Effective in communicating complex technical information to both top-level management and end-users. Flexible and resourceful, applying strong organizational, time-management and planning skills to deliver projects on time/budget, in pressure and aggressive timelines.
- Strong communication and interpersonal skills. Experienced effective team leader as well as team player.
TECHNICAL SKILLS:
ETL Tools: Data Stage, SAP BO DS, Oracle Warehouse Builder, Informatica, SSIS
OLAP/BI/Viz: BO Web i, Xcelsius, Cognos, Tableau, Power BI.
ERP: SAP ECC/EHP SD, MM, PP, QM, HR, FTM, DTS, OTC, PTP (P2P), CO PA.
DW/Planning: SAP BW 3.0C, 3.1C, 3.5, SAP BI 7.0, 7.3 & 7.4, BPS and BPC.
Databases: HANA IM DB,, SQL, DB2
Languages: SQL, PL/SQL.
Operating & Testing: UNIX, Windows, MS-DOS, Linux, QTP, ALM
EXPERIENCE:
Confidential, San Ramon, CA
SAP BW|HANA Consultant
Responsibilities:
- Technically Hands on, leadership, direction and guidance to design and develop a sustainable Geographical wide Business Intelligence reporting framework and solutions
- Assess and cultivate long-term strategic goals for data warehousing in conjunction with data users, department managers, clients, and other key stakeholders
- Worked closing with Confidential Business Pricing and Sales Team on Business requirement, created Functional Spec., Technical specifications and standard modeling documents for HANA
- Implemented the Technical design requirements for the business phase one requirements.
- Configure System Replication Server (SLT) and replicated the Meta data table into SAP HANA using Data Provisioning technique and updated hierarchy tables using data services.
- Design and Developed the Calculation views (Graphical & SQL script), analytic and attributes views.
- Worked on SQL scripts using CE functions and Procedures in calculation view.
- Developed SAP HANA information models such as Packages, Attribute Views, Analytic Views, and Calculation Views with graphical and script based methods, using SQL, SQL Script, and CE Functions.
- Developed analytical views to integrate different tables and Transport request created through Life Cycle Management and created user profile privileges/analytical privileges.
- Expertise in develop calculated attributes, calculated measures, restricted measures, calculated columns, filters, hierarchies, variables, input parameters to satisfy reporting requirements using SAP HANA
- HANA Analytics were used for Sales and Financial visualization of HANA components
- Developed and tested the following HANA Data Models: Attribute Views for master data, Analytic Views for Transaction Data and Calculation Views Graphical and SQL Script/procedures. Joins/Union used in various Attribute, Analytic and Calculation Views for LO report consumption with time dimensions, data provision is done through SLT and used SDA/SDI as virtual model.
Environment: SAP HANA, HANA Analytics, SAP SLT, SAP ECC, SAP BO and Non SAP.
Confidential, Montvale, NJ
SAP BW|HANA Consultant
Responsibilities:
- SAP BW-HANA blend scenario solutions for specific requirements where high volume of detailed data reporting is required.
- Design HANA Information Models such as Attribute Views, Analytical Views, Calculation Views and Column/Row based tables in HANA design studio and make them available in the BI system via virtual providers
- Perform SLT replication to migrate ECC tables to HANA and extracting live data from cloud systems using Smart Data Integration (SDI) and Smart Data Across (SDA) to combine both structured and unstructured data for reporting
- Restricted data access by using Analytic privileges (system privilege, object privilege, package privilege) and Creating Role by grouping analytical privileges
- Worked with Copy & Derived options while creation HANA objects
- Working with different type of joins: Inner Join, Left outer join, Right outer join, Referential join and Text Joins
- Created script based Calculated Views
- Created decision tables using Parameters, Conditions & Actions for what-if analysis
- Transporting the HANA Objects by using Developer mode and Delivery unit
- Developed Webi reports, extensively used Prompts, Variables, Drill down, Breaks, Sections, Conditions, input controls
- Worked on Business Objects and created Aggregation levels, Filters, Variables, Planning functions, Planning Sequences, input ready queries, workbooks, etc
- Written/Programed code to get Hierarchy structure data into table columnar format, which will help in break down reporting in SAP BO Web I.
- Worked on developing Visual Composer reports to Design studio with a different User Interface using different customized cascaded style sheets.
Environment: SAP HANA, SAP BO, Design Studio, Analysis for Office, BODS, SAP SD, PP, MM, SAP BPC.
Confidential, Auburn Hills, MI
SAP HANA Architect
Responsibilities:
- Design comprehensive BI solutions, translating complex requirements into an optimal BI design and data validation.
- Developed SAP HANA information models such as Packages, Attribute Views, Analytic Views, and Calculation Views with graphical and script based methods, using SQL, SQL Script, and CE Functions.
- Developed analytical views to integrate different tables.
- Expertise in develop calculated attributes, calculated measures, restricted measures, calculated columns, filters, hierarchies, variables, input parameters to satisfy reporting requirements using SAP HANA
- Design HANA Information Models such as Attribute Views, Analytical Views, Calculation Views and Column/Row based tables in HANA design studio and make them available in the BI system via virtual providers
- Apply advanced data modeling techniques, including currency conversion, variables and input parameters
- Perform SLT replication to migrate ECC tables to HANA and extracting live data from cloud systems using Smart Data Integration (SDI) and Smart Data Across (SDA) to combine both structured and unstructured data for reporting
- Couple of projects on Side car approach to build the Warehouse and Sales Models.
- SAP HANA security patches are published according to the general SAP security patch strategy in SAP Security
Environment: BODS, SAP ECC 6.0, HR, FIORI, HADOOP and SAP HANA 1.0.
Confidential, Jackson, MI
SAP BW|HANA Consultant
Responsibilities:
- Plan Business Analysis approach, stakeholder analysis, business activities, communication and
- Management process.
- Prioritizing, organizing on specific requirement (CCA, COPA, Open and Clear Items).
- Responsible for the deliverables of projects in scope assessment, risk assessment, mapping, business
- Cases, use cases, and business process documentation.
- Assist clients to draw business and insights from complex data sets.
- Close communication with business stakeholders on requirement of Projects
- Manage solutions scope & requirement, traceability and communication.
- Design and implement proof of concept solutions and create advanced BI visualizations
- Keep abreast of current trends related to BI/Analytics/Big Data technologies
- Apply structured data requirements analysis and data modeling techniques and methods as part of the Enterprise Performance Life Cycle