SUMMARY:

• Microsoft Certified Professional (MCP). Ambitious and integrity driven professional offering over 10 years of software development and support experience in Internet and client - server application development areas. Strong analytical thinker with strength in business problem solving. Excellent programming abilities.

TECHNICAL SKILLS:

Programming languages: C#, VB.NET, jQuery, JavaScript, DHTML, XML, XSLT, Perl 5.8, VBScript, Transact-SQL, PL/SQL, Visual Basic 6.0/5.0/4.0, PL/1, FORTRAN 77/4

Databases: MS SQL Server 2012/2008/2005/2000/7, Oracle 10g, MS Access 2003/2000/97

Libraries, technologies, frameworks, tools: Visual Studio.NET 2012/2010/2008/2005/2003/2002/6.0, MVC, ASP.NET 4.0/3.5/2.0/1.1/1.0, WCF, .NET 4.5/4.0/3.5/3.0/2.0/1.1/1.0, Win Forms, LINQ, SOA, Web Services, SOAP, Enterprise Services, IIS 6.0, ASP 3.0, TCP/IP, Crystal Reports, DevExpress, MS Enterprise Library, MS User Interface Process (UIP), nHibernate, nUnit, Infragistics NetAdvantage, ADO.NET, ADO, ODBC, COM, COM+, MS Office 2010/2007/ 2003/2000/97, Visio 2003, Visual Interdev, Team Foundation Server(TFS), Visual Source Safe (VSS) 2005/6.0, Star Team, Clear Case, Subversion (SVN), Informatica 8.1, Open PGP Encryption, MS SQL Server Integration and Reporting Services (SSIS, SSRS), VSTO 3.0, Design Patterns, Ajax technology, Telerik framework.

Operating Systems: Windows 2012/2008/7/2003/ XP/2000/NT/98/95, MS-DOS.

PROFESSIONAL EXPERIENCE:

Confidential

SENIOR SOFTWARE DEVELOPER

Responsibilities:

• As member of Razor-Risk risk management team, participated in Razor NGX project. The project aimed at development of corporate risk management application framework. The framework included custom data loader ETL tool, Back Testing and Stress Testing processors, VAR (Value-at-Risk) calculation engine and user interface (UI) application. Worked on the data loader tool for the framework and was involved in all stages of software development life cycle. Worked with business analysts on application requirements, created application design, coded and tested the application.
• Used Visual Studio 2012, .NET 4.5 and SVN as development tools for the project.
• Used C# and LINQ to develop and code client side data access and business components.
• Created custom json data parser and xml based Data Dictionary configuration module for the application.
• Used SQL Server 2012 as a back end for the application. Used Transact-SQL to create server side objects such as stored procedures, views and tables. Participated in database performance tuning.
• Created test framework for the project.
• Participated in development of components for the Back Testing and Stress Testing processors, Scenario Generator and VAR engine. Used C# and Entity framework to develop new and modify existing components.
• Used SVN as a source code control tool. Used JIRA for project issues and bug tracking.

Confidential

SENIOR SOFTWARE CONSULTANT

Responsibilities:

• As member of a team, participated in OTR Multiple Data Loader project. The project aimed at creating custom ETL application capable of processing diverse incoming user data. The application was composed of data loading components and user interface (UI). The work on the project included design, development and coding on middle tier, database and front end layers. Participated in all stages of software development life cycle (SDLC) such as design, development, coding, testing.
• Used Visual Studio 2012 and Team Foundation Server (TFS) 2012 as main development tools for the project.
• Used C#, LINQ and Entity framework to create data access and business components. Created xml, comma delimited and fixed length data parsers for the project.
• Used SQL Server 2008 as a back end. Created several database objects such as tables, views, stored procedures and user-defined functions. Participated in database performance tuning.
• Designed and developed user interface using C# and MVC framework.
• Used Team Foundation Server as a source code control tool.

Confidential

SENIOR APPLICATION DEVELOPER

Responsibilities:

• As a team member in the Capital Markets Enterprise Risk & Portfolio Management (CM&ERPM) department, took part of COPS Investment Plan project aimed at creating programming tools for data reconciliation process. The goal of the project was to develop a set of custom ETL software components which would be compatible with the AVTL Service, existing enterprise framework and capable of extracting and manipulating diverse fixed income and GIC business data.
• The work on the project included the design and development of new and modification of existing components.
• Participated in all stages of software development life cycle (SDLC) such as gathering requirements, design, development, coding, testing.
• Used Visual Studio 2010 and Team Foundation Server (TFS) as the primary development tools for the project. Used C#, LINQ and Entity framework to create data access components and implement application business logic. Created XML parser component for the application.
• Used TFS capabilities for testing and debugging the application code.
• Used SQL Server 2008 as a back end for the project. Created several database tables to hold financial data. Designed and developed several views and stored procedures to implement data access logic for the project.
• Participated in SQL Server performance tuning and query optimization.
• Used Team Foundation Server as a source code control tool.

Confidential

SENIOR DEVELOPER

Responsibilities:

• As a member of Enterprise Risk Management Solutions (ERMS) department, participated in Problem Loans Reporting System (PLRS) project. The goal of the project was to ensure Scotiabank’s compliance with regulatory reporting requirements by enabling the department to generate quarterly reports in accordance with OSFI’s time lines and standards.
• The work on the project included design and development of new functionalities for the PLRS web application as well as redesign and redevelopment of existing application modules.
• Participated in all stages of software development life cycle (SDLC) such as gathering requirements, design, development, coding, unit testing and implementation.
• Used Visual Studio 2010, ASP.NET and MVC frameworks, javaScript and HTML to create several new web pages for the application user interface. Used jQuery and Ajax technologies to provide communications to third party web services from within PLRS application web pages. Used C# to create code-behind for the application web pages.
• Used SQL Server 2008 as a back end for the project. Created several new database tables to hold financial data. Used T-SQL and created several database objects such as stored procedures, user defined functions and views in order to implement data extract and manipulation. Designed and developed several SQL Server Integration Services (SSIS) packages in order to facilitate loading external data to the database.
• Used C#, LINQ and Entity framework in order to create application business and data access objects. Created a few WCF web services for the application in order to exposure commonly used functions and improve user interface.
• Used Crystal Reports for Visual Studio .NET to improve reporting capabilities of the application. Created a few new reports and modified existing application reports.
• Used Visual Source Safe (VSS) as a source code control tool.

Confidential

SENIOR SOFTWARE DEVELOPER

Responsibilities:

• Participated in redesign and redevelopment of the department’s CRM Tool, Infos/SMARTs web based application. The tool was designed as a three-tier web based application, aimed to facilitate managing bank’s partners’ information.
• The project included redesign and redevelopment of several existing subsystems and adding new functionalities to the tool. Participated in all stages of the software development life cycle such as design, development, coding, unit testing and implementation. Worked on design and development of presentation layer, business logic and data access layer. Used Visual Studio 2010, ASP.NET and MVC frameworks, C#, jQuery, Ajax technology, javaScript, HTML to develop new and modify existing user interface. Used C#, LINQ, ADO.NET and Entity Framework to create data access and business components. Used SQL Server 2008 as a backend to hold customer information. Participated in database design and development. Using T-SQL, developed several database objects such as tables, views, user defined functions(UDF) and stored procedures. Participated in database tuning and optimization. Used Visual Source Safe (VSS) as a source code control tool.
• Participated in “Cash Impact Projection” project aimed to automate a process of trading data exchange between MVEST portfolio administration system and Customer Purchases and Redemptions (CPR) tool. The application was designed and developed as a custom ETL tool with business logic implemented as a set of SQL Server stored procedures, views and functions.

Confidential

SENIOR WEB DEVELOPER

Responsibilities:

• Took part in the ‘Investor Central’ project, intended to facilitate investment management process on behalf of the company’s clients. The project included creation of a web based application aimed at storing and managing investment data and providing a web-based interface for the data.
• Participated in all stages of the software development life cycle, including design, development, coding and testing. Participated in the design and development and coding of the web application. Used Visual Studio 2010, ASP.NET 4.0 framework, C#, jQuery, JavaScript, HTML, Telerik controls, Ajax technology to create application front end. Used C# to create application middle tier and data access components. Used SQL Server 2008 Transact SQL to create backend objects such as tables, views, stored procedures, triggers. Used WCF framework and C# to create several web services for the project. The web services were used to expose common functions to different part of the application. Used Team Foundation Server(TFS) to manage debug process and maintain different versions of source code.

Confidential

SENIOR SOFTWARE DEVELOPER

Responsibilities:

• Participated in the Pension and Benefits management project, aimed at providing HR solutions to the United Church of Canada (UCC). Worked on the design and development of a new web based application in order to assist UCC in administering pensions and benefits for their employees. Used Visual Studio 2008 and ASP.NET 3.5 technology to create the application front end; used SQL Server 2008 database as a back end.
• Participated in all stages of the software development life cycle; including design, development, testing and implementation. Co-operated with business analysts on business requirements. Participated in the design, development and testing of a web based user interface; created several web pages and web custom controls.
• Created middle tier components and database objects. Used ASP.NET 3.5, C#, JavaScript and HTML to create UI web pages; C# and ADO.NET framework to create middle tier components; Transact-SQL to create SQL Server database stored procedures, triggers, views and tables. Used Visual Source Safe 2005 to maintain different versions of source code.

Confidential

SENIOR SOFTWARE DEVELOPER

Responsibilities:

• Worked on migration of business reports system developed with MS Office (Excel VBA) to server platform. The existing system was used for mortgage principal balances and cash flow calculations. The project included implementation of the business logic using C# and .NET framework; providing new reporting capabilities for the application; creation of back end objects such as tables, triggers and stored procedures on the database server (SQL Server 2008).
• The application was designed as a Service Oriented Application and included a set of business components and web services. Used Windows Communication Foundation (WCF) technology to create the services. Used Object Oriented Design (OOD) methodology, Visual Studio 2008, .NET 3.5, C#, ADO.NET and LINQ frameworks to design and develop the business and data access components. Used SQL Server Reporting Services (SSRS) to provide reporting capabilities for the application. Used SQL Server 2008 as a backend to hold financial data. Used Transact-SQL to create tables, stored procedures and triggers on the database server.
• Used VSTO 3.0 to manipulate Excel data source files. Used XML to create source file definitions and configuration files for the application components. Created XML Schema documents to validate the definition and configuration files. Used Subversion to maintain different versions of source code. Worked on all stages of the development cycle including design, development, coding, testing and implementation. Worked with business analysts on business requirements; designed and developed application framework. Worked with support team and DBA to implement the application.

Confidential

SENIOR SOFTWARE DEVELOPER

Responsibilities:

• Participated in Currency and Coin Handling Environment (CACHE) project. The purpose of the project was to provide the US Federal Reserve with an automated currency processing system, different parts of which were responsible for currency movement, verification and destruction amongst others.
• Worked on user interface and middle tier components for the existing client-server application framework. Used Object Oriented Design (OOD) methodology to create the application middle tier components. Used Visual Studio 2005, C#, .NET 2.0 technology and DevExpress framework to design and develop new Win forms and middle tier components for the application. Designed and developed several Web services to provide data exchange process between the application business layer and Oracle database server. Used XML, SOAP and .NET 2.0 framework to create the Web services.
• Worked with business analysts on business requirements for the project. Used Clear Case to maintain different versions of source code.

Confidential

SENIOR SYSTEMS ANALYST / DEVELOPER

Responsibilities:

• Participated in Third Party Index Funds project - aimed to implement a new trading data exchange process between Bloomberg trading system, the data provider, and Statpro. Participated in all stages of software development process for the project, including design, development, testing and implementation. Worked with business analysts on business requirements, created and implemented application design. Used SQL Server 2005 as a backend to hold financial data and created several SQL Server tables, stored procedures, views and user functions using Transact-SQL. Designed, developed, tested and implemented several Informatica ETL packages aimed to extract and transform equity trading data. Created several Perl scripts to provide FTP, email and file manipulation functionalities for the project. Used Clear Case to maintain different versions of Informatica packages and Perl scripts.
• Participated in Global - Asian Bloomberg databases replication project - aimed to automate existing process of trading data synchronization between Bloomberg Trading System Global and Asian databases. Created and implemented application design and logic. Designed and developed several Informatica packages aimed to extract trading data from Bloomberg Global database, transform it and load into Asian database. Created several Perl scripts to provide file transformation and email functionalities for the project..
• Automated Bloomberg users auditing system at the department by creating a new .NET Win Forms application. Used Visual Studio 2005 and .NET 2.0 technologies to design and develop the application. Used C# to create application user interface; C# and ADO.NET to create middle tier components; Transact-SQL to create SQL Server database objects such as tables, views, stored procedures and user defined functions; Crystal Reports for .NET to create application reporting capabilities. Used Visual Source Safe 2005 to maintain different versions of application source code.
• Worked on improving existing processes at the department, such as Global Supply Demand Management system (GSDM) and 4Sight.
• For 4Sight process used XML to create new process definitions; PL/SQL to create new and alter existing Oracle stored procedures.
• For GSDM used Transact-SQL to create new stored procedures and views on SQL Server. Used Visio 2003 and MS Office 2003 to create application documentation.
• Converted existing application created with Visual Basic 6.0 into .NET counterpart. The application is aimed to receive trading data from Bloomberg using Bloomberg API for .NET and present the data for business users. Redesigned the application and added a new functionality. Used C# to create application components; Crystal Reports to provide reporting capabilities for the application.
• Automated a trading data exchange process between Manulife and Mackenzie Financial. The process includes submission of transaction tickets executed in Bloomberg as a part of fund management services Manulife offers to third party clients. Mackenzie uses these tickets to book transactions in their book of records. The trading data for the process includes equity and fixed income transactions. Worked with business analysts on business requirements, created and implemented application design. Designed and developed Informatica package to extract and transform Bloomberg trading data. Created several stored procedures on SQL Server to hold financial information. Worked with implementation team to create a schedule in Control-M system for the process.
• Designed, developed and tested several software components for existing corporate Data Hub Framework using Microsoft Visual Studio 2005 and .NET 2.0 technologies. The components are aimed to implement base functionality for trading data exchange process between the bank and external clients. Participated in all stages of software development life cycle, including design, coding, testing and debugging. Worked with system architect on technical specifications and participated in design and code review process.
• Used Object Oriented Design (OOD) methodology to create the set of new components and integrate them with the existing enterprise framework. Used C# and ADO.NET framework as primary tools to create the new components. Used Transact-SQL to create new and alter existing SQL Server tables, triggers, stored procedures and user defined functions to implement component business logic. Used .NET Win Forms and C# to create test applications for the new components. Used Visual Source Safe to maintain different versions of the components.
• Participated in designing process of trading data encryption for the corporate Data Hub Framework. Created encryption component aimed to be used within the Framework to protect trading data. Used Microsoft Visual Studio 2005, .NET 2.0, C# and Open PGP technologies to design and develop the component. Designed and developed PGP Key Management application aimed to maintain encryption keys for the component. Used .NET 2.0 Win Forms and C# to create the application.

Confidential

SENIOR SYSTEMS ANALYST / DEVELOPER

Responsibilities:

• Participated in North American Equity (NAE) project - aimed to implement a new trading data exchange and reconciliation process between the company and external clients such as CIBC Mellon and Bloomberg trading system. Worked with business analysts on business requirements; created and implemented application design; created system design documentation.
• Designed, developed, tested and implemented several MS SQL Server DTS packages aimed to extract and transform equity trading data. Used VBScript to create new DTS packages; Transact-SQL to create SQL Server tables and stored procedures to implement business logic.
• Used PGP 9.0 command line utility to apply data encryption to the process and provide secure data exchange.
• Implemented several enhancements and modifications to Credit Notes, existing corporate ASP.NET intranet application, using Microsoft ASP.NET 2.0 technology. Worked with business analysts on developing business requirements for the application and participated in all stages of the software development lifecycle (SDLC), including design, coding, testing, debugging and implementation. Used ASP.NET 2.0, JavaScript, HTML and Infragistics controls framework to enhance and modify browser based user interface; C# and ADO.NET framework to create middle tier components; Transact-SQL to modify existing and create new stored procedures and views on the MS SQL Server database server.

Confidential

SENIOR SOFTWARE CONSULTANT

Responsibilities:

• Redesigned a core enterprise application, Call Resolution Process, using Microsoft .NET 1.1 technology. Designed and developed a new version of the application using Win Forms 1.1, C#, and Microsoft Enterprise Library framework. Participated in all stages of software development process such as design, development, coding, testing and implementation. Worked with system architect and project manager on the project requirements, participated in design and code review processes.
• Split the existing application code into separate modules in order to implement 3-tier client-server application design. Incorporated several changes to the application logic aimed to improve existing call resolution process at the enterprise call centre. Used .NET XML libraries to create a new version of XML parser module for the application. Tested the new version of the application using Red Gate database comparison tool. Changed existing database design to accommodate changes introduced into the application.
• Designed and developed a client-server application, Rejected Calls Process, aimed to process rejected calls at the enterprise call centre. Used Win Forms 1.1, C#, and ADO.NET framework to create user interface, business and data access components. Used FTP third party tool, MOVEit API, to implement data exchange process between the call centre network and a secure ftp site.
• Incorporated several enhancements to existing .NET client-server applications at the enterprise. Used C# and ADO.NET framework to create new and alter existing business and data access components; Transact-SQL to create stored procedures and views on the database server; COM+ to provide scalability to the application components.

Confidential

SENIOR SOFTWARE DEVELOPER

Responsibilities:

• Participated in reengineering of Appraisal, a core enterprise application, using Microsoft .NET 2.0 technology. Designed and developed a new version of the application aimed to be used on Tablet PC. Participated in all stages of software development lifecycle including design, development, coding and testing. Worked with business analysts on system requirements and acted as software designer when developing the new application.
• Created a user interface for the application using Win Forms 2.0, C#, Microsoft User Interface Process (UIP), and Microsoft Enterprise Library frameworks. Used C# and nHibernate object relational mapping tool (ORM) to create middle tier and data access components. Used nUnit framework to test the components. Used log4net utility to provide logging capabilities for the application. Worked on creation and implementation of the domain model for the application. Changed existing database design to accommodate new functionality of the application. Used Star Team to maintain different versions of application source code.
• Participated in design and development of web service for the application aimed to provide a data exchange between central enterprise database and databases located on Tablet PCs. Used XML and SOAP toolkit to create the service.
• Participated in creation of Document Repository for the project using Wiki. Used Visio 2003 and MS Office 2003 to create application documentation.

Confidential

SENIOR PROGRAMMER / ANALYST

Responsibilities:

• Designed and developed Internet Banking application using Microsoft Visual Studio 2003 and .NET 1.1 technologies. Used existing Internet Banking web site created with ASP technology as a prototype to create the new application. Converted web pages created with ASP technology into ASP.NET. Converted COM components and web pages created with VB6.0 and VBScript into VB.NET and C# components. Added new functionality to the application and optimized application logic. Used ASP.NET 1.1, VB.NET, JavaScript, and HTML to create browser based user interface; ADO.NET, C# to create middle tier and database access components; Transact-SQL to create stored procedures, views, and triggers on database server.
• Modified existing and created new SQL Server stored procedures and views to accommodate new functionality of the web application. Created several DTS packages using VBScript to provide data exchange process between the Internet Banking application and other bank systems. Created several custom web controls for the application to improve application user interface. Used C# and ADO.NET to create the controls. Used Crystal Reports for Visual Studio .NET to create reporting capabilities for the application.Used Visual Source Safe and Star Team to maintain different versions of application source code. Used IIS to host the application.
• Created data bridge components to provide communication over TCP/IP protocol between the Internet Banking web application and core banking processing system. Used C#, Asynchronous Calls and Multithreading technologies, Thread and Socket classes to create the components. Adjusted the components to make them callable from within MS SQL Server stored procedures and from within .NET middle tier components.
• Created Message board and Document Repository for the project using Microsoft SharePoint Portal Server. Developed and implemented web based reporting application aimed to provide statistical data for different business units in the bank. Used ASP.NET, VB.NET, JavaScript, and HTML to create user interface, Transact-SQL to create database back end procedures; Crystal Reports to create application reporting capabilities, C# and ADO.NET to create middle tier components.
• Designed, developed and implemented client-server application aimed to collect points for American Airlines (AA) Company Program. Used Win Forms 1.1, VB.NET and Infragistics NetAdvantage controls to create application user interface; ADO.NET, VB.NET to create middle-tier and database access components; Transact-SQL to create stored procedures, triggers, views, and user-defined functions on MS SQL Server. Used Crystal Reports for Visual Studio .NET to create reporting capabilities for the application. Created several SQL Server DTS packages to support data exchange process between the Bank and American Airlines Company.
• Created and supported an application aimed to provide account and transaction information in XML format for different branches of the bank.
• Supported bank applications created with .NET Win Forms, Visual Basic 6 and MS Access by modifying them in accordance with new requirements.
• Supported corporate Internet Banking web site created with IIS, ASP, VBScript, Visual Basic, MSMQ, and COM+ technologies. Used Visual Interdev to alter existing ASP pages.
• Acted as a project lead and technical architect when worked on the Internet Banking project. Coordinated efforts of other team members to analyze, design, and code project solutions. Enforced and evolved software development standards and best practices.

Confidential

INTERMEDIATE DATABASE ANALYST / PROGRAMMER

Responsibilities:

• Developed and implemented ASP.NET 1.0 web application aimed to collect account and customer information for the bank. Used Visual Studio 2002, ASP.NET 1.0, JavaScript, C# and DHTML to create browser-based user interface; C# and ADO.NET to create middle-tier and data access components; Transact-SQL to create SQL Server stored procedures, triggers and views. Worked with business analysts on developing business requirements for the application and participated in all stages of the development process including design, coding, debugging, implementation, and support. Used IIS to host the application.
• Supported financial reporting system by modifying it in accordance with rapidly changing business environment and developed new version of the system using MS Access 2000, Crystal Reports 8.5, Visual Basic 6.0, MS SQL Server 2000, and Hyperion Essbase database reporting tools.
• Developed and implemented several client-server applications aimed to help business analysts to manage customer accounts. Used Visual Basic 6.0 and MS Access 2000 VBA to create user interface; Visual Basic 6.0 and ADO framework to create middle tier and data access components; COM+ to provide scalability to the components; Transact-SQL to create back end storedprocedures, triggers and views on database server.
• Designed, developed, and implemented client-server application aimed to prepare customer information for the Government of Canada. The application passed Government and is currently used for anti money laundering process at the bank. Used Visual Basic 6.0 to create user interface; ADO framework to provide data access on database server; MS SQL Server DTS packages to create output files. Migrated several databases created with MS Access 97 to SQL Server platform.
• Performed DBA duties such as database backup and restore. Managed user accounts and permissions.

Confidential

PROGRAMMER ANALYST

Responsibilities:

• As a team member took part in developing software package for monitoring system.
• Worked with business analysts on developing business requirements for the package and participated in all stages of the development process including design, coding, debugging, testing, and support. Designed and developed several applications for the package including billing application, Admin application, and reporting system.
• Used Visual Basic to create application user interface; ADO framework and Visual Basic to create middle tier components; MTS to provide scalability to the components; Transact SQL to create stored procedures and triggers on database server; MS Access and Crystal Reports tools to create reporting system. Designed and implemented database for the package. Implemented the package and supported users for problem determination and resolution. Maintained the package by establishing improved versions.
• Performed DBA duties such as database backup and restore.

Confidential

PROGRAMMER ANALYST

Responsibilities:

• Designed, coded, tested, and implemented several database applications for the enterprise needs such as automation of management processes at the enterprise, automation of storage facilities registration processes. Used MS Access to create user interface and Data Access Objects (DAO) framework to access data stored in database. Used MS Access reporting tools to create reporting capabilities for the applications. Performed application support at the enterprise.
• Central Scientific and Research Technological Institute