Versatile individual with experience collecting,transforming and organizing data for analysis in order to make informed decision. Excellent understanding and proficiency of platforms for effective data analysis,including SQL,spreadsheets,Tableau & R,strong communication,organizational and analytical skills,
Overview
8
8
years of professional experience
1
1
Certification
Work History
Deputy Manager
Ashoka University
New Delhi
08.2022 - Current
Created dashboards using Power Bi to track and analyze key metrics.
Leveraged SQL queries to extract, transform and load data into databases.
Utilized statistical techniques to translate raw data into actionable insights.
Implemented effective database management strategies to support informed decision-making using data-driven solutions.
Built visualizations that enabled users to quickly interpret results from complex analyses.
Utilized advanced analytics tools such as SAS, SPSS, Excel PowerPivot, to manipulate large volumes of structured and unstructured data sets.
Utilized predictive modeling to increase and optimize customer experiences, revenue generation, ad targeting, and other business outcomes.
Worked closely with management to prioritize business and information needs.
Collected business intelligence data from industry reports, public information or purchased sources.
Integrated third-party applications with the CRM platform to increase efficiency.
Generated performance metrics reports from data stored in the CRM database.
Planned and implemented strategies for paid search campaigns across multiple ad networks.
Designed landing pages that convert visitors into leads or sales.
Analyzed data from Google Analytics, Adwords, and other sources to track performance of campaigns.
Directed social media and digital marketing strategy and initiatives to promote brand building, guest retention and revenue-focused activities.
Developed and implemented a WhatsApp communication channel for stakeholder engagement, handling the entire process from approval to message delivery without third-party involvement.
Technical Executive
Jones Lang Lasalle @ Google PVT. LTD
Gurugram
10.2016 - 08.2022
Build an APAC Ops dashboard for Google leadership, not only for analysis but also for monitoring team performance, in turn bringing down our escalation tickets by 10%.
Efficiently managed space operation for Google Gurgaon and increased KPI performance for the account from 4.4 to 4.6.
To maintain and compute monthly PPS 'Pay per seat' charges for vendor partners '20 partners' operating from Google sites based on seat utilization, managing a monthly transaction of ~3 million $
Forecasting and budgeting of Google sites.
Succeeded in achieving 0% variance for two consecutive years.
Prepared proposals, handled, and shared about 26 AMC contracts across Google North/South offices with a cumulative negotiated rate of 20% against last year's amount.
Managed updates of sustainable utility and water data for India and Philippines on Google's sustainable portal.
Created Dashboard across various Google offices in India.
Supervised a team of 10 people and trained personnel from different offices.
Analyzed user feedback from surveys and focus groups in order to improve product features and usability.
Negotiated contracts with vendors for the procurement of hardware or software components.
Created automated reports to visualize financial performance metrics.
Education
B-Tech - Mechanical Engineering
GLA University
Mathura
Skills
Spreadsheet advanced user
SQL
Power BI
Tableau
Analytics Skills
Finance
Procurement Domain Knowledge
Data Cleaning
Analysis
Visualization
Big query- SQL Certification
Careerachievements
Stranger Things Award to tackle the complex world of data.
Got Service GEM Award for providing Sublime client service
Awarded with IFM superstar for adaptability of the new projects.
Received Technical GEM award for ensuring optimum performance of the team by organizing team building activities.
Training
Google Data Analytics Course
Tableau Certification
Big query- SQL Certification Training
Accomplishments
Received 3 quarterly rewards and "Outstanding" Rating for 2 consecutive year for 2 year of service @Ashoka University
Stranger Things Award to tackle the complex world of data @JLL India
Got Service GEM Award for providing Sublime client service Awarded with IFM superstar for adaptability of the new projects @ JLL India_Google
Received Technical GEM award for ensuring optimum performance of the team by organizing team building activities.@JLL India_Google
Certification
Google Data Analytics Course
Tableau Certification
Big query- SQL Certification Training
Languages
Hindi
First Language
English
Advanced (C1)
C1
Timeline
Deputy Manager
Ashoka University
08.2022 - Current
Technical Executive
Jones Lang Lasalle @ Google PVT. LTD
10.2016 - 08.2022
B-Tech - Mechanical Engineering
GLA University
Google Data Analytics Course
Tableau Certification
Big query- SQL Certification Training
Similar Profiles
Aadya SinhaAadya Sinha
Head of the Department,Disposable Waste Management at Ashoka UniversityHead of the Department,Disposable Waste Management at Ashoka University