Developer Software

Dmitry Mirkin

**** ******** ***

Skokie, IL *****

Home: 847-***-****

Cell: 847-***-****

Email: **********@*******.***

Summary

Computer professional with solid background in design, development, and implementation of complex Web based and client-server applications and systems.

Excellent analytical, organizational, decision-making, time management, and communication skills.

In-depth knowledge of business structure and financial foundation of projects.

Solid experience in optimization, integration & implementing 3rd party tools/software

Certification

Microsoft Certified Professional (MCP) (2000);

Certificate of completion:

-TCS Internal Certification

Process: Agile Way of Working Foundation (2018)

-Web and Application Development Essentials(VS2012) (2014)

-Advanced Web Application Development with VS2005 (2009)

-SQL Server: Writing store procedures (2006)

-Microsoft.Net. Advanced Studies for Enterprise Development (2002)

-Visual Basic/Access Application Developer (1997)

Programming Languages/Technologies

Latest Visual Studio environment: IIS 8.5; IIS 7; .NET Framework 2.0; 3.5; 4.0;4.5; VS2003; VS2005; VS2010, VS2012 (including TFS, JavaScript, HTML, CSS), SVN,

Borland Developer Studio 2006 (Delphi) – used for developing COM object

.NET platform (ASP.NET, C#, VB.NET, ADO.NET), ASP, VS ComponentOne toolbox, SQL Manager 2005, VB(v.4,5,6), Visual InterDev (VBScript, JavaScript, HTML4,5, DHTML, CSS), ADO, ODBC, Visual SourceSafe, Commerce Site Server 3.0, XML / XSL (T), SQL, Source Integrity, Citrix Program Neighborhood, Lotus Notes

Operating Systems/Networks

MS Windows 3.11 through Windows 10 / Ethernet, TCP/IP, Internet, WWW, CITRIX

Databases

MS SQL Server 6.5/7.0/2000/2005/2008R2/2008R2 (including T-SQL, SSIP) /2012 R2; MS Access 97 / 2007 / 2013; DB2 v.8,9; Sybase 6.1

Methodologies

.NET, DNA/2-, 3-tier architecture (Web, Client / Server), OOA & OOD, Relational Technology, Structured Programming

Applications / 3rd party tools / browsers used

Microsoft Office (latest), RoboHelp, Crystal Report, ChartFX, FrontPage, Adobe Acrobat Reader, WinZip, AlZip, MS Internet Explorer, Mozilla Firefox, Google Chrome, PC Anywhere, WebEx, Fiddler; Elastic; WinMerge

Experience

Tata Consultancy Services, Naperville, IL (or Edison, NJ) 12/2016-04/2019

Industry: Consulting for airline/transportation, insurance, financial, manufacturing, etc.

Tech Lead/Developer

Client: “United Airlines ” (airline industry)

Projects: EZR, GEZR (core support team – ticketing and reservation applications)

Environment: SCRUM; DEV-EQA-PROD; multiple teams;

Software: Windows Server 2012 and higher; VB6; C# components; Web Services; Fiddler;

Sql Server 2012; Elastic; ServiceNow;

Data sources: SQL Server 2012 (Microsoft) database: SHARES (mainframe)

Assignments:

-Fixing bugs in EZR/GEZR (using TFS, VB6, C#, data sources, web services, 3rd party tools);

-Working with incidents as needed (using ServiceNow application);

-Extension of existing functionalities EZR/GEZR;

-Development, testing, release of developed code;

-Cooperating with SCRUM team, working with multiple team’s environment.

Insight Global., Rosemont, IL 05/2016-09/2016

Industry: Consulting for insurance, financial, manufacturing, etc.

Developer/Analyst

Client: “Great American Insurance Group ” (insurance industry)

Projects: Adding features to existing app, writing reports

Environment: Visual Studio 2005/2012; SQL Server 2012 (adding/deleting new tables, writing store procedures); TFS; Windows apps; CSLA - Business Objects (VB.NET environment), Crystal report

Software: Windows Server 2012; SQL Server 2012 (Microsoft) database.

Documentation: Documented all steps, did unit/regression tests

List of assignments:

oQuote Follow-Up (created e-mail to notify client about offered quote).

oCreated report (writing .xsd, Crystal Report) for newly associated division

o Combined and show summarized comments from different users of application (including pre-set comment).

oChange Factor value control for ability to use 3 decimals

oAdd e-mailed warning for certain states without tax

oImplement a new payment plan for newly associated division

oCreated a big report (writing .xsd, Crystal report) for newly created form

oSynchronized info from two different tabs.

Mercury Consulting., Hinsdale, IL 05/2014-12/2015

Industry: Consulting for insurance, financial, manufacturing, etc.

Consultant

Client: “TNCRRG (The National Catholic Risk Retention Group, Inc.) ” (insurance industry)

Project: “ Migration of Web site into the Cloud”

Environment: Web, Client-Server (.NET environment)

Software: SonicWall Global VPN(communication); Lotus Notes v.8.5 (email/calendar); Windows Server 2012 with IIS 8.5; Windows Server 2008 with IIS 7.0; SQL Server 2012 (Microsoft) database; SQL Server 2008 (Microsoft) database.

Integration: Installed needed software and migrated existing Web site “into the cloud”.

Migrations: Installed SQL Server 2012 and migrated existing DB to the same server.

Documentation: Documented all steps and settings, did regression test

Client: “InfinityQS” (manufacturing industry)

Project: Utility Upload Tool (manufacturing industry)

.NET environment

Windows Desktop Application

Software: SonicWall Global VPN(communication); Lotus Notes v.8.5 (email/calendar); SQL Server 2008R2 (Microsoft) database; SQL Server 2012 (Microsoft) database; DB2(AS400) database; Development: Visual Studio 2010 (C#);

Development: Analyzed requirements; designed database tables; designed new application; developed code/store procedures; tested; created setup project; migrated to Client server.

Documentation: Wrote user manual, documented results of functional test, acceptance test, regression test.

Client: “TNCRRG (The National Catholic Risk Retention Group, Inc.) ” (insurance industry)

Project: “Update CMS (Content Management System) - Replacement existing HTML Editor”

Environment: Web, Client-Server ((.NET environment – MVC based Web application)

Software: SonicWall Global VPN(communication); Lotus Notes v.8.5 (email/calendar); SQL Server 2008R2 (Microsoft) database; Development: Visual Studio 2010 (C#, ASP.NET); FreeTextBox (3rd party HTML Editor); ASPxHTMLEditor v.14.1 (DevExpress) (3rd party HTML Editor)

Integration: Analyzed, found replacement, re-designed, developed, tested, installed new HTML Editor instead of existing providing the same interface/functionality. Resolved browser compatibility issues.

Developed Web application parts: changed Master page, Content folder files, Views folder files, bin folder, web.config file to implement a new HTML Editor feature

Client: “MCSI (Municipal Collections Systems, Inc.) ” (financial industry)

Project: “MSCI Dialer Pool optimization” (Windows application)

Environment: Windows desktop application; (.NET environment)

Software: SonicWall Global VPN(communication); Rational Team Concert v.4 (Project Management System); Lotus Notes v.8.5 (email/calendar); Sybase v.6.1 (SAP) database; SQL Server 2008R2 (Microsoft) database; Development: Visual Studio 2010(C#); MS Office v.2010(Excel); Telerik tools v.2010 (3rd party controls).

Optimization: Analyzed, re-designed, developed, tested, installed updated existing application to run minutes instead of hours/days.

First Insurance Funding Corp., Northbrook, IL (Wintrust subsidiary) 08/2007-01/2014

Industry: Financial Services

.NET Developer /Analyst/Software Engineer

Project(s): Applications developed / supported:

Agency Services

Insured Services

Quoting (including PFA – Premium Financial Agreement)

Integration

Premium Billing System

Misc internal applications.

Environment:

Web, Client-Server (VS2003; VS2005; VS2010; SQL Server 2008; VB.NET, C#, ASP.NET, VBScript, JavaScript, Web Services (SOAP); MS Exchange; Active Directory (user experience); SharePoint (user experience); HTML; XML; CSS; Borland Developer Studio 2006 (Delphi));

Analyzed business processes and requirements to create solutions that meet and exceed the project stakeholders needs and vision

Designed, developed and tested .Net and other Windows and Web applications

Did troubleshooting and maintaining production programs, and documenting projects and business processes.

Documented app changes, wrote specifications, manuals, worked with stakeholders to gather requirements.

Witt/Kieffer, Oak Brook, IL 04/2005-07/2007

Software Specialist /Technical Lead

Project: Application “Blackberry-based online job application” for mobile device (VB.NET)

Environment: Web, Client-Server

Participated in the project planning activities, gathering requirements, discussing business problems, providing documentation and recommendations of potential solutions and risks.

Designed, developed, tested and implemented application for “Blackberry” mobile device.

Created project documentation including functional and non-functional requirements, application design documents and testing plans.

Re-architected application data access and execution by eliminating embedded SQL and creating data access layer. Made changes to the database design, created triggers, created and optimized stored procedures, constrains, indexes.

Re-designed the existing application written on PowerBuilder 6.5.

Made significant changes to the existing Intranet application, improving user interface and performance.

Served as a liaison between IT department and end-users.

Performed training and mentoring of Help Desk operators who support new and modified applications.

Titan Technology Group, Chicago, IL 11/2004-03/2005

Consultant / Web Developer

Client: “TotalWorks (Catalog Production company)”

Project: “ Shopping Cart ” (C#, ASP.NET)

Environment: Web, Client-Server

Designed and implemented user authentication mechanism to simplify passing data between Java based and .Net applications.

Re-designed existing application by externalizing business rules for their maintainability and by changing presentation layer to improve end-user experience.

Designed SQL Server stored procedures to execute application business rules, created data validation routines.

Performed research, evaluation, and implementation into production of Content Editor for existing Web application.

Digital Staffing, Oak Brook, IL 06/2004-10/2004

Consultant / Web Developer

Client: “NCREL (North Central Regional Educational Laboratory)” (VBScript, JavaScript, HTML, ASP)

Project: “Federal”

Environment: Web, Client-Server

Based on existing documentation, gathered business requirements, designed and created new Web application for collecting data from local centers.

Designed Database for the above application, performed existing data validation and transferred it into the new database, wrote stored procedures implementing existing business rules.

Integrated reports into existing main application (PPICS) using ChartFX.

TEK Systems, Rolling Meadows, IL 04/2004-06/2004

Consultant / Web Developer

Client: “ Helios OE (distribution company) ”

Project: “HeliosOE - Order Entry System” (C#, ASP.NET)

Environment: Web, Client-Server

Created dynamic reports (using ComponentOne toolbox) and integrated them into existing environment.

Modified existing and created new stored procedures, tuned database to optimize performance.

Pepid, LLC, Skokie, IL 07/2003-03/2004

Title: Consultant / Software Developer

Project: “Pepid” (VB.NET)

Environment: Web, Client-Server

Prototyped and implemented Web version of existing client-server application.

Designed and created two Web based applications: Scheduled IIS Report and Reader.

Created client-server version of existing Dynamic Index Palm application.

Built diagnostics and alert services into auto-installing program.

Performed data transfer using DTS.

STL Technology Partners, Bloomington, IL 10/2002-06/2003

Title: Software Developer

Client: “Illinois Power” (Decatur, IL)

Project: “Illinois Power” - set of applications for gas distribution (VB.NET, COM)

Environment: Client-Server

Converted existing SqlWindows applications to 3-tier based applications using DB2 as backend and VB6 for middle-tier and front-end (ADO 2.7, Crystal Report 8.5, Ultragrid Infragistics 2.01).

Modified / rewritten existing store procedures (DB2) for new objects needs.

Provided new objects with code supported same functionality as old application.

NuBreed Technologies, Inc., Chicago, IL 04/2002-09/2002

Consultant / Software Developer

Project: “Shopping cart”

Created scalable E-Commerce solution framework for generic On-Line Store-Front deployment. The. NET-based application framework featured SQL Server 2000 backend, Core components written in C#, COM+ enabled transactional components, C#, ASP.NET, ADO.NET, XML/XSLT technology, and SOAP-based web services.

Participated in design and development of Windows based Admin. application and Web based Customer maintenance and Order Entry applications.

Bacons Information, Inc., Chicago, IL 03/1999 – 03/2002

Developer II / Web Developer

Project: “MediaSource Internet” (Web)

Worked as a part of the team to create and support large-scale Web application for On-Line sales of Information products.

Web application featured SQL Server 2000 back end, ASP 3.0, ADO 2.6, HTML/CSS technology, and TCP/IP-based web services.

Project: “HelpStar” (Client-Server)

Designed, developed, tested, and implemented client-server application called HelpStar.

Created new relational database based on existing non-relational database.

Transferred data from existing database to the new one, wrote store procedures for COM objects.

Project: “Media Directories” (Client-Server)

As part of the team developed client-server Media Directories application.

Developed numerous internal applications.

Emergency24, Inc., Chicago., IL 07/1997 – 03/1999

Web Developer

Project: “Secure Internet Service” (Web)

Worked on design and development of large-scale Web application called Secure Internet Service.

Modified existing database, created stored procedures, performed data transfer from flat files into SQL Server database.

Developed internal desktop applications.

Software Express, Inc., Skokie, IL 03/1997 - 07/1997

Consultant / Software Developer

Project: “Grading System” (Client-Server)

Developed desktop application called Grading System.

Modified & developed application database, wrote stored procedures.

Education

TCS

TCS Internal Certification Process: Agile Way of Working Foundation 2018

TCS Continuous Learning Program iQMS for PLs Training – PM E0 2017

Advanced Computer Training, Glenview, IL 2014

ADO.NET

LINQ & Entity Framework

MVC

Learning Tree, Schaumburg, IL 2006

SQL Server: Writing store procedures

Goal Training, Inc., Skokie, IL 2002

Microsoft.Net. Advanced Studies for Enterprise Development

(ASP.NET, C#, VB.NET, XML/XSLT, Web-Service Design, .NET Framework)

Computer Systems Institute, Skokie, IL 1996 -1997

Visual Basic/Access Application Developer

Oakton Community College, Des Plaines, IL 1994 -1996

Completed classes:

- Information Systems for Business

- Programming Logic and Techniques

- C / Unix

Polytechnic Institute, Minsk, USSR 1971 - 1976

Diploma: MS in Mechanical/Electrical Engineering

Citizenship

US Citizen

Dmitry Mirkin

Contact this candidate