Mitchell Halpern Email & Phone Number

Princeton, Nj, Us

• Reviewed, categorized, maintained and enhanced existing Azure – Denodo – Power BI reporting systems.• Updated data model and architecture including consolidation, performance enhancement, incremental updates and researched and tested new/alternative processes and tools.• Replaced cubes with store procedures to build data sets to replace and enhance exiting reporting reducing data loads by 70% while growing reports 35%.• Replaced existing process with Snowflake to allow rollbacks (data backup, single data set to reduce storage), complete automation from data updates to the building of API’s

Lysaker, No

* Documented current tools, data, and reports and assessed the current BI environment, architecture, components, and configuration. * Performed root cause analysis by identifying issues causing performance and availability degradation. * Proposed Azure/Power BI future state and capabilities for a Data Governance framework, tools, best practices, and architecture. * Identified a BI Data Governance solution's current capabilities and specific future needs in collaboration with stakeholders.

Coeur D'Alene, Id, Us

• Assess current BI environment, architecture, components and configuration. • Document current tools, data, and reports. • Identifying issues that are causing performance and/or availability degradation and perform root cause analysis. • Propose Azure/Power BI future state and capabilities for a Data Governance framework, tools, best practices, and architecture. Work with key stakeholders to identify current capabilities and specific future needs of a BI Data Governance solution.

Rockville, Maryland, Us

• Reviewed and converted marketing/media reports from Tableau to Power BI.• Set up Power BI in cloud server and created year to year variance reports.• Defined and validated roles and rules within the Power BI Desktop. • Designed a consistent format/layout for reports and consolidated reporting.

• Drive cross-business decisions that align business priorities with business strategies into an enterprise data strategy. Integrate and align business roadmaps into an enterprise data roadmap to deliver on the enterprise data strategy. Prioritization of enterprise data needs and enterprise data governance and define data prioritization framework for cross functional initiatives. • Define data governance operational processes (e.g., data quality measurement) in line with policies and standards, clearly articulating roles & responsibilities and establish and disseminate required frameworks, methodologies, tools, standards and templates to be used for Data Governance• Responsible for data governance and canonical information modelling across programs impacting clinical development planning, clinical supplies, clinical trial execution and Regulatory submission• Play a strategic role in the implementation of priority projects related to centralization the exchange of operational data between systems and integrated, cost-platform reporting and dashboarding, and advanced statistical analysis and predictive modelling

• Lead the efforts to define, implements, and evolve the Data Governance Center of Excellence at Allergan including, business analysis, project management, education, and detailed analysis and documentation.• Identify and track data mapping efforts from the various Financial, Regulatory, Project Management, and Regulatory systems and organizations into a consolidated Data Virtualization environment based on Denodo Platform in MS Azure.• Design, prototype, and deliver an integrated Data Governance capability utilizing a MS Azure backend and Power BI architecture and reporting and analytics front end.

• Provides strategic architectural guidance to business domains in defining or designing enabling technologies (Amazon S3/AWS Redshift/Tableau) supporting business processes, functions and organizational structures, as well as in researching, identifying and internally marketing technology enablers supporting organizational priorities.• Participates in the definition and execution of the Enterprise Architecture Program roadmap.• Leads and facilitates the creation of reference architecture, patterns and guidelines to support IT delivery.• Drives enablement work supporting enterprise and program level Epics decomposition in collaboration with product and portfolio delivery teams.• Creates enterprise architectural artifacts including: models, reference architectures and architectural patterns.• Leverages architecture governance process to provide IT and Business guidance for intentional architecture decisions.• Partner with IT and business teams to solve problems, develop new algorithms and models, and identify trends and opportunities. Inform, influence, support, and execute business and product decisions.

• SME for the eRAP version 2.1 upgrade, documentation (DiARy and PROTON), testing, and implementation.• Support, plan, design/architect, execute and close-out of Clinical Programs/Trials through the use of data, statistics, analytics, BI, visualization, reporting and planning tools/solutions. Guiding the evolution of Standards analysis, KPI’s and executive reporting through Spotfire BI.• Provide understandable and actionable reports on clinical data and monitoring of clinical data for key stakeholders• Provide quantitative analytical support to the global program teams, including providing support on analysing data quality, architecture, aggregations, use ability, guided analysis, ad hoc data exploration, and reports• Advanced conceptual, architecture, and development knowledge of SQL and VBA (Excel) to write and understand queries and extract datasets and produce reports• Familiarity and working knowledge of Business Intelligence tools including, Spotfire, JReview, and SAS

Toronto, On, Ca

• Owner and Technical Leader of the Corporate Performance Data Warehouse supporting Operations and Partner Reporting and Analytics supporting over a hundred measurements and KPI’s. Provided Vision, Technical and Architectural vision, roadmaps, detailed requirements and management to the upgrade and implementation of an integrated DW\BI\Analytics platform and solution integrating MS SQL Server and Qlikview visualizations.• Architected and delivered a multi-tiered ETL, DataMart, and Measurements platform integrating Data Quality\Governance, in memory aggregated measurements and a single version of truth. Integrated Project Management tool (Planview), HR, Operations, and IT Management (ServiceNow) into a DW\BI solution to provide an integrated DW, Operations, Analytics\Measurements corporate management solution.• Built and managed a team of analysts and technical developers to identify, provide requirements, build, test, and manage multiple Financial and Operations solution for KPMG’s internal KTech Organization

Architected Microsoft 2012 Support Center solution integrating real time processing and supporting in memory reporting and analytics for Operations and Executive Management. Defined Architecture and prototyped multi-tiered score card\dashboard reporting and self-service BI solution.

Florham Park, New Jersey, Us

Analyzed goals and resources to propel the organization to self-service business intelligence (BI) utilizing the Microsoft BI tool set. Provided guidance on best practices, architectural reviews, SSIS process and packages, cube analysis and enhancements, SQL queries and reporting, and plans for data integration and reporting. Prototyped the executive information balanced scorecard for upper-level management. Supported ETL, data warehouse (DW), SSAS, SSRS legacy processes, and systems along with new Microsoft technology initiatives.Highlights• Supported the launch of Microsoft DW and BI tools by architecting and launching a BI sandbox.• Delivered an integrated Microsoft BI solution for the Supply Chain and Finance Departments.• Equipped power users with self-service BI for by combining sales, earnings, inventory, cost of goods sold, and forecasts into a PowerPivot, Power View, tabular model, SharePoint, and BI Center.• Ensured consistency in naming convention, calculation logic, and reporting by performing an audit/cataloging of the DW/cubes to verify measures/calculations against the JD Edwards (JDE) financial system.

Provided consulting services for various high-profile projects in the communications, financial, and pharmaceutical industries.Highlights• Played a key role as Business Architect and developer of a big data Hadoop/Microsoft project for Viacom Networks advertising; identified key performance indicators (KPIs), analytics, and visualizations.• Created an integrated reporting prototype management information system for financial cash premiums, transactions, and earnings as DW BI Architect/Lead Consultant for Mekaza Staffing at Assured Guaranty.• Developed an integrated SSIS/SSAS/PowerPivot Master Data Services and balanced scorecard solution for The Medicines Company as Microsoft BI Manager, linking financial, clinical trials, sales, customer, and internal perspectives.Viacom (through Park Hudson) Sr. BI Architect• Business Architect and developer of a Big Data Hadoop/Microsoft By project for Viacom Networks, campaign/advertising/ creative and identifying KPI’s, analytics and visualizations. Assured Guaranty (through Mekaza Staffing) Sr. BI Architect• Provided Design. Best Practices, Project Plan (milestones and key tasks), documented Standards for Naming and Development, and conducted new cube testing.• Business Architect for six week client discovery, documentation, gap analysis, and roadmap for a future BI implementation for a data driven Sales and Operations corporate solution.THE MEDICINES COMPANY Microsoft BI Manager • Microsoft BI Lead (SQL 2008 r2 and 2012) to design and build integrated SSIS/SSAS/Power Pivot Master Data Services and Balanced Scorecard solution for dynamic International Pharmaceutical company linking Financial, Clinical Trials, Sales, Customer and Internal perspectives.

New York, Ny, Us

Orchestrated a group of onshore and offshore developers to enhance and support Fannie Mae’s and Affordable Properties‘ existing ETL, cubes, security, Access, and operational guidance, including financial and operational dashboards and reporting.• Led integrated business and technical/application team to provide required Fannie Mae quarterly reporting through the design and development of an integrated Excel/SQL Server (stored procedures) and dashboard Cash Flow reporting. • Supported and enhanced Fannie Mae and Affordable Properties (200+ properties 80,000+ units) Financial and Operational dashboards, reporting (i.e., Income Statement, Balance Sheet, Cash Flow, NOI, exception reporting, Lead a team of on and off shore developers to enhance and support existing ETL, Cubes, Reports, Security, Access, and Operational Guidance.• Under direction of the CFO designed/architected a Data Governance program of Data Stewards, Processes, Views, Control Tables, SharePoint lists, and single view of the business.

London, Gb

Hired/coached the technical team, trained Sales and Solution Directors, provided pre-sales materials/presentations and created targeted solutions. Architected the IBM product focus (DataStage, QualityStage, Information Analyzer, and Business Glossary).Highlights• Set up senior management to link corporate objectives to planned initiatives via a balanced scorecard from existing reports integrating finance, operations, customer, and internal perspectives.MFX Fairfax Senior Business Intelligence Applications Manager • Managed DW\BI ETL team supporting our various clients and system architecture. Designed and implemented enhancements to the ETL, Recon, and data marts to support analytics, analysis, and reporting.• Designed and prototyped scorecard\dashboard management reporting systems for pre-sales efforts and future corporate vision.Credit Suisse, IT Private Banking Project Manager Wealth Management Systems • Managed vendor relationship as well as systems development for a new Wealth Management system.• Designed and build data marts to allow the business to perform ad hoc queries and reporting to better design and customize final system and reporting.Prolifics, a JYACC Company Manager Data Warehousing and Business Intelligence • Defined and built Information Management Practice: identified and architected IBM Product focus (DataStage, QualityStage, Information Analyzer, and Business Glossary); hired and trained technical team; educated Sales and Solution Directors; handled pre-sales materials and presentations; identified and developed targeted services, solutions and programs.

New York, Ny, Us

Led the enterprise data warehouse (EDW) acquisition from sales and marketing and redesign as an operational EDW with 26 underwriting systems, diverse platforms (databases), vendors, products, and reporting requirements. Played key roles as both the business and technical leads for the EDW, including business leaders, IT architecture, database administrators, business analysts, ETL (DataStage), and reporting (Cognos). Developed road maps and business cases ($5M+ per year), and supervised priorities, schedules, and EDW evolution.Highlights• Orchestrated a project to model, design, and build reporting and analytics for the business process management (BPM) system (MS SQL Server back end) to control submission and renewal processes and workflow management.• Delivered optimization of prioritization, forecast, and performance via market segmentation and analysis to manage daily work. • Lead the acquisition of the EDW from Sales and Marketing and its redesign as an Operational EDW with 26 underwriting systems, diverse platforms (databases), vendors, products, and reporting requirements while providing a consolidated view of the overall business and still provide/support the individual business data and reporting needs and perspectives.• Served as both the Business and Technical leads for the EDW, diverse business leaders, IT – architecture, DBA’s, BA’s, ETL (DataStage) and Reporting (Cognos). Developed and Maintained multi-year roadmaps, wrote\ championed all business cases ($5million+ per year), negotiated\resolved priorities, schedules and EDW evolution.• Envisioned and led full design of a DW solution (MS SQL Server); from concept, detailed requirements, costs, and schedule, enterprise data repository, marts, and three tiered dashboard / balanced scorecard reporting to run, manage, and plan Small Business operations and financial planning through the use of Balanced Scorecards and Metrics -- the prototype for larger corporate wide implementation.

• Project manager for three simultaneous DW / BI / CRM development efforts for the Health Insurance, Life Insurance, and Airlines industries. Led weekly project status meeting with both client and project team to track progress toward established milestones. Proactively addressed client issues and concerns, set client expectations, and ensured customer satisfaction.• Transferred / architected the business requirements to a logical data design and then to an implement physical design. Developed / validated strategies to analyze data quality for both completeness and accuracy. Evaluated and developed data transformation rules based on business knowledge and data quality assessment results. Analyzed, categorized, and prioritized business information requirements.