01/16/2024 updated

MS
100 % available

Senior Integration Analyst & Biztalk Developer

Bruxelles, Belgium
Worldwide
Postgraduate Managerial Studies, profile: IT Project Management / 2011-2012 / University of Warsaw / Warsaw, Poland Master of computer science, profile: Management, specialization: computer science in economy / 2001-2003 / Academy of Management in Katowi
Bruxelles, Belgium
Worldwide
Postgraduate Managerial Studies, profile: IT Project Management / 2011-2012 / University of Warsaw / Warsaw, Poland Master of computer science, profile: Management, specialization: computer science in economy / 2001-2003 / Academy of Management in Katowi

Profile attachments

CV - Marek Siwek

Client Server ModelsComputer ProgrammingExtract Transform Load (ETL)Database ApplicationDatabase QueriesMiddlewareFinancesPublic ServiceVenta al por MenorSoftware EngineeringSystems IntegrationTestingLifecycle Management
Solid software development (integrating, implementing, designing, programming, testing) experience with middleware and client-server technologies
Experience with Extract, Transform and Load (ETL) and system integration tools
Excellent skills on database query, design, develop, tune, migrate and support database applications and solutions
Expertise in full lifecycle development
Attitude and ability to “think outside the box”
Strong track record working across functions cooperating with IT
Strong knowledge of the Financial Services (public sector), Banking industry (retail & investment) and Logistics

Experience

Professional experience10+ years
Freelancer since2014

Languages

GermanBasic knowledgeEnglishFluentFrenchGood

Project history

Sr Integration Analyst/Developer/Architect

AG INSURANCE (BRUSSELS, BELGIUM)

Insurance

>10.000 team member

Responsibilities:
  • As Sr Integration Analyst/Developer/Architect
    • Implementation of tasks related to the migration of the Mainframe system to Micro Focus Server (server virtualisation),
    • Software modernization, migration to another environment, technology, improvement, performance optimization,
    • Leading analysis and development of creating tools, services and interfaces used by developers,
    • Review, solution optimization, code optimization,
    • Creating and publishing software packages used by other developers (NuGet package) for .Net, Biztalk and Azure solutions,
    • Monitor Azure resource utilization and actively plan and implement performance optimization and cost efficiencies,
    • Designing solutions, proposing and presenting changes, preparing technical and user documentation,
    • Maintaining and creating new communication channels for communication within a closed system (inter-operability like TCP, Named Pipelines),
    • File-based queue creation, log file rollover, log archiving systems,
    • Building a visual file management system and an editor for mainframe file systems (datasets) for the Windows environment,
    • Maintaining the code repository, preparing the build, publishing the code (D/Q/A/P), publishing to the NuGet Gallery,
    • Gathering, documenting and managing customer (developers) requirements (Azure DevOps).
    • Resolving incidents related to the operation of components, configuration, access in complex and disperse systems,
    • Providing support in the field of training, mentoring in the field of technology and development tools,
    • Create a test plan, execute tests, report test results
    • Building custom testing tools, executing tests (load test, smoke test, performance test)
    • Resource/infrastructure monitoring and its health/performance components.
TECHNICAL ENVIRONMENT
C# .Net Core/Framework, ASP.NET, C/C++, Microsoft Team Foundation Server, Azure DevOps, CI/CD, Microsoft PowerShell, Python, WPF .NET, Entity Framework, Object-relational mapping (ORM), UML, Inter-process Communication (IPC), TCP Communication, Microsoft Excel Pivot Tables, Microsoft Power BI, Microsoft SQL Server, Microsoft SSMS, T-SQL, Microsoft Biztalk, XML, Web API, REST, SOAP, Microsoft IIS, Azure Service Bus, IBM MQ, Azure Functions, Azure Logic Apps, Event Grid, API Management, Azure Integration Services, Azure AD, Micro Focus Server, IMS, Visual Cobol, JCL, IBM DB2, Serilog, Postman, SPFLite, SQLite, Logz.io, Microsoft System Center Operation Manager (SCOM), Identity and access management (IAM), SDLC, Microsoft SharePoint, Microsoft Visio.

Sr BizTalk Integration Analyst/Developer/Architect

BIDFOOD S.A. (THUIN, BELGIUM)

Transport & Logistics

>10.000 team member

Responsibilities:
  • As Sr BizTalk Integration Analyst/Developer/Architect
(Biztalk Server Administration & Platform Modifications)     
    • Configure Network Access, Database Infrastructure and Distributed Transaction Coordinator Services (MSDTC)
    • Maintain environment uptime by monitoring BizTalk Server exceptions and resolving BizTalk Server specific issues
    • Scaling Out the BizTalk Server for performance, Long transactions, Large Messages
    • Create of new Hosts, adapters, Monitor and Debug the UAT, PRD Platforms, Job scheduling and monitoring
(Release Management)
    • Plan and coordinate the release of project deliverables for Biztalk Applications, third-party applications and infrastructure updates
    • Deploy and configure the BizTalk solution to development, test, staging and production environments
    • Lead the Go-Live activities after successful deployment of the software
(Operations Support)
    • Work with the Application Management team to provide support for existing application portfolio; Timely resolution of problems and inquiries from the Business
    • Technical troubleshoot integration issues in all stages of SDLC
    • Support for any new changes, environmental, configurational, organisational, software, hardware.
(Biztalk Development & Test)
    • Using various integration tools, techniques, patterns, languages, transformations, components and other related methodologies to deliver a working solution (BTDF, ESB, ETL, WSDL, orchestrations, schemas, maps, transformations, custom pipelines, custom functions, adapters, etc)
    • Working on updates or amending functionality like upgrades, migrations or linking to multiple system platforms (for example: IBM AS/400, SAP)
    • Apply unit testing approaches to all software developed, support project testing activities
(Database Development & Management)
    • Objects & Schema design (logical and physical), SQL query tuning
    • Create complex functions, scripts, stored procedures and triggers to support application development, performance tuning (SQL, DB2)
    • Develop and manage the related automated tasks
(Analysis)
    • Involved in scoping projects and helping teams understand the best integration solutions, lead and participate in design workshops,
    • Deliver in-depth and breadth technical and not excluding business expertise related to project
    • Document necessary integration architecture design and analysis work
(Design)
    • Provide tailored architecture, design and development services to a portfolio of integration and automate business processes projects (EAI, B2B, ESB)
    • Review and integrate application requirements, including functional, security, integration, performance, and quality
    • Work proactively, together with a project team or individually, to deliver technically proficient and sustainable integration solutions
TECHNICAL ENVIRONMENT
Microsoft BizTalk Server 2013-2016, BAM Portal, Microsoft Visual Studio 2012-2019, Microsoft SQL Server 2010-19, SQL Profiler, SQL Server Management Studio, NET / C#, Microsoft Azure, Azure DevOps, Azure Pipelines, CI/CD, WCF, SQL, XML, XSD, XSLT, Xpath, SOAP, WCF, REST, HTTP, (S)FTP, WSDL, API, SOA, Microsoft SSIS, SSRS, AS400, IBM DB2, Lotus Notes, IBM MQ Series, Microsoft Team Foundation Server, PowerShell, BTDF/Deployment Framework, Agile, Jira, Confluence, Web Services, .NET Framework, .NET Core Framework, ASP.NET MVC (patterns: SoC, DI, IoC), O/RM, Entity Framework, LINQ, Serilog, Moq, Postman, Soap UI Tool, OAuth2, XSRF
DESIGN PATTERNS
Biztalk: Aggregator/Splitter Design Pattern (Batching/De-Batching), Sequential Convoy Pattern (Correlation Types), Message Throttling Pattern, Filter, Broker, Error Handler
Web Services: Model View Controller (MVC), Separation on concerns (SoC), Dependency Injection (DI), Inversion of Control (Ioc), Microservices, Service bus

Sr Software Engineer / Oracle PL/SQL Database Developer Expert

European Commission (BRUSSELS, BELGIUM)

Government and Public Services

>10.000 team member

Responsibilities:
  • As Sr Software Engineer / Oracle PL/SQL Database Developer Expert
    • Creates system solutions by developing, implementing, and maintaining components, packages and interfaces,
    • Follow all the IT software development processes from the business modelling to the test of RUP disciplines,
    • Production of functional and technical analysis documentation and specifications in line with business requirements,
    • Analysis of requirements, feasibility and current system behaviour,
    • Development and maintenance of existing SQL and PL/SQL source code, views, stored procedures, triggers, packages,
    • Advising on Oracle features and on the best practice and optimal approach in the use of PL/SQL,
    • Database tuning and performance monitoring, conduct performance tests and optimize developments to improve performance from an end to end perspective,
    • Monitor, identify, investigate and proactively communicate problems or system issues and recommend solutions,
    • Routinely use pairing techniques in programming, code reviews, system design and requirements analysis,
    • Support releases in accordance with development life cycle.
TECHNICAL ENVIRONMENT
Oracle Database 11g, Adobe ColdFusion, SQL, Oracle PL-SQL, JavaScript, HTML, UML, PL/SQL Developer 10, Eclipse Juno 4.2, RUP, Jira Project Management Software, Confluence, GIT 1.9, Microsoft Windows, Microsoft Office 2010.

Technical Lead - PowerBuilder & Sybase Designer / Developer

Bank of Ireland

Banking & Financial Services

>10.000 team member

Responsibilities:
  • As Technical Lead - PowerBuilder & Sybase Designer / Developer
    • Design/Development of change to PowerBuilder/ Sybase applications under:
OMNI Replacement Programme (migration from Sybase platform to IBM MQ Series/DB2 environment, more than 100 applications involved) and
      • Design and develop changes to bank applications (written in PowerBuilder and Sybase),
      • Application support to developments and all test phases onshore/offshore,
      • Provide technical supervision of changes implemented by Dell offshore developments,
      • Engagement with IBM, infrastructure change, tech services,
      • Submission of application changes for packaging & release by IBM.
    • Design/Development of change to PowerBuilder/ Sybase applications under:
Retail Branch Desktop Applications Windows 7 Compatibility Assessment Programme (applications migration from Microsoft Windows XP 32 bit to Microsoft Windows 7 64-bit environment, more than 100 applications involved)
      • Acting as a Subject Matter Expert (SME), provide input to the development of business and functional requirements,
      • Working closely with other staff, such as project managers, system architects, designers, developers, systems analysts,
      • Integrating existing software products by getting incompatible parts of software to work together with new OS platform,
      • Writing and testing code and then refining and rewriting as necessary,
      • Participation in User Acceptance Testing (UAT) to obtain confirmation that the system meets Clients requirements.
TECHNICAL ENVIRONMENT
Sybase PowerBuilder 10.5, Sybase ASE 12.5 and 15.5, IBM DB2, IBM MQ Series, Microsoft Office 2010 Package, Agile Project Management, SQL Transact, Visual Basic, VB.Net, AS/400, Microsoft Yammer, Microsoft Lync.

Senior Application Analyst / Developer

SOCIETE GENERALE, CORPORATE AND INVESTMENT BANKING (WARSAW, POLAND)

Banking & Financial Services

>10.000 team member

Responsibilities:
  • As Senior Business Analyst
    • Contributing of key in the definition of both functional and non-functional system requirements and defining development strategy,
    • Translating business requirements into detailed design documents,
    • Design data models and diagrams based on business and technical requirements,
    • Conducting user acceptance tests, collects defect density, code coverage and complexity metrics,
    • Development and maintenance of a working knowledge of the business applications to enable effective support.
    • Participation in system migration and integration projects
      • GLOBAL TOOLS – analytical support for replacing banking IT systems
      • Analytical support for replacing banking IT systems,
      • Identifying system platforms, components, inputs, interface requirements, and dependencies which ensure that the new system will achieve its objectives,
      • Planning and executing integration of an applications into the computing environment,
      • Provide user support through analysis and problem solving to facilitate installation, implementation, maintenance, education and documentation of computer hardware and software systems,
      • CUSTODY2 – gathering requirements, analyse, assess and map data structure, perform data migration (from Sybase to Oracle based system),
      • Responsible for gathering requirements, analyse, assess and map data structure, perform data migration (from Sybase to Oracle based system),
      • Review and monitor the new implemented set of systems to ensure that the original client requirements are achieved and that the system meets acceptable levels of reliability, integrity and performance,
      • Provide input to the usability experience while using/testing delivered software products, etc.,
      • Integrate various technologies, systems, applications, database and components across multiple platforms
  • As Senior Programmer (PowerBuilder, Oracle)
    • Writing source code, adapting existing components, testing the developed components, and creating test data as necessary,
    • Working closely with users to ensure the project meets business needs,
    • Designs new program functionalities by analysing requirements, constructing workflow charts and diagrams, writing specifications,
    • Using appropriate performance metrics to monitor, optimize and troubleshoot system performance
    • Provide technical deliverables for a number of banking applications (built using Sybase PowerBuilder)
      • HVT – High-Volume Transaction System, local IT banking system,
      • SORF – System for Settlement of Futures for Security Services (Custody) Department              
TECHNICAL ENVIRONMENT
Sybase PowerBuilder Classic 12.5, Sybase ASE, Sybase PowerDesigner, Microsoft Visual Studio 2010 (C#), Java 6, Eclipse, Thomson Reuters Kondor+, Informatica PowerCenter, Oracle, CVS, SVN, Microsoft SQL Server, Microsoft Excel, Microsoft Visual Basic for Applications (VBA), Microsoft Project, Lotus Notes (Lotus Script), Prince2, Scrum Agile Project Management, ETL, Microsoft.NET, Business object, Windows Server, Unix, Microsoft Visio, SQL Transact, Cobol, XML, XSLT, XPath, Sybase Adaptive Server, Windows Scripting, Java SE, Windows PowerShell, Microsoft SharePoint, Jira, Confluence


Application Analyst / Developer

SKG PLC (ASSECO GROUP) (BIELSKO-BIALA, POLAND)

Internet & IT

50-250 team member

Responsibilities:
  • As Theme Leader:
  • Provide expertise and support as a theme leader of software modules: local administration and central administration, liquidation of commodities, execution of debts,
  • Engage with and supporting all aspects of the user acceptance testing
  • As a Financial Software Trainer:
  • Produce training documentation, materials and certification for products and technologies,
  • Deliver training to Client theme leaders in Client training centres across the country
  • As a Tester, User Manual Writer:
  • Prepare a testing plan with various parameters,
  • Prepare bug reports of the tests conducted on the software
  • As an Analyst:
  • Performs business analysis activities, such as requirements analysis, business process modelling, and the creation of use cases, business rules, glossaries, diagrams, user interface, and responsibility specifications,
  • Document and revise functional requirements and specifications,
  • Conduct internal and external presentations to demonstrate executable software
  • As a Programmer:
  • Produce detailed specifications and writing the programme codes
  • Convert requirements into software modules and applications
TECHNICAL ENVIRONMENT
Sybase PowerBuilder, PFC Library, Sybase ASA, ASE, AIX, CASE tools, IBM Rational Rose, UML, Microsoft Source Safe, IBM Rational Robot, Prince2 Project Management, SQL Transact, XML, XSLT, XPath, Windows Server, C/C++, Sybase PowerDesigner, Microsoft Office automation, VBA, Microsoft Visio, Microsoft Project, Linux, HTML, XHTML, DHTML, CSS, JavaScript, ASP, PHP, Mantis

Certificates

Microsoft Certified: Azure Solution Architect Expert

Microsoft

2023

Microsoft Certified: Azure Developer Associate

Microsoft

2022

Microsoft Certified: Azure Administrator Associate

Microsoft

2022

Microsoft 70-483 Programming in C#

Microsoft

2020

Microsoft 70-487 Developing Windows Azure and Web Services (C#)

Microsoft

2020

Microsoft 70-486 Developing ASP.NET MVC4 Web Applications

Microsoft

2020

Microsoft 70-487 Developing Windows Azure and Web Services (C#)

Microsoft

2020

Microsoft 70-486 Developing ASP.NET MVC4 Web Applications

Microsoft

2020

Microsoft Certified Solutions Associate (MCSA): Web Applications

Microsoft

2020

Microsoft Certified Solution Developer (MCSD): App Builder (C#)

Microsoft

2020

Microsoft Certified Professional (MCP) on: MS SQL Server 2000, MS Windows® Server 2003, MS Windows® XP Professional

Microsoft

2010

Microsoft Certified Database Administrator (MCDBA) on Microsoft SQL Server 2000

Microsoft

2010

Sybase Certified PowerBuilder 10 Developer Professional (CPD)

Sybase

2010

Oracle 10g Database: SQL Certified Expert (OCE)

Oracle

2010

Oracle 9i PL/SQL Developer Certified Associate (OCA)

Oracle

2010

Microsoft Certified Technology Specialist (MCTS) in SQL Server 2005

Microsoft

2010

Microsoft Certified Technology Specialist (MCTS): Developing Business Process and Integration Solutions by using Microsoft BizTalk Server 2006

Microsoft

2010

Contact form

Log in to get in touch

You need to be logged in to use the contact form.

Sign upLog in