Andrey Luzhin

• Project’s data base design and development: implemented new logic, added flexibility, DWH for real-time reporting. Final code/scripts/features review. • Analytics and statistics project development (from scratch): over 10000 different types of data being collected and analyzed. Data analysis, PL/SQL, Transact-SQL, Excel, Oracle BI. • Multiple databases integration (over 25 independent DBs, including MS Access, FoxFro & etc.), ETL (SQL & Python scripting, Pentaho Data Integration, raw data analysis).

• Statistics & data analysis for the project. SQL script development (PL/SQL, T-SQL). • Analyzed and documented the project (more than 20 mln units of various types, about 20 sources of data receiving, incl. the data from devices). Database architecture, structure, design & code review. Project technical scope and limitations defining. • Integration of independent DBs into project, ETL. Project DB structure adaptation. Troubleshooting (fixpacks, data verification and correction, developers support).

Key responsibilities: • Developing analytical reports (Oracle BI reports design) • Developed and maintained web portals (HTML, CSS, JS, PHP, Drupal, Perl, analytics and statistics) • Communication with prefectures and public institutions of engineering services as part of the city web-portal maintenance

Key responsibilities: • Software development (Delphi, Perl, PHP, SQL) • Industrial Safety Group LAN administration and data protection (Windows servers, Active Directory, FreeBSD, VPN, Kerio WinRoute Firewall, Kaspersky Business Space Security, StarForce)