SUMMARY:

• Having 6+ years of experience in IT Industry with extensive experience in SAP BI/BW and BO consultant, which includes experience in SAP HANA as a technical consultant playing various key roles in design, development and reporting techniques on tools like SAP BW 7.4, SAP HANA,BW ON HANA, S/4 HANA, BUSINESS OBJECTS.
• Hands - on experience working with standard and custom SAP BW Extractors, SAP BW on HANA features such as advanced DSOs, composite providers, Open ODS views, exposing BW models as HANA views, mixed scenarios, HANA Analysis process in BW and LSA ++ best practice and performance optimization concepts.
• Expertise in Data Modeling and Re-Modeling of Info Cubes, DSOs (Standard, Direct update and Write optimized), Info Objects, Info Areas, Info Sets, Info Sources, Virtual Providers.
• Excellent skills to work with Flat File Extraction, BI Content Data Sources and extraction models including Full and Delta updates.
• Good experience in dealing with both SAP and non-SAP systems. Developed all kinds of Routines (Start, End and Expert) during the creation of Transformations and DTP’s using ABAP.
• Experience in Designing new solutions using SAP BW on HANA to deliver capabilities meeting business functional requirements and Defining the BW on HANA and S/4 HANA architecture to design new data flows and data integration scenarios.
• Excellent skills to develop reports using POWER BI, WEBI, TABLEAU and Crystal Reports.
• Experience with SAP HANA programming including SQL script (Procedures, functions, Sequence, DB triggers) and CE-functions and Virtual Data Model (VDM), Data Services (DS)
• Experience in Information Models such as Attribute Views, Analytic views, Calculation Views (Graphical & SQL Script based), Hierarchies and Decision Tables. Have good understanding of different joins and unions like Inner, Left Outer, Right Outer, Referential, Text joins and sizing, scoping, high availability, and delta merge
• Hands on experience with SAP BI Tools including BW, building reports using ABAP routines in Transformations, start routine, end routine, Expert routine, SAP HANA Expert script, Integrated Planning.
• Experience with design and development of various dashboards utilizing MSPowerBI/Tableau visualizations like bar graphs, line graphs, maps, scatter plots, pie charts, histograms, bullet, geographic visualizations, heat maps and highlight tables
• Expertise in Test Models, Unit, Functional, integration and Regression testing all the modules to make sure it is working as expected and data is going through appropriate transformation steps and bug fixes.
• Experience and possess strong knowledge in SAP HANA Data modeling and data provisioning using Inbuilt HANA tools like Enterprise Information Management and external data provisioning tools like SAP LT Replication server (SLT), SDA (Smart Data Access), SAP Replication Services (SRS), Smart Data Integration.

SUMMARY:

Elements: Particulars

Primary Skills: SAP BW 7.5, HANA 1.0/2.0, Tableau, Power BI

Data Provisioning: SLT, SDA, SDI, BODS

Project Management: Microsoft Suite (Project, Visio, MS Office, PowerPoint, Excel)

Operating Systems: Windows XP/Vista/7/8/10

Languages: ABAP, HTML, CSS, ActionScript, JavaScript

Reporting Tools: HANA Modeler, Using Excel, IDT, Lumira, MS Power BI, BOBJ, AO, Design Studio, TABLEAU.

Databases: SAP HANA, MS SQL, MS Access, DB2, SQL,/PL SQLDesigning & Documentation MS Visio, MS SharePoint

PROFESSIONAL EXPERIENCE:

Confidential, WARSAW, IN

SAP BW HANA CONSULTANT

Environment: BW 7.4/SAP HANA 1.0

Responsibilities:

• Developed Technical Specifications based on Functional Specifications that outlines required Characteristics, Measures and Business Rules. The Technical Specification outlined the overall HANA design to meet and satisfy the Business Reporting Requirements.
• Worked closely with the Database and ETL team to get required table structures.
• Responsible in collecting SAP R/3 system and Non-SAP legacy systems list of values for Harmonized global Hana views and reporting architecture BI Report solution:
• Customer Types, Vendor Types
• Document Types, Billing Types
• Movement Types, Inventory Status Types, Storage Location Type
• Material Type, Product Type
• Involved in data extraction from SAP R/3 system and Non-SAP systems and scheduled Full Loads / Delta Loads using Process Chains. Also worked on data extraction from Flat files into BW and Hana Data Base for Data Flows.
• Extensively worked on SAP BW 7.4. Extended non-cumulative handling for Advanced DataStore Objects with delta calculation.
• Extensively worked on Data design and Data modeling using Extended Star Schema.
• Created master data objects as Attribute views, joined multiple master data tables depending on the requirement, selected key figures and attributes to give context to the master data.
• Involved in creation of Analytical views to support multi-dimensional reporting by joining Fact table data foundation to modeled dimensions attribute views, selected attributes and measures.
• Created Calculation views using data base tables, attribute views and analytic views, in order to address complex business requirements created SQL Script based Calculation views.
• Involved in creation of Calculated attributes, measures, Restricted measures, Calculated columns, filters, hierarchies, variables, input parameters to satisfy reporting requirements using SAP HANA IMCE STUDIO
• Developed SQL scripts and functions for complex reusable scenarios in HANA.
• Involved in data extraction, data cleansing, data mapping, data harmonization, data enrichment, data consolidation, data loading and data reconciliation.
• Follow the company procedures to migrate from the development environment to QA quality assurance all the universes and reports until the production server.
• Created Universes on top of HANA calculation views and developed the Web Intelligence (Webi) reports and dashboards using IDT Information design tool.
• Involved in developing and conducting extensive Unit testing, Regression testing, User Acceptance Testing UAT and documentation.

Next Labs, San Mateo, CA

SAP BI/BO/ Consultant

Environment: BW 7.4/BW 7.3/BI 7.0/ECC 6.0/BO. 4.1/BEx. esponsibilities:

• Worked on Scenarios to optimize HANA procedures to provide results at much faster time frames.
• Working on data flows to support Business planning and consolidation integration.
• Creation of Attribute Views, Analytical Views and Calculation views Graphical and SQL Script - CE Functions and Stored Procedures.
• Created BODS data sources for extracting Warehouse and Transportation costs information into BW.
• Used Eclipse data modeling in HANA studio to Create ADSOs, Composite Providers, Open ODS views and Info objects.
• Created ADSOs of type standard DSO and info cube. Used Field based modeling in Designing of ADSOs.
• Created Calculation views of Dimension, Star join and Cube types based on ADSOs, Composite Providers and Master data tables.
• Created Data sources based Open ODS views to Consume Calculation views into BW system.
• Used Projections, Aggregations, Joins, Unions and Rank nodes in Calculation views design.
• Created restricted columns, calculated columns, Input parameters and variables in Calculation views.
• Created Level and Parent-Child hierarchies. Have experience with working currency conversion in Calculation views.
• Used ABAP start and End routines in transformations. Created different Rule groups for Creating Account Hierarchy for Gross margin.
• Worked on Support Tasks related to Inventory Management and SD functional areas.
• Have Exposure to BW/HANA Security model.

Confidential - Southlake, TX

SAP BW HANA CONSULTANT

Responsibilities:

• Involved in data migration and conversion activities that include extraction, transformation, migration, validation and reconciliation of data.
• Involved in information gather phase.
• Worked on Advanced DSO, Open ODS View, Composite providers & Transient providers.
• Created Process Chains and Meta-Chains for periodic upload of Text data, Master data and Transactional data, and Monitored data loads with full update and delta mechanisms.
• Created Process Chains and Meta-Chains for periodic upload of Text data, Master data and Transactional data, and Monitored data loads with full update and delta mechanisms.
• Designed and implemented SAP HANA data modeling using Attribute View, Analytic View, and Calculation View.
• Involved in data extraction, data cleansing, data mapping, data harmonization, data enrichment, data consolidation, data loading and data reconciliation.
• Involved in supporting the data migration strategy and processes to enable efficient and effective deployment data conversion.
• Created many WEBI reports over advanced DSOs and Views.

Confidential - Oak Creek, WI

SAP BW Analyst

• Design and Development of Custom Info Cubes, ODS objects, Multi Providers, Info sets and master data objects.
• Strong working experience in data analysis, design, development, implementation and testing of data warehousing using data conversions, data extraction, data transformation and data loading (ETL).
• Involved in Business requirements gathering and preparation of Technical Specifications documents, Training guides and other data mapping documents.
• Development and Enhancement of Info sources, Transfer rules and update rules.
• Used Delta update to load data into SAP BW.
• Worked on loads and scheduling with Process Chains.
• Developed test cases and conducted Unit Testing.
• Identifying the risks and issues from team meetings and coordinating with Project manager

Confidential

Web Developer

Responsibilities:

• Gathering business requirements from the users and translating them into technical designs.
• Written DB queries for analytical reports to be created for the reporting to higher management
• Designed the WebPages for the internal portal for the employees
• Involved in the design of the database for the HR department to be able to store the employee information and building the interrelationship with finance for payroll processing & attendance management.
• Built the sections of the webpage for the corporate website related to the policies of HR
• Worked on enhancements for the system responsible for the Vendor relationship management.
• The application was built on Java as front end and SQL server on the backend