Manish Kumar

Experience

• 

  Groomefy

  Feb 2019 - May 2019

  Machine Learning Data Analyst

  • Collaborated with SAS Programmers to resolve data cleaning and preparation tasks for machine learning models.• Developed Python scripts to classify images for machine learning model training.• Managed and manipulated large datasets in Excel before system entry.• Developed Python scripts to automate data cleaning and preprocessing tasks directly within Excel spreadsheets, streamlining the preparation process for analysis and model training• Converted Excel files to JSON format to create searchable attributes.• Uploaded data to MongoDB servers and extracted it using Studio 3T.• Oversaw data management for cataloging and machine learning projects. Show less

• 

  Seair Exim Solutions

  May 2019 - Jan 2021

  Data Analyst

  • Worked with Database Admin to address issues, enhance operations, and deliver outstanding customer service for global import-export trade data.• Developed and implemented Python code leveraging Selenium WebDriver, reducing human effort in web scraping and data insertion to SQL Server databases by approximately 90%.• Standardized supplier data by correcting multiple spellings and misspellings using an anagram algorithm implemented with Python and SQL Server.• Developed a Python script capable of dynamically executing SQL queries retrieved from an Excel file, processing them on SQL Server, saving the output to Excel with corresponding filenames, and triggering VBA scripts for formatting automation.• Ensured data accuracy by promptly rectifying entry errors, preventing potential issues like duplication or degradation.• Automated file handling and cleaning using python.• Power user of Excel, and Google Spreadsheets.• Created Emailer on Google Cloud Platform for sending 100's of emails with attachments in few minutes from Google Spreadsheets using Google Apps Script.• Streamlined web scraping operations using Python and Selenium, effectively populating null records sourced from websites.• Investigated and resolved data integrity concerns using Python.• Developed Python scripts with xlwings to clean Excel files containing extensive data.• Developed a VBA macro proficient in converting HTML files into Excel format, enhancing data processing efficiency.• Created data visualization reports using matplotlib.• Deployed SQL database components including tables, views, and procedure views. Formulated comprehensive schema data models to optimize database structure and functionality. Show less

• 

  Biz2Credit

  Jan 2021 - Feb 2022

  SQL Developer

  • Managed AWS RDS instances, executing comprehensive backup strategies and performing point-in-time restorations to ensure data durability and rapid recovery from data loss incidents.• Optimize database performance, test databases and perform bug fixes.• Provide administration, authentication and authorizations for Database.• Understanding and collecting requirements from Business user side or Business Analyst and convert that requirement to SQL queries.• Actively engaging with developers to understand and resolve database issues promptly, fostering efficient problem-solving and optimizing application performance.• Implemented Python scripts to monitor MySQL replication status, detecting and alerting on replication failures in real-time, thereby enabling proactive resolution of issues and ensuring data consistency across distributed databases.• Designing databases and ensuring their stability, reliability, and performance.• Fix any issues related to database performance and provide corrective measures. • Developed and implemented shell scripts to automate daily MySQL database backups, ensuring data integrity and facilitating efficient disaster recovery processes.• Develop best practices for database design and development activities.• High availability solutions for MySQL and MongoDB servers, including replication, clustering, and failover mechanisms, guaranteeing continuous availability and minimizing downtime for critical data services.• Performed execution of online DDL commands on production servers in accordance with development requirements, ensuring minimal disruption to operations and maintaining data consistency and availability. Show less

• 

  Birdeye

  Feb 2022 - now

  Database Solution Engineer

  • Own and support all databases including Production, QA, and Dev 24x7, ensuring high availability, data integrity, and disaster recovery• Managing a diverse database environment including AWS RDS with MySQL engine, MySQL and MongoDB on EC2, and Aerospike, providing optimal performance and point-in-time recovery• Installing and configuring MySQL, MariaDB and MongoDB replication on EC2 servers, ensuring high availability, disaster recovery, and backup recovery• Executed DDL operations on terabyte-scale tables using pt-online-schema-change (pt-osc) and online DDL techniques, ensuring minimal disruption• Monitoring solutions like Zabbix to track database performance and proactively resolve issues• Enabled Advanced Encryption Standard (AES) encryption for EBS volumes to secure data at rest for MySQL production databases, utilizing a rolling upgrade method to maintain continuous availability and avoid downtime• Enhanced database security by transitioning from conventional database users to AWS Security Manager for centralized secret management• Achieved zero-downtime relocation of MySQL production read replicas to different availability zones, enhance disaster recovery and high availability• Established replication instances between AWS and GCP for MongoDB and MySQL, boosting disaster recovery and high availability across cloud platforms• Created Redash dashboards to publish slow query logs and provide query optimization insights• Implemented comprehensive backup policies using Percona xtrabackup, mysqldump, mongodump, and AWS EBS snapshots.• Developed custom Python scripts for task failure notifications, data inconsistency alerts, and monitor MySQL replication status• Designing high-performance database schemas for large volumes of data, maintained databases, increased data storage capacity, and troubleshot database functionality issues• Providing administration, authentication, and authorizations for databases, ensuring secure and efficient access control Show less