Eugene Turkestanov

Eugene Turkestanov Calgary, Alberta, Canada Email:-Cell: - cell Summary           19+ years’ experience in Information Technology area. More than 10 years’ experience as SQL Database Developer 7 years’ experience as DBA. Specialized in SQL Server 6.5/7/2000/2005/2008/2012/2014 and MySQL. Proficient in data architecture, database design, modeling, analysis, installations, upgrades, performance tuning, scheduling backups/recovery, SSIS, SSRS, Enterprise Data Warehousing. Data migration, data modeling, ETL and BI development, including stored procedures, functions, views and triggers. 5 years’ experience in management. Ability to work in team and with individuals of different skill levels, strong commitment to meet deadlines under pressure. Experienced in documentation. 3 years’ experience in Web development. ASP.NET, MVC, Ajax, JavaScript, C#. 2 years’ experience in Agile. Work-related qualities and skills Dependable and hardworking, comfortable with tight schedules, able to learn new technologies and products rapidly, self-motivated and responsible, good team player, excellent communicational skills, good problem solving skills. Software Knowledge SQL Server 7.0-2014, Crystal Reports 8-11, Platinum SQL ERP, Clientele, TFS, MySQL, Pentaho ETL, Visual Studio, Sage 50, MS Office 365, Informatica Power Centre 9 and MS Power BI Desktop. Programming Languages and Technologies Transact-SQL, ASP.NET, C#, MVC, Ajax, JavaScript, VBA, HTML, ADO, SSIS, SSRS, OLAP, OLTP, ETL, EDW, XML Major Projects Professional Experience  Implementation of new module “Purchase order” of Platinum SQL ERP System  Developed new functionality for merchandise reservation for Platinum SQL ERP System  Banking Conversion.  Enterprise Data Warehouse November 2013 – Current Lead Developer / Team Lead in Mawer Investment Management www.mawer.com  Managing a team of developers, assigning tasks, defining goals and terms  BI development and reporting  Created SSIS packages, data modeling, mapping, ETL  Data warehouse and SSAS development  SharePoint Development  Web Development  Enterprise Data Warehouse development Technologies: SQL Server 2008/2008 R2 - 2014, SSIS, SSRS, SSAS, ASP.NET, MVC, T-SQL November 2013 - Current Managing Partner in DBDev.ca www.dbdev.ca  Database development and Administering using MS SQL Server  Crystal Reports  Sage 50 Reporting, customization and integration  Web Development  Mawer Investment Management, Enterprise Data Warehouse development  Ensign Atlantic, incident reports delivery solution  Sage 50 (Simply Accounting) Custom Reporting  InterVisa Inc web application Technologies: SQL Server 2014, ASP.NET, C#, MVC, Ajax, VBA February 2011 – November 2013 Senior Database Developer / Team Lead in Propak Systems Inc. www.propaksystems.com  Created database objects as such as tables, store procedures, triggers, views, indexes and user-defined functions  Created SSIS packages, data modeling  BI development and reporting  Web development  Managing team of report developers and database developers  Database Administering Technologies: SQL Server 2005/2008 R2, SSIS, SSRS, OLAP, ASP.NET, MVC September 2007 – February 2011 DBA (MySQL, MS SQL Server) in Call Genie www.callgenie.com, Calgary, Alberta  Executed database backups and recovery, implementation, tuning, monitoring, capacity planning, query performance tuning, database server performance tuning, security, database maintains, code reviews, data architecture and analysis;  Documented database servers’ environment, user manuals;  Recommendations for development team;  Developed web application based on Google maps;  Developed BI reports for executive team. Technologies: Pentaho ETL, PHP, Ajax, JavaScript, MySQL, MS SQL Server, Excel, RDBMS, SSIS June 2007-August 2007 ETL Developer (contract) in Hitachi (Ideaca), Calgary, Alberta  Data migrating from JD Edwards to MS Dynamics Axapta (Oracle and MS SQL Server 2005) Technologies: ETL, MS SQL Server, Oracle, Excel, RDBMS, SSIS Nov.2005-June 2007 Win/Web developer (contract to permanent) in First Calgary Savings Calgary, Alberta  Reports and Database development.  Created internal banking applications.  Worked on design of new banking system database.  DBA duties (SQL Server 2000 and 2005): backup, recovery, security, performance, tuning.  Database analysis in banking conversion project. Technologies: MS SQL Server, .NET, T-SQL, Crystal Reports, Excel, RDBMS, SSIS Jan. 2001 – June 2005 Database developer/DBA in JSC “RRC Company” (exclusive distributor of Cisco, IBM, ViewSonic, Intel, Zyxel in Russia) Moscow, Russia  Reports and database development; Developed new modules and features for Platinum SQL ERP; Provided maintenance/support activities; Created DTS packages and OLAP solutions; Executed database backups and recovery, implementation, tuning, monitoring, capacity planning, provided general technical and network troubleshooting, performance tuning.  Created internal tracking system. Technologies: DTS, PHP, MS SQL Server, Crystal Reports, T-SQL, DTS, OLAP, VBA, RDBMS     Jul. 1997 – Dec. 2000 Technical Support Engineer in EpicRus (exclusive partner of Epicor corp. www.epic.ru/eng/) Moscow, Russia  Analyzed clients’ databases and troubleshooting;  Recommendations on improvement of the system functionality for development team.  Solving problems in administering SQL Server 2000 as backup and recovery database, maintenance tasks configuring, managing database files, jobs, troubleshooting, performance tuning;  Provided technical support of Platinum SQL ERP system. Technologies: MS SQL Server, Crystal Reports, T-SQL, DTS, OLAP, VBA, RDBMS Jul. 1996 – Jun.1997 Programmer in FutureWare-AMF Moscow, Russia  Interface development, development tools, test environments and Installation at client sites;  Developed accounting applications based on SQL Server platform. Technologies: MS SQL Server, Crystal Reports, T-SQL, Delphi, RDBMS Education and certification  Bachelor's Degree in Computer Science Moscow Machine Construction Institute.  Diploma in Accounting, Moscow Accounting College.  Microsoft Certified Professional in “Installing, Configuring, Administering SQL Server 2000”  “Introduction to Visual Basic.NET Programming with Microsoft .NET”,  “Programming with the Microsoft .NET Framework (MS C#.NET)”,  “Designing and Implementing OLAP Solutions with MS SQL Server 2000”