Working for more than Seven years as a data & Business analyst, I have enjoyed my ever-growing passion for data. I have been working as a freelancer in Upwork for more than 5 years and gained several happy clients. Currently, I am also a data consultant for some clients in the USA, Canada, and Europe.
I do not showcase past projects because I seriously respect clients' confidentiality.
I perceive tables and data as raw materials in a production line that produce a final product called information which one uses as a commodity for their business. And I build machines to process those data, using tools like Google scripts coding and python. Google sheet and scripts coding are one of the cheapest, simplest, and easiest ways that any business can handle and process its data. That is where I am proving my expertise.
Moreover, I have also developed professional-level skills in python and Matlab for more complex and time-consuming computation of data.
What I believe:
- Every frequent copy-paste work can be automatized.
- If you are doing repetitive tasks on the computer every day, you are not working smart.
- For many tasks, google sheets can be programmed such that it eliminates the need of buying costly software.
- Google sheet is a versatile internet-based platform. You can connect its data with google forms, google docs, calendar, google slides, database, and several web-based applications like firebase, data studio, google/Facebook ads, salesforce, android apps, etc.
- Google sheets/scripts is eliminating the need of Microsoft Excel and Macros in Business/ Corporate sector.
What I do :
1. Make visually appealing dashboards in google sheets with powerful data computation capability.
2. Data handling, management, processing and visualisation in google sheet and script.
3. Make interactive google sheets through in-built formulas, Custom built formula and complex coding
4. Integrate google sheet with other web-based platforms through API integration. (JSON and XML).
5. Suggest businesses for restructuring of their sheets for optimization and easy data handling.
6. Integrate google sheet with other Google apps like Gmail, Google Calendar, Google docs, Google Slide, Google forms and other spreadsheets.
7. Integrate google sheet with BigQuery, SQL databases, python, desktop applications and other web platforms.
8. Create triggers to run tasks automatically.
- Open AI: Using Open AI API to accomplish what it offers- text completion, summarization, language processing, chatGPT, image generation, embeddings, moderation.
- Project Coin: A google sheet dashboard for cryptocurrency trading, which makes API call to several cryptocurrency websites, fetch the desired data and interpret them and get optimized business data.
-Google ads/ Facebook ads management: A spreadsheet project to fetch data from google ads and Facebook ads (API integration) and manage the data.
-Comparison graph project: An interactive google sheet project which makes multiple graphs based dynamic inputs and dynamic data validations.
- Google sheet Consulting: Complete google sheet solutions (dashboard creation, automation, optimization and external integration ) for companies located in Canada, UK and Australia.
-Financial data analysis in google sheets with macrotrends.
-Simulation of courier data in google sheet.
- Integrate E-commerce (Bigcommerce and Shopify) data to google sheets.
- Integrate google sheets or apps with several APIs such as Slack,Tink, Monday, webhose, NewsApi, Datanews, Nimble, Mailchimp, Mailshake, BOL, Bigquery, Google search Console, Tune, Google Natural Language Processing (NLP), IBM watson Natual Language Understanding (NLU), hubspot, Twillo, gohighlevel, newsapi, parsehub, webhose, bigquery, google search console, OCR, semrush, Open AI, etc. Expertise in Outh2 authorization, REST/SOAP API with JSON and XML response handling.
-Python-based web application
-several web apps using google apps script with google sheets as a database.
-speech recognition and voice interface web application using apps script with google sheets as data storing platform.
-office management system (inventory, payroll, report generation)
-Managing google drive files and making custom script.
-Optimization problem solving with Operational Management technique (simplex method- mathematical approach)
-Cryptocurrency and ticker/stocks data analysis system
-Project Management System (Medical, real estate, and health services)
-Building custom web apps based on Google Apps Script.
-Building add-ons for google sheets.