Worked on development of following BI Dashboards:(a). Litigation Management System (LMS) Dashboard for Attorney General (b). Trace and Trace Dashboard(c). Sales Tax Refund Dashboard(d). Revenue Analysis Dashboard(e). Notices Dashboard(f). TAX-RAY Dashboard(g). Physical Survey Dashboard(h). Ponit-of-Sale (POS) Dashboard(i). Audit Monthly Progress Report (MPR) Dashboard(j). FASTER Dashboard (k). Risk Based Audit Management System(l). Iris-WRIT (Withholding Real Time Information Tracker)(m). Iris Dashboard (n). Citizen Dashboard(o). Sales Tax & Federal Excise BI Dashboard(p). Executive Dashboard for Customs (q). Revenue Collection Dashboard

FBR’s National Data Warehouse is maintaining Pakistani Taxpayers historical data from 2000 onward with the foremost objective of revenue growth and expansion of tax base. These objectives are achieved through rigorous analysis of tax information, identification of gaps and policy improvements through application of cause-and-effect analysis. Tax data is combined with external agencies data to build 3600 view of taxpayer’s financial net worth. Specially designed ETLs processes extract tax data (of Income Tax, Sales Tax, Federal Excise Duty and Import Duty domains) from transaction systems, transform it into star-schema data structures and load into Data Warehouse overnight. This data is also cleansed prior to loading in EDW, and populating BI cubes. The EDW is used to prepare analysis, assessment, enforcement and forecasting reports through use of comparative and statistical analysis techniques.

Annual Audit Selection: (2007-2013)This is a rigorous annual exercise performed by FBR and involves selection of taxpayers for field Audit based on taxpayers data of declarations and revenue collection for past several years. Risk based parametric selection of taxpayers is performed from each business sector, geographical local and type of taxpayer to create a homogeneous data sample. Technically this involves complex data processing routines and preparation of details sheets having particular risk based selection criteria, individual taxpayers risk score and criteria to support decision for audit selection.FBR Collection Automation Project (CAP):In year 2007, the FBR decided to automate tax collection processes by SBP and NBP banks by issuance of Computerized Payment Receipt to taxpayer as part of Tax Administration Reforms Program (TARP). The project rolled out in nation-wide branches of SBP and NBP yielding;• Up to seventy percent improvement in data quality• End of the month revenue reporting time reduced from over six weeks to seventy two hours • Capability to produce many analytical and statistical reports with greater accuracyActivities Performed:• Development of Forms and Reports. • Dashboard creation in Apex 3.3.• Assist team members in Software Development assignments.• Ad-hoc reporting to stakeholders.• Data loading and consolidation into main repository, data received from all SBP and NBP branches on daily basis.• Data Dissemination to field offices.• Data Analysis. • Data Backups.• Technical Documentation.• Official Correspondence.Applied Technologies:Oracle Developer 6i/10g, Query Builder, Toad, Oracle Discoverer 10g, Oracle Application Express (Apex 3.3), Oracle DB 9i/10g, SQL, PL/SQL.

Responsibilities Include:• Development of Forms and Reports. • Data Dissemination to field offices.• Documentation.• Official Correspondence.Projects include: Payroll System, Oil Accounting System, Hospital Billing System, Shares System, Computer Complaints System, Inventory System, Sales and Purchase Enquiry System and ID Card System.Applied Technologies: Oracle 9i, Developer 6i.