Ayana Vinayan
kochi
Summary
Results-oriented Software Engineer with 3 years of experience in database development, recognized for designing and optimizing robust database systems that enhance software application performance. Demonstrates strong analytical skills and expertise in data structures, query optimization, and performance tuning. Successfully delivered high-quality solutions on time and within budget, contributing to overall project success. Aiming to leverage technical skills to drive innovative software solutions in a collaborative environment.
Overview
3
3
years of professional experience
Work History
Software Engineer
Prudent Technologies Pvt Ltd
Kochi
05.2022 - Current
• Developed complex SQL queries to extract, manipulate, and analyze data from MySQL databases efficiently.
• Designed and implemented normalized database schemas to ensure data integrity and optimize performance.
• Created stored procedures, triggers, and functions using PL/SQL and MySQL to automate business logic and enhance database functionality.
• Optimized SQL queries and database performance by analyzing execution plans, indexing strategies, and query tuning techniques.
• Provided technical support and troubleshooting for database-related issues, resolving performance bottlenecks and ensuring data integrity.
• Documented database schemas, configurations, and processes to facilitate knowledge sharing and team collaboration.
Education
Bachelor of Computer Applications -
Bharathiyar University
03-2019
Higher Secondary -
GGHSS Kodungallur
03-2016
High School -
GHSS Edavilangu
03-2014
Skills
- MySQL
- PLSQL
- JAVA
- Writing queries and Stored Procedures
- Performance tuning
- Best practices documentation
- Research and analysis
- Database backup
- RDBMS
- Query optimization
- Database objects design
- Data migration
- Data security
- GITHUB
PROJECTS
- Automated Communication Platform (ACP)
Prudent Technologies Pvt Ltd
• Collaborated with stakeholders to gather and analyze business requirements, translating it into stored procedure specifications and implementation.
Created a comprehensive database schema comprising tables, procedures, functions, and triggers to efficiently organize and manage data within the
system.
• Partitioned large tables to improve query performance within stored procedures.
• Utilized appropriate indexing strategies, to optimize data retrieval and manipulation operations within stored procedures. - Prudent Messaging Middleware (PMMW)
Prudent Technologies Pvt Ltd
• Collaborated with stakeholders to gather and analyze business requirements, translating it into stored procedure specifications and implementation.
Created a comprehensive database schema comprising tables, procedures, functions, and triggers to efficiently organize and manage data within the
system.
• Partitioned large tables to improve query performance within stored procedures.
• Utilized appropriate indexing strategies, to optimize data retrieval and manipulation operations within stored procedures. - Payment Gateway
Prudent Technologies Pvt Ltd
• Collaborated with stakeholders to gather and analyze business requirements, translating it into stored procedure specifications and implementation.
Created a comprehensive database schema comprising tables, procedures, functions, and triggers to efficiently organize and manage data within the
system.
• Partitioned large tables to improve query performance within stored procedures.
• Utilized appropriate indexing strategies, to optimize data retrieval and manipulation operations within stored procedures.
Timeline
Software Engineer
Prudent Technologies Pvt Ltd
05.2022 - Current
Bachelor of Computer Applications -
Bharathiyar University
Higher Secondary -
GGHSS Kodungallur
High School -
GHSS Edavilangu
Similar Profiles
Subeesh KumarSubeesh Kumar
Managed Business Developement & Direct Sales at Prudent Technologies Pvt. LtdManaged Business Developement & Direct Sales at Prudent Technologies Pvt. Ltd
FLIRGIN GEORGEFLIRGIN GEORGE
Software Developer at Prudent Technologies Pvt. Ltd.Software Developer at Prudent Technologies Pvt. Ltd.
Siva Rajesh KanuruSiva Rajesh Kanuru
Director Sales and Operations at Sri Ranga Motors Pvt Ltd(TATA MOTORS)Director Sales and Operations at Sri Ranga Motors Pvt Ltd(TATA MOTORS)