Michael Allaire Email & Phone Number

New York, Ny, Us

Data Analyst working to access, assimilate, and integrate data to dderive insight for Supply Chain decision-making with variety of Business Intelligence and database IDE applications (Excel, Alteryx, Tableau, SAP Business Objects, Toad DataPoint, Oracle SQL Developer) accessing data from various enterprise systems (Enterprise Data Warehouse, Cloudera HUE big data platform utilizing Hive/Impala query, Oracle e-Business Suite ERP, Oracle Product Data Hub, Oracle Demantra Demand Planning, SalesForce CRM/CPQ/SFA)

Columbus, Oh, Us

Worked alongside Big Data contract consultants in support of development and production platforms of Cloudera CDH 5 Hadoop platform on Red Hat Linux clusters with subsequent hosting of redeveloped reporting applications transitioning from legacy platforms. Utilized GIT code migration process for deployment of template- driven Bash and SQL script generation for creation / maintenance of supporting HDFS / Hive / Impala tables. Online training courses taken for introductory Big Data, Hadoop, Linux and Python knowledge acquisition. Developed and utilized Microsoft Power BI data visualization software dashboards. Continued ad-hoc support for 3rd party EiS Technologies operational reporting solution for Oracle e-Business ERP instance.

Columbus, Ohio, Us

Member of multi-disciplinary global team of functional / technical support personnel engaged in the preparation and requirements gathering phase of a multi- year design, configuration and conference room pilot phases for the North American deployment of an Oracle e-Business Suite R12.1.3 ERP system (comprising Manufacturing, Supply Chain, Projects, Service and Financials) with Oracle BI Applications on an Oracle BI Enterprise Edition (OBIEE) v11. 1.1. 7. x technology platform. Received training in Lean Methodology, Business Analyst requirements gathering, ITIL methodology and Project Management Life Cycle.

Columbus, Ohio, Us

Administrator for Oracle Discoverer 4i & 10g versions, NoetixViews v5.8 on Noetix WebQuery platform, and EiS eXpress Reporting v7.1 operational reporting solutions supporting several hundred reporting end users of Oracle e-Business Suite R11. 5.10. 2 production ERP system (comprising Manufacturing, Projects, Service, Supply Chain and Financials modules) supporting 2 European manufacturing facilities, 9 EMEA and 6 Asia-Pacific sales offices. Worked with an external consultant on development of a custom ETL / integration process using Oracle Warehouse Builder 10g in support of a Vendavo Pricing application implementation. Participated with external consultants in the setup / configuration of an Oracle Business Intelligence (OBIEE) 10g platform and Oracle Business Intelligence Applications (OBIA) v7.1. 6.2 (including Supply Chain and Order Fulfillment, Procurement and Spend applications). Extensive experience with developing / troubleshooting Oracle reporting SQL code on Oracle Database Enterprise Edition versions 8, 9i, 10g and 11g database versions.

Columbus, Ohio, Us

Member of an international corporate team for 9 month design/configuration and subsequent implementation of an Oracle e-Business Suite R11.5.9 ERP system (comprising Projects, Service, Supply Chain and Financials modules) in the UK sales office with subsequent deployment implementations in following years to 9 EMEA and 6 Asia-Pacific sales offices. Served as subject matter expert on Project Accounting module of e-Business Suite. Administered and developed Oracle Discoverer 4i reporting solution against the ERP operational database.

Columbus, Ohio, Us

Member of a 3 person team working with external consultants on the design, configuration and deployment of a JD Edwards OneWorld ERP system implementation into Caracas, Venezuela sales office.

Columbus, Ohio, Us

Participated in ERP system implementations in Binghamton, NY manufacturing facility; Reynosa, Mexico manufacturing facility and McAllen, TX warehouse and provided ongoing ERP system and reporting support as administrator of Cognos Impromptu v6 software.

Columbus, Ohio, Us

Transferred from Materials Management operations into Information Technology department for international project to implement legacy North American mainframe ERP system, Cullinet, into United Kingdom manufacturing plant, UK sales office, and Slovak manufacturing facilities for Y2K mitigation. Lived in Swindon, England for year and half with family during EMEA implementations. Assumed role of administrator for Cognos Impromptu v6 reporting tool used by North American and EMEA users for reporting against ERP data extracted to an Operational Data Store hosted on an Oracle Database Enterprise Editions (v9i >10g > 11g).

Columbus, Ohio, Us

Returned to Columbus, OH from El Centro, CA. Trained in and performed role of manufacturing plant Master Scheduler maintaining 10-15 different Planning Bills of Material comprising thousands of components and subassembies to maintain forecast schedules and component mix / structures for optimal forecasting of material requirements in support of manufacturing production plans. Utilized intermediate Microsoft Excel skills to perform analyses against data extracts of planning bill structures and material consumption histories along with regular inputs from Sales & Operations Planning meetings to produce optimal forecasts and planning bill structure maintenance in the ERP system for optimized plan scheduling by the MPS/MRP planning engine.

Columbus, Ohio, Us

Moved from Columbus, OH to El Centro, CA near the Mexican border to implement our North American mainframe ERP system, Cullinet, in Mexican manufacturing plant in Mexicali, Mexico and U.S. warehouse in Calexico, CA. Post-implementation, served as the planning manager, training and supervising Mexican planning personnel in the proper use of the ERP system planning processes. Promoted to materials manager overseeing all production and procurement planning personnel and processes in the factory and warehouse.

Columbus, Ohio, Us

Planned electronic subassemblies and purchased component ordering and inventory levels in support of production planning schedules utilizing the company's Cullinet mainframe Enterprise Resource Planning (ERP) system. Responsible for planning of local assembly production and inventories in addition to planning transfer demands between Columbus, OH ; Fremont, CA and Mexicali, Mexico facilities.