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

Syam Vemula

Verified Expert  in Engineering

Data Engineer and Developer

Location
Hyderabad, Telangana, India
Toptal Member Since
June 18, 2020

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

Logitix - Main
Azure Data Factory, Azure, Snowflake, Data, SQL, Python, Data Engineering, ETL...
Laerdal Medical
Azure, Data, SQL, Azure Blob Storage API, Databricks, Azure Data Factory...
ContractPod Technologies Limited
Microsoft Power BI, DAX, Azure Data Factory, Azure SQL Databases...

Experience

Availability

Full-time

Preferred Environment

Microsoft Power BI, DevOps, Azure, Snowflake, Azure Analysis Services, Azure Data Factory, 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

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, Azure, Snowflake, Data, SQL, Python, Data Engineering, ETL, Hadoop, Apache Spark, Kibana, ETL Implementation & Design, ETL Testing, Azure Synapse, Data Management

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, 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

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, 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, 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, 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, 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, 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, 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

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.
2007 - 2011

Bachelor's Degree in Computer Science Engineering

Jawaharlal Nehru Technological University, Kakinada - Kakinada, India

DECEMBER 2021 - PRESENT

Microsoft Certified: Azure Fundamentals

Microsoft

MARCH 2014 - PRESENT

MCSE: Business Intelligence

Microsoft

AUGUST 2013 - PRESENT

MCSA: SQL Server 2012/2014

Microsoft

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++

Platforms

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

Paradigms

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

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, 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, OCR, 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