18 years as Sr. Technical Specialist/Consultant in Multi-tier Enterprise Health Care Systems.
Data Governance , Conversions, Warehousing, Upgrades, Design, Development and Deployment of Health Informatics Systems across a multi-vendor platforms. Heavy influenced by daily exposure to large, multivariate datasets. An expert in Data -Migration, Manipulation,Interfacing,Storage,Translation,Intelligence, Mining).
Equipped with newest modeling,architect,tuning,monitoring,gathering,programming ,reporting solutions from IBM, Oracle, SAS, SQL Server 2005/2008, SSRS, Sharepoint,Sybase, Embarcadero, Quest and Seagate.

• Data and Reporting Manager
• Meaningful Use Core and Menu software developer. Providers Educator. Data collector.
• Systems Integration Specialist.
• Developer/programmer/tailor.
• Data manipulator, integrator, examiner, miner. Predictive analytics.
• Warehousing. Data housekeeper.
• Database Administrator, Merger, Archiver, Integrator.
• Applications/Systems Analyst, 24/7 On-Call Support.
• Interface Specialist.
• Disaster recovery Planner.
• End-User reporter.
• Security user's administrator. Security auditor.
• QA scripts writer.
• Team lead/Project Plans/Scopes developer.
• Specifications, Documentation, Training materials writer. SDLC advocate/follower.
• Relational databases Trainer (IT staff internally).
• Business analyst.

CORE COMPETENCIES:

Operating Systems

IBM OS390; Windows 3.1,95, 98, ME, 2000, 2003, XP; NT, Vista, Windows 7, Novell Netware 4.x-6.x.; UNIX; LUnix, DOS

Client Server Universal:

SQLSvr 2005/2008, SSRS, MYSQL, SAS, Sybase ASE 11.5, Oracle 9,10,11, MS Access, Excel, RDBMS, Sharepoint, Infopath, SSIC, SQL 2008 Managment Studio, Buisness Intelligence R2, PL/SQL, Quest for WH and Data analysis, Embarcadero DBArtisan 8.7, Oracle Enterprise Manager, SQL Plus, Oracle Discoverer, Oracle DBA Studio , Oracle SQL developer, Oracle 10G Express DB Manger, Quest Performance Tuning Suit, ERWin, Power Builder, SQL Optimizer, SQL Security Manager, Sybase IQ, WS-FTP, Rapid SQL, SQL Advantage, Infomaker, MS Sharepoint, Segate Crystal Reports, Interfaces protocols (HL7 DATAGATE, XML, Batch, Online, FTP), UltraEdit, Remedy, VMWare , Visio, Dameware, Webex.

Maiframe Universal:

CICS; IMS; DB2; VSAM; OS/JCL; OPC; TSO/ISPF; IBM Utilities; Data-Expert; Platinum; COBOL/COBOL II, Microfocus Cobol; Enscribe/Tandem, ASSEMBLER; Fortran, MT4,IDCAMS Utilities; LIBRARIAN; PANVALET; INTERTEST; FILE AID; EXPEDITOR; IMS backup utilities; DLI Storage handler; E-Z-tree.

Industry Specific:

ECW(EClinicalWorks), SalesForce, Nextgen, Carecast, Lastword ,IDXRAD, RIS, Centricity, Apollo, McKesson, Muse, Logician, EPF, Epic, Eclipsys, QuadraMed , Power Abstract (Meta); MSO-Morrisey(Credentialing System), ECHO,New Innovations; Eagle, TSI, Medipac, SMS, EZIQ;3M; CCS(HPOC), HITECH Act, Meaningful Use, Core Measures, Managed Care, Risk Management, Decision Support, Quality Management

PROFESSIONAL EXPERIENCE:

2010 - current
Confidential
Data and Reporting Manager

Environment: SQL SVR 2005/2008, MYSQL, SQL 2008 (ETL packages, Management Studio, Business Intelligence R2, SSRS), SAS Enterprise Guide 4.2, SAS basic 9.2, SAS Management Console.

• Collecting, transmitting, loading, maintaining, data mining and reporting of aggregate data from NYC outpatient clinics to DOHMH warehouse.
• In the lights of NYC Meaningful Use preparation: Wave I Core and Menu Measures: Data collection scripts,Reporting progress by all MU measures analysis. Providers education and technical support.
• Surveillance and syndromic data analytics.
• Providers Pay for Performance projects data collection and analytics: NYC eQuits(smoking cessation) and NYC eHearts(specific conditions monitoring).

2005 - 2010
Confidential, October
Sr System Analyst
Technical lead in:

• LastWord - Carecast conversion 16 years worth of data (database and client) of Registration, Pharmacy, Lab, Cardiology, Microbiology and Ancillary modules. Montefiore Hospital and all outpatient clinics. Pre-conversion data-analysis; converted database integrity validation; converted data post-validation. Implementation. Post Implementation. Support. Including over 800millions records of: Clinical, Registration, Compendium, Pharmacy tables, Orders/Order Sets, ICD9 codes, Measure VT's, System Tables, Crosswalk Files, Labels Printing Routers settings, predefined terminal settings. Interfaces redesign, screens tailoring/remapping, ad-hocs rewiring & adaptation. Carecast security database rebuilding and remapping, including Provider Credentialing Data and end-users security data.
• Designed and supported HL7 interfaces: Carecast to/from Ancillary: Orders_Out, Orders_In, Result_ In, ADT_Out, ADT_In, Pyxis, Apollo, McKesson, Muse, Eagle, IDXRAD, Labs, Nuclear Medicine.
• Our Lady of Mercy conversion into Carecast. Clients installation. Its interfaces redesigning, rewiring.
• Upgrades: 3 versions of Carecast . IDXRAD, Apollo, McKesson, RIS, Triple-G and its clinical and non-clinical HL7 and batch interfaces redesign/adaptation.
• Bronx Lebanon Hospital conversion from Lastword to ECLIPSYS. Data extraction, pre-extract referential integrity validation, final extraction validation.
• Bronx-Rhio specifications for data feed supply.
• Developed HL7-ERROR-SELF-FIXER for Radiology, Cardiology and Lab Results.
• Integrated Provider Credentialing Data (6 doctors databases synchronization)
• Designed NPI (National Provider Identifier) Loader-Synchronizer across Monteifiore,including Referring Providers warehouse from other states.
• Designed and implemented Pre-load duplicate ALERTER (Doctors and Users in Carecast)
• Designed Troubleshooter Database (MS Access) Keywords searchable for Service Desk and analysts on-call.
• Mapped Carecast main screens through TCPIP message with database fields accordingly.
• Developed Specifications and scripts for various end-user reporting stored procedures. for quick comparison individual security classes across different Montefiore Facilities(up to 3 wild card entries) for Departments directors and HR audit use.
• Developed HL7-ERROR-MSG-DETECTIVE: Set of queries against ANC systems ERROR_Que's; for analysts on-call to trace the message in case non- deliverance, multiconnecting to carecast (sybase,odbc),radiology(sql),cardiology(sql),remedy(oracle), excel & access sources.
• Improved devices mapping and data storage habits and uniforms (terminals, printers, labels-routers).
• Throughput Initiative for the hospital executives: tracing the inpatient data recordings life time: from patient admitted, transferred, tests ordered, results arrivals, vitals recorded, medications given, all charted, discharged. Through mass data manipulation statistical reports were graphically presented and allowed leadership to identify the areas of performance delays, as the results were grouped down to single work flow, location and shift. Final reports are running on Crystal on demand, raw data attached to pivots, presenting AVG by all means and offering the comparison with past performance; "Coefficient of Excellency" was developed based on provided best statistic.
• Lab Latency Investigation of systematic messages delays in LAB_RESULTS_IN, heavy statistical analysis on time frames messages deliverance. Mass timestamps data manipulation/analysis (orders and results records/messages) allowed to identify few areas of Carecast-Cerner -TripleG delays.
• Carecast Security User ID's and Security Classes maintenance across facilities, including Physicians credentials. Users activities back-log monitoring and periodical random auditing upon departments requests. Stored/archived audit files for other groups/systems.
• Risk Assessment of all terminals at Montefiore - logoff/idle time on patient sensitive information screens, securing HIPAA standards, specifically at ER workstations and/or other public areas.
• Carecast database schemas analysis for the stage of out-reporting of Meaningful Use.
• End-user reports by different means on demand for: Decision Support, Risk Management, Professional Billing, Security auditing, Clinical trials.
• Data extracts to the Department of Health, NYC.
• Provided Rotated Production Support 24/7

1996 - 2005 Confidential, NYC

2000 - 2005
Sr. Systems Analyst
Confidential, New York City

Received numerous recognition awards for planning, designing, developing , building, implementing and providing ongoing support for multiple client server and mainframe applications, interfaces , upgrades, conversions and desktop/server software upgrades, including: ADT(Admit Discharge Transfer System, CICS,IMS,VSAM), EAGLE(CICS,VSAM),CCS (Clinical Care System/HPOC, CICS,IMS,VSAM), PRISM(Carecast), Archiving old ADT database, PCS(IMS,VSAM,CICS), Morrisey(Oracle 9,10,11), Medical Records(Charms, CICS, IMS, Vsam), Power Abstract(Meta Technology, Oracle 9) 3M,Remedy(Oracle 10), IDXRAD, Cerner, Medipac, SMS,GALLUP(National Statistic Analysis) mass extracts.

1996 - 2000
Confidential, New York City
Senior Programmer Analyst

Provided day-to-day application support for All Hospital Facilities on 4 major online/batch systems and various interfaces: EAGLE, ADT(Admit Discharge Transfer System), PCS(Provider Credentialing System), Medipac System, SMS, EZIQ; Professional Billing Interfaces, CHARMS; IDX interfaces. Y2K major systems upgrades. Major Conversions and interfaces. Environment: CICS,IMS,VSAM,COBOL/COBOL II.

1993 - 1996
Confidential, New York City
Programmer Analyst, Consultant

Development of Multi Currency Project, initiated for analysis and coordination the expansion of Private Client Operations and System environments, supporting non-dollar trading in the domestic retail world. Analysis, design, coding and implementation firm-wide, used screens and programs for bookkeeping system to support a Multi-Currency environment. Maintenance and support of Money Market (MMI) system, which handles pending issuance instructions, automatically generates issuance deposits and transactions as well as the periodic interest and principal payments. Responsible for developing Paying Agent Money Market (PAMM) update function, used by paying agent to input cash and modify payment dates for all of his MMI payments pending. Conducted unit and acceptance test, provided production ongoing support and problem resolution. Participated in Y2K inventory analysis. Environment: VSAM, IMS, CICS, COBOL/COBOL II.

1987 - 1991
Confidential
Student, researcher
Laboratory Research Data Processing.

Environment: Fortran 4, Assembly, Algol, PL

EDUCATION:

PhD Theoretical Physics and Mathematics
MS Philosophy

SPECIAL TRAINING from Ernst & Young, CapGemini, SAS, Oracle, Sybase, IDX, GE, Microsoft:

2010: SAS 9, Base Programming :Managing Data, Generating Reports, Handling Errors
2008-2009: SAS 9, Base Programming: Accessing Data, Creating Data Structures
Oracle Discoverer, Oracle OBIEE, Data Mining:MiningStructure,Model Objects
Logical Architecture (Analysis Services - Multidimensional Data)
Database Objects (Analysis Services - Multidimensional Data)
2006 - 2007: HL7 ancillary design, Carecast,Lastword,Enscriibe, Tandem, Enscribe, Attunity
Sybase data modeling, Sybase database tune-up, SQL data warehousing
2005: Effective Business Writing, IPSmart administration, Unix Part1,2
2003-2004: Oracle 9i DBA Fundamentals I,certification, Oracle 9i DBA Fundamentals II certification
Oracle 9i,SQL, New Innovations, Oracle DBA fundamentals 1, Oracle8 Admin Data Storage, Oracle8 Admin
Manage Security, Project Management: The Fundamentals, "Communication with Difficult People"
Handling Difficult Co-Workers, Business Writing: Creating Effective Proposals
2002: Oracle PL/SQL Procedures, Oracle 8 Manage Data, Oracle 8, Manage Instance, 3M Coding and
Reimbursement System Software, Power Abstract, Crystal Reports, CHP NGH Account - HIPAA Required
Education, Americas Outsourcing-2003 P&D Process,Organizational Communication, Managing
Communication.
2001: Oracle PL/SQL Basics, Oracle DML & DDL, Oracle SQL End User Part (1,2,3), Gamma, K-base,
Remedy/EARS, Stress Management Fundamentals, Ethical Decision Making, Managerial Business Ethics,
Organization Ethics, Communicating with Your Customers, Excellence in Service: Fundamentals for
Employees, Excellence in Service: Fundamentals for Managers, Conducting Meetings: Effective Meeting
Communication, Effective Presentations