Data Management
Resume:
Patrick O’Brien
Home: 267-***-****
Lansdale, PA 19446
Mobile: 215-***-****
******@*******.***
Profile
Business Systems Architect/Analyst with exceptional analysis and communication skills and extensive experience in the Life Sciences industry. Able to decompose complex business problems, analyze various solutions and provide leadership in the implementation of solutions. Builds relationships with project stakeholders and project teams to identify, document and prioritize requirements. Builds process models to analyze and clearly communicate complex business system changes to all stakeholders.
Background
Experienced in all phases of system development from Discovery and Business Case development to process and system design through user acceptance. Over 10 years of Managed Care experience working for healthcare information providers, pharmaceutical manufacturers and a health insurer.
Professional Experience
Magic Hat Consulting, Fort Washington, PA January 2016 – July 2016
Consultant Business Analyst at CareCam Health Systems
Worked as Business Systems Analyst at a startup developing innovative mobile applications to empower individuals to become more educated, skilled and confident in managing their own health.
Defined requirements for integrating of third-party content into cloud-based content management system.
Defined workflow for creation, approval and publishing original content items created by the CareCam clinical team.
Modeled processes for management of health and well-being articles, videos and original content in a content management system for use within CareCam mobile applications.
Defined requirements for delivering Health Content on the CareCam mobile platform through search features or delivery within well-being programs designed to educate and motivate users.
Defined requirements for administration and delivery of health challenges to motivate users to adopt health promoting activities.
Matchpoint Consulting, King of Prussia, PA February 2015- December 2015
Consultant Business Analyst at American Board of Internal Medicine
Worked as Business Systems Analyst in the Strategy Planning and Optimization team to define and prioritize business requirements for several strategic initiatives
Defined modifications to legacy systems to support differentiation of initial certification exams for new physicians and maintenance of certification (MOC) exams given to experienced physicians.
Defined enhancements required to enable pooled exams for sub-specialties that group initial certification and MOC populations together.
Defined standards and practices for modeling business processes throughout the enterprise.
Modelled operational processes for the Program Operations department.
Defined requirements for enhancements to the score reports provided to examinees to communicate their performance across medical content areas in relation to their peers.
Defined requirements for integration of data from the Accreditation Council for Continuing Medical Education (ACCME) for the purpose of granting Maintenance of Certification credits for completion of accredited CME activities.
Hired by Matrix, Glen Rock, NJ August 2014- December 2014
Consultant Business Analyst at Dun & Bradstreet
Worked as Business Systems Analyst for Dun & Bradstreet North American Delivery team on the Batch Transformation project to improve the processes by which large data products are fabricated.
Documented current state and future state processes for fabrication of batch data products.
Defined testing processes used by the business to migrate fabrication processes from mainframe to a Hadoop platform including user acceptance, parallel runs and end-to-end testing with customers
Modeled change management processes to accommodate business changes that can occur impacting customer deliverables during the transition.
Open Systems Technologies, Philadelphia, PA June 2013-June 2014
Consultant Business Analyst at Independence Blue Cross
Worked as Business Systems Analyst for Independence Blue Cross Informatics organization on the Blue Core project to integrate Member data being processed by Highmark into the Independence Blue Cross enterprise data warehouse
Documented Business and Functional Requirements to address mapping and transformation of Highmark data into the enterprise data warehouse for membership, coordination of benefits and healthcare reform.
Defined an interface for integration of health plan membership information from a third-party software platform into the enterprise data warehouse.
AETEA Information Technology, Blue Bell, PA November 2009–April 2013
Consultant Business Analyst at Merck
Worked as Business Analyst for Merck Research Laboratories (MRL) on a program to improve decision-making by enhancing project and pipeline information quality and transparency through improved information management and access.
Coordinated testing efforts for deployment involving MRL project reference, tracking, planning and management applications, SAP financial systems and business planning and consolidation applications
Defined business requirements for integrating Merck drug discovery and development project information with financial data from SAP.
Worked as the Lead Business Analyst for MRL Divisional IT program to remediate MRL applications impacted by the implementation of a new Compensation & Career Framework.
Managed communication of the impacts of the new framework to divisional IT resources.
Analyzed the impact of the new framework on more than 80 applications.
Worked as part of the Information Technology Client Services organization supporting Managed Markets Finance and Managed Markets Marketing at Merck. Responsible for definition of requirements, supporting system design, development of user acceptance testing plans & test cases, facilitation of user acceptance activities.
Creation of a Managed Markets Discount Model for the accrual of managed markets discounts and financial reporting. Synthesized a new model leveraging aspects of Merck, Schering Plough and MSP JV methodologies.
Creation of a managed markets forecasting application utilizing a common methodology for the integration of Merck and Schering-Plough.
Provided analysis, expertise and guidance in the transition from an internal formulary data management to use of third-party provided formulary data for use is sales and business intelligence applications.
TEK Systems, Plymouth Meeting, PA June 2008–November 2009
Consultant Business Analyst at Wyeth Pharmaceuticals
Worked with leaders of the Contracting, Pricing and IS teams in the Healthcare Systems organization as part a Payer Excellence program at Wyeth Pharmaceuticals.
Provided analysis, expertise and guidance in the use of Payer-level data from IMS Health and other pharmaceutical data providers.
Defined system and process enhancements for three new applications to support contracting with payers including:
oA modeling tool that uses a regression analysis to predict market share
oScorecards that track segment and account performance on a quarterly basis
oA forecasting tool that enables the creation and analysis of financial models of various contract scenarios
IMS HEALTH, Plymouth Meeting, PA 1999–2008
Business Systems Architect
Served as primary Business Architect for Managed Care, Consumer Health and Portfolio Optimization business lines.
Worked with product managers to define new and enhanced information products for pharmaceutical sales, marketing and managed care applications. Led projects through Discovery and Architecture & Planning stages by clarifying concepts, prioritizing features and defining operational processes. Presented to senior management as part of the portfolio management process to securing funding and approval. Partnered with internal and external development organizations to complete development. Managed Business Analysts working on other IMS development projects.
Created a new delivery application for the Managed Care business line which integrates plan-level prescription data with payer, plan, and PBM reference data, which was a key component to restoring growth and profitability to this business line.
Created new plan-level offerings reporting Copay and Source of Business metrics which provide significant additional insight and increased revenue over the legacy prescription metrics.
Enhanced the Managed Care delivery application by improving data quality, adding new plan-level data assets and integrating client-specific sub-national geographic views which expand the potential audience for plan-level data.
Implemented a new plan identification methodology to restore IMS Health’s competitive advantage by raising the plan granularity from about 35% to over 70%, significantly increasing the value of plan level prescription data and enabling plan-level reporting of longitudinal metrics.
Launched the Consumer Health business line in the US by establishing a process to integrate retail sales data from AC Nielsen with IMS National Prescription Audit data to track the dynamics of markets with significant activity in both prescription and over-the-counter (OTC) treatments. AC Nielsen data was also integrated into IMS global OTC applications.
Leveraged relationship with third party vendor that created the managed care reporting application to create a reporting platform for consumer health data in a matter of weeks with minimal investment.
Managed a transition from AC Nielsen to Information Resource Inc. as the source of OTC sales data to increase the quality of the product reference data, the reliability of the data delivery and better position IMS Consumer Health for delivery of subnational reporting which greatly increased the value of this business line.
Developed version 2 of IMS Health Product Development Methodology by modeling the Discovery and Architecture & Planning stages and creating templates, examples and user guides for all business architecture work products. This served as the basis for the global Integrated Product Development Process.
Modeled processes, data, systems, applications and organizations across the enterprise, from data acquisition, standardization, verification, application of statistical methodologies, data warehousing through syndicated and client-specific data extraction, summarization and presentation to facilitate orientation of new business analysts.
CAP GEMINI AMERICA, Bala Cynwyd, PA 1995-1999
Project Manager (1998–1999)
Lead a team of 8 consultants in the design, development and implementation of several electronic commerce applications that extend the functionality of a legacy auto insurance application to various business partners for Reliance Direct, a start-up direct auto insurance company.
Created a web application to facilitate claims handling by a network of independent adjusters, attorneys, and investigators to eliminate the need for expensive internal organizations.
Provided a communication link for a glass service provider to instantly verify coverage to reduce the cost and time required for these low-value claims.
Integrated a real-time credit score check from third-party vendor into the quote and rating system
Team Leader/Principal Consultant (1995-1998)
Responsible for the migration of 12 legacy billing, funding, financial, contact and claims systems into a new billing system designed and built by Cap Gemini for CIGNA Special Risk Financial. The unit handled the property & casualty business that required special considerations and claims handling for self-insured companies.
Lead all aspects of migration of critical data from multiple generations of legacy systems into the new system enabling a smooth transition with no disruption to client service or cash flow.
Modified the migration process from a one-time only approach to a phased migration to reduce risk.
Identified and addressed several integration issues between billing, funding and financial subsystems.
Created and administered an application to enable cleansing and consolidation of contact data to eliminate potential confusion of duplicates.
Trained client service and financial personnel on the migration process and use of the new system.
Senior Consultant (1997)
Worked as part of the Cap Gemini Global Marketing Unit analyzing successful projects in the insurance industry for deployment across regions.
Supported the Cap Gemini U.K. team on a distribution and contact management system for Wesleyan Assurance that enabled financial advisors, area managers, and home office personnel to manage contacts, make presentations and illustrations and interface with legacy policy management systems. This laptop-based system was a central component to the complete transformation of their life insurance business.
Business Analyst (1998-1998)
Defined a data archival system for Montell Polyolefins to retain required data from multiple legacy platforms in multiple locations that were being decommissioned as part of a migration to SAP R/3.
Analyzed on-going archival options for SAP R/3 including various packages and technologies to support the archival of large volumes of data.
Developed an implementation and staffing plan for data archival and access applications.
BELL ATLANTIC CORPORATION, Philadelphia, PA 1990 - 1995
Programmer/Analyst
Led a team in the analysis, design, testing and implementation of PowerBill, an alternative bill-delivery tool for large business clients that facilitated distribution of charges back to individual departments to expedite payment.
Responsible for all aspects of the Regional Automated Message Accounting system for inventory, validation, reformatting and distribution of call detail for toll billing carrier access billing, independent phone companies, security interrogation and message detail recording for business customers.
Earned Bell Atlantic Quality Award for outstanding achievement for upgrading the Regional AMA system, reducing run-times by fifty percent.
Educational Background
Bachelor of Science in Computer Science, Degree received: May 1990
University of Delaware, Newark, DE 19711
Concentration in Artificial Intelligence. Minor in Philosophy.
Graduate Courses in Networking, Database Design, Operating Systems, Architecture, Expert Systems
Masters of Science Courses Completed, 1991 – 1994
Drexel University, Philadelphia PA
Courses in Operating Systems, Algorithms, Data Structures, Parallel Processing
Contact this candidate