Zachary Dimitrov

NewBusiness.bg is a free PDF-newspaper and online site about startups, business ideas, small and medium business. Writing articles for various IT business related solutions. Managing partnerships with associates. Unite and lead the core team of the company.

Database optimisations, data ingestion and operational intelligence.

Querying large Data sets, extracting and preparing data for analysis and consumption by individuals and /or automated systems. Adopting an innovative approach to the analysis of in-house data, with a view to provide relevant context of core metrics to the end users. Tuning and optimising SQL queries and stored procedures. Working closely with Risk Analysts to understand data requirements , design optimal data structures for analysis.

Using Partitioning for performance tuning and archiving purposes. Patching complex TSQL stored procedures, managing backups and restores and perform disaster recovery planning. Production experience with T-SQL. SQL Performance tuning-Detecting and optimizing slow running queries and bad performing indexes. Dissecting execution plans. Communication and cooperation with many different parties. Database development. Creating on demand reports. Database build automations. Read, manipulate and insert XML data. T

Creating SQL (MS SQL/T-SQL and Oracle PL/SQL) data structures for GeoCon PlanExpert PRO software. Coding business logic into programming units. Optimization of scripts and internal database structures. On-demand design and creation of patches. Consulting foreign customers (French and German) and optimizing their systems through remote desktop access applications. Backup and restore of client databases and schemas (Microsoft SQL and Oracle). Writing step-by-step guides for company products and their features

Working with Oracle, trying to write PL/SQL procedures and queries. Operating with enormous data warehouse. Responsible for preparation of analyze reports for data management and business intelligence division.

Information Security, Corporate Intelligence, Knowledge Management, Advanced Methods in Cryptology and Information Processing, Network Security, Corporate Communications.

Security and data protection in operating systems. Intellectual Property, Risk Management, Information Security, Cryptology, Financial Security, Physical Security.

Computer Architectures, Business and Administration Communications, Information Systems, Computer Networks and Communications, Fundamentals of Commercial Law, Project Management.

Fundamentals of organizations, People in corporations, Finances, Marketing, Team working, Information Society, Motivating people.