LEON KATSMAN

**** **** *** ******, # *-E

Brooklyn, NY 11223

Tel: 718-***-****

E-mail: acxrd2@r.postjobfree.com

OBJECTIVE:

To obtain a challenging position with growth potential to utilize my programming and database developing experience in a stimulating environment.

SUMMARY:

● Fourteen years of experience with extensive analytical, design, programming and testing skills for a variety of

business, n-tier applications

● Knowledge of Visual Basic, VB.NET, COM objects

● Experienced in developing Web and Windows applications using ASP.NET, ASP, CSS, HTML, XML,C#,VB.NET, VBScript, JavaScript, MTS, Visual Interdev.

● Experienced in MS Access, MS SQL Server, ORACLE, RDBMS, SQL language and Crystal Reports.

● Experienced in full project life cycle, excellent debugging skills, fluent in object-oriented and procedural

programming.

● Exceptional problem solving skills, excellent communication of technical information and concepts

● Working knowledge of the Microsoft suite of products, and extensive experience as a system developer in a

corporate environment

● Used Visual Source Safe and SVN extensively for version control

● Excellent Analytical, Communication, Presentation and Writing skills

● Ability to organize and manage multiple tasks in a fast-paced environment

● Strong attention to detail, problem solving, and interpersonal skills

● Confident and mature working in a team, or independently

● Can comprehend, articulate & willing to learn & apply emerging technologies quickly

HARDWARE:

IBM PC’s and compatibles

LANGUAGES

& SOFTWARE:

C#, VB.NET, ASP.NET, ADO.NET, AJAX, BizTalk Server, XML, XSLT, Visual Basic, COM objects, VB Script, ASP, Java Script, CSS, HTML, MS SQL Server,SSIS, SSRS, WCF, MVC, MS Access, MS Office, Crystal Reports, Visual Studio 2003/05/08/10,Visual InterDev 6.0, Visual Source Safe, TFS, SVN, MS Visio, BizTalk 2004/2006/2006R2, Entity Framework, Web API, Angular JS, Agile methodology.

OPERATING SYSTEMS:

Windows NT 4.0, MS Windows 95/98/2000/XP/7, Windows Server 2003/2008

EXPERIENCE:

02/2016 – 08/2016 Neuberger & Berman, New York, NY

Senior Developer (Contract)

•As a part of a team, designed and developed the IAB2 System that inherited some of the old functionalities and new users’ requirements. Also, this application has more user-friendly screens.

Environment: This web site was written in Angular JS, MVC, Web API, Bootstraps, and SQL Server was used on the backend.

• As a part of a team, modified the Investment Advisory Billing (IAB) System. The IAB is used

By Wealth Management (WM), Private Asset Management (PAM), Institutional Asset Management (IAM) and Trust Company to setup the billing parameters for client accounts.

Environment: The web site was written in ASP.NET MVC, Web Forms, C#, HTML, JQuery, and SQL Server was used on the backend. This site was developed in 4.5 framework.

•Created new and modified existing SSIS packages.

•Provided production support.

04/2015 – 12/2015 On Peak, New York, NY

Senior Developer (Contract)

•Developed an application that allows users to send confirmation emails to groups and individuals.

Also provided the functionality to track the emails that were sent based on the different criterias.

Environment: This web site was written in ASP.NET MVC, C# and SQL Server was used on the backend. This site was developed in 4.5 framework.

•Developed Customer and Event web services and the ‘Business and Data Access logic’ that was related to the services. The services were used in the different applications to maintain customers and events data.

Environment: These web services utilized WCF technology and were written in C#. They use SQL database.

•Participated in the development and implementation of TPHousing web application. This application provides users with such functionalities like booking hotel rooms for different events.

Developed Malty Room functionality that allows users to see the details about rooms, check availability and many different aspects that are related to hotel reservation.

Environment: This web site was written in ASP.NET, JavaScript/jQuery, CSS, C# and SQL Server was used on the backend. This site was developed in 4.5 framework.

•Also provided production support, wrote SSRS reports that were used in multiple applications.

01/2014 – 12/2014 VOYA(ING), New York, NY

Senior Developer (Contract)

• As a part of a team, developed and implemented Investment Management Direct

(IMDirect) intranet web application. Developed the interface that hosts multiple applications that

users use to manage their daily business needs. These applications allow traders and business analysts

to use different portfolios and strategies for their clients.

• Participated in the development of the Admin part of the site that allows the

administrator of the site to add new applications, menus, create new pages and controls, assign roles to the applications per user.

Environment: This web site was written in ASP.NET, JavaScript/jQuery, CSS, C# and SQL Server was used on the backend. This site was developed in 4.5 framework.

•Took part in development and implementation of the Gift and Entertainment Entry (GNE) web application. This site has Admin and interfaces for users’ interaction. Developed pages that allow users to add, view and manage their entries.

Environment: This web site was written in ASP.NET, JavaScript/jQuery, CSS, C# and SQL Server was used on the backend. SSRS was used to view the data. This site was developed in 4.5 framework.

•Also, was involved in the process of rebranding and rewriting the old legacy applications in the new 4.5 framework.

• Also provided production support.

02/2013 – 10/2013 International Institute of Education, New York, NY

Senior Developer (Contract)

• Took part in development and maintenance of Integration System. The main purpose of this

System is to synchronize the data between Oracle CRM and Enterprise systems.

• Developed “Integration.Enterprise” component that contains Entities for different objects that are

used in the system. Also, this component contains multiple classes that incorporate business logic

that is used for the Integration 2 and the Integration 3 processes.

Environment: This component was written in C# and SQL Server was used on the backend.

• Designed and developed “Error Log” application which is an internal web site. By using this

application, a user can view the records that were not processed correctly and reprocess them.

User can export data to Excel and send the notification email to specified users.

Environment: The project is developed in .NET 4.0 Framework using ASP.NET, CSS, HTML, LINQ

and AJAX for presentation layer. C# was used for code behind pages and classes. On the back end, SQL

Server database was used. Entity Framework was used to communicate with SQL Server.

07/2012 – 12/28/2012 Time Warner, New York, NY

Developer (Contract)

• Took part in design and development of HRPortal Wrapper component. The purpose of the

component is to provide Single Sign-on (SSO) into both EC Applications and Work Day/Mercer

applications.

• Developed Disaster Recovery (DR) landing page that replaces the original HRPortal landing

page when that page is unavailable.

• Designed and developed a facility that adds updates and deletes applications.

• Developed a web service that is utilized by multiple processes.

• Was involved in the rebranding and enhancing of the Employee Connection applications.

Environment: Those applications were written in ASP.NET, VB.NET, C# and SQL Server was used on

the backend. Entity Framework was used to communicate with SQL Server. AJAX and CSS were used for presentation layer.WCF was used for development of a web service. MVC was used to develop a facility that maintains application data.

02/2011 – 06/2012 Foundry9, LLC, New York, NY

Software Engineer

• As a part of a team, designed and developed Acquisitions System Web Site. This is content

management tool that allows users to create the content for different pages. User can create a

template. The template can have text blocks, links, images and cards. When template is created, LP

(Landing Page) can be added to the template. When LP is set up, the setting can be pushed to the

chosen destination by FTP.

When a user presses button “publish”, the tool generates XML file that has all settings for cards,

images and links. Also, IIRF.ini file is created where all rules are specified to rewrite URLs.

• Was involved in the development of front end, business layers, data access and back end.

Environment: The project is developed in .NET 4.0 Framework using ASP.NET, CSS, HTML, LINQ

and AJAX for presentation layer. C# was used for code behind pages and classes. On the back end,SQL

Server database was used. Agile methodology was used for development cycle.

• Took part in design and development of Refer a Friend Web Site.

By using this site, a user can refer a friend for promotions from different credit cards by Email, Face book, and Twitter.

• Was involved in the development of front end, business layers, data access and back end.

Environment: The project is developed in .NET 3.5 Framework using ASP.NET, CSS, HTML, LINQ

and AJAX for the presentation layer. C# was used for code behind pages and classes. On the back end,

SQL Server database was used. Agile methodology was used for development cycle.

• Participated in the security model coding across multiple web sites.

• Created WCF web service that communicates with database and populates a web page with data.

9/2010 – 01/2011 Emblem Health, Inc, New York, NY

Developer(Contract)

• Was involved in the enhancement of the EmblemHealth Medicare Enrollment Web Site.

This web site has ability to perform on-line enrollment into Medicare Plans offered by

EmblemHealth for various channels – individuals, Agents and Brokers via EmblemHealth.com

web portal and Medicare Plans offered by CCI via Connecticare.com. EmblemHealth.com would

have the ability to accept enrollment data and send it to downstream system for processing the

Enrollment.

• Was involved in the enhancement of front end, data access, business layers and back end.

Environment: The project is developed in .NET 3.5 Framework using ASP.NET, CSS, HTML and AJAX for the presentation layer. C# was used for code behind pages and classes. On the back

end, ORACLE database was used. Agile methodology was used for development cycle.

11/2008 – 06/2010 CareAdvantage, Inc. Iselin, NJ

Developer

• Took part in design and development of RPNavigator web site. RPNavigator, CAI’s data, the

analytical tool that represents HIPPA related data. RPNavigator is an invaluable decision support

system and predictive modeling tool that establishes the foundation for targeted benefit design,

vendor selection, clinical analysis, and health care delivery, via an intuitive web based interface.

• This web site has Client and Admin part. I designed and developed Admin part of the application.

The Admin functionality allows user to add new clients, remove existing clients, set sub clients,

assign permissions for the client, assign client to certain group, and set a visibility in the web

site (narrow the data that user can see depends of permissions).

• Was involved in development of all 3 tiers: presentation layer, middle tier and a back end.

Environment: The project is developed in .NET 3.5 Framework using ASP.NET, CSS, HTML and AJAX for the presentation layer and C#.NET for classes’ development and code behind pages. It utilizes LINQ with various SQL stored procedures to manipulate data.

• Designed and developed Upload web site. By using this site, a user can upload any raw data files

to the server for downloading the data into the SQL Server database for processing. This

application has a client and admin functionalities. User can upload files and see the history of

uploaded files. Administrator of the site can set permissions for users and see what user is currently

logged in, set the time frame so the user can see the history of uploaded files.

Environment: The project is developed in .NET 2.0 Framework using ASP.NET, CSS, HTML and AJAX for the presentation layer and C#.NET for classes’ development and code behind pages. It utilizes ADO.NET object with various SQL stored procedures to manipulate data.

• Developed Parser that parses data from the EDI file into the database.User will send a file by

FTP to the inbound location of the BizTalk Server. Then BizTalk will grub the file and load

data into the SQL Server database. Incoming Schema was converted to the C# class. Created

component that is utilized by BizTalk to manipulate the data from the incoming file.

• Designed and created database to store data.

Environment: The project is developed in .NET 2.0 Framework C#.NET for classes’ development, SQL

Server and BizTalk Server.

• Developed Gaps in Care logic. The purpose of this functionality is to populate certain tables

with data that is used by RPnavigator web site to display statistics of different type of sickness.

Environment: The project is developed in SQL Server.

07/2007 – 11/2008 Westcon Group, Inc. Tarrytown, NY

Developer

• Took part in development, design and unit testing of Westcon North American password-protected e-commerce website that sells computer related items: compass.comstor.com. Features of the website include: up-to-date product availability, list pricing and order tracking capability. By using this site, a user can place an order, check a shopping cart, get a discount, track the orders and request RMA (Return Material Authorization) The site sells products from such vendors as: IBM, Nokia, Citrix, Cisco, Check Point, Aruba, Nortel and many other vendors.

• Was involved in development of all 3 tiers: presentation layer, middle tier and a back end. Was responsible for development of a shopping process that includes creation of several web forms. The forms allow users to choose items by ‘part number begins with’, ‘part number contains’ or ‘product description’. They can select a vendor, choose search criteria and search Results Quantity. After the search results are displayed, a user can click on a certain part number to see the part details/specifications. After that, in the check out process, the user can update, delete or modify the order; provide billing and shipping information. At last, the email with the order number and details is sent to confirm the order.

Environment: The project is developed in .NET 2.0 Framework using ASP.NET, CSS, HTML and AJAX for the presentation layer and C#.NET for classes’ development and code behind pages. It utilizes ADO.NET object with various SQL stored procedures to manipulate data.

• Was involved in development of WCF B2B BizTalk project. The main functionalities of the project are: to receive inbound information from the clients with request information about existing products, the prices for them, availability of the products, shipping information, RMA information; to send response information for their request.

• Took major part in development of ‘Availability’ Inbound Transaction. This transaction provides a request for information on the current stock available for an item, the quantities that are coming into Westcon inventory, their estimated arrival dates and an indicator as to whether the item is restricted to the customer making the request.

• Developed ’The Product Catalogue’ which is a standard transaction providing item detail information to customers as part of Westcon’s core electronic data offering. This is a transaction between BizTalk 2006 (BTS06) and MS SQL Server.

• Created a transaction that is used to retrieve ‘Pricing Information’ for products stored in JD Edwards.

Environment: This project is developed in .NET 2.0 framework using BizTalk Server 2006R2, SQL Server 2005 as a back end, and C #.NET for classes’ development.

01/2007-04/2007 KPMG LLC, Montvale, NJ

Senior Associate (Contract)

• As a part of a team, developed the Pursuit Resource Center (PRC), which is an internal web application created to support the Proposal Team in creating well-written, accurate, and compelling proposals. PRC will be used to create, track, edit, and approve information used in proposals. This information will be reviewed by DPP and an editor prior to releasing the information for use within proposals. In addition, this information (called content from this point forward) will be reviewed on a scheduled basis to assure continuing accuracy and relevance. A user will chose sections that are important to the proposal. The user will then choose supporting information for each section called content. The user can also enter any specific questions that need to be addressed and assign appropriate content that answers the question. Then user will modify and approve the outline of the document. Lastly, the team will produce 1 or more documents in formats such as Word and, in the future, PowerPoint.

• In the presentation layer, I was responsible for creation of Admin pages that allow Web Site Administrator to view user information, make necessary changes to user information, and assign the rules for the users.

• Participated in design and development of SQL Server Database

• Created technical documentation for Business Objects using NDoc

Environment: The project is developed in .NET 2.0 Framework using ASP.NET, JavaScript and AJAX for the presentation layer and C#.NET for classes’ development and code behind pages. It utilizes ADO.NET object with various SQL stored procedures to manipulate data.

03/2006 – 01/2007 Interpublic Group of Companies, New York, NY

Back Office/ BizTalk Developer (Contract)

• Was involved in development and support of the company’s Business Office Applications involving employee benefits

• Participated in development of the company’s Intranet using ASP.NET and C# solution on a SQL Server back-end.

• Developed maintenance application in ASP.NET and ADO.NET that helped users to enter, update and delete data.

• Creation of schemas using BizTalk flat-file extensions and development of a pipeline component to parse SAP IDOC flat files into XML format

• Development of maps using the BizTalk Mapper and XSLT to transform documents

• Used C# (aka C sharp) in the scripting functoids to support necessary logic

• Use functoids to handle complex data conversion.

• Creation of orchestrations to support business logic, to route and transform documents

• Creation of BizTalk business rules in order to enhance performance.

• Developed Media interfaces that handle financial information from the various Media systems. The Media Systems are legacy systems within IPG that handle media-related information. The interfaces integrate the information in the media system with the SAP environment.

• Created ‘Media Preprocess Validate Interface’ that is responsible for receiving files from the client; ‘Media Preprocess Validate Interfaces’ that require interaction with users that validate data using validation web page; ‘Media preprocess Validate Restage Interface’ which is responsible for correction of wrong user input; ‘Media Interface’ that is responsible for data mapping between SAP master tables and data from the client; ‘Media log Process interface’ is attached to interface reprocessing web page which should be used by a user after correction of mapping; ‘FB01 Interface’ which is responsible for posting of output of the data to SAP.

• Wrote technical documentation

Environment: These projects are developed in .NET 2.0 framework, BizTalk Server 2006R2, SQL Server 2005 as a back end, ASP.NET and C #.NET.

08/2005 - 03/2006 Sumitrans Corporation, Long Island, NY

Programmer

• As a part of a team, developed the Sumitrans Corporation’s Intranet using ASP.NET and VB.NET solution on a SQL Server 2000 back-end

• Developed web control that allowed setting a blackout date using ASP.NET

• Created dynamic photo-album that displays database drive pictures on a page using ASP.NET and stored procedures developed in SQL Server 2000

• Developed data validation/mapping process that allows productively update majority of the source data leaving the fewer part for manual address format through web-based Portal interface.

• Developed component using Visual Basic 6 and SQL Server 2000 which creates a flat file and sends this file via FTP to a destination.

• Took part in design and development of BizTalk-based subsystem that exchanged shipment

information between Sumitrans and company’s clients. The BizTalk system exchanged flat

EDI file with our partners, and converted these to and from common XML documents which

were exchanged with clients’ management applications.

• Prepared project documentation using Microsoft Visio.

12/2002 – 08/2005 Maxim Capital Enterprises Ind., Brooklyn, NY

Programmer/Analyst

• Developed the application that collects automobile prices from data sources such as NADA, Blackbook, and GoldBook as well as collateral quality factor, maximum

Capitalization and loan-to –value ration factors to form the basis of a comprehensive auto loan evaluation system.

Environment: This project is developed in VB.NET and SQL Server as a backend. It utilizes ADO.NET object with various SQL statements to manipulate data.

• Designed and developed application that captures auto-loan applicant information and does

preliminary underwriting. As soon as application for a loan submitted to APPRO (software

package used to assess credit risk), the ‘Pre-Bureau Decline’ and ‘Risk Processor’ modules

credit bureau reports are assembled and electronically presented to the Credit Analyst for evaluation. Documents are stored in an imaging system (Keyfile)

• On the front end, was responsible for creating interfaces that provide loan application information.

• In the middle tier, created MCE.DLL: this component is a database access layer, which

incorporates underwriting logic and error proof modules.

• Took major part in design and implementation of a relational database.

• Created MCE Parser.dll that parses data from the database to flat file format.

Environment: This object-oriented system is developed in Visual Basic and SQL Server.

It utilizes ADO object with various SQL statements to manipulate data, uses API functions and

COM object. Stored procedures were created to enforce business rules and to maintain data integrity.

06/2001 - 12/2002 ClIO & Associates Corp., Staten Island, NY

Client: J.P.Morgan, New York, NY

Programmer/Analyst- Consultant

• As a part of a team, participated in design, development and implementation of Client and Product Revenue Information System.

• Took major part in developing an Adjustment area of this system. The Adjustment area provides an efficient, streamlined, user-friendly adjustment facility for making corrections to the revenue balances.

• All adjustments are subject to the edit/validation criteria.

• The Adjust Function allows manually enter adjustments to records that have been submitted

And reside in the system. Adjustments can be made to accommodate changes to any of the data elements that define a record.

• Provided program documentation.

Environment: This is a multi-user object-oriented system developed in Visual Basic and SQL Server.

System utilizes RDO object with various SQL statements to manipulate data, uses API

functions, ActiveX custom controls, OLE Automation as well as Crystal Reports tool. Stored

procedures and triggers were created to enforce business rules and to maintain data integrity.

Client: AT&T, Somerset, NJ

Programmer/Analyst-Consultant

• Worked on design, development and implementation of Project Management Tracking

System (PMTS), which is a planning tool that helps Managers control multiple projects and

resources.

• PMTS allows viewing and updating information about employees and projects.

• With PMTS, manager can analyze the status of his projects using a common database, and then share that information with other managers in the district.

• Ad-hoc reports can be generated from the application on the existing data at any point of time.

Environment: This system is developed in Visual Basic and MS Access. Created user documentation

03/2000 -06/2001 Long Beach Acceptance Corp., Paramus, NJ

Programmer/Analyst – Web Developer

• Worked on design and development of LBAC (one of the leading providers of automobile financing to the ‘non-prime’ credit market) Web site, which will be accessible to orphan Dealers, to Dealers with Internet access and to LBAC employees entering applications, either remotely or on – site.

• The Dealers will also be able to see and print the latest forms required for entry into the LBAC Indirect Dealer program, review the status of their loans, automatically receive e-mails when the loan status changes, check on recent LBAC news, e-mail questions and enter registration information if they are new to LBAC.

• Took major part in the development of front end, middle tier and back end areas of the project.

• On the front end, was responsible for creation interfaces that provide loan application information.

• In the middle tier, created LBAC.dll component, which is the main database access layer for the application.

• Most of the objects in this component are used by other parts of the system, mostly ASP files,

to do such tasks as inserting and updating loan records.

• Created the UTFParser (also known as the “Parsing Engine”) – the main engine for interpreting output from the web site to the proprietary UTF1 format used by the Exchange Server system.

• MTS - transactions are used throughout the system, as a further safeguard of system integrity. Implemented the stored procedures for the MS SQL Server 7.0 database.

Environment: This object – oriented system is developed in Visual Basic, ASP, HTML, Java Script

and SQL Server. It utilizes ADO object with various SQL statements to manipulate data, uses API functions and COM objects. Stored procedures were created to enforce business rules and to maintain

data integrity.

EDUCATION:

09/94 – 07/99 Belarusian Polytechnic Institute, Minsk, Belarus

Degree: BS in Computer Science

REFERENCES:

Will be furnished upon request.

Contact this candidate