Mehboob Sarwar

• Manages, plans, controls, organises resources and prioritises tasks to ensure that management reporting services are delivered to meet business needs.
• Design, develop, publish, schedule and maintain various Crystal reports for different business units in Legal Aid.
• Sources, analyses and extracts data from a number of databases. Develops Microsoft SQL queries, view, functions and stored procedures to fulfill data requirements.
• Develop Power BI reports and dashboard of different KPI’s measures after creating data model and dataset using disperse sources like csv, excel, Google Analytics and SQL.
• Develops management report specifications, business analysis, change control and technical documentation.
• Coordinates user testing and manages the resolution/escalation of issues in the context of testing.

Organization Wide Survey Project

• Develop, publish, schedule and maintain analytical Power BI reports for FIMS and RiskMan incident management system as per business requirements. Also developed Document control reports using SharePoint 2010 database tables.
• Created Care Action Visit Power BI data model using Denodo VQL query.
• Provide data extract writing complex SQL quires as per business needs from data warehouse Fact, Dimension and other various data sources.
• Use Microsoft TFS and Subversion source control software to store the developed report/tabular models in the repository.

NAVIGATE

• Develop and maintain both analytical and student centric SSRS reports for Navigate student management systems. Some of the reports are Pass and Retention, Letter of Offer, Attendance List, Grade Distributions etc.
• Write data extract SQL quires as per business requirements from student management systems.

IBM Cast Iron Integration Projects

• Western Union Money Transfer data integration with MAZE database – Created castiron orchestration mapping to read a csv file from the FTP server and then insert the data in MAZE table.
• IDP OSCAR student application data integration with Salesforce – developed orchestration to read data from the XML sent by OSCAR and integrate it into Salesforce.

Client Service Model Strategic Project

• Maintain overnight ICCMS Data warehouse ETL process and checking the replication database for 450 tables and corresponding Change Data Capture (CDC) tables.
• Develop 50 new data models using ModelRight, Visio, Excel etc. as per the business needs and the changes made in the CRIS source systems.
• Maintain the Data dictionary and Data mapping using the Excel for the existing and newly developed schema objects.
• Daily ETL monitoring and fixed issues by modifying OWB packages, correcting data integrity in the source system when ETL failed.
• Developed several SQL data fix scripts in CRIS database to reduce the quarantine case counts. Count has been reduced from several thousands to hundreds.
• Modified 1 long running job from 2 hours to 10 minutes after implementing indexes. Whole ETL running time was also reduced by 2 hours.
• Prepare SQL scripts, Change Implementation Plans and work as a Release Manager for Data warehouse production migration. Migrated 3 data warehouse releases without any major issues and impact.