Post Job Free

Resume

Sign in

Manager Data Analyst

Location:
West Bloomfield Township, MI
Salary:
95000
Posted:
February 17, 2021

Contact this candidate

Resume:

DOUGLAS J. PARSON

adj88p@r.postjobfree.com

734-***-****

•A Motivated Business Analyst and Systems Manager with a 10 year track record of success in Healthcare and Automotive industries.

•Has leveraged positions in business analysis and project management to implement continuous process improvement strategies that resulted in reduced operational costs and waste.

•Utilized pharmacy system - QS1 functionality to reduce drug inventory and improve health insurance receivables

•Documented processes for Medicare billing to reduce audits and improve cash flow.

•Has employed six sigma and lean operating principles to chart data and quantify improvements.

•Regarded as a motivated leader, effective change agent, and ambitious professional.

SKILLS SUMMARY

Client/Vendor Relations IT Implementation Budget Management

Process Improvement Staff Coaching/Mentoring Project Planning

End User Training Inventory Control E-Commerce

Ad-Hoc Database Report Generation Cost Benefit Analysis Financial Analysis

SOFTWARE PROFICIENCY

Brightree (Medicare Billing System), QS/1 (Pharmacy System), Microsoft Sharepoint, Microsoft Office, Word, Excel, PowerPoint, Access, Microsoft Project, Visio, SQL, SQL Queries, HTML, PeopleSoft, SAP, Peachtree, ALM-HP Quality Center, Outlook, Lotus Notes, Jira-Agile, Tableau, Collibra, Service Now

PROFESSIONAL EXPERIENCE

Diplomat Specialty Pharmacy Jul 2014 – Present

Business Analyst

•Responsible for aligning business deliverables with project goals.

•Gather Requirements, Prepare Functional Specification Documents and Utilize Agile to achieve project timeline and manage change.

•Constructed V-LOOKUP in excel to capture data points from multiple sources into common layout for development.

•Refine Process Work flows to reduce development time.

•Develop Test cases with Quality Assurance to ensure that deliverables are being fulfilled.

•Coordinate data governance activities of mapping of customer field requirements to business terms.

•Define big data source fields from multiple sources and provide logic for common etl process into data vault.

Healthy Living Diabetic LLC Feb 2010 – Apr 2012

Operations Manager

•Lead operations of Diabetic Mail Order, Durable Medical Equipment and Pharmacy Operations.

•Developed scorecard metrics and established baselines to gauge productivity and DSO score.

•Main point of contact for Compliance and Government Medicare Audits.

•Managed dispensing trends in Excel to reduce drug costs and maximize Sales Incentives.

•Implemented electronic time clock and EDI feeds into standardized payroll system.

•Developed Order Shipment Queries to produce daily exports into third party logistics shipping software.

•Created process flow diagrams for billing errors to shorten length of payment and increase cash flow.

Chrysler Corporation / Mopar Parts and Service Feb 1997 – Nov 2008

Operations Planning and Support Manager 2004 - 2008

•Led operations of a 1.25 million square foot distribution center housing $96 million in vehicle parts inventory.

•Main point of contact for computer systems, customer service, and accounts payable.

•Guided two managers, ten supervisors, and eight salaried charged with inventory, safety, and quality metrics.

•Created a budget of over $8 million and cut monthly expenditures for the complex by 20% over four years.

•Managed process improvement projects of shipping $250+ million in products that led to increases in all supply chain metrics to 25 global parts distribution centers, and 5,400 automobile dealerships.

•Reduced warehouse shrink resolution time by 24 hours and increased vendor payments by 5 days.

•Expanded ISO quality systems by establishment of rigorous audits and development of robust process controls for sustained improvements.

•Created Ad-hoc database SQL queries to utilize system data in excel to make knowledges based decisions to solve operational issues and reduce cost.

Labor Saving Initiatives

•Saved over $2.8 million by increasing inbound lines per hour by 26% and outbound lines per hour by 19% while reducing indirect labor over a four-year period.

•Generated savings of $250,000 by implementing a one-shift loading operation, which reduced two salaried employees and supervisor overtime.

•Exceeded performance goals by 15%, eliminating the need for weekend overtime and saving $715,000+ in budgeted labor expenses.

Time Saving Initiatives

•Reduced time needed to select and ship daily receipts to field parts distribution centers from 118 hours to 71 hours.

•Participated in completing a Green Belt project to reduce pool to intransit @ 3 sigma.

•Designed process to ship directly to customers via United Parcel Service, decreasing cycle time by 20%.

•Increased production by ten minutes per employee per shift and reallocated five heads per week into productive activities by creating HTML content for an Andon Electronic Display Board on the plant floor, to communicate safety, quality, and delivery metrics and corporate information to employees.

Project Manager - Warehouse System Deployment Manager 2000 - 2004

•As an internal business consultant, focused efforts on redesigning and sustaining warehouse processes.

•Evaluated the functionality, growth, and system architecture of warehouse management systems of five vendors and prepared a business case, ROI, and GAP analysis of the top two products.

•Prepared and maintained a project implementation plan and reviewed vendor compliance with purchase order.

•Transformed sql configuration files into excel templates for cookie cutter type system configurations.

•Partnered with finance to map new transactions to the financial ledger.

•Developed user test cases and monitored progression of data at each stage of the transaction.

•Identified issues during test plan and implemented corrections prior to first site launch.

•Developed training material content and facilitated training sessions with end users prior to each launch.

•Led diverse, cross-functional teams in the fulfillment of productivity, quality and bottom-line objectives

•Focused efforts on redesigning and sustaining processes, setting the stage for future and on-going process improvements.

•Conducted 30/60/90 day follow up programs and responsible for senior management update presentations.

Labor Saving Initiatives

•Integrated the first Mopar and Mercedes Benz parts distribution center in Orlando, Florida with SAP, resulting in significant overhead cost savings, a warehouse in Jacksonville was closed, and 18 staff members were reassigned within the network.

Business Analyst - Manager User Systems 1999 - 2000

•Supported Chrysler’s receiving system at five distribution centers and four third-party packagers.

•Prepared system rollout plant to 15 additional parts distribution centers.

•Managed site configuration integrity.

•Directed supervision to maintain system integrity by maintaining current dates and purge of data.

•Documented system functionality to support manpower turnover.

•Conducted training workshops for all users and provided newly created handouts.

Time Saving Initiatives

•Eliminated redundant tasks, saving dispatchers five minutes each shift, by enhancing Chrysler’s receiving system to include a new PF key to print inyard reports. Also enabled an auto link feature.

•Developed a training program for the field distribution center launch of Chrysler’s receiving system, thus standardizing receiving processes in all part distribution center operations.

Warehouse Manager 1997 - 1999

•Directed 2 supervisors and 55 UAW employees in a 350,000 square foot facility containing top twenty percent of high volume parts in the Mopar network.

•Communicated with the dealer network to eliminate service issues.

•Partnered with the global warehousing system team to implement a Radcliffe warehousing system.

•Scheduled workforce to achieve compliance and thru-put goals.

•Maintained safety and part quality initiative programs.

•Worked harmoniously with union leaders to facilitate change and deliver results.

EDUCATION

Master of Science, Information Resource Management, Central Michigan University

Bachelor of Business Administration, Management / Finance, University of Michigan

ADDITIONAL TRAINING: Six Sigma Green Belt; Root Cause Analysis; Continuous Improvement; ISO Assessment; Occupational Health and Safety; Workplace Violence and Employee Assistance



Contact this candidate