MGZ NETART

Software Development and Support

Home
Our Company and Products
C# Examples
MRDS Examples
Resume
Contact Us


GENNADIY ZARETSKIY
ph.  (732) 705-1713
zaretskiy@MGZNet.com
                                                     
 
SOFTWARE:  C#, VB.NET, ASP.NET, Microsoft CCR and DSS Toolkit 2008, JavaScript,  ASP, HTML/DHTML, XML, T-SQL, PL/SQL , 3-rd party controls: FarPoint, Bloomberg APIs, Apex (TrueDBGrid), FTP control, Northwoods GoDiagram controls
MS SQL SERVER 2000, ORACLE 9i, 10g, MS ACCESS 2000, PostgreSQL, Adobe Designer 7.0
Crystal Report 8.0, InstallShield 6.1.
WINDOWS XP/2000/NT

EXPERIENCE:
MGZ NetART, Morganville, NJ    10/2000 – current
President
Custom software development.

Bristol-Myers Squibb
, Lawrenceville, NJ    12/2008 – current
Consultant
•    Responsible for full cycle design, development and distribution of Petri Net Designer. Application allows users to create a Petri Net diagram with ability to provide custom code for each created object on the diagram.  Application utilized C# Win Forms, and Graphical User Interface was developed base on GoDiagram third party controls.
•    In order to provide an ability for users dynamically modify custom code during execution separate class library been created utilizing Reflection namespace, and allows to load and unload separate Application Domains on the fly.
•    Application allows users to create, modify and store model as xml files, as well as save it in to the Oracle database.
•    Responsible for full cycle design, development and distribution of PetriNet Service Application. Application utilized Microsoft CCR and DSS Toolkit 2008. Application includes several modules: Petri Net Server, Petri Net Dispatcher, Transition servers and Instrument Servers.
•    The development process adopted Agile and SCRUM methodologies.
Software and tools: MS VS 2008, C#, ASP.NET, Oracle 10g
 
Lumeta, Somerset, NJ    05/2008 – 10/2008
Lead Software Engineer
•    Leadership responsibilities for development support of MapViewer Application. MapViewer is a WinForm C# application and was developed to support online and offline modes for network data analyses. To represent the data Infragistic grid.
•    Application retrieves the data from Java Application and Tomcat Service. MapViewer communicates with web service through SOAP messages. To increase the usability each service request was implemented in a separate thread.
•    Responsible for coordination of C# development team effort. The development process adopted Agile and SCRUM methodology, including a 90 days development cycle (Sprint), and daily development meetings to coordinate the activities of different development groups.

NBA, Secaucus, NJ 06/2007 – 03/2008
Consultant
• Responsible for full cycle design, development and distribution of FTP Transfer application. Application allows user to copy file from FTP site base on configuration stored in Sybase database. Application utilized C#, Sybase database.
• Responsible for full cycle design, development and distribution of Sore Bug application utilizing VB6, ClientDLL.dll, Lyric software. Application retrieves information from All stats and Arena feeds and transfer it to Lyric screen to show score and news on TV screen.
• Responsible for maintenance and support Player Information Contract Statistics (PICS). Application allows user to select players by different criteria’s. Application utilized ASP.NET JavaScript and C# as a front end and Sybase database as a back end.
Software and tools: MS VS 2003, 2005, C#, ASP.NET, VB.NET, DBArtisan 7.2.1, ADO.NET, T-SQL, UML, MS Visual Modeler.

Galleon Group, New York, NY 06/2007 – 10/2007
Consultant (Part Time)
• Responsible for full cycle design, development and distribution of reconciliation application for a hedge fund.
• Application performs calculation of P&L data on daily bases for all listed Portfolios and reconciles reporting results between Account Administrative and Internal Systems report.
Software and tools: VB.NET (MS VS 2005), ADO.NET, MS SQL 2005, T-SQL, DTS, UML, MS Visual Modeler, FarPoint Spread.

Stryker, Mahwah, NJ 03/2003 – 05/2007
Tech Lead/Project Lead
• Project leader responsibilities for the GUI, middle tier, and database design and implementation of Attendance application. Application utilized VB.NET as a front end (Windows forms) VB.NET and T-SQL as a Middle tier and MS SQL as a back end database.
• Technical leader responsibilities for data migration from SAS files and SQL databases to the Oracle 10g database. Application utilized SQL DTS packages, views and stored procedures for formatting and extracting data, and SAS reports for validation.
• Responsible for full development cycle of data entry modules for EDC application for remote users, utilizing ASP.NET, JavaScript, HTML, XML, SQL, Adobe pages.
• Design and implementation of EDC trial application for surgeon-run studies. Application utilized ASP.NET, JavaScript, HTML (Web forms), C# as a Middle tier, and SQL 2000 as a back end.
• Responsibilities for production support, database administration of existing applications in VB6 and MS SQL 2000 Database. Project planning for the future releases and enhancements.
• Responsible for full cycle development for numerous enhancements for existing Clinical Data Capture application, such as Reimbursement, Audit Trail, Electronic and Manual data clarifications. Application utilized stored procedures, triggers and DTS packages on MS SQL 2000, VB6 as a front end, Crystal Report 8.0.
• Responsible for technical evaluation of numerous EDC applications.
• Responsible for installation and technical support of all business application of Clinical Department.
Software and tools: VB.NET, ASP.NET, JavaScript, C#, ADO.NET, VB 6.0, MS SQL 2000, Oracle 10g, T-SQL, DTS, UML, MS Visual Modeler, FarPoint Spread, COM/DCOM, Adobe Designer 7.0.

Brencourt Advisors, New York, NY 09/2001 – 01/2003
Sr. Associate
• Responsibilities for full cycle development, distribution, and production support of Inventory System applications for hedge fund. Applications analyze Equities, Fixed Income Securities, Options, Payables and Receivables, Other Derivatives, Cash, etc. Applications provide tools to review P&L attributions for Merger/Distressed Arbitrage teams.
• Development of Windows Service and Console applications for GICS data migration. Application transfers CSV and XML files from FTP sites to the local network, and then to the database. Application utilized VB.NET and MS SQL 2000. Connection to the database was implemented as a DLL class library.
• Development of “Reconciliation” application in VB6, which allows users to copy information from different counter parties and prime brokers (Morgan Stanley and Citco) through FTP protocol or via e-mail. File exchange process utilizes PGP coding-decoding technique.
• Development of “Accounting” application utilizing ASP (VBScript and JavaScript) as a presentation layer, and VB6 for middle-tier components.
• Responsibilities for production support of existing applications and MS SQL Database (DBA).
Software and tools: VB.NET, VB 6.0, ASP.NET, ADO.NET, JavaScript, MS SQL 2000, T-SQL, UML, MS Visual Modeler, FarPoint Spread, Mabry's FTP/X control, Bloomberg APIs, COM/DCOM, PGP.

IBM, New York, NY 10/2000 – 06/2001
Consultant
• Design GUI, COM and database structure for “Bridge Inventory” and “Bridge Maintenance” Systems (NYC DOT). Application utilizes Visual Basic 6.0 as a front end and SQL 7.0, MS Access, dBase and MS Excel as a back end.
• Development of front-end (VB 6), middle- (COM), and back-end tiers for “Tracking” application.
• Development of “Engineering” application on ASP, with ability to retrieve and modify data from MS SQL 7 database. Application utilized MTS objects as a Middle-tier layer.
• Responsibilities for deployment and distribution of applications utilizing InstallShield.
Software and tools: VB 6.0, ASP, SQL 7.0, dBase, MS Access, MS Excel, T-SQL, COM/DCOM, COM+, InstallShield, FarPoint Spread, Sheridan ActiveResizer.

Intercounty Clearance, New York, NY 10/1999 – 10/2000
Consultant
• Responsibilities for the full cycle development of “PowerLegal” business applications. Application provides online access to public records (UCC and related lien records) nationwide, and provides tools to retrieve and file documents.
• Design and development of middle-tier DLL application to establish connection, and to represent data from various types of databases: MS Access, MS SQL 7, and Oracle 8.
• Development of ActiveX controls to encapsulate common routines for front-end application.
• Migration of data from MS Access to MS SQL 7. Designed database schemas.
Software and tools: VB 6, ASP, MS Access 97/2000, SQL 7.0, T-SQL, MTS, 3-rd party OCX: Apex TrueDB Grid, VideoSoft, COM/DCOM, API functions, Deployment Wizard, Connex, VaxBasic.

Photronics, Brookfield, CT 07/1998 – 10/1999
Sr. Programmer Analyst
• Development of a Business Applications on Visual Basic 6.0/5.0, for equipment data maintenance. The application utilizes InProcess Server DLL to establish connection and represent business objects collections.
• 24-hour production support of “MASKTRAC” business application
• Development and maintenance of views, functions and procedures on PL/SQL.
• Development of business reports with Crystal Report 4, utilizing Web Component Server.
Software and tools: VB 5/6, ORACLE 8, Crystal Report, PL/SQL, 3-rd party OCX: Apex TrueDBGrid, Sheridan controls, COM/DCOM, API functions, Oracle Plus.

Prodigy Services Company, Yorktown Heights, NY 05/1996 – 07/1998
Consultant
• Responsibilities for full life cycle development of Business/Financial Applications on VB 5.0/4.0. Applications provide users with an access to the news and financial data for all of the New York Stock Exchange listed companies, with capabilities to analyze data offline.
• Development of applications, which retrieve data from DB2, and accumulate market data in to MS Access database.
Software and tools: VB 5.0, MS Access 2/97, DB2, SQL, API functions, and 3-rd party OCX controls.

CERTIFICATES:
03/2003 Microsoft Certified Applications Developer (MCAD)

EDUCATION:
Moscow State Mining University, PhD
Moscow State Mining University, MS in Computer Science