Ilya Kuzkin

Enterprise and solution data architecture

Data conversion, integration, mapping, and consolidation for a multi-tenant Microsoft Dynamics Business Central implementation from legacy source systems. Successful implementation.

Enterprise-level data warehouse, enterprise data model creation, data architecture of cloud data assets, solution architecture, and technical leadership on data projects.

SQL Server, Sparx Enterprise Architect, Agile

- Migration of on-premises VMs to private and public clouds - Migrating Oracle and SQL Server databases to public and private clouds, database tuning - Establishing cloud backup and recovery strategy, establishing backups, schedules, enterprise-wide backup/recovery policies

- Working as a liaison between business and development teams to convert the business requirements into the data requirements. - Modeling of enterprise-level concepts and objects - Design and Development of XSD schemas (based on ARTS canonical model) and data mapping documents to create enterprise service bus (IIB) messages - Creation of queries and models to collect business data and publish in a form of XML messages

- Design and Model Logical and Physical Data Models based on the requirements (business and technical) - Information and Data Architecture - Participation in establishment of data requirements and mapping the user requirements - Working with development teams (pods) establishing the application requirements (functional requirements and GUI), and mapping them against database objects - Working closely with DBA team to ensure the database specification guidelines are met - Maintaining compliance with general database design principles (performance and scalability, normalization, nomenclature et cetera) - General database administration (creation and maintenance of test environments, testing the scripts) - Database release preparation and management. - Working closely with the Business and Data Analysts, queries creation and optimization queries - Design of mapping and information flow diagrams between enterprise systems - Creating enterprise-wide data and definition dictionary

- Working with BA team and end-users to establish business and technical requirements; creation of functional and technical specification documents - Architectural design of new modules - Logical and Physical modeling - Code development (including very complex calculations and scenarios) - Performance and scalability issues resolution - General application architectural design - General technical lead - Developing coding standards and practices - Devising testing, deployment and release strategies

- Oracle Administration and Support - Oracle Development (PL/SQL, data modeling) - Establish IT processes, enabling the operation cycle and development infrastructure - Staff Training (Oracle – PL/SQL, Application Server, Standard Operating Procedures) - Technical leadership (architectural and database design)