Andrey Skudar

Senior

Registration: 13.04.2022

Specialization: Data engineer, data architect, software developer

Technical Skills: Data Warehousing: Understanding of Data Warehouse construction and design (Data vault, Achor modelling including). Skills to model complex ETL-processes. Skills to plan productivity of ETL-processes. Development of Data Warehouse structure, data regions, and datamarts. Deep understanding of MPP architecture (Teradata, SAP HANA, Snowflake, etc) Oracle Database (as OLTP platform) and common SQL dev skills : Able to carry out any client tasks on database development. Deep understanding of Oracle Architecture. Excellent SQL skills. Ability to build queries of any complexity (including analytics, advanced data groupings and aggregation, other Oracle-specific extentions for SQL). Serious experience in optimization of SQL queries and applications as whole. Skills to read and understand execution plans and adjust them using various approaches. Able to develop both server and client program modules of any complexity. Performance tuning: Solid knowledge regarding instance-wide performance tuning and analysis. Skill to read and understand tkprof and statspack reports, PDCR reports, other performance tracking techniques. Programming languages and technologies: Python. Skilled in programming environments: Quest Software TOAD, SQL Navigator, PL\SQL Developer, PyCharm, Oracle Reports, BI Tools, SAS DIS, ODI, etc. Database design in ERWin environment. Applied and office programs - in all variety.

SQL Oracle Teradata Big data Dwh ETL Python

Portfolio

Barclays Bank

Senior Software Developer

Teradata

PS Consultant

FEDERAL FREIGHT

Head of applications and DWH support

Skills

DWH

ETL

ORACLE

Teradata

SQL

DB optimization

Python

Big Data

Clouds

Analytical skills

Work experience

PS Consultant

12.2018 - 02.2022 |Teradata

IT, System Integration, Internet • Software Development • System Integration, Technological and Business Processes Automation, IT Consulting Business Services • Consulting Services Lead data engineer. ETL developing and refactoring, optimization (SAS DIS, stored procedures, shell scripting, Python, spark). BigData projects on Hadoop and Teradata platform for telco and bank clients. Leading developers team. Pilot projects in clouds (AWS, Oracle clouds, Snowflake, dbt + Matillion ETL)

Principal database developer

04.2015 - 11.2018 |Fazis, LLC

IT, System Integration, Internet • Internet Company (Search Engines, Payment Systems, Social Networks, Information and Educational, Entertainment Resources, Website Promotion etc.) Principal software engineer and solution architect • Development of server side platform of gaming internet site (Oracle 11g). • Expertise at Oracle RDBMS. • Optimization and refactoring a lot of legacy code. • Help and consultations to the team on the choice of database technologies/development techniques. • Leading at security control, fraud control projects. • Planning of business and technology extension. • Help to the support team with resolution of production issues and satisfaction of customer requests or complaints

Head of applications and DWH support

02.2014 - 04.2015 |«FEDERAL FREIGHT», JSC

Transportation, Logistics, Warehousing, International Logistics • Rail Transportation DWH architect, head of ETL development. • Complex project with many heterogeneous sources, real time ETL, staging on Oracle platform and data marts on SAP HANA. • Development of real time ETL (Informatica PowerCenter, PowerExchange). • DB modelling and optimization (SAP HANA, Oracle). • DWH development planning. • Expertise at Oracle RDBMS, DWH concepts • Experience with SAP HANA, Informatica PowerCenter, PowerExchange was gained.

Senior Software Developer

01.2012 - 01.2014 |Master-Bank

Financial Sector • Banking DWH architect, Principal ETL developer • Development of a corporate DWH architecture on Oracle 11g platform, development planning. • Data sources analysis (own ABS and Online Banking, Way4), business requirements analysis. DWH modeling, design and development of real time ETL processes (Golden Gate, ODI). • Development of card processing analytical reports. • Expertise at Oracle RDBMS, DWH, BI, Way4. • Finished several acquiring reports for merchants.

Senior Software developer of Cards Unit

08.2008 - 01.2012 |Barclays Bank

Financial Sector • Banking Lead software engineer of cards processing system. (Way4, Oracle) • Extension and customization of server-side part of Openway Way4 cards processing system. • Development and integration of new card products and services - Internet Banking, 3DSecure E commerce etc.) • Refactoring and optimization of former card products, reports, applications. • System analysis of Way4. • Development of specification and requirements for new card products. Expertise at Oracle RDBMS, DWH, BI • Help to the support team with resolution of production issues and satisfaction of customer requests or complaints. • Completed all mandatory regulatory reporting for Bank cards from near zero. • Developed plenty of accounting, regulatory and management cards reports. Most of the old reports were rewritten and were made more efficient, fast and robust. • Good knowledge of cards processing, banking systems was gained

PS Consultant

03.2006 - 08.2008 |Teradata, LLC

IT, System Integration, Internet • System Integration, Technological and Business Processes Automation, IT Consulting Lead Data engineer. • Design and development of ETL processes for feeding the Data Warehouse and Internet Bank. • Leading 3rd party contractors including ETL quality assurance. • Physical database design. • Consultations to the customers. • Any other post-sale activities as appropriate. Expertise at variety of technologies: • Oracle Data Integrator (formerly Sunopsis), Oracle RDBMS, Teradata RDBMS, Teradata SQL, Load/Unload Utilites, application development techniques. Successfully finished several projects with Teradata: • DWH deployment. • Internet Bank and DWH integration. • Custom Statements Print. • I got strong knowledge of Teradata technologies and Data Warehouse construction and design. • "Master teradata" degree received.

Lead Software Engineer

08.1998 - 03.2006 |«Intellex», JSC

IT, System Integration, Internet • Software Development Team lead • Development of cargo transportation management system for Russian railroads (RRR) as leading developer. (Delphi, Oracle) • Leading at several sub-projects. • Development of Master Data Management system for RRR as architect, team lead. (Delphi, Oracle) • Participated in performance control and optimization project for RRR as oracle expert. • Physical database design. (Oracle) • Participated in reporting project for planning department of RRR as architect and project manager (DWH on Oracle platform, Business Objects) • Working with the customer - from definition customer requirements to training of personnel. • Code reviews for all new database code developed by the team. Achievements: • Very big project of cargo transportation management system was implemented in production and 100% of RRR cargo transportation is performed by this system now. • Large experience server-side developing gained. I got strong knowledge of Oracle SQL, PL\SQL, physical design, optimization on statement, database and instance level. • Good experience of leading up to 5 juniors including remote ones.

Software engineer

02.1997 - 08.1998 |«Dive», LLC

IT, System Integration, Internet • Software Development Key responsibilities: • Development of pass control system for Moscow underground. (Delphi) • Server side development of several projects for Russian Development. (MSSQL) • Design and development of bug tracking application for internal company users. Achievements: • Projects were successfully finished. • My bug tracking application was used in company for more than 10 years. • I got good experience of client and server development.

Educational background

Theoretical physics (Masters Degree)

1992 - 1996

National Research Nuclear University 'MEPhI', Moscow

Languages

EnglishIntermediateRussianNativeUkrainianAdvanced