Sql Server Data

YURI KONDRATYEV

**A Vanbrugh Ave.

Toronto, Ontario M1N 3T4

E-mail: acssnb@r.postjobfree.com

Home Tel. 647-***-****

OBJECTIVE

To obtain a position as a Senior .NET Developer

PERSONAL HIGHLIGHTS

Master’s Degree in Computer Science

Seventeen years of experience in designing, database modeling, developing and implementing innovative solutions for financial, businesses, engineering, transportation and logistics applications. Work extensively in designing and developing relational database management systems, n-tier client/server applications and multiple interface applications

Experienced with all phases of the SDLC, with emphasis on system design and analysis

Excellent skills in data architecture and modeling/warehousing techniques

Excellent database administration, tune up and performance trucking skills

Excellent debugging and problem solving skills

Excellent planning, analytical, organizational, and writing skills

Self motivated, with methodical, meticulous work habits and people skills

PROGRAMMING LANGUAGES AND TOOLS

Borland C/C++, Visual C++ (MFC, ATL, STL), Visual Basic 3/4/5/6, VB.NET, C#, ASP.NET DAO/ADO, ADO.NET, COM/DCOM, COM+ (ATL, IDL, OLE, ActiveX), Crystal Report 6,8,11, Microsoft Reporting Services, Visual Studio 6, Visual Studio 2003/2005/2008/2010, Rational Clear Case, HTML, VBScript, Java Script, Visual Interdev, Web Services/ Portal Technologies,

TCP/IP, ASP, ASP.NET

DATABASE MANAGEMENT SYSTEMS

MS SQL Server 6.3/7/2000/2005/2008/2012/2014, Integration Services (SSIS), Reporting Services 2005/2008 (SSRS), SQL Server Analysis Services (SSAS), OLAP Cubes, T-SQL, MS Access, Oracle 7.3/8i/9i/10g, MySQL, DB2/UDB 5.1 / 5.2, Sybase Unix Oracle Reports, SQL*Plus, PL/SQL

TESTING AND ISSUE TRACKING TOOLS

Quick Test Pro.9.2, Win Runner 4.0/6,0, Load Runner 6.0,Quality Center, TestDerector 7, Mercury, Test Partner 6.0, QA Run 4.9.1, WebCheck, QA Director 5.01,QALoad, AutoMate4, "Bugzilla", "Buggit", TrackRecord, Infoman, Issue Trucker, FogBugz, Selenium Web Driver

WORK EXPERIENCE

July 2014 - Present

Architect-Developer RateTheFreight, Toronto, Ontario

Net development and project highlights

Designed and developed Framework for RateTheFreight portal

Designed front end website layout, pluggable dynamic menu system for the main window, Master webpage.

Designed database structure for RateTheFreight

Designed and developed DAL for RathTheFreight which consisted of main business logic classes and WCF communication layer which allows to place DAL components and Database on a remote control for distributed computing and keep them from DMZ.

Designed and developed Rating Engine.

Designed and developed Compliance Posting System with integration to WSIB and DOT(department of transportation) websites.

Developed Automation Scripts for regression tests.

Tools: Visual Studio 2010, C#, SQL Server 20014, JavaScript, JQuery, Telerik Controls, Selenium Web Driver

Jan. 2013 – July 2014

Senior Application Developer Constellation Home Builders Systems, Markham, Ontario

Net development and project highlights

Enhance current and create new product update modules for Constellation Updater – windows service for automatic updates for Constellation Home Builders suite of applications. Constellation Updater is capable of updating windows applications, windows services, web services, web applications, updating Progress and SQL Server databases schemas, uploading rdl files to SSRS servers, with code and database backup and rollback capabilities.

Compile, obfuscate and prepare update packages for new releases, create SQL update scripts.

Developed Regression Automation Scripts.

Modify Install Shield projects to include latest releases into setup packages

Provide level 3 customer support.

Tools: Visual Studio 2012, C#, SQL Server 2000/2005/2008/20012, OpenEdge9/10/11,

VBScript, Visual Basic 6, TFS, QTP,,Batch Scripting, VBS scripting

Nov. 2011 – Jan. 2013

Senior Database Developer Syncada from Visa, Toronto, Ontario

Database development and project highlights

Enhanced current ETL processes, which involves extracting data from multiple SQL Server Databases, unification and harmonization of old legacy systems with new system and loading into DB2 warehouse.

Analyzed, redesigned and streamlined the ETL packages and reduced loading time from 5 hours to 1.5. The project utilizes advanced techniques such as package templates, checkpoints, dynamically generating packages and component development.

Gathered and analyzed customer data volume and load requirements.

Modeled data conversion methodology to plan data loads based on sizing.

Converted customer data through initial and/or delta load processes involving batch or real-time integration with existing systems.

Wrote and tuned queries to optimize performance loads, created stored procedures, scripts and data mapping for ETL packages.

Managed and tested mock production data loads.

Debugged and resolved defects.

Wrote documentation, release notes, provided knowledge share session to team members.

Tools: Visual Studio 2008/2010, C#, SQL Server 2005/2008, Integration Services (SSIS), DB2 9.7,

TFS

Jun. 2011 – Nov.2011

Senior Programmer Analyst Smartech Consulting Inc., Markham, Ontario

Database and Win32 development and project highlights

Designed and created an ETL data integration project to load offline constituency, team and donation data from Cornerstone Fundraising Solutions into Convio Systems for the fall Run For Cure 2011 event.

Designed and created an ETL data integration project to load online constituency, team and donation data from Convio Systems into The Raiser's Edge CRMS for Canadian Brest Cancer Foundation.

Projects included modules for data cleansing and validation, address correction and validation, constituency matching against existing ones to avoid duplication and reporting statistics, error and process's progress.

Tools: Visual Studio 2008/2010, C#, SQL Server 2008, Integration Services (SSIS), Reporting Services 2008 (SSRS), Batch Scripting, VBS scripting

Sep. 2009 – Jun. 2011

Senior Programmer Analyst Global Credit and Collection Inc., Markham, Ontario

Win32 Development and project highlights

Designed and developed API library for a new eCollect 3.1 suite of applications. The API is a two-tier system – one tier is a definition of business objects and business rules for front end applications such as eCollect3.1, Workflow Manager, Scheduler, Dialers, Client exchange data programs, web applications, etc. Another tier resided on the server for all DAL logic. Communication layer between two tiers was done via WCF.

Designed and developed New Business Distributor which distributed new accounts amongst collectors using pluggable distributing modules: Target Box Count, Distribute Evenly By Count, Distribute Evenly By Balance, Distribute Randomly.

Supported legacy eCollect2.6 system. Developed modifications for legacy system per user requests.

Supported existing and creating new client data exchange programs to load new accounts, update existing accounts, process recalls and accounts inventories, send transactions, activity logs.

Supported settlement, compliance and clearing modules

Supported credit bureaus, wash data exchange programs.

Supported payment transactions data exchange programs: Direct Debit, ACH, US Credit Cards, Canadian Credit Cards.

Database administration and development

Created a data mart for Avaya Dialer, which was used to track dialer calls, collector calls, duration and response types. Created ETL packages to load the data from Dialer Transactional database into the data mart. Created multiple reports for data analysis and client reporting on account activities.

Designed table strictures, wrote SQL statements, analyzed SQL statements execution plans, wrote ad-hoc reports, developed stored procedures and functions, assessed the performance impact of any system change.

Created maintenance plans for automatic database backup, reorganizing data and indexes, truncating log files, updating statistics and removing unused spaces.

Created SQL profiles and implemented partitioning, analyzed database performance.

Quality Assurance

Created and executed Unit Tests.

Performed code reviews.

Tools: Visual Studio 2008/2010, C# VB.NET, Visual Basic 6, SQL Server 2005/2008, Integration Services (SSIS), Reporting Services 2008 (SSRS), SQL Server Analysis Services (SSAS), Access 2007, Crystal Report 11,WPF, WCF, WIN32 API, COM/COM+, Win XP/Win 7,UNIT Test, Issue Tracker, FogBugz, TOAD

June. 2009 – August. 2009

Senior Database Developer Imperial Tobacco Canada, Brampton ON

Database development

Created new data mart for the Logistics Department which was used for analyzing efficiency of dispatcher routs / load distribution / travel time. Created ETL package to load data from Transactional database into the data mart with a script to calculate Miles on the routs, created multiple reports for data analysis.

Tools: SQL Server 2008, Integration Services (SSIS), Reporting Services 2008 (SSRS), VB.NET

Sep. 1999 – Apr. 2009

Senior Systems Analyst VirtualDispatch Inc., Stouffille ON

Win32 Development and project highlights

Work on second and third releases of Excelerate 9000 and Excelerate Lite TMS (Transportation Management System). The system includes new features such as Simple and Advance Equipment Trucking for light and enterprise solutions, Automated Dispatch, interface with Qualcomm Satellite Tracking, EDI Communication, Automated Payroll processing, Equipment Maintenance, Warehouse Module, Online Order Entry, Online shipment tracking, Online PO/BOL/PRO documents processing, online reporting.

Work closely with customers to analyze, recommend, and provide detailed documented solutions in order to implement changes appropriate to the customer's specific business needs. Responsible for defining and resolving technical issues and establishing a methodology for communication and on-going resolution. Acquire and maintain working knowledge of the customer's operations, interact with Administrative staff to gather and analyze customer’s requirements, formulate, justify and recommend alternatives in order to customize Excelerate 9000 TMS including the identification of major system enhancement to suit customer’s business model. Install Excelerate at new customers, train and “going live”.

Created Standalone Report Application, which allowed dynamically add new reports to the existing system allowing highly customizable report system. Developed multiple reports using Crystal Report and Microsoft Reporting Services – Customers/Vendors/Users Lists, Invoice reports, Statement Invoices, POD, Profitability, Salesperson Commissions, Payroll Reports, Transfer Reports and many others.

Designed and developed Automated Commercial Environment (ACE) communication system to U.S. Customs and Border Protection. The ACE project is part of a modernization plan, which requires electronic manifest submissions from highway carriers to U.S. Customs one hour before the truck reaches the first port in the United States or 30 minutes prior for FAST shipments.

Developed BarCode Sticker Print out and automatically linking scanned documents with BarCode stickers into the database for Customer’s retrieval via Internet.

Developed interface to intercept from and send to CanCom Satellite macro messages to automatically update trip statuses, to notifying drivers on new orders/changes on existing orders, to track equipment to help dispatchers to make an informed decisions.

Designed and developed warehouse system, which worked in conjunction with Excelerate 9000. The warehouse application allows creating inbound manifests and warehousing items directly from Excelerate 9000 thus eliminating double entry in the organization. System allows scanning in, scanning of and tracing movement of warehouse item in the warehouse, to generate a Pick-Ticket report when user create an outbound manifest, to generate notification to suppliers on low stock items.

Designed and developed Internal Communication system, which allows users of Excelerate 9000 to exchange orders, assign carriers, confirm pickups/deliveries, invoice and send tracing documents electronically.

Designed and developed rate system zone based on user defined zones, zip/postal codes and city/states. Created interfaces to RateWare and CZAR rating engines

Customize project upon customer requests.

Support sales and marketing efforts, create appropriate documentation such as presentations, technical guides, represent company’s software product to potential customers (buyers), participate in trade shows.

Web Development and project highlights

Developed ASP.NET application for remote Order Entry, online reports, online shipment trucking.

Developed class hierarchy for Excelerate Live system.

Developed ASP.NET QuickBooks Online Integration module for Excelerate Live.

Developed Automated Commercial Environment (ACE) communication system to U.S. Customs and Border Protection for Excelerate Live.

Created multiple reports with Microsoft Reporting Services.

Created multiple Web Services and Interfaces to Web Services.

Developed Class/Code generation tool to speed up development process.

Database administration and development

Administered databases at the development and customer sites, tuned up, trucked performance and troubleshoot.

Designing table strictures, wrote SQL statements, analyzed SQL statements execution plans, wrote ad-hoc reports, developed stored procedures and functions, and assessed the performance impact of any system change.

Wrote procedures to move data from legacy systems into production databases, created LTL packages to import data from various source systems into SQL Server database.

Installed, backed up and restored database.

Profiled SQL server.

Created maintenance plans for automatic database backup, reorganizing data and indexes, truncating log files, updating statistics and removing unused spaces.

Created users and roles and assigned user rights.

Created SQL profiles and implemented partitioning, analyzed database performance.

Quality Assurance

Designed and built Test Automation Architecture for Auto-Regression Testing of Excelerate, Excelerate Live and Excelerate 9000 TMS (Transportation Management System) systems.

Design and execute test strategies and test plans for SIT/UAT of new and next releases projects of Excelerate Lite, Excelerate Live and Excelerate 9000.

Design new and maintain, improve current production scripts, test scenarios and data matrices accordingly to changes made in Excelerate family products [new functionality, features, business rules] through its SDLC.

Setup and configure testing environment to cover all aspects for SIT/UAT performance.

Execute test scripts and schedule multiple test machines used in QC Auto-Test Lab for performance and load testing.

Execute test script runs for regression packages for Excelerate Lite, Excelerate Live and Excelerate 9000.

Designed and implemented Nonstop Mode to test new releases of Excelerate family products without maintenance of reusable scripts, to validate new GUI or Non GUI objects, new features implemented in new releases.

Designed Test Manager Module and replaced QA Director [Compuware] to provide a user with full control, flexibility and information during overnight unattended execution in 24*7 schedule.

Tools: SQL Server 6.5/7/2000/2005, Integration Services (SSIS), Reporting Services 2005 (SSRS), SQL Server Analysis Services (SSAS), OLAP Cubes, Erwin, Access 2000/2007, WIN32 API, COM/COM+, Visual Basic 6,VB.NET, ADO.NET, ASP.NET, Crystal Report 6/8/11, Microsoft Reporting Services, Visual InterDEV6, FTP protocols, WinInetAPI, XML, Visual Basic Script, WHS, VBA (MS Exel97/2000), Windows NT4/Win2K/Win XP/Vista platforms, QTP.8.0/9.0, Quality Center, TestDerector 7.oi - Mercury, TrackRecord, FileAid

Mar. 1998 - Feb. 1999

Programmer Analyst Antropos Networking Technologies Inc., Toronto

Win32 Development and project highlights

Designed and implemented a three-tier architecture for Load and Equipment Matching application. Designed user interface and workflow of Load and Equipment Matching application. Designed and coded a Parser/Generator which would take as input a text stream describing business functions, parse that stream for recognizable tokens and generate the SQL statements corresponding to the requested/required actions against the database. Was responsible for creating logical and physical models of data structures that are stored as database objects to solve specific business needs. Gathered business requirements, created functional prototype of internal and external systems designs, including definitions of databases, files, programs and module, developed stored procedures, functions, evaluated technical options. Established and maintained technical environments for construction, testing and implementation of programs and modules, developed detailed program specifications from general specifications, coded programs, prepared test plans/scripts/data for UT, SIT, UAT and performance testing, assisted in all aspects of implementation, provided technical support to systems analysts and junior staff, on occasion, supervised the activities of junior team members. Investigated and resolved system problems, and provided post-implementation support.

Responsible for administrating databases, tune up, performance trucking and troubleshooting.

Tools: Oracle 7.3, Developer 2000, Discoverer 2000, Oracle Reports, Crystal Report 6.0.

Aug. 1997 – Feb. 1998

Programmer Analyst Smart Line Inc., Toronto

Win32 Development and project highlights

Analyzed customers’ business needs and requirements. Conducted feasibility studies and analysis of requirements for new applications. Designed and implemented custom databases for Inventory Management System. Tested final products (identified the causes, debugged, modified, and wrote subroutines to fix problems). Assisted in the completion of system testing. Prepared and updated technical documentation of individual programs and system flows, as required by the end-users. Delivered unit tested code for all functions as assigned in accordance with Development Methodologies and Programming Standards set by Smart Line Inc.

Database administration and development

Administered databases at the development site, tuned up, trucked performance and troubleshoot.

Created new SQL queries ad-hoc reports as users requested.

Tools: SQL Server 6.5, Access 7, Visual Basic 5,Crystal Report, Visual C/C++, Windows NT4.

Sep. 1996 - Jul. 1997

Programmer Analyst DBL Ltd., Toronto, Ontario

Win32 Development and project highlights

As a programmer-analyst, designed and developed General Ledger Module for Visual Manufacturing application. This module is the sole automatic input to the General Ledger system, and all applications, which need to feed the General Ledger, must go through this application. Module can import data through EDI communication, flat, DBF and MDB files.

Designed and developed Order Entry / Billing, Payroll / Human Resources modules. Created new sales profitability, salesperson profitability, customer profitability, order, invoice reports. Also was responsible for troubleshooting problems discovered during product testing and implementation, as well as customization and redesign of user interface based upon suggestions made by customers.

Tools: SQL Server 6.5, MySQL, WIN32 API, Visual C++ (MFC, STL), Crystal Reports 4.5, Windows NT4 platform.

Jun.1994-Aug.1996

Programmer Bank “Ukraine”., Kiev, Ukraine

AS/400 MainFrame Development and project highlights

Designed, coded, supported line modules on MainFrame that communicated with AS/400 using APPC and Message Queue Series.

Created APPC simulators on AS/400 for unit testing.

Designed, coded, supported day/night mode switching programs on Mainframe for conformance with AS/400.

Designed, coded data conversion programs (from Mainframe to AS/400).

Tools: AS/400, Cobol, C/C++

EDUCATION

1989-1994 MS Degree in Computer Science (5.5 years Masters Degree Program).

National Polytechnic University, Kiev, Ukraine.

REFERENCES

Available upon request.

Contact this candidate