Ishan Pande

Business System Analyst at Agile Datapro
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
San Francisco, California, United States, US

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
Join now
You need to have a working account to view this content.
Join now

Credentials

  • Fundamentals of the Databricks Lakehouse Platform Accreditation (V2)
    Databricks
    Jun, 2023
    - Nov, 2024
  • Academy Accreditation - Databricks Lakehouse Fundamentals
    Databricks
    Jun, 2023
    - Nov, 2024

Experience

  • Agile Datapro
    • United States
    • Software Development
    • 1 - 100 Employee
    • Business System Analyst
      • Feb 2023 - Present

      Leveraging Vertex AI by Google Cloud, to streamline Network Security Analysis for telecommunication incident resolution workflows. Developed intricate time series data sets utilizing PostGres and Apache Druid instances in Google Cloud Platform (GCP) to gather real‑time performance data from network clients in adherence to the SLA's. (Dataproc) Expertly employed PowerBI to conceive and implement a sophisticated multi‑tenant dashboard, enabling comprehensive network health monitoring across all devices. This instrumental solution facilitated early detection of critical issues, thereby significantly diminishing the mean time to resolution, 20%. Requirements gathering, documentation and collaboration with stakeholders to define technical solutions for cloud‑based systems for a Telecommunications company. Writing highly complex SQL queries, stored procedures, triggers, CTE's. Data Storage, Modeling, Schema Design, Aggregation & Classification. Experience working with agile and waterfall methodologies. Show less

  • Fresh Origins
    • United States
    • Farming
    • 1 - 100 Employee
    • Senior Data Analyst
      • Oct 2021 - Feb 2023

      Migrated legacy Sage database for Agricultural Sector (Visual Produce) to Oracle ERP Cloud for Netsuite implementation. Spearheaded successful training initiatives for new ERP system (Oracle NetSuite) and warehouse management software(Parity Factory), resulting in 90% of the workforce effectively utilizing the new systems to streamline operations and increase productivity. Utilized Tableau and custom SQL feature to create dashboards and identify correlation between customer journeys, break points, call reasons, bill shock, and locations. Worked with CFO and Controller to drive data support for understanding financial impact and preparing evidence for recording journal entries. Create weekly dashboards using Tableau and analyze the model performance each week. Worked with ADP as well for HR and Accounting to track employee metrics. Show less

  • PNC
    • United States
    • Financial Services
    • 700 & Above Employee
    • Data Analyst
      • Sep 2020 - Oct 2021

      Followed Agile testing methodology, participated in daily SCRUM meetings, and tested each Sprint deliverable. Enabled and empowered Business Accounting, F&S, Tax team to achieve business goals, through data analytics support, dashboards, tooling automation and operation efficiency enhancements Prepared dashboards using calculated fields, parameters, calculations, groups, sets, and hierarchies in Power BI. Support Accounting and Finance & Strategy team for month end close process. Performed data preprocessing and feature engineering for further predictive analytics using Python, PySpark. Involved in complex SQL queries using views, indexes, triggers, roles, stored procedures, and user-defined functions. Show less

  • University of South Florida
    • United States
    • Higher Education
    • 700 & Above Employee
    • Graduate Assistant
      • Mar 2020 - Jun 2020

      Chatbot Development using IBM Watson to help TA's and Professors answer student queries. Used NLP techniques and tools, such as sentiment analysis, entity recognition, and intent classification. Chatbot Development using IBM Watson to help TA's and Professors answer student queries. Used NLP techniques and tools, such as sentiment analysis, entity recognition, and intent classification.

  • Winds E World
    • Bengaluru, Karnataka, India
    • Business Intelligence Analyst
      • Dec 2018 - Jul 2019

      Successfully achieved a remarkable month‑over‑month average increase of 43.7% in the number of users over a 7‑month period by reducing critical information transfer times resulting in a significant boost in the user base from 4,500 to 42,000. Analyzed the conversion rates and performance of mobile applications on the Google Play Store and Apple App Store to improve retention rate by 27%. Successfully achieved a remarkable month‑over‑month average increase of 43.7% in the number of users over a 7‑month period by reducing critical information transfer times resulting in a significant boost in the user base from 4,500 to 42,000. Analyzed the conversion rates and performance of mobile applications on the Google Play Store and Apple App Store to improve retention rate by 27%.

  • CSPL Computers Pvt. Ltd.
    • Information Technology & Services
    • 1 - 100 Employee
    • Business Analyst
      • 2017 - 2018

      Supporting data scientists with ad‑hoc data requests, dataset development projects, and validation of generic scores. Data Labeling and basic SQL querying. Power BI dashboards with Measures. Supporting data scientists with ad‑hoc data requests, dataset development projects, and validation of generic scores. Data Labeling and basic SQL querying. Power BI dashboards with Measures.

  • GrabLoyalty
    • India
    • Advertising Services
    • 1 - 100 Employee
    • Data Engineer
      • Mar 2014 - Feb 2017

      Utilized AWS EC2 and Lambda to build a scalable and secure online payment gateway infrastructure, handling transaction processing and event‑driven tasks. Own the code promotion process, including the branch management and build management. Setup the automation deployment using Kubernetes and Docker Hub on AWS. CI/CD: handle, troubleshoot, maintain & optimize AWS TensorFlow’s CI/CD infrastructure. Utilized AWS EC2 and Lambda to build a scalable and secure online payment gateway infrastructure, handling transaction processing and event‑driven tasks. Own the code promotion process, including the branch management and build management. Setup the automation deployment using Kubernetes and Docker Hub on AWS. CI/CD: handle, troubleshoot, maintain & optimize AWS TensorFlow’s CI/CD infrastructure.

Education

  • University of South Florida
    Master's degree, Computer/Information Technology Administration and Management
    2019 - 2021
  • SRM University
    Bachelor of Technology - BTech, Computer Science
    2013 - 2017

Community

You need to have a working account to view this content. Click here to join now