Resume

Sign in

Sql Server Oracle .Net

Location:
Toronto, ON, Canada
Posted:
April 14, 2016

Contact this candidate

Resume:

PETER YANITSKY

Phone (cell): 416-***-**** ** Knoll Drive, Toronto, ON, M9A 4G9

Phone (res): 416-***-**** E-mail: acucx5@r.postjobfree.com

PROFFESSIONAL PROFILE:

Highly skilled IT professional with 15+ years of experience in Application Development, Systems Architecture and Database Design

Worked with various clients in financial, telecommunication, retail and advertising sectors, including CIBC, BMO, Sun Life, PricewaterhouseCoopers, Sears, Bell Canada, ACNielsen, Nestle, Procter & Gamble, Rogers and OLG

Expert in developing scalable, high-performance Web applications using Microsoft.NET technology

Solid understanding of Relational Database concepts and Data Modelling

Strong knowledge of Oracle and MS SQL Server databases

Hands-on experience working with Content Management applications

Outstanding analytical and problem solving skills

Ability to adapt well to changing priorities and deadlines

Proven track record of high performance

Professional Certification/Education

M.Sc. in Applied Mathematics & Computer Science

TECHNICAL EXPERTISE:

Languages: C#, VB.NET, ASP.NET, SQL, HTML, Java, JavaScript, jQuery, C++, VB, MDX, CSS

Databases: SQL Server, Oracle, DB2, Sybase, Informix, MS Access

Platforms: Windows NT/XP, UNIX

Tools/Technologies: .NET, J2EE, RUP, UML, Agile, IIS, ASP.NET, ADO.NET, Flash, MS Visual Studio, Web Services, SOA, MVC, .NET Remoting, WCF, PL/SQL, Transact-SQL, COM, VML, WebSphere, MCMS, SharePoint, XML/XSL, MQSeries, MSMQ, SSRS, Crystal Reports, Analysis Services, SSAS, ETL, SSIS, AngularJS, Golang

PROFFESSIONAL EXPERIENCE:

Publicis, Sep. 2013 – current (Contract)

BMO Financial Literacy web application:

designed and developed MVC application for BMO users interaction with different financial topics

designed and developed new database for managing user actions

designed and developed the Windows service for collecting website usage statistics

built user activities dashboard

built content management admin tool

OLG website’s web services:

developed job-scheduler for feeding SDI sport events data

developed web service handling thousand simultaneous calls per second

Rogers “Spin to Win” web application

LG data segmentation:

developed job-scheduler for monthly feeding LG email responses

developed database scripts for LG products and promotions segmentation

Environment : Agile, Visual Studio 2012, SQL Server 2012, .NET 4.0, C#, HTML, CSS, JavaScript, jQuery, MVC 4.0, WCF 4.0, Entity Framework 4.0, AngularJS

CapitalC, Nov. 2011 – Sep. 2013 (Contract)

Designed and developed new database and web services for Nissan.ca and Infiniti.ca

Integrated used vehicles information from multiple sources

Designed and developed SQL Server reporting services for Nissan Canada sales

Environment: Visual Studio 2008, SQL Server 2008 R2, .NET 3.5, jQuery, SSIS, SSRS

Bell Canada, Jun. 2011 – Nov. 2011 (Contract through ThoughtCorp)

Design/development of new functions for the web-based Bell Canada Programmer Payment System

Environment: Agile, Visual Studio 2008, Oracle 10g, HTML, CSS, JavaScript, jQuery

MacLaren McCann Canada Inc., Jun. 2010 – Jun. 2011 (Contract)

Designed and developed new pages for Nestle web sites

Added new features for Nestle US, Nestle Canada, Nestle-Baby.ca

Implemented a microsite for Bayer Canada (database and web application)

Environment: Agile, Visual Studio 2008, C#, ASP.NET, SQL Server 2005, MCMS 2002, HTML, CSS, JavaScript, jQuery, Flash

BBDO/Proximity Canada, Nov. 2008- Jun. 2010 (Contract)

Designed and developed web applications (back-end and front-end) as well as web services for Gillette (Procter & Gamble), implemented solutions for several international campaigns on gillette.com

Implemented a secure FTP process for sharing user data between Procter & Gamble applications

using SSIS ETL

Implemented SQL BI reports for Gillette’s website usage

Designed and developed the Gillette users experience SSRS reports using SSAS OLAP cubes

Environment: Visual Studio 2005, ASP.NET 3.5, SQL SERVER 2005, SSIS ETL, SSRS, SSAS, C#, HTML, CSS, JavaScript, jQuery

CIBC, Nov. 2007 - Nov. 2008 (Contract)

Designed and developed a new version of the CIBC Call Center application (Event Data Broker)

Implemented a secure SAML communication between Call Center and Enterprise web services

Developed a Confirmation Management System for over-the-counter derivatives transactions

Environment: Visual Studio 2005, C#, .NET Remoting, ASP.NET, XML/XSL, SAML

BMO Bank of Montreal, Aug. 2007- Nov. 2007 (Contract)

Analyzed BMO intranet search engine and provided improvement recommendations that were successfully implemented

Developed fetch engine for integrating NTLM security

Environment: C#, WebSphere, SharePoint, Autonomy

ACNielsen Canada, May 2006 - Feb. 2007 (Contract)

Designed and developed a web based Report Engine as a part of the ACNielsen OLAP Analysis system Developed a server-side interface to generate output in various formats

Developed ACNielsen desktop tools based on the OLAP technology

Environment: C#, C++, ASP.NET, Web Forms, ADO.NET, SQL Server 2000, ORACLE, OLAP, .NET components (Aspose, SoftArtisan), RUP, UML, MDX, Analysis Services, SSAS

Sun Life Financial, Jan. 2006 - May. 2006 (Contract)

Designed and developed the Quality Assessment workflow web-application with multi-role hierarchical employee structure, created data model, provided database design specifications

Developed and implemented SQL stored procedures, application components, web services for SLF applications

Environment: C#, VB.NET, ASP.NET, ADO.NET, SQL Server 2000, XML/XSL, TRANS-SQL, JavaScript

Akanda Innovation Inc, Oct. 2002 - Dec. 2005 (Contract)

Designed and implemented a call center system for Canadian and US local governments

Designed and developed a workflow-enabled web application for the US and Canadian municipalities to perform real-estate property assessment and taxation

Designed and developed a web application for Tyler Inc. (USA) to keep track of the company clients, vendors, software applications

Environment: RUP, UML, RequisitePro, ORACLE 9i, SQL Server 2000, MS Visual Studio 2003, .NET, ASP.NET, ADO.NET, VB 6, VC++ 6, ASP, SharePoint, PLSQL Developer, C#, XML/XSL, VML, JavaScript, MSCM 2002, GIS, Crystal Reports for .NET

PricewaterhouseCoopers, Nov. 2000 - Sep. 2002

Systems Architect, eBusiness Advisory Services

Responsible for functional and technical design of the ECI Brokers Finder web site

Provided functional and technical design for Toyota Credit web-based credit approval application

Designed a web-based application to tracking the forest renewal process controlled by the British Columbia Ministry of Forestry Industry

Carried out a technical evaluation of various web hosts for the PwC accounting outsourcing application

Environment: RUP, UML, RequisitePro, Rational Rose, DB2, SQL Server 2000, MS Visual Studio, ASP, VB 6, VC++ 6, SharePoint, XML/XSL, J2EE, WebSphere 4, VisualAge for Java 4, Java, EJB, MQSeries, Crystal Reports 8, JavaScript

NAME Inc., Apr. 2000 - Nov. 2000 (Contract)

Provided technical architecture and functional design for a joint NAME/IBM project to integrate pharmaceutical information across the industry

Developed modules for a web-based stock trading system (Stock Wash Application)

Environment: StoryServer, Tcl, XML/XSL, J2EE, WebSphere 4, VisualAge for Java 4, Java

Ontario College of Physicians and Surgeons (CPSO), Jan. 1999 - Apr. 2000 (Contract)

Designed and developed data models and new components for CPSO enterprise systems.

Designed and developed modules for CPSO Web Site

Environment: RUP, UML, SQL Server 7, MS Visual Studio, ASP, VB 6, COM, ASP

Sears Canada, Apr. 1998 – Jan. 1999 (Contract)

Performed system design for a multithreaded NT Agent – a communication link between legacy CICS system (MVS) and the new retail management application (Vantive/PeopleSoft)

Created an interface to integrate a third-party (Portrait Studio) application with Sears POS system

Bell Mobility, Ontario, Nov. 1996 – Apr. 1998

Technical Architect

Developed and implemented system architecture with an emphasis on distributed object and Internet technology. Special projects included:

Creating a web site for mobile telephone dealers to administer customers’ accounts.

Bell Mobility security administrative tools



Contact this candidate