PROFESSIONAL SUMMARY

Experienced IT professional with strong technical and application skills in a wide range of applications and technical areas. Analytical and creative problem solver with expertise in design and development of various applications.

TECHNICAL SKILLS

Programming languages: VB6, VBNET, VBA, VC++, COBOL, FORTRAN, PASCAL, C, and SQL
Databases: SQL Server, MS ACCESS, BTRIEVE, DBASE, FoxPro, ORACLE, RMS, and RDB
Utilities and development tools: Crystal Reports, DTS, HTML, ASP, SQR, MS Office, including MS Excel, XML, Java, and Sharepoint, Meditech
Operating Systems: Windows 95/98/2000/XP, Unix, VMS, and VOS
Hardware: PC, VAX, and IBM mainframe

WORK EXPERIENCE

Confidential, Evergreen Park, IL
VBA Developer/Meditech Consultant March, 2009 – present

Was responsible for the development and maintenance of the CYBERMED – hospital-billing system.

Duties include:

• Determining business requirements from users
• Medical coding: assigning CPT codes, updating ICD9 DB, etc
• Design, development and implementation of back-end databases and workflow process by using triggers, MS Access macros calling SQL store procedures and system ODBC.
• Design development and implementation of front-end MS Office GUI (interface), which was responsible for collecting input in various MS Access forms from the user and processing it to conform to a specification the back-end can use. In process 11 MS Access forms, 8 macros and 3 reports have been produced.
• Design, debugging and implementation of several financial and statistical reports (15). Most of them have been created by using MS Access reports, although on several most recent ones we used. Crystal Reports ver. 11
• In addition several statistical Pivotal reports have been created , with MS Access forms as front-end and MS EXCEL Pivotal tables as back-end
• Presenting final program to end users
• Revisions & Maintenance of program/data
• Converted some of the software from ACCESS VBA into SQL Server, VB and Crystal Reports;

Was responsible for the maintenance and ongoing support for software products for Meditech modules.
Duties include:

• Research, identification, test and implementation of the solutions to special customer requests and requirements (for example, special reports and changes to existing software through table/file changes);
• Documentation for supported systems to ensure that all levels of support have reference material to best support the customer;
• Creation and maintenance of the NPR reports.

Confidential Bannockburn, IL
Consultant through TEKsystems (Senior System Analyst since May, 2007) November, 2006 - December, 2008

• Created the entire network of the major GAP Insurance Systems, systems, which consisted of Premium, Claims, Reinsurance, Compliance, etc….
• Each system consisted of a set of MS GUI front-end forms, created with MS ACCESS forms, macros and VBA, and back-end MS ACCESS tables. Those systems have an ability to act independently as well as in connection with each other. Duties included feasibility study, design, coding, testing and implementation;
• Worked with business representatives to have a clear picture of their needs;
• Provided training, customer support and troubleshooting via a newly developed system of SRs

(service requests):

• Converted some of the software from ACCESS VBA into SQL Server, VB6 and Crystal Reports;
• Logical and physical design, automation, installation and monitoring of various databases.

All programming was done in MS ACCESS VBA by using SQL Server, MS Access and ORACLE as a back end as
well as VB6 and Crystal Reports. Some application development was done in SharePoint.

Confidential Vernon Hills, IL
System Analyst /Database Administrator December, 2000 - July, 2006

• Was responsible for the development of the following systems: Inventory, Purchasing, Order Entry and Account Receivable.
• Was involved in database design and data modeling
• Performed feasibility study, analysis, design, coding, testing and implementation. Acted as project leader of the group of several programmers as well as one-man team.
• Worked with business teams to clarify requirements and business needs.
• Developed system test plans, ensure that software quality assurance standards are met and validate that business goals are accomplished.
• Developed high-level system narratives.
• Provided training and customer support for all the users.

All programming was done in VB6 and Crystal Reports by using SQL Server and MS Access as a back end.

• Maintenance and enhancements of EDI system.
• Was responsible for feasibility study, market research, user requirements identification, analysis, design, coding, testing, debugging, documentation, implementation, user training and customer support.
• Worked with business and technical teams of TARGET, WALMART, KMART and others to confirm the compatibility of both ends of EDI.

All programming was done in VB6 and Crystal Reports by using MS Access as a back end.

• Conversion of the existing miscellaneous programs from DBASE 5 to VB6 and MS ACCESS.

Confidential Buffalo Grove, IL
VB/ Access Developer June, 1991 - October, 2000

Assignments included:

For American Institute of Osteoporosis, Chicago, IL, Aug, 99

• Development of the financial management package, which includes Billing, Account Receivable, Payroll, EDI and Order Entry modules. Acted as a project leader and system manager.

All programming is done in VB6 and MS Access. Reports are created by using Crystal Reports.

• Conversion of the existing PeopleSoft SQR (v6.2) reports into Crystal.
• Confidential Glenview, IL, Jun 98
• Development of the Billing System.
• Duties included feasibility study, design, coding, testing and implementation.
• Programming was done in VB4 and MS ACCESS.
• Conversion of the existing system from VB4/MS ACCESS to VB6 and SQL SERVER.

Confidential Morton Grove IL, Apr, 97

Development of the WEB pages for MSNBC.

Development of the statistical WEB pages for San Francisco Giants, MLS, MSNBC NBA, MSNBC NHL and NFL

• All programming was done in DEC VAX environment (back end) and VB, HTML/ASP (front end).
• Confidential Chicago, IL, mar, 96
• Maintenance and enhancement of the Insurance and Membership Systems.
• Programming done in DEC VAX Basic, Visual Basic and MS Access
• Conversion of some existing dB from DOS to MS Access

Confidential Lisle, IL, may 94

Development of the warehousing system, Order Entry and Distribution Systems.

Programming done in DEC BASIC, Powerhouse, VB and MS ACCESS.

Confidential , McKenry City, IL, Feb, 93

Development and maintenance of EDI system.

Was responsible for feasibility study, market research, user requirements identification, analysis, design, coding, testing, debugging, documentation, implementation, user training and customer support.

All programming was done in DEC BASIC

EDUCATION:

• MS in Computer Science
• BA in Mathematics