Post Job Free

Resume

Sign in

Sql Server Software Developer

Location:
Toronto, ON, Canada
Posted:
May 09, 2017

Contact this candidate

Resume:

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



Contact this candidate