SUMMARY

• Around 16+ years of extensive experience in SAP BW/BI which includes around 6 years in HANA and BW/4HANA, this includes Data Modeling, ETL and Report Development.
• During years of experience, he has worked for multiple onsite Projects in United States of America, United Kingdom and India in SAP ERP space with different roles like Business Analyst, Solutions Architect, Lead Consultant and Onsite coordinator handling end - to-end deliveries.
• So far, He has been involved in 5 end-to-end SAP Implementations, 5 SAP Upgrades, 2 Data archiving, 3 BW HANA migrations, 2 HANA DB Administrations support.
• SAP Certified Application Associate - SAP Analytics Cloud

AREAS OF EXPERTISE:

• Expertise in SAP HANA Studio Modeling, in creating various Information Models like Attribute, Analytic and Calculation Views.
• Configured and Extracted data from SAP BW/4HANA Data Base using SLT.
• Experience with integration of HANA with MDX provider for validation through frontend.
• Hands on experience in SQL, Procedures and Scripted Calculation Views, SQL Hints and SQL Plans.
• Experience in creation of delivery units, Import-exports.
• Experience in creation of Variables, Input Parameters.
• Experience in creating calculated columns and Performance tuning of HANA Models.
• Exposure to functionalities like Import, Export and Schema Mapping.
• Developed reports using AFO, Power BI and Created Webi reports.
• Hands on BW 7.5 on HANA using objects such as composite providers, ADSO’s etc.
• Created and validated HANA based designs.
• Validate CPU usage, memory footprint and system load during test run for reports and data loads.
• HANA Security (creation of users and providing the roles and authorizations based on the business requirements).
• Worked in SQL Procedures, Script Calculation Views in sales to achieve the open stock & close stock valuation data.
• Basis sanity checks after the upgrade.
• Worked extensively on HANA modeling and responsible for HANA development deliverables in time, Lead for Cutover Activities and handled multiple projects.
• Experience in SAP BW/4 HANA, Advanced DSO(ADSO), Open DSO Views, Transient Providers, Composite Providers, Publishing HANA Model in SAP BW, Import SAP NetWeaver BW Model to HANA.
• Experienced in handling tasks/requests and actions in FIORI.
• Experience in Layered Scalable Architecture plus plus(LSA++).
• Experience in writing AMDP, creating Open ODS views, DB connect datasources.
• Transportation of objects to different landscapes and trouble shooting.
• Responsible for planning cut-over activities for the go-live support for the development work.
• Redesigned HANA Attributes Views, and HANA Analytical Views for Sales Stats Extractor Loads and called them using the Open ODS (Using Database Tables/ Views) in SAP HANA Studio for SAP BW/4 HANA.
• Experienced in customer exit variables for WEBi reports.
• Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports.
• Created Dax Queries to generated computed columns in Power BI.
• Generated computed tables in Power BI by using Dax.
• Involved in creating new stored procedures and optimizing existing queries and stored procedures.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps
• Explore data in a Variety of ways and across multiple visualizations using Power BI
• Used Power BI Gateways to keep the dashboards and reports up to date.
• Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.
• Published reports and dashboards using Power BI to import data from various sources such as SQL Server, SQL Server Analysis Services (Tabular Model), MS Excel etc.,

TECHNICAL SKILLS

Languages: C, knowledge of C++, SQL

Databases: HANA 2.0, SQL Server 2012

Operating Systems: MS-DOS, Linux and Windows NT/2000/2007/Vista

ERP: SAP BI 7.0, 7.3, 7.4, BW/4HANA, SAP ECC 6.0, EHP6, S/4HANA 1809 in SD, MM, FI, SC

Reporting Tools: Bex/BW query designer, BOBJ, SAP Analytics Cloud(SAC), Design Studio 1.5, POWER BI, Knowledge on Click Sense

Tools: HP QC/ALM, JIRA V7.6.6, IBM CQ (Clear Quest)

PROFESSIONAL EXPERIENCE

Confidential

HANA/BI Consultant

Responsibilities:

• Requirements gathering for business-critical reports leading to complex data flow models.
• Development of Operational reports, Financial reports, Budgeting & Costing reports, Sales reports and Productivity reports.
• Documentation of Functional Mapping and Technical Mapping documents.
• Extraction of Data from S4 using SLT.
• Creation of complex Calculation Views using Star Joins
• Creation of Procedures and Functions using SQL
• Creation of Analytic Privileges to restrict data for different business users.
• Creation of Variables, Input Parameters in calculation views.
• Performance tuning of the HANA models using Explain Plan and Viz. Plan.
• Extensively created and transported HANA Content Objects between the landscapes.
• Implement and modify Business Object Central Management Console and management of complex reporting environments.
• Develop analytical reports and dashboards using an assortment of SAP business objects products such as Web Intelligence (Webi).
• Created Business Objects suite (WEBi, Scheduling, Distributing & L3 support activities)
• Created reports prototypes using Web Intelligence (Webi) for user presentation importing existing user accounts, groups, categories, Webi documents to Business Objects 4.3
• Analyzed, Design and Develop / Modify WEBI Reports and Universes in 4.2 and FIORI (4.3).
• Created reports prototypes using Web Intelligence (WEBI) for business teams like FI, SD.
• Used HP ALM for System Integration Testing and User Acceptance Testing of the HANA Models and WEBI Reports.
• Leading defect triages with the stake holders and driving till closures.

Confidential

BW4/HANA and BI Consultant

Responsibilities:

• Creation of delivery units and transports using Delivery Units, Import Exports and CTS.
• Creation of Variables, Input Parameters in graphical and scripted calculation views.
• Created flow graphs from remote source to SAP HANA.
• Created Process chains to load data from ECC to BW/4 HANA data model objects.
• Created BW Queries on top of Composite providers and ADSO for various Operational and analytical reporting needs.
• Created AMDP’s, Open ODS views and DB connect datasources using Eclipsed based Data modeling and design in BW/4HANA.
• Developed objects such as Info-object, DTP, Transformation, Data source, ADSO’s, Composite Providers, Cube, Multi provider. Involved in DSO deletion program.
• Imported data from SQL Server DB to Power BI to generate reports.
• Created Dax Queries, generated computed columns in Power BI.
• Generated computed tables in Power BI by using Dax.
• Created Power BI Reports and Dashboards with rich Visualizations.
• Created and Supported activities on WEBi reports as a part of reports migration.
• Created HANA modeling like scripted/graphical calculation views, table functions, Procedures, Virtual table, Virtual Procedures and support activities.

Confidential

BW4/HANA and BI Consultant

Responsibilities:

• Created AMDP’s, Open ODS views, DB connect datasources.
• Expertise working with Eclipsed based Data modeling and design in BW/4HANA.
• Creating Data flows in SAP BW/4 HANA Modeling involving ADSO, Composite Providers and Open ODS for extracting data from S4 and third-party data sources.
• Extraction and loading of data from S4 HANA data sources across different business functions such as Sales and Distribution, Finance, Billing etc.
• Created Process chains to load data from S4 to BW/4 HANA data model objects.
• Created BW Queries on top of Composite providers and ADSO for various Operational and analytical reporting needs.
• Involved in multiple end to end development Projects using S/4HANA, BW.
• Created SAP BI Related AMDP/ABAP routines like Start/End/Field/Expert routines.
• Day to Day support tasks to Monitor and fix any load issues.
• Involved in requirement gathering for development, Data modeling and designing reports as per the requirement.
• Provided solution architect to from design.
• Involved in discussion with User and requirement gathering.
• Developed objects such as Info-object, DTP, Transformation, Data source, ADSO’s, Composite Providers, Cube, Multi provider, Involved in DSO deletion program.
• Created Power BI reports and Dashboards with rich visualizations.

Confidential

HANA Consultant

Responsibilities:

• Created HANA modeling like scripted/graphical calculation views, table functions, Procedures, Virtual table, Virtual Procedures.
• Creation of delivery units and transports using Delivery Units, Import Exports and CTS.
• Creation of Variables, Input Parameters.
• Performance tuning by SQL analyzer, Adding Filters, Standard techniques by avoiding many aggregations, Consuming stored procedures.
• Expertise working with Eclipsed based Data modeling and design in BW/4HANA.
• Creating Data flows in SAP BW/4 HANA Modeling involving ADSO, Composite Providers and Open ODS for extracting data from S4 and third-party data sources.
• Extraction and loading of data from S4 HANA data sources across different business functions such as Sales and Distribution, Finance, Billing etc.
• Created Process chains to load data from S4 to BW/4 HANA data model objects.
• Created BW Queries on top of Composite providers and ADSO for various Operational and analytical reporting needs.
• Day to Day support tasks to Monitor and fix any load issues.
• Involved in requirement gathering for development, Data modeling and designing reports as per the requirement.

Confidential

HANA Consultant

Responsibilities:

• Involved in Onsite/Offshore model, understanding Business Requirements and gatherings.
• Analysis of the Business Requirements and developing Functional and Technical design Documents.
• Daily meetings with the onsite team and coordinating the work among the team members.
• Creation of Attribute, Analytic and Calculation views.
• Creation of calculated columns.
• Creation of delivery units.
• Creation of Variables, Input Parameters.
• Testing of data resulting from the view.

Confidential

BW4/HANA

Responsibilities:

• Analysis of the Business Requirements and developing Functional and Technical design Documents.
• Extensively worked on the Back-End development involving developing complex data models using best solution approaches.
• Worked on the Front-End Development on SAP BI 7.0 BeX Analyzer by developing Queries, Web templates.
• Involved in Redesigning/Migration of the Data Models for many existing applications to improve the systems performance.
• Also handled complete migration of the BW 3.5 queries to BI 7.0 with error handling issues.
• Worked on standard and custom defined LO extractors. Installed relevant SAP business content.
• Filled the setup tables and created the Delta Management.
• As part of BIA project, identified the InfoCubes for BIA and created Indexes in BIA for those InfoCubes.
• Coordinated transporting the BW objects created/activated/modified from Development System to Test and Production System.
• Error Debugging and rectification, solving issues, problems faced during Data loads.
• Fixed number of data load issues like data load failures, long running jobs etc.
• Extensively worked on the Maintenance and Support areas both at Back End and Front End Areas.

Confidential

BI Consultant

Responsibilities:

• Involved with Onsite/Offshore model Client and understanding their Business Requirements.
• Detailed analysis of the Webtemplates, web items and the queries used in a Webtemplates
• Creating the design studio reports as per the design of the Webtemplates.
• Worked in creating reports in design studio by using grids, filters, tables, charts, buttons and many more.
• Testing the reports of Design Studio and WAD.

Confidential

SAP BW Consultant

Responsibilities:

• Implemented various Performance Tuning activities to increase the performance of Queries by Creating indexes, Aggregates, Partitioning and Compression.
• Error Debugging and rectification, solving issues, problems faced during Data loads.
• Involved in Increasing the Load performance of the BW system while loading into DSO objects and InfoCubes.
• Fixed number of data load issues like data load failures, long running jobs etc.
• Analyzed PSA table growth and scheduled weekly PSA deletion jobs.
• Fixed number of DSO activation errors.
• Fixed number of BW related system related system refresh errors and documented those errors.
• Extraction of data from flat files, Monitoring the Process Chains for daily, weekly and monthly loads.

Confidential

BI Consultant

Responsibilities:

• Analysis of the technical concept and design of InfoObjects and Dataflows.
• Creation of process chains and data load, Analysis of load failures and correction.
• Delivery to onsite for testing.
• Took responsibility of cleaning up the BI system Back end by Objects not required in all the systems. Also cleaning the Front-end side by identifying and deleting unused queries and Web Templates in all the systems.
• Involved in Data Extraction from SAP and Non-SAP systems using SAP extraction Methods.
• Analysis of the technical concept and design of InfoObjects and Dataflows.
• Creation of process chains and data load.
• Delivery to onsite for testing.
• Analysis of load failures and correction.
• Took responsibility of cleaning up the BI system Back end by Objects not required in all the systems. Also cleaning the Front-end side by identifying and deleting unused queries and Web Templates in all the systems.
• Involved in Data Extraction from SAP and Non-SAP systems using SAP extraction Methods.