Dmitry Ikan

ad1ooq@r.postjobfree.com; 818-***-****; https://www.linkedin.com/in/dmitryikan/

System Analysis & Design

SQL Server

.NET (2.0-4.5)

Visual Studio

SSRS, SSIS

VB6, VB.NET, VBA

MS Windows NT Network

T-SQL

PowerShell

MS Windows (3.1 – 10)

MS Access (all versions) VBA

HTML, CSS

MS Office (solutions)

MS Excel (all versions) VBA

XML, XSLT, XQuery

8/15 – Present Ikan Computer Consulting, Los Angeles, CA

Software Engineer / Computer Consultant

PCI Services LLC, Burbank, CA

oDeveloped various financial reports in Excel using VBA (Access) complex Micro-systems.

WNC First Insurance, South Pasadena, CA

oDeveloped various financial reports in Visual Studio (BI) and automated report execution using SSIS packaging tasks and SQL Server Job Scheduling.

oDeveloped and implemented SSIS configuration system based on SSIS objects for easy adjustment of variables and SSIS tasks.

3/08 – 7/15 Country Villa Health Services; Los Angeles, CA

Analyst / Software Engineer / T-SQL Developer

oManaged multiple SQL servers with running Vision software - Electronic Medical Records.

oDeveloped PowerShell scripts contorted by XML configuration files to do data backup from production and restore on test and training Vision instances along with running maintenance SQL scripts. Repeatedly developed and ran SQL scripts to maintain data and software integrity.

oDeveloped custom report for Vision system using SQL Reporting Services (SSRS) to accommodate growing users’ needs. Those reports were required complex report design along with elaborate systems of SQL scripts, store procedures, and custom functions, complicated procedures submerge custom reports into Vision system.

oDesigned, developed, and maintained data imports and exports into data warehouse using SQL and SQL Server integration Services (SSIS) packages.

03/96 – 3/08 Ikan Computer Consulting, Los Angeles, CA

Software Engineer / Computer Consultant / T-SQL Developer

Soft Gel Technologies Inc

oBased on extensive and accurate business operations analyzed and developed several MS Office Solutions by utilizing MS Access on front end, Visual Basic for Application to define business intelligence and MS SQL Server 2005 on backend.

oDeveloped “QA Inspection” application to take data entry for QA department and make proper decision for department administration, along with accurate data analyses and reporting system.

oDeveloped “Employee Training Tracking” application which allowed tracking all necessary training for proper employee, with extensive reporting system.

oPreformed necessary changes to prior design systems.

Leaders

oUtilized VB.NET and ASP.NET 2.0 with XML Services for developing web application for gathering information of future clients (merchants). Gathered information would then be transmitted to parent company’s WEB Services for extensive processing.

oMaintained and preformed necessary changes using VB.NET and Java Scripts to in-house developed WEB Infra-Office application Matrix v.2 which was based on .NET 1.1 technologies.

TABC Toyota

oAnalyzed existing application named “Training Enrollment,” which was developed in MS Access for data entry, and also maintained data integrity.

oComposed necessary changes to applications’ infrastructures, user interfaces and reporting systems, data migration procedures by utilizing Visual Basic for Application.

oCreated an instruction manual for future users.

Sage Publications

oAnalyzed data entry system (ARGI) for organizational rules and financial formulas.

oBased on proper analysis, developed MS Office solutions for MS Access and MS Excel by utilizing Visual Basic for Application for well improved reporting systems: Circulation Reports, Financial Reports, and Monitoring Reports.

oDeveloped Web base application (reporting system) by transferring major parts of Circulation Reports system onto Server environment (SQL Server 2000, VB.NET and ASP.NET 1.1 WEB Server).

oCreated user defined financial calculations and functions and complex store procedures with a limited amount of views in SQL Server 2000.

oUtilized ASP.NET (Visual Basic on server end) and ADO.NET to design multi-framed UI (report menu, criteria forms, and report details) with multi-database connections.

Golin/Harris

oConfigured logical flow of application on prior system.

oSurveyed users for necessary changes to meet client’s criteria.

oEmployed Windows API and Visual Basic to engineer an application based on analyses.

oProvided technical support for client’s staff.

Bank of America

oAnalyzed AS400 database and user requirements for necessary data components.

oDeveloped web applications, utilizing Visual Basic, based on outcome of analyses.

oAssociated application with any database platform using billed SQL Statements.

oTrained users and programmers on proper use and maintenance of application.

oFacilitated daily reports for multiple departments with use of AS400 technology.

Mitratech

oConverted data from outdated sources into Oracle or SQL server for CLMS (in house developed software) scheme.

oDeveloped software utilizing Visual Basic 6.0 and Access 2000 to execute converting tasks.

oPerformed routing checks and necessary fixes on systematic databases.

oInstalled and maintained Oracle and SQL servers.

GTA

oDeveloped interoffice software for reports on Windows platform, utilizing Visual Basic 5.0 and Access 97.

oLed programming department in completion of projects.

oDeveloped user friendly and optimized forms with compact coding behind them.

oCreated accurate reports for project usage

PCSC

oUpdated and configured PCs with new hardware and other components.

oInstalled Windows (3.11, 95, 98, NT) and configured to LAN.

oExamined Micro LPM for improper functions and eliminated any systematic errors.

THOMAS HAYES CONSULTING

oConfigured an interoffice network on a Pentium Server using Windows NT v 3.51.

oProvided heavy technical hardware (PC compatible) and complex software support for custom application (EYEMIS v 1.9c) utilizing Norton PC Anyware v 7.5.

oFrequently tested and debugged in-house developed software.

oVisited clients' offices to ensure highest quality of service.

EDUCATION:

07/17 NEW HORIZONS; Burbank; CA

Certificates Classes Completion

Reports Development; SQL Server Management (T-SQL); Building and Maintain Data Warehouse and ETL

04/10 LA Valley College, Valley Glen, CA

Computer repair, networking installation and computer programming

09/98 TELTECH; Burbank, CA

Certificate of Completion KESET International Program "Achieving Extraordinary Customer Relations"

02/98 PCSC; Carson, CA

Certificate for Installation and Service on LiNC-NET and Eclipse Access Control Systems

7/96 COMPUTER LEARNING CENTER; Los Angeles, CA

Associate Degree in Computer Programming Technology

11/95 SANTA MONICA COLLEGE; Santa Monica, CA

Major: Computer Programming

Contact this candidate