I am a professional BI/Python Developer with 5+ years of technical expertise; curating innovative, performant and scalable solutions on projects with a tangible value for businesses. I have mastery in the delivery of solutions for web-based BI systems (Django/Flask), Data warehouse solutions, ETL pipelines, various API integrations, engaging visualisations (marketing funnel), and predictive analytics scripts.
Developed this project as a personal self-marketing tool; worked on the frontend and backend components of the semantics analysis tool in 2+ weeks using semantic analysis requirements from previous projects and freelancing requests from clients. The hosting site has a few visitors per week, with the potential for more. It accepts text inputs up to 500Kb. Each new line within text file represents different text group (e.g. product review paragraph). It supports categorisation by using specific tags identifying text groups of interest. New functionalities will be added as the user base grows.
TOPO Centras is the largest household appliances and electronics retail network in Lithuania. Developed BI tools to enhance the marketing and operational activities of TOPO Centras with a focus on ETL pipeline development, Data warehouse development, and report solutions for the frontend.
Engineered a Flask-based solution that works with transaction data based on specific requirements for a specific business. It shows the data manipulation/presentation capabilities of Flask. Developed the transaction management tool and implemented functionalities for importing/summarizing, output, basic and single-user login. It is built on a Flask framework with SQLite as the database engine to meet the needs of the client on the project.
Developed a tool which works like OLAP Cubes by taking data snapshots of SalesForce objects and uploading those objects to Big Query. The final solution is a multi module Python project, which can accept specific specifications for data snapshots (e.g. snapshots of leads object, or order object), automatically build SQL schema from scratch (primary keys, foreign keys, tables) and upload data snapshots to Big Query. It uses Google sheets and other APIs for data input - critical for data aggregation and visualization processes. The solution automates the complex workflow followed by analysts within a company on a weekly basis using Excel and other tools. It can also perform more complex snapshot calculations as well as offload dependencies onto the SalesForce data storage which is priced per GB of storage.
Work history
UpStack
Python Developer
2019 - Present (4 years)
Remote
Creating and developing innovative software solutions for clients across a broad range of industries.
Participate in scrums consisting of cross-functional teams, both software and hardware.
Ensure that features are being delivered efficiently and on-time.
Developed and maintained Data Warehouse solutions with ETLs; iterating specific ad hoc solutions - cube-like reporting tools for SalesForce.
Worked on the delivery of descriptive and predictive analytics within the marketing function feature; to include analysis of performance, lead scoring, BI solutions linking Google Adwords with other data sources for ROI metrics, and other specific hypotheses.
Produced engaging data visualisations through Pandas Matplotlib, Google Data Studio, and data frontends for operations using Flask and Django.
Participated in the design of requirements for managerial reporting; developing specifications, implementing solutions and coordinating with third parties - Union square architecture, ERP system providers and custom APIs.
Engineered a managerial reporting tool with functionalities for daily forecast and cost reporting; improving monthly board report processes.
Created local Python and VBA tools for architecture team leaders automating tedious calculation processes from CAD designs.
Developed and worked with Python and VBA for the iteration of tools used for report automation and data retrieval; increasing the overall efficiency of operations.
Exercised technical judgment for project/programme financial reporting and forecasting deliverables.
Anticipated challenges, removed roadblocks, and fostered alignment by providing training to project stakeholders.
