Bachelor's degree @
Temple University - Fox School of Business and Management
STRATEGY ♦ BUSINESS INTELLIGENCE ♦ ADVANCED DATA ANALYTICS
Accomplished BI and advanced data analytics strategist and delivery leader adept at developing innovative and impactful analytic solutions to inform strategic decision making, as well as measure, monitor and improve corporate performance. Particularly effective at translating complex strategic challenges into relevant analytic frameworks, sourcing the most relevant data, developing
STRATEGY ♦ BUSINESS INTELLIGENCE ♦ ADVANCED DATA ANALYTICS
Accomplished BI and advanced data analytics strategist and delivery leader adept at developing innovative and impactful analytic solutions to inform strategic decision making, as well as measure, monitor and improve corporate performance. Particularly effective at translating complex strategic challenges into relevant analytic frameworks, sourcing the most relevant data, developing advanced analytics and modeling, driving business adoption, and delivering results.
>19 years of experience in the successful design, development, implementation, and support of critical systems leveraging data analytics and insights to provide a business advantage
>Broad industry and functional experience including Consulting, Consumer Products, Financial Services, Insurance, Pharmaceuticals, Legal, Manufacturing, and Oil & Gas, Finance, HR, Information Technology, Product Manufacturing, Marketing, and Sales
>Deep and broad subject-matter expertise in strategic planning, business analytics, advanced analytics, data mining, predictive modeling, data visualization, statistical modeling, price optimization and demand analysis
>Broad and comprehensive knowledge of most major business intelligence tools/platforms including Business Objects (SAP), Tableau, Microstrategy, Microsoft Reporting Services, Tibco Spotfire
>Significant experience and proven success serving as an advisor to senior executives and business stakeholders
Principal Consultant @ Lead consulting engagements that deliver high impact analytic/BI capabilities and solutions. Sample consulting services include;
•Strategy; analytic and BI advisory; business need and value assessments, business case development, roadmap planning
•Advanced Analytics; specialize in data mining, statistical analysis, forecasting, predictive modeling, competitive intelligence, and data optimization
•Business Intelligence; enterprise data integration, self-service reporting and analysis (dashboards, drill downs, reports, etc.) capability development
•Data Warehousing; data model design and data integration architecture strategy development
•Data Management; data sourcing, quality analysis, modeling, integration, and master data management/warehousing
•Support Services; flexible support options to deliver on client specialized skill and experience requirements
AREAS OF TECHNICAL EXPERTISE
Enterprise Performance Management and Analytics; Budgeting, Forecasting, Planning, Consolidation, Profitability, Demand Planning, Sales Analytics, Contact Center, Marketing, Web Site, Price Optimization, Human Resources (e.g., workforce planning, recruiting, benefits, etc.)
Business Intelligence; dashboards, production reporting, OLAP, ad-hoc query
Data Warehousing And Analytics; Oracle SQL, SSAS (Microsoft SQL Server Analysis Services) and SSIS (Microsoft SQL Server Integration Services), metadata design and management (SAP), performance management, data quality, schema development
Financial; SAP EPM 10, Oracle Essbase, HFM
Databases; Oracle, Teradata, Hana, Hadoop, SQL Server
Analytics; SAS, R, SQL, data mining and statistics, forecasting, advanced Excel modeling From 2013 to Present (2 years) Collegeville, PADirector, Commercial Assessment @ Led large-scale global cross-functional initiatives focused on the identification and resolution of analytic capability gaps in the areas of strategy and commercial assessment (forecasting and valuation). Representative work includes:
•Identified opportunity to provide a reporting and analytics solution to enhance consideration of competitor activities. Approached an industry-leading data provider to develop data assets and subsequently led the program to deliver an industry-first big data solution providing global sales information and analytics covering the entire global pharmaceutical industry
•Leveraged program above to lead delivery of an industry first “quantitative strategy” program. This program developed advanced predictive models to provide projections of all internal and competitor assets for use by Strategy, Portfolio Optimization, Finance and other team. Worked across Pfizer functions to optimize and embed capability into core country, region and global planning and strategic processes. This solution is a key driver of both forecasting processes, as well a long-term strategic plans
•Identified opportunity to enhance the profitability of new product launches through the development of Pfizer’s first launch optimization analytic framework used to determine optimal price points by market and optimal market launch sequence and timing.
•Served as Commercial Operations business lead for deployment of SAP enterprise resource planning (ERP) system for the US market. From 2009 to 2013 (4 years) Collegeville, PADirector, Global Forecasting Center of Excellence @ Led the Wyeth Global Forecasting Center of Excellence prior to the merger with Pfizer. The Global COE enabled and supported strategic decision making processes across Finance, Commercial and Manufacturing by driving global process excellence.
•Oversaw global forecast execution and provided analytical capabilities, analyses, and training to global, regional and market forecasting leads
•Led the selection, implementation and ongoing management of the SAP EPM Global Forecasting solution. This transformational initiative, driven by the Pharmaceuticals CFO and with a steering committee consisting of the CFO, CIO, and VP of the Commercial organization delivered the organization’s first global solution to enable all aspects of forecasting and budgeting, and to identify global commercial risks and opportunities and drive the global Sales & Operations Planning (S&OP) process
•Led a variety of commercial Competitive Intelligence (CI) programs including the first application of text mining technologies for assessment of competitor launches and Key Opinion Leader (KOL) relationship mapping From 2006 to 2009 (3 years) Collegeville, PASenior Consultant @ •Led and managed all aspects of business intelligence and data warehousing engagements with Fortune 100 clients. Involved in all aspects of delivery, including presales, development, and implementation of both data warehousing and BI solutions – predominantly budgeting, planning and profitability applications
•Experience with a large variety of financial and ERP systems including SAP, JD Edwards, Solomon, etc. From 2005 to 2006 (1 year) Conshohocken, PASenior Consultant/Project Manager @ •Led various transformational initiatives focused on the build out and optimization of the company’s benefit outsourcing business, with a focus on IT, service center capabilities (CRM, phone, web, benefit transaction systems), workforce planning, capacity planning, forecasting, and profitability analysis
•Designed, developed, and implemented data warehousing, reporting/analytic, and business intelligence solutions
•Developed forecasting models to support various aspects of service center operations (call routing and arrival, web traffic, etc.)
•Developed models to predict the effects of special events (service outages, special causes of demand, etc.)
•Managed the evaluation and selection of software and toolsets used to support business functions including RDBMS, OLAP, CRM, performance management and optimization packages, systems management, web analytics, simulation modeling, etc.
•Designed Portals Scorecards, trending analysis, Dashboards, KPIs (key performance indicators) and benchmarks
•Partnered with HR team to develop and deploy recruiting analytics and workforce analytic capabilities From 1998 to 2005 (7 years) Greater Philadelphia AreaSenior Consultant @ •Responsible for implementing global financial consolidation, budgeting and reporting systems for Fortune 50 clients.
•Developed a financial consolidation application for a global healthcare company. The success of this engagement led to a series of efforts to implement the technology within all divisions globally.
•Led the design and delivery of a financial consolidation, budgeting and dashboard system for a global oil company. From 1996 to 1998 (2 years) Malvern, PAImplementation Specialist @ H&W Benefit System Implementations From 1996 to 1996 (less than a year) Greater Philadelphia AreaSystems Developer @ Developed financial planning software used to develop investment strategies in all areas of financial planning including retirement planning, education funding analysis, investment planning, tax planning, estate planning, and portfolio analysis From 1994 to 1996 (2 years) Greater Philadelphia Area
BA, Economics @ Temple University From 1992 to 1996 Bachelor's degree, Economics @ Temple University - Fox School of Business and Management From 1992 to 1996 Ethan Krow is skilled in: Business Intelligence, Data Warehousing, ERP, Business Process, Requirements Analysis, Program Management, Analytics, Forecasting, SAP, Project Management, Analysis, Data Analysis, Requirements Gathering, Management, Hyperion Enterprise, Project Planning, Financial Reporting, Budgets, Performance Management, Finance, Team Management, Business Analysis, OLAP, Process Improvement, Cross-functional Team..., IT Strategy, SDLC, CRM, Business Process..., Demand Planning, Sales..., Big Data, Predictive Modeling, Management Consulting, Pharmaceutical Industry, HR Analytics, EPM, Advanced Analytics, Workforce Planning, Human Resources, Integration, Outsourcing, Strategy, Business Objects, Data Modeling, Business Analytics, Data Integration, Consulting, Leadership, Vendor Management, Change Management
Looking for a different
Get an email address for anyone on LinkedIn with the ContactOut Chrome extension