WILBERSON THEODORE
Albany, New York ***** 518-***-****
*****************@*****.***
Skills
• Data Visualization (Tableau).
• SQL (MySQL, PostgreSQL).
• Data Analysis, Data Aggregation, Data cleaning.
• Microsoft excel (Pivot Tables, IF, VLOOKUP, XLOOKUP)
• Salesforce, Jira, Google Cloud Platform.
• Basic understanding of machine learning algorithms.
• Market Research, Business analysis.
• Familiarly with R Programming.
• Technical Documentation.
• Extensive knowledge of cryptocurrency markets and blockchain technology.
Experience
Statistical Analyst,04/2023 Current
New York State Education Department Albany, New York
• Compiled and computed data for reporting using Microsoft Excel and statistic reporting templates, resulting in accurate and timely reporting for management.
• Successfully designed and deployed a secure platform, resulting in a 30% increase in data accessibility and a 25% improvement in data-driven decision-making.
• Utilized Microsoft Excel formulas, including Xlookup and IF, to efficiently complete required tasks and reduce manual data entry by 30%.
• Conducted statistical analysis on large datasets to support research initiatives and educational policy decisions, resulting in a 15% improvement in program effectiveness.
• Accelerated stakeholder comprehension by spearheading the creation of interactive Tableau dashboards and data visualizations; drove a 40% increase in understanding and enhanced communication of insights and outcomes.
• Conducted extensive data analysis to evaluate the effectiveness of educational programs and interventions, providing actionable insights for improvement.
Business Analyst, 02/2022 04/2023
Purshe Kaplan Sterling Investments Albany, New York
• Employed SQL expertise to efficiently execute data cleaning, transformation, and validation tasks, resulting in a significant improvement of 95% in data accuracy and ensuring consistent and reliable data for all analytical procedures.
• Created commission batches with 100% accuracy for electronic deposits on Salesforce, reducing payment errors by 35% and saving the company over $20,000 in payment corrections and associated fees.
• Improved the existing reporting dashboards and the functionality of planning tools, reduced data processing time by 95%.
• Developed and maintained commission reporting dashboards using Tableau, providing clear visibility into commission payouts and performance for a team of 33 financial advisors.
• Analyzed commission data resulting in identifying and correcting errors, leading to a 99% accuracy rate in commission payouts to financial advisors.
• Collaborated with cross-functional teams to identify and implement process improvements resulting in a 25% increase in efficiency and a 30% reduction in errors.
Financial Data Analyst, 08/2019 10/2021
NATIONWIDE Troy, NY
• Enhanced financial reporting accuracy by gathering data from diverse sources and creating comprehensive financial statements, such as cash flow, P&L, and balance sheet, yielding a 99% error-free report.
• Conducted data analysis and preparation to ensure accurate financial reporting structure.
• Applied Data Mining techniques and advanced Microsoft Excel skills VLOOKUP, XLOOKUP, Countif, sorting, & filtering functions.
• Achieved customer satisfaction rating of 95% within three months, exceeding the company’s stretch target of 90%. Education and Training
12/2018 SUNY College At Oswego Oswego, NY
Bachelor of Science Business Administration
Certifications
• Data Visualization with Tableau Specialization
• Google Data Analytics Professional Certificate
Personal Projects
• Led and educated 23 team members with investment products, advice, and planning.
• Conducted extensive research on peer and competitor positioning and analyzed the evolving crypto landscape to provide valuable insights and recommendations.