JEGATHEESWARAN SUNDARAVADIVEL

Client: UBS Bank, Credit Suisse Investment Bank.

• I work as a Data Engineer at UBS Wealth Management Investment Bank.
• Designed and implemented data processing pipelines using Python, PySpark, Pandas, and Matplotlib for statistical analysis and data visualization in the Azure environment.
• Developed and optimized data extraction workflows for equity and mutual fund (MF) forms, ensuring efficient data transfer to target servers.
• Migrated and optimized legacy Shell and C++ scripts to Python, improving performance and maintainability.
• Collaborated with Linux and AIX server teams for TLS upgrades, and optimized Python monitoring scripts for system health checks.
• Developed a User Access Portal using Django, PostgreSQL, Gunicorn, and Nginx, streamlining access management.
• Managed job scheduling and workflow automation using Control-M, creating and modifying job configurations via XML.
• Built and deployed multiple PySpark pipelines using Apache Airflow, enhancing data processing for the Saudi region.
• Engineered a Python-based data pipeline for seamless database migration from SQL to PostgreSQL.
• Led the migration of Python and Shell scripts to new Red Hat servers, ensuring compatibility and performance optimization.
• Automated file transfers between jump servers and IBM On-Demand (OD) for PE, SCR, and SIR files, using Shell scripting.
• Provided production support, troubleshooting Python, PySpark, and Pandas scripts to resolve system issues.
• Managed CI/CD pipelines with Bitbucket and Jenkins, ensuring smooth deployments across DEV, SIT, and UAT environments.
• Documented development progress on Confluence, updated Jira Scrum Boards, and prepared detailed deployment instructions.
• Maintained HP ALM Quality Center (QC) for project tracking and defect management.
• Worked with Azure and Odyssey cloud environments for scalable, efficient, cloud-based solutions.

Technologies: Python, PySpark, Pandas, Tkinter, Django, PostgreSQL, Git, Control-M, Apache Airflow, Azure Blob Storage, AWS S3, Odyssey, FTPS.

Client : Société Générale (SG) Bank,

• Worked for Société Générale (SG) is a global investment bank, in this project i am working as Python Senior Associate
• Developed and maintained the IPACFEF application, managing user access rights for secure server logins.
• Designed and implemented a FastAPI-based privilege access system, streamlining server access for authorized users.
• Built PySpark and Pandas-based data pipelines, optimizing data processing workflows.
• Automated job scheduling and workflow management using AutoSys, ensuring efficient data processing.
• Generated and deployed RSA keys to user machines for enhanced security.
• Automated the Impulse ticket generation process in IPACREF for managing server access requests.
• Refactored and optimized cron batch scripts, improving system efficiency and reducing execution time.
• Configured Virtual Hosting and set up UAT application servers for testing and deployment.
• Led the Linux (Red Hat) TLS upgrade, enhancing system security and compliance.
• Migrated legacy databases to IPACREF, ensuring seamless data transition.
• Developed and maintained the IPACRFF Active Directory (AD) sync process, improving authentication workflows.

Technologies: Python, PHP, PySpark, Pandas, FastAPI, PostgreSQL, Git, AutoSys, and Symfony.

Client: Schneider Electric.

Project: DigiQ (Presales and Order Booking Tool)

• Developed and maintained DigiQ, a digitized quotation and order booking tool, streamlining pre-sales and procurement processes.
• Integrated with SAP systems to fetch master data configurations via RFC connections, and automated CRON jobs.
• Implemented workflow matrices for multi-level approval processes based on discount structures and user roles.
• Ensured global application compatibility, adapting integration processes to various country-specific SAP systems.
• Automated order registration in SAP via RFC, generating Purchase Server Order Numbers, and storing them in DigiQ.
• Managed delivery scheduling based on order timelines to optimize the logistics workflow.
• Utilized Git for version control and deployment across multiple environments.

Project: Columbus (Travel Expense & Claims Management)

• Developed and maintained a travel expense and claims management system, enabling users to submit and track reimbursement requests.
• Integrated with SAP systems for seamless expense tracking and approval workflows.
• Implemented LDAP authentication for secure user access.
• Automated data fetching from AMEX servers using CRON jobs improves processing efficiency.
• Managed workflow matrices for claim approvals, ensuring compliance with company policies.
• Used Git for source code management and deployment across servers.

Technologies: Python, Pandas, PyAutoGUI, PHP, CakePHP, Oracle, Git, Cron Jobs, BMC Remedy, Linux.

Project: EduBold (School Education Management System)

• EduBold is a cloud-based SaaS application designed to streamline school and college administration by automating key operations.
• Developed and enhanced modules for student registration, admissions, fee collection, examinations, student portals, transport, library management, payroll, accounts, and inventory.
• Implemented workflow automation to optimize various school processes and sub-processes, reducing manual workload, and improving efficiency.
• Developed a parent portal to provide real-time access to student performance, attendance, and academic progress, enhancing communication between schools and parents.
• Designed a management portal with comprehensive MIS reporting, enabling administrators to track institutional performance, and generate critical insights.
• Configured and optimized the LAMP stack for application deployment and integrated MongoDB for handling unstructured data.
• Implemented Git-based version control for source code management and automated deployments to ensure seamless application updates.
• Ensured scalability and performance optimization, allowing the system to support multiple schools and colleges across different regions.

Technologies: PHP, Python, LAMP Stack, MongoDB, Git, Linux, SaaS, Cloud Deployment

Project : E-Campus (Comprehensive Education Institute Management)

• E-Campus is a 100% web-based, integrated education ERP designed to streamline institutional administration and academic operations.
• Developed modular functionalities for admissions, examinations, promotions, fee management, financial accounting, timetabling, staff payroll, library management, and inventory tracking.
• Implemented automated workflows that integrate student and staff administration modules, ensuring seamless data flow across all departments.
• Designed and maintained student individual portals to provide real-time access to exam results, attendance, fee payments, and course progress.
• Developed a semester exam publishing module, enabling students to access their results efficiently.
• Integrated hostel management features, including room allotment, transfers, and vacate requests, with an automated email notification system for administrative tracking.
• We Implemented face detection technology using .NET for student entry-exit tracking, capturing attendance via biometric authentication.
• Automated daily consolidated hostel reports are sent via email notifications to management for better oversight.
• Used SVN for version control, and managed server-side deployments efficiently.

Technologies: PHP, CakePHP, PostgreSQL, SVN, HTML, CSS, jQuery, Ajax).