Delivery Manager / Data Engineering Competency Lead
с 05.2020 - По настоящий момент |Forte Group
Jira, Confluence, Google Workspace, Github, draw.io, Web3 and Web2 Development, Monolithic/Micro-service Architecture, Cloud (Oracle, AWS, Azure, OpenShift), K9S, Snowflake, Databricks, Spark
● Designed a high-performance data pipeline prototype using Snowflake and Databricks to validate cross-platform interoperability.
● Collaborated on RFP responses for complex data engineering bids, bridging the gap between business requirements and technical feasibility.
● Vetted and interviewed senior data engineering talent, ensuring project teams were staffed with high-performing subject matter experts.
● Established and led the Data Engineering Community, driving knowledge sharing, collaboration, and professional growth within the organization.
● Strategically managed a portfolio of diverse projects across Workload Automation, Tele-Health, Communication, Web3, and Fintech domains, ensuring successful delivery and client satisfaction.
● Cultivated strong relationships with top management (VP and Director level), ensuring clear communication and alignment on strategic initiatives.
● Orchestrated the activities of multiple development streams, each implementing distinct delivery components, ensuring seamless integration and overall project success.
● Introduced and implemented a full-cycle QA framework with a structured test pyramid, resulting in enhanced product quality and reduced defect rates.
● Consistently delivered product features within established timelines and to customer specifications, leveraging an agile Delivery Management framework.
Data Team Lead / Delivery Manager
08.2017 - 05.2020 |EPAM Systems
Azure SQL Database, Azure Blob storage, Azure Data Factory, SQL Server Management Studio, Visual Studio 2015, Visual Studio Team Services, Jira, Confluence, Xmind, Microsoft Project, Cloud, .NET, ReactJS, ETL, BI
Regulatory Affairs Project Management Database (Oil and Gas Company):
● As a Delivery & Database Architecture Lead, drove the complete development and deployment of a sophisticated, cloud-native Azure solution, from initial design to final release, encompassing complex data integration and a modern React JS front-end.
● Architected the database structure, including operational and integration layers, ensuring data integrity and performance, and designed the data movement architecture using Azure Data Factory, implementing a custom change data capture mechanism.
● Managed 4+ distributed teams (~40 members) across 3 countries, including 3 Scrum feature teams and 1 Kanban support team, along with shared resources (BAs, UI/UX, DevOps, SMs).
● Oversaw budget tracking and solution rollout planning, ensuring projects stayed within financial constraints and timelines.
● Negotiated and aligned solution architecture with internal and external stakeholders, ensuring technical feasibility and business requirements were met.
● Established and optimized development processes, improving team efficiency and productivity.
● Collaborated in requirements gathering, ensuring clear understanding and alignment with project goals.
● Facilitated team growth by identifying and onboarding suitable team members, and coordinating their integration with the customer.
● Directed DB team activities, including task prioritization, code reviews, meeting organization, requirements gathering, and process improvement.
Lead DBA
12.2013 - 01.2017 |EPAM Systems
Oracle 11.2.0.4.0, SwissCom, Talend EDI, SQL Developer, SQL Loader, Jira, Confluence, Git, Way4, ETL, Migration, XML, MS SQL Server 2014, Oracle 11g, PowerView, PowerPivot, SSIS, SQL Server Management Studio, Oracle Datamodeler, Oracle Developer, DW, BI, OLAP, SAP BODS, Oracle Application Express, SVN, UNIX, Data Obfuscation
Data Migration for Financial Services (Middle East Banks):
● Served as a Key Developer for a critical data migration project for a group of banks, leading payment solution providers in the Middle East.
● Rapidly acquired domain knowledge within two weeks, enabling seamless transition and replacement of a key developer.
● Successfully delivered a half-created solution to the production environment, navigating a new business domain.
● Designed and implemented ETL processes for data warehouse population using Talend EDI.
● Developed and executed a migration approach utilizing the SwissCom suite.
● Automated XML file generation and data import via XSLT transformations and Way4 integration.
Environment: Oracle 11.2.0.4.0, SwissCom, Talend EDI, SQL Developer, SQL Loader, Jira, Confluence, Git, Way4, ETL, Migration, XML.
BI Dashboard Development for Highly Secured Financial Data (Software & Hi-Tech):
● Served as BI Team Leader/Data Modeler for a part-time project focused on creating dashboards for top management, handling highly secured financial data.
● Consulted on DWH creation and security model design, ensuring data protection.
● Selected appropriate BI tools and architected the solution model.
● Analyzed and distributed tasks among team members.
● Shared best practices and conducted code reviews.
● Resolved complex challenges through effective stakeholder communication and performance tuning.
Environment: MS SQL Server 2014, Oracle 11g, PowerView, PowerPivot, SSIS, SQL Server Management Studio, Oracle Datamodeler, Oracle Developer, DW, BI, OLAP, ETL.
Data Warehouse Enhancement & Maintenance (Vodafone/Kabel Deutschland):
● Served as Anonymization Team Leader/Key Developer for enhancing and maintaining an existing data warehouse.
● Led the anonymization team, prioritizing tasks, organizing meetings, gathering requirements, and implementing Kanban methodology.
● Designed and implemented a data anonymization framework, including data obfuscation processes, resulting in a solution with over 50 unique functions and a user interface built on Oracle APEX.
● Designed and implemented interfaces for two major telecommunication operators.
Environment: Oracle 11g, SQL Developer, SAP BODS, Oracle Application Express, SVN, Jira, Confluence, ETL, DW, UNIX, Data Obfuscation.
Software Engineer
09.2012 - 12.2013 |ScienceSoft
SQL Server 2008/2012, SSIS, Microstrategy, ErWin, TFS, SQL Server Management Studio, MS Build, BI, ETL, DW
Greenfield Data Warehouse & Analytical Dashboard Development (Retail Company):
● As a Key DW/BI Developer spearheaded the development of a comprehensive data warehouse and analytical dashboards from inception, serving major retailers in the US and European markets.
● Conducted in-depth source data dependency analysis to ensure accurate and reliable data integration.
● Architected and implemented a robust data warehouse from the ground up, utilizing the Kimball methodology for optimal performance and scalability.
● Engineered a sophisticated change data capture (CDC) mechanism, employing full source-to-target comparison, ensuring data integrity and real-time updates.
● Designed a complex BI model for Microstrategy, creating dimension and fact tables and effectively managing balanced, unbalanced, and ragged hierarchies.
● Significantly optimized SQL query performance, ensuring rapid data retrieval and analysis.
● Maintained direct communication with clients, ensuring alignment with requirements and delivering valuable insights.
● Automated the build creation process, developing a two-part (database and Microstrategy) build that supported both full and incremental installations, enabling efficient updates and deployments.
Software Maintenance Engineer
08.2010 - 09.2012 |EPAM Systems
SQL Server 2005, SSIS, SSRS, SharePoint, SQL Server Management Studio, BI, ETL, DW, MS SQL Server 2008/2012, Oracle 10g, TOAD, BIDS, Oracle 10.2, PL/SQL Developer, SQL Loader, ERwin, UNIX, Virtualization
BI Solution Maintenance & Support (Cara Restaurants):
● Served as a Project Coordinator for the technical support and maintenance of a critical BI solution for Cara Restaurants, a franchising company, built on MS SQL Server 2012 and SSRS.
● Streamlined change management by efficiently gathering, prioritizing, and implementing service requests, ensuring rapid response times.
● Enhanced team collaboration through effective knowledge transfer sessions between Minsk and Lviv teams.
● Improved client communication by proactively gathering requirements, providing clear progress updates, and presenting solution implementations.
● Optimized deployment processes by meticulously preparing deployment packages.
● Resolved performance bottlenecks within the BI environment.
Environment: SQL Server 2005, SSIS, SSRS, SharePoint, SQL Server Management Studio, BI, ETL, DW.
Reporting System Support & Optimization (Oil & Gas Company):
● Provided critical monitoring and support for Cognos Web Portal and Cognos Report Studio during system upgrades.
● Reduced downtime by effectively managing incidents, including tracking, analysis, resolution, and knowledge base maintenance.
● Improved data integration efficiency by developing and optimizing ETL scripts and SSIS packages for synchronizing Oracle and SQL Server data warehouses.
● Enhanced reporting performance by configuring and optimizing core reporting services, including report template updates.
● Ensured database stability and performance through proactive SQL Server database maintenance, tuning T-SQL stored procedures, and implementing disaster recovery procedures.
● Improved help desk efficiency by optimizing help desk processes.
Environment: MS SQL Server 2008/2012, Oracle 10g, TOAD, BIDS, SQL Server Management Studio, BI, ETL, DW.
Data Integration & Interface Development (Retail & Distribution):
● Served as an Oracle Developer and Data Modeler for a project focused on creating a new data export interface.
● Accelerated data integration by developing, updating, executing, and optimizing SQL and PL/SQL scripts.
● Improved stored procedure performance by reducing execution time from 30 minutes to 5 minutes through effective SQL and PL/SQL tuning.
● Provided informal team leadership by coordinating database development activities.
● Contributed to interface design and implementation.
● Facilitated smooth knowledge transfer to both internal and external support teams.
● Automated data loading by utilizing SQL Loader and Korn/Perl scripts to import external CSV data into Oracle databases.
Environment: Oracle 10.2, TOAD, PL/SQL Developer, SQL Loader, ERwin, UNIX, ETL, Virtualization.
Software Engineer
07.2009 - 07.2010 |Group of company Alutech
Firebird, Delphi 6, IB Expert, Database Comparer, Fast Report, OLTP, Ad-Hoc Reporting
● Developed, supported, and ensured seamless application-database interaction for critical business applications.
● Empowered junior users by creating a user-friendly designer mode for gate creation and calculation, simplifying complex tasks.
● Enhanced reporting capabilities by implementing an ad-hoc reporting feature within the main gate parameter calculation solution, enabling flexible data analysis.
Systems Administrator
11.2007 - 05.2009 |Belsoft-Borlas Group
MS SQL 2005, SharePoint Designer, SQL Server Management Studio, SharePoint, OLTP, Ad-Hoc Reporting
● Administered and maintained Microsoft SharePoint Server: created and configured new sites, provided user training, and implemented regular backup procedures.
● Provided comprehensive technical support: installed and configured Windows operating systems, maintained and replaced hardware equipment.
Software Engineer
11.2005 - 11.2007 |Minsk Automobile Plant
Oracle 8i, MS SQL 2000, Visual FoxPro, Delphi 7, PL/SQL Developer, TOAD, SQL Plus, OLTP, Ad-Hoc Reporting
● Developed a comprehensive system for production and inventory management.