Syam Vemula, Developer in Hyderabad, Telangana, India
Syam is available for hire
Hire Syam

Syam Vemula

Verified Expert  in Engineering

Bio

Syam is a data engineer with seven years of experience using Azure: SQL, Synapse, Data Lake, and Data Factory to design, build, and implement data analytics, database solutions, and Power BI reporting dashboards, including embedded analytics. He's also proficient in creating and maintaining SQL Server databases and developing T-SQL stored procedures and functions. Since 2011, Syam has developed continuously with the Microsoft BI stack, building data models and reports.

Portfolio

Ray Business Technologies
Azure Synapse, Snowflake, Microsoft Power BI
Logitix - Main
Azure Data Factory (ADF), Azure, Snowflake, Data, SQL, Python, Data Engineering...
Laerdal Medical
Azure, Data, SQL, Azure Blob Storage API, Databricks, Azure Data Factory (ADF)...

Experience

  • SQL - 12 years
  • ETL Development - 12 years
  • Azure SQL Databases - 6 years
  • Azure SQL - 6 years
  • Azure Data Factory (ADF) - 6 years
  • Microsoft Power BI - 6 years
  • Data Modeling - 6 years
  • Azure - 6 years

Availability

Full-time

Preferred Environment

Microsoft Power BI, DevOps, Azure, Snowflake, Azure Analysis Services, Azure Data Factory (ADF), Azure Data Lake, Azure Data Lake Analytics, Azure Functions, Azure SQL Databases

The most amazing...

...thing I've worked on was a data warehouse project where I became an expert on Power BI, Data Factory, Azure Functions, Databricks, DWH, SSIS, and Snowflake.

Work Experience

Senior Consultant

2023 - 2024
Ray Business Technologies
  • Developed an end-to-end data warehouse for an eCommerce application using Snowflake.
  • Built five critical Power BI dashboards for day-to-day monitoring.
  • Implemented full-cycle deployment for cloud services in Azure and Power BI reporting infrastructure.
  • Architected and oversaw multi-cloud data infrastructures, enabling enterprise-level analytics.
  • Led governance strategies to ensure data integrity, security, and compliance across AWS and Azure.
  • Engineered high-performance ETL workflows using dbt, Python, PySpark, and Redshift.
Technologies: Azure Synapse, Snowflake, Microsoft Power BI

Data Engineer

2023 - 2023
Logitix - Main
  • Developed a web app to manage the clients, jobs, and job experts.
  • Enhanced the ADF pipelines to reschedule in an optimized way.
  • Tracked and managed the work deliverables for the web app features.
Technologies: Azure Data Factory (ADF), Azure, Snowflake, Data, SQL, Python, Data Engineering, ETL, Hadoop, Apache Spark, Kibana, ETL Implementation & Design, ETL Testing, Azure Synapse, Data Management, Data Build Tool (dbt), Analytical Thinking

Data Engineer

2021 - 2023
Laerdal Medical
  • Developed a data set to view the sales performance of the Brazil and US regions against other countries using Azure Data Factory, Synapse, and Azure SQL.
  • Fixed numerous bugs in the data model and streamlined and automated the deployment process.
  • Built an automated test process to validate the loaded data.
  • Designed and developed using a data modeling technique to analyze the sales information for Brazil.
Technologies: Azure, Data, SQL, Azure Blob Storage API, Databricks, Azure Data Factory (ADF), Azure Stream Analytics, Azure Data Lake Analytics, Azure Event Hubs, Azure SQL, Microsoft Power BI, Azure SQL Databases, ETL Development, T-SQL (Transact-SQL), Data Modeling, Databases, Database Design, Database Transactions, Data Engineering, Database Structure, Microsoft Azure, ETL Implementation & Design, ETL Testing, Python, Master Data Management (MDM), Data Analytics, Database Migration, Azure Databricks, Azure Synapse, Spark, Data Management, Analytical Thinking

Microsoft Power BI Elite Engineer

2020 - 2023
ContractPod Technologies Limited
  • Built a Microsoft Power BI dashboard to get insights for each client as part of the product feature. Later, I migrated the reporting dashboard to Qlik and was involved in end-to-end activities to deliver the reports on the new platform.
  • Used Bitbucket, Jira, and Confluence for project management.
  • Accomplished the reporting dashboard feature for each client to access the data securely as part of product rollout.
Technologies: Microsoft Power BI, DAX, Azure Data Factory (ADF), Azure SQL Databases, ETL Development, T-SQL (Transact-SQL), SQL, Azure, Qlik Sense, Microsoft Azure, Google Data Studio, QlikView, Python, Master Data Management (MDM), Data Analytics, Database Migration, SQL Stored Procedures

Senior Data Engineer | Tech Lead

2017 - 2021
Airliquide
  • Migrated on-premise traditional data warehouse solution to Azure cloud.
  • Tracked and fixed issues using ServiceNow and managed the project activities integrated into Trello cards for easy follow-ups.
  • Used Azure DevOps to deploy Azure Data Factory, Azure SQL database, Azure SQL Data Warehouse, and Azure functions.
Technologies: Azure, Azure Analysis Services, Azure Data Factory (ADF), Azure Data Lake, Azure Functions, Azure Blobs, Azure SQL, Azure Logic Apps, Business Intelligence (BI), Data Warehousing, Snowflake, Data Architecture, Data Integration, SQL, Microsoft SQL Server, Data Pipelines, Python, Database Optimization, Data Visualization, Dashboards, Data Analysis, Microsoft Power BI, Azure SQL Databases, ETL Development, T-SQL (Transact-SQL), Data Modeling, Databases, Database Design, Database Transactions, Data Engineering, Database Structure, Microsoft Azure, ETL Implementation & Design, ETL Testing, Google BigQuery, BigQuery, Optical Character Recognition (OCR), Google Cloud Platform (GCP), Data Analytics, Database Migration, Amazon S3 (AWS S3), Azure Databricks, SQL Stored Procedures

Data Engineer

2019 - 2019
Decentral Park Advisors LLC
  • Gathered requirements for developing a dashboard for different categories of data.
  • Understood the existing conventional Excel report and identified the areas to generate the datasets to develop the Power BI report.
  • Worked on an Azure SQL database to capture the data and store it in tables.
  • Created a data model along with the required calculated columns and measures using DAX in Power BI to generate the mockup report pages aligned with the Excel report.
  • Worked on a set of Power BI report pages by using the generated data model.
Technologies: Azure SQL Databases, REST APIs, Azure SQL, Microsoft Power BI, Data Visualization, Dashboards, Data Analysis, ETL Development, T-SQL (Transact-SQL), SQL, Databases, Database Design, Database Transactions, Data Engineering, Database Structure, Microsoft Azure, SQL Stored Procedures

Data Warehouse Architect

2019 - 2019
Gerse Jongens Communicatie B.V.
  • Supported an in-house application database design.
  • Developed a data warehouse for reporting purposes in an Azure cloud environment.
  • Wrote Microsoft Power BI reports and supported embedding them into a web application.
  • Helped set up an Azure environment for databases and a data factory.
  • Created Azure Data Factory pipelines to load data from different source systems.
Technologies: Business Intelligence (BI), Azure SQL Databases, Azure SQL, ETL, Microsoft SQL Server, Azure Data Factory (ADF), Microsoft Power BI, Data Warehousing, Azure, Data Visualization, Dashboards, Data Analysis, ETL Development, T-SQL (Transact-SQL), SQL, Data Modeling, Databases, Database Design, Database Transactions, Data Engineering, Database Structure, Microsoft Azure, SQL Stored Procedures

Freelance Power BI Database Developer

2017 - 2017
Brightfield Group
  • Converted R script business rules corresponding to SQL rules.
  • Built Azure Data Factory pipelines to process those rules without manual interaction.
  • Designed reporting tables to pivot and unpivot data.
Technologies: Business Intelligence (BI), Azure SQL Databases, T-SQL (Transact-SQL), Azure SQL, Microsoft Power BI, Azure Data Factory (ADF), Data Analysis, SQL

Senior Microsoft BI Consultant

2015 - 2017
InfoMagnus
  • Designed a data warehouse solution for one of the largest healthcare organizations in the US.
  • Created a database solution for loading web data and generating reports.
  • Developed an ETL tool to load quarterly data from community banks.
  • Built a couple of Power BI dashboards for a transportation organization.
Technologies: ETL, Data Warehousing, Business Intelligence (BI), Azure, Azure SQL Databases, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Microsoft SQL Server, Azure Data Factory (ADF), Microsoft Power BI, Azure SQL, T-SQL (Transact-SQL), SQL, Data Modeling, ETL Development, Microsoft Azure, Looker

Senior Developer

2014 - 2015
Pramati
  • Built multiple reporting dashboards using the SSRS reporting tool.
  • Created stored procedures and functions to support the reports.
  • Developed an ETL solution to extract and transform data using SSIS.
Technologies: ETL, Business Intelligence (BI), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), T-SQL (Transact-SQL), SQL, Data Modeling, ETL Development

Software Engineer

2011 - 2014
MAQ Software, LLC.
  • Developed a data warehouse solution for an SQL Server product for one of the top 50 companies.
  • Created a reusable deployment tool for databases and cubes.
  • Built a SharePoint website to display the developed SSRS reports.
Technologies: ETL, Business Intelligence (BI), Azure SQL, Microsoft Power BI, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), T-SQL (Transact-SQL), SQL, ETL Development

Experience

Migration of On-premise Databases to Microsoft Azure Cloud

A project completely built on a Microsoft Azure cloud environment. I designed the database and set it up in Azure. The legacy app's back end was in an on-premise environment, and I completely owned the lift and shift to the Azure cloud.

Data Warehouse Solution for a US Sales Organization

A Power BI-based project for a US-based client. I worked in multiple areas such as SSIS, SSAS, SSRS, tabular models, DAX, and so on. This project involved pulling a huge amount of data from the source and then building cubes and, later, SSRS and Excel reports. On top of that, I also worked with the Agile methodology.

Data Warehouse Architecture for a Marking Platform

My role in this project consisted of supporting an in-house application database design and developing a data warehouse for reporting purposes in an Azure cloud environment. I also wrote Power BI reports and supported their embedding in a web application. I helped set up an Azure environment for databases and a data factory. Finally, I created Azure Data Factory pipelines to load data from different source systems.

Education

2007 - 2011

Bachelor's Degree in Computer Science Engineering

Jawaharlal Nehru Technological University, Kakinada - Kakinada, India

Certifications

DECEMBER 2021 - PRESENT

Microsoft Certified: Azure Fundamentals

Microsoft

MARCH 2014 - PRESENT

MCSE: Business Intelligence

Microsoft

AUGUST 2013 - PRESENT

MCSA: SQL Server 2012/2014

Microsoft

Skills

Libraries/APIs

REST APIs, Azure Blob Storage API

Tools

Azure Logic Apps, Microsoft Power BI, Qlik Sense, Looker, BigQuery, Kibana

Languages

SQL, T-SQL (Transact-SQL), Python, Snowflake, JavaScript, HTML, C, C++

Paradigms

ETL, Business Intelligence (BI), Database Design, ETL Implementation & Design, DevOps

Platforms

Azure, Azure Functions, Databricks, QlikView, Azure Synapse, Google Cloud Platform (GCP), Azure Event Hubs

Storage

SQL Server Integration Services (SSIS), Azure SQL, SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Azure SQL Databases, Azure Blobs, Data Integration, Microsoft SQL Server, Data Pipelines, Databases, Master Data Management (MDM), Database Migration, Amazon S3 (AWS S3), SQL Stored Procedures, Database Transactions, Database Structure

Frameworks

Spark, Hadoop, Apache Spark

Other

ETL Development, Azure Data Factory (ADF), Google Data Studio, MSBI, Azure Analysis Services, Microsoft Azure, Data Warehousing, Data Modeling, Database Optimization, Data Visualization, Dashboards, Data Analysis, Data Engineering, ETL Testing, Data Analytics, Azure Databricks, Data Management, Azure Data Lake, Azure Data Lake Analytics, Data Architecture, Google BigQuery, Optical Character Recognition (OCR), Data Build Tool (dbt), Analytical Thinking, DAX, Data, Azure Stream Analytics

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring