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