Data Engineer and Developer
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.
ExperienceETL 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 years
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.
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.
Senior Data Engineer | Tech Lead
- 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.
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.
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.
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.
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.
Pramati Technologies Pvt Limited
- Developed multiple reporting dashboards.
- Created stored procedures and functions.
- Developed ETL solutions.
- Developed a data warehouse solution.
- Created a reusable deployment tool for databases and cubes.
- Built a SharePoint website.
Migration of On-premise Databases to Microsoft Azure Cloud
Data Warehouse Solution for a US Sales Organization
Data Warehouse Architecture for a Marking Platform
- 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.
SQL, Stored Procedure, T-SQL (Transact-SQL), Snowflake, Python
QuickBooks API, Walmart API, REST APIs, Azure Blob Storage API
Azure Logic Apps, Microsoft Power BI, Power Query
ETL, Business Intelligence (BI), DevOps
Azure, Azure Functions, Databricks, Azure Event Hubs
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
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
Bachelor's Degree in Computer Science Engineering
Jawaharlal Nehru Technological University, Kakinada (JNTU) - Kakinada, India
Microsoft Certified: Azure Fundamentals
MCSE: Business Intelligence
MCSA: SQL Server 2012/2014