Data Analyst Intern
Bayer Crop Science
May 2023 - Present
I developed an automated decision dashboard for biological phenotypic experiments in disease, pest, and weed control teams, resulting in a 25% improvement in overall efficiency by eliminating manual work. The dashboard efficiently queried data from the Crop Science Warehouse in JSON format using Google BigQuery and Python, allowing for easy data flattening. The user-friendly dashboard incorporated advanced filtering options and interactive visualizations using plotly dash, enabling users to review, rearrange, and download experiment summaries in PNG and Excel formats. The application was deployed using Domino Data Lab, facilitating day-to-day experimental analysis. Throughout the project, I actively engaged with a team of scientists, incorporating their feedback and insights to ensure successful adoption by end users.
Programmer Analyst
Meditab Software Pvt. Ltd.
January 2021 - October 2021
My expertise lies in leveraging SQL and PowerScript to build and enhance various product features. I have developed complex SQL queries, incorporating multiple joins and Data Window to present user-friendly information. Additionally, I possess strong data analysis skills, using Python libraries to create customized reports that address clients' specific needs. One of my key achievements has been optimizing legacy SQL queries by implementing modern SQL functionalities such as window functions and Common Table Expressions (CTE), significantly improving query performance by 50-70%. Moreover, I have taken charge of aggregating bug reports for team members, efficiently tracking bug resolution progress and presenting it in weekly meetings. My proficiency extends to maintaining stored procedures and procedural codes, ensuring the seamless functioning of both frontend and backend components of Intelligent Medical software.
Research Intern
CHARUSAT University
May 2020 - August 2020
I am an experienced database developer skilled in MS Access, MySQL, and Azure MySQL. I designed, developed, and deployed a database for department students and alumni. Utilizing Azure Data Factory, I created ETL pipelines to maintain an active data warehouse, categorizing students and alumni for outreach activities. With Power BI and Azure, I automated dynamic dashboards to track various KPIs for outreach. This provided real-time insights to optimize strategies. My expertise in database management and automation ensures accurate and accessible data, enabling informed decision-making. I am dedicated to delivering efficient solutions for managing student and alumni records while enhancing outreach efforts for the department.
