OBJECTIVE:

Seeking a position as a Programmer Analyst

SUMMARY:

• 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

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, BizTalk, COM/COM+, MSMQ, Lotus Notes, SAS, Web Services; Waterfall, Agile, eXtreme Programming, MS Office, MS Project, ColdFusion

Operating Systems: Windows, Unix (XENIX, Linux), MS-DOS

EMPLOYMENT HISTORY:

SENIOR PROGRAMMER ANALYST

Confidential

Responsibilities:

• 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: Oracle 11g, PL/SQL; ASP.Net, VB.NET, C#, MVC, Entity Framework, Visual Studio 2019; TFS, Git; JIRA; JSON; Agile

SENIOR PROGRAMMER ANALYST

Confidential

Responsibilities:

• 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: Oracle, PL/SQL, Oracle Forms

SENIOR PROGRAMMER / APPLICATION SUPPORT ANALYST

Confidential

Responsibilities:

• 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 (management, financial analysts, taxation specialists, security staff) to ensure the smooth development process and timely fixing of the various issues
• Updated the databases’ structure: created queries, stored procedures, etc.

Tools: SQL Server, Excel, VBA, Macros

APPLICATION SUPPORT ANALYST / PROGRAMMER ANALYST

Confidential

Responsibilities:

• 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: .Net, ASP.NET, C#, .SQL Server, T-SQL; SAS; Access, Excel; VBA, Macros, Python, VB6, VBScript, PowerShell; TFS

SENIOR PROGRAMMER ANALYST

Confidential

Responsibilities:

• 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

SENIOR ETL DEVELOPER ANALYST

Confidential

Responsibilities:

• Designed & developed various ETL - style scripts for the new version of Confidential 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

PROGRAMMER ANALYST

Confidential

Responsibilities:

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

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

PROGRAMMER ANALYST

Confidential

Responsibilities:

• 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

SUPPORT ANALYST / ETL DEVELOPER

Confidential

Responsibilities:

• 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: SQL Server, T-SQL, .Net 4.51, C#, VB.NET, Citrix, MS Windows Server, VBA, Macros, Python, VBScript, PowerShell; Access, Excel; TFS; Ambit Software

PROGRAMMER ANALYST

Confidential

Responsibilities:

• 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

SENIOR PROGRAMMER ANALYST

Confidential

Responsibilities:

• Took part in the development of the mobile (Android) version of Interactive Symptom Assessment and Collection 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)

PROGRAMMER ANALYST

Confidential

Responsibilities:

• 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

SENIOR PROGRAMMER ANALYST

Confidential

Responsibilities:

• 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

SENIOR PROGRAMMER ANALYST / III LEVEL SUPPORT ENGINEER

Confidential

Responsibilities:

• 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 ( Confidential, 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
• Produced numerous end-user & development documents

Tools: 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

SENIOR PROGRAMMER ANALYST

Confidential

Responsibilities:

• Upgraded the existing applications (Scorecard Suite, Disability Log, Capital Markets Info): 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