Meghan Alexander Email & Phone Number

Jacksonville, Fl, Us

Jacksonville, Fl, Us

Jacksonville, Florida, Us

New York, New York, Us

Jacksonville, Florida, Us

- Create requirements based on business needs for reports and ad hoc analysis- Developed datasets for consumption using proc SQL within SAS- Created and maintained PowerBI dashboards related to current project operations- Investigated discrepancies between provided logic scenarios and post implementation scenarios and gathered and organized new requirements based those findings with advisement from Business- Maintained and processed records through SAS which enriched and transformed data for consumption by vendors to allow the procurement of Medicare member charts- Managed relationships with leadership to create visibility of issues and support upcoming changes - Finalized Lean Six Sigma Project and earned Green Belt Certification

Jacksonville, Florida, Us

- Identified 30+ issues within databases and payment system and coordinated with impacted areas to investigate or resolve issues - Applied logic to source data utilizing SAS and SQL to identify errors which led to inaccurate payment downstream of almost 1M in the past two years, and estimated savings of 500K/yearly savings with my developed automation- Completed Lean Six Sigma training - Assisted Administration Team in multiple improvement projects that helped with time savings (400hrs+/yearly), efficiencies and accuracy of work - Developed and managed a OneNote knowledgebase for department to improve governance, visibility, and standardization of business and technical knowledge of Sales Compensation as well as processes for creation and approval of documentation- Provided evaluations for business leaders by creating complex datasets utilizing application, enrollment, contract alignment, and sales compensation data to project impacts of adjustments to current compensation plans- Created an Over 65 auto-dispositioning tool (using SAS) for improving operational efficiency and processing of disputes and reducing the potential for manual error caused by human review- Coordinated with IT and provided requirements for solutions/changes to current builds to production systems leading to increased accuracy of the Sales Compensation payment system - Became the trusted source for knowledge and advisement in Over 65 data in relation to Sales Compensation, including impacts of CMS regulation and Medicare Supplement regulation, therefore providing input, analysis, and recommendations for business leaders on changes to Sales Compensation O65 Channel

Jacksonville, Fl, Us

- Created Ad Hoc Analysis for power users to answer business questions utilizing SQL, Excel pivot tables, Tableau, PowerBI and OBIEE- Performed QA for EDW implementation, organized UAT documentation within SharePoint Lists, and trained power users on tools as well as processes which led to increased trust and adoption of current systems created by myself and my team- Created and managed power user mapping documentation stored in Excel that referenced IT transformation rules by utilizing INDEX MATCH MATCH formulas as well as hyperlinks for all downstream data sources to increase visibility and increase knowledge of business users of how tables interacted with one another - Worked with the Business to finalize and adjust business requirements for changes/builds improving quality of requirements and decrease of follow up requests as well as clarification needed to execute requests- Improved work quality of work by completing additional training when available including SQL, Tableau, OBIEE, SSAS, and PowerBI- Led bi-weekly meetings with the Business to update on project progress and capture current concerns identified by the Business - Investigate UAT issues on reports- Create SharePoint solutions to improve communication within team and with business- Utilized JIRA for task tracking- Assisted users with requests using ServiceNow

- Directly managed the hiring of new technicians, which included reviewing applications, interviewing applicants, and processing accesses needed for new technicians- Continuation of duties listed in previous career histories

- Improved training documentation to keep material up to date with a dynamic technological environment which encouraged consistent and accurate training of processes- Analyzed and updated ticket auditing practices to accurately pull from complete data as well as encouraged random sampling of data• Managed reports within ticketing system and consulted coworkers on the creation of reports to confirm data integrity- Created reports to generate statistics to document trends on a monthly basis to encourage employee engagement- Resolved malfunctions within Excel documents to avoid the impediment of workflow within management team- Documented specialized knowledge on processes in Knowledge Base to assist new management staff on current management operations- Created work schedules for technicians through Excel - Received ITIL Foundations certification to improve IT Service Management knowledge

- Provided Tier I & II IT support for UNF’s community of students, faculty and staff while demonstrating exceptional customer service- Created multiple reports within ticketing system for daily operations to run efficiently- Edited existing reports to provide concise queues- Trained and mentored new technicians to sustain knowledge within the Help Desk- Initiated projects with the approval of management to improve efficiency

Master Of Science - Ms, Data Science

Bachelor Of Arts (B.A.), Multi/Interdisciplinary Studies