Experience
University of Pennsylvania Health System– Philadelphia PA
Manager, Research Data Analytics, Data Analytics Center 3/2014 to Present
- Overseeing enterprise-wide development of research data warehouse solutions in partnership with technical, academic and business leadership.
- Leading the overall architecture, design, development, deployment, maintenance, enhancement, services, and support of hardware and software for structuring/organizing, storing, retrieving, analyzing, and reporting research information and operational/production data.
- Managing complex projects and initiatives which significantly impact business outcomes through the development of business intelligence, data warehousing, reporting, and analytics solutions.
- Defining the needs of the development through short and long-term goal setting, assessment of information technology needs, and information systems integration, IT business operations, risk analysis, security, applications development, database management, user and system support, and related operations.
- Developing departmental policies and procedures to enhance operational efficiencies, while working through IS staff, leveraging peer resources, engaging external expertise, and maintaining strong relationships with internal business units, vendors and clients.
Senior Clinical Information Analyst, Information Services Department 2008-2014
- Analyzed, designed, developed, documented and implemented the application that will be used to extract, calculate, and deliver Hospital Quality Measures as part of the successful Meaningful Use Stage 2 certification process and attestation (PMURS: Penn Meaningful Use Reporting System).
- Functioning as Scrum Master for the Ambulatory Analytics Project; Producing specification documents, facilitating meetings, guiding the developing team, assisting with internal and external communication.
- Created Universe, WEBI reports, Query as Web Services using Business Objects for the Ambulatory Analytics Project.
- Created dashboards using Business Objects Xcelsius 2008 for the Ambulatory Analytics Project.
- Analyzed, designed, developed, documented and implemented the application used to extract, calculate, and deliver Hospital Quality Measures as part of the successful Meaningful Use certification process (PMURS: Penn Meaningful Use Reporting System). In 2011, PMURS was one of the 12 healthcare organization across the country certified for the calculation and submission of clinical quality measures.
- Analyzed, developed clinical data and designing data marts to support OBIEE (Oracle Business Intelligence application).
- Developed Reports / Dashboards with different Analytic Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using OBIEE.
- Gained additional experience in implementing the complete life cycle of Business Intelligence with Star and Snow flake Schemas.
- Configured OBIEE iBots to deliver Analytics content based on an automated, scheduled, query to obtain daily and weekly reports.
- Interacted with clinicians for gathering the OBIEE Report and Dashboard requirements and define business and functional specifications.
- Customized and developed RPD (Physical, Business and Presentation Layer), configuring metadata objects and Web Catalog Objects.
- Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to OBIEE Repository.
- Active contributor to the overall Design of the Clinical Data Warehouse
Fox Chase Cancer Research Center– Philadelphia PA 1992-2007
World renowned Cancer research and treatment center
Senior Programmer Analyst, Bioinformatics 2004-2007
- Developed and maintained Oracle and PostgreSQL database for the ProtLIMS (Proteomics Lab Management Information System) and FlowLIMS (Flow Cytometry LIMS) projects.
- Developed views and materialized views for the ProtLIMS project (Oracle and PostgreSQL database).
- Developed DAO (Data Access Object) for viewing data from multiple tables (using OptimalJ, Java IDE).
- Performed Data-Driven Testing for the developed DAO (using OptimalJ application).
- Developed the ProtLIMS application from OptimalJ to JBoss (J2EE based application server) to different platforms (Windows XP, Sun/Solaris, Red Hat Linux).
- Developed Java Swing application comparing the content of several input files.
- Developed instruments in XML and Jsp on PRESAGE (a web-enabled data acquisition tool where the metadata in stored in XML files).
- Participated in the full-life-cycle of an implementation, including: Application Design and configuration, Requirements Gathering and Business Analysis following the Capability Maturity Model (CMM) methodology.
- Used version control and build management systems for the products and projects using CVS and Ant.
- Developed and maintained MySQL database for the Plasmid Database project.
- Was a contributing member of the “Foundation Architecture Committee” – lead a team responsible for evaluating and selecting several development tools for ER (Entity Relationship) and UML (Unified Modeling Language) to be used by all of the IT groups at FCCC
Programmer Analyst, Division of Population Science 2000-2004
- Developed forms, edit reports and built automated mailing systems for various medical studies using Oracle development tools such as: Developer 2000 (Forms 4.5, 6.0), PL/SQL, SQL.
- Developed designed and implemented project models including creation of tables, views, reports and data entry screens, using Power Design AppModeler.
- Performed statistical analysis of data using SAS.
Programmer- MRI Department 1998-2000
- Developed platform independent applications and 3D (Three Dimensional) Graphical User Interfaces (GUI) that are used in MRI related research and studies utilizing my knowledge of IDL (Interactive Data Language), a programming platform for data analysis, visualization, and cross-platform application development.
Researcher- Department of Molecular Structure 1992-1998
Ben-Gurion University of the Negev-Israel
Researcher-Department of Chemistry 1990-1992