Principal Data Architect Resume Example

Love this resume?

By clicking Build Your Own Now, you agree to our Terms of Use and Privacy Policy

Jessica Claire
Montgomery Street, San Francisco, CA 94105 (555) 432-1000,
Career Overview

Business Intelligence/Data Warehouse Manager with background on multiple analytics platforms. Versed in the areas of clinical trial database design, data warehousing, data modeling, dashboard development and statistical analysis. Extensive functional knowledge of clinical trial processes/development, health care management and health care delivery.

  • QlikView, Tableu, QlikView Applications: Medidata, Phase Forward, Oracle
  • Server/Publisher, Matlab, COGNOS, Business Clinical, OpenClinica, SAP, Finance, Payroll,
  • Objects,PowerView, Matlab, PowerBI, Data Human Resources, EMR, Clinical, Insurance,
  • Warehousing, ETL, SSIS, SSAS, SSRS, OLAP Meditech, eCW Misc Technical: ERWIN, Unix,
  • Databases: Microsoft SQL Server 2008/2012, XML, HTML, Informatica
  • Oracle 11g, Pervasive SQL, mySQL, Star Schema
  • Languages: PL/SQL, T-SQL, SQL,
  • Microsoft .NET, Unix Scripting, R, Python
Microsoft .NET, architect, Budgeting, BI, Business Intelligence, Business Objects, business processes, COGNOS, hardware, Crystal, data entry, data warehouse, Databases, database, debugging, Delivery, product design and development, edit, ERWIN, ETL, senior management, Finance, Financial Analysis, forms, functional, General Ledger, HTML, Human Resources, HR, Informatica, Insurance, investments, Languages, Leadership, logic, Matlab, Meditech, meetings, Publisher, mySQL, enterprise, operational data store, OLAP, operating systems, optimization, Oracle, PL/SQL, Oracle and SQL, Payroll, policies, processes, proposals, Python, Quality, QA, RDBMS, reporting, Safety, SAP, MS SQL, Microsoft SQL Server, SQL, statistical analysis, strategic, Sybase, system design, T-SQL, Unix, Unix Scripting, upgrades, vision, Warehousing, XML
Work Experience
12/2013 to Current Principal Data Architect Financial Industry Regulatory Authority, Inc. | Los Angeles, CA,
  • Define and architect the central data warehouse/operational data store while integrating numerous data sources.
  • Researched various enterprise analytics and reporting solutions, defining the business intelligence roadmap for senior management.
  • Define, architect and develop the 'Cloud Based' Microsoft Power BI analytics platforms.
  • Establish guidelines and procedures for incorporation of new business reporting requirements into the existing data warehouses and data marts.
  • Manage and monitor the Informatica ETL environments for a number of third party applications.
  • Built various analytical models for business areas including investments, Finance, General Ledger, HR and Payroll.
12/2011 to 12/2013 Clinical Data Architect/Developer Experfy Inc | Cambridge, MA,
  • Collaborated with HSL Executive Committee to define measurable corporate KPIs for Health Care Delivery.
  • Created QlikView analytics prototype applications for Electronic Medical Records and Managed Health Care review.
  • Developed QlikView applications/dashboards using visual analytics within the areas of Medicine, Pharmacy, Quality and Finance.
  • Coded user-customizable applications that converted raw data into understandable graphical formats and reports.
  • Developed metrics used to determine inefficiencies and areas for improvement.
  • Tracked, analyzed and interpreted data trends in all business areas for presentation to the Executive Committee.
  • Drafted Business Intelligence technical documents, including whitepapers.
12/2010 to 12/2011 Project Manager Massachusetts General Hospital | Charlestown, MA,
  • Prepared and presented technical proposals to senior management for clinical trial development.
  • Designed and developed Clinical Trial CRFs and associated edit logic using Oracle Cinical, Medidata and Phase Forward toolsets.
  • Led meetings and created action plans with departmental managers to review project statuses and proposed changes.
  • Identified "bottlenecks" and implemented new and improved processes and policies for Clinical Trial Management.
  • Developed IT strategic vision and drove key departmental objectives.
  • Led cross-functional teams to analyze and understand the operational impacts and opportunities of technology changes.
  • Developed metrics used to determine inefficiencies and areas for improvement.
  • Conducted activity-based analysis of business processes converted to metrics and made recommendations based on the findings.
  • Drafted detailed design objectives and developed architectural and system design documents.
03/2006 to 05/2010 Principal Reporting Architect Mantech International Corporation | Yorktown, VA,
  • Managed the road map for Data Warehouse/Reporting product design and development within the Clinical Sciences function.
  • Streamlined acquisition of reporting requirements using Crystal to disseminate clinical trial data for Medidata RAVE, Phase Forward and Oracle Clinical trials.
  • Supervised the work of 3 BI software engineers developing analytics for clinical trial management.
  • Collaborated with Clinical Sciences Leadership to establish tools to monitor and report on Safety Issues using analytics.
  • Coordinated with QA testers for end-to-end unit testing and post-production testing on Business Objects analytics.
  • Led working groups to develop mitigation strategies and prepare standard operating procedures.
  • Resolved customer reporting issues by establishing workarounds and solutions and by debugging and creating defect fixes.
  • Wrote cross-platform software for Business Objects components and exported system interfacing files.
  • Prepared technical architecture proposals for enhancements and integration of existing third party clinical software systems.
02/2004 to 03/2006 Clinical Data Manager BOSTON SCIENTIFIC CORPORATION | City, STATE,
  • Designed clinical trial CRF forms for Phase III trials.
  • Developed and programmed clinical trial forms using Medidata RAVE and Phase Forward.
  • Monitored clinical trial data entry, resolved queries and scrubbed data.
  • Using Business Objects and/or COGNOS developed reports that identified clinical trial problem areas.
  • Created extract files for statistical analysis and FDA submissions.
03/1999 to 01/2004 Database Administrator BOSTON SCIENTIFIC CORPORATION | City, STATE,
  • Management of all aspects of the hardware and software infrastructure for Oracle and SQL Server databases.
  • Performance optimization tuning of SQL queries for online and batch processes.
  • Budgeting for hardware and software needs in support of the RDBMS.
  • Served as sole database administrator for Sybase, Oracle and MS SQL running on various operating systems.
  • Designed, documented and executed maintenance procedures, including system upgrades, patch management and system backups.
  • Served as sole database administrator for Sybase, Oracle and MS SQL running on various operating systems.
Education and Training
Expected in M.B.A | FINANCE Suffolk University, Boston, MA GPA:
FINANCE Emphasis on Financial Analysis B.S: BIOLOGY
Expected in | Pre-Veterinary Studies University of Massachusetts, Amherst, MA GPA:
Pre-Veterinary Studies

By clicking Build Your Own Now, you agree to our Terms of Use and Privacy Policy

Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

How this resume score could be improved?

Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:


Resume Strength

  • Formatting
  • Length
  • Personalization
  • Strong Summary
  • Target Job

Resume Overview

School Attended
  • Suffolk University
  • University of Massachusetts
Job Titles Held:
  • Principal Data Architect
  • Clinical Data Architect/Developer
  • Project Manager
  • Principal Reporting Architect
  • Clinical Data Manager
  • Database Administrator
  • M.B.A