ASHAJYOTHI YARLAGADDA

Toronto

Summary

Results-driven Data Analytics professional with over 7 years of combined industry experience in software development and database engineering, complemented by a Master of Data Analytics degree with a 4.19 GPA. Demonstrates expertise in data preprocessing, statistical analysis, and visualization using Python, R, SQL, and Power BI. Adept at translating complex datasets into actionable business insights to support data-driven decision-making across marketing, operations, and general analytics functions. Proven track record of delivering scalable database solutions, optimizing query performance, and collaborating effectively in cross-functional team environments.

Overview

years of professional experience

Work History

Software Developer & Data Analyst

Velosoft

09.2015 - 11.2019

Architected and maintained enterprise-grade software applications using Python, Java, and SQL, supporting a user base of 500+ internal stakeholders and reducing system downtime by 18% over two years.
Designed and optimised complex relational database schemas in PostgreSQL and SQL Server, improving query response times by up to 35% through targeted indexing, query refactoring, and execution plan analysis.
Delivered end-to-end ETL workflows to consolidate data from multiple operational systems into a centralised reporting warehouse, enabling cross-departmental analytics and reducing manual reporting effort by 40%.
Collaborate within a cross-functional Agile/Scrum team of 12 developers and analysts, contributing to sprint planning, code reviews, and retrospectives to ensure on-time and within-scope deliverables.
Created interactive Power BI dashboards and automated Excel reports for senior management, translating raw transactional data into KPI scorecards that guided strategic business decisions.
Performed rigorous software testing — including unit, integration, and regression testing — using standardised test plans, identifying and resolving 200+ defects prior to production release.
Maintained strict adherence to company data-governance policies, confidentiality agreements, and intellectual property requirements throughout all phases of the software development lifecycle.

Junior Software Developer

Perigon Technologies

01.2012 - 08.2015

Contributed to the full software development lifecycle — from requirements gathering and system design through to coding, unit testing, debugging, and deployment — across multiple client-facing web and desktop applications.
Developed and maintained SQL-based data access layers in MySQL and SQL Server, writing stored procedures, triggers, and parameterised queries to ensure robust, secure data retrieval and manipulation.
Assisted in the migration of legacy databases to modernised relational schemas, including data cleansing, validation, and reconciliation activities that improved overall data quality and consistency.
Built internal productivity tools using Python and .NET that automated repetitive reporting tasks, saving the operations team approximately 10 hours per week in manual data processing.
Participated actively in code-review sessions, incorporating feedback to adopt best-practice coding standards and improve the maintainability and readability of shared code repositories.
Coordinated with QA engineers to develop and execute comprehensive test cases, reducing the average bug escape rate by 22% and contributing to a consistent record of on-time project delivery.
Upheld all confidentiality obligations and intellectual property agreements, departing the organisation in good professional standing with a strong performance record.

Education

Master of Data Analytics - undefined

University of Niagara Falls

Canada

Bachelor of Computer Science & Engineering - undefined

Loyola Institute of Technology and Management

India

Skills

Programming Languages: Python, R, JavaScript, Objective-C, NET, HTML, CSS

Data & Analytics Tools: SQL, Power BI, Excel, Tableau (basic)

Database Platforms: MySQL, PostgreSQL, Microsoft SQL Server, Microsoft Access

Frameworks & Technologies: React Native, ETL Pipelines, Agile/Scrum

Office & Productivity: Microsoft Word, PowerPoint, Access

CORE COMPETENCIES

Strong organisational and time-management skills
Exceptional written and verbal communication
Collaborative team contributor and independent self-starter
Detail-oriented with ability to manage concurrent priorities
Financial document handling and budget coordination
Commitment to confidentiality and professional conduct

Timeline