Andy Liu

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. Skills: Technical Proficiencies: Python, HTML, CSS, JavaScript, SQL, Excel, PowerPoint, Tableau, Power BI. Web Development: A-Z expertise in WordPress, Shopify, SEO, and social media marketing (Instagram, TikTok, Facebook, Google Ads). Analytical Competencies: Skilled in predictive modeling, statistical analysis, data scraping/cleaning, dashboard creation, data-driven decision-making. Soft Skills & Attributes: Strategic Thinking: Skilled in identifying market opportunities and conducting trend analysis, complemented by a strong aptitude for rapid learning and self-motivation. Problem-Solving: Analytical Troubleshooting, Creative Solutions Communication: Articulating Complex Data Insights, Client Presentations oLeadership: Team Collaboration, Mentorship, Efficient in filing your taxes. Some examples of my data-driven results and accomplishments includes: 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. Oversaw the preparation and analysis of internal operations data, including customer acquisition, customer support, vendor management, order fulfillment, website development, marketing photos, and outsourcing. 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. 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. 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. I'm very approachable and genuinely enjoy meeting new people. Feel free to connect with me at here on LinkedIn!

Work History

Ecommerce Owner | Empowering Brands with Data-Driven Insights

BD2SDeveloped 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 AcademyFeb 2023 - Sep 2023 • 8 mosSelective 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 OneApr 2017 - Jul 2019 • 2 yrs 4 mosConsistently 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

CitiMar 2016 - Apr 2017 • 1 yr 2 mosAs 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

TargetContract EmployeeSep 2024 - Apr 2024 • 8 mosEfficiency 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 Academy

Certificate in Data Analytics

Brooklyn College

Bachelor's degree, Accounting and Business/Management2011 - 2015

Similar Pangeans

How Pangea Works

Effortlessly discover top talent

We've distilled the candidate search from endless hours down to just a few minutes. Using Pangea's AI-powered search tools, you can find top fractional talent able to take on your next project. Our system looks at your company's niche and your needs to find the perfect match faster than any traditional hiring platform.

Start working with talent today

The top talent on Pangea is ready to get started with you right now. You can message or hire a candidate right from their profile page and start assigning work as soon as they respond. And the best part? Pangea's fractional contract structure lets you start small and ramp up as your needs change, keeping your costs manageable and your team's capabliities flexible.

Track work and invoices in one place

Assign tasks, track progress, and complete invoices all on Pangea. We've combined every part of the hiring process into one platform to eliminate the miscommunication that's unavoidable on other freelance platforms. We even send out 1099s to your contractors at the end of the year!