Around 15 years of experience being a Data Engineer/Analyst, working in Business Intelligence/Data Warehousing and modern web projects. Recent experience of working in hybrid role of liaison between Business, Management and Technical teams. Worked directly with various customers to demo and train them in the new products we developed, gathering feedback and creating requirements for development teams to address it. Worked on Projects in Transportation, Banking and Finance domains. Technical expertise in Microsoft SQL Server suite of products (SSIS, SSAS, and SSRS). Specialized in Data warehousing concepts and various methodologies (star/snowflake schemas, data marts etc.) Experience in designing and documenting API specifications, designing API centric data architectures and creating data ingestion pipelines for supporting the UI applications. Experience in creating Data pipelines that automate project data flows (on-premise) using Airflow/Sql Server Agent/Spring Boot Batches/Logstash. Hands on experience using Airflow, AWS Kinesis along with Python scripts for ETL/data migration. Also some experience with Kafka-Debezium, PySpark, Supersets reporting. Experience in Data modelling and designing databases with various optimization requirements. Experience in working with MS SQL Server Analysis Services (SSAS) cubes, using MDX to retrieve data for reporting and analysis. 6+ years of experience working as a Technical Lead (and Onsite coordinator for onsite-offshore model). Experience of working in Agile projects, using Jira/Confluence.