Ray Madara

Experience

• 

  Paragon

  Jul 2007 - Nov 2007

  Data Analyst (Contract Position)

  Worked onsite at Merck Pharmaceuticals at their Rahway plant. Was in e-discovery department working to query data out of their many databases to support ongoing legal projects.

• 

  The Hibbert Group

  Mar 2008 - Nov 2012

  Project manager within the Database & Market Intelligence group for projects supporting major pharmaceutical clients. Tasks and responsibilities include: - Developing, documenting and testing technical solutions or processes that include data transmissions, database design/testing/analytics, and web applications. Documentation ranges from BRD's, programming requirements (for IT), user/data flows to user documentation.- Analyzing requests to evaluate integration solutions based on enterprise data sources- Translating client requirements into development specifications for IT developers- Coordinate with both client and IT to develop project plans in order to implement solutions in a timely fashion and manage project costs- Presenting fine details of development (or finished product) to client or upper management at a high level- Responsible for working with database developers to create generic database structures and processes to be adapted for any client requests- Coordinate and execute test plans against new development projects- Create website wireframes for web application solutions that heavily utilize complex backend databases- Manage team priorities and delegate priorities where necessary- Manage product issues and continue to improve systems to provide the best possible service to the clients Show less - Manage HCP marketing database for a major pharmaceutical client. - Utilizing Oracle applications to set up survey's and campaigns. - Utilizing SQL to test new data inputs/outputs, monitor performance, and for ongoing/adhoc reporting. - Extensive experience with XML file structure for transmitting data from one source to another.- Responsible for taking business requirements and translating in a technical way to design various business solutions. - Required to create extensive documentation and project plans to lead development efforts for database and database related projects. Show less - Team Lead specialist for managing new client projects- Developed requirements documentation for the client- Developed technical specifications for setting up new web services, email blasts, file conversions, and customized direct mail pieces- Worked closely with client and vendor partners to maintain daily operations, file transfers, or other potential issues- Created documentation for ongoing operations including Interface Agreements with other vendors.- Created internal checklists for daily/weekly/or monthly team activities- Created custom access databases for various team work flows and client reporting Show less - Monitored and Controlled daily team operations and processes- Utilized mainframe environments for testing/production table setups. Also used for running job procedures for reports and adhoc processing- Developed technical specifications for setting up new work flows for enterprise fulfillment system.- Requirements gathering and submission for developing new email blasts.- Requirements gathering for internal file conversions to vendor specified XML layouts - Requirements gathering for customized direct mail pieces.- Worked closely with client and vendor partners to maintain daily operations, file transfers, or other potential issues- Created documentation for ongoing operations including Interface Agreements with other vendors.- Created internal checklists for daily/weekly/or monthly team activities Show less

  • Business Analyst

    Jun 2011 - Nov 2012

  • Business Intelligence Specialist

    Jun 2010 - Jun 2011

  • Sr. Technical Specialist

    Sept 2009 - Jun 2010

  • Technical Specialist

    Mar 2008 - Sept 2009
• 

  IQVIA

  Nov 2012 - Apr 2024

  * Technical Product Manager for the OCE (Orchestrated Customer Engagement) Marketing (Multi Channel Marketing) product offering powered by Salesforce Marketing Cloud. * Hands on use of Salesforce Marketing Cloud to build POC (proof of concepts) using out of the box functionalities like Cloud Pages, Data extensions, queries and automations (to name a few). * Working with stakeholders from many internal teams, globally, to gather all client requirements to be prioritized on a feature backlog or near-term roadmap* Lead the design of innovative product features based upon industry requirements for IQVIA’s Life Sciences multi channel marketing product offering.* Author high quality design and functional specifications and user stories within an agile methodology using tools like JIRA, Gitlab, and Confluence.* Interact and lead engineering teams to drive high quality product feature development* Help manage account provisioning with our partner, Salesforce, from a process and documentation standpoint* Partner with Salesforce Marketing Cloud to establish process and documentation to scale the product offering for fast and efficient implementations Show less IMS Health is now IQVIA* Working on the Implementation Delivery team to integrate their data and configure Nexxus Marketing (a cloud based application designed to enable life sciences companies to manage multi channel marketing Databases, campaigns, and reporting that is suprisingly simple, formerly Appature Nexus). * Worked with Life sciences clients to understand and document their business requirements* Design and document database ERD's, User Interface specs for development, data mapping for ETL loads, API specifications, and more* Working with the development team to document, implement, and test the solution. * Quality assurance and testing of new solutions* Designed and Developed technical documentation templates and best practices for the internal team* Designed standardized ETL processes in Snaplogic & Informatica that could be re-used by teams globally to reduce project scope, costs, and schedule to deliver* Act as a SME for standard ETL’s to drive adoption via managing global documentation, providing training videos, or even one-on-one training with individuals* Act as a product liaison for delivery to ensure our Client’s requirements and needs are being met. Also to gain information on the product roadmap and product activities that I can share with my team. * Trained, lead, and mentored new Solutions Architects * Worked with clients to aide in Training and UAT of the delivered product Show less Originally hired with SaaS startup called Appature which was acquired by IMS Health who is now IQVIA- Working on the Customer Success (implementation) team; understand client business rules to integrate their data into Nexus Marketing (a cloud based application designed to enable life sciences companies to manage CRM Databases, campaigns, and reporting that is suprisingly simple). - Design and document database ERD's,User Interface specs for development, data mapping for ETL loads, API specifications, and more- Working with the development team to document, implement, and test the solution. - Quality assurance and testing of new solutions- Work with client to perform final UAT. - Train the client operations team that will be responsible for the system Show less

  • Director Product Offering Management

    Mar 2021 - Apr 2024

  • Associate Director, Product Management

    Aug 2017 - Mar 2021

  • Senior Solutions Architect

    Mar 2013 - Aug 2017

  • Solutions Architect

    Nov 2012 - Mar 2013
• 

  Salesforce

  Apr 2024 - now

  Product Management Director - Life Sciences Cloud

  Product Manager for the new Life Sciences CloudLead the requirements, strategy, and design of innovative product features based upon industry requirements for Life Sciences customers.Build subject matter expertise in Data Cloud, Marketing Cloud on CORE, and Agentforce to bring integrated solutions across Salesforce products. Author high quality design and functional specifications for epics and user stories within an agile methodologyInteract with engineering team to drive high quality product feature developmentInteract with customers, services, and sales to understand new use cases for consideration in roadmap release pipelines and feature backlogs Show less