Professional Objective:

To assist others that would fully utilize my knowledge of database management, leadership capabilities and overall software development expertise in Information Technology.

CURRENT WORK:

Database Administrator

Confidential

Responsible for maintaining the Teradata production and development data warehouses for Geisinger's CDIS IT department. Responsibilities include performance tuning, collecting statistics, monitoring performance and creating analytics to improve query performance and overall health of the database environment.

Extract Translate and Load ETL Developer

Confidential

Specializing in Informatica PowerCenter and Data Replication products. Responsible for daily replication of clinical data from Oracle databases to Teradata databases. Develops PowerCenter ETL workflows to harvest various third party data sources. Creates analytics from log files and monitors replication performance on a daily basis. Developed IDRTools application to automate and expedite data replication processes as well as analytics used by executive management.

Senior Clinical Innovation Analyst

Confidential

Conducted independent quantitative and statistical analysis of clinical information with summarized findings and recommendations for both technical and non-technical clinical audiences. Ensured the accuracy, data integrity and validity of data analytics. Specialized in EPIC/Clarity datamart development and support. Created Crystal Reports for analytics. Provided technical support for Oracle, MS/SQL and Teradata SQL databases. Developed automated data harvesting procedures for outside source systems and Extract, Translate and Load ETL methods. Created Datamart Assistant application to automate and expedite datamart maintenance.

Database Developer/Consultant

Confidential

Sub-contracted to Prudential Insurance to create Total Quality Management TQM processes. Designed and implemented a Financial Errors and Losses tracking DBMS for Prudential Retirement and established a consolidated Plan Technical Services system that integrated Client Testing and Reporting, Pension and 5500 Tax group databases using Visual Basic VB into an integrated MS SQL 2005 database application. Incorporated Lotus Notes data and produced numerous Excel reports using MS/Access 2007 as a common front end for mass deployment. Created VB applications to generate dynamic policy documents automatically in PDF format.

IT Manager

Confidential

Executive responsibilities included creating Budget/Forecasting/Network Management/Resource Management for this data processing consulting firm. Managed staff of application programmers and oversaw the project management of various software applications contracted for development using SDLC methodologies. Designed interactive VB distributive database applications for Court Management Traffic/Criminal/Civil, etc , Document Management, Jury Selection and a Warrant Tracking system for law enforcement. Developed Extract, Translate and Load ETL procedures of legacy data. Designed VB medical billing, wound care management and financial tracking software. Designed and developed Senior Care Elopement Prevention software for nursing homes for elopement prevention of the elderly. Developed inventory control and various business management application programs that include document management and scanning. Designed and developed the Abduction Central Alert ACA Amber Alert distributive database application now used nationwide for Amber Alerts by law enforcement. Applications were designed and implemented for MS Windows using VB and Pervasive SQL with other applications using MS/SQL and MS/ACCESS databases. Installed and managed Pervasive and MS/SQL database management systems. Developed internet applications that interfaced distributed databases and utilized Dynamic Link Libraries DLL's , Active Server Pages ASP , JAVA, JAVA SCRIPT, DHTML, XML and Voice XML.

RELATED EXPERIENCE:

Corporate Database Administrator

Confidential

Standardized 42 divisions of corporation on single database management system ADABAS/Natural. Developed migration tools for a variety of databases VSAM, IMS, DL1, SQL . Interacted with remote division management. Lead database training seminars. Developed standards, procedures, and provided technical support for the entire corporation. Designed and implemented numerous CICS Cobol mainframe database applications for the corporation including a corporate wide customer service information Help Management system.

Business Systems Analyst

Confidential

Examined existing business procedures in order to propose, design, and implement alternate methods for greater performance and reduced costs. Provided technical support for corporate divisions. Evaluated new software packages to determine their possible use within the corporation. Designed and implement CICS Cobol application programs including corporate wide project/time management billing system and inventory control applications. Created automated Job Control Language JCL generators that included Easytrieve reports and extracts for corporate distribution and standardization.

Programmer/Analyst

Confidential

Designed and implemented software packages. Trained new employees concerning corporate standards and procedures. Provided technical support for corporate divisions. Coded Assembler and CICS Cobol application programs with VSAM, IMS, DL1 databases.