Md Yunus Jamal Email & Phone Number

Hyderabad, In

Paris, France, Fr

Managerial Responsibilities:1. Leading the business analytics team for Medical BI and Reporting solutions and supervising a team of 9+ associates.2. Business support for the GBUs (Vaccines, Specialty Care, and General Medicines) by providing business insights and recommendations, with daily analytics and strategic needs.3. To ensure timely and high-quality delivery, coach and mentor the team of analysts and senior analysts.4. Train associates how to use the project management tool Smartsheet, Power BI, and R programming.Projects accomplished -1. MedSmart Project: Designed a comprehensive and customer-focused web-based project management tool for monitoring the execution of vaccines medical projects at both the global and regional levels.2. Consolidation of vaccine studies : Develop one stop automated solution to combine medical studies that is managed by many systems.3. Cross-functional Dashboards and Trackers: A) Developed a country specific tracker for commercial and medical activities within the Vaccines GBU that are simplified for JPAC and Asian countries. B) Automated the tracker and developed a dashboard in order to understand process and get insights based on regional, cross functional and country wise.3. Others (Ad-hoc) A) Omnichannel projects for various GBUs: Working as a point of contact between the delivery team and the business units to collect business needs and streamline delivery. B) Created dashboards using Smartsheet and Power BI for various teams within Vaccines, including R&D, Compliance & Governance, Digital, Marketing, and Finance.Awards & Recognitions:Received Extra Mile Reward & Recognition like - Play to Win (3 times) and Consistency Champion.Skills:Pharmaceutics · Business Analysis · Business Strategy · Data Analysis · Business Intelligence (BI) · Analytical Skills.

Paris, France, Fr

Basel, Baselstadt, Ch

Responsibilities:• Provide analytical support to Novartis Internal Customers (SCM) on analytical reports.• Analyze data quality issues, their trends and impact on business through root cause analysis.• Create and publish the monthly/weekly reports and KPI analysis.• Gather the requirements for the new or existing reports.• Gathering business requirements from respective stakeholders and translating the information to Informatica tool developers.• Provide training on R and Python to new and existing associates.Automation projects undertaken (with R Scripting & Qlik Sense)• Automated training modules for Master Data Management group• Visualization for data quality team reports through Qlik Sense tool• Automated data quality validation project “Novartis Financial Change Control”• Calculation based complex report automated – Stock management and SPoC reference files.• NOSSCE plants KPI analysis and validation. • Scripted to clean the data and validate as per scope for semi structured dataset based report.• Automated monthly calendar as per project wise deliverables for internal and external associates.

Dublin 2, Ie

Project: Cash Flow Forecasting using Analytical tools (R Shiny, QlikView & MySQL)• Preparing cash flow forecasting reports monthly for three regions based on KPIs. • Variance analysis between actual and forecasted data using QlikView dashboard.• Regular adjustment in KPIs number based on payable funding cycle of vendors and their classification. • Seek on business inputs, last month actual numbers and adjustment files used for regular reporting.• Customize and automate R Shiny (BI tool) based on new or change from existing scope.• Provide business insights in forecasted reports on three ROCs based on QlikView charts. Project: Payment performance analysis through Account Payable Analytics • Analyze and understand huge data sets and their KPI to gain visibility across business units • Observed factors that influence late payments for top five vendors by volume on month basis. • Provided qualitative business insights and quantitative observations as per problem statement. • Prepare and present a late payment dashboard to leadership on a monthly basis. Project: Variance -analysis model with R and QlikView to analyze three ROCs for multiple portfolios.

New York, Ny, Us

Responsibilities :•Creating multiple reports on a daily, weekly, monthly, quarterly and annual basis to reflect company’s financial health around P&L’s.•Sales variance analysis and prepare financial models as per KPIs. •Responsible for data management and meet report production targets along with quality and TAT.•Handling ad-hoc request from clients regarding different performance dashboards.•Claim analysis for different accounts and provide suggestion to resolve related issues.•Prepare a presentation on weekly basis showing the complete performance of the different accounts over the period which is being showcased in account owner’s meeting on weekly basis.•Organizing and lead weekly and monthly conference calls with stakeholders for process improvement.Major Projects: •Prepare model based on new hierarchy change for the account and brand-related financial KPIs.•Sales performance model for comparative data analysis and commentary.

New York, Ny, Us

Project: Develop tool for Pricing Analysis• Working with commercial engineers and global pricing leaders to gather deal wise technical, financial, operational, sales and bidding reports.• Responsible for deal evaluation, deal pricing using scope normalization, database management, deal win-loss analysis, equipment cost optimization, BOP pricing analysis, competitive intelligence, process technologies and water treatment schemes with different water types (pollution level).• Customer requirement analysis and documentation based on business process.• Review and understand the complexity of each deal documents like cost roll-up sheets, technical offers, process flow diagrams and piping design.• Responsible to prepare standard templates in form of deal book, cost bucket and database template using advance excel and dashboard.• Developed database, deal bucket, process flow diagram, BOP price and cost analysis, equipment cost and price analysis, division of responsibilities between customer and suppliers.• Developing the tool for pricing analytic using VBA and advance excel.• Communicate with customer to understand requirement and review of each deal book and database template.

Gurgaon, Haryana, In

Responsibilities:• Manage and build dashboards/templates for timesheet, revenue and operating expense analysis. • Report creation and customization for client profitability and operating profit for the company.• Support finance and sales team with relevant data analysis, charting and reports.• Generate invoices, purchase order, statement of work, reports and deliver to clients and management • Analyze and monitor trends in key performance indicators (KPI) like the cause of unexpected variance. • Daily interaction with domestic and international clients for business supporting documents.• Prepare and compile transnational support data and reports via Siebel CRM system.• Support team leaders in recruitment and banking operational processes.• Synchronize and maintain database supporting third party vendor invoices in the order to bill process.• Enabling project code for consultants and creating project extension.

Mba, Finance & Accounting

Bachelor Of Technology (B.Tech.), Computer Science

Xiith, Science

10Th, Science