Sangram Patro
Verified Expert in Engineering
Data Engineer and Azure Developer
Hyderabad, Telangana, India
Toptal member since September 30, 2021
Sangram is a seasoned IT industry professional with 14 years of experience specializing in data engineering. He possesses a diverse range of proficiencies, including but not limited to big data processing, SQL, No-SQL solutions, orchestration, and warehousing. He also has extensive experience in architect solutions and demonstrates strong programming skills. Sangram is well-versed in Azure Cloud too.
Portfolio
Experience
- Azure SQL - 11 years
- Azure - 9 years
- Azure Data Factory (ADF) - 8 years
- Solution Architecture - 7 years
- Azure Data Lake - 7 years
- Microsoft Power BI - 7 years
- Azure Databricks - 5 years
- Azure Synapse Analytics - 1 year
Availability
Preferred Environment
Windows
The most amazing...
...thing I've designed is column-level security on a data lake system using Azure Data Bricks with Scala and Python and also with Azure Synapse Analytics.
Work Experience
Senior Software Engineer
Information Technology Company
- Designed and implemented column-level security on an HR data lake system on top of Azure Data Lake Storage Gen 2. Used Azure Data Bricks with Scala and Python and also Azure Synapse analytics.
- Designed and developed a data catalog solution for the org so as to incorporate data discoverability of assets as part of their data governance journey.
- Applied engineering fundamentals to every problem statement, such as CI/CD, security, disaster recovery, and data quality, to deliver the right code the first time.
- Provided expertise in Azure Data Lake Storage Gen 2, SQL Server, MongoDB, Azure Cosmos DB, Azure Data Factory, Azure Synapse Analytics, Azure SQL DW, Azure Data Bricks using Scala, HIVE, Python, and Azure Purview, among others.
Senior Associate Software Engineer
Information Technology Company
- Managed a team of seven people to design and implement a disaster recovery solution and Microsoft Power BI solutions and develop pipelines using Azure Data Factory for loading and handling COSMOS data..
- Developed responses to RFPs for several clients. These included building Microsoft Power BI dashboards and defining rich metrics for the senior executives.
- Gained and applied diverse experience in data science and engineering, including Azure Data Factory, Azure Machine Learning, and PaaS.
- Managed software associates with proper planning and execution of activities across sprints.
Senior System Analyst Programmer
Accenture
- Implemented a compensation management system that enabled a Netherlands telecom company to pay 2,500 sales employees and business partners seamlessly.
- Automated payment processing by reading the raw payment files and using SSIS to process the data into a star schema data model. Developed subscription-based reports for effective payments based on sales.
- Communicated with clients regularly to understand their requirements and meet high-quality standards using Agile processes.
Senior Software Engineer
Infosys
- Implemented a supply chain visibility tool for managing the performance of products, customers, vendors, and employees.
- Managed the module inventory and handled inventory management for products.
- Led the end-to-end process and tools, including ideation, for a big project.
Experience
Human Rights
Education
Master's Degree in Business Management
Narsee Monjee Institute of Management Studies - Karnataka, India
Bachelor's Degree in Computer Science
National Institute of Science and Technology - Orissa, India
Certifications
Microsoft Azure Data Engineer Associate
Microsoft
Skills
Libraries/APIs
Azure Blob Storage API
Tools
Azure Monitor, Azure Key Vault, Microsoft Power BI, Azure IoT Hub
Languages
SQL, Python, Scala, C++, C, Batch
Paradigms
Business Intelligence (BI), ETL, Lambda Architecture
Platforms
Azure, Databricks, Azure Synapse, Windows, Azure Synapse Analytics, Azure Event Hubs, Azure SQL Data Warehouse, Dedicated SQL Pool (formerly SQL DW)
Storage
Azure SQL, Microsoft SQL Server, SQL Server Integration Services (SSIS), Azure SQL Databases, Azure Cosmos DB, Master Data Management (MDM), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL Server 2012
Frameworks
Apache Spark
Other
Azure Data Factory (ADF), Azure Data Lake, Design Documentation, Data Engineering, Azure Databricks, Solution Architecture, Architecture, Data Warehousing, Data Analytics, Data Analysis, Azure Analysis Services, Programming, Networking, Computer Architecture, Data Structures, Finance, Operations, Azure Stream Analytics, Containers
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring