Pharmacy consultants working to educate clients to provide, savings, reduce waste and providean overall better pharmacy benefit.Tasks:Work with Analytics/Reporting DepartmentAssist in ETL ProcessDevelop Methods to Enhance Data QualityDevelop SQL Queries Troubleshoot Data IssuesWrite new Data MappingsAudit and Enhance Current Data Mappings

Mostly the same as DATA ANALYST but across multiple platforms of the now-merged EnvisionRx and MedtrakRx.

Pharmaceutical Benefit Manager (PBM) formerly know as MedtrakRx and recently merged with EnvisionRx and rebranded as Elixir Solutions.Tasks at Elixir:Write SQL Queries for Ad Hoc and Automated Reporting.Visualize Data Utilizing Tableau Desktop.Robotic Process Automation to Automate 100s of Reports, Daily Tasks, and Macros.Edit Microsoft Access and Excel VBA Macros, Queries, Tables, Import/Export Specifications.Translate and Map Client Data to Elixir Data.Collaborate and Automate Tasks for Internal Departments Including Billing, Clinical, Customer Service, Legal, Account Management.Part of Cross-Functional IT Department.Skills:RPA/VisualCronData AnalysisSQL/MySQL and OracleMicrosoft OfficeVBA for Access and ExcelOutlookWebEx TeamsCrystal ReportsFile Configuration and UploadingTableau Desktop

I worked in the Office of Environmental Quality as a data analyst. The majority of my time is spent running the Energy Empowerment Program, requiring me to use my skills in project management, customer service, and data analysis to maintain relationships, develop new strategies for running the program, and analyse the energy data and building records that come into the City. Other projects include interdepartmental work on sustainability projects.Major Accomplishments: Established guidelines and processes for Energy Empowerment Program.Helped hundreds of people collect and interpret energy consumption information.Wrote out an annual report published by the City using a combination of R and Power BI for visualization and analysis.Looked into the feasibility and implemented automating processes using various tools.Made major contributions to program website using Google Analytics to help implement updates.Developed spreadsheet calculations to replicate former Energy Star Score models.Observing outliers and gaps within the City's own facility utility usage and promote better data quality. Major data edits to over 70 buildings.Tasks:Main Point of Contact, Established Procedures for Energy Empowerment Program.Visualized of Program Data and Metrics Using Power Bi Desktop/One Drive/Power BI Service.Created Initial Specs and Upgrades for Program CRM Built by It. Managed Imported and Exported Data.Reported visualized and analyzed Energy Benchmarking Yearly Metrics Published by the City Using a Combination of Power BI, R, and Excel.Research Public Policy Relating to Environmentalism and Energy Efficiency.Strategically Used Google Analytics to Perform Major Contributions to Program Website.Developed Spreadsheet Calculations to Replicate Former ENERGY STAR Score Models.Key Skills:Power BIExcel and VBA MacrosCRMMicrosoft FlowREnergy Star Portfolio ManagerProject ManagementData AnalysisData CollectionData CleansingEducational MediaEmpathy

Eight week internship focusing on project management of incoming client requests.Tasks included:Project management for incoming client requests and see requests through start to finish.Updated information and ran project status reports for company and clients using Microsoft Excel.Located client information indexed in warehouse and produced scanned images of information on request into client systems.Communicated with clients about project requests, project status requests, and completed tasks.Key SkillsMicrosoft ExcelProject ManagementClient CommunicationCustomer Service

Company collected commercial real estate data from brokers in about 50 markets. My role was to collect information from the Orlando market and update the data.Tasks included:Performed various data collection and entry and word processing tasks; updated commercial real estate data, proofread and edited documents such as brochures and other marketing materials.Managed and assigned tasks to Philippines team researchers and ensured quality of their work.Led team market presentations in conference calls for supervisors in many departments in the company; topics include current metrics, goals, roadblocks, and suggestions for strategic change.Operated professional communication systems, such as telephone, email, video conference.Marketed listing data, brochure and photo information on the company website for brokers.Managed data in Sugar CRM.Major Accomplishments:Reduced overseas communication barriers with Philippine teammates. This improved the flow of communication and significantly increased data entry accuracy.Improved relationship with VP of large firm. Originally frustrated, he eventually provided large amounts of data to our company.Pitched simple operational change calculated to save $10,000/week in productivity.

Policy internship within the Mayor's Office.Tasks included:• Received inbound constituent calls and addressed needs or transferred individuals as needed.• Attended public meetings and took detailed notes on events, such as youth commission.• Attended several professional on-the-job training courses detailing how to train individuals.• Researched public policy within the city and other metropolitan areas in the country to make recommendations on effective policy and strategically implementing various policy changes.