Sql Server Development

Maria Treskov

** ********** **., ******, **, Canada, K2M 2X8

Tel. 613-***-**** Email: *.*******@******.***

Objective: A challenging software developer position where my knowledge and

expertise will contribute to the company goals.

Summary of Qualifications

. Experienced in development of various projects in a Microsoft

environment.

. Excellent Technical skills in C#, VB.NET, ASP.NET, SQL Server

2005/2008/2012.

. Extensive development experience in Database Applications and Graphical

User Interface (GUI).

. Skilled at Object Oriented Analysis and Design techniques (OOA/OOD) and

applying those techniques with .NET.

. Skilled at Database design, development, normalization, performance

optimization and troubleshooting.

. Experience in software development management, team leading and project

management.

. Perform well both independently and as a team player.

. A meticulous, methodical and creative work style, with a passion for

developing consistent, scalable, functional and attractive applications.

. Loyal and professional attitude, flexible, strongly motivated.

. Able to work under pressure and a quick and accurate learner.

Employment History

Software Developer 2010 - present

CaseWare RCM Inc., Ottawa

. Development of Web bases continuous monitoring accounting application

used for auditing and financial data analysis.

. Design, development and administration of MS SQL Server 2008 database.

. Create custom SQL queries and reports. Performance tuning.

. Server side and Client side development using C#, ASP.NET MVC, WCF.

. Design and development of localization for the database and server

allowing application to support many languages using the same codebase.

The application was released in English, Spanish, and French.

. Development of cloud based server API utilized Google Big Query for

financial analysis.

. Create packages for importing data from CVS, Access, Excel file formats

into SQL Database using T-SQL and SSIS.

. Create Unit Tests.

. Prepare requirements analysis and software design specifications.

. Agile software development environment.

Technical Environment: MS Windows, SQL Server 2008, C#, ASP.NET MVC,

ADO.NET, IIS, T-SQL, MS Visual Studio 2010/2013, Entity Framework, TFS,

WCF, Active Directory, UML, XML/XSD/XSLT, Java script, VMware, SSIS, IDEA

script, Hyper-V, Google Big Query.

Senior Software Developer 2006 - 2010

Embla Systems, Ottawa

. Design and development of The Embla Enterprise System - client-server

application, intended for storage and managing all the patient data,

scheduling appointments, collection data from medical devices and

administrating the database.

. Design, development and administration of MS SQL Server 2000/2005/2008

database. Creation of new and optimization of existing stored procedures

for better performance.

. Development of client application's GUI using C# and VB.NET.

. Development of Web Server for patients' questionnaires using ASP.NET and

IIS5/6/7.

. Development of Windows Services and Web Service using C#.

. Implement security models for MS SQL Server in Windows and SOA (Service

Oriented Architecture) environment.

. Create custom C# controls to facilitate application development and

future maintenance.

. Development of reports using ActiveReports.

. Evaluate different security options including creating groups in Active

Directory and Group Policy Objects (GPO).

. Create in-house tools for create/restore SQL users, automate installers

and builds.

. Create custom SQL queries and reports. Performance tuning.

. Migration of customer data stored in different formats into SQL Database

using T-SQL, DTSX/SSIS.

. Development of installer packages for the Server, Client, Windows

Services, Web Server, and Web Service using Wise Installer, VB script and

WMI.

. Maintenance and trouble-shooting of company products.

. Prepare requirements analysis and software design specifications.

Technical Environment: MS Windows, MS Server 2003/2008, SQL Server

2005/2008, C#, VB.NET, ASP.NET, ADO.NET, IIS5/6/7, T-SQL, MS Visual Studio

2005/2008, Subversion, Active Directory, GPO, UML, XML/XSD/XSLT, TCP/IP,

HHTP, SSL, WMI, Multi-threading, Wise Installer, VB script, VMWare,

Syncfusion, ActiveReports, IssueView, HL7, DTSX/SSIS, SOA.

Senior Software Developer and Database Analyst 2003 - 2005

NextWorksMedia Inc., CA - Ottawa

. Design and implementation of VideaWorks - three-tier client-server

application, intended for storage and distribution of multimedia content.

. Design, development and administration of MS SQL Server 2000 database.

. Design and development of ADO.NET component to provide DB access.

. Development of client application's GUI component using ASP.NET.

. Design and development of in-house Bug Tracking system using C# /

ADO.NET/ MS SQL Server.

. Prepare Windows Installer packages for the application deployment.

Technical Environment: Windows XP, SQL Server 2000, C#, VB.NET, ASP.NET,

ADO.NET, IIS5, T-SQL, MySQL, MS Visual Studio 2003, Visual SourceSafe,

UML, MS Windows Installer.

Software Developer and Database Analyst 1993 - 2001

Human Resources International Ltd., Israel

. Design and implementation of Client/Server educational and training

for the Ministry of Education and the Ministry of Health, the Ministry

of Transportation and two major Israeli banks.

. Design and development localization for the database and client

allowing application to support many languages using the same

codebase. The application was released in Hebrew, Dutch, Finnish,

Italian and Turkish.

. Development of interactive localization tool, allowing for translation

of the company's applications to multiple languages.

. Design, development and administration of MS SQL Server and FoxPro

databases.

. Development of client application's GUI.

. Prepare of requirements analysis and software design specifications as

well as provision of trouble-shooting, performance improvement,

maintenance and client training for all the products.

Technical Environment: MS Windows, DOS, SQL Server 7, VB, FoxPro, DDE,

ActiveX, ODBC, COM, SQL.

Educational Background

M.Sc. Applied Mathematics and Computer Science.

Moscow Technological University, Information Technology and Economics

Department, Program: Systems and Computer Engineering, Moscow, Russia

Courses and certificates

. Windows Communication Foundation (WCF) Using C# (2012)

. Microsoft .NET Framework - Application Development C# (2010)

. Database Systems. Oracle 9i (2004)

. .NET Framework and ADO.NET (2003)

. Java Programming (1999)

. Mastering MFC fundamentals using MS Visual C++(1997)

. Mastering VB6 Development (1998)

. MS Visual FoxPro(1996)

. Data Modeling and relational database design (1995)

Security Clearance: Enhanced.

Languages: English, Russian, Hebrew.

Contact this candidate