Location
PolandRate
Years of experience
10+About
A professional with extensive experience in data engineering and software development, he has a proven track record of delivering complex data solutions. His expertise includes designing and optimizing custom Python ETL processes and improving internal performance by transitioning systems to Azure. He is adept at mapping client data to the ARDM format and implementing Docker-based APIs for seamless data access. He specializes in designing and optimizing ETL processes, SQL databases, and integrating client systems with Appriss Secure. His background includes transforming and importing data to meet specific client needs, as well as developing applications for processing and managing paper documents. His skills extend to SQL database design, administration, and optimization, as well as integrating various client systems. With significant experience in Azure, he has successfully designed and migrated internal processes to Azure, leveraging Azure Virtual Machines (VMs), Green plum on Azure, and other Azure services to enhance system performance, scalability, and reliability. His work includes setting up Azure-based environments, configuring Azure resources, and implementing best practices for cloud security and cost management. Additionally, he has contributed to server projects in the telecommunications industry, demonstrating his ability to adapt to diverse technical environments. He excels in designing robust data architectures, optimizing database performance, and developing tailored solutions to meet a wide range of business requirements.Tech Stack
Azure, C#, ETL, Git, PostgreSQL, Python, TFSExperience
- Designed and migrated internal processes to Azure, leveraging Azure Virtual Machines (VMs) and Greenplum on Azure to boost scalability, reliability, and performance.
- Analyzed and designed ETL processes for ingesting client data, ensuring seamless integration, processing, and transformation to meet business requirements.
- Designed SQL databases, optimized SQL queries, and implemented indexing and performance tuning to enhance database efficiency and responsiveness.
- Prepared applications for processing paper documents, incorporating advanced features such as scanning (TWAIN, ISIS), file importing, OCR using ABBYY Engine, and manual indexing of missing data to ensure complete and accurate document processing.
- Exported processed documents according to client requirements, including creating multipage TIFF files, PDFs with text layers, XML files, and Excel files, meeting diverse client specifications.
Employment history
• Analyzed, designed, and prepared custom Python ETL processes for data ingestion, ensuring efficient data flow and integration.
• Improved the performance of internal Python solutions, enhancing overall system efficiency and reducing processing time.
• Mapped client data to the ARDM (Appriss Retail Data Model) format, facilitating accurate and standardized data reporting.
• Designed and migrated internal processes to Azure, leveraging Azure VMs and Greenplum on Azure to boost scalability and reliability.
• Prepared Docker environments with APIs for accessing data from Greenplum DB, streamlining data retrieval and usage.
• Analyzed and designed ETL processes for ingesting client data, ensuring seamless data integration and processing.
• Designed SQL databases and optimized SQL queries, including index creation and SQL Server settings changes to improve performance.
• Prepared comprehensive ETL processes tailored to specific client needs.
• Integrated with client systems to ingest data using various methods, including queues, SFTP, and Webservices.
• Transformed and imported data to Appriss Secure, ensuring data accuracy and consistency.
• Configured Appriss Secure according to client requirements, providing customized data solutions.
• Prepared applications for processing paper documents, incorporating scanning (TWAIN, ISIS), file importing, OCR using ABBYY Engine, and manual indexing of missing data.
• Exported processed documents according to client requirements, including multipage TIFF files, PDFs with text layers, XML files, and Excel files.
• Analyzed and designed processes for managing documents received from clients, ensuring efficient and accurate data handling.
• Developed applications for importing data from various client sources, such as websites and FTP, facilitating seamless data integration.
• Integrated client systems for importing and exporting data, enhancing data interoperability and accessibility.
• Prepared applications and reports for internal company needs, integrating OSG’s internal systems for streamlined operations.
• Developed and optimized systems for processing scanned documents, improving data processing efficiency.
• Designed SQL databases, administered SQL Servers, and optimized SQL queries, including index creation and query corrections.
• Developed and integrated new functionalities to enhance system capabilities.
• Identified and resolved software errors to ensure seamless operation.
• Wrote unit, integration, and acceptance tests to validate software performance.
• Actively participated in client meetings to understand requirements and demonstrate new functionalities.
• Collaborated with cross-functional teams to gather requirements and ensure project alignment.
• Optimized code for improved performance and scalability, adhering to best practices.
• Assisted in the design and architecture of new software modules to meet evolving project needs.
• Provided academic support and mentorship to students, helping them with coursework, projects, and career advice.
• Assessed student performance through assignments, projects, exams, and provide constructive feedback to help them improve.
• Kept up-to-date with the latest developments in programming and technology to ensure teaching content remains relevant and cutting-edge.
• Participated in research activities related to computer science and programming, contributing to the academic community’s knowledge base.