Todd Tian | LinkedIn
, , Websites111connectionsJoin LinkedIn & access Todd's full profileJoin LinkedIn & access Todd's full profile. It's free!As a LinkedIn member, you'll join 300 million other professionals who are sharing connections, ideas, and opportunities.See who you know in commonGet introducedContact Todd directly111connectionsWord & Brown General AgencyConsultant/Business System AnalystAugust 2014 – Present
BackgroundProject management and Scrum Experiences in the following industries:
* IT Industry - software development, database analysis, TFS, HP Autonomy and ETL;
* E-commerce - Website homepage and shopping process design, ma
* Media & Entertainment - Youtube big data, E-
Technical Skills and Experience:
* Project Management in Waterfall & Agile/Scrum M
* Business Analysis with Heavy Requirement G
* Microsoft Softwares - Proficient in Excel, PowerPoint, Word, Visio and P
* Business System Analysis - Seamlessly Cooperate with Different D
* Database Management and Analysis with MySQL;
* Strong Decision Making Ability Based on the Deep Analysis of All Existing Data and the Logical Prediction of Future T
* Hands-on Experience on Programming Languages - JAVA, C++, HTML, XML, R, HP Autonomy, TFS;
* Data Modeling and ETL with T
* Statistical Data Analysis on Big Data from all sources such as MySQL Databases, Third-party data tools, and Website P
* Professional Business Reporting on Daily B
* Corporation System and Internal Tool A
* Process Integration and O
* Portfolio Investment and Risk Control for S
Personal Goals:
* Highly self-motivated, well organized and goal-orientated.
* Strong communication and interpersonal skills to lead team for challenging tasks.
* Effective at team working in an international environment with diverse.
* Outstanding fast learning skills and independent working ability enables me to quickly get used to all new systems and technology
* Excellent time management and scheduling allows me to successfully finish all tasks even under heavy pressure and tight time limit
* Strong passion to learn anything new in order to keep up with the latest trends and technologyExperienceConsultant/Business System Analyst• Performing as the Business System Analyst to capture business requirements and turn into User Stories to help the engineering team to digest, support team by acting as the liaison between business and the developers to enable efficient communication, and prepare future projects timeline to pre-fill working schedules to ensure no-gap between
• Performing as the assistant scrum role to prepare sprint retrospective document to summarize what the team accomplished in the past sprint and point out the disadvantages to improve, and lead the scrum meeting to ensure efficien
• Performing as the IT consultant to support different teams to complete projects in time with strong multi-tasking and effective tiSr. Business System Analyst for Corp Bus & Project Manager• Performed as senior business system analyst to become the bridge between development team and user to allow efficient resources allocation and cross-department communication, deeply understand the Agile methodology and proficient in preparing project requirements, leading team discussion, and problem solving to ensure the successful development, successfully working with more than eight groups and four huge departments to deliver the Crazy Egg project to greatly
sales by 240%
• Performed as Product Manager to identify, analyze and document business requirements, perform as the leadership role to know How, When and Why to plan and monitor project process, carefully implement risk management and budget planning to control the cost, provide support through all stages of application development lifecycle, organize effective meeting to motivate the team to successfully deliver several impressive improvements
websites which boost traffic by 300% and sales by 400%;
• Cross-trained at RMA and inventory control department to study the process of the complex RMA system in order to discover the system improvements, creatively proposed the integration tool to optimize and simplify the operations in order to greatly boost the processing speed by 40% and reduce the systematic error by 30% in just 3Marketing and Sales Manager & Marketing Director• Performed as E-commerce marketing director to be responsible for Amazon, Newegg and EBAY online sales operation and advertising campaign, taking the leadership of the team to efficiently promote Lepow Portable Charger products through social media and special events marketing, boosted sales performance and brand awareness by 400%
• Independently negotiated exclusive distributor contract with clients, responsible for inventory management, shipment scheduling, sales performance analysis and public relations, developed partnership with BestBuy, D&H and Verizon and greatly Business System Analyst for Big Data & Data ETL Programmer• Performed as business analyst to be responsible for marketplace analysis, management and Proficient in MYSQL and advanced Excel operations to considerably increase th cooperated with Ops (operators) to troubleshoot job issues and help on database maintenance
• Promoted as marketplace manager to support several “giants” in digital media industry (YouTube Data Analysis and financial clearance), such as MySpace, VEVO and Marker Studio
• Independently learnt the most popular open ETL tool - Talend and performed as data integrator to build complex modeling jobs and fix existing job based o combined with JAVA programming skills to greatly enhance the functionality of Talend programming
• Independently learnt modeling tool – Clearing Engine and performed as project modeling designer to propose efficient calculation methods and advanced job structure for Maker Studio and UMG
• Performed statistical data analysis on the Big Data of YouTube video traffic, contents, user behavior and revenue performance, and prepared daily, weekly and monthly detailed reports to support concise decision-
• Presented detailed project design with explicit viewpoints and clear stru kept in touch with clients closely to ensure prompt communication and product support
• Became a “bridge” between business rule and programming language as business system analyst role to coordinate engineering team and business analysis team to ensure the precise understanding of the job requests and the successful delivery of the products
• Suggested marketing ideas and plans for Ads provider based on deep data mining and marketplace analysis, implemented promotion activities and events effectively to increase the Ads-revenue by 30%
• Met tight job deadlines closely with strong motivation, and multi-tasked with efficient time managementSmall Business Owner & Website Builderwww.• Independently designed and built the on-line shopping website in order to expand the existing successful wholesale business from Los Anleges Downtown to the whole nation
• Efficiently managed inventory, promoted products through social network, and provided fast shipment deliveryData Analyst, Programmer and Tech Support• Create a smart online talking robot to help ESL students practice English (/robot/)
• Analyzed data statistically to identify the most frequently used words, phrases, and sentences, and uploaded into database with more than 80k vocabulary
• Independently learnt and quickly applied a new programming language, AIML, for scripting of the robot in one week
• Collaborated with team closely to update the database, and individually finished the programming part of the robot
• Diagnosed and resolved user problems immediately through emails and phones, provided great customer service experience and increased the number of users by 20% each month
• Met tight job deadlines closely with strong motivation, and multi-tasked in managing and maintaining website weekly basis
• Creatively and prospectively developed the HTML5 versions of the robot, significantly increased the user groups and user numbersData Analyst• Utilized search algorithms, text mining, data classification and statistical analysis to study how budget cut influenced the courses offered by University of California, Berkeley
• Compiled, organized, and managed large historical dataset of UCB class schedules encompassing year 2003 to 2009, with over 3000 courses and 149 departments
• Efficiently managed schedule to coordinate group meetings and individual working, assisted other group members to finish their parts of the project in time
• Analyzed the correlation of courses offered by different departments to determine strategies on how to use the limited educational recourses most efficiently, reduced the school expense by 15% in next semester
• Represented detailed plots and reports with explicit viewpoints and clear structure by power pointCertificationsScrumMasterCAPMVolunteer Experience & CausesCommunity Service LeaderOpportunities Todd is looking for:Joining a nonprofit boardSkills-based volunteering (pro bono consulting)Causes Todd cares about:Economic EmpowermentEducationScience and TechnologyProjectsETL Central for Digital Media Royalty Distribution of Maker Studio- Designed and implemented a data ETL central tool for Marker Studio to help calculate royalty distribution for their talents in di
- The tool pre-checked the raw data from YouTube, and marked all data contents and formation
then the tool will do initial data ETL to prepare the data for the the calculation process takes the calculation model from each contract and calculate the traffic info, revenue info and royalty results across video levels, channel level the tool then begin reporting process to generate business report through Excel and PDF; if any errors detected, the tool can allow easy quick auto-correction process
- The tool is designed to run on daily, weekly and monthly basis, once scheduled through server, the tool will run by itself smartly and shoot notification emails to user if
- The tool is also universal, which allow customization to apply to other revenue distribution reporting task based on diff
Team members:, , Pavan Reddyge, • Performed as the Scrum Master to manage and lead the Homepage Redesign UX project to greatly improve the user experience of the NewEggFlash On-line Store, carefully prepared documents and lead team meeting to closely monitor the progress of the project, effectively communicate between engineering team and marketing team to ensure smooth cross-dept cooperation to finish this important project in just 6 months with limited the successful launch of the new homepage greatly boost the daily traffic by 400% and daily sales by 200%; It is a smart online talking robot to help ESL students practice English online. I am the data analyst, programmer and tech support for this project. As data analyst, I need to analyzed data statistically to identify the most frequently used words, phrases, and sentences, and up As the only programmer in this project during the whole period, I first self-learnt a new language called AIML for scripting of t then, I am working on design the logic of this robot, and update the database and fix any user problems immediately. As the tech support, I need to diagnose and resolve user problems through emails and phones to keep users growing fast.Team members:, Ron Lee• Independently designed and built the on-line shopping website in order to expand the existing successful wholesale business from Los Anleges Downtown to the whole nation
• Efficiently managed inventory, promoted products through social network, and provided fast shipment delivery
Digital Media Royalties Distribution PlatformSaaS platform used by Marker Studio to automate royalties earned on digital ad subsidized networks (including YouTube).
Team members:, , , Courses Computing Data (STAT 133)Concepts of Probability (STAT 134)Linear Modelling (STAT 151B)Sampling Survey (STAT 152)Concept of Statistics (STAT 135)Stochastic Process (STAT 150)Econometric Analysis (ECON 141)Financial Economics (ECON 136)Econ Theory - Micro (ECON 101A)Econ Theory - Macro (Econ 101B)Intro to Analysis (MATH 104)Discrete Event Simulation (IND ENG 131)JAVA (CS 124)LanguagesEnglishNative or bilingual proficiencyMandarin,ChineseNative or bilingual proficiencySkillsSQLBusiness AnalysisData AnalysisMicrosoft OfficeAccessPowerPointE-commerceJavaIntegrationLeadershipMicrosoft SQL ServerMicrosoft ExcelProject ManagementExcelDrawingChinese cultureMarketingProduct MarketingSales ManagementInventory ManagementManagementProgrammingStatisticsAgile MethodologiesRMatlabC++iPhoneOnline AdvertisingAdvertisingSystems AnalysisMS ProjectMind MappingTalendSocial NetworkingData MiningTime ManagementStatistical ModelingData WarehousingETLEconomicsMySQLDatabasesProject PlanningSoftware DevelopmentJIRACertified Scrum Master...EducationBachelor of Arts (B.A.), , 3.82Activities and Societies:&Chinese Student Association, UC BerkelyBachelor of Science (B.S.), , 4.0Activities and Societies:&AGSHonors & AwardsAdditional Honors & AwardsPasadena City College:
Awards: Summa Cum Laude Honor of 2009 (Top 0.05%),
Superior Achievements in Economics and Mathematics
Scholarships: William Miller Scholarship of Mathematics for outstanding performance and creativity
View Todd's full profile to...See who you know in commonGet introducedContact Todd directlyNot the Todd Tian you're looking for?
People Also ViewedSr. Business Analyst / Project ManagerProduct ManagerCreative Director Manager, Platform Product Management Sr. Director of Business Planning Director of Product Management Director of Technology,
(Newegg Automotive Brand)
LinkedIn member directory: