About Me

I am Sonya "Sunny" Lawrence-Thompson, a curious and intrinsically motivated Analyst with a passion for solving complex problems and crafting strategic solutions. My journey through the consumer goods, manufacturing, and healthcare industries has sharpened my analytical skills and deepened my love for data-driven decision-making.

I thrive on challenges that require a blend of systematic thinking and creativity. My expertise in Python, SQL, Database Manipulation, and financial analysis tools like Excel and Power BI enables me to turn data into actionable insights. I'm always learning and pushing the boundaries of what is possible, whether it be automating a process or diving into a new project with fresh eyes.

I believe in finding the right solution for every problem, and I am driven by a disciplined approach and a relentless curiosity. My goal is to leverage my skills to make a meaningful impact, all while staying true to my love for learning and exploration.

Favorite quote: "The only thing we have to fear is fear itself" FDR

Financial Analyst

Jacksonville Orthopaedic Institute

• Automated manual company-wide processes using Microsoft Excel and Python
• Collaborated with various departments to develop and produce new data management tools
• Strategically designed key performance indicators (KPI) to guide company wide data analysis
• Implemented budget processes using demand and assumption-based analytics, while conducting monthly variance analysis
• Produced monthly financial dashboards using Microsoft Power BI; proactively identifying emerging trends in financial data to drive timely action

Data Quality Analyst

FCRD Services

• Built and maintained financial models for ROI and Cash flow projections as needed.
• Developed dashboards to measure and monitor the effectiveness of products and services.
• Conducted drill-down analysis to identify recommendations to improve outcomes and overall performance improvements.
• Possessed and maintained a comprehensive understanding and knowledge of the industry, products and services, and corporate organizational structure.
• Effectively communicated results of analyses to the management team, executive leadership, and greater organization in professional reports and presentations.

Data Science Fellow

edX

• Demonstrated proficiency in SQL and experience in designing and implementing data models, conducting data analysis, and performing ELT functions to extract, load, and transform data.
• Improved skills in using IBM Cognos, Power BI, and various Python libraries such as Matplotlib, Pandas, Seaborn, and Plotly to visualize reports and generate dashboards.
• Developed a strong understanding of Machine Learning algorithms and models, with experience applying them to real-world problems using Python and MySQL in Jupyter Notebook.
• Demonstrated ability to develop and implement structured methodologies to tackle complex data science problems and projects.
• Gained experience in data mining, cleaning, and wrangling, and constructing data pipelines to support Machine Learning and other analytics use cases.

Accountant

Indiana Stamp Company

• Ensured tax compliance by timely remitting state and federal business taxes.
• Improved efficiency by over 90% by streamlining accounts payable procedures and overseeing daily and monthly bank reconciliation statements, ensuring accuracy and completeness.
• Managed the entire data life cycle for customers' personally identifiable data using proprietary local software, ensuring compliance with data privacy regulations while investigating and resolving accounting discrepancies promptly.

Staff Accountant/Office Manager

BTS Plumbing & Heating

• Spearheaded company-wide data transformation from hardware to software and analyzed complex business problems to identify solutions
• Efficiently inputted customer's personally identifiable data into proprietary local software and accurately coded financial data using QuickBooks Desktop Pro
• Managed 50+ daily job schedules using Microsoft Excel aggregate functions and followed up with contractors to ensure timely job completion
• Collaborated with a Certified Public Accountant (CPA) to probe financial statements for adherence to GAAP
• Created and managed Microsoft Excel spreadsheets containing 10,000+ customer job profiles, utilizing Pivot Tables, LOOKUP functions, and formulas.

Huntington University

• Bachelor of Science, Accounting
• Bachelor of Arts, Psychology
• Minor in Management
• Cum Laude
• Activities and societies:
• > International Student Council, Treasurer
• > Alpha Gamma Pi, President
• > Friesen Center, Volunteer

International Open Academy

• Certified ESL Instructor
• > Teaching English as a Second Language