SUMMARY

• Information Technology professional offering over 15 years of experience in all areas of research and development, data analysis and software development, including team lead and project management, looking for an opportunity to apply it in a director of data architecture or principal/lead data architect role.
• Proven track record of success in identifying problems and developing innovative solutions.

TECHNICAL SKILLS

Operating Systems: Linux, Solaris, Tru64, HP - UX, IRIX, Windows

Relational Databases: Oracle, IBM Netezza, Informix, Microsoft SQL Server, PostgreSQL, MySQL, Microsoft Access

Applications: i2b2, Ab Initio, KNIME, Microsoft SharePoint Server, Microsoft Project Server, Microsoft Visio, Microsoft Office, Oracle UltraSearch, Crystal Reports, Apache, MarkLogic XML Server, LiquiBase, ERwin

Programming: UNIX Shell (sh, bash, csh, tcsh), Perl, Python, Fortran, PL/SQL, 4GL, XML, JSON, HTML, Javascript

PROFESSIONAL EXPERIENCE

Senior data architect, Scrum Master

Confidential, Fairfax, VA

Responsibilities:

• Wrote the project charter and guiding principles for modeling.
• Defined high level requirements for the web based data modeling application.
• Proposed solutions for data models extensibility and protection of personal information when sharing data between multiple applications in the “publisher-subscriber” cloud-based integrated environment.
• Gathered global higher education domain-specific knowledge from subject matter experts and translated it into a set of JSON entity schemas used in the API development process.
• Designed and developed an application that generates templates for sample data files from JSON models.

Technical architect

Confidential, Plymouth Meeting, PA

Responsibilities:

• Proposed a catalog of company data assets, and a system that would allow more efficient knowledge sharing and utilization of resources, by matching their skillset and expertise to project needs.
• Created a data model, designed and developed an Oracle database schema and PL/SQL package to collect aggregated medical claims data, utilized by multiple analytical and reporting (BI) applications.
• Architected a data model and integration framework for the Oncology data warehouse, and an ETL/ELT system to gather data from various repositories. Designed processes to build and maintain Warehouse dimensions and fact data.
• Set up an efficient ETL process retrieving the entire history of prescription projections from a fact table in the production data warehouse on Netezza, into a data warehouse for reporting and analytics on Oracle.

Solutions architect

Confidential, Nashville, TN

Responsibilities:

• Created a data model and built a database for the Research Derivative data repository that contains all types of clinical data from electronic health records.
• Set up a regular update process, which includes NLP-based extraction of medication and problem list information from documents, and parsing of XML-based forms.
• Implemented the KNIME workflow engine for clinical study data selection algorithms.
• Installed and configured the i2b2 platform to work with the data in the Research Derivative repository.
• Deployed the MITRE de-identification toolkit (MIST) to remove PHI from clinical documents.
• Designed and implemented backend and middleware layers for a statistical browser, which identifies statistically significant associations between data elements in health records.
• Led the data migration project from Oracle to Netezza.
• Designed a set of ETL pipelines from clinical and genotyping data repositories into Netezza.
• Proposed creating a library of reusable phenotyping algorithms (identifying case and control population sets for clinical studies).

Lead database architect

Confidential, Nashville, TN

Responsibilities:

• Wrote functional requirements and lead development efforts on two separate products - an integration engine, and record matching and linking application.
• Reviewed the data flows within the electronic health record management application. Created a comprehensive data model and a new database schema.
• Designed and developed a complete data layer framework.
• Developed modules for the integration of external data sources via Web Services API.
• Developed parsers for XML based incoming messages, including CCR, and a CCR document builder.
• Led company preparation to the 2010 IHE Connectathon.
• Designed, developed and implemented code for migration Midsouth eHealth Alliance data from Oracle to MySQL.
• Designed, developed and implemented application extracting complete patient information into XML files for the MarkLogic indexing and search engine.

Senior analyst

Confidential, San Bruno, California

Responsibilities:

• Analyzed processes and procedures of software change management at Confidential, Inc.
• Prepared a Functional Requirements Specification for an automated migration process.
• Built a MySQL database to collect migration statistics.
• Wrote Perl Coding Guidelines for internal development.

Chief Technical Officer - Consultant

Confidential , Plano, Texas

Responsibilities:

• Developed the company's IT strategy. Co-authored a proprietary technique for screening property listings.
• Architected, designed and developed a Perl application, implementing the screening technique, and property appraised value estimation.
• Created procedures for updating the database of active, sold and rental properties.
• Developed, tested and deployed the company's website.

IT Consultant

Confidential, Richardson, Texas

Responsibilities:

• Reviewed existing data model.
• Created a new MySQL database schema to enable adding and expanding functionality of the company website.
• Prepared data migration procedures and performed data migration.
• Redesigned and redeveloped existing PHP code to work with the new database.
• Ported the database and the website to a new server.
• Administered company servers (WhiteBox Linux) and MySQL database.