# Mayank Vyas > Principal BI Engineer Location: Fremont, California, United States Profile: https://flows.cv/mayankvyas • Over 15 years of IT experience in Business Intelligence, Datawarehouse and other environments • Comprehensive experience in designing and delivering analytical solutions • Extensive experience in data analysis • Expert in developing Business Intelligence dashboards using Tableau • Expert in writing ANSI SQL and SQL Tuning • Excellent communication and interpersonal skills ## Work Experience ### Principal Busines Intelligence Engineer @ Upgrade, Inc. Jan 2021 – Present | San Francisco Bay Area • Owned the end-to-end analytics architecture powering executive, finance, marketing, and risk decision-making across the lending business, serving as the single point of accountability for metric correctness and availability. • Partnered directly with VPs and Directors to translate growth, credit, and financial strategy into production analytics, enabling leadership to make weekly and quarterly decisions using a shared, trusted metrics framework. • Designed and scaled a cloud-native analytics platform (Redshift, Airflow, Tableau) supporting 100+ stakeholders, handling loan-, transaction-, and funnel-level data at hundreds of millions to billions of records. • Built executive-level dashboards used in weekly leadership reviews and board-level discussions, providing real-time visibility into approvals, funded loans, revenue, and portfolio health. • Implemented incremental ETL pipelines with automated data quality checks and SLAs, improving data freshness from T+1 to near real-time for core lending and growth KPIs. • Partnered with marketing and growth teams to deliver end-to-end funnel analytics from application through funding, improving visibility into approval drop-offs and funded conversion rates. • Optimized Redshift data models and query patterns, reducing dashboard latency by 40–60% and controlling warehouse costs as data volumes scaled. • Leveraged GenAI tools (Augment, Claude) to accelerate SQL, Python, and data-pipeline development, improving development velocity, code quality, and design iteration speed. • Enabled true self-service analytics for operators and PMs by standardizing SQL patterns, documentation, and dashboard conventions, reducing ad-hoc analytics requests by ~35%. • Mentored BI engineers, established analytics best practices, and played a key role in hiring and onboarding analytics talent as the company scaled. ### Senior BI Engineer @ Google via NTT Jan 2021 – Jan 2021 | Mountain View, California, United States • Developed a Vendor Vaccination Portal to evaluate the “Return To Office” Readiness • Designed End-to-end solution to relocate vendors from Google Owned Offices to other locations that helped in cost cutting • Developed a system for Risk Assessment solution to assess risk of various TVCs ### Senior BI Engineer @ Samsung Electronics America Jan 2016 – Jan 2020 | Mountain View, California, United States • Worked collaboratively with business partners and different IT departments to provide integrated solutions • Analyzed finance data to develop DSO mechanism to assess the digital revenue performance which enabled stakeholders to get consolidated data for all accounts • Developed process to generate Samsung Stores KPIs that allowed Retail team to understand Store performances across a range of metrics • Provided solutions to track NCME performance across various channels which allowed retail team to assess digital revenue and unit POS performance across SEA’s mobile division by account, product and channel • Designed a system to track digital HHP performance across various channels that enabled Mobile and Retail Teams to track Mobile Business Performance quickly • Worked on Big Data team to provide BI Solutions to support Samsung eCommerce business • Interacted with business users and stakeholders from requirement analysis and designing till go live • Developed process to reconcile data between Finance and eCommerce using dashboards which allowed users to find out the gaps in the data • Designed Weekly Business Review Process using traffic, sales and supply chain data that enabled top leadership to understand business performance on a timely basis • Provided Profit & Loss Statements using BI dashboards which allowed Finance team to quickly evaluate eCommerce performance on a regular interval • Performed Tableau Server Administration responsibilities like User Management Analyzed data from several data sources and developed complex data scripts ### BI Analyst @ VMware Jan 2015 – Jan 2016 | Palo Alto, CA • Worked in Project Management and QA Teams to provide analytical solutions • Developed complex and predictive dashboards from Bugzilla to analyze the bugs data, to show the bugs for a given project by priority, severity, or to show how it is distributed by components which enabled top management to understand bug resolution performance • Analyzed project management data and developed dashboards to track the status of various projects ### Business Intelligence Analyst @ Nestle Dreyer’s Ice-cream Inc Jan 2012 – Jan 2015 | California • Designed the data model for dashboard and reporting needs • Designed a process to predict demand of various products at various times using dashboard which helped the company in meeting the demands of various items in a company • Developed dashboard to show weekly sales measures against various metrics • Developed dashboard to show weekly actual sales of various products Vs Forecast ### ETL Developer /Reports Developer @ Nestlé Jan 2011 – Jan 2011 | Oakland, CA ### Senior Developer @ Nestlé Jan 2010 – Jan 2010 | Oakland, CA • Developed Invoice Processing System that will load the data into the system from various sources, validate the same and export the data into Oracle Financial systems • Developed automated ordering system that will generate orders based on variables ### Senior Developer @ Dreyer's Grand Ice Cream Jan 2002 – Jan 2010 | Oakland, California ### Database Developer @ Sun Microsystems Jan 2002 – Jan 2002 ### Oracle Developer @ Language Line Services Jan 2001 – Jan 2002 ### Sun Microsystems @ Sun Microsystems Jan 2000 – Jan 2001 | fremont, california ### Systems Analyst @ CMC Ltd Jan 1997 – Jan 2000 ## Education ### Master of Computer Applications (M.C.A.) in Computer Software Engineering Dharmsinh Desai University ### Bachelor of Commerce (B.Com.) in Advanced Accounting and Auditing, Leadership and Management Gujarat University ## Contact & Social - LinkedIn: https://linkedin.com/in/mayankvyas001 --- Source: https://flows.cv/mayankvyas JSON Resume: https://flows.cv/mayankvyas/resume.json Last updated: 2026-04-12