Merck Group

Sales Enablement through Analytics:
	Sales Reporting & Enablement
	MIS, Dashboarding | Performance Tracking 
	Data Steward | Data Governance
	Data Analytics 
	Pricing Analytics
	SFDC Analytics and Governance
	Incentive Analytics
•	Preparing Variance Analysis and Trend Analysis reports of Pipeline Hygiene on a Monthly and quarterly Basis
•	Preparation and analysis of Daily, Weekly, Monthly, and Quarterly reports and shared the reports with the Management teams
•	Ecommerce report: Provided strategic financial support to stakeholders about the business
development of each Brand Description. (Like: -Sigma, EMD Millipore, Roche, Amgen …etc.)
•	Tableau visualizations: Worked a great extent with the design and development which Includes Preparing Dashboards using calculations, parameters, calculated fields, groups, and sets in Tableau
•	SPA Accounts: Year-end target setting activity and reviewing Completion of Acquisition.
•	Sales Analytics: Responsible for Global Daily Sales report, Business segment daily sales report, BU wise scorecard, and Performance Dashboard & Deep Dive analysis.
•	Management Reporting: Responsible for publishing MBR (Monthly Business Review), QBR (Quarterly Business review), Mgmt. Scorecard, 
•	Territory Management & Incentive calculation (TMIC): Sales Territory Management and Sales commissions process for account managers on a quarterly, half-yearly & yearly basis
•	Business Support: Support business teams in evaluating new business opportunities by addressing commercial and profitability aspects 
•	IT Collaboration: Addressing any data discrepancy for sales and orders data in SAP systems and SAP Next implementation; was responsible for testing & providing the feedback to the IT team
•	Audit: Managing the (Internal & External Audit), Process Governance & Lead ISO Internal Auditor. Audit findings to make profit & operational improvements

Senior Specialist, Data Analytics & Reporting

KPMG

Conduct an in-depth analysis of Financial Statements like Balance sheets, statements of operations, stockholder’s equity, cash flow, Trial Balance, etc for their mathematical Accuracy, to ensure the data published is truthful for the benefit of shareholders. 

Review of 10-K, 10-Q, and 8-K documents which are filled with Security Exchange Commission (SEC) the USA.

Verifying Mathematical accuracy and Fundamental analysis of the financial data from Annual Reports, Quarterly reports, and Press Releases of Companies, Providing accurate MIS reports.

Preparing reports with the raw data which interprets the differences over the prior year over the current year $ and % of Increase/ Decrease both QTD data and YTD Data.

Using IDEA (Interactive Data Extraction and Analysis) & SMART ANALYZER for data analysis and preparing reconciliation reports.

Performing control testing for Each significant accounts and relevant assertions CEAVOP and following with COSO principal following with TOD, Test of operating effectiveness, substantive testing of controls also Verifying SOC report, SOX report. 
     
Bank reconciliation tracing the Bank balance to the ending bank statement, tracing the reconciled item to supporting document, and ending cash general ledger balance to the general ledge

Checking the Schedule of Investments (SOI) in the report for its valuation as of the date of a report from Bloomberg, we have live Bloomberg Terminals installed for accessing the needed information.

eGPA (e-Audit Procedure Analysis): Planning for the Future Work Request by analyzing the time and budget for the procedures to be performed by a discussion with the US engagement Team.

All the above process is based on Expedited TAT, Business excellence through speed and teamwork & a 100 % paperless environment Able to handle work to the clients.

Senior Associate

Experienced in Data Analytics, Financial Reporting, and Business Strategy

As a Senior Specialist at Merck KGaA, I lead a dedicated team of data analysts focused on delivering data-driven insights to fuel strategic growth and commercial excellence within the healthcare industry. Boasting over a decade of experience in data analytics, financial reporting, and business strategy, I possess an unwavering passion for unveiling patterns and trends that drive informed decision-making and optimize overall performance.

My track record includes the successful establishment of analytics teams, increased client engagement, and the delivery of transformative projects spanning multiple domains, including sales enablement, pricing analytics, SFDC analytics, and incentive analytics.

Key Highlights:

1) Proficiency in Financial Accounting, Auditing, Sales Analytics, People Management, and Project Management, complemented by strong business acumen.

2) Skilled in BI HANA, SFDC, Tableau, MS Excel, JIRA, SNOW, ManGo, SAP BeX/BI/WEBI, and eAudIT.

3) Certified as a Lean Six Sigma Yellow Belt and ISO 20000-1:2018 Internal Auditor.

4) Boasting international exposure, having traveled to Singapore for a Tableau training and workshop.

Functional Areas of Expertise:

1) GTM Enablement Team
2) Global Pricing Team
3) Digital Strategy Team
4) Commercial Strategy Leadership Team
5) Business Planning and Implementation Team
6) Sales Incentive and Territory Management Team
7) Global Customer Excellence Team.

Let's connect and explore how we can collaborate to drive data-driven success in the Pharmaceutical industry.

Taplio

Lokesh Devihosur 🇮🇳's Linkedin Analytics

Lokesh Devihosur 🇮🇳

Ready to grow your LinkedIn presence?

Taplio

.css-6ytdur{background-image:linear-gradient(284deg, rgba(39, 43, 72, 1) 0%, rgba(33, 47, 183, 1) 100%);color:transparent;-webkit-background-clip:text;background-clip:text;}Lokesh Devihosur 🇮🇳's Linkedin Analytics

Lokesh Devihosur 🇮🇳

Ready to grow your LinkedIn presence?

Lokesh Devihosur 🇮🇳's Linkedin Analytics