Sanil Vannantavita
Bengaluru
Summary
Google Cloud Certified Professional Data Engineer with 13+ years of experience in data warehousing and a Post Graduate Diploma in Data Science. Expertise in designing technical architectures, managing infrastructure, executing ETL processes, and migrating legacy systems to GCP. Proficient in BigQuery, Cloud Run Functions, Pub/Sub, Cloud Storage, SQL, and Python. Skilled in data visualization tools like Power BI.
Overview
12
12
years of professional experience
1
1
Certification
Work History
Data Engineer
IKEA
Bengaluru
05.2023 - Current
- Part of Risk Analytics team which comes under Business Risk and Compliance.
- Developed an application integrating various data sources to detect anomalies indicative of fraud across different risk topics.
- Collaborated with business stakeholders and the product team to gather business requirements and worked on the data proof of concept (POC).
- Partnered with engineering, product, and UI/UX teams to build the complete data product (PEDX team).
- Managed daily maintenance tasks, incident handling, and team support.
- Supported Agile ceremonies by ensuring data-related tasks were efficiently managed and aligned with Agile principles.
- Facilitated source data migration, ensuring the process was smooth, secure, and efficient
- Assisted Power BI teams by maintaining a robust, efficient, and scalable data infrastructure.
- Optimized daily job runs (data pipeline), reducing job running time by 30%.
- Enhanced BigQuery usage, resulting in a 60% reduction in cloud billing costs
- Improved query performance in PostgreSQL, boosting application UI performance by 30%.
Data Engineer
IBM (Client – H&M)
Bengaluru
05.2017 - 05.2023
- Designed and implemented data warehousing solution for H&M online sales analysis which include multiple data integration like sales, Stock, Bought data.
- Automated end to end data checks which helps to verify all functional changes quickly with zero defects.
- Closely worked with ML Engineering team to build end-to-end solution to predict rate of return of online sales order which helps to decrease overstock by up to 9 million pieces per season
- Worked with multiple stakeholders and solved business problem by adjusting online sales prices to improve stock health and increased net sales by 3% and slow-moving stock from 51% to 45% share of stock.
- Onsite working experience with clients in Sweden (2 years).
- Lead team of four full-time employees and one contractor.
- Experience in working in Google cloud products such BigQuery, Cloud SQL, Cloud Storage and Cloud Functions.
Datawarehouse Engineer
TCS (Client – Deutsche Bank)
Bengaluru
12.2012 - 04.2017
- Analyzed source systems, business requirements and identified business rules for building data warehouse.
- Created 20+ functional, technical design and data mapping documents by interacting with customers subject-matter experts.
- Developed complex SQL queries to process data and generate cubes for visualizing.
- Designed and developed 15+ complex Informatica mappings.
- Optimized ETL performance to provide quickest response time possible.
- Proactively identified, managed, and corrected data quality issues with automation scripts.
Education
Post Graduate Diploma - Data Science
International Institute of Information Technology
Bangalore2019
Bachelor of Technology - Electronics And Communication Engineering
ASIET
Kaladi2012
Skills
- Google cloud Platform
- Data engineering
- Data migration
- Business Analysis
- Data Analysis
- Machine learning
- Informatica
- SSAS cube
- IBM Cognos
- IBM Netezza
- Microsoft Power BI
- SQL
- Python
- Agile and Scrum
- DevOps
Certification
- Google Cloud Certified Professional Data Engineer (Nov 2022 – Nov 2024)
Timeline
Data Engineer
IKEA
05.2023 - Current
Data Engineer
IBM (Client – H&M)
05.2017 - 05.2023
Datawarehouse Engineer
TCS (Client – Deutsche Bank)
12.2012 - 04.2017
Post Graduate Diploma - Data Science
International Institute of Information Technology
Bachelor of Technology - Electronics And Communication Engineering
ASIET
Similar Profiles
Adam GutowskiAdam Gutowski
Furniture Sales Associate/Customer Service Representative at IKEAFurniture Sales Associate/Customer Service Representative at IKEA
Erla Dís GuðnadóttirErla Dís Guðnadóttir
Logistics at IKEALogistics at IKEA
Ahmed KamelAhmed Kamel
Goods Flow Manager at IKEAGoods Flow Manager at IKEA