SUMMARY:

• Snowflake and SAP BW/ HANA Consultant with over 15 years of professional experience in Data ware housing area in design, development and implementation of business applications.
• Around 3 years of extensive experience in Snowflake and Migrating Data from SAP HANA to Snowflake.
• In depth understanding of Snowflake cloud technology and Snowflake Multi - cluster Size and Credit Usage .
• Played Key role in Migrating SAP HANA objects into snowflake environment.
• Experience with Snowflake Multi-Cluster Warehouses , Snowflake Virtual Warehouses and in building Snow pipe .
• In-depth knowledge of Data Sharing in Snowflake and Snowflake Database, Schema and Table structures .
• Experience in using Snowflake Clone and Time Travel .illion.
• Hands on experience and very good knowledge in different ETL tools like talend and matilion.
• Worked on Microsoft SQL and T- SQL Programing including Store Procedure user defined functions views and cursors.
• Worked on Oracle SQL and PL SQL Programing including Store Procedure user defined functions views and Cursors and Very good knowledge with Teradata.
• This includes expertise in SAP Business Information Warehouse, ABAP, ECC and around 5 years of good experience in SAP Enterprise HANA, SAP BW on HANA ,Native HANA and Data Provisioning using BODS,SDI,SDQ,SLT and SAP HANA XSA.
• Lead BW/HANA teams with size varying from 8 to 10 people, to successfully deliver multiple projects with onshore and offshore model.
• Worked extensively around 10 years at client location. Worked extensively Full SAP BW Life Cycle project implementations in MM, FI, CO, CRM ,GTS and SD modules.
• Performed extensive LO(SD,MM),FI, CO, PS, CRM, GTS and generic data extractions.
• Having good functional knowledge in FI,SD,MM,CRM, GTS and extensively worked with these extractors.
• Experienced in all phases of BW implementation using ASAP methodology.
• Trained and Certified in Enterprise SAP HANA from SAP and trained in BW on HANA from SAP and good experience in creating different models like Attribute views, Analytical views and Calculation views,
• Good Hands on experience in extracting data using BODS and SAP HANA EIM tools like SDI and SDQ .
• Good in writing Functions, procedures and using them in Calculation views of HANA.
• Worked extensively and interfaced various file systems by defining custom DSOs, ODS Object, Info Source and Cubes.
• Exposed to life-cycle environment like analysis, design specification, development, performance tuning, testing, documentation, maintenance, trouble-shooting and scheduling batch Processes through process chains.
• Good working knowledge in Sap BO like Creating universe, Webi Reports and Analysis for OLAP Reports and Design Studio .
• Good working Hands on Knowledge in SAP BODS using Data Integration, Data Quality and Platform transforms to meet Customer specification like extracting the data from legacy to BW and HANA .
• Extensively worked with Customization by including ABAP code for data source enhancement for Transactional and Master Data sources and creating function modules.
• Worked extensively in writing Customer exits and User exits and BADIs. Good working knowledge in ABAP on HANA.
• Experience in writing Start routine, End routine, Expert routine and writing ABAP code for customers exits.
• Expert in building Multi providers and Info sets as per the query needs. Configured and implemented BW reporting using Bex analyzer/browser and WEB Application designer.
• Developed flexible queries using filters, navigational attributes, variables, calculated key figures, restricted key figures, exceptions and conditions in Bex analyzer used RRI feature to jump between the Queries to analyze the data efficiently.
• Used BW Statistics, Query Monitor and created Indexes, Aggregates to enhance query performance.
• Worked in Web Application Designer (WAD) for creating web templates and published the reports in Portal. Created I-views from Web Templates.
• Strong working knowledge of BI 7.0 with different features like Data transformation process, data stage object (DSO), expert routines, start routines, end routines.
• Creating Information Models (Calculation Views) as per the business requirements with functional areas of FI, CO, MM, Sales
• Calculation Views with SQL Script by calling procedures, functions in the calculation view.
• Implemented Transformations with SLT using IUUC REPL CONTENT.
• Created Analytical Privileges to implement row level security on calculation views on Plant & company code.
• Worked with Business users in developing roles and personalized queries according to users based on the business area and developed Authorizations.
• Worked extensively in all phases of implementation Business requirement gathering, creating the functional and technical specs, design, and development and testing.
• Strong planner and organizer with demonstrated ability to master new concepts quickly, in corporate the latest technology, and develop business solutions that increase efficiency, productivity, and profitability.
• Excellent communication, presentation and interpersonal skills

WORK EXPERIENCE:

SAP HANA SQL Solution Architect

Confidential

Responsibilities:

• Involved in Migrating Objects from SAP HANA to Snowflake.
• Created Snow pipe for continuous data load.
• Used COPY to bulk load the data.
• Created internal and external stage and transformed data during load.
• Worked with both Maximized and Auto-scale functionality.
• Used Temporary and Transient tables on diff datasets.
• Cloned Production data for code modifications and testing.
• Shared sample data using grant access to customer for UAT.
• Time traveled to recover missed data.
• Used Airflow and created DAGs and scheduled jobs and very good in writing python scripts.
• Created a Snow pipes by using auto ingest and loaded the data from AWS s3 buckets to Snowflake.
• Very good knowledge in AWS.
• Developed data warehouse model in snowflake datasets using where Scape.
• Very good experience in python to create data base objects like tables, views and load the data using Python scripts.
• Heavily involved in testing Snowflake to understand best possible way to use the cloud resources.
• Experience in enhancing performance of SQL Quires using execution plans.
• Created Standards and best practices for DB Design and Development.
• Experience in Data base version control tools such as GIT Hub.
• Worked on SQL data transfers using merge, insert and update logic.
• Experience in SQL Programing including Store Procedure user defined functions views and cursors.

SAP HANA SQL Solution Architect

Confidential, Bentonville, AR

Responsibilities:

• Created Different Calculation Views in HANA like Dimensional Calculations views and Cube based Calculation views.
• Created Cube base calculation with star join option to do multi-dimensional modeling.
• Extracted Data from Different source databases like Oracle, MS SQL Server, and Teradata and loaded in SAP HANA using SAP BODS as ETL.
• Expert in Writing SQL, Procedures, Functions and Views in different databases like Oracle, MS SQL Server and Teradata.
• Used Different DML statements like Select, Update, Delete and Insert and DDL statements like Create Alter and Drop.
• Experience in creating clustered indexes and non-cluster indexes to optimize quires.
• Experience in writing SQL code for UAT and Unit testing for data validation.

SAP BW/HANA Principle Architect

Confidential, New York, New York

Responsibilities:

• Developed SAP HANA data modeling using Calculation Views User Management, Optimization of HANA models.
• SAP HANA enabled solutions design (Data Provisioning, Application, Security, and Reporting).
• Extensively used SAP HANA Data provisioning using SAP HANA EMI services like SDI and SDQ.
• Very good in writing SQL Script and used them in Script based Calculation views .
• Created different views based on SLT tables and used native HANA calculation views .
• Worked extensively and good Knowledge about all the changes in HANA 2.0 and BW/HANA.
• Worked on different reports like Inventory Aging Report, First Pass Quality Report, MTTR/MTBR Report, Plant Maintenance, and Quality Management Reports.
• Working closely with BODS team to develop different reports in Design Studio and to extract data from 3rd party systems.
• Migrated all EDW Legacy reports to SAP by extracting the data from SQL server DB extraction and transformation performed using BODS and loaded the data to SAP BW.
• Used SAP BW table in HANA modeling and created different Calculation views on top of these table and created different reports using Webi and Design Studio.

SAP BW/HANA Principle Architect

Confidential

Responsibilities:

• Involved in Business requirement gathering, creating the functional and technical specs, design, development, testing and implementation of Business Warehouse Change requests.
• Working on different GTS reports like Import, Export and Preference Reports
• Developed SAP HANA data modeling using Analytic Views and Calculation Views User Management, Optimization of HANA models.
• SAP HANA enabled solutions design (Data Provisioning, Application, Security, and Reporting).
• Creating Information Models (Calculation Views, Analytical views, Attribute views) as per the business requirements
• Calculation Views with SQL Script to access data from Row store tables.

Confidential

Environment: BW 7.4, ABAP, HANA, BO, BODS.

SAP BW/HANA Solution Architect.

Responsibilities:

• Worked on different retailers reports like Sales and Stock, New Items, OSA reports
• Developed Composite Providers, Calculation views based on different requirement of reports.
• Working closely with BO and BODS team to develop different reports in Design Studio and to extract data from 3rd party systems.
• Working on DSIM models on HANA and responsible for create and setup Complete DSIM system and DSR Reports and complete responsible for design and development of different retailers reports.
• Worked extensively on BODS to extract transform and load data from different legacy systems to BW.
• Creating Information Models (Calculation Views, Analytical views, Attribute views) as per the business requirements with functional areas of FI, CO, MM, SD, CRM and PS data.
• Very good in writing Procedures, Functions using the SQL Script and used them in Calculation view.
• Calculation Views with SQL Script for complex logic .
• Expert in writing ABAP code as per the requirements like Expert routine, End routine, Start routine and customer exits for reports.

SAP BW/HANA Solution Architect

Confidential

Environment: BW 7.4, ABAP, HANA, BO, BODS.

Responsibilities:

• Involved in Business requirement gathering, creating the functional and technical specs, design, development, testing and implementation of Business Warehouse Change requests.
• Working on different reports like Sales and finance reconciliation reports and migrated the BO reports on EDW to HANA on BW and then we did the modeling in HANA studio and created different views like calculation view, analytical view and attribute views.
• Developed Expert routine, End routine, Start routine and involved in writing customer exits for reports.
• Working with functional team closely for fiscal year changes for fiscal variant and complete responsible for the impact analysis of that in BW.
• Working closely with BO and BODS team to develop different reports in Web and to extract data from 3 rd party systems.
• As a SAP BW/HANA Consultant, responsible for design, development, testing and implementation of Business Warehouse requests from requirement gathering to go live.
• Involved in creating different reports like Sales by country and different finance reports like Balance sheet and Profit and Loss using HANA models.
• Worked on different BO reports which were on EDW previously we migrated all the reports from EDW to BW on HANA using BODS as ETL (As back end logic) BW as staging and did the modeling in Enterprise HANA and created Webi and Analysis for OLAP reports in BO.
• Developed SAP HANA data modeling using Attribute Views, Analytic Views and Calculation Views User Management, Optimization of HANA models.
• SAP HANA enabled solutions design (Data Provisioning, Application, Security, and Reporting).
• Extracted data from different source of GTS extractors like 0SSL CD 1,0SSL CD 2 Created different reports like import and export analysis based on GTS in BO using HANA views based on BW tables.
• Worked on different CRM extractors like CRM Service Orders Header Data and Item data, CRM Complaints Item and CRM Service Contract Header and Item Data.
• Creating Information Models (Calculation Views, Analytical views, Attribute views) as per the business requirements with functional areas of FI, CO, MM, SD, CRM and PS data.
• Very good in writing Procedures, Functions using the SQL Script and used them in Calculation view.
• Calculation Views with SQL Script to access data from Row store tables.
• Implemented Transformations with SLT using IUUC REPL CONTENT.
• Created Analytical Privileges to implement row level security on calculation views on Plant & company code.
• Closely worked with BO and BODS team to meet Customer specification.
• Extracted different source data to SAP BW as a staging and designed HANA models in SAP Enterprise HANA with respect to BW tables.
• Developed SAP HANA data modeling using Attribute Views, Analytic Views and Calculation Views User Management, Optimization of HANA models.
• Worked on Creating IDT universe, Webi Reports and Analysis for OLAP based on HANA views.

Confidential

Environment: BW 7.3, ABAP, HANA, BO, BODS.

Responsibilities:

• Interaction with Business for proper understanding of requirements and deliverables.
• Analysis of the Business Requirement.
• Preparation of the design and design documents as per Business Requirement. • Development of Backend objects to meet Business Requirements.
• Analyzing and modifying standard extractors as per the requirement and creation of Generic Extractors for reconciliation data
• Writing ABAP code whenever necessary.
• Creating reports in BEx Query Designer as per business requirement.
• Worked on Creating IDT universe, Webi Reports based on Bex reports.
• Unit Testing, Integration Testing and User Acceptance Testing.
• Co-ordination for Business Acceptance and sign offs.
• Worked on APD's.
• Worked with different data like CRM FI and SD Header Data and Item data.

Confidential

Sr. SAP BW/BI with ABAP Developer

Responsibilities:

• Responsible for Leading the BI support team to support finance and sales work streams.
• Closely associated with HP business and delivered optimized business solutions, also regularly monitoring OLTP changes.
• Involved in the design, development, testing and implementation of Business Warehouse using extended star schema and configuring the system and users.
• Extracted data for Inventory and Sales from Different Business Content extractors 2LIS 03 BX, 2LIS 03 BFand 2LIS 03 UM for Stock initialization, Stock moments, Stock Revolutions.
• Working experience on BTE extractors
• Developed complex queries for Inventory Management: Inventory on Cycle Counts, Inventory Overview: Simple and Extended views and analysis using Structures, RRI, calculated and restricted Key Figures, query properties and Variables etc.
• Sole responsible for designing & developing Inventory Management reports such as Stock Overview, Inventory Overview and demand supply match reports.
• Developed User Training Material and Worked on developing detailed material for Knowledge Transition for maintenances of the project.

Sr. SAP BW/BI with ABAP Developer

Confidential

Roles & Responsibilities:

• Involved in analyzing the available models, realization, design, development and Cut over Activities to extract data into BW from different work streams and provide support for various areas like GL, AR and AP.
• Used LO extract structures for extracting sales order, Delivery, Billing and Purchasing data (Header, Item level and Schedule line) from SAPR/3 Source system.
• Extracted accounts receivable and payables and GL data transaction figures (0FI GL 04) and Line items for the Customers (0FI AR 04) and Vendors (0FI AP 04)data from SAPR/3 TO BW.
• Worked on Open hub destinations and developed various customized tools to analyze the BW Objects in the system

SAP BW/BI Developer

SAP BW with ABAP Consultant

Responsibilities:

• Involved in gathering user requirements, cr eation of Business Specification and BW Implementation design document.
• Extracted data using LO Cockpit Extractions (SD-Sales Order, Billing, Notification), Generic Extractions and CRM Extractors.
• Generating Enterprise Portal, Web Templates and Process Chain Implementation
• Used Cell Restrictions, filtering, conditions, variables, RRI interfaces and jump queries.
• Developed different reports in FI such as Balance Sheet, P&L, Cash Flow, Day Sales Outstanding, 7th Work day analysis, Top Ten Customer based on outstanding Balance.
• Unit/Integration/System test design and Performance Tuning for the Bex Queries.
• Monitoring of the data load and update processes running in the production environment