Portfolio
Enjoy my Porfolio
As a business owner, I began leveraging automation to boost exposure and sales, and I found a growing interest in using data to solve real-world problems. That curiosity led me to enroll in a four-month data analytics boot camp with TripleTen, where I sharpened my ability to interpret and visualize data. Over the past five years, I’ve supported businesses and fellow entrepreneurs as a contract Data Analyst—helping them understand customer behavior to promote exposure and improve marketing strategies by making data-driven decisions. I enjoy learning new skills and invite you to take some time and enjoy the projects I've completed during my journey breaking into tech. Enjoy!CRM Systems Experience:
• Salesforce Sales Cloud and Marketing Cloud: Managed client interactions, tracked sales pipelines, and executed marketing campaigns.
• EPIC, NexGen, Maestro, XLCare: Maintained patient and client records, ensuring compliance with healthcare regulations.
• Odoo: Implemented and customized CRM solutions for personal e-commerce businesses, integrating automation to streamline operations.
Developer Tools: Zapier, App Automation and Intergration using API key generation to input and manage client data.
“If you can’t fly, run. if you can’t run, walk. If you can’t walk, crawl. But by all means, keep moving.”
Important skills I learned along the way:
Customer Interaction Reporting
Client Automation
Customer Relationship Management (CRM)
Data Exploration
Data Cleaning and Sorting
Automation and Integration Workflows
Webshop Creation and Design
Marketing Strategy Development
Pivot Tables
Data Visualization
Business Analytics & Key Performance Indicators (KPIs)
Entrepreneurship
Public Health Advocacy
Take a look at projects I’ve completed to show my skills along the way:
The Process Begins Here:
Business Analytics and Data Visualization Expertise
Advanced Excel Functions:
• Utilize VLOOKUP for efficient data retrieval across extensive spreadsheets.
• Apply aggregate functions to summarize data, providing a clear overview of key metrics.
• Employ splicing and sorting techniques to segment data effectively for detailed analysis.
Data Visualization:
• Create compelling visual representations of data to communicate findings clearly.
• Develop dashboards and reports that highlight trends, patterns, and insights, aiding in strategic decision-making.
Business Strategy Recommendations:
• Analyze data findings to provide actionable recommendations that drive business growth and efficiency.
• Collaborate with stakeholders to implement data-driven strategies, enhancing overall performance.
These visuals describe an project completed for Fresh Beats, an subscriber ran music streaming company that requested insights on user preferences and marketing strategies to improve conversion and promote exposure. Take a look at the complete project below:
Take on a pivot table created to describe an beauty salon’s break down of Expenses and Income in months June (6) and July (7) using this data set: K.Williams-Copy of Income and Expenses for BeautyPlus.pdf
The final recommendations and insights for marketing strategies for Fresh Beats:
EDI (Electronic Data Interchange) Automation
Vendor Integration: Implemented EDI to exchange order and shipping data directly with suppliers, cutting down email communication and manual entry.
Order Automation: Automated purchase order creation and confirmation using EDI, reducing delays and ensuring accuracy in high-volume transactions.
Shipping & Tracking Updates: Set up automated EDI communication with shipping carriers for real-time tracking updates and delivery confirmations.
Compliance: Ensured EDI compliance with vendor standards, reducing chargebacks and improving operational reliability.
Developer Tools: App Intergration and API Key Generation, Management of customer data information in regard to CRM for marketing, sales, inter-communication, and management purposes. Including: Zapier, Odoo CRM, Google One AI and Analytics, etc.
Technical Proficiencies We May Have Overlooked
Odoo Platform Integration
CRM & Sales Management: Used Odoo’s CRM module to track leads, manage customer interactions, and automate follow-ups, leading to improved customer retention and faster response times.
Inventory Automation: Integrated Odoo Inventory to monitor stock levels in real-time, automatically reordering popular hair and jewelry products to prevent stockouts.
Order Fulfillment: Streamlined order processing with Odoo’s Sales and Invoicing modules, reducing manual invoicing tasks and ensuring timely deliveries.
E-commerce Sync: Connected Odoo with my Shopify storefront to centralize product management and reporting across platforms.
Workflow Automation & Integration Management
Microsoft and Google Suites:
• Microsoft Office Suite:
• Excel: Advanced proficiency in data analysis and visualization tools.
• Word: Experienced in creating comprehensive reports and documentation.
• Outlook: Skilled in managing communications and scheduling.
Teams Meetings: Experienced and conducting communication through virtual platforms.
Google Workspace:
• Sheets: Competent in cloud-based data analysis and collaboration.
• Docs: Adept at producing and sharing professional documents.
• Gmail: Proficient in email communication and organization.
Core concepts of BACCM, the Business Analysis Core Concept Model:
Change, Need, Solution, Stakeholder, Value, and Context.
Communicate with stakeholders effectively while working on a brief.
Identify best mode of treatment or method including the best approach to resolve the communicated assignment to meet the needs of stakeholders.
Breaking a task into subtasks and handling the most common of them, such as exploratory analysis and data grouping.
Used pivot tables to answer specific business questions and communicate findings to stakeholders
Drawing conclusions and making recommendations based on data analysis
Prepare conclusions, visualizations and spreadsheets to be presented to stakeholders— using clear chart and spreadsheet formatting and documenting the work for future reference.
Share results of your work to produce impact and influence business decisions.
Data Cleaning and Transformation:
Proficient in cleaning and organizing large datasets to ensure accuracy and consistency.
Skilled in file conversions between formats such as Excel (.xlsx) and CSV (.csv) to facilitate seamless data integration.
Remove inconsistencies and duplications in data to prepare it for further analysis.
Used pivot tables to answer specific business questions and communicate findings to stakeholders
Inventory Analysis Conducted on LuxeJeweryCo: CSV Asset Value.pdf
