Irina Fikhgendler

* Lessons
* Practical tasks
* Recommendations for good teaching materials
* Advices about next steps

* Lessons
* Practical tasks
* Recommendations for good teaching materials
* Advices about next steps

* User guides
* Design & Development inner documentation
* Status documents

On Russian and English, e.g.:
https://www.linkedin.com/feed/update/urn:li:activity:6372043655062126592
https://www.linkedin.com/feed/update/urn:li:activity:6376440462747725824
https://www.linkedin.com/feed/update/urn:li:activity:6377926019856244736
https://www.linkedin.com/feed/update/urn:li:activity:6377927114766708736
https://www.linkedin.com/pulse/what-i-miss-memsql-irina-fikhgendler/

* System Analysis
* Design & Development
* Team, Projects, DBA leading
* Problems solving

* In each project with REST API
* For integration JS libraries

* Development ETL processes with SQL Server Data Tools between SQL Server and Hadoop/Impala, AWS S3 buckets, REST API
* Updating the tabular model and creating repors

Integration into application the Python ML libraries

Integration the external libraries and utilities by different ways (e.g., data pipelines, Power Shell, XML, Json, launcher applications, REST API, etc.)

* ETL projects using C#
* Tools and utils development with C#
* Data-driven applications development with C#
* Data layer and business logic implementation with C#

* Bash (MySQL monitoring and partitioning automation)
* cmd (deployment complex applications including databases)
* Power Shell (migration from MSSQL to MySQL with corresponding tables structure changing)

* Full development life cycle
* Especial parts of system: databases, tools, utils, etc.

* Modelling
* Programming
* Revers engineering
* Data migration

NEW PROJECTS
* Data structure modeling
* DB creating (tables, relations, constraints, views, indexes)
* DB coding (queries, scripts, stored objects: functions, procedures, triggers)
* Filling look-up tables
* Creating data layer classes for required programming language (C#, Python, etc.)
* Implementation ETL
* Full documentation including SQL and utils written to create/fill/test databases
* Training the users
* General naming convention and general code style to simplify understanding and support

LEGACY PROJECTS
* Reverse engineering
* Partly or full redesign
* Deployment new versions with minimum (or even without) down time
* Problems discovering and fixing
* Performance improvement
* Migration between different DB server types

* Power Builder to creating production systems and dev/test tools
* Power Designer to DB modelling

NEW PROJECTS
* Data structure modeling
* DB creating (tables, relations, constraints, views, indexes)
* DB coding (queries, scripts, stored objects: functions, procedures, triggers)
* Filling look-up tables
* Creating data layer classes for required programming language (C#, Python, etc.)
* Implementation ETL
* Full documentation including SQL and utils written to create/fill/test databases
* Training the users
* General naming convention and general code style to simplify understanding and support

LEGACY PROJECTS
* Reverse engineering
* Partly or full redesign
* Deployment new versions with minimum (or even without) down time
* Problems discovering and fixing
* Performance improvement
* Migration between different DB server types

REAL TIME ANALYTICS (MemSQL, Kafka)
* Creating DB, data structure and stored objects, pipelines and ETL processes

DATA SCIENCE (Python)
* Integration ML libraries, e.g., clustering the users of social network

MS BI (MSSQL + Data Tools, Hadoop, Impala, S3 AWS CLI, REST, C#, Tableau)
* Creating the data structure and stored objects
* Development ETL processes (to Anodot, from AppsFlyer, etc.)
* Implementation the reports

* Development the modules requiring integration the scientific and ML libraries and fast visualization the results
* Preferable IDEs are Anaconda 3 and VS Python Tool

* Querying Hadoop via Impala
* Querying Hadoop/Impala from linked SQL Server stored procedures
* Creating Tableau reports on Hadoop/Impala
* Development ETL process Hadoop/Impala - SQL Server

* Prototype rapid development
* Indexing background process

* 10+ years in online games back-end development
* Databases
* Notification, marketing, affiliate and retention systems
* ETL processes and other BI tasks
* Significant contribution to the data platform and key data-driven applications of successfully sold startup HOF

* Data-driven applications
* Test tools
* Automation tools
* Layers, modules, libraries, classes

GRAPH DATABASES (Neo4j)
* Writing the queries (Cypher + APOC)
* Creating C# libraries for social network based on Neo4j graph
* Creating C# application to test mentioned libraries
* Implementation subgraphs visualization (Alchemy.js, CefCharp)
* Creating the millions test users
* Integration the Python to
** Reading from Neo4j and clustering the users with ML libraries
** Visualization the plot "Andrews curves" (Pandas) to evaluate the results of multidimensional vectors clustering

* Creating own applications on C#
* Using existed tools