• Creating and Managing Datawarehouse and BI Solutions for POS (Point of Sales) and HR (Human Resource) Systems.• Creating Datawarehouse (Star and Snowflake Schemas) on MS SQL Server• Extracting, Transforming and Loading data from other sources like MySQL via ETL and TSQLmethods.• Designing Tabular Cube using SSAS on MS Visual Studio to perform Analytics on the data.• Creating new Measures and KPI using DAX on SSAS / PowerBI• Creating Power BI Dashboards / Excel Report getting data from Tabular Cube or SQL StoredProcedures and Views.• Fetching Tabular Cube Data directly from SQL Analysis Server using MDX Language.• Monitoring and Managing Data Base / BI Cube Performance by performing DBA Tasks.

• Managing Sales Systems (S&D Pro) by providing end to end support to the users in coordinationwith local and international vendors and business support departments.• Coordinating closely with SD & MM Teams for the Master Data availability in S&D Pro Systems.• Providing extensive Application Support by resolving tickets in given ETA.• Troubleshooting and rectifying issues/bugs reported during operations to ensure continuity of the business with minimal downtime and involvement of Regional Team / Vendors.• Coordinating closely with Business Users for understanding their business needs and translating themto vendors for enhancements in current systems.• Testing new enhancements and planning/providing training to business users.• Providing inhouse solutions where possible to save customization cost for the Company.• Designing SQL Views / Procedures and sharing Data Insights to Management through Excel Reportsand Power BI Dashboards.• Negotiating and getting Sign Off from vendors on Customizations and SLAs.• Did R&D on Android base Handheld Terminals purchase for our Sales Reps.• Coordinated with Procurement for the timely procurement of the SRs Devices and dispatching it to all36 locations Pan Pakistan with proper Asset Tagging.• Set up Mobile Device Management Software (SOTI - MobiControl) for managing and controlling HHTs.• Managing complete process of R&M of the Devices, Reporting Lost/Stolen cases and claims adjustmentin coordination with Security Admins and Insurance Team.• Defining different SOPs for improving IT Processes.• Implemented DB Backups and DB Monitoring Jobs to avoid any data loss.

• Assigned for Requirement Gathering, Blueprint Creation, Project PlanCreation, Deployment and Training Plans for successful training and rollingout of new Sales System (Android Based - SalesBuzz) in Pan Pakistan (36 locations - 420+ users).• Managing Sales Systems (both Primary - SalesBuzz & Secondary - S&D Pro) by providing end to end support to the users in coordination with localand international vendors and business support departments.• Providing extensive Application Support by resolving tickets in given ETA.• Coordinating closely with SAP SD & SAP MM Teams (local / international) for the Master Data availability following from SAP to SalesBuzz and S&D ProSystems.• Troubleshooting and Rectifying issues/bugs reported during operations to ensure continuity of the business with minimal downtime and involvementof Regional Team / Vendors.• Coordinating closely with Business Users for understanding their business needs and translating them to vendors for enhancements in currentsystems.• Testing new enhancements and planning/providing training to business users.• Providing inhouse solutions where possible to save customization cost for the Company.• Designing SQL Views / Procedures and sharing Data Insights to Management through Excel Reports and Power BI Dashboards.• Negotiating and getting Sign Off from vendors on Customizations and SLAs.• Did R&D on Android base Handheld Terminals purchase for our SalesReps.• Coordinated with Procurement for the timely procurement of the SRsDevices and dispatching it to all 36 locations Pan Pakistan with properAsset Tagging.• Set up Mobile Device Management Software (SOTI - MobiControl) for managing and controlling HHTs.• Defining different SOPs for improving IT Processes.• SPOC from Abudawood Pakistan to coordinate with Regional SAP Team for user related and CRFs related matters.• Implemented DB Backups and DB Monitoring Jobs to avoid any data loss.

Manage primary Sales System.

Performing R&D on BI and EDW Enhancement for Sales and Calls Data.Implementing ETLs, SSRS and SSAS.Sales and Calls Data Reconciliation to avoid data discrepancy in DataWarehouse.Creating Reports on Salesforce CRM and Power BI and implementingWorkflows.Managing SQL Jobs and maintaining SQL Server's performance.Worked with software development and testing team members to design and develop robust solutions to meet client requirements for functionality,scalability, and performanceCollaborated with management, internal and development partners regarding software application design status and project progress

Extracting reports for clients according to the requirement.Coordinating with relevant stakeholders for information gathering, business & gap analysis and attend meetings to finalize the project scope.Involved in all stages of the project lifecycle to date from the Business Case development through to post implementation and support.Developing propose option list and implementation as per project plan.Linkage between varies modules as per business process.Support in General Banking and Technical Issue of Summit Bank Limited & KASHF Micro Finance Bank.ProjectsReporting options for Export Refinance (ERF) Loan Application module for Summit Bank.Schedule of Charges (SOC) module for Summit and Habib Metropolitan Bank. Technologies UsedNetBeans (IDE)Jasper iReport (Reporting)Sybase (Database Server)