Latest Projects

IFRS Reporting

Led the design and development of the GL Extraction Project orchestrating the extraction of finance transactional data from an Oracle database. Utilized SQL queries within Java to efficiently generate files containing the necessary financial transactions for integration with the ARRE System.

javasqllinux

Provisioning - API Integration

Developed a Python Tool for the Provisioning Team to manage Home Location Register (HLR) operations efficiently. Integrated with an API to update, delete, and swap subscriber information, streamlining telecom provisioning processes. Deployed the tool on Redhat Linux for reliable and efficient operation.

pythonlinux

Bulk MSISDN Swapping (LNP)

Automated the comprehensive data retrieval and cleaning, utilizing Python libraries such as Pandas and NumPy to ensure accuracy. Executing SQL queries to generate MSISDNS and crafting a vital EPM script for bulk MSISDN swaps, I ensured operational resilience, during Syniverse outages.

pythonsqllinux

Financial Data Analysis Tool

Designed and developed a Python CLI tool to analyze GL files generated for each bill run. Leveraging Pandas and NumPy, it extracts insights into trends, and anomalies, producing text-based reports. Additionally, implemented anomaly detection algorithms to identify irregularities and sending email alerts.

pythonsql

Command-Line Tool akin to Alteryx

Created a tool to automate file analysis from current bill runs, matching data with an Oracle database via SQL queries. Integrated email alerts for stakeholders. Utilized Python, Pandas, and NumPy to streamline data processing tasks, improving efficiency in financial workflows by facilitating database interactions.

pythonsqllinux

Automating Pre BillRun Reports

Leveraging Python scripting, the project significantly reduced manual processing time by automating the generation of comprehensive reports, ensuring accuracy and efficiency in billing activities. Automated data validation and analysis techniques were implemented to enhance revenue assurance practices, further streamlining operations.

pythonsqllinux

Independent Projects

RESTful API Development

Developed a robust RESTful API for an e-commerce platform using Python and Flask, integrating Docker for containerization and Flask-Smorest for API documentation. Leveraged Flask-SQLAlchemy for efficient ORM and Redis for caching, enhancing API performance. Utilized OpenAPI for API specification, ensuring clear communication and seamless integration with front-end applications. Successfully implemented CRUD operations for managing products, tags and user accounts, delivering a scalable and well-documented solution.