Alec Macdonell
Fresno,CA
Summary
Accomplished Senior Data Analyst with a proven track record at Integrated Prescription Management, leveraging Python programming and advanced analytics to deliver actionable insights, enhancing decision-making and operational efficiency. Skilled in fostering cross-departmental collaboration, demonstrating exceptional problem-solving and data warehousing expertise to drive business intelligence initiatives.
Overview
30
30
years of professional experience
Work History
Senior Data Analyst
Integrated Prescription Management
06.2009 - 03.2023
- Delivered comprehensive reports highlighting key trends, patterns, anomalies, presenting findings to senior management for informed decision-making purposes.
- Analyzed large amounts of data to identify trends and find patterns, signals and hidden stories within data.
- Leveraged text, charts and graphs to communicate findings in understandable format.
- Partnered with IT teams to ensure seamless integration between databases and analytical tools, maximizing system efficiency across departments.
- Assessed large datasets, drew valid inferences and prepared insights in narrative or visual forms.
Database Administrator
UsScript
03.2000 - 06.2009
- Streamlined backup and recovery processes, enhancing overall system stability and availability.
- Ensured database security with implementation of role-based access control and regular vulnerability assessments.
- Reduced data retrieval times for business users by creating indexed views and optimizing stored procedures.
- Built databases and table structures for web applications.
Computer Programmer Analyst
RxNet
07.1993 - 01.2000
- Created databases, data entry systems, web forms, and other applications for diverse uses.
- Collaborated with cross-functional teams to develop innovative solutions for complex business problems, improving overall system functionality.
- Spearheaded the migration of legacy systems to modern platforms, ensuring seamless integration and minimal downtime.
- Developed in-house applications designed for company needs.
Education
Bachelor of Science - Mathematics
Harvard University in Extension
Cambridge, MA06.2025
Skills
- Advanced Excel
- Python Programming
- Data Warehousing
- Business Intelligence
- SQL Expertise
- Tableau Software
- R Programming
- Statistical modeling
- Advanced analytics
Timeline
Senior Data Analyst
Integrated Prescription Management
06.2009 - 03.2023
Database Administrator
UsScript
03.2000 - 06.2009
Computer Programmer Analyst
RxNet
07.1993 - 01.2000
Bachelor of Science - Mathematics
Harvard University in Extension
Similar Profiles
Paul ThurstonPaul Thurston
Construction Worker/Interim Site Superintendent at Integrated Construction Management, Inc.Construction Worker/Interim Site Superintendent at Integrated Construction Management, Inc.
Muddasir ShahMuddasir Shah
FM Engineer at Concordia DMCC integrated Facility ManagementFM Engineer at Concordia DMCC integrated Facility Management
Francesca MedinaFrancesca Medina
Chiropractor Assistant at Absolute Integrated Health Pain ManagementChiropractor Assistant at Absolute Integrated Health Pain Management