YI LI
*** ****** **. ********@*****.***
Campbell, CA95008 408-***-****
SUMMARY
Vast experienced in business data extracting, market metrics analysis, project coordination and management.
n
Proficient in SQL, HTML, CSS, JavaScript, Tableau, SSRS, ETL, SaaS, Excel, Visio, Access, Oracle11g etc.
n
A team player, multi-tasking for cross-functional teams, critical thinking, extremely detail and target oriented.
n
PROFESSIONAL EXPERIENCE
A startup company. San Jose, CA
Product Analyst and Project Lead (2014-2015)
Identified key business data metrics, performed market analysis and designed the UX website for new products.
n
Led a team of 3 and examined the market need, defined user preference and measured the market trends with
n
visualized data report on PPT and Excel pivot table. Designed dashboard and UI with HTML and CSS.
Built up business model with Human Mathematical Intuition Analysis (HMIA) and User Persona Hypothesis.
n
Presented Consequential Analysis Design (CAD) and modeling report, for stakeholders’ decision-making.
n
Conducted business analysis with Extraction, Transformation and Loading (ETL) and online analytical process
n
(OLAP). Defined scope with engineering and PM teams to ensure dimensions and metrics were incorporated.
Balanced customer demands and project priorities with multiple groups with large data analysis for consensus.
n
Manipulated, cleaned and processed data to analyze and predict market trends, using SQL, SaaS and Access etc.
n
Documented project findings using graphical presentations and stored the result as references for future projects.
n
MA LABORATORY INC. San Jose, CA
Amazon Business Specialist (2010-2013)
I was promoted after 9 months of work, managed Amazon e-Commerce team with $2,500,000/month revenue.
n
Used Data Stage ETL solution and integrated the core transaction processor with efficient system architecture.
n
Refined the online order system with “Cloud Talking” design, which reduced 30% waiting time on transactions.
n
Analyst on critical business functions, designed the business flow map with UX analysis, and proposed the UI
n
and UX design to IT and MIS teams, and translated the business need into technical data for technical teams.
Incidentally, I was asked to be the acting manager for 8months, and delivered outstanding work with teamwork.
n
Account Representative (2009-2010)
Achieved 180% of sales quota and was recognized as top new sales with outstanding customer service in 2009.
n
Executed 100+ customers’ orders on EDISOX, and generated an innovative “Buy without PO” business model,
n
which facilitated customers, credit team and PM team, and resulted in a significant revenue increase by 30%.
Deeply analyzed on client database, provided customized service to each customer, and built robust relationship.
n
SILICON IMAGE. Sunnyvale, CA
Business Database Designer (2008 – 2009 Grade ‘A’ Capstone Project)
Developed an “S-InSight” dashboard with OBIEE. Collaborated with a team of 5, examined on “As-is and To-be”
n
process flow, and upgraded the operating system which effectively reduced 18% cost and 25% processing time.
Designed the UI with user experience analysis, and generated the HTML interface with CSS.
n
Researched on user experience and market forecast on Pivot Table, and captured key matrix for best DB design.
n
Designed models for different business goals on OBIEE, and provided critical insights for stakeholder’s decision.
n
EDUCATION
MS, Santa Clara University, MSIS Information, California, 2009. Grade ‘A’ on Capstone Projects
BA, Wuhan University of Technology, Global Trading, Wuhan, China, 2005