Ashir K.

Need scalable data pipelines that actually work? I help companies streamline data workflows from messy raw to clean gold using industry-best engineering practices.💡 Free 30-min consultation to audit your pipeline or discuss architecture. 🎥 Want a Loom video of a similar project? Just ask. I am a "Top Rated Data Engineer" with over 5 years of experience in the field. I specialize in designing and implementing end-to-end data solutions that drive business value, specifically for Data Lake and Data warehousing purposes. Whether it's optimizing data retrieval performance or delivering successful projects for clients. 𝐄𝐱𝐩𝐞𝐫𝐭𝐢𝐬𝐞: ✅ Building and architecting multiple Data pipelines, end-to-end ETL processes for Data ingestion and transformation in MS Azure (Data Factory & Synapse) & AWS Glue. ✅ Handling diverse data formats - Excel, JSON, XML, and various DB files. ✅ Experience in Migrating SQL databases to Azure cloud, Azure Data Lake, Azure Data Lake Analytics, Azure SQL Database, Data Bricks, and Azure SQL Data warehouse, as well as controlling and granting database access. Migrating On-premise databases to Azure Data Lake store using Azure Data Factory. ✅ Experience in Developing Spark applications using Spark-SQL in Databricks for data extraction, transformation, and aggregation from multiple file formats for analyzing & transforming the data to uncover insights into customer usage patterns. ✅ Creating simple and informative Data Visualizations using Power BI. 𝐓𝐞𝐜𝐡 𝐒𝐭𝐚𝐜𝐤: 🌟 𝐃𝐚𝐭𝐚𝐛𝐚𝐬𝐞 𝐃𝐞𝐯𝐞𝐥𝐨𝐩𝐦𝐞𝐧𝐭: Database Design, SQL Query Writing, Stored Procedures, SQL Views and Functions, Database Triggers, Building ER Diagrams, Table Partitioning. 🌟 𝐄𝐱𝐩𝐥𝐨𝐫𝐚𝐭𝐨𝐫𝐲 𝐃𝐚𝐭𝐚 𝐀𝐧𝐚𝐥𝐲𝐬𝐢𝐬: Pandas Python, Seaborn, Matplotlib, Numpy. 🌟 𝐌𝐢𝐜𝐫𝐨𝐬𝐨𝐟𝐭 𝐀𝐳𝐮𝐫𝐞: Storage Account, Data Factory, Synapse Analytics, Analysis Service,DataBricks, Stream Analytics. 🌟 𝐀𝐦𝐚𝐳𝐨𝐧 𝐖𝐞𝐛 𝐒𝐞𝐫𝐯𝐢𝐜𝐞: API Gateway, Lambda, S3, Athena, Cloud Formation, IAM. 🌟 𝐃𝐚𝐭𝐚𝐛𝐚𝐬𝐞𝐬: Azure SQL Database, Google Big Query, PostgreSQL, Microsoft SQL Server, MySQL, MongoDB. 🌟 𝐏𝐫𝐨𝐠𝐫𝐚𝐦𝐦𝐢𝐧𝐠 𝐋𝐚𝐧𝐠𝐮𝐚𝐠𝐞s: Python, PySpark 🌟 𝐎𝐫𝐜𝐡𝐞𝐬𝐭𝐫𝐚𝐭𝐢𝐨𝐧𝐓𝐨𝐨𝐥: Airflow. 🌟 𝐑𝐞𝐩𝐨𝐫𝐭𝐢𝐧𝐠: Microsoft Power BI. #DataAnalytics #Python #BigData #DataPipeline #PowerBI #DataVisualization #DataAnalyst #Analytics #SQL #Dashboard #Visualization #PYSpark #ExcelDashboard #ExcelDataAnalysis #SQL #DataEngineering #BigData #DataEngineer #Cloud #ETLDeveloper #DatabaseDesign #AzureDataFactory #Spark #DataExtraction #SoftwareArchitect #DataPipeline #ETL #Data Engineering #DataCleaning #DatabaseDesign #ExcelDataEntry #DataEntry #BigDataAnalytics #DataVisualisation #MicrosoftExcel #DataAnalytic#ApacheSpark #DataAnalyst #BigDataAnalytics #DataPipelines #Consultation #Airflow #ETLPipeline #DataIntegration #CloudMigration #Azure Data Factory #Synapse #Microsoft Fabric #Google Ads API