Roman Krotov Email & Phone Number

Jacksonville, Florida, United States

Denver, Colorado, United States

-Engineered a comprehensive data solution for a major banking client using Azure Data Factory, Azure Data Lake Gen2, Azure SQL Database, Azure Databricks, and PowerBI.-Integrated diverse data sources including banking systems and SaaS platforms into Azure Data Lake Gen2, streamlining data workflows.-Optimized metadata-driven pipelines in Azure Data Factory, enhancing functionality with control flow activities and Azure Function integration.-Managed ETL/ELT processes in Azure Data Factory and Azure Databricks, focusing on data integrity and scalability for financial data.-Implemented monitoring and maintenance protocols for data pipelines, ensuring operational excellence and compliance with banking regulations.-Led the development of scalable, real-time data pipelines, integrating Azure Event Hubs and Kafka, crucial for high-volume financial data processing.-Played a pivotal role in data transformation using PySpark and Spark SQL in Azure Databricks, and implemented Delta Lake for Lakehouse architecture.-Developed Azure Data Factory triggers for efficient pipeline scheduling and monitoring, aligning with the bank's data processing needs.-Created dynamic PowerBI dashboards and reports, providing key insights for the bank’s strategic decision-making and financial analysis.

Mariupol, Ukraine

• Architecting and implementing cutting-edge data engineering solutions using Azure Databricks, Azure Data Lake Gen2, Azure Data Factory, and Power BI to ensure seamless data flow and analytics capabilities.• Utilizing Azure Databricks services within Azure's ecosystem, aligning the organization with best practices and optimizing data processing workflows.• Managing Databricks notebooks, harnessing their full potential through utilities, magic commands, and productivity-enhancing features.• Establishing efficient notebook workflows by seamlessly passing parameters between notebooks for data processing and analysis.• Configuring and monitoring Databricks clusters, cluster pools, and jobs to guarantee high availability and optimal performance.• Ensuring secure data access by mounting Azure Storage in Databricks using secrets stored in Azure Key Vault, prioritizing data integrity and confidentiality.• Efficiently managing data through Databricks Tables and Databricks File System (DBFS), enhancing data accessibility and reliability.• Implementing a Lakehouse architecture with Delta Lake to streamline data storage and management.• Developing interactive dashboards for data visualization, empowering data-driven decision-making processes.• Ingesting diverse data sources into the data lake as parquet files and tables using PySpark, including CSV and complex JSON files.• Applying PySpark transformations and Window functions to derive meaningful insights from data.• Creating and managing local and temporary views in PySpark and Spark SQL, facilitating data exploration and analysis.• Implementing data processing patterns such as full refresh and incremental load using partitioning strategies to optimize efficiency.• Leveraging Delta Lake for Data Lakehouse architecture advantages, including efficient data management, versioning, and data quality control.

Kyiv, Ukraine

• Organized and implementated the inspection, acceptance control and technical review of rails, railroad switch and rail-fastening system in Ukraine, France, Belgium and Spain• Led a team of engineers - inspectors who carried out continuous acceptance and quality control of the production of all rails and rail fasteners at the Azovstal plant (Mariupol, Ukraine) for the railways of Ukraine, Europe and Asia.• Ensured compliance with state, interstate and industry standards, technical conditions and other regulatory documents.• Led technical audits to fully investigate quality control processes and root out deficiencies.• Supervision over the organization of the product quality system at all stages of the production of rails and rail fasteners, converter production, rolling production, laboratory tests.• Prepared and issued documentation confirming the quality of manufactured products in accordance with EN 13674, ISO 9001.• Systematic analysis of reports from the engineering team on product defects detected upon acceptance.• Investigated and documented changes, deviations and reclamations.• Supervised and directed quality control personnel through effective mentoring, coaching and work delegation, conducted product quality issues review meetings.• Participated in the development and coordination product quality control case review documentation;• Planned the department work in accordance with the Enterprises' production plans.• Organized technical trainings, briefings and testing of department employees, onoccupational safety, fire safety, as well audit process issues.• Built automated test scripts to handle repetitive software testing work.• Optimized test cases to maximize success of manual software testing.• Created successful test scripts to manage automated feature testin.• Determined test requirements and built jobs to meet quality requirements and benchmarks in support of internal software developers.

Kyiv, Ukraine

• Monitored product quality at all stages of production process.• Evaluated components and final products against quality standards and manufacturing specifications.• Recorded inspection and test results on data sheets.• Reported repeated issues to supervisors and other departments, collaborating to identify issue roots and rectify problems.• Monitored experimental and new samples testing, served as a member of a New Product Sample Review and Acceptance for Production Committee;• Developed and presented a Plan for improving the quality and reliability of rails and rail fasteners produced at manufacturing plants.• Prepared and submitted a proposal for modifications in the design and regulatory documentation. • Suspend product acceptance when the technological process and quality system of the manufacturing enterprise does not ensure compliance with the requirements of the design and regulatory documentation.

Mariupol, Ukraine

• Utilized AutoCAD and other software to create detailed drawings.• Produced sketches and diagrams to illustrate design concepts.• Collected construction site reports, analyzed building codes and made weight, volume and stress calculations to determine materials needed for projects.• Designed high quality, robust and cost-effective CAD product models by preparing routine layouts, detailed drawings, assembly sketches and diagrams.• Interacted with architects and clients to obtain critical design information necessary to complete projects within intended time frames.• Performed mathematical formulas to generate engineering models and calculations for system performance.

Master Of Science - Ms, Electromechanical Engineering

Bachelor'S Degree, Welding Technology And Equipment