We provide IT Staff Augmentation Services!

Sap Bw / Hana Consultant Resume

Eden Prairie, MN

PROFESSIONAL SUMMARY:

  • Over 10 years of working experience in IT role with SAP BW HANA/BI/BW full life cycle implementation with SD, MM, PP, FI/CO, HR and CRM modules.
  • Experience with multiple full life - cycle implementations in SAP BI/BW, Business Objects adopting ASAP Methodologies which involves Requirement Workshops, Gap analysis, Business Blue-Printing, Realization, Data extraction, Data modeling, Data loading, Production Support, Testing, Documentation, Requirement analysis, End user documentation, Reporting and Go-Live Check.
  • Worked on Front End , BEx (Business Explorer) Analyzer, BEx Broad Casting BEx Query Designer Queries, Workbooks and Web Reporting (WAD).
  • Worked on Generic extraction to pull the required data from R/3 to BW system.
  • Experience in Data-Modeling, Delta Extraction, Generic Delta Extraction, Data Loading Scheduling .
  • Designed documentation standards for Technical and Functional Specs and test plans for UAT, Integration testing.
  • Worked on Schemas/Packages, Tables, Calculation Views and defining Joins Attributes and Measures.
  • Worked extensively on Data Modeling design like creating Info Objects, Info Cubes, DSO, Advanced DSO, Composite Provider, Multi Providers, Info Sources, Info set, time dependent master data and in ETL (Extraction, transformation and loading) activities like Extraction from Source system, Transformation rules, Data Transfer Process (DTP), Open Hub service etc.
  • Worked on Schemas/Packages, Tables, Calculation Views and defining Joins Attributes and Measures.
  • Experience and knowledge in the Data Warehousing using Data Extraction, Data Transformation and Data Loading (ETL).
  • I have worked on Support patch upgrade and DR (Disaster Recovery) activities.
  • Worked in Performance Tuning, BW Statistics, Aggregates, Process chains, Testing, Go-Live, Production Support, End-user training, Documentation. Rich experience in Design and Development of BW Reports, BEx Analyzer.
  • Applied and implemented ASAP, Waterfall and Agile methodologies.
  • Expertise in business warehouse components Info Objects, Standard and Custom Info Cubes, DSO's, Info packages, DTP's and Transformations.
  • Expertise in Data-Modeling Multi providers, Info cubes, DSO, Remote Cubes, Master Data, Process Chains, Extraction LO Cockpit, non-SAP, Flat files Generic Extractors using FI-CO, MM, AP, AR, GL.
  • Strong experiences in installing the Standard Business Content objects and enhance them into custom objects based on the business requirements.
  • Worked on BW support project activities data loading monitoring and troubleshooting the failures.
  • Experience in system maintenance tasks Delta queue cleaning, Setup table deletion validation.
  • Expertise in scheduling and monitoring daily, weekly and monthly loads for master data and transaction data.
  • Extensively used Data Services Management Console to schedule and execute jobs, manage repositories and perform metadata reporting.
  • Good knowledge with SAP BW HANA.
  • Expertise in SAP BW Architecture including Extractors, Data Sources, Info Objects, Info sources, ODS Objects, Info Cubes, Info Packages, and Hierarchies.
  • Data modelling (Dimensional & Relational) concepts including Star-schema modelling, Snowflakes modelling, fact and dimension tables.
  • Good Knowledge in Performing Data Modeling in HANA Studio by Developing Analytical views, Attribute views for the Transaction and Master Data respectively and Created Calculation Views using Attribute views, Analytic views etc.

TECHNICAL SKILLS:

ERP: SAP BW HANA 7.3/7.4/7.5, SAP BI 7.0, BW 3.5, 3.0 and SAP ECC 6.0/5.0 .

Reporting Tools: BEx Analyzer, Query Designer, Business Objects 4.0, Web based Reports, WEBI, and Lumira

Data Modelling: Dimensional Data Modelling, Star Schema Modelling and Snow-Flake Modelling, FACT and Dimension Tables, Physical and Logical Data Modelling.

Operating Systems:: UNIX, Linux, AIX, Solaris, MS-Dos, Windows NT 4.0/2000/2003/2008 r2/XP/Vista/7

Databases:: Oracle, HANA, MS SQL Server 2008 R2/2005

PROFESSIONAL EXPERIENCE:

Confidential, Eden Prairie, MN

SAP BW / HANA Consultant

Roles & Responsibilities

  • Analyzed the User Requirements and created Functional and Technical Specifications.
  • Working on the SAP HANA production issues, HANA performance Optimization and experienced in analyzing the SAP HANA SQL procedures.
  • Reporting: Integration of SAP HANA models with SAP Business Objects 4.0 tools - WEBI
  • Architect the Design for development of SAP BW Application as per User Requirements starting from extracting the data from different SAP ECC and Non-SAP Applications.
  • Working on Schemas/Packages, Tables, Calculation Views and defining Joins, Attributes and Measures.
  • Interact with business to gather requirements, prioritize work, develop enhancements to the existing system, and perform change management/training for BO Reporting and applications.
  • Worked extensively on Data Modeling design like creating Info Objects, Info Cubes, DSO, Advanced DSO,
  • Composite Provider, Multi Providers, Info Sources, Info set, time dependent master data and also in ETL (Extraction, transformation and loading) activities like Extraction from Source system, Transformation rules, Data Transfer Process (DTP),Open Hub service etc. Also involved new features of SAP BI security like Analysis authorization.
  • Performed SAP Data Migration by using Business Objects Data Services as the ETL tool
  • Extensively used Data Services Management Console to schedule and execute jobs, manage repositories and perform metadata reporting.
  • Created the Universe using Information Designer Tool on HANA Calculation Views and Generated the WEBI Reports
  • Responsible for developing BI data models and designs, configuring custom and delivered BW Content, analyzing BW reporting requirements, developing detailed reporting specifications.
  • To activate Business Content Objects (Data Sources, Info Objects, Info cubes, and DSOs etc.) and developed customized objects as per the requirement
  • Created Complex Expert, Start, End and Field level routines in transformations as per the requirement.
  • Developed Service Backlog Data Model to get Open Sales Orders, Open Deliveries and Open Billing data.
  • Developed and Enhanced the Billing Document Item using Customer Exit, Contract and Project Data and extracted the data from SAP ECC to SAP BW to generate Service Reporting.
  • Build Bex queries using Restricted Key Figures, Calculated Key Figures, Exceptions, Conditions, Variables and Filters.
  • Performed unit testing on the complete data flow of the model developed from source system through BW, UAT (user acceptance testing) and data validation testing and prepared documentation. Planned the cut over activities before go live and performed the downtime activities.
  • Developed Service Order, Notification and Warranty Models which includes Extraction from SAP ECC, Back End Modeling and Front-end Reporting.
  • Developed Real Time Info providers, Aggregation levels, Planning functions, Planning sequences, input ready queries using BEx Query designer.
  • Created Dashboards for Project Systems Data for every project linking to its Basic and Activity Data.

Technical Environment: SAP BW HANA 7.4/7.5, SAP BI 7.0, SAP BO 4.0 and SAP ECC 6.0., Business Explorer, Business Objects, Utility Server.

Confidential, San Francisco, CA

SAP BW Hana Consultant

Roles & Responsibilities

  • Worked on Performance tuning of the calculation views by analyzing the execution plan of the calculation view.
  • Developed Service Labor Utilization End to End Model till Reporting.
  • Enhanced Goods Movements Data source and wrote customer exit (CMOD) to fill the new fields.
  • Developed Project Systems Data Model with Project Basic and Activity Data having Project, WBS, Network and Activity level Details.
  • Create printable reports for actual verses plan data using Crystal Reports for Production, Sales and Revenue.
  • Integrated Microsoft Office to HANA reporting build scale out HANA design for growth and performance boost and disaster recovery.
  • Worked on extracting data from non-SAP sources using SDA and creating calculation views on top of the third-party source system tables
  • HANA information model design and build which includes Package, Attribute View, Analytic View, Calculation View and Schemas.
  • Design SAP HANA data model information Views for report consumption with time dimensions.
  • Develop SQL scripts and functions for complex reusable scenarios in HANA.
  • Worked in mixed modeling by converting existing multi providers to composite info providers and creating calculation views in Native HANA
  • Enhanced the existing data sources and the flow till multi provider before converting the multi providers to composite info providers.
  • Worked on creating Table functions, stored procedures using SQL Script.

Technical Environment: SAP BW HANA 7.4, SAP BI 7.0, SAP BO 4.0 and SAP ECC 6.0., Business Explorer, Business Objects, Utility Server, Lumira

Confidential

SAP BI Consultant

Roles & Responsibilities

  • Good experience in monitoring the data transfers from Source Systems into BW with Full update and Delta mechanisms for Master and Transaction data.
  • Worked in Performance Tuning, BW Statistics, Aggregates, Process chains, Testing, Go-Live, Production Support, End-user training, Documentation.
  • Experience in Data-Modeling, Delta Extraction, Generic Delta Extraction, Data Loading Scheduling.
  • Designed documentation standards for Technical and Functional Specs and test plans for UAT, Integration testing.
  • Worked on Generic extraction to pull the required data from R/3 to BW system.
  • Worked on BW Accelerator for critical info providers to improve the reporting performance.
  • Rich experience in Design and Development of BW Reports, BEx Analyzer.
  • Worked on Utility server to download the files by using the Transaction code AL11.
  • Good experience in Post Refresh and Regression test activities
  • Responsible for requirement gathering and analysis of the business requirement that could be satisfied with SAP business content and created the necessary objects required.
  • Actively worked in House Keeping Activities to improve the system performance.
  • Preparing the Procedures Document for the Adhoc loads and Load failures and sharing with team for the future reference.
  • Used Filtering, Conditions, Variables, and Navigational Attributes to develop the flexible reports for the end user.
  • I have worked on Decommission the unnecessary loads from BW system to get more space availability.
  • We used to extract the data from ETL Informatica system to SAP BI system for the reporting.
  • Worked on Critical tickets and Enhancements effectively.
  • I have worked on Support patch upgrade and DR (Disaster Recovery) activities.
  • Finding the root cause for the errors of the chains if they have not started in time.
  • Supporting the team members if any critical issues/ load monitoring.
  • Maintaining work history for all the tickets until it is closed.

Technical Environment: SAP BI 7.0, SAP R/3 ECC 6.0, BI Accelerator, Flat files, Utility server, ETL Informatica

Confidential

SAP BI Consultant (SAP BI 7.0 End to End Implementation)

Roles & Responsibilities

  • Worked in complete life cycle Implementation of SAP BI that includes Data Extraction, Data Modeling and Reporting
  • Experienced in requirement gathering, gap analysis and developed functional specifications, technical specifications and blueprint. Interacted with business users for the requirements of management reports & dashboards.
  • Involved in Finding the requirement and Preparing the Business Blue Print (BBP).
  • Installed the Business content ODS/Cubes for the SD, FI CO, MM, HR and QM applications.
  • Worked in Performance Tuning, BW Statistics, Aggregates, Process chains, Testing, Go-Live, Production Support, End-user training, Documentation.
  • Rich experience in Design and Development of BW Reports, BEx Analyzer.
  • Post production support, monitoring daily loads and defect fixing, Process Chains maintenance for master data and transaction data
  • Created Info packages for initial, full and delta uploads for both master data and transactional data.
  • Responsible for Data Extraction from R/3 Source System, Loading Data into Data Targets in BW.
  • Worked extensively on Administrative Workbench, Design of Info Cubes, Data Store Objects, Multi providers, Info Objects, Info sources, Transformation, Info packages and Data Transfer Process (DTP).
  • Enhanced the existing Data Source and changed the Info Cube Design accordingly.
  • Created flexible reports using calculated key figures, filters and variables. Provided drill down functionality on reporting. Extensively used all the features in BEx Analyzer.
  • Conducted Training to Core Team and end user on running various queries and reports in BEx and on Info Cubes, DSO and Multi Provider.
  • Uploaded master data and transactional data from SAP R/3 via data staging to PSA, DSO, and Info Cubes.
  • Worked on creating the Generic Data Sources to reach the Client Reports Requirement
  • Worked on Transportation of Objects - R/3 and BW across the System Landscape.
  • Reconstruction of data requests from PSA in case of data load failure.
  • Actively involved in monitoring the data transfers from Source Systems into BW with Full update and Delta mechanisms for transaction data

Technical Environment: SAP BI, SAP R/3 ERP 5.0, Flat files, Utility server

Confidential

Associated BW Consultant (SAP BW 3.0 End to End Implementation)

Roles & Responsibilities

  • Worked with different users to gather business requirements and transformed them into a data modeling.
  • Analyzed business reporting requirements and installed the necessary objects for Standard Info Cubes.
  • Worked on the development of various info cubes related to Sales & Distribution.
  • Worked on Creating RFC Connection (Configuration) Between the R/3 Source System and BW 3.5 Source System
  • Configured and Customized Standard Cubes, Multi Cubes, and ODS Objects
  • Loaded Plan Data from Flat File Source System into BW Systems
  • Setup periodic data loads from R/3 full/delta enabled and legacy system (flat files) containing certain customer information and enhancement of extract structure
  • Worked on Currency Translation for SD Exports Order and Billing.
  • Created BEx Reports for the required SD Order and Delivery and Billing.
  • Created Process Chains for Master Data Text, Attribute, and Transactional Data for Order, Delivery, and Billing.
  • Generated reports using BEx (Business Explorer) with exceptions, conditional formatting, restricted and calculated key figures.
  • Designed and optimized the queries (top customers, monthly incoming orders and Delivery and Sales analysis) and created reports using BEx Analyzer and Browser
  • Loaded Data from mySAP CRM to BW Systems for Campaign, Lead, and Opportunity.

Technical Environment: SAP BW 3.5, SAP R/3 EEC 5.0, Flat files and SAP CRM

Hire Now