Experience

World Wide Professional Solutions

• United States
• Construction
• 1 - 100 Employee

• Data Analyst (Project Control Coordinator)

  • Jun 2022 - Present

  Chandler, Arizona, United States

• Data Analyst (Program Integration Specialist)

  • May 2021 - Present

  Phoenix, Arizona, United States Contract at Intel, Chandler • Worked as a Data Analyst in Supply-chain department to track and optimise inventory and supply chain of Intel’s product. • Created self service interactive dashboard to understand supply chain & find key influencer for backlog and inventory using Tableau, SQL Server & Excel. • Used quantitative supply chain & customer data to understand customer behaviour, life cycle, preference to guide company to take more personalized data driven… Show more Contract at Intel, Chandler • Worked as a Data Analyst in Supply-chain department to track and optimise inventory and supply chain of Intel’s product. • Created self service interactive dashboard to understand supply chain & find key influencer for backlog and inventory using Tableau, SQL Server & Excel. • Used quantitative supply chain & customer data to understand customer behaviour, life cycle, preference to guide company to take more personalized data driven decisions. • Collabarated with data engineers to create data pipelines by traslating business KPIs/OKRs. Translated business logic into technical language & validated logic for data integrity & accuracy.



Coursesity

• India
• E-learning
• 1 - 100 Employee

• Business Data Analyst

  • Jan 2020 - Apr 2021

  Remote • Worked as a lead analyst for the sales & marketing department to optimize lead funnel for coursesity.com. • Worked on Google Analytics for lead segmentation and analysis to find the area of opportunity for coursesity. This initiative helped coursesity to reduce SEM spend & increase conversion rate by 5%. • Created multiple self-service interactive reports and dashboards using Tableau & Google Analytics for daily sales & operation tracking. • Analyzed and developed metrics about the… Show more • Worked as a lead analyst for the sales & marketing department to optimize lead funnel for coursesity.com. • Worked on Google Analytics for lead segmentation and analysis to find the area of opportunity for coursesity. This initiative helped coursesity to reduce SEM spend & increase conversion rate by 5%. • Created multiple self-service interactive reports and dashboards using Tableau & Google Analytics for daily sales & operation tracking. • Analyzed and developed metrics about the shopping pattern of the customer to predict the company’s sales to create multiple personalized campaigns for different segments. • Designed and scheduled actionable A/B testing for enhancing marketing campaigns performance-based design of experience(DOI) concept and provide recommendations through leveraging hypothesis tests (t-test & chi-square). • Generated multiple ad-hoc analysis by using SQL, pivot table, Excel to answer business questions, and present business insights to higher management. Show less



Singh Diamonds & Meghna Diamonds

• Data Analyst

  • Jun 2015 - Dec 2018

  Mumbai, Maharashtra, India • Worked as a data analyst in the sales & customer experience dept. to increase sales & Return on Investment (ROI). • Performed exploratory data analysis & customer segmentation to understand the purchasing behavior of the customer for targeted offers using CRM data. This helped company to engage loyal customers & increase repeat sales. • Worked with data engineers to build & maintain data warehouse for analytical use. Worked extensively on query optimization techniques to improve the… Show more • Worked as a data analyst in the sales & customer experience dept. to increase sales & Return on Investment (ROI). • Performed exploratory data analysis & customer segmentation to understand the purchasing behavior of the customer for targeted offers using CRM data. This helped company to engage loyal customers & increase repeat sales. • Worked with data engineers to build & maintain data warehouse for analytical use. Worked extensively on query optimization techniques to improve the efficiency of the query. • Built multiple sales dashboards using Excel, PowerPivot to track sales performance & discover sales opportunities. • Collaborated with multiple departments to gather different data points to understand customer behavior and recommend targeted sales opportunities to the business for higher lifetime value (LTV). Show less



SHAIRU GEMS DIAMONDS PRIVATE LIMITED

• India
• Retail Luxury Goods and Jewelry
• 1 - 100 Employee

• Software Developer

  • Jan 2015 - May 2015

  Surat, Gujarat, India Worked on the development of relational database designed & seamlessly integrated data from multiple sources & platform to create data warehouse infrastructure & generate customer insights. Assigned to a Task Allocation Project, Helped DBA to create database for the system using SQL server 2012. Helped developer team to design the system using PHP, HTML & Joomla.