Vidaan Shankar Email & Phone Number

Austin, Tx, Us

Green Bay, Wisconsin, Us

- Automated data retrieval from JIRA and Cherwell APIs using Python (Requests Library) to streamline information flow and enhance operational visibility within the organization.- Deployed scalable and consistent AWS infrastructure using Terraform to pull data from 3rd party vendor.- Migrated data from on-premises SQL Server databases and Oracle DB to Snowflake through GitHub based CI/CD pipelines using Control-M jobs. - Designed and implemented data models based on the Medallion architecture, aligning with business requirements and improving data usability and efficiency.- Developed an interactive Power BI dashboard to track multiple projects and tasks, providing real-time visibility into the status of engineering team activities. - Incorporated features to display project progress, task completion status, and average sprint velocity, enabling efficient monitoring and informed decision-making for project management. - Collaborated with business teams in an agile environment using JIRA and Confluence for project management and documentation.

Madison, Wi, Us

Consulting Practicum:- Deployed a Gaussian Process Regressor ML model to determine optimal settings for combine harvester machine based on multiple weather paramaters and crop type depending on the overall geographic location.Walmart Regional Distribution Center Optimization (Python, Excel):- Used Bing Maps API to create distance matrix between RDCs and stores in Excel with VBA and used Mixed Integer Linear Programming (MILP) to map Regional Distribution Centers (RDCs) with stores based on capacity and demand by location.Cloud Data Pipeline:- Built high-volume data pipelines on cloud using Fivetran and dbt to extract, load and transform data from S3 buckets into BigQuery and set up S3 as an external stage for Snowflake through a storage integration and built dashboards in Looker.- Connected Snowflake and AWS through API integration to make use of External functions in AWS Lambda for automating notifications using AWS SNS.Prediction of Dengue Cases (Python - ML):- Built ML model to predict number of dengue cases in Puerto Rico and Peru using regression models such as Random Forest, XG Boost, ADA Boost, Support Vector Machines etc. Random Forest model had the best accuracy of 60%.- Conducted exploratory data analysis (EDA) through univariate and bivariate analysis to understand interactions between features to enable feature engineering and scaling data.

Mumbai, Maharashtra, In

Mumbai, Maharashtra, In

Master Of Science - Ms, Business Analytics

Master Of Technology - Mtech, Project Management

Bachelor Of Technology - Btech, Engineering