We provide IT Staff Augmentation Services!

Business Intelligence And Reporting Consultant Resume

4.00/5 (Submit Your Rating)

Nashville, TN

COMPUTER SOFTWARE:

Excel, SQL, SQL Server Management Studio, Visio, Linux Nano, Walmart( SAP, SMART, Retail Link), Service Titan ERP, Meraki MDM, Windows 10, Kali Linux, Oracle VM, ACL

PROFESSIONAL EXPERIENCE:

Confidential, Nashville, TN

Business Intelligence and Reporting Consultant

Responsibilities:

  • Performed software quality control testing of Service Titan ERP system. Identified significant software and business process issues.
  • Worked with the CFO and CIO to define KPI and produce operational dashboards.
  • System Administration / IT Architecture
  • Developed and Deployed the companies first MDM software for 1,000 mobile devices including role based permissions, whitelists, OS versions control, and asset tracking capabilities.
  • Authored the companies first mobile device and acceptable use policies
  • Audit
  • Identified 75% failure rate in maintaining customer record accuracy in ERP system. Developed methodology for call center to correct accuracy issue.
  • Resolved call center process of breaching customer PII on 63% of phone calls.

Confidential

Senior Analyst

Responsibilities:

  • Created reporting dashboards with SQL, MicroStrategy and Tableau resulting in the reduction of one FTE for reporting functions.
  • Developed automated dashboards on call center industry benchmark KPIs.
  • Developed operation dashboards to visualize agent performance, call center process performance, first call resolution, geographical performance, and customer asset performance.
  • Implemented a proof of concept to quantify customer satisfaction through after call surveys on 2,000 agents in three call centers.

Confidential

Data Analytics Manager

Responsibilities:

  • Developed and implemented financial risk mitigation framework. Increased main process accuracy by 45% on the largest work stream for vendor EDI and store merchandise reconciliation process.
  • Created and implemented entire financial reporting framework with weekly scorecard status updates to Executive VP level.
  • Developed and measured all KPIs and SLAs to evaluate multiple work streams for 1,000 production employees in multiple legacy computer systems.
  • Researched budget variance on a pharmaceutical accounting reconciliation process and projected $6MM in human errors annually based on an audit sample set. Worked cross functionally to automate vendor transactions for an ROI of eight FTEs.

Confidential, Bentonville, AR

Fraud Manager

Responsibilities:

  • Identified and resolved $21MM in wasteful spending and fraudulent activity.
  • Developed audit methodology for store based cash office disbursements and identified over $10MM in policy violations.
  • Led cross functional team with SOX, Internal Audit, and legal to perform risk testing and continuous monitoring of the payroll department in which over 20 ghost employees were identified.
  • Created a new process to identify conflicts of interests that resulted in 15 cases submitted to the ethics department that lead to 1 VP and 12 Senior/Director level terminations.

We'd love your feedback!