Business Analyst

YASHI TIWARI

San Francisco, CA adxxoc@r.postjobfree.com +1-415-***-**** LinkedIn Dashboarding GitHub Big-4 experience at Deloitte as a Consultant for 2 years with Master’s in Business Analytics, worked on client facing company- wide projects to provide operational strategies. Professional expertise in communicating business insights with dashboards to stakeholders and project owners. Recently worked on a business analytics venture for a media company for user retention program. Skills

Technical: Python, R, Tableau, Power BI, RDBMS, SQL, NoSQL, Spark, AWS, GitHub, Google Sheets, Looker Industrial: Data Analysis, MS Excel/Power Point, Google Suite, Data Visualization, Machine Learning, Time Series Analysis Practicum Analytics Experience - Kqed, San Francisco, USA Sep’22-Jun’23 Project Manager and Business Analyst

As part of MSBA, managed team of 6 and solved client’s user retention issue for a media company with 1.15M+ donors.

• Build business schema for different data sources and manage deliverables and technical requirements for 3 parallel tracks.

• Cleaned, integrated, manipulated, and analyzed large datasets to draw trends in the data using SQL. Further empowered the results by forecasting users’ revenue for the next 3 years using machine learning algorithms like RF, XGBoost and SMOTE.

• Assessed and refined the existing prediction models, improving the accuracy from 78% to 85% and identifying true positives with 90% precision.

• Designed revenue-enhancement strategies and recommendation for resource allocation based on research and analytical approaches, to align project deliverables with the compliance.

• Communicated findings with Tableau dashboard to and discussed business insights to increase user retention and fundraising. Professional Experience – Deloitte, India Dec’20-Jul’22 Consultant (Risk Analysis)

• Analytics Expertise: Delivered strategic remediation plans for a US-based company of market valuation worth $28 billion and performed risk assessments for a $2.4M revenue business unit, prevented financial loss due to business failures.

• Supervised compliance analytics team working on Robotic Process Automation (RPA) automated business process to ensure quality results, resulted in reduction of turnaround time by 15% and 25% reduction in incidents.

• Independently lead risk analysis for 5 large application datasets, communicated root cause analysis with technical and non- technical members and tracked implementation of remediation plans, testing led to reduction of risk incidents by 72%.

• Initiated the development of VBA macros script for data analysis to quickly prepare the data to streamline the process, reduced the 8 hours of manual work to few seconds and prevented chances of manual error.

• Experience in creation of test plans, running tests and validation in UAT environment and releasing it to production environment

• Cross-collaboration arena: Collaborated with business owners, analytics, and compliance teams, assisted in requirements gathering and proposal development, lead to increment of the project budget by 20% and tenure with the vendor for 3 years.

• Worked with business owners to define key performance indicator (KPIs) and identify benchmarks to evaluate performance.

• Dashboarding: Provided detailed business insights, and actionable strategies with short- and long-term remediation plans, on monthly Power BI dashboards to stakeholders including compliance team, project leads and business owners.

• Trained new employees on report drafting and data visualization dashboarding adhering to industry standards.

• Brainstorming inputs: Provided business knowledge and leverage insights for business requirements development with focus on industry best practices standards and encouraging the adoption of data tools for better decision making.

• Documentation: Handled SOP documentation and workpaper development in MS Excel and maintained client’s documentation tool for reports to enable enhancements in future as per the client’s best practices. Intern (Risk Advisory)

• Assisted in audit for the second largest private airport operator in the world and identified gaps in policies and IT infrastructure and maintain minutes of meetings (MOMs) for the scrum team and followed up with client’s team for action items.

• Creating ad-hoc and regular reports based on client's requirements and assisting in monthly business review presentations. Analytics Projects

• Warehouse and cost linear optimization: Performed optimization using linear programming for online retail stores of amazon supply chain to deduce costs, profits, and no. of warehouses to operate to meet demand effectively.

• Custom Chatbot using NLP: Developed an end-to-end custom chat in Spark and python, using TensorFlow library for BERT

(NLP), ability to understand and respond intelligently and seamless integration for enhanced user experience.

• Sentimental Analysis: Performed sentimental analysis on Yelp user reviews dataset, using machine learning techniques, such as LR, SVM, RF. Word vectorization to analyze reviews’ sentiment using word2vec, TD-IF, n_gram on google cloud.

• Product Branding Analytics: By analysing sales data for Nike and Adidas shoes, uncovered insights into consumer behavior and the efficacy of various branding strategies. Derived findings to optimize brand positioning, enhance brand equity, and quantify the impact of branding strategies on customer perception and loyalty. Education

MS in Business Analytics University of California Davis, San Francisco, USA Aug’22- Jun’23 B. Tech in Electronics and Communication Engineering JIIT, Noida, India Jul’16- Jun’20 Leverage working relationships across teams to ensure alignment and drive the adoption of recommended data sources and analysis practices. Maintain expertise in privacy requirements and identify and address impact of updated guidance on work activities and results.

Contact this candidate