Eric Samson Ayyinki

• Utilized SQL to analyze customer support reports, improving response time
• Automated repetitive tasks using Python scripts, resulting in an increase in operational efficiency.
• Developed SQL databases to track customer interactions and support metrics.
• Implemented Python-based tools for data scraping and analysis
• Demonstrated adaptability by quickly learning new software tools and technologies, allowing for seamless transitions between various support systems.
• Recognized patterns in customer inquiries, suggesting relevant updates to company''s FAQs section on website to reduce future tickets volume.
• Promoted a positive work environment by actively contributing ideas during team meetings aimed at enhancing overall productivity.
• Enhanced team performance with regular coaching and feedback sessions.

• Alexa device user data processing, device response and performance monitoring.

• Applied Agile methodologies, conducting weekly Sprints and stand-up meetings for iterative development.
• Implemented Python, SQL, and PL/SQL-based data processing, reducing errors and improving overall data integrity.

• Designed and developed data ingestion pipelines using Scala, Apache Spark, Apache Kafka, and PL/SQL for efficient ETL into Azure Data Lake Storage (ADLS), Azure Synapse Analytics, and Azure Database for MySQL.
• Leveraged Tableau to create interactive and visually compelling dashboards, providing stakeholders with actionable insights from complex datasets.
• Designed and implemented scalable data solutions, resulting in a significant decrease in data latency.
• Maintained consistent data models across multiple databases, ensuring higher data quality.
• Developed robust backend systems in Java and PL/SQL for data processing and analysis, enhancing efficiency and scalability in data operations.
• Designed, implemented, and maintained RESTful APIs to facilitate seamless data communication and integration across various systems, ensuring reliability and performance in data exchange.

• Orchestrated end-to-end CI/CD pipelines, integrating GitLab CI to automate testing, deployment, and collaboration across the software development lifecycle in both on-premises and cloud environments.
• Developed complex PL/SQL packages, procedures, and functions for business applications, leveraging advanced features like collections, nested tables, ref cursors, materialized views, and dynamic SQL.
• Performed SQL tuning, database application design, and developer support, contributing to efficient and optimized database operations.
• Crafted detailed design documents, promoting clear communication and precise documentation of system architectures and implementation specifics.

• POC for team building activities, mentored 2 batches of new-hires, performance reports, SLA management,weekly shrinkage reports and NPT performance tracking.