Sql Server Development

VASILY KRAPIVNITSKIY

(address available upon request)

Phone (available upon request) abplxa@r.postjobfree.com

SUMMARY

DBA/Database&Software Developer with in-depth years experience in the development and design of

database strategies, monitoring and improving database performance and capacity, Internet and

Intranet applications with the latest technologies. Experience in running multi-tier development

projects. Responsible, organized, able to multitask, team player. Work well under pressure. Efficient

problem solver with strong hands-on experience in custom software development and support.

Excellent analytical and problem solving skills. Extensive knowledge and experience of High -

Performance, N-Tier Architecture, Microsoft .NET platform, and full System Project Li fecycle

implementation. Bilingual work experience (Russian)

PROFESSIONAL EXPERIENCE

Penncro Associates, Inc., Southampton, PA

January, 2012 Present time

Reporting Analyst

SSRS reports developing (SQL Server 2005-2008)

SSIS packages support/developing

TSQL, C# programming

American Advanced Institute of Technology (AAIT), Warminster, PA

June, 2012 Present time [part time job]

SQL Server Lab Assistant

SQL Server 2005-2008: database modeling, TSQL, database administering

SQL Server Business Intelligence Development Studio: SSRS, SSIS: packages developing, debugging,

deployment

FAMILY PLANNING COUNCIL, Philadelphia, PA

September, 2010 December, 2011

Programmer

Developed and passed to production several Windows and Web Applications using Visual Studio 2010

(C#, Javascript, JQuery, ASP.NET)

Performed customer support for Windows and Web applications users

Installed several SQL Server 2008 instances, solved software compatibility and system upgrade

problems

VASILY KRAPIVNITSKIY PAGE 2

SQL Server 2008 management: backup, restoration, tuning.

Wrote number of SQL functions and Stored Procedures

Developed big amount of SSRS reports (SQL Server 2008), wrote SQL functions, sp, queries for the

reports.

Created complex SSIS package. Used remote server connections, XML and flat files transferring, data

transformation, error checking, import to SQL Server 2005/2008 and Access databases, automatic email

notifications.

(MS SQL Server 2005-2008, Microsoft Visual Studio 2008-2010, C#, Visual Basic, Java, Javascript,

JQuery, XQuery, XML, MS EXCEL, MS ACCESS, SSIS, SSRS, Sharepoint, RW CAREWare)

VOICE SYSTEMS ENGINEERING, INC, Holland, PA

February, 2008 June, 2010

Information Systems Programmer

Created set of stored procedures, functions, triggers to enforce business rules that govern data in the

database

Created multiple reports (Crystal Reports, SSRS)

Analyzed and optimized MS SQL Server production database

Solved data-related problems.

Upgraded and tested databases during SQL Server update

Significantly speeded up internal web reports system by creating Windows application to manage files,

database data and folders using .NET technology (C#)

Created several SQL Server Integration Services (SSIS) to manage SQL Server objects and data

(MS SQL Server 2005/2008, Microsoft Visual Studio 2005/2008, C#, Visual Basic, JavaScript,

HTML, DHTML, XML, Visual Source Safe, Crystal Reports, MS EXCEL, SSIS, SSRS, MS

Sharepoint)

ENARA GROUP INC., Warminster, PA

August, 2006 February, 2008

Database Analyst

Coded and enhance a number of SQL Server functions, stored procedures, triggers, views and DTS

Packages

Monitoring SQL Server Agent Jobs and SQL Server performance

Developed integration strategies including ETL, web services, XML

Analyzed and tune database for optimal efficiency

VASILY KRAPIVNITSKIY PAGE 3

(SQL Server 2000/2005, SQL/Transact SQL, Microsoft Visual Studio, Visual Source Safe, PC

Anywhere, MS Office, PL/SQL, SSIS)

HOPE INTERNATIONAL, Churchville, PA

April, 2006 July, 2006

Database Analyst

ASP pages developing/support (VB Script).

Contact information data importing/exporting(MS Outlook, MS Access)

Set up and support an E-mail database (SQL Server)

(SQL Server 2000, SQL/Transact SQL, MS Visual InterDev, MS Outlook, MS Access, VB Script,

HTML, XML)

EDUCATION

BS, Engineering, State University of Aerospace Technologies, Moscow, Russia

BA, Theology, Saint-Petersburg Christian University, Saint-Petersburg, Russia

American Advanced Institute of Technology (AAIT), PA

OPERATING SYSTEMS

MS Windows NT/95/98/2000/XP/ VISTA/ 7, Windows Server 2003,

Windows Server 2008

DEVELOPMENT TOOLS

MS Visual Studio.NET 2000/2003/2005/2008/2010, MS Visual InterDev 1.0/7.0, MS Visual Basic

5.0/7.0, SQL Server Business Intelligence Development Studio (SSIS, SSRS) MS IIS-5/6, MS

Personal Web Server, MS Visual Source Safe, MS Office, Adobe PhotoShop, Adobe Acrobat, PC

Anywhere, Terminal Services, Macromedia, Red-Gate suite, Microsoft FrontPage, Seagate Crystal

Reports 7.0/8.5/10, MS SQL Reporting services, MS Power Point, MS Excel, MS Access, Oracle 10g.

PROGRAMMING LANGUAGES

SQL/Transact SQL, PL/SQL, LINQ, C#, VB.NET, C++,

VB Script, Java Script, JScript, jQuery, HTML, DHTML, XML

DATABASES

MS SQL Server 2000/ 2005/2008, MS Access, Oracle

Contact this candidate