SAJIL LIDHAN

1. Business Requirements Analysis

• Collaborated with telecom clients to analyze requirements for customer promotions and mobile plans
• Translated complex business logic into structured JSON rule definitions with condition-action workflows
• Ensured system scalability while maintaining alignment with client business objectives

2. Rule Processing Architecture

• Engineered conversion system between JSON rule definitions and XML processing format
• Designed flexible data mapping architecture connecting business rules to multiple database systems
• Integrated with MySQL, Oracle, Hive and HBase through dynamic profile-column mapping

3. ETL Pipeline Development

• Implemented Pentaho KTR workflows to generate optimized SQL queries
• Configured Redisson caching server to improve system performance
• Automated data transformation processes between different formats

4. Automation Script Development

• Built Python scripts for automated customer segmentation
• Eliminated manual steps in customer data processing

5. Third-Party System Integration

• Integrated external APIs for executing customer promotions
• Ensured reliable delivery of customer benefits and bonuses

6. System Deployment

• Deployed solutions on Kubernetes and standalone systems
• Maintained CI/CD pipelines for seamless updates

7.System Maintenance

• Improved business logic through iterative development
• Conducted cross-environment testing and validation

8. Technical Documentation

• Documented system architecture and integration specs
• Created deployment procedures and schema references