Technical Leader, Senior Associate-Performance Information, Senior Process Executive - Operations

Client: Automotive Electronic Manufacture
Environment: Python 3, Excel, VBA, Word, MySQL, Redmine, phpmyadmin, JIRA, Testlink | Team Size: IC
(Individual Contributor)
Technical Leader
* Collaborated with internal teams and management to comprehend user requirements, offering
technical solutions, and automating routine tasks to enhance efficiency.
* Automated data extraction from JIRA, Redmine, Planio, and Testlink using Python modules such
as Redminelib, testlink, jira, and multithreading.
* Implemented a script utilizing socket programming to fetch data from the server directly.
* Developed an intranet management dashboard, accessible at a central location (with specific
IP), using Python.
* Created a GUI application with Python using the Tkinter module.
* Functioned as the administrator for Redmine version 2.4.2, managing project creation,
trackers, workflow, and roles according to real-time requirements.
* Managed MySQL database operations through phpMyAdmin for the Redmine tool.
* Designed and developed issue synchronization between client and internal web portals using
Redmine API and Python.
* Crafted customized macros to generate multiple reports from a single file for weekly customer
releases, resulting in significant time savings.
* Retrieved data from the database using MySQL queries.
* Created VBA macros based on requests from management and various teams across projects.
* Automated the daily calibration package creation process with Python scripts, allowing
packages to be built as per required parameters.
* Developed Python auto scripts to interact with an SQLite database, efficiently storing data
extracted from Redmine and Testlink tools.

Client: Global Dispute Reporting
Environment: SAP (System Application Product), Excel, Power point, Minitab 15, BW Template
Senior Associate-Performance Information
* Managed MIS reports for the Dispute Team globally, ensuring delivery accuracy.
* Maintained and updated daily trackers and log files for Daily, Weekly, Monthly, and Ad-hoc
reports.
* Supported ad-hoc reporting requirements as needed, demonstrating flexibility in responding to
changing needs.
* Provided support for client reporting activities, ensuring client-specific reporting needs
were met.
* Supported internal reporting activities, adhering to a report calendar and ensuring timely
delivery of scheduled reports to management teams.
* Prepared critical weekly and monthly reports, including Service Level Agreements (SLA)
reports.
* Utilized Minitab 15 for generating charts and data visualization.
* Scheduled data extraction in SAP to ensure accurate data retrieval, even in the absence of
team members.
* Created customized delivery templates and contributed to process automation using tools such
as MS Excel formulas and Visual Basic Application (VBA Macro).
* Produced comprehensive documentation for all activities, including SOP and IOP.

Client: British-Australian multinational (Accounts Payable - MIS Team)
Environment: SAP 6.0 (System Application Product), Excel, Power point | Role: Subject Matter Expert
(SME)
Senior Process Executive - Operations
* Oversaw MIS reports for the client's Accounts Payable department, ensuring accuracy and
timeliness.
* Addressed ad-hoc change requests and handled escalations within the team.
* Provided daily reports to clients and promptly addressed ad-hoc requests as needed.
* Prepared and disseminated Daily, Weekly, and Monthly Reports to both internal teams and
clients.
* Published daily Status reports, including Production Reports and invoice pending Reports.
* Collected data from various departments and integrated it into consolidated weekly and monthly
presentations (PPT files).
* Produced critical weekly and monthly reports such as CSL-KPI, SLA, and Web cycle reminder
reports for Site supervisors.
* Implemented automation using Excel formulas and VBA code to enhance efficiency and reduce
manual workload.