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

<p>Designed the delivery of analytics reports, encompassing data extraction, evaluation, design, analysis, and quality control.<br>
Built rich and compelling BI dashboards highlighting key performance indicators for informed decision-making for business.<br>
Consolidated secondary sales & stock data from 30+ distributors branches pan Pakistan in our data warehouse.<br>
Created visualizations based on requirements and ideating innovative solutions using the latest various BI tools.<br>
Performed data analysis forecasting, growth and transformed data into information & actionable insights.<br>
Managed day by day activities Experience and proficiency in requirement gathering, data analysis, and data validation.<br>
Developed sales and performance measurement for Sales and Marketing, HR, Supply Chain and Compliance team.<br>
Self-Initiate & lead the various projects for Business Process Improvement & Automation.<br>
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.<br>
Developed Sales & Field Force Performance Analytics executive dashboard for the management using Qlik Sense.<br>
Developed Product-SKU Performance Analytics dashboard for the business using Microsoft Excel.<br>
Extracted data from 3 different sources & developed a corridor dashboard for all stakeholders using Microsoft Power BI.<br>
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.<br>
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).<br>
To counter risk management, developed multiple reports and dashboard using Power BI and Qlik Sense.<br>
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)</p>

<p>Developed Commercial Secondary Sales Dashboards & Reports using SAP Business Objects (Web Intelligence).<br>
Leveraged advanced SQL skills to extract valuable information, imported data from SQL Server DB, and created data models.<br>
Designed & executed Power BI visualization solutions, including dashboards, reports, scorecards, charts, and ad-hoc reports.<br>
Conceptualized, designed, and implemented end-to-end Business Intelligence solutions & also enhanced existing BI systems.<br>
Experienced with OLTP databases and OLAP databases, including DHW DB Connections, and LIVE Data Connections.<br>
Published reports and created dashboards in Power BI Services.<br>
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.<br>
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.<br>
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.<br>
Awarded for development of 350+ commercial secondary sales reports using SAP Business object & Web Intelligence.<br>
IQVIA Lead for Novartis - Usage of products and utilization of market data for quarterly reports and ad-hoc analysis</p>

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