SUMMARY OF QUALIFICATIONS

• General
• Supervision of a team of developers
• Software project management
• Partnership with software development and quality assurance companies abroad
• Hands-on experience with Systems Development Life Cycle SDLC and agile development
• Excellent communication skills and authoring of written documentation and correspondence
• Proactive and able to handle multiple projects simultaneously
• Extensive knowledge and background in natural language processing, Client Relationship Management CRM , taxi dispatch products, banking and investment management systems.
• Programming languages
• Delphi Object Pascal 12 yrs
• C/ C , C .NET 8 yrs
• Perl, PHP 5 yrs
• Java, ASP.NET 4 yrs
• JavaScript, HTML
• Assembler
• Database Management Systems
• Advanced level of SQL programming and database management 11 yrs :
• database design and management of databases, schemas, tables, views, users, roles, indexes, constraints, jobs, alerts, reports, cubes, dimensions, data transformation queries writing and profiling, performance tuning development and debugging of triggers, functions, stored and extended stored procedures with external code in dynamic-link libraries database migration, backup/restore, replication
• Transact-SQL Microsoft SQL Server 2000-2014 10 yrs
• MySQL, Oracle PL/SQL, Sybase, Access, Paradox, FoxPro, dBase, Excel, XML, flat files
• Operating systems: Microsoft Windows Linux Ubuntu, RedHat, Knoppix IBM AIX

Technologies

• Microsoft Windows .NET Framework: Windows Presentation Foundation WPF , WinForms, ASP. NET, LINQ Web Services, WCF, XSL transformations, DCOM, ADO, Windows Services, Win32 API
• Unix/Linux Perl Catalyst MVC, LIBC standard library , Standard Widget Toolkit SWT , Swing, Eclipse, Java Server Pages JSP
• Other
• Version control systems: Git, Atlassian Stash and SourceTree, MS Visual Studio Team System, Apache Subversion SVN
• Management of server roles and services Web Server IIS, Apache , MS Exchange
• Shell scripting, batch files authoring
• CRM products: ProTrak Advantage, PerTrac/Whittaker Garnier CMS, Sage Act 2007, NetAge Solutions Dynamo Hedge Fund CRM, MS Dynamics, Commence
• Automatic reports creation with custom tools and various integrated reporting systems
• Documentation authoring using MS Office Suite Excel, Access, PowerPoint, Word, Visio
• ER diagramming project management with MS Project
• Custom software development for smart phones Android, Symbian/Nokia
• Advanced graphic/video design using Adobe Photoshop, CorelDRAW, 3D Studio Max, Lives

WORK EXPERIENCE

Senior Software Developer Confidential

Key responsibilities

• Development of the dispatch system OnQ , including:
• Windows services to interact with mobile units and various webservices C , .NET 4
• Web API and website for interaction with users, mobile apps, and third-party products
• WCF and Windows services for automatic updates of all software components on servers and workstations .NET 4.5
• Database design and management MS SQL
• Embedded and mobile software development Android, Windows CE
• Comprehensive reporting standalone application WPF, DevExpress
• Numerous reports embedded in dispatch system Crystal Reports
• Development of installations, authoring of technical documentation
• Technical customer support, deployment, upgrades, troubleshooting, performance tuning, profiling
• Code review for PCI compliance of the corporate website, database and services

Confidential

Independent Information Technology Consultant

• Full management, development, and marketing of software for Natural Language Processing/Learning
• Software for learners of foreign languages C .NET, WPF, WinForms, MS Visual Studio, CryptoAPI, .NET Framework 3.5
• Website for language learning software HTML, JavaScript, PHP, Microsoft Web Developer
• Speech recognition Research and Development R D C .NET, WPF, WinForms, Microsoft Visual Studio Team System, .NET Framework v.3.5, Delphi Object Pascal
• Natural language translators and multilingual dictionaries with word, phrase, transcription lookup C .NET, WPF, WinForms, Microsoft Visual Studio, .NET Framework 3.5, Delphi Object Pascal

Confidential

Key responsibilities, tools and technologies used:

• Complete development of the natural language processing module for the Website real-time processing of a large number of user queries, Perl, Catalyst Model-View-Controller MVC , agile development, Apache HTTP Server, Subversion SVN , MySQL, Ubuntu Linux
• Development and debugging of many other modules of the Website various back-end processes handling and debugging of the client-side results produced as HTML pages
• Database design and development creation of table structures, views, and stored procedures that incorporate the business logic required by the Website population and normalization of data making sure that the data integrity is intact through primary/foreign keys, table/field constraints, default values optimization of performance, query/views/stored procedures tuning MySQL on Linux Ubuntu, standard tools coming with MySQL server
• MySQL database server administration on Ubuntu Web server, including data dumps, backups, SQL debugging and running updates using secure shell SSH , secure copy SCP

Confidential

Senior Software Developer/Computer Systems Analyst

• Confidential private company specializing in software products for pension funds and investment markets its client list includes a lot of internationally recognized companies traditional investment and hedge funds : Artisan Funds, Delaware Investments, F C Investments, GM Asset Management, Gryphon, Hamilton Lane, Marathon Asset Management, and many others
• Main software product: ProTrak Advantage Client Relationship Management CRM System
• Main tools and technologies used: Borland Delphi, MS Visual C .NET, WPF, WinForms, ASP. NET, MS Visual Studio Team System, Visual SourceSafe, MIDAS 3 tiers , ADO, MS SQL Server 2000-2008, Win32 API, MS Office integration and automation Outlook/Word/Excel/Access , .NET Framework 3.5

Key responsibilities

• Project management, supervision of a small team of developers
• Core functionality design, development and debugging, including:
• front-end user interface, integration with MS Office Suite Outlook, Word, Excel automation
• business logic on the application server side middle tier and the database server back-end using queries/triggers/stored procedures written in Transact-SQL MS SQL
• sync module data retrieval for the synchronization through queries/views and stored procedures
• parameterized and customizable reports data retrieval through queries/views/stored procedures
• the sophisticated state-of-the-art custom Query Builder QB module with drag-and-drop interface and a multitude of features data retrieval, table/views linking, search/filtering by criteria, expression evaluation and use in criteria export reports in numerous formats such as HTML, XML, PDF, XLS, etc. mass email creation integration with other modules of ProTrak Advantage CRM design and creation of tables/views and stored procedures that support the QB module
• Database architecture design, creation, and profiling MS SQL , including creation of tables/views, making sure that the data integrity is intact through proper transaction handling, primary/foreign keys, table/field constraints, default values and rules, writing queries in a distributed environment development of stored procedures, triggers, functions, performance tuning, profiling
• Conversion from numerous systems of competitors: CMS by PerTrac/Whittaker Garnier, Act 2006/2007 by Sage, Dynamo Hedge Fund CRM by NetAge Solutions, MS Dynamics, Commence, and a lot of custom solutions this involved a lot of data migration, writing queries in a distributed environment to retrieve data writing views, stored procedures, and extended stored procedures with external code in DLLs written in C .NET Transact-SQL MS SQL
• Database management MS SQL , including schemas/users/roles management, database backup/restore, management of jobs and alerts, dumping of tables/views, and database migration
• Build automation, development of installations, deployment management
• Technical support assistance, quality assurance

Confidential

Senior Software Developer

Confidential software development company: banking system and other products Oracle Certified Partner among this company's clients are: JSCB HVB Ukraine Bank Austria Creditanstalt AG , ING Bank and more than 30 Ukrainian banks

Major projects, tools, technologies, and key responsibilities

• Client Relationship Management System ProTrak Advantage CRM Delphi, MS SQL Server 7.0/2000/2005, MIDAS 3 tiers , Win API, Borland TeamSource native version control system for Delphi
• Core functionality development: GUI, Outlook/Excel/Word automation, reports, business logic application servers , import/mass mailing/query builder/sync/calendar/other modules
• Database architecture design and creation, query optimization development of triggers and stored procedures creation of reports, data dumps, backups performance tuning, SQL profiling, database migration
• Oracle PL/SQL
• Core functionality development
• Database architecture design and implementation, creation of tables/views/triggers/stored procedures
• Installation development InstallShield Professional
• Maintenance, quality assurance, and technical support
• CGI extension for Apache Web server for US-based auto dealers PHP, Perl, GNU C , shell scripting, MySQL, RedHat Linux, Apache
• Development of a Website based on the template provided by the customer
• Site's interaction with users
• Data storage and retrieval creation of MySQL databases, tables, views, triggers, and stored procedures management of data dumps, backups restoring data from dumps/backups
• Email processing and automatic sending of notification
• CostExpert: Financing and Cost Estimation System for Marotz Company Calif. Delphi, RDBMS Oracle 7 8, PL/SQL, Paradox
• Data processing and transformation creation of tables/views/triggers/stored procedures database migration, backup/restore
• Medium and minor functionality
• Installation development for all parts of the system
• File Transfer Server Windows NT 4.0, Linux RedHat, IBM AIX 4.2. Microsoft Visual C 6.0, WinSock, Win API, WinInet API, LIBC, Unix shell scripting, Windows batch files
• Network communication using the following protocols: UDP, TCP/IP and FTP
• Security enforcement
• Data compression
• Porting the project to Linux and AIX
• Multitier distributed computer system for Optical Character Recognition OCR of Health Care forms and documents, developed for Dakota Imaging Columbia, MD Windows NT, Linux RedHat, IBM AIX, Microsoft Visual C Sybase Adaptive Server
• Development of various software components client and server applications , porting to Linux/AIX
• Network data transfer, compression, encryption
• Security enforcement
• Documenting, quality assurance, technical support
• Database design tables/views creation , and data manipulation writing queries and stored procedures database backups user/roles management