Anusha Pamali Dsilva
Rio Tinto
Milpitas,CA
1
Certification
11
years of professional experience
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.
Work History
Data Engineer
2 Years- 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 validated JSON payloads with cross-functional teams to ensure data integrity. Configured secure SSL certificates, achieving a 50% reduction in data retrieval times.
- Extracted oil data from legacy source systems using ODBC connections and configured SSIS packages for scheduled data loads, improving efficiency by 90% and enabling timely report generation.
- Created Power BI reports for KPIs and automated workflows with Power Automate, streamlining productivity tracking and facilitating 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
7 Months- Resolved issues in the existing ETL setup for extracting oil data and implemented an alternate solution that significantly improved performance and efficiency by 90%.
- Resolved issues in ETL setup for extracting oil data and implemented alternate solution, enhancing performance and efficiency by 90%.
- Developed Python scripts to establish ODBC connections to source data, enabling efficient extraction and transfer of data records for continuous synchronization.
- Created a dashboard to predict engine health based on oil sample data, reducing the cost and frequency of failures by 85%.
Senior Software Engineer
7 Years 3 Months- Automated policy creation for life insurance product using Python and improved processing time by 85%.
- Developed Python scripts to encrypt customer detail files and securely store in S3, enhancing data protection.
- Developed Python scripts to encrypt files containing customers details and store it in S3.
- Analyzed insurance product usage data in R Studio to derive insights on customer preferences and trends.
- Developed and executed SQL queries to retrieve information adhering to business requirements.
- Analyzed insurance product usage data in R Studio to get insights on products extensively used by customers.
- Documented insurance and credit card processes to streamline training and onboarding for new team members.
- Collaborated with cross-functional teams using Agile methodologies, such as Scrum and Kanban, to deliver high-quality software products within tight deadlines.
Education
Master of Science - Information Systems
Master of Science - Software Engineering
Skills
Data Engineering & Processing: ETL/ELT Pipelines
Apache Spark/PySpark
Apache Airflow
PyIceberg
PyArrow
Data Modeling
Data Lakes
Schema Evolution
Data Quality Validation
dbt
Cloud & Data Platforms: AWS (S3
Glue
Redshift
IAM
Lambda
Aurora)
Azure (Azure SQL Database
API Management
DevOps)
GCP (BigQuery)
Databricks
Snowflake
Programming & Scripting: Python
SQL
R
PowerShell
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.2025Read More
Data Science and Engineering Intern
Rio Tinto
06.2022 - 01.2023Read More
Senior Software Engineer
Wipro Limited
05.2014 - 08.2021Read More
University of Utah
Master of Science from Information Systems
Read More
Birla Institute of Technology And Science
Master of Science from Software Engineering
Read More