Bhargav K Email & Phone Number

United States

Led the design, development, and optimization of scalable data architectures, focusing on data ingestion, storage, and transformation processes using cloud-based platforms like AWS, Azure, GCP and Snowflake. Expertise in building and optimizing complex ETL pipelines for processing large volumes of structured and unstructured data across diverse environments.Developed and deployed end-to-end data pipelines using Data Factory, Databricks, and Apache Spark, ensuring seamless data extraction, transformation, and loading (ETL) from various sources such as SQL Server, Oracle, SAP, and cloud-based data lakes. Automated data workflows using Airflow and integrated external APIs for real-time data streaming using Python.Utilized Power BI and Tableau to design and deliver comprehensive data visualizations, enabling data-driven decision-making and performing in-depth analysis on data relationships, trends, and dependencies. Implemented reporting solutions by integrating with enterprise data warehouses to deliver actionable insights across business domains, including finance and healthcare.Provided leadership in defining best practices for data engineering, including data quality management, performance optimization, and security compliance. Mentored junior data engineers, conducted peer reviews, and ensured the alignment of data pipelines with business goals.Supported production operations by debugging complex data workflows, ensuring real-time data availability, and maintaining integration across environments using Unix, Shell Scripting, and DevOps. Focused on ensuring high availability, performance tuning, and data integrity across cloud and on-premise systems.

Developed and optimized data models and database objects such as Tables, Views, Stored Procedures, Functions, Joins, Indexes, and Triggers in SQL, ensuring high performance, data integrity, and stability across enterprise systems. Expertise in query optimization and performance tuning to handle large datasets and complex queries.Designed and implemented ETL processes using cloud platforms to validate, extract, transform, and load data from multiple sources, including flat files, Excel, and SQL Server. Managed incremental data loads and implemented Slowly Changing Dimensions (SCD) Type 2 for tracking historical data changes efficiently.Automated data workflows by scheduling ETL jobs using Airflow and SQL Agent, improving data flow efficiency across cloud and on-premise environments. Developed custom ETL solutions for data migration and integration with external APIs.Extensively worked with data modeling and analytics tools , building OLAP cubes, tabular models, and writing DAX expressions to support complex business reporting and analytics needs.Designed interactive dashboards and parameterized reports using Power BI and SSRS, providing drill-down capabilities and delivering actionable insights to stakeholders. Ensured data consistency and accuracy through rigorous testing and validation processes.Collaborated with cross-functional teams to streamline data pipelines and ensure alignment with business goals, contributing to continuous improvement of data integration and reporting solutions across various domains.

ETL and Data Integration: Developed and automated ETL workflows using SSIS to integrate data from diverse sources, improving data accuracy and enabling centralized analytics in a data warehouse environment.Database Design and Optimization: Designed and optimized OLTP and OLAP databases, boosting data retrieval efficiency and reducing redundancy, while supporting business needs for reporting and analytics.SQL Development and Performance Tuning: Created complex T-SQL queries and optimized data loading, cutting batch job execution time by 30%, reducing storage costs, and enhancing overall SQL Server performance.Reporting and Visualization: Delivered automated, interactive SSRS reports and dynamic Tableau dashboards, empowering stakeholders with real-time insights into key business metrics.Data Security and Compliance: Implemented role-based access control and data encryption in SQL Server, ensuring compliance with GDPR and industry standards across reporting solutions.Proficient in Databricks for big data processing, utilizing Apache Spark to handle large-scale data transformations and optimize performance for real-time and batch processing needs.Adept at ensuring data quality, governance, and security, while collaborating with cross-functional teams to deliver end-to-end solutions that align with business goals and drive data-driven decision-making.

Experienced Data Engineer Consultant specializing in database migration projects, successfully migrating complex datasets from legacy systems to modern platforms ensuring minimal downtime and data integrity throughout the migration process.Expertise in SQL development for data transformation, migration, and optimization, designing and implementing high-performance queries, stored procedures, and database structures to ensure seamless data handling during migration.Proficient in creating and managing data pipelines to automate migration workflows, improve efficiency, and ensure compliance with data governance standards, ensuring a smooth transition to cloud architectures.Collaborated with cross-functional teams to assess, plan, and execute migration strategies, ensuring that business-critical data was migrated accurately, on time, and aligned with project goals while optimizing data storage and performance.

Master'S Degree, Computer Science

Bachelor’S Degree, Computer Science Engineering