21 years of progressive programming and system analyst experience in the distributed Web N-tier, Smart Client, & client server environments. Managed, designed, developed & maintained complete program's life-cycle. Solid communication & analytical skills.

Expertise Includes: .NET 1.0 - 4.5, MVC4, Razor, ASP.NET & Visual Studio 2015, 2013, 2012, 2010, 2005, 2003… , C#, 508 Conversion, Win VB apps, Web Development, Visual Basic, MS SQL Server 4.2 - 2012, MS MTS Server, Oracle, MS Access, T-SQL, Java Script, HTML, VB Script, Crystal Reports, Wise, MapInfo,  ActiveReports, Excel, Entrust Toolkit, Sheridan Custom Controls, ERWin, Help Writer Software and Custom ActiveX Controls, Y2K Conversion, RUP, Clearcase. 

OPERATING
SYSTEMS

SOFTWARE

LANGUAGES

SECURITY
CLEARANCE

HARDWARE:

IBM PC
Tablet PC
_________________
Windows 2008/2012

Windows 2003
Advanced Server

Windows 8/8.1

Windows 7

Windows VISTA

Windows XP

Windows 2000

Windows 2000
Advanced
Server

Windows 95/98

Windows NT

WS, Server

Windows 3/3.11
OS / 2
MS DOS

·    ASP.NET 1.x/2.x/3.x/4.x

·    VB.NET

·    C#.NET

·    Razor

·    Visual Basic 2 / 3 / 4 / 5 / 6

·    ASP Pages

·    Visual InterDev 1.0 / 6.0 / 7(.Net)

·    VB Script

·    Java Script

·    SQL SERVER 6 /6.5 / 7

·    SQL SERVER 00,03,05,08,2012

·    Crystal Enterprise 8.5 / 9 /10 / XI

·    Crystal Reports 6/7/ 8.x /9 /10 /XI

·    Crystal Reports 2.5 / 3 / 4.5 / 5

·    MTS 1.1 / 2.0

·    JAWS 3.7 / 4 / 4.1/12/13

·    MS FrontPage 98/2000

·    IIS 5/6.0/7.0

·    Personal Web Server

·    Oracle 7, 8I, 9i, 10g, TOAD, PL/SQL

·    Oracle Light

·    T-SQL

·    SQL

·    SQL Plus

·    PL / SQL

·    MS Access 2000 / XP Developer

·    MS Access 1.1 / 2 / 7 / 8

·    Far Point Spread 2.0 / 2.5 / 3.11

·    MicroGraphx FlowCharter

·    Adobe PhotoShop 5/6

·    Paint Shop Pro 5 / 6

·    OS SQL SERVER 4.2

·   IE 2/3/4/5.X /6.X /7.X /8.X

·   Netscape 2.X - 6.X

·   Visio Professional 5a/ 00/03

·   MS Office 95/ 97/00/XP/ 03

·   MS Excel 95/97/00/XP/ 03

·   MS Word 95/97/00/XP/ 03

·   Rational Clear Quest

·   ErWin/ERX 3 / 3.5

·   ERStudio

·   MAP Info Pro. 5.X

·   GeoMedia Pro. 2 / 3

·   Intergraph SmartScetch 3

·   IMS Project Exchange

·   Wise 4 / 5 / 6 / 7 / 8 / 9

·   Help Writer

·   RoboHelp

·   Axialis AX-Icons 4.5

·   Sheridan Active Controls

·   Sheridan Data Widgets

·   Sheridan Calendar

·   Sheridan Designer

·   Borland C

·   Borland C++

·   VideoSoft ActiveX Elastic

·   AccessToVB 4.1

·   Entrust Toolkit for VB/C/C++

·   FORTRAN

·   PL1

·   Forest & Trees 3.3

·   Rochade

·   FarPoint .NET All versions

·    Red Gate for SQL Server

·      VB .NET  

·      C#.Net

·      Razor

·      ASP.NET

·      T-SQL

·      Java Script

·      Visual Basic 6

·      Visual Basic 5

·      Visual Basic 4

·      Visual Basic 3

·      Visual Basic 2

·      VBA

·      BASIC

·      Oracle 7 / 8i / 10i

·      VB Script

·       HTML

·       DHTML

·      XML

·      DTD

·      MapBasic

·      SQL

·      MS T – SQL

·      FORTRAN

·      SQL Plus

·      PASCAL

·      C, C++

·      PL/SQL

·      PL1

Secret clearance within Federal agencies:

USPIS

DOD

Sensitive clearance within Federal agencies:

FRB

FDIC

US Senate

GSA

IT LIONS INC                                                                         5/2013 – PRESENT

Software Architect, DBA, Sr. Software Developer

Implemented automatic data load application/service from files to database. Completely generic service driven by config files.

Designed and implemented client’s internal website using SQL Server 2012, MVC4, ASP.NET, Razor, C#, Kendo UI, Enterprise Library, and Entity Framework.  Redesigned old database and created SQL script, SSIS to migrate data from MYSQL to SQL Server.

Third party components used: Kendo Grids/ Dropdowns / Lists / AJAX and etc…, SQL SERVER 2012, VS 2012, Subversion.

IT LIONS INC  (AceInfo for USDA)                                                                           3/2014 – 8/2014

Software Architect (part time)

Improved and advised on changes to public SuperTracker application. VS 2013, OO design patterns, WCF, Enterprise Library multi-tier tracing, logging and error recording using static logger implementation (enterprise library 6), AJAX, code refactoring. SQL Server 2012, .Net 4.5.1, App Fabric.

IT LIONS INC – HHS (ALTA)  (Rockville MD)                                                           2/2013 – 5/2013

Software Architect, DBA, Sr. Software Developer, Team Lead

Designed and implemented HHS public website - web based solution that orchestrates information about HHS events. Object oriented design using NHibernate, SQL Server 2012, and Visual Studio 2012 (C#, ASP.NET). High level of parallelization within algorithms utilized multi-processor power and made an application highly scalable webfarm. Redesigned SQL Server Database to handle high load.

Third party components used: Telerik Grids/ Dropdowns / Upload / Download / Progress Bar / Lists / AJAX and etc…, NHibernate, SQL SERVER 2012, VS 2012, Subversion.

IT LIONS INC - US Air Force  (Arlington VA)   - ATCS (Herndon, VA)                    9/2007 – 1/2013

Software Architect, DBA, Sr. Software Developer, Team Lead

Implemented and supported Warehouse Management System (WMS) - web based solution that stores product data for both physical and electronic products and provides product procurement, order processing, and fulfillment capabilities to the customers of US Air Force industry. Web service/WCF supports data sharing. Used Akamai Servers Solutions to accelerate WMS application and dynamically-generated content while providing fast and flawless media and software delivery. Supported production with more than 30 VMs and clustered SQL server. WMS application was written to support hardware/software utilization for the F5 devices.

High level of parallelization within algorithms utilized multi-processor power and made an application highly scalable. Followed Security Development Lifecycle (SDL) guidelines. Used Agile and TDD (test driven development) approaches for project implementation. Employing RUP, rational tool for system OOP designs and for reverse engineering.

Pioneered Composite Application Library implementation, MVP model utilization on the project (presenter, view, model in Supervising Controller Pattern). Used factory pattern, creational, structural and behavioral patterns, NHibernate, Service-Driven design, Telerik Controls, AJAX. Used Visual Studio and TeamCity, Subversion to do auto builds, precompiled check-ins using Subversion, Scrum Agile methodology. Tested application for different operating systems (XP/Vista/win7 32/64).

Third party components used: Telerik Grids/ Dropdowns / Upload / Download / Progress Bar / Lists / AJAX and etc…, NHibernate, SQL SERVER 2008, VS 2008/2010. 

Maintained production and test SQL server databases:

Installation, upgrade and configuration of MS SQL Server and databases in clustered and non-clustered environments. Set up different Replication Models - Merge, Snapshot, and Transactional. Employed mirrored/witness databases and Log shipping with SQL Server 2005/2008. T-SQL coding and testing: functions, views, triggers, cursors, and stored procedures. Performed Performance Tuning, Query Optimization, Client/Server Connectivity. Security implementation – support of groups, users operations including creation/alteration, grant of system/dB roles and permissions on various database objects. Created Tables, Views, Functions, Indexes, Stored Procedures, Cursors, Triggers, packages, Scheduling Database Maintenance Jobs (rebuilding indexes, full and incremental backups, backup transaction logs, maintaining data consistency and etc…), detaching, attaching, moving databases, Sending Alerts using Database Mail. Upgraded from MSSQL Server 2005 to MS SQL Server 2008 R2. Used DBCC Utilities Checks Database Consistency. Created sql server reports and used SQL Server Reporting Services. Advocated Capacity planning, Performance Tuning, Disaster Recovery, Trouble shooting, database log analysis, backup and restore procedures policies. Creation and maintenance of Databases, creating Roles and managing user permissions.

ITLIONS INC (NRC, BOOZ ALLEN HAMILTON)                                                  Aug 2007 to Feb 2011

Sr. Software Developer/DBA/Analyst 

NRC Contract Continue to support TEAM, Team Online, Inventory Management applications by writing new and rewriting old asp forms to Asp.Net, creating new and fixing old reports written in Crystal Reports XI.  Assisted other developers with code reviews and optimization designs, supported others and helped to troubleshoot problems. Provided ongoing deployment and production support. Evaluated product scalability and future expansion predictive benchmarking and baseline estimates based on number of anticipated concurrent users and transactions per second. Proposed several alternative solutions to support scalability.

Third party components used: Telerik Grids/ Dropdowns / Upload / Download / Progress Bar / Lists / AJAX and etc…, NHibernate, SQL SERVER 2008, VS 2008/2010. 

ITLIONS INC (NRC, BOOZ ALLEN HAMILTON)                                              August 2006 to 8/2007

Sr. Consultant Programmer/DBA/Analyst                                                                                  

Implemented and deployed VB.Net 2005 web application front-end (web/asp.net, vb.net / c#.net) for manual and automatic payments and invoices matching. This is three-tier (thin client, business objects, data access) application designed to automate processing of bank payment files and Booz Allen Hamilton invoices. AR Matching system have security form authentication login against Oracle database with custom written Oracle Membership Provider class with Users, Profiles, and Roles, ODP (Oracle Data Provider), reports exported directly to MS Excel from web pages, and grids consisting of drill-down hierarchical data.  Application designed using ASP.NET 2005, Oracle 10g, Visual Source Safe 2005, IIS 6, and FarPoint Spread 2.5 for ASP.NET 2. Utilized SiteMap control, master pages implementation approach, Web Parts personalization.

Continue to support TEAM and TeamOnline applications by writing new and rewriting old asp forms to Asp.Net, creating new and fixing old reports written in Crystal Reports XI.  Assisted other developers with code reviews and optimization designs, supported others and helped to troubleshoot problems. Provided ongoing deployment and production support. Evaluated product scalability and future expansion predictive benchmarking and baseline estimates based on number of anticipated concurrent users and transactions per second. Proposed several alternative solutions to support scalability upgrade. (ASP.NET 2003, SQL Server 2000, Visual Source Safe 2005, Crystal Reports XI, ADO.NET, XML, and etc…).

Used SharePoint Services for global data and documents exchange, notification services, and deliverables and team work load tracking. Microsoft Project Manager, Active Directory authentication. Utilized InfoPath for XML data entry forms to support standard input from client organizations.

ITLIONS INC (STGI, TAC Worldwide Consulting, NRC)                  November 2005 to August 2006

Sr. Consultant Programmer/DBA/Analyst                                                                                              

Implemented VB.Net 2005 application (web/asp.net / win forms and vb.net smart client). Implemented merge replication for an adoption agencies audit applications that support an online and offline modes - VB.NET 2005 and SQL Server 2005, Visual Source Safe 2005. Worked on issues of rapid deployment of the customized system features of the dynamic database, screens and reports over to different clients. Provided existing production application support and troubleshooting. Evaluated ClickOnce proactive deployment strategies versus Wise packaging. Implemented deployment tool which alleviates automation of database deployments (using SMO), replication, users, permissions, screens, reports, tables, triggers, views and other SQL Server 2005 objects to any given server with public IP address. All SQL Server objects were created based on objects metadata definitions in master database. Deployment application was performing scan of tables and data from master database (populated with Custom UI Form XML and Database Designers) were transformed into new database available for immediate use by an end user. Created application that allows its owner to do dynamic modification to the deployed application (add forms and controls) and database (add fields and tables). Created remote client application which allows user to access databases locally and over the network, using replication and working disc (Windows and Web Forms), Component One controls, Tab Control, and Docking Control (Windows Forms), FarPoint Spreadsheets 1.1/2 (Grid for Windows Forms), and Component One PDF Ad-Hoc Reports.  Wise Install versions 6.2 and 7. Worked on issues of rapid deployment of the customized system features of the dynamic database, screens and reports over to different clients. Mixed VB.NET and C# environment.

Implemented Web application – online training courses enrollment and financial credibility verification - ASP.NET 2003 and SQL Server 2005, Visual Source Safe 2005.  This application will allow user to register and pay for course online.  Solution consists of client ASP.NET application and Management application written in WINFORM.NET (VB.NET). Win form admin application was designed to add courses information, possible course locations, restaurants, hotels, and etc… Web application displays this information for the user, allowing him to register/pay for any available course and dynamically create trips with maps to any course/hotel/restaurant location he/she chooses.

Continue to support TEAM and TeamOnline applications by writing new asp forms (Asp.Net), fixing reports (Crystal Reports XI), and updating security and database for better performance.  Assisted other developers with optimal code designs, supported others and helped to troubleshoot problems with an online payment process (VeriSign) and security model to provide highest level of security protection against hacker attacks.

Worked on many other applications under the same .NET solution, including but not limited to UI Form XML Builder, Form Navigation XML Designer, Database Table Designer, and etc… Total of 39 applications under this solution. Third party components used: Component One grid

ITLIONS INC (US Senate, NIH,NRC, Intersections)   Sr. Consultant/DBA/Analyst/Team Lead   Jul 2004 to Nov 2005

US Senate: Designed three VB.Net 2003 applications (two web/asp.net and one vb.net smart client). Implemented merge replication for emergency evacuation applications that support online and offline modes - VB.NET and SQL Server 2000. Maintenance of an accounting and emergency evacuation planning applications - VB.NET. Tested application's performance characteristics and improved application scalability based on Performance Monitoring and custom benchmarking identified bottlenecks. One of Asp.NET applications used stateless controls to improve speed on broadband connection. Created Crystal Report Engine to display reports in ASP.NET application using DHTML Crystal ASP.NET component. Created Crystal Reports using ADO connection to SQL Server 2000. Created powerful random password generation (mixed-case alpha-numeric with special characters, 12 to 20 characters) sent by user request to an email address registered in database. Evaluated application of existing market products supporting .NET grids, rich client GUI, PDF export and Report Builders tools. Provided existing production application support and troubleshooting. Advised on SQL 2005, VS Studio 2005 gradual migration strategies. Third party components used: Component One grid (Windows and Web Forms), Component One Combo Box, Tab Control, and Docking Control (Windows Forms), FarPoint Spreadsheets (Grid for Windows Forms), and Component One PDF Ad-Hoc Reports.

NR Corp: Designed Ad Hoc Web based report system for NR TEAM application to allow for a dynamic reports build and customizations. The Ad Hoc report system front-end is written using ASP.NET 2003 and Crystal Reports 10 (Later ported to Crystal Reports 11 for the reason of improved server side printing). Microsoft SQL Server 2000 was used as a data repository.

The main part of the system is Table Cubes (set of views and/or tables based on event) and fields that belong to them. Fields and tables are loaded from database sys tables. Reports could be generated from one or multiple tables and/or views. In case multiple objects were used, Ad Hoc application collects all possible joins from sys tables or preset joins to build query for the report. User can choose any criteria by typing condition or selecting one from the list. User has ability to sort, group by or create Fiscal Year totals and/or counts. User has ability to choose 4 different column counts per report (6, 8, 11, and 13) with 6 possible page types and orientation settings each. Reports designer provides server and client printing with ability to set network and local printers for server printing (this option allows user to preserve all print settings for the report). Reports are using dynamic query generation and can be run against any database and /or server that are being passed at the time of runtime generation of the report. Created error class for TEAM application that allows to record all errors (handled and unhandled) in to XML file sorted by Date, User, and Time error occurred. Designed ‘Message Box’ class to allow developers to generate Message and Prompts Boxes like in VB.NET using one line of code. Worked on project integration (business and programming sides) and deployment issues. Mentored team of development and made decisions based on collective input in duration of meetings with customers.

Intersections: Created VB.Net 2003 application for stress testing of SQL Server 2000 with unlimited user load and with reported statistics of server use, load, and crush reasons. This application was loading and reading data to and from SQL Server 2000 database with different intervals. Wrote complicated stored procedures using table parameters, cursors, loops, BCP to read file names and directories, load data from files to tables, move/delete/copy processed files to ftp, used Instead Of triggers with DBEncypt database design. Rewrote company tables, views, and stored procedure to work with DBEncrypt process. VB.NET Stress Test application was used to determine maximum users for decrypted and encrypted databases and server ability to handle this load. Created Web Services components to process data from files and move them to new destination.

IT LIONS INC (NIH, Judge Inc, NRC)         Sr. Consultant/DBA/Analyst/Team Lead              March 2003 to July 2004

Handled routine database support, tuning, maintenance, transaction log save/restore SQL Server operations in multi-server environment. Validated and implemented hot/warm servers backup policies, strategies and replication, data synchronization among multiple servers. Employed push and pull data approaches.

Responsible for distributed Web applications design, implementation and support. An application supports a variety of end user devices such as PDAs, Tablet PCs, and regular PCs.  Implemented DLL to do scheduled loads of Lotus files data into a SQL database via XML structures as an intermediary. Separated business and data access logic into different deployment units installed on Web and application servers accordingly. VB.NET, VB6, VB Scripts, ASP, SQL 2000, MS XML 4.0.

Developed reports for commercial Lab Ware application (LIMS) used in pharmaceutical research projects. Wrote crossed tabs reports, sub-reports, statistical reports that helps to intelligently analyze medical samples data and to draw an educated conclusions based on the comparison of multiple test results.  Rationalized the data store and retrieval techniques in order to fine tune application performance.

Crystal Reports 9, Oracle 9i, TOAD, PL/SQL editor.

Developed “Nstep” application using VB 6 and MS Access XP ADP application. Designed database, stored procedures, and triggers using SQL-Server 2000. Created custom ActiveX controls that provide dynamics of ad-hoc wizard functionality and allows user to create their own customized screens without writing any code. User Screens have ability to retrieve data from database and save new or update existing records. The XML driven GUI designed to support user ability to choose files and load different screens. Created DTS packages to transfer data from previous versions of application. Utilized database replication. Rewrote an application with enhanced and added features and better structured and bulletproof design. Participated in deployments and user training sessions, provided staff with consultations on the best implementation and enhancements tactics, and discussed long term prospects of the project development and maintenance strategies.

Tools, Software, and Operating System Used:

·       Desktop: VB 6, MS Visual Studio 6, SQL Server 2000, Visio 2000, Crystal Reports 9 Enterprise addition, MS Visual SourceSafe, Access XP/2000, Word XP, Excel XP including extensive VBA programming from within Access, Word, and Excel, Paint Shop Pro 6, Acrobat Photoshop 6, Microsoft Windows XP/2000/98, Wise 9. 

IT LIONS INC (USPIS)         Sr. Programmer/Analyst/Team Lead                                   Sep 2000 to Feb 2003

As a team lead established an efficient communication channel between clients, developers and QA teams. Translated business, functional requirements into the technical design and architecture. Worked as liaison between DBA team and developer teams. Orchestrated moves among development, test and production clusters.  Conducted code reviews within a team members.

Established JAWS scripting development patterns (control classes) to make a move of mission critical applications toward new government 508 standards in a productive and timely manner. I was leading programmer during the 508 marathon and assisted all company developers and QA with technical support and guidance.

Listed below applications are 10 full-blown commercial systems designed or redesigned for US Postal Inspection (USPIS):

All of them used MS SQL Server 2000 as their back-end. OCX’s, DLL’s, ASP’s, and / or HTML as their front ends. All applications are n-tier apps that use business services and data services components. All applications had two way reporting: Crystal reports for regular users and MS Excel for 508 users. All applications are compliant with US Government Disability Act. (508 Standard)

Developed Name And Address search engine assist. This is DLL type global application that found an Enterprise-wise utilization within the company. This DLL uses Postal AMS (Address and Matching System) + Intelligent Search Software. Along with a data retrieval mechanisms support this product performs data validations and requested data amendments. An application does intricate template-based searches by person’s credentials, fixes incorrect street addresses, cities, states and/or zips using an artificial intelligence paradigms and approximations. This app works both as a stand-alone entity or could be utilized by other applications and by SQL DTS.

Developed web-based application ‘Misconduct and Complaint Tracking System’ (MCTS) for recording and tracking of internal crime investigations and complaints of an alleged serious misconduct by Inspection Service employees. MCTS has strict user requirements and multi level security designed beyond typical USPIS Intranet security standards. MCTS has been written in VB 6 using active document VBD and ASP pages. An application uses a lot of classes and custom controls. In order to comply with USPIS policy of not employing third party controls I developed custom Multi Column database-driven Drop Down box. API functions were employed to achieve many of control functionalities. Designed Calendar control that outperformed Microsoft’s Calendar control based on a results of benchmarking test. Designed Spread Sheet type custom control that included all functional and GUI features of Far Point spreadsheet third party control and served for an Advanced Search (ADHOC Report).  

Produced three new releases of Vacancy Announcement application (‘VAP’) and a 508 release based on new government standards. VAP generates and advertises USPIS Vacancy Announcements and collects data about the announcements posted and the candidates selected within the US Postal Inspection (USPIS), the US Postal Service (USPS), and outside the USPIS and USPS. This application consists of two main parts: Administrative OCX component and Set of ASP and HTML pages available to every user within the corporation

Worked as a part of the team developing ARIS application. The Anthrax Reporting Incident System (ARIS) is a web-based application for tracking and reporting anthrax incidents. The purpose of ARIS is to ensure the accuracy of data entered in Anthrax database, this is the tool to track incidents nationwide and report the results to Postal Management and the various law enforcement agencies. Mission critical application was designed in a record time working around clock. Front end - ASP, OCX application, MTS, SQL server.

Redesigned ISPEMS application to meet new 508 standards. The Inspection Service Property and Evidence Management System (ISPEMS) is an automated program that records and tracks all high value information. The system uses a series of user-friendly, pop-up selection menus and narrative fields for standardized entry. The system has reports that can be generated on a structured basis using different filters. The system produces reports at different levels (national, division, & team levels) depending on the access level of the user.

Redesign PMN application to follow government 508 guidelines. The Prohibited Mailing Narcotics (PMN) system is a web-based application for recording and entering information concerning known and suspected illegal drug and drug-money mailings. The PMN system is capable of tracking, researching, and reporting suspicious activities. This application uses ASP and OCX.

Redesign PDS application to meet government 508 standard. This application uses ASP and OCX. I was part of the team in PES, LIMS and FCS applications. I helped to fix SQL and reports in FCS and PES. Redesign and fix every Crystal Reports + SQL to meet new requirements by the customer in LIMS application.

Developed small PDA database applications to support time, projects, tasks, and personal information tracking.

Tools, Software, and Operating System Used:

·       Desktop: VB 6, MS Visual Studio 6, SQL Server 7 / 2000, Visio 2000, Crystal Reports 8.5 Enterprise addition, MS Visual SourceSafe, Rational Clear Quest, Office XP including VBA programming inside of Excel, Word, and Access, Paint Shop Pro 6, Acrobat Photoshop 6, Microsoft Windows NT/2000. 

·       PDA: DB Anywhere, HAND DB, Windows CE

NR INC (SAIC - RCAS)      Sr. Technical Project Manager Sr. Programmer/Analyst        Feb 2000 to Dec 2000

Managed, designed, and implemented 'CARRS Data Repository & Metrics System' software using VB 6 as a front-end and Oracle 8 as a back-end. This software provided critical information and data needed to manage software production and processes that are developed, delivered within budget and on time. Application provided ability for a regular user to view reports online using IE 5. Admin users had separate application to generate reports in Excel or Crystal Reports from VB Application, Reports links were persisted to the database and accessible from company Home Page. Coding structure in VB includes classes and user defined controls. Performed data migration from Rochade database to Oracle 8. Designed a relational normalized database. Custom Controls used: (FarPoint SpreadSheet, DB Grid Pro 5, Sheridan Designer Studio). Developed reports in Crystal Report 6/7 against Oracle 8 and VB Application.

Supervision team on 'CARRS' Project. Lead developers providing assistance with coding and screen designs.

BUTTLER TECHNOLOGY INC. (Marriott Y2K Office )          Sr. Programmer/Analyst           Jul 1999 – Jan 2000

Developed Web Application using InterDev 6, IIS. Created ASP Pages with the dynamic database driven menu.

All data processing done on the server side using VB Scripts with ADO ActiveX database object. On the client side used Java Script (to provide universal browsers support) to build collection of nodes with folders, subfolders and links to different Word, Excel, PowerPoint documents and I M S Excel reports from Project 98 and Oracle 8.0 database. Files were displayed inside the browser on the left side as the user clicks on the link. That approach allowed minimized web site maintenance. Written VB application to let user to manipulate links via server folders navigation and persisted files locations to the database that originally was an Access and then migrated to Oracle.

Developed VB 6 “Y2kInfo Tracking System” (YTS) application and designed new YTS database using Oracle 8i. YTS saved data and displayed it via Crystal Reports and on the GeoMedia maps. Data were loaded into database per user request and upon direct automatic load from files that were sent to via Outlook email. Developed in-process and out-process ActiveX Controls and COM/DCOM.

Designed Maps in MapInfo Professional 5.5 that locates and displays properties around the world in different zoom levels and different sizes. Used MapInfo and MapBasic to create professional application. Recreated the same application using software from different vendor (GeoMedia Professional 3). Created VB6 Application to save and enter data to Access and then Oracle 8i databases.

Both VB applications (for the web and maps databases) had queries to database in separate designer class so it would be easy to maintain them inside the code. Both applications used API Functions and ADO to access databases. Created Oracle stored procedure to load data to VB application.  Both VB6 applications used:  Sheridan Designer, Data, and Calendar Widgets ActiveX Controls ; FarPoint SpreadSheet 3.0 ActiveX Control; Standard MS ActiveX controls;  AccessToVB 4.1;

Created dynamic reports in MS Excel using pivot tables for IMS software (extension of MS Project 98). Each time when report was opened it hit Oracle database using DAO (used DAO to be able to run reports on the standard Marriott PC without any installation. Reports used DSN that was created dynamically when report starts and deleted when report was unloaded (used API Function)). Excel Reports were located on web server and were available to everybody via Intranet inside Internet Explorer 4.0 / 5.0 and Netscape 4.61 browsers.

Developed reports in Crystal Report 7.0 against Oracle 8I and used VB Application to run them on user computers.

ATR (Government Federal Reserve Board  -- FRB)          Sr. Programmer/Analyst/DBA         February 1998 – July 1999

Designed and implemented ‘FOIA Tracking System’ software using VB 6 front-end and MS NT Server 6.5 / 7.0 as a back - end. Coding structure in Visual Basic includes classes and user defined controls. Performed data migration from Paradox database to MS Access 8.0 and to MS SQL Server using Microsoft BCP Utility software. Designed a relational normalized database in ERWin.  Ported this database over to Microsoft NT Server 6.5 / 7.0 using ERWin. Created stored procedures and triggers. Created dynamic search wizard-like utility with table driven GUI definitions which made structural table modifications transparent to the user. Create in-process ActiveXControls. Tools: FarPoint SpreadSheets 2.5, Graphical tools, Sheridan Custom Controls, VS ActiveX 5 Controls and Visual Inter Dev. 

Developed reports using Crystal Reports 7 designer component and Excel to build reports that can not be handled by Crystal Reports.

Excel reports were opened from VB through OLE mechanism. Software guides user with precise instructions through business logic using Voice Accompaniment and Video Animation. Interfaced with client on a daily basis providing design concepts, support, advised on improvements to be made to system and gathering business requirements.

Designed, developed and maintained the program's life - cycle.

Lead developers providing assistance with coding and screen designs.

Maxim Group (Bureau of National Affairs (BNA))           Sr. Programmer/Analyst                           Aug 1997 – Feb 1998

Design and implemented GUI concepts, coding structure using Visual Basic Scripts and MS InterDev. In this development used ASP Pages (using VB Scripts on the server side) and HTML 3.2 that provided to the user access to dynamic reports (Crystal Reports 6.0) through web pages using Crystal Reports Smart ActiveX Viewer. Those reports were pulled directly form SQL Server 6.5. Implemented Server and client security to prevent unauthorized use of reports.  Loaded data to SQL Server 6.5 using MS BCP utility.

Designed and implemented ‘BNA Pension Audit Advisory’ software via VB 4 language front–end (Tools: FarPoint SpreadSheets 2.5, Graphical tools, Sheridan Custom Controls, VS ActiveX 5.0 Controls, VB 5.0 Controls and etc.) and MS Access 8.0 as back – end.  Employed Voice Accompaniment and Video Animation. Implemented Word 8.0 / Word Pad advisory documents access from within application  (Using OLE mechanism).  This program helps user (company) to answer all questions required for ‘401K plan’ and print report using Crystal Reports 6.0.

Designed, developed and maintained the whole program's life - cycle.

Computer Associates  (Government FDIC)               Sr. Programmer/Analyst                               Nov 1996 – Aug 1997

Contracted to CASI (Computer Associates Inc) to design and implement a database application for Federal Deposit Insurance Corporation to electronically process employee childcare benefits (CCPS).  Lead other developers providing assistance with their coding and screen designs.

Designed and implemented GUI concepts, coding structure via Visual Basic 4 language front–end. (Tools: FarPoint SpreadSheets 2.5, Graphical tools, Sheridan Custom Controls, VS ActiveX 5.0 Controls, MS SQL Server 6.5 Utilities). Performed data migration from DB2 database to MS Access 8 and to NT SQL Server using MS BCP Utility software. Designed a relation, normalized database in MS Access 8. Ported this database over to MS NT Server 6.5. Create stored procedures for every query in application and triggers to force data integrity. I have developed sophisticated reports using Crystal Reports 5. Consulted our FDIC client on a daily basis providing them with design concepts, answers to questions, advice them on how the system could be improved and how to implement it. 

Designing a database application for Federal Deposit Corporation ‘Time and Attendance Processing System’ (‘TAPS ’).  This application completely streamline and automate its’ time and attendance reporting process corporate–wide.  Designed and implemented GUI concepts, coding structure using Visual Basic 4 language front – end and MS ACCESS 7.0, MS NT SQL Server 6.5 as back – end   (Tools: Far Point SpreadSheets 2.5, Graphical Tools, Sheridan Custom Controls, VS ActiveX 5.0 Controls, Microsoft SQL Server 6.5 Utilities).

Designed relational, normalized database in MS Access 7.0, converted this database over to MS NT SQL Server 6.5.  Design stored procedures and triggers to support client/server technology. Lead other developers providing assistance with their coding and screen designs. Interfaced with client on a daily basis providing design concepts, advised on system improvements, software and hardware recommendations.

Implemented mission critical application "Project Excellence System" that had main intended to be used by FDIC for assisting in time and resource management on all their projects. It has features, which will enable FDIC to have full tracking and monitoring system to regulate and centralize the projects and have a scheme for performance measurement. 

Worked extensively with a third - party VBX / OCX  (Tools: SpreadSheets 2.5, Graphical tools, Sheridan Custom Controls), DLL encapsulated functions to perform VB calls to SQL Server, with local MS Access 7 tables. Developed 30 sophisticated reports using Crystal Reports 4.5 and Forest & Trees 3.3 software. Designed, developed and maintained the whole program's life-cycle. (Tools: VB4, NT SQL SERVER 6.5, ACCESS 7.0). Was responsible for searching up-to-date technology and management concepts in order to assist FDIC's successful reorganization process.

Telemet America Corp.                         Programmer/Analyst and DBA                               March 1996 – November 1996  

Implemented Customer Support Contact system for maintenance and tracking of the company on-line activities that reflect stock market software purchases and exchanges.  Application was based on a client server platform and performed via Visual Basic 3.0 language front – end interface to the MS SQL Server 4.2 / 6.0 (OS2 and Windows NT Platforms). This application was installed on the LAN Novell under the Windows Operating System.

As DBA, performed data migration from the mainframe to the MS NT SQL Server using MS BCP Utility Program. Considered numerous data integrity and security system issues in this project. Created stored procedures.

Widely used third – party tools (Tools: FarPoint SpreadSheets 2.1 Control, Graphical tools), DLL encapsulated functions to perform VS calls to the MS NT SQL Server 6.0 with local MS Access 2.0 tables. Developed sophisticated reports using Crystal Reports 4.5 software.  Designed, developed and maintained the whole program's life - cycle.

egrated some animation coding.

US Citizen                                                          References available upon request