SUMMARY:

• Analyst with 5+ years of experience in analyzing data and generating reports, building complex queries with SQL and creating dashboards & visualizations in Tableau.
• Completed 400+ hours curriculum for hands - on projects in data engineering with Python at Springboard School of Data in 2021. Seeking an opportunity in data engineering field.

TECHNICAL SKILLS:

Programming/Scripting: SQL, Python, Bash

Data Visualization: Tableau, Google Dashboards, Matplotlib

Database, Big Data and Stream: MySQL, MS SQL Server, Hadoop, MapReduce, Kafka

Cloud: AWS Certified Cloud Practitioner, AWS Certified Data Analytics

Work Scheduling: Google PLX Workflows, Airflow

Tools: Git, Erwin Data Modeler, Microsoft Office, Google Sheets, Google Slides

PROFESSIONAL EXPERIENCE:

Data Engineer

Confidential, Menlo Park, CA

Responsibilities:

• Created six dashboards to provide insights for internal stakeholders on Unidash dashboarding tool
• Created a config file for an Instagram team to be able to submit their queries automatically on internal experiment tool
• Submitted a code change using VS Code - Dataswarm to customize anomaly alert settings based on data science team’s needs

Data Analyst

Confidential, San Bruno, CA

Responsibilities:

• Scheduling and managing daily auto runs of SQL queries on PLX Workflows to keep Google dashboard tables updated
• Creating and maintaining Google dashboards to monitor the partner analytics report feeds by using derived tables
• Communicating with engineering team about expected/unexpected changes detected on the dashboards for Confidential Music partner analytics report feeds
• Contributing to bug fixing efforts on SQL data pipelines by commenting on Buganizer and/or deploying and testing changes by customizing SQL files and test files
• Setting up and maintaining anomaly alerts on Corso to automate detecting unexpected patterns on data pipelines by using Cider code change list interface and Shell command line for config creation and testing
• Performing root cause analysis on Corso anomaly alerts and resolving anomaly bugs with comments for interested internal stakeholders in Confidential Music Data Warehouse

Data Analyst

Confidential, Santa Clara, CA

Responsibilities:

• Pulled and wrangled tweet data with customized SQL queries from MongoDB database utilizing NoSQLBooster to contribute to data preparation processes for data science team
• Developed and improved KPIs using Tableau enabling the editor team leader to track and manage the performance of tweet editors
• Supported app development team with new app features by extracting meaningful ideas from tweet data via exploratory analyses leveraging Python and Tableau
• Visualized and highlighted tweet data on Tableau, assists pursuing data continuity and integrity, increasing data quality and inspiring new app features

Data Analyst

Confidential

Responsibilities:

• Worked on Google Analytics data of e-commerce websites to prepare 270+ web/product analytics reports; enabled clients to improve their website contents and product specs.
• Managed 10+ small to mid-size companies’ e-commerce website migrations by executing data migration with product images leveraging SQL, Excel and FileZilla FTP connector
• Helped and trained e-commerce website admins to fully utilize admin panel, mainly for product category management, stock management and new product creation
• Analyzed social media statistics derived from Buffer platform and created 200+ weekly social media interaction reports improving clients’ account management
• Conducted 50+ A/B tests by using Optimizely and e-commerce website built-in tools to assess the effects of new web designs and campaign settings on conversion rates
• Analyzed orders by working on purchase data using Tableau helping clients improve their customer loyalty
• Blended Google Analytics data with purchase data in Tableau for further web analytics allowing clients to improve their conversion rates

Associate Recruiter

Confidential

Responsibilities:

• Created and updated candidate pool by pulling information from internal and external job platforms to increase efficiency of location-based hiring process
• Conducted phone interviews to filter the candidates in the current pool based on job requirements and candidate competencies to save time and resources during the interview process
• Planned and executed interviews by orchestrating competency exams and face-to-face interviews locally
• Managed post-hire process by informing candidates and gathering required information and documents to convey them to payroll department

Office Worker

Confidential

Responsibilities:

• Helped with 10+ trade show/fair and event planning, creating or updating presentation files, monitoring budgets and expenses, as well as some client interactions
• Assisted for sales and account team members with projects to create and maintain a high-profit margin customer portfolio
• Assists unit management with clerical duties related to payroll, accounting, receiving, and/or human resources including filing, data entry, record review and maintenance

Marketing Specialist

Confidential

Responsibilities:

• Curated relationships with 20+ local companies/institutions such as TVs and radio stations to enlarge potential customer base, resulting in nearly 10% increase in sales
• Worked in the termination process to save 15+ commercial clients from terminating high tech equipment service agreements which were approximately 6% of the service revenue sources