Amogh Katwe Email & Phone Number

Dallas, TX, US

Purchase, NY, US

Irving, TX, US

• Lead a clinical dashboard project from acquiring requirements from stakeholders, analyzing data and creating the visualization for the dashboard using MicroStrategy
• Built a web application using Python and Streamlit that automates hospital survey and calculates survey points for each facility and stores them on to the SQLServer database
• Implemented multiple excel and microstrategy report automation using selenium and sharing screenshots using python’s SMTP library
• Lead COVID related tasks by querying, analyzing, validating and automating reports for multiple geo-locations
• Worked on cataloging data present in the data lake which will help the team understand what data is available for use
• Develop python scripts that will collect all the logs in debug mode and store them to a file

Austin, Texas, US

• Implemented a new rewards feature for the app using python, that will provide customers with an extra referral bonus
• Built daily, weekly & monthly reports using python for the executives that would provide customer and finance insights
• Updated the backend Mongo dB to keep data in sync with the bank
• Re-write the legacy reporting JavaScript code in Python
• Designed new protocols/methods for ingesting customer's data & storing them in the backend dB & feed them to the API

London, England, GB

• Optimized truck utilization by implementing grid search ARIMA model that predicts and automates upcoming orders
• Build a statistical model using daily consumption data to optimize tank allocation, eliminate product out-runs, reduce urgent orders and allow pro-active communication using a notification system.
• Develop and maintain end-to-end data pipelines using pachyderm that automates the data ingestion, pre-processing & model building process
• Build and maintain SQL scripts on Dremio that are used to display aggregated order data through visualizations
• Apply statistics & data science methods on historical data to find order patterns and customer ratability
• Present actionable insights to business stakeholders on historical sales data to understand customer order & delivery patterns using Tableau

Boston, MA, US

• Technology: SAP, Excel
• Used SAP to order supplies and manage procurements for research laboratories.
• Manage grants for the department and made it available to the faculty members.
• Coordinate the weekly seminars on research topics for Biochemistry department.
• Communicate with the third party vendors regarding the order details.

Wilmington, Massachusetts, US

• Technology: R, Power BI (DAX), SAP and Daptiv.
• Determined the source of the data, coordinated extraction and acquisition
• Performed EDA and statistical analysis on CapEx and OpEx budgets using R
• Collaborated with stakeholders to automate the process of weekly revenue generation reports and created Business Requirements Document
• Developed BI reports which alerted the teams and ensured projects were completed within the allocated budget
• Developed interactive dashboards on Power BI to view weekly revenue by different users

Master Of Science - Ms, Computer Science

Bachelor Of Engineering (Be), Computer Science