Client All Connectiva's Clients (like AIRTEL, IDEA, STC, TMOBILE, TSTT, TUNE TALK, VIDEOTRON, YTL, WATANIYA, ZAIN)Responsibilities Developed many database stored procedures & functions. Troubles shoot different PL/SQL problem and Providing technical solutions. Also handle different SQL performance tuning & Database related problems.Team Size 35Software used Oracle PL/SQL, DataStageProject Details Telecom service providers loses a part of their revenue due to different types of fraud and leakage. IRMS(Integrated Revenue Management Systems) is a Connectiva Revenue Assurance product which takes data or CDR as input from different telecom sources such as SWITCH, IN, HLR etc and find the revenue leakage of the client with the help of ETL server. ETL server extract the data and apply some transformation, business rules on it and then upload the data in to different target tables. Through the reconciliation of different target tables of different data source, it find out the differences as leakage. Smart 2. ProjectCompany PriceWaterHouseCoopers (PwC)Client PwC (US)Responsibilities Developed many database stored procedures, packages & functions.Team Size 10Software used Oracle PL/SQL FAMS 3. Project

Duration 6 MonthsTeam Size 5Software used ASP, SQL Server.Description Hospital Management.

Duration 10 MonthsTeam Size 12Software used VB, ASP, SQL Server.Description An ERP System. Lions Hospital Management System 4. Project

Duration 6 MonthsTeam Size 4Software used VB, Oracle.Description Office automation system www.wbfdc.com