Data Engineer
2019 - 2019Decentral 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 Azure SQL database to capture the data and store in tables.
- Created a data model along with required calculated columns and measures using DAX in Power BI to generate the mock-up report pages aligning to excel report.
- Worked on a set of Power BI report pages by using the generated data model.
Technologies: Azure SQL Databases, REST API, Azure SQL, Microsoft Power BIData Warehouse Architecture for a Marking Platform
2019 - 2019Gerse 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, SQL Azure, ETL, Microsoft SQL Server, Azure Data Factory, Microsoft Power BI, Data Warehousing, AzureFreelance Power BI Database Developer
2017 - 2017Brightfield 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, Azure SQL, Microsoft Power BI, Azure Data FactorySenior MSBI Consultant
2015 - 2017InfoMagnus 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, Business Intelligence (BI), Azure, Azure SQL Databases, SQL Azure, SSAS, SSRS, SQL Server Integration Services (SSIS), Microsoft SQL Server, Azure Data Factory, Microsoft Power BI, Azure SQLSenior Developer
2014 - 2015Pramati 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), SSRS, SQL Server 2012, T-SQLSoftware Engineer
2011 - 2014MAQ Software- Developed a data warehouse solution.
- Created a reusable deployment tool for databases and cubes.
- Built a SharePoint website.
Technologies: ETL, Business Intelligence (BI), SQL Azure, SharePoint, Microsoft Power BI, SSAS, SSRS, SQL Server Integration Services (SSIS), SQL Server 2012, T-SQL
Syam Vemula
Software Developer in Hyderabad, Telangana, India
Member since February 1, 2016
For the past four years, Syam's been using Azure services (Azure SQL, Data Warehouse, Data Lake and Data Factory) to design, build, 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, and since 2011, he's continuously worked on MSBI development (SSIS, SSAS, and SSRS).
Syam is now available for hire
Portfolio
- Decentral Park Advisors LLC (via Toptal)Azure SQL Databases, REST API, Azure SQL, Microsoft Power BI
- Gerse Jongens Communicatie BV (via Toptal)Business Intelligence (BI), Azure SQL Databases, SQL Azure, ETL...
- Brightfield Group (via Toptal)Business Intelligence (BI), Azure SQL Databases, T-SQL, Azure SQL...
Experience
- Business Intelligence (BI) 8 years
- T-SQL 8 years
- Microsoft Power BI 4 years
- Azure 4 years
- SQL Azure 4 years
- Azure SQL Databases 4 years
- Azure SQL 3 years
Availability
Part-time
Preferred Environment
Microsoft Power BI, SQL, DevOps, Visual Studio, Azure
The most amazing...
...thing I've worked on was a data warehouse project in which I became expert on Power BI, Azure DWH and MSBI Stack components: SSIS, SSRS, and SSAS.
Employment
Experience
- Migration of On-premise Databases to Microsoft Azure Cloud (Development)
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 (Development)
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.
Skills
Languages
C#, Stored Procedure, T-SQLFrameworks
ASP.NETLibraries/APIs
QuickBooks API, Walmart API, REST APITools
Azure Logic Apps, Microsoft Power BI, SSAS, SSRS, Visual StudioParadigms
Business Intelligence (BI), ETL, DevOpsPlatforms
Azure, Azure Functions, WindowsStorage
SQL Server Integration Services (SSIS), Azure SQL, SQL Azure, SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Azure SQL Databases, Microsoft SQL Server, Azure Blobs, SQL Server 2012, Azure Cloud ServicesOther
Azure Data Factory, Google Data Studio, MSBI, Azure Analysis Services, Microsoft Azure, Data Warehouse Design, Debugging, Azure Data Lake, Azure Data Lake Analytics, Data Warehousing, DAX
Education
- Bachelor's degree in Computer Science Engineering2007 - 2011Jawaharlal Nehru Technological University, Kakinada (JNTU) - Kakinada, India
Certifications
- MCSE: Business IntelligenceMARCH 2014 - PRESENTMicrosoft
- MCSA: SQL Server 2012/2014AUGUST 2013 - PRESENTMicrosoft
