Sql Server Customer Service

ROMAN KORDONSKY

** ********* ***. **********, ** 01890

Phone: 781-***-****

E-mail: aczaa2@r.postjobfree.com

PROFESSIONAL EXPERIENCE

MASS GENERAL HOSPITAL, Boston, MA

**/****-**/****

Information Management Developer (Contract)

Developing SSIS Integration package to retrieve data from Google Analytics to Mass General Hospital Data Warehouse. SSIS 2012, VB.NET, SQL Server 2012, Google Analytics Source and other technologies were used to complete the project.

Developing SSIS Integration package to integrate data into Raiser Edge Database from the Hospital eCommerce (WooCommerce) website. SSIS 2012, C#, SQL Server 2012, WooCommerce REST API, Shell Script, ImportOMatic, Raiser Edge and other technologies were used to complete the project.

Developing SSIS Integration package to synchronize constituent/lead data between Marketo System and Raiser Edge System. SSIS 2012, C#, SQL Server 2012, Marketo REST API and SOAP API, ImportOMatic, Raiser Edge and other technologies were used to complete the project.

Performed some DBA duties including setting the new environment, adding new users, creating new Stored Procedures, Views and Triggers in SQL Server 2012.

UNIDINE CORPORATION, Boston, MA

07/2012-Present

Database Administrator

Responsible for Database Administration and was the only MS SQL Server DBA in the company.

Developed over 20 SSIS integration packages for various company needs.

Designed several reports using SSRS. Customized and supported all of the crucial company’s application including uCatering using PHP and MySQL, uFinancial using ASP.NET and SQL Server, NetSuite. Developed mid-tier applications to connect MS Dynamics Great Plains and the major company application uFinancial.

Developed integration processes between Stromberg (currently ADP) and NetSuite using uFinancial as mid-tier. Responsible of designing the Company Intranet using Share Point (Office 360). I was maintaining Active Directory and in absence of our Network Administrator was responsible for the company network administration.

Supported and customized all the company web applications using IIS, ASP.NET and PHP.

AXSUN TECHNOLOGIES / VOLCANO CORP, Billerica, MA

12/2008-03/2012

Enterprise Systems Analyst

MS SQL Server Database Administrator. Upgraded the company’s SQL Server from MS SQL Server 2000 to 2008. Wrote several stored procedures, created DTS/SSIS packages and reports.

Tuned database and analyzed query performance.

Responsible for Camstar InSite MES as System Administrator and customized the System according to user’s requests and manufacturing needs. Developed several DLLs with different functionalities. For example sending automatic notifications when material units pass through the certain steps in the workflow, check if the proper components were in place during Filter assembly, etc.

Responsible for Business Objects System as System Administrator and Universe Designer. Customized several Universes and created several new ones according to the company needs. Developed several applications for inner company use and for company’s customers. Played crucial role in transferring manufacturing process from old Camstar InSite MES System to new MS Dynamics AX 2009 ERP System.

Developed several applications providing automatic data transfer from one system to another. During our Network Administrator absence partly was responsible for our LAN System Administration. Provided Helpdesk support for our users.

Supported and customized the company web applications using IIS, ASP.NET.

SCHEIDT & BACHMANN USA, Burlington, MA

04/2005-11/2008

Software Engineer

Oracle DBA for MBTA Automatic Fair Collection (AFC) System responsible for database backups, replication and Queries optimization. Analyzed, designed and developed several VB-6, VB.NET and Oracle database related applications and reports in the company’s MBTA AFC System project. Applications are providing end users with ability to customize the parameters of the report. Developed and modified several major Oracle reports: Device Activity, Customer Service, Transaction Detail, Shift Event Detail and others.

Responsibilities included Windows 2003 System Administration, HP-UX administration, CCS Administration, etc. Developed an application to transfer data between new AFC System and old MBTA Money Room System. For inner company use created several reports using Crystal Reports and SQL Server. Provided user training for MBTA personnel. Started to develop the company Main Module Web application.

IAN MARTIN THECNOLOGY, Seabrook, NH

11/2004-12/2004

Consultant

Developed five different applications for Seabrook Nuclear Power Station allowing to communicate and to share data between Lotus/Notes (MAXIMO) system and Microsoft/Oracle based SITRIS system. Applications transfer data from MAXIMO to SITRIS, evaluate data during process, storing result of the data process in log files providing the detail information about each problem during the process. VB, Oracle SQL Server, Lotus/Notes, Crystal Reports, ASP, IIS were used to developed the applications. Worked as a part of the team provided several suggestions allowing to improve performance of MAXIMO and SITRIS Systems.

ADECCO TECHNICAL, Portsmouth, NH

06/2004-10/2004

Systems Developer

Developed two applications for Liberty Mutual (Portsmouth, NH office) providing customized solutions to improve network security against possible harm from devices connected to Liberty Mutual WAN. Application LM Audit is running on a connected to WAN device and checking it for appropriate patches and file versions. As a result of this audit process the device could be allowed to connect to network with full or partial access or login process will be halted. Application RADIUS Trigger is running on RADIUS Server and checking wireless devices connection to the network. It is checking for an existence of LM Audit application in the device. If the application does not exist RADIUS Trigger will push LM Audit software onto device and triggers the application. Developed Log In part and device audit of Liberty Mutual Security Compliance web based project using ASP.NET and IIS. VB.NET, ASP.NET, SQL Server 2000, IIS, XML, RADIUS Server, IPSec, Active Directory and SMS were used to accomplish the project goals.

DAVIS INC., Nashua, NH

03/2004-05/2004

Consultant

Provided consultation in POG Application on Staples side. Solved several problems in data retrieving. Optimize the database of the Application.

Created several QA procedures for the Application Development.

P&P CONSULTING, Winchester, MA

05/2003-03/2004

Consultant

Worked on several projects for small businesses in Eastern Massachusetts. Developed several financial, customer care client/server applications, customer databases. Developed web based customer feedback application. Applications were developed using Visual Basic, ASP, Oracle, SQL Server, MS Access.

SYRATECH CORPORATION, Boston, MA

12/1998-07/2002

Computer Systems Analyst

Worked as a team leader in development serial projects and databases. Developed several web and client/server applications on my own, including Invoice, Deposits, Version Control. Developed several financial reports for Invoice and National Bank Deposits application. Developed several applications for HP 3000 using Fortran, Cobol and RPG.

Worked as a system administrator of Optika Imaging System (Acorde and FilePower as a part of my duties. Designed and developed workflows for Acorde Imaging System. Developed several improvements allow to utilize the FPIS for different fields of the Corporation. Took active leading role in development Commission Management System ad Supply Chain Management Applications. Prepared all analyses for the Corporation EDI project. Troubleshot Corporation systems and evaluation of different kinds of software for Corporation used (Legal, accounting, Internet scanning. Used various languages (VB, VBA, VBScript, ASP, XML, C/C++, PowerHouse, Java) and several databases (HP 3000, SQL Server, Access 97, dBase III and IV).

JEWELSTONE SYSTEMS INC., Toronto, ON

02/1998-10/1998

Programmer/ Analyst

Created, designed and developed program Request For Service (RFS) for all divisions in the company including accounting part. Application allows user quickly to find if problem occurred before and to bill client by hourly and daily bases. For front end was used Visual Basic 5.0 for database MS SQL Server 6.5. For Reports was used Crystal Reports. Application runs in client/server environment. Participated in developing Marketrax software.

LEAD GENERATION SERVICES, Toronto, ON

12/1997-02/1998

Systems Analyst/ Programmer

Created application for collecting information from clients (banks). Created, designed and developed database for this information. To create Printing Reports I used Crystal Reports. Worked in client/server environment. Used Visual Basic 5.0 and MS SQL Server 6.5. Carried responsibilities as Database Administrator.

CANADIAN COLLEGE OF BUSINESS & COMPUTERS, Toronto, ON

10/1997-12/1997

Programming Instructor

Educated students in basic programming technique, logic and programming design in Visual Basic 4.0 and Borland C++ 4.02. Taught students Principles of Internetworking, Installation, Configuration and System Administration of Novell NetWare 4.1 and Windows NT 4.0. Under my supervision students created small networks in every technical lab from one Server and 4-5 Workstations. Servers and Workstations in every lab used different network operating systems – Novell NetWare 4.1, Windows NT 4.0 and UNIX.

PROFESSIONAL TRAINING

Diploma

Computer Programmer/Analyst

CDI COLLEGE OF BUSINESS AND TECHNOLOGY, Scarborough, Ontario

EDUCATION

Master’s Degree

Civil Engineer

RIGAS TECHNICAL UNIVERSITY, Riga, Latvia

FOREIGN LANGUAGES

Fluent in Russian and Belarusian and several other European languages written/oral skills.

Hebrew oral skills.

TECHNICAL SKILLS

MS SQL Server/SSIS/SSRS/SSAS

Seventeen years working experience in Design Databases. Six years DBA experience. Using SSIS, SSRS and SSAS to design databases, developed integration packages and reports. Database tuning.

Oracle

Five years working experience on developing applications, reports in Oracle. Four year experience as Oracle DBA for MBTA AFC System. Database tuning, replication and optimization.

Visual Basic/VBScript/VB.NET/VBA

Seventeen years working experience. Analyzed, coded, designed and developed several different projects for different clients using MS Access, SQL Server, Oracle, FoxPro, HP 3000 as databases, to customize Camstar InSite MES and Microsoft Dynamics AX.

Camstar InSite Management Executive System (MES)

Over three years of System Administration and InSite Development using Visual Basic and System’s Tools such as InSite Designer

Business Objects

Over three years of the System Administration and Universes Design Experience. Working with different versions of Business Objects

Microsoft Dynamics AX

Played a crucial role in converting from Camstar MES system to Dynamics AX

C/C++/C# Programming Language

Over two years working experience. Created, designed, analyzed and tested several projects in MS-DOS, Windows-3.x, 95 and NT environment.

Crystal Reports

Nine years of working experience with Crystal Reports. Developing several financial reports for different applications (Invoice, National Bank Deposits) Using MS Access, SQL Server, Oracle and HP 300 databases to provide data for reports.

ASP/ASP.NET

Analyzed, created and designed several projects for Syratech, Axsun and Unidine use.

HTML

Analyzed, coded and designed several WebPages.

PHP

Used in customization of uCatering application for Unidine Corporation. Currently utilizing PHP5.

PowerHouse

Three years working experience. Worked on various projects. Created different libraries and reports. Expert knowledge of Quiz.

OPERATING SYSTEMS

Windows-95/98/2000/2003/7, Windows NT, Novell NetWare, HP/UX, Linux and MPE/iX.

Contact this candidate