Harshit Desai Email & Phone Number

Kirkland, Wa, Us

Seattle, Wa, Us

Seattle, Wa, Us

Created SQL queries to extract large and complex datasets to help build data science models and built dashboards to explain model output created by data scientists. Worked closely with Data engineering and PMs to launch new products/program initiatives and test acceptance criteriaBuilt dashboards, Page 0, reports and narratives for monthly/ quarterly business review. Created monthly leadership reports in Amazon Talent Management (TM) org. which provide a snapshot of business activities and key insights to leadership, help drive new initiatives and implement process improvements to core TM programsPerformed Gap analysis to identify issues faced by stakeholders and gathered new requirements to enhance Clarity (HR analytics tool)Conducted data deep dives related to Attrition, Performance Management, Talent Evaluation to generate actionable insights for TM Programs. Developed Employee Sentiment Tracker to sense employee sentiment across Amazon and other competitors

Seattle, Wa, Us

Provided analytical partnership to Global Startup BD team, for strategic startup customers representing close to 10% AWS revenueDeveloped automated scoring model using SQL and Tableau to filter, score and stack rank the most promising top 3000 startups out of >250k startup customers based on key variables like growth, valuation, funding, AWS spend, no. of investors etc.Collaborated with cross functional teams of BIEs, Sales managers/BDMs, Data Engineers and defined user needs, identified gaps and developed Hot startup Heatmap product in AWS Quicksight to enable strategic engagement with C suite and drive business strategies based on data driven tool which showed the health of 3k hot startup customers on 11 strategic parameters (ML services spend, cost optimization, revenue growth rate etc.) Worked with stakeholders to drive product enhancementsOwned Hot startup L plus adoption goal, part of top 15 AWS level goals (>$10,000 revenue per customer), developed data driven strategy for the BDMs to increase L plus adoption. Proactively identified and resolved strategic issues that impair meeting the goalIdentified close to 8K customers who were incorrectly mapped outside of Startup segment creating a business impact of ~$60M (based on 4 months YTD) for the segment and thereby enabling these customers to benefit from Startup segment programsDefined metrics, built SQL queries and developed multiple automated dashboard products in Tableau / AWS Quicksight enabling the business to track revenue trends, top gaining/declining customers, service usage trends, track new/launched/closed business opportunities etc. and thereby reducing reporting time by 40%

Boston, Ma, Us

Worked as strategy and analytics intern to develop Asia logistics network strategyIdentified 5 high potential locations for future warehouses and consolidation centers in Asia, through demand and cost analytics Extracted data using SQL and analyzed large data sets for 25 countries worldwide, related to supplier purchase orders, container shipment data, supplier/factory cluster locations, SKUs and product categoriesIdentified key metrics and created data visualizations and Tableau dashboards for General Manager of Asia LogisticsModeled various supply chain costs using advanced Excel for comparative analysis of various types of warehouses

Mumbai, Maharashtra, In

Tracked portfolio of 50-60 companies at Global Analytical Center leveraging business and financial analyticsAnalyzed business models, market drivers, operating efficiency, competitive intelligence, economic indicators to develop insightsDeveloped risk models and analyzed credit risk parameters, financial ratios and liquidityPerformed regression and time-series forecasting of financial metrics and prepared 5-year financial projections

Roseland, New Jersey, Us

Created forecast models to predict revenue for BUs constituting ~24% of company`s revenueAs analytical SME to 25 department heads, managed forecasting for Marketing and Sales Operations BU (annual budget of $120M)Designed monthly dashboards, performed variance analysis and presented business insights leading to 15% cost savings

Mumbai, Maharashtra, In

Tracked 20-25 companies, built time series and analytical models for forecasting business performancePrepared business intelligence reports including peer comparison tables, credit ratio charts and industry driversAnalyzed financial statements and developed reports with key sector trends, business drivers and performance of key players

Master Of Science - Ms, Business Analytics And Project Management

Master Of Business Administration (M.B.A.)- Gold Medalist, Finance & Marketing

Bachelor Of Engineering (B.E.), Electronics And Communications Engineering

Hsc, Science