profile-pic
Vetted Talent

Shivangi Sharma

Vetted Talent
Highly-motivated employee with desire to take on new challenges. Strong worth ethic, adaptability and exceptional interpersonal skills. Adept at working effectively unsupervised and quickly mastering new skills, who believes in data is the new oil.
  • Role

    Digital Analyst (SEO Specialist)

  • Years of Experience

    4.3 years

Skillsets

  • Data Analytics
  • Advanced excel analysis
  • Client interaction
  • Link Building
  • Local SEO - 3.3 Years
  • Product seo
  • Team Collaboration
  • Google Analytics - 4 Years
  • Google Search Console - 4.0 Years

Vetted For

10Skills
  • Roles & Skills
  • Results
  • Details
  • icon-skill_image
    SEO Analyst(US Shift)AI Screening
  • 75%
    icon-arrow-down
  • Skills assessed :HTML, CSS, CMS platforms, Technical SEO, Local SEO, International SEO, SEMrush, Ahrefs, Google Analytics, Google Search Console
  • Score: 45/60

Professional Summary

4.3Years
  • Mar, 2024 - May, 2024 2 months

    Data Engineer II

    Datametica Birds
  • May, 2023 - Jan, 2024 8 months

    Data Engineer

    Climate Connect Digital
  • Aug, 2021 - Apr, 20231 yr 8 months

    Software Developer II - Data Engineer

    Walmart Global Tech
  • Mar, 2020 - Aug, 20211 yr 5 months

    Software Developer - Big Data

    InfoObjects

Applications & Tools Known

  • icon-tool

    MS office

  • icon-tool

    Excel

  • icon-tool

    Tableau

  • icon-tool

    Teradata

  • icon-tool

    GCP

  • icon-tool

    Airflow

  • icon-tool

    BigQuery

  • icon-tool

    Databricks

  • icon-tool

    MS office

  • icon-tool

    Excel

  • icon-tool

    Tableau

  • icon-tool

    GCP

  • icon-tool

    Google Analytics

  • icon-tool

    Google Search Console

  • icon-tool

    GMB

  • icon-tool

    Looker Studio

  • icon-tool

    WordPress

  • icon-tool

    CallRail

Work History

4.3Years

Data Engineer II

Datametica Birds
Mar, 2024 - May, 2024 2 months
    Working on a migration project, where I have used multiple ways to load data, used python for test cases, and google could platform for creating pipelines for specific migration tables. Each of which requires an end to end work from creating STMs to querying them and CTL which are used to create pipelines.

Data Engineer

Climate Connect Digital
May, 2023 - Jan, 2024 8 months
    Being a part of the CarbonShop team where we create data pipelines for a seamless carbon credit distribution for our clients. The organization with a cause, led me get a lot of knowledge about climate change and how we can save the earth. As a data engineer, we have multiple registries of projects for which we build a platform. Using GCP for storing and processing data from multiple sources.

Software Developer II - Data Engineer

Walmart Global Tech
Aug, 2021 - Apr, 20231 yr 8 months
    As part of the FINTECH team, I am working as a data engineer who uses multiple tools and technologies to get the results from the data.I have written unit test cases in SCALA and we use SPARK as the best big data framework for our project. The contribution involves my dedication towards the big data world, along with also managing and handling team collaborations.Worked on Multiple Refactoring Tasks for the existing data platform Wrote multiple unit test cases for the existing code.Involved in creating various ingestion pipelines and workflows for the internal data platform and ETL work, These pipelines were used and triggers through cloud functions in GCP,along with use of GCS bucket. Creating a Unified data platform for the project. I have used SDLC to minimize our project risks through different approaches, along with agile.I have been involved in the SDLC process from planning - development - to maintenance.

Software Developer - Big Data

InfoObjects
Mar, 2020 - Aug, 20211 yr 5 months
    As a part of the Big Data team, I have worked on new technologies like BlueLink for an automobile client, which is super exciting.Using the data/information from customers, to help them in a more innovative way. From development to deployment, I have learnt the software cycle.Created Multiple Data Ingestion Pipeline on Databricks in Scala.Worked as Part of the Data Engineering Team responsible for migrating and creating pipelines for clients. Following the SDLC process for the whole software.

Achievements

  • National level chess Player
  • Trained in Indian classical music (Vocals)

Major Projects

4Projects

CILL- Central Item Level Ledger

    An audit-able/accounting resilient central data repository where all data generated by systems will reside for use by Finance and other organization needs.Building a Unified data platform for FINTECH project for walmart.

Predicting Lifes Expectancy After Heart Surgery

    The prediction helps in health care sector,serving people about whether they will survive after one year of the surgery or not.It is a CLASSIFICATION problem in machine learning,where our dataset has a problem called CLASS IMBALANCE, which was solved by SMOTE and I used "Random Forest Algorithm" for my model training and got 82% accuracy with a confusion matrix.

Sports Tak

    News Website Optimization project including analysis and optimization for Sports Tak.

Gujarat First

    Project for optimizing and analyzing the news portal Gujarat First.

Education

  • B.Tech

    Rajasthan Technical University,RTU (2020)
  • XII

    Kendriya Vidyalaya (2016)

Certifications

  • Certified scrum master

  • Sql for data science

  • Certified scrum master(2023) by scrum alliance

  • Certified for sql for data science course

AI-interview Questions & Answers

You can see. Yes. So, uh, I have total three point five years of experience in the field of SEO, and I have completed my BTech in 2018. Uh, other than that, I have, like, in the SEO field, I have completed my technical on page and off page stuff. So I have knowledge all around. Uh, secondly, I have, uh, start from the, uh, website audit to analyze, uh, analysis, uh, data analysis through GA and GSC, and then take my decisions to what we have to do in the keyword research, uh, keyword research and what we have to, uh, do in the computer analysis. And now, uh, I have to, uh, then I have, like, uh, performing best in terms of the SEO of performing, like, performance, like, uh, what we have to implementation in the technical and on page part of the stuffs, then I have to move on to the off pages stuff, which we, uh, in which we are analysis, uh, what kind of link building activities we have to perform so that our keyword, uh, keyword, uh, will start to ranking and also, uh, in the last but regularly audit of the website. So we can, um, regularly audit the website so we can analyze this what our performance is all around. So, yes, this is all overview about what I can do in my SEO experience. Second uh, and, uh, finally, uh, the niche which I have to use, like, uh, which I have to work on, uh, SEO front. One is the sports website, which is related to the, um, sports, uh, sports niche. Second is real estate website, which is named as a overall reality. Third one is e commerce website, like, q e c QSI sign, which is related to the signage industry, and other e commerce website, like Softinn Baby, PDF Show, and Anchor, which is all other e commerce website. Few of them working on the, uh, working on the front of WordPress, and other one, like Softinn maybe, is working on the Shopify website. So, yes, I have overall experience on all these, uh, field of the SEO. And, regularly, I have updated my knowledge regarding the SEOs, like, uh, SEO through the SEO general, uh, through some updates, like, code web vital. I have regularly referred to the SEO general and other updates given provided us by the Google. And thirdly, I have, uh, working on the lead generation part as well, uh, through the audit. Uh, I have analysis what kind of quality in the ecommerce website, particularly I use, what kind of quality, um, quality leads we have. So, yes, I'm doing that. That's it about.

Your go to source real time SEO news, and how can you evaluate the credibility of that information? So, yes, my go to source for real time SEO news is one is the SEO general. They are regularly updated through the various multiple articles provided by them, and they also have the detailed articles on them. So, yes, I have reading all the knowledge through the SEO generals. And, uh, other part is that I have evaluate that this information is particularly uh, good, uh, effective or credibility of the information. I find it out when you are, uh, searching on the Google itself and you're searching on the webs uh, Bing itself, they are multiple ample of website. They provide us you the information, uh, information that it is, uh, it is credible or not. So once I started to read all about that, after that, when once I read all these things all these things, uh, then I have to apply on my projects that it is working. Suppose, uh, for example, the core web vital score, which is Google regularly updated, uh, updated, and some e e e a t, the news, uh, the update which is provided by the Google. Now the AI overview, um, provided by the Google. So I apply on my projects. Like, for the core web vital, I, uh, analyze my website speed, website performance, and then, uh, then, uh, then translate it to the, um, integrate it to, uh, on my website. Like, uh, I have to, uh, analyze my website score and then, uh, provide it, uh, then improve my website core web vital score, like FID, LCD, whatever the terms they have. Just improve that, uh, which is improve improvement through the image optimizations, JavaScript optimization. I have performed that. So after that, I find it out that it is this result is credible or not. Uh, why? Because, um, why? Because when I optimize my website, particularly, I see the result as well. When I, uh, optimize my website speed, it shows us on the result as well that my, uh, website performance, user experience has been increased, and that is, uh, my bounce rate has been decreased decreased. My, uh, when user come to my website, I experienced particularly the engagement rate and bounce rate has been decreased. So, yeah, one, uh, one, the processes. First, I read about the through the SEO journal, and then I read through, uh, then I read through other articles as well that this information is rather related to we we apply it or not. So I apply, uh, so I just find it out the way, and then I apply all all these informations, uh, to, uh, on real time sources I I apply on my projects. And if it is working, then the whole project I am applying the whole pages, I am applying that. Secondly, other projects I am also applying. So this is the, uh, this is a go to source of my real time SEO news. And second one is a Twitter also because they provide us the real time news as well. They they are multiple like, bug, they have one of the SEO specialist, and they provide us the regular updates about the SEO. Not only the, uh, regular updates, also if you are, uh, putting your queries to them, they are also provide us the, uh, they are also provide us the reply on that. So it is very information that we have, um, uh, communication through the Twitter. So it is very helpful to us. Yeah. That's about, uh, that's about my group.

How do you manage SEO for large ecommerce platform with 1,000 SKUs? Okay. So one thing is that for the ecommerce platform, particularly, I have 1,000 SKUs. So I divided one one and foremost thing is that when I created my website, um, there are multiple pages. Secondly, I have updated my site map. Like, I have, uh, divided my site map according to the, uh, according to the pages. I have decided my, uh, I have divided my site map. And now the turn is that and integrate the, uh, site map slash in the through integrate through the site map slash index so that all these URLs are in the similar site map. Uh, so it will be easy for me to understand what pages we have, what pages we have updated, what kind of, uh, optimization we have to perform so it will be easy for me. So, uh, yes, I do, uh, first and foremost thing is that sitemap applications. Then I have, uh, through picking up the one sitemap and all these pages, which we have in a one sitemap, I have to overview that they are particularly, uh, good in, uh, start with the technical audit. I have, uh, um, start with the technical audit. I just analyze whether my website, uh, technical, all the things like, uh, code web vital school, uh, and, uh, other, uh, like, other things, images were optimized or not, uh, and, uh, robot dot txt file. All these things are updated or not. So I have to check all these things. Four zero four errors is not provided on the website, and broken links, um, broken links, search console doesn't show any errors on that. So I analyzed all these one by one. And, uh, sometimes I perform the manual check as well. Then I have to go to the on page analysis, uh, through whatever the keyword research, uh, through the competitor analysis as well as, uh, through my own analysis, uh, what kind of page we have, what kind of product we are serve. So analyze all these competitors as well. And according to the keyword research, what we have performed, optimize the on page, uh, stubs of all these pages. And through the and so this is my management part. Like, I start and then I start the main product focus pages, which we are, uh, which we are targeting to get the quality of the leads. It's not about the quantity. It's all about the quality of the leads. So I just, uh, target to the off page activities all these, uh, main product focus pages. Because what happened to us, like, main product focus, uh, if you have a ecommerce website say, like, I have a signage industry website, which is related to the ecommerce website, and there are ample of pages. So I just first analyze what are the main product focus that client want to generate the leads. So first, I target all these in an, uh, site map, which is known as a product site map or the category site map. So it is well informing the structured data is implemented or vital score is implemented. No four zero four hours is there. So I just analyze all these things and putting it all these, uh, products and categories in the one site map. Secondly, I have to like, I have analysis, uh, again, the second site map, which I am linked to the blog related site map, like, all these articles, blogs, which providers are info our customers, our users, the information about, uh, what kind of products we sell or the commercial information or the other kind of information so that they can enhance their knowledge about the, uh, about that particular articles. So, yes, I performed that. Uh, so in the second map, uh, site map, I have to do that. And thirdly, but not leastly that, um, the other categories which we are, uh, area we serve pages, like, uh, what kind of area we are targeted, what niche we are provided to other categories is, like, the area we serve. So, basically, what I have to do, I have to just divide in my site maps in, uh, multiple category multiple categories, integrate it it in the site map slash index part, and then, uh, optimize and analyze what can I, uh, analyze my website, uh, according to that?

For elements and AI overviews here, how we are adapting keyword and content strategy to appear in AI summaries. So, yes, for the AI summaries, one for the alum particularly, uh, yet, it is not, uh, confidently we are sales because some SEO general says that we are not confidently sales or doesn't do Google penalize all these things. So, uh, it is, uh, yeah, that is working or not. We are not confidently sales. But yes. Uh, second, uh, second thing is that, uh, what kind of keyword strategy we are follow. So for the LLMs and AI overviews, particularly, the overview users want us a short information about that. So we are targeting the user inform user related queries. We are targeting the long tail keywords first, which we are target, uh, which in which provide the information about Google queries. So I, uh, so what we can do if we are typing search was for example, I just want to buy a product, uh, related to the shoes. I just want what kind of shoes I want, uh, to buy? It's a red color, pink color, or any other color. What kind of material I use? I just type user. Particularly, what, uh, do is on the search result, they are they are typing on the Google, uh, search. They are typing what information they want, and it converted into the user queries. So, mainly, what kind of content I what kind of keyword I suggest is the long tail keyword which target user queries. Uh, secondly, the content strategies, content is short, crispy for all AI overviews. Secondly, content is related to, uh, FAQs, which generally provides the information about user queries. And, thirdly, uh, that for the AI summaries, we are divided our content in different part. Like, for the first above part, we are provided information as well as answer the user queries related thing. When we are write our blog, we are just provided the information or user quality related information so that if, yeah, we can optimize it, we can optimize it. Uh, it can provide it as a own AI overview. So, yes, in the blog or in the or in the, uh, pages, we are, uh, firstly, we are divided on our content in multiple target, and this is related to the tofu mofu and tofu structures. Top of the query, we have to analysis, uh, like, uh, target the user queries, short summaries about our what kind of short summaries we are provided to our users. This all about this pro blog pages is all about related to provide you to the information. So all these are appears. Uh, and after that, there is an, uh, medium type. Like, we have provided in the middle of the funnel. We are just provided the little detailed information. And in the bottom of the funnel, we have provide the extensive detailed information to our users so that when some users come on our website uh, find AI overview and then come to our, uh, website. It is helpful not only helpful for him or her to, uh, find out the answers of their queries, but, uh, also find out the, uh, detailed information which we are provided.

Provide this code web vital issues especially for large template based service website. Okay. So for the code web vital particularly, first and foremost thing is that we have through the page speed insight and through the SEMrush. Because for page speed insight, first, we analyze what overall speed of our website is. If it showed decline, we there are ample of, uh, things like FID, LCD. We have to optimize through image optimization, JavaScript optimization. If our developer is good, we can reduce our writing codes on our website. Secondly, in an SEM dash data also, we have provided multiple pages on which our result have been, uh, on which our speed have been decline, uh, declined. So we are targeting them as well to optimize our website. And for the last template website based website, we have to we have to create our website. We have to ultimately, we have to create our website with respect to the go with respect to the user good to the user experience. So, uh, through the through we have reduced the image size. We have I may and and remain the picture quality as well. We have, uh, optimized our images, our content, our content part. We have to find it out on the they are working on the ample of projects, uh, especially on the WordPress website. We have plugins as well, which are performing well and provide us the 99% of the code web vital score. Like, for the sports website, which which I have working, it is an ample of articles on published on a daily basis. There is a lot and large template website for a sports, and we have achieved the score through the sorted plug in because we have, um, not only optimized the image of the website, we also, um, uh, optimize a low content speed loading speed of the content. So, yes, we can optimize it, uh, through reducing our, uh, code, reducing our writing code as well, uh, remove the unnecessary line unnecessary blank lines, white lines, which we have on our code so we can remove that as well. Uh, secondly, um, the content the content part, we are just, uh, on a paragraph wise or the which is also beneficial for us in the AIO overview. Uh, also, in a pointer wise on the topic wise, we have to, uh, we have to, uh, create our content. We have not unnecessarily overloaded our website through unnecessary video or images or external links. We have not to over overly optimize or overburden our website. It's a short, but it's free website, so we can, yes, we can free, um, improve our code by title score as well.

What's your strategy to capture value in zero click s r s so for zero click SERP environment, what I have to first and foremost part is that what kind of keywords we have to select. So because if we rank our keyword if we rank our keywords in an zero click SERP, uh, like, in an SERP, we can rank our, uh, uh, keywords. It is well and, um, well and good for us. Secondly, we use the AI for this so that at least a short information, but informative information will be pro will we can provide to our users, to our customers about our products, about our website, about whatever the niche we have, short information we are provided. Secondly, we have technical part. We have totally, uh, optimized our technical things. Like, we have structured data on our website. Our core web vital is perfectly fine, uh, perfectly fine, and it speed is very good. Our UI UX design is well and good. Uh, we can internal link on we can we have a good internal linking on our web website. We have, uh, uh, target we have no four zero four or any kind of broken links on our website. So, technically, we can find it out. Our website is performing well and good. Secondly uh, sorry. Thirdly, we have, like, target the on page part if we are PSP, but informative user target and information informative meta description, which all meta's title and description, which target the user c user CTA, which have included the CTS as well and which target the right customer on our website. We can find it out altogether through the data analysis thing. So before we start all these things, we have to perform the data analysis. Either it is through the computer analysis or through the GSE and GA GA, we can analyze data targeting from which country, from which city our traffic has come, our users will come. And what kind of bounce rate, what kind of engagement rate is there, uh, through the heat map as well, we can analyze, um, we can analyze through the heat map that there is a a what kind of content user wanted to interested in. So we are targeted that, uh, targeted that so we can analyze. If, uh, we can write the content on that front, user will definitely come on to our website. And in generation of AI, we have to adopt AI as soon as possible, like, through the particularly on the content front, we have the FAQs, which is very helpful for us. Secondly, uh, we have keywords. Find it out not only through the complete analysis or through our own research like Google AdWords Planner. No. We have to research on search queries as well because, ultimately, we are targeting the users. What kind of, uh, things they what kind of analysis they have, what kind of questions they have, what kind of search capabilities they have. So we have to analyze the user experience as well. And first, uh, foremost, we have also the our UI UX design is perfectly fine. It is attractive because when you will come to our website, if we are have a good website, it is it is UI UX design is very attractive, then user come on our website, and, ultimately, they have again and again come on our website. So, yeah, this is what my strategy.