Scroll To View More
Sergey Larionov, SQL Developer in Wrocław, Poland
Sergey Larionov

SQL Developer in Wrocław, Poland

Member since February 23, 2018
Sergey is an Informatica PowerCenter certified specialist with about ten years of experience building scalable projects and systems using Oracle, SQL Server, DB2 or Informatica platform. He enjoys working on challenging data projects and making easy to handle large data systems.
Sergey is now available for hire

Portfolio

Experience

  • SQL, 18 years
  • Informatica PowerCenter, 10 years
  • Linux, 10 years
  • Oracle, 10 years
  • Bash Scripting, 8 years
  • Sybase PowerDesigner, 6 years
  • Oracle SQL Data Modeler, 5 years
Wrocław, Poland

Availability

Part-time

Preferred Environment

Windows, Linux, Unix, Oracle, MS SQL Server, IPC

The most amazing...

...thing I've coded is a mechanism to run Informatica PowerCenter workflows by schedule and by demand. It reacts on a workflow status and can send notifications.

Employment

  • Developer

    2017 - PRESENT
    Volvo IT (Poland)
    • Developed workflows set to load data from DB2 to Netezza.
    • Test loaded data using a QuerySurge tool.
    • Set up a QuerySurge tool.
    • Created a shell script to set some values depending on environment.
    Technologies: PowerCenter, Netezza, DB2, Oracle, SQL, Linux scripting
  • ETL Developer

    2015 - 2017
    Credit Suisse (Poland)
    • Supported an inherited Oracle SQL code (procedures, triggers, etc.) without any documentation.
    • Serial development of a PowerCenter objects list.
    • Developed a semi-automated SQL test engine.
    • Built a semi-automated OBI reports test engine.
    • Provided deep SQL code analysis and automation in order to find dependencies.
    • Created SQL ETL procedures with merge.
    • Built a Python-based XML objects comparison tool, allowing to skip not-interesting tags.
    Technologies: MS SQL Server, PowerShell, Windows, SPSS, PowerCenter, Oracle
  • ETL Developer

    2013 - 2016
    Orient Express Bank (Russia)
    • Serial development of Informatica PowerCenter objects;
    • Developed a Run Queue management system, which is able to run IPC workflows based on timetable or event. There is an ability to limit an amount of process running in parallel to control the load and performance, notification system which allows to inform users in case of load failure or delay.
    • Created a platform which is able to automatically generate all the code to create/update IPC objects ob the basis of source fields list.
    • Designed an automatic testing system.
    • Developed and supported VBA extensions of PowerDesigner, allowing to automatically generate set of child objects on the base of the parent one.
    Technologies: Informatica PowerCenter, SQL, Oracle, Linux, PowerDesigner
  • ETL Expert Developer

    2011 - 2013
    Bank of Moscow (Russia)
    • Developed a distributed Change Data Capture (CDC) system on the basis of a trigger set.
    • Built a Web-Services based system to initiate data load processes from remote branches.
    • Created a multi-instance parallel data load processes from remote branches to a single target object.
    Technologies: Informatica PowerCenter, SQL, Oracle, Linux, Oracle Data Modeler
  • ETL Developer

    2008 - 2011
    Data Integration Software (Russia)
    • Contributed as a consultant at huge variety of different customers (banks, telecom operators, insurance companies, etc.).
    • Supported and developed of Informatica PowerCenter objects on the basis of technical design.
    • Created testing documentation, test scenarios, cases, and reporting to a customer.
    • Distributed tasks among team members, tasks execution control, reporting to customers. Team contained max. 10 members (1 architect, 3 analysts, and 6 developers).
    Technologies: Informatica PowerCenter, SQL, Oracle, Linux, MSSQL Server, DB2, Teradata, Netezza
  • Software Engineer

    2004 - 2008
    Konica Minolta Photo Imaging (Russia)
    • Created a technical support database, allowing to gather all services provided over technical equipment.
    • Developed a marketing reporting system to show photo film sales over regions/brands.
    • Tested distributed automatic photo shop system.
    • Built an exhibition database, allowing to sign to lectures, and printing badges.
    • Developed a training department database allowing to plane lectures, distribute them among trainers, and print certificates.
    Technologies: MS SQL Server, MS Access, PowerDesigner, Delphi

Experience

  • Integration of Mobile Billing System with Bonus Card System (Development)

    I had to export data from the billing system to the flat file(s), then send them to remote FTP. After response from bonus card system I had to download changed files and merge the data into the billing again.

    Conditions - each file had to contain no more than max amount of records + records groups had to be placed in a single file, group breaks were prohibited.

    Tools used - Informatica PowerCenter, Oracle, bash.

  • Training Team Calendar (Development)

    A small project where I had to create an accounting system for a training department. They wanted to have a calendar with ability to order rooms, to plan trainings separately for each trainer.

    Tools: MS SQL Server, MS Access;

  • ODS for a Bank (Development)

    I had to create Change Data Capture (CDC) system for a set of remote branches on the basis of Oracle triggers. Then this data had to be periodically gathered and an ODS had to be created using this data.

    Tools: Oracle, Informatica PowerCenter, IPC Web Service Hub.

  • Script to Operate With Files (Development)

    A bash script was created which is able to copy/move files selected by complex conditions between FTP/SFTP/SAMBA/Local sources/targets. Each instance is controlled by a control file, containing source/target type, paths, filters, additional settings (if files are to be processed somehow during the transfer, if they are to be compressed/uncompressed, etc.)

    Tools: bash scripting.

  • IPC Workflows run Tool (Development)

    The task was to create a framework able to start IPC workflows by event or by timetable, control the amount of processes running in parallel, notifications in case of failure, to provide process dependencies etc.

    Tools: Oracle, IPC.

  • OBIEE Regression Testing Tool Based on Excel/VBA (Development)

    The task was to compare data from two different OBIEE servers. An Excel file was created holding all possible combinations of report source fields. This Excel was able to connect to two OBIEE servers, ask to generate reports with sets of filters applied and compare the results.

  • IPC Objects Generator. (Development)

    An IPC contains an ability to generate mappings using template and source metadata (tables description). A set of templates was created + an semi-automatic system generating source data for them on the basis of changed definitions taken from PowerDesigner model.

Skills

  • Languages

    Bash Script, SQL, XML, Python, Visual Basic for Applications (VBA)
  • Tools

    Informatica PowerCenter, Sybase PowerDesigner, Oracle SQL Data Modeler, Oracle Application Express (APEX)
  • Platforms

    Windows, Oracle, Linux, QlikView
  • Libraries/APIs

    Beautiful Soup
  • Storage

    IBM DB2, Teradata, SQL Server 2008, Netezza
  • Other

    Bash Scripting

Education

  • PhD in Electric Power, Informatics
    1999 - 2004
    Moscow Aviation Institute - Moscow, Russia
  • Bachelor of Engineering degree in Radioelectronics
    1993 - 1999
    Moscow Aviation Institute - Moscow, Russia
Certifications
  • PowerCenter Data Integration 10 Developer, Specialist Certification
    SEPTEMBER 2017 - PRESENT
    Informatica University
  • PowerCenter Data Integration 9.x Administrator, Specialist Certification
    AUGUST 2017 - PRESENT
    Informatica University
  • DEV523. Advanced Modeling Techniques using PowerDesigner 15
    SEPTEMBER 2010 - PRESENT
    SAP Russia
  • ERL15 AllFusion ERwin Data Modeler;
    JUNE 2009 - PRESENT
    Moscow Training Center
I really like this profile
Share it with others