April 2013 - Current
Business Analyst
Pharmaceutical Company (Veeva CRM)
- Define business and functional application requirements to integrate 3 sales forces into Veeva CRM
- Organize and facilitate internal team and client-facing meetings
- Manage and mitigate project issues and risks
- Collaborate with Commercial Data Warehouse and Testing and Validation teams
Apr 2012 – April 2013
Business Analyst / Reporting Team Lead
Pharmaceutical Company (OBIEE Reporting System)
- Inventoried and rationalized 400+ SQL/manually created or maintained reports into self-serve reports
- Defined business and functional reporting requirements to create metadata model and subject areas within OBIEE
- Managed offshore development, reporting, and testing teams (10-12 resources)
Feb 2010 - Jan 2012, Mar 2007 - May 2007
Business Analyst / Technical Team Lead / Project Manager / Subject Matter Expertise / ETL Analyst
Pharmaceutical Company (Commercial Data Warehouse)
- Defined business and functional requirements, designed, and implemented multiple solutions to do the following:
- Load new Rx and DDD Class of Trade data into the Commercial Data Warehouse, aggregate, and provide extracts to downstream system
- Enhance the capabilities of the client’s Primary Care marketing campaigns via various data sets within the Teradata semantic layer for the Campaign Management System
- Modify an existing process that provides Cost and Coverage dynamic data sets to Veeva CRM to present specific statistical product data to Health Care Providers via slide presentations
- Support the business needs of defining business rules for the sampling of controlled substances at an address level
- Load historical interactions from the pharmaceutical company acquired by the client into the client’s Central Interactions Repository (CIR) to be consumed by downstream systems
- Integrate and support the legacy campaign management operations and reporting requirements of a recently acquired pharmaceutical company into the client’s existing Campaign Management System.
- Develop a system to store Health Care Provider (HCP) Preference restrictions (exclusions, suppressions, and opt outs)
- Performed an analysis of the client's data flows, and provide recommendations/guidelines to effectively and efficiently manage their data processes
- Managed teams of 3 offshore resources per project to build, test, deploy, and temporary support solution
- Managed project scope, plan, financials, status reports, issues, and risks
- Drafted PCR (Project Change Request) documentation to modify the contract agreement with client
- Provided subject matter expertise to Technical Team Lead, Client Project Manager, and Offshore resources to implement solutions to improve data integration and enhance the management of multi-channel marketing across 3 separate projects
Aug 2009 - Jan 2010, Mar 2007 - Nov 2007
Data Integration Designer/ Developer
Pharmaceutical Company (Siebel Life Sciences 8.x)
- Assessed the client’s existing Integration Solution, designed, developed, tested, and implemented automated solutions to enhance the interface to better manage data consistency between the source application and Siebel application
- Migrated source data from source systems to pilot Siebel application
Mar 2008 - Jan 2010
Integration Subject Matter Expert / Technical Lead
Pharmaceutical Company (Customer Master to Siebel Life Sciences Integration)
- Provided subject matter expertise in the implementation of an additional subject area and modifications to the existing Customer Master to Siebel integration process
- Implemented a one-way integration between the client's Customer Master and Siebel applications for account and contact entities
- Managed teams of 4-6 resources, migration and testing activities, and inter-team collaborations
Nov 2007 - Mar 2008
Information Management & Architecture Strategist
Pharmaceutical Company (Information Management & Architecture)
- Assessed the current state of the client’s Enterprise Architecture, and assisted in the development of a 5-year Master Plan/Roadmap to realize an optimized Enterprise Architecture
Apr 2006 - Aug 2006
Data Conversion Designer / Developer
Dental Product and Equipment Manufacturer (Siebel Life Sciences 7.7)
- Analyzed, Designed, Built, Tested, and Implemented a data solution to load source data into the new Siebel application via Informatica PowerCenter and Siebel EIM
Sept 2004 – Mar 2006, Sept 2006 - Mar 2007
Data Conversion Designer / Developer / Rational Change Management Administrator / PM Assistant
Hospitality Company (Siebel eHospitality 7.8)
- Migrated data from various source systems into the newly implemented Siebel application utilizing Informatica PowerCenter and Siebel EIM
- Automated the data migration process, and performed system, QA, and performance testing activities
- Managed the usage of RequisitePro, ClearQuest, and ClearCase (Rational Suite), and provided training to the users
- Assisted Project Management in day-to-day activities to maintain project