Madison Lusane
Atlanta
Summary
Dynamic Data Analyst with a proven track record at Myers and Stauffer LC, specializing in transforming complex datasets into actionable insights through expertise in Excel, SQL, API integration, Python, ArcGIS Pro, and Power BI. Highly proficient in automating workflows and optimizing data processes to boost efficiency and drive informed decision-making. Skilled in data visualization and analysis, with a strong focus on accuracy, attention to detail, and delivering impactful results.
Overview
3
3
years of professional experience
Work History
Data Analyst
Myers and Stauffer LC
09.2023 - Current
- Developed and delivered monthly reports utilizing advanced Excel functions to streamline data analysis.
- Leveraged data visualization tools, including Power BI, to effectively communicate complex business insights to stakeholders.
- Created and maintained Excel-based tools to efficiently gather and present metrics, enabling concise resource allocation strategies.
- Enhanced decision-making by providing accurate, actionable insights through data analysis and visualization.
- Automated repetitive workflows through scripting, allowing more time for strategic and in-depth analysis.
- Improved reporting efficiency by optimizing SQL queries and restructuring databases, significantly reducing report generation time.
- Designed dynamic, visually appealing Power BI dashboards to simplify complex datasets and support informed decision-making.
- Applied advanced data visualization techniques to present clear, impactful insights tailored to stakeholder needs.
- Completed diverse projects involving the development of SQL and Python scripts from scratch to meet unique business requirements.
- Designed and implemented custom SQL queries and Python scripts to extract, transform, and analyze data, delivering tailored solutions for complex challenges.
- Demonstrated versatility by adapting scripting skills to various arbitrary projects, ensuring precise and effective results.
- Leveraged Power BI and API integration to analyze and create actionable insights from reports submitted by clients through a custom-built API portal.
Data Analyst Intern
Myers And Stauffer LC
01.2023 - 09.2023
- Identify, analyze and interpret trends or patterns in complex data sets by finding correlations and visualizing with charts.
- Utilize various professional statistical techniques and maintain large databases to collect and analyze data from internal and external clients.
- Develop tables, views and materialize views using SQL.
- Design, develop, modify and debug programs.
- Create accurate and successful test scripts to manage automation testing of certain products and features.
- Optimized SQL queries for faster processing times, increasing overall productivity within the team.
- Conducted thorough data validation and cleanup, ensuring accuracy and reliability of datasets used for analysis.
Ophthalmic Technician
Milan Eye Center
04.2022 - 11.2022
- Operated ophthalmic equipment for patient eye examinations and prepared patients for examinations and surgeries.
- Explained pre- and post-operative procedures to patients and carefully reviewed surgical plans.
- Measured intraocular pressure using Goldman and Tonopen tonometry process.
- Measured and recorded visual acuity and color vision testing.
Education
Certification - Data Science And Analytics
Georgia Institute of Technology
Atlanta, GA03.2023
Bachelor of Science - Computational And Applied Mathematics
Kennesaw State University
Kennesaw, GA08.2022
High School Diploma -
Shaw High School
Columbus, GA05.2017
Skills
- Data Visualization and Presentations: Expertise in creating visually compelling dashboards and reports using tools like Power BI and Excel to effectively communicate complex data insights to stakeholders
- Data Analysis: Skilled in analyzing large datasets to identify trends, patterns, and actionable insights, enabling informed business decisions
- Python Programming: Proficient in using Python for data analysis, automation, scripting, and developing custom solutions to streamline workflows
- Excel Functions: Strong knowledge of essential Excel functions and tools for efficient data management and reporting
- SQL Development: Strong proficiency in writing, optimizing, and managing SQL queries for data extraction, transformation, and analysis across multiple databases
- Data Cleaning: Experienced in preparing and cleaning raw data to ensure accuracy, consistency, and readiness for analysis
- ETL Processes: Skilled in designing and executing Extract, Transform, Load (ETL) workflows to integrate, process, and migrate data between systems
- Data Mapping: Adept at mapping data between systems or formats, ensuring seamless integration and consistency across datasets
Languages
Spanish
Elementary
Programming Languages
- R
- Python
- Java
- C#
- SAS
- MS SQL
- PowerBI
- Power Query
- SSIS
- VBA
- Microsoft Excel
- Microsoft Powerpoint
- Microsoft Word
- Office 360
- ArcGIS Pro
Timeline
Data Analyst
Myers and Stauffer LC
09.2023 - Current
Data Analyst Intern
Myers And Stauffer LC
01.2023 - 09.2023
Ophthalmic Technician
Milan Eye Center
04.2022 - 11.2022
Certification - Data Science And Analytics
Georgia Institute of Technology
Bachelor of Science - Computational And Applied Mathematics
Kennesaw State University
High School Diploma -
Shaw High School
Similar Profiles
Joy TontohJoy Tontoh
Senior Accountant at Myers And Stauffer LCSenior Accountant at Myers And Stauffer LC
Bradley C. HoffmannBradley C. Hoffmann
Staff Analyst at Myers and Stauffer LCStaff Analyst at Myers and Stauffer LC
Jacob DayJacob Day
Staff Accountant at Myers and Stauffer PLLCStaff Accountant at Myers and Stauffer PLLC