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