VitaliyNiko

@vitaliyniko

Automation Developer: Google Sheets, APIs, SQL

Ukraine
Russian, Ukrainian, English
About me
I build analytical reports, dashboards, mobile apps, and Telegram bots, as well as integrate external APIs and databases. * Sales, profit, margin, inventory, and procurement analytics * Automated reports and interactive dashboards in Google Sheets / Looker Studio * Integration with marketplace APIs, MySQL / PostgreSQL, and Google Workspace * Custom mobile business apps with AppSheet * Process automation using Apps Script (JavaScript), Python, and SQL I work with Google Workspace, Apps Script, AppSheet, Python, SQL, MySQL, PostgreSQL, Telegram Bot API, Excel, and VBA.... Read more

Skills

v
vitaliyniko
VitaliyNiko
Offline • 

See my services

Formulas & Macros
I will write professional vba macros and access excel automation scripts
From$25 / projectMore details
Programming & Tech
I will build google apps script automation for sheets, docs and gmail
From$25 / projectMore details

Portfolio

Work experience

РУСАЛ

РУСАЛ

Full-time • 7 yrs 6 mos

SAP CO (Controlling) Consultant

Oct 2014 - Sep 2019 • 4 yrs 11 mos

Worked as an SAP CO (Controlling) Consultant, focusing on the automation of auxiliary production processes and management reporting, serving as a liaison between ABAP developers and end users of SAP transactions. Key responsibilities: - Gathered and analyzed business requirements from end users for SAP CO module functionality and reporting - Translated business requirements into functional specifications for ABAP developers - Configured and supported SAP CO processes, including cost center accounting and internal order management for auxiliary production - Automated management reporting workflows within SAP CO to improve reporting accuracy and reduce manual effort - Tested and validated custom transactions and reports developed by ABAP team before deployment - Provided user training and support on SAP CO transactions, ensuring correct usage and data consistency - Coordinated between business users and technical development team to troubleshoot issues and implement enhancements - Documented business processes, functional specifications, and user guides for SAP CO functionality

Economist in Reporting Analysis and Management

Mar 2012 - Oct 2014 • 2 yrs 7 mos

Worked as an Economist in Reporting Analysis and Management for a production shop (workshop), responsible for cost accounting, budgeting, and investment analysis. Key responsibilities: - Developed budgets and financial plans for the shop's operational activities - Calculated cost of production (cost of goods manufactured), including direct and indirect cost allocation - Prepared product costing (calculation of unit cost per product type) based on production volumes and resource consumption - Conducted investment analysis, evaluating the feasibility and financial impact of capital projects - Analyzed production and financial performance against planned targets, identifying cost deviations and inefficiencies - Prepared management reports summarizing shop-level financial and operational results - Collaborated with production and finance departments to ensure accurate cost data and reporting consistency - Recommended cost-reduction and efficiency measures based on financial analysis findings This role gave me strong hands-on experience in cost accounting, financial modeling, and production economics — a foundation that now supports my work building automation tools (VBA, Excel, Google Apps Script) for cost calculation, budgeting, and reporting workflows.

Ощадбанк

Lead Economist at a bank branch

Ощадбанк • Full-time

Mar 2007 - Nov 2011 • 4 yrs 8 mos

Worked as a Lead Economist at a bank branch, responsible for financial planning, performance analytics, and operational efficiency. Key responsibilities: - Developed branch budgets and financial plans, including forecasting and variance analysis - Monitored and analyzed branch performance against key operational and financial indicators (KPIs) - Calculated quantitative metrics for banking operations, including workload timing and process efficiency (time and motion studies) - Prepared analytical and management reports for senior leadership based on performance data - Identified trends and process bottlenecks, proposing improvements to optimize branch operations - Acted as deputy branch manager, overseeing daily operations and decision-making in the manager's absence - Coordinated cross-departmental data for consolidated branch reporting This role strengthened my skills in financial analysis, data-driven decision-making, process optimization, and operational management — expertise I now apply to building automation tools (VBA, Excel, Google Apps Script) that solve exactly the kinds of reporting and analytics challenges I once tackled manually.