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.

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.

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.
• 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.
• 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.

• 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.
• 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.
• 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.

• 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• Provided Design. Best Practices, Project Plan (milestones and key tasks), documented Standards for Naming and Development, and conducted new cube testing.

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.
• 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.
• 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.
• 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.
• 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.
• 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.

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.
• 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.
• 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\.
• 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.

• 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.
• 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..