Jokeith Green, MSBI

Experience

• 

  US Army

  Feb 1996 - Feb 2004

  Combat Medic

  Come to the aid of wounded, injured or ill soldiers.

• 

  Louisiana National Guard

  Dec 2007 - Dec 2014

  Healthcare Specialist

  • Assisted in organizing and instructing Combat Lifesaver Classes for the 225th Engineer Brigade across the state of Louisiana, resulting in over 2500 soldiers (over 7 years) being trained and certified. • Served as a Project Manager for the 256 Engineer Brigade Annual Health Assessment using line balancing strategies• Compiled medical readiness data.• Created databases and visualizations, using Excel, to ensure supervisor could accurately report the status of the Brigades medical readiness to the Commanding General on a quarterly basis.• Accurately informed Higher command resulting in higher medical readiness grades and a decrease in duplicate work bringing spending on supplies down due to less waste. Show less

• 

  CVS Caremark Corporation

  Mar 2010 - Jul 2014

  Lead Pharmacy Tech - Inventory Specialist

  • Reached out to doctors’ offices to clarify orders and resolve patient concerns, resulting in better patient safety, correct order filling, and a better relationship with both the doctors and the customers. • Promoted items that were on sale and seasonal promotions that were sent down from the corporate level, resulting in an increase in overall store and pharmacy sales.• Performed Data entry of the customers prescription information and insurance information. Promoted seasonal sales and customer appreciation events, resulting in increased brand and customer loyalty. • Controlled the flow of inventory. Ordered medications that were running low seeking the best deal from our vender, removed expired medications from the shelves and order more. A decrease in pharmacy drug cost was a direct result of this action.• Establishes and monitored a “fast mover shelf” so that the most commonly used drugs could be reached faster, bringing about a more proficient and system. This also resulted in increased productivity by decreasing the time it took to fill prescriptions.• Submitted and followed up on Prior Authorization request to insurance companies.• Responsible for Technician scheduling and time off request approval• Responsible for coaching and counseling.• Contributed to the hiring and firing process. Show less

• 

  Express Pharmacy Solutions

  Sept 2016 - Dec 2018

  Lead Pharmacy Analyst

  • Developed databases in excel to manage customer orders including insurance adjudication status and shipping status.• Created weekly reports and visualizations with Microsoft Word, Excel, and Power BI to show management the status of our inventory, sales, outgoing orders, and scheduled orders.• Managed Workers Compensation claims from end to end personally completing over $315,000 in, paper hand billed, Workers Comp claims collected in 2018.• Created a database with excel that contained the details of Workers Comp orders that we are working on allowing me to create Profit/Loss and Profitability reports.• Negotiated a price that is reasonable for both parties with Worker Comp companies who were unwilling to pay the originally billed price. This resulted in a dramatic increase in payments received.• Submitted and followed up on prior authorization request to insurance companied for services or medications that were initially deemed too expensive or no in the line of therapy based on diagnosis code submitted.• Supervised up to 2 other pharmacy technicians and 1 customer service representative, created schedules, and provided coaching when necessary.• Effectively trained new Technicians, Sales Associates and Customer Service Reps creating an efficient workforce leading to the team receiving three quarterly bonuses in 2018. This is compared to zero quarterly bonuses in the previous year prior to me becoming the lead technician.• Responsible for Technician scheduling and time off request approval• Responsible for coaching and counseling.• Contributed to the hiring and firing process. Show less

• 

  LAAJ Business Solutions

  Jan 2017 - Dec 2019

  Business Intelligence Analyst

  • Used tools such an Excel and Power BI to clean data and convert it into actionable information using DAX measures.•Created Business Intelligence Reports and Dashboard for end user use• Set up KPI Dashboards to assist in the decision-making process.• Provided analysis and insights to senior management on metric development variations.• Communicated technical information clearly and accurately through speech, writing, Power Point presentations and Power BI Data Visualizations.

• 

  Kroger Specialty Pharmacy

  Mar 2019 - Nov 2020

  Lead Pharmacy Technician

  • Member of the Quality Improvement Team• Audited team member performance to ensure workflow processes were up to quality standards.• Created detailed reports and graphs of the quality audits to team members supervisor for review.• Write detailed progress notes on outcome of activities performed allowing clear communication for those who accessed the patient's EMR after me. • Ensure all required elements of referral are present and following up with appropriate parties to obtain missing information.• Route referral to the correct station that would be next in the process, dictated by the findings in insurance adjudication.• Responsible for making 65 reaches each day (processing new referrals, and reaching out to clients to update the status, etc.). • Exceeded expected metric goals by 10% on monthly basis.• Submitted and followed up on Prior Authorizations for medications or services deemed too expensive for insurance companies. Show less

• 

  Option Care Health

  Nov 2020 - Jun 2022

  Pharmacy Tech Supervisor/ Pharmacy Analyst

  • Effectively managed and maintained a physical inventory of $36M.• Led the pharmacy through quarterly inventory events. I was able to reduce our inventory variance from -$202,000.00 when I started to under $125.00 when I left.• Managed inventory using Oracle Fusion Cloud and Oracle Business Intelligence.• Supervised 10 IV Cleanroom Technicians.• Maintained standards of cleanliness in the IV Cleanroom in accordance with federal, state, and regulatory guidelines.• Ordered drugs and supplies to replenish depleted inventory.• Responsible for ensuring that all team members maintain their competencies and that their certifications are up to date.• Created reports and dashboard using Microsoft Power BI and Oracle Business Intelligence to analyze and report inventory issues.• Created reports and dashboard using Microsoft Power BI to maintain optimal inventory par levels and to order each drug from the best source for the best price. By doing this I was able to keep our Cost of Goods Sold low in comparison with other branches within the company.• Promoted a spirit of teamwork and encouraged communication when dealing with difficult team members.• Exemplified leadership through 3 cleanroom shutdowns, due to a malfunctioning HVAC system, where my team had to perform compounding activity at another branch an hour and a half away from our home branch.• Coordinated the logistics of shipping medications for the orders that were dispensed at our home branch to our alternate location during the shut downs. • Triaged orders as that came in and ensure that my team compounded the medications based on the priorities laid out by the Pharmacists. Then made certain the correct orders were send back to our home branch at the correct times so they could be shipped or delivered to our patients when their dose is due.• Effectively used business analytics while scheduling and team time management during extended periods of being short staffed. Show less

• 

  Clearly Amazing

  Apr 2022 - Jul 2023

  Senior Business Intelligence Analyst

  • Build Business Intelligence Department from the ground up, setting the foundation for actionable insights to be presented to leadership on a continuous basis. • Develop APIs for the CRM system to set up data flows for the Extract, Transform, Load (ETL) process in Power BI for business analysis.• Use M-Language to shape data in Power BI Query.• Collect & Analyze Sales Data using Excel, Google Sheets and Microsoft Power BI.• Examine Work Orders created and other sales reports to identify sales patterns and areas for improvement, comparing actual sales data to goals.• Review charges to determine if reps are upselling and bundling multiple services• Compare sales to quota, by market, by rep, by call center/team• Identify capacity (either specific markets, or days) and share with Leadership to maximize density• Review all Plans sold as recorded by the Sales reps. Confirm recurrence is set up properly and Service Charges are entered correctly. Clean and validate data in Power BI.• Deploy Data Management and Data Warehousing techniques while collecting, storing and using the data extracted from the CRM tool.• Create Contracts in Vonigo with information on Plans Sold tracking doc.• Ensure Data entry of incoming leads and plans are correct.• Identify training needs and conduct training, as needed.• Create reports for Management breaking down Plans sold by type, on site estimator and daily, month, annual amount.• Create and maintain a Master Dashboard for the corporate level and drilldown dashboards for each of the 9 subsidiary sites. • Generate accurate, clear KPIs and reports that explain complex trends using Microsoft Power BI.• Use Python and Power BI to identify sales trends and forecast future sales based on historical and seasonal data. Show less

• 

  Eminent Future

  Jan 2023 - May 2024

  Business Intelligence Analyst

  • Extract data from databases using Microsoft SQL Server creating joins where necessary.• Ingest data into Power BI or Tableau using databricks.• Explore, Wrangle, Mutate, Process, and Export Data in R Studio.• Flatten Data to CSV or Excel files.• Import flatten files into Tableau for data modeling and visualization.• Create tiles, dashboards and stories in Tableau to visualize the data.• Gather meaningful insights from the visualizations.• Create PowerPoint Presentations using the visualizations and explained the actionable insights and analyst recommendations drawn from the data and visualizations.• Support State Department by helping to design front office and budget formula systems. Show less

• 

  DSD Laboratories

  Sept 2023 - May 2024

  Business Intelligence Analyst

  Develop Business Intelligence solutions using the Qlik Sense and Jira system.Pull reports from multiple databases creating joins where necessary. Clean, manipulate data to link relationships creating Star and Snowflake schemas during the ETL process.Support mission objectives by providing clean, insightful visualizations based on granular data pulled in from databricks.