jahan ullah

• Designed the delivery of analytics reports, encompassing data extraction, evaluation, design, analysis, and quality control.
• Built rich and compelling BI dashboards highlighting key performance indicators for informed decision-making for business.
• Consolidated secondary sales & stock data from 30+ distributors branches pan Pakistan in our data warehouse.
• Created visualizations based on requirements and ideating innovative solutions using the latest various BI tools.
• Performed data analysis forecasting, growth and transformed data into information & actionable insights.
• Managed day by day activities Experience and proficiency in requirement gathering, data analysis, and data validation.
• Developed sales and performance measurement for Sales and Marketing, HR, Supply Chain and Compliance team.
• Self-Initiate & lead the various projects for Business Process Improvement & Automation

Designed the delivery of analytics reports, encompassing data extraction, evaluation, design, analysis, and quality control.
Built rich and compelling BI dashboards highlighting key performance indicators for informed decision-making for business.
Consolidated secondary sales & stock data from 30+ distributors branches pan Pakistan in our data warehouse.
Created visualizations based on requirements and ideating innovative solutions using the latest various BI tools.
Performed data analysis forecasting, growth and transformed data into information & actionable insights.
Managed day by day activities Experience and proficiency in requirement gathering, data analysis, and data validation.
Developed sales and performance measurement for Sales and Marketing, HR, Supply Chain and Compliance team.
Self-Initiate & lead the various projects for Business Process Improvement & Automation.
Developed the DSR System (Daily Sales Reporting) - importing wholesalers’ raw secondary sales data of 100k+ rows every day to local SQL Server platform using ETL tool and transforming it into Qlik Dashboards for various end users.
Developed Sales & Field Force Performance Analytics executive dashboard for the management using Qlik Sense.
Developed Product-SKU Performance Analytics dashboard for the business using Microsoft Excel.
Extracted data from 3 different sources & developed a corridor dashboard for all stakeholders using Microsoft Power BI.
Spearheaded and developed an in-house Tender Management System for Pakistan managing a +$20m portfolio of tenders for the country, resulting in a cost saving of $150,000, also awarded Novartis Presidential Award for this project.
Automated the Field Force Incentive Policy design and calculation which removed manual work of 40+ hours every quarter and reduced errors by 100% with a fully compliant intersystem - (Backend SQL Server - Frontend SAP BO).
To counter risk management, developed multiple reports and dashboard using Power BI and Qlik Sense.
Project Lead In the global and local project like HCP Portal, top 5 countries in migration of the Novartis Pakistan website to latest technologies and NCARE (online ecommerce medicine portal for patient only)

Developed Commercial Secondary Sales Dashboards & Reports using SAP Business Objects (Web Intelligence).
Leveraged advanced SQL skills to extract valuable information, imported data from SQL Server DB, and created data models.
Designed & executed Power BI visualization solutions, including dashboards, reports, scorecards, charts, and ad-hoc reports.
Conceptualized, designed, and implemented end-to-end Business Intelligence solutions & also enhanced existing BI systems.
Experienced with OLTP databases and OLAP databases, including DHW DB Connections, and LIVE Data Connections.
Published reports and created dashboards in Power BI Services.
The target setting exercise for Novartis in 2018 utilized three years of detailed brick-level data to establish growth expectations for each unit, which were then aggregated to meet the bottom-line target.
SharePoint Automation: Introduced a new tracker for the medical team replacing the old Excel-based system to ensure compliance and accuracy, saving more than 3-4 working days of manual work every month using Microsoft SharePoint.
Led Oncology Team Transition: Led onboarding of the Oncology team and integrated the oncology systems into Pharma systems, enhanced their manual system to automated system while ensuring compliance with the internal guidelines.
Awarded for development of 350+ commercial secondary sales reports using SAP Business object & Web Intelligence.
IQVIA Lead for Novartis - Usage of products and utilization of market data for quarterly reports and ad-hoc analysis

Created dynamic database-driven web applications using Oracle Application Express.
Integration of Oracle Application Express (APEX) with Oracle Forms & Reports.
Developed interactive MIS dashboards & Forms/Reports using Oracle Application Express.
Collaborated cross functionally as a liaison with business and IT teams in gathering requirements for developing applications.