Julia Gasanova - IT Professional

Areas of Expertise

Technologies & Tools:

Cloud technologies: AWS
Programming languages: JavaScript, C#, Java, Python, PHP, Delphi, C++
Web technologies: ASP.NET, Oracle APEX, HTML, CSS, Bootstrap, Angular, jQuery
APIs: SOAP, REST, RESTful, GraphQL
Databases: Oracle, MySQL, MS SQL Server, PostgreSQL, MongoDB, DynamoDB; SQL, PL/SQL
Data Processing & Distributed Systems: Apache Kafka, Apache Spark, Databricks, Hadoop, Amazon Kinesis, AWS Glue
ETL/ELT & Orchestration: dbt, Oracle Data Integrator (ODI), Apache Airflow
Data Warehousing & Storage: Snowflake, Amazon S3, Amazon Redshift
BI & Reporting Tools: Oracle BI, Power BI, Tableau
Diagrams/architecture: ER, UML, Flowchart, BPMN diagrams
Version control: Git, SVN
CI/CD pipelines: Jenkins, GitHub Actions
Project management: JIRA, Confluence, Redmine
Operating systems: Windows, Linux

Leadership & Cross-Functional Skills: project management and planning; cross-functional team collaboration; stakeholder communication and management; waterfall and agile (Scrum, Kanban) methodologies and practices; allocating tasks and tracking delivery; prioritization and backlog management; team guidance, mentoring and knowledge sharing; enforcing code quality standards and best practices; ownership of end-to-end delivery.

Business Analysis: requirements gathering and analysis; modeling system interactions and workflows; bridging technical and business requirements; process mapping and optimization; creation of functional specifications, feature definitions, and use cases; requirements management and traceability across the software development lifecycle; presenting technical solutions to non-technical audiences; documentation and technical writing; business process analysis to identify patterns and bottlenecks and provide recommendations for improvements and automation.

Software Architecture: system and software architecture design; technology evaluation and selection; Domain-Driven Design (DDD); distributed systems architecture; API-first architecture (RESTful services, contract-driven design); microservices architecture and service decomposition; event-driven and asynchronous architectures; scalability, availability, and fault-tolerance design; data architecture and data flow design; integration architecture and system interoperability; serverless architecture and cloud-native design.

Software Engineering: full software development lifecycle (SDLC) implementation, from requirements through production support; object-oriented, functional, and modular programming principles; data structures & algorithms; debugging, troubleshooting, and root-cause analysis; performance tuning and optimization; refactoring and technical debt reduction; production support and issue resolution; reverse engineering legacy systems and designing modern replacements; web application development (front-end and back-end); integration solutions and middleware development; API design and development; test design and automated testing practices; version control and collaborative development workflows; build, release, and deployment automation.

Data Architecture & Engineering: data architecture and modeling; relational (SQL) and non-relational (NoSQL) databases; ETL/ELT design, implementation, and optimization; data pipeline development and orchestration; data warehousing architecture and management; data lake design, ingestion, transformation, and analysis; SQL query optimization and performance tuning; scripting for data processing and automation (Python, Bash, etc.); data integration across multiple sources and systems; data quality, validation, and governance; data visualization for analytical and operational reporting; schema design and database normalization; indexing, partitioning, and performance strategies; metadata management and documentation; monitoring and troubleshooting of data workflows.

Data Analysis & Data Science: data collection, cleaning, and preprocessing; exploratory data analysis (EDA) and descriptive statistics; extracting insights from campaign, operational, or transactional data; identification of patterns, trends, and anomalies in data; analysis of rare or outlier cases; data quality assessment, validation, and error detection; statistical analysis and hypothesis testing; forecasting and predictive modeling (time series, regression, etc.); monitoring and evaluating analytical models and solutions; defining, monitoring, and reporting KPIs and success metrics to track business performance; performing ad-hoc and bespoke analyses to support business and client reporting (e.g., QBRs).

Soft Skills: fast learner enthusiastic about learning new things and improving existing skills and knowledges; good communication and teamwork skills; accomplished team-player, who can also work independently; excellent analytical skills; problem solving; attention to detail; critical thinking; focusing on results; activity; creativity; great time management, organization and prioritization skills; punctuality; responsibility; flexibility and adaptability.

Career Path

2011 - 2017

I started my career as a software engineer at Ukrtelecom, one of the largest telecommunications operators in Ukraine with millions of subscribers, developing a wide range of software for call center operations.

I provided ongoing support for 20+ production systems serving the operator’s internal hotlines and external outsourcing clients, covering IVR (Interactive Voice Response) solutions and call-center operator software for call handling and processing. I delivered end-to-end implementation of new call-center hotline projects, from initial design to production rollout. I also developed software for internal call-center processes automation, built integration solutions and APIs for cross-system communication, and designed database architectures, data warehouses, ETL workflows, and data pipelines for large-scale data processing, supporting advanced analytics and dozens of reports and dashboards. As well as delivered specialized solutions such as systems for displaying operational information on screens across operator rooms.

During six years at the company, advanced from junior engineer to head of the department. Developed strong ownership in tackling complex problems while leading a team through a challenging period of restructuring, managing team capacity and priorities, mentoring engineers, and balancing hands-on technical work with people leadership and strategic decision-making.

I led automation initiatives that reduced manual effort for internal call-center processes by over 75%, significantly improving operational efficiency. I also architected and implemented a large-scale data solution that consolidated client information from multiple sources, cutting retrieval time by more than 40%, enabling IVR personalization, enhancing customer experience, and reducing average call-handling time by around 20%. One of my key leadership achievements was developing an outbound calling system based on the open-source platform Asterisk, which lowered software and hardware expansion costs for outbound calling by over 80%.

2017 - 2024

For more than seven years, I worked for a Medirent Information Technology, company developing software for government and social institutions, contributing to e-government initiatives and large-scale social benefit payment systems. One of the key projects was the automated system for pension assignment and payments for the Pension Fund of Ukraine. I also worked on multiple reporting development projects and led the technical development of a centralized integration system that integrated multiple business applications for social benefit payments, including the Pension Found system.

I was involved across the full lifecycle of the large-scale, mission-critical systems development, including maintenance and implementation of significant changes and improvements to a high-load system in production operation. I built integration solutions and APIs enabling data exchange between internal systems and external platforms, including e-government services and banks. My role also had a strong data focus. I designed ETL processes and data pipelines, built and evolved data warehouses, implemented solutions for processing large datasets, and developed complex reports, dashboards, and forecasting solutions to support data-driven decision-making.

I contributed to migrating the high-load Pension Fund of Ukraine system from Oracle APEX to ASP.NET, preserving functionality while adding new features and ensuring a smooth transition. I designed multiple data warehouses, cutting report generation time by 50–70% and easing peak-load stress, and led a centralized integration system that boosted efficiency and reduced manual effort by over 30%. Throughout, I made critical decisions under pressure to implement large, mission-critical system changes quickly without compromising quality.

2024 - present

Another project I contributed to involved developing transport and logistics software for a large supermarket chain in the EU, designing and building a suite of applications that function as an integrated ecosystem. These applications communicated with internal components as well as multiple external systems, requiring careful design of interfaces and data flows. My responsibilities covered API development, ETL processes, and data pipeline implementation, along with the development of reports and dashboards for operational insight. Alongside back-end and integration work, I contributed significantly to front-end development, building rich user interfaces that balanced functionality, usability, and performance.

A major achievement on this project was the independent design and implementation of a software solution that consolidated and replaced two legacy systems.

Academic Background

I have a strong academic background in mathematics, supported by a Master’s degree in Applied Mathematics. My studies covered discrete mathematics, probability theory, mathematical statistics, and elements of quantum computing. I also developed a solid foundation in mathematical analysis, optimization theory, systems analysis, and the modeling of complex systems, along with exposure to automated systems design, programming automation, and expert systems. My education allowed me to hone my analytical skills and ability to see patterns in any business processes and complex real-world problems. I have consistently applied the acquired skills in practice, designing mathematical models and translating them into efficient software solutions, while continuing to expand my expertise.