Syam Vemula
Data Engineer and Developer
Location
Hyderabad, India
Toptal Member Since
June 18, 2020
For the past five years, Syam's been using Azure services including Azure SQL, data warehouse, data lake, and Data Factory to design, build, and implement data analytics, database solutions, and Power BI reporting dashboards, including Power BI embedded. He's also proficient in creating and maintaining SQL Server databases and developing T-SQL stored procedures and functions. Since 2011, Syam has continuously worked on MSBI development, including SSIS, SSAS, and SSRS.
Syam is available for hire
Hire SyamPortfolio
Laerdal Medical AS - Main
Azure, Data, SQL, Azure Blob Storage API, Databricks, Azure Data Factory...
Airliquide
Azure, Azure Analysis Services, Azure Data Factory, Azure Data Lake...
Decentral Park Advisors LLC (via Toptal)
Azure SQL Databases, REST APIs, Azure SQL, Microsoft Power BI...
Experience
ETL Development - 12 yearsSQL - 12 yearsT-SQL (Transact-SQL) - 12 yearsAzure SQL Databases - 6 yearsAzure Data Factory - 6 yearsMicrosoft Power BI - 6 yearsAzure SQL - 6 yearsAzure - 6 yearsLocation
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 in which I became an expert on Power BI, Data Factory, Azure functions, Databricks, DWH, SSIS, and Snowflake.
Work Experience
2021 - 2023
Data Engineer
Laerdal Medical AS - Main
- Developed a data set to view the sales performance of the Brazil and US region against other countries using ADF, Synapse, and Azure SQL.
- Fixed numerous bugs in the data model and streamlined/automated the deployment process.
- Built an automated test process to validate the loaded data.
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)
2017 - 2021
Senior Data Engineer | Tech Lead
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), Azure Cloud Services, Data Warehouse Design, Data Warehousing, Snowflake, Data Architecture, Data Integration, SQL, Microsoft SQL Server, Data Pipelines, Python, Data Modeling, Database Optimization, Data Visualization, Dashboards, Data Analysis, Microsoft Power BI, Azure SQL Databases, ETL Development, T-SQL (Transact-SQL)
2019 - 2019
Data Engineer
Decentral Park Advisors LLC (via Toptal)
- 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
2019 - 2019
Data Warehouse Architecture for a Marking Platform
Gerse Jongens Communicatie BV (via Toptal)
- Supported an in-house application database design.
- Developed a data warehouse for reporting purpose in an Azure cloud environment.
- Wrote Power BI reports and supported the embedding of them in a web application.
- Helped to 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 Warehouse Design, Data Warehousing, Azure, Data Visualization, Dashboards, Data Analysis, ETL Development, T-SQL (Transact-SQL), SQL
2017 - 2017
Freelance Power BI Database Developer
Brightfield Group (via Toptal)
- Converted R script business rules corresponding 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
2015 - 2017
Senior MSBI Consultant
InfoMagnus Technolgies Pvt Limited
- Developed a data warehouse solution to one of the largest healthcare organizations in the U.S.
- Created a database solution for loading web data and developing 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, Data Warehouse Design, Business Intelligence (BI), Azure, Azure SQL Databases, SSAS, 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
2014 - 2015
Senior Developer
Pramati Technologies Pvt Limited
- Developed multiple reporting dashboards.
- Created stored procedures and functions.
- Developed ETL solutions.
Technologies: ETL, Business Intelligence (BI), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server 2012, T-SQL (Transact-SQL), SQL
2011 - 2014
Software Engineer
MAQ Software
- Developed a data warehouse solution.
- Created a reusable deployment tool for databases and cubes.
- Built a SharePoint website.
Technologies: ETL, Business Intelligence (BI), Azure SQL, SharePoint, Microsoft Power BI, SSAS, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server 2012, T-SQL (Transact-SQL), SQL
Experience
Migration of On-premise Databases to Microsoft Azure Cloud
This project is 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
This was a BI-based project for a US-based client. Here, 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.
- Developing a data warehouse for reporting purposes in an Azure cloud environment.
- Writing Power BI reports and support their embedding in a web application.
- Helping to set up an Azure environment for databases and a data factory.
- Creating Azure Data Factory pipelines to load data from different source systems.
- Supporting an in-house application database design.
- Developing a data warehouse for reporting purposes in an Azure cloud environment.
- Writing Power BI reports and support their embedding in a web application.
- Helping to set up an Azure environment for databases and a data factory.
- Creating Azure Data Factory pipelines to load data from different source systems.
Skills
Languages
SQL, Stored Procedure, T-SQL (Transact-SQL), Snowflake, Python
Libraries/APIs
QuickBooks API, Walmart API, REST APIs, Azure Blob Storage API
Tools
Azure Logic Apps, Microsoft Power BI, Power Query
Paradigms
ETL, Business Intelligence (BI), DevOps
Platforms
Azure, Azure Functions, Databricks, 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
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, Debugging, Azure Data Lake, Azure Data Lake Analytics, Data Architecture, DAX, Data, Azure Stream Analytics
Education
2007 - 2011
Bachelor's Degree in Computer Science Engineering
Jawaharlal Nehru Technological University, Kakinada (JNTU) - 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