Michael Kamergorodsky

ac668q@r.postjobfree.com

718-***-****

Technical skills

Hardware: Client/Server environment, I-Series(AS/400), IBM Mainframes

.Net Development: MS Visual Studio 2012, VB.Net, C#, Ajax, MVC, MS Reporting Services, HTML, XML, ASP.Net, ADO.Net, CSS, LINQ, Web Services, SSRS, IIS, MS Share Point,

SOA (Service Oriented Architecture), XML-based web services, Silverlight, SCRUM methodologies.

Operating Systems: Windows 10, Windows Server, OS/400

Programming: COBOL, COBOL/ILE, DB2, SQL, CL/400, PL/SQL, Synon 2E

Databases: MS SQL Server, Oracle, MS Access, DB2, including design of all components and maintenance.

Applications: Insurance: Underwritings, Claims, Billing, Financial, Reporting, Interfaces; Data Migration; Banking; International Trading; Inventory; General Ledger; Accounts Receivable, Accounts Payable, E-Commerce.

General:

oExperience supporting Web based applications

oExperience working with HTML and XML

oExperience in the definition, creation and execution of test scripts

oStrong problem-solving skills

oExperience with defect analysis and reporting

oExperience creating and maintaining file interfaces via SFTP

oStrong attention to detail

oExcellent written and verbal communication skills

oDemonstrated time management skills with the ability to meet tight deadlines

oAbility to work well in a team environment

oAbility to work well under pressure and work multiple tasks simultaneously

oSuperior customer service skills

Experience:

EDM Electronic Data Management, Brooklyn NY 03/2015 – Present

Position: Lead Software Developer

Created a Web-based Application for small to mid-sized business: Service and/or Product Sales oriented with the following modules:

oServices Transactions;

oSales/Purchases Transactions;

oShopping Cart;

oTasks/Projects Management with Employees Time Tracking;

oGeneral Ledger;

oPayroll;

oCommunications: Emails and Text Messages to the cell phones.

oReports, Dashboards and on-line Data Queries;

oImport/Export Interfaces.

Custom Screens are designed as Web Pages(.aspx) with direct access to Database objects and standard controls: Text Boxes, Dropdown lists, Check Boxes, Radio Buttons, Grid views, etc.

Each Grid view control is used to display with filters and sorting of specific data and is supported by add, view, update, delete functions that is displayed upon security allowances in a specialized Data Table for each program and User. Some Grid Views are used of export to .PDF, Excel, MS Word, Text format files and printing capabilities. Multiple screens are handled with Asp Panels that control the flow of the operation.

The following Technologies were used:

oBack End: SQL Server (2010 – 2017);

o.net foundation (4.0 +);

oOperating Systems: Windows 10, Windows Server 2012, Windows Server 2016;

oClient access: Any Internet browser Java script enabled;

Programming and Tools: ASP.Net, ADO.net, VB.Net, SSRS, IIS, MS Visual Studio 2017, MS SQL

Server Data tools 2017, MS Office 2016.Security:

oDatabase: By MS SQL Server

oApplication: Login is required for the access.

oUser Profiles are available but not limited to: Administrator, Employee, Guests, Customers.

oWeb Pages: General access is allowed/limited by internal security that is designed to manage user profiles for access and Add, Edit, Delete, View functions to allow or limit user to Web Page function.

Created Database Objects: Tables and Views with Triggers, Constraints and Stored Procedures used MS ACCESS and SQL Server.

Utilized SSRS Reporting services to create Customized views and reports.

Used SharePoint 2010 and IIS

Created WEB Pages for mobile and Android devices with MVC, CSS, HTML 5

Used WCF as tool to implement and deploy a Service Oriented Architecture (SOA).

Used various source control and management tools.

Western Word Insurance, Parsippany, NJ 11/2016 – 01/2017

Position: Lead Software Developer

Technologies: ASP.Net, VB.Net, IIS, ODBC, I-Series, DB2, COBOL, CL, VB.Net, MS Visual Studio

Application Package: Wins

Created Interface of automated upload of Underwritings and Claims data in Excel format to I-Series DB2 tables using VB.NET, ASP.NET, ODBC

Created Edit Programs for uploaded file using COBOL/400, Workstation Files

Created Mail notification programs using COBOL/400, CL/400

Nationwide Insurance, Des Moines IA 10/2014 – 02/2015

Position: Lead Software Developer

Technologies: ASP.Net, VB.Net, IIS, ODBC, I-Series, DB2, COBOL, CL, VB.Net, MS Visual Studio

Application Package: Wins

Analyzed existing Billing System and prepared synopsis for improvement and changes based on Client’s requirements.

Created Web Pages to extract Data from DB2 Tables and Oracle Tables (Financial Data) with filtering and sorting capabilities using VB.NET, ASP.NET, ODBC, MS Grid View.

Created Data Entry Programs utilizing ASP.Net, VB.Net, ADO.Net, DB2/400 tables, ODBC.

EDM Electronic Data Management, Brooklyn NY 01/2012 – 09/2014

Technologies: MS Windows Server, MS SQL Server 2008 R2, MS Access, .NET Framework, VB.Net, SSRS,

LINQ, Entities, Java script, AJAX, MVC and HTML 5.0., Share point, J-query

Position: Lead Software Developer

Created Data Entry Programs using ASP.NET, ADO.Net and VB.Net

Extensively used MS Visual Studio 2013 for development and testing and PL/SQL

Used Master Pages for Navigation between ASPX Pages and unique appearance

Extensively used CSS classes (external and internal) to improve appearance and to use properties of controls that require CSS Classes

Used Java script, Ajax Functions, J-query for Client-side functions programming

Used AJAX Toolkit Extenders along with Web Services and Java script functions to improve standard ASP.Net controls.

Created WEB Pages for mobile and Android devices with MVC, CSS, HTML 5

Used WCF as tool to implement and deploy a Service Oriented Architecture (SOA).

Used various source control and management tools

Applications:

Patient and Treatments tracking system for Animal Hospital;

Web Store Back-End Processing, Internal Reporting, Day-End, Month-End Processing;

Calendar-Based Event Tracking System for Children’s Parties Organizer

Accounts Receivable Tracking Sales and Payments System

Inventory Control System

Merchants Insurance Group, Buffalo, NY 11/2009 – 11/2011

Position: Contractor, Developer/ Project Leader

Technologies: AS/400, ASP.NET, VB.NET, Crystal Reports, IBM Mainframe, DB2, COBOL, MS ACCESS

Application Package: Wins

Created and implemented interface between WINS Insurance Package and Freedom GL package

Eliminated existing Interface between IBM Mainframe and Freedom GL Package.

Implemented WINS Insurance Re-Insurance Package

Designed and implemented various Accounting and management reports

Created and distributed various financial reports with GUI interface utilizing VB.NET, ASP.NET, PL/SQL

and Crystal Reports.

Participated in Testing, Client’s personnel training and documentation.

Farmers Insurance Group, Cleveland, OH 07/2009 – 10/2009

Position: Contractor, Developer

Technologies: AS/400, DB2, Oracle, I-series Synon, PL/SQL

Application Package: Wins

Converted existing DB2 Database into Oracle including Tables, Views, Triggers and Constraints

Modified existing applications to access Oracle Database

Migrated and verified data to Oracle

Set up Production, QA and Development Environments

Participated in Testing, Client’s personnel training and documentation.

TransGuard, Naperville, IL 04/2009 – 06/2009

Position: Contractor, Developer

Technologies AS/400, COBOL, RPG, PL/SQL

Application Package: Wins

Designed interface between WINS Insurance Package and Freedom GL package

Set-up a test plan and implemented core interface programs

Aegis Insurance, East Rutherford, NJ 10/2008 – 12/2008

Position: Contractor, Business Analyst

Technologies: ASP.NET, ADO.NET, AS/400, PL/SQL

Application Package: Wins

Performed Analysis and Research for various Insurance Processes including Policies, Claims, Reinsurance

Performed cost Analysis for various projects that would involve outsource resources

Blue Cross of North Carolina, Durham, NC 07/2008 – 09/2008

Location: Company type: Insurance Company

Duration: 9 Months

Position: Contractor, Developer

Technologies ASP.NET, VB.NET, SQL Server, PL/SQL

Participated in design, coding, testing of Automated Group Enrollment System.

Hartford Financial Products, New York, NY 06/2007 – 06/2008:

Position: Contractor, Developer

Technologies: AS/400, COBOL, CL, SQL, ASP.Net, VB.NET, ADO.net

Application Package: Wins

Performed Modifications and additions to company’s WINS and Vision products.

Developed Back-end Interface for Claims Entry/Update program.

Created Various Management Reports, Downloads and Report files.

Developed on-line Data queries.

Fireman’s Insurance Fund, New York, NY 02/2007 – 05/2007

Position: Contractor, Developer

Technologies: VB.NET, ASP.NET, AS/400, ADO.NET, COBOL, CL, PL/SQL

Application Package: Wins

Developed a special report for an “Interstate” agency that required various Policy Premium and Claims Information that was extracted from company’s AS/400 Database.

AIG, Livingston, NJ 03/2006 – 12/2006

Position: Contractor, Developer

Technologies: AS/400, COBOL, CL, SQL

Application Package: Wins

Participated in Support and Maintenance of WINS package for various clients utilizing COBOL/400 ILE, and CL/400.

Sumitomo Marine Management, Warren, NJ 08/2005 – 02/2006

Position: Contractor, Developer

Technologies: AS/400, COBOL, CL, SQL

Application Package: Wins

Developed EDI Reports for Workmen’s Compensation First and Supplemental Reports of Injury.

Created Additional Screens for entry for the fields missing in WINS package.

Modified WINS Claim Entry and Checks programs to include new Entries.

Created an Extract, Acknowledgement and logging procedures.

Used SQL/400, Query/400, DB2/400 and Sequel to retrieve information and analyze Data files.

Yasuda Marine Management, New York, NY 04/2005 – 07/2005

Position: Contractor, Developer

Technologies: AS/400, COBOL, CL, SQL

Application Package: Wins

Developed EDI Reports for Workmen’s Compensation First and Supplemental Reports of Injury.

Created Additional Screens for entry for the fields missing in WINS package.

Modified WINS Claim Entry and Checks programs to include new Entries.

Created an Extract, Acknowledgement and logging procedures.

Used SQL/400, Query/400, DB2/400 and Sequel to retrieve information and analyze Data files

AXA Global Risks, New York, NY 01/2005 – 03/2005

Position: Contractor, Developer

Technologies: AS/400, COBOL, CL, SQL

Application Package: Wins

Updated WINS insurance package to the latest software release.

Created Test Environment.

Created various Premium Analysis Reports.

Additional Jobs/Projects are available upon Request.

Education

1979 - State University of Latvia, Riga Latvia – B.S. of Economics.

1982 - DPI, Data Processing Institute, Baltimore MD – Certificate of Computer Programming

Contact this candidate