John Murphy Email & Phone Number

Johns Creek, Georgia, Us

VP of Data Management for BeyondTrust serving as the enterprise-wide data leader and evangelist. Initially focused on defining and delivering an enterprise data strategy and developing and implementing programs to improve and sustain the management, governance, protection, and value of BeyondTrust’s unique data assets.BeyondTrust is the worldwide leader in intelligent identity and access security, empowering organizations to protect identities, stop threats, and deliver dynamic access to empower and secure a work-from-anywhere world.

New York, Ny, Us

Led a team providing the data management, integration, business intelligence, and analytics for Finance, Underwriting, Insurance Operations, Patient Safety, and Claims functions. Key Achievements:• Remotely managed a team of seven staff consisting of business intelligence analysts, data analysts, system administrators, database administrators (DBAs), architects, and ETL developers - located in Atlanta and New York - assigning and directing work, managing schedules, and providing coaching.• Developed a 3-year analytics strategic roadmap that defines the strategic direction from data management to descriptive analytics to predictive analytics. Solicited feedback to ensure analytics strategy was aligned with corporate strategy and continuous improvement goals.• Created a data management and analytics operating model that centered on team member point of contact, their knowledge areas, their typical responsibilities, and overall team outcomes. Model approved by business stakeholders.• Managed all aspects of maintaining and supporting the Enterprise Data Warehouse (EDW) lifecycle including data architecture design, source data analysis, data management, ETL, reporting, business intelligence, and analytics projects.• Managed the delivery of reports, dashboards, and analysis, using SQL, Tableau, Cognos Business Objects, R (RStudio), Python, and CRM Analytics (a.k.a. Einstein Analytics) for all business stakeholders.• Developed SQL queries (T-SQL), stored procedures, functions, and views as needed, to fulfill ad hoc analysis requests and to source enterprise Tableau dashboards.

Columbus, Ga, Us

In this newly created role, led the generation of actionable business insights derived from unique credit card payment data assets for over 130 banks with 800 million accounts on file and 30 billion transactions a year. This includes leveraging data visualization, storytelling, and data science, to drive business impacts and create value for key internal and external business stakeholders. Key Achievements:• Partnered with Data Engineering to develop and maintain the data architecture, analytics platforms and visualization technologies to support and meet the needs for creating analytics data products.• Presented Tableau based data products to small to mid-sized bank executives, as a product offering, to grow their credit card acquisition program and maintain existing portfolios.• As an individual contributor, utilized Apache Drill (SQL) and HiveQL to analyze a previously developed credit card big data environment to identify data flow rules/processes and document data lineage and business logic to support the creation of data products for small to mid-sized banks.• Developed SQL (DB2) queries to perform data analysis and fulfill ad hoc requests as needed.

Ingelheim Am Rhein, Rhineland-Palatinate, De

Developed and oversaw the global data management, business intelligence and analytics strategy and delivery. Accomplished this by being a cross-functional agent of change with an inspiring vision and a call to action.Key Achievements:• Built an analytics and business intelligence team, from scratch, consisting of four data analysts that provided data management, business intelligence, and data science insights across four global regions.• Set the strategic direction for the department by developing a global data management and analytics operating model and strategic three-year data analytics roadmap.• Created and led virtual teams consisting of internal, external, and offshore resources to create a global data governance and data management framework. A common language, processes, and procedures were delivered and adopted for regional and global data attributes.• Led the implementation and build out for scaling the current Oracle US Enterprise Data Warehouse (EDW) to provide and meet global analytics, data visualization and reporting needs. • Championed and led global data science and machine learning efforts for predicting future macro trends, demonstrating productivity gain, and establishing early warning systems.• Led the implementation and build out of 16 country-level global BI dashboards. Initial implementation estimate was two years. Focusing on outcomes rather than tasks, successfully implemented the project in 10 months.• Managed the delivery of global data analysis, using SQL (PL/SQL), Qlik, PowerBI, and R (RStudio).• Developed SQL queries (PL/SQL) and stored procedures, as needed, to fulfill ad hoc analysis requests and to source QlikView and Power BI enterprise dashboards. • Mentored, coached, and encouraged the analytics team to explore different visualization and analytical techniques (using SQL, R (RStudio), Python, Tableau) to uncover potential business insights. Efforts resulted in identifying an under-serviced market segment.

Ingelheim Am Rhein, Rhineland-Palatinate, De

Successfully led all US animal health data analytics and business intelligence initiatives in a dynamic and continuously changing environment. Key Achievements:• Built a Business Intelligence team consisting of seven analysts, from the ground up, that was not only responsible for data management and generating customer insights to 400+ sales territories covering $1.5B of business, but also insights to the marketing, national accounts, distribution, B2B, B2C, and call center functions.• Led the design and development for implementing an Oracle US Enterprise Data Warehouse (EDW). Partnered and collaborated with data engineering to build a strong data architecture.• Interacted with marketing and sales executive leadership to establish the vision, strategy, requirements, and differentiating analytics for successfully creating a CRM 360° view of the customer. • Spearheaded the creation of a cross-functional Business Intelligence Competency Center (BICC). Outcomes, from the team, consisted of a data dictionary, reporting and data standards, governance, and a master data management (MDM) framework.• Partnered with sales and marketing leadership to define and document processes and key data elements to be used for implementing operational metrics and KPIs to support the sales process and on-going marketing programs.• Developed and updated SQL queries (PL/SQL) and Tableau dashboards, as needed, to support day-to-day operations.

Ingelheim Am Rhein, Rhineland-Palatinate, De

Lead and directed the IT delivery of corporate reporting, business intelligence, data analytics, and planning and forecasting objectives for 33 global animal health reporting entities across 150 countries. Successes included: • Partnered with CFO and Regional Heads to define the the strategy, the data requirements, the architecture, and the analytics for creating a global financial reporting environment.• Led the design and development of a financial global data mart. Developed KPIs and thresholds that caught “exceptions” in real-time. Efforts resulted in the reduction of the financial close calendar by 4 days.• Ensured that the system and data architecture was scalable and aligned with global corporate reporting strategy and compliance expectations (e.g. SOX, FDA).• Developed SQL (T-SQL) scripts to extract financial data for ad hoc analysis and data validation exercises.• Architected and developed Essbase OLAP cubes to support the financial close, budgeting, and long-range operating plan activities.

Ingelheim Am Rhein, Rhineland-Palatinate, De

Transitioned and fully integrated the global financial consolidation system and reporting platforms from France to the United States.• Reversed engineered SQL code, SQL stored procedures, ETL logic, system configurations, and business processes in order to successfully deliver the financial close within 90 days of migrating from France.• Designed and developed Microsoft Report Builder executive level business intelligence dashboards supporting the monthly closing process, audits (internal/external), global management reporting, and long range planning and forecasting. This was a first of its kind for the organization.

Ingelheim Am Rhein, Rhineland-Palatinate, De

Captured and documented business requirements and translated those requirements into functional and technical design documents. Reverse engineered application logic, system functionality, and business processes in anticipation of converting two AS400 systems and one IBM Mainframe into an Oracle Applications (ERP) instance. • Documented and reversed engineered RPG Code and system functionality in anticipation of converting two AS400 systems and one IBM Mainframe into an Oracle Applications (ERP) instance.• Designed and developed Oracle BI Discover dashboards to support accounts receivables analytics and reporting needs.• Developed PL/SQL scripts to validate data migration/integration from AS400 systems to an Oracle Application Database.

Supported extranet and intranet websites and back office applications. Captured and documented business requirements and translated requirements into functional design documents and technical specifications. Took on many stretch assignments including developing SQL scripts for data analysis and validation, updating ASP and VB source code, performing quality assurance (QA) testing, and providing hands-on desktop support to the call center team. Primary liaison between the business leads, internal end users, and development teams.

Norcross, Ga, Us

I was initially hired as an engineering technician to test, measure, and collect data on construction materials and soils, but was quickly promoted to a project manager role in the environmental services department. As a project manager, I was responsible for Phase I Environmental Assessment projects.In this role, I worked closely with clients, law firms, banking institutions, testing laboratories, contractors, and government agencies to ensure that proper due diligence was conducted and that the final reports were successfully delivered on time and under budget.

Jacksonville, Fl, Us

I was accountable for the supervision of train movement in and around the railroad yard. This position is similar to an air traffic controller, but for trains. I organized work for train crews to separate railcars from inbound trains that would then be used to construct trains for outbound destinations. I was responsible for locomotive horse power requirements and the proper placement of each railcar.

Bachelor Of Science, Biology

Mini Mba, Strategy And Entrepreneurship Essentials Program