Cierra Smith

Hi! I’m a Business Intelligence Analyst + Admin of nearly 4 years who has had the pleasure of working with over 30 Etsy shop owners through various project management sprints and consults. I have a degree in Business Analytics as of December 2022, as well as accredited certifications in Business Analytics: Business Intelligence, Information Technology: IT Foundations, and Business Analytics: Marketing Analytics. Those programs of studies, as well as external work, have afforded me not just working knowledge, but up-to-date expertise in SQL Tableau, and Microsoft Excel, as well as limited knowledge in Python (particularly NumPy) and R. I've done a number of data analysis projects, including a large-scale analysis as a summer 2022 intern for Fortune Global 500 company, Accenture. I'm familiar with Agile methodologies, the Scrum framework, and Jira. I'm dedicated to high ethical standards, results-driven, self-motivated, communicative, and personable.

Skilled in PostgreSQL, Tableau, and Microsoft Excel. Proficient in Python, R, and Power BI. Etsy-specialized Business Intelligence Analyst with nearly 4 years of experience. Accenture Business Intelligence Analyst Intern for Summer 2022. Dedicated to high ethical standards. Results-driven, self-motivated, communicative, and personable

Experience 

Etsy Shop Admin/Business Intelligence Analyst Self-employed Contractor

Sep 2019 - Present (3 years 9 months) As an experienced Business Intelligence Analyst, my primary focus is to help Etsy shop owners achieve optimal visibility and market positioning through comprehensive data gap analyses, keyword and trend analyses, competitor and market analyses, and gathering and eliciting all necessary requirements to prepare Business Requirements Documents (BRDs). In addition, I have a proven track record of implementing effective SEO strategies that have helped my clients stand out in a highly competitive marketplace. My projects typically follow the scrum framework and are completed in two to four-week sprints with regular communication between myself and the client. I have worked with numerous Etsy shops, including GentlemenMade.com, LightStarDesigns, Unique Styles Asfoor, RememberedFondly.com, FunFamilyGiftShoppe, Fountains.com, LevelUpGamingShopCo, WhimsyWonderSeeds, GiGiHerbalApothecary, LaurelLodge, Notion TemplateGeek, BooksByWilson, MartinAGD, School of Greatness, and Brave Soul Blankets.

Etsy Shop Owner Etsy Jul 2019 - Present (3 years 11 months) $15.78k+ in revenue selling exclusively digital products to a micro-niche target audience 87.8k+ shop visits

Blogger Cultured Simplicity Dec 2019 - Mar 2023 (3 years 4 months) Manage all administration tasks including blog writing, social media marketing, SEO, and site speed optimization. Cierra Smith - page 1 Although continued through my Pinterest presence, I decided to let the actual blog part go in March 2023, after three years. 

Pinterest Content Creator Cultured Simplicity Jun 2022 - Jan 2023 (8 months) Cultured Simplicity is a blog and social presence all about simplifying a productive, balanced, and successful life for students and women. In the past 18 months, my Pinterest profile has received over 4.06 million impressions, 1.61 million engagements, and a total audience of 2.6 million-- with the majority of my growth occurring in the past 6 months, in which I was invited to an exclusive paid program directly by Pinterest. I'm in a hiatus period of sorts right now as I focus on other endeavors, but I anticipate creating more content at some point in the near future. 

Business Analyst Intern Accenture Jun 2022 - Aug 2022 (3 months) • Analyzed business processes, uncovered areas for improvement, and developed and implemented creative solutions that created value for clients • Collaborated with teams and clients to identify, collect, and analyze requirements to build innovative technology solutions • Supported data analysis and profiling, gathered business/technology requirements, created functional deliverables • Aided test teams and generated/executed test scenarios • Assisted with client interviews/workshops and built Excel models • Supported day-to-day activities and helped to identify and resolve user issues 

Excel with Dell Mentee Dell Technologies Jan 2022 - Apr 2022 (4 months) Content Writer | Editor The Triangle Trend Jun 2020 - Mar 2022 (1 year 10 months) Content writer for a start-up Media Company based in Raleigh, NC. I was tasked with consistent content ideation and wrote approximately 5 articles per week focused on local events, food, fitness, and fun. 

Content Leader Jul 2019 - May 2021 (1 year 11 months) Paid internship turned content creation position with growing Social Media company, Pingster. I created promotional social media content as well as blog articles, with total creative autonomy. Social Media Manager Brave Soul Incorporated Sep 2019 - Jun 2020 (10 months) Cierra Smith - page 2 Facebook and Instagram Content Writer and Pinterest Virtual Assistant for the nonprofit organization, Brave Soul Inc. Also known by its Etsy shop name, Brave Soul Blankets. I wrote all the descriptions/captions for Instagram and Facebook posts. I managed all aspects of the company's Pinterest account along with designing graphics in Canva and Adobe Photoshop and editing product photos using Adobe Lightroom. I created multiple mockups using the Adobe creative suite to showcase the shop's Etsy-based listings. I used Tailwind, a scheduling application, on a regular basis to ensure a steady flow of content. 

Intern Baldwin& Jun 2019 - Jun 2019 (1 month)

Wake Technical Community College Associates of Applied Sciences, Business Analytics, Information Technology 2019 - Dec 2022 

Licenses & Certifications Learning Excel 2016 - LinkedIn Excel Essential Training (Office 365) - LinkedIn Computer Science Principles: Digital Information - LinkedIn Advertising on Facebook - LinkedIn SAS® 9.4 Cert Prep: Part 01 SAS Programming Essentials - LinkedIn SAS® 9.4 Cert Prep: Part 02 Accessing Data - LinkedIn PostgreSQL Essential Training - LinkedIn Relational Databases Essential Training - LinkedIn SQL for Non-Programmers - LinkedIn Certification in Business Intelligence - Wake Technical Community College Cierra Smith - C25350B Certification in Business Analytics: Marketing Analytics - Wake Technical Community College C25350C National Career Readiness Certificate Platinum - ACT Joining Data in SQL - DataCamp Intermediate SQL - DataCamp Excel with Dell - Dell Technologies Data Manipulation in SQL - DataCamp PostgreSQL Summary Stats and Window Functions - DataCamp Functions for Manipulating Data in PostgreSQL - DataCamp Data Communication Concepts - DataCamp Data-Driven Decision Making in SQL - DataCamp Exploratory Data Analysis in SQL - DataCamp Microsoft Office Specialist: PowerPoint Associate (Office 2019) - Microsoft Data Analyst in SQL - DataCamp Pinterest Advertising Essentials - Pinterest Cierra Smith - Issued Feb 2023 - Expires Feb 2025 Data Analyst Associate - DataCamp Issued Feb 2023 - Expires Feb 2025 Applying SQL to Real World Problems - DataCamp Analyzing Business Data in SQL - DataCamp SQL for Business Analysts - Excel with Dell - Dell Technologies - Datacamp Analysis in Excel - DataCamp Introduction to relational databases in SQL