profile-pic

Nishant Rao Guvvada

Nishant Rao Guvvada

With over 6 years of experience in the field, I have honed my skills in cloud server management (specifically in Google Cloud and AWS), Vertex AI, and Tableau. I am also well-versed in Vertex AI, leveraging its capabilities to build advanced machine learning models. Furthermore, my proficiency in Tableau has allowed me to present data in a visually appealing and intuitive manner, enabling stakeholders to derive actionable insights. With my diverse skill set and extensive experience, I am confident in my ability to deliver exceptional results in any project or role

  • Role

    Machine Learning Engineer

  • Years of Experience

    6 years

Skillsets

  • Ecommerce - 2 Years
  • Risk compliance
  • Ml engineering
  • Bi tools
  • Ai models
  • Analytics
  • Cloud Computing
  • Data Visualization
  • automation
  • Python Programming - 3 Years
  • MS Excel - 5 Years
  • Google Analytics - 1 Years
  • Machine Learning
  • PowerBI - 5 Years
  • Data Analysis - 5 Years
  • QA - 3 Years
  • SQL - 5 Years

Professional Summary

6Years
  • Mar, 2022 - Present2 yr 6 months

    Visualization Analytics Specialist II

    Rackspace
  • Nov, 2020 - Mar, 20221 yr 4 months

    Financial Data Analyst, Closing Team

    Better Mortgage Corporation
  • Nov, 2020 - Mar, 20221 yr 4 months

    Financial Data Analyst: Closing Team

    Better Mortgage Corporation
  • Jun, 2016 - Jun, 20171 yr

    Research Associate (Ownership, Quality Analysis Team)

    S&P Global Market Intelligence
  • Feb, 2019 - Nov, 20201 yr 9 months

    Analyst: Global Security Team

    EY Global Delivery Services
  • Feb, 2019 - Nov, 20201 yr 9 months

    Analyst, Global Security Team

    EY Global Delivery Services
  • Jun, 2016 - Jun, 20171 yr

    Research Associate: Ownership/Quality Analysis Team

    S&P Global Market Intelligence

Applications & Tools Known

  • icon-tool

    MySQL

  • icon-tool

    Python

  • icon-tool

    Microsoft Power BI

  • icon-tool

    SQL

  • icon-tool

    Google Analytics

  • icon-tool

    Microsoft Excel

  • icon-tool

    Tableau

  • icon-tool

    GCP

  • icon-tool

    Google BigQuery

  • icon-tool

    Power BI

  • icon-tool

    Tableau

  • icon-tool

    MS Excel

  • icon-tool

    MS Access

  • icon-tool

    SQL

  • icon-tool

    Power Automate

  • icon-tool

    Snowflake

  • icon-tool

    Airflow

  • icon-tool

    AWS

Work History

6Years

Visualization Analytics Specialist II

Rackspace
Mar, 2022 - Present2 yr 6 months

    Roles and Responsibilities:

    • Primary Responsibility to deliver reporting solutions to RAX clients using BI tools, Python programming and ML engineering.
    • Developed multiple AI based applications.
    • Graduated from Google Immersive Advanced Solutions Lab, built a capstone project on Image Classification of hip implant x-rays.
    • Recognized by Technical Innovation Awards for developing a tool in Python to delink BI tools from Data Stores for the 2nd Quarter FY 23.
    • Earned AI Ready and AI Business badges for trainings on FAIR (Foundry for AI by Rackspace).

    Project 1:

    BI Data Delver:

    • A chatbot for writing code, summarizing datasets and locating fields within Google BigQuery.
    • A text-to-code converter cum code summarization AI bot. My contribution to the project included building the ML model leveraging vector store based on the concept of retrieval augmented generation.
    • The team built the frontend using streamlit.

    Project 2:

    Genie:

    • An AI bot for generating BI metrics along with statistical and business summaries presented in a visually appealing format such as interactive graphs and tables.
    • My contribution to the project involved building the data pipeline using tensorflow APIs to train the model.
    • A chatbot for providing a detailed summary of clients and pipelines via natural language.

    Project 3:

    Contract Validation Tool:

    • An interface to summarize and validate contracts ingested via pdf uploads.
    • The tool is based on the text generation model (Google's text-bison).
    • My contribution included fine tuning the pretrained model.

    Project 4:

    Recommendation System:

    • A movie recommendation system which employs collaborative filtering technique to provide personalized movie suggestions based on user preferences.
    • By analyzing user behavior and preferences, the system identifies patterns and similarities between users, enabling it to recommend films that align with their tastes.
    • The project mirrors the approach used in various movie streaming services.

    Project 5:

    Dashboard Migration:

    • Completed migration of dashboards to Tableau from Qlik Sense.
    • The project involved refactoring legacy SQL code into BigQuery compatible, recreating the metrics and calculations of the former dashboard on the new visualization tool.

    Project 6:

    Automation of manual excel based reports:

    • Created an application in python to automate the process of creating excel based reports fronted with a user-friendly GUI. (used openpyxl, pandas and tkinter libraries to create the application).
    • The project delinked BI tools from the data stores.
    • The application allowed users to bypass BI tools to fetch the report directly from the source, thereby delinking the source from the BI tools for the users.

    Project 7:

    Pipeline Dashboard:

    • Built a dashboard to capture the end to end process of converting an opportunity into a closed booking (won or lost).
    • The project included building the data source on Google Cloud Platform BigQuery (SQL) and presenting the information on an interactive dashboard using Tableau.

Financial Data Analyst, Closing Team

Better Mortgage Corporation
Nov, 2020 - Mar, 20221 yr 4 months

    Roles and Responsibilities:

    • Primary responsibility to analyze parameters (DTI/HTI, LTV calculation, taxation) required for approval of mortgages and reporting on the pipeline via MS Excel, Power BI and Tableau.
    • Automated sub processes leading using Macros and Power BI. - Devised a Macro enabled formula driven checklist to increase the efficiency and quality of the mortgage closing process.

    Project 1:

    • Built a Mortgage Approval Prediction System, a machine learning product, based on Logistic Regression model using Scikit-Learn.

    Project 2:

    • Built reports on excel, Power BI and Tableau to present the pipeline statistics to the leadership.
    • The reports sourced data from Google's BigQuery as well as flat files (manually created by Closers involved in the mortgage process).

    Project 3:

    • Automated excel reports using Power Query and Power BI, thereby, transforming excel reports into Power BI dashboards.

    Project 4:

    • Devised a formula driven checklist for the closers to increase efficiency of the online mortgage process.

Financial Data Analyst: Closing Team

Better Mortgage Corporation
Nov, 2020 - Mar, 20221 yr 4 months
    Analyzed mortgage parameters and automated subprocesses using Macros and Power BI.

Analyst, Global Security Team

EY Global Delivery Services
Feb, 2019 - Nov, 20201 yr 9 months

    Roles and Responsibilities:

    • Primary role to conduct Global Risk Compliance and publish dashboards and reports using Power BI on various in-house monitoring systems such as Everbridge, Visual Command Centre.
    • Assisted and led process enhancement initiatives through MS Excel, MS Access, SQL and Power Automate leading to in-process automation.

Analyst: Global Security Team

EY Global Delivery Services
Feb, 2019 - Nov, 20201 yr 9 months
    Conducted Global Risk Compliance and published dashboards and reports using Power BI.

Research Associate (Ownership, Quality Analysis Team)

S&P Global Market Intelligence
Jun, 2016 - Jun, 20171 yr

    Roles and Responsibilities:

    • Ownership team - conducted detailed research on ownership of shares claimed by companies in publicly available reports.
    • Quality Analysis team - role to form a team wide guideline using databases such as Bloomberg, Zoom-info, D&B and in-house Capital IQ

Research Associate: Ownership/Quality Analysis Team

S&P Global Market Intelligence
Jun, 2016 - Jun, 20171 yr
    Conducted research on share ownership and formed team-wide guidelines using financial databases.

Achievements

  • Recognized by Technical Innovation Awards for developing tool in Python to delink BI tools from Data Stores for the 2nd Quarter FY 23.
  • Earned AI Ready and AI Business badges for trainings on FAIR (Foundry for AI by Rackspace).
  • Part of the college soccer team in Anna University intercollege football championship. HOBBIES Learning new languages (linguistic as well as technical),
  • Developed multiple AI-based applications
  • Graduated from Google Immersive Advanced Solutions Lab
  • Recognized by Technical Innovation Awards for developing a tool in Python to delink BI tools from Data Stores
  • FAIR (Foundry for AI by Rackspace) trainings

Testimonial

EY

Phil Phillips

I have worked with Nishant on many high priority security projects and have always found him to be a valuable member of the team. Nishant is highly responsive, he has strong technical skills and always takes initiative to follow-up on key tasks without oversite. His communications, both written and verbal, are clear and concise. He is inclusive of others and does an excellent job supporting all members of the team. Nishant has the courage and leadership skills to make the right decisions for the right reasons. If I had a very important assignment and wanted to ensure success, Nishant would be one of my first picks for the team.

Major Projects

8Projects

Movie Recommendation System

Personal
Dec, 2023 - Jan, 2024 1 month

    Project :

    • A movie recommendation system based on collaborative filtering technique.
    • The movie recommendation system I developed employs collaborative filtering technique to provide personalized movie suggestions based on user preferences.
    • By analysing user behaviour and preferences, the system identifies patterns and similarities between users, enabling it to recommend films that align with their tastes.
    • This collaborative approach enhances the accuracy and relevance of suggestions, creating a more engaging and satisfying user experience.
    • The project mirrors the approach used in various movie streaming services.

    Link: https://huggingface.co/spaces/nishantguvvada/Recommendation-System

Data Delver:

Rackspace
Nov, 2023 - Dec, 2023 1 month

    Project :

    • BI Data Delver: A LLM based chatbot (PaLM2) for writing code, summarizing datasets and locating fields within Google Big Query.
    • Data Delver is a text to code and summarization AI bot providing transformation logics, calculation definitions, locating and summarizing codes and fields within codes as well as writing SQL scripts.
    • This chatbot leverages Retrieval-Augmented Generation implemented using Google's Vertex AI Vector Store, enhancing its ability to intelligently retrieve and generate responses.

X-ray Assistant

Personal
Nov, 2023 - Dec, 2023 1 month

    Project :

    • An image classification model for hip-implant X-ray use case.
    • The application uses a model based on convolutional neural network (CNN) with 80% accuracy.
    • This application holds significant potential in streamlining medical assessments, providing reliable support for healthcare professionals.
    • The CNN's ability to discern intricate details within X-ray images contributes to the model's high accuracy, making it a valuable tool for efficient and accurate classification of hip implants.
    • The model outputs "Control" for perfectly fitted implants and "Loose" for those requiring attention, emphasizing its practicality in clinical decision support.

    Link : https://huggingface.co/spaces/nishantguvvada/Hip-Implant

Contract Validation Tool:

Rackspace
Oct, 2023 - Nov, 2023 1 month

    Contract Validation Tool:

    • An interface to summarize and validate contracts ingested via pdf uploads.
    • The tool is based on PaLM2 model and works using prompt engineering.

Genie:

Rackspace
Sep, 2023 - Oct, 2023 1 month

    Project :

    • Genie is a bot (LangChain) for generating BI metrics along with statistical and business summaries presented in a visually appealing format such as interactive graphs and tables.

Bookings Dashboard

Rackspace
May, 2023 - Jun, 2023 1 month

    Project :

    Bookings Tableau Dashboard

    • In the project, I integrated data from Google Big Query by constructing stored procedures, tables, and views.
    • Focusing on the pivotal theme of bookings, I merged datasets related to bookings, products, and customers.
    • This data amalgamation empowered the creation of a comprehensive data source, which became the foundation for a dynamic and insightful dashboard.
    • The visualization highlighted top 10 products and customers, providing a nuanced perspective on total booking amounts and segmenting booking amounts by stages.
    • The project not only showcased my proficiency in Tableau but also demonstrated the strategic utilization of Big Query to craft an informative and visually engaging business intelligence tool.

Capstone Project on Image Classification

Jan, 2022 - Dec, 2022 11 months
    Built a capstone project on image classification of hip implant x-rays during Google lab training.

Mortgage Approval System

Better Mortgage Corporation
Nov, 2020 - Mar, 20221 yr 4 months

    Project :

    • A Mortgage Approval Prediction System based on Logistic Regression machine learning model using Scikit-Learn.
    • Logistic Regression facilitates binary classification by modelling the probability of approval or rejection based on input features.
    • Leveraging historical data, the model learns patterns to predict the likelihood of mortgage approval.
    • By utilizing the logistic function, it transforms the output into a probability score, making it effective for decision-making.

Education

  • Masters of Business Administration (M.B.A)

    Delhi School of Management

  • Masters of Business Administration, Finance & IT

    Delhi School of Management, Delhi Technological University (2016)

  • B.E. Electronics & Communications

    SMK Fomra Institute of Technology, Anna University (2014)

Certifications

  • AWS

    AWS Solutions Architect Associate (Dec, 2023)

  • Tableau

    Salesforce (Jan, 2024)

  • Google

    Google's Advanced Solutions Lab for Machine Learning (Nov, 2023)

  • Ai business badges

  • Ai ready

  • Google immersive advanced solutions lab

  • Aws solutions architect associate

Interests

  • Photography
  • Painting