Post Job Free

Resume

Sign in

Support Analyst Developer

Location:
Toronto, ON, Canada
Posted:
January 31, 2023

Contact this candidate

Resume:

Alexander Shteyner

** *********** **., ***. ****

Toronto, Ontario, M2R 3B7

Phones: 416-***-****, 416-***-****

E-mail: adu11w@r.postjobfree.com

OBJECTIVE

Seeking a position as a Programmer Analyst or a Support Analyst

HIGHLIGHTS

- Extensive experience in Windows and UNIX (Linux) based programming

- Professional knowledge of wide range of computer software, system and application programming, testing and support

- Extensive experience in full software development life cycle (SDLC) for government, financial, accounting, manufacturing, HR, sales, etc. applications and Web sites

- Expertise in user support, professional user consulting, preparation of documentation

- Analytical and problem-solving skills

- Highly organized, responsible and accurate, quick learner with the ability to self-educate, able to work independently and as a part of a team

- Enhanced Reliability Security Clearance (Level II – Secret)

COMPUTER SKILLS

Languages

C#, VB.NET, Visual Basic, VBA, VBScript, Java, C / C++, JavaScript, XML, Shell, COBOL

Databases

MS SQL Server, Oracle, Netezza, MS Access, Pervasive SQL

Tools/Utilities/ Technologies

ASP.NET, ASP, ODBC, ADO, IIS, Visual Studio, TFS, SourceSafe, Git, IBM Rational ClearCase, ClearQuest; CSS, SSRS, SSIS, DTS, Crystal Reports, Active Reports, Visio, NUnit, COM/COM+, MSMQ, Lotus Notes, Azure DevOps, Web Services; Waterfall, Agile, eXtreme Programming, MS Office, MS Project, ColdFusion

Operating Systems

Windows, Unix (XENIX, Linux), MS-DOS

EMPLOYMENT HISTORY

May 2022 – now

SENIOR PROGRAMMER ANALYST

Manitoba Public Insurance, Winnipeg, Manitoba (remote)

- Supported the development and customization required for DVA platform, created and maintained the related program codes

- Worked with key business stakeholders and subject matter experts (SME) within all business functions, gathered, documented, and analyzed business needs and requirements.

- Provided support for assigned systems and applications

- Ensured 100% compliance to the requirements, discipline and controls

- Developed test data and analyzed results

- Analyzed the current systems through review of documentation and consulted with various internal and external stakeholders

Tools: .Net, C#, Visual COBOL, Power Shell, SQL Server, Jira; Azure DevOps; COBOL

October 2021 – March 2022

(also worked in 2018-2019, 2015-2016)

SENIOR APPLICATION SUPPORT ANALYST / PROGRAMMER ANALYST

Bank of Nova Scotia ( Scotiabank ), Toronto, Ontario

Anti-Money Laundering AML

- Upgraded .Net Core DFS-504 process certification application

- Worked with key business stakeholders and subject matter experts (SME) within all business functions, gathered, documented, and analyzed business needs and requirements.

- Created a new version of the scheduled data transformation services (Python)

- Ensured 100% compliance to the requirements, discipline and controls

- Upgraded the database structure (queries, tables, indexes, procedures, etc.)

- Provided ongoing ASP.Net, SQL Server, Python support,

Tools: .Net, .Net Core, C#, Python, Power Shell, SQL Server, IBM Hive Hadoop ; Confluence, BitBucket, Jira

February 2021 - May 2021

SENIOR PROGRAMMER ANALYST

Elections BC / Fujitsu Consulting, British Columbia

- Designed and Developed ACS: Web tools for managing access to Election system for the various types of the employees and public users

- Updated the database structure for the Election management database: created and updated tables, views, queries, stored procedures, etc.

Tools/ technologies: Oracle 11g, PL/SQL; ASP.Net, VB.NET, C#, MVC, Entity Framework, Visual Studio 2019; TFS, Git; JIRA; JSON; Agile

October 2020 - December 2020

SENIOR PROGRAMMER ANALYST

Ontario Medical Association, Toronto, Ontario

- Created the tools for data transformation and loading OMA Member Database

- Designed and developed tables and scripts for the next generation of Dividend and Refund data

- Updated the databases’ structure: created tables, queries, stored procedures, triggers, etc.

Tools/ technologies: Oracle, PL/SQL, Oracle Forms

November 2019 -

April 2020

SENIOR PROGRAMMER / APPLICATION SUPPORT ANALYST

KPMG, Toronto, Ontario (one of the largest accounting / auditing companies)

Ignition Tax Services

- Created the models and developed software to process Horizons ETFs exchange, generated the documents about the election on disposition of shares (T2057, T2058, TP518, TP529) to CRA and Revenue Québec

- Developed ETL style software to load financial data from Web, transformed it and saved for the report generation.

- Communicated with the miscellaneous stakeholders to ensure the smooth development process and timely fixing of the various issues

- Updated the databases’ structure: created queries, stored procedures, etc.

Tools/ technologies: SQL Server, Excel, VBA, Macros

July 2018 – July 2019

(also worked in 2015-2016, 2021-2022)

APPLICATION SUPPORT ANALYST / PROGRAMMER ANALYST

Bank of Nova Scotia ( Scotiabank ), Toronto, Ontario

International Banking, Operations

- Created new & updated / enhanced existing applications (Genesys, Property Tracker / Agency Tracker) to support BNS activities in the Caribbean and Latin America

- Worked with key business stakeholders and subject matter experts (SME) within all business functions, gathered, documented, and analyzed business needs and requirements.

- Served as a liaison between the business community and IT

- Ensured 100% compliance to the requirements, discipline and controls

- Upgraded the database structure (queries, tables, indexes, procedures, etc.)

- Provided ongoing ASP.Net and SQL Server support, wrote & optimized queries & procedures

- Performed different support activities: user training, updates, error fixing, requirements gathering, creation of the programmers’ & end users’ documentation

Tools/ technologies: .Net, ASP.NET, C#, .SQL Server, T-SQL; SAS; Access, Excel; VBA, Macros, Python, VB6, VBScript, PowerShell; TFS

December 2017 – April 2018

SENIOR PROGRAMMER ANALYST

Ministry of the Environment Canada, Toronto, Ontario

- As a Business Analyst created / updated various functional specifications, data mapping and business requirements documents for SARA project, made the recommendations about the database structure and user interface, participated in the data gathering and technical design meetings

- Analyzed existing ColdFusion / SQL server application to extract the business logic, algorithms & data processing specifics

- Created JSON RESTful web services to obtain & update SARA-related data (.Net, ASP.NET, Web API, MVC, LINQ, Entity Framework, SQL Server, Unit testing, Git)

- Developed new & optimized existing SQL Server tables, views and queries

May 2017 –

October 2017

(also worked in 2008)

SENIOR ETL DEVELOPER ANALYST

Rogers Communications, Brampton, Ontario

- Designed & developed various ETL – style scripts for the new version of Rogers Human Resource as a part of the Transition project from PeopleSoft to Oracle HCM system. The scripts join the different data sources, validate data, store the results into Active Directory and generate various reports (Excel, VBA, Macros, VBScript, SQL, VB6). As a BA analyzed system specifications and gathered requirements & data from the various stakeholders to identify information, procedures and decision flows; conducted requirements analysis; participated in technical design sessions to determine information needs, business rules, interfaces and decision flows

January 2017 –

April 2017

PROGRAMMER ANALYST

TTC (Toronto Transit Commission), Toronto, Ontario

- Designed & developed “Catalogues” – a content management customizable Web system, which allows to store, manipulate and provide permissions-based access to various kind of TTC-related data – software design, database structure, programming, QA, support

Tools: ASP.NET, C#, CSS, JavaScript, SQL Server, TFS, SSRS, SSIS

December 2016 – January 2017

(also worked several times between 2005 & 2015)

PROGRAMMER ANALYST

Diamond Yarn, Toronto, Ontario

Created new & updated existing reports for the company’s Payment software – MS Access, Excel, VBA, Macros

- Provided application support: training, documents’ preparation, bug fixes, upgrade/refactoring

December 2015 – July 2016

(also worked in 2018-2019, 2021-2022)

SUPPORT ANALYST / ETL DEVELOPER

Bank of Nova Scotia ( Scotiabank ), Toronto, Ontario

Enterprise Risk Management & Compliance Solutions (ERMCS)

- Organized Automotive Lending & Fund Transfer Pricing ETL data transfers between mainframe, SAS and Windows based SQL Server & Access databases, generated data files for the further analysis

- Designed & developed FileProcessor- file level manipulation ETL-support tool to conduct mass data moved between various servers

- Created a tool for the data conversion & transfer between the different versions of the Budgeting & Planning databases

- Created set of programs / scripts for the space management and large files loading & data transformations on the Production & UAT servers

- Provided ongoing SQL Server support, wrote & optimized queries & procedures

- Performed different support activities: user training, updates, error fixing, requirements gathering, creation of the programmers’ & end users’ documentation

Tools/ technologies: .SQL Server, T-SQL, .Net 4.51, C#, VB.NET, Citrix, MS Windows Server, VBA, Macros, Python, VBScript, PowerShell; Access, Excel; TFS; Ambit Software

April 2015 - November 2015

(also worked several times between 2005 & 2017)

PROGRAMMER ANALYST

Diamond Yarn, Toronto, Ontario

- Created various reports for the company’s top management (Inventory, Sales, Payments etc.) and ETL-style data transfer, uploading and validation systems between numerous applications - MS Access, Excel, VBA, Macros, OSAS, VB6

- Provided application support: training, documents’ preparation, bug fixes, upgrade/refactoring

February 2015 - March 2015

(Also worked in 2014)

SENIOR PROGRAMMER ANALYST

Cancer Care Ontario, Toronto

- Took part in the development of the mobile (Android) version of Interactive Symptom Assessment and Collection ( ISAAC ) tool, which allows patients to insert and monitor their symptoms through online software. Developed front-end & middle tier. (.Net 4.5, C#, VB.NET, ASP.Net, MVC, Web Services, SQL Server, T-SQL, HTML, JavaScript, TFS)

May 2014 - February 2015

PROGRAMMER ANALYST

BMO (Bank of Montreal) Financial Group, Capital Markets

- Designed, built, and provided ongoing maintenance & support of DAC - a software tool primarily used for a support of Market Risk and Credit Risk data analysis (mostly VaR). Now it is universal framework which can be used for different types of data analysis; it allows keep/transfer/reuse the processing scripts for different environments; presents the results in the professional graphic mode; supports: Netezza, Oracle, Access, XML, flat files, Excel, JIRA; MS Project

- Took part in the development of applications’ suite for Grid-style distributed calculations of big matrices (.Net 4.0, C#, VBScript, Outlook, SSRS)

- Developed multi-level reporting suite

- Performed support activities: user training and seminars, updates, error fixing, requirements gathering, creation of programmers & end users’ documentation

March - May 2014

SENIOR PROGRAMMER ANALYST

Cancer Care Ontario, Toronto

- Designed & developed Scorecard - software application, which allows to collect miscellaneous primary (department level) data about various CCO activities and generate the summary reports & charts for the top management (Excel, VBA, Macros, Access)

- Performed unit/regression & user acceptance testing, developed tested plans

Performed support activities: user training and seminars; conducted stakeholders’ meetings

November 2012 - January 2014

(also worked for GnD in 2008-2010 and 2011)

SENIOR PROGRAMMER ANALYST / III LEVEL SUPPORT ENGINEER

Giesecke & Devrient Software Solutions America, Vaughan, Ontario

GnD is the leading international technology provider in banknote production and processing, smart card solutions, electronic payments, and security documents and identification systems

- Created new & modified existing analytical & reporting tools for Compass software (cash management system, designed to automate every process at a cash center) for the major US, Canadian, UK, Australian, South African & Latin American banks and bank service companies (BMO, Bank of America, CIBC, G4S, Brinks, Intria)

- Upgraded, enhanced, re-factored, provided performance tuning for standalone & Web-based Orders, Deposits, ATM subsystems for Bank of America, G4S, Scotia Bank

- Designed & developed ETL-style data transfer, uploading and validation systems between numerous local databases and central data warehouses

- Supported the deployment and implementation of the banknote processing technologies; performed data & system analysis; worked closely with project managers, clients, QA to ensure software quality & usability, data integrity

- Provided database design & optimization (tables, queries, procedures, etc.)

- Performed various types of testing: automated unit testing, manual black- and white-box testing, regression testing, user acceptance testing, installation testing, stress testing. Developed testing plans and executed them

sTools: VB, C#, VB.NET, VBA, macros, SQL Server, Oracle, T-SQL, PL/SQL; SSRS, DTS & SSIS, XML, HTML, JavaScript, ASP.Net, ASP, VBScript, NUnit, Visio; MVC, Web Services; ClearCase, ClearQuest, TFS, SourceSafe; Excel, Access, MS Project

August 2012 - October 2012

SENIOR PROGRAMMER ANALYST

Franklin Templeton Investments, Toronto, Ontario

- Upgraded the existing applications (Scorecard Suite, Disability Log, Capital Markets Info, AML): moved to the global network, improved speed & reliability, fixed errors

- Re-factored the sub-system for the data transfer between offices

- Made databases’ (re)design & optimization (performance tuning)

- Worked closely with project managers & QA to ensure software quality & usability

Tools: Excel, VBA, macros, Access, SQL Server, T-SQL, ASP, XML, HTML

March 2012 - July 2012

WEB DEVELOPER / PROGRAMMER

Discover / Iron Logic (Rogers’ sub-contractor), Brampton, Ontario

Developed ENV Verification, Ariba and HUB web-based systems (sales, promotions for the Rogers’ partners & employees) - ASP.NET, Visual Studio 2010, C#, VB.Net, NUnit, Classic ASP, VBScript, Entity Framework, Single SignOn, SQL Server, PowerShell, SharePoint, SSRS, SSIS, Visio; MVC, Web Services; HTML, JavaScript

January 2012 - March 2012 (also worked several times between 2005 & 2016)

SENIOR ANALYST PROGRAMMER

Diamond Yarn, Toronto, Ontario

- Created ETL -style transformation services for data transfer between the original accounting and warehouse system OSAS and diamondyarn.com web site

- Developed various A/P & A/R related reports

Tools: C#, Excel, Access, VBA, macros, XML, XSLT; Visio, MS Project

June 2011 - January 2012

DEVELOPER ANALYST

Giesecke & Devrient Software Solutions America, Vaughan, Ontario

- Modified existing & developed new analytical & reporting tools for Compass software suite (Cash centers’ automation management system) for the major USA, Canadian & UK banks and banking service companies (BMO, Bank of Nova Scotia, CIBC, RBC; G4S, Intria).

- Updated Web-based interface to the Order & Shipment system for Bank of Canada

- Provided database design & optimization (tables, queries, procedures, etc)

- Developed presentation & data transformation/moving (ETL) software

- Fixed & re-factored End-Of-Day (EOD) / Shutdown reporting system

Tools: VB6, VB.Net, C#, SQL Server, T-SQL, SSIS, SSRS, Visio, IBM Rational ClearCase, ClearQuest, Lotus Notes, NUnit, XML; VBA; Python, MS Project; SharePoint

March 2011 -

April 2011

(also worked several times between 2003 & 2014)

SENIOR PROGRAMMER ANALYST

Taxtronix Systems, Toronto, Ontario

- Designed & developed the new version of PayHelp & GIFI software: added Accounts Payable / General Payee subsystem and employees and subcontractors’ payroll, taxes, WSIB, EI and CPP calculations for non-Ontario businesses; optimized database (Visual Studio, VB6, VBA, SourceSafe, ActiveReports, VBUnit, Access, SQL Server)

October 2010 - February 2011

SENIOR PROGRAMMER ANALYST / WEB DEVELOPER

Thomas Cook / MyTravel, Toronto, Ontario

- Developed the web services for Travel Deals, Flights & Cruises (data loading to the travel agencies’ web sites)

- Created a set of XSLT files for travel data’s transformations: XML to XML, XML to HTML (ASP.Net, .NET 3.5, C#, VB.Net, Oracle, HTML, CSS, JavaScript, AJAX, jQuery, MS Project, Visio; Web Services, MVC)

- Prepared application programmer’s documentation

1999 - 2010

PROGRAMMER ANALYST, SENIOR PROGRAMMER ANALYST, BUSINESS ANALYST / PROGRAMMER, WEB DEVELOPER, DATABASE DEVELOPER

Several positions in Canada and the USA

- Several contracts 2005-2015. Designed & developed tools for data transfer between different subsystems of OSAS accounting software; created inventory, A/P & A/R related reports (VBA, Excel, Access) Diamond Yarn, Toronto

Created new & modified existing analytical & reporting tools for Compass banking software (Cash management & AML) for the major US, Canadian & UK banks & banking service companies

- Developed e-commerce B2C web site (front & back-end), Re-modeled and optimized the database, added reporting & analysis tools, made numerous changes in front-end (VB.Net, ASP.Net, SQL Server, HTML, JavaScript; NUnit); Analyzed system specifications & competitors’ sites to identify information, procedures and decision flows; conducted requirements analysis; participated in technical design sessions to determine information needs, UI, business rules, interfaces and decision flows (LoomToRoom)

- Several contracts 2008-2014: Created new & modified existing analytical & reporting tools for Compass banking software (Cash management & AML) for the major US, Canadian & UK banks & banking service companies. Tools: VB6, VB.NET, C#, WinForms, NUnit, SQL Server, SSIS, SSRS, ClearCase, ClearQuest, Visio, MS Project, XML, JavaScript, VBScript, CrystalReports; SharePoint (Giesecke & Devrient)

- Re-developed / re-factored ARAMIS commercial fleet insurance software. Updated set of business rules, optimized the program and database to increase speed and reliability, fixed numerous problems ; Provided tests' scripts preparation and UAT support. Tools: VB6, VBA, ComponentOne & Sheridan controls, SQL Server, TOAD, DTS, MDX, ClearCase, XML, XSLT, Visio (The Economical Insurance Group, Waterloo, Ontario)

Developed semi-automated system for new account data uploading to the Practivity Intranet system, which parses the input data stored in the Excel, validates data against the database, generates screen reports, uploads actual data to the database. ASP, VBScript / VBA, Ajax, Excel, Access, Oracle, AspUpload (Rogers Communications)

- Developed a new version of Uniform Commercial Code filing system. This N-tier COM+ based system utilized Oracle and SQL Server as the databases, and provides front-ends and business logic on all stages of loan application process. VB6, SQL Server, Oracle, ActiveReports / Crystal Reports, XML, XSLT, ASP, CDO, Visio, MSMQ, DTS, SSRS; in house built CRM system. Secretary of State Office, Columbus, OH, USA

- Designed and developed PayHelp software (payroll; taxes, EI, CPP, WSIB; T4 and T5018). Taxtronix. VB6, ActiveReports, SourceSafe, Access, Visio, SQL Server. Python

- Designed & developed ETL-style Returns Processor for major American banks to load huge volumes of bank data (XML, CSV, Zip, native file formats) from FTP and remote net servers, convert to standard XML, validate, extract relevant data, upload results to Processing databases, and generate human- & computer-readable reports and logs (RDM)

CERTIFICATIONS

Brainbench

Skill-Guru

AJAX, ADO.NET, C#, VB 6, VBS, JavaScript, ASP.NET

VBA 94% (2015)

EDUCATION AND TRAINING

- Various software development related courses

- SAS programming courses

- Software development compliance with defect and change request procedures

- VBS course

- Software development projects’ management using IBM ClearQuest and ClearCase

- . NET programming course (ASP.NET, C#, XML / XSLT; eXtreme programming)

- e-commerce course (advanced Web development)

- Business Analysis

- UNIX

- Java

- Oracle, SQL Server, Unify, DB2

National University of Economics, Kharkiv, Ukraine

B. Sc. in Engineering. Graduated with honors

Specialized in Computer Processing of Economic Data.

Major: Computer Science, minor: Economics

REFERENCES

Available Upon Request



Contact this candidate