Business Intelligence and Data Analyst, Salt Lake City, Utah
Nutraceutical
* Delivered data analysis and business intelligence projects using advanced features on Power BI, automated ETL pipelines on SQL
Server, and coded forecasting models in MS Excel and Python, leading to an increase of revenue by 10% in 1 year
* Led the distribution chain of over 100 customers by providing ad-hoc data plus on time in full analyses to ensure customer success
* Automated 70% of manual business operations, reduced internal data request wait time by 90%, and minimized major risks by 40%
* Analyzed shipping costs and convinced the company to change to another shipper resulting in over $1M in savings for the fiscal year
* Developed dashboards and directly reported to the CEO and the COO of the company over 80% of the times. This increased data
visibility resulting in effective communication between the senior leaders that drove the operational strategy across the company
* Leveraged analytic problem-solving skills in working with large disparate datasets to report portfolio operational metrics and
performance. This ensured stakeholder and management visibility into operations and key performance indicators
* Managed and analyzed weekly, monthly, and quarterly costs using the external data feed by partners like Amazon, FedEx, UPS, etc.,
* Built a predictive model in Python for ‘Customer’s next purchase day’ with an output accuracy of 84%. Developed dashboards using
DAX and Power Query on Power BI and communicated results to the sales and marketing teams for planning of future sales goals
* Acted as a liaison between the customers, operations, finance, and technology teams to ensure overall operational success
Business Intelligence Analyst, Phoenix, Arizona
Arizona State University
* Analyzed, classified, studied 6000 user comments on Reddit and developed a social media analytics perspective model through text
analytics using deep learning LSTM (Long Short-Term Memory) classifier
* Leveraged Keras library in Python for sentiment analysis to augment human interactions and achieved an accuracy score of 73%
* Amplified marketing impact and used Tableau to visualize data points and communicated results and key ideas to decision makers
Capstone Project - Data Scientist, Phoenix, Arizona
Arizona Lottery
* Improved the business sales by 15% by applying data modeling and machine learning methods in Python to predict delinquent lottery
retailer accounts for the sales & marketing team. Used SQL, Excel to integrate data from multiple sources
* Developed a predictive analytical model in Python to find the “Recency, Frequency, and Monetary (RFM) values” of customers
* Collaborated with multi-functional teams to facilitate new business models and communicated ideas to executives across the company
Analyst - Trainee, Bangalore, India
Aricent
* Designed SQL queries to extract data from the data warehouse to the MySQL cluster by ensuring 100% dataflow accuracy to clients
* Created data reports and provided recommendations for specific scenarios which reduced validation effort by 20%
