Sokol Ramaj

Responsible for managing and handling data and data models for their Analytics Teams. Manipulate and analyze data in a variety of formats. Create and update data models to use with data mining tools Develop scripts for data file processing and process integration tasks. Troubleshoot and optimize ETL code; interpret ETL logs, perform data validation Provide assistance with ETL design, development, and performance tuning Create Data life cycle management procedures

Assist in identifying potential revenue leakages, and support investigations to reduce or recover losses Follow constantly changing procedures and product catalogs to minimize company losses Develop and maintain In-house Parallel Charging Systems. Define data models for Data Mining process. Day-to-day data analysis and internal audits for RA, data mining, analysis, reporting, validating rating /charging aspects

Install, configure, upgrade and maintain Oracle database environments. Write Linux shell scripts to automate database maintenance functions. Perform database tuning and performance monitoring. Oracle Database problem diagnosis and resolution. Database capacity monitoring and planning. Implement Backup & Recovery process using RMAN scripts. Data Migrations using Oracle Data pump (EXPDP, IMPDP) Develop In-house ETL software to populate Data Warehouse and other enterprise systems.

Developing PL/SQL packages and procedures to generate reports and metrics to track data consistency in platforms as Billing, MSC, SMSC, SGSN, GGSN, and Radius. Administrating Subex’s Nikira Fraud Management System. Creating rules according to business decision. Creating data-marts to monitor subscriber daily traffic and link analysis Analyzing subscriber behavior and applying thresholds. Develop and maintenance of SIMBox and Bypass fraud detection tools