Senior Consultant resume example

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