Senior Information Technology professional with over fifteen years of combined technical, project and staff management experience in the areas of full life cycle development and production support of client/server and Web based applications. Experienced with Structured and Object Oriented Technologies. Extensive knowledge of .NET technology, C#, Classic ASP, Visual Basic, Delphi, MS ACCESS, Java, and Web Sphere.

Technical Summary

Operating Systems: Windows XP, NT, 2000, 98, 95, 3.x, UNIX, MS DOS.
Languages, Software, and Tools: C#, VB.NET, ADO.NET, ASP.NET, Visual Basic, Java, ASP, HTML, JavaScript, VB Script, XML, AJAX, LINQ, Delphi, Web Sphere, PowerBuilder, Transact-SQL, PL-SQL, C, C++, Visual C++, Windows SDK, MFC, COM, Crystal Reports, Excel, Microsoft Exchange, Microsoft Outlook, Microsoft Project, WinBach, DTS, LEGI for Windows, Label Matrix, Label View.
Databases: SQL 2000/2005, SQL 7, MS-ACCESS, Oracle, and Paradox.

Professional Experience

Consultant, Confidential, IL 06/2009 to Present

• As a lead developer responsible for full lifecycle development of a secure web site.
• This includes identification of business requirements by interacting with the business, functional specification creation, database design and application architecture, coding, testing, and creation of the documentation.
• The main purpose of the application is to allow paying by credit card for purchases of requested medical records. Requestors are divided in a few groups and provided with user name and password, which allows them to view the list of records based of their user role and hierarchical level in accessing the information. Requestors, whose role allows to purchase the record, can pay by entering credit card information into a secure web form. The payment is forwarded to the credit card company for approval and if approved, the paid record becomes available for download.
• The application keeps track of requestors and internal admin personnel activities and also allows to perform administration functions and maintaining database information.
• The application involves following technologies: ASP.Net 3.5 with C#, XML, AJAX, with the data stored in SQL 2008 database.

Consultant, Confidential, IL02/2008 to 03/2009
Confidential, Chicago, IL

• As a technical lead participated in full lifecycle development of a logging module for the worldwide used PaymentNet secure web site. The application allows setting up hierarchical levels for credit card approvers, creation of new and maintenance of existing credit cards, processing all credit card transactions, creation of a large number of reports, and keeping track of all modifications and changes to the vital user and financial information.
• The logging module is a tracing component of the application designed to keep track of the changes made to the credit card holder’s personal information, their user role, and hierarchical level in accessing information.
• The application is build on following technologies: ASP.Net with C#, Classic ASP, VB6 DLLs with the data stored in SQL2000/2005 database.
• Analyzed, modified and enhanced a large number of existing .Net and ASP web pages, stored procedures utilizing C#, ASP, VB6, T-SQL, vbscript, javascript, AJAX.
• Created a number of monthly reports utilizing Crystal Reports.
• Provided level 3 technical support for production issues. Interacted with the Business and QA staff in determining requirements, business rules and the necessary improvements.

Consultant, New-York, NY03/2007 to 12/2007
Confidential, Northfield, IL

• As a lead developer was responsible for full life cycle development of a secure web site for Security and Controls department. This includes database design, gathering client requirements, analysis, application development, and testing. The purpose of the application is to determine the financial significant rating which in part determines
  whether or not the application should be tested as part of Sarbanes-Oxley initiative.
• The web site consists of three main modules: FSS application; security and user maintenance modules; and database tables maintenance module. The FSS module consists of five web pages and allows tracking application attributes and assesses risk associated with their security controls; entering new application attributes and editing already existing ones; keeping track, add new and edit existing inbound interfacing applications. The security and user maintenance modules provide user authentication and authorization and include login and change password web forms along with the administration page. The database tables maintenance module is another administration tool allowing application administrator(s) working with the underlying tables in order to keep the data current and review the changes made by the users.
• Participated in the design and implementation of SQL Server database.
• Created DTS packages for data transformation.
• Created stored procedures for data storage and data manipulation.
• Technology used: ASP.Net.2.0, ADO.Net, AJAX, and SQL Server 2000.
• Development language C# and Javascript.

Confidential, Northbrook, IL 09/2005 to 12/2006

• Responsible for full life cycle development of a web based application for the Financial and Marketing departments including gathering client requirements, analysis, development and testing. The application consists of the presentation layer developed in ASP.NET with the logical layer implemented in stored procedures.
• Responsible for DTS packages creation for data transformation along with the development of SQL Server stored procedures for Financial and Marketing analysis, including gathering client requirements, analysis, development and testing.
• Tables generated by stored procedures allow presentation of sales data, analysis of performance by different vendors, product initiative results, daily, monthly and yearly comparisons; performance by regions, branches, and areas; sales performance by catalog modules and are used for web presentation.
• Technology used: ASP.Net, ADO.Net, and SQL Server 2000.
• Assigned to the Freight department for restoring the functionality of an earlier created MS Access application.
• The application utilizes data created in SQL Server and linked to MS Access. This includes repairing stored procedures, restoring functionality of Excel charts populated from MS Access, and data analysis in order to recover freight losses. Created a large number of stored procedures for analytical purposes in SQL 2000.

Confidential, Glenview, IL02/2005 to 08/2005
Confidential,

• Acted as an outsourcing project manager and developer for Web based Balance Sheet Review full life cycle application development. The main development team was located in the Philippines along with a smaller number of developers in Chicago.
• Responsible for gathering client requirements, translate them into functional design, coordinate development, testing and final presentation to the user.
• Allocated development recourses overseas and in Chicago, reviewed database layout, detail designs and other documentation, gave technical recommendations and coordinated deployment with other departments and groups in accordance with Accenture processes.
• Hands-on development of .Net applications along with developing system designs, database layout and stored procedures utilizing SQL2000 DB.
• Enhanced existing Asset Management VB6 application by adding new functionality.

Confidential, Rolling Meadows, IL. 03/2004 to 01/2005

• Full life cycle application development of Cross Functional Online secure web site.
• Application allows the analyses and management of Service Requests and Break/Fix processes as implemented by CSC.
• It consists of over 60 password protected web pages and reports residing on different servers. Web pages allow retrieval and presentation of daily activity data in formats based on different search criteria.
• Comments can be added to the database by authorized management personnel for the presentation in reports.
• The technologies utilized are ASP.Net with VB.Net, ASP, Crystal Reports 9, and SQL 2000 database.
• Responsible for modifications of web based Dashboard application. Modifications include creation of a new page for report viewing along with enhancements to the existing ones.
• Developed Monthly View web application. It allows reviewing monthly results in different areas of activity by selecting different criteria.
• Full life cycle application development of Executive Dashboard.
• Application consists of three web pages allowing the management to review company performance in different areas of service. The drilldown approach is used to get from the general to detailed information.
• Technology used: ASP.Net, ADO.Net, SQL Server 2000, and Crystal Reports.
• Developed Daily Results web application allowing analyzing results for the infrastructure service activity.
• All web applications utilize ASP, VBscript, Javascript, ADO and SQL 2000 database.
• Have developed a large number of web-based reports reflecting performance of different areas of business.
• Crystal Reports( version 9) was used as a reporting tool with SQL 2000 database.

Programmer/Analyst Confidential, Northbrook, IL.2003 to 03/2004

• Responsible for design and development of an ASP.NET application for a medical insurance company. The application allows dynamically create payers and sub payers groups, viewing and updating their payment status. Application developed in C#.
• Participated in conversion of an ASP application into ASP.NET. Application developed in VB.NET
• Full life cycle development of a project tracking application for an engineering department.
• It allows assigning unique numbers for new projects in multi-user environment. Developed in Visual Basic 6 with SQL 2000 database.
• Responsible for full life cycle ASP and HTML application development for a law firm.
• Application consists of two web pages incorporated into an existing application. The first page acts as a menu, allowing the user to select property identification number and corresponding tax year.
• The second one is populated with data based on the previous select and allows doing calculations and online comparison analyses. It also allows updating current or inserting new records in SQL database.
• The analyses are used to reduce property taxes.
• VBScript and JavaScript are used for programming client side and server side.

Programmer/Analyst (Project Manager)Confidential, 1998 to 2003

• Responsible for full life cycle development of client/server applications including business analysis and data gathering, database design, functional specification generating, and software development.
• Deployment of the applications, including user training and technical support.
• Full life cycle development of a VB 6 application for tracking weekly performance of the Sales force. The application involves programming Microsoft Outlook 2000 for Meeting generation, Contacts information, and e-mail sending.
• Microsoft Excel is utilized as a data source of Contacts information.
• Microsoft Exchange Server is utilized for retrieving the participants\' Appointment data stored in the Calendar folder in order to obtain the results of their activities. All the data is combined with the Mainframe generated weekly sales result and stored in SQL 2000 database. Stored procedures are used for data manipulation.
• Crystal Reports 8.5 is utilized to produce a reporting document, which is e-mailed by the program to the participants and their managers.
• Full life cycle development of a VB 6 with SQL 2000, SQL 7 database Price Book application. It allows generating Price Books for USA and Canadian customers, based on multiple criteria and price structures. Application utilizes stored procedures for data evaluation and retrieval. The Book is generated in different formats in Crystal Reports.
• Development of a file generating application for an existing MS-ACCESS program. The application generates 5 different files from SQL 7 database. The business rules of file creation are implemented in stored procedures.
• Full life cycle development of a VB 6 application for Sales force support, allowing to import mainframe generated files into a database; retrieve, analyze and reorganize data, based on the sale results and marketing forecast, group them by branches and accounts and BCD compress for the use with a hand held barcode reading device.
• Modifications and enhancements of Delphi 3 applications.
• Full life cycle VB 6 application development of a Bin Label program designed to import data and print graphics containing labels on thermo-transfer printers, involving software printing packages and supporting hardware.
• As a part of a team participated in design and development of HR employee evaluation application, allowing supporting management decisions and monitoring employees’ progress. Application was developed in VB 6 with MS-ACCESS database.
• As a part of a team participated in design and development of a VB 6 bug tracking application.
• Full life cycle application development of a scheduling application allowing automatic data collection through incoming phone calls, data extraction and grouping, mainframe uploading and network backup. Application was developed in WinBach.
• Full life cycle application development of a FaxBack application, which automated the process of creating and sending sales proposals to clients. The application detects the appearance of a data file, downloads it into the database, creates the proposal and sends it via e-mail to the Fax Server. Application was developed in VB 6 with Crystal Reports utilizing MS-ACCESS database.
• All the applications utilize DAO for database manipulation, own ActiveX and third party controls and software packages, involve API functions for calls to DLLs’, and communication ports for data processing.

Education and training:

M.S. in Telecommunications (Minor in Computer Science)
Java Introduction, Intermediate, Advanced. Glenview, ACT.
Web Sphere. Glenview, ACT.
VB. NET. Glenview, ACT.
C#. Glenview, ACT.
ASP.NET. Glenview, ACT.
VB development with SQL 7. Chicago, Information Management Group.
Web development with ASP. Chicago, LXL
Advanced Application Development with VB. Chicago, Information Management Group.
What’s new VB 4.0, Intermediate. Chicago, Information Management Group.
Project Management. Chicago, CCA, Inc.
ORACLE 7. CCA, Inc.
UNIX. CCA, Inc.
Visual C++, Windows SDK, MFC. Chicago, ATI Computers.
C and C++ Course for Telecommunications Professionals. Kishinev, USSR, 1990.