Michael Kamergorodsky
******@***.***
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