Jacqueline Smith-Medrick Email & Phone Number

Seville, Oh, Us

Ensured performance obligations of outsourced computer programs are met. Compiled and analyzed data of support systems to support management, maintenance and performance. Generated and compiled reports to identify problems and provide possible solutions for outstanding issues. Applied communication, analytical and problem-solving skills to identify and resolve system issues and boost performance and benefit of IT systems investments.● Identified issue with cross-functional tables and worked collaboratively with other teams to resolve data flow.● Tapped for RPA development to automate processes and free up work resources.

Ohio, United States

● Developed reporting utilizing SQL and Excel to isolate Owner Operator drivers responsible for bypass self-payment.● Developed a hardware tracker in Excel VBA resulting in recovery of over $130k of lost equipment in the first 6 months of use.● Utilization of multiple SQL joins to identify database inaccuracies and identify corrections needed.● SME for fleet camera, weight bypass, database integrity programs.● Heavily influenced database upgrade development through structured SQL queries and data flow corrections.

Streamline overall supply chain functions to ensure timely delivery of orders. Manage technical reports and share valuable insights with management. Orchestrate training sessions regarding modern applications in Ortec for maintaining dispatch system through direct access. Oversee area logistics, transform raw data into useful information, and track deliveries leveraging SAP, QlikView, and CRM software.● Utilized QlikView reporting to identify areas of improvement and increased on-time delivery percentage of business and residential propane sales up to 100% within a year by devising and implementing robust logistic solutions.● Formulated on-boarding and training materials to quickly integrate new hires.

Delivered remarkable technical support, as well as analyzed and troubleshot complex issues for boosting client and employee satisfaction. Designed and developed a grading scale for recruiting vendors. Devised efficacious SOPs for facilitating staff personnel in performing simple IT tasks. Maintained database backup for recovery and fixed county field and vendors laptops. Oversaw auditor’s website and conducted maintenance operations to ensure smooth functioning. ● Promoted green environment by preventing around 3K hard copies of documents through the automation and digitization of county forms. ● Installed 40-seat computer lab with reimaged machines and fully networked for county software training camp.● Maintained auditor’s website including running and working errors of SQL scripts to upload accurate county tax payment information.● Developed a standards handbook of regulations and SOPs for future IT technicians.

Cleveland/Akron, Ohio Area

Responded to incoming calls from clients for providing support and resolving complex issues. Provided Medicaid approval, as well as conducted SNAP interviews. Conducted research to determine eligibility and oversaw various fraud alerts.● Formulated and implemented an effective process to guarantee monitoring of all flagged accounts within time constraints. ● Played a key role in retrieving $25K+ of fraudulent payments within a year by conducting research and performing analysis.● Garnered positive feedback from escalated customers for providing exceptional services and boosting satisfaction.● Recognized for efficiently using the alert collection and facilitating staff personnel by providing training to swiftly mitigate threats.● Maintained eligibility standards through review and understanding of the Ohio Revised Code.