Open To Work
Brian Stephenson
MONTAGUE,NJ
Summary
Dynamic Senior Consultant with extensive experience in Master Data Management at IQVia, specializing in Informatica MDM Hub and data governance. Proven track record in delivering robust solutions that enhance data integrity and compliance. Adept at cross-functional collaboration and problem-solving, driving successful project outcomes in fast-paced environments.
Overview
40
40
years of professional experience
Work History
Senior Consultant – Master Data Management
IQVia/HighPoint Solutions LLC
Bridgewater, NJ
01.2016 - 06.2023
- Collaborated with Master Data Management teams to design and implement tailored master data management solutions for corporate clients, enhancing data integrity across IQVia and HighPoint Solutions.
- Completed team projects for major client: Johnson & Johnson, Flexion, Allergan, Camping World, Pfizer, Providence Health Care, and Takeda/Shire.
- Team delivered and implemented Master Data Management solutions and updates for Party Master or Product Master data systems for each client.
- Developed Informatica Data Director Data Steward applications and governed standard values and data cleanse lists.
- Primary tools of use were Informatica MDM Hub and Informatica Data Director, Informatica PowerCenter, Linux servers, and Oracle and SQL Server databases.
- Worked closely with Informatica technical support on issues and bugs in version releases for Informatica MDM.
- Worked with Master Data Management system transitions from Reltio (configuration and migration).
- Experience with Talend, SnapLogic.
Consultant - Cloud Systems Architect
Bayer Healthcare
Tarrytown, NY
03.2014 - 12.2015
- Developed cloud-based web services and product offerings for Bayer Diabetes Care division, enhancing patient engagement and care delivery.
- Completed architecture, design and development of cloud-based web services and database functionality accessible by Android and Apple mobile devices, using C# .Net, ASP.NET, WFC Web Services, SQL Server 2012, Mirth Connect, and other related technologies.
- Implemented web service security technologies and processes, focusing on OAuth protocol and adherence to industry and government standards for security and data privacy.
- Collaborated with Electronic Medical Records (EMR) organizations to deliver HL7 format EMR feeds of patient-related diabetes care information, improving data interoperability.
Manager of Application Development
VideoBank (LHS LLC)
Northvale, NJ
05.2012 - 12.2013
- Managed VideoBank's multi-platform development team as lead architect, overseeing design, development, and optimization of VideoBank suite of video observation and location management products for military, police, sports, and entertainment industries.
- Developed multiplatform architecture and communication strategies using .Net and SQL Server technologies, WPF and WCF, video processing, and location technologies.
- Implemented Agile programming initiatives, enhancing team collaboration and development processes.
Senior Software and Database Architect/ Engineer
ThorTech Solutions, Inc.
White Plains, NY
04.2007 - 04.2012
- Collaborated on design, modeling, development, and administration of Election Analysis System (EAS) components for collecting exit poll information across all political primaries, caucuses, and general elections in the U.S., utilized by National Election Pool organizations including ABC, NBC, CBS, CNN, Fox News, and Associated Press.
- Implemented design and development in Agile environment for EAS, focusing on T-SQL, C#, ASP.Net, jQuery, Web and XML programming, and SQL Server 2008 database administration and support.
- Working with Linux, Tomcat and PostgreSQL in the Amazon Web Services (AWS) cloud, using Elastic Cloud Computing (EC2) and Simple Storage Service (S3).
Senior Software Architect/ Engineer, Pfizer Projects
HighPoint Solutions, LLC
Warren, NJ
04.2004 - 01.2007
- Software Architect and developer on HighPoint development consulting team for Pfizer.
- Implemented projects using Agile programming to electronically generate and distribute customized data reports for Pfizer products and competitors to sales representatives via integration with laptop sales force automation (SFA) software.
- Implemented data transfer layers, appropriate architecture and data transfer mechanisms from Oracle sales databases through SFA software to the laptop of sales reps.
- Developed web site for Pfizer Sales Representative Portal to deliver reports to personnel using ASP.NET, C#, and SQL Server 2005, including supporting Windows Services.
- Led development of reporting generator system to automate generation of Excel reports from XML report definitions on a scheduled basis.
- Created web-based sales dashboard for Novo Nordisk using multidimensional data.
- Transitioned from Aecio Technology to Pfizer
Director, Application Architecture and E-Business
Schering-Plough Corporation
Union, NJ
01.2000 - 01.2004
- Multiplatform enterprise level software development Team Leader using modified Agile programming process based on Microsoft Solutions Framework, to improve processing efficiencies.
- Recommended web development and e-business strategy and application architecture for SP, leveraging Ariba software and collaborating with Microsoft development support team.
- Successfully implemented Electronic Expense Reporting project (EER), based on Ariba, used by 4000 field sales representatives to declare expenses and track spending, fulfilling FDA guidelines.
- Achieved interfaces to General Ledger, Accounts Payable, Wells Fargo and American Express (for direct payment), and to compliance systems for monitoring sales spending on physicians.
- Led GxPharma pilot project to implement centralized Documentum-based GMP document authoring and tracking system for FDA-monitored manufacturing sites via Wide Area Network.
- Completed Product Complaint system, for high level problem analysis on product manufacturing by coordinating and integrating data access from various corporate product complaint reporting systems, including adverse events systems, fulfilling FDA guidelines.
- Designed and approved technical aspects of projects, including business analysis, solution development, budget estimates, data content modeling, management of multiplatform development teams, quality control testing, system implementation supervision, and production support design.
- Directed upgrades of systems to VB.NET, C#.Net, and ASP.Net, ensuring alignment with resource and training requirements.
- Participated in Schering-Plough Architecture Review Board (ARB) to conduct technical reviews of ongoing divisional application projects.
- Completed significant individual web-based applications.
- Contributed to pharmaceutical production processes
Intranet/E-Commerce Technical Architecture Manager
Schering-Plough Corporation
Union, NJ
01.1992 - 01.2000
- Scoped, developed and implemented newly introduced corporate Intranet-based enterprise-level web applications, using tools including Microsoft Visual Studio (Visual Basic and C++), to access to legacy databases in mainframe DB2 and Oracle.
- Technical Architect in successful division wide e-commerce implementations, including Ariba e-procurement and expense reporting.
- Integrated Ariba purchasing with internal supply chain systems.
- Participated in the Architecture Review Board.
- Created enterprise Intranet development standards on coding language guidelines and enterprise systems considerations.
Project Manager/Technical Architect, RAPIDS System/Professional Service & Marketing Information Systems Manager/Developer/Architect
Schering-Plough Corporation
Union, NJ
01.1983 - 01.1992
- Led technical management of resources for Promotional Impact Decision Support System (RAPIDS), ensuring system alignment with organizational goals.
- Implemented RAPIDS software Delphi Sessions at various international subsidiaries, using software to help analyze and optimize sales force size and detailing tactics, resulting in lower costs and higher productivity for sales teams.
- Administered department-wide LAN and email systems while developing customized business applications to enhance operational efficiency.
- Worked with Research department on identifying published adverse events articles, and integrating adverse event system reports into business communications.
Education
Bachelor of Science - Biology
Pennsylvania State University
University Park, PASkills
- Master Data Management
- Informatica MDM Hub
- Data governance
- Cloud architecture
- SQL programming
- Database administration
- Agile methodologies
- Software development lifecycle
- Technical documentation
- Problem solving
- Informatica IDD & IDQ
- Reltio
- Enterprise architecture
- Metadata Management
- C#NET
- VBNET
- ASPNET
- JavaScript
- jQuery
- SQL Server
- Oracle
- AWS (EC2, S3)
- Web Services (REST/WCF)
- EMR/HL7
- OAuth
- Mirth Connect
- Agile SDLC
- Team Management
- Cross-functional Collaboration
- 21 CFR Part 11
- GxP validation
- FDA Validated Environments
Training
- C# and Visual Basic .Net development training
- Team Leadership and Management training
- Microsoft Solutions Framework and Agile Programming training
- Informatica PowerCenter, MDM Hub, and Informatica Data Director training
- SQL programming and SQL Server 2008+ administration training
- Reltio and JSON training and programming
Core Skills
Informatica MDM Hub, IDD, IDQ, Reltio, Data Stewarding, Data Quality, Metadata Management, C#.NET, VB.NET, ASP.NET, JavaScript, jQuery, SQL Server, Oracle, AWS (EC2, S3), Web Services (REST/WCF), EMR/HL7, OAuth, Mirth Connect, Agile SDLC, Team Management, Cross-functional Collaboration, Enterprise Architecture, 21 CFR Part 11, GxP, FDA Validated Environments
Work Preference
Job Search Status
Open to workWork Type
Contract WorkLocation Preference
RemoteSalary Range
$9/hr - $90/hrTimeline
Senior Consultant – Master Data Management
IQVia/HighPoint Solutions LLC
01.2016 - 06.2023
Consultant - Cloud Systems Architect
Bayer Healthcare
03.2014 - 12.2015
Manager of Application Development
VideoBank (LHS LLC)
05.2012 - 12.2013
Senior Software and Database Architect/ Engineer
ThorTech Solutions, Inc.
04.2007 - 04.2012
Senior Software Architect/ Engineer, Pfizer Projects
HighPoint Solutions, LLC
04.2004 - 01.2007
Director, Application Architecture and E-Business
Schering-Plough Corporation
01.2000 - 01.2004
Intranet/E-Commerce Technical Architecture Manager
Schering-Plough Corporation
01.1992 - 01.2000
Project Manager/Technical Architect, RAPIDS System/Professional Service & Marketing Information Systems Manager/Developer/Architect
Schering-Plough Corporation
01.1983 - 01.1992
Bachelor of Science - Biology
Pennsylvania State University