Victor Zoubenko

Business Intelligence Consultant

adlhz1@r.postjobfree.com • 727-***-****

GitHub• LinkedIn • St Petersburg, Florida

Goal-driven and ambitious professional skilled in leading database development efforts including requirements gathering, designing, implementing, testing, and reporting. Able to confidently architect data warehouses and systems as well as to carry out deep data analysis functions. Competent team-player adept at leading teams towards delivering bespoke projects across a diverse range of international corporate environments. Proficient in identifying opportunities to automate mundane processes and streamline daily business operations.

Technical Proficiencies

Platforms:

Windows, Linux, Mac, Windows Server, SQL Server 2008-2019, MySQL 5-8, Azure: VM, Front Door, Application Gateway, Virtual Network Gateway; ViciDial, Github, Electronic Data Interchange, SendGrid, Mollie, Selenium

Tools:

Datagrip, SQL Management Studio, Pycharm, Git/Github, SSRS, Access, Excel, Youtrack, Smartsheet, Upsource, MySQL workbench, Azure Data Studio

Languages:

T-SQL, MySQL, Python, Access VBA, PowerShell, MSSQL-XML, Azure SQL

Personal Learning Projects:

Python AI / Computer Vision program: real time object Identification, state detection, vehicle control.

Career Experience

Solidus.Digital, St. Petersburg, Florida 2019 – Present

Director of Business Development

Supervise day-to-day tasks of three Developers responsible for development of T-SQL and MySQL engineering projects. Ensure best practices are adhered to and maintain code quality via code reviews. Implement InfoSec best practices to ensure safety of client data. Serve as a liaison and advisor between C level executives, offshore development teams, and in-house development team. Build and deploy Azure cloud-based development environment. Automate and simplify SQL deployment processes.

Decoupled T-SQL database architecture from ORM’s, allowing for increased system performance, minimal network traffic, a significant reduction in release errors, and reduced middleware & frontend development efforts.

Designed and developed cyrpto currency trade data application. Backend powered by Python/TSQL.

Secured larger customer base while minimizing payment failures and fraudulent activities by re-engineering T-SQL banking and contract sub-systems.

Modernized SQL deployment processes via Powershell and reduced deployment times from multiple hours to push button and done.

Implemented Git VCS for SQL releases and JetBrains based project management solution for requirements, task management, and prioritization.

Designed and automated data masking processes for deployment of DB’s to test environments.

Led successful ETL project development between two international businesses operating in a mixed dialect environment between MySQL server (IT) and a T-SQL server (EN).

Designed Preprod release environments and secure access policies to protect unmasked client data.

Italia Gas E Luce, Lucca, Italy 2018 – 2019

Project Manager SQL Developer

Collaborated with US-based development teams to enhance business processes around billing, account management, and customer service delivery. Crafted plans to map project specifications and desired outcomes. Led technical teams towards delivering various key projects on time and within allocated budgets. Monitored and reported on project progress to senior stakeholders and clients.

Boosted weekly arrears revenue by up to €70k by playing an instrumental role in optimizing billing, account suspension, and email notification systems.

Devised a cross-server data synchronization tool for T-SQL, MySQL, and Azure servers.

Python PEC Email Processer: fetch, categorize, move, decrypt, parse, and load into the database.

Automated Import of Excel/XML/HTML reports: Used Python & Selenium library to fetch, then transform and load to db.

AP&G, Largo, Florida 2015 – 2018

Director of Accounts Management Data Analyst

Led a team of five professionals across account management, payroll, reporting, order processing, and collection departments. Replaced MS Access based reports with T-SQL, SSRS reports in line with business requirements. Oversaw requirements gathering and process authoring efforts for new territories and energy service providers. Served as liaison between accounts management team and VP of Sales, VP of Operations, Director of Customer Service, CIO, and CTO. Promoted to the Director of Accounts Management position after six months as a Data Analyst.

Increased weekly revenue by up to $50k after successfully building and implementing a collections program.

Minimized time spent on payroll processing by 90% through introducing system optimizations and automated employee onboarding activities.

Identified an unnoticed batch of $200k in ghost transactions while conducting an in-depth analysis on a $1.8M reconciliation project.

PES, Tarpon Springs, Florida 2011 – 2015

Network & PC Support Consultant Dialer Administrator

Managed reporting processes using MySQL and Excel tools. Facilitated multi-WAN setup, automatic fail over, load balancing, and QOS routing activities. Installed active directories and regularly maintained users on the server. Arranged the ethernet, servers, switches, and PC’s at company’s second location, ensuring maximum functionality to allow staff members to conduct their duties with minimal disruptions.

Optimized dialer management tasks by 50% using MySQL and Python languages.

Developed an automated PC setup process using a Windows Image Tool, CloneZilla and AD Group policies.

A+ Computer Solutions, Dunedin, Florida 2010 – 2011

PC Technician

Supplied remote and onsite IT Services to four cellphone store chains as well as ad hoc and B2B customers. Carried-out PC deployments in office environments. Conducted remote network administration, monitoring, and troubleshooting activities to ensure optimal functionality of all hardware systems. Managed point-of-sales and performed all PC hardware repairs according to client requirements to effectively manage expectations and provide quality service delivery.

Built a book of business by developing client relationships, resulting in client base growing organically through referrals and word of mouth.

Standardized and automated diagnostic and repair processes.

Implemented an inventory tracking system.

Developed marketing campaigns and managed execution.

Contact this candidate