Oleg Gorodetskiy

SUMMARY

With a MS in Computer Science, Mr. Gorodetskiy has experience in Information Technology in several industries. Operates primarily in a team lead and developer role. Industry experience includes: Scientific Calculations, Artificial Intelligence, Accounting, Billing Systems, Manufacturing Scheduling, Integration, Quality Management and E-commerce. Current skills and technology strengths include database design, web based intranet, internet and n-tier client server systems.

TECHNICAL EXPERIENCE

SYSTEM DEVELOPMENT

Object Oriented Design

Object Oriented Analysis – UML (Select and Rational Rose environment)

Visual Integrated Development Environment

- MS Visual Studio 5/6/2005/2008/2010

/2012/2013/2015

Crystal Reports

Data Warehouse with MS OLAP

ERwin Data Modeler

DATABASES

MS Analysis Services

MS Access 2.0/97/2000

Oracle 7/8i/9i

MS Visual FoxPro 6

Mainframe / DB 2

Progress 8/9

MySQL

MS SQL server 6.5 /7/ 2000/ 2005/ 2008/ 2012/2014

TFS 2008 / 2010/2012

AngularJS

LANGUAGES

HTML

JavaScript

ColdFusion

ASP

ASP.NET 1.1/2003/2005/2008/ 2010/2012/2013

JSP

XML, XSL, XSLT, XHTML

MS SQL-Server/SQL

PL/SQL

MS VB /COM/COM+

MS VB.NET

MS Visual FoxPro

MS Visual InterDev

MS Visual C++

C#

Fortran

Pascal

C

Refal

FoxBase

Clipper

BUSINESS EXPERIENCE

BUSINESS AREAS

Mailing Systems and Inserters

-System Integration

-Scheduling

-Build to Order

-online manufacturing QA

E-business

-events, attendees services;

-online Billing system

-online Library system

-online Logistic system

-E-commerce

Customer Surveys

Airline Services

EDUCATION

DEGREES

Master of Science

Computer Science,

Moscow State University, USSR

CLASSES

MS Accses 2/97

Visual Foxpro 3.0

SQL Server 7.0: administration and programming

Visual Basic 5.0/6.0

ColdFusion 4.5

SQL server 2005: administration and programming

.Net 2.0

ASP.NET security, SANS

CHRONOLOGICAL EXPERIENCE

1/2019– 1/2020: Software Engineer, Spirit Airline, Miramar, FL (

SQL server 2012/2014, .net: 3.5/4.0/ 4.5/4.6,ASP.NET, WebAPI. SOAP, odata. AngularJS, EF,

MS Visual Studio. 2017,C#, TFS2010/TFS 2012.

Optimization AngularJS applications to improve performance of EF, using MS ADO, stored procedures, views, linked sql servers

WEB API - Bid Services

1/2018– 12/2018: Senior Consultant, TekPartners, Miramar, FL (contract with Spirit Airline)

SQL server 2012/2014, .net: 3.5/4.0/ 4.5/4.6,ASP.NET, WebAPI. SOAP, odata. AngularJS, EF,

MS Visual Studio. 2017,C#, TFS2010/TFS 2012.

Updated applications according to version update of Navitaire service,

Optimization AngularJS applications to improve performance of EF, using MS ADO, stored procedures, views, linked sql servers

Microsoft Azure knowledge

2/2015 - 12/2017: Senior Consultant, Marnanmax, Hollywood, FL

SQL server 2012/2014, 3.5/4.0 4.5,ASP.NET, WebAPI

MS Visual Studio. 2012/2013/2015, VB.NET,C#, TFS2010/TFS 2012.

Developed restful services using WEB API for the Customer Management System.Hands-on experience with RESTful web, distributed and cloud services

Prototyped usage of MS Azure (sql server, database and blobs on MS cloud).

7/2015 – 11/2015: Senior Consultant, CERS, FL (contract)

SQL server 2012, 3.5/4.0,ASP.NET, WCF, Fiddler 4.6

MS Visual Studio. 2012/2013, C#, TFS2010/TFS 2012.

Integrated .Everglades Direct Efile4biz.com to Intuit (QuickBooks) app store:

Development included: Single Sign In (OpenID), QuickBooks data authorization/transfer (OAuth) implementation, Access tokens management ( validation, storing, refreshing and disconnecting)

Developed Password hashing, Tokens creation/utilization for Forgot Password and Login AS - functionality

Improved/Developed upload of tax forms in excel files using Efile4biz.com and Tax Forms Import Service (WCF).

Updated and developed SSRS reports via BI projects.

8/2005 - 1/2015: SQL Lead Architect / .Net Senior web developer,Vitacost.com, Boca Raton, FL

SQL server 2000/2005/2008/2008R/2012, JavaScript, HTML, ColdFusion, . NET

1.1/2.0/3.5/4.0,ASP.NET,

MS Visual Studio.NET 2003/2005/2008/2010/2012, VB.NET,C#, ADO.NET, MS Visio, VSS, TFS2008 / TFS2010/TFS 2012.

Created .NET architecture and prototypes for the conversion complete site from ColdFusion to .NET platform and DATA source from SQL2000 to SQL2005/sql2008

Development included:

oBlue Dragon implementation for the step by step cfm pages conversion to the aspx/ascx pages.

oDevelopment of the prototypes for the ASP.NET/HTML pages, User Controls for Master Page.

oPrototyping of ADO.NET related objects such as: SQLDataAdapter, SQLdataReader, DataSet for the .net site.

oDatabase Structure Conversion.

oDatabase related classes development to provide required functionality and secure data access.

oCreation of password encryption algorithm (implemented SHA256)

oCreation of Credit Card encryption algorithm (implemented Rijndael)

Used Winscp (command line and dll) for implementation of the secure files transfer (SFTP protocol) to communicate to pamentech

Used OpenPGP Library for .NET 1.7.6 (DidiSoft) to encrypt files with sensitive information (private/public keys generation and usage).

Implemented Kerberos based authentication for the Applications/WEB Sites/ SQL servers

connections, and data encryption (DPAPI, RSA, Rijndael), secure update procedures

according to PCI/SOX compliance.

Developed documents for the ASP.NET/SQL server coding standards.

Developed Change Management/Source control document based on VSS/TFS usage.

Created TFS custom build and branch management for QA and production SW releases.

Implemented .net based ENDECA search engine/ Dev Studio/Web Studio (6.x, 64 bit).

Developed SSIS packages (dts packages) to extract data from many data sources, transform those data and load result in Endeca indexes.

Implemented multi-level multi product categories structure for the flexible product marketing on web site.

Implemented center-controlled Caches for product data, which significantly improved SQL Servers and Sites performance.

Implemented Active-Active (based on Load Balancers and MS SQL server peer-to-peer replication and failover) enterprise sites configuration, which are geographically located on the EAST and WEST cost of USA.

This allows to balance the load on Web Servers, SQL servers, and promote SW releases on sites during regular working hours with 0 down time.

Performed conversion TFS projects from TFS 2008 (eScrum template) to TFS 2010 (MSF for Agile software development v5.0 template) and TFS2012, Automated Builds with custom tasks. TFS customization: automatic population of source control with sql objects scripts and team queries using TFS API.

Implemented selected pages translation to several different languages using Systran SW.

Implemented web API services for Customer/Checkout Interfaces.

9/2004 – 7/2005: Principal Consultant, Ciber, FL.

SQL server 2000, JavaScript, HTML, ASP, ASP.NET,

MS Visual Studio.NET, VB.NET, ADO.NET, MS Visio.

Support/ Enhancement American Express online Billing/Payment system.

Development included:

oDevelopment/Fixing ASP/ASP.NET/HTML pages, User Controls according to specs.

oImplementation of ADO.NET related objects such as: SQLDataAdapter, SQLdataReader, DataSet and DataGrid.

oDatabase tables/views/stored procedures development to provide required functionality and secure data access.

6/2004 – 8/2004: Principal Consultant, The Monroe Group, Monroe, CT.

Oracle 9i, PL/SQL Developer, JavaScript, HTML, ASP, MS Visio, JSP, Jakarta Struts, Java.

Redeveloped: United Illuminating SMS system: (WEB based system to provide information for power suppliers and energy consumers according to existing government policies and regulations: Oracle 9i, PL/SQL Developer: packages and stored procedures, JavaScript, HTML, ASP, MS Visio)

Development included:

oFixing ASP/HTML pages according to specs.

oDatabase architecture design, package/stored procedures development to provide complete security for production data.

oApplication implementation data extraction via stored procedure calls.

oDocumentation development: Use Case diagram, Class Diagrams, Site diagram.

oPrototype preparation to convert ASP pages to JSP pages via Jakarta struts framework usage.

5/2000 – 5/2004: Principal Consultant, Keane, Inc., Rocky Hill, CT.

MS SQL server 6.5/7.0/2000 –Transact, MS OLAP, Oracle 7/8.i/9i and PL/SQL, DBArtesian,TOAD, XML/XSLT, Crystal Reports 8.0, ColdFusion, JRun3.0, Progress, JavaScript, HTML, ASP, ASP.NET, ADO.NET, C#, JSP, VB 6.0/COM, VB.NET, MS VC++ 6.0/ActiveX control, MS Visual InterDev 6.0.,VSS, FTP, Korn Shell, MS Analysis Services, ERwin Data Modeler.

Developed Plutus: Danzas financial forecasting system: (WEB based system: ASP, ERwin Data Modeler, FTP, SQL2000: stored procedure, triggers)

Development included:

oPlutus application/database architecture creation, prototype development and complete implementation.

oFinancial key performance indicators trend generation using linear extrapolation method (mathematical analysis and formulas creation).

oForecasting Reports creation with frame “frozen” feature for the Plutus users (Financial officers and accountants).

oImplementation of the security management and settings of Plutus.

Created T-SQL script to load Danzas-AEI reporting system for : COSS, Report Writer and Plutus from FTP servers automatically with data validation and user notification via emails(ERwin Data Modeler, FTP, SQL2000: stored procedure, triggers, DTS packages)

Created architecture of Data Warehouse for Danzas Reporting system.

Set Database replications (Publisher/Subscriber snapshot and transactional push replications ). Created cubs and MDX queries. ( SQL2000: stored procedure, triggers, linked servers, distributed queries and RPCs, MS OLAP )

Developed profit share report functionality and modified Enterprise/Client reports (ASP/ASP.NET, C#, JSP, XML, XSLT, JavaScript, SQL2000, ORACLE 8i, ODBC, JDBC, COM, Korn Shell) in COSS and Report Writer ( Subsystems of International WEB based Danzas-AEI logistic system).

Development included:

oASP pages to ASP.NET pages conversion, ASP.NET pages modification and creation (C# has been used for the CodeBehind).

oWEB services development and implementation for the profit share rules.

oADO.NET SqlDataAdapter and datagrid utilization. Stored procedures, UDF development and modification. Queries handled more than 5 million records.

oConversion of SQL server databases from SQL server 6.5 to SQL server 2000

oKorn shell script creation and modification to automate Country/Agent data (shipping transactions) loading into Report Writer database.

oPrototype building and document preparing to convert Report Writer/COSS back end from SQL server databases to ORACLE databases.

Modified GLOBAL RATE -Subsystem of International WEB based Danzas-AEI logistic system (JSP, EJB, ORACLE 8i/9i)

Modification included:

oEditing/Creation of the packages, stored procedures, functions in ORACLE database.

oModification of JSP pages.

Customized the WEB based Library System (ILL “Wings”) for an industry leading Biomedical company (Pfizer, Groton and La Jolla divisions). Implemented connections to the central demographic database and procurement library system: “BiblioTech Pro 2.2”, and developed variety of reports (ColdFusion, JavaScript, VB, COM, Oracle 8.i, Progress, Crystal Reports 8.0).

oDeveloped script and wizard based universal parser for importing of the citation files (ColdFusion, JavaScript,Oracle 8.i).

oDeveloped the networker for communications between different libraries using Oracle message database and Email POP boxes.

Responsible for developing a web based Billing System for an industry leading dot.com - group travel management company (B-There.com). System comprised the configuration and administration screens for billing transactions over variable periods of time (ColdFusion, JSP and JavaScript).Data for the billing system is sourced from a data warehouse with daily and planned semi-real time data feeds

Responsible for summary and detailed billing reports using MS OLAP/MS Analysis Services (Star Schema, cubes and MDX query creation), Crystal Reports ActiveX controls, ActiveX viewer, MS Visual InterDev, VB, VC++/COM and ASP.

oAsp reports development using ADOMD objects to extract data from MD cubes

oWeb based data drill down to detail functionality developed using ColdFusion CFML scripts

oInterfacing of billing system to Great Plain accounting package

oApplication and database level security access control implementation

1998 - 2000: Senior Engineer, Pitney Bowes, Danbury, CT.

MS Visual Studio 6.0, MS Visual Basic 5.0/6.0, DAO, ADO, Access, Crystal Reports 6./7.0, SQL, Visual Foxpro 6.0, MS SQL Server 7.0, ORACLE, HTML, ColdFusion, JavaScript.

Responsible for developing interfaces (Visual Basic 6.0, ADO, Crystal Reports, ColdFusion, HTML, FoxPro 6.0) for APS, a production scheduling system developed by CWAY /Epicore Co. The batch Windows NT Server application loads files exported into MS Access format the APS system. ColdFustion, Active X and Crystal Reports controls generated reports for intranet viewing. FoxPro was used for desktop access. Strong security was applied to financial reports.

Designed and developed a Production Quality Database application using ColdFusion, HTML, JavaScript, Crystal Reports, MS SQL server 7.0, Transact SQL stored procedures, ORACLE, ODBC. Application is used to collect and search for data, generate signed documents, create reports on incoming part quality issues, manufactured assemblies, product installations and quality testing

The system is used by several hundred internal intranet and external internet users. Interfaces to ORACLE provided data feeds.

1994 - 1998: Staff Engineer and Team Lead, Pitney Bowes, Shelton, CT.

Visual Basic 5.0/6.0 CLIPPER, SQL, PCs, Visual FoxPro 6.0, VAX VMS, Novel, TCP/IP, FTP, LAN, FoxPro 2.6 for DOS/WINDOWS, MS Visual Basic 5.0, COM

Developed a Post-Installation Survey System to gather and process information regarding customer satisfaction (FoxPro 2.6, Novell, SQL). This multi-user system allows creates questionnaires and surveys with parent-child relation between questions and answers. Statistical reports generated from the results

Developed a “Built-To-Order” System to configure software applications and install it on customer’s PC’s. Used for installation of shipping systems such as STAR700/400, SEND-IT, ARRIVAL, ASCENT (FoxPro 2.6, Visual FoxPro 6.0, VB6, COM, Novell, RIMAGE systems). The system controls all stages of customer order process, keeps track of production process and shows status of order in production. Interfacing of orders files from IBM to NOVELL using FTP/TCP/IP

Designed and implemented automated warning system based on CC-MAIL software (Windows-95/ Visual FoxPro 5.0 / OLE). The system checks for errors in orders, identifies the causes of errors, and sends the warning message via the CC-mail to inform users on distribution lists for corrections.

Contact this candidate