Developer Sales

Mayank Vyas

************@*****.*** 510-***-**** www.linkedin.com/in/mayankvyas001

Summary

• 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 Technical Skills

• Business Intelligence: Tableau Desktop 2018.3, Tableau Server 2018.3

• Databases: Hadoop, Hive, Impala, AWS, Oracle 11g, SQL Server, MySQL

• Programming Languages: PL/SQL, Unix Shell Scripting

• Tools: Google Suite, Microsoft Suite, Toad, SQL Developer, Git, JIRA Projects

Senior BI Engineer/TPM (Omnichannel Team) Samsung, Mountain View, CA Apr. 2018 – Till Date

• 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 Environment: Cloudera Hadoop, Impala, Hive, Amazon Web Services, Tableau Desktop 2018.3, Tableau Server 2018.3

Senior BI Engineer / TPM (eCommerce Team) Samsung, Mountain View, CA Oct. 2016 – Apr. 2018

• 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

• Developed Data Quality Checks dashboards

Environment: Tableau Desktop 2018.3, Tableau Server 2018.3, Cloudera Hadoop, Impala, Hive, Amazon Web Services

BI Analyst VMWare Inc., Palo Alto, CA May 2015 – July 2016

• 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 manangement to understand bug resolution performance

• Analyzed project management data and developed dashboards to track the status of various projects Environment: Tableau Desktop 9, Tableau Server 9, Bugzilla, HPQC, Oracle 11g, My SQL, SQL Server BI Analyst Nestle Dreyer’s Ice-cream Inc., CA Jan 2013 – Apr. 2015

• Design the data model for dashboard and reporting needs

• Delivered analytics that span from complex, long-term deliverables to very quick-turn, reactive reporting insights to impact immediate decision making

• 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 Environment: Oracle 11g, SQL, Tableau Desktop 8.2, Tableau Server 8.2 ETL Developer Nestle Dreyer’s Ice-cream Inc., CA Jan 2012 – Dec 2012

• Analyzed the data requirement for data warehouse and prepared the design document

• Analyzed business requirements and business rules to convert them into technical tasks

• Write the ETL script using SQL, PL/SQL to bring sales data into Data Warehouse

• Tune and optimize queries using Explain Plan

Environment: Oracle 10g, SQL, PL/SQL, Oracle Reports Tech Lead /Sr. Developer Dreyer’s Grand Ice-cream Inc., CA Nov 2002 – Dec 2011

• Designed and developed a system to send sales, promotion and accounting data from Oracle and Oracle Financials to SAP

• 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 Environment: Oracle 10g, SQL, PL/SQL, Designer 10g, Developer 10g, TOAD, Appworx 5 Oracle Developer Sun Microsystems, CA Apr 2002 – Oct 2002

• Developed a system that will split the revenue data to different countries and sales persons.

• Design and development of major processing of revenue splitting at the back-end through Triggers, Stored Packages, Functions and Procedures using PL/SQL and SQL Environment: Oracle 9i, SQL, PL/SQL, Developer 6i (Forms, Reports), Toad Oracle Developer Language Line Services, CA Nov 2001 – Mar 2002

• Automated the billing project module

Environment: Oracle 8i, SQL, PL/SQL, Developer 6i (Forms, Reports), Toad Oracle Developer Sun Microsystems, CA Mar 2000 – Oct 2001

• Developed the collection system, which takes the input of Daily Collection and determines the To Do List for various collectors.

Environment: Oracle 8, SQL, PL/SQL

Oracle Developer Gujarat Narmada Valley Fertilizer Co., India Feb 1997- Jan 2000

• Developed sales and finance modules of GNFC

Environment: Oracle 7.3, SQL, PL/SQL, Developer 2000 (Forms 4.5, Reports Designer 3) Education And Certification

• M.S. Computer Science

• Oracle Certified Professional

• Attended training for Tableau Advanced and Fundamentals

Contact this candidate