| OBJECTIVE: | To obtain a programmer/developer position with a reliable company that will allow me to use my skills and knowledge to full extent for the benefit of the employer as well as provide myself with perspective for career development and advancement. | | PROGRAMMING LANGUAGES AND TECHNIQUES: | VB.NET, ADO.NET, ASP.NET, VB 6, ASP, MSOffice Visual Basic for Applications (VBA), VBScript and JavaScript, XML, HTML/DHTML and CSS hardcoding, PHP. Some Java, Perl and C++ experience. | | DATABASES AND REPORTING TOOLS: | MS SQL 7/2000, MS Access 97/2000/XP and mySQL databases, Crystal Reports 8.5 | | OPERATING SYSTEMS | All Microsoft operating systems: MS-DOS, Windows 3.1/3.11/NT 3.51/NT 4.0/95/98/2000/XP. Familiar with with CentOS, Knoppix and Ubuntu.
| | OTHER PROGRAMS, TOOLS AND SYSTEMS | Apache Web Server, IIS 5.0/6.0, Adobe Photoshop, Adobe ImageReady, Dreamweaver MX |
| RELEVANT EXPERIENCE | 03/2004 - present: Database Developer/VB.NET developer
Pfizer Inc., New York, NY
- Performing analysis of existing system’s efficiency and suggesting improved ways to report on existing data.
- Designing and implementing web application (developed in ASP.NET/VB.NET with MS SQL 2000 on the back end) to produce user-customizable reports based on detailed financial and accounting data available.
- Designing and developing (using VB.NET) a server component for uploading non-scheduled data feeds and data feeds that did not conform to assigned standards to assure the database contained as much data as possible.
- Reviewing and suggesting updates to existing data feeds, suggesting improved ways to integrate various data feeds into single data warehouse.
- Developing routines to cross-match variations of vendor name to single vendor, improving report outcomes.
- Creating relationships between data tables, SQL queries and stored procedures for the purpose of retrieving necessary information.
- Designing load-triggered stored procedures and routines to ensure conformance to company policies.
- Preparing high-level data requirements for upgrading current project to company-wide analysis and reporting tool.
- Participating in decision-making on projects goals, timeline and milestones, producing CBT and printed manuals on software features, hosting training sessions with business analysts and project managers.
- Participating in decision-making sessions with business analysts and project managers on implementation of next versions of other in-house software packages to maintain compatibility with existing reporting tools.
| 09/2003 - 12/2003: Database Developer/Administrator
New York Life Insurance, New York , NY
- Developed Corporate Travel Department (CSD) project using MS Access 2000, VBA and Crystal Reports 8.5.
- Rewrote database code to improve stability and data consistency.
- Redesigned data tables, designed various reports in order to meet clients’ needs.
- Developed data consistency checks procedures, data restoration procedures and back up.
- Trained users showing them how to assure data consistency during entry.
- Managed Access database, performed maintenance on database use procedures to check for data integrity.
| 10/2001 - 06/2003: Programmer/Analyst
Alexandra Investment Management, New York , NY
- Developed, deployed and supported software project for Standard & Poors CompuStat data feed.
- Worked on several components including scheduled daily ftp download and unzipping data feed files, parsing received files (both in ASCII and XML format), uploading parsed data into MS SQL 2000 database, creating and e-mailing reports. Developed using VB.NET, ADO.NET and SQL stored procedures with ASP.NET programming.
- Worked with third-party .NET components providing complete data universe for numerous in-house projects including Bankruptcy Prediction System and Pricing Warehouse
- Fully developed and deployed portfolio monitoring system with live feed from Bloomberg BBCOM component.
- Worked with GUI front end with live data for portfolio instruments displayed in real time as well as separate class for acquiring data from Bloomberg BBCOM component in a real time. System created using VB 6 and Crystal Reports 8.5 with MS Access database on the back end.
- Implemented System on traders' and analysts workstations eliminating the need of manually tracking current portfolio as well as watched stock
- Participated in development of pricing warehouse for company. Responsibilities included developing parsers for data submitted by different brokers in a form of Excel, XML, CSV and PDF files eliminating the need to manually process given files on a day to day basis.
- Developed project's admin interface; designed and implemented XML configuration files; created and analyzed logs. Software was created using VB.NET, MS SQL 2000 and stored procedure, code was managed using MS Visual SourceSafe.
- Developed P&L analysis system, to analyze and report P&L based on different schemas. The system was built as a group of VBA macros in Excel spreadsheet with MS Access 97 database on the backend. System allowed business analysts and traders to see the performance of managed portfolio
- Developed dedicated backup solution using VB 6 for traders' data files allowing them to keep track of the changes to the portfolio as well as have immediate access to portfolio snapshots for any past date.
- Created and deployed numerous VBA macros, functions and tools for Excel, Access and Outlook to relieve traders and analysts of routine tasks, consulted users on MS Office VBA programming, helped develop custom solutions for day-to-day issues.
- Extended functionality of main in-house portfolio management application by creating various components, classes, queries and reports using VB 6, VBA and MS Access increasing traders' and analysts' productivity and reducing average workload
- Managed inventory database for all in-house computer equipment, generated various reports, tracked hardware changes and upgrades, assisted and recommended purchases of software and hardware.
- Assisted end-users on trading desk, acted as a liaison between development group and end-users.
| 11/1998 - 03/2001 - Developer/Consultant/PC Technician
System 2000, Co., Brooklyn , NY
(Clients worked for: ING Barings, Deutsche Bank, Wyckoff Heights Medical Center, "Line of Ariadna" psychological support phone service, AAS Exclusive Tax, performing artists groups, real-estate offices, various small business and non-for-profit organizations, home-based businesses)
- Participated in Web development, maintained different company web sites using ASP, PHP, FrontPage, DreamWeaver and HomeSite (DHTML, CSS, JavaScript, and VBScript). Created database driven web sites using ASP with MS Access as the back end.
- Designed and developed MS Access databases for different kinds of businesses. Designed reports by different clients' specifications using MS Access Basic (including inventory database, real estate database, employee database, clients database, documents database)
- Created automatic procedures using VBA to interchange data between Excel, Access and pure text files for later transmission over modem/Internet which reduced processing time by over 70% and eliminated possibility of user-introduced errors.
- Created inventory database using Access that exports stock reports to Excel and accepts data from Excel worksheet using VBA macros.
- Provided client software and hardware support and troubleshooting, LAN administration and network support in mixed Windows95/98/NT/2000 and Novell Netware environment, worked together with the clients to develop custom solutions for their specific needs.
- Set up different networking equipment (network cards, hubs, routers, printers, wiring).
- Led groups of 2 to 4 members working on different projects: helpdesk, PC support, Y2K and software rollouts, and computer assembly.
- Designed and developed custom database solution for psychological phone help service using Visual Basic 6.0, SQL, Crystal Reports and Access database (created tables, SQL queries, relationships, designed forms and reports) that led to increased customer satisfaction and decrease of organization's processing costs.
- Migrated data from old databases (Paradox, dBase, FoxPro) to Access 97/2000. Recreated reports using built-in Access reports and/or Crystal Reports, successfully increasing efficiency by 40%, capacity of system by 600% and reducing system's average response time.
| 1/1998 - 11/1998: Programmer
BioLab Testing Laboratory., Brooklyn , NY
- Designed and developed software package for blood examination laboratory to analyze blood samples by their optical refraction.
- Researched and developed specific mathematical analysis methods to complete the project reducing average calculation time by 400%.
- Created libraries (reusable components) for researched methods and calculations part of the project to reuse it during further product development on different platforms (Windows 3.1, Win32, Linux).
- Developed copy protection portion of the project using C++ and Assembler that yielded 30% of increase in sales.
| 06/1995 - 12/1997: Database Programmer
World-Link, Inc., New York , NY
- Designed, developed, and implemented software to keep track and price phone calls made through the phone company using MS Access 2.0 Database and Visual Basic for Applications in MS Windows 3.11, reducing processing cost.
- Provided database maintenance and troubleshooting to ensure database consistency and error-free records.
| | | | EDUCATION | 2004 - current - Courses in Computer Science - Baruch College, New York , NY
Major: Bachelor of Science in Computer Sciences | 1999 - 2002 - Courses in Computer Science - Pace University
New York , NY | 1991 - 1993 - Associate Degree - Kharkov State University
Kharkov , Ukraine
Major: Radio physics and Electronics | | | OTHER SKILLS:
Project management, technical writing, data migration.
Fluent in languages: English, Russian, Ukrainian. | |