Projects
Data delivery and automation (Python, Selenium, bs4, snowflakeDB)
- Automated scripts to extract sales and auction details of heavy equipment in US and Canada.
- Created scrapers for new websites and managed data formatting and validation.
- Ensured timely delivery of client requirements and maintained automation scripts..
- Validated and modified data as per requirements before pushing it into the client database.
- Played a key role in ensuring accurate and up-to-date information for users.
Data Inventory Model (R, Big Data Analysis)
- This project underscored the critical role of descriptive analysis in identifying business inefficiencies and charting a course for strategic improvements.
- Applied advanced big data analysis methodologies to unearth valuable insights and patterns within the expansive datasets.
- Orchestrated the design and implementation of robust data cleaning and preprocessing pipelines to ensure data integrity and quality.
- Utilized statistical analysis and visualization techniques to present key findings and trends, providing actionable recommendations for enhancing business performance and improving historical data accuracy.
CSV validation, OCI Migration (Python, Oracle DB):
- Developed an automated system for data collection, validation, and migration.
- Implemented cronjobs for scheduled execution and tested API data for accuracy.
- Managed backend code maintenance and migration processes.
Crypto Model (R, SQL)
- Developed an automated algorithm to analyze cryptocurrency cycles, indicators, and trends.
- Wrote code to test and optimize the algorithm for various currencies.
- Conducted data collection from client databases and performed data cleaning.
- Deployed the algorithm to run daily and store output tables in SQL.
IoT Based Puzzle Car Parking System (Python, SQL)
- Designed and implemented a PLC-based automatic car parking system with IoT integration.
- Managed data collection, cleaning, and database management using Python libraries.
- Conducted data analysis using pandas, NumPy, and matplotlib for insights generation.
- Ensured smooth execution of daily operations and prepared regular reports for stakeholders.