Muhammad Rizwan

• 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 TSQL methods.

• 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 Stored Procedures 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 coordination with 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 them to 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 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 Sales Reps.

• Coordinated with Procurement for the timely procurement of the SRs Devices and dispatching it to all 36 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 adjustment in 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 Plan Creation, Deployment and Training Plans for successful training and rolling out 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 local and 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 Pro Systems.

• 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 them to 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 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 Sales Reps.

• Coordinated with Procurement for the timely procurement of the SRs Devices and dispatching it to all 36 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 adjustment in coordination with Security Admins and Insurance Team.

• 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.

• 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 Data Warehouse.

• Creating Reports on Salesforce CRM and Power BI and implementing Workflows.

• Managing SQL Jobs and maintaining SQL Server’s performance.