Igor Kizima

212-***-****

acgiho@r.postjobfree.com

Professional Summary:

> Front-office development

> Financial Modeling, .NET / Excel -VBA (VSTO) / SQL Developer.

> Highly experienced in SQL queries, joins and store procedures

> Developed and implemented reports against SQL Server (SSRS), Access

and MS Excel.

> Good exposure to SharePoint - creating & designing web parts, views,

reports, surveys, workflows and interfaces with multiple MS SQL/Access

databases over network infrastructure.

> Expert in building Excel front ends using VB (VSTO, WPF) forms and

manipulating them through VBA

> Highly proficient in Access/Excel/SQL data extraction, transformation

and loading using ODBC, ADO, DAO

> Efficient in all aspects of MS Excel/Access (tables, queries, forms,

reports, modules, macros, security) including database design &

development

> Experienced in evaluating and modifying tables, queries, and reports.

> High level of expertise in advance Excel features (pivot tables,

charts, functions, scenarios etc.)

Skillset:

C# /VB.NET, VSTO, SQL Server 2012, VBA (MS Office 2003-2010), SharePoint

2010, XML 1.1, JQuery, PHP

Projects Summary:

Skadden LLP, New York, NY

2005 - present

Programmer Analyst / System Coordinator

The aim of the projects was to perform business/finance application

developing (SQL, .NET Window Forms,

MS Excel/Access (VBA) macros, Add-ons etc.) Financial Modeling, Financial

reporting automation.

Hardware/Software:

MS Excel 2003-2010/Access 2003-2010 VBA, SQL Server 2000-2008, Visual

Studio 2005-12

Responsibilities:

> Reporting tools development with VBA, SLQ and VB.Net/C# (VSTO, WPF)

> Expanded the potentiality of ad-hoc tools to enable more efficient

evaluation of financial measures, analysis

and report preparation SQL Server 2012 (SSAS, SSIS, SSRS), XML, CMS,

.NET

> Created, implemented and maintained SQL Server databases 2000- 2012

> Provided software programming support for in-house application

development and system enhancement

> Converted existing Microsoft 2003-2010 Excel based solutions / macros

/add-ins and modules to .Net

> Debug the VBA errors in MS Access/Excel user form caused due to

migration from 2003 version to 2010.

> Supported existing functions of the system as well as any newly

created applications.

> Maintain test lab environment of computers and Citrix.

> Manage inventory of applications, files and tools to be modified,

fixed or tested

> Provide weekly status on progress and challenges

> Provided support and training to staff members on various

applications, including ADERANT Expert,

Excel, the department's custom Excel macros, and SQL Server Reporting

Services (SSRS).

> Empowered and supported business users with tools to assist with daily

ad-hoc requests

> Participates in a project to develop DB meaningful, advanced analysis

solution by using SSAS, SSIS and SSRS

> Worked as a team member with other technical staff to ensure

compatibility and connectivity between systems

Volt Information Sciences, Inc. New York, NY

2002 - 2005

VBA/Excel developer/ Data Analyst

ProcureStaff Technologies pioneered the vendor-neutral contingent workforce

Vendor Management System (VMS) application, which has become the industry

standard The project objective was to create set of Access/Excel forms to

automate e-billing, collections reporting and for data auditing.

Hardware/Software:

MS Excel 2000-2003/VBA, MS Access 2003, PeopleSoft, SQL Server 2000

Responsibilities:

> Obtained initial requirements from business analyst and corresponded

with them throughout conversion.

> Created MS Access database using tables and forms.

> Designed a front-end access to reports, queries and forms

> Created Front End Screens with data validations Using Access VBA

> Imported data into Excel from Access for creating pivot tables and

Charts.

> Conducted financial ratios analysis and reporting using Excel/VBA

> Defined the various naming standards.

> Developed prototypes and managed changes based on feedback.

> Worked with Add Ins features into Excel Sheets with XLA technology.

> Generated weekly sales report in excel spreadsheets using Excel/VBA.

Trainings:

Solartech - Microsoft .NET (C#, WPF, SharePoint) 2008, 2010

Learning Tree - Microsoft .NET and VSTO 2008

Sams Consulting - Microsoft .NET and C# development course (January -

June 2004)

Sams Consulting - Java 1.3 development course (September - December 2002)

Education Qualifications:

Bachelor of Business Administration (BBA), Finance

National University of Economics Kharkov, Ukraine 1991-1996

Technical Post Graduate Courses

Cope Institute NY, NY - Computer Programming C, Java (2000-2002)

Contact this candidate