PATRICIA L. PHILLIPS

acvi5v@r.postjobfree.com

http://www.linkedin.com/pub/patricia-patti-phillips/1a/9b2/162/

734-***-****

CAREER SUMMARY

Over fifteen years of successful experience and expertise with data/business analysis, database extraction, data manipulation, report composition and project management in the healthcare, IT, finance, digital marketing and automotive industry. Strong track record of contributions through planning, innovation and training. Demonstrated interpersonal and leadership skills utilizing team building concepts resulting in several corporate awards.

Analytics, problem solving, departmental leader, requirements gathering

Resourceful in data extraction, data manipulation, automating or streamlining existing processes and adapting to new process improvements and technologies

TECHNICAL SKILLS:

Expert Level in Microsoft Office Technology – Excel (Pivot Tables, Macros, VLookup, Sumif, Complex Formula Building), Access (Query Building), PowerPoint, Word, Project

Tools: Ad Hoc Reporting, Facets, iCIMS, UltiPro, CITRIX, Paradox, QuickBooks, Business Intelligence, PeopleSoft, SharePoint, SQL, Tableau, JIRA (JQL), Clarity, Salesforce

PROFESSIONAL EXPERIENCE:

Lead Sales Operations Consultant, CenturyLink, Southfield, MI 4/2015 – present

Generate complex weekly, monthly and quarterly reporting to executive leadership which drives business decisions

Administrator of regional SharePoint site

Calculate monthly targets and bridge payments

Assign new sales rep sales IDs

Maintain and audit yearly targets for sales reps in nine states

Lead real estate project management

Business Analyst/Project Lead, Stefanini, Inc., Southfield, MI 4/2014 – 4/2015

Business Analyst/Project Coordinator/Reengineering Practitioner supporting the Ford ITHQ Project Management Office

Managed projects within the PMO business office; Clarity version upgrade lead tester and coordinator, Clarity data cleanup initiative, Business Continuity Process building manager, MCRP coordinator, CPMM training compliance initiative

Generated monthly metrics on Project statuses in MS Excel and prepare presentations in MS PowerPoint.

Reviewer for yearly SOX processes and procedures pertinent to the IT PMO division

Assisted manager on reengineering initiatives

Gathered project statuses for monthly executive meetings

Analytics Project Lead Coordinator, MRM Worldwide, Birmingham, MI 9/2013 – 4/2014

Project coordinator for projects with client General Motors providing coordination of assignments and tasks and meetings internally and with client

Lead projects to determine project scope and requirement definitions

Developed project workbooks for all projects to include scope, assignments, tasks, issue logs, risk summary and status updates using MS Project

Performed analysis on status and issue log in MS Excel and created dashboard reporting in JIRA

for management utilizing JQL/SQL language

Generated monthly service level agreement reports in MS Excel for client

Adhered to open communication, transparency and responsiveness to the client’s needs

Data Analyst, GalaxE.Solutions, Detroit, MI 7/2012 – 9/2013

Systems administrator for iCIMS providing updates, guidance, assistance and coordination for problems and resolutions

Submitted an idea to iCIMS to assist in accurately reporting on recruiter activity. The idea was developed and added to the May 2013 release

Worked on group projects to determine requirement definitions

Analyzed and reported daily activity workflows for recruiter’s candidate pipelines in MS Excel

Analyzed monthly, quarterly and annual trends, quotas and goals for recruiting hires utilizing pivot tables, vlookup and complex formulas in MS Excel

Developed graphs and charts for hiring trends and quotas using MS Excel

Calculated monthly service level agreement incentives and bonuses in MS Excel

Utilized Business Objects reporting tool in UltiPro

Lead tester and coordinator for system migration from UltiPro to iCIMS; performed large data extraction and new system data upload

Modified manual processes into automated systems and coordinated report development for data and trending analysis

Performed weekly audits to protect data integrity using MS Access/SQL queries

Office Manager, McKague Financial, Livonia, MI 1/2011 – 7/2012

Generated general correspondence and statistical reports using MS Access

Prepared oral and written reports, including graphs and charts, for presentations in MS Excel and PowerPoint

Created monthly company newsletter for distribution to current and potential clients

Developed and maintained a variety of records, files and reports in MS Access

Supported president in daily office activities and handled daily client contact and customer service

Coordinated monthly financial advisement seminars

Bookkeeper, Mema’s Munchies, Wayne, MI 2/2000 – 2/2010*

Processed payroll, monthly sales tax, employee tax statements and quarterly filings

Recorded daily financial transactions and processed account payables

New Vehicle Sales Consultant, Tennyson Chevrolet, Livonia, MI 9/2006 – 6/2007*

Negotiated sales and processed all necessary paperwork to deliver new vehicles to customers

Utilized nationwide database to locate vehicles based on customer criteria

Handled all internet based leads and subsequent sales

Generated vehicle sales through cold calling initiatives

Sr. Data/Financial Analyst, Blue Care Network of Michigan, Southfield, MI 1/2004 – 6/2006*

Originated and maintained reports and analysis daily, monthly and annually to assist management in business decisions using MS Access and Excel

Performed analysis and testing of new system implementation and procedure guidelines

Created and preserved various databases for analysis

Reported results of ad hoc requests submitted by various departments

Executed daily and monthly audits to identify and correct data concerns using MS Access

Collected data from multiple platforms and sources in order to run queries

Devised and supported queries utilized for analysis to ensure data integrity

Developed, managed and uploaded monthly pricing schedules to the mainframe

Completed daily account reconciliations

Compiled monthly and annual general ledgers utilized by the Accounts Payable department

Created and updated pivot tables in complex MS Excel worksheets

Supervisor/Financial Analyst, Blue Care Network of Michigan, Southfield, MI 3/2000 – 1/ 2004

Conducted interviews and completed recruitment process for newly hired employees

Instituted and conducted software and system training presentations for analyst staff

Monitored analyst staff assignments and methods utilized to complete tasks

Implemented strategic and impact planning programs

Initiated team-building concepts and initiatives to clarify roles and responsibilities between supervisor and analyst staff

Promoted teamwork through improved reliability, responsiveness and overall quality of tasks

Facilitated semi-annual and annual employee merit reviews and evaluations

Data/Financial Analyst, Blue Care Network of Michigan, Southfield, MI 4/1999 – 3/2000

Responsible for business financial processes

Consolidated multiple financial reporting presentations monthly utilizing MS-Excel knowledge

DBA/Developer of MS-Access database of continuous improvement data

Created a MS-Excel reporting interface utilizing pivot tables

Developed MS-Access macros to accomplish transfer from mainframe system

Created variance commentary of monthly financial capitation payments

Assisted team members by developing various MS-Excel reports and MS Access databases

Analyze data and develop conclusions

Provider File Analyst, Blue Care Network of Michigan, Southfield, MI 3/1996 – 4/1999

Coordinated information submitted by various sources to establish and maintain healthcare provider demographics and financial affiliations

Ensured accuracy, completeness and timeliness of information housed on healthcare provider database allowing for accurate capitation and claims payments

Affirmed healthcare provider directory by tracking and auditing eligibility listings, medical groups and sites, hospital affiliations and geographic location changes

EDUCATION:

Pursuing Bachelors of Arts in Business Administration (Senior status with 3.6 GPA – Anticipated completion date 9/2017)

Ashford University – Undergraduate Courses

University of Phoenix – Undergraduate Courses

Davenport University – Undergraduate Courses

* Employment Gaps-Worked at Olive Garden 6/2007 - 2/2011 as a Certified Trainer/Bartender

Contact this candidate