SUMMARY

ASP.NET / VB.NET Developer with project management and outsourced team leading experience. Experienced in full software development lifecycle (SDLC), agile development, project management, data feeds, back end development, front end interfaces and usability; taking over outsourced and incomplete projects and finalizing them on tight deadlines. Possess excellent verbal and written communication skills with business users and managers of all tiers, capable of producing full technical documentation and specs as well as designing complex information systems.

SOFTWARE, APPLICATIONS and TOOLS

VB.NET, ADO.NET, ASP.NET, AJAX, PHP 4, VB 6, Office Visual Basic for Applications (VBA), JavaScript.
XML, HTML/DHTML, CSS, MS SQL 2000, MS Access 2000/XP, mySQL databases, Crystal Reports.
MS Project, Windows/IIS and Linux, Apache, mySQL, PHP, (LAMP) platform.

EXPERIENCE

SENIOR WEB PROJECTS MANAGER / TEAM LEADER

Zealus Web Design Studio, Brooklyn, NY
2005 – current

• Gathering requirements from clients and writing technical specifications for working teams
• Managing web projects’ progress on an ongoing basis, including pre-launch and after-launch support and maintenance
• Responsible for distribution of resources among various projects, including outsourced development and design teams
• Participating in clients’ strategic promotional and technology decision-making
• Responsible for pre-sales and post-sales negotiations with clients, leading sales and training sessions
• Responsible for post-production project support and development
• Design and implement web site features using PHP 4.x, mySQL database, styling sheets (CSS), image editing software (Photoshop, Paint.NET, Gimp)
• Overseeing company’s own PR and customer service

ASP.NET / VB.NET / MS SQL DATABASE DEVELOPER

Healthfirst, New York, NY
04/2008 – current

• Maintained multiple in-house applications written in vast range of technologies from VB.NET/ASP.NET based on .NET framework 2.0 to VB 6 and classic ASP. Developed additional features and extended functionality for existing projects.
• Maintained multiple database projects, including projects cross-feeding from MS SQL 2000/2005 and IBM iSeries (AS/400).
• Maintained company’s public web sites for NY and NJ (JavaScript, HTML, Adobe Photoshop)
• Worked with multiple business users across several departments to coordinate and finalize business requirements for designed software
• Produced functional specifications documents for each major release of maintained software

VB.NET / ASP.NET / SQL PROGRAMMER

Pfizer, New York, NY
03/2004 – 04/2008

• Performing analysis of existing system’s efficiency and suggesting improved ways to report on existing data
• Designing and implementing spend reporting web application (developed in ASP.NET/VB.NET with MS SQL 2000 on the back end) to provide upper management with user-customizable reports based on detailed accounting (Accounts Payable/General Ledger) data available
• Enhancing existing functionality with additional features, such as reports export to Excel/Access, ability to save and reuse reports, tracking application usage, common Pfizer login
• Designed and developed (using VB.NET) a server component plus set of MS SQL stored procedures for uploading data feeds and prepare data for use in reports
• 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
• 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

DATABASE DEVELOPER / ADMINISTRATOR

New York Life Insurance, New York, NY
09/2003 – 12/2003

• 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

VB / VB.NET PROGRAMMER/ANALYST

Alexandra Investment Management, New York, NY
10/2001 – 06/2003

• Developed, deployed and supported software project for Standard & Poor’s CompuStat data feed as a part of development of company’s Pricing Warehouse and Bankruptcy Prediction System. Developed custom parsers for data submitted by different brokers in a form of Excel, XML, CSV and PDF files. Developed and deployed components for scheduled daily ftp download of feed files, parsing XML into MS SQL 2000 database, creating and e-mailing reports. Developed using VB.NET, ADO.NET and SQL stored procedures
• Fully developed and deployed portfolio monitoring system with live feed from Bloomberg BBCOM component, created GUI front end to display instruments dynamics in real time acquiring data from Bloomberg BBCOM component. System created using VB 6, MS Access and Crystal Reports 8.5
• Implemented System on traders’ and analysts workstations eliminating the need of manually tracking current portfolio as well as watched stock, implemented project’s admin interface; software was created using XML, VB.NET, MS SQL 2000 and stored procedures; 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 existing Access 97 database on the backend
• 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

DEVELOPER / CONSULTANT / PC TECHNICIAN

System 2000, Co., Brooklyn, NY
11/1998 – 03/2001
(Clients include: ING Barings, Deutsche Bank, small businesses)

• Participated in Web development, maintained different company web sites using ASP, PHP, FrontPage, DHTML, CSS and JavaScript. Created database driven web sites using ASP with MS Access as the back end
• Designed and developed custom database solution for psychological phone help service using Visual Basic 6.0, Crystal Reports and Access database
• 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)
• Assisted in database migration from FoxPro/dBase to MS Access. Created automatic procedures using VBA to interchange data between Excel, Access and pure text files for transmission over modem/Internet
• Provided client software and hardware support and troubleshooting, LAN deployment, equipment setup, 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
• Led and mentored groups of 2 to 4 members working on different projects: helpdesk support, PC support, Y2K and software rollouts, and computer assembly, assisted managers and senior members with distributing tasks

DOS / WINDOWS PROGRAMMER

BioLab Testing Laboratory, Brooklyn, NY
1/1998 – 11/1998

• 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 (DOS, Windows 3.1, Win32, Linux)

MS ACCESS PROGRAMMER

World-Link, Inc., New York, NY
06/1995 – 12/1997

• Designed, developed, and implemented software to keep track and price phone calls made through the phone company using MS Access Database and Visual Basic for Applications in MS Windows 3.11
• Created and produced reports using MS Access to provide company’s management with an overview of various time and customer based usage patterns

EDUCATION

2007 – current – BA in Entrepreneurial Management, Baruch College, CUNY, New York, NY
2004 – 2006 – Courses in Computer Science, Baruch College, CUNY, New York, NY
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