Shruti Srivastava Email & Phone Number

• Data extraction, cleaning and analyzing using SQL and Python• Produced reports and dashboard using Power BI focusing on business objectives• Proficient in using Microsoft office 365 tools • Design, build and deployed Power BI solutions• Conducted comprehensive SEO analysis using Google Analytics data.• Developed and executed SQL queries to extract and analyze large datasets for SEO performance.• Created and maintained Metabase dashboards to visualize SEO metrics and KPIs.• Identified key insights and trends to optimize web content and improve search engine rankings.Projects Predictive modeling for price prediction for Airbnb in NYC• Creating predictive model using statistical tools such as Regression Analysis for Air BnB dataset• Ability to retrieve, analyze and synthesis large amounts of data • Pulling insights from data analyzed such as which area are most expensive, least expensive and most popular places to rent• Visualized the data using Matplotlib and Seaborn libraries from Python• Prediction of unit price as well as what evaluation of different areas, host effects the renting Life Insurance Risk Prediction using Machine Learning Algorithm• Creating predictive model using statistical tools such as Classification Model• Data was cleaned, checked for missing values, exploratory data analysis was performed on the dataset, target variable was identifie

• Coordination and Interacting with various stakeholders within the organization• Developing Project based tools such as Gantt Chart and Process Checklist

Sarnia

• Coordinated effectively between the mechanical, process controls and drafting department to obtain data and conduct feasibility studies. • Conducted hydraulic run in HYSYS and HAZOP analysis studies for risk analysis of the plant. • Performed process safety valves sizing to avoid over pressurization and process safety incidents.• Conducted feasibility and economic studies within the refinery.• Investigated/troubleshot process problems, evaluated refinery parts and ensured smooth plant operations.

Calgary

•Scheduled and coordinated projects and staff to ensure timely project completion •Performed pump and tank Sizing calculation for oil/water treatment plants to conduct feasibility study•Conducted hydraulic runs for oil/water treatment and firewater system in Korf, ensured process efficiency•Assisted in developing of technical manuals for departmental usage•Developed process flow diagrams (PFDs), and process and instrumentation diagrams (P&IDs) for construction of the pump stations•Performed heat and material balance using HYSYS to optimize the process•Prepared accurate datasheets for tanks, pumps, process safety valves and heat exchangers for submission to the vendors•Finalized line list, tie in list, utility summary and battery limit table to complete the deliverables of the package

Calgary

•Performed pipe sizing using Pipeflo to determine the optimal size of the pipes•Assisted in sizing of separators and compressors to ensure the equipment works to its specification and capacity•Conducted Glycol heat tracing calculations for feasibility study•Prepared accurate datasheets for air-cooler using ACX for feasibility study

Data Science Certification

Data Science Certificate

Master Of Engineering (M.Eng.)

Bachelor Of Science (B.S.), Chemical Engineering