Summary
Overview
Work History
Skills
Certification
Timeline
Generic

Ajay Babu Daggubati

Irving,TX

Summary

With 18 years in data management, BI, and ERP, I offer 5 years of focused expertise in Databricks (Lakehouse, PySpark), and Snowflake (virtual warehouses, zero-copy cloning, HVR). My 13-year SAP background (HANA architecture/development, BW on HANA, BusinessObjects, ABAP) provides a strong foundation. I am proficient in Power BI (end-to-end solutions, DAX), dbt Cloud, advanced SQL, and SAP BEx tools, and I am seeking a challenging opportunity to leverage this blend of classic ERP and modern cloud data skills to drive innovative, data-centric strategies.

Overview

20
20
years of professional experience
1
1
Certification

Work History

Principal Consultant

Heidelberg Materials
Dallas, Tx
03.2024 - Current
  • Automated Data Integration and Ingestion: Worked on orchestrating seamless data integration from SAP systems and diverse, structured sources into Snowflake. I have been involved in proficiently leveraging data frames and datasets to efficiently process diverse data formats from sources, including HDFS, Azure Data Lake Storage (ADLS), AWS S3, and API integrations.
  • Robust Data Pipeline Architecture (Bronze/Silver/Gold): Involved in designing and implementing a multi-layered data modeling architecture within Snowflake, where I worked on utilizing bronze (raw), silver (cleansed/enriched), and gold (curated/aggregated) table layers. This approach I helped implement ensured data integrity, traceability, and optimized data for efficient analytical consumption.
  • Advanced Snowflake Data Modeling and Management: Worked on implementing dynamic tables for automated data refresh and materialized views to significantly enhance query performance and maintain data consistency. I have been involved in expertly utilizing zero-copy cloning for rapid, cost-effective data replication, and Time Travel functionalities for simplified historical data access, auditing, and compliance.
  • Optimized and Resilient Data Workflows: I have been involved in capitalizing on Snowflake’s near-zero management capabilities, including auto-scaling, auto-suspend, fail-safe mechanisms, and secure data sharing. I worked on implementing advanced security features to create reliable, scalable, and highly optimized data processing workflows.
  • Query Performance Tuning and Efficiency: Worked on conducting thorough performance tuning and optimization of Snowflake queries. I was involved in strategically applying clustering keys and materialized views, resulting in substantial reductions in query execution times. I also worked on enhancing overall query efficiency by leveraging Snowflake's intelligent caching mechanisms and micro-partitioned data storage.
  • Scalable and Automated Workload Management: Involved in successfully deploying Snowflake's auto-scaling and auto-suspend features to manage fluctuating workloads seamlessly. The solutions I worked on eliminated the need for manual administration, enhanced performance under varying demand, and optimized resource utilization.

Principal Consultant

Luxottica
Mason, OH
07.2022 - 03.2024
  • End-to-End Data Pipeline Development: Engineered and optimized large-scale data ingestion and ETL pipelines, utilizing Apache Spark within Azure Databricks. Proficiently leveraged DataFrames, Datasets, and RDDs to efficiently process diverse data formats from sources including HDFS, Azure Data Lake Storage (ADLS), AWS S3, and API integrations.
  • Advanced PySpark and SQL Optimization: Extensive experience in developing complex data transformations and analytics using PySpark and Spark SQL. Successfully enhanced query performance through advanced techniques such as predicate pushdown, partition pruning, strategic caching, and leveraging Adaptive Query Execution (AQE) for dynamic query plan adjustments, leading to significant improvements in processing speeds for data-intensive applications.
  • Data Integrity and Preparation: Skilled in defining and managing schemas, performing robust data transformations, and implementing data cleansing processes within Databricks notebooks to ensure high-quality data readiness for advanced analytics, and machine learning model development.
  • Secure and Scalable Cloud Solutions: Demonstrated ability to build secure and scalable data solutions on Azure by integrating Azure Key Vault for secure management of storage mount points, and access credentials.

Principal Consultant

Zimmer Biomet
Warsaw, IN
09.2021 - 06.2022
  • Strategic Cloud Data Migration Leadership: Led complex data migration initiatives from SAP HANA to cloud platforms, specializing in Snowflake. Expertise includes leveraging Pillar Replication and Alteryx for ETL processes, optimizing for high-volume transactional data, and intricate data migration scenarios.
  • Scalable Snowflake Data Modeling: Architected and developed robust, scalable data models within Snowflake, ensuring efficient data storage, rapid retrieval, and effective analysis of large-scale datasets.
  • ETL Workflow Design and Orchestration: Designed, deployed, and managed comprehensive ETL workflows within the Snowflake ecosystem, orchestrating seamless data transformations and integrations from various source systems.
  • HANA to Snowflake Data Integration and Sharing: Utilized SAP HANA Calculation Views as a primary data source for migrating data into Snowflake. Leveraged Snowflake's unique architecture to implement secure and controlled data-sharing capabilities, facilitating collaboration across multiple business units and stakeholders.
  • Snowflake Infrastructure Management and Optimization: Built and maintained Snowflake virtual warehouses, ensuring on-demand scalability and optimal performance. Expertly managed Snowflake stages and data pipelines for efficient and reliable data ingestion from diverse sources.
  • Advanced Snowflake Development: Developed complex Snowflake views and stored procedures to encapsulate business logic, streamline data access, and enable efficient querying for analytical purposes.
  • Collaborative SQL Optimization: Collaborated closely with data engineering teams and analysts to develop and provide highly optimized SQL scripts for querying and extracting insights from Snowflake data.
  • Continuous Improvement & Feature Adoption: Proactively explored and implemented Snowflake's latest features and best practices to continuously enhance data processing efficiency, analytical capabilities, and overall platform performance.

Lead Technical Consultant

AstraZeneca
India
01.2018 - 08.2021
  • Design interactive and visually appealing visualizations and dashboards to showcase the platform's potential.
  • Worked on mixed scenarios like BW, HANA, and BO Dashboards (AFO).
  • Analyzing CRs and SERs and Preparing Technical documents and Development.
  • Understand the business process and provide the approach documents for various business processes.
  • Created different types of calculation views for achieving different reporting requirements.
  • Worked on the Transportation of the HANA objects.
  • Worked on performance issues in process chain monitoring.
  • Solved different issues in the SLT system.
  • Configured jobs in SAP BODS for data sending to AWS from SAP BW on HANA.
  • Scheduled BODS jobs for data replication.
  • Worked on the creation of different types of ADSOs.
  • Involved in plan visualization for improving the performance of the views.
  • Worked on loading the data from ECC and APO to SAP BW HANA using SLT.
  • Experience with replication reports.
  • Worked on analytical privileges.
  • Worked on configuring the NLS process for ADSO.
  • Worked on trace analysis.
  • Consumed the views in analysis for office (AFO).
  • Performance tuning of Bex and AFO reports.
  • Monitoring of the process chains.
  • Handled the tickets based on priority.
  • Monitoring background jobs.
  • Monitoring the daily loads by using ST13.
  • Created the Meta chains and local process chains.
  • Worked on creating WEBi reports using the SAP B0 4.0 platform.
  • Involved in upgradation to BW4HANA using In place conversion from SAP BW7.5 SP05.
  • Involved in the Simplification list in BW4HANA.
  • Involved in Transfer tool using RSB4HTRF from SAP BW7.5 to BW4HANA objects.
  • Created a WEBI Report and Dashboard for NAM technical migration reports.

Lead Technical Consultant

Wales and West Utilities
India
06.2015 - 12.2017
  • Managing App Support, with a team of 5 members.
  • Understanding of client Business & their requirements in terms of Technical and Functional.
  • Responsible for complete App Support in terms of Planning, Developing, Testing, and Delivering the IN / SR / MCR /CR.
  • Involved in major projects like Data model migration from BW 3.5>BW 7.0 and performance Optimization project (Rapid growth of data load performance, reduced running time from 7hrs to 3hrs).
  • Worked extensively on ABAP.
  • Involved in writing start routines, end routines, expert routines, and customer exists.
  • Involved in creating custom and enhanced data sources by writing function modules.
  • Handling P1 tickets and resolving them without SLA breach.
  • Upgrade BW 7.0, 7.4 SP07 & ECC 6.0 EHP3àECC 6.0 EHP7.
  • Involved in Pre & Post Upgrade activities of BW & ECC.
  • Involved in Unit Testing and Business Acceptance Testing using the Qualifier tool.

Lead Technical Consultant

Pall Corporation
India
01.2015 - 05.2015
  • Upgrade BW 7.0à7.4 SP07 & ECC 6.0 EHP3àECC 6.0 EHP7.
  • Involved in Pre & Post Upgrade activities of BW & ECC.
  • Completely responsible for testing of BW objects, Test cases & end - end scenarios.
  • Identified and resolved issues while upgrading.
  • Responsible for complete upgrade activities.
  • Testing, Analysis & identifying solutions for the objects affected during the upgrade.
  • Involved in SPDD & SPAU activities.

SAP Technical Consultant

Magneti Marelli
Germany
05.2013 - 09.2014
  • Interacting with the business users in the relevant functional area and understanding their business processes, current pain points, and business requirements.
  • Responsible for gathering business requirements, defining deliverables, and functional analysis for new enhancements.
  • Responsible for blueprinting, and gap analysis between requirements and available BW functionality.
  • Participates in architecture and design of solution leads module level design and implementation.
  • Writes functional specifications to address the “gaps.”
  • Set up test scenarios, and test cases and either perform or support some or all of Unit Testing, Integration Testing, and User Acceptance Testing.
  • Identifying and resolving BI Performance issues and BI maintenance activities.
  • Designed and developed Bex reports & BO dashboards for Consignment Stock reports and ABC classification reports.
  • Involved in writing ABAP customer exits and routines.
  • Designed and developed custom extractors to create complex reports using Bex such as MRP reports, planning reports, and Obsolescence analysis reports.
  • Designed and developed Bex reports such as Daily & Monthly Stock reports, and Movements count reports by implementing SAP standard SD & MM Data Sources.
  • Fully involved in setting up the BW quality system in the existing landscape.
  • Interacting with the business users in the relevant functional area and understanding their business processes, current pain points, and business requirements.
  • Migration of existing BW 3.5 objects to BI 7.0.
  • Complete responsibility for the transport management system.
  • Responsible for solving level 1 technical issues.
  • SPOC for all BW-related activities.

SAP BW Consultant

Aegis, Essar Group
India
12.2011 - 04.2013
  • Preparing Technical specifications based on Functional Specifications.
  • Installing Business Content Data Sources as per the requirements.
  • Configured data sources in ECC by using LO Cockpit (LBWE) and initialized the Set-up tables.
  • Scheduled and Implemented delta mechanism for periodic loads.
  • Involved in extracting Business Content Data Sources like FI-AP, FI-AR, and FI-GL.
  • Created custom queries and defined Calculated Key figures and Restricted Key figures, Conditions and Exceptions, Text and Characteristics Value variables with Customer Exit, etc.
  • Led the offshore BI team and was responsible for the deliverables in BI for different verticals in ESSAR Group: ESSAR Steel, ESSAR Oil & ESSAR Power.
  • Involved in Monitoring and Handling tickets posted by the end user.
  • Monitoring of data loads and analyzing the reasons for frequent failures of data loads.
  • Resolving critical production failures & informing the client of the reason & how it was rectified.
  • Handled the tickets of priority 1, 2, and 3 by following (SOP) Standard Operating Procedures and never breached any Sever Level Agreement (SLA).
  • Maintain a list of all the activities for all the tickets until it is closed down.
  • Supported the client by providing long-term solutions to the tickets by doing Root cause Analysis.
  • Debugging and understanding code mal functions in ABAP code.
  • Checking the daily schedule for the run & ensuring that the jobs are finished within the specified time frame.
  • Actively and regularly involved in load monitoring of Daily and Monthly data loads using Process Chains.
  • Maintaining Reconciliation to verify the data in R/3 and SAP BW are the same or not after the data load.
  • Worked with Information Broadcasting, where we distributed BI information to different users in different formats and different schedules.

SAP Consultant

Lonza Walkersville
Switzerland
12.2010 - 12.2011
  • Understanding technical aspects of the current BW system.
  • Identifying and improving data load & reporting performances wherever required.
  • Understanding customer current pain points in using existing BW reports and making changes wherever required.
  • Resolving delta issue for payment management (Changed the design of payment management without disturbing existing reports to reduce process chain runtime from 16 hours to 2 hours).
  • Migration of several applications from BW 3.5 to BI 7.0.
  • Responsible for creating and delivering critical sales and financial reports which help customers in analyzing and improving the sales performances globally for all verticals.
  • Weekly interaction with the customers in Switzerland & USA for status updates to deliver better quality reports.
  • Involved in creating Global Sales Reporting for LBS, LSIM, and LSIN/P.

Software Engineer

Automotive Lighting
Germany
11.2008 - 11.2010
  • Responsible for BW Implementation by integrating 8 SAP & 1 non-SAP system which helps customer reduce their manual activities.
  • Understanding the customer needs and fulfilling their requirements by implementing necessary standard and custom reports in BW.
  • Creation of several reports based on the logistics module which helps customers to analyze the stock and material movements globally.
  • Identifying and fulfilling the gaps between the requirements and available BW functionality.
  • Involved in the data extraction of standard application components like LO (SD, MM), FI, and COPA.
  • Worked on Flat file extraction for SIGIP data.
  • Involved in creating custom KPI reports like Material consumption and forecast using generic data sources.
  • Creating, scheduling, and monitoring process chains for data loads.
  • Involved in activities like the creation of source systems, and RFC connections in SAP systems.
  • Worked extensively on Bex Broadcasting (Settings, scheduling the reports, broadcasting query in graphical format).
  • Worked extensively on Currency Translations.
  • Worked on RRI (Report to report interface to call other reports from one single report).
  • Worked on aggregates and indexes for performance optimization.
  • Responsible for Transport Management for all objects till Production.
  • Installation and activation of business content.

Technical Manager

Swingwind Technologies
01.2005 - 02.2007
  • Team Size 08.
  • Design and development of online exam software using Adobe Flex and open-source database.
  • Interacting with graduate students to understand the nature of competition in pursuing jobs.
  • Seminars and demonstrations of products in Universities and Engineering colleges.

Skills

Technical skills

Big Data and Cloud Platforms

  • Databricks: Proficient in leveraging the Databricks Lakehouse Platform, including workspace navigation, notebook development, cluster management, and job scheduling
  • PySpark: Extensive experience in developing and optimizing data processing and analytics applications using PySpark, including RDDs, DataFrames, Spark SQL, and performance tuning
  • Snowflake: expertise in Snowflake DB, including virtual warehouse sizing and management, zero-copy cloning, time travel, data sharing, and implementing HVR replication
  • SAP HANA: in-depth knowledge of HANA architecture, SAP HANA database administration, and development using HANA Studio, skilled in creating calculation views (graphical and SQLScript), attribute views, analytical views, and implementing complex joins, and data modeling
  • SAP HANA replication: experienced with SAP Landscape Transformation (SLT), SAP Direct Extractor Connection (DXC), and SAP Data Services for data replication into HANA

Business intelligence and data warehousing

  • SAP BW on HANA: a comprehensive understanding of SAP BW on HANA, including SAP HANA-optimized DataStore Objects (DSOs), InfoCubes, semantically partitioned objects (SPOs), and advanced data modeling concepts
  • SAP BusinessObjects (BO BI): skilled in using SAP BO BI tools, including Information Design Tool (IDT) for universe design, Web Intelligence (WEBI) for ad-hoc reporting, SAP Dashboards (formerly Xcelsius), SAP Lumira/Explorer, and Analysis for Office/OLAP
  • Power BI: Proficient in developing end-to-end Power BI solutions, including creating robust data models, utilizing Power Query for data transformation, configuring gateways for data refresh, implementing Row-Level Security (RLS), managing workspaces, and developing reports for mobile applications, with a strong command of DAX functions for complex calculations
  • dbt (Data Build Tool): experience with dbt Cloud for building, testing, and deploying SQL-based data transformation pipelines, particularly in conjunction with cloud data warehouses like Snowflake

Data manipulation and programming

  • SQL & scripting: advanced SQL scripting skills, including writing and optimizing stored procedures, table functions, scalar functions, window functions, and dynamic SQL
  • SAP ABAP: Experience with BW ABAP transformation routines, customer exits in BEx, data source enhancements, Data Transfer Process (DTP) routines, and Integrated Planning (IP) routines

Reporting and analysis tools

  • SAP BEx tools: proficient in SAP Business Explorer (BEx) suite, including BEx Query Designer for creating complex queries, calculated key figures (CKFs), restricted key figures (RKFs), structures, variables, BEx Analyzer for Excel integration, BEx Broadcaster, and developing web reports

Certification

  • SAP Certified Application Associate - Reporting/Modelling and Data Acquisition with SAP BW/4HANA 2.x
  • SAP Certified Application Associate - SAP Analytics Cloud
  • MCSA (Microsoft Certified System Administrator)
  • MCP (Microsoft Certified Professional)

Timeline

Principal Consultant

Heidelberg Materials
03.2024 - Current

Principal Consultant

Luxottica
07.2022 - 03.2024

Principal Consultant

Zimmer Biomet
09.2021 - 06.2022

Lead Technical Consultant

AstraZeneca
01.2018 - 08.2021

Lead Technical Consultant

Wales and West Utilities
06.2015 - 12.2017

Lead Technical Consultant

Pall Corporation
01.2015 - 05.2015

SAP Technical Consultant

Magneti Marelli
05.2013 - 09.2014

SAP BW Consultant

Aegis, Essar Group
12.2011 - 04.2013

SAP Consultant

Lonza Walkersville
12.2010 - 12.2011

Software Engineer

Automotive Lighting
11.2008 - 11.2010

Technical Manager

Swingwind Technologies
01.2005 - 02.2007

Similar Profiles

CREATE PROFILE
Ajay Babu Daggubati