Software Engineer
NeoSOFT · Jun 2026 – Aug 2026
- Project: Rule Engine Automation | Tech: MS SQL Server, PostgreSQL, Snowflake, T-SQL, Dynamic SQL, Python, Power BI Client Data: Samsung, SBI, SBI Life, Axis Bank Built and supported a rule-driven automation framework that processes client dialer, disposition, and Ops Alignment data across multiple clients and generates a cohort-level report consumed by Power BI.
- The framework was implemented on Snowflake and PostgreSQL, and designed to be reusable across clients by driving business logic from a central rules table rather than hardcoding it per client.
- Architecture Flow: Client Data -> Public -> Dump -> sync_import_data -> Process -> Rule Engine -> cohort_APR_report -> Power BI Key Contributions: • Worked on the Public layer where clients send dialer, disposition, and Ops Alignment data for processing. • Handled the Dump layer — raw dialer and disposition data was stored as-is, while Ops Alignment data was brought in through a Python-based import process. • Built and maintained sync_import_data, which dynamically processes incoming data for multiple clients — Samsung, SBI, SBI Life, and Axis Bank — across Snowflake and PostgreSQL environments. • Worked with rule_master, a table holding client-provided business formulas such as COUNT, SUM, AVG, and various filter conditions. • Contributed to a common Rule Engine built using structured SQL and dynamic SQL on Snowflake and PostgreSQL, reading formulas from rule_master and applying them to each client's processed data — allowing the same framework to be reused across clients without rewriting logic. • Ensured final rule-engine output was correctly written into cohort_APR_report, the table consumed downstream by Power BI dashboards. • Validated processed and rule-engine output against source data across clients





