As a System Engineer with 2 years of professional experience and a recent graduate with a Master's degree in Computer Science, I am fluent in Python, Java, SQL, and ETL processes using Informatica Power Center, with expertise in AWS and data visualization through Power BI. I am known for strong communication skills and teamwork, with a proven ability to analyze complex issues and work effectively with both technical and non-technical.
Data Center Management: Oversaw the operations of physical and virtual data centers, ensuring high performance and reliability.
Client Collaboration: Worked with RWE Supply and Trading, a leading German client, to provide seamless data center solutions.
Technical Proficiency: Utilized VMware vSphere and vSAN to enhance data centre efficiency and performance.
Automation and Scripting: Developed scripts to automate health checks for VMware servers and facilitate the creation of virtual machines, significantly improving operational efficiency.
Cross-functional coordination: Collaborated with storage and network teams to ensure server connectivity and integration, enhancing infrastructure stability.
Project Oversight: Employed Jira to track daily updates and tasks and optimise project workflows and communication.
Project Overview: Developed a comprehensive data pipeline to analyze housing market trends and predict future property values, providing insights for real estate investors and urban planners.
Data Extraction: Utilized Informatica to extract housing data from multiple online sources, including real estate listings, public records, and market reports, ensuring a robust and diverse dataset.
Data Processing: Employed PySpark to process and transform large volumes of data, performing data cleansing, feature engineering, and enrichment to ensure accuracy and consistency.
Workflow Orchestration: Implemented Apache Airflow to automate and schedule data extraction and processing tasks, enabling efficient data integration and regular updates.
Data Storage: Used AWS S3 for intermediate data storage and loaded processed data into Amazon Redshift for structured storage, enabling advanced querying and analysis.
Database Management: Utilized SQL to manage and query data within Redshift, optimizing performance for efficient retrieval and analysis of housing market trends.
Statistical Analysis: Imported machine learning functions to compute key statistical measures such as mean, variance, and standard deviation to assess housing market data and trends.
Data Visualization: Created interactive dashboards using Power BI to visualize market trends, price distributions, and statistical insights.
Published a major project on "Spectrum Sensing in OFDM Using Energy Detection" in IEEE during my undergraduate studies.
https://ieeexplore.ieee.org/document/9155728
Vice President, Indian Graduate Student Organization: Enhanced the graduate student experience at SUNY Binghamton by organizing cultural and educational events.
Campus Cricket Team: Led the team for two years, contributing to its success with strategic leadership and teamwork.
Volunteer, Student Social Responsibility: Educated communities in India on blood donation and environmental cleanliness, promoting social responsibility.