IGOR CHIROKOV
HYPERLINK "mailto:acz7wi@r.postjobfree.com" acz7wi@r.postjobfree.com
Software Developer
** ***** ********** ** ******** Developer
Knowledge of software development methodologies and processes.
Senior development role in large-scale software development projects.
Proficiency at finding and solving problems.
Strong expertise in data modeling
Analytical problem solving and decision making skills
Working with multiple stakeholders in a problem-solving environment
High analytical & troubleshooting skills
Extensive recently experience of programming in C#, Visual Studio.Net (VS2003, VS2005, VS2008, VS2010), Entity Framework 4.1,VB/VB.Net, Visual Studio 6, ASP.NET, SSIS/SSRS (Integration Services – Fuzzy Match, Report Server, and ETL packages), T-SQL, SQL Server, Java – 1.4-1.6, GUI- Swing, JSF, JDBC, Java WebSphere / Oracle Database(IBM RAD 6.0-7.0) – environment, PL/SQL (PL/SQL Developer, TOAD), Oracle 10g, PHP/MySql. Also have good work experience in Pascal, Fortran, Crystal Report, Infomix, Sybase, Java (J2EE platform, Servlets, JDBC, JSP, XML)
Special Software: Matrox ActiveMIL: version 8.0
CERTIFICATION
Brainbench Master Certification in C#
Brainbench Certifications in OO Concepts VB.NET, ASP.NET, MS SQL Server
Brainbench Master Delphi Fundamentals
SKILLS
SOFTWARE:
Languages C#, VB.NET, Java – 1.4-1.6, Delphi, C/C++, VB (6), SQL, VBScript, JavaScript(jquery.min.js, bootstrap.min.js), HTML, XML, PL/SQL, VBA
Databases Oracle, SQL Server, MySql, Data Warehousing, MS Access, Sybase, Informix, FoxPro, and others
Technology, .NET (1.0; 1.1; 2.0, 3.5,4.0), Entity Framework 4.1, Java, Swing, JSF, JDBC, Java WebSphere / Oracle Database(IBM RAD 6.0-7.0) – environment. OOP, UML and Object Oriented Design, SSIS/SSRS, ETL packages, WinForms, GUI, Perl, OLE/OCX/ActiveX, COM/DCOM/COM+, Win32, API, Client/Server, N-tier, ASP, ASP.NET, PHP, HTML4/5, JavaScript,DAO, ADO, ODBC, UML and others
Systems Windows XP/2000/NT/98/95/3.x, MS/PC DOS, UNIX, OS MFT...MVS, VMS/VAX
Other MS Visual Studio (6,2003,2005), NANT/ANT, MSBUILD, StarTeam, MS Visual SourceSafe, IIS, Visio, APIs, Crystal Reports, MS Office, Borland and others
HARDWARE: IBM PC, IBM 360/370, VAX and others
Professional Experience
05/2016 – 03/2017 Senior Software/Database Developer - Consultant, Entertainment One
Projects
Producer Report System – full redesign, dramatically improved large program – hundred times –included speed running, development and maintenance. Decrease tickets/incidents from Customers. Used Agile Methodology.
Used SQL Server 2005/2008, SSIS/SSRS, DevExpress controls, Net technology – VS 2008/2008/2012, ASP.Net, MVC, C#, Entity Framework 4.1, JavaScript(jquery.min.js, bootstrap.min.js), Ajax, SVN, SourceSafe, LINQ, Crystal Report., WCF, WPF. Used n - tier application with OOP, design patterns.
09/2015 – 05/2016 Senior Software/Database Developer - Consultant, WEBCOM Inc.
Projects
Cost Price Plus/Price List- integrated new future in existing POEM-Planning/Distribution System. ASP.Net, C#,SQL Server 2005/2008/2012, T-SQL script.
On Time Reporting System- new integrated system for POEM POEM-Planning/Distribution System. ASP.Net, C#,SQL Server 2005/2008/2012, T-SQL script, SSIS-Reporting System. Analyzing Data processing.
FTP Receiver – load/ upload data from FTP sites to corresponded Service(WCF Service) . C#, SQL Server 2005/2008/2012
03/2015 – 09/2015 Senior Software Developer - Consultant, NB Computer Services Ltd.
Projects
Conversion big data from text files to Oracle DB(Oracle 11 ); SQL Server 2005/2008 using VB6 code. Core Java- Eclipse environment.
Converting VB6 to C#(VS 2010/2013), ASP.NET, JavaScript(jquery.min.js, bootstrap.min.js), AJAX, HTML, CSS . . Creating, designing new conversion Engines using VS 2010/2013(Framework 4.5), updating and creating new DB components for conversion data. Core Java.
09/2011 – 03/2015 Software Developer - Consultant, Entertainment One/Alliance Films Inc.
Projects
Converting VB6, VB.Net projects to C# Projects for VS2010, backend with SQL server 2005/2008/2012, SSIS/SSRS
Automate the manual steps to transfer the balance of Un Paid revenue account to its corresponded Paid account. C#, T-SQL script, SQL Server 2005/2008/2012,Bulk processing, SSIS, LINQ, documentations – User Requirements Specification(URS), Technical Documentation(TD).
SSIS, T-SQL script, SQL Server 2005/2008/2012, C#, DevExpress controls, Web Development-ASP.NET
Automate import of Maple (Maple Pictures Corporation)Contracts into PRS – Alliance Inc. SSIS,T-SQL script, SQL Server 2005/2008/2012,DB Development, documentations – URS,TD.
Allocation Revenue and Cost from Box Set to Individual Titles. C#, Crystal Report, Epicor9- Customization, documentations – URS,TD
Credit Memo Customization for Epicor 9, C# – URS,TD
Goals of the projects: Design – Development – Deploy to Production - Maintenance, creating new futures for Epicor-software solutions for manufacturing, distribution, services, retail Management Tools. Used SQL Server 2005/2008, .Net technology – VS 2008/2008/2010, ASP.Net, MVC, C#, Entity Framework 4.1, JQuery, Ajax, SVN, SourceSafe, Epicor 9-Customization,LINQ, Crystal Report., WCF, WPF. Used n - tier application with OOP, design patterns.
09/2010 – 08/2011 Software Developer - Consultant, TD Bank
Project
Cash Management System - Consolidated Billing System(CBS) .
JLS - Input Data and Calculation System for CBS.
For Electronic Funds Transfer(EFT) – Conversion Billing Plans and Codes.
AIS – Automated Individual Scorecard - report the scorecard for every person in a branch.
Upgrade from Oracle 9i to Oracle 11g
Struts, Spring, Hibernate, Net Framework -1.0/2.0/3.5/4.0, Transactional SQL/SQL Server 2005/2008, Windows 2003, Oracle 9i/11g, MKS, Crystal Report 10
Web development –Java –J2EE, EJB with Eclipse Platform, JUnit – Unit tests, MVC, jQuery, Ajax
Windows development – C# -Visual Studio 2003/2005/2008, VB6, VB.Net, NUnit
Goals of the project: Maintenance, Development new futures
Development and design standards: IBM Rational® Application Developer™ 7.5 for WebSphere® Software Version: 6.1/7.0 .Used 2-3 tier application with OOP, design patterns.
10/2009 – 08/2010 Software Developer - Consultant, Business Propulsion System Inc.
Project- Risk management system, Java and .NET Framework, used Subversion (SVN) is version control system, Eclipse Platform – Java, Web Application technologies using Apache,wing, JSF, JDBC, Oracle Database /Access/MySql/– environment, VB.Net, C# - AddIns components for Windows XP, Win7, Vista, Object Oriented Design, Microsoft Access convert to Oracle database. Front-end applications.
Goals of the project: To create Tool for Risk management system
Development and design standards: Used 3 tier application with OOP
Build and Testing: Used object oriented programming, Unit tests.
Development/Maintenance: Java 1.4 – 1.6 and C#, .Net technology – VS 2008, ASP.Net, MVC, C#, Entity Framework 3.0 and XML, Ajax, HTML4/5, JavaScript, .NET framework 3.5 Development –PL/SQL Developer for Oracle. Used Multithreading, Multiprocessing.
Consulting: Database development: Data analyzing, improving query performance. Multi DB designing:, Oracle 10g, MySql,, Access, Sql Server., Crystal Report 10
Support/Analyzing: Design Patterns, Report Server, troubleshooting, analyzing performance : Java, C#. PHP
11/2008 – 10/2009 Programmer Analyst/ Software/Database Developer - Consultant, Ministry of Health and Long-Term Care (MOH), Government of Ontario
Project- Health Professions Database (HPDB), used CVS - a version control system, Eclipse Platform – Java, Spring, Hibernate,Swing, JSF, JDBC, Java WebSphere / Oracle Database(IBM RAD 6.0-7.0) – environment, C#, .Net, C/C++, Object Oriented Design, Crystal Report 10
Goals of the project: Analyze business requirements and creating Tool for Comprehensive Planning Database with demographic, educational and employment data for all allied professions.
Incorporate/integrate HSC common utilities.
Short Description: Project consists of three projects-applications – tools.
1. Unique Identifier - UI: using a standard cryptographic hashing function which guarantees irreversibility by nature, hashing algorithms are one-way, used 6 fields for creating. C#, ANSI C, gcc, unique ID – 22 chars - GUI wrapper (at least for release 1.1) is just one TCL/TK script.
2. Preparation Tool – PT - The Preparation Tool will perform conversions based on a set of code tables and a series of .txt files. These .txt files are meant to be edited by each regulatory college so as to match the values in their data source. Stand alone application – used multithreading – GUI and backend thread - core Java
3. Validation Tool – VT – High-performance Rule Engine validates submission data, creating Errors Report - used multithreading – Web and backend thread, multiprocessing – Windows Service – used Java Service Wrapper
Development and design standards: Used 3 tier application with OOP
Systems design: Creating Java applications used on any platforms – Windows, UNIX, Linux
Build and Testing: Used object oriented programming, Unit tests.
The final stage: creating Jar Files for deploying Web, Stand alone and Windows service applications
Development/Maintenance: Java 1.4 – 1.6 and C#.Net, ASP.Net and XML, .NET framework 2.0; C/C++, UML, Development –PL/SQL Developer for Oracle. Used Multithreading, Multiprocessing.
Consulting: Database development: Data analyzing, Adjusted Designed database, creating DAL – Data Access Layer, improving query performance. PL/SQL, Oracle 10g., MVC
Support/Analyzing: Design Patterns, Report Server, Crystal Report 10, troubleshooting, analyzing performance : Java, C/C++,C#
03/2008 – 10/2008 Programmer Analyst /Software Developer -Consultant, Relco Inc.,
Project- Scanning Vision System for Output – SVS, used SDLC, the Systems Development Life Cycle, UML and Object Oriented Design
Goals of the project: Retrieve information (real time environment) from Cutting Machine: useful percent of use a Surface, number of dies used for cutting, date of using dies and so on.
Short Description: Blob, Model and Bar Code Image Recognition – C#.Net, ASP.Net and XML, C/C++, VB.NET, PHP,VS2005; VBA with MS Office XP; database/project management – SQL Server 2005, MySql,Crystal Report.
Development and design standards: Used 3 tier application with OOP – Windows application
Systems design: Detailed definition for hardware and software.
Build and Testing: Used object oriented programming with modular and subsystem programming where code is tested in various levels.
The final stage: Installation (used One Click methodology) and moved from Development To Production stage
Special Software: Matrox ActiveMIL: version 8.0
Development/Maintenance: C#, C/C++, VB6/VB.NET, UML, Win Applications, ASP.NET, WCF, Development –Production process: .NET framework 1.1/ 2.0; T-SQL (SQL Server 7/2000/2005). Used Multithreading, Multiprocessing.
Consulting: Database development: Data analyzing, Design new database, creating Stored Procedures, improving query performance. T-SQL, SQL Server 2005, Integration Services – Report Server, ETL packages.
Support/Analyzing: Design Patterns, Report Server, troubleshooting, analyzing performance : VS2003/2005/2008, T-SQL, C#, VB.Net
11/2007 – 03/2008 Consultant /Software/Database Developer, Toromont CAT, Inc.,
Consulting: Database development: Data analyzing, improving query performance. Migration Sql Server Jobs from SQL Server 7 to SQL Server 2000: T-SQL, VBscript, Perl, Integration Services – Fuzzy Match, Report Server, ETL packages, Data Warehousing
Support/Analyzing: Classic ASP and ASP.NET applications, Design Patterns, Fuzzy Match, Report Server, troubleshooting, analyzing performance: VS2003/2005, T-SQL, C#, HTML, Java 1.4, JavaScript,VBscript, VB6/VB.Net,
Maintenance/Development: Classic ASP, ASP.NET, Win Applications, SQL JOBS – Development –Production process: .NET framework 1.1/ 2.0; T-SQL (SQL Server 7/2000/2005).
6/2007 – 10/2007 Consultant/ Software Engineer, Raymond James Financial, Inc.,
StarTeam Migration project (more then 500 projects)
Consulting: Creating build scripts using NAnt, MSBuild. Creating templates for deployments tools for different type of applications: Web/Windows, Java, .NET Framework 1.1/2.0, VS2003/VS2005, VS6(C/C++,VB6, VBA)
Support/Analyzing system requirements for VS6, VS2003 and VS2005. SSIS: Fuzzy Match, Report Server. Identify program interactions and appropriate interfaces with affected components and sub systems.
Maintenance/Development: Modify programs, including specifying logical and mathematical operations and designing files, input documents, reports, screens and user procedures. Used NAnt, MSBuild. Creating deployment tools(Distribution, Publish, Source) for NET applications( framework 1.1/ 2.0; WEB/Windows applications) and C/C++,Classic ASP,VB5/6 applications.
1/2007 – 4/2007 Consultant/ Programmer Analyst /Software Developer, Cogeco Cable Inc.
Consulting: Data Warehousing, Database converting (SQL Server, Oracle), creating Batches transactions (Credit Cards, Online Adjustment, Reporting): Overnight and On Demand.
Support/Analyzing the existing application Cash Management System/Billing/Adjustment Batch Process: (VISIO, C#,VB6/VB.NET, Oracle/ SQL Server/ MS Access, VBA with MS Office XP) – lead project
Maintenance: Improving performance software. Testing(ASP.NET)
Advanced Database development: Audit database, Triggers : Oracle 8/9, TOAD
Development Environment: Visual Studio 2005, ASP.NET, C#( Design Patterns), VB 5/6, SSIS(Integration Services – Fuzzy Match, Report Server),Crystal Report 8/10
VB- Com Object, Multi-tiered (3)-ASP.NET Application
5/2006 – 12/2006 Software Engineer/Consultant, IPC Information Systems, Toronto
Consulting: Improving Sockets Communication package (Multi-threading )
Support/ Maintenance the existing application Records Management Systems project (PRIORS): (ASP.NET, C#, VB6, Oracle/ SQL Server/ MS Access), Java –code analyzing.
Maintenance: Analytical research and improving performance software.
Resolve any identified bugs/application anomalies. Testing, Perform Unit Testing
Advanced Database development: Complete Audit all data, Triggers : Oracle, SQL Server 2000, Access 2000/2002, ASP.NET,C#, VB 6, VB.NET, Crystal Report 6/8/9/11
5/2002 – 4/2006 Senior Software Developer, Wells Hospitality Systems, Toronto ON
Consulting: Designed new capabilities for Point-of-Sale (POS) system; Business Vision software: Analyzing database, reports.
Virtual Manager Software: Analyzing database, Business rules, reports.
Converted software from desktop application to .NET Technology.
Converting SQL server database to Oracle, used TOAD 8, UNIX / Windows OS, N-Tier
Applications. Development: Scheduling with Forecasting and Replication Features,
Sales Forecast (Statistical Linear regression Model), Reports
Business Vision software: creating additional software package
Maintenance: Restaurant Service Applications (more 1 million compiled lines of code); Internet application (about 1.5 million compiled lines of code)
Languages: C#, ASP.NET, XML,QL Server, T-SQL, Oracle 8/9, PL/SQL, VB5-6, VBA – Access 2000/2002, VB.NET, Delphi 5/6/7, Crystal Report 8-9, Pervasive 2000 (Btrieve database), Access 97/2000, InstallShield
12/2001 – 4/2002 Consultant, Delivery-Point Shipping Inc., Toronto, ON
Provided E-commerce/ Internet solutions for Delivery-Point business
Created deployment tools, using Apache Ant
Created web-application, using j2ee technology,
Languages: C-Unix(Solaris),Java 1.3, Servlets, JDBC, EJB, XML, JSP, Apache
Server, Orion web server, Sybase7.0.3, Informix, mySQL, MS Access, SQL Server
11/1999 – 11/2001 Senior Software Developer, Wells Hospitality Systems, Toronto ON
Consulting/ Development: Designed new capabilities for Point-of-Sale (POS) system;
UNIX / Windows OS, N-Tier Applications.
Maintenance: Restaurant Service Applications (more 1 million compiled lines of code); Internet application (about 1.5 million compiled lines of code)
Languages: SQL Server, T-SQL, Oracle 8/9, PL/SQL, VB3-4, Delphi 1-4, Crystal Report 6/7, Pervasive 2000 (Btrieve database), Access 97/2000, InstallShield
2/1998 – 10/1999 Senior Programmer / Analyst, Transformation Processing Inc., Toronto ON
Web-development. Created input web-application for database Embedded 2000 Repository – back-end: ACCESS 97
Developed database Embedded 2000 Repository
VB 5, Crystal Report, MS-ACCESS/97, InstallShield, Documentation- HTML - Help
Maintenance, testing and creation new functions for Translators:
1. From RPG-AS400 to C-ANSI(C/C++, Perl 5, LEX (FLEX), YACC (BISON)
2. GUI (Windows Programming – API /Visual C++)
3. COBOL-AS400 to MicroFocus COBOL (C/C++)
Windows NT/95, UNIX
Developed Inspector C/C++ - for Analyzing and Inspection C and C++ source code (Y2K: Inventory, Scanning, Propagation, Inspection and Checking) and Testing. Documentation.
Languages : Windows NT/95, InstallShield, C/C++, VB5 (converting to VB6), SQL-Server 6.5, MS-ACCESS97, PCLEX, PCYACC
5/1999 – 6/1999 System Architect /Consultant, Norbel Metal Company, Toronto ON
Converted database from ACCESS 2.0 To ACCESS 97(VBA)
Converted, checked and fixed source code
Fixed Y2K bugs
3/1997 – 2/1998 Project Leader /Programmer/Analyst, Unique Systems Inc., Toronto ON
Designed and developed database UniqBase System for System Documentation, WorkOrder Database for Invoice -VBA, Job Order Processing and Part Numbers Inventory. Windows NT/Server 4.0, WINDOWS 95,Visual Basic 5.0, Access97, ActiveX Control, Delphi 2.0
Created applications for Digital Audio Broadcasting (DAB): Windows NT, HP Open View Windows
Languages : (TCP/IP, SNMP), VB5.0, C/C++ (Visual C Client/Server Application (sockets programming) : Windows NT 4.0 -VxWorks; UNIX, VB5.0, C/C++ (TCP/UDP/IP-protocols)
10/1996 – 3/1997 Programmer / Analyst, Enigma Software Corp., Toronto ON
Designed, developed and implemented Web application (Database) for Medical Information System.
Languages : UNIX for PC, Windows NT/Server 3.51, WINDOWS 95, Delphi (Client/Server), Interbase, VB5.0, VBScript, HTML 3.2, Java, JavaScript, LiveWirePro, ActiveX Control Pad, Informix 7.2
8/1996 – 10/1996 Programmer / Analyst, Info Systems, Toronto ON
Designed and developed database for info-system.
Languages :Windows 95, Windows NT 3.51, VISUAL BASIC 3.0, Delphi (Client/Server, 2.0), Interbase, ACCESS 2.0
3/1995 – 7/1996 CNC Programmer, Global Company, Toronto ON
1/1992– 7/1993 System Architect /Senior Programmer, The State Russian Bank, Moscow, Russia
Prepared and analyzed Statistical data for insurance company in C/C++
Improved databases and streamlined operations in Business Basic,COBOL, C, FORTRAN 77
1/1985– 1/1992 Project Leader /Senior Programmer, The State Scientific Research Institute of Energy,
Moscow, Russia
Provided system design, programming, testing, documentation, technical support and maintenance of software for nuclear-physics, economical and statistical calculations WINDOWS, UNIX, C, Assembler
Designed, developed, and implemented software for computer simulation for developing engineering and nuclear reactor systems UNIX, C, FORTRAN 77
Developed the multicriteria optimization model for calculation of economical characteristics. MS DOS, UNIX, C
Developed Non-Linear Optimization model. Used statistical methods and methods of linear and nonlinear analysis. MS DOS, UNIX, C, FORTRAN 77
EDUCATION
PhD in Mathematical modeling, designing software for physics/economics
Master of Science (Computer Science), MOSCOW STATE UNIVERSITY, Moscow, Russia
Master of Science (Physicist), Moscow Power Engineering Institute (Technical University), Moscow, Russia
REFERENCES
Available upon request