Analyst Programmer Ramco Systems
Designed scalable SQL database schemas to support anticipated data growth, using normalization, indexing, and partitioning strategies to improve performance and maintainability. Optimized complex SQL queries and database indexes to enhance query performance and system stability.
Built and maintained ETL and data pipelines using Apache Airflow and Python to automate data ingestion and processing, improve reliability, and reduce manual effort. Developed backend features and integrations using SQL, Java, and HTML, while creating unit and integration tests for production reliability.
Collaborated with business analysts, QA professionals, and project managers to translate requirements into technical designs, documentation, and deployment support. Investigated and resolved production issues to minimize user impact and provide ongoing system support.