Summary
Overview
Work History
Education
Skills
Professional Experience
Timeline
Generic

CHAITANYA NAGARJUNA VELURU

Summary

Experienced SAP BI/HANA SQL Snowflake Data Engineer with deep knowledge in business processes associated with Financial Reporting and having 8 years of experience as a technical consultant. Worked on 2 full-cycle SAP BW/BI implementations, Upgrade projects, Application Development/ Support, and migration projects. Experienced SAP HANA Analytics professional in design, implement and deploy SAP HANA solutions for customers across industries, including SAP BW/4HANA, SAP Enterprise HANA, SAP Analytics solutions. Using Agile & Scrum methodologies, leveraging agile methodologies in SAP. Meetings with business for quarterly and yearly projects to be implemented, creating Epics and Stories. Actively Involved in Sprint planning, backlog requirement and release management activities using JIRA, Agile Central tools.

Overview

9
9
years of professional experience

Work History

Data Engineer

3M
Bangalore
01.2022 - Current
  • Analyzed business requirements and created the logical data models that describe all the data and relationships between the data
  • Worked with SAP BW on HANA, worked on mixed scenarios using both HANA as data mart + BW on HANA and consumption of HANA models in BW and BW models in HANA
  • Implemented SAP BW on HANA specific modelling like Advance DSO, Open ODS View, Composite Providers and exposing BW objects in HANA Views, Operational Data provisioning
  • Extracted data from multiple functional areas, from SAP source systems such as S/4 HANA, CRM and from non-SAP systems
  • Working with an 'Agile' team using Scrum Framework
  • Implemented BW powered by HANA solutions using LSA++ Architecture
  • Involved in Daily scrum meetings with the Scrum master to get the list of objects targeted for the upcoming release and worked with the offshore team to deliver them as planned
  • Created Dimension Calculation views to get master data, Calculation views (with cube or Star Join) to get fact data and utilized Star schema modelling
  • Created HANA models using both physical tables and virtual tables
  • Created Analytic Privileges based on filters required as per the users using the privileges like restriction based in country and region etc
  • Using normal filter and stored procedures upon the data models
  • Created Input parameters, Variables, Calculated columns, restricted columns (KPIs) according to the Created different types of visualizations viz., geographical visualizations after slicing and dicing the account operations related data to analyze financial data across different locations
  • Worked on migrating the HANA objects from Development/Test environment to Production environment using Delivery Unit
  • Data provisioning from SAP ECC system to HANA using SLT replication, to replicate tables from SQL server to HANA
  • Worked on creation of Tables in Snowflake
  • Worked on integration team to load the data from Teradata to Snowflake
  • Worked on creation of V01 & V02 views in Snowflake.

Advisory Consultant

IBM
Bangalore
11.2021 - 12.2021
  • Involved in daily discussion with Solution Architect/Business team to understand the functional specs and create technical specs accordingly
  • Worked on optimizing the information views for better performance
  • Used SLT replication server to load real-time data form ECC to HANA
  • Migrated HANA content from development, quality testing environment to Production environment using delivery units.

Application Developer

Fujitsu Consulting India Pvt Ltd
Bangalore
09.2016 - 10.2021
  • Worked on LSA and LSA ++ Architecture for developing models
  • Developed BW models using the new info providers such advanced DSO’s and Composite providers on the new BW Modeling tools perspective in HANA Studio
  • Extensively worked on the Hana Modeling side on views such as attribute view and calculation views
  • Monitoring ticketing tool regularly (service now) and worked on tickets priority based
  • Managing the Data Targets by having the correct and up to date data (Check reports)
  • Working closely with Lead Architects in streamlining the developments
  • Created Queries using different Variables using different Processing types
  • Monitoring of data loads on daily basis, which will update into various BI data targets
  • Used to schedule Process Chains as per Factory calendar specific to country
  • Extensively worked on Performance enhancement features such as Partitioning, Indexing, maintaining aggregates and Compression
  • Worked on Transportation for new changes from Development system to Quality system
  • Validate the Transported Objects in Quality system and prepare for User Acceptance Test
  • Prepare the Load Plan in Production post User Acceptance Test
  • Produced the Cutover activities especially the movements of the Transports and their dependencies from the respective objects
  • Interacted with the business users in identifying the requirements, prototyping the reports, design and development of the reports
  • Actively participated in Cutover and Go Live activities
  • Involved in maintaining documentation for all the Support Activities.

SAP BW Associate Consultant

Arrowhead Services Pvt Ltd
Bangalore
11.2015 - 09.2016
  • Responsible for 24X7 hour support of the system on a regular basis
  • Monitoring of process chains and analyzing the reasons for frequent failures of the Process Chains
  • As a member of Sap BW team, involved in Analyzing the data, Business content installation, customized and configuration of objects
  • Scheduling BW jobs, monitoring these Schedules on Process Chains and BW monitor
  • Worked on process chain monitoring using RSPC, RSPCM, RSMO, checked jobs in SM37, and work processes in SM50
  • Involved in escalating high prioritized tickets regarding extractions, performance issues and loads failures
  • Maintaining Reconciliation to verify the data in SAP R/3 and SAP BW are same or not after the data loads
  • Worked on data loading from an external system to BW using the flat files
  • Analyzing business-reporting requirements that would satisfy by the users
  • Monitoring the performance of queries and effectively presented the report as per the requirement
  • Modifying the reports as per the user requirements
  • Increased the query performance with the help of RSRT
  • Created Aggregates to increase Query performance
  • Involved in maintaining documentation for all the Support Activities.

Education

Skills

  • Data Warehouse: SAP BW 35x - BW7X & Native HANA
  • Cloud Technologies: Snowflake / SAP Datasphere
  • ERP: SAP R/3 ECC 60
  • Data Base System: HDB (Hana Data Base)
  • Data Base Tool: SQL
  • Reporting Tool: Business Explorer, BEx Query Designer, BEx Analyzer & AO and BO, SAC
  • Office Tools: MS Word, MS Excel, MS Power Point
  • Operating System: Windows 2000/XP and all Higher Versions, MS-DOS

Professional Experience

· Working with 3M Bangalore from January 2022 to Till date as a Data Engineer.

· Worked with IBM, Bangalore from November 2021 to December 2021 as a Advisory Consultant.

· Worked with Fujitsu Consulting India Pvt Ltd, Bangalore from September 2016 to October 2021 as a Application Developer.

· Worked with Arrowhead Services Pvt Ltd, Bangalore from November 2015 to September 2016 as a SAP BW Associate Consultant.

Timeline

Data Engineer

3M
01.2022 - Current

Advisory Consultant

IBM
11.2021 - 12.2021

Application Developer

Fujitsu Consulting India Pvt Ltd
09.2016 - 10.2021

SAP BW Associate Consultant

Arrowhead Services Pvt Ltd
11.2015 - 09.2016

Similar Profiles

CREATE PROFILE
CHAITANYA NAGARJUNA VELURU