Andy Liu

About

With a background rooted in the e-commerce sector, I bring valuable experience in managing and operating e-commerce websites while leveraging data-driven insights to optimize performance. I have successfully conceptualized and executed data-driven marketing campaigns for my e-commerce business, leveraging analytics and insights to consistently generate over 1000% ROI. <br><br>Skills:<br><br> Technical Proficiencies: Python, HTML, CSS, JavaScript, SQL, Excel, PowerPoint, Tableau, Power BI.<br> Web Development: A-Z expertise in WordPress, Shopify, SEO, and social media marketing (Instagram, TikTok, Facebook, Google Ads).<br> Analytical Competencies: Skilled in predictive modeling, statistical analysis, data scraping/cleaning, dashboard creation, data-driven decision-making.<br> Soft Skills & Attributes:<br> Strategic Thinking: Skilled in identifying market opportunities and conducting trend analysis, complemented by a strong aptitude for rapid learning and self-motivation.<br> Problem-Solving: Analytical Troubleshooting, Creative Solutions<br> Communication: Articulating Complex Data Insights, Client Presentations<br>oLeadership: Team Collaboration, Mentorship, Efficient in filing your taxes.<br><br><br>Some examples of my data-driven results and accomplishments includes: <br><br>Pioneered the implementation of advanced data analysis techniques, optimizing Google, Facebook, Instagram, TikTok, and other advertising platforms. Through this approach, I increased client retention by 300% and achieved 1000% ROI.<br><br>Oversaw the preparation and analysis of internal operations data, including customer acquisition, customer support, vendor management, order fulfillment, website development, marketing photos, and outsourcing. <br><br>Developed multiple online e-commerce websites using WordPress, Shopify, and coding techniques, resulting in consistent 1000% ROI. Through self-learning in website creation and brand marketing, I utilized data analysis to inform decisions and drive profitable growth.<br><br>Outside of the data realm, I find immense joy in maintaining an active lifestyle by going on hikes and going to the gym. The discipline and dedication I bring to my workouts also translate into my approach to data analysis, as I continuously strive for precision, accuracy, and excellence.<br><br>I get excited about opportunities where I'm able to leverage big data to drive strategic decision and identify patterns that have real world impact. <br>I'm very approachable and genuinely enjoy meeting new people. Feel free to connect with me at here on LinkedIn!

Experience

• Ecommerce Owner | Empowering Brands with Data-Driven Insights · BD2S01-01-2020

  Developed multiple online brands using WordPress, Shopify, and coding, resulting in over 1000% ROI within one year, leveraging self-taught website creation and brand marketing expertise. Constructed highly effective marketing models, leading to a remarkable 300% increase in client retention, achieved by optimizing Google, Facebook, Instagram, and other ads. Successfully led and managed teams of experienced contractors, ensuring timely and budget-compliant completion of high-ticket projects. Mentored and recruited contractors, sharing best practices to drive exceptional client satisfaction, resulting in 1000+ 5-star reviews. Oversaw various internal operations, including customer acquisition, customer support, vendor management, order fulfillment, website development, marketing photos, outsourcing, and more.

• Data Analyst Apprentice · Fullstack Academy02-01-2023 – 09-01-2023

  Selective Enrollment and Recognition: Selected from a highly competitive pool (with a 5% Acceptance rate), for NYC Tech Talent Pipeline sponsorship, recognizing data analytics potential. Completed over 900 hours in a rigorous data analytics program, mastering tools like Excel, PowerPoint, Spark, Azure ML, SQL, Python, Tableau, and AWS. Project-Driven Learning & Certification: Developed real-world data analytics skills through weekly projects, culminating in Tableau and AWS Data Analytics certifications.

• Head Teller · Capital One04-01-2017 – 07-01-2019

  Consistently achieved the top sales performer status in checking & saving accounts, loans, and lines of credit, resulting in a continuous increase in branch sales numbers month after month. Ensured exceptional client satisfaction and loyalty, garnering 5-star weekly survey reviews by consistently exceeding client expectations and going above and beyond to meet their financial needs. Pioneered a remarkable 50% increase in branch partner sales opportunities by skillfully vetting potential clients and referring them to the appropriate branch associates, effectively expanding the customer base and revenue streams. Maintained impeccable precision in balancing cash drawers, bank vault, and wire transfers, handling daily transactions of over $150,000, utilizing both manual counting and advanced machine-driven approaches to ensure accuracy and security. Demonstrated leadership and commitment to the growth of the team by providing comprehensive training and mentorship to junior banking staff, fostering a culture of continuous learning, and readily addressing any inquiries.

• Teller · Citi03-01-2016 – 04-01-2017

  As a Teller at Citi, likely contributed to daily banking operations by assisting customers with transactions, maintaining cash drawer accuracy, and providing excellent customer service.

• Logistic Analyst · Target09-01-2024 – 04-01-2024

  Efficiency Transformation & Metrics Design: Engineered and deployed innovative solutions and metrics, achieving a 20% uplift in supply chain efficiencyanda15% cost reductionthroughstrategicKPIs. Data Analytics Excellence: Spearheaded comprehensive data analyses with R, Python, and SQL, unraveling inefficiencies and strategic initiatives that resultedina25% improvementinlogisticsoperations. Operational Improvement & Business Evolution: Drove continuous improvement projects based on detailed data insights, contributing to a 30% enhancement in operational productivity and a 20% growth in business agility.

Education

• Fullstack AcademyCertificate in Data Analytics
• Brooklyn CollegeBachelor's degree, Accounting and Business/Management

Similar talent on Pangea

Sreeja K.Experienced Marketing Analyst and Data Scientist with Expertise in Data Analytics and Machine LearningSarah S.Data Analyst | Driving Data-Driven Decisions |Colorado Springs, COJudith V.Data Analyst | Business Intelligence Strategist | Driving Growth with Data-Driven Decisions | Power BI | SQL | Python | Empowering African Businesses with InsightsNairobi, KenyaBen V.Experienced Strategy, Analytics & Data Science LeaderWashington, DC