Headline

Lead Data analyst at Google via Infobahn

About

A designated data and business analyst with 5+ years of experience in identifying trends and opportunities to convert them into actionable insights and develop business strategies from large volumes of data for helping the organization achieve its long-term goals. Strong working knowledge of data analysis, reporting, statistical data modeling, data mining, and business intelligence tools. Proficiency and hands on experience in BI tools like Tableau, Power BI, Google Analytics, R, Excel. Professional experience working with relational databases and tools like MS SQL server, MS Access.

Location

Mumbai

AI stack

codex

github copilot

kiro

meta

openai

perplexity

ChatGPT

ChatGPT Images

Microsoft Copilot

Work experience

Lead Data Analyst at Google, Aug 2021 - Present · 5 yrs, Irvine, California, United States

Acquisition Analyst at Google, Aug 2019 - Aug 2021 · 2 yrs 1 mo, Irvine, California

Data Analyst Intern at La Mere, LLC, Jan 2019 - May 2019 · 5 mos, Fullerton, USA, • Gathered insights from historical sales data of Super 8 Motel and devised pricing strategies for all room types. Implemented predictive models in R to forecast the demand and revenue of the motel with an accuracy of 80%. • Created dashboards and analytical reports depicting the overall profits, revenue collected, ratings by users, performance trends, occupancy and projected future sales for the management to make informed decisions. • Leveraged Tableau & Excel to deploy KPI based ad-hoc reports of Super 8 Motel’s booking data. Developed presentations, communicated key findings to senior management and recommended potential business strategies by analyzing market trends.

Data Analyst at Digital Edge Technologies, Jul 2014 - Jul 2017 · 3 yrs 1 mo, Mumbai Area, India, • Created relational databases and designed databases schemas highlighting the critical entities influencing product sales as a part of the company’s proof-of-concept project. Employed complex queries and stored procedures by employing MS SQL Server to extract critical information from client database. Utilized SSIS to extract, transform and load (ETL) data from multiple sources to optimize daily, weekly and monthly database updates, and enable efficient data integration and process automation. • Designed models in MS Excel for conducting demand planning, inventory control and management of stock on hand. Analyzed raw data using advanced Excel functions like conditional formatting, Pivot Tables and VLOOKUP. • Conducted data pre-processing on the raw data using Excel and R. Developed interactive dashboards, data visualizations and monthly insight reports using Tableau, Excel and Power BI to assess financial performance and potential market issues for the company’s chief clients. • Utilized Google Analytics to analyze visitors flow & interaction throughout client websites and increased traffic by 14%.

Education

Master of Science - MS, Information Systems- Business Analytics, California State University, Fullerton

Bachelor of Engineering - BE, Information Technology, MCT's Rajiv Gandhi Institute Of Technology