programmer/analyst
Resume:
IGOR ZILBER
Brooklyn, NY 11235
Home :347-***-****
Cell :646-***-****
**********@*****.***
OBJECTIVE: To obtain a position as a Programmer/Analyst to fully utilize my 14 years experience in Data Analysis including 7 years development in Visual Basic and Relational Databases and 7 years of SAGE Sales Logix CRM development.
SOFTWARE:
OS: MS Windows 3.X/95/98/00, MS Windows NT 3.5/4.0, UNIX 4
Languages: MS Visual Basic 3.0/4.0/5.0/6.0, MS Access 2.0/7.0, C/C++, COBOL, Pascal,
Databases: MS SQL Server 6.0/6.5/7.0, SYBASE 10/11, DB/2
Internet Tools: HTML, DHTML, CSS, VBScript, JavaScript, MS IIS 4
Tools: ActiveX/COM/DCOM, DAO/RDO/ADO, Win32 API, OPOS-2, Crystal Report, Business Objects 4.1, SalesLogix 5.0/5.2 /6.2/7.2/7.5 (SLX)
EXPERIENCE:
ACS Commercial Solutions, New York, NY 03/2003 - 11/2008
Senior Programmer
Collaborated with Product Managers and Account Managers to debug, develop and enhance existing and new software for CRM (Customer Relationship Management) systems designed to support financial services industry, specifically Mutual Funds sector by providing contact management and sales tracking. Developed User Interfaces screens, data management, and codes designed to receive and import data from third party sources and post to proprietary sales tracking systems. Provided clients with technical support and application service.
Projects are implemented with Sales Logix language functionality, Visual Basic 6.X, Crystal Reports 8.0,8,5, ASP, Java Script and SQL Server 7.0/2000,XML.
• Deploymenrt of various enhancements to Sales Logix CRM application using Sales Logix Visual Basic Scripts, SDK and DLL, Visual Basic 6.X
• Database maitenece, support and modifications including development of tables, views and stored procedures
• Development of technical specifications, test plans and deployment methods
• Data transfer and manipulation from Excel spread sheet to the SLX front end within Sales Logix functionality
• Daily data monitoring, grouping and reporting per user specifications using SLX tools and query analyzer
• Daily data import utilizing XML program
• Data export to the AS400 sales tracking system
• Complex Stored Procedure programming and testing for the reporting needs using Crystal Report as a front-end
Micromuse Inc., New York, NY 03/2001 - 11/2002
Senior Programmer
Database administration and end-user support, front-end design and report generation to support company sales force and marketing needs. Custom application development and data analysis.
Projects are implemented with Sales Logix Basic language functionality, Visual Basic 6.X, Crystal Reports 8.0,8,5, ASP, Java Script and SQL Server 7.0/2000.
• Deployment of custom functionality to Sales Logix CRM application using Sales Logix Basic scripts functions, SDK and DLL, Visual Basic 6.X.
• Reports design using Sales Logix IQ reporting tool, Crystal Report and MS Excel.
• WEB based reporting site development and maintenance using reporting tools such as Crystal Reports, SQL Server, ASP and Java Scripts languages.
• Complex Stored Procedure programming and testing using Crystal Report as a front-end.
• Program and test triggers for data flow monitoring.
• MS Excel application for products price quotation purposes.
Weekly Reader Corporation, Stamford, CT 01/2000 - 03/2001
Programmer/Analyst
Performed day-to-day administration and programming to support marketing and company IT application needs. Developed front-end user interface for data manipulation such as selections by user given criteria, updates and inserts of two databases simultaneously.
Projects are implemented with MS Visual Basic 6.X, MS SQL Server 6.5 and Business Objects 4.1
• Program and test SQL stored procedures, formatlistcountreports, pullselectednames and deliver promotion files to appropriate vendors
• Handle workstation setup and software installs.
• Generate post Campaign reports and Response Reports based on marketing specifications
• Ensure proper functioning of database
• Develop programming solutions for business applications using VB 6.0 & Access
• Program and test SQL stored procedures and format reports using
• Business Objects 4.1 report tool
• Transferring data from MS SQL Server database to data file in a user specified format using BCP utilities
• Keep abreast of latest hardware and software development IT
• Participate in conversion from SQL 6.5 to SQL 7.X
Consultant Positions 05/1999 - 12/1999
World Copy, New York, NY, Vicom Computer Services Inc., Farmingdale, NY
Projects were implemented using VB 6.X and Text Database
• Developed an application to work with Excel files, read and write, format files by the client request and prepare them to the delivery.
• Developed reports for the existing DOS based inventory system by importing text files in to MS Access and creating reports using MS Crystal Report Writer. Tested and modified an existing VB project that printed reports in the different formats using VB 6.X and MS Crystal Report Writer. Created HTML pages for the existing WEB project, incorporating VBScript.
GEAC Computers Inc., Paramus, NJ 07/1997 03/1999
Programmer/Analyst
Developed the POS system designed for full service hotel systems and restaurants.,,providing users with an ability to make information request, build their own screens, manage remote printers, print business management reports, and produce calculations.
Project has been implemented with MS Visual Basic 5.0 and MS SQL Server 6.5.
• Participated in user requirement analysis, creation of prototypes and interaction with users
• Designed front end user interface for data manipulation based on GUI standard utilizing advanced features of third party controls and touch screen technology
• Designed Database structure including development of tables, views, stored procedures and triggers
• Developed module for supporting touch screen technologies and credit card interface
• Designed remote printer management tool using Windows API, ActiveX and DCOM technology
CSG, Lawrenceville, NJ 03/1995 07/1997
Programmer/Analyst
Projects implemented with MS Visual Basic 3.0, MS Access 1.1, and SYBASE 10 MS Visual Basic 4.0 and MS SQL Server 6.0/6.5
• Participated in development of a Brokerage Application, which provided managers and analysts with information about Mutual Funds performance, produced Financial Calculations and generated Reports. This application imported daily information from the mainframe system, and provided conversion to SQL Server database. It also enabled users to maintain History Data and run reports.
• Participated in the design and development of a Legal Office Management System. The System consists of data collection and reporting on matters related to Clients and their Cases. Daily tracking of Pertinent Dates, Costs, Revenue, Matters, Billing Information and Accounts Receivable.
EDUCATION:
03/2007 SAGE Software
Introduction to Developing Sage CRM Sales Logix V7.0
08/1996 09/1996 Calc Canterbury
Programming in Microsoft VB 4.0
09/1983 06/1988 Kiev State College of Transport Communication, Kiev, Ukraine
BS in Information Systems
REFERENCES: Available upon requests.
Contact this candidate