Summary
Overview
Work History
Education
Skills
Timeline
Generic
Bharghav Tammina

Bharghav Tammina

Senior Software Developer
Chennai

Summary

Results-driven Professional Developer with 4 years of IT experience specializing in Database Design, Development, Implementation, and Maintenance. Proficient in analyzing and maintaining database applications within SQL Server 2016/2018 in an OLAP/BI environment. Demonstrated expertise in utilizing the Microsoft SQL Server Business Intelligence suite, encompassing SSIS, SSRS, Azure Data Factory (ADF), PowerBI, and Snowflake for OLAP, Data Marts, ODSI, Slowly Changing Dimensions, Data Cleansing, and Data Migration.

Overview

4
4
years of professional experience
4
4
Languages

Work History

ADF Developer

HCLTECH
03.2023 - Current


  • Client: Nestle
  • Project: ARF(Application Reporting Framework
  • Building pipelines to copy the data from source to destination and created dependencies in Azure Data factory.
  • Moving data from Azure SQL DB to Azure Blob storage with the help of pipelines and data flows
  • Moving CSV files from Azure blob to WebUI.
  • Implemented Azure Logic Apps and Functions to automate business processes and improve efficiency.
  • Developed integration solutions using Logic Apps and APIs to connect disparate systems and automate data flows.
  • Created automated workflows with the help of triggers.
  • Scheduling Pipelines and monitoring the data movement from source to destinations.
  • Transforming data in Azure Data Factory with the ADF Transformations.
  • Troubleshoot any kind of data issues or validation issues.
  • Develop and unit test application programs as specified in Technical Designs
  • Collaborated with cross-functional teams to ensure seamless integration of new features.
  • Conducted data modeling, performance and integration testing.
  • Debugged complex software issues, leading to a more stable product release.
  • Participated in regular code reviews, ensuring high-quality standards were consistently met across all development efforts.
  • Documented software development methodologies in technical manuals to be used by IT personnel in future projects.
  • Tested and deployed scalable and highly available software products.

SSIS Developer

HCL Tech
01.2022 - 03.2023
  • Client: Nestle
  • Project: ARF(Application Reporting Framework)
  • SSIS Package Development: Created SSIS package to load data from flat file and XML file to report Datamart and DWH.
  • Implemented configuration for data viewers and logging and error during the package handling.
  • Migrated SSIS package from older version to new version.
  • Designing BI solutions with Microsoft SQL Server 2016 and 2018.
  • Strong Experience in MS SQL DB, Stored Procedures, SSIS ETL.
  • Have a participated in all phases of Software Development Lifecycle (SDLC).
  • Experience in working in Agile teams, able to lead a team and working independently.
  • Resolved data issue after unit testing and documentation of system for ETL process.
  • Developed reusable components in SSIS to minimize development efforts across multiple projects.
  • Managed end-to-end ETL process from source systems to the data warehouse, ensuring optimal performance and data quality.
  • Streamlined ETL processes for faster data extraction, transformation, and loading.
  • Worked closely with database administrators to optimize SQL queries for improved performance in SSIS packages.
  • Performed regular database backups to prevent information loss.

Snowflake Developer

HCL Tech
06.2021 - 01.2022
  • Client: Nestle
  • Project: CX Mono
  • Snowflake Developer: Bulk loading from the Blob storage to the snowflake internal stage using the ADF pipeline.
  • Loading data into snowflake tables from the internal stage using snowsql.
  • Used COPY, LIST, PUT and GET commands for validating the internal stage files.
  • Used import and Export from the internal stage (snowflake) from the external stage.
  • Developed snowflake procedures for executing branching and looping.
  • Transferring data using the PT framework from STG to INT.
  • Created clone objects to maintain zero-copy cloning.
  • Data validations have been done through information schema.
  • Provide support of production applications by trouble shooting issues, and developing, testing and migration of Data.
  • Gathering requirements from the client and implementing them as tasks as per requirements.
  • Understand the business processes and application functionality and delivering the workloads before the deadlines.


Education

Bachelor of Technology - Mechanical Engineering

Kalinga University
Raipur, India
04.2001 -

Skills

  • Azure Data Factory(ADF)
  • Databricks
  • Pyspark
  • SQL
  • SSIS
  • PowerBI
  • Snowflake
  • Python
  • Software development
  • Big data analytics
  • Agile methodologies
  • CI/CD
  • Development lifecycle management

Timeline

ADF Developer

HCLTECH
03.2023 - Current

SSIS Developer

HCL Tech
01.2022 - 03.2023

Snowflake Developer

HCL Tech
06.2021 - 01.2022

Bachelor of Technology - Mechanical Engineering

Kalinga University
04.2001 -
Bharghav TamminaSenior Software Developer