Data Analyst Sales

Hardil Trivedi

******.*******@*****.*** 469-***-**** www.linkedin.com/in/ht7781 Austin, Texas

EDUCATION

The University of Texas at Dallas Aug 2018 - May 2020

Master’s in Business Analytics

The Institute of Technology, Nirma University, Gujarat, India Aug 2014 - May 2018

Bachelor’s in Computer Science

SKILLS

Programming Language: C, Python, R, SQL, SAS, JavaScript, HTML, CSS, Visual Basic & Excel Macros

Data & Visualization Tools: Tableau, PowerBI, MS Excel (VLOOKUP, Pivot tables), MS SQL Server, SSIS, SSRS, Qlik sense

Other Tools: QuickBooks, HTML5, Zoho Analytics, ERP system and tools, JIRA, Alteryx

Certifications: Google Analytics AdWords/Video/text ads, Google Ads fundamentals

PROFESSIONAL EXPERIENCE

Supply Chain Data Analyst, Regali Inc, Richardson, Texas November 2020 – Current

Designed the Regali ERP system database structure using MS SQL Server and performed EDI integration to push invoices from Regali ERP system to QuickBooks.

Improved on-time delivery efficiency by 25% by developing dashboards using Excel and PowerBI to monitor status of open orders, live inventory feed from vendor warehouse and inventory residing in production warehouse

Analyzed the past sales data, buying trends and freight charges using Excel and PowerBI and developed an optimized low risk price models which serves the demand fluctuations for SLAs on new contracts

Analyzed the compliance of data sets for EDI integration between Regali, Amazon B2B and Vendor’s supplier base

Business Intelligence Developer, SanJose Systems, Austin, Texas July 2020 – November 2020

Developed highly customizable dashboards and paginated reports of financial (1.5 M) data using MS SQL server, SSRS and Power BI and provided a comprehensive range of ultra-modern visuals to high value clients

Implemented VBA Macro scripts for Excel to automate the data cleaning process and developed dashboards in Power BI (DAX, power query, MDX) and presented in weekly management meetings

Developed ad hoc reports, analyzed and identified trends and communicated findings to SME and managers

Data Science Intern, Intulize, Richardson, Texas Jan 2020 – May 2020

Performed RFM (Recency, Frequency, Monetary) analysis on B2B and B2C customers to create segmentations using Python to increase personalize communication, cross-selling opportunities, ROI and better customer retention rate

Analyzed a consumer panel of 15,000 hardware industry subscribers, defined by A/B testing and identified KPIs for customer acquisition, retention and loyalty

Built a customer scoring system using purchasing trends and navigated Stakeholders to invest $5M to get the best ROI

Data Analyst Intern, G.E.M. Tech, India Aug 2017 - May 2018

Designed web-scraping tool in Python to extract data and statistics from various E-commerce sources; summarized using Tableau to co-relate customer behavior

Helped to achieve $2M of seed investment by predicting revenue using ARIMA model for the consumer electronics market with 80% accuracy using Tableau, Python

Accelerated unique website visitors by 50% and sales by 20% by conducting and monitoring SEO campaigns on daily basis using tools like Google Analytics and performed A/B testing for promotions

Designed SSIS packages to export heterogeneous data from OLE DB Source, Excel and SQL Server to Data warehouse

ACADEMIC PROJECTS

Search Engine Optimization (Google Analytics): Conducted SEO campaign with little-likes.com for 3 month-long period and increased online sales by 25%; Analyzed customer behavior to predict bids for SEM

Used Car Price Prediction (SAS): Wrote scalable algorithms to clean used cars data of 500k and compared logistic regression, Decision Tree, Random forest, Neural networks to predict the target variable car price with 87% accuracy

Airbnb Price Prediction of New York (RStudio): Performed data transformation and exploration; Built predictive model using stepwise regression to estimate price with an accuracy of 86.7%; validated using k-fold cross validation

Contact this candidate