Data Analyst

Sim Neyzi

Analyst

Mountain View, CA

********@*****.*** - 408-***-****

Authorized to work in the US for any employer

WORK EXPERIENCE

Business Intelligence Analyst

Google/Cognizant - Mountain View, CA - 2016-12 - Present

●Analyzing ~10k lines of evals weekly, identifying metrics that reveal accuracy of data sets using advanced Excel functions such as pivot tables, vlookup and sumproduct

● Improved efficiency by %75 and increased deadline accuracy by developing Javascript code that generates timestamps to track daily productivity of 15 operators

● Automated data collection and reporting processes by developing SQL queries (join,nested etc.) and volatile tables, as well as using Excel scripts

● Calculating operators’ error rate (KPI) by cross referencing their output against QC

● Preparing weekly, monthly, quarterly business review presentations that point out issues and give general insights on operations during meetings with management Transportation Billing Specialist

Walmart eCommerce - San Bruno, CA - 2016-06 - 2016-12

●Saved company 1.5M annually by developing Marketplace transportation cost allocation model in Excel using

lookup functions, conditional functions and array formulas

● Compiled and formatted raw data using Excel data tools and pivot table, created dashboards that visualize revenue, cost and profit

● Ensured transportation compliance of 3,000+ walmart.com vendors with electronic data interchange requirements and worked with them on improving data quality

● Developed new SQL and PL/SQL queries to pull relevant data from Teradata and Synapse databases in order

to be used in forecast analysis and reports

● Analyzed 10M lines of billing data weekly, finding discrepancies, interpreting causes and resolving the issues Maps Data Analyst

Apple Inc/NetPolarity - Sunnyvale, CA - 2015-03 - 2016-02

●Resolved 600+ issues by doing online research to validate data provided by vendors/users and evaluating the accuracy of listed Point of Interest (POI) data on Maps based on policy guidelines

● Created 1500+ POI listings on Maps, precisely placing pin-markers and set entry points per geocode data to provide an excellent service experience to millions of Apple Maps users

● Led a new project for POIs located inside airports, created policy, added use cases and defined an efficient workflow for other data analysts

● Guided over 15 team members on existing policies, procedures and best data validation practices

● Collaborated with other software engineers on internal web-app for inputting geocodes EDUCATION

Certificate in Marketing Management

University of California Santa Cruz Extension - Santa Clara, CA 2014-04 - 2014-12

BS in Economics

Yildiz Tehcnical Univeristy - Istanbul

2008-09 - 2012-06

SKILLS

SQL, Excel, VBA, Javascript, Pivot Tables, VLOOKUP, Python, Team Leader, Presentation Design, Data Analysis, Analytics

Contact this candidate