Alexey Lomakin

Developed and optimized SQL queries to improve performance, fix bugs, and reduce execution time, including rewriting legacy code. Built a replicable end-to-end analytics pipeline in Python, covering data collection, transformation, storage, and visualization, and delivered key insights to C-level stakeholders. Contributed to the new Azure Databricks infrastructure by handling data migration, transformation, and creating fact sheets for accurate reporting.

Identified areas that could be improved through specific processes and addition of new software. Designed, developed and integrated software solutions based on business requirements and objectives. Balanced multiple projects by completing and updating documentation, managing scope and adjusting schedules. Completed software development lifecycle from requirement analysis to test planning, test case development and test execution.

Analyzed large amounts of data to identify trends and find patterns, signals and hidden stories within data. Used business objects, business intelligence and other reporting tools to extract data from data solutions and data warehouses. Created and automated data visualizations to present insights and tell compelling stories.

Identified and documented detailed business rules and use cases based on requirements analysis. Researched and resolved issues regarding integrity of data flow into databases. Used statistical methods to analyze data and generate useful business reports. Tested data prediction algorithms based on historical data. Analyzed transactions to build logical business intelligence model for real-time reporting needs. Developed tables, views and materialized views using SQL.

Created a database on access for for automatic filling of forms of template documents Mentored employees and offered constructive feedback for performance improvement. Detailed upcoming software upgrades and system sprints to team members. Integrated and updated software products to boost system compatibility

Discovered root causes of problems and identified appropriate solutions. Queried databases for information needed for report processing. Performed budget analysis to control expenditures and predict future budget needs. Identified clear connections between policies and business results to eliminate or reduce confusion and help employees achieve goals.