𝐒𝐐𝐋 𝐒𝐜𝐫𝐢𝐩𝐭𝐢𝐧𝐠: ✦ Collaborated with team members to understand data requirements, utilized advanced SQL queries to extract and clean data for comprehensive financial analysis for 4000+ capital projects, and regularly optimized scripts for improved performance and seamless integration from multiple sources into financial reporting systems. Also, Regularly optimized SQL scripts to enhance performance and adaptability, enabling seamless integration of data from multiple sources into financial reporting systems.𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 𝐃𝐚𝐭𝐚 𝐌𝐨𝐝𝐞𝐥𝐢𝐧𝐠, 𝐕𝐢𝐬𝐮𝐚𝐥𝐢𝐳𝐚𝐭𝐢𝐨𝐧, 𝐑𝐞𝐩𝐨𝐫𝐭𝐢𝐧𝐠:✦ Developed complex data models to facilitate in-depth financial analysis for 4000+ capital projects.✦ Created visually compelling and interactive Power BI dashboards, and paginated reports providing actionable financial insights. Key dashboards are – capital project life cycle, capital portfolio summary, capital finance project and team KPIs, weekly capital finance variance and active task report, capital project summary report. 𝐂𝐚𝐩𝐢𝐭𝐚𝐥 𝐏𝐫𝐨𝐣𝐞𝐜𝐭 𝐁𝐞𝐧𝐜𝐡𝐦𝐚𝐫𝐤:✦ Validated project financials, information and then utilized it to develop a Power BI benchmarking and estimating report encompassing 1,000+ projects, ranging from minor renovations to new construction. It incorporated the ability to escalate costs to the current value using cost indexes and future escalations. It also includes construction market overview, material price, lead time trends. This report has been utilized by cross-functional team members for project cost estimating purposes. 𝐂𝐚𝐩𝐢𝐭𝐚𝐥 𝐏𝐫𝐨𝐣𝐞𝐜𝐭 𝐂𝐥𝐨𝐬𝐞𝐨𝐮𝐭 𝐏𝐫𝐨𝐜𝐞𝐬𝐬:✦ Audited 50+ projects to ensure accuracy & reliability of both financial & non-financial data.✦ Evaluated 50+ projects ensuring accurate cost allocation to relevant asset categories.✦ Review about 150 financial transactions with a range of $30,000-$80,000 monthly.

✦ Assessed the efficacy of policies leveraging quantitative methods - regression, logistic, SEM ✦ Investigated consumers’ psychological factors influencing their buying intention and behavior ✦ Identified key drivers of user satisfaction with EV attributes for optimal resource allocation strategies ✦ Designed and implemented large-scale surveys and questionnaires to gather consumer insights✦ Authored 5 scientific articles for publications in peer-reviewed journals and 4 got published✦ Presented findings in seminars, and effectively communicated complex ideas to diverse audiences

Research Projects:✦ Uniform environmental safety in the Arctic✦ Long term consequences of temporary trade barriers✦ Academic literature on electric vehicles

✦ Used advanced SQL queries to extract, clean, and prepare large data sets on BigQuery✦ Conducted time series analysis on Google Analytics datasets to evaluate the trends of KPIs. ✦ Conducted data mining on Google Analytics datasets to comprehend consumer behavior.✦ Designed a specific survey questionnaire to gain in-depth insights into consumer behavior.

✦Participated in 12-week-full-time career accelerator✦Enhanced skills in data gathering, wrangling, data analysis, data visualization, modeling✦Created predictive models by supervised & unsupervised machine learning techniques✦Enhanced skills in programming language Python, Scala, SQL✦Python skills include Numpy, Pandas, NLTK, Scikit-Learn, tensorflow, keras, StatsModel ✦Acquired practical knowledge of data scraping from various sources✦Utilized CNN neural network in Capstone for image classificationKey projects:✦ Vehicle image classification using CNN to determine vehicle make & model✦ Classification modelling to predict a specified subreddit✦ Sentiment analysis of Covid-19 related tweets by geographical region