Svilenvalkov Resume Complete 20080903

Svilen Valkov

M.Sc., MCDBA, MCSE

23 HillBank Tr., Brampton ON, L6S 1P6 ● 905-791-8239 ● [email protected] ● www.linkedin.com/in/svilenvalkov

[1]

OBJECTIVE Provide consulting services with excellence as Database Architect, DBA and System Administrator. PROFILE Confident, motivated and energetic excellent performer and high-end professional with accomplishments in both technology and management. Resourceful and supportive leader, positive communicator, benefiting clients and management. Always learning, developing perfect and automated self-sustaining database centric solutions. HIGHLIGHT OF QUALIFICATIONS Performer produced results on multiple projects for corporate and operations level clients International expertise as a part of distributed teams for European and American large projects Leader and positive communicator, responsible for defining timeframes, tasks, system architecture and design Multi-lingual in English (fluent), French (basic), German (good), Russian (fluent) and Bulgarian (fluent) TECHNICAL SKILLS Databases ● 8+ MS SQL Server 7/2000/2005 ● 5+ Oracle 9/10 ● 9+ Access ● 1+ Sybase ● 1+ PostgreSQL OS ● 8+ Windows NT/2000/2003 ● 7+ Linux Red Hat (CentOS), Debian/Ubuntu ● 1+ Unix Solaris Servers ● 7+ MS Exchange 5.5/2000 ● 7+ IIS 5/6 ● 5+ Apache ● 2+ Postfix ● 5+ SourceSafe ● 2+ SVN Platforms ● 3+ SugarCRM ● 2+ WordPress ● 2+ MediaWiki ● 2+ Project-Open ● 2+ Trac ● 2+ Gallery 2 Virtualization ● 5+ VMware ● 4+ Xen ● 5+ Virtual PC/Server ● 1+ KVM ● QEMU ● Chroot ● 3+ LinuxVserver Tools ● 6+ Visio ● 3+ Jdeveloper ● 4+ SQL Developer ● 5+ SQL*Plus ● 5+ Visual Studio ● 5+ Dia Languages ● 8+ T-SQL ● 6+ PL/SQL ● 7+ VBS/Cmd ● 5+ Bash ● 4+ ASP ● 10 + HTML/JS ● 7+ C/CGI WORK EXPERIENCE System and Security Architect, Self-employed (Canada) (August 2008 – Present) Designed and audited IT systems. Planed and reported IT implementations, assessed business requirements and assigned programming tasks. Audited security for remote exploit vulnerabilities, database infrastructure, application code hardening, injection protecting and operation system configuration and tuning. Environment: PostgreSQL, MySQL, WordPress, Apache, PostFix, Windows, Ubuntu Linux. Time use: 50 % System Architect, 20 % DBA, 30 % Security Audit § Audited IT security environment for Consulate General of Bulgaria Toronto, Canada •Researched remote vulnerabilities of operating system, services and applications (code and forms) •Analyzed and advised security measures and administration practices § Designed system architecture for Independent Artist Label •Negotiated business requirements for definition of system architecture and business logic •Supervised software development of databases and visual implementation Senior Database Architect, EuroRisk Systems(Bulgaria/Austria) (February 2006 – April 2008) Developed Central Data Warehouse (VLDB, DSS, OLAP) for BAWAG P.S.K., one of the largest European financial networks in a team with system architect, database developer and 4 Java/Jsf developers. Negotiated requirements with BAWAG P.S.K. for system with 7-10 million customers in 7 countries, 2 to 5 thousand concurrent users and average of 2 billion rows of financial data loaded for less than 15 minutes. Database support of Risk Management Framework with 2 DBAs, 2 system architects and VB6, .NET developers. Environment: Oracle 9.2/10.2, MS SQL Server 2000/2005, Linux CentOS 4 (Red Hat), Solaris 10 and AIX. Time use: 50 % Database Architect, 40 % DBA, 10 % Database Developer § Conceptualized Data Architecture for enterprise systems and databases •Created standards, diagrams and infrastructure of the data schemes and configurations •Developed system policies - multi-language, security, templates, IOT nomenclatures •Cataloged template for generation of business objects (packages, functions and procedures) •Designed security architecture for fine grain and database audit, metadata triggers and table history § Developed ETL, Imports and Exports for large datasets, security and controls •Transfered up to 300.000 rows per minute via dynamic external template tables •Normalized materialized view, tables and vertical/horizontal partitions of 200 million rows •Setup database links, detail logging in all levels – successful, bad and rejected rows § Supported Business Intelligence (BI) engine for assignment of financial analysis aggregates and risk limits

Svilen Valkov

M.Sc., MCDBA, MCSE

23 HillBank Tr., Brampton ON, L6S 1P6 ● 905-791-8239 ● [email protected] ● www.linkedin.com/in/svilenvalkov

[2]

•Developed hierarchies and OLAP objects as materialized views and specific triggers for change pools •Optimized hierarchy aggregation for tree of related clients, groups and trend calculations •Designed rule based engine interfaces for duplication searches of related entities •Generated template based dynamic creation of static objects for alerting and conditional calculations § Administered 12 Oracle 9/10 and 7 MS SQL Server 2000/2005 for development and testing •Managed and tuned database storage, database access and indexing for performance tweaking •Patching, auto-generation of metadata templates (scheme mapping), automated backup •Monitored database log and trace files for exception trace mining and connection troubleshooting § Managed Linux CentOS 4 (Red Hat EL) with VMware environment for database and application platform •Maintained setup, configurations and tuning for Oracle related installations •Coordinated backup and administrative scripting for disaster recovery and tuning Senior Database Programmer, SysMaster (Bulgaria/USA) (August 2005 – November 2005) Supported and customized VOIP billing and Quadruple Play databases for the largest VoIP billing and call routing solution company with database architect, database developer and C/C++ programmers. Environment: Sybase ASE 11.0.3, Red Hat Linux 7.2, Fedora 6/7, Windows. Time use: 20 % DBA, 30 % Database Architect, 50 % Database Developer § Supported VOIP billing platform database for VoiceMaster VOIP billing software •Designed flexible template forms with database generated elements for survey system •Customized logging of deadlocks/locks, system monitoring, full security audit, access and statements § Designed databases for Quadruple Play system - Internet, Television (VOD, PPV, Live) and phone (VoIP) •Invented database for Interactive TV, VOD, PPV with sessions, automatic generation of playlists •Arranged logging and billing per user or device with session re-initialization, timeouts and crashes § Administered Linux systems (Red Hat 7.2) – monitoring, cron tasks, bash scripting and C/CGI Senior DBA(2002), Société Générale Expressbank (Bulgaria/France) (November 2001 - August 2005) Conceptualized and supervised Central Bank Data Warehouse for the 20th largest world bank groups. Coordinated a database team of 3 DBAs, 5 system administrators and 20 VB 6, .NET, Delphi developers. Centralized more than 5 million transactions per day and business data for millions of dollar of turnover operations from more than 200 thousand customers in more than 20 branches and one hundred locations. Validated purchases of equipment for more than 200 hundred thousand dollars. Environment: MS SQL Server 2000, Oracle 9i, Exchange, VMware, Virtual Server, Windows NT/2003, AIX Time use: 40 % DBA, 40 % Database Architect, 20 % Database Developer § Integrated and maintained Data Warehouse VLDB (Very Large Databases) for up to 1.5 billion records •Defined and enforced standards and conventions for data management in the organization •Developed extended procedure for file data modifications and T-SQL usage of command line programs •Horizontally partition ranges through views, complex triggers (800 hundreds million rows) •Facilitated historical versions with time machine getting information up to any date in the past § Developed and consolidated ETL, Import, Export and operations for warehousing •Scheduled DTS, T-SQL, VBS and CMD from/to MS SQL Server, Access, Excel, DBF, CSV, PDF, etc. •Designed sophisticated ETL and T-SQL data cleansing - from and to legacy systems •Retrieved web parses of HTML tables. Imported and exported blob objects •Coordinated transparent access for heterogeneous sources/destination via database linked servers •Harvested Windows domain information (ADSI) in database - about users, groups and rights § Established in-house Business Intelligence (BI), DSS and OLAP databases for events and trends •Defined requirements and automated management reports for balance and credit trends •Hierarchy objects, rule-based triggers for multi-table, multi-rows operations, history audit •Formulated government report requirements for the organization's financial and operative activities § Organized databases for 5 Experian Credit Scoring systems (Transact/ PPI) •Designed unattended scheduled multistage ETL transformations (more than 1600 rows T-SQL code)

Svilen Valkov

M.Sc., MCDBA, MCSE

23 HillBank Tr., Brampton ON, L6S 1P6 ● 905-791-8239 ● [email protected] ● www.linkedin.com/in/svilenvalkov

[3]

•Formulated metadata version control for overlapping information (marketing, financial and aggregations) •Operated multi-node application level failover cluster (MS Windows Server and MS SQL Server) § Modeled in-house database for negative accidents and documents for unwanted clients (Black List) •Managed corporate and individual clients, statistics, multilevel hierarchies, etc. •Attained debts and court (internal/external) from sources (Internet, newspapers) with trust percentage •Arranged document management with history of packaging, senders (recipients), blobs and conversions •Established metadata and label system for configurations, security and multi-language information •Prevented SQL injection, auditing, schema validation, row level permissions, portable authentication § Advised database architecture for Phone Banking IVR (Alcatel PBX) system •Designed of login system, client information and possible linked users •Systematized logging of sessions, client prompts and actions •Integrated import and ETL transformation for clients, accounts and transactions § Managed 10 MS SQL Server databases, 2 Oracle instance as setup, upgrades, optimizations, backups, etc. •Devised materialized views and stored procedures for performance tuning of asp front applications •Maintained 15 Windows 2000/2003, 2 MS Exchange 5.5/2000 and domain architecture •Operated multi-node application level failover cluster (MS Windows Server and MS SQL Server) •Developed custom VBS and CMD scripts for unattended tape backup operations § Consolidated virtual production and testing environments with VMware and Virtual Server/PC Database Designer, Self-employed (Bulgaria) 2001) § Developed MS Access databases and interfaces for small retail enterprises

(December 2000 - November

Technical Support, ISP-Digital Systems (Bulgaria) (August 2000 – October 2000) § Supported and troubleshooted remote Internet/Windows/Network for ISP, Consulted networks, Unix (BSDi) VOLUNTEERING System administrator/Database Architect METANOYAH - Open Source ERP project, www.metanoyah.org (November 2005-present) § Managed and coordinated project planning, budgeting and support § Organized and maintained Linux clusters for virtual machines – Xen, VMware, Ubuntu, Red Hat (CentOS) § Established distributed software/modeling collaboration environment for open source development System administrator/Web developer Varna Pentecostal Church (www.epc-varna.org) (September 2002-September 2004) § Designed and supported as HTML, CSS, Java Script and image editing of web project with more that 150 pages § Prepared Red Hat 9 server with raid, scripts and backups for web, mail and streaming services. More work experience details available upon request EDUCATION § University of Economics, City of Varna - Bulgaria / Ikonomièeski Universitet (Varna, Bulgaria) (University of Toronto Comparative Education Results Expected October 2008) • Master's degree, Computer Science 2004-2006 • Associate degree, Computer Science 2000-2002 • Bachelor's degree, International Business 1997-2001 CERTIFICATES & TRAINING § Brain Bench IT exams, tinyurl.com/brainb 2006-2008 § Microsoft Certified Professional (MCP ID: 1920999), tinyurl.com/mcptra (661535 / WelcomeHOME) • Microsoft Certified System Engineer (MCSE) 2000-2003 • Microsoft Certified Database Administrator (MCDBA) 2000-2001 More certificate details available upon request

Svilen Valkov

M.Sc., MCDBA, MCSE

23 HillBank Tr., Brampton ON, L6S 1P6 ● 905-791-8239 ● [email protected] ● www.linkedin.com/in/svilenvalkov

[4]

PUBLICATIONS CompSysTech'08. Bulgaria – Article “Innovative Concept of Open Source Enterprise Resource Planning (ERP) System”, ecet.ecs.ru.acad.bg/cst08/docs/cp/SII/II.6.pdf June 2008 AWARDS Free Ideas. Sirma, Salesforge.com. Bulgaria - 1 prize “SugarCRM module for repository access” June 2007 INTERESTS Open Source, Linux, History, Christianity, Music, Travel, Tennis, Golf REFERENCES Available upon request