Ryan Pass Email & Phone Number

Lawrence Township, Nj, Us

• Manage the site's IT roadmap, project portfolio, and end-to-end architectural design documentation to accurately and comprehensively represent the current and target-state landscape for upstream/downstream system integrations.• Support the multi-year IT integration and synergy between Celgene, and BMS in the manufacturing, of CAR T-cell therapy, including the site transition from Oracle EBS to SAP S/4 HANA.• Collaborate across regions with business and engineering teams to mitigate risks in a 24x7 (GxP) environment, ensuring compliance and operational continuity.

Woodinville, Washington, Us

Sr. Manager, Enterprise Systems & Digital Transformation (05/2021 – 12/2023)• Partnered with the Finance and Accounting teams to manage and enhance the operational systems and oversee the implementation and development of Software as a Service (SaaS) projects and tools including Anaplan (FP&A), Blackline, and the support of Oracle JD Edwards E1 (ERP).• Led daily Agile/Scrum sessions with the vendor in transitioning SMWE’s data infrastructure and reporting from on-premises to Microsoft Azure (Data Lake, Databricks, Synapse Analytics, Power BI).• Managed the IT team responsible for Business Intelligence (BI) development, master data management, and data engineering.• Developed a Business Intelligence Center of Excellence to enable the business to create reports while aligning to standards to maintain consistency in reporting across the enterprise.Manager Finance Systems & Processes (01/2017 – 5/2021)• Oversaw the data management activities between Oracle JD Edwards E1 (ERP) and SAP BPC during critical planning, month-end close, quarterly forecasting, budgeting, and consolidated financial reporting.• Ensured data quality and accuracy between Oracle JD Edwards E1 (ERP) and SAP by developing data validation and reconciliation processes reducing closing times by 50%.• Managed the BPC platform including Microsoft SQL Servers, Analysis Services (SSAS) OLAP cubes and dimensional models, data hierarchies, data security, MDX, SSIS packages, and VBA scripts for FP&A.• Responsible for maintaining ITGC standards and SOX compliance for all financial systems and tools.• Led SaaS projects including Anaplan (S&OP), Concur, and Vistaar, ensuring timely and budget-compliant delivery.• Developed the Enterprise BI reporting strategy and roadmap in collaboration with the CIO for transitioning obsolete technology.

Redmond, Washington, Us

Project: IT Managed Services (08/2015-01/2017)• Provided technical leadership in Business Intelligence (BI) by leading the delivery of reporting and analytical solutions that enabled well-informed decision-making and continuous improvements for teams in IT support and the data centers, which helped to improve operational efficiency for SLAs and customer NSAT performance.• Developed Executive Level presentations for monthly (MBR) and quarterly business reviews (QBR) for management.Project: Retail Stores (06/2014-07/2015)• Oversaw the development team in building the retail store’s data warehouse, which enabled omnichannel analysis and alerting capabilities on activities across the eCommerce and the Microsoft physical stores.• Facilitated daily Agile/Scrum sessions with the onshore and offshore engineering teams.• Analyzed business requirements to understand business goals, and challenges, prioritized user stories, and the product backlog.• Created logical and physical data models using Erwin to map rules between MS Dynamics AX 2012, MS Dynamics AX, and third-party OLAP tools.Project: Xbox (07/2013-05/2014)• Managed the development of the customer insights reporting platform that provided a 360-degree view of the customer's experience with the Xbox One console. • Used an Agile/Scrum methodology to manage the development and prioritization of the backlog.• Engineered ETL pipelines to process data from disparate sources e.g., telemetry, customer support, social media, and engineering.• Developed MS SQL OLAP cubes and various SQL and Excel reports where engineering and support teams could gain valuable insights into the product. • Successfully reduced product issues and enhanced customer satisfaction during the Xbox product launch.

Bellevue, Wa, Us

• Technology partner for the Finance and Marketing teams in developing data solutions for marketing spend analysis.• Developed datasets from multiple disparate systems, from departmental SQL Servers to the enterprise data warehouse (Teradata), for use in SAS statistical models in fraud, customer behavior, churn, and nationwide promotions.• Created Tableau dashboards for real-time insights into store commissions, empowering Finance teams.

Burbank, Ca, Us

• Led a team in developing a cross-functional online ad reporting platform for ESPN.com, ABC.com, and Disney Online, which significantly improved the reporting speed and accuracy from several days to seconds with detailed insights into ad campaign performance, enabling stakeholders to make data-driven decisions promptly.• Collaborated with business stakeholders in defining strategic objectives and building actionable KPIs for reporting.• Within six months of deployment, increased the user base from 60 to 600, delivering over 10K monthly reports and supporting all Disney online properties.

New York, Ny, Us

• Led application design sessions with business stakeholders in the development of the IT PMO resource utilization project. • Developed SQL-based dashboards and KPIs in Business Objects for the PMs and CIO, providing valuable insights and visibility into top-to-bottom IT activities.

• Provided support for Neonatal, ICU, and Cardiology software systems, ensuring successful implementations.

Bachelor Of Business Administration (B.A.), Management Information Systems

Certificate, Oracle Application Development