Home
Jobs
Rexus Group logo

Python Developer – VB Script Modernization

0 years

0 Lacs

India

Posted:1 week ago| Platform: Linkedin logo

Apply

Skills Required

python developer script visual planning checks automate reporting processing analysis data reports testing integration report deployment maintenance design architecture automation logging troubleshooting interface configuration dashboard technology stack development excel authentication test linux documentation installation code support git tracking collaborative

Work Mode

On-site

Job Type

Contractual

Job Description

Scope of work: Visual Basics Script to Python 1. Planning 1.1 Objective Recreate the functionality of the original script using Python to perform normality checks, automate email reporting, and log processing. 1.2 Requirement Analysis 1.2.1 Input/Output Requirements Input: CSV files, system configurations, or other data sources. Output: Generated reports, emails, and logs. 1.2.2 System Requirements Python 3.x Dependencies: pandas, openpyxl, smtplib, os, etc. 1.3 Milestones Script conversion to Python. Functional testing of email integration and report generation. Deployment and maintenance. 2. Design 2.1 System Architecture Core functionality divided into modules: Data Processing Module: Parses input files and validates data. Report Generation Module: Generates normality check reports. Email Automation Module: Sends reports via email. Error Logging Module: Logs errors for troubleshooting. 2.2 User Interface • Console-based interaction for configuration, with optional integration into a web-based dashboard. 3. Technology Stack 3.1 Python Libraries Data handling: pandas, os, csv. Email: smtplib, email. File processing: openpyxl, xlsxwriter. 4. Develoment 4.1 Setup and Configuration Initialize the Python project with appropriate file structure. Create a configuration file (config.json or .env) for constants like email credentials and paths. 4.2 Script Development 4.2.1 Data Handling Read and validate input files (e.g., CSV/Excel). Handle missing or malformed data. 4.2.2 Report Generation Use pandas to create data summaries or normality checks. Save output as .xlsx or .pdf. 4.2.3 Email Automation Integrate smtplib to send emails with attachments. Ensure secure authentication (e.g., TLS/SSL). 4.2.4 Error Handling and Logging 1. Implement structured logging using logging module. 5. Testing 5.1 Unit Testing Test individual functions for data processing, report generation, and email sending. 5.2 Integration Testing Verify end-to-end functionality, ensuring compatibility between modules. 5.3 Environment Compatibility Testing Validate functionality across different OS environments (Windows, Linux). 5.4 Performance Testing Ensure the script handles large datasets efficiently. 6. Deployment 6.1 Documentation Create a comprehensive user manual with steps for installation and execution. Document code using inline comments and docstrings. 6.2 Environment Setup Provide a requirements file (requirements.txt) for dependencies. Package the script for easy deployment using PyInstaller or similar tools. 7. Maintenance and Support 7.1 Version Control Use Git for version tracking and collaborative development. 7.2 Updates and Bug Fixes Periodically review the script for improvements and new features. 7.3 Support • Provide ongoing support for troubleshooting and issue resolution. Show more Show less

More Jobs at Rexus Group

Data Analyst Intern

Mumbai, Maharashtra, India

Experience: Not specified

|

Salary: Not disclosed

Human Resources Intern

Mumbai, Maharashtra, India

Experience: Not specified

|

Salary: Not disclosed

Human Resources Intern

Mumbai, Maharashtra, India

Experience: Not specified

|

Salary: Not disclosed

Human Resources Intern

Mumbai, Maharashtra, India

Experience: Not specified

|

Salary: Not disclosed

Software Engineer Intern

Mumbai Metropolitan Region

5.0 - 5.0 yrs
|

Salary: Not disclosed

Mock Interview

Practice Video Interview with JobPe AI

Start Python Interview Now

My Connections Rexus Group

Download Chrome Extension (See your connection in the Rexus Group )

chrome image
Download Now
Rexus Group
Rexus Group

18 Jobs

RecommendedJobs for You

Rexus Group logo

Python Developer – VB Script Modernization

Rexus Group

India

Rexus Group logo

Python Developer – VB Script Modernization

Rexus Group

India

Rexus Group logo

Python Developer – VB Script Modernization

Rexus Group

India

Rexus Group logo

Python Developer – VB Script Modernization

Rexus Group

India