Liam M. Mullen

Dearborn, MI *****

313-***-**** (C)

adwpik@r.postjobfree.com

S u m m a r y o f q u a l i f i c a t i o n s

• Senior financial analyst with over 30 years’ experience in the automotive / insurance / healthcare / banking cost accounting and financing business

• Practical experience in MS-Excel, MS-Access, MS-Word, MS-PowerPoint, MS-Outlook, VBA, MS- PowerBI

• Completed special projects involving complex data from multiple sources through extensive use of pivot tables and graphs

• Self-starting result oriented with excellent interpersonal skills and a first-rate team player I T E x p e r i e n c e

• MS-Excel, MS-Access, MS-PowerPoint, MS-Word, MS-Outlook, MS-Visio, MS-SharePoint, VB6, VBA, MS-SQL Server, MS-Power Pivot

• Tableau, Ricochet. Hyperion Interactive Reporting Tool, OS9

• SAP R/3, FICO modules, PCM, BEx Query Tool, BPC, Crystal Reports

• Oracle, TOAD, Python, Cognos Report Studio, JD Edwards (JDE)

• SalesForce, Austin Tetra, MultiTool.Net, Great Planes, VB.Net

• Lotus Notes, Hyperion/Essbase and PeopleSoft

• SQL Server 2000, Model204 and IBI-FOCUS

• IBM-DB2 and IBM Query Management Facility (QMF)

• HTML, TSO Clists, Job Control Language (JCL), QueryAid and SPUFI P r o f e s s i o n a l e x p e r i e n c e

Kelly Services

Kelly Services – Troy, Michigan August 2021 – November 2022 Data Reporting Analyst

• Support standard practice reporting across the Business Unit, including tracking Key Performance Indicators (KPIs) and compiling operational trends/performance reports in accordance with the BU's management cadence

• Support ad-hoc reporting, analytics, and "deep dive" research needs requested by BU senior leaders by understanding needed data, running, or coordinating reporting within necessary timelines, and presenting insights via effective data visualization, written reports, and presentations

• Identify trends, gaps, new business opportunities and process governance issues through analysis of data.

• Present analysis, findings, and recommendations to facilitate operational improvement and strategic decision-making

• Using advanced MS-Excel skills, familiar with advanced logical formulas, data summarization techniques, charting and macros/VBA

• Experience analyzing and trending copious amounts of data, including data cleaning/wrangling (e.g., missing value interpolation, transformation, etc.)

• Utilizing communication skills including verbal, written, and listening

• Ability to work confidently and comfortably with operational leaders at multiple levels within an organization, including at the VP and SVP level.

• Be proficient in developing professional relationships with internal customers and making own recommendations to reporting approach.

• Ability to interpret customer needs, problem solve, and make recommendations for reporting approach.

• Ability to work independently with limited daily supervision while verifying completeness & accuracy of work product

• Being able to demonstrate initiative and self-motivation

• Efficient time management skills to meet reporting deadline

• Experience with Power BI and Tableau while be familiar with SQL Kelly IT Services

Comerica Trust – Detroit, Michigan October 2018 – April 2020 Trust Database Developer

• Responsible for maintaining the quality and integrity of Personal Trust Advisory Administration Repository System (PTAARS) databases that provide access to stored trust information and aggregation of data for operational decision support and for accurate fiduciary and non-fiduciary reporting

• Coordinates data flows across systems while implementing program coding within the databases

• Provided highly technical specifications, test plans and testing for the required programming within corporate standards

• Proficient in SQL, Visual Basic or similar programming language and techniques

• Experienced with end-user data reporting tools such as SharePoint

• Technical written communication skills including documenting business requirements, developing test scenarios/plans and documenting relational data structures

• Skilled verbal communicator who can tailor communications for both technical and non-technical colleagues at many levels throughout the Bank

• Business acumen in contact center and/or retail banking technologies Automated Benefit Services – Sterling Height, Michigan August 2016 – October 2018 Senior Data Analyst

• Build & operationalize processes to ensure timely data updates and data accuracy in line with project scope and recommendations

• Support & execute change management activities around testing, implementation, and training

• Maintain mapping files

• Upload and download data and verify results

• Monitor data quality

• Actively participate as a project team member to ensure operational readiness of new system deployments and system enhancements

• Identifies, communicates, and works to resolve data gaps that impact fulfillment of business and functional requirements

• Document end-to-end operating processes

Robert Half International – Management Resources

The TAPCo Group, Finance - Wixom, Michigan May 2016 – June 2016 Senior MS-Excel VBA Developer

• Develop, design and improve 2016 rebate financial models to provide broader functionality

• Utilized MS-Access knowledge to accomplish complex tasks without supervision

• Convert MS-Access database in MS-Excel workbook equivalents

• Organize work independently

• Validating and correcting data issues on Customer Rebate data purity International – Management Resources

Federal Mogul - MotorParts, IT Finance - Southfield, Michigan September 2015 – February 2016 Senior Financial Analyst / VBA Developer

• Develop, design and improve 2016 Cost Center Budget financial models to provide broader functionality and complexity

• Utilized MS-Excel VBA knowledge to accomplish complex tasks without supervision

• Develop, design and improve 2016 Cost Center Forecast financial models to provide broader functionality and complexity

• Prepare variance analysis of consolidated financial performance (Actual vs. Budget/Forecast)

• Prepare and analyze TeleCom monthly bills

• Consolidate and analyze Cost Center forecast and budget

• Prepare and analyze the consolidated monthly senior management Financial Performance Review

• Coordinate budget and forecast preparation

• Prepare and complete miscellaneous special projects as assigned

• Organize work independently and in teams

• Generate reports from a variety of corporate system applications, such as SAP

• Launched and administered use of MS-SharePoint site for 2016 budget and forecast model workbooks

• Validating and correcting data issues on Cost Center data purity Team Detroit Inc., Finance - Dearborn, Michigan August 2014 – September 2015 Finance Client Manager

• Responsible for assisting in the management of Client Financial Reporting typically related to pricing of Scopes Of Work for fee base tracking projects of all Ford and Lincoln (Tier 1 and Tier 2) business

• Maintaining, developing, calculating and reporting Time Of Staff (TOS) against budget for Ford, Lincoln, Ford Customer Service Division (FCSD), Ford Credit, Global and Emerging Market Systems (EMS)

• OS9 Development and Launch

• Successfully develop and launch of the OS9 System in collaboration with Senior TDI Management and the WPP Business Intelligence Team

• Responsible for the development and maintenance of both internal and external reports associated with the OS9 System (i.e. utilization, direct margin, open position, project management reporting)

• Work collaboratively with the Business Intelligence Group as the Data Stewart

• Responsible for the pricing of scopes of works, tracking of projects and associated reporting as they relate to our major and minor clients

• MS-Excel developer of TOS reporting supporting agency understanding of work performed versus fee based budgets

• Validating and correcting data issues on agency TOS data purity

• Maintain and support all company standards as specified within the Quality Management System

• Supports/facilitates the mandatory adherence to ISO9001 requirements, processes and procedures

• Perform other duties and projects as assigned

• Organize work independently and in teams

At-Tech

CenturyLink Communications, Sales Operations - Southfield, Michigan October 2013 – April 2014 Data Analyst

• Analyze geographical markets to assist in providing recommendations for the Midwest Region for future growth

• MS-Access and MS-Excel developer of numerous processes supporting market segment data

• Validating and correcting data issues on market segment data purity

• Developed numerous queries using SalesForce, Austin Tetra and MultiTool.Net web interface

• Prepare and complete miscellaneous special projects as assigned

• Organize work independently and in teams

Epitec, Inc.

Blue Cross Blue Shield of Michigan,

Management Analysis and Reporting - Detroit, Michigan February 2013 – October 2013 Senior Developer Analyst

• MS-Access and MS-Excel developer of numerous processes supporting ASC Contribution Model

• Validating and correcting data issues on loaded data for ASC Contribution Model

• Developed numerous SQL queries using TOAD-Oracle in support of ASC Contribution Model

• Technical writer of ASC Contribution Model

• Prepare and complete miscellaneous special projects as assigned

• Organize work independently and in teams

DTE Energy Gas- Budget, Forecasting and Reporting - Detroit, Michigan March 2008 – October 2012 Financial Analyst

• Prepare variance analysis of consolidated financial performance (Actual vs. Budget/Forecast)

• Consolidate and analyze total company forecast and budget

• Prepare and analyze the consolidated monthly senior management Financial Performance Review

• Maintain and improve financial models

• Coordinate budget and forecast preparation

• Prepare and analyze balance sheet accounts in specific accounting periods

• Prepare presentations for senior management

• Prepare and analyze the annual AGA fact book

• Prepare and complete miscellaneous special projects as assigned

• Organize work independently and in teams

• Generate reports from a variety of corporate system applications, such as SAP R/3, BW/BCS and BPC Robert Half International – Management Resources

DTE Energy Gas- Budget, Forecasting and Reporting - Detroit, Michigan November 2007 – March 2008 Financial Analyst

• Responsible for business financial processes

• Analyze data and develop conclusions

Contact this candidate