-> Learnt how to create a SheetBot (helps in uploading the data from Google Sheet to Database as a table and vice versa), a Data Product (user centric table) which helps to simplify the query to extract the data, PySpark to handle big data and create Data Products and Apache AirFlow for scheduling and monitoring the tables deployed on the platform.-> Conducted SQL 101 sessions to empower the users to query the data efficiently and accurately and held feedback sessions to understand… Show more -> Learnt how to create a SheetBot (helps in uploading the data from Google Sheet to Database as a table and vice versa), a Data Product (user centric table) which helps to simplify the query to extract the data, PySpark to handle big data and create Data Products and Apache AirFlow for scheduling and monitoring the tables deployed on the platform.-> Conducted SQL 101 sessions to empower the users to query the data efficiently and accurately and held feedback sessions to understand what are the users' requirements from data.-> Researched multiple database designs (Star Schema, SnowFlake Schema, Data Vault) to tackle the problems faced by the SQL users, such as complexity and slow execution of queries, and designed and led the development of Silver Layer, a layer on top of existing Raw Layer, which reduced the existing 500 tables to 50 user centric tables without the loss of information and reducing the complexity of database.-> Learnt Tableau to create a dashboard which is used across the organisation having high level KPIs and graphs which the business considers to evaluate the health of the business. Show less

-> Integrate and visualize insights from different sources of data to develop a holistic market and customer understanding, and develop dashboards to communicate results to the leadership.-> Acted as a Analytics POC for the Supply vertical and used data to make data driven decisions. Proposed a solution to the management to improve the fulfilment of rides across the country, which then helped improving the Fulfilment of rides from 65% to 78%.-> Hypothesis tested various Proof… Show more -> Integrate and visualize insights from different sources of data to develop a holistic market and customer understanding, and develop dashboards to communicate results to the leadership.-> Acted as a Analytics POC for the Supply vertical and used data to make data driven decisions. Proposed a solution to the management to improve the fulfilment of rides across the country, which then helped improving the Fulfilment of rides from 65% to 78%.-> Hypothesis tested various Proof of Concepts and proposed a Bonus structure for riders which helped the business to become CM positive.-> Analyzed Data to figure out the fraud being committed by drivers and customers negatively impacting the growth of business.-> Learnt Microsoft Excel, Google Sheets to make dashboards to track the performance of business KPIs nationally.-> Answer complex business questions via ad-hoc SQL queries to enable product owners to make critical decisions. Show less

-> Researching on Data Science tools and libraries, and gathering real world data to analyze and drive insights for better planning strategies.-> Building predictive models using FB & Google ads data, and developing methods to analyze model’s performance.-> Created a Consumer Insight Dashboard using Google Data Studio (Now Looker Studio) keeping track of all business KPIs and deployed the application using AWS.-> Learnt Pyspark to handle big data, performed Hypothesis… Show more -> Researching on Data Science tools and libraries, and gathering real world data to analyze and drive insights for better planning strategies.-> Building predictive models using FB & Google ads data, and developing methods to analyze model’s performance.-> Created a Consumer Insight Dashboard using Google Data Studio (Now Looker Studio) keeping track of all business KPIs and deployed the application using AWS.-> Learnt Pyspark to handle big data, performed Hypothesis Testing on the dataset and used a Machine Learning model to predict the mortality of patient given he/she is diagnosed with a Heart disease. Show less

Telenor is a Norwegian majority state-owned multinational telecommunications company. It is one of the world's largest mobile telecommunications companies with operations worldwide. Tools: AngularJS, Spring Boot, Python, Power BI, Java.Created a Customer Insight Dashboard in my Internship at Telenor. The main objective of the dashboard was to ease the monitoring of customers on one single platform. The Dashboard made API calls to collect the data from various end points and the… Show more Telenor is a Norwegian majority state-owned multinational telecommunications company. It is one of the world's largest mobile telecommunications companies with operations worldwide. Tools: AngularJS, Spring Boot, Python, Power BI, Java.Created a Customer Insight Dashboard in my Internship at Telenor. The main objective of the dashboard was to ease the monitoring of customers on one single platform. The Dashboard made API calls to collect the data from various end points and the insights of the data were presented to the Admin Panel. This project helped stakeholders in understanding the business and helped them move forward. The dashboard used REST APIs to fetch data from EasyPaisa, MyTelenorApp, SAS RTDM and presented all of the data of customers in one platform.Responsibilities:=> Gathering and analyzing business user requirements, evaluating software needs, researching new technologies for designing solutions to meet stakeholder expectations.=> Transforming requirements into tangible solutions, logical data modeling, database designing, software development, requirements documentation and process flow designing.=> API’s development for integration of different business support systems and platforms. Show less

• Gathering insights of the stock sold, by performing data cleansing, data modelling and data visualization and performing predictions on the data using time series analysis for better planning strategies.• Assisting troubleshooting and networking issues and provide technical support to 850+ employees nationwide and 12+ stakeholders.• Maintaining a hassle free and reliable connection for 850+ users nationwide to improve the workflow for employees.• Supporting the IT team in… Show more • Gathering insights of the stock sold, by performing data cleansing, data modelling and data visualization and performing predictions on the data using time series analysis for better planning strategies.• Assisting troubleshooting and networking issues and provide technical support to 850+ employees nationwide and 12+ stakeholders.• Maintaining a hassle free and reliable connection for 850+ users nationwide to improve the workflow for employees.• Supporting the IT team in maintaining hardware and software through collaboration. Show less