Andrey Verbitskiy

***-**** ***** ********* *****, Mississauga, ON L4Y 3A2

Home phone: 905-***-****

Cell phone: 647-***-****

Email: abotz3@r.postjobfree.com

Objective: Business Analyst

Experienced and certified Business Systems Analyst, ETL Developer, Database Architect (including Data Warehouse and Data Mart), Data Modeler, Data Migration Specialist, Data and Content Manager, Software Tester, Report Writer, Presentation Maker, Technical Writer, with more than ten years experience, seeks a position within a progressive organization that will enable me to use my skills and advance in my fields of expertise.

Professional Profile

-Extensive experience in design and development of integrated information systems

-Data modeling and design of database structures (including Data Warehouse and Data Mart)

-ETL maps creation and development

-Management of information

-Testing programs

-Creation reports

-Training users

-Implementation of electronic presentations

-Writing users manuals and program specifications

-Excellent communication skills, a good team player, as well as an independent performer

Technical Skills

-RDBMS: Oracle since 1996, Informix since 1996, Adabas since 1986, Visual FoxPro since 1990

-Informatica Power Designer Center since 2008

-SQL (for Oracle, Informix, Visual FoxPro) since 1994

-HTML (including HTML editing software) since 1998

-System Analysis and Design since 1989

-ERWin, BPWin since 2000

-UML since 2000

-MS Help Workshop since 1996

-Photoshop since 1995

-Microsoft Office (including Word, Access 2003, 2000, 97, Excel 2003, 2000, 97, PowerPoint 2003, 2000, 97, Visio 2003, 2000, 97) since 1994

Professional Experience:

June 2007 – to present: Gateway Worlds Inc., Website Content Manager and Usability Consultant;

February 2008 – August 2008: The Ministry of Transportation of Ontario, ETL Developer;

Before 2005: non Canadian experience (mostly as Business Systems Analyst, Database Architect (including Data Warehouse and Data Mart), Data Modeler).

Here is my experience in detail:

Gateway Worlds Inc., Toronto, Ontario

Website Content Manager and Usability Consultant, June 2007 – to present

My activity is a core of several Health Care Careers web sites: www.ontarionursing.ca (contains vacancies for nurses and nurse management), www.ontariohealthcarecareers.ca (contains vacancies for Health Care professionals (Speech Language Specialist, Occupation Therapist etc (contains vacancies for pharmacists and pharmacy management):

My duties include checking web-sites of Health Care Providers, which are our clients, in order to find positions, which should be inserted ‘our’ database. In addition, I should find positions in ‘our’ database, which should be removed, because these positions have been closed by Health Care Providers.

When I check job opportunities in web-sites of Health Care Providers, I define, which category (nurse, nurse manager with subcategory, health care specialist with subcategory, pharmacist) should be assigned to ‘new’ position.

All changing in ‘our’ database I implement via special Internet-application.

In addition, I test ‘our’ web-sites when it is necessary and prepare according reports for our developer team.

The following tools are used by me: Excel, Word, Photoshop and HTML.

The Ministry of Transportation of Ontario, Toronto, Ontario

CareerBridge Intern on position of ETL Developer, February 2008 – August 2008

Member of developer team in project ‘Beginning Driver Education’.

- One of key contributors to develop the ETL specification documents with column level transformation logic, validation rules

- Key contributor to develop Informatica mappings, sessions, workflows based on ETL specifications to migrate business information from several sources (MS Excel, MS Access, flat-files) to Oracle Enterprise Transactional Database

- Key contributor to debug the Informatica mappings and key contributor to test thoroughly for different scenarios and prepared test results.

- Documentation writer for the system

I am considered by my colleagues as ETL-guru.

Tools: Informatica, Oracle 9i, Toad, Sybase Power Designer, UML, MS Word, MS Excel, MS Visio, MS Access.

Regional Fund of Medical Compulsory Insurance, Yekaterinburg, Russia

Senior Specialist of Software Department, 1993-2005

Leader of development team.

-Designer and developer a Management Information System for the Fund. System allowes the client to analyze its financing of hospitals, clinics, and drugstores.

-Feature automated financial reconciliation with proprietary accounting package.

System housed large amounts of data:

-more than 4 million insurees;

-more than 250 hospitals/ clinics;

-more than 400 drugstores;

-a lot of insurance companies.

Key contributor to create and develop three generations of these systems. Each of them was implemented by me personally. The first generation was based upon DBase+Visual FoxPro. The second generation based upon RDBMS Informix. The third based upon RDBMS Oracle; this generation is in use today.

My responsibilities include:

-Business Requirements Gathering and documentation

-Data modeling

-Complex ETL involving various sources and targets (Visual FoxPro, Informix, Visual FoxPro, and Oracle)

-Reporting (SQL, Excel)

-Testing

-Published User Manual

-Help system implementation

-User training

In addition:

- Key contributor to represent the organization at numerous healthcare and medical insurance exhibitions.

Tools: MS Word, MS Excel, MS Visio, MS Access, MS Powerpoint, XML, ERWin, BPWin, UML, HL7, MS Help Workshop

Education

Ural State Technical University ( Yekaterinburg, Russia )

Degree evaluated by University of Toronto as Bachelor’s Degree

Additional education:

- I have completed the Data Warehouse and ETL Training at (2009)

- I have completed the Business Analyst courses at IIBS (Mississauga - 2010)

Certification

Brainbench RDBMS Concepts Certification 2002

Brainbench Data Modeling Concepts 2004

Brainbench Systems Analysis 2004

ProTech Professional Technical Services Advanced SQL (Oracle) 2008

Contact this candidate