Post Job Free

Resume

Sign in

Sql Server Developer

Location:
Hollywood, FL
Posted:
August 18, 2016

Contact this candidate

Resume:

IGOR VINOGRADOV

**** ******** ******, ** *****

Phone: 786-***-****

E-mail: acv710@r.postjobfree.com

RESUME

SUMMARY

Database Management Systems:

MS SQL Server 7.0, 2000 – 2012 (18 years)

Informix 9.x, 10 (7)

Oracle 7.3-8.0 (2)

Programming Languages:

Transact-SQL (16), PL/SQL (2)

C#, VB.NET, ASP.NET (14)

C/C++ (5)

JavaScript, VBScript, XSL, XML, CSS, HTML (5)

Visual Basic 5.0-6.0 (5)

PHP, RedBeans (2)

Objective-C for Cocoa Touch iPhone SDK (1)

Operating Systems:

Windows NT 4.0, 9x/2000/XP/7

Red Hat Linux

Mac OS X 10.5.6

Other Tools and Technologies:

Web Services (WCF/WSDL/JSON), Windows Services, Multithreading

Salesforce. APEX, VisualForce

SSRS, SSAS, SSIS, SoapUI, UML

Salesforce, VisualForce, APEX

VitualBox, Hyper-V, VMWare

IIS, TFS, VSS, CVS, SVN

Git, JIRA, Confluence

XCode, Interface Builder (IB), Cocoa Touch for Mac OS X

BEA Tuxedo, Crystal Reports

Education:

1991-1996. Chernivtsy State University, Ukraine.

BS in Applied Mathematics, Computer Science

Sylvan Prometric

2015. Salesforce Certified Administrator

2015. Salesforce Certified Developer

2013. Microsoft Certified Professional (MCP) SQL Server 2012

2002. Microsoft Certified Professional (MCP) SQL Server 2000 Developer

1999. Oracle Certified Professional (OCP) Exam. SQL and PL/SQL Programmer.

EXPERIENCE

December 2012 – present Phase One Consulting Group, Alexandria, VA

Architect, Project Lead

Working as developer and administrator on Salesforce project which is designed to manage investment portfolios, client base, decision making processes, etc.

Salesforce, Visualforce, custom objects, APEX classes, triggers, SOQL, Migration tools

Currently work on Uniform Rail Costing System (URCS) for Surface Transportation Board agency (STB). System includes extensive data mining and management based on the information provided by the agency. Web user interface is designed to generate data information and perform system analysis.

Data Import/Export, database development, tuning and optimization.

Web interface design and implementation for user input and navigation

Data presentation layer using different formats, such as XML, Excel, WSDL, etc.

Data warehouse technologies, such as SSAS, SSIS and SSRS

C#.NET, VB.NET, ASP.NET, PHP, XML, SQL Server 2008 R2, SSAS. SSIS, SSRS, TFS

Worked as a senior software developer on PQSW project. Website is built .NET architecture hosted by TeamSite, involves MS SQL Server database, ASPIRE XML file and various third party sources of public information. Also, worked on BMS enterprise system which consists of various systems bundled together and server as a service provider for VA hospitals. Responsibilities included:

Analysis of user requirements, their implementation and detailed documentation

Developing SQL database for PQSW project

Reading, parsing and uploading into SQL Server Aspire XML file

Developing of SSIS package to automate Aspire XML file quarterly upload into PQSW DB

Working on web interfaces of PQSW website

C#.NET, VB.NET, ASP.NET, XSL, XML, SQL Server 2008 R2, TFS, TeamSite, SharePoint

September 2009 – November 2012 Amadeus, Miami, FL

System Architect, Lead Developer

Worked as a system architect and lead developer on various enterprise projects. Systems built on different architectures and technologies, involving GUI, BE services, Web Services, various SQL databases, Amadeus Selling Platform, etc.

Creating customized scripts which interact with Amadeus Selling Platform

Analysis of user requirements and their integration into existing system

Developing SQL databases for different projects

Designing GUI interfaces according to customer requirements

Creating BE and Web services for robotic applications

Testing, deploying and supporting completed solutions

C#.NET, VB.NET, ASP.NET, XSL, XML, SQL Server 2005/08, Web services, UML, Mantis

June 2002 – August 2009 Spirit Airlines / Results Reservation Tech., Miami, FL

Senior Developer, Architect

Was a part of the team which designed a new airline reservation system. The application consists of front-end written in VB.NET and C#.NET which calls a number of middle-tier Tuxedo services, Informix database as a back-end running on Red Hat Linux platform, SQL Server as a data warehouse and a web platform.

As a senior developer was overseeing a small group of GUI/web developers, responsible for the whole project process: specifications, development, testing, build and release

Worked on multiple web projects & interfaces (booking, availability, OTA, etc.), & WSDL

Developed SOAP/XML services in C++/E-SQL which run under Tuxedo on Red Hat Linux

Designed a new booking process module, availability, passenger reallocation, inventory control, fares and pricing, flight information, accounting interfaces, etc.

Designed DB schema, was responsible for tuning, performance & some administrative duties

Created over 100 SSIS/DTS packages, set up multiple types of replication

Migrated existing functionality from VB6.0 to VB.NET and C#.NET

C#/VB/ASP.NET, Jscript, XSL/XML, SQL Server 2005, Informix 10x, Tuxedo, Linux, CVS

January 2001 – April 2002 Burger King Corporation, Miami, FL

Senior Programmer, Analyst, Consultant

Participated in designing AMWS and CMS databases that store information about restaurant operations. Both databases are currently heavily in use by restaurants and corporate systems. System was developed for working in distributed environment. Participated in:

Developing logical data model & physical database design (data integrity, normalization,etc.)

Programming business logic with stored procedures, UDFs, transactions, triggers and cursors.

Extracting from & packaging data in XML format, flat files and other data providers

Tuning & optimization data access using indexes, SQL Profiler, query execution plan.

SQL Server 2000(DTS, linked servers, Replication), Visio.

Developed reporting part for POS system to provide sales process & information maintenance in restaurant. POS closely interacts with Compris OLE Servers, such as Labor ActiveX, POS Data ActiveX, Inventory ActiveX, etc. New reporting system allows flexible maintenance, scalability & great performance.

Developed number of inventory report forms, with CSS, DHTML & both scripting languages

Used IEobject & WebBrowser Control for calling browser-interface reports from VB applications directly.

Work with IObjectSafety Interface security features for unsigned ActiveX & COM objects in DHTML files

Created system of XML files for data repository.

VB6 (ADO, COM), HTML/DHTML, CSS, VB/ JavaScript, XML/ XSLT, Visual InterDev 6.0, VSS

June 2000 – December 2000 Univision Communications, Miami, FL

Senior Programmer, Analyst

Participated in the development of “A million” project. This multi-tiered, Intranet application was designed to provide a question repository for the show “A Million”. This application is based on a number of distributed COM objects, which are run under MTS. Part of the project was created as an Intranet application with ASP for an outside access to the main database. Responsibilities:

Created a number of methods and properties in the different COM objects.

Participated in database design and modification (query tuning, complex views, triggers, procedures)

Created browser-based forms for contestant interview and different types of inquiries.

Participated in the development of algorithms for data encryption and application security.

VB 6.0 (ADO), SQL Server 7.0, MTS, Crystal Reports 7.0, ASP, HTML, VSS

April 1998 – May 2000 Target Systems Company, New York, NY

Developer, Analyst

Developed CSAM system. It includes customer files management, order processing, inventory, billing, A/R, style master, etc. for apparel manufacturing business. Participated in full project life cycle client/server and intranet/internet applications development, system design:

System analysis, E/R modeling, database schema design and administration (for both RDBMSs).

Implementation of business functions using stored procedures and triggers (for both RDBMSs)

Designing and developing user interface modules and reports.

Transfer existing client/server application to intranet/internet application.

Developing web-based application for integration with existing database.

VB 6.0 (ADO, ODBC, COM), SQL Server 7.0, Oracle 8.0, Crystal Reports 7.0, ASP, HTML, Office 97



Contact this candidate