• Pioneered the development and integration of sophisticated AI functionalities into web applications, leveraging GPT-3.5, GPT-4, and OpenAI's Whisper.
• Architected a versatile chat interface that enables users to engage in real-time conversations with AI, akin to ChatGPT, with chat history saving capabilities.
• Designed an interaction mechanism for users to have dynamic Q&A sessions based on uploaded documents.
• Implemented detailed, AI-powered discussions about my personal experiences, skills, and hobbies.
• Developed the full-stack application using Python, FastAPI, Supabase, Next.js, and Typescript.
• Utilized Tailwind CSS and ShadCN library for a responsive and intuitive user interface.
• Leveraged Weaviate and Supabase for data management and operations.
• Ensured application's deployment using Docker, Nginx, and Linux with a consistent development-to-production pipeline via Git.
• Notably, many features I've created during my freelance period are showcased in my current portfolio web app, even if some past projects remained unreleased.
• I warmly invite you to sign up and experience firsthand the cutting-edge AI features integrated within this portfolio web app.
• Architected and implemented a cloud-based data infrastructure to support data ingestion, transformation, documentation, and ELT processes, utilizing a technology stack that includes Python, Airbyte, DBT, and Prefect.
• Orchestrated data warehousing solutions in Google BigQuery, focusing on the development of sophisticated data transformations, models, and analytical views/tables through DBT
• Established and sustained a centralized data repository, acting as the "single source of truth," by integrating multi-source data and third-party tools, thereby strengthening the foundation for internal business intelligence and analytics.
• Designed and developed ETL job scripts and data pipelines, optimizing data flow and operational efficiency.
• Seamlessly integrated heterogeneous data streams—sourced from platforms such as Heap, Pipedrive, and various Google APIs—into targeted destinations like Google BigQuery and Intercom, leveraging Python and the aforementioned cloud infrastructure.
• Skillfully visualized critical business data using Google Data Studio, enabling informed decision-making and strategy optimization.
• Engineered customer segmentation and analysis frameworks using SQL, Hadoop, and Python to optimize targeted marketing campaigns.
• Conducted value and mobility assessments of customer interactions, leveraging SQL, Hadoop, and Python to inform product enhancement strategies.
• Authored Python scripts and orchestrated data pipelines for seamless integration of Google Analytics API, Google Play API, and App Store API data into a centralized data warehouse.
• Developed automated MS SQL procedures that harmonize multi-source data, transforming it into structured formats suitable for comprehensive reporting.
• Crafted insightful dashboards and visualizations using Power BI, serving as key instruments for data-driven decision-making.
• Executed web scraping techniques using Python to harvest relevant data, followed by loading the scraped information into a data warehouse for further analysis.
• Acted as the analytical liaison across departments, offering data interpretation services that informed evidence-based responses to critical business questions and hypotheses.
• Specialized in customer value and ad-hoc analyses, yielding actionable insights for strategic planning and execution.
• Overseeing end-to-end business operations with a focus on strategic scaling.
• Engineered a proprietary web application to automate various operational tasks including inventory management, order fulfillment, financial accounting, and advertising strategies.
• Utilized a robust technology stack consisting of Python FastAPI, Supabase, PostgreSQL, Prefect, and DBT, deployed within Docker containers on a Linux VPS and orchestrated via Nginx as a reverse proxy.
• Administering and fine-tuning Amazon PPC campaigns for optimized ROI, while employing automation strategies for scalability.
• Orchestrated the development, deployment, and automation of ANACREDIT batch reporting mechanisms for compliance with NBS (National Bank of Slovakia) and ECB (European Central Bank) guidelines.
• Engineered and automated specialized reports with a focus on risk assessment, alongside creating comprehensive reporting tools for cross-departmental needs.
• Assumed full responsibility for the accurate ingestion of real-time data into databases, ensuring data integrity and reliability.
• Implemented database modifications and schema adjustments to accommodate evolving data requirements and formats.
• Oversaw the batch generation process for CRIF reporting, adhering to established data protocols and standards.
• Crafted specialized reports in compliance with the National Bank of Slovakia's regulatory framework.
• Conducted work productivity calculations to monitor and improve operational efficiency.
• Managed the daily automated email distribution to partners, guaranteeing timely and accurate communication.
• Collaborated on the development of early termination and scorecard models, contributing analytical insights and data expertise.
• Configured ODBC (Open Database Connectivity) connections for users and automated report generation via ODBC, streamlining data accessibility and reporting processes.
• Specialized in ad-hoc analyses to provide timely and actionable insights for pressing business queries and challenges.
• Participated in a rotational training program, gaining hands-on experience in Risk Analyst and Accountant roles.
• Conducted comprehensive risk assessments and generated diversified risk reports to identify vulnerabilities in the company's operational frameworks.
• Managed the company's blacklist, enforcing risk mitigation strategies to safeguard business integrity.
• Oversaw specific segments of NRKI and Solus registers, ensuring accurate and compliant data management.
• Completed specialized software-related assignments to support risk analysis endeavors.
• Undertook ad-hoc projects, providing solutions for emergent risk-related scenarios.
• Managed the bookkeeping activities including the documentation of supplier and customer invoices, proforma invoices, internal financial records, and bank statements, as well as write-offs.
• Assisted in the monthly reconciliation of bank accounts to ensure financial accuracy.
• Collaborated on monthly financial closing activities, supporting comprehensive reporting and auditing processes.
• Engaged in specialized software-related assignments to optimize accounting operations.