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

• Produced and maintained monthly financial dashboards for 5 divisions, 13 rehabilitative centers, and 33 doctors using PowerBi; proactively identifying actionable trends in insurance claims, collections, patient payments, and employee productivity
• Created demand and assumption-based budget models using Python, leveraging historical data to drive variance analysis, improving budget accuracy by 15%
• Collaborated with cross-functional teams to implement various stored procedures for data cleaning and extraction using SQL Server Management Studio, Visual Studio Code, and PowerBi, streamlining interdepartmental workflows and enhancing HIPPA data privacy compliance using restrictions
• Automated manual company-wide data reconciliation and reporting processes using Excel and Python, resulting in a 20% increase in operational efficiency and reducing errors across departments by over 70%
• Developed key performance indicators (KPI) using Excel and SQL, including metrics for financial performance and payroll data analysis, reducing monthly department reporting time from 1 week to 2 days

Data Quality Analyst

FCRD Services

• Delivered executive-level PowerBi reports and PowerPoint presentations, guiding key revenue and expense decisions that optimized financial outcomes by 10%
• Designed interactive dashboards in PowerBi to track product effectiveness, providing insights that led to improved decision-making and increased customer satisfaction
• Conducted drill-down analysis using Excel and PowerBI to uncover operational inefficiencies providing recommendations that led to a 25% improvement in overall efficiency
• Built and optimized ROI and cash flow projection models using advanced Excel functions, improving financial forecasting accuracy by 10-15% and informing strategic leadership decisions

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

• Oversaw daily and monthly manual bank reconciliations for over 1,500 customer accounts, ensuring 100% accuracy and completeness of financial records
• Managed customer data life cycles using proprietary software, ensuring full compliance with data privacy regulations and reducing data handling errors by 90%
• Provided prompt and professional responses to manufacturing and billing inquiries, enhancing customer satisfaction and accelerating payment timelines by over 75%
• Managed state and federal tax compliance by completing quarterly tax filings with 100% accuracy, ensuring timely remittance and preventing financial penalties
• Investigated and resolved accounting discrepancies, reducing financial reporting errors by 90% and ensuring data accuracy and compliance with internal audit standards
• Streamlined accounts payable procedures by restructuring data entry schedules and workflows, increasing efficiency by over 150%, and achieving significant operational cost savings
• Processed over 120 daily accounts receivable, credit card transactions, and invoices using cloud-based systems, reducing payment lag time and improving cash flow management

Huntington University

• Bachelor of Science, Accounting
• Bachelor of Arts, Psychology
• Minor in Management
• 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