Key Roles and Responsibilities:
1. Process Discovery and Solution Design
Partner with Operations, Planning, Reporting and other stakeholders to understand workflows, pain points, business rules, inputs, outputs and control requirements.
Document the current-state process, identify automation opportunities, and design a practical future-state workflow.
Assess feasibility, dependencies, exceptions, risks and expected advantages before development begins.
Convert business requirements into clear technical specifications, acceptance criteria and delivery plans.
2. Automation Development
Develop automations that import, validate, transform and export data between Excel, MS SQL databases, email attachments, shared folders, web sources and approved applications.
Build Python-based solutions using relevant libraries such as Pandas, SQLAlchemy, Selenium, Beautiful Soup, PyTest, Matplotlib and suitable GUI frameworks.
Develop and maintain Excel/VBA automations, advanced formulas and reporting tools for recurring operational requirements.
Create user-friendly interfaces,



configuration controls and process flows where business users require guided execution.
Use modular, object-oriented and reusable design practices to improve maintainability and scalability.
3. Reporting and Data Automation
Automate existing and new reporting requirements while keeping outputs standardized and flexible enough for approved business changes.
Create controlled data pipelines and scheduled workflows that reduce repetitive effort and manual handling.
Validate source-to-output reconciliation, data completeness, transformation logic and exception handling.
Coordinate with BI and reporting teams where automation feeds dashboards, scorecards or client deliverables.
4. Testing, Deployment and Production Support
Prepare test scenarios and perform functional, regression, negative and volume testing before release.
Coordinate user acceptance testing, capture approvals and implement production releases throug

📌 Automation Specialist (Ahmedabad)
🏢 Advantmed India
📍 Ahmedabad