Devansh Gandhi Email & Phone Number

Woonsocket, RI, US

New York, US

• Built google cloud infrastructure to automate data extraction and analysis from google ads data hub & amazon marketing cloud
• Developed dashboards like audience affinities, customer journey, campaign performance to drive deeper media insights
• Wrote python scripts and build automated cloud solution to collect advertising data from 50+ countries for a Fortune 500 consumer products company resulting in 23% avg lift in viewable impressions (qCPM)
• Deploying AWS solution and creating SQL use cases to uncover 10% additional media effectiveness on Amazon advertising for a Fortune 100 food & beverage company

Bloomington, IL, US

• Utilizing SQL, Tableau, Python to build data sources, reports, and dashboards to deliver insights to the business/management team
• Built an operational dashboard to track KPI’s for monitoring workloads, service levels and determine staffing decisions
• Creating a Process Management scorecard to track employee’s productivity, SLA, and quality at various organizational levels
• Migrating 10+ data pipelines from legacy systems to SQL Server through SSIS, stored procedures, and T-SQL

Bloomington, IL, US

• Comparative Analysis of Credit Model: (Regression, XGBoost, Deep Learning)
• Identified techniques to improve the existing credit model by creating an ensemble model to enable a faster handling timeCI/CD Pipelines: (SVN, Gitlab, Jenkins, Liaison)
• Constructed CI/CD pipelines for java,.NET applications to improve code reliability to reduce time to production by 20% Property Image Recognition: (Classification, Computer Vision, Object Detection)
• Created a machine learning model to predict the risk category of the policy to lower the risk of insurance over 13%
• Worked with the data science team to streamline the data flow pipeline to enhance efficiency to achieve an overall accuracy of 71%Graph Database with Identity Management: (Neo4j, NoSQL)
• Consolidated data from three directory servers to build a centralized graph database for Access Control and Identity Management

Champaign, Illinois, US

Led a team of 5 consultants to recommend a business strategy to enter Asian markets to an upcoming chatbot application

Champaign, Illinois, US

Devised a market entry strategy for food safety provider to launch its products in a potential 20M$ international market

Champaign, Illinois, US

• Performed in-depth Market Research and Competitor Analysis for a technology startup located in the United States
• Optimized the client’s existing marketing strategies by providing the client with a new pricing model to increase customer base

Champaign, IL, US

• Created a spatial database containing information about weather, soils, land allocation for the entire US using PostgresSQL and PostGIS
• Developed Maps and visualizations to analyze the different conditions in which the corn, cotton and almonds crop grow in the US

Mumbai, Maharashtra, IN

• Researched and analyzed various types of Life insurances and annuity plans offered by SBI Life Insurance
• Developed the interface for the surrender of an insurance policy for “SBI LIFE” project using Java technologies such as “Java Server Pages, Enterprise Java Bean and Java Page Flow” on Oracle WebLogic software

Master Of Science - Ms, Information Management

Bachelor Of Technology, Computer Engineering