Albert (Al) M. Rice

Phone: +1-248-***-**** Skype ID: arice012

Email: adh3y8@r.postjobfree.com

Areas of Expertise:

Data Analytics, Global Program/Project Management, Information Technology (IT) Infrastructure, Agile/Scrum & Waterfall competence, Global Finance & Accounting, IT Vendor Relationship Management, IT Infrastructure Management, Project Management Office (PMO), Portfolio Management, EDI/B2B Communications, Business Architecture, Change Management, Office 365 migration, SDLC Quality Manager, Capability Maturity Model (CMM), Volunteerism, PM-Application Programming (Monarch, Java, JavaScript, C++, PHP, VBA, etc.), Splunk, QlikView

CAREER SUMMARY

Senior financial and IT executive with superior leadership and global experience in accounting, finance, operations, data analytics, information technology, EDI/B2B Communications, change management and IT project/program & vendor management. Over 25 years of increasing management responsibilities in a variety of industries, including utilities, manufacturing, automotive, information technology and non-profit organizations. Senior manager positions include: global director – IT finance, strategy & IT contract and vendor relationship management; global program/project portfolio manager - information technology; practice director - information technology consulting; SDLC Quality Manager; ERP project director - SAP; director - financial shared services; transition manager - joint venture; accounting director, controller and financial analyst.

EXPERIENCE

Data Transformation & Analytics Nov-2017 – Current

Trends In Data, LLC

Self-employed as Freelance Data Analyst, ETL and Data Transformation Expert:

Developed automated data extract, data modeling & transformation and loading solutions for medium and large-scale, manufacturing, financial, non-profit companies, among others

Expert in Data Modeling using Altair/Datawatch tool: Monarch (similar to: Tableau, Business Objects).

Experienced writing data extracts and reporting within, SAP, Oracle, DB2, SQL Server, Hadoop and other data environments.

Developed automated data analysis & user interface solutions using vbScript, VBA, PHP and other languages

Very disciplined, responsive, and accountable remote support professional

Enthusiastic, referenceable and highly satisfied clients

Business Integration Manager, Data Analytics Feb-2018 – Current

Ford Motor Company (Contractor), Dearborn, MI

As Senior Business Integration Manager, my responsibilities involve liaison between Ford Sales & Marketing Groups and IT to design and build effective digital solutions for sales and marketing campaigns, while leveraging market data, analytics and intelligent customer interaction.

Manages a team of IT engineers and solution architects to design, develop and deploy IT and social media solutions to market vehicle and mobility to existing customers and customer prospects via social media and smart phone applications.

Leverage my deep global procurement and financial management experience to collaborate with Ford’s international Finance, Sales & Marketing teams to document business requirements and transfer the same into technical and functional specifications for high impact IT applications and data solutions. Solutions include interactive, web-based marketing tools and smart phone applications.

Developed higher competence as Product Owner, utilizing Agile and Scrum methodologies.

Information Technology Delivery Manager/ Sr. Program Manager Mar-2017 – Oct-2017

DTE Energy (Contractor) Detroit, MI

Recently completed contract with DTE Energy ($10 billion utilities company) to develop and implement the following critical initiatives:

15-Year Strategic Technology Platform Plan (TPP) – Coordinate all activities of technical resource teams to develop the strategic technology roadmap to guide investment, resource development and organization structure, towards a Best In Class IT Application and Infrastructure platforms of the future.

Facilitated special sessions with VP/CIO and senior IT leaders to establish resource allocation and aspirational objectives for each technology platform for the next 15 years. Technology platforms included: Customer Information Systems, Collaboration (i.e., Office 365, including tenant to tenant migration), ERP, Data Analytics, IT Services, Electrical Distribution and Work & Asset Management.

Major deliverables across each Platform included: Formation of Platform Teams, Create Charter, Develop Technical Roadmap and Key Milestones, Capital Allocation, Define KPIs, Change Management, Create Stakeholder analysis, and Rollout & Communication plan.

Re-platform and Re-Implement “Troux” Architecture & Planview IT Asset Management System

Manage migration of Troux Architect system from unstable, and faulty Linux server platform to Windows server platform

Manage upgrade of Troux Architect application from Version 9 to Troux Architect Version 13, which addressed many performance issues which affected ability of the business architects’ productivity

Enhance the IT Community Outreach & Volunteerism Program

Within four months, developed a very successful and impactful volunteerism program which resulted in a 260% year over year increase in the involvement, and recognition of IT engineers’ volunteerism outreach in the communities where they live and work for DTE.

Managed development of a smartphone App (utilizing O365 Platform) for ease of posting volunteer hours worked at non-profit organizations, which will increase the number of non-profits receiving grants from the DTE Philanthropic Foundation.

In all the above initiatives, I directly interacted with senior IT leadership, including the VP/CIO and his direct reports (IT Directors). Additionally, At DTE, I was completely immersed in the Agile development methodology, and enhanced my Scrum knowledge. I also demonstrated my deep knowledge of the collaborative functionality Office 365 suite, including SharePoint, Groups, Teams, Channels, MDM, DLP, Power BI and tenant to tenant migration. Additional productivity and analytic tools utilized included: MS Project, Visio, and Datawatch Monarch (data analytics tool).

Program Manager & Data Analyst Aug 2015 – Mar-2017

Trends In Data, LLC, West Bloomfield, MI

Designed, Developed and Implemented back office processes and systems for two (2) large non-profit organizations (a historic church/museum, and a childhood substance use disorder prevention program). Projects include accounting and information systems, change management, computer-aided data analytics, software development and business process redesign. Generated substantial new revenue sources for this small non-profit organization.

Trained and achieved expert skills as data analyst utilizing the Monarch data analytics tool sourced by Datawatch Corporation.

Director, Global IT Finance, Strategy & Vendor Management Apr 2010- Aug 2015

Motorparts Division, Federal-Mogul Corporation, Southfield, MI

Report directly to the SVP/CIO

Direct responsibility for management of the global IT project portfolio (average $80 million per year in CapEx and Expense). Responsibilities include administration of the project management office (PMO); including project governance, strategic planning, budgeting and performance reporting.

Major ERP Governance and Delivery. As director of strategic programs/projects, managed delivery of major ERP systems, including SAP, QAD/MFG Pro and Oracle. Ensured mission critical applications were deployed, supported and managed in line with CMM, PMI and ITIL standards. ERP deployments involved design, development, rigorous unit & integration testing, data management, change management and post production handover. Primary database solutions involved were Oracle (SAP & Oracle ERPs) and Progress DB (QAD/MFG pro).

Project Manager, Failover IT Data Center Implementation. Managed a team of IT technicians and external IT vendors to fully design and implement as remote failover data center (in Philadelphia, PA) for all Federal Mogul critical IT infrastructure and applications.

Global IT Finance Director. Responsibilities involve all finance activities (capital investment, budget, forecasts, actuals and month-end accounting activities) for North American locations and cost centers and reporting and financial management of rest of world IT finance. Expertise in SAP FICO, MM & PP

Vendor Relationship Management. Negotiated and managed vendor contracts for all infrastructure, application and services IT vendors, globally. Recently, involved in support of company's plan to segment the company into two separate legal entities, which significantly impacts vendor relationships.

Business Architecture. Managed alignment and justification of IT solutions and capabilities with critical business process requirements.

Program Manager, Global SAP Deployment May 2007-Mar 2010

Federal-Mogul Corporation, Southfield, MI

Manage all program office and project management activities associated with the global deployment of SAP ERP solution across global Federal-Mogul sites.

Directly responsible for SAP solution design and architecture, financial management, deployment, management reporting and SOX audit compliance associated with SAP Program Everest (“One SAP for One Federal-Mogul”).

Reporting directly to the IS General Manager, who had overall responsibility for Program Everest, I manage all program activities (including: change management, contract administration, time reporting, communications, financial analysis) to successfully achieve program deliverables on schedule and on budget.

Key achievements during this assignment include:

Full accountability for over $30 million in program CapEx spending

Successful deployment of SAP at major Federal-Mogul manufacturing and aftermarket facilities in North America, Europe and Asia-Pacific

Instituted a consistent, global project management methodology for deploying SAP (including structured project management principles and strong program governance oversight)

Established a standard, effective approach for reporting project status at project team and senior management levels, which include financial, resource-efficiency and compliance metrics

Design and managed implementation of IT work request system utilizing Java and PHP resources, which included both onshore & offshore resources.

Global Manager, Information Technology Project Management Office Jun 2006-Apr 2007

Federal-Mogul Corporation, Southfield, MI

Responsible for effective management and control of all information technology (IT) projects, which included instituting best project management practices for strategic, enterprise information technology projects. Utilized both waterfall and agile project & solution development methodologies.

Directly responsible for all policies, procedures and ongoing metrics associated with the information technology (IS) project management office (PMO).

As a member of the IS management team with specific responsibility for the PMO group, my group maintained the complete IS project portfolio, and was integral to all decisions affecting project selections, resource allocation and financial reporting.

During this 11-month assignment, my PMO team implemented major process improvements for project initiation, gate reviews and project status reporting throughout the project life cycle. Such improvements included: Streamlined project documentation, increased use of electronic workflow tools, fuller integration and increased accountability by project managers, and maximizing the use of the Microsoft Project Server environment.

Other major accomplishments included:

Standardized global project status reporting for all projects;

Refined the process for collecting, evaluating and reporting key project performance metrics for the $40 million (including capital and expense) IS project portfolio;

Trained the complete IS organization (over 400 people) on improved project governance process and tools;

Achieve a 156% improvement (from 96/month to 256/month) in project status & metrics reporting by project managers;

Fully integrated business analysis and architecture within IT project implementations.

Manager, Quality Assurance – Application Service Delivery Aug 2005 – May 2006

Federal-Mogul Corporation, Southfield, MI

Responsible for the quality assurance of all production applications within Federal-Mogul

Developed, implemented and assured adherence to strong quality processes within the applications service delivery group. Such processes include change management, change control, testing, user acceptance and support

Developed, Maintained and reported meaningful project and operational metrics

Enforce compliance with all statutory & regulatory requirements

Developed, implemented and monitored processes for effective resource allocation and utilization

Ensure business impact analysis and quality assurance processes throughout the entire System Delivery Lifecycle

Ensure strong technical competence within the group

Facilitate training and effective use of IS Applications within the organization

Major accomplishments included:

Developed and implemented Quality Assurance standards for Application Inventory database (appx. 700 major applications)

Developed and implemented Resource Skills Management database

Developed and maintained a Resource Tracking tool (in line with Federal-Mogul staff reduction objective)

Project Manager, Business Process Outsourcing (Financial Shared Services) Jun 2004 – Aug 2005

Federal-Mogul Corporation, Southfield, MI

As member of the Business Process Outsourcing (BPO) team, was responsible for negotiating the final BPO contract and implementation with IBM.

As project manager, manage the complete implementation of the BPO agreement, including business process, IS technical interface and ongoing IS support for outsourcing Federal-Mogul North American and European Financial Shared Services.

Major accomplishments included:

Successfully managed an internal and external team of lawyers, BPO advisers and senior IBM and Federal-Mogul Finance and IS managers to structure and implement a complex BPO-FSS solution.

Managed the complete technical integration of Federal-Mogul IT systems and related infrastructure to IBM service centers in Poland, Costa Rica and India relating to the BPO-FSS solution.

Successfully managed the outsourcing and implementation of a global expense reporting solution as a Phase 2 initiative under the IBM/F-M BPO-FSS solution

EDUCATION

Executive MBA (1995), Rochester Institute of Technology, Rochester, NY

BS - Accounting (1978), Alcorn State University, Lorman, MS

SPECIAL SKILLS

Languages: English, Some Spanish, Some Chinese

Computer Software: MS Project Professional, MS Project Server, Monarch Developer, Visio

Microsoft Office 365 [Excel, Word, PowerPoint, Publisher, Access, Visual Basic (VBA)], SharePoint, 4 G/L (Focus); Statistical (Minitab), Splunk, QlikView

Applications Experience SAP (R/2, 4.6, ECC 5.0, ECC 6, HANA), Oracle Financials, Hyperion, One Stream, Lotus Notes, SharePoint, QAD, MFG Pro, Planview, EDI/B2B Communications, CA Portfolio Management (legacy system w/modifications)

Soft Skills: Excellent Listener, Speaker and Presenter, Change Management, Business acumen

Special Certification Currently studying for Six Sigma Certification, Business Architect, 2013 (Business Architecture Center of Excellence), Agile deployment competent

Contact this candidate