Dipl.-Ing. Lazar Nakinov

Senior BSS consultant in West and Central Europe working for several largest Telecom operators in RWCE, RMED and RMEA regions; Most of my time I am spending in troubleshooting & tuning complex billing systems spanning across multitier architectures using latest high end server/storage/network technologies running on very large single and RAC Oracle databases having rigorous availability demands and very fast response times under mixed Oracle workloads.

Senior Consultant in Competence Centre Europe (Technical Lead Dept) with a role of Core Performance Lead responsible for analyzing and tuning billing systems with regards to load behaviour, throughput, memory consumption, latency, I/O performance and scalability in a highly concurrent OLTP/DSS environments using various file systems/vertical volume managers (GPFS, ZFS, CFS, VxFS, OCFS2 / ASM) on various OS (AIX, Solaris, HP).

Working with Oracle database 8i, 9i, 10g and 11g in implementation, configuration, tuning & administration under Windows and Unix environments for various Telecom projects; Anti-money Laundry Agency; Government Institutions and Founds.

On site support engineer for a financial institution in Manhattan, New York (USA) responsible for: - Maintaining integrity of users and their entitlements in the databases and their dependent systems - Maintaining data/transactions integrity - Applications maintenance - Monitoring background processes - Reporting - Stored Procedures troubleshooting/debugging - Monitoring OS processes - Provide database support during large bulk roll-outs in cooperation with other teams

Working on LHS - BSCS iX R2 Billing Platform - Database baseline setup for BSCS iX - Oracle installation & configuration, performance and sql tuning - Advanced PL/SQL programming - Various on demand reports (Unbilled amount, Interconnect, Airtime, Free Talk Time Usage, Bundles) - HP-UNIX shell scripting - Rerating (with custom SQL scripts) - Development of interface for loading data from BSCS to HLR for setting basic network parameters (CLIP/CLIR/SOCLIP/SOCLIR)

Working on different projects for several European Telecom operators, Telco billing applications (Intake, Invoicing, Reporting), Central Billing System (CBS), Mobile virtual network operators (MVNO) – Tele2, Government projects, Mobile-phone end-users applications etc.

Designing and coding client/server architecture applications on Win32 platform, using Borland Delphi / C++ / JavaME and various RDBMS (Oracle, Interbase and MS SQL Server). - Development and maintenance of Storage managing systems (features for invoices, payments, various financial reports, managing client’s orders etc) - CRM & ERP - Development of Process modelling systems (between various machines, calculating waste & products, working hours, reports etc) for several companies in Macedonia

Working on an application that incorporates features for monitoring user’s entry/exit from work using smart cards, calculating monthly payment, report system, synchronization with other database servers etc. Technology used was Borland C++/Delphi and Interbase/MS SQL Server as RDBMS.

Foundations of predictive analysis; Essential forecasting & predictive analysis; Methodically forecasting Oracle performance; Predictive data analysis; Increasing forecast precision; Practical queuing theory; Data collection and workload characterization; Regression analysis (RA); Scalability

Introduction to Oracle System Behaviour Analysis; Setting Up the Fully Quantified Analysis; Executing the Quantitative Performance Analysis and Solution Evaluation; Anticipating Solution Impact Case Studies

Oracle performance diagnosis; Serialization Control; The lock, latch, & mutex; Operating system contention identification; ASH centric response time performance diagnosis; Oracle buffer cache deep internals, diagnosis, and resolution; Oracle shared pool deep internals, diagnosis & resolution; ORTA

11g RAC Architecture overview and basic principle for developing RAC-aware applications; Development of scalable applications with Oracle 11g RAC; Oracle 11g RAC introduction; Services in RAC; Workload balancing in Oracle 11g RAC; TAF; FAN; Tuning; Best Practices

11 - new features of Oracle Database 11g; All about binding; Materialized Views, Caching; Effective Indexing; Storage Techniques; Reorganizing objects - when and how

Methods, work around and dirty tricks for dealing with classic performance problems when the system is in production; key targets, indicators and mechanism for producing a well-tuned system on day one. Strategies for dealing with badly performing systems after go-live

System Initialization, Package Management, Kernel Services, System Services, User Administration, Filesystem Management, Advanced Filesystem Management, Network Configuration, Installation, Virtualization with Xen, Troubleshooting

Oracle 10g Performance Tuning Oracle 10g SQL Tuning

Oracle 10g Administration I Oracle 10g Administration II