Sql Server Developer

ROLAND BERNSHTEIN

North York, ON M*R *N*

Phone: 647-***-**** / *******@*****.***

DATABASE / SOFTWARE DEVELOPER

SUMMARY OF QUALIFICATIONS

DATABASE:Modified database schema to decrease duplicated data growing by normalize up to 3rd normal formImproved performance by redesigning column indexes, indexed views, tables partitioningFixed issues by transferring dynamic SQL queries into Stored ProceduresWrote T-SQL stored procedures, parameterized views, triggers, cursors and user defined functions

APPLICATIONS / COMPONENT DEVELOPMENT:Translated business rules into logical, functional and physical layersCreated numerous reports to address particular project goals using SSRS and SSASDeveloped server side components related to database using Microsoft latest technologies ASP.NET, C#

WEB PROGRAMMING / DATABASE DEVELOPMENT / MANAGEMENT / CLIENT SUPPORT:On-line games interactive marketing swarm; VB6/ASP/SQL database-driven server-side components; Provided internal development DBA support, information recovery and backup strategies; Trained company clients workers; Analyzed, drafted and issued working documentation

COMPUTER TOOLS

HTML, CSS, CLF 2.0, JavaScript, SSRS 2005, XML, Oracle Forms, ReportsERD, Normalization, DTS, SSIS 2005, Oracle SQL Developer / Designer, Quest Toad, UML2, VisioT-SQL, PL/SQL, DDL, DML, Stored Procedures (CLR), Functions, Triggers, Java, ADO.NET, WCF, C#, ASP.NETMVC, SCRUM, SDLC, RAD, Visual Studio (6.0 - 2010), TFS, OCS, IIS, Apache Tomcat, JDeveloper, Eclipse, NetBeansSQL Server (2000, 2005, 2008 R2), Data Entity Framework, Hibernate, Oracle 10gWindows (2008 R2 Server, 2003 Server, XP, 7, 8), Linux (RedHat, CentOS, Debian, Ubuntu, SuSE)

EXPERIENCE

KWizCom Corp (Toronto) – May 2011 - presentDocument functional, logical and technical requirementsDevelop Data Grid Web Parts to display data from SQL Server 2005 database utilizing Business Data CatalogDeploy custom defined reports created by SQL Server Reporting Services (SSRS) on SharePoint 2007 Portal

Quest Software Corp - contract - summer 2010Modified database schema to decrease duplicated data growingTransferred dynamic SQL into Stored Procedures and User Functions as well as creating Indexed ViewsImproved performance by modifications of current index strategy - tables partitioning, column indexing

Education / Certifications / Training

Web and Desktop Programming, Heritage College, Ottawa / Gatineau - 2008-2011

Relevant Course Works:Java EE, EJB 3.0Oracle 10gC# (3.5)SQL Server 2008

Data Warehouse Architecture, Professional Association for SQL Server (PASS)

Microsoft Certified Technology Specialist: SQL Server 2005 (MCTS)

B.Sc. Production Management and Economics, Novocherkassk Reclamation Engineering Institute, Russia, 1993

Contact this candidate