Syam is available for hire
Hire SyamSyam 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
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.
Skills
Languages
SQL, T-SQL (Transact-SQL), Python, Snowflake, JavaScript, HTML, C, C++
Tools
Azure Logic Apps, Microsoft Power BI, Qlik Sense, Looker, BigQuery, Kibana
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
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
Frameworks
Spark, Hadoop, Apache Spark
Libraries/APIs
REST APIs, Azure Blob Storage API
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
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