Anusha Pamali Dsilva
Summary
Results-oriented Data Engineer with 3+ years of experience delivering impactful data-driven solutions. Successfully led a team of developers to implement a system that enhanced data accessibility by 50% and improved data accuracy by 30%. Skilled in cloud platforms like Azure and AWS, Python, SQL, and API development, with a proven ability to collaborate with cross-functional teams. Adept at integrating software development practices into data engineering workflows, ensuring scalable, secure, and efficient systems that drive business insights and operational excellence.
Overview
10
10
years of professional experience
1
1
Certification
Work History
Data Engineer
Rio Tinto
Salt Lake City
05.2023 - Current
- Developed an API-driven data pipeline to ingest third-party transformer oil data into Azure SQL Database, ensuring secure access via API Management, automating instance execution with web services, and integrating version control and CI/CD using GitHub and GitHub Actions.
- Designed and visualized optimized data processing workflows, resulting in an 85% increase in operational efficiency and significant cost reduction.
- Developed and implemented ETL solutions for the Operational Data Platform, leveraging DevOps practices to ensure transformed data is available in the data warehouse and BI layer for real-time connections and visualization. Added over 25 KPIs for productivity reporting, enhancing data availability for end users and improving tactical decision-making by 98%.
- Conducted comprehensive API testing with Postman and collaborated with partners to test JSON payloads pushed to Flask API endpoints.
- Extracted oil data from legacy source systems, configured SSIS packages for scheduled data loads from source system to target, improving efficiency by 90% and driving cost savings through generated reports.
- Documented data architecture designs and changes, ensuring knowledge transfer and system maintainability.
- Implemented SSL certificate to extract downtime metrics data for KPIs, resulting in a 50% reduction in retrieval time, validated through Postman, and integrated into Power BI for visualization purposes
- Backtracking and resolving data issues in condition monitoring reports by modifying or writing complex SQL queries, views and stored procedures
Data Science & Engineering Intern
Rio Tinto
Salt Lake City
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 delta 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
Pune, India
06.2014 - 08.2021
- Build a utility in python to handle reimbursements for customers wrongly charged on their credit card there by increasing process efficiency to 88%
- 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
- Build and maintained data extraction tool using SQL queries, 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 up 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 Science
University of Utah, David Eccles School of Business
Master's - Software Engineering
Birla Institute of Technology and Science, Pilani, India
Bachelor's - Computer Application
Mangalore University
Skills
- Programming & Scripting: Python, SQL, R Programming
- Database Systems: SQL Server (SSMS), PostgreSQL, Cassandra, MongoDB, MySQL, Amazon Redshift, Azure SQL Database, BigQuery
- ETL & Data Pipeline Tools: AWS Glue, SSIS, Azure Data Factory,Apache Airflow
- Data Warehousing & Analytics: Amazon Redshift, BigQuery
- Data Modeling & Design: Erwin Data Modeler, Visio, Lucidchart
- Cloud Platforms & Services: AWS (Glue, Redshift, Aurora, S3), Azure (SQL Database, API Management, DevOps), Google Cloud Platform (BigQuery)
- Data Visualization & Reporting: Power BI, Matplotlib, Tableau
- Version Control & CI/CD: GitHub, GitHub Actions, Azure DevOps
- API & Web Services: RESTful APIs, API Management,
- Development & Collaboration Tools: Jira, Agile Methodology, SDLC processes
- Additional Skills: Data modeling, ETL development, data governance
Certification
Data Engineering Nano Degree, Udacity, 08/21
- Developed ETL pipelines for Apache Cassandra and Postgres, processing event data and loading into fact and dimension tables.
- Built data pipelines to extract, stage, and transform data into Redshift for user insights.
- Implemented Spark-based ETL pipeline for processing and storing data in S3.
- Automated and monitored production data pipelines using Apache Airflow.
Skills: Python, Postgres, Apache Cassandra, AWS, Redshift, Spark, Apache Airflow
Timeline
Data Engineer
Rio Tinto
05.2023 - Current
Data Science & Engineering Intern
Rio Tinto
06.2022 - 01.2023
Senior Software Engineer
Wipro Limited
06.2014 - 08.2021
Master's - Information Science
University of Utah, David Eccles School of Business
Master's - Software Engineering
Birla Institute of Technology and Science, Pilani, India
Bachelor's - Computer Application
Mangalore University
Similar Profiles
Tyler KnudtsonTyler Knudtson
Haul Truck Operator at Rio TintoHaul Truck Operator at Rio Tinto
MESUI TUA’IMESUI TUA’I
Service Person at Rio Tinto Iron OreService Person at Rio Tinto Iron Ore
Dillan AminDillan Amin
Head of Customs & Global Trade - Director Level at Rio Tinto LimitedHead of Customs & Global Trade - Director Level at Rio Tinto Limited
Manuel NavarroManuel Navarro
Millwright at Core Group - Shelter (Rio Tinto)Millwright at Core Group - Shelter (Rio Tinto)
POONAM BHAWARIPOONAM BHAWARI
Data Engineer at RBL BankData Engineer at RBL Bank