Jerome Mitchell Email & Phone Number

Marietta, Georgia, United States

● Designed and developed dynamic clinical study dashboards using Power BI and MicroStrategy Dossier, providing management with data visualization and analytics for faster and more informed decision-making● Collaborated with clinical operations to identify key performance indicators and metrics to best measure study progress and results● Analyzed KPIs to determine areas of improvement and provide recommendations for operational strategies● Monitored and reviewed study results and identified areas for further research and investigation to support management with strategic planning and goal setting● Utilized Excel, SQL, and SAS to clean and validate data for accurate reporting and analysis

Greater Atlanta Area

● Implemented and modified client dashboards, enhancing user navigation and reporting functionality● Analyzed data quality for the company, client portfolios, and third-party contracts to generate reports and create data visualizations for presentations● Completed quality assurance testing of automated systems, forms, dashboards, and reports to ensure accuracy● Improved delivery time of manual quarterly reporting by 90% through the implementation of automated KPI and status reports for various clients● Collected, reviewed, and presented data for client progress reports to support business planning and goal setting● Entered and updated approximately 100 SQL queries to manipulate data for importation

Greater Atlanta Area

● Served as a Subject Matter Expert within EDI (Electronic Data Interchange), focusing on Electronic Remittance Advice (835) to ensure prompt and proper payment processing● Acted as an invaluable resource to overseas partners, providing education about current processing systems and common troubleshooting tips● Identified root cause for issues, recommended solutions and delivered application support to maintain high user satisfaction

Greater Atlanta Area

● Assisted team with ANSI 5010 conversion project for Bank of America, by setting up processing tables to migrate data from 4010 version up to 5010 version● Played a key role in administration of ANSI 4010 project to set up mapping tables and convert ANSI files into a specific format for proper business processing● Constructed, maintained, and tested tables to translate data for ANSI X12 format transactions, print image data from proprietary Electronic Data Capture (EDC) system, and additional file types such as CSV and XML to organize files into a standardized database format● Conducted implementation of a new automation process which slashed labor hours and cut costs associated with healthcare provider billing, data procurement, and processing