William Norfleet
Oneal
Alexandria,VA
Summary
Experienced analyst with a strong background in finance, commercial real estate, and the DOJ. Recognized for a collaborative approach and a track record of delivering results. Adaptable to changing needs and consistently performing at a high level. Committed to making data-driven decisions and providing actionable recommendations to achieve desired outcomes.
Overview
5
5
years of professional experience
2
2
Certificates
1
1
Language
Work History
Functional Analyst
Intellibridge/Accenture
08.2023 - 11.2024
- Observed four product releases to ensure documentation of all problems, fixes, and discoveries within the testing before full release.
- Successfully conducted User acceptance training to validate previous satisfaction from end users with the product.
- Developed comprehensive documentation for both technical and non-technical stakeholders, including a product roadmap.
- Handled and troubleshot SQL issues within Athena, identifying gaps and problem areas. Utilized stored procedures to shave down 2-3 minutes of time writing queries clearing redundancy.
- Effectively communicated complex technical information to diverse audiences through clear writing, concise presentations, and engaging discussions.
- Collaborated with cross-functional teams to manage project priorities effectively, balancing multiple tasks to achieve desired outcomes on time and within budget constraints.
- Bridged communication gaps between IT professionals and end-users by translating their unique needs into actionable technical specifications.
- Provided expert guidance to junior team members.
- Met with clients to understand business requirements, perform gap analysis and translate technical requirements.
Product Analyst
American Express
08.2022 - 06.2023
- Assisted in managing Annual/Iterative planning discussions on prioritizing initiatives by setting up over 15 technical readouts of said initiatives in an easy to consume format to advise presenters.
- Facilitated communication between technical and non-technical stakeholders, ensuring clear understanding of project requirements and expectations.
- Assisted in creation of update of daily refresh to shave the time down from over 1 hour to under 5 minutes.
- Responsible for daily Tableau & Airtable refresh which enables other business users to self-support their data needs.
- Created repository of reports in Tableau, Airtable, & Confluence to enable access to all LOB's with proper access.
- Documented end to end stakeholder & team meetings to ensure clarity and transparency.
- Devised data visualization dashboards of initiatives to make complex data more accessible to end users in order to self serve.
- Developed detailed product roadmaps, aligning team efforts towards achieving milestone goals and objectives.
Market Research Analyst
CoStar Group
03.2021 - 06.2022
- Gathered requirements to create ad hoc reports detailing annual construction records as well as daily, monthly, & quarterly exposure reports.
- Created marketing KPI's to determine overall outreach, profitability, and listing presence on the platform.
- Collaborated with the engineering team on the marketing data pipeline to ensure SQL code Is optimized for performance; using stored procedures that shaved 1.5 seconds from marketing CDX email campaigns used by brokers.
- Utilized SQL server to pull daily data queries and prepare reports on daily, weekly, monthly, and quarterly basis also shaved .78 seconds from personal query time using stored procedures.
- Utilized marketing data to drive business decisions for each brokerage by leveraging view count, unique visitors, and month to month views of listings which led to continued revenue growth.
- Performed benchmark reports on marketing exposure and correlation to sales for clients, created plans to increase exposure, and maintained revenue intake of over two billion dollars in verified transactions.
Fraud Analyst
Capital One
10.2019 - 04.2021
- Executed Ad hoc reporting to increase fraud detection in the southeastern region of the US.
- Created multiple dashboards in Excel documenting fraudulent transactions, high risk areas, & fraudulent transactions by purchase.
- Completed research, analysis, and documentation of account activity and worked with fraud victims to analyze transactions on their account to ascertain problematic merchants and recommended actions to remove or minimize BSA/fraud exposure.
- Completed time sensitive reports relating to BSA, including currency transaction reports and suspicious activity alerts to clear customer accounts and remove harmful transactions.
- Evaluated large sets of customer data to identify and prevent fraudulent activities.
- Reviewed reports and found over 35 individual transactions which appeared suspicious to uncover possible fraudulent activity.
Education
Bachelor of Science - Mass Communication
08.2016 - 05.2019
- 3.0 GPA
- Elected Captain of Rugby Team
- Professional Development: MyTechBestFriend(Bootcamp)
Skills
Reporting Analytics
ETL Development
Data Visualization
Microsoft suite
Requirements gathering
Databricks
Stakeholder management
Power BI
Data modeling
Tableau
Product roadmapping
SQL
Technical documentation
Athena
User acceptance testing
Certification
Certified Scrum Master
Timeline
Certified Scrum Master
08-2024
Certified Product Owner
08-2024
Functional Analyst - Intellibridge/Accenture
08.2023 - 11.2024
Product Analyst - American Express
08.2022 - 06.2023
Market Research Analyst - CoStar Group
03.2021 - 06.2022
Fraud Analyst - Capital One
10.2019 - 04.2021
Virginia Commonwealth University - Bachelor of Science, Mass Communication
08.2016 - 05.2019