Anusha Pamali Dsilva
Summary
Results-focused data professional equipped for impactful contributions. Expertise in designing, building, and optimizing complex data pipelines and ETL processes. Strong in SQL, Python, and cloud platforms, ensuring seamless data integration and robust data solutions. Known for excelling in collaborative environments, adapting swiftly to evolving needs, and driving team success.
Overview
11
11
years of professional experience
1
1
Certification
Work History
Data Engineer
Rio Tinto
05.2023 - 05.2025
- Architected and developed a Flask API-driven data pipeline to ingest transformer oil data into Azure SQL Database, secured via Azure API Management. Integrated CI/CD pipelines using GitHub Actions for automated deployments, collaborating with cross-functional teams to ensure seamless integration and alignment with business needs.
- Designed and optimized ETL workflows, increasing operational efficiency by 85% and significantly reducing costs.
- Implemented ETL solutions for the Operational Data Platform, enabling real-time data availability in the data warehouse and BI layer, adding 25+ KPIs to improve productivity reporting and decision-making by 98%.
- Conducted API testing with Postman and worked with cross-functional teams to validate JSON payloads and ensure data integrity. Configured secure SSL certificates, reducing data retrieval times by 50%.
- Extracted oil data from legacy source systems using ODBC connections, configured SSIS packages for scheduled data loads from source to target, improving efficiency by 90% and driving cost savings through generated reports.
- Created Power BI reports for KPIs and automated workflows with Power Automate, streamlining productivity tracking and enabling actionable insights.
- Resolved data issues in condition monitoring reports by modifying or writing complex SQL queries, views and stored procedures.
Data Science and Engineering Intern
Rio Tinto
06.2022 - 01.2023
- Created a dashboard to predict engine health based on oil sample data, reducing the cost and frequency of failures by 85%.
- Resolved issues in the existing ETL setup for extracting oil data and implemented an alternate solution that significantly improved performance and efficiency by 90%.
- Developed Python scripts to establish ODBC connections to source data, efficiently extracting and pushing data records to the destination, ensuring continuous data synchronization and updates.
- Designed and optimized complex SQL queries to split downtime records by shift and accurately determine the production day.
Senior Software Engineer
Wipro Limited
05.2014 - 08.2021
- Built a utility in Python to handle reimbursements for customers wrongly charged on their credit card thereby increasing processing efficiency by 90%.
- Developed Python scripts to encrypt files containing customers details and store it in S3.
- Automated policy creation for life insurance product using Python and improved processing time by 85%.
- Analyzed insurance product usage data in R Studio to get insights on products extensively used by customers.
- Built and maintained data extraction tool using SQL queries and Python libraries (pandas) to extract and consolidate data from different third-party vendors.
- Developed and executed SQL queries to retrieve information adhering to business requirements.
- Documented various insurance and credit card flows to ease training and development for new hires in the team.
- Collaborated with cross-functional teams using Agile methodologies, such as Scrum and Kanban, to deliver high-quality software products within tight deadlines.
Education
Master's - Information Systems
University of Utah
05-2023
Master's - Software Engineering
Birla Institute of Technology And Science
12-2018
Skills
- Programming & Scripting: Python, SQL, R, PowerShell
- Data Engineering & Processing: ETL/ELT Pipelines, Apache Spark, Apache Airflow, PyIceberg, PyArrow, Data Modeling, Data Lakes, Schema Evolution, Data Quality Validation
- Cloud Platforms: AWS (S3, Glue, Redshift, IAM, Lambda, Aurora), Azure (Azure SQL Database, API Management, DevOps), GCP (BigQuery)
Certification
- AWS Certified Data Engineer – Associate, 01/2026
- Credential URL: https://www.credly.com/badges/0513cae3e58-4aec-a079-db7c9c2ce054/public_url
- Data Engineering Nanodegree, Udacity, 08/2021
- Bootcamp – Data Engineering, Zac Wilson, 03/2025
Timeline
Data Engineer
Rio Tinto
05.2023 - 05.2025
Data Science and Engineering Intern
Rio Tinto
06.2022 - 01.2023
Senior Software Engineer
Wipro Limited
05.2014 - 08.2021
Master's - Software Engineering
Birla Institute of Technology And Science
Master's - Information Systems
University of Utah