SUMMARY

A senior level Information Technology professional with an advanced knowledge of relational database design and more than 20 years of experience in all aspects of business analysis, application design, development, and systems integration, on a wide variety of technical platforms.

TECHNICAL SKILLS

Operating systems

VAX/VMS, Windows 7/XP/2000/NT/98/95, SQLServer, Linux, Unix/AIX, VM/CMS languages

CACHE v.5.0, MUMPS, Oracle Form Builder 4.5/6.0, Oracle Report Builder 6.0, Oracle Designer/2000, Microsoft Access, Microsoft Visual Basic, SQL, PL/SQL, SQLPlus, SQLForms, SQLAssist, SQLLoader, Advanced COBOL, SAS, Basic and Assembly Language Programming

hardware/Platforms

VAX Alpha 8400, VAX 6320/8810/8650, RISC6000, IBM 4381, MicroVAX

PROFESSIONAL EXPERIENCE

Confidential

Sr. Programmer/Analyst, Data Warehousing

• Responsible for creating and coordinating the distribution of student enrollment data extracts using PL/SQL Developer for the New York State Education Department. Involved in ETL, again using PL/SQL Developer for eScholar, NYSSIS, Credit Where Credit is Due and the Community College General Education Studies projects for various internal departments and outside state and federal agencies.
• Design and create reports based on user requirements using Oracle Business Intelligence Enterprise Edition OBIEE with enhancements in html using Oracle v.11g.
• Create, maintain and modify systems integration projects using Oracle Data Integrator to create a Financial Aid Data Warehouse in order to enable users to create their own reports and statistical analyses in OBIEE.

Confidential

Consultant

• Client: Office of Confidential and Developmental Confidential
• Responsible for the re-design of an obsolete Oracle ad hoc database from 5 de-normalized tables to over 20 normalized tables. Also created the data capture scripts from the Cache MUMPS environment as well as the automated load of the captured data files to the new Oracle tables using VAX DCL and SQLLoader. The new design allowed the data to be updated daily as opposed to weekly.
• Responsible for application development, programming and maintenance in DSM MUMPS/CACHE v.5.0 for all aspects of the Client Management side of the Tracking and Billing System TABS , using Creative Sociomedics software, including but not limited to insuring compliance with Federal HIPAA guidelines and interfacing with the e-MedNY data warehouse.
• Acted as primary TABS liaison to the Web Development team during their creation of an Oracle front-end data entry system to the Cache database.
• Consulted with fiscal officials to develop the initial loads, data entry screens and maintenance routines to facilitate the Day Habilitation, At-Home Residential and Intensive Behavioral Services Units of Service tracking system.
• Participated in the creation of web services scripts to facilitate the interfaces between Cache and Microsoft's Dynamics application.

Confidential

Consulting Services

Consultant

Client: Office and Developmental Confidential

• Responsible for application development, programming, and maintenance in DSM MUMPS/CACHE v.5.0 for all aspects of the Client Management side of the Tracking and Billing System TABS , using Creative Sociomedics software, including but not limited to insuring compliance with Federal HIPAA guidelines and interfacing with the e-MedNY data warehouse.
• Acted as primary TABS liaison to the Web Development team. Participated in the design and development of the Oracle tables required to facilitate the implementation of the governor's FSS/OPTS initiatives. Created MUMPS routines for interfacing TABS data with these tables.
• Worked as one of four MUMPS programmers leading the conversion of the TABS system from MUMPS to CACHE v.5.0, providing a graphical user interface GUI to the configuration and management tools associated with a remote CACHE database.
• Responsible for interfacing client demographic and clinical data to a VAX-based Oracle database and quality assurance data to a UNIX-based Oracle database Open VMS Environment .
• Responsible for training and assisting new hires, both consultants and state staff. Also created detailed user manuals, including screen shots and step-by-step instruction

Confidential

Client: Confidential

Assurance Department

• Created an automated system for developing project plans for the Director of Quality Assurance using DataTree MUMPS.
• Designed and created globals as well as developed data entry screens, menus and reports based on the Essential Set protocol put forth by Software Productivity Center, Inc.

Confidential

• Responsibilities included using Oracle Form Builder, Report Builder, Designer, and PL/SQL.
• Served as Technical Lead for design, development and implementation of the new Appointment Scheduler Module for Arizona WIC System.
• Solely responsible for security/roles/menu generation and development of the laptop process to download the WIC database from a server to a laptop and back again for use in remote, satellite clinics.
• Aided in developing and de-bugging Microsoft Access Reports based on data in the PVCS Software Tracker system.
• Responsible for overall adherence to functional requirements and support of users from pilot through implementation.

Confidential

Client: Confidential

• Worked on the Cytotechnologist Registry Database Application.
• Using Microsoft Access Relationships tool, created ER diagrams, table mappings and design following several meetings with users to analyze their needs.
• Created tables, converted/imported data from Excel spreadsheets, and developed data entry screens, menus and reports.
• Wrote the user manual and provided user training.
• The system used ODBC for systems integration with the statewide laboratory database.
• Continued to provide ongoing support and training.

Client: Confidential

• Performed application development, programming, and maintenance in DSM MUMPS for all aspects of the billing side of the Tracking and Billing System TABS .
• The environment for this account used CreativeSocioMedics CSM Digital Standard MUMPS Software.
• Participated in the conversion, testing, and implementation of Y2K-compliant software, both Oracle and MUMPS.
• Developed and implemented training for new hires.
• Responsible for interfacing client financial data to a VAX-based Oracle database and Quality Assurance data to a UNIX-based Oracle database Open VMS Environment .
• Participated in the creation, maintenance, and optimization of tables. Wrote MUMPS routines that would create, update, or delete database globals.
• Completed data integrity checking before, during and after the upgrade from Oracle v.7 to Oracle v.8.

Confidential

• Executed the installation of the Electronic Data Exchange systems integration software in hospitals across the United States and Canada. This involved interfacing with SMS, TDS, HBO, IDX and several ancillary applications and network packages.
• Spearheaded hardware connectivity issues and remote client support.

Confidential

Laboratory Systems Analyst

• Served as one of a three-person team installing the PC NetWare-based Co-Lab System. Co-Lab is a Laboratory Information Systems product, written in DataTree MUMPS.
• Oversaw and performed the development and installation of the interfaces between TDS' Admission/Discharge/Transfer and Order Entry systems, and the Co-Lab System.
• Performed NetWare user security tasks, PC configurations, on-call system and user support, maintenance of the current TDS Lab System and systems development programming in DTM MUMPS to create operator-friendly procedures for systems maintenance.
• Participated in the creation, maintenance and optimization of tables. Wrote MUMPS routines that would create, update, or delete database globals.

Confidential

Senior Product Specialist

• Executed the installation of the Electronic Data Exchange systems integration software in hospitals across the United States and Canada. This involved interfacing with SMS, TDS, HBO, IDX and several ancillary applications and network packages.
• Spearheaded hardware connectivity issues and remote client support.

Confidential

Consulting Systems Analyst

Served as Project Manager for the upgrade of a Philadelphia Hospital's Radiology Information System from DECrad v.2 to DECrad v.3, including the initial analysis, file coordination, as well as the interfacing of the hospital 's TDS ADT/Order Entry and SMS billing systems to the DECrad package DECrad is Digital's Radiology Tracking System written in DSM Digital Standard MUMPS .

Confidential

Systems Analyst

• Served as Project Leader for the conversion of the Medical Records Department from IBM COBOL to a Unix-based Relational Database system running on a MicroVAX.
• Maintained applications and development, training, coordination, and monitoring of users and 24-hour operational support.
• Performed the development and maintenance in the conversion of the hospital's IBM COBOL ADT System to ISM MUMPS.
• Executed application development, maintenance, and interfacing to Physician's Billing, Administration, Registration, and several other ancillary departments.
• Conducted application development and maintenance in IBM COBOL for the departments of Nursing, Finance, and Materials.
• Developed user-friendly applications and data entry programs in SAS for the hospital-wide departmental mailing system.
• Participated in the creation, maintenance and optimization of tables. Wrote MUMPS routines that would create, update or delete database globals.

Confidential

Graduate Teaching Assistant

• Taught one semester each of COBOL, Basic, and Assembly language programming.
• Headed two classes of 25-30 undergraduate students each semester.