Shivashish Bhardwaj

Implemented recruitment chatbot deployment using Rasa and openAI framework with data querying using MySQL and python. Created cash-flow financial model with time series analysis in machine learning.

Extracted, cleaned and prepared data using Python, Sql, Pyspark and MS Excel to help build marketing mix models that resulted in a lift of ROI. Analyzed data of monthly active users and used outputs to guide marketing and product strategies. Performed exploratory data analysis to identify relationships in enormous data and provided actionable insights to stakeholders. Designed predictive models using regression analysis, clustering, classification and other advanced statistical techniques to support business decision-making. Created custom dashboards using Tableau and Power BI to give real-time insights into company operations.

Assisted with the planning, tracking and coordination of the data migration team and with the migration run-book and the scope for each customer. Worked on the employee's database under HR department for managing basic enterprise functionalities. Worked on SQL optimization procedures and triggers. Worked closely on Oracle fusion HCM to maintain OTBI reports. Implemented Fusion HCM using PL/SQL to prepare reports for core HR, leave and absence. Wrote SQL Queries to obtain data from multiple tables to spool into CSV format and provide extracts to all company businesses and users. Contributed the development of multiple database projects and was involved in end-to-end process for one of the company’s biggest client with on time delivery and under budget completion.

Designed, managed and facilitated business programs for the firm. Provided reports regard how customer is using the company's website, over visualization tools like Power BI and Tableau. Analyzed company's monthly and yearly sales to develop five-year monthly projections by revenue and customer type. Have automated some manual processes via Excel Macros and standardized reporting templates, resulting in efficient data collection and a reduction in total turnaround time. Authored business requirements document for proprietary software application, solution assessment and validation.