Syed Mehdi Abbas

• Senior Business Intelligence Analyst specializing in Power BI, lead transformative initiatives by harnessing the full potential of data analytics. I oversaw the development of enterprise-level Power BI solutions, integrating disparate data sources to deliver comprehensive insights across the organization. My role includes not only designing and implementing complex data models and DAX calculations but also overseeing the creation of intuitive dashboards and interactive reports that facilitate data-driven decision-making at executive levels. Through strategic stakeholder collaboration and advanced analytics techniques, I have consistently driven operational efficiencies, identified revenue opportunities, and optimized business processes.
• Mentored junior consultants, helping them enhance their skills and contribute more effectively to projects.
• I have also worked on Databricks SQL, leveraging its powerful querying capabilities and integration with Apache Spark. My experience with Databricks SQL includes crafting and optimizing queries, and integrating with other data tools to deliver actionable business intelligence. I have utilized Databricks SQL for replicating logic from QlikView Dashboards’ ETL load scripts in SQL & generate parquet files to be ingested in Power BI.

Technologies:

• 1. Power BI.
• 2. Databricks SQL.
• 3. QlikView/Qlik Sense.
• 4. Qlik NPrinting.

Data Sources:

• 1. Microsoft Azure.
• 2. Snowflake.
• 3. SAP.
• 4. Oracle.
• 5. MS SharePoint / MS Excel / MS Access.
• 6. SQL Server

• Team Lead for Qlik Analytics. Performed analysis & developed dashboard applications on QlikView/QlikSense. Supervised, managed & assisted the Qlik team to achieve milestone targets through ETL for new developments of dashboards along with providing support on existing Qlik Applications on QlikView/QlikSense. Co-ordinated with business partners for relevant departments to provide support, gather requirements & provide useful insights to business/users on dashboard development through Qlik products. Ensure proper documentation and all other SOP(s) are in place for Qlik Development. Ad-hoc development and reporting to business to prepare/export data fetched from different sources.
• Through Qlik Management Console, manage all administration tasks. Migrated reports from QlikView to QlikSense. Check, validate and integrate various data sources which may include SAP SQL/SAP BW/SAP ABAP/ Oracle/ MS SharePoint/ SQL Server/MS Excel/ MS Access, etc. Financial Closing critical process initiated each month to lock and reconcile accurate analytical and transformed on both Qlik & SAP BW. Provide trainings to users/developers on QlikView & Qlik Sense.

Technologies:

• 1. QlikView/Qlik Sense.
• 2. Qlik Management Console (QMC).

Data Sources:

• 1. SAP SQL / SAP BW / SAP ABAP.
• 2. Oracle.
• 3. MS SharePoint / MS Excel / MS Access.
• 4. SQL Server

• Develop and prepare strategies for Business Intelligence processes in QlikView/QlikSense for Faysal Bank Ltd, perform analysis on organization processes and provide appropriate results. Prepare architecture for data, prepare strategies and provide business object solutions as per requirements. Monitor efficient working of all existing Business Intelligence projects/dashboards (40+) and analyze requirements and perform appropriate maintenance across all data repositories/virtual servers.
• Administer projects, prepare updates and implement all phases for project to achieve all project objectives. Interpret complex data and identify requirements for business enhancement in project. Perform assessment on all dynamic reporting requirements and develop long term strategy for various reporting solutions (Qlik NPrinting). Work with process development and resource teams and prepare appropriate schedule for daily/monthly/yearly routine reporting as per requirement. Manage all data for transactional sources (Excel/Oracle/SQL/Qvds,etc.) and prepare effective reports.

Technologies:

• 1. QlikView/Qlik Sense.
• 2. Qlik NPrinting.
• 3. Qlik Management Console (QMC).

Data Sources:

• 1. Oracle.
• 2. MS Excel / MS Access.
• 3. SQL Server

• Development & Management of Sales Model with respect to change in sales' trends, comparative visual and statistical analysis through charts and graphs of sales of present fiscal year against previous year. Sales Targets calculated according to designations. Weekly Reports developed for any Accounts openings, and weekly sales. Profit & Loss calculation against Sale Entities, calculation of Tagged and Transact AUMs, Management Fees, Rolling Profit & Loss, Commissions earned and override.
• Transactional Amount calculation with respect to Gross Sale, Gross Redemption or Net Amount according to different Source Types. Automation of Fund Manager's Monthly Report to prepare data model for the complex data of FMR previously maintained on Spreadsheets. Provided one window solution for the portfolio of the client.

Technologies:

• 1. QlikView.
• 2. Qlik NPrinting.
• 3. Qlik Management Console (QMC).

Data Sources:

• 1. Oracle.
• 2. MS Excel / MS Access.
• 3. SQL Server