Stephen Kern Email & Phone Number

Fair Lawn, Nj, Us

Washington, District Of Columbia, Us

Deliver high value business intelligence, data warehousing, master data management, ERP, business process design, and project management solutions. Strategically lead and guide complex, fast-paced projects to completion both on-time and within budget and scope. Key Achievements:1) Spearheaded the development of a validated quality analytical dashboard for Normalized Compliant Rate, LIR, MIR, CAPAs, and Complaints for a PA-based pharmaceutical company. 2) Clearly defined and developed strategy and a mitigation plan for a NJ-based pharmaceutical company. Completely replaced the MES system within the company’s North American consumer manufacturing sites. Re-organized and utilized data to drive critical decision-making processes.3) Program Manager for the design, development, and launch of a comprehensive master data management system for products at a PA-based pharmaceutical company. Deployed Informatica-MDM and IDQ modules to most efficiently capture, analyze, and utilize data.4) Lead an assessment to migrate a major pharmaceutical company’s manufacturing data lake, data warehouse and reporting systems to the cloud using Snowflake. Currently leading the migration.

New York, New York, Us

Directed global business intelligence efforts in delivering IT solutions to improve organizational efficiency and productivity. Conducted commercial sales analytics for US trade, injectibles, generics and animal health business units. Managed data warehousing to provide full integration of SAP manufacturing data and incident tracking, laboratory information, and annual product review compliance. Spearheaded the SAP/PGS integration through the Federated HANA Cloud Analytics Hub environment. Oversaw real-time data warehousing for product allocation of over $30B sales and product rebate tracking. Manage Level 2 and 3 support for with reporting and analytics within the Pfizer global supply organization. The data warehouse staff is organized around Solutions Engineering and Delivery, using SOW-based consulting firms including Accenture, IBM, and TCS for most projects.Delivered hands-on program and project management in the areas of global supply chain analytics, SAP supply chain analytics, and integrated manufacturing excellence.Key Achievements:1) Supply Chain -- Developed and implemented a supply chain analytics and business intelligence system that provided visibility to all levels of management. 2) Data Warehouse -- Defined the strategy for a manufacturing unified data warehouse that achieved a hard ROI of over $50M within 6 years, and $200M3) Quality Issues Analytics -- Led the team in developing a Quality Issues Analytics system that allows manufacturing to track, re-mediate, eliminate, and forecast drug product issues and complaints. 4) End-to-End Analytics -- Won the 2016 W.E. Upjohn Award for Integrated Manufacturing Excellence in providing End-to-End Analytics across Pfizer. 5) Project Launch -- Successfully launched projects, including solutions for global supply chain analytics, SAP supply chain analytics, integrated manufacturing excellence, and a unified data hub. Transitioned information into the AWS cloud,

Parsippany, Nj, Us

Directed the data warehouse and reporting staff throughout 7 divisions, and a departmental expense budget of $3M. Developed and implemented a global data warehouse to support finance, COM, production, inventory, purchasing, sales, production forecasting. reporting, and analysis. Utilized Crystal Enterprise browser and hardcopy, Crystal Analysis (OLAP), and Vista Plus for report distribution and archiving. Key Achievements:Implemented an Enterprise Financial reporting system that digitally distributed all reporting globally. Developed a worldwide sales data warehouse that prevented profit losses of over $200M annually.

Worked closely with fortune 500 companies in deploying ERP replacement systems to enable a smooth transition over the Y2K period.

Automated all functions of the US/Canadian divisions. Designed and programmed a custom system covering all aspects of the business. Deployed an end-to-end ERP system. Supported, through automated systems, company growth from a $30M to a $350M business within 5 years.