Tanvir S.

• Applied SQL commands like SELECT, FROM, WHERE, and ORDER BY to extract data from two tables.
• Utilized primary and secondary keys for table joins and developed ER diagrams to visualize established data flow processes.

• Applied Excel functions such as formulas, filters, and pivot tables to compute and report on metrics like gallon roll forwards, purchases, and fuel sales, resulting in the successful reconciliation of $73K in propane inventory.

• Utilized Power BI to generate pie charts, bar charts, and segment analysis, showcasing metrics like total sales per country, total units sold per product, and total discounts by segment. This facilitated trend analysis and provided insights into spending patterns.

• Utilized R Studio to generate 22 histogram views, evaluating correlations among factors such as overall price distribution, carat size versus price, and color versus price.
• Incorporated metrics such as mean calculations, for loops, and trend analysis to provide comprehensive insights.

• Utilized predictive analytics to forecast future company performance, utilizing linear regression to identify correlations between original and placebo pills. Results revealed a minimal impact on outcomes.
• Conducted multiple regression analysis to assess the relationship between GDP, education expenditure, employee compensation, and unemployment rates, revealing valuable insights into economic patterns and financial behaviors.
• Leveraged analytics to examine GDP and its potential… Show more

• Utilized predictive analytics to forecast future company performance, utilizing linear regression to identify correlations between original and placebo pills. Results revealed a minimal impact on outcomes.
• Conducted multiple regression analysis to assess the relationship between GDP, education expenditure, employee compensation, and unemployment rates, revealing valuable insights into economic patterns and financial behaviors.
• Leveraged analytics to examine GDP and its potential economic ramifications, aligning financial strategies with anticipated market trends. This proactive approach facilitated adjustments in business strategies, investments, and resource allocation. Show less

• Played a key role in a prescriptive analytics initiative that boosted revenue by $153K through enhanced techniques, alongside implementing a system that raised earnings to $431K from $218K.
• Delivered a comprehensive case study on Harrah's Cherokee Casino, analyzing revenue management tactics and loyalty programs, calculating metrics like customer lifetime value and return on investment.
• Investigated the efficacy of revenue optimization methods at the casino, including dynamic… Show more

• Played a key role in a prescriptive analytics initiative that boosted revenue by $153K through enhanced techniques, alongside implementing a system that raised earnings to $431K from $218K.
• Delivered a comprehensive case study on Harrah's Cherokee Casino, analyzing revenue management tactics and loyalty programs, calculating metrics like customer lifetime value and return on investment.
• Investigated the efficacy of revenue optimization methods at the casino, including dynamic pricing, yield management, and targeted promotions to maximize profitability.
• Executed revenue management strategies enabling precise customer segmentation at a casino, tailoring benefits to enhance retention among high-spending patrons.
• Designed a tiered reward structure featuring complimentary rooms and meals for customers spending over $1,000, fostering loyalty and driving revenue growth.
• Strategically managed limited availability by aligning incentives with customer spending patterns, reducing "no-shows" and boosting overall revenue. Show less