Mintu Kumar

Background

About Mintu Kumar

BCA from Meerut University with 10 years experience in VBA Development, Automation Specialist, Data Analyst, and Power BI. 4 Year experience in Python (Pandas, NumPy, Scrapy, Beautiful Soup, Selenium, Seaborn, Matplotlib, Tkinter), Spark on Databricks (Spark SQL, Dataframe), and DSA. Machine Learning Specialization: Develop and maintain Python-based web scrapers and crawlers to extract structured and unstructured data from websites using libraries like Scrapy, BeautifulSoup, Puppeteer, and Selenium and data cleaning and analyzing using Pandas and NumPy. Design and implement ETL processes to extract data from various sources, transform it according to business rules, and load it into target databases (MySQL, PostgreSQL and SQL Server) or data warehouses (AWS). Develop Python scripts and functions to clean, preprocess, data manipulation, and transform raw data into formats suitable for analysis and modeling Develop machine learning models using Python libraries such as scikit-learn. Develop interactive dashboards and visualizations using Python visualization libraries (Matplotlib, Seaborn, Plotly) or web frameworks (Streamlit). Worked on Agile methodologies within a DevOps context, participate in daily stand-up meetings led by the project manager, involving developers, operations engineers, testers, and other stakeholders for completed tasks, ongoing work, bugs, task allocation and any obstacles or challenges encountered. Create desktop application tools within MS Access, design and generate different type Query, Forms, Reports, Macros and integrate to SQL Server as backend database. Writing and debugging VBA code within MS Access to automate tasks, enhance functionality, and improve user interface. Develop VBA macros and scripts in Microsoft Excel, Access, and other Office applications to automate repetitive tasks and improve efficiency. Maintain and enhance existing VBA codebase, ensuring compatibility and functionality across different versions of Office. Create user-friendly interfaces and reports using VBA to facilitate data analysis and decision-making processes. Create VB scripts to integrate to SQL Server database for retrieve, manipulating data Create database schemas, tables, indexes, views, and stored procedures. Debug and troubleshoot issues related to SQL queries and database performance Develop custom applications within MS Access to meet specific business requirements. Perform regular database maintenance tasks such as compacting and repairing databases Design and create user-friendly forms and interfaces for data entry and navigation.