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.